20 golfers over 3 days playing in foursomes

golfnut111

New Member
Joined
Apr 4, 2019
Messages
7
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?
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
I think I have an idea that may work for you. Go back to the "Common Social Golfer Problem" thread. Their is another link at the bottom of that thread. The other link takes you to a free tool that I think will do this for you very well - but there is a twist. Instead of putting in 4 as the number of golfers per team, use 2 golfers, and use 10 golfers instead of 20. Then you generate an A golfer schedule and a B golfer schedule, and then just put them together.
 
Last edited by a moderator:
Upvote 0
@golfnut1
The link provided does allow for 20 golfers over 3 events !
Simply click on the pairings generator button and it will take you to the build schedule where you can set it up for your field.
 
Upvote 0
I'm still having problems solving this. The problem is I have 10 better players in one group or the "A" players and 10 worse players in another group or "B" players. I want 2 A and 2 B players in each foursome, but I don't want anyone to play with the same players twice over the 3 days. Maybe there isn't a simple way to do this and I have to just fumble with the different names until I get something that works. Thanks for all you help though. I really appreciate it.
 
Upvote 0
golfnut11,
See if this layout is any help...


Excel 2007 32 bit
A
B
C
D
E
F
G
H
I
J
1
Tee 1Tee 2Tee 3Tee 4Tee 5
2
Day 12A 4A 2B 4B1A 5A 1B 5B7A 8A 7B 8B3A 10A 3B 10B6A 9A 6B 9B
3
4
Day 22A 4A 7B 8B3A 10A 2B 4B 1A 5A 3B 10B6A 9A 1B 5B 7A 8A 6B 9B
5
6
Day 32A 4A 6B 9B1A 5A 7B 8B3A 10A 1B 5B 6A 9A 2B 4B7A 8A 3B 10B
7
8
9
10
20 Golfers - 4somes - 3 Days
11
A' Flight'B' Flight
12
1AAlan1BPeter
13
2AGeorge2BFrank
14
3AJim3BJeff
15
4APat4BSam
16
5ADave5BConrad
17
6ARay6BTerry
18
7AMiles7BBob
19
8ALarry8BTed
20
9ADuncan9BJerry
21
10AMurphy10BZiggy
Sheet: Sheet2




I used the golf program in the last post of the "Common Social Golfer Problem" thread mentioned previously.
I had 10 'A' players (1A, 2A, and etc) and 10 'B' players (2A, 2B, and etc.) in the following format.
Then I used the code below to replace the corresponding name for each player in each 4 some.
I hope this is helpful.
Perpa


Code:
Sub AddPlayerNames()
Dim myString1, myString2 As String
Dim rw As Long


For rw = 12 To 21
      
    myString1 = Cells(rw, "A")
    myString2 = Cells(rw, "B")
    Range("B2:J6").Replace What:=myString1, Replacement:=myString2, LookAt:=xlPart, _
            SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
            ReplaceFormat:=False
Next


For rw = 12 To 21
      
    myString1 = Cells(rw, "E")
    myString2 = Cells(rw, "F")
    Range("B2:J6").Replace What:=myString1, Replacement:=myString2, LookAt:=xlPart, _
            SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
            ReplaceFormat:=False
Next
End Sub
 
Last edited:
Upvote 0
If I'm reading this correctly, 2A & 4A are playing together all 3 days. What I want is to each player to have 9 different partners over the 3 days. He wouldn't see the same partner over the 3 days. I keep trying, but I'm thinking there might not be a solution.
 
Upvote 0
golfnut111,
This is about as close as I was able to get...the last 2 foursomes (in red font) have played other players more than once, but 13 out of 15 foursomes seem well mixed...
Perpa

Excel 2007 32 bit
L
M
N
O
P
Q
53
Tee1 Tee2 Tee 3 Tee 4 Tee 5
54
Day 11A 2A 1B 2B3A 4A 3B 4B5A 6A 5B 6B7A 8A 7B 8B9A 10A 9B 10B
55
Day 210A 1A 4B 8B2A 9A 3B 6B4A 8A 5B 7B3A 6A 10B 1B5A7A 2B 9B
56
Day 31A 9A 3B 7B6A 8A 2B 4B 2A 4A 5B 10B5A 10A 6B 8B 3A 7A 1B 9B
Sheet: Sheet1
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,954
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top