Golf League Schedule, 20 Teams, Front & Back Nines

[bsteinerjr]

Hello, I am a secretary of a 20-team golf league that plays weekly with 10 teams playing the front-9 and 10 teams playing the back-9 each week. We play a 19-week schedule with all teams playing each other once. A standard 20-team, 19-week is no problem; however, the goal is also for each team to play the same 9 on back-to-back weeks as few times as possible. Is anyone aware of a way to develop a schedule of this nature.

Any help with this issue is greatly appreciated!!!

 

[BSALV]

i have no idea what you're asking, but can you show an example of what you ask, for example for 4 or 5 teams.
Extrapolating to 20 is then easy (?)

 

[bsteinerjr]

Okay, I'll try to better explain/illustrate what I'm asking. Here are the facts:

1. The golf course has 18 holes, consisting of holes 1 thru 9 (the front-9) and holes 10-18 (the back-9).
2. Our golf league consists of 20 teams.
3. Our season lasts 19 weeks and all teams play each other one time.
4. Each week there are ten two-team matches, five on the front-9 and five on the back-9.

I have a standard 20-team, 19-week schedule that accomplishes bullet point 3 above; however, ideally, each team would alternate which nine they play each week. Unfortunately, this is impossible. For example, let's assume teams 1 thru 10 play against each other for the first nine weeks of the season, alternating between the front-9 to back-9 each week. Likewise, for the same nine weeks, teams 11 thru 20 play each other alternating between the back-9 to the front-9 each week. Starting with week ten teams 1 thru 10 will begin playing teams 11 thru 20, and this is where the problem arises. At this point in the schedule, half of the teams will have to play the front-9 two weeks in a row and the other half of the teams will have to play the back-9 two weeks in a row. The issue of teams having to play the front-9 or back-9 on consecutive weeks will continue to occur numerous times for the remainder of the schedule. The goal of the schedule I am seeking would minimize and distribute evenly the number of times this occurs. I have included an 8-team schedule below to illustrate the problem I am encountering.

View attachment 62554

As previously indicated, the ideal 20-team schedule would accomplish the following:

• Cover a period of 19 weeks with all teams playing each other one time.
• Each team would alternate playing the front-9 and back-9 each week as often as possible.
• Playing the same 9 by any team on consecutive weeks would occur as few times as possible.
• When playing the same 9 on consecutive weeks occurs, these occurrences would be distributed evenly between teams across the schedule.

Thank you for your help with this issue!

 

[bsteinerjr]

Here is the attachment I reference in my previous posting. It appears there may be issues viewing this attachment.

 

[BSALV]

20 teams = 190 combinations of duos (team 1 vs team 2 = team 2 vs team 1 = 1 duo)
Every round everybody plays, so that's 10 duos, 5 in the front, 5 in the back
Every duo has to play once in the front, once in the back.
So you need 190/10 * 2 = 38 rounds.
Where do i make an error ?

 

[BSALV]

ra.xlsm
a first trial, your 38 rounds without alternating Front-Back each round.
How far was your previous solution ?
Did you have alternating Front's and Back's or didn't you have a solution at all ?

ra.xlsm
	C	D	E	F	G	H	I	J	K	L	M
