3rd Annual Wanna-Par-Maker Tournament.xlsm

	A	B	C	D	E	F	G	H	I	J	K	L
1		Wanna-Par-Maker 2023
2	Golfer	Course 1 Total	Course 2 Total	Course 3 Total	Course 4 Total	Stroke Total	Winning Percentage	HC Win Percentage
3	Ty	38	36	33	35	142	100%	-16%
4	Stack	38	36	33	37	144	98%	-13%			35
5	Abby	33	36	37	39	145	97%	-9%
6	Norm	35	40	32	39	146	96%	-8%
7	Tasha	34	38	41	35	148	94%	-11%
8	Zach V	33	37	37	41	148	94%	-5%
9	Devry	40	37	32	42	151	91%	-2%
10	Jake	38	33	40	43	154	88%	1%
11	Richard	38	37	31	48	154	88%	6%
12	Landon	37	39	36	44	156	86%	3%
13	Tanner	35	37	45	40	157	85%	0%
14	Alex	40	37	34	49	160	82%	11%
15	Riley	38	42	41	41	162	80%	4%
16	Juan	42	39	40	43	164	78%	7%
17	Klenker	48	35	40	41	164	78%	5%
18	Amy	45	31	41	48	165	77%	12%
19	Dean	40	38	37	54	169	73%	20%
20	Randy	40	36	42	52	170	72%	19%
21	Travis V	48	42	42	45	177	65%	16%
22	Chase	37	55	47	42	181	61%	15%
23
24		Tie Breaker 1	Lowest score on Forest Dale #8
25		Tie Breaker 2	Lowest score on Nibs #9
26		Tie Breaker 3	Lowest score on Glenmoore #17		Stop looking at this tasha
27		Tie Breaker 4	Lowest score on Glenmoore #9		don't tell me what to do jake
28		Tie Breaker 5	Lowest score on Nibs #3		i will do what i want
29
30	Rule 1:	If a ball is lost off the Tee, re-hit from Tee on shot 3.
31	Rule 2:	If a ball is lost after a shot, drop it at the spot it's lost and hit your next shot with additional stroke added. EG: Zach hits his 2nd shot into water, drop at spot it went to the fish and hit shot 4.
32	Rule 3:	All balls must be hit off grass. If ball comes to rest on dirt, drop within 2 clubs length on grass no closer to the hole.
33	Rule 4:	Tournament Leader for the day must putt with the SPM putter.
34	Rule 5:	All courses must be played from blue tee.
35	Rule 6:	Ice'd Lowest Score on every Par 3.
36	Rule 7:	Max Score of 10 on individual hole
37	Rule 8:	All Chance money must be agreed to before start of Friday round. Actual strokes only count for Chance.
38
39	Long Drive Trophy		Devry 310
40	Longest Putt Trophy		Abby 33						#REF!
41	Swag Bag Giveaways
42									HC Perc	HC	Lowest Score
43						1 / (1+B(1-A)(1-H)/A/H/(1-B))		Norm	114.50%	0.3	0.144	98.66%
44						A=golfer score		Randy	95.42%	0.25	0.144	96.74%
45						B=lowest score		Alex	125.95%	0.33	0.144	97.61%
46						H=Handicap		Zach	0.00%		0.144	200.00%
47								Brian	0.00%		0.144	200.00%
48								Jake	95.42%	0.25	0.144	98.09%
49								Tasha	95.42%	0.25	0.144	98.52%
50								Dean	95.42%	0.25	0.144	96.84%
51								Ty	0.00%		0.144	200.00%
52								Tanner	57.25%	0.15	0.144	97.85%
53								Short Stack	0.00%		0.144	200.00%
54								Flip	0.00%		0.144	200.00%
55								Stack	68.70%	0.18	0.144	98.79%
56								Chase	125.95%	0.33	0.144	95.69%
57								Howard	0.00%		0.144	200.00%
58								Richard	125.95%	0.33	0.144	98.09%
59								Abby	26.72%	0.07	0.144	98.72%
60
61	Golfer	Course 1 Total	Course 2 Total	Course 4 Total	Total	Handicap	Winning Percentage	Course 3 Total	Par Pecentage	Shots Above Win
62	Norm	35	40	39	146	30	96%	32	97.26%	4
63	Devry	40	37	42	151	25	91%	32	94.04%	9
64	Klenker	48	35	41	164	15	78%	40	86.59%	22
65	Zach V	33	37	41	148	33	94%	37	95.95%	6
66	Chase	37	55	42	181	33	61%	47	78.45%	39
67	Jake	38	33	43	154	25	88%	40	92.21%	12
68	Tasha	34	38	35	148	25	94%	41	95.95%	6
69	Dean	40	38	54	169	25	73%	37	84.02%	27
70	Abby	33	36	39	145	7	97%	37	97.93%	3
71	Tanner	35	37	40	157	15	85%	45	90.45%	15
72	Travis V	48	42	45	177	18	65%	42	80.23%	35
73	Randy	40	36	52	170	25	72%	42	83.53%	28
74	Stack	38	36	37	144	18	98%	33	98.61%	2
75	Alex	40	37	49	160	33	82%	34	88.75%	18
76	Juan	42	39	43	164	30	78%	40	86.59%	22
77	Richard	38	37	48	154	33	88%	31	92.21%	12
78	Landon	37	39	44	156	10	86%	36	91.03%	14
79	Riley	38	42	41	162	15	80%	41	87.65%	20
80	Ty	38	36	35	142	22	100%	33	100.00%	0
81	Amy	45	31	48	165	35	77%	41	86.06%	23
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100