PDA

View Full Version : Sports scheduling helper



JayTee
08-11-2018, 11:16 AM
I have a simple scheduling table to determine 16-game schedules in a league of 32 teams:

https://i.imgur.com/ShtN22o.png

The teams are numbered 1-32. The games in the red triangle are all the unique games (everything repeats on the other half). A team's schedule can be read across or down. For example, Team 9 plays 1, 5, 10, 10, 11, 11, 12, 12, 13, 14, 15, 16, 17, 21, 25, 29 (they play 10, 11 and 12 twice as indicated in those cells).

There are 256 games total for the season. What I would like to do is write a program that uses this table to print (to a separate table) all 256 games as rows, like this:

https://i.imgur.com/hO4DFMn.png

Ideally, the games would be set so that each team plays 8 home games and 8 away games, though I realize this adds complexity and likely would take extra tables/steps.

Any help on getting started would be appreciated.

Fluff
08-11-2018, 11:44 AM
Cross posted https://www.mrexcel.com/forum/excel-questions/1066659-sports-scheduling-helper.html