1	round	Front1	Front2	Front3	Front4	Front5	Back1	Back2	Back3	Back4	Back5
2	week 1	Team7 vs Team18	Team17 vs Team20	Team1 vs Team16	Team9 vs Team12	Team2 vs Team10	Team4 vs Team8	Team5 vs Team14	Team6 vs Team11	Team3 vs Team19	Team13 vs Team15
3	week 2	Team7 vs Team10	Team8 vs Team20	Team5 vs Team14	Team4 vs Team12	Team13 vs Team19	Team17 vs Team18	Team2 vs Team6	Team3 vs Team11	Team1 vs Team15	Team9 vs Team16
4	week 3	Team6 vs Team18	Team13 vs Team16	Team8 vs Team9	Team11 vs Team12	Team4 vs Team10	Team17 vs Team19	Team2 vs Team7	Team5 vs Team15	Team3 vs Team20	Team1 vs Team14
5	week 4	Team1 vs Team12	Team8 vs Team10	Team3 vs Team11	Team5 vs Team9	Team15 vs Team16	Team14 vs Team19	Team4 vs Team18	Team7 vs Team13	Team6 vs Team17	Team2 vs Team20
6	week 5	Team2 vs Team3	Team17 vs Team18	Team11 vs Team15	Team9 vs Team13	Team1 vs Team4	Team16 vs Team19	Team5 vs Team6	Team10 vs Team20	Team7 vs Team12	Team8 vs Team14
7	week 6	Team2 vs Team7	Team6 vs Team15	Team12 vs Team13	Team14 vs Team17	Team9 vs Team16	Team1 vs Team11	Team8 vs Team19	Team3 vs Team4	Team5 vs Team20	Team10 vs Team18
8	week 7	Team16 vs Team18	Team8 vs Team19	Team4 vs Team5	Team1 vs Team14	Team6 vs Team13	Team10 vs Team11	Team7 vs Team9	Team2 vs Team15	Team17 vs Team20	Team3 vs Team12
9	week 8	Team3 vs Team10	Team8 vs Team15	Team2 vs Team6	Team7 vs Team12	Team13 vs Team14	Team11 vs Team18	Team4 vs Team9	Team16 vs Team17	Team1 vs Team20	Team5 vs Team19
10	week 9	Team9 vs Team18	Team13 vs Team20	Team5 vs Team12	Team14 vs Team19	Team11 vs Team17	Team15 vs Team16	Team1 vs Team2	Team6 vs Team8	Team3 vs Team10	Team4 vs Team7
11	week 10	Team4 vs Team6	Team5 vs Team7	Team10 vs Team19	Team1 vs Team17	Team15 vs Team20	Team9 vs Team13	Team11 vs Team16	Team2 vs Team3	Team8 vs Team18	Team12 vs Team14
12	week 11	Team6 vs Team7	Team1 vs Team3	Team2 vs Team20	Team4 vs Team9	Team5 vs Team19	Team14 vs Team17	Team10 vs Team16	Team12 vs Team18	Team8 vs Team13	Team11 vs Team15
13	week 12	Team3 vs Team7	Team14 vs Team15	Team2 vs Team13	Team6 vs Team17	Team9 vs Team20	Team10 vs Team12	Team5 vs Team8	Team1 vs Team19	Team4 vs Team11	Team16 vs Team18
14	week 13	Team4 vs Team20	Team2 vs Team14	Team10 vs Team16	Team13 vs Team15	Team12 vs Team18	Team1 vs Team6	Team8 vs Team9	Team7 vs Team19	Team11 vs Team17	Team3 vs Team5
15	week 14	Team4 vs Team15	Team3 vs Team6	Team5 vs Team8	Team1 vs Team20	Team13 vs Team18	Team11 vs Team19	Team7 vs Team10	Team2 vs Team16	Team9 vs Team14	Team12 vs Team17
16	week 15	Team1 vs Team5	Team3 vs Team19	Team2 vs Team15	Team12 vs Team16	Team4 vs Team17	Team7 vs Team8	Team9 vs Team11	Team18 vs Team20	Team10 vs Team13	Team6 vs Team14
17	week 16	Team2 vs Team11	Team7 vs Team8	Team1 vs Team9	Team4 vs Team14	Team3 vs Team16	Team18 vs Team19	Team15 vs Team20	Team6 vs Team13	Team10 vs Team17	Team5 vs Team12
18	week 17	Team11 vs Team19	Team6 vs Team14	Team1 vs Team7	Team5 vs Team16	Team10 vs Team20	Team8 vs Team17	Team2 vs Team4	Team15 vs Team18	Team12 vs Team13	Team3 vs Team9
19	week 18	Team15 vs Team17	Team6 vs Team8	Team2 vs Team19	Team5 vs Team18	Team4 vs Team7	Team13 vs Team14	Team11 vs Team12	Team16 vs Team20	Team9 vs Team10	Team1 vs Team3
20	week 19	Team16 vs Team17	Team2 vs Team5	Team1 vs Team19	Team8 vs Team18	Team10 vs Team15	Team4 vs Team6	Team3 vs Team14	Team9 vs Team12	Team11 vs Team13	Team7 vs Team20
21	week 20	Team6 vs Team9	Team12 vs Team19	Team2 vs Team8	Team14 vs Team16	Team5 vs Team20	Team3 vs Team13	Team10 vs Team15	Team1 vs Team18	Team7 vs Team11	Team4 vs Team17
22	week 21	Team10 vs Team12	Team5 vs Team15	Team7 vs Team20	Team9 vs Team19	Team3 vs Team4	Team8 vs Team11	Team1 vs Team13	Team2 vs Team17	Team14 vs Team16	Team6 vs Team18
23	week 22	Team8 vs Team17	Team1 vs Team11	Team3 vs Team14	Team12 vs Team20	Team4 vs Team18	Team7 vs Team16	Team13 vs Team19	Team6 vs Team10	Team2 vs Team5	Team9 vs Team15
24	week 23	Team6 vs Team12	Team8 vs Team13	Team2 vs Team4	Team3 vs Team5	Team11 vs Team18	Team14 vs Team15	Team1 vs Team16	Team9 vs Team20	Team10 vs Team19	Team7 vs Team17
25	week 24	Team1 vs Team13	Team5 vs Team10	Team3 vs Team8	Team12 vs Team14	Team11 vs Team20	Team6 vs Team19	Team7 vs Team18	Team4 vs Team16	Team15 vs Team17	Team2 vs Team9
26	week 25	Team3 vs Team13	Team4 vs Team19	Team9 vs Team10	Team5 vs Team6	Team7 vs Team15	Team8 vs Team20	Team2 vs Team18	Team1 vs Team17	Team11 vs Team14	Team12 vs Team16
27	week 26	Team1 vs Team18	Team6 vs Team20	Team12 vs Team15	Team11 vs Team14	Team9 vs Team17	Team5 vs Team10	Team4 vs Team13	Team2 vs Team19	Team3 vs Team7	Team8 vs Team16
28	week 27	Team8 vs Team16	Team10 vs Team14	Team11 vs Team13	Team7 vs Team9	Team15 vs Team18	Team4 vs Team19	Team3 vs Team17	Team1 vs Team5	Team6 vs Team20	Team2 vs Team12
29	week 28	Team9 vs Team11	Team3 vs Team20	Team5 vs Team17	Team6 vs Team16	Team7 vs Team14	Team2 vs Team10	Team1 vs Team8	Team13 vs Team18	Team15 vs Team19	Team4 vs Team12
30	week 29	Team3 vs Team12	Team2 vs Team17	Team1 vs Team10	Team16 vs Team19	Team6 vs Team11	Team7 vs Team14	Team4 vs Team20	Team5 vs Team13	Team8 vs Team15	Team9 vs Team18
31	week 30	Team7 vs Team13	Team1 vs Team8	Team10 vs Team18	Team6 vs Team19	Team9 vs Team14	Team4 vs Team15	Team12 vs Team20	Team3 vs Team16	Team2 vs Team11	Team5 vs Team17
32	week 31	Team8 vs Team11	Team1 vs Team15	Team7 vs Team16	Team2 vs Team12	Team5 vs Team13	Team4 vs Team10	Team9 vs Team17	Team19 vs Team20	Team14 vs Team18	Team3 vs Team6
33	week 32	Team16 vs Team20	Team18 vs Team19	Team8 vs Team12	Team4 vs Team13	Team7 vs Team17	Team1 vs Team10	Team3 vs Team15	Team5 vs Team11	Team6 vs Team9	Team2 vs Team14
34	week 33	Team2 vs Team9	Team10 vs Team13	Team15 vs Team19	Team14 vs Team18	Team3 vs Team17	Team8 vs Team12	Team11 vs Team20	Team4 vs Team5	Team6 vs Team16	Team1 vs Team7
35	week 34	Team1 vs Team2	Team10 vs Team11	Team17 vs Team19	Team4 vs Team8	Team14 vs Team20	Team3 vs Team18	Team13 vs Team16	Team12 vs Team15	Team6 vs Team7	Team5 vs Team9
36	week 35	Team8 vs Team14	Team2 vs Team18	Team3 vs Team15	Team11 vs Team16	Team10 vs Team17	Team9 vs Team19	Team13 vs Team20	Team6 vs Team12	Team1 vs Team4	Team5 vs Team7
37	week 36	Team7 vs Team11	Team19 vs Team20	Team6 vs Team10	Team2 vs Team16	Team9 vs Team15	Team5 vs Team18	Team13 vs Team17	Team4 vs Team14	Team3 vs Team8	Team1 vs Team12
38	week 37	Team1 vs Team6	Team4 vs Team11	Team18 vs Team20	Team3 vs Team9	Team13 vs Team17	Team12 vs Team19	Team2 vs Team8	Team5 vs Team16	Team7 vs Team15	Team10 vs Team14
39	week 38	Team4 vs Team16	Team12 vs Team17	Team5 vs Team11	Team3 vs Team18	Team7 vs Team19	Team14 vs Team20	Team6 vs Team15	Team1 vs Team9	Team8 vs Team10	Team2 vs Team13
40	trash
Blad1

 

