anyone have an Excel worksheet for calculating net skins that they want to share?

[djt]

Hey everyone, I just became the handicap chairperson for my informal golf club.  In the past, we have calculated skins the old fashioned way, with paper and pencil after the round, then skimming the net scores for each hole to see if there was a tie or if there was a winner for the hole.  We determine the number of overall skins won, and figure out the payout per skin based on the overall skins pot.

 

Wanted to see if anyone had an excel worksheet or a google sheet that was already built out for calculating skins winners and perhaps a way to calculate using a percentage of handicap for the skins game, and highlighting the low net score for a particular hole (no highlighting if there is a tie).

 

Thanks in advance and hope 2024 brings you all a bunch of fairways and greens!

[hollabachgt]

Here you go:

 

Skins Game Calculator

Use the blue cells to enter in your course and player information, including gross scores for each hole, and the sheet will calculate the rest.

[djt]

thanks, hollabachgt!  super appreciate you sharing your worksheet!

[Dwools1989]

On 1/31/2024 at 12:56 PM, hollabachgt said:

Here you go:

 

Skins Game Calculator

Use the blue cells to enter in your course and player information, including gross scores for each hole, and the sheet will calculate the rest.

Thank you for sharing your. Do you know of a way to add a .5 value to the gross score? Or so that if a handicapped player ties a player not getting strokes, the tie will go to the player not getting a stroke? 

 

I have attached a copy of the sheet that I downloaded. 

 

https://docs.google.com/spreadsheets/d/16o3YoaOusGj9sRbtKG_7Mu_4JbwhkG6UKYPPVRRKYCA/edit?usp=sharing

[hollabachgt]

10 hours ago, Dwools1989 said:

Thank you for sharing your. Do you know of a way to add a .5 value to the gross score? Or so that if a handicapped player ties a player not getting strokes, the tie will go to the player not getting a stroke? 

 

I have attached a copy of the sheet that I downloaded. 

 

https://docs.google.com/spreadsheets/d/16o3YoaOusGj9sRbtKG_7Mu_4JbwhkG6UKYPPVRRKYCA/edit?usp=sharing

You could use a IF formula with a second half scoring column for every hole.

 

IF player A net score equal player B net score , compare player A gross score against player B gross score in the second column. 

[union865]

   I cannot thank you enough for having the knowledge to make up this skins calculator and for sharing it with everyone. It is exactly what I was looking for. I couldn't figure out how to do it and this works perfectly for taking out the 'Human Factor' when looking for skins for 32 golfers. Again thank you for sharing this.

[union865]

Is there anyway to use this calculator when a golfer has a handicap of more then 18??? It works perfectly for 18 and under, but does not work for a handicap higher than 18. Any ideas???