Followers 0

# 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 on other sites

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

0

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

0

##### Share on other sites

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 on other sites

Yahoo has a golf handicap tracker, which I use -

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

0

##### 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 on other sites

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

0

##### Share on other sites

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

0

##### 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 on other sites

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

0

##### Share on other sites

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

##### Share on other sites

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 on other sites

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 on other sites

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 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 on other sites

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

## Create an account

Register a new account

Followers 0

• ### Topics Being Discussed Right Now on The Sand Trap

• #### What would a PGA Tour player shoot at your home course?

By dove694, in Golf Talk

• 114 replies
• 1,885 views
• #### Jr Tournament play?

By Cwmgr, in Rules of Golf

• 6 replies
• 72 views
• #### "5 Minutes Daily" Practice Challenge May 2016

By iacas, in Instruction and Playing Tips

• 309 replies
• 4,052 views
• #### Presidential Race 2016

By iacas, in The Grill Room

• 959 replies
• 16,046 views
• #### Memorial Day 2016

By DaveP043, in The Grill Room

• 3 replies
• 62 views

• Want to join this community?

We'd love to have you!

• ## 2016 TST Partners

• ### Posts

• What would a PGA Tour player shoot at your home course?
It's wwhatever he had in his mind as being a typical golf course. Your rebuttal is lame.  Most people score better on courses with which they're familiar. You know this. Yes it is. There's still a drop-off between the best players and the worst players on the PGA Tour, even if that drop has decreased quite a bit over the last 40 or 50 years. There's still a drop, and the OP specified middle-of-the-pack PGA Tour players - of which Graeme was not at the time. Players of all levels make more putts on faster, smoother greens, particularly shorter putts. This affects PGA Tour players a bit more because they're more likely to hit the line they intended to hit - a bump, then, is only going to increase the odds of a miss. Sorry, Drew. I don't just make this stuff up. Kinda matches what Dave said.
• Jr Tournament play?
In the junior events I officiate (including the Dustin Johnson World Junior, PGA Section Junior Championship and The George Holliday), parents are not permitted off the cartpaths. Also, any communication between parent and player may be consider a Rule 8 (advice) violation. This is on the AJGA hardcard. As for relief from roots, the Decision (33-8/8) Q.May a Committee make a Local Rule providing relief without penalty if a player's stroke is interfered with by exposed tree roots? A.A Local Rule is authorized only if an abnormal condition exists. Generally, the existence of exposed tree roots is not abnormal. However, if the exposed tree roots are encroaching on to the fairway, a Committee would be authorized to make a Local Rule providing relief under Rule 25-1 for interference from exposed tree roots when a ball lies on a closely-mown area. The Committee may restrict relief to interference for the lie of ball and the area of intended swing. was recently revised to authorize committees to give relief for roots in closely mown areas ONLY. Prior to that there was no relief at all.
• "5 Minutes Daily" Practice Challenge May 2016
Spent about 30 minutes at the short-game practice area at the course, practicing chipping.
• Presidential Race 2016
"When the people find that they can vote themselves money that will herald the end of the republic" -Benjamin Franklin-
• What would a PGA Tour player shoot at your home course?
Not crazy about I know a guy who knows a guy anecdotes but I know a guy that went to high school with Steve Jones, 8 tour wins including a major. He's not just a guy he's my office assistant's hubby. They still hook up for a round here and there when Steve is around and have since they were HS buddies. He said SJ's score were/are always under par but vary.