[bsteinerjr]

ra.xlsm
a first trial, your 38 rounds without alternating Front-Back each round.
How far was your previous solution ?
Did you have alternating Front's and Back's or didn't you have a solution at all ?

ra.xlsm
	C	D	E	F	G	H	I	J	K	L	M
1	round	Front1	Front2	Front3	Front4	Front5	Back1	Back2	Back3	Back4	Back5
2	week 1	Team7 vs Team18	Team17 vs Team20	Team1 vs Team16	Team9 vs Team12	Team2 vs Team10	Team4 vs Team8	Team5 vs Team14	Team6 vs Team11	Team3 vs Team19	Team13 vs Team15
3	week 2	Team7 vs Team10	Team8 vs Team20	Team5 vs Team14	Team4 vs Team12	Team13 vs Team19	Team17 vs Team18	Team2 vs Team6	Team3 vs Team11	Team1 vs Team15	Team9 vs Team16
4	week 3	Team6 vs Team18	Team13 vs Team16	Team8 vs Team9	Team11 vs Team12	Team4 vs Team10	Team17 vs Team19	Team2 vs Team7	Team5 vs Team15	Team3 vs Team20	Team1 vs Team14
5	week 4	Team1 vs Team12	Team8 vs Team10	Team3 vs Team11	Team5 vs Team9	Team15 vs Team16	Team14 vs Team19	Team4 vs Team18	Team7 vs Team13	Team6 vs Team17	Team2 vs Team20
6	week 5	Team2 vs Team3	Team17 vs Team18	Team11 vs Team15	Team9 vs Team13	Team1 vs Team4	Team16 vs Team19	Team5 vs Team6	Team10 vs Team20	Team7 vs Team12	Team8 vs Team14
7	week 6	Team2 vs Team7	Team6 vs Team15	Team12 vs Team13	Team14 vs Team17	Team9 vs Team16	Team1 vs Team11	Team8 vs Team19	Team3 vs Team4	Team5 vs Team20	Team10 vs Team18
8	week 7	Team16 vs Team18	Team8 vs Team19	Team4 vs Team5	Team1 vs Team14	Team6 vs Team13	Team10 vs Team11	Team7 vs Team9	Team2 vs Team15	Team17 vs Team20	Team3 vs Team12
9	week 8	Team3 vs Team10	Team8 vs Team15	Team2 vs Team6	Team7 vs Team12	Team13 vs Team14	Team11 vs Team18	Team4 vs Team9	Team16 vs Team17	Team1 vs Team20	Team5 vs Team19
10	week 9	Team9 vs Team18	Team13 vs Team20	Team5 vs Team12	Team14 vs Team19	Team11 vs Team17	Team15 vs Team16	Team1 vs Team2	Team6 vs Team8	Team3 vs Team10	Team4 vs Team7
11	week 10	Team4 vs Team6	Team5 vs Team7	Team10 vs Team19	Team1 vs Team17	Team15 vs Team20	Team9 vs Team13	Team11 vs Team16	Team2 vs Team3	Team8 vs Team18	Team12 vs Team14
12	week 11	Team6 vs Team7	Team1 vs Team3	Team2 vs Team20	Team4 vs Team9	Team5 vs Team19	Team14 vs Team17	Team10 vs Team16	Team12 vs Team18	Team8 vs Team13	Team11 vs Team15
13	week 12	Team3 vs Team7	Team14 vs Team15	Team2 vs Team13	Team6 vs Team17	Team9 vs Team20	Team10 vs Team12	Team5 vs Team8	Team1 vs Team19	Team4 vs Team11	Team16 vs Team18
14	week 13	Team4 vs Team20	Team2 vs Team14	Team10 vs Team16	Team13 vs Team15	Team12 vs Team18	Team1 vs Team6	Team8 vs Team9	Team7 vs Team19	Team11 vs Team17	Team3 vs Team5
15	week 14	Team4 vs Team15	Team3 vs Team6	Team5 vs Team8	Team1 vs Team20	Team13 vs Team18	Team11 vs Team19	Team7 vs Team10	Team2 vs Team16	Team9 vs Team14	Team12 vs Team17
16	week 15	Team1 vs Team5	Team3 vs Team19	Team2 vs Team15	Team12 vs Team16	Team4 vs Team17	Team7 vs Team8	Team9 vs Team11	Team18 vs Team20	Team10 vs Team13	Team6 vs Team14
17	week 16	Team2 vs Team11	Team7 vs Team8	Team1 vs Team9	Team4 vs Team14	Team3 vs Team16	Team18 vs Team19	Team15 vs Team20	Team6 vs Team13	Team10 vs Team17	Team5 vs Team12
18	week 17	Team11 vs Team19	Team6 vs Team14	Team1 vs Team7	Team5 vs Team16	Team10 vs Team20	Team8 vs Team17	Team2 vs Team4	Team15 vs Team18	Team12 vs Team13	Team3 vs Team9
19	week 18	Team15 vs Team17	Team6 vs Team8	Team2 vs Team19	Team5 vs Team18	Team4 vs Team7	Team13 vs Team14	Team11 vs Team12	Team16 vs Team20	Team9 vs Team10	Team1 vs Team3
20	week 19	Team16 vs Team17	Team2 vs Team5	Team1 vs Team19	Team8 vs Team18	Team10 vs Team15	Team4 vs Team6	Team3 vs Team14	Team9 vs Team12	Team11 vs Team13	Team7 vs Team20
21	week 20	Team6 vs Team9	Team12 vs Team19	Team2 vs Team8	Team14 vs Team16	Team5 vs Team20	Team3 vs Team13	Team10 vs Team15	Team1 vs Team18	Team7 vs Team11	Team4 vs Team17
22	week 21	Team10 vs Team12	Team5 vs Team15	Team7 vs Team20	Team9 vs Team19	Team3 vs Team4	Team8 vs Team11	Team1 vs Team13	Team2 vs Team17	Team14 vs Team16	Team6 vs Team18
23	week 22	Team8 vs Team17	Team1 vs Team11	Team3 vs Team14	Team12 vs Team20	Team4 vs Team18	Team7 vs Team16	Team13 vs Team19	Team6 vs Team10	Team2 vs Team5	Team9 vs Team15
24	week 23	Team6 vs Team12	Team8 vs Team13	Team2 vs Team4	Team3 vs Team5	Team11 vs Team18	Team14 vs Team15	Team1 vs Team16	Team9 vs Team20	Team10 vs Team19	Team7 vs Team17
25	week 24	Team1 vs Team13	Team5 vs Team10	Team3 vs Team8	Team12 vs Team14	Team11 vs Team20	Team6 vs Team19	Team7 vs Team18	Team4 vs Team16	Team15 vs Team17	Team2 vs Team9
26	week 25	Team3 vs Team13	Team4 vs Team19	Team9 vs Team10	Team5 vs Team6	Team7 vs Team15	Team8 vs Team20	Team2 vs Team18	Team1 vs Team17	Team11 vs Team14	Team12 vs Team16
27	week 26	Team1 vs Team18	Team6 vs Team20	Team12 vs Team15	Team11 vs Team14	Team9 vs Team17	Team5 vs Team10	Team4 vs Team13	Team2 vs Team19	Team3 vs Team7	Team8 vs Team16
28	week 27	Team8 vs Team16	Team10 vs Team14	Team11 vs Team13	Team7 vs Team9	Team15 vs Team18	Team4 vs Team19	Team3 vs Team17	Team1 vs Team5	Team6 vs Team20	Team2 vs Team12
29	week 28	Team9 vs Team11	Team3 vs Team20	Team5 vs Team17	Team6 vs Team16	Team7 vs Team14	Team2 vs Team10	Team1 vs Team8	Team13 vs Team18	Team15 vs Team19	Team4 vs Team12
30	week 29	Team3 vs Team12	Team2 vs Team17	Team1 vs Team10	Team16 vs Team19	Team6 vs Team11	Team7 vs Team14	Team4 vs Team20	Team5 vs Team13	Team8 vs Team15	Team9 vs Team18
31	week 30	Team7 vs Team13	Team1 vs Team8	Team10 vs Team18	Team6 vs Team19	Team9 vs Team14	Team4 vs Team15	Team12 vs Team20	Team3 vs Team16	Team2 vs Team11	Team5 vs Team17
32	week 31	Team8 vs Team11	Team1 vs Team15	Team7 vs Team16	Team2 vs Team12	Team5 vs Team13	Team4 vs Team10	Team9 vs Team17	Team19 vs Team20	Team14 vs Team18	Team3 vs Team6
33	week 32	Team16 vs Team20	Team18 vs Team19	Team8 vs Team12	Team4 vs Team13	Team7 vs Team17	Team1 vs Team10	Team3 vs Team15	Team5 vs Team11	Team6 vs Team9	Team2 vs Team14
34	week 33	Team2 vs Team9	Team10 vs Team13	Team15 vs Team19	Team14 vs Team18	Team3 vs Team17	Team8 vs Team12	Team11 vs Team20	Team4 vs Team5	Team6 vs Team16	Team1 vs Team7
35	week 34	Team1 vs Team2	Team10 vs Team11	Team17 vs Team19	Team4 vs Team8	Team14 vs Team20	Team3 vs Team18	Team13 vs Team16	Team12 vs Team15	Team6 vs Team7	Team5 vs Team9
36	week 35	Team8 vs Team14	Team2 vs Team18	Team3 vs Team15	Team11 vs Team16	Team10 vs Team17	Team9 vs Team19	Team13 vs Team20	Team6 vs Team12	Team1 vs Team4	Team5 vs Team7
37	week 36	Team7 vs Team11	Team19 vs Team20	Team6 vs Team10	Team2 vs Team16	Team9 vs Team15	Team5 vs Team18	Team13 vs Team17	Team4 vs Team14	Team3 vs Team8	Team1 vs Team12
38	week 37	Team1 vs Team6	Team4 vs Team11	Team18 vs Team20	Team3 vs Team9	Team13 vs Team17	Team12 vs Team19	Team2 vs Team8	Team5 vs Team16	Team7 vs Team15	Team10 vs Team14
39	week 38	Team4 vs Team16	Team12 vs Team17	Team5 vs Team11	Team3 vs Team18	Team7 vs Team19	Team14 vs Team20	Team6 vs Team15	Team1 vs Team9	Team8 vs Team10	Team2 vs Team13
40	trash
Blad1

