Unique Pairs for 12 Players

[TerrorTot38]

Hi All,

I have a maths question I need your help with.

I'm trying to generate 12 unique pairs for Badminton Doubles to not have the following:

• Player 12 not playing Player 4 three times (example Game 4, Game 5 and Game 6)
• Player 5 not playing Player 7, 8 and 11 more than once such as 7,8, 7,11 or 8,11 but not all 3 (shown below)

This is my game sheet thus far below, as you can see all unique pairs:

Match：1	Court 1	Court 2	Court 3
	9 & 1	11 & 2	12 & 7
	10 & 6	4 & 5	8 & 3
Match：2	Court 1	Court 2	Court 3
	3 & 5	12 & 10	1 & 4
	7 & 8	11 & 6	2 & 9
Match：3	Court 1	Court 2	Court 3
	12 & 2	4 & 7	6 & 8
	3 & 9	5 & 1	10 & 11
Match：4	Court 1	Court 2	Court 3
	1 & 3	12 & 8	10 & 2
	5 & 6	9 & 4	11 & 7
Match：5	Court 1	Court 2	Court 3
	10 & 1	12 & 6	8 & 11
	3 & 4	7 & 2	9 & 5

However I make changes to one thing and either no unique pairs or in my example above Player 5 against 7,8 and 11.

I have represented the data to show the players and opponents across the games.

	Game 3	Game 3	Game 4	Game 4	Game 5	Game 5	Game 7	Game 7	Game 10	Game 10
1	10	6	2	9	4	7	5	6	3	4
2	4	5	1	4	3	9	11	7	12	6
3	12	7	7	8	12	2	5	6	10	1
4	11	2	2	9	5	1	12	8	10	1
5	11	2	7	8	4	7	1	3	8	11
6	9	1	12	10	10	11	1	3	7	2
7	8	3	3	5	5	1	10	2	12	6
8	12	7	3	5	10	11	9	4	9	5
9	10	6	1	4	12	2	12	8	8	11
10	9	1	11	6	6	8	11	7	3	4
11	4	5	12	10	6	8	10	2	9	5
12	8	3	11	6	3	9	9	4	7	2

Could anyone advise if this iteration is possible or the closest I'm going to get is what I have.

 

[Sulprobil]

I suggest to google for
tournament round robin filetype:xlsm.

There is a manual approach, too: just imagine 6 tables in a row adjacent to each other, the 12 players sitting face-to-face. Each table represents a court (games for tables 4-6 have to be played at the same courts as 1-3 after those games are finished). After round 1 player 1 stays at his table and at his chair, all other players move one place in counter-clock direction, and so on.

 

[NdNoviceHlp]

Here's some Round Robin code. HTH. Dave

Round Robin

Hi, very new to this so please be gentle. Im trying to make a round robin draw for my local league. 20 players to play each other 3 times, `Ive searched the web and tried all sorts of different things to no avail, please if any help is available would much appreciate it.

www.mrexcel.com