Jump to content
IGNORED

Golf Handicap Calculator


lsu70510
Note: This thread is 2473 days old. We appreciate that you found this thread instead of starting a new one, but if you plan to post here please make sure it's still relevant. If not, please start a new topic. Thank you!

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!

IN MY BAG:

 - TaylorMade R11 Driver (Stiff Flex)

 - TaylorMade R11 3 Wood (Stiff Flex)

 - TaylorMade Rescule 11 (Stiff Flex)

 - Nike Slingshot irons (3 - PW)

 - TaylorMade TP xFT 52*

 - TaylorMade TP xFT 60*

 - Nike OZ Mallet Putter

 - Titleist NXT Tour golf balls

 - Footjoy StaSoft glove

 - Adidas Powerband Sport shoes

Link to comment
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.

Matt

Mid-Weight Heavy Putter
Cleveland Tour Action 60˚
Cleveland CG15 54˚
Nike Vapor Pro Combo, 4i-GW
Titleist 585h 19˚
Tour Edge Exotics XCG 15˚ 3 Wood
Taylormade R7 Quad 9.5˚

Link to comment
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.

Tristan Hilton

My Equipment: 
PXG 0211 Driver (Diamana S+ 60; 10.5°) · PXG 0211 FWs (Diamana S+ 60; 15° and 21°) · PXG 0211 Hybrids (MMT 80; 22°, 25°, and 28°) · PXG 0311P Gen 2 Irons (SteelFiber i95; 7-PW) · Edel Wedges (KBS Hi-Rev; 50°, 55°, 60°) · Edel Classic Blade Putter (32") · Vice Pro or Maxfli Tour · Pinned Prism Rangefinder · Star Grips · Flightscope Mevo · TRUE Linkswear Shoes · Sun Mountain C130S Bag

On my MacBook Pro:
Analyzr Pro

Link to comment
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.)

Bill

Link to comment
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.

But then again, what the hell do I know?

Rich - in name only

Link to comment
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.

Bill

Link to comment
Share on other sites


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

IN MY BAG:

 - TaylorMade R11 Driver (Stiff Flex)

 - TaylorMade R11 3 Wood (Stiff Flex)

 - TaylorMade Rescule 11 (Stiff Flex)

 - Nike Slingshot irons (3 - PW)

 - TaylorMade TP xFT 52*

 - TaylorMade TP xFT 60*

 - Nike OZ Mallet Putter

 - Titleist NXT Tour golf balls

 - Footjoy StaSoft glove

 - Adidas Powerband Sport shoes

Link to comment
Share on other sites


  • 2 years later...

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.

Tristan Hilton

