Golf - Keeping Your Handicap

bver_hunter

Well-known member
Nov 5, 2005
30,573
8,612
113
I have started taking up to golf and have decided to keep a handicap. Always had a opinion it was a boring sport until the Pandemic hit and I joined a couple of buddies on the golf course. Next Season the intention is to join a Golf Club. You automatically then get access to Golf Canada Membership and their site to keep your handicap. However, this Season I decided to start keeping my own Handicap and put together an excel Spread-sheet. Then I realized that the Handicap Rules actually changed in 2020 to take into account 8 rather than 10 of your best scores in 20 rounds. That is not a problem to switch to 8. But what what is challenging is taking 2 strokes off in the first 3 rounds by Adjustments then it goes down to 1 stroke off in 4 games and finally 0 strokes off in 5 games. That is based on just one best score. However, when you play 6 rounds it averages the best 2 rounds but then gives you a stroke off. From 7 rounds onwards there is no problem as the Adjustment reveals no strokes to be taken off your Handicap. But just cannot get the spread-sheet to remove these strokes when it automatically calculates the Handicap based on the average of the respective rounds. Any ideas how to do so if there are any IT wizards on this Board?

scorechRT.png
 
I believe there are a number of free websites that will track and calculate your handicap - just Google "Golf Handicap Calculator" and pick one you like.

I used to track my handicap but have not for a few years and forget the app I used. I came to the realization that I was under the illusion that I was actually not that bad my real handicap was that I try to play golf and the golf gods regularly disabused me of the that notion.

I usually shoot in the low to mid 90's with the very, very occasional round in the mid 80's depending on the rating of the course - so it did not make sense to me to be too focused on my handicap. Now I measure my rounds as a success if I can play 18 holes without losing a ball.
 
  • Like
Reactions: Captain Bly
Once you play 20 games shouldn’t it fix itself?

Not sure how to set up a formula for first 8 or so, but I do maintain one that works once you played 20 times. I just set up an excel function that first calculated the differential for each game in one column. And then a function that averages the best 8 handicap differentials out of a range of 20 — and drag that formula down. If you need that formula let me know.

Two things changed in 2019 or 2020 ( I think because I just started calculating it in 2020 and there is info and apps on the internet that use both the old and new method).
— best 8 instead of best 10 which you have captured.
— but your differential each round is now at a factor of 1, rather than .96 if i remember the old formula correctly.

So under the new system you get helped by the top 8 instead of top 10, but each individual round differential is higher.
 
Look up THE GRINT app.

Thanks. I can also get just the Free Handicap on Sandbagger. But I have also developed a Course Handicap section for each course that we play on. We can then compare what we are doing versus the actual expected score based on the Handicap. That is why we want to use the spread-sheet to track it all without subscribing to an online site.
 
Once you play 20 games shouldn’t it fix itself?

Not sure how to set up a formula for first 8 or so, but I do maintain one that works once you played 20 times. I just set up an excel function that first calculated the differential for each game in one column. And then a function that averages the best 8 handicap differentials out of a range of 20 — and drag that formula down. If you need that formula let me know.

Two things changed in 2019 or 2020 ( I think because I just started calculating it in 2020 and there is info and apps on the internet that use both the old and new method).
— best 8 instead of best 10 which you have captured.
— but your differential each round is now at a factor of 1, rather than .96 if i remember the old formula correctly.

So under the new system you get helped by the top 8 instead of top 10, but each individual round differential is higher.

Precisely, at the moment on the spread-sheet I just enter the number of rounds along with the slope, and rating. It then automatically takes the best differential from the first three to the first five rounds, and when it reaches the 6th round it averages 2 of the best differentials and so on. Now we cannot automatically get the strokes taken off when it automatically adjusts the differentials based on the number of rounds. So I have to do it manually. I guess once we do 7 rounds, then this will not be an issue. The spread-sheet also determines the Course Handicap and accordingly measures the estimated score based on the Course Handicap for Each Golfer versus The Actual Score. This way we compete with one another based on how many strokes we are over or under our expected scores. Yes I removed the 0.96 adjustment as it no longer applies and the only thing that we have to do is truncate the average of the differential scores to calculate the Handicap Index.
 
I believe there are a number of free websites that will track and calculate your handicap - just Google "Golf Handicap Calculator" and pick one you like.

I used to track my handicap but have not for a few years and forget the app I used. I came to the realization that I was under the illusion that I was actually not that bad my real handicap was that I try to play golf and the golf gods regularly disabused me of the that notion.

