Golf League Scheduling

[cdh121]

Hi everyone:

I have looked through the message boards for solutions to my problem and I don't think I've found anything that quite fits. Here's my challenge...

I run a golf league with 32 teams, so I have 16 tee time slots. Because of time constraints, job responsibilities, etc., my teams fall into 3 general groups:

• Those that can play in any of the tee time slots (1-16)
• Those that can only play in slots 1-8
• Those that can only play in slots 9-16

I am also trying to avoid teams playing each other in back-to-back weeks if possible, but repeats over the course of the season are OK, as are teams not playing each other at all (our season typically runs 16 weeks).

Any help or solutions to this issue are most welcome. If there is an existing solution on these boards that you're aware of, please point me in that direction as well. Thanks in advance.

 

[rilzniak]

Have you tried using ChatGPT or Google Gemini? Below is a sample solution it provided for me. I'm assuming that you may want to change the Tee Time Slot for Group 'A' teams so you could provide that instruction to the software and have it run the results for you.

 

[Fluff]

@rilzniak please note the Rules regarding the use of AI to answer questions. Rule#17

 

[rilzniak]

@rilzniak please note the Rules regarding the use of AI to answer questions. Rule#17

My mistake, I wasn’t aware.

 

[felixstraube]

Maybe you can reuse this, I worked on a while back:

Random Player Generator

I am a member of a golf Society with 20 permanent players. We book 5 time slots x 4 players each week (2 pairs). How do I generate a schedule so that each player plays with a different pairing. There will ultimately be 19 weeks before the schedule reverts back to week 1.

www.mrexcel.com

And use 32 as the value n. Or use 16 for the group that can play anytime, and 8 and 8 for the other groups.
How many teams fall into each group? I would need some more details.

 

[cdh121]

Maybe you can reuse this, I worked on a while back:

Random Player Generator

I am a member of a golf Society with 20 permanent players. We book 5 time slots x 4 players each week (2 pairs). How do I generate a schedule so that each player plays with a different pairing. There will ultimately be 19 weeks before the schedule reverts back to week 1.

www.mrexcel.com

And use 32 as the value n. Or use 16 for the group that can play anytime, and 8 and 8 for the other groups.
How many teams fall into each group? I would need some more details.

Hi Felix. That looks very good! Would it work with the three groups as described? The size of each group changes a bit from year to year, so if there was a way to enter that group size in, that would be awesome. For the sake of example, let's say each group was roughly equal size...10-12 teams per group, totaling 32 teams. If you need exact numbers, you could use 12 for Group A, 8 for B, 12 for C.

 

[cdh121]

My mistake, I wasn’t aware.

Hi Rilzniak...thanks for chiming in. I'm pursuing another solution below but I appreciate your efforts (even though your suggestion is technically not allowed here). Thank you.

 

[felixstraube]

Hi, Maybe this will work?:
File to download: GolfLeagueScheduling.zip

