Contextures

Excel Golf Scores Workbook

Enter your golf scores, and view your annual summary, in this free Excel workbook

Golf Scores Workbook Overview

Enter your golf scores in this Excel workbook, for each round of golf that you play during the year.

Enter your golf scores

Excel will calculate the totals for front 9 and back 9 holes, and the total score. Then, based on your handicap, a net score is calculated.

net score is calculated

On the Summary sheet, your overall results for the year are shown.

overall results for the year

The Summary worksheet is protected, with no password, to prevent the formulas from being accidentally deleted.

Enter the Course Information

The first step is to enter the par for each hole in your golf course, on the Summary sheet.

enter the par for each hole

Enter Your Scores

After each round of golf, enter the date, and your score for each hole, in the light green cells.

Enter Your Scores

The worksheet has conditional formatting, so the pars will be coloured orange, and scores below par are bright green.

The Scores sheet has an Excel table with a few rows, and it will expand automatically when you start a new row.

View Your Annual Summary

On the Summary sheet, your average and best scores are calculated, as well as the number of rounds played.

Summary sheet, average and best scores

Also, your best score for each hole is shown, and your average score on each hole.

best score for each hole

Finally, there's a tally of your pars, bogeys, birdies, etc., for each hole, using the COUNTIF function. The most frequent type of score is highlighted for each hole.

tally of your pars, bogeys, birdies

How It Works

There's one named range in the workbook -- CoursePar.

one named range in the workbook

The CoursePar named range is used in the conditional formatting on the Scores worksheet.

conditional formatting on the Scores worksheet

Download the Workbook

Download the zipped workbook: Excel Golf Scores . The file is in xlsx format, and does not contain any macros.

More Excel Golf Files

Assign TeeOff Times -- uses an Advanced Filter to schedule selected players in specific time slot; file contains a macro which automates the filter GolfTeeOff.zip 11 kb

Assign TeeOff Times -- This version has a UserForm in which to enter data: GolfTeeOffForm.zip 16 kb

Search Contextures Sites

 

 

 

 

30 Excel Functions in 30 Days

 

 

Last updated: September 30, 2016 7:28 PM