I usually shoot in the low to mid 90's with the very, very occasional round in the mid 80's depending on the rating of the course - so it did not make sense to me to be too focused on my handicap. Now I measure my rounds as a success if I can play 18 holes without losing a ball.

Like I mentioned above it is all to do with competing among ourselves where we determine our individual Course handicaps and expected scores and accordingly measure it against our actual scores. then the guy who does the worse buys the beers. Well this way we are on a level playing field.
 
https://gao.ca/

I don't know what free calculators are out there but for $49.95/year you can join Golf Ontario/Canada and enter your scores directly. Put in enough cards and you will have a registered handicap.
 
Once again for now this Handicap Index is purely designed to give us individual Course Handicap that I already have developed a spread-sheet in this respect. All I wanted was this new strokes taken off the differentials in the first few rounds as per The Adjustments column. But of course that is too complicated unless there is a real Tech Savvy IT guy who can advise.

I am aware of this Golf Canada handicap as I stated in one of my above Posts and will automatically be enrolled as a member towards the end of this season when I become a member of a golf club!!
 
I have to be honest, in this day and age of political correctness, I can’t believe the golf world hasn’t done anything to change the name of this, especially after baseball starting using the term “injured list” in place of “disabled list”.
 
  • Like
Reactions: The Oracle
I have to be honest, in this day and age of political correctness, I can’t believe the golf world hasn’t done anything to change the name of this, especially after baseball starting using the term “injured list” in place of “disabled list”.
I can understand certain aspects of the PC movement, but I thought changing the name of the disabled list was dumb (not that there's anything wrong with injured list). If a player is injured and cannot play, by definition he is disabled, albeit temporarily. It's accurate and appropriate terminology.
 
You have serious problems. Type in "handicap definiton". Nothing to do with humans. Cancel culture is disgusting. Go cancel yourself in total if you can't handle every other word in life.

I know that you jack ass, and I can handle every word. I'm talking about the over kill of cancel culture.
 
Jackass wow so tough when defensive. You were not being sarcastic in your " i can't believe". You want them to change it. Anyone who is okay with the term would not even bring up the issue in the manner you did. Read how it sounds..."day and age as well". You aren't fooling anyone.
 
Jackass wow so tough when defensive. You were not being sarcastic in your " i can't believe". You want them to change it. Anyone who is okay with the term would not even bring up the issue in the manner you did. Read how it sounds..."day and age as well". You aren't fooling anyone.


You keep telling that to yourself buddy, if it lets you sleep at night.
 
Once you play 20 games shouldn’t it fix itself?

Not sure how to set up a formula for first 8 or so, but I do maintain one that works once you played 20 times. I just set up an excel function that first calculated the differential for each game in one column. And then a function that averages the best 8 handicap differentials out of a range of 20 — and drag that formula down. If you need that formula let me know.

Two things changed in 2019 or 2020 ( I think because I just started calculating it in 2020 and there is info and apps on the internet that use both the old and new method).
— best 8 instead of best 10 which you have captured.
— but your differential each round is now at a factor of 1, rather than .96 if i remember the old formula correctly.

So under the new system you get helped by the top 8 instead of top 10, but each individual round differential is higher.

I have a spread-sheet that now automatically adjusts the Handicap Differential based on the Rounds played and it also pulls up the respective number of Score differentials according to the above chart. So for 8 games it pulls up two score differentials, whereas it is 3 score differentials for 11 Rounds.
But I also had to create a separate spread-sheet to incorporate the above adjustments to the Handicap Index for the first 6 Differentials. So the two spread-sheets now accurately display the exact Handicap Differential Index that is then used to highlight the expected score for the Course in the next upcoming round.

So I am finally.........done. Yes you are right that the 0.96 Factor is no longer a requirement to calculate the final Handicap Index. Not sure why it was there in the first place.
 
I have a spread-sheet that now automatically adjusts the Handicap Differential based on the Rounds played and it also pulls up the respective number of Score differentials according to the above chart. So for 8 games it pulls up two score differentials, whereas it is 3 score differentials for 11 Rounds.
But I also had to create a separate spread-sheet to incorporate the above adjustments to the Handicap Index for the first 6 Differentials. So the two spread-sheets now accurately display the exact Handicap Differential Index that is then used to highlight the expected score for the Course in the next upcoming round.

So I am finally.........done. Yes you are right that the 0.96 Factor is no longer a requirement to calculate the final Handicap Index. Not sure why it was there in the first place.

Man you have way to much time on your hands,lol........