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.