Consulting

Results 1 to 2 of 2

Thread: Sports scheduling helper

  1. #1
    VBAX Newbie
    Joined
    Aug 2018
    Posts
    1
    Location

    Question Sports scheduling helper

    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.

  2. #2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •