Golf Workbook

I have received a lot of help form this forum in developing a spread sheet for the golf game I participate in on the weekends. I am attaching it so those of you that are looking for specific formulas on calculating, STABLEFORD, GROSS SKINS, NET SKINS, HIGHLIGHTING LOW CELLS, HIGH CELLS, figuring HANDICAPS etc..... may find the formulas of use.

Feel free to use any, all or none of it. It's just my way of saying "thank you" for all the help I received. If anyone does use it, I tried to make it so that all you had to input was gross score and player info, everything else is calculated. Good luck and thanks again for all the help.

RWhite,
I noticed in one of your other threads that you were building a fomula that adjusted quotas based on what the player shot that particular week. I downloaded your spread sheet and couldn't find the adjusted quota. Is there a particular place in the current spreadsheet I should look for adjusted quotas?
Example.
Player A's quota is 25 and they finish with 30 points. Weekly score +5
Next weeks quota would be 27.
Thanks for your help and your scoring spreadsheet is incredible!

I used this formula for quota adjustments:

=G8 + LOOKUP(ABS(H8-G8), {0,2,5,8,11}, {0,1,2,3,4} * SIGN(H8-G8))

G8 represented what that player needed and H8 is what he/she got. Below is the adjustment parameter:

a player at or +1/-1 has no adjustment (quota stays the same)
a player over their points by 2-4 moves up +1, below their points by 2-4 goes down -1
a player over their points by 5-7 moves up +2, below their points by 5-7 goes down -2
a player over their points by 8-10 moves up +3, below their points by 8-10 goes down -3
A player at 11 or more over goes up +4 and under goes down -4. 4 is the MAX adjustment

Here is some of the sheet I used for our league. I used to have a more comprehensive example but I lost it when my hard drive crashed a couple of months ago.

Handicaps can be determined in many ways. Some of the variables include the number of rounds used (last ten, best ten etc). Also not all HCPs allow every stroke counted to prevent someone from "padding" their HCP i.e. thking more strokes to make their HCP higher. In our league we did not count and score for HCPs that was more than 3 over par for any single hole.


JIm O

Thanks for your help!

Does anyone have a spreadsheet for scoring ship, captain or crew or wolf?