[thehip41]

At this point we have verified our schedule is correct. All teams have the correct amount of home games and total games. We assume the games vs. opponents is correct because we used the matchup tab. We can test that after we import into the game as well.


Now what we will do is create a new tab, I usuallu call it Export. We need 4 columns.

Column A will be the Day of the schedule. I always start at 1.
Column B will be the time of the game
Column C is the Road team
Column D is the home team.

Make sure there are no equations in the export tab, just numbers.

For Column A, we need 5 games per day. Since our schedule is very balances, we play 6 days in a row, and then one off day. For this I do the following.

I type in

1
1
1
1
1
2
2
2
2
2
all the way through 6.

Then in the Row 31, just use this formula =7+A1

Copy that all the way down. It will give us 5 games a day for six days in a row and the 7th day off.

Each schedule is different.

When I have schedules that have varying days off, or 2 games one day and 5 the next, I simply take the amount of teams and divide by two. That is how many games you can have (the max) on a certain day. Then as you start copying, you can delete the extra games for certain days.

Now we have the days correctly listed in Column A. We can add times a few ways. You can make all the games at 7pm. so 1900.

Just type 1900 in the first column and copy it all the way down.

Or you can use the RNG to assign some times as 1900 or 1700 or whatever you want.

Regardless of how you decide, they go in the second column.

Games, we are going to copy from the schedule tab to the export tab.

On the schedule tab, erase the background fills for all the numbers. Then highlight the 5 games being played on day 1. Copy

Go to C1 on the export tab. Paste them there.

Then paste two more times on day 2 and day 3.

Once you have that done, I mark off those games on the schedule tab so I know I already copied them.

Do this for the rest of the games. Since we have no all star game, it's a simple matter of copying and pasting until we are done.

Once we have all the games in the export tab, I do a sum all equation on the bottom of each row. If they don't equal, something is wrong.

Another good check figure. We had 810 games we need to schedule (based on the calculations from the Info tab)
You can see the export file, it has 810 lines. We have all the games we are supposed to have.


Assuming they are equal, we are ready to copy this to the Open Office file template I created.