Keep Stats

[Parker0065]

Here is an attachment of the XL file I use to keep my stats. If anyone is interested in using something like this I can make up some user instructions. Some of it is automated but some of the data has to be entered in certain places.

[Silvertree]

I started Par-formance journals a few rounds ago. I am undecided at this point, but so far I like the amount of information I am recording.

[sonicblue]

Here's what it does:

Each line records the course, date, rating and slope. You enter your scores as a five digit number, namely: Par - Score - Putts - FH - GIR. An entry of "45210" would indicate:

Par = 4
Score = 5
Putts = 2
FH = Yes (1 = yes, 0 = no)
GIR = No (1 = yes, 0 = no)

From there, the stats I have right now are: Score, GIR %, PPGIR, PPMGIR, Scrambling, Driving, # subpar, # bogies, # worse. For all these stats, I also have the cumulative number, bests in each category, and the stats you achieved in each during the best (lowest scoring) round. Lastly, it computes your USGA handicap (though I ignore the 5-round minimum) based on both the formula-# of rounds, and all rounds (just so you can see how the requirement of using "X # of best rounds" affects your index).

It's an early draft but I wanted to post it anyway. Feel free to post comments, suggestions, critiques, etc.... I can do pretty much anything with a spreadsheet, so I can refine and add, but I also want to keep it pretty compact. It only has 40 rows right now in order to stay under forum file size limits. I have a sample round loaded in as an example of how to fill it out. Hope it's helpful.

[Thrdroc]

Its good just overly complicated. I would have just made rows for each category that you wanted instead of having 5 numbers in each box. That way if you play the same course a lot you can easily see what your trouble holes are.

I don't know if you are planning on giving this to other people to use or this is is going to stay as a personal sheet but other people will certainly get confused with your methodology.

[sonicblue]

I agree the methodology is different, but I don't see it as all that complicated. The five digits is exactly how it would read down a column on my scorecard (par on the card, my written score/putts, then a check mark for FH and GIR). Having 18 slots for each category makes for lots of columns and lots of scrolling; putting the five sections in a block makes it very hard to aggregate as well as add subsequent rounds.

It's here to be used, I'm not trying to mass market or anything. Hopefully, some people who don't have anything else will find it useful for the basic stats it has.

[Thrdroc]

Well since its yours it will never look complicated or hard to understand.

The only thing I would add to improve it would be par 3, par 4 and par 5 performance.

[lamebums]

Here's what it does:

If you can add this - add in a thing that calculates the percentage of fairways and greens hit.

[DBake]

Well since its yours it will never look complicated or hard to understand.

I agree hole performance's and green/fairway percentages can give a person a lot of information.

[plus4]

Each line records the course, date, rating and slope. You enter your scores as a five digit number, namely: Par - Score - Putts - FH - GIR. An entry of "45210" would indicate:

I didn't open your file because I don't know where it's been

, but from one Excel "guru" to another, I'd recommend placing each specific type of data (each stat/shot) in its own column. The data entry is still pretty simple, plus this will allow you to generate any statistic you want, as well as do all kinds of sorting, pivot tables, etc. in an efficient manner. I have a pretty detailed spreadsheet that I record my rounds in. It's amazing what you can learn about your game by analyzing your stats. For anyone that doesn't want to bother with a spreadsheet, Intelligolf is probably the best product out there, for the money, that I've seen or used. It will tell most golfers more than they'll ever want to know about their game.

[sonicblue]

Update: OK, here's the deal:

"ENTER CARD" tab: A straightforward, each number in its own cell, entry sheet. Course name, date, rating, slope, and hole-by-hole par, score, putts, FH, GIR.

"VIEW CARD" tab: Select the round from the grey drop-down (shows Course - Date). I loaded in a handful of samples. It shows a "nice" score card, with highlights for FH/GIR, pars, subpars, bogeys/worse, etc... Also shows total score, differential for the round (and rank thereof), and cumulative USGA index. Lastly, a host of stats are shown at the top, for:

* that round
* your best in each category
* the stat for that category in your lowest round

Categories are: Driving, GIR, PPGIR, PPMGIR, Scrambling, Par 3 avg, Par 4 avg, Par 5 avg.

File is uploaded to my web host, as I expanded it to allow 100 rounds, and it exceeds forum limits.

Right-click, Save-As . There is a macro, a simple copy-paste. You may need to explicitly enable macros. plus4 - feel free to disable them, crack it open and verify it's safe

[ndredsox]

Hey thanks for this!! I did something like this, but made one for each course I played. I scanned the layout off of the scorecard and made my own little yardage/score book.

[Newbie Collection Agency]

Wow this excel program is really nice.

I've tried to make one but I'm not as advanced in excel as you.

It's also very nice that you share it...thank you.

If you wanted to help me.... ..you could make it so that you can scores per 9 holes as well. I don't get to play 18 very often.

Also if there was a way for the program to remember golf course data. Where I pick a course and the info is displayed. I.E. Frount 9 Back 9, distances par ect.

Thanks again for sharing.

[sonicblue]

Good ideas, it all sounds feasible. I'll see what I can do.....

[sonicblue]

bump - now with 9-hole capability. The course data thing is harder than it seems in Excel (I'm trying to do an Access version, where something like that is much simpler, but the other stuff is more complicated!). Also, I ditched the "Bests" stats, saved file space and didn't think it was really that useful.

Right-click, Save-As .

[Bluenoser67]

I keep all my stats on an Excel Document. Have been since 2004. There are a couple of reasons I think this is better than any of the web based stat trackers.

1. I can maniputate the data what ever way I want. If I want to know how often I 3 putt the 15th hole of my home course I can strip down my data and determine that.

2. I am the host of my own data. My concern with web based stat trackers is that I wake up some day and go to put my data in the computer and the site is persona no grata and so is the last 5 years of my golf stats.

Attached is my simple spreadsheet. All you have to enter is the score of the hole the Shots to green and Fairways hit and the spreadsheet will calculate everything else for you. (please note you will have to change the par for each of your course holes to match the course your playing)

Enjoy

[Crafty]

I keep a small composition notebook in my car. After my round, I write down my score, faiways, greens, putts, and up&down; stats for each hole on I sheet that I made. I then write down two strenghts and weaknesses about the round. Then, at the end of each month(roughly), I look back and average the stats of my previous rounds. I also look at the strengths and weaknesses for reoccuring patterns. I prefer to do it this way because I don't have to spend oodles of time putting in unecessary information on a software program, and it gives me direct and simple feedback.

[sboardz006]

i keep mine. last year i used the golf digest handicap thing to do it. prob try out the golf channel one this year

[mikelz]

I have never found a stat book that allows you to enter how you hit each of your 7 shots getting to the green. I don't keep any.