Additional Tips for Collecting and Entering Hole Data
Golfer Tracker for Excel Lite is able to analyze and report on a plethora of
statistical information about each round of golf, but only requires a
few pieces of
information in order to accomplish that goal. As an avid golfer and developer of
the program, I've been testing/using it for two years and have entered well over
100 rounds into the program by collecting just a few pieces of information for
each hole on a blank scorecard. This is the information I collect:
- Location of tee shot (FW, FC, R, B, PA, OB).
- Drive distance on par 4's and par 5's (this is optional).
- Location of 2nd shot on par fives (FW, FC, R, B, PA, OB)
- Location of Approach shot (G, FW, R, B, PA, OB).
- Distance of your first putt on the hole.
- Distance of the putt you made to finish the hole.
There's no reason to get too precise with drive and putt distances.
Drive distance is optional but it can easily be estimated using your
distance to the green after your drive. You can become very good at
estimating putt distance by pacing off a few putts over the course of a
couple rounds. Once you've paced off a few putts,
you'll be amazed how good you become at estimating your distances.
For rounds on courses I know well, I can recreate most of this information
from memory. However, I typically keep a scorecard to track the
information. I usually remember where I hit each shot from, so in some cases
I go on Google Maps after the round, turn on the satellite layer, zoom in all
the way on the course I played and use the Measure Distance function to measure
the distance to the hole or the distance of some longer putts. I've recreated complete rounds from memory just by
doing this.
Here are a few more tips that will help you out.
- Don't agonize over distances and collecting every bit of data. Make your
best guess and move on. Use Google maps to measure distance feature with the
satellite layer turned on and zoomed all the way in to get better estimates
if you need them.
- Don't worry about capturing all your shots on blow-up holes. Just record
your tee shot, an approach, and whatever you did around the green. The
program also provides a "No Approach" option so you can skip
recording your
approach shot on a hole. This is especially useful for punch out shots where
you didn't really have an approach shot. It is best not to record a punch
out shot as an approach unless you had a legitimate chance to get it on the
green.
- Don't bother recording shots that are complete statistical
outliers. You'll have so much data that ignoring a few shots won't
matter. For example, suppose you hit a good drive, completely top
your 2nd shot and then hit a good approach shot onto the green. Just
record your drive, your approach and whatever shots you played on
and around the green. If you hit the green with your approach,
select the green for the location but uncheck the Green in
Regulation box. You can still record the correct score for the hole
but there's no value in recording a shot you completely topped, or
whiffed. This is true for tee shots also that you might completely
muff. For example, say you top your tee shot on a par 5 and it only
goes 25 yards, then pull out 5-wood and hit it 230 down the middle.
Just record the 5-wood shot for your tee shot, ignore the topped
drive, and record your 3rd shot for your 2nd, etc.
- The program doesn't care how many holes you played so if you just sneak
out and play 4 or 5 holes, you can easily record them in the program and the
data will be saved and included in your reports. Or, if you play a few extra
holes after your 18 hole round, record the extra holes as another round with
however many holes you played. The more data you enter, the better.
Managing Rounds
Creating Reports
Visit Checkbook on Facebook
Visit Handicap Manager on Facebook