[thehip41]

After you have all the series mapped out and you verify that you have all the games on the matchup tab, it's time to move onto setting up the rest of the work papers.

I must stress its imperative that you have the correct amount of series/games on the matchup tab. If you have too few or too many games there, this isn't going to work.


There are three more tabs added:
- Schedule
- HA
- Ten team rotation


The schedule is where we will paste our games. Since we have 5 games a day, I just put a new week every 10 lines. Just have to make sure to leave enough lines for each day's games.


The HA is where I track the teams home and away series. For 3 games series like this schedule, I try to keep it at a maximum of 4 series in a row at home or on the road. With 10 teams this is pretty straight forward.


The Rotation tab is the key to the schedule. On this tab, we have a full rotation of each team playing every other team. For 10 teams, you will have a block of 9 series. For 16 teams, it will be a bock of 15 series. This might be the constraint when creating your own schedule. If you get stuck trying to create this, there are websites that will create schedules for you . I just use them to create a schedule with 1 game vs. each team. So for 10 teams, it's a 9 game schedule. I just take that schedule and make it into my rotation template.

On the Rotation tab, we have 9 blocks. Each team plays every other team 6 times. On the right hand side, I created a list of series. This is how I will schedule my games. I use a random number generator and plot out 1-9 in row AB. I do the same thing for the row AC.

I try to keep the end of row one and the beginning of row two so that the teams don't play within 2 series of each other. So the end of row 1 is 5 3. I don't want the beginning of row 2 to be a 5 or a 3.

Our schedule will be created using the rows on the right and the blocks of games that is corresponds with on the left.

We will touch on the HA tab once we start scheduling games.