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 macro 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.
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 macro 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.
