20 golfers over 3 days playing in foursomes

[golfnut111]

I'm trying to create a spreadsheet where I can 20 golfers playing over 3 days and none of the golfers play with each other twice. On each team will be two "A" players and two "B" players. I've figured out how to make the 1st day random but I can't figure out out to make days 2 & 3 where the players don't play with each other again. Please help! I've been trying for half a day to figure this out. Is there a program to do this?

 

[Michael M]

@golfnut1
Did you retry the pairing generator ??
It worked for me with 20 players over 3 days !!

http://golfsoftware.com/tools/schedu...generator.html

 

[golfnut111]

Thank you so much for all your help Perpa. It is really appreciated.

 

[Perpa]

Thank you so much for all your help Perpa. It is really appreciated.

golfnut111,
I appreciate the feedback and you are very welcome. I have golfed is several similar groups, but was never active in the set up of the foursomes. This has been a good 'learning experience'.
Thanks to Stephan Crump and Michael M for their assistance with the pairings generator.
Perpa

 

[Graymalkin]

This is probably two months after your event, but you can have 5 rounds of foursomes and still have all partners different.

Foursome 1

Foursome 2

Foursome 3

Foursome 4

Foursome 5

R1

A1

A6

B1

B6

A5

A10

B5

B10

A4

A9

B4

B9

A3

A8

B3

B8

A2

A7

B2

B7

R2

A5

A9

B3

B7

A4

A8

B2

B6

A3

A7

B1

B10

A2

A6

B5

B9

A1

A10

B4

B8

R3

A4

A7

B5

B8

A3

A6

B4

B7

A2

A10

B3

B6

A1

A9

B2

B10

A5

A8

B1

B9

R4

A3

A10

B2

B9

A2

A9

B1

B8

A1

A8

B5

B7

A5

A7

B4

B6

A4

A6

B3

B10

R5

A2

A8

B4

B10

A1

A7

B3

B9

A5

A6

B2

B8

A4

A10

B1

B7

A3

A9

B5

B6

<colgroup><col><col span="24"></colgroup><tbody>
</tbody>

This would also allow you to have 4 ability groups, since each foursome has 1 player each from the groups A1-A5, A6-A10, B1-B5 & B6-B10.

GM