DPChallenge: A Digital Photography Contest You are not logged in. (log in or register) 
 

DPChallenge Forums >> General Discussion >> 2010 DPC User Rankings (Week 15)
Pages:  
Showing posts 1 - 25 of 28, (reverse)
AuthorThread
 04/07/2010 01:01:21 AM · #1
I finally found a formula that would work for posting previous week rankings.

Enjoy!

Week 15

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.

Thanks,
Scott

Message edited by author 2010-04-07 20:58:26.
 04/07/2010 01:06:25 AM · #2
On the ball this week :)

That is YOU of course, not me... I slipped 3 places. :(
 04/07/2010 01:10:16 AM · #3
Originally posted by vlado:
On the ball this week :)

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.
 04/07/2010 01:13:23 AM · #4
Hey....I finally moved...someone must have woken me up.
 04/07/2010 01:41:54 AM · #5
Would be interesting to work out which DPL team has the highest score in the weekly rankings.
 04/07/2010 07:13:15 AM · #6
I dropped from 50 to 53 but should jump back up here after Sunday. If NikonJeb is reading this then I'M COMING AFTER YOU!!!

Message edited by author 2010-04-07 07:13:28.
 04/07/2010 07:53:55 AM · #7
Originally posted by SDW:
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.

Message edited by author 2010-04-07 07:54:11.
 04/07/2010 08:24:24 AM · #8
Originally posted by paynekj:
Originally posted by SDW:
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.

Hope that helps.

Thanks,
Scott

Message edited by author 2010-04-07 08:24:53.
 04/07/2010 08:36:27 AM · #9
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)
 04/07/2010 09:02:25 AM · #10
whats the "points" bit?
 04/07/2010 09:13:29 AM · #11
it won't let me open the link...sorry...
 04/07/2010 09:28:48 AM · #12
Wow I jumped from 267 to 219.. onward and upward!
 04/07/2010 09:45:35 AM · #13
Originally posted by Ja-9:
it won't let me open the link...sorry...


finally worked...sigh
 04/07/2010 09:47:47 AM · #14
I am ranked 11th!!!! This will probably be the only time in my life i will be above DrAchoo LOL
 04/07/2010 01:34:20 PM · #15
45th place....what was I before..?? lol..

hey..I found it...I moved up!! yesss

Message edited by author 2010-04-07 13:35:41.
 04/07/2010 02:07:19 PM · #16
Originally posted by JulietNN:
I am ranked 11th!!!! This will probably be the only time in my life i will be above DrAchoo LOL


I bet you are safe for another week. :) Then I pounce!
 04/07/2010 02:30:17 PM · #17
lol, Dr, we are going to be on top of each other and switching places the whole time
 04/07/2010 02:58:28 PM · #18
Originally posted by JulietNN:
lol, Dr, we are going to be on top of each other and switching places the whole time

get a room. :P

Thanks for compiling the list again, Scott!
 04/07/2010 03:11:36 PM · #19
Originally posted by Art Roflmao:
Originally posted by JulietNN:
lol, Dr, we are going to be on top of each other and switching places the whole time

get a room. :P

Thanks for compiling the list again, Scott!


Gross, Art! The gal is 95!!!

Juliet, I'm gonna be Stalking you!

Message edited by author 2010-04-07 15:13:16.
 04/07/2010 03:46:23 PM · #20
It's just terrible! (Referring to my own score) Thanks for posting again!
 04/07/2010 03:57:59 PM · #21
Thanks, Scott!
 04/07/2010 05:42:17 PM · #22
I'm 586! that is such a cool number. I have nowhere to go but up!
 04/07/2010 05:56:54 PM · #23
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.
 04/07/2010 07:38:27 PM · #24
Originally posted by njsabs:
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?
 04/07/2010 08:48:18 PM · #25

Week 15

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.

Thanks,
Scott

Message edited by author 2010-04-07 20:57:58.
Pages:  
Current Server Time: 08/24/2025 07:48:14 AM

Please log in or register to post to the forums.


Home - Challenges - Community - League - Photos - Cameras - Lenses - Learn - Help - Terms of Use - Privacy - Top ^
DPChallenge, and website content and design, Copyright © 2001-2025 Challenging Technologies, LLC.
All digital photo copyrights belong to the photographers and may not be used without permission.
Current Server Time: 08/24/2025 07:48:14 AM EDT.