Spreadsheet: 818153d1676624823-identify-highest-3-numbers-in-a-range-of-cells-in-a-row-2022-2023-winter-championship-mod3
Sheet: Sheet1

2022-2023 SENIORS WINTER CHAMPIONSHIP |  |  |  |  |  |  |  |  |  | [NAME]: 85% WHS, Buffer=Corr Average +4, Winner (12 merit points) is cut 1 shot, 11 and 10 merit points also get cut if >buffer.
Name | Paid |  | WHS | WHS | Rounds | TOTAL |  | Best12 | Count | 2022-10-24 00:00:00 |  |  |  |  | 2022-10-27 00:00:00 |  |  |  |  | 31/10/22 |  |  |  |  | 2022-11-03 00:00:00 |  |  |  |  | 2022-11-07 00:00:00 |  |  |  |  | 2022-11-10 00:00:00 |  |  |  |  | 2022-11-14 00:00:00 |  |  |  |  | 2022-11-21 00:00:00 |  |  |  |  | 2022-11-24 00:00:00 |  |  |  |  | 28/11/22 |  |  |  |  | 2022-12-01 00:00:00 |  |  |  |  | 2022-12-05 00:00:00 |  |  |  |  | 2022-12-08 00:00:00 |  |  |  |  | 2023-01-09 00:00:00 |  |  |  |  | 2023-01-12 00:00:00 |  |  |  |  | 2023-01-26 00:00:00 |  |  |  |  | 2023-01-30 00:00:00 |  |  |  |  | 2023-02-02 00:00:00 |  |  |  |  | 2023-02-06 00:00:00 |  |  |  |  | 2023-02-09 00:00:00 |  |  |  |  | 2023-02-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Best 12 Merit point Scores
 | Entry |  | INDEX | INDEX | Played | MERIT |  | Merit | Merit |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT |  | New | Rank | REV | MERIT | Lowest Merit | HDCP | Average Merit | Total Stbd | Average Stableford
 | £3.00 |  |  | 85% |  | points |  | Points | times | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Points | HDCP |  | Rank | Points | Point Score | CUTS | points score | Points | Points Score |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Counting
[NAME] |  |  | 36.6
 |  |  |  | 0
 |  |  |  |  | 0
