•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Tournament Player Selection Problem
Our take
In organizing a charity tournament for 22 players over 13 hours, the challenge lies in fairly rotating participants across three courts. With four players per court each round, ensuring balanced playtime and minimizing repeated pairings is essential. Your initial idea of a 38-round table, featuring 22-minute games, highlights the complexity of achieving equitable matchups and rest periods. To enhance fairness and variety, consider developing a structured rotation system that evenly distributes games and partners, fostering an enjoyable experience for all participants.
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]
Read on the original site
Open the publisher's page for the full experience
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