NOTE: You will notice that the standings have changed. The Macro was not working the way I thought and was not wiping DQ'ed entries. With the number of entries and Average incorrect it was throwing off the rankings. Please note due to this you may go up or down in ranking because every point is based on how many USERS have entered and how many entries each USER has. Also Averages and percentile points also are effected by the number of USERS. For some reason I though something looked wrong so instead of running the macro by adding the current week I went back and run the macro from the beginning of the year. This took out all DQ'ed entries, updated Username changes, and updated entries were appropriate. Sorry for the inconvenience and the rush to put the numbers up last night. Going forward I will run the macro fresh (from beginning of the year) each week. Please be patient as it will take longer to post.
I have triple checked the numbers as best as I can. If you see something wrong please let me know.
That is YOU of course, not me... I slipped 3 places. :(
I learning a little more VBA and using macros. I helps a bit. Kirbic wrote 99% of the VBA code I have just added a little bit to it.
When Kirbic gets the time he may help me with a great VBA code macro that will allow me to post the rankings within minutes after rollover instead of hours or days.
I finally found a formula that would work for posting previous week rankings.
It does seem to be showing that my previous ranking was the week 13 value rather than the week 14 value.
The reason your previous score is different than what was posted in week 14 is because the first update of each month the macro runs through all the DQ's and takes out those users scores. By doing this it may make your previous rank higher or lower.
Can't believe I'm ranked at 120. MUCH better than what I would have thought. Having said that, it makes me really wish I didn't submit my "waiting" entry. :o)
What the heck I am still doing at the top. Seriously.....not the place I expected to be. However, after my free study score surfaces...I am positive I will not be there anymore.
What the heck I am still doing at the top. Seriously.....not the place I expected to be. However, after my free study score surfaces...I am positive I will not be there anymore.
I'm not quite sure I understand why I maintained my position either - and h2 pulled two exceptional entries this week - why isn't the gap wider?
NOTE: You will notice that the standings have changed. The Macro was not working the way I thought and was not wiping DQ'ed entries. With the number of entries and Average incorrect it was throwing off the rankings. Please note due to this you may go up or down in ranking because every point is based on how many USERS have entered and how many entries each USER has. Also Averages and percentile points also are effected by the number of USERS. For some reason I though something looked wrong so instead of running the macro by adding the current week I went back and run the macro from the beginning of the year. This took out all DQ'ed entries, updated Username changes, and updated entries were appropriate. Sorry for the inconvenience and the rush to put the numbers up last night. Going forward I will run the macro fresh (from beginning of the year) each week. Please be patient as it will take longer to post.
I have triple checked the numbers as best as I can. If you see something wrong please let me know.
