Reference Page
Scores Sheet

On this sheet you enter the rounds you play. To add a round, push Ctrl+Shift+R. If macros are off see the manual copy section. Add as many rounds to the sheet as you wish.
Each section is explained below. Editable fields are in bold.
- Date - Enter the date the round was played.
- No. - Round number, automatically calculated.
- Course - Enter the course number. Use the number given to the course on the courses page.
- Course Name - Automatically displayed once you enter a course number.
- Holes - Automatically calculated based on number of scores entered.
- Match - Enter Win, Loss, Tie, or leave it blank. This keeps track of your record when playing against someone.
- HCP - Your USGA handicap index at the time the round was played, automatically calculated.
- Two nine hole rounds are combined into 18 holes and conted as one round when figuring your handicap
- Once you have at least 5 counted rounds your handicap index is displayed in cell B3 of the stats sheet.
- If you don't have a handicap index yet the USGA rules state to use the maximum handicap of 36.4.
- Course Handicap - This is displayed to the right of the handicap index. This is calculated based on your handicap index and the course rating and slope for the course. The course handicap is the number used to subtract from your score to find your net score. It is also used to calculate ESC.
- ESC - Equitable stroke control is the maximum number of strokes you're allowed to take when figuring your handicap. It is based on your course handicap for the round. Below this your adjusted round score is displayed.
- Handicap Differential - This gives you a rough idea of how the round affects your handicap if it is used. The lowest of these are averaged to find the handicap index. How many are used depends on how many rounds are entered. Nine hole rounds are combined to form one 18 hole handicap differential when calculating the handicap index.
- For more information about how the handicap system works see The USGA Handicap System Manual.
- Par - This is automatically calculated based on the scores entered and the pars entered on the courses sheet. They are automatically colored: blue for over par, gray for even par, and red for under par.
- Score - Enter your scores for each hole on this line. Totals are automatically calculated.
- Putts - Enter your putts for each hole on this line. Totals are automatically calculated.
- GIR Putts - The number of putts you make on holes you hit the green in regulation. This is automatically calculated.
- Fairways Hit - Enter a 1 for a hit, 0 for a general miss, or L / R for the side missed. For par 3's leave it blank.
- Drive Length - Enter your drive length here if you have a laser rangefinder or GPS device that measures your drive length. This overwrites the formula for calculating it from approach length. Otherwise this is automatically calculated by subtracting the approach length from the total length of the hole. The PGA Tour keeps drive length stats on one predetermined hole per 9.
- Scrambling - This is automatically calculated. If you missed the green in regulation you
receive
either a 1 or 0 depending on whether you saved par or not.
- GIR - The number of shots allowed to hit a green in regulation is par minus two strokes for putts. It is automatically calculated by subtracting the putts from your score and adding two. The difference between the result of this and par is displayed. If it is 0 or less it is a green in regulation. If it is more than 0 it is a green missed. In the special case that you putt the ball off the green, you need to overwrite the calculated value. Subtract one from the displayed GIR number for every stroke taken after you hit the green that was not a putt. Overwrite the displayed number with the result.
- Apch Length - Enter this for holes that are straight. 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. On holes with doglegs your actual drive length depends more on how much you cut the corner off. The PGA Tour keeps drive length stats on one predetermined hole per 9.
- Sand Saves - If you were in a greenside bunker and got up and down enter a 1. If you failed to get up and down enter a 0. If you were not in a greenside bunker leave it blank. This stat does not depend on whether you made par or not, only if you got the ball in the hole in two strokes or less from the bunker.
- White Space - The white space around the scores is used for calculating various stats about the round. It is in white so it doesn't clutter up the view of the round. If you change or clear one of these cells some of the stats for the round may become incorrect.
- The text and numbers to the right of the first few rounds is where the stats over all rounds are calculated. This information is then used by the stats and compare sheets.
Courses Sheet

On this sheet you enter the courses you play. To add a course, push Ctrl+Shift+C. If macros are off see the manual copy section. Enter as many courses as you wish.
Each section is explained below. Editable fields are in bold.
- Name - Enter the course name here.
- Number - Course number, automatically calculated.
- Course Rating - Enter the course's course rating here. 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. Only use the calculation if individual
nine hole ratings are not available. Course ratings 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.
- Slope - Enter the course's slope rating here. 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 slopes for the
individual
nines. The
calculation
uses the 18 hole slope. Only use the calculation if
individual
nine hole slopes are not available. The slope is usually found on the score card. Also check the USGA Course Rating Database. It is different for each set of tees so use the rating for the set of tees you are playing from.
- Hole - Hole Numbers.
- Handicap - Enter the handicap for each hole. This is
usually
found on the score card.
- Yardage - Enter the length of each hole. Use the yardage for the set of tees you are playing from. Totals are automatically calculated.
- Par - Enter the par for each hole. Totals are automatically calculated.
Stats Sheet

