• Announcements

    • iacas

      Introducing TST "Clubs!"   08/28/2017

      No, we're not getting into the equipment business, but we do have "clubs" here on TST now. Groups. Check them out here:
Sign in to follow this  
lsu70510

Golf Handicap Calculator

Recommended Posts

Does anyone have / know of a Microsoft Excel template which calculates your handicap?  I go to golf.com and must enter ALL of my rounds after every round I play to determine my handicap.  I wanted a free template which calculates it for me so I can save the information and edit it after each round.  Any help is greatly appreciated!

Share this post


Link to post
Share on other sites

Sign up (or log in) today! It's free (and you won't see this ad anymore)!

Sign up (or log in) today! It's free (and you won't see this ad anymore)!

It's super easy to right the formula yourself to get the HC score for each round.  Say you write in a bunch of stats about the round in a row 1, with column A being your score, column B being the course rating from the tees you played, and column C being the course slope from the tees you played.  Then your index score for that round is:

=(A1 - B1) * (113 / C1) * 0.95

Say that formula is in column D.  If you've entered at least 20 rounds, then your HC is just the average of the best 10.  There's definitely a better way to get that average, but an easy way to get it is to use the SMALL function.  SMALL takes two arguments.  The first is the array of values, in this case D1:D20.  The second is the rank of the value you want.  So if you want the second smallest value, you would type "=SMALL(D1:D20, 2)".  So you could put into some cell the formula:

=(SMALL(D1:D20, 1) + SMALL(D1:D20, 2) + SMALL(D1:D20, 3) + ... + SMALL(D1:D20, 10)) / 10

Where the ... signifies using that same SMALL formula for ranks 4 through 9.

Alternatively, there are plenty of free handicap trackers for both the PC and your phone.  I use the "Handicap" app for my android phone.  It doesn't keep tons of stats.  Just FWs, GIR, and penalties.  But you can enter courses and rounds and it'll keep your HC for you and keep track of those other three stats as well.

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades



Originally Posted by mdl

=(A1 - B1) * (113 / C1) * 0.95

The multiplier is actually 0.96.

Also you can make it a little more elegant by keeping a second sheet with an identifier for each course (and each set of tees, if you play different ones) on a row along with the rating and slope. Then you can just enter the course/tee identifier and have it automatically look up the rating and slope from the second sheet (instead of entering those numbers every time you play that course/tee). For example, here's my formula for finding the differential:

ROUND((A1-VLOOKUP(B1,Courses!$A$3:$C$102,2,FALSE))*113/VLOOKUP(B1,Courses!$A$3:$C$102,3,FALSE),1)

In this example, B1 is the course/tee identifier and A1 is the score I shot. "Courses" is the name of a second sheet with the courses on it, where column A is the course/tee identifier that I enter with my score on the first sheet, column B is the rating, and column C is the slope. The Course sheet has a list of courses from row 3 to row 102. The third argument in the VLOOKUPs is the column number for the value I'm looking for (column 2 for rating, column 3 for slope), and the 4th argument (FALSE) tells VLOOKUP to find an exact match, not an approximate one.

Just as an example of what I mean by a course/tee identifier, I might use "DOB" for Diamond Oaks blue tees.

There may be better ways of doing this - I am by no means an Excel expert.

(Also note that the 0.96 multiplier is not in my formula because I do that when I average the 10 best.)

Share this post


Link to post
Share on other sites

Yahoo has a golf handicap tracker, which I use -

http://golf.sports.yahoo.com/tracker

Share this post


Link to post
Share on other sites



Originally Posted by sacm3bill

The multiplier is actually 0.96.

Also you can make it a little more elegant by keeping a second sheet with an identifier for each course (and each set of tees, if you play different ones) on a row along with the rating and slope. Then you can just enter the course/tee identifier and have it automatically look up the rating and slope from the second sheet (instead of entering those numbers every time you play that course/tee). For example, here's my formula for finding the differential:

ROUND((A1-VLOOKUP(B1,Courses!$A$3:$C$102,2,FALSE))*113/VLOOKUP(B1,Courses!$A$3:$C$102,3,FALSE),1)

In this example, B1 is the course/tee identifier and A1 is the score I shot. "Courses" is the name of a second sheet with the courses on it, where column A is the course/tee identifier that I enter with my score on the first sheet, column B is the rating, and column C is the slope. The Course sheet has a list of courses from row 3 to row 102. The third argument in the VLOOKUPs is the column number for the value I'm looking for (column 2 for rating, column 3 for slope), and the 4th argument (FALSE) tells VLOOKUP to find an exact match, not an approximate one.

Just as an example of what I mean by a course/tee identifier, I might use "DOB" for Diamond Oaks blue tees.

There may be better ways of doing this - I am by no means an Excel expert.

(Also note that the 0.96 multiplier is not in my formula because I do that when I average the 10 best.)


To get an accurate index you also have to do the rounding correctly.  Differentials are rounded to the nearest tenth.  Then the Index is truncated to the tenths place.

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades



