| Author | Thread |
|
|
10/25/2004 02:27:44 AM · #1 |
I decided to figure out how to calculate what a single vote was on my submission based on the previous and current averages. Not too complicated. Now I just ask my TI-89 for the answer.
You need the current number of votes (n), the current avg vote (a), and the previous avg vote (b). If more than one vote has been cast between the b and a scores, the result will be the average of the votes cast in that period.
Equation:
v = na - b(n-1)
For instance, I was at 5.8333 with 24 votes. When I updated, I had 25 votes and an average of 5.9200.
So:
v = (25 * 5.92) - (5.8333 * 24)
= 148 - 139.9992
= 8 (approx.)
Someone gave me an 8! Cool.
Yeah, I know it's simple, but I thought someone else might enjoy the extra curiosity satisfaction. More juice for the addiction of the update button. :)
|
|
|
|
10/25/2004 02:51:34 AM · #2 |
What we need now is an applet to sit in the notification tray, polling the site looking for updates and logging all activity. Of course the drain on server resources would be large, but it is all in the name of feeding the addiction -- isn't it? :D
David
|
|
|
|
10/25/2004 02:58:28 AM · #3 |
Reading that equation gave me a headache.
June
|
|
|
|
10/25/2004 03:10:40 AM · #4 |
Reading this thread and finding math in it made me sad.
I just remembered that next semester I need to take Calculus 2 and Discrete Math :'(
Message edited by author 2004-10-25 03:14:14.
|
|
|
|
10/25/2004 03:34:59 AM · #5 |
| Yeah, it would be cool to have a real chart of the score as it settles in on the final score. It wouldn't be too bad on the server, I think. The score charting application wouldn't have to download any images from the DPC home page, just the HTML content and scrape out the score box. It'd take maybe an hour for me to write a simple program to do this and put a usable interface on it. |
|
|
|
10/25/2004 04:57:31 AM · #6 |
It still doesn't take into account ppl who've already voted, tweaking their scores on a 2nd or 3rd pass of all the photos. I often go back once or twice and finetune my votes after viewing the whole lot.
|
|
|
|
10/25/2004 07:21:11 AM · #7 |
If you are really into it, use 'Excel' instead of the calculator to track it.
Create three columns:
Column A: Current Number of Votes
Column B: Current Average score
Column C: =ROUND(((A2*B2-A1*B1)/(A2-A1)),1)
The formula depends on there being at least two rows, the one it is on and a preceding row. The formula as presented should be in C2. Copy and paste the formula to all other cells in column C, it should change dynamically.
Doesn't solve all the other issues of people changing/tweaking votes, etc, but does build a trend line on the cheap. I am sure there are at least a few industrious souls that are screen scraping to get updates more or less as they happen maybe?
|
|
|
|
10/25/2004 08:35:19 AM · #8 |
You mean like this? I've been doing it the past 5 challenges. It is amazing how close the trends are!
Here is my average and "delta vote" charts:
 |
