View Single Post
Old 04-08-2015, 03:27 PM   #9
thehip41
Major Leagues
 
thehip41's Avatar
 
Join Date: Aug 2014
Posts: 349
Part 5 - Finishing the scheduling of games

Where we left off in part 4, we had schedule 1 series for each team. We have 53 more series to schedule.

What we do next is look on our 10 T Rotation. The second number in the first row is a 1 (9 was first series). We copy the 5 series from block one into the first Friday in the schedule:

1 10 2 9 3 8 4 7 5 6

These are the match ups for the next series. This is the first real decision you have to make. Do you want teams to go back and forth for H/A. Do you want to try to build out some 3-4 series home stands?

For the most part, I try to do two things when scheduling after the first series:
1. Keep the teams with a similar amount of home series as I go (row 2 on the HA tab will tell you how many series they have at home)

2. Keep teams at home or on the road for 2 to 4 series.

Again, it's up to you. I try to balance it out earlier in the season because you have less options later in the schedule since team 2 has to play at team 4 when there is only one series left (or any other team as an example)

So the matchup 1 - 10 Both were at home in series 1. I just randomly choose who's at home this series.

Same with 3-8.

After you set who is at home on the schedule tab, go to the matchup tab and highlight the 5 series you selected.

Then go to the HA tab and put an H in the 5 teams that are home in series 2.

Then go to the 10 T Rotation tab, highlight block 1 and the number 1 in the first row.

Now you have two series scheduled.

Repeat this 52 more times

When you are the end, you should have all the match up highlighted, row two of the HA tab should say 27 for each team. Column M should be orange for each row.

On the 10 T Rotation page, you should have all six columns highlighted.


After you have everything set up and you feel you have the right amount of games for everyone, it's time to test the schedule.

Next time.
Attached Files
File Type: xls 10T 162G 10 GUIDE PART 5.xls (86.5 KB, 505 views)
thehip41 is offline   Reply With Quote