First of all, thank you for your time working on my request!

Here are the issues I see with your trial data presented:

1. It is for 38 weeks; my time frame is limited to 19 weeks. Given this limited time frame, Team1 vs Team2 must only occur one time, and it doesn't matter if this match occurs on the front-9 or the back-9. In the provided trial data Team1 plays Team2 twice, once on the front-9 and once on the back-9.

2. I analyzed the first 19 weeks of the trial data to verify if this portion of the data would provide the results for a 19 week I am seeking. It does not for the following reasons:

A. Team1, for example, does not play Team1 and does play Team20 twice.

B. Team1, for example, plays the front-9 on two consecutive weeks on multiple occasions and at one point plays the front-9 on four consecutive weeks.

C. Team1, for example, plays the back-9 on two consecutive weeks on multiple occasions.

I have attached my current version of the schedule I have been using. This schedule does a pretty good job of accomplishing my objectives; however, I am looking for something even better.

Thanks again for your help!

 

[bsteinerjr]

I have re-attached the current version of the schedule I have been using. This version of the schedule accurately identifies the teams that play either the front-9 or the back-9 on two consecutive weeks. I would like to reduce the number of these occurrences, if possible. Please disregard the attachment from my previous posting. Thank you.

 

[BSALV]

Just to know, how many such teams do you have at this moment ? As reference for my solution ?

 

