Version History

Jan 11 12
  • Added a new stat to the stats sheet called Scrambling Conversion %. This is similar to Birdie Conversion % except that instead of measuring the birdie putts converted when hitting the green in regulation, this measures the par putts converted when missing the green in regulation. This is different from scrambling in that it doesn't count holes with no chance to save par with a putt which happens when you’re still not on the green after one stroke over green in regulation.
  • The GIR displayed on the rounds sheet was changed in order to enable the new calculation. Previously it was a simple 1 or 0 for hit or not hit. Now it is the difference between how many strokes it took to hit the green and how many strokes a GIR is for the hole. This means that 0 or less in now a GIR and more than 0 is a green missed. A value of 1 is where the new stat comes in, a green missed but with a putt to save par.
  • A gray background was added to the handicap differential on the rounds sheet. It was also shortened and shifted to the left to free up cells for the new calculation and also make room for future calculations. The order of some of the stats in the scrambling section of the stats sheet changed and shifted down to include the new stat. As a result of these changes follow the notes at the bottom of this page when copying rounds into the new version or comparing spreadsheets.
  • Fixed a bug in the ball striking stat. Previously any GIR hole with nothing entered in for fairways hit was counted successful. Now this is only the case for par 3's where fairways hit are never entered. In figuring the percentage, the total attempts for this stat is now the total number of holes where something was recorded for fairways hit plus the total number of par 3's played.
  • Fixed a bug in the compare files sheet where the hole difficulty stats were using the rounds set on the compare sheet instead of the stats sheet.
  • The printing margins were fixed so that when printing the stats sheet, all of the stats fit on one 8 ½ x 11 inch sheet of paper.
  • Added a note to the documentation about directly adding drive length for a hole on the rounds sheet.
Aug 30 11
  • Bug fixed on January 17, 2011 was reappearing when saving the spreadsheet as a different file type such as *.xlsm. This is probably how it came about the first time. The problem is, in calculating the stats on the scores sheet, editing and reentering the criteria for database functions is needed for them to work even though no actual changes are made. It only occurred in stats where identical criteria were used in more than five consecutive columns. The solution this time was to rearrange the order of the stats calculated so that stats that use the same criteria do not occur more than five times consecutively. Still unsure of the exact reason for this problem, possibly a bug in how Excel handles things. Hopefully in this spreadsheet this bug is squashed for good now.
  • Updated the link in the documentation for the USGA Course Rating Database.
Mar 05 11
  • Fixed a bug in how albatrosses were calculated. Previously it was using DAVERAGE instead of DSUM to find the total number of albatrosses made.
  • Fixed a typo of the word score at cell Z18 of the scores sheet.
  • Updated the documentation for the compare files sheet to include instructions for opening the Edit Links Dialog Box in Excel 2007 and newer.
Jan 17 11
  • Fixed a bug where in new spreadsheets the stats in the scoring section did not display without reentering the criteria used to calculate these stats.
Aug 28 09
  • Fixed a bug where after 20 handicap rounds were entered (with two 9 hole rounds counting as one handicap round) your handicap was no longer calculated. A handicap is calculated using only the 20 most recent handicap rounds. Once the total reaches 20 the spreadsheet finds the row number for the 20th most recent handicap round so it knows where to start the calculation. It was instead returning the row number of the current round. This caused a number error because it had no rounds to use to calculate the handicap.
Jun 29 09
  • Fixed a bug where your best nine holes in relation to par displayed incorrectly if it was even par. For nine hole rounds, the spreadsheet skips the nine not played because the blank cell has a value of zero. However an even par round also comes back as a value of zero and was therefore also skipped. This was fixed by changing it to use the aggregate total of zero to determine if a given round was played. Aggregate low nine was already using this and not affected.
  • Nine hole scores are now used correctly in figuring your handicap. Previously they were counted as a full round just like 18 hole scores. They are now combined with other nine hole scores to form 18 hole scores before they are counted. This means that two nine hole rounds only count as one round now when figuring your handicap.
  • You are now able to enter course ratings and slopes for the individual nines of a course in addition to the full 18. The spreadsheet is set up to divide the 18 hole course rating by two and use the same slope. Overwrite these numbers if you have individual ratings for the nines. One place to look for these nine hole ratings is at the USGA Course Rating Database.
  • The handicap field is now automatically filled in when entering a new round. If you have fewer then five rounds counting towards your handicap (two nine hole rounds combine and count as one round) your handicap is the maximum of 36.4. After you have five rounds in it calculates your handicap based on the previous rounds. This matches what is displayed in cell B3 on the stats sheet before you enter the round. After entering the round your handicap may change so they no longer match.
  • Added "Par or Better" stat to the stats, compare, and compare files sheets. This is similar to par breakers only it also includes pars.
Sep 24 07
  • Initial release.

To move existing rounds and courses from an older version, create new rounds and courses in the new version then copy and paste only the entered data over. Do not copy and paste the entire round or course over as some of the calculations in the other cells may have changed.

When comparing files, different versions are not necessarily compatible with each other.

Back to Golf Stats Tracker Home Page