Jump to content
Check out the Spin Axis Podcast! ×
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

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


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

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

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


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

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


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

  • 3 weeks later...
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

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

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

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


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

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

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


  • 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

    • Day 280 6-9 low point control, practice missing towel. No ball, started to get the hang of hitting way in front of towel. Going to keep at it. 
    • Day 9 - (9 Jun 26) - Weekly nine hole session with my good friend, I played again from one set of tees up from my usual (set up the bag 4h, 6i-Pw, Gw, Lw) to focus more on iron play in the approaches (esp longer ones on the 4's and 5's).  Used the hybrid for tee shots only, had to play irons in from there on....made for a great work on course management and dealing with iron shots I normally don't see.  Key focus was on keeping ball in play, playing to distances that set up for either GiR or nGiR's.  Played a split nine (5 on the front, 4 on the back - the turn works nicely as both nines turn and run parallel coming in - easy to jump from 5 to 15 (especially when the course is not busy)).  Worked with my friend on his course management skills - offering thoughts as a "caddie" might and helping him to confidently choose and execute the shot he was seeing. 
    • Interesting that you post this - was playing today with my good friend in our typical weekly nine-hole round.  He has a lot of chatter in his mind, most of the time, yet today was much improved.  Yes, he went through a number of swing thoughts (like the ones highlighted), but then you could almost hear the switch click off - it was like when I shot the distance, and said its "X yards", he confidently said "this club should cover that..." and made his shot most of which were nicely rewarded.   Came away shooting one of his best nine-hole rounds ever.  For me, I do have thoughts  - not in terms of negotion but rather evaluation.  What is the wind doing?  Is there trouble - left, right, middle - not that I am a great fader or drawer of the ball?  Where is the better landing spot/zone?  What is my target window and what in the distance helps me see it?  I wonder if the "negotiation" is more about not understanding "typical distance for a given club (carry and roll)" and more about remembering how that flushed 5i that went and went or how the 4i that can get there with but not reliably or accurately.  
    • God I hate when golf can’t give me n+1 day of success. Drives me up the wall when my body is, FU! Im like, ok let’s check the vid. Yep too much turn, arms getting behind me. Ok, I work on that. Get the feel back for a shorter swing. Confirm with video. Then going back to arms down stuff.  Arms down, nope it’s hands out towards the ball. Oh, you get arms down better. Guess what, you don’t get to rotate and you hit 6 inches behind the ball. Yay!  Maybe I should have walked off the range and not wasted my time. I wish there was a body alert system when it’s going to a SOB for the day. 😭 OK rant over, I’ll be back at this tomorrow.   
    • Wordle 1,816 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.