Was going to see if you guys could help me with something.
I have a spreadsheet that I use to make teams for my weekly golf game. I enter each player and their handicap, and it determines:
1) optimal number of groups based upon number of players
2) number of players in each group
and then it basically assigns teams by using a "snake draft" type formula. For example, if I have 9 players:
Team 1
Lowest handicap player
6th lowest handicap player
7th lowest handicap player
Team 2
2nd lowest handicap player
5th lowest handicap player
8th lowest handicap player
Team 3
3rd lowest handicap player
4th lowest handicap player
9th lowest handicap player
The problem is, that doesn't always add up to the optimal teams (which would be that if we added up the sum of each team's handicaps, they would all be as close to equal as possible). We often have 5+ groups, and I wanted to have a system that allowed nobody to argue about the teams.
Is it possible to have Excel solve for what combination of players on each team results in the most-equal groups?
Bookmarks