Forum
here is your august one-cell TAPL calculator (the TAPLet)
|
skrumgaer wrote
at 1:11 PM, Thursday August 2, 2007 EDT
The TAPL is explained in the comment on my profile page.
To use the calculator, copy and paste all of your percentage stats (including the column headings) into the upper left corner of a blank spreadsheet. Use Paste Special....Text. Then copy the following and paste it anywhere to the right of your stats. =1000*SQRT(SUM(F2:F7))*(((((F2*G2+F3*G3+F4*G4+F5*G5+F6*G6+F7*G7)/SUM(F2:F7))-0.14)^2/0.14)+((((F2*H2+F3*H3+F4*H4+F5*H5+F6*H6+F7*H7)/SUM(F2:F7))-0.14)^2/0.14)+((((F2*I2+F3*I3+F4*I4+F5*I5+F6*I6+F7*I7)/SUM(F2:F7))-0.14)^2/0.14)+((((F2*J2+F3*J3+F4*J4+F5*J5+F6*J6+F7*J7)/SUM(F2:F7))-0.14)^2/0.14)+((((F2*K2+F3*K3+F4*K4+F5*K5+F6*K6+F7*K7)/SUM(F2:F7))-0.14)^2/0.14)+((((F2*L2+F3*L3+F4*L4+F5*L5+F6*L6+F7*L7)/SUM(F2:F7))-0.14)^2/0.14)+((((F2*M2+F3*M3+F4*M4+F5*M5+F6*M6+F7*M7)/SUM(F2:F7))-0.14)^2/0.14)) |