Golf Tournament - 12 players, 6 players on Team A & 6 players on Team B.

[BC22]

Golf Tournament - 12 players, 6 players on Team A & 6 players on Team B. 3 groups of 4 play each day. 7 days in total. Each group should have 2 players from Team A v 2 players from team B. Can anyone provide formula that will generate the fixtures for the 7 days which ensures teammates do not play each other more than twice and opponents are not matched more than 3 times?

 

[Graymalkin]

There is no way I can think of that you could use cell formulas to solve this problem, it's just too complicated. The optimization software that I have used to create the schedule below, could potentially be re-written in VBA, but I guess it is unlikely I will get around to that.

 (A2 A3 v B3 B6) (A5 A1 v B2 B5) (A4 A6 v B1 B4)
 (A1 A4 v B6 B5) (A3 A5 v B1 B4) (A6 A2 v B3 B2)
 (A3 A1 v B4 B3) (A2 A6 v B5 B1) (A5 A4 v B2 B6)
 (A5 A6 v B1 B6) (A4 A3 v B2 B3) (A2 A1 v B4 B5)
 (A2 A5 v B2 B4) (A6 A1 v B6 B3) (A3 A4 v B5 B1)
 (A5 A4 v B3 B5) (A1 A2 v B1 B2) (A3 A6 v B4 B6)
 (A3 A6 v B5 B2) (A2 A4 v B4 B6) (A5 A1 v B3 B1)

I believe the schedule meets your requirements for partners and opponents, and it is reasonably well balanced for the three columns (tee-off times).