Help on formula in Golf Spread sheet - Golf knowledge needed

[damian_r_Home]

I think anyone who could help me on this may really need golf knowledge (especially Stapleford scoring system)

Above is a basic spreadsheet that I’m trying to create for me and a few friends in which we are going to log all our golf scores.

The problem I’m having is getting the Stapleford points bit to work in cell H6, by using the handicap score in cell E6 against the hole difficulty in cell H4.

Basically you are allowed an extra number of shoots on your round of golf (this is your handicap). Depending on the difficulty of the hole (ranges from 1 to 18, 1 being the hardest) it depends on the number of extra shots you get.
Example being Handicap of 28 you get one extra shot on every hole, which uses up 18 of you additional shots, and then another shot on holes difficulties 1 to 8. Someone with a handicap of 9 would only get an extra shot on hole difficulties 1 to 9.
Right, are you still with me?
The number of points you get now depends on the number of shots you took. i.e. the par for the hole + the number of extra shots you were allowed = your par.
If you took the same number of shots as your par you get 2 points, 1 shot above your par you get 1 point, 2 shots over and more you get no points. For every shot under your par you get another point i.e. 1 shot under = 3 points, 2 shots under = 4 points, etc, etc.
Now you see why I think someone with golf knowledge really may be the only ones who can help here.

If necessary I would be very happy to send the spreadsheet I’ve done so far (less all my failed formulas and lookups) if it makes it easier for anyone to help me.

Thanks in advance

Damian

 

[georged2]

Re: Help on formula in Golf Spread sheet - Golf knowledge ne

Hi Bravos, an awesome formula that works prefect, of course when fixed with the =.

Many courses around Australia have adopted a split index rating. As an example, a par 4 at Box Hill Golf Club has an index of 18/31. It is determined that a golfer with a handicap of 36 should not get 2 shots on this very easy hole.

Can your formula be adjusted to work out a split index. As it stands, your formula will award a 36 handicapper 2 shots on this particular par