Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Golf Handicaps
Does anyone know how to obtain an Excel worksheet that calculates golf
handicaps? I would try to develop my own but don't know the mysteries of golf handicap calculation. D |
#2
|
|||
|
|||
Several years back I posted code to do this. You can probably find it on
Google. I had no idea how to calculate a golf handicap, either, but a quick Google search revealed all. On Sat, 10 Sep 2005 13:14:14 +0000 (UTC), "David Clark" wrote: Does anyone know how to obtain an Excel worksheet that calculates golf handicaps? I would try to develop my own but don't know the mysteries of golf handicap calculation. D |
#3
|
|||
|
|||
A golf handicap is 96% of the best 10 of your last 20 games. To calculate it,
you need to: 1. For each game, calculate your differential (your score minus the course rating) 2. Sum the lowest 10 differentials in the last 20 games. 3. Multiply by 96%. -- Regards, Fred "David Clark" wrote in message ... Does anyone know how to obtain an Excel worksheet that calculates golf handicaps? I would try to develop my own but don't know the mysteries of golf handicap calculation. D |
#4
|
|||
|
|||
Hmmm.... The info I found was a bit more complicated than that. AIR, it
involved values for course ratings and course slopes, as well as your scores. On Sat, 10 Sep 2005 09:48:46 -0600, "Fred Smith" wrote: A golf handicap is 96% of the best 10 of your last 20 games. To calculate it, you need to: 1. For each game, calculate your differential (your score minus the course rating) 2. Sum the lowest 10 differentials in the last 20 games. 3. Multiply by 96%. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Golf scorecard again | New Users to Excel | |||
Golf Pool | Excel Discussion (Misc queries) | |||
Golf League Schedule | Excel Worksheet Functions | |||
Golf Handicap | Excel Worksheet Functions | |||
I need a template for weekly scheduling of golf tee times | Charts and Charting in Excel |