Spreadsheet: 880587d1728398252-double-stroke-formula-for-stableford-scoring-system-golf-zebula-scorecard-thursday
Sheet: Scorecard

 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-10-08 16:34:48 |  |  |  | 2024-10-08 16:34:48
 | Match |  |  | Date |  |  |  |  |  |  | Player A |  |  |  |  |  |  |  | Player B
 | QPQ |  |  | 2023-09-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DATE:>>
 |  | SSS 70 | SSS 66 |  | Handicaps |  | Handicaps >>> |  |  |  | 12 |  |  |  | >>>>>>> |  |  |  | 24
 | Tee Used | X | [NAME] only
 | Hole | White Yards | [NAME] | Par | Stroke Index |  | HCP |  |  |  | Gross Score |  |  |  | S'ford Points |  |  |  | Gross Score |  |  |  | S'ford Points
 | 1 | 276 | 381 | 4 | 5 |  | 1 |  | 4 | 5 | 4 | 7 | 1 | 0 | 3 |  | 4 | 5 | 4 | 19 | 2 | 0 | 4 |  | Points should be 5 as the player double strokes on strokes 1-6  (24-18)
 | 2 | 508 | 491 | 5 | 13 |  | 2 |  | 5 | 13 | 5 | -1 | 0 | 0 | 2 |  | 5 | 13 | 5 | 11 | 1 | 0 | 3 |  | Points should be 3 as the player only gets 1 stroke on this hole as the stroke is higher than 6 so this is correct
 | 3 | 358 | 360 | 4 | 15 |  | 3 |  | 4 | 15 |  | -3 | 0 | 4 |  |  | 4 | 15 |  | 9 | 1 | 4 |  |  | If we change the handicaps in L8 and T24 then the points need to change accordingly to the strokes per hole column F and what their gross score was on that hole.
 | 4 | 303 | 270 | 3 | 11 |  | 4 |  | 3 | 11 |  | 1 | 1 | 3 |  |  | 3 | 11 |  | 13 | 1 | 3
 | 5 | 224 | 226 | 4 | 1 |  | 5 |  | 4 | 1 |  | 11 | 1 | 4 |  |  | 4 | 1 |  | 23 | 2 | 4
 | 6 | 371 | 359 | 5 | 9 |  | 6 |  | 5 | 9 |  | 3 | 1 | 5 |  |  | 5 | 9 |  | 15 | 1 | 5
 | 7 | 394 | 383 | 4 | 3 |  | 7 |  | 4 | 3 |  | 9 | 1 | 4 |  |  | 4 | 3 |  | 21 | 2 | 4
 | 8 | 188 | 178 | 3 | 17 |  | 8 |  | 3 | 17 |  | -5 | 0 | 3 |  |  | 3 | 17 |  | 7 | 1 | 3
 | 9 | 315 | 310 | 4 | 7 |  | 9 |  | 4 | 7 |  | 5 | 1 | 4 |  |  | 4 | 7 |  | 17 | 1 | 4
 | Out | 2937 | 2958 | 36 | Out |  | OUT |  |  |  | 9 |  |  |  | 5 |  |  |  | 9 |  |  |  | 7
 | 10 | 342 | 336 | 4 | 12 |  | 10 |  | 4 | 12 |  | 0 | 1 | 4 |  |  | 4 | 12 |  | 12 | 1 | 4
 | 11 | 213 | 197 | 4 | 6 |  | 11 |  | 4 | 6 |  | 6 | 1 | 4 |  |  | 4 | 6 |  | 18 | 2 | 4
 | 12 | 474 | 471 | 4 | 14 |  | 12 |  | 4 | 14 |  | -2 | 0 | 4 |  |  | 4 | 14 |  | 10 | 1 | 4
 | 13 | 380 | 385 | 3 | 18 |  | 13 |  | 3 | 18 |  | -6 | 0 | 3 |  |  | 3 | 18 |  | 6 | 1 | 3
 | 14 | 123 | 110 | 4 | 2 |  | 14 |  | 4 | 2 |  | 10 | 1 | 4 |  |  | 4 | 2 |  | 22 | 2 | 4
 | 15 | 523 | 417 | 5 | 16 |  | 15 |  | 5 | 16 |  | -4 | 0 | 5 |  |  | 5 | 16 |  | 8 | 1 | 5
 | 16 | 480 | 412 | 4 | 4 |  | 16 |  | 4 | 4 |  | 8 | 1 | 4 |  |  | 4 | 4 |  | 20 | 2 | 4
 | 17 | 151 | 138 | 3 | 10 |  | 17 |  | 3 | 10 |  | 2 | 1 | 3 |  |  | 3 | 10 |  | 14 | 1 | 3
 | 18 | 393 | 413 | 5 | 8 |  | 18 |  | 5 | 8 |  | 4 | 1 | 5 |  |  | 5 | 8 |  | 16 | 1 | 5
 | In | 3079 | 2879 | 36 | In |  | IN |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | Total | 6016 | 5837 | 72 | Totals |  | SCORE |  |  |  | 9 |  |  |  | 5 |  |  |  | 9 |  |  |  | 7
 |  |  |  |  | Nett |  | NETT |  |  |  | -3 | 0 | 0 | 0 |  |  | 0 | 0 | -15 | 0 | 0 | 0
 | [NAME] | JMH |  |  | Total Holes Won |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0