Millar I | 3 |  | 16.6 |  |  |  |  |  |  | 24 |  |  |  |  | 33 |  |  |  |  | 28 |  |  |  |  | 31 |  |  |  |  | 28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 |  |  |  |  | 31 |  |  |  |  | 34 |  |  |  |  | 33 |  |  |  |  | 32 |  |  |  |  | 26 |  |  |  |  |  |  |  |  |  | 33 |  |  |  |  | 30 |  |  |  |  | 27 |  |  |  |  | 37 |  |  |  |  | 26
Miller P | 3 |  | 21.9 |  |  |  |  |  |  | 31 |  |  |  |  | 27 |  |  |  |  | 31 |  |  |  |  | 34 |  |  |  |  | 27 |  |  |  |  |  |  |  |  |  | 32 |  |  |  |  | 37 |  |  |  |  |  |  |  |  |  | 37 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 |  |  |  |  | 41 |  |  |  |  | 37 |  |  |  |  | 47 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 |  |  |  |  | 39 |  |  |  |  | 40
Milne C | 3 |  | 4.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 |  |  |  |  | 39 |  |  |  |  | 33 |  |  |  |  | 36 |  |  |  |  | 39 |  |  |  |  | 38 |  |  |  |  | 32 |  |  |  |  | 29 |  |  |  |  | 33 |  |  |  |  | 32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 |  |  |  |  | 29 |  |  |  |  |  |  |  |  |  | 35 |  |  |  |  | 36 |  |  |  |  | 33
[NAME] | 3 |  | 9.6 |  |  |  |  |  |  | 42 |  |  |  |  | 35 |  |  |  |  | 38 |  |  |  |  | 34 |  |  |  |  | 37 |  |  |  |  | 36 |  |  |  |  | 33 |  |  |  |  | 38 |  |  |  |  | 33 |  |  |  |  | 38 |  |  |  |  | 38 |  |  |  |  | 34 |  |  |  |  | 31 |  |  |  |  | 31 |  |  |  |  |  |  |  |  |  | 36 |  |  |  |  | 31 |  |  |  |  | 36 |  |  |  |  | 34 |  |  |  |  | 32 |  |  |  |  | 40
[NAME] | 3 |  | 16 |  |  |  |  |  |  | 27 |  |  |  |  | 28 |  |  |  |  | 32 |  |  |  |  | 32 |  |  |  |  |  |  |  |  |  | 31 |  |  |  |  | 37 |  |  |  |  |  |  |  |  |  | 36 |  |  |  |  | 40 |  |  |  |  | 47 |  |  |  |  | 38 |  |  |  |  |  |  |  |  |  | 36 |  |  |  |  | 37 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37
[NAME] | 3 |  | 32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 |  |  |  |  |  |  |  |  |  | 26 |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44 |  |  |  |  | 32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35
Niven M | 3 |  | 14.4 |  |  |  |  |  |  | 32 |  |  |  |  |  |  |  |  |  | 36 |  |  |  |  | 37 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
Panton N | 3 |  | 3.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33
Park A | 3 |  | 23.7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 |  |  |  |  | 35 |  |  |  |  | 35 |  |  |  |  | 34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38 |  |  |  |  | 24 |  |  |  |  | 31 |  |  |  |  | 28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38 |  |  |  |  | 27 |  |  |  |  | 27
Payne J | 3 |  | 22.5 |  |  |  |  |  |  | 28 |  |  |  |  | 37 |  |  |  |  | 26 |  |  |  |  | 33 |  |  |  |  | 35 |  |  |  |  | 38 |  |  |  |  | 35 |  |  |  |  |  |  |  |  |  | 36 |  |  |  |  | 41 |  |  |  |  | 40 |  |  |  |  | 28 |  |  |  |  | 36 |  |  |  |  | 41 |  |  |  |  | 43 |  |  |  |  |  |  |  |  |  | 44 |  |  |  |  | 41 |  |  |  |  | 41 |  |  |  |  | 34
Putnam K | 3 |  | 20.6 |  |  |  |  |  |  | 32 |  |  |  |  | 29 |  |  |  |  | 32 |  |  |  |  | 36 |  |  |  |  | 28 |  |  |  |  | 33 |  |  |  |  | 37 |  |  |  |  | 39 |  |  |  |  |  |  |  |  |  | 40 |  |  |  |  | 37 |  |  |  |  | 34 |  |  |  |  | 31 |  |  |  |  | 45 |  |  |  |  | 44 |  |  |  |  | 34 |  |  |  |  | 40 |  |  |  |  | 43 |  |  |  |  | 42 |  |  |  |  | 39 |  |  |  |  | 37
Rae A | 3 |  | 22 |  |  |  |  |  |  | 35 |  |  |  |  | 37 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 |  |  |  |  | 31 |  |  |  |  | 33 |  |  |  |  | 39 |  |  |  |  | 46 |  |  |  |  | 49 |  |  |  |  |  |  |  |  |  | 27 |  |  |  |  | 28 |  |  |  |  | 42 |  |  |  |  | 41 |  |  |  |  |  |  |  |  |  | 38 |  |  |  |  |  |  |  |  |  | 39 |  |  |  |  | 38 |  |  |  |  | 31
[NAME] |  |  | 11.7
Rhodes P | 3 |  | 19.8 |  |  |  |  |  |  | 23 |  |  |  |  |  |  |  |  |  | 34 |  |  |  |  | 21 |  |  |  |  | 23 |  |  |  |  |  |  |  |  |  | 33 |  |  |  |  | 25 |  |  |  |  | 33 |  |  |  |  | 36 |  |  |  |  | 34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 |  |  |  |  |  |  |  |  |  | 30 |  |  |  |  | 25 |  |  |  |  | 18 |  |  |  |  |  |  |  |  |  | 29
Rodney I | 3 |  | 18.2 |  |  |  |  |  |  | 34 |  |  |  |  |  |  |  |  |  | 27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37 |  |  |  |  | 28 |  |  |  |  |  |  |  |  |  | 34 |  |  |  |  | 42 |  |  |  |  |  |  |  |  |  | 33 |  |  |  |  | 38 |  |  |  |  | 39 |  |  |  |  |  |  |  |  |  | 30 |  |  |  |  | 39 |  |  |  |  | 35 |  |  |  |  | 42 |  |  |  |  | 37 |  |  |  |  | 37
Senior R | 3 |  | 12.5 |  |  |  |  |  |  | 30 |  |  |  |  | 34 |  |  |  |  | 28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 |  |  |  |  | 36 |  |  |  |  |  |  |  |  |  | 34 |  |  |  |  | 40 |  |  |  |  | 35
Shand N | 3 |  | 16.2 |  |  |  |  |  |  | 37 |  |  |  |  | 27 |  |  |  |  | 37 |  |  |  |  | 33 |  |  |  |  | 30 |  |  |  |  | 28 |  |  |  |  | 35 |  |  |  |  | 35 |  |  |  |  | 35 |  |  |  |  | 39 |  |  |  |  |  |  |  |  |  | 36 |  |  |  |  | 38 |  |  |  |  | 33 |  |  |  |  | 37 |  |  |  |  | 38 |  |  |  |  | 41 |  |  |  |  | 38 |  |  |  |  | 34 |  |  |  |  | 32 |  |  |  |  | 32
Spaven D | 3 |  | 13.8 |  |  |  |  |  |  | 29 |  |  |  |  |  |  |  |  |  | 28 |  |  |  |  | 28 |  |  |  |  | 29 |  |  |  |  | 37 |  |  |  |  | 31 |  |  |  |  | 38 |  |  |  |  | 39 |  |  |  |  | 39 |  |  |  |  |  |  |  |  |  | 36 |  |  |  |  | 34 |  |  |  |  | 36 |  |  |  |  | 39 |  |  |  |  | 38 |  |  |  |  | 40 |  |  |  |  |  |  |  |  |  | 39 |  |  |  |  |  |  |  |  |  | 35
[NAME] |  |  | 31.4
[NAME] | 3 |  | 33.5 |  |  |  |  |  |  | 26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  |  |  |  | 28 |  |  |  |  | 35 |  |  |  |  | 32 |  |  |  |  | 33 |  |  |  |  | 34 |  |  |  |  | 50 |  |  |  |  | 30 |  |  |  |  | 35 |  |  |  |  | 40 |  |  |  |  |  |  |  |  |  | 42 |  |  |  |  | 36 |  |  |  |  | 42 |  |  |  |  | 40 |  |  |  |  | 38 |  |  |  |  | 32
[NAME] |  |  | 31.7
Walker K | 3 |  | 12
Watson I |  |  | 23.9
Watt A | 3 |  | 18.6 |  |  |  |  |  |  | 26 |  |  |  |  |  |  |  |  |  | 28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 |  |  |  |  | 36 |  |  |  |  | 29 |  |  |  |  | 33 |  |  |  |  | 33 |  |  |  |  | 35 |  |  |  |  | 27 |  |  |  |  | 32 |  |  |  |  | 38 |  |  |  |  | 33 |  |  |  |  | 34 |  |  |  |  | 30 |  |  |  |  | 37 |  |  |  |  | 33 |  |  |  |  | 33
Blank |  |  | 18
Blank |  |  | 18
Wilson I | 3 |  | 17.7 |  |  |  |  |  |  | 34 |  |  |  |  |  |  |  |  |  | 34 |  |  |  |  | 34 |  |  |  |  | 30 |  |  |  |  | 29 |  |  |  |  | 37 |  |  |  |  | 36 |  |  |  |  | 42 |  |  |  |  | 41 |  |  |  |  | 41 |  |  |  |  | 28 |  |  |  |  | 40 |  |  |  |  | 42 |  |  |  |  | 41 |  |  |  |  | 35 |  |  |  |  | 34 |  |  |  |  | 39 |  |  |  |  | 39 |  |  |  |  | 41 |  |  |  |  | 31
[NAME] | 3 |  | 16.8 |  |  |  |  |  |  |  |  |  |  |  | 35 |  |  |  |  | 38 |  |  |  |  | 40 |  |  |  |  | 31 |  |  |  |  | 34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 |  |  |  |  | 27 |  |  |  |  | 38 |  |  |  |  | 36 |  |  |  |  | 31 |  |  |  |  | 38
TOTALS
Competitors Played |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
BUFFER
 |  |  |  |  |  | 1st Place |  |  |  |  |  |  |  | 2nd Place |  |  |  | 3rd Place in Green |  | 3rd Place |  |  |  |  |  |  |  |  | Challenging |  |  |  | Handicap cut |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Largest
 |  |  |  |  |  | Handicap cut
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Red Course  Handicap cuts |  |  |  |  |  |  |  |  |  | Blue Course Handicap cuts
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <=Buffer - No Change |  |  |  |  |  |  |  |  |  | <= Buffer - No change
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >Buffer |  |  |  | -1 |  |  |  |  |  | >(Buffer)  -1
Number of Rounds -2
Lowest
2nd Lowest
Add 2 lowest
Total Scores
Total scores - 2 worst
Average
Corrected Average
BUFFER Corrected Ave