|
So now that you have all 54 series scheduled for each team, we need to make sure that every team plays exactly 162 games overall; and exactly 81 at home.
I do this by using the Cont+F in excel. On the schedule tab, make sure all of your cells are numbers and not formulas. Do this buy copying the whole page, and pasting using the "123" function. For this page, we usually hard type everything so it's not a huge issue.
After you do this, hit Cont F to bring up the search box.
Hit options
Check the "match entire cell contents" box
type: 1 in the find what box. Hit find all.
With hope, it will say 162 cell(s) found.
Erase 1, hit 2. Find all.
Repeat for the amount of teams you have. Make sure they are all 162.
That will test to make sure we all have 162 games. For the second test, make a copy of the Schedules tab.
Right click the schedules tab
move or copy
click the create a copy box
highlight (move to End)
Hit ok
It will created schedule(2) at the end. On this tab, delete columns
A
C
E
G
I
K
M
We will be left with only the HOME games of every series.
Do the control + F again. same process.
We should have 81 games for each team.
Sometimes you will have a few teams with 84 and a few with 78. Or more or less.
When this happens, you have to trouble shoot and figure out what happened. Most of the time, you will have one team with 84 home games, and one team with 78 home games.
So instead of 9H/9A against say, team 3, team 1 has 12H/6A
This happens occasionally. What I do is do a replace on the back up schedule.
So lets create a new copy of the schedule. So we have Schedule(3) tab.
Hit control F
Hit the Replace tab
Make sure "match entire cell contents" is checked.
Find what: 1
Replace with: 1 (but format the cell color to some warm color, like light orange
Find what: 3
Replace with: 3 (format the cell color to some cool color, like light blue.
You will replace all 162 games for each of these teams. The 18 games they play against each other will be easy to see, you will have an orange cell next to a blue cell 3 games in a row.
Look at see, we will probably see four series of 3-1 and two series of 1-3.
Change one of the 3-1's to 1-3 (the whole series).
Save, create a new copy, and then test to see if they have the same amount of home games.
Once all the teams have the same amount of games (162) and home games (81), we are ready to move on.
On thing, this won't test that we play the correct amount of games vs. each team. But using the matchup tab, it's hard to schedule the wrong amount of games vs. several teams and have everyone have the 162 - 81 answers when we roll the test.
From here, we take our schedule and make 4 columns in an excel file that we will copy and paste into the Open Office file.
From the open office file, we will save it as the .lsdl file
|