Golf Prize Distribution

At first glance this may seem to be out of my normal range of spreadsheets, most of which are financial based. Anyone that has worked at a credit union or bank, however, knows that there are at least three or more times a year that an association or client will hold a golf tournament. Anyway, this is an Excel spreadsheet that computes the winners of a tournament and their prize money. The default data shows 61 golfers playing for a total prize amount of $3,000. There are 10 potential winners ranging from $1,000 for the first-place score to $40 for the last winning score.

The problem, of course is that most likely there will be ties at one or more of the winning scores. For example, the default scores show three players tied for first place with scores of 70. Each of the three players cannot receive $1,000, or the rest of the winners will receive nothing. So, the first three winners will take the total of the first three prizes of $1,000, $700, and $400 and divide the $2,100 by three for a split of $700 each. Likewise, the second-best score of 71 had two winners. They would get the 4th and 5th prizes of $300, and $175, for a total of $237.50 each. Due to the splitting, there was 11 winners and only 10 prizes.

Your can see where in a tournament of say 25 prizes, this could be more challenging. The trickiest part was calculating the winner’s names separated with commas. I used the FILTER function which I think is still only available on Office 365 Excel. I also used the SEQUENCE function, only available on Office 365.

This formula is for private use only and is not endorsed by the PGA or any other golf association.

 

Download  Excel File: Golf

 

 

 

Don Pistulka
Don Pistulka

Retired Credit Union CFO - Finance
Background: over 40 years in investments, asset/Liability management, banking, securities trader.
Worked for: California Credit Union, WesCorp, CalFed S&L, Crocker Bank, Carroll McEntee, Federal Home Loan Bank Board (D.C.), Western Asset Management, Security Pacific National Bank.

Leave a Reply

Your email address will not be published. Required fields are marked *