Search
Contextures Sites
| |||
|
|
|
|||
Contextures Inc., Copyright ©2013
All rights reserved.
Search Contextures Sites
Excel Template - Golf Scores
Golf Scores Template Overview
Enter the Course Information
Enter Your Scores
View Your Annual Summary
How It Works
More Excel Template Golf FilesDownload the zipped sample file: Excel Template - Golf Scores
Golf Scores Template Overview
Enter your golf scores in this Excel template, for each round of golf that you play during the year.
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.
On the Summary sheet, your overall results for the year are shown.
The Summary and Scores worksheets are protected, with no password.
Enter the Course Information
The first step is to enter the par for each hole in your golf course, on the Summary sheet.
Enter Your Scores
After each round of golf, enter the date, and your score for each hole..
Using conditional formatting, the pars will be coloured orange, and scores below par are green.
The Scores sheet has formatting and formulas down to row 80, and you can add more if necessary.
View Your Annual Summary
On the Summary sheet, your average and best scores are calculated, as well as the number of rounds played.
Also, your best score for each hole is shown, and your average score on 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.
How It Works
There's one named range in the workbook -- CoursePar.
The CoursePar named range is used in the conditional formatting on the Scores worksheet.
Download a zipped file
More Golf Template 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
Contextures Inc., Copyright ©2013
All rights reserved.
Last updated: May 21, 2013 7:02 PM
