Copy and paste the headings and all 4 rows of your monthly percentages into the upper left corner (Cell A1) of a blank spreadsheet using Paste Special....Text. Then copy and paste the formula below into any blank cell of your spreadsheet and you have the instant June TAPL calculator. This is the revised version of TAPL which is the old TAPL x 10 divided by the square root of the number of games.

If you have fewer than four months of data, do not put the TAPL calculator above Row 6.

=1000*SQRT(SUM(F2:F5))*(((((F2*G2+F3*G3+F4*G4+F5*G5)/SUM(F2:F5))-0.14)^2/0.14)+((((F2*H2+F3*H3+F4*H4+F5*H5)/SUM(F2:F5))-0.14)^2/0.14)+((((F2*I2+F3*I3+F4*I4+F5*I5)/SUM(F2:F5))-0.14)^2/0.14)+((((F2*J2+F3*J3+F4*J4+F5*J5)/SUM(F2:F5))-0.14)^2/0.14)+((((F2*K2+F3*K3+F4*K4+F5*K5)/SUM(F2:F5))-0.14)^2/0.14)+((((F2*L2+F3*L3+F4*L4+F5*L5)/SUM(F2:F5))-0.14)^2/0.14)+((((F2*M2+F3*M3+F4*M4+F5*M5)/SUM(F2:F5))-0.14)^2/0.14))