6 golfers, threesomes, 3 rounds of golf

[breaking80]

Hey everyone. I havent been able to figure this out.  I want to do a random draw, but have the spreadsheet set up in advance.
Can someone help with my scenario, so we play with each other at least once and not more than twice with one person? If that is possible.
Thank you.
John

[Ian Wakeling]

The 'at least once' property that you are looking for is not mathematically possible.  The best that can be done is to have three pairs of players who do not play together, while other pairs meet once or twice.   In the schedule below the former are (1 6), (2 4) & (3 5).

(3 4 1) (5 6 2)
(1 2 5) (4 3 6)
(6 5 4) (2 1 3)

[breaking80]

Thank you-i was afraid of that, but appreciate the verification.