Mixing up golfing groups (excel format)
 

Guys, who can help me here? I've been heading up a golf outing for
about 12 years now, and not often (but occasionally) I get that golfer
that says,"how'd you make up these groups (in a drunken slur)?". Well,
that's the reason I am looking for some assistance. What I have this
year is six groups of four. The initial groupings I will initiate based
on..., but we will play two more rounds and I would like to maximize
mixing players up the second and third round. There may be a year or so
that I have five groups of four or four groups of four. Will the format
(program) be the same? You'd make my life easier. Are you up for the
'challenge'? Thanks in advance, GE.

Mixing up golfing groups (excel format)
 

Ok - so for the first round you just pick the groups by some arbitrary
method, right?

Then for subsequent rounds you want to simply mix up the groups, kind of
like drawing names from a hat? Personally you might be most effectively off
using a hat and an assistant: toss names in hat, shake hat vigorously, have
assistant pull them out 1 by 1 and you type new group names.

But you can do something similar in VBA using the RND() [random] function to
do it for you. If written properly, it would be a generic type routine
requiring only the list of names to work with and the number of people to put
into each group. It would be up to you to make sure that number of people in
a group * number of groups = total people available.

With a little effort you could even check that no group consisted of the
same bunch of people as any group in the previous round(s) - but that kind of
takes the randomness out of it, doesn't it unless you want to guarantee that
no group in any round is made up of the same people.

"GeorgiaEddie" wrote:

Guys, who can help me here? I've been heading up a golf outing for
about 12 years now, and not often (but occasionally) I get that golfer
that says,"how'd you make up these groups (in a drunken slur)?". Well,
that's the reason I am looking for some assistance. What I have this
year is six groups of four. The initial groupings I will initiate based
on..., but we will play two more rounds and I would like to maximize
mixing players up the second and third round. There may be a year or so
that I have five groups of four or four groups of four. Will the format
(program) be the same? You'd make my life easier. Are you up for the
'challenge'? Thanks in advance, GE.

Mixing up golfing groups (excel format)
 

Hi,

You can use the Solver tool to solve this type of problem. First you need
to attach the add-in under Tools, Add-ins. To learn how to use the tool
Microsoft Excel includes a workbook, Solvsamp.xls in the Office\Samples
folder.

This is probably more than you wanted but...
--
Cheers,
Shane Devenshire


"GeorgiaEddie" wrote:

Guys, who can help me here? I've been heading up a golf outing for
about 12 years now, and not often (but occasionally) I get that golfer
that says,"how'd you make up these groups (in a drunken slur)?". Well,
that's the reason I am looking for some assistance. What I have this
year is six groups of four. The initial groupings I will initiate based
on..., but we will play two more rounds and I would like to maximize
mixing players up the second and third round. There may be a year or so
that I have five groups of four or four groups of four. Will the format
(program) be the same? You'd make my life easier. Are you up for the
'challenge'? Thanks in advance, GE.