{"id":436,"date":"2016-07-11T11:20:00","date_gmt":"2016-07-11T15:20:00","guid":{"rendered":"http:\/\/spreadsheet-day.com\/blog\/?p=436"},"modified":"2021-10-19T09:14:44","modified_gmt":"2021-10-19T13:14:44","slug":"track-your-golf-scores-in-excel","status":"publish","type":"post","link":"https:\/\/spreadsheet-day.com\/blog\/2016\/07\/11\/track-your-golf-scores-in-excel\/","title":{"rendered":"Track Your Golf Scores in Excel"},"content":{"rendered":"<div class=\"d942c2121bfbd137a3b44056a000f09c\" data-index=\"1\" style=\"float: none; margin:10px 0 10px 0; text-align:center;\">\n<script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\r\n<!-- Responsive Top -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-9531091850463532\"\r\n     data-ad-slot=\"6574318169\"\r\n     data-ad-format=\"auto\"><\/ins>\r\n<script>\r\n(adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p>If you&#8217;re playing golf this summer, keep track of your golf scores in this free Excel template. How many Birdies do you have so far this year? What&#8217;s your average score? Even when you\u2019re golfing, it\u2019s Spreadsheet Day!<\/p>\n<p><!--more--><\/p>\n<h3>Enter Your Golf Course Info<\/h3>\n<p>At the start of the season, enter the golf course information \u2013 what is the par for each hole?<\/p>\n<p>Excel formulas calculate the totals for the front nine holes, the back nine holes, and the course total.<\/p>\n<p><a href=\"http:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2016\/07\/golfscores01d.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px;\" title=\"golfscores01d\" src=\"http:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2016\/07\/golfscores01d_thumb.png\" alt=\"golfscores01d\" width=\"402\" height=\"102\" border=\"0\" \/><\/a><\/p>\n<h3>Enter Your Golf Scores in Excel<\/h3>\n<p>During the golf season, each time you play a round of golf, enter the date, and your score for each hole.<\/p>\n<p><a href=\"http:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2016\/07\/golfscores01.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px;\" title=\"golfscores01\" src=\"http:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2016\/07\/golfscores01_thumb.png\" alt=\"golfscores01\" width=\"400\" height=\"201\" border=\"0\" \/><\/a><\/p>\n<p>Also enter your handicap, and Excel will calculate your net score.<\/p>\n<p><a href=\"http:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2016\/07\/golfscores01b.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px;\" title=\"golfscores01b\" src=\"http:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2016\/07\/golfscores01b_thumb.png\" alt=\"golfscores01b\" width=\"352\" height=\"202\" border=\"0\" \/><\/a><\/p>\n<p>There are a few rows in the Scores sheet already, and you can add more as you need them. The table will expand automatically when you add a new row.<\/p>\n<h3>Your Golf Summary<\/h3>\n<p>As the season progresses, you can see how you\u2019re doing.<\/p>\n<p>On the Summary sheet, Excel formulas show how many rounds of golf you\u2019ve played, your overall low scores, and your overall average scores.<\/p>\n<p><a href=\"http:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2016\/07\/golfscores01c.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px;\" title=\"golfscores01c\" src=\"http:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2016\/07\/golfscores01c_thumb.png\" alt=\"golfscores01c\" width=\"402\" height=\"127\" border=\"0\" \/><\/a><\/p>\n<p>The Summary sheet also shows your best score on each hole, and your overall average for each hole.<\/p>\n<p>Conditional formatting highlights the pars, and the below par scores.<\/p>\n<p><a href=\"http:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2016\/07\/golfscores01e.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; margin: 0px; display: inline; padding-right: 0px; border: 0px;\" title=\"golfscores01e\" src=\"http:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2016\/07\/golfscores01e_thumb.png\" alt=\"golfscores01e\" width=\"402\" height=\"87\" border=\"0\" \/><\/a><\/p>\n<h3>Eagles, Pars and Bogeys<\/h3>\n<p>There is also a list of Eagles, Birdies, Pars, and other scores, with your count for each hole.<\/p>\n<p>In this section, conditional formatting is used to colour the cells that have the most frequent number in each row. For example, for Pars, 2 is most frequent, and is highlighted for holes 1, 3, and 6.<\/p>\n<p><a href=\"http:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2016\/07\/golfscores01f.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" style=\"background-image: none; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border: 0px;\" title=\"Track Your Golf Scores in Excel\" src=\"http:\/\/spreadsheet-day.com\/blog\/wp-content\/uploads\/2016\/07\/golfscores01f_thumb.png\" alt=\"Track Your Golf Scores in Excel\" width=\"403\" height=\"227\" border=\"0\" \/><\/a><\/p>\n<h3>Download the Excel Golf Scores Template<\/h3>\n<p>To download your free copy of the template, go to my Contextures website, on the <a title=\"Excel golf scores template page\" href=\"http:\/\/www.contextures.com\/excel-template-golf-scores.html\" target=\"_blank\" rel=\"noopener\">Excel golf scores template page<\/a>. Click the link near the top of the page, to go to the download section.<\/p>\n<p>There is also a section on how the conditional formatting works, to highlight the par and below par scores.<\/p>\n<p>The zipped file is in xlsx format, and does not contain any macros.<\/p>\n<p>_______________<\/p>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>If you&#8217;re playing golf this summer, keep track of your golf scores in this free Excel template. How many Birdies do you have so far this year? What&#8217;s your average score? Even when you\u2019re&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":434,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-436","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheets"],"_links":{"self":[{"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/436","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/comments?post=436"}],"version-history":[{"count":4,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/436\/revisions"}],"predecessor-version":[{"id":947,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/posts\/436\/revisions\/947"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/media\/434"}],"wp:attachment":[{"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/media?parent=436"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/categories?post=436"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/spreadsheet-day.com\/blog\/wp-json\/wp\/v2\/tags?post=436"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}