|
There is one more step before moving on. I try to verify I have the correct number of series on my "matchup" tab. I use the COUNTA function in excel.
A few rows below the matchups, in A30, I use this formula:
=counta(a1:aaa29)
This gives a result of 540
This is a count of all the numbers on the screen. We need to translate to total games.
Divide this 540 by 2 = 270 (This is because there are two numbers on the screen for each series (1 2 2 1) etc)
270 is the number of total series in the league schedule. Each series has 3 games.
270 * 3 = 810
If you look on the info page, we already proved out that there are 810 total games.
10 teams times 162 games each = 1620. Divide that by 2 = 810.
In the next installment, I will go over the workpapers for the Daily Schedule, the Team Rotations, and the Home/Away splits.
|