View Full Version : Sports scheduling helper

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


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:


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.

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