| Author | Thread |
|
|
03/25/2005 07:33:53 PM · #1 |
A lot of us track our scores during a challenge. It's fun to watch the scores rise and fall and wonder what kind of score since your last update contributed to that change. Well, I have a simple Excel spreadsheet that I thought I would share with anyone who may want to use it also (assuming you have Excel).
It looks like this....
"Votes" are simply the number of votes when you check.
"Average" is where you enter the DPC average vote at the time.
"# votes since..." is just telling you how many votes since you last checked and recorded.
"average vote since last check" will calculate what the average vote you received was since the last check.
For instance, in the supplied example, when I recorded the 69th vote, my average total score was 6.1594. The last time I checkwas when there was only 25 votes in. Since I last checked, the 44 latest votes averaged 6.36. Of course when the change of votes is only one, then this number reflects the actual score that incremental vote gave you.
Nothing fancy, but helpful and fun.
You can download the spreadsheet
here.
My data is still in the speadsheet, so just write your own scores in place of my sample. You only ener the votes and the average, the sheet calculates the last two columns.
Mark |
|
|
|
03/25/2005 07:39:34 PM · #2 |
This works in the OpenOffice.org open-source office suite as well.
Thanks for sharing!
-Terry
|
|
|
|
03/25/2005 07:40:17 PM · #3 |
|
|
|
03/25/2005 07:43:04 PM · #4 |
The world hates us statisticians. Whats fun for us is not the norm. I'm intrigued by econometric models. Were not the same as others. Great chart though.
|
|
|
|
03/25/2005 07:44:16 PM · #5 |
Originally posted by neophyte:
Were not the same as others. |
I just have to give you guys a hard time... you know I secretly adore all that mathematical-type stuff. ;o)
|
|
|
|
03/25/2005 08:04:14 PM · #6 |
I've got more or less the same spreadsheet on my computer, with a graph that shows the movements of my score. Of course when it's only updated add odd intervals it's all a bit misleading, but can I help it if I'm obsessed?
|
|
|
|
03/25/2005 08:14:15 PM · #7 |
Thanks for posting Mark. Is the link down? I can't access. It even fails if I cut and paste.
|
|
|
|
03/25/2005 08:59:01 PM · #8 |
I emailed it to you.
Message edited by author 2005-03-26 03:02:33. |
|
|
|
03/25/2005 09:10:03 PM · #9 |
| I still want my live RSS feed of this data. RSS! RSS! |
|
|
|
03/25/2005 11:11:49 PM · #10 |
Originally posted by jbsmithana:
Thanks for posting Mark. Is the link down? I can't access. It even fails if I cut and paste. |
You can try going here and follow the "My Documents" link.
//f1.pg.briefcase.yahoo.com/auburn_california
|
|
|
|
03/26/2005 02:03:27 AM · #11 |
Originally posted by laurielblack:
 |
Now Laurie, don't get me started! |
|
|
|
03/26/2005 05:19:31 AM · #12 |
Originally posted by bledford:
I still want my live RSS feed of this data. RSS! RSS! |
Huh? What's RSS?
|
|
|
|
03/26/2005 05:25:17 AM · #13 |
Originally posted by gloda:
Originally posted by bledford:
I still want my live RSS feed of this data. RSS! RSS! |
Huh? What's RSS? |
Really Simple Syndication (RSS) is a data access method that allows the data (just the data) in a standard XML format to be accessed by means of a URL.
Basically it means we could access the data directly instead of having to hand enter the information or use a spider as a few have done.
A live feed would update the information on the fly, with each change in the votes and comments being submitted.
@D&L: pretty please!
David
Message edited by author 2005-03-26 05:27:30.
|
|
|
|
03/26/2005 05:30:46 AM · #14 |
It also means we could use PHP to have our score live updated into a PNG image file doesn't it?
|
|
|
|
03/26/2005 05:41:31 AM · #15 |
Originally posted by Konador:
It also means we could use PHP to have our score live updated into a PNG image file doesn't it? |
probably, but I was thinking more along the lines of a desktop (or tray) applet to constantly display scores and notify when comments are receive without having to open a browser -- not that coming to DPC is a bad thing ;) -- or even a java phone applet that would allow checking scores from web enabled cell phones.
It makes the data available without the overhead of a web page -- anything a computer can do with that data can then be done, limited only be imagination and know-how.
David
|
|
|
|
03/26/2005 06:09:32 AM · #16 |
I already thought of those things - now I know what name to associate with them. Thanks. RSS would be a great thing, I'm sure some of our specialists would create a neat little program straight away.
|
|
|
|
03/26/2005 12:22:03 PM · #17 |
| I was thinking of using the RSS feed to drive a SVG graph. |
|
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/06/2025 04:33:45 AM EDT.
