Anyone interested in a Mac Numbers "Strokes Gained Putting" worksheet? I'm going to polish up something I've been thinking about since I saw this tweet:

https://mobile.twitter.com/SwashPutting/status/558183245221621760

By simply logging the distance of 1st, 2nd, (and hopefully not 3rd putt), a wealth of information can be had. The rest of the post below shows some graphs and summary data. Apps like Game Golf, ARCCOS, and others should be able to implement this EASILY, but they don't yet. I don't know why not. It's not rocket science.

Ok, so away we go. First enter your data:

You need to only enter the stuff in the Putt 1/2/3 columns. The rest calculates itself. Including the little "grading" feature, with weakness and strength.

The calculations were made from Mark Brodie's analysis found on page 4 of his 2011 paper on the topic--> http://www.columbia.edu/~mnb2/broadie/Assets/putting_strokes_gained_20110113.pdf

If the data changes year to year, we can just edit this chart below (a separate table in the spreadsheet). I've interpolated some data to make it go foot by foot:

For every putt's initial starting distance, you gain or lose strokes based on the average the PGA player takes to putt from there. Nothing fancy so far.

The fun comes in looking at multiple rounds. Here are several rounds combined in graph form:

For this next graph, I plot strokes fewer than 30 against strokes gained putting by round. For my sample data, there's a correlation, but I don't think one necessarily exists. I used "30 putts" arbitrarily," so if you have 36 putts, that's a -6 value. If you putt 27, that would be +3 obviously. My data is made up, but I'll try to go back and enter real data from last season later.

Here's another one showing putts per round, average proximity from the hole, and length of putts made (again, sample data only- don't read anything into it):

Lastly, I'm working on showing more detail for each range of putt. For 8-10 feet, for example, just by entering that simple data above, you can get all of this information:

Make percentage from each range. Average miss (in feet) for each range- and miss % for each range, obviously. For each range, you'll know your average Strokes Gained Putting, so that you can see which ranges you are weak.

The trick with analyzing strokes gained putting by range though is that you can hit good distance putts, but if you stink at the 4-5 footers, it shows in the long range Strokes Gained Average as well. You have to temper the Strokes Gained Putting averages for each range, with the percentage makes at each range.

Since we have the Percent Made at each range for the pros, that can also be added to the graphs of your performance by range for comparison. Cool stuff.

This spreadsheet will be obsolete once the various tools out there start incorporating it. Why don't they do it now???? I see a huge benefit in benchmarking your own performance.

Send me a PM if you want a copy of the spreadsheet as is. I'm constantly tweaking it to add new graphs and functions, so it changes daily, bit by bit.

**The Grade System (for those interested)** (Click to show)There's a grade assigned on the first page of the spreadsheet- in case you wondered how it worked, here's the reference table that you can configure (this template started from the "GPA" template in Mac Number, and I didn't take some of it out yet- I thought the GPA thing was cool actually):