On this sheet view your stats for a single round, group of rounds, or all rounds combined.
Rounds - To enter a specific range of rounds, enter the first round to include in cell C1 and the last round to include in cell E1. Leaving the cells blank is the same as setting them to the first round and last round
respectively.
If you do not enter the information required for a stat it displays as 0 or in some cases "#DIV/0!".
General
- USGA Handicap Index - This is your USGA
Handicap
Index based on the rounds entered.
- A handicap requires at least 5 rounds entered. Until then it displays "#N/A". Two nine hole rounds are combined and only count as one round. Your handicap differentials for each round give you an idea of your handicap until you have 5 rounds. For more information about how the handicap system works see The USGA Handicap System Manual.
- This stat is not affected by changing the number of rounds counted.
- Match Record - This is your Win-Loss-Tie record based on what you enter next to the match field of each round.
- Rounds Finished - The number of rounds entered on the scores sheet.
- Per 18 - The total holes played divided by 18. This number is used for other "per round" stats to stay consistent as 18 hole stats even when you only play 9.
- Avg Holes - The average number of holes played per round.
- Holes Played - The total number of holes played.
- Distance Played - The total distance played given in yards and miles. This is based on the yardages you enter for each hole on the courses sheet.
Stats
- Driving Accuracy - How often you hit the fairway off the tee.
- Left Miss - How often you miss the fairway left off the tee.
- Right Miss - How often you miss the fairway right off the tee.
- Driving Distance - How far you hit the ball off the tee. Based on the data you enter for approach distance remaining.
- GIR - How often you hit the green in regulation. (Regulation is par minus two strokes for putts)
- To Par - What your score is in relation to par for all holes you hit the green in regulation.
- Per Hole - What you average score to par is on hole you hit the green in regulation.
- Birdie Conversion % - How often you convert a birdie after hitting the green in regulation.
- Ball Striking - How often you hit both the fairway off the tee and the green in regulation on a hole. On par 3's only hitting the green in regulation is required.
- Scrambling - How often you save par after missing a green in regulation. (The attempts stat is how many times you've missed the green in regulation.)
- Scram Conversion % - How often you convert a par putt after missing the green in regulation. (The attempts stat is how many times you missed the green in regulation by one stroke and therefore attempted a putt to save par.)
- Sand Saves - How often you get up and down from a greenside bunker. An up and down is 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.
- Chip Ins - How often you chip the ball in. (figured as number of 0 putts)
- Bounce Back - How often you bounce back with a birdie (or better) after making a bogey (or worse).
- Streak Avoidance - How often you avoid following one bogey (or worse) with another.
- All Putts - Average and total putts for all holes played.
- GIR Putts - Average and total putts on holes in which you hit the green in regulation. This is a more accurate measure of your putting because it
eliminates
the times when you chip it up close and one putt.
- 3+ Putts - How often you 3 putt (or worse).
Course
- Course Average - The average length and par of the courses you've played.
- Hole Average - The average length and par of the holes you've played.
- Stroke Average - The average length you hit each stroke (including the 300 yard drives and the 2 inch putts) and the average length stroke required to play par golf.
Scoring
- Total Scoring - Total strokes taken, aggregate and in relation to par.
- 9 Hole Scoring - Average and best 9 hole rounds, aggregate and in relation to par. 18 hole rounds are counted as two 9 hole scores.
- 18 Hole Scoring - Average and best 18 hole rounds, aggregate and in relation to par. For average stats all 9 hole rounds are included as half a round. For best rounds only complete 18 hole entries are accepted.
- Par 3, 4, and 5 Performance - Average and total performance on par 3's, 4's, and 5's.
- Birdie and Par Percentage - How often you make birdie or better and par or better on par 3's, 4's, and 5's.
- Hole Difficulty - Average score per hole on the hardest, middle and easiest third of holes in each round. This is based on the handicaps given for the holes on the courses sheet.
- Albatrosses, Eagles, Birdies, Pars, Bogeys, Double Bogeys, Triple Bogeys, Others, Par Breakers, Par or Better, and Holes in One:
- Percent - How often you make that score.
- Total - Total number of that score made.
- Holes per - The average number of holes that go by before making another one.
- Per Round - How often per round (18 holes) you make that score.
- Par Breakers - Any under par score on a hole.
- Par or Better - Any score of par or under par on a hole.
Compare Sheet

On this sheet compare a single round or group of rounds with each other. Stats are color coded: red is improved, blue is worse, and gray is no change.
- Enter a round or set of rounds on the stats sheet, then do the same on the compare sheet. The compare sheet now displays the difference between the rounds on the stats sheet. Some examples of useful information:
- Set the stats sheet to all but the most recent round and the compare sheet to all rounds. This shows how much the most recent round has changed your stats.
- Set the stats sheet to all rounds and the compare sheet to only the most recent round. This shows how much off your average you were for the round.
Compare Files Sheet

This sheet compares the rounds set on the stats sheet to the rounds set on the stats sheet of another file. Stats are color coded: red is better, blue is worse, and gray is no difference.
To enable this sheet you have to tell Excel which file to compare to using the Edit Links Dialog Box.
- In Excel 2003 or older go to the Edit Menu and select Links.
In Excel 2007 or newer click on the Data Tab and the Edit Links button.
- Click on change source and find the file you want to compare to.
If you make changes to the other file while this file is not open you have to update the values on this sheet.
- Open the Edit Links Dialog Box as before.
- Click on update values.
If you want Excel to prompt you to update the values each time you open the file.
- Open the Edit Links Dialog Box as before.
- Click on Startup Prompt
- Select Let users choose to display the alert or not.
- Click OK and save the file.
Templates Sheet

This sheet contains blank entries for rounds and courses. There isn't any need to make changes to this sheet. The macros automatically copy blank rounds from here. If you do not want to enable macros you need to manually copy and paste as
described
below.
Manual Copy and Paste
- Go to the templates sheet. Here there is a blank round entry and a blank course entry.
- Select the entire area that is boxed off for either the blank round or blank course.
- Switch to either the courses or scores sheet.
- Select the cell in the first column leaving one row blank after the last entry. If this is the first entry, use row two. It is important that the spacing remains the same so that the spreadsheet adds up the data from each round
correctly.
- Paste the blank entry in.
Back to Golf Stats Tracker Home Page