Randomly pair numbers in excel for Golf tournament- help needed!

breffnij

Hi all,

I'm looking for some help regarding a golf draw my Dad is trying to make and need some excel coding for it to work. I'm useless albeit not incompetent on excel.

Basically there are 20 players going out in groups of four (fourballs). What I am trying to do is to assign each player with three new players for each of the 5 days of the holiday.

Players have been broken down into two groupss based on their handicap. Group A = players 1-10 and Group B = players 11-20.

Each day a player from Group A needs to be paired with a Player from Group B to player another random combination (another group of one from A and .

Is this sort of coding possible? I've read threads about similar stuff being done but just unsure how to do it. Any help would be greatly appreciated as I've wasted 3 hours on this already!!!!!!

smokiebeverage

You could do it in excel but to be honest you would be quicker by hand, the number of variables is fairly small

breffnij

Thanks for reply smokiebeverage.

The thing is the numbers may grow (4 are waiting on confirmation) so at least if I have a code or quick way on excel then I can change it at the drop of a hat. Is it really that complicated to do on excel? Doing it out by hand is more complicated than you think....at least for my Peter Griffin sized brain....:D

smokiebeverage

Breffnij,

Now excuse me if I get it wrong but my brain is frazzled after a long week but I think it may work like this

Split the handicap groups into two groups and rotate the groups by 1 for the first group, 2 for the second group and 3 for the third group, like below (I know thats a terrible description!! Sorry)

DAY 1
A1 A2 B1 B2
A3 A4 B3 B4
A5 A6 B5 B6
A7 A8 B7 B8
A9 A10 B9 B10

DAY 2
A1 A4 B5 B8
A3 A6 B7 B10
A5 A8 B9 B2
A7 A10 B1 B4
A9 A2 B3 B6

DAY 3
A1 A6 B9 B4
A3 A8 B1 B6
A5 A10 B3 B8
A7 A2 B5 B10
A9 A4 B7 B2

DAY 4
A1 A8 B3 B10
A3 A10 B5 B2
A5 A2 B7 B4
A7 A4 B9 B6
A9 A6 B1 B8

DAY 5
A1 A10 B7 B6
A3 A2 B9 B8
A5 A4 B1 B10
A7 A6 B3 B2
A9 A8 B5 B4

You'll need to check my logic as I really am knackered, this is easily expanded for more players. I'm not great at excel, and the brain isn't up to it on a Friday night, but I hope this helps.

breffnij

Smokiebeverage,

What a legend.....that looks good at first glance and more than enough for what they'll need. Wish I'd a mind like that!! You've earned your few cold ones tomorrow.

Thanks alot!

smokiebeverage

I'd have to really look at it to check. Excel should be easy now that I think about it, if you really need it give me a shout and I'll have a crack at it

Capt'n Midnight

you could do out the tables of A v.s B

and on the day use dice or name in a hat to decide which number to assign to each player



The rule of not re-using combinations on subsequent days means it's difficult to do in a spreadsheet without some programming (if you want total randomness) and you won't be saving any time unless the problem is very complex.