[thehip41]

As I talked about in part 1, I set up the schedule using series as the building blocks. In this part, we are going to take the series blocks we created in the 10 team rotation and use them to start scheduling games.

The first thing you do is go to the 10 T Rotation tab. You can see on the right the first number in the first row is 9. That means on the left, we are using block 9 as the first set of games.

Copy those 10 cells, go to the Schedule tab, and paste them into cell E2. This is the first Tuesday of the first week. (remember we are playing 6 games a week, T W Th, Fr Sa Sun.

Right now we have 5 games scheduled on the first Tuesday. I usually flip a few numbers so it's not all the low numbered teams on the road.

You can either just manual pick them or use a RNG to decide which ones to use. For this, I will switch teams 1, 2 and 4 at home.

This leaves us with these 5 games on Tuesday:
9 10 8 1 7 2 3 6 5 4

I highlight all 10 numbers to make sure I am using each team once. For this league, it's 10 numbers, sum is 55. If you had team 4 in there a twice, the sum wouldn't be 55.

After you are satisfied with these five games, we need to mark them off on the "matchup" tab.

On the matchup tab, highlight the series 9 10. 8 1. Repeat for all 5.

Since this is the first series, all 5 of those will be available. Later in the schedule, maybe all 3 series of 8@1 are highlighted and you have to change it to 1@8.

Back on the schedule page, copy/paste the games to Wednesday and Thursday.

Now we are going to use the HA tab. We want to keep track of what teams are home and away.

For the first series, these are the home teams. 1 2 4 6 10.

On the HA tab, in the first row, put an H in the columns for 1 2 4 6 10.

The HA tab has several formulas in it.
- In row 2, I have a Counta formula to count all the "h" in that column for each team. When you put "h" in c3, it will count that as a home series for team 1.
- In column M, I have another counta. It will count everything in that row.
-There are two conditional formatting sets. In Column M, once it hits 5, it will trigger the CF. I do this so I can make sure that I have exactly 5 home teams that bar.
-The second CF is for every bar inside the table. If you type h, it will turn blue.


So when you type in H for the 5 home teams, it will add 1 to row 2, it will color it blue (so you can easily see the Homestands and Roadtrips), and it will color column M orange once it hits 5.

These are just checks for me to make sure everything is right. For a 10 team league its not that pressing, but if you have 40 teams, its more important.

Lastly, we go to the 10 T Rotation tab. Highlight Group 9. Highlight the number 9 at the top of the row.


We repeat the process for the Fr, Sa, Sun series. For the second series, we will use the second number in row AB (1)