Reference Page

Scores Sheet

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.

Courses Sheet

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.

Stats Sheet

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

Stats

Course

Scoring

Compare Sheet

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.

Compare Files Sheet

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.

  1. 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.
  2. 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.

  1. Open the Edit Links Dialog Box as before.
  2. Click on update values.

If you want Excel to prompt you to update the values each time you open the file.

  1. Open the Edit Links Dialog Box as before.
  2. Click on Startup Prompt
  3. Select Let users choose to display the alert or not.
  4. Click OK and save the file.

Templates Sheet

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

  1. Go to the templates sheet. Here there is a blank round entry and a blank course entry.
  2. Select the entire area that is boxed off for either the blank round or blank course.
  3. Switch to either the courses or scores sheet.
  4. 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.
  5. Paste the blank entry in.

Back to Golf Stats Tracker Home Page