Forum
Will the top kdicer in the baseball-style standings please stand up?
|
skrumgaer wrote
at 11:03 AM, Friday September 28, 2007 EDT
One of the top contenders in the baseball-style standings, Sergio, has dropped out of the top 25. I suspect that there are other contenders who have never been in the top 25. To see if you are a contender, copy the column headings and first (or only) row of data in your profile and paste (using text mode, not html) into the upper left corner of a blank spreadsheet.
Then, copy the following: =(1000-E2)*0.5+E2*(1*G2+2*H2+3*I2+6*J2+5*K2+4*L2)/6 and paste it into Cell M2, adjacent to the end of your row of numbers. The number you get is your absolute score. The smaller the number, the better. The current best absolute score is 428.45. If your absolute score is less than this, you are the new leader. If you are in serious contention, post to this thread before midnight Sunday and I will work up the final monthly standings. |
Replies 1 - 6 of 6
|
MadHat_Sam wrote
at 2:38 PM, Friday September 28, 2007 EDT Is 488.775 in contention?
|
|
|
skrumgaer wrote
at 3:38 PM, Friday September 28, 2007 EDT MadHat Sam: No.
A newbie starts out at 500. Most of the top 25'ers down to about 450. You are in contention if you are 450 or lower. |
|
Ssergio wrote
at 7:46 PM, Friday September 28, 2007 EDT I actually got my computer killed by my little cousin who spilled a glass of coke on it... And altough I play a lot, unlike some I can't play at work... ;) But beware I will be back !!!!
|
|
|
skrumgaer wrote
at 8:56 PM, Friday September 28, 2007 EDT Make this tweak to the formula:
Replace the "/6" at the end with "/(6*SUM(F2:L2))". This tweak is necessary because Ryan truncates the percentages and they usually don't add to 100%. If you have played 1000 games, the gain of a percentage point would mean, on average, a 5-game gain in your absolute score, with a range from 0 to 10. With the tweak, the expected error becomes zero, although there is still a range of -5 to +5. |
|
Big Jumblies wrote
at 12:12 PM, Saturday September 29, 2007 EDT Quattro Pro doesnt like that tweak to the formula. Without the tweak it came out to 500 does that mean I'm a n00b?
|
|
|
skrumgaer wrote
at 8:39 PM, Saturday September 29, 2007 EDT BJ:
No, it means that you are a subnoob. Noobs know enough to stay away from Quattro. In LOTUS 1-2-3, which I used when I was a subnoob, sums are expessed as @SUM(F2..L2). |
