This sheet shows information and stats relating to your handicap. Editable fields are in bold.
A handicap requires at least 5 rounds entered. Until then the USGA rules state to use the maximum handicap of 36.4. Note that if you already have a handicap, the calculated handicap on the spreadsheet may not match the handicap you already have until the rounds it uses are in the spreadsheet (last 20 differentials and in some
situations tournament
scores up to a year ago). For more information about how the handicap system works see The USGA Handicap System Manual.
Revision - Your
revision
handicap is your current handicap index used when playing rounds. It is updated on the 1st and 15th of the month.
Trend - Your trend handicap includes rounds played since the last revision. The letter "L" is added to the end to
indicate
that it is a local handicap.
Highlight - Select from the drop down Revision, Trend, Both, or None. This allows you to highlight the scores actually used to calculate your handicap.
Active Season - Set the first cell to the start date of the active season in your area and the second cell to the end date of the active season. If your area's active season is year round leave this blank. Only rounds at a course location
currently
in active season are counted towards your handicap. To find when active seasons are for different areas see the USGA Handicap Revision Schedule.
Rounds
The rounds section shows the rounds included in your handicap. The lowest of the differentials have a red star and are the rounds averaged to find the handicap index. How many are used depends on how many rounds are entered. An 18 hole round requires at least 13 holes played. A 9 hole round requires at least 7 holes from the same 9 played. Nine hole rounds are combined to form one 18 hole handicap differential.
The tables form an
overlapping
diagram to show the rounds used to calculate the revision and trend handicaps.
Yellow - These are the rounds used to calculate your latest
revision
handicap. The red started rounds on the left are the rounds used to calculate the handicap.
Blue - These are the rounds used to calculate your trend handicap. The red started rounds on the right are the rounds used to calculate the handicap.
Green - These are the rounds used by both the latest revision and the current trend.
History - Shows your
revision
history
during
the period of rounds displayed.
Tournament Record - This is a record of all of your
tournament
scores. Your two best
tournament
score differentials from the last year are included in your handicap. They only affect the calculation if they are
significantly
better than your regular rounds. When this occurs, an "R" for reduced is added after your handicap.
Handicap Card
This replicates the handicap card.
You can print this on a piece of paper or an index card to carry with you. To do this, drag a
selection
over these cells and select print selection in the print
dialog
box.
Home Course - Enter the number of your home course from the courses sheet.
Name - Enter your name as you want it to appear on your handicap card.
ID - Enter your ID if you have an ID
associated
with a club.
Club -
Automatically
filled from the number entered as your home course. Overwrite this if your club is not a course on the courses sheet.
Effective - Date of last handicap revision.
Scores Posted - Total number of scores used for your handicap.
Scores - Scores used in your handicap, ordered newest to older
from left to right in four rows.
A red star
indicates
a score actually used in the calculation. Letter codes are also added to the end of some scores.
A - Away - A round not played at your home course.
C - Combined - Two 9 hole rounds combined to make an 18 hole score.
T - Tournament - A round played in a tournament.
Handicap Trend Projection Tool
The handicap trend projection tool is used to project how future rounds affect your handicap or to find what you need to shoot in future rounds to meet a handicap goal.
Date - Enter a future date when you plan to play a round.
Tournament Score - Enter a T if you want the round designated as a tournament score, otherwise leave blank.
Score - Enter a 9 or 18 hole score.
Front 9 - Enter how many holes are played on the front 9.
Back 9 - Enter how many holes are played on the back 9.
Course - Enter the number of the course played from the courses sheet. The course name
automatically
fills in to the right of it.
Tee -
Automatically
fills in the tee name for the course number entered.
Rating -
Automatically
fills in the course rating for the course, tee, and hole combination played.
Slope -
Automatically
fills in the slope for the course, tee, and hole combination played.
Differential - Calculated from the score entered and the course rating and slope. The letter C indicates the first 9 hole round that is combined with another 9 hole round.
Goal - Calculated highest score you can shoot and still make your handicap goal. When scores are grayed out, the round does not affect your handicap due to a differential that is higher than your current highest round counted.
Projected Handicap - This is what your handicap is projected at if you shoot the scores entered.
Handicap Goal - Enter goal for a handicap to reach in the rounds entered.
Highest Possible - This is the highest your handicap can get over the period of rounds entered. This is what your handicap is if all future rounds are not used due to
differentials
that are higher than the ones already entered.
Average Differential - This is the average differential required in your future rounds to meet your handicap goal.
Number of Rounds - This is the total number of future rounds entered so far.
Tournament Score Reduction - This section only displays when your goal handicap brings into play a
tournament
reduction or
tournament
reduction prevents you from reaching the calculated highest possible handicap.
Without Reduction - The highest your handicap can get before a reduction takes place.
Highest Reduction - The point at which your handicap is the highest it can get with a
tournament
reduction applied and the
resulting
handicap after reduction.
Reverse Calculate - The point at which a
tournament
reduction is applied to your handicap and the resulting handicap after reduction.
Handicap Stats
These are some
miscellaneous
stats relating to your handicap.
Dates - This is the date range used for the handicap stats below. The dates used are from the stats sheet. To use different dates change the dates on the stats sheet.
Rounds - Number of rounds played during the time period.
Differential - Shows you stats for your
differentials
if all rounds were included.
Course Rating and Slope - Shows the difficulty of the courses you are playing.
Average - Your average differential, course rating and slope over the time period.
Compare - Your averages over the time period on the compare sheet and the difference between them and the stats sheet.
Compare Files - The averages for another spreadsheet and the difference between them and the stats sheet.
Tournament Calculations
These are calculations related to your
tournament
scores for calculating
whether
they affect your handicap. There are four sets, one for each handicap calculation (revision, trend, projection and goal).
Scores - The number of tournament scores from the last year.
Lowest - The lowest differential in a tournament score in the last year.
2nd Low - The 2nd lowest differential in a tournament score in the last year.
Difference - The difference between your current handicap index and your 2nd lowest differential. This is highlighted in red when the difference is high enough to cause a reduction in your handicap.
Avg. Diff. - This is the difference between your handicap index and the average of your two lowest differentials. This and the number of
tournament
rounds played are used to look up how much your handicap reduction is.
Reduction - This is how much your handicap is reduced due to your
tournament
performance.
Reduction Point - This is how high your handicap must reach before the
tournament
scores come into play and reduce it.
