Golf Match Play Calculations

[PDXGolfGuy]

Hey All, I am in some desperate need of help for a Ryder Cup (Match play) style golf tournament. We are doing a combination Ryder Cup team format over the course of 3 days, 8 players, teams of 2, as well as have an individual component to scoring our Net for a cash prize at the end. I have figured out basic calculations for the individual net scores sheet.

First Goal:
Goal is to have a player enter their score for a hole, take into account there handicap and if it should be applied (example, I am 18 HDCP therefore I get a stroke subtracted from my entered score each hole, whereas one of my players is a 2 HDCP and based on the course only gets 2 strokes subtracted on holes 6 and 12) and therefore give a score for them.

Second Goal:
Teams are put together during the 3 day tournament (teams 1 and 2, since it's 2 foursomes of golf its 2v2 or team 1A vs team 2A and team 1B vs team 2B. That said I would like to take into account individual scores from above and then based on teams compare which individual had lowest score per hole (i.e. {Player 1 team 1A scores 4, Player 2 team 1A scores a 3; Player 3 team 2A scores 4, Player 4 team 2A scores 5, therefore since player 2 team 1A scored a 3 their score would 'Win' their team the hole. If the hole is tied I would like a notation of either Halved or tied.

I have a added a link of the sheet 'Team Scores' https://drive.google.com/open?id=0B0Af3Tf2bzsLNWk1N2JaZWJiOEE and the look I am going for...and I am open to any suggestions, feedback, etc....

Thank you,
Excel Newb

 

[AhoyNC]

You could use something like this for your first goal of calculating handicap.

You would enter data in yellow cells.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1	Course
2	Hole		1	2	3	4	5	6	7	8	9	Out	10	11	12	13	14	15	16	17	18	In	Total
3	Hcp.		3	13	17	5	11	9	15	1	7		10	12	16	14	2	8	6	18	4
4	Par		4	4	3	5	4	4	3	5	4	36	4	4	3	4	5	4	4	3	4	35	71
5	Name	Hndcp
6	Golfer2	5	1	0	0	1	0	0	0	1	0		0	0	0	0	1	0	0	0	1
7		Score	4	5	3	4	4	4	2	5	5	36	5	4	3	4	6	4	3	3	4	36	72
8		Net	3	5	3	3	4	4	2	4	5	33	5	4	3	4	5	4	3	3	3	34	67
9
10	Golfer3	18	1	1	1	1	1	1	1	1	1		1	1	1	1	1	1	1	1	1
11		Score	5	4	4	6	6	5	3	7	5	45	5	4	4	6	7	4	4	4	5	43	88
12		Net	4	3	3	5	5	4	2	6	4	36	4	3	3	5	6	3	3	3	4	34	70
13
14	Golfer4	24	2	1	1	2	1	1	1	2	1		1	1	1	1	2	1	2	1	2
15		Score	5	4	5	7	5	6	4	8	5	49	6	5	4	4	7	6	5	3	6	46	95
16		Net	3	3	4	5	4	5	3	6	4	37	5	4	3	3	5	5	3	2	4	34	71
Sheet1

Cell Formulas
Range	Formula
L4,V15:V16,L15:L16,V11:V12,L11:L12,V7:V8,L7:L8,V4	L4	=SUM(C4:K4)
W4,W15:W16,W11:W12,W7:W8	W4	=L4+V4
C6:K6,M14:U14,C14:K14,M10:U10,C10:K10,M6:U6	C6	=INT($B6/18)+IF(C$3<=MOD($B6,18),1,0)
C8:K8,M8:U8,C16:K16,M16:U16,C12:K12,M12:U12	C8	=C7-C6