•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Tournament Player Selection Problem
I want to work out who will be playing on which court each round.
A charity tournament has been organised for 22 players.
We are playing for 13 hours, where 3 courts will have 4 people playing. (12 playing 10 resting).
I want to create a table for players numbered 1 to 22. Where partners and opponents mix as evenly as possible. I'm struggling to ensure fairness of the number of games per player and the least amount of pairings duplicated.
My initial plan was creating a table of 38 rounds (22 minute games, last game just carries on till finish) but struggled to figure out the fairest rotation.
Any ideas or help is appreciated!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#Excel alternatives
#tournament
#players
#22 players
#player selection
#fairness
#games
#rotation
#pairings
#courts
#table
#partners
#opponents
#rounds
#charity