View Single Post
Old 04-07-2015, 01:31 PM   #3
thehip41
Major Leagues
 
thehip41's Avatar
 
Join Date: Aug 2014
Posts: 349
Part 2 - Setting the series match ups

Now that we know we need 18 games vs. each of the 9 teams in the league, we need to list out all the games that can be scheduled; for all the teams.

I group them by series.

On the Matchup tab, you can see all the series that will be scheduled on this schedule.

We start with team 1:

Team 1 plays 3 home series and 3 road series vs. all the teams.

In the first two cells of row 1; you can see 1 2 This translates to 1 @2

That's a 3 game series.

For each team, team 1 plays 3h/3a series. That looks like this

1 2 2 1
1 2 2 1
1 2 2 1


Repeat for all 9 opponents.

For team 2, all 18 games vs. team 1 are already scheduled. So we start with 23 32.

For team 3, all games vs. team 1 and 2 are accounted for, so we start with 34 43.

Once you get to team 9, we have

9 10 10 9 three times.

Team 10 has nothing listed since all of their games are accounted for.

I use this sheet to keep track of the series I've already scheduled.



The next step is determining who plays who and when.
Attached Files
File Type: xls 10T 162G 10 GUIDE PART 2.xls (38.5 KB, 1121 views)
thehip41 is offline   Reply With Quote