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
