Sorry to disappoint, Ed! I guess I'm not a smart guy, because I don't
understand the question. Actually, I don't think I know what a fair
foursome is. For instance, first I would want to know:
(1) Does a club win, or does an individual win?
(2) What game is being played? Individual stroke play? Four ball
better ball? Something else?
(3) Does the game include handicap, or is it gross? Either way, are
the handicaps known and trusted?
(4) Could you give some examples of an UNFAIR foursome, so I know
what the metric of fairness is?
Basically I'm saying that you are asking for a precise, algorithmic
solution to a problem that is far from precisely stated. ("Fair" is
hardly a precise measurement.)
Thanks,
DaveT
At 04:42 PM 8/6/2007, Ed Reeder wrote:
I'm hoping that one of you smart guys can help me out.
From time to time I participate in tournaments with other clubs and we
create foursomes which usually consist of two players from one club and
two players from the other club. At times the number of players on each
side may be different, so instead of 2 from each side, it could be 3 and
1, or even 4 and 0.
Right now we do this by hand, with no real guidance on how to fairly
allocate the players.
I'd like to have a way to automatically and fairly create foursomes.
Though we typically have only two clubs to draw from, I could see that
three or four could be a possibility.
I've got a few questions:
1. Is there a formula for fairly creating the foursomes?
2. Is there a way to automate this in Excel, with the ability to draw
players from 1 to 4 "pools" of players?
3. Is there a cheap software package that does this?
Thx,
/Ed
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: 8/5/2007 4:16 PM