# Golf Handicap calculator

1. ## Golf Handicap calculator

Hello Everybody

I'm John Stevenson & This is my first time posting here.
I run a Design & Print business in Glasgow so my problems are normally more Creative than Mathematical.

However, I'm going on a small golf tour to Turkey this year and have been trying to devise a Handicap Calculator but can't get the right formula

Spreadsheet is attached in case anybody can help.
Handicap Calculator.xlsx
Specification is as follows:
8 people
Names and Handicaps to be entered manually
5 rounds of golf
scores to be entered manually using Stableford points golf system
Total score for 5 rounds to be calculated by the program
Average score for each round (across 8 players) to be calculated for each round
Difference to the average to be calculated for each player, at the end of each round
New Handicaps to be calculated by the program at the end of each round
For players whose score is 1 point better or worse than the average, no handicap change. i.e. if the average score is 36, players scoring 35, 36 or 37 will not have their handicaps changed. This will be called the buffer zone.
For players whose score is better that the average, their handicap is to be decreased by 0.5 for each 1 point their score is better than the buffer zone.
For players whose score is worse that the average, their handicap is to be increased by 0.5 for each 1 point their score is better than the buffer zone.

2. ## Re: Golf Handicap calculator

The fractions make it a bit more difficult. Not sure where you wanted the separation of .5 to be, but this should be close enough. Place in C4 and then drag to G11. Modify as needed.
=IF(ABS(B15-B\$23)>1,SIGN(B15-B\$23)*MROUND((ABS(B15-B\$23)-1)/2,0.5),0)+B4

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1