u/InternationalBad5251

▲ 3 r/excel

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!

reddit.com
u/InternationalBad5251 — 16 days ago