Getting Started

• What to Track
• Turning on Macros
• Entering Data
• Viewing and Comparing Stats

What to Track

You can enter any of the following information into the spreadsheet:

• Scores - Your total strokes on each hole.
• Putts - Your total strokes taken on the green. This is not related to what club you use. Putting from the fringe is not considered a putt.
• Fairways Hit - Whether you hit the fairway or not. You may also keep track of which side you miss on too.
• Drive Length - Distance hit on your tee shot. Use a laser rangefinder or GPS device that measures your drive length directly or calculate it from your approach distance remaining. The PGA Tour keeps drive length stats on one predetermined hole per 9.
• Approach Distance - Distance left to the green. If you don't have a device to measure your drive length, this is used in combination with the hole length to calculate your drive length. Only record this on straight holes. On holes with doglegs your actual approach distance depends more on how much you cut the corner then your drive length. The PGA Tour keeps drive length stats on one predetermined hole per 9.
• Sand Saves - When you're in a greenside bunker and how often you get up and down (or hole out). An up and down is considered taking one shot to get up to the hole and one shot to get down in the hole. This is not related to the score made on the hole.

You do not have to track everything however what you put in affects what stats you get out of it. I recommend at least tracking your scores and putts for each hole. If you only keep track of your scores, you only get a handicap and average scoring stats. In addition to putting stats, tracking putts gives you stats such as GIR and scrambling. I just write down scores and putts and enter the rest in from memory. If you don't think you can remember them then form a short hand system for writing them on the card as you go.

Turning on Macros

This sheet uses macros to make adding new rounds and courses easier. The macros copy and paste a blank round or course to the next opening with a single keyboard shortcut. To enable macros in Excel:

1. Go to Tools > Macro > Security.
2. Select Medium and click OK.
3. Restart Excel for the setting to take effect.

Now when opening any file with macros you are prompted whether you want to enable them or not. If you do not wish to enable macros you need to copy and paste blank rounds manually.

Entering Data

To get started add a course to the courses sheet.

1. Press Ctrl+Shift+C. A blank entry for a course appears. (If you have macros off see the manual copy section)
2. Enter a name for the course in the cell above the word Hole.
3. Enter the course rating and slope to the right of each. The first two cells are for the front nine and back nine and that last cell is for the full 18. Overwrite the calculation of the front nine and back nine if you have ratings for the individual nines. The calculation halves the 18 hole course rating and uses the same slope. Only use it if individual nine hole ratings are not available. Course ratings and slopes are usually found on the score card. Also check the USGA Course Rating Database. They are different for each set of tees so use the rating for the set of tees you are playing from.
4. Fill out the Handicap, Yardage, and Par information for each hole. Use the yardage for the set of tees you are playing from. Totals are automatically calculated.

Next add a new round.

1. Press Ctrl+Shift+R. A blank entry for a round appears. (If you have macros off see the manual copy section)
2. Fill in the following fields across the top:
   • Date - Date the round was played.
   • Course Number - The number for the course displayed on the courses sheet.
   • Match Outcome - Win, Loss, Tie, or blank if no opponent was played.
3. If the round was only 9 holes delete the numbers and totals for either the front or back 9, whichever you didn't play. Do not delete anything below the sand saves line as these lines calculate some of the stats for the round.
   
4. Fill in some or all of the following rows depending on what information you tracked in your round:
   • Score - Score on each hole.
   • Putts - Total putts on each hole.
   • Fairways Hit - 1 for a hit, 0 for a general miss, or L / R for the side missed. Leave blank for par 3's.
   • Drive Length - Distance hit on tee shot. Enter yardage directly if you have a laser rangefinder or GPS device that measures drive length. This overwrites the formula for calculating it from approach length.
   • Apch Length - Distance left after tee shot. Enter if you don't have a device to measure your drive length. Leave blank on holes with doglegs since distance varies based on how much you cut the corner.
   • Sand Saves - 1 for a sand save, 0 for a failed save, or blank if not in a greenside bunker.

The rest of the rows are automatically calculated based on the information you provide.

For more information on what each row means see the scores sheet reference.

Viewing and Comparing Stats

Switch to the stats sheet to view your stats. Once you have more then one round in you can change which round(s) you are viewing stats for by entering numbers next to the rounds field. For more information see the stats sheet reference.

Another feature you can use when you have more then one round in is the compare sheet. This allows you to compare your stats in one set of rounds to another. For more information see the compare sheet reference.

You can also compare the stats sheet of one file to another. For more information see the compare files sheet reference.

That's a basic run through of everything you need to know to get started. For more information about anything that appears on a sheet see the reference page. If you have any questions, comments, or suggestions please feel free to contact me.

Back to Golf Stats Tracker Home Page