Forum
The July one-cell TAPL calculator (the TAPLet)
|
skrumgaer wrote
at 1:16 PM, Monday July 2, 2007 EDT
To use this calculator, copy all of the percentage data (with the headings) off your profile page and paste it into cell A1 of an empty spreadsheet. Then copy the following formula and paste it in any blank cell (but if your numbers do not go back as far as March, don't paste it any place where those numbers would have been (down to row 6).
=1000*SQRT(SUM(F2:F6))*(((((F2*G2+F3*G3+F4*G4+F5*G5+F6*G6)/SUM(F2:F6))-0.14)^2/0.14)+((((F2*H2+F3*H3+F4*H4+F5*H5+F6*H6)/SUM(F2:F6))-0.14)^2/0.14)+((((F2*I2+F3*I3+F4*I4+F5*I5+F6*I6)/SUM(F2:F6))-0.14)^2/0.14)+((((F2*J2+F3*J3+F4*J4+F5*J5+F6*J6)/SUM(F2:F6))-0.14)^2/0.14)+((((F2*K2+F3*K3+F4*K4+F5*K5+F6*K6)/SUM(F2:F6))-0.14)^2/0.14)+((((F2*L2+F3*L3+F4*L4+F5*L5+F6*L6)/SUM(F2:F6))-0.14)^2/0.14)+((((F2*M2+F3*M3+F4*M4+F5*M5+F6*M6)/SUM(F2:F6))-0.14)^2/0.14)) |
Replies 1 - 3 of 3
|
know_it_all wrote
at 1:52 PM, Monday July 2, 2007 EDT is this an alternate score calculating system? why do we need this if the one here is working fine and fair?
|
|
|
skrumgaer wrote
at 1:56 PM, Monday July 2, 2007 EDT Yes, this is completely unoffical. I forgot to mention that the TAPL is explained in the comment on my profile page.
|
|
|
know_it_all wrote
at 4:36 PM, Monday July 2, 2007 EDT so is the score higher the better?
|
