Jump to content
Check out the Spin Axis Podcast! ×
Check out the Spin Axis Podcast!
IGNORED

Golf Handicap Calculator

lsu70510

By lsu70510
in Golf Talk

 Share
Note: This thread is 3277 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

lsu70510 Member

lsu70510

Posted
Posted

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


mdl Great Member

mdl

Posted
Posted

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˚

Awards, Achievements, and Accolades
1

tristanhilton85 Great Member

tristanhilton85

Posted
Posted

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: 
Titleist TSR2 Driver (Fujikura Pro 2.0 TS; 10.5°) · PXG 0211 FWs (Diamana S+ 60; 15° and 21°) · PXG 0211 Hybrid (MMT 80; 22°) · Edel SMS Irons (SteelFiber i95; 5-GW) · Edel SMS Pro Wedges (SteelFiber i110; 56°, 60°) · Edel Classic Blade Putter (32") · Maxfli Tour Ball · Pinned Prism Rangefinder · SuperStroke Grips · Flightscope Mevo · TRUE Linkswear Shoes · Vessel Player V Pro 

Awards, Achievements, and Accolades
1
1
1
1
1
1
1

sacm3bill Great Member

sacm3bill

Posted
Posted


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


turtleback Super Member

turtleback

Posted
Posted


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

Awards, Achievements, and Accolades
1

sacm3bill Great Member

sacm3bill

Posted
Posted


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


lsu70510 Member

lsu70510

Posted
  • Author
Posted

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


  • 2 years later...
tristanhilton85 Great Member

tristanhilton85

Posted
Posted

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: 
Titleist TSR2 Driver (Fujikura Pro 2.0 TS; 10.5°) · PXG 0211 FWs (Diamana S+ 60; 15° and 21°) · PXG 0211 Hybrid (MMT 80; 22°) · Edel SMS Irons (SteelFiber i95; 5-GW) · Edel SMS Pro Wedges (SteelFiber i110; 56°, 60°) · Edel Classic Blade Putter (32") · Maxfli Tour Ball · Pinned Prism Rangefinder · SuperStroke Grips · Flightscope Mevo · TRUE Linkswear Shoes · Vessel Player V Pro 

Awards, Achievements, and Accolades
1
1
1
1
1
1
1

  • 3 weeks later...
14ledo81 Super Member

14ledo81

Posted
Posted
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

Awards, Achievements, and Accolades
1
1
1

David in FL Incredible Member

David in FL

Posted
Posted
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

Awards, Achievements, and Accolades
1
1
1
1
1

saevel25 Incredible Member

saevel25

Posted
Posted

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:

Awards, Achievements, and Accolades
1
1
1
1
1
1
1
1

flopster Great Member

flopster

Posted
Posted

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


14ledo81 Super Member

14ledo81

Posted
Posted
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

Awards, Achievements, and Accolades
1
1
1

David in FL Incredible Member

David in FL

Posted
Posted
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

Awards, Achievements, and Accolades
1
1
1
1
1

Note: This thread is 3277 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
 Share
Go to topic listing


  • Want to join this community?

    We'd love to have you!

    Sign Up

  • TST Partners

    Carl's Place
    PlayBetter
    Golfer's Journal
    ShotScope
    The Stack System
    FitForGolf
    FlightScope Mevo

    Coupon Codes (save 10-20%): "IACAS" for Mevo/Stack/FitForGolf, "IACASPLUS" for Mevo+/Pro Package, and "THESANDTRAP" for ShotScope. 15% off TourStriker (no code).

  • Posts

    • RetiredOldMan
      Too Old?

      By RetiredOldMan · Posted

      StuM,  I have, in the past, added a left handed club. (Ususally a 7 iron) However, I usually take a stroke penalty and move the ball to where I want it.  I play for fun and in a pinch can use theback side if my club if I don't want the penalty stroke.    RetiredOldMan,  Terry 
    • saevel25
      Brendan Sorsby Sports Betting

      By saevel25 · Posted

      So, Brendan Sorsby, Texas Tech transfer QB, was found guilty of sports betting by the NCAA. He admitted to it. He placed thousands of bets over multiple years while at Indiana and Cincinnati. This included betting on his own teams.  The NCAA rules ban athletes from betting on any sport (college or pro).  A retired visiting judge from Tarrant County, Texas has put an injunction on the NCAA ruling. He is a visiting judge because the first judge was a graduate and big fan of Texas Tech, and he recused himself. The judged ruled the following... "Under Curry's order, Sorsby is permitted to play for Texas Tech's 2026 season on the condition that he continues his treatment for a gambling and anxiety disorder and serves a two-game suspension (missing games against Abilene Christian and Oregon State)."  Don't get me wrong, I don't particularly care for the NCAA. That still doesn't mean that a college can choose when or where to say, "Yea we agree to these rules for all our sports, well except in this case." Here is a breakdown from S&W. The Hidden Weapon in Sorsby’s Injunction: How a Lubbock County Court Order Quietly Neutralized the NCAA’s Most Powerful Enforcement Tool - Law Offices of Snell & Wilmer By Ryan J. Regula On June 8, 2026, Lubbock County District Court Judge Ken Curry issued a temporary injunction in Brendan Sorsby v. National Collegiate Athletic Association, Cause No. DC-2026-CV-0791 (99th Judicial District... The main judgement made sense. Sorsby, I am going to have all this harm done to me if I don't get to play. The Judge, I agree. The penalty for gambling is too harsh, so here are all these things you must do, and I will grant this injunction against the NCAA. Basically, an analogy would be when a person goes into court for a DUI and they agree to all these other things to not end up in jail.  What sucks for the NCAA is the NCAA has appealed to Texas’ Seventh Court of Appeals, based in Amarillo. All four justices that preside over the court are graduates of Texas Tech University School of Law. It would be hilarious if all four of them had to recuse themselves 🤣. For those who like to read legal rulings...  
    • StuM
      Swing Thoughts & Mental Game

      By StuM · Posted

      The chatter in my brain is when the distance is between clubs since I am pretty weak at shortened backswings, etc. I try to simply decide if being long or short is the better outcome and choose my club based on that and simply not even try for the “real” distance.  For me a full normal swing is what I strive for.
    • saevel25
      Swing Thoughts & Mental Game

      By saevel25 · Posted

      I saw this comment made in a golf article... "Most golfers stand over a 4- or 5-iron still negotiating with themselves. They think about how hard to swing, whether they have the right club, if they have the aim correct and more. It’s a lot to deal with and long irons punish the “half-in” golf swing." I am not sure the "most golfers" is correct regarding the bolded part. I can understand if there is a bunker, water, and/or OB that a lot of golfers would be fixated on that. I am not sure that leads to ending up more times there. Pending your level in golf, the variance is so large in outcomes, it could be just with in the expected outcomes. I can understand if have a big lake on the right side of the hole being one of the most terrifying shots for right-handed amateur golfers.  I am not sure many golfers are standing over the ball talking to themselves, "Ok, maybe I should step back and pull the 4-iron. Am I lined up right? Oh, the wind came up, should I swing harder? What am I going to have for dinner tonight, maybe steak. (Joking, somewhat 😛)" A question is that how much chatter do you get while standing over the ball. Are you questioning the everything about your golf shot?   
    • coachjimsc
      Wordle Daily Puzzle

      By coachjimsc · Posted

      Wordle 1,816 5/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.

  I accept