Refer to the Golf Tracker.
The Golf Tracker documents the performances of each member of our friend group. The main goal of the spreadsheet was to demonstrate that we are in fact improving and to add some competition to our golf game.
The Golf Tracker has a legend outlines the colour scheme used within the tracker. Other than the colours used to identify players, the best scores are colder colour.
(Worst/Hardest) RED < PINK < ORANGE < GREEN < BLUE (Best/Easiest)
The courses that have been played on are document here.
The coloured tees with the corresdoning slope and rating are listed here, along with the par for each hole and the last time the course was verrified.
The 18-hole rounds and 9-hole rounds of all players are listed in the corresponding tab. They are both in descending order of the "True Score" (TrSc) of each player's round.
The True Score considers the score of the round as well as the difficulty of the course, allowing for a more fair comparisson between rounds. The lower the True Score, the better.
The 18-Hole True Score is linked in the following areas:
- Overall(18) - Column AW
- Players Pages - Column AT
The 9-Hole True Score is linked in the following areas:
- Overall(9) - Column AE
- Players Pages - Column BX
The True Score is calculated using the same formula used to calculate a player's handicap. The formula for the True Score can be seen below.
The True Score is calculated using the main formula used to help calculate a player's handicap.
Each member of our friend group has their own player page detailing their personal stats and rounds.
The 18-Hole Rounds Table records every 18-Hole round the player has played.
All formatting for the table is automatic but the player must enter the following:
- Course Played (B)
- Tee Played From (C)
- Rating of the Course (D)
- Slope of the Course (E)
- Date Played (F)
- Score and Par of Each Hole (J-AS)
Then, the following will be automatically calculated:
- Course Ranking (A)
- Round Score (G)
- Round Par (H)
- Round Score +/- (I)
- True Score (AT)
- Round Overall Ranking (AU)
As the player progresses, their career average will be tracked in row 20, along with their yearly average.
The 9-Hole Rounds Table records every 9-Hole round the player has played. If an 18-Hole round was played, the front 9 and back 9 of the round are added to this table (not automatically yet).
All formatting for the table is automatic but the player must enter the following:
- Course Played (AX)
- Tee Played From (AY)
- Rating of the Course (AZ)
- Slope of the Course (BA)
- Date Played (BB)
- Score and Par of Each Hole (BF-BV)
Then, the following will be automatically calculated:
- Course Ranking (AW)
- Round Score (BC)
- Round Par (BD)
- Round Score +/- (BE)
- True Score (BX)
- Round Overall Ranking (BY)
- Player Score (BZ)
As the player progresses, their career average will be tracked in row 20, along with their yearly average.
The Player Score allows players to see if they are improving and how they compare to other golfers in an impartial manner. The lower the Player Score, the better.
The Player Score is calculated and documented in the BZ column of the 9-Hole Table on a Player Page. The current Player Score is the Player Score of latest entry in the 9-Hole Table. The Player Score history is plotted in the top left of a Player Page.
The Player Score is calculated using the generic formula used to calculate a player's handicap, just with some added liberties. A Player Score is calculated based on the 10 best rounds in a player's most recent 20 rounds. The Player Score formula may be seen below.
....where B=10 and R=20
However, if less than 20 rounds have been played, consult the table below to find the value of B.
| Rounds (R) | Best __ Scores (B) |
|---|---|
| 1-2 | 1 |
| 3-4 | 2 |
| 5-6 | 3 |
| 7-8 | 4 |
| 9-10 | 5 |
| 11-12 | 6 |
| 13-14 | 7 |
| 15-16 | 8 |
| 17-18 | 9 |
| 19 | 10 |
The player score is then recalculated based on the table below.
| Player Score (P) | Max Per Hole |
|---|---|
| P<10 | +2 |
| 10<P<20 | 7 |
| 20<P<30 | 8 |
| 30<P<40 | 9 |
| 40<P | 10 |
The individual hole performance of the player over their career is depicted in two tables and four pie charts.
The individual hole performance is automatically tallied into the top-left table. The rate is calculated automatically in the bottom-left table. The results of the bottom-left table are illustrated in the four pie charts to the right.
The table is sorted by par (3-5) and hole result. The hole result legend may be found below.
| Hole Result | Abbreviation | Score |
|---|---|---|
| Eagle | E | -2 |
| Birdie | Bi | -1 |
| Par | P | 0 |
| Bogey | B | +1 |
| Double Bogey | DB | +2 |
| Triple Bogey | TB | +3 |
| Blow Up Hole | Bl | +3< |
The average round progression over a player's career is illustrate for both 18-Hole and 9-Hole rounds.
X-axis - Hole
Y-axis - Score of the Hole
