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

DPChallenge Forums >> General Discussion >> User Percentile Rank
Pages:  
Showing posts 1 - 5 of 5, (reverse)
AuthorThread
07/16/2011 08:58:18 PM · #1
Don't give up on me :). I'm slowly getting all the challenges compiled. Currently I have the data to challenge 717 (July 2007) with over 13400 unique users entering a challenge.
The more data retrieved the slower Excel runs, so it's takes about 2 1/2 minutes to get one challenge. Even though I have a 4-Core / 8GB computer it heats up the system to much and causes the program not to respond if I try to get more that 25 or so challenges at one time.
Currently DPC has finished challenge 1417 so I'm about half way there.

Anyone with VBA / Macro knowledge would like to help me create a macro to speed up the process feel free to contact me.
The macro I'm using know was created by Kirbic for another project and I thank him for his time and effort. It's a great macro but gathers more info than needed on this project. If I had a macro that only did the necessary data recovery and functions needed it may be faster.

Keep looking - I should have the User Percentile Ranks complete in the near future.

Scott
07/16/2011 09:32:47 PM · #2
Thank you Scott, for your time and dedication to this site. What a gift you are.
07/16/2011 10:38:26 PM · #3
Originally posted by MacDonald:

Thank you Scott, for your time and dedication to this site. What a gift you are.


Yes, thanks much!
07/17/2011 03:14:42 AM · #4
Indeed. An amazingly dedicated fellow.

In fact, there should be such an award. FDPC - Fellow of DPChallenge!

Thanks Scott
07/17/2011 09:37:18 AM · #5
Can't help you I'm afraid but certainly want to add my thanks to the rest who appreciate your efforts

Message edited by author 2011-07-17 09:37:42.
Pages:  
Current Server Time: 08/18/2025 11:33:48 PM

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/18/2025 11:33:48 PM EDT.