Net Skins Format

[CWallis847]

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??

ScoreCard for Printing
		1	2
Course	Handicap	17	11
Course	Par	4	4
Name	1
Name	2
Name	3
Name	4
Name	5
Name	6
Name	7
Name	8
Name	9
Name	10
Name	11		*
Name	12		*
Name	13		*
Name	14		*
Name	15		*
Name	16		*
		1	2
Gross Scores
		1	2
Course	Handicap	17	11
Course	Par	4	4
Name	1	5	5
Name	2
Name	3
Name	4
Name	5
Name	6
Name	7
Name	8
Name	9
Name	10
Name	11
Name	12
Name	13
Name	14
Name	15
Name	16
		1	2
Gross Scores
	Double E	0	0
	Eagles	0	0
	Birdies	0	0
	Pars	0	0
	Bogey	1	1
	Double Bogey	0	0
NET Scores
		1	2
Course	Handicap	17	11
Course	Par	4	4
Name	1	5	5
Name	2	0	0
Name	3	0	0
Name	4	0	0
Name	5	0	0
Name	6	0	0
Name	7	0	0
Name	8	0	0
Name	9	0	0
Name	10	0	0
Name	11	0	-1
Name	12	0	-1
Name	13	0	-1
Name	14	0	-1
Name	15	0	-1
Name	16	0	-1
		1	2
NET Scores
	Double E	0	0
	Eagles	0	0
	Birdies	0	0
	Pars	0	0
	Bogey	1	1
	Double Bogey	0	0

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

 

[Brian from Maui]

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

 

[CWallis847]

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?

 

[Brian from Maui]

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?

Yes. If you have trouble, send me a PM with your email address and I'll send you a copy workbook.