To set up your own grand TAPL calculator on a spreadsheet:

1. Copy the four lines from your Performance History, including the header line that says “Month Rank Score … etc. by dragging over them with the mouse and clicking Edit…Copy on the browser.

2. Open a blank Excel spreadsheet and click on the upper left cell (A1),

3. Click on Edit….Paste Special on the spreadsheet, and select Unicode Text or Text. Do not select HTML.

4. Click OK. Your performance history should now occupy the top four rows of the spreadsheet from Column A to Column M. The first five rows of numbers are there for show and you won’t actually be using them in the calculations.

5. Into Cell F5 paste or type the following formula:

=F2+F3+F4

6. The equal sign must be there. In Cell F5 will appear the sum of your games played in May, April, and March.

7. Into Cell G5 paste or type the following formula:

=(G2*$F2+G3*$F3+G4*$F4)/($F2+$F3+$F4)

8. The equal sign must be there. The dollar signs must be there and in their correct positions or the next step will be messed up. The number that will appear in Cell G5 will be your first place percentage times the number of games you have played in May, plus your April first place percentage times the number of games you played in April, plus your March first place percentage times the number of games you played in March, divided by your total number of games played in May, April, and March. In other words, your weighted average by number of games per month.

9. Click on Cell G5. Move the mouse cursor over the black square at lower right hand corner of Cell G5 until the cursor becomes a black cross. Hold and drag the mouse over six cells to the right and release. You will have duplicated your calculations of the first place percentages for the second place finishes, third place finishes, etc. If done correctly, you should have a row of seven percentages which are the weighted averages for the percentages for the firsts, seconds, thirds, etc. (They may show as decimals instead of percentages, but this doesn’t matter for the steps that follow).

10. Into Cell G6 paste or type the following formula:

=100*(G5-0.14)^2/0.14

11. As you did in Step 9, click and drag on the lower right corner of Cell G6 to duplicate the formula in the six cells to the right.

12. Into Cell M5, paste or type this formula:

=SUM(G6:M6)*F5

The result is the TAPL for your May, April, and March games combined. Your results are coanventiently displayed with your total number of games on the left, the seven percentages, and the TAPL.

Incidentally, you cannot get a combined TAPL by summing your monthly TAPLs. You have to use the weighted percentage averages as described above.

To update the calculation, copy your latest Performance History (or someone else's) and paste it into the spreadsheet using Paste Special and it will automatically update the TAPL.