Putting Statistics

Because of my recent terrible putting, I decided to keep track of every putt to see what I can see about it. Here’s how I compiled the stats.

I wrote down how many paces each putt was and assumed one step was 2.5 feet. The Made formula in the table is

For that date and hole, see if there’s a putt with a higher number. If not, I must have made that one. The Left formula is

Same as the last except that it sums the length of the putt that’s one higher. Over in the stats table, I use these formulas

Made:

If it’s greater than or equal to the first number and less than or equal to the second number and I made it, count it.

Made %:

Take the number made and divide it by the total putts in that distance range. The IFERROR is for divide by zero errors.

Avg Left:

This sums all the “Left” numbers for putts not made and divides by the number of putts not made.

Max Left:

This one’s an array formula, so enter with Ctrl+Shift+Enter, not just enter.

In retrospect, I should have noted putts that went past the hole as negative distances and putts that were short of the hole as positive distances. I could have got the same stats as above plus I would know if I had a tendency to be short or long. It feels like enough bookkeeping for the golf course already, but maybe I’ll implement that change in the future.

So, what did I learn? I learned that I like numbers and statistics, but I don’t think I learned anything useful for my golf game.

You can download PuttingDistance.zip