Plan Golf 4-Balls - Any spreadsheets?

[Pork]

Chaps,

My Bro is heading off for 5 days of golf with 21-23 others and has asked me to put together a schedule of 4-balls where you dont play with the same players on any of the days.

I did this for him once before on a spreadsheet and manually checked them all - surely there is a quicker way?

Do any of you have any suggestions? All help appreciated!

Thanks

[anonymous-user]

Day One
1 5 9 13 17 21
2 6 10 14 18 22
3 7 11 15 19 23
4 8 12 16 20 24

Day Two
1 2 3 4 8 12
5 17 10 22 15 16
9 21 14 7 19 20
13 6 18 11 23 24

Day Three
1 2 3 4 9 13
6 18 11 23 16 17
10 22 14 8 20 21
14 7 19 12 24 5

Day Four
1 2 3 4 10 14
7 19 12 24 17 18
11 23 15 9 20 22
15 8 20 13 5 6

Day Five
1 2 3 4 11 15
8 20 13 5 18 19
12 24 16 10 21 23
17 9 21 14 6 7

Sorry can't get the formatting to work, copy and paste it into Excel and then text to columns delimit by space.

Players 1-24 in fourballs Day One is obvious, Day two is the horizontal of day One and then Days 3, 4 & 5 are basically + 1 on the previous day except for the key 1,2,3&4 positions with 5,6 & 7 taking over from 24, 23 & 22 sequentially.

Edited by anonymous-user on Thursday 24th February 15:39

[Pork]

I'll have a look through that, thanks very much for the reply.

[anonymous-user]

Pork said:

I'll have a look through that, thanks very much for the reply.

Sorry it doesn't work, the 24,23 & 22 treatment are causing duplication, I'll have another look.

[Pork]

OneDs said:

Pork said:

I'll have a look through that, thanks very much for the reply.

Sorry it doesn't work, the 24,23 & 22 treatment are causing duplication, I'll have another look.

OK, no worries. I thought I'd cracked it last night, but alas, no.

[anonymous-user]

I had another look and kept running into issues, I think it will work across 4 days but not 5.

[Pork]

In case anyone was interested, I found this as a solution:

Grp 1 Grp 2 Grp 3 Grp 4 Grp 5 Grp 6
Day1 A B K U I J S E Q R C M D G F X H L N O P T V W
Day2 A C L V I K T F Q S D N E H G R B M O P J U W X
Day3 A D M W I L U G Q T E O F B H S C J N P K R V X
Day4 A E N X I M V H Q U F P G C B T D J K O L R S W
Day5 A F O R I N W B Q V G J H D C U E K L P M S T X
Day6 A E P S I O X C Q W H K B E D V F J L M N R T U
Day7 A H J T I P R D Q X B L C F E W G K M N O S U V