This sheet contains stats relating to your match play results. The matches are rounds played on the same day in
a separate
spreadsheet file containing your opponent's rounds. Editable fields are in bold.
Opponent - Name of your opponent's spreadsheet. To change spreadsheets see the linking spreadsheets page.
Handicap - Select from the drop down either on or off. This changes if handicaps are used to determine who wins holes.
Hole Highlight - Select from the drop down either on or off. This highlights the holes on the scores sheet where the handicap comes into play.
Dates - This is the date range used for the match stats. The dates used are from the stats sheet. To use different dates change the dates on the stats sheet. Below is the total number of rounds played during this time period (counting both match and non-match rounds).
Match Record - This is your Win-Loss-Tie record.
Win % - The percentage of times you win your matches.
Matches
Matches - Total number of matches played.
Margin - Amount a player is up at the end of a match
Total - Total of all margins in all matches.
Percent - Average percentage of round players win by in a round.
Per 18 - Average number of holes players win by (18 hole match).
Length - How long a match goes before it is decided.
Total - Total number of holes played where the match was not yet decided.
Percent - Average percentage of the round played before a match is decided.
Per 18 - Average holes a round goes before the match is decided (18 hole match).
Average Finish - Average match finish in terms of traditional match play scoring (margin & holes remaining).
Holes
Holes - Total number of holes played
Won, Lost, Halved -
Total - Total holes won, lost, or tied.
Percent - Percentage of holes won, lost or tied.
Per 18 - Average number of holes won, lost, or tied (18 hole match).
Net - Subtraction of lost from won holes. Shows how much ahead or behind you are overall.
Match Handicap Calculator Tool
The match handicap calculator tool is used to calculate the course handicap difference between two spreadsheets for a
particular
course and holes. This allows you to know how many shots to give or
receive
in advance of a match so you can score it while playing.
Player - Enter the number of the course from this file's course sheet. Course name, tee and course handicap are
automatically
filled in.
Opponent - Enter the number of the course from the other file's course sheet. Course name, tee and course handicap are
automatically
filled in.
Holes - Enter how many holes are played for each 9.
Tee Difference - If players are playing from
different
tees this is calculated to
compensate
for the difference.
Final
Difference - This is the number of strokes the player in this spreadsheet gives or
receives. If playing match play strokes are divided evenly among all holes in order of lowest handicap holes first.