|
|
|
10/25/2004 09:23:04 AM · #9 |
Ahem... Watch Laurie run for her life screaming!!! LMAO! All that Math and graphing and equations....someone has too much time on their hands... ;) ;) LOL
|
|
|
|
10/25/2004 09:36:39 AM · #10 |
Originally posted by cpurser:
You mean like this? I've been doing it the past 5 challenges. It is amazing how close the trends are!
Here is my average and "delta vote" charts:
|
I have been doing the same but I have to enter the informtion every hour since i'm a regestured user. Wish I could find a way for my spreadsheet to auto update every hour. Do you enter each vote or have you found a way for yours to auto update? |
|
|
|
10/25/2004 09:52:30 AM · #11 |
Originally posted by richterrell:
If you are really into it, use 'Excel' instead of the calculator to track it.
Create three columns:
Column A: Current Number of Votes
Column B: Current Average score
Column C: =ROUND(((A2*B2-A1*B1)/(A2-A1)),1)
The formula depends on there being at least two rows, the one it is on and a preceding row. The formula as presented should be in C2. Copy and paste the formula to all other cells in column C, it should change dynamically. |
Thanks Rich! That's a nice simple way to make it easier to track. But now my score is dropping so I will try not to worry about every single vote. Yeah, right. I'm still click-click-clicking the update button. :-| |
|
|
|
10/25/2004 10:00:49 AM · #12 |
...suddenly, my husband's Star Wars collection seems almost "normal" to me...
ROFLMAO!!!! :o) |
|
|
|
10/25/2004 10:59:53 AM · #13 |
Originally posted by SDW65:
I have been doing the same but I have to enter the informtion every hour since i'm a regestured user. Wish I could find a way for my spreadsheet to auto update every hour. Do you enter each vote or have you found a way for yours to auto update? |
I have to enter the votes manually. It would be wonderful to have it automated.
laurielblack - I agree... it is sad!! But I am an engineer, so I have no choice... it is a sickness!! :-)
Chad |
|
|
|
10/25/2004 11:05:16 AM · #14 |
Originally posted by laurielblack:
...suddenly, my husband's Star Wars collection seems almost "normal" to me...
ROFLMAO!!!! :o) |
'Excel'?!? I just use the Force. |
|
|
|
10/25/2004 11:08:30 AM · #15 |
Originally posted by laurielblack:
...suddenly, my husband's Star Wars collection seems almost "normal" to me...
ROFLMAO!!!! :o) |
You speak of sad addicted people then you use ..... ROFLMAO !!
Explain yourself young lady or go to your room :-)
|
|
|
|
10/25/2004 11:31:01 AM · #16 |
| Personally, I'd like to have the histogram of the votes displayed during the voting. |
|
|
|
10/25/2004 11:51:01 AM · #17 |
| I'm waiting for an RSS feed of my current scores so I can scrape the data hourly and log it to a database. I'm such a nerd. |
|
|
|
10/25/2004 12:23:07 PM · #18 |
So cpurser, where did you get your spread sheet from? Just curious... *wink* *wink*
|
|
|
|
10/25/2004 01:28:48 PM · #19 |
Originally posted by dswebb:
So cpurser, where did you get your spread sheet from? Just curious... *wink* *wink* |
Ah, Master Doug, the great originator of this highly complex piece of computation!
Notice I never said that I made the spreadsheet myself. :-) However, I did do some useful "upgrades" in verson 2.0. |
|
|
|
10/25/2004 01:35:36 PM · #20 |
Originally posted by laurielblack:
...suddenly, my husband's Star Wars collection seems almost "normal" to me...
ROFLMAO!!!! :o) |
I'm sure there is a 12-step program available for this.
LOL
|
|
|
|
10/25/2004 05:20:47 PM · #21 |
Originally posted by Bran-O-Rama:
It still doesn't take into account ppl who've already voted, tweaking their scores on a 2nd or 3rd pass of all the photos. I often go back once or twice and finetune my votes after viewing the whole lot. |
Nor does it take into account the situation where two voters enter their votes at almost the same moment.
In our modern, technologically advancing world things become possible faster than we can made rational decisions about whether they are desirable.
Message edited by author 2004-10-25 17:25:57. |
|
|
|
12/28/2004 02:45:00 AM · #22 |
A while ago, I made this simple page that calculates the vote. Heres the link if anyone wants to use it:
//www40.brinkster.com/tyt2000/dpcvc.aspx
- Thamer |
|
|
|
12/28/2004 12:48:04 PM · #23 |
| You guys have WAY too much time on your hands! I guess this is a sign that we need more challenges :D |
|
|
|
12/28/2004 01:19:17 PM · #24 |
| well my head is spinning with all the math , I'll put my sox back on now i'm over 15 votes!!!!LOL |
|
|
|
01/02/2005 06:10:50 PM · #25 |
Originally posted by bledford:
I'm waiting for an RSS feed of my current scores so I can scrape the data hourly and log it to a database. I'm such a nerd. |
Hmm... RSS feed would be useful. At least fun to play with. |
|