GolfLeagueScheduling.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	Group	Size			Slots	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16
2	A	12			Groups	B	B	B	B	A	A	A	A	A	A	C	C	C	C	C	C
3	B	8		Weeks	1	B 5 - 6	B 1 - 2	B 4 - 7	B 3 - 8	A 5 - 10	A 1 - 2	A 4 - 11	A 3 - 12	A 7 - 8	A 6 - 9	C 5 - 10	C 1 - 2	C 4 - 11	C 3 - 12	C 7 - 8	C 6 - 9
4	C	12			2	B 6 - 7	B 4 - 2	B 1 - 3	B 5 - 8	A 7 - 10	A 8 - 9	A 5 - 12	A 4 - 2	A 6 - 11	A 1 - 3	C 7 - 10	C 8 - 9	C 5 - 12	C 4 - 2	C 6 - 11	C 1 - 3
5		32			3	B 6 - 2	B 7 - 8	B 1 - 4	B 5 - 3	A 1 - 4	A 5 - 3	A 7 - 12	A 6 - 2	A 9 - 10	A 8 - 11	C 1 - 4	C 5 - 3	C 7 - 12	C 6 - 2	C 9 - 10	C 8 - 11
6					4	B 1 - 5	B 6 - 4	B 8 - 2	B 7 - 3	A 7 - 3	A 1 - 5	A 8 - 2	A 9 - 12	A 10 - 11	A 6 - 4	C 7 - 3	C 1 - 5	C 8 - 2	C 9 - 12	C 10 - 11	C 6 - 4
7	Weeks	16			5	B 8 - 4	B 7 - 5	B 2 - 3	B 1 - 6	A 10 - 2	A 8 - 4	A 1 - 6	A 9 - 3	A 7 - 5	A 11 - 12	C 10 - 2	C 8 - 4	C 1 - 6	C 9 - 3	C 7 - 5	C 11 - 12
8					6	B 1 - 7	B 8 - 6	B 2 - 5	B 3 - 4	A 12 - 2	A 11 - 3	A 1 - 7	A 10 - 4	A 9 - 5	A 8 - 6	C 12 - 2	C 11 - 3	C 1 - 7	C 10 - 4	C 9 - 5	C 8 - 6
9	Seed	16/01/2024			7	B 3 - 6	B 1 - 8	B 4 - 5	B 2 - 7	A 9 - 7	A 10 - 6	A 2 - 3	A 1 - 8	A 11 - 5	A 12 - 4	C 9 - 7	C 10 - 6	C 2 - 3	C 1 - 8	C 11 - 5	C 12 - 4
10					8	B 5 - 6	B 1 - 2	B 4 - 7	B 3 - 8	A 2 - 5	A 1 - 9	A 10 - 8	A 3 - 4	A 11 - 7	A 12 - 6	C 2 - 5	C 1 - 9	C 10 - 8	C 3 - 4	C 11 - 7	C 12 - 6
11					9	B 6 - 7	B 4 - 2	B 1 - 3	B 5 - 8	A 4 - 5	A 12 - 8	A 2 - 7	A 3 - 6	A 11 - 9	A 1 - 10	C 4 - 5	C 12 - 8	C 2 - 7	C 3 - 6	C 11 - 9	C 1 - 10
12					10	B 6 - 2	B 7 - 8	B 1 - 4	B 5 - 3	A 5 - 6	A 12 - 10	A 2 - 9	A 4 - 7	A 3 - 8	A 1 - 11	C 5 - 6	C 12 - 10	C 2 - 9	C 4 - 7	C 3 - 8	C 1 - 11
13					11	B 1 - 5	B 6 - 4	B 8 - 2	B 7 - 3	A 5 - 8	A 1 - 12	A 6 - 7	A 4 - 9	A 3 - 10	A 2 - 11	C 5 - 8	C 1 - 12	C 6 - 7	C 4 - 9	C 3 - 10	C 2 - 11
14					12	B 8 - 4	B 7 - 5	B 2 - 3	B 1 - 6	A 5 - 10	A 1 - 2	A 4 - 11	A 3 - 12	A 7 - 8	A 6 - 9	C 5 - 10	C 1 - 2	C 4 - 11	C 3 - 12	C 7 - 8	C 6 - 9
15					13	B 1 - 7	B 8 - 6	B 2 - 5	B 3 - 4	A 7 - 10	A 8 - 9	A 5 - 12	A 4 - 2	A 6 - 11	A 1 - 3	C 7 - 10	C 8 - 9	C 5 - 12	C 4 - 2	C 6 - 11	C 1 - 3
16					14	B 3 - 6	B 1 - 8	B 4 - 5	B 2 - 7	A 1 - 4	A 5 - 3	A 7 - 12	A 6 - 2	A 9 - 10	A 8 - 11	C 1 - 4	C 5 - 3	C 7 - 12	C 6 - 2	C 9 - 10	C 8 - 11
17					15	B 5 - 6	B 1 - 2	B 4 - 7	B 3 - 8	A 7 - 3	A 1 - 5	A 8 - 2	A 9 - 12	A 10 - 11	A 6 - 4	C 7 - 3	C 1 - 5	C 8 - 2	C 9 - 12	C 10 - 11	C 6 - 4
18					16	B 6 - 7	B 4 - 2	B 1 - 3	B 5 - 8	A 10 - 2	A 8 - 4	A 1 - 6	A 9 - 3	A 7 - 5	A 11 - 12	C 10 - 2	C 8 - 4	C 1 - 6	C 9 - 3	C 7 - 5	C 11 - 12
Total