Originally Posted by turtleback

To get an accurate index you also have to do the rounding correctly.  Differentials are rounded to the nearest tenth.  Then the Index is truncated to the tenths place.



Yep. I"m rounding in the formula I posted, and I'm truncating when I do the average and multiply by 0.96, which I didn't post. I was assuming the OP knew the formula and was just asking how to implement it in Excel, so I didn't go into more detail... but you're right to point that out.

Share this post


Link to post
Share on other sites

Can u send me your excel file for handicap tracking?? Bmervar19@gmail.com

Sorry... just saw this. You should have it now.

BTW, Welcome to The Sand Trap. I hope that you stick around; it's a great community to be apart of.

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades

If you could send it to me as well, I would certainly appreciate it. 14ledo81@gmail.com

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades

Hi there... would you be willing to send me the excel spreadsheet as well?  Thank you!  slevy53@live.com

[quote name="14ledo81" url="/t/54088/golf-handicap-calculator#post_982169"]If you could send it to me as well, I would certainly appreciate it. 14ledo81@gmail.com[/quote] Just out of curiosity, why would you want a spreadsheet to calculate an invalid handicap index, when you can obtain a genuine, valid index for $25 or so per year?

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades

Just out of curiosity, why would you want a spreadsheet to calculate an invalid handicap index, when you can obtain a genuine, valid index for $25 or so per year?

Is it invalid to use an excel spreadsheet?

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades

Just out of curiosity, why would you want a spreadsheet to calculate an invalid handicap index, when you can obtain a genuine, valid index for $25 or so per year?


That's what I was wondering as well. sure it'd be nice just to know for your own interest but it's useless if you want to enter any tournaments.

Share this post


Link to post
Share on other sites

I don't play in any tournaments, and have no plans to. Strictly for my own interest. Mainly to gauge progress.

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades

I don't play in any tournaments, and have no plans to. Strictly for my own interest. Mainly to gauge progress.

Then track your average score..... One mathematical calculation means no more than another for your purpose.

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  



  • Want to join this community?

    We'd love to have you!

    Sign Up
  • 2017 TST Partners

    Talamore Golf Resort
    PING Golf
    FlightScope Mevo
    Mission Belt
    Snell Golf
    Frogger Golf
    PitchFix USA
  • Posts

    • I started playing 3-4 months ago, having never been on a course of touched a golf club. I am really loving the game, but frustrated with my progress. On my little 9-hole course (2100 yards) I have gone from 82 to 63, but on my proper 9-hole (3200 yds) I am stuck at 75-80. I play 3 times a week (except some breaks when I travel for work), and take lessons. I can’t practice much more as the range seems to be contributing to various injuries. My technique is definitely improving, having more control around the green and at double/triple bogey on par 3s. My main issue seems to be getting to the green on par 4 and 5 where I often spend 6-7 strokes just getting there. My tee shots are inconsistent and max 120 yds, and even though I rarely shoot OB I often just shoot 50 yds ahead.  Looking at this forum, most people seem to struggle with the 100 to 120, so it is really discouraging to be at 160 (I count everything!). Did anyone start so badly, and was there a point in which things started coming together? Please share! At this point I still enjoy myself, but it’s starting to be demotivating. 
    • Brilliant info, I hadn't thought of that... Ha ha I'm afraid it does get very windy and wet here in Winter and I found that the hybrids were launching a little high and just wanted an iron that would keep it down a bit. I figured that the 24* driving iron with the bit of extra cavity/help in the back would be a solid option and then go from 5-PW with my set.   I think the shims work well ( from what I googled ) once the prep work is done correctly on the adapter and all parts are sanded to help better contact for the epoxy so should be good to go. Thank you @WUTiger appreciate the info
    • Not for me. If i duff my last few balls its just a case of "well they didnt go as planned, not a problem". I didnt used to be like that. I'd bring old balls with me so i could finish on a good shot but i feel, for me, doing that doesnt benefit me. Its a personnal kind of thing. If i've had a really good session then a few bad shots isnt the end of the world. I generally finish with pitches so there is less chance of finishing with a duff but if i do then its no biggie. Best to make the mistakes  in dress rehersal than on the night. I do agree with not going to bed angry though, never good.
    • 20" and 80" measuring devices will be on the market shortly.
    • That is not evidence of a conspiracy.  You can suspect collusion if you want, but there is absolutely no proof that anyone conspired to anything.  What little evidence that suspicion provides is completely circumstantial, and you can't provide a motive for such a conspiracy.   You may be right that there is a tacit conspiracy, but that would be very hard to prove to the point of meting out any punishment.  Suspicion and supposition certainly wouldn't convict anyone in a court of law, and I feel that you have to hold it to at least that high a standard. 
  • Blog Entries

  • Today's Birthdays

    1. Covert
      Covert
      (74 years old)
    2. opie
      opie
      (40 years old)
    3. Robert Diddings
      Robert Diddings
      (33 years old)
  • Get Great Gear with Amazon