In case anybody is looking for Excel formulas, here are some examples (in my sheet, Score is column D, Course Rating column E, and Slope Rating column F (& Score Differential G) with Row 2 being my oldest round & where I'm tracking Handicap) Score Differential: =(113/F2)*(D2-E2) Drag formula down from G2 to max of G21 depending on how many rounds you have currently. Handicap examples: 4 rounds total: =AVERAGE(SMALL(G2:G5,{1})-1) 5 rounds total: =AVERAGE(SMALL(G2:G6,{1})) 9 rounds total: =AVERAGE(SMALL(G2:G10,{1,2,3})) 20 rounds total: =AVERAGE(SMALL(G2:G21,{1,2,3,4,5,6,7,8})) I'm only at 5 rounds myself, but last 2 above should work (might be able to simply formula in some places). Good luck!
Great video Drew. I have one inquiry though. I've read in a few other posts and watch a couple other videos about the handicap system. According to those you're only calculating the handicap index and not your true handicap. Albeit they're the handicap and handicap index are very close. The Handicap Index (HCI) needs to be plugged into a second equation. From my research the Handicap formula is: HC= (HCI x SR)/113 + (CR-PAR). Where SR, CR and PAR are Slope Rating, Course Rating and Par for that course. Please let me know if something is amiss. Thanks again for the video.
So that 8.3 is the average of all of my score differentials from the past 2 years. So if I didn't pick my lowest 8 scores then my Handicap would be at 8.7 based on the average of every round I've played. But, luckily for us we get to pick our lowest 8 rounds of our most recent 20, and that is what makes me a 1.7 HCP in cell C:42. Thanks for watching!
Thanks for the comment Colby! I usually track through 18 birdies app or on scorecard and keep it on a google doc. You can also track through the GHIN app I believe!
what's the difference between "adjusted gross score" and "net score"? Example: If I'm a 12 Hcp and I shoot 8 at a Par 4 with Stroke-Index 7, I get one stroke on that hole. So gross score is 8, adjusted gross score is 7 with the net double bogey rule and now I can further subtract 1 for the net score (then being 6?) because of the 1 stroke I gained? Or can't I? But then adjusted gross score would just be the same as net score?
Drew, I'm hoping you can help me! We play the same course every week in our league. My average differential on that course is 4.68 (course rating 69 and slope 122). My program calculated my handicap index at 5.7. My question is, if I go play a much harder course (i.e. Muirfield Village, with a rating of 72 and 147 slope), how do I adjust my course handicap to play that course against others?
Hey Jim thanks for comment. You would simply take your index of 5.7 multiply by course slope rating of the new course (147/113) then you would add course rating minus par if there is a difference. In your example you would be adjusted up about 2 strokes to a 7 at Muirfield Village. Hope this helps
@@lewisrussell2783 I think the USGA is just giving the benefit of the doubt that you might not have played your best round since you’ve only got a couple scores posted.
Just record scores that are 15 or 20 higher than you’ve ever shot in your life . Now take that bloated handicap to your Mens or women’s weekly tourney and clean up
In case anybody is looking for Excel formulas, here are some examples (in my sheet, Score is column D, Course Rating column E, and Slope Rating column F (& Score Differential G) with Row 2 being my oldest round & where I'm tracking Handicap)
Score Differential: =(113/F2)*(D2-E2)
Drag formula down from G2 to max of G21 depending on how many rounds you have currently.
Handicap examples:
4 rounds total: =AVERAGE(SMALL(G2:G5,{1})-1)
5 rounds total: =AVERAGE(SMALL(G2:G6,{1}))
9 rounds total: =AVERAGE(SMALL(G2:G10,{1,2,3}))
20 rounds total: =AVERAGE(SMALL(G2:G21,{1,2,3,4,5,6,7,8}))
I'm only at 5 rounds myself, but last 2 above should work (might be able to simply formula in some places). Good luck!
Finally someone that didn’t assume everyone knew what crap meant and really explained it through. Thanks man 🎉
Awesome video Drew...thank you! For now I'm going to calculate it myself and have developed my own spreadsheet...
Really helpful to break down what each component is and how it figures into your overall handicap.
Thanks Drew, you explained it very well. 👍
This is nice and clear. Thanks for sharing!
Absolutely great video thank you
great video, exactly what i was looking for, THANKS
Great video, explained very well 👏🏾 👍🏾
Thank you....straight forward and to the point.
Thanks! Would also be helpful to explain AGS and net double bogey concept
Great video Drew. I have one inquiry though. I've read in a few other posts and watch a couple other videos about the handicap system. According to those you're only calculating the handicap index and not your true handicap. Albeit they're the handicap and handicap index are very close. The Handicap Index (HCI) needs to be plugged into a second equation. From my research the Handicap formula is: HC= (HCI x SR)/113 + (CR-PAR). Where SR, CR and PAR are Slope Rating, Course Rating and Par for that course. Please let me know if something is amiss. Thanks again for the video.
Thanks for the info! Very helpful.
Very useful explanation - thank you.
Thanks for watching 😀
Awesome! I would love to see your formulas so I can keep track of this myself. Why does cell E:42=8.3?
So that 8.3 is the average of all of my score differentials from the past 2 years. So if I didn't pick my lowest 8 scores then my Handicap would be at 8.7 based on the average of every round I've played. But, luckily for us we get to pick our lowest 8 rounds of our most recent 20, and that is what makes me a 1.7 HCP in cell C:42.
Thanks for watching!
I hit a 7 iron 150 yards working with John Handly at Hidden Hills Golf Course.
Great job explaining
This was really good! Thanks! Do you use an app to track GIR and putts etc? Thanks again!
Thanks for the comment Colby! I usually track through 18 birdies app or on scorecard and keep it on a google doc. You can also track through the GHIN app I believe!
Good video brother!
what's the difference between "adjusted gross score" and "net score"? Example: If I'm a 12 Hcp and I shoot 8 at a Par 4 with Stroke-Index 7, I get one stroke on that hole. So gross score is 8, adjusted gross score is 7 with the net double bogey rule and now I can further subtract 1 for the net score (then being 6?) because of the 1 stroke I gained? Or can't I? But then adjusted gross score would just be the same as net score?
I’m a solid 98 if that’s consistent what would my hands cap be 🤷
Ok, cool, that was easy, thanks man,
No Problem!
Drew, I'm hoping you can help me! We play the same course every week in our league. My average differential on that course is 4.68 (course rating 69 and slope 122). My program calculated my handicap index at 5.7. My question is, if I go play a much harder course (i.e. Muirfield Village, with a rating of 72 and 147 slope), how do I adjust my course handicap to play that course against others?
Hey Jim thanks for comment. You would simply take your index of 5.7 multiply by course slope rating of the new course (147/113) then you would add course rating minus par if there is a difference. In your example you would be adjusted up about 2 strokes to a 7 at Muirfield Village. Hope this helps
I enjoyed this!! Do you know if the 113 would be the same figure to multiply by if I’m in the UK?
Yes it is. The WHS is supposed to make the calculation the same around the world.
@@randomtask99 ace, thank you Odd Job.
6 off a hundo! Keep it up homie
The show goes on! Thanks for watching 🤝
Does 9 holes work for this?
Outstanding
Can’t you build a formula into an excel spreadsheet to calculate golf handicap?
I’m sure you could!
So when you take into consideration the adjustment when doing 1 or 2 rounds, do you just add 2 on top of your handicap?
When you only have a couple of differentials it will actually subtract from your handicap until you hit close to 20 rounds
@@drewfortsongolf5529 mad! do you know why that is? So really you could say you're a 12 when in reality you're a 14?
@@lewisrussell2783 I think the USGA is just giving the benefit of the doubt that you might not have played your best round since you’ve only got a couple scores posted.
@@drewfortsongolf5529 thank you, your video has really helped me out I honestly found it so difficult figuring it out on my own lol. Cheers pal.
Does it matter if some of the last 20 games where at par 3 course's and sone where at full courses
The USGA does not accept scores from par 3 courses for figuring a player's official handicap
My handicap is.....I TRY TO GOLF!
I’m a little bit mentally handicapped on the golf course most times lol
Just record scores that are 15 or 20 higher than you’ve ever shot in your life .
Now take that bloated handicap to your Mens or women’s weekly tourney and clean up
I scoured.
I could not find.
Then, I saw your face, and your face alone was trustworthy
🤔 I thought the slope rating was for how hot the female Asians Golfers were at a particular course ! I’ve been doing it incorrectly for years then ! 👅