I wish I had the math skills to tackle the following dilemma. I schedule or help schedule a number of tournaments for a few different sports. A round robin (each member of the group plays each other member once) format is commonly used in the first round to whittle a large number of players/teams down to a more manageable number to enter the draw proper by advancing only the top players. Sometimes a round robin is used as a final placing. I have always wished for an excel sheet whereby I could just plug in the number of entrants for a particular round robin and have the sheet spit out who plays who in each successive round. An odd number of entrants would end up with one bye per team during the round robin. Tournament schedulers like to pit the top two seeds against each other during the last round of a round robin. Generally the higher the seed, the weaker the competition in the opening rounds. Does anyone have a formula or macro that could be applied to this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sport Round Robin Algorithm
- Thread starter kdeans
- Start date
Similar threads
- Locked
- Question