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
=SUMPRODUCT(([Date]=[@Date])*([Hole]=[@Hole])*([Putt]=[@Putt]+1))=0
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
=SUMPRODUCT(([Date]=[@Date])*([Hole]=[@Hole])*([Putt]=[@Putt]+1)*([Length]))
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:
=SUMPRODUCT((tblPutts[Length]>=I3)*(tblPutts[Length]<=J3)*(tblPutts[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 %:
=IFERROR(K3/SUMPRODUCT((tblPutts[Length]>=I3)*(tblPutts[Length]<=J3)),0)
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:
=IFERROR(SUMPRODUCT((tblPutts[Length]>=I3)*(tblPutts[Length]<=J3)*(NOT(tblPutts[Made]))*(tblPutts[Left]))/SUMPRODUCT((tblPutts[Length]>=I3)*(tblPutts[Length]<=J3)*(NOT(tblPutts[Made]))),0)
This sums all the “Left” numbers for putts not made and divides by the number of putts not made.
Max Left:
{=MAX((tblPutts[Length]>=I3)*(tblPutts[Length]<=J3)*(NOT(tblPutts[Made]))*(tblPutts[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