Cell Formulas
Range	Formula
F1:U1	F1	=SEQUENCE(,SUM(B2:B4)/2)
F2:U2	F2	=TEXTSPLIT(REPT(A3&";",B3/2)&";"&REPT(A2&";",B2/2)&";"&REPT(A4&";",B4/2),";",,1)
E3:E18	E3	=SEQUENCE(B7)
F3:U18	F3	=LET( GA, "A " &'Group A'!C6#, GB, "B " &'Group B'!C6#, GC, "C " &'Group C'!C6#, weeks, $B$7, weeksSizeGA, TAKE(VSTACK(GA,GA,GA,GA), weeks), weeksSizeGB, TAKE(VSTACK(GB,GB,GB,GB), weeks), weeksSizeGC, TAKE(VSTACK(GC,GC,GC,GC), weeks), HSTACK(weeksSizeGB, weeksSizeGA,weeksSizeGC) )
B5	B5	=SUM(B2:B4)
Dynamic array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F2:U2	Cell Value	="C"	text	NO
F2:U2	Cell Value	="B"	text	NO
F2:U2	Cell Value	="A"	text	NO

GolfLeagueScheduling.xlsx
	A	B	C	D	E	F	G	H
1	n	12	(n even)
2	Seed	16/01/2024
3
4			Pairs
5			1	2	3	4	5	6
6	Weeks	1	5 - 10	1 - 2	4 - 11	3 - 12	7 - 8	6 - 9
7		2	7 - 10	8 - 9	5 - 12	4 - 2	6 - 11	1 - 3
8		3	1 - 4	5 - 3	7 - 12	6 - 2	9 - 10	8 - 11
9		4	7 - 3	1 - 5	8 - 2	9 - 12	10 - 11	6 - 4
10		5	10 - 2	8 - 4	1 - 6	9 - 3	7 - 5	11 - 12
11		6	12 - 2	11 - 3	1 - 7	10 - 4	9 - 5	8 - 6
12		7	9 - 7	10 - 6	2 - 3	1 - 8	11 - 5	12 - 4
13		8	2 - 5	1 - 9	10 - 8	3 - 4	11 - 7	12 - 6
14		9	4 - 5	12 - 8	2 - 7	3 - 6	11 - 9	1 - 10
15		10	5 - 6	12 - 10	2 - 9	4 - 7	3 - 8	1 - 11
16		11	5 - 8	1 - 12	6 - 7	4 - 9	3 - 10	2 - 11
Group A

Cell Formulas
Range	Formula
B1	B1	=Total!B2
B2	B2	=Total!B9
C5:H5	C5	=SEQUENCE(,B1/2)
B6:B16	B6	=SEQUENCE(B1-1)
C6:H16	C6	=LET(n,$B$1, i,SEQUENCE(n-1,,0), k,INT((SEQUENCE(,n-2)+1)/2), s,IF(ISODD(SEQUENCE(,n-2)),1,-1), res,HSTACK(EXPAND(1,$B$1-1,,1),i+2,MOD(i+k*s,n-1)+2), rows,WRAPROWS(TOCOL(res),2), pairs,BYROW(rows,LAMBDA(x,CHOOSECOLS(x,1)&" - "&CHOOSECOLS(x,2))), nPairs,(n-1)*(n/2), randomNumbers,DROP(REDUCE(B2*(2^31-1)/73051,SEQUENCE(nPairs),LAMBDA(x,y,VSTACK(x,MOD(48271*CHOOSEROWS(x,-1),2^31-1)))),1)/(2^31-1), randomOrder,INT(SEQUENCE(nPairs,,0)/(n/2))+1+randomNumbers, orderedPairs,SORTBY(pairs,randomOrder), final,WRAPROWS(orderedPairs,n/2), final)
Dynamic array formulas.

GolfLeagueScheduling.xlsx
	A	B	C	D	E	F
1	n	8	(n even)
2	Seed	16/01/2024
3
4			Pairs
5			1	2	3	4
6	Weeks	1	5 - 6	1 - 2	4 - 7	3 - 8
7		2	6 - 7	4 - 2	1 - 3	5 - 8
8		3	6 - 2	7 - 8	1 - 4	5 - 3
9		4	1 - 5	6 - 4	8 - 2	7 - 3
10		5	8 - 4	7 - 5	2 - 3	1 - 6
11		6	1 - 7	8 - 6	2 - 5	3 - 4
12		7	3 - 6	1 - 8	4 - 5	2 - 7
Group B

Cell Formulas
Range	Formula
B1	B1	=Total!B3
B2	B2	=Total!B9
C5:F5	C5	=SEQUENCE(,B1/2)
B6:B12	B6	=SEQUENCE(B1-1)
C6:F12	C6	=LET(n,$B$1, i,SEQUENCE(n-1,,0), k,INT((SEQUENCE(,n-2)+1)/2), s,IF(ISODD(SEQUENCE(,n-2)),1,-1), res,HSTACK(EXPAND(1,$B$1-1,,1),i+2,MOD(i+k*s,n-1)+2), rows,WRAPROWS(TOCOL(res),2), pairs,BYROW(rows,LAMBDA(x,CHOOSECOLS(x,1)&" - "&CHOOSECOLS(x,2))), nPairs,(n-1)*(n/2), randomNumbers,DROP(REDUCE(B2*(2^31-1)/73051,SEQUENCE(nPairs),LAMBDA(x,y,VSTACK(x,MOD(48271*CHOOSEROWS(x,-1),2^31-1)))),1)/(2^31-1), randomOrder,INT(SEQUENCE(nPairs,,0)/(n/2))+1+randomNumbers, orderedPairs,SORTBY(pairs,randomOrder), final,WRAPROWS(orderedPairs,n/2), final)
Dynamic array formulas.

GolfLeagueScheduling.xlsx
	A	B	C	D	E	F	G	H
1	n	12	(n even)
2	Seed	16/01/2024
3
4			Pairs
5			1	2	3	4	5	6
6	Weeks	1	5 - 10	1 - 2	4 - 11	3 - 12	7 - 8	6 - 9
7		2	7 - 10	8 - 9	5 - 12	4 - 2	6 - 11	1 - 3
8		3	1 - 4	5 - 3	7 - 12	6 - 2	9 - 10	8 - 11
9		4	7 - 3	1 - 5	8 - 2	9 - 12	10 - 11	6 - 4
10		5	10 - 2	8 - 4	1 - 6	9 - 3	7 - 5	11 - 12
11		6	12 - 2	11 - 3	1 - 7	10 - 4	9 - 5	8 - 6
12		7	9 - 7	10 - 6	2 - 3	1 - 8	11 - 5	12 - 4
13		8	2 - 5	1 - 9	10 - 8	3 - 4	11 - 7	12 - 6
14		9	4 - 5	12 - 8	2 - 7	3 - 6	11 - 9	1 - 10
15		10	5 - 6	12 - 10	2 - 9	4 - 7	3 - 8	1 - 11
16		11	5 - 8	1 - 12	6 - 7	4 - 9	3 - 10	2 - 11
Group C

Cell Formulas
Range	Formula
B1	B1	=Total!B4
B2	B2	=Total!B9
C5:H5	C5	=SEQUENCE(,B1/2)
B6:B16	B6	=SEQUENCE(B1-1)
C6:H16	C6	=LET(n,$B$1, i,SEQUENCE(n-1,,0), k,INT((SEQUENCE(,n-2)+1)/2), s,IF(ISODD(SEQUENCE(,n-2)),1,-1), res,HSTACK(EXPAND(1,$B$1-1,,1),i+2,MOD(i+k*s,n-1)+2), rows,WRAPROWS(TOCOL(res),2), pairs,BYROW(rows,LAMBDA(x,CHOOSECOLS(x,1)&" - "&CHOOSECOLS(x,2))), nPairs,(n-1)*(n/2), randomNumbers,DROP(REDUCE(B2*(2^31-1)/73051,SEQUENCE(nPairs),LAMBDA(x,y,VSTACK(x,MOD(48271*CHOOSEROWS(x,-1),2^31-1)))),1)/(2^31-1), randomOrder,INT(SEQUENCE(nPairs,,0)/(n/2))+1+randomNumbers, orderedPairs,SORTBY(pairs,randomOrder), final,WRAPROWS(orderedPairs,n/2), final)
Dynamic array formulas.

Let me know what you think.

 

[cdh121]

I think that's really close...but teams from the non-time-restricted group A should be able to play teams from B and C. In other words, Group A should be able to play teams from A, B, or C since they can play in any of the time slots; Teams from groups B and C will never play each other because of the restrictions. That allows for more randomness amongst all teams while still keeping restricted teams within their own boundaries. Make sense?

 

[felixstraube]

Yes that makes perfect sense. Lets see if I undestood correctly and the new version does what it should.

File to download: GolfLeagueScheduling2.zip

Try it and let me know.

GolfLeagueScheduling2.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	Group	Size
2	A	12			Slots	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16
3	B	8		Weeks	1	B7 - A9	B6 - A7	B1 - B2	B3 - A11	A1 - A2	B4 - A4	B5 - A8	B8 - A6	C5 - A12	C1 - C2	C4 - A5	C9 - C10	C3 - A10	C7 - C12	C6 - A3	C8 - C11
4	C	12			2	A1 - A9	B6 - A4	B8 - A7	B5 - A11	B1 - B3	A2 - A6	B7 - A8	B4 - B2	C5 - A10	C7 - A12	C8 - A3	C10 - C11	C9 - C12	C6 - A5	C1 - C3	C4 - C2
5		32			3	B5 - B3	B1 - B4	A2 - A7	B6 - B2	A1 - A8	B8 - A4	A6 - A9	B7 - A11	C8 - A5	C6 - C2	C9 - A12	C10 - A3	C5 - C3	C11 - C12	C7 - A10	C1 - C4
6					4	A2 - A4	A1 - A11	B7 - B3	B1 - B5	A6 - A8	A9 - A7	B8 - B2	B6 - B4	C11 - A12	C9 - A10	C7 - C3	C1 - C5	C12 - A3	C8 - C2	C6 - C4	C10 - A5
7	Weeks	16			5	B1 - B6	A2 - B2	B7 - B5	A1 - B3	A7 - A8	A6 - A11	A9 - A4	B8 - B4	C9 - C3	C8 - C4	C7 - C5	C11 - A10	C12 - A5	C1 - C6	C10 - C2	A3 - A12
8					6	A1 - B5	A2 - B4	A6 - B3	B1 - B7	A9 - B2	A7 - A11	A8 - A4	B8 - B6	A3 - A10	C9 - C5	C8 - C6	C10 - C4	A12 - A5	C11 - C3	C12 - C2	C1 - C7
9	Seed	16/01/2024			7	A4 - A11	A6 - B5	A1 - B7	B1 - B8	A2 - B6	A9 - B4	A7 - B3	A8 - B2	A3 - C3	C10 - C6	C11 - C5	A5 - A10	C12 - C4	C9 - C7	C1 - C8	A12 - C2
10					8	A7 - B5	A6 - B7	A11 - B2	A9 - B6	A8 - B4	A4 - B3	B1 - A1	A2 - B8	C12 - C6	A3 - C5	C1 - C9	C11 - C7	A10 - C2	C10 - C8	A5 - C3	A12 - C4
11					9	A8 - B6	A4 - B5	B1 - A2	A7 - B7	A9 - B8	B2 - B3	A6 - A1	A11 - B4	A12 - C6	C1 - C10	C2 - C3	A5 - C5	A10 - C4	C11 - C9	A3 - C7	C12 - C8
12					10	A11 - B6	A8 - B8	B1 - A6	A9 - A2	B3 - B4	A4 - B7	A7 - A1	B2 - B5	C1 - C11	C3 - C4	C2 - C5	A10 - C6	A5 - C7	C12 - C10	A3 - C9	A12 - C8
13					11	B3 - B6	A8 - A2	A7 - A6	B4 - B5	B2 - B7	B1 - A9	A4 - A1	A11 - B8	C1 - C12	A12 - C10	C3 - C6	A10 - C8	C2 - C7	A3 - C11	A5 - C9	C4 - C5
14					12	B5 - B6	A8 - A9	B1 - A7	B4 - B7	B3 - B8	A11 - A2	B2 - A1	A4 - A6	C5 - C6	C3 - C8	A5 - C11	C2 - C9	A10 - C10	C1 - A3	C4 - C7	A12 - C12
15					13	B2 - A6	B3 - A2	B1 - A8	B6 - B7	A4 - A7	B5 - B8	A11 - A9	B4 - A1	C3 - C10	C1 - A12	C5 - C8	A10 - C12	A5 - A3	C4 - C9	C2 - C11	C6 - C7
16					14	A11 - A8	B5 - A2	B7 - B8	B2 - A7	B4 - A6	B1 - A4	B6 - A1	B3 - A9	A10 - A12	C2 - A3	C6 - C9	C1 - A5	C3 - C12	C4 - C11	C7 - C8	C5 - C10
17					15	B3 - A8	B6 - A6	B8 - A1	B5 - A9	B4 - A7	B7 - A2	B2 - A4	B1 - A11	C5 - C12	C6 - C11	C8 - C9	C4 - A3	C2 - A5	C3 - A12	C7 - C10	C1 - A10
18					16	B7 - A9	B6 - A7	B1 - B2	B3 - A11	A1 - A2	B4 - A4	B5 - A8	B8 - A6	C5 - A12	C1 - C2	C4 - A5	C9 - C10	C3 - A10	C7 - C12	C6 - A3	C8 - C11
Total

Cell Formulas
Range	Formula
F2:U2	F2	=SEQUENCE(,SUM(B2:B4)/2)
E3:E18	E3	=SEQUENCE(B7)
F3:U18	F3	=LET( GAB, 'Group AB'!C6#, GAC, 'Group AC'!C6#, GABt, BYROW(GAB, LAMBDA(x, LET(arr, VALUE(TEXTSPLIT(TEXTJOIN(" - ",,x)," - ")),TEXTJOIN(" - ",, IF(arr>$B$3, "A1."&TEXT(arr,"00"),"B"&arr))))), GACt, BYROW(GAC, LAMBDA(x, LET(arr, VALUE(TEXTSPLIT(TEXTJOIN(" - ",,x)," - ")), TEXTJOIN(" - ",, IF(arr>$B$4, "A2."&TEXT(arr,"00"),"C"&arr))))), ABC, HSTACK(GABt,GACt), tj, TEXTJOIN(" - ", ,BYROW(ABC, LAMBDA(x, TEXTJOIN(" - ",,x)))), t, TEXTSPLIT(tj, " - "), a, SORT(UNIQUE(FILTER(t, LEFT(t,1)="A"),1), ,,1), s, "A"&SEQUENCE(,COLUMNS(a)), r, IFERROR(XLOOKUP(t, a, s, ,0),t), v, VALUE(TEXTSPLIT(TEXTJOIN(" - ", ,'Group A'!C6#)," - ")), Aarr, HSTACK(v,v), i, IF(LEFT(r,1)="A", "A"&INDEX(Aarr,1, TEXTAFTER(r,"A")),r), res, WRAPROWS(BYROW(WRAPROWS(i, 2), LAMBDA(x, TEXTJOIN(" - ",,x))), 16), ress,TAKE(VSTACK(res,res), $B$7), ress )
B5	B5	=SUM(B2:B4)
Dynamic array formulas.

GolfLeagueScheduling2.xlsx
	A	B	C	D	E	F	G	H	I	J
1	n	16	(n even)
2	Seed	25/04/2024
3
4			Pairs
5			1	2	3	4	5	6	7	8
6	Weeks	1	7 - 12	6 - 13	1 - 2	3 - 16	9 - 10	4 - 15	5 - 14	8 - 11
7		2	9 - 12	6 - 15	8 - 13	5 - 16	1 - 3	10 - 11	7 - 14	4 - 2
8		3	5 - 3	1 - 4	10 - 13	6 - 2	9 - 14	8 - 15	11 - 12	7 - 16
9		4	10 - 15	9 - 16	7 - 3	1 - 5	11 - 14	12 - 13	8 - 2	6 - 4
10		5	1 - 6	10 - 2	7 - 5	9 - 3	13 - 14	11 - 16	12 - 15	8 - 4
11		6	9 - 5	10 - 4	11 - 3	1 - 7	12 - 2	13 - 16	14 - 15	8 - 6
12		7	15 - 16	11 - 5	9 - 7	1 - 8	10 - 6	12 - 4	13 - 3	14 - 2
13		8	13 - 5	11 - 7	16 - 2	12 - 6	14 - 4	15 - 3	1 - 9	10 - 8
14		9	14 - 6	15 - 5	1 - 10	13 - 7	12 - 8	2 - 3	11 - 9	16 - 4
15		10	16 - 6	14 - 8	1 - 11	12 - 10	3 - 4	15 - 7	13 - 9	2 - 5
16		11	3 - 6	14 - 10	13 - 11	4 - 5	2 - 7	1 - 12	15 - 9	16 - 8
17		12	5 - 6	14 - 12	1 - 13	4 - 7	3 - 8	16 - 10	2 - 9	15 - 11
18		13	2 - 11	3 - 10	1 - 14	6 - 7	15 - 13	5 - 8	16 - 12	4 - 9
19		14	16 - 14	5 - 10	7 - 8	2 - 13	4 - 11	1 - 15	6 - 9	3 - 12
20		15	3 - 14	6 - 11	8 - 9	5 - 12	4 - 13	7 - 10	2 - 15	1 - 16
Group AB

Cell Formulas
Range	Formula
B2	B2	=Total!B9+100
C5:J5	C5	=SEQUENCE(,B1/2)
B6:B20	B6	=SEQUENCE(B1-1)
C6:J20	C6	=LET(n,$B$1, i,SEQUENCE(n-1,,0), k,INT((SEQUENCE(,n-2)+1)/2), s,IF(ISODD(SEQUENCE(,n-2)),1,-1), res,HSTACK(EXPAND(1,$B$1-1,,1),i+2,MOD(i+k*s,n-1)+2), rows,WRAPROWS(TOCOL(res),2), pairs,BYROW(rows,LAMBDA(x,CHOOSECOLS(x,1)&" - "&CHOOSECOLS(x,2))), nPairs,(n-1)*(n/2), randomNumbers,DROP(REDUCE(B2*(2^31-1)/73051,SEQUENCE(nPairs),LAMBDA(x,y,VSTACK(x,MOD(48271*CHOOSEROWS(x,-1),2^31-1)))),1)/(2^31-1), randomOrder,INT(SEQUENCE(nPairs,,0)/(n/2))+1+randomNumbers, orderedPairs,SORTBY(pairs,randomOrder), final,WRAPROWS(orderedPairs,n/2), final)
Dynamic array formulas.

GolfLeagueScheduling2.xlsx
	A	B	C	D	E	F	G	H	I	J
1	n	16	(n even)
2	Seed	16/01/2024
3
4			Pairs
5			1	2	3	4	5	6	7	8
6	Weeks	1	5 - 14	1 - 2	4 - 15	9 - 10	3 - 16	7 - 12	6 - 13	8 - 11
7		2	5 - 16	7 - 14	8 - 13	10 - 11	9 - 12	6 - 15	1 - 3	4 - 2
8		3	8 - 15	6 - 2	9 - 14	10 - 13	5 - 3	11 - 12	7 - 16	1 - 4
9		4	11 - 14	9 - 16	7 - 3	1 - 5	12 - 13	8 - 2	6 - 4	10 - 15
10		5	9 - 3	8 - 4	7 - 5	11 - 16	12 - 15	1 - 6	10 - 2	13 - 14
11		6	13 - 16	9 - 5	8 - 6	10 - 4	14 - 15	11 - 3	12 - 2	1 - 7
12		7	13 - 3	10 - 6	11 - 5	15 - 16	12 - 4	9 - 7	1 - 8	14 - 2
13		8	12 - 6	13 - 5	1 - 9	11 - 7	16 - 2	10 - 8	15 - 3	14 - 4
14		9	14 - 6	1 - 10	2 - 3	15 - 5	16 - 4	11 - 9	13 - 7	12 - 8
15		10	1 - 11	3 - 4	2 - 5	16 - 6	15 - 7	12 - 10	13 - 9	14 - 8
16		11	1 - 12	14 - 10	3 - 6	16 - 8	2 - 7	13 - 11	15 - 9	4 - 5
17		12	5 - 6	3 - 8	15 - 11	2 - 9	16 - 10	1 - 13	4 - 7	14 - 12
18		13	3 - 10	1 - 14	5 - 8	16 - 12	15 - 13	4 - 9	2 - 11	6 - 7
19		14	16 - 14	2 - 13	6 - 9	1 - 15	3 - 12	4 - 11	7 - 8	5 - 10
20		15	5 - 12	6 - 11	8 - 9	4 - 13	2 - 15	3 - 14	7 - 10	1 - 16
Group AC

Cell Formulas
Range	Formula
B2	B2	=Total!B9
C5:J5	C5	=SEQUENCE(,B1/2)
B6:B20	B6	=SEQUENCE(B1-1)
C6:J20	C6	=LET(n,$B$1, i,SEQUENCE(n-1,,0), k,INT((SEQUENCE(,n-2)+1)/2), s,IF(ISODD(SEQUENCE(,n-2)),1,-1), res,HSTACK(EXPAND(1,$B$1-1,,1),i+2,MOD(i+k*s,n-1)+2), rows,WRAPROWS(TOCOL(res),2), pairs,BYROW(rows,LAMBDA(x,CHOOSECOLS(x,1)&" - "&CHOOSECOLS(x,2))), nPairs,(n-1)*(n/2), randomNumbers,DROP(REDUCE(B2*(2^31-1)/73051,SEQUENCE(nPairs),LAMBDA(x,y,VSTACK(x,MOD(48271*CHOOSEROWS(x,-1),2^31-1)))),1)/(2^31-1), randomOrder,INT(SEQUENCE(nPairs,,0)/(n/2))+1+randomNumbers, orderedPairs,SORTBY(pairs,randomOrder), final,WRAPROWS(orderedPairs,n/2), final)
Dynamic array formulas.

GolfLeagueScheduling2.xlsx
	A	B	C	D	E	F	G	H
1	n	12	(n even)
2	Seed	06/03/2024
3
4			Pairs
5			1	2	3	4	5	6
6	Weeks	1	1 - 2	6 - 9	7 - 8	4 - 11	3 - 12	5 - 10
7		2	7 - 10	8 - 9	6 - 11	1 - 3	4 - 2	5 - 12
8		3	1 - 4	9 - 10	8 - 11	7 - 12	6 - 2	5 - 3
9		4	6 - 4	1 - 5	10 - 11	7 - 3	9 - 12	8 - 2
10		5	9 - 3	8 - 4	7 - 5	10 - 2	1 - 6	11 - 12
11		6	1 - 7	9 - 5	12 - 2	8 - 6	10 - 4	11 - 3
12		7	9 - 7	10 - 6	11 - 5	12 - 4	2 - 3	1 - 8
13		8	1 - 9	3 - 4	2 - 5	12 - 6	10 - 8	11 - 7
14		9	3 - 6	2 - 7	11 - 9	12 - 8	4 - 5	1 - 10
15		10	3 - 8	12 - 10	4 - 7	2 - 9	5 - 6	1 - 11
16		11	1 - 12	3 - 10	2 - 11	6 - 7	5 - 8	4 - 9
Group A

Cell Formulas
Range	Formula
B1	B1	=Total!B2
B2	B2	=Total!B9+50
C5:H5	C5	=SEQUENCE(,B1/2)
B6:B16	B6	=SEQUENCE(B1-1)
C6:H16	C6	=LET(n,$B$1, i,SEQUENCE(n-1,,0), k,INT((SEQUENCE(,n-2)+1)/2), s,IF(ISODD(SEQUENCE(,n-2)),1,-1), res,HSTACK(EXPAND(1,$B$1-1,,1),i+2,MOD(i+k*s,n-1)+2), rows,WRAPROWS(TOCOL(res),2), pairs,BYROW(rows,LAMBDA(x,CHOOSECOLS(x,1)&" - "&CHOOSECOLS(x,2))), nPairs,(n-1)*(n/2), randomNumbers,DROP(REDUCE(B2*(2^31-1)/73051,SEQUENCE(nPairs),LAMBDA(x,y,VSTACK(x,MOD(48271*CHOOSEROWS(x,-1),2^31-1)))),1)/(2^31-1), randomOrder,INT(SEQUENCE(nPairs,,0)/(n/2))+1+randomNumbers, orderedPairs,SORTBY(pairs,randomOrder), final,WRAPROWS(orderedPairs,n/2), final)
Dynamic array formulas.