Quota/Dogfight/Chicago Golf Spreadsheet

[Jonezy47]

Good Afternoon,

I am trying my best to create a golf spreadsheet for a league. I am curious if anyone has a current golf league spreadsheet that contains any of these. I would love the quota spreadsheet, but would take any. I am struggling on excel creating formulas although I have had a great deal of help from Mr Fluff, it might just be easier if someone had one. I run u multi round league on different courses, so it would be great if i can just change the pars to each hole to adjust to the new course without having to create an entire new spreadsheet for each course that included handicaps to point total. It would be a major bonus to if it showed skins as well. Only if people are willing to share. I am still working on mine, but will have to create multiple spreadsheets for each course with all the formulas and will just be a lot of work thats probably not necessary all because I am not quite familiar with excel, but I am working on getting better. Thank you so much! I will attach an example of what I have created so far but I will need room for at least 24 golfers.

 

[Dave Patton]

A few recommendations
1. provide a full explanation of what you require; assume that we do not know anything about your scoring system
2. provide an extract of your sheet with the forum's tool named XL2BB
3. show expected results
4. update your profile. What version of Excel do you use?
5. test suggestions

N.B. Try suggestions in your previous post.

 

[Jonezy47]

Quota is a gamed based on points. Take ones handicap and subtract it from 36. The total after subtracted from 36, equals your points that you must get in your round.
Double Bogey or worse=0
Bogey=1
Par=2
Birdie=4
Eagle=8

I would like to be able to change the par every round and handicap depending on what course is being played. instead of making multiple sheets for each course I would just like to enter course information and people to start plugging scores right away showing results of skins, total scores and everything else. I have excel 365

 

[AhoyNC]

See if this example helps. The formula for the Quota assumes you have Excel 365 (if not let us know what version you are using).
In the example for the formulas to up date all you have to do is change the row for course HC and row for course par per hole.
Row 5 is the actual score Mitch had per hole.
Row 6 would show the number of strokes allowed per hole based on HC.
Row 7 is player's HC score
Row 8 is points per quota. Note I used a table to reference points which would allow you to change the point system and not have to change the formula.

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1
2		Hole	1	2	3	4	5	6	7	8	9		10	11	12	13	14	15	16	17	18
3		HC	9	13	7	11	1	3	17	5	15	OUT	14	2	12	10	18	4	6	8	16	IN	Total
4	Player	Par	4	4	5	4	4	5	3	4	3	36	4	5	4	5	3	4	3	4	4	36	72
5	Mitch	Score	3	4	5	4	5	7	6	2	3	39	5	4	4	5	2	4	4	4	5	37	76
6	HC- stroke/ hole	15	1	1	1	1	1	1	0	1	1	8	1	1	1	1	0	1	1	1	0	7	15
7	HC score		2	3	4	3	4	6	6	1	2	31	4	3	3	4	2	3	3	3	5	30	61
8	Quota		4	2	2	2	1	0	0	8	2	21	1	4	2	2	4	2	1	2	1	19	40
9
10
11											Quota Table		Pts
12											Bogey=1	1	1
13											Par=2	0	2
14											Birdie=4	-1	4
15											Eagle=8	-2	8
Sheet1

Cell Formulas
Range	Formula
V4:V8,L4:L8	V4	=SUM(M4:U4)
W4:W8	W4	=V4+L4
C6:K6,M6:U6	C6	=INT($B6/18)+IF(C$3<=MOD($B6,18),1,0)
C7:K7,M7:U7	C7	=C5-C6
C8:K8,M8:U8	C8	=XLOOKUP(C$5-C$4,$L$12:$L$15,$M$12:$M$15,0)

 

[Jonezy47]

Thank you so much for your response that looks great!

 

[AhoyNC]

You're welcome. Thanks for the feedback.
Usually what I do is have one sheet to enter the score which would feed other sheets to do HC, Quota game, etc. That just seems to make it easier the drag formulas down and across.