[BSALV]

i can't do better then your 40, but mine are more random distributed (+) and non all players are 10 times in the front & 10 times in the back (---).
So game over ?

ra_ZAT.xlsm
	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC
1	InFront	K
2	RL	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	tot		not okay
3	R		1		1		1	1		1		1			1			1	1		9		4
4	C	1		1		1		1		1			1		1		1	1		1	10		2
5	E	1		1		1		1	1		1		1		1			1		1	10		2
6	G	1		1		1		1		1		1		1		1		1	1		10		1
7	H	1		1		1		1		1		1		1			1				8		3
8	A	1		1		1	1		1		1		1			1			1		9		3
9	B	1		1		1		1		1		1		1		1		1	1		10		1
10	D	1		1		1		1			1		1	1		1		1			9		3
11	F	1		1		1		1		1	1		1		1	1		1	1	1	12		4
12	I	1		1		1			1		1		1		1		1		1	1	10		2
13	J	1		1		1		1		1		1		1		1	1			1	10		2
14	K		1		1		1		1		1	1		1		1		1		1	10		1
15	L		1		1		1		1			1		1		1		1		1	9		1
16	M		1		1		1		1	1		1		1		1	1			1	10		3
17	N		1		1			1		1		1		1	1		1		1		9		2
18	O		1		1		1		1		1		1		1		1		1		9		0
19	P		1		1		1			1		1	1		1		1		1		9		2
20	Q		1		1		1		1		1			1		1	1			1	9		3
21	S		1		1		1		1		1		1		1		1		1		9		0
22	T		1		1		1		1		1		1		1			1		1	9		1
23	tot	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	190		40
Tournement

Cell Formulas
Range	Formula
CC3:CC22	CC3	=SUM(--(BH3:BY3=BI3:BZ3))
CC23	CC23	=SUM(CC3:CC22)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
BH3:BY22	Expression	=BH3=BI3	text	NO