Forum
The Instant One-Cell TAPL Calculator
|
skrumgaer wrote
at 12:28 PM, Friday May 25, 2007 EDT
I have been asked by a number of people to post my TAPL-calculating spreadsheet somewhere and post a link to it. I have not done that yet, but this is the next best thing: the entire TAPL calculation in one cell. No cut-and-paste, no moving, no transpose, no other stuff. Follow these three steps.
1. Copy your profile percentages and their headings off your profile page and paste them in the upper left corner of the spreadsheet using the "Edit....Paste Special....Text" menu in Excel. Do not use HTML. You should have a row of headings in Cells A1 to M1 and three rows of percentages (If you have not been playing kdice for three months you won't have three row, but no problem). 2. Copy this string: =100*SUM(F2:F4)*(((((F2*G2+F3*G3+F4*G4)/SUM(F2:F4))-0.14)^2/0.14)+((((F2*H2+F3*H3+F4*H4)/SUM(F2:F4))-0.14)^2/0.14)+((((F2*I2+F3*I3+F4*I4)/SUM(F2:F4))-0.14)^2/0.14)+((((F2*J2+F3*J3+F4*J4)/SUM(F2:F4))-0.14)^2/0.14)+((((F2*K2+F3*K3+F4*K4)/SUM(F2:F4))-0.14)^2/0.14)+((((F2*L2+F3*L3+F4*L4)/SUM(F2:F4))-0.14)^2/0.14)+((((F2*M2+F3*M3+F4*M4)/SUM(F2:F4))-0.14)^2/0.14)) and paste it in any blank cell of your spreadsheet (but if you don't have three rows of percentages, don't stick it where the second or third row would be). Voila! Your TAPL should appear in the cell you pasted the string into. To update your TAPL, copy your top row of games played and percentages and paste it over your old top row of games played and percentages and you have your new TAPL. There's nothing more to it. |
Replies 1 - 3 of 3
|
Mikeypoo wrote
at 12:30 PM, Saturday May 26, 2007 EDT Dude are you going to post a top 25 or something
|
|
StormLord wrote
at 2:57 PM, Saturday May 26, 2007 EDT Works in OpenOffice.org too. Needs to be pasted as HTML tho.
Good job skrumgaer, you're fucking mad. |
|
skrumgaer wrote
at 6:05 PM, Saturday May 26, 2007 EDT I have just opened an account in OpenOffice.org.
|