OOTP Developments Forums - View Single Post - Making a 162-game Schedule for 22 teams using Excel

Kirby Paquette · 04-27-2022, 11:07 AM

04 The Schedule

The first thing to do is paste “The Swiss Knife” on the right in the schedule sheet. I call it “The Swiss Knife” because it is very useful. It allows me to transposed the rows of games of a whole week into columns that will be used for the final assembly of the schedule.

Name: 032.png
Views: 718
Size: 66.0 KB

I have designed it for 40 teams (or 20 games) but it can be easily adapted for 22 teams (11 games) by just shorting up the ROWBOX. Then bringing up the SK-BOX and the GAMEBOX covering position 12 to 20. I do that for all the seven “days” of the week.

Name: 033.png
Views: 722
Size: 89.8 KB

Here it is, all adapted for my needs.

Name: 035.png
Views: 715
Size: 77.8 KB

I copy and paste a bunch of them, one under another.

Name: 036.png
Views: 708
Size: 104.0 KB

04-27-2022, 11:07 AM	#10
Kirby Paquette Major Leagues Join Date: May 2009 Location: Montreal Posts: 308	04 The Schedule The first thing to do is paste “The Swiss Knife” on the right in the schedule sheet. I call it “The Swiss Knife” because it is very useful. It allows me to transposed the rows of games of a whole week into columns that will be used for the final assembly of the schedule. I have designed it for 40 teams (or 20 games) but it can be easily adapted for 22 teams (11 games) by just shorting up the ROWBOX. Then bringing up the SK-BOX and the GAMEBOX covering position 12 to 20. I do that for all the seven “days” of the week. Here it is, all adapted for my needs. I copy and paste a bunch of them, one under another.