How can I create a Formula to figure out a Golf Handicap IN MS SQL
Step 1
(Score - Course Rating) x 113 / Slope Rating
For example, let's say the score is 85, the course rating 72.2, the slope 131
The formula would be (85 - 72.2) x 113 / 131.
This differential is calculated for each round entered.
Golf Handicap Calculation - Step 2
Figure out how many differentials are being used. Not every differential that results from Step 1 will be used in the next step. If only five rounds are entered, only the lowest differential will be used. If 20 rounds are entered, only the 10 lowest differentials are used. A chart at the bottom of this page shows how many differentials are used based on the number of rounds entered.
Golf Handicap Calculation - Step 3
Get an average of the differentials used by adding them together and dividing by the number used (i.e., if five differentials are used, add them up and divide by five).
Multiply the result by .96 (96-percent). Drop all the digits after the tenths (do not round off) and the result is handicap index.
Rounds Entered Differentials Used
5-6 1 lowest
7-8 2 lowest
9-10 3 lowest
11-12 4 lowest
13-14 5 lowest
15-16 6 lowest
17 7 lowest
18 8 lowest
19 9 lowest
20 10 lowest
Thanks in advance