Net Skins Format

C

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]
 
Sort by date Sort by votes
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
You must log in or register to reply here.

Similar threads

G
  • Solved
Golf Score If Blank or Zero
Replies
9
Views
253
KevCarter
KevCarter
R
  • Locked
  • Question Question
Revised Golf scoring
Replies
1
Views
363
Fluff
Fluff
VinceF
  • Solved
Play .wav File When Cell Contents Change
Replies
4
Views
91
VinceF
VinceF
G
  • Solved
Adjust Golf league Skins Conditional formatting
2
Replies
11
Views
641
Fluff
Fluff
P
  • Question Question
Hoping to get help with a Macro!
Replies
0
Views
327
PEM000
P

Share this page

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