| Author | Thread |
|
|
09/01/2004 05:31:00 AM · #1 |
What's your average finishing position?
My average place is 36th from 79 Challenges.
|
|
|
|
09/01/2004 05:34:44 AM · #2 |
| 82 from 18 challenges! :( |
|
|
|
09/01/2004 05:42:10 AM · #3 |
Originally posted by jonpink:
What's your average finishing position?
My average place is 36th from 79 Challenges. |
Mine is 115 out of 16 challengers, that didn't look good and is relevant to the number of entries, so I worked out average % placing.
That was 50% much more happier with that. |
|
|
|
09/01/2004 05:43:34 AM · #4 |
since I'm bored, I'll respond here.
My average placing in 208th in one challenge :)
WHat?!
|
|
|
|
09/01/2004 05:47:50 AM · #5 |
| 69 from 8 challenges or 74th percentile if I'm doing this math correctly. |
|
|
|
09/01/2004 06:09:03 AM · #6 |
111th from 9 challenges, 60th percentile.
David
|
|
|
|
09/01/2004 06:52:07 AM · #7 |
I can't be bothered to work mine out :P Does anyone else want to? hehe
|
|
|
|
09/01/2004 06:53:29 AM · #8 |
|
|
|
09/01/2004 06:57:39 AM · #9 |
That's funny, I've only even been in the 200ths once :P
|
|
|
|
09/01/2004 07:03:58 AM · #10 |
Yours is too long to figure out - even for excel.
Message edited by author 2004-09-01 07:04:13. |
|
|
|
09/01/2004 07:47:07 AM · #11 |
| 24th out of 11 challenges |
|
|
|
09/01/2004 07:53:31 AM · #12 |
114 out of 12 challenges
52%, I think.
Start my photography class tonight, I hope I learn about lighting! :)
|
|
|
|
09/01/2004 08:31:37 AM · #13 |
48th out of 37 challenges- 78%
I'd like to think that recent history is a better indicator:
24th out of 15 challenges- 89% |
|
|
|
09/01/2004 09:24:28 AM · #14 |
Originally posted by jonpink:
Yours is too long to figure out - even for excel. |
Nah, Excel's "Web Query" feature makes it a piece of cake to run stats on your challenge entries any time you want.
Open a new worksheet
Choose Data > Import External Data > New Web Query...
Type "//www.dpchallenge.com/profile.php" into the Address box
Scroll down to the "Challenge Entries" section and click the little yellow arrow (turning it into a green checkmark)
Click the "Options..." button in the top-right corner
Enable "Disable date recognition" so your "Place" column doesn't get converted to a date
Click "Import"
Click "OK" to accept the defaults in the "Import Data" dialog
Presto! Your challenge entries are now in Excel, ready for analysis.
Save your worksheet, and when you open it a few weeks down the road and want to update it with your latest challenge entries, just choose the Data > Refresh Data menu option and your latest challenge entries will be imported!
The "Place" column is a little funky because it has two numbers in it. To get just the first value in a column by itself for analysis, put the following formula in J2:
=INT(LEFT(E2,SEARCH("/",E2)-2))
and then drag the lower-right hand corner of cell J2 down to copy it as many times as needed ('til your last challenge entry).
You can now use Data > Sort... to order the table however you want (use the 'J' column to accurately sort by "Place").
Message edited by author 2004-09-01 09:29:26.
|
|
|
|
09/01/2004 09:36:36 AM · #15 |
Thanks Eddy :)
Average place: 41st
Average percent: 73%
Out of 123 challenges.
|
|
|
|
09/01/2004 09:40:26 AM · #16 |
EddyG that is fantastic... Thanks.
But I'm not telling because they are not worthy of being told! Yet. lol
|
|
|
|
09/01/2004 09:44:49 AM · #17 |
Originally posted by EddyG:
Nah, Excel's "Web Query" feature makes it a piece of cake to run stats on your challenge entries any time you want.
|
I think you should all be very proud of me...because I (yes, me the mathematically challenged child of DPC) just followed EddyG's instructions and have my VERY OWN DPC SPREADSHEET now!!!! ;o)
What to do with all those stats now...hmmm..... :o)
edit...my average percentile is 60% for 42 challenges. I'm happy with that, being that I don't know what I'm doing half the time! ;o)
Message edited by author 2004-09-01 09:54:18.
|
|
|
|
09/01/2004 09:47:04 AM · #18 |
You are the daddy EddyG.
I use excel but do it by hand - and also took my "/" away by hand. this is the key! =INT(LEFT(E2,SEARCH("/",E2)-2))
Clever Eddy!
|
|
|
|
09/01/2004 09:47:26 AM · #19 |
I also copied and pasted! Will try the web thinggy now :D
|
|
|
|
09/01/2004 11:23:28 PM · #20 |
Originally posted by laurielblack:
I think you should all be very proud of me...because I (yes, me the mathematically challenged child of DPC) just followed EddyG's instructions and have my VERY OWN DPC SPREADSHEET now!!!! ;o) |
Wow! Congrats! ;-)
Originally posted by laurielblack:
What to do with all those stats now...hmmm..... :o) |
Just think of all the pretty graphs you can make now... =] |
|
|
|
09/01/2004 11:25:33 PM · #21 |
Originally posted by EddyG:
Wow! Congrats! ;-)...Just think of all the pretty graphs you can make now... =] |
LOL... but don't say it too loudly, I have a rep to protect! ;o)
|
|
|
|
09/01/2004 11:27:55 PM · #22 |
Originally posted by Konador:
I can't be bothered to work mine out :P Does anyone else want to? hehe |
ditto on me. isn;t this kinda depressing tho? I'm scared to get mine
|
|
|
|
09/01/2004 11:33:39 PM · #23 |
Place 96 ?? I think...I'm not sure I did that right...
56%
11.409 comments
|
|
|
|
09/01/2004 11:34:21 PM · #24 |
I tried to import the data into Excel, but it didn't, it said "Invalid Web Query".
Any ideas on how I can get it to work? |
|
|
|
09/01/2004 11:35:33 PM · #25 |
Originally posted by tyt2000:
I tried to import the data into Excel, but it didn't, it said "Invalid Web Query".
Any ideas on how I can get it to work? |
now if I can get it to work... surely you can too! ;o)
|
|
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: 09/09/2025 06:30:56 PM EDT.
