Check 1: Double Booking

Using "CountIf" to ensure that teams do not play twice in the same day.

Games not occurring on back to back days is ensured by the every other day schedule format. This does not necessarily ensure that a team does not play twice on the same day.

Adding a game, checking the output.

After adding an erroneous game, notice how the check moves from "1" to "2".

Check 2: Confirming Number of Games

This check confirms that all teams are playing the right amount of games in the raw schedule output and in the distance calculation.

If a game was deleted, the distance calculation would come out low and if a game was double counted the output would come out high. I calculated distances for both the actual schedule and mine. The output on the "Schedule Comparison" page comes from these calculations.

Calculation made from distance calculation output using "countif" formula. It matches the number of games played in the 2018-2019 season.

Sacramento plays at Portland once in the 2018-2019 season because they are not in the same division. (Sacramento will play at Portland twice for the next four years.)

Delete a game, checking the output.

If I delete a game, the "countif" formula counts one less and the corresponding "if" formula returns the string "different".