• Announcements

    • iacas

      Visit FlagstickRule.com   03/13/2017

      Visit the site flagstickrule.com to read about and sign a petition for the USGA/R&A regarding the one terrible rule in the proposed "modernized" rules for 2019.
Sign in to follow this  
Followers 0
lsu70510

Golf Handicap Calculator

28 posts in this topic

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!

0

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)!

Where's iacas!? It's the perfect time to buff up Scorecard!

0

Share this post


Link to post
Share on other sites

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.

0

Share this post


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

I have an excel file.... if you want to shoot me a PM with your email address, I'd be happy to send it your way.

0

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.)

0

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

0

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.

0

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.

0

Share this post


Link to post
Share on other sites

Thanks for all of your reply's.  I truly appreciate the help!!!

0

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.

0

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

0

Share this post


Link to post
Share on other sites

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

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?

0

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?

0

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.

0

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.
0

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.

0

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  
Followers 0



  • Want to join this community?

    We'd love to have you!

    Sign Up
  • 2017 TST Partners

    PING Golf
    Leupold Golf
    Snell Golf
    Talamore Golf Resort
    Lowest Score Wins
  • Posts

    • Final chapter - mystery solved......and boy am I a "dufus".......like "DUH".... The hosel adapter for Tour Edge Exotics has a short 1.75 inch sleeve that slips over the attachment screw to hold the screw straight (and prevent cross threading I presume).  Somehow when the shaft was removed, the sleeve had slid up into the shaft, hidden from view. The shaft (with hidden sleeve) was then installed into another standard head and during installation, had gotten loose and was free to slide up and down the shaft. When I bonded the shaft to the head, I had given it a small tap on the grip end to seat the shaft which is recommended practice by some fitters. This action would have presumably forced the sleeve up in the shaft and due to larger diameter of the shaft, was free to slide. I don't feel too bad however, as I had made a telephone call to a local fitter, and he was dumfounded as well. 
    • I think a qualified fitter should be able to provide that info! Of course, I have to allow for the fact that, like a medical diagnosis, @Spring1 is simply looking for a second opinion, albeit from complete and total strangers who have never seen him swing a club. Look, @Spring1, I'm not trying to be rude here, nor is anyone else. It's just that your question confuses us a bit. And don't let this "grilling" scare you away. We're honestly curious and would like to help. FWIW, graphite shafts are lighter than steel. So, if you stick the same length graphite into a formerly steel shafted iron, it's going to monkey with the swingweight. It will make it lighter! To compensate, most manufacturers will make the graphite shafted clubs slightly longer to get the swingweight back up. The question is whether or not you can hit those longer irons as accurately as the originals. You should be allowed to hit both models and make a decision from that. And, I notice that you're a 39, and you mentioned the Ping brand in particular. So, I'm guessing this was a "golf store" fitting, and not a "custom clubmaker" fitting. Then another possibility presents itself. Maybe @Spring1 is wondering whether the store "fitter" is trying to upsell him into something more expensive, or something they need to move! All that matters is performance. Do the clubs work for you? And, of course, I could be entirely wrong about everything I've typed above and made a complete fool of myself! But then, I (and we) could use a bit more info.
    • Saw something intresting during my round the other day.my home club here in new zealand has a pretty relaxed dress code.and I was in my normal sort of outfit for a warm day.plain shorts,and a plain blue Nike t-shirt with no graphics or logos on it.no knee length white socks thou lol.and saw a visitor to our club dressed in golf pants and a polo. But his polo had a big skull and crossbones on it with the skull smoking.just playing devils advocate here,but it would be intresting to see what happened if he turned up at the only course in our area that stipulates a collar.ild argue that a plain t-shirt looks a lot better.(all thou as i said in the original post i always stick a polo on when i play at that club)
    • He's still young too thou,is it a case of just needing to mature a bit.and get a bit more experience.(how old is he exactly i know his early 20s?) I know he's not the same type of players but i seem to remember sergio garcia having a lot of blow up holes when he was younger,and losing his temper a lot more over it.and he seems to have matured into a much more composed player these days. That said ild take Jordan's game over mine in a heartbeat 
    • Could be the greens you play.  There is one course I play ocassionally that has greens that are not too fast but are hard.  It's hard to make a ball mark, it's hard to stop the ball.  You have to try to adjust to the roll.
  • TST Blog Entries

  • Blog Entries

  • Today's Birthdays

    1. bigtosh90
      bigtosh90
      (27 years old)
    2. dopplegvnger
      dopplegvnger
      (25 years old)
    3. Frank62
      Frank62
      (55 years old)
  • Get Great Gear with Amazon