My Equipment: 
PXG 0211 Driver (Diamana S+ 60; 10.5°) · PXG 0211 FWs (Diamana S+ 60; 15° and 21°) · PXG 0211 Hybrids (MMT 80; 22°, 25°, and 28°) · PXG 0311P Gen 2 Irons (SteelFiber i95; 7-PW) · Edel Wedges (KBS Hi-Rev; 50°, 55°, 60°) · Edel Classic Blade Putter (32") · Vice Pro or Maxfli Tour · Pinned Prism Rangefinder · Star Grips · Flightscope Mevo · TRUE Linkswear Shoes · Sun Mountain C130S Bag

On my MacBook Pro:
Analyzr Pro

Link to comment
Share on other sites

Awards, Achievements, and Accolades

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

-Matt-

"does it still count as a hit fairway if it is the next one over"

DRIVER-Callaway FTiz__3 WOOD-Nike SQ Dymo 15__HYBRIDS-3,4,5 Adams__IRONS-6-PW Adams__WEDGES-50,55,60 Wilson Harmonized__PUTTER-Odyssey Dual Force Rossie II

Link to comment
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?

In David's bag....

Driver: Titleist 910 D-3;  9.5* Diamana Kai'li
3-Wood: Titleist 910F;  15* Diamana Kai'li
Hybrids: Titleist 910H 19* and 21* Diamana Kai'li
Irons: Titleist 695cb 5-Pw

Wedges: Scratch 51-11 TNC grind, Vokey SM-5's;  56-14 F grind and 60-11 K grind
Putter: Scotty Cameron Kombi S
Ball: ProV1

Link to comment
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?

Matt Dougherty, P.E.
 fasdfa dfdsaf 

What's in My Bag
Driver; :pxg: 0311 Gen 5,  3-Wood: 
:titleist: 917h3 ,  Hybrid:  :titleist: 915 2-Hybrid,  Irons: Sub 70 TAIII Fordged
Wedges: :edel: (52, 56, 60),  Putter: :edel:,  Ball: :snell: MTB,  Shoe: :true_linkswear:,  Rangfinder: :leupold:
Bag: :ping:

Link to comment
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.

Rich C.

Driver Titleist 915 D3  9.5*
3 Wood TM RBZ stage 2 tour  14.5*
2 Hybrid Cobra baffler 17*
4Hybrid Adams 23*
Irons Adams CB2's 5-GW
Wedges 54* and 58* Titleist vokey
Putter Scotty Cameron square back 2014
Ball Srixon Zstar optic yellow
bushnell V2 slope edition

Link to comment
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.

-Matt-

"does it still count as a hit fairway if it is the next one over"

DRIVER-Callaway FTiz__3 WOOD-Nike SQ Dymo 15__HYBRIDS-3,4,5 Adams__IRONS-6-PW Adams__WEDGES-50,55,60 Wilson Harmonized__PUTTER-Odyssey Dual Force Rossie II

Link to comment
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.

In David's bag....

Driver: Titleist 910 D-3;  9.5* Diamana Kai'li
3-Wood: Titleist 910F;  15* Diamana Kai'li
Hybrids: Titleist 910H 19* and 21* Diamana Kai'li
Irons: Titleist 695cb 5-Pw

Wedges: Scratch 51-11 TNC grind, Vokey SM-5's;  56-14 F grind and 60-11 K grind
Putter: Scotty Cameron Kombi S
Ball: ProV1

Link to comment
Share on other sites

Awards, Achievements, and Accolades

Note: This thread is 2473 days old. We appreciate that you found this thread instead of starting a new one, but if you plan to post here please make sure it's still relevant. If not, please start a new topic. Thank you!

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


  • Want to join this community?

    We'd love to have you!

    Sign Up
  • TST Partners

    TourStriker PlaneMate
    Golfer's Journal
    ShotScope
    The Stack System
    FlightScope Mevo
    Direct: Mevo, Mevo+, and Pro Package.

    Coupon Codes (save 10-15%): "IACAS" for Mevo/Stack, "IACASPLUS" for Mevo+/Pro Package, and "THESANDTRAP" for ShotScope.
  • Posts

    • I did read the fine print tonight. It said replace with “similar features & function”.  8 yeas ago my purchase had features that today are available on the lower end models and the current version of my model has more “bells & whistles” than what I got 8 years ago.  So I am thinking they honored the agreement and I can’t argue the offer. since getting a credit for the full purchase price all I am really out over the past 8 years was the cost of the extended warranty, which was less than a low end  treadmill would have cost me. now the question is which model to replace with.  I’ll stay with Nordic Track or I forfeit the $1,463 credit so I will get Nordic Track.  And they honored the warranty and were not hard to work with which is a plus.
    • Generally speaking, extended warranties are a terrible deal and should almost always be avoided. They are a huge profit center for the companies that offer them, which should tell you almost everything you need to know about how much value most consumers get when purchasing them.  This is correct, and the old adage applies - only buy insurance when you can't afford the loss. This usually doesn't apply to most consumer goods.  To your second question, no I don't believe the offer is fair. They are replacing it, but it is not being replaced at "no cost to you". Since the amount being disputed (over $500) is non-trivial, I would probably push the issue. Don't waste your time on the phone with a customer service agent or a supervisor. They have probably given you all they have the authority to do. Rather, I would look at the terms of your agreement and specifically legal disputes. The odds are you probably agreed to binding arbitration in the event of a dispute. The agreement will outline what steps need to be followed, but it will probably look something like this.  1. Mail the Nordic Track legal department outlining your dispute and indicate you are not satisfied with the resolution offered.  2. Open up a case with the AAA (American Arbitration Association), along with the required documentation. 3. Wait about 4-5 weeks for a case to be opened - at which point someone from Nordic Track's legal department will offer to give you the new model at no cost to you.  They certainly don't want to spend the time and energy to fight you over $500. 4. Enjoy your new Nordic Track at no cost to you. I recently entered binding arbitration against a fairly large and well known company that screwed me over and refused to make it right. In my demand letter, I made a pretty sizeable request that included compensation for my time and frustration. Once it hit their legal department, they cut me a check - no questions asked. It was far cheaper to settle with me than to send their legal team to defend them in the arbitration.
    • I never thought of looking at it on multiple purchases like you said.  Yes, the extended may help me on 1 or 2 items but not the other 5 or 6.
    • Day 84 - Forgot to post yesterday, but I did some more chipping/pitching.    Back/neck were feeling better today, so I did a much overdue Stack session. 
    • Wordle 1,013 4/6 ⬛⬛🟩🟨⬛ 🟩⬛🟩⬛🟨 🟩🟩🟩⬛⬛ 🟩🟩🟩🟩🟩
×
×
  • Create New...

Important Information

Welcome to TST! Signing up is free, and you'll see fewer ads and can talk with fellow golf enthusiasts! By using TST, you agree to our Terms of Use, our Privacy Policy, and our Guidelines.

The popup will be closed in 10 seconds...