Scoring Analysis

Aztecs27

Money List Winner
Joined
May 26, 2010
Messages
8,823
Location
Gloucester, UK
Visit site
Kind of a follow on from the stats thread, but a mate of mine has devised a spreadsheet so he can record his scores round his home club this season and he helped me do one for my home club.

It's fairly simple and I think will be a handy tool for the upcoming season.

So far it's got two worksheets, one for recording the score which calculates the average for each hole over the season as well as giving you scores that are nett of your handicap and nett average scores over the season.

And the other records the number of putts per hole. I have set the "par" for number of putts at 2 per hole. I know this is only the ideal number if you're hitting GIR, but it gives something to work on, and also gives an average per hole over the season.

It automatically colours the cell white, black, blue or red depending on whether you par, birdie, bogey or blob a hole and having put in the info for just one round thus far, it's highlighted some things for me:

- I had 7, count them SEVEN 3 putts on Sunday. Which, quite frankly, is not good enough. You're never going to post a decent score doing that. Turn those into two putts (which the majority of them should have been to be honest) and all of a sudden things are looking up.

- 4 of those 3 putts were on holes that left me with a bogey, meaning I had a chance to putt for par, and should have taken them.

- If I turn my brain fart holes into double bogeys, I'm actually 23 over, which, although still not where I want to be, is on the right track.

All of a sudden, you can see the positives and the negatives very clearly and isolate them and see where it is that needs work.

Slightly more encouraged now....Off to the range I go. :)
 
I've written one that analyses every round on the three courses I play regularly. I also enter in each shot I play and rank it good/quality miss or poor. Then I can chart by club and situation where I am struggling.

I do the same on the range with 5 x 10 shots from different clubs also scoring good/quality miss/poor.

Got the idea from talking with Graeme McDowell's coach Karl Morris and simply added my EXCEL skills to make it happen.

Still need to get a life though.
 
Right, how much you looking to make me one for my home course?


:D

PM me and I'll do you one for nothing. Not difficult at all!

You sir, are a legend! PM on the way!

For the record, I'd have done one for free as well! But I just took longer to reply! :D

Anyone willing to share a copy of theirs to see what stuff I can add to mine? (Paul, I'm looking at you! ;))
 
You can do this through www.howdidido.co.uk if your club is registered.
all you have to do is embellish your score after each round. It will ask what you did after each shot ie- hit fairway, hit green , hit rough etc .
then you have stats for for driving accuracy, greens in reg, putts per round, and what your results on certain holes for the season are.
 
You can do this through www.howdidido.co.uk if your club is registered.
all you have to do is embellish your score after each round. It will ask what you did after each shot ie- hit fairway, hit green , hit rough etc .
then you have stats for for driving accuracy, greens in reg, putts per round, and what your results on certain holes for the season are.

Yes you can...Our club isn't registered with HDID though :(
 
It's finished. It's nothing too exciting but will calculate your average score on each hole, the number of pars, eagles, birdies, bogeys etc.

Enter the putts and it will track your putts on each hole too.

If anyone wants it, just drop me a PM with their address and I'll send it over.
 
My stats are kept by my Golfshot GPS app on my iPhone. I find that I am more likely to input them, as you do it at the end of each hole. Only takes about five seconds.
 
Top