Net Skins Format

CWallis847

New Member
Joined
Jun 16, 2015
Messages
2
Hello, Thank you in advance for all your time and effort. I appreciate the help.
I run a small 60 person golf league, it is a 9 hole league and recently we have started doing GROSS (without Handicaps) and NET (with Handicaps) skins game.
I figured out how to calculate the NET portion of the game upto 18 strokes, but we have a few players that are higher, which means there should be two strokes deducted from their GROSS score on some holes. Any clue on how to do that??

[TABLE="width: 267"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 3"]ScoreCard for Printing[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Course[/TD]
[TD]Handicap[/TD]
[TD]17[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]Course[/TD]
[TD]Par[/TD]
[TD]4[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]8[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]9[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]10[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]11[/TD]
[TD] [/TD]
[TD]*[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]12[/TD]
[TD] [/TD]
[TD]*[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]13[/TD]
[TD] [/TD]
[TD]*[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]14[/TD]
[TD] [/TD]
[TD]*[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]15[/TD]
[TD] [/TD]
[TD]*[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]16[/TD]
[TD] [/TD]
[TD]*[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="colspan: 2"]Gross Scores[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Course[/TD]
[TD]Handicap[/TD]
[TD]17[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]Course[/TD]
[TD]Par[/TD]
[TD]4[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]8[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]9[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]10[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]11[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]12[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]13[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]14[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]15[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]16[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Gross Scores[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Double E[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Eagles[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Birdies[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Pars[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Bogey[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Double Bogey[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]NET Scores[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Course[/TD]
[TD]Handicap[/TD]
[TD]17[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]Course[/TD]
[TD]Par[/TD]
[TD]4[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]6[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]7[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]8[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]9[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]10[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]11[/TD]
[TD]0[/TD]
[TD]-1[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]12[/TD]
[TD]0[/TD]
[TD]-1[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]13[/TD]
[TD]0[/TD]
[TD]-1[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]14[/TD]
[TD]0[/TD]
[TD]-1[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]15[/TD]
[TD]0[/TD]
[TD]-1[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]16[/TD]
[TD]0[/TD]
[TD]-1[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]NET Scores[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Double E[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Eagles[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Birdies[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Pars[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Bogey[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Double Bogey[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
 
My sheet is setup as

Handicap for holes: B5:J5 holes 1-9, L5:T5 holes 10-18

Gross scores entered in sheet Scores!B10:J10, 1-9 and Scores!L10:T10, for holes 10-18

Enter in the Net!B10,

=IF(AND($W10 > 18,$W10-18 >= B$5),Score!B10-2,IF(AND($W10 > 18,$W10-18 < B$5),Score!B10-1,IF(AND($W10 < 0,$W10+18 < B$5),Score!B10+1,IF(B$5 <= $W10,Score!B10-1,Score!B10))))

Where W10 houses handicap
 
Upvote 0
Thank you very much. i will try that when i get a chance. If a player gets 2 strokes on a hole does your method work?
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top