Spreadsheet: 793449d1661491121-upgrade-from-vlookup-to-index-and-match-excel-help
Sheet: Handicaps

MIDSHIRES HANDICAPS |  |  |  |  |  | MIDSHIRES HANDICAPS |  |  | event | 1 | 2 |  | 3 | 4 | 5 | 6 |  |  | 7 | 8 | 9 |  |  | 10 | 11
Members |  |  |  |  |  | Members |  |  | days | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 2 | 3 | 1 | 1 | 1 | 2 | 3 | 1 | 1 | 2 | 3 | 4
PLAYER | Exact | PLAYING | PLAYER | Exact | PLAYING | PLAYER | Exact | Play | Off | Adj | Adj | Adj | Adj | Adj | Adj | Adj | Adj | Adj | Adj | Adj | Adj | Adj | Adj | Adj | Adj | Adj | Adj | Adj
 |  |  |  |  |  |  |  |  | 18.4 | 0 | 0.3 | 0.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 45.4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 29.8 | -4.5 | 0.4 | 0.2 | 0 | 0.3 | 0.4 | 0 | 0 | 0 | 0.7 | 0.3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 13.9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 25.7 | 0.8 | 0 | 0 | 0.6 | -1.4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 22.6 | 0 | 0.4 | 0.2 | 0 | 0.3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 31 | 0 | 0 | 0 | 0 | 0 | 0 | -0.8 | 0.8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 13 | 0 | 0 | 0 | 0.5 | 0.2 | 0 | 0.6 | 0.6 | 0.8 | 0.6 | 0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 16.2 | 0 | 0 | 0 | 0 | 0.2 | 0 | 0 | 0 | 0 | 0.6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 14.6 | 0 | 0 | 0 | 0 | 0.2 | 0 | 0 | 0 | 0 | 0.6 | 0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 15 | 0 | 0.3 | 0 | 0 | 0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 17.9 | 0 | 0.3 | 0.1 | 0.5 | 0 | 0 | 0 | 0 | 0 | -0.4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 8.4 | 0 | 0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 32.7 | 0 | 0.5 | 0.3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 13 | 0.7 | 0.3 | 0.1 | 0.5 | 0.2 | 0.3 | 0 | 0 | 0 | 0.6 | 0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 11 | 0.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 16.7 | 0 | 0.3 | 0.1 | 0.5 | 0.2 | 0 | 0 | 0 | 0 | 0 | 0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 37.4 | 0 | 0.5 | 0.3 | 0.7 | -3.9 | 0 | 0 | 0 | 0 | -7.3 | 0.3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 18.5 | 0 | 0.4 | 0.2 | 0.5 | 0 | 0.4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 8.5 | 0 | 0 | 0 | 0 | 0 | 0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 19.8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.7 | 0.3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 22.6 | 0 | 0 | 0 | 0 | 0.3 | 0.4 | 0.7 | 0 | 0.9 | -0.6 | 0.3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 11.2 | 0 | 0 | 0 | 0.5 | 0.2 | -2 | 0 | 0 | 0 | 0.6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NON-MEMBERS |  |  |  |  |  |  |  |  | 10.8 | 0 | 0.3 | -1.1 | 0.5 | 0.2 | 0.3 | 0 | 0 | 0 | 0.6 | 0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 30.4 | 0 | 0.5 | 0.3 | 0.7 | 0.4 | 0.5 | 0.8 | 0 | -4.6 | 0 | 0.3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 8.1 | 0 | 0.2 | 0 | 0 | 0.1 | 0.2 | 0.5 | 0.5 | 0.8 | 0 | 0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 9.2 | 0 | 0.2 | -1.4 | 0.4 | -1.4 | 0 | 0 | 0 | 0 | 0 | -1.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 23.9 | 0 | -2.9 | 0.2 | 0 | 0 | 0.4 | 0.7 | 0.7 | 0.9 | 0 | -1.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 16.6 | 0 | 0.3 | 0.1 | 0.5 | 0.2 | 0.3 | 0.6 | 0.6 | 0.8 | -0.6 | 0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 16.3 | 0.7 | 0.3 | 0.1 | 0.5 | 0.2 | 0 | 0.6 | 0.6 | -3.9 | 0.6 | 0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 20.7 | 0 | 0.4 | 0.2 | 0.6 | 0.3 | 0.4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 11.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 5.2 | 0.6 | -0.1 | -0.3 | 0 | 0.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 26.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 23.4 | 0.8 | 0.4 | 0.2 | 0.6 | 0.3 | 0 | 0.7 | 0.7 | -1.4 | 0 | 0.3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 10.3 | 0.7 | 0 | 0 | 0 | 0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 14.9 | 0.7 | 0.3 | 0.1 | 0.5 | 0.2 | 0 | 0.6 | -2.6 | 0.8 | 0.6 | 0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 14.9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 31.3 | 0 | 0.5 | 0.3 | 0.7 | 0.4 | 0 | -6.2 | 0.7 | 0.9 | 0.7 | 0.3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 34.8 | -3.5 | 0 | 0 | -6.3 | 0.3 | 0 | 0.7 | -2.6 | 0.9 | 0.7 | 0.3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 23.8 | 0.8 | 0.4 | 0.2 | -3.4 | 0.3 | 0.4 | -1.6 | -1 | 0.9 | 0.7 | 0.3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 12.7 | 0 | 0.3 | 0.1 | 0 | 0 | 0.3 | 0 | 0 | 0 | 0.6 | 0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 18.8 | -0.9 | 0.3 | 0.1 | 0 | 0.2 | 0.3 | 0 | 0 | 0 | 0 | 0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 9.4 | 0 | 0.2 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 12 | 0.7 | 0.3 | 0.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.6 | 0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 18.4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 26 | 0 | 0 | 0 | 0 | 0.6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 8.8 | 0.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -0.6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 9.3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 27.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.9 | 0 | 1.1 | 0 | -2.9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 21 | 0 | 0.3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 29 | 0 | 0 | 0 | 0.6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 18.3 | 0 | 0.4 | 0 | 0.6 | 0 | 0.4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 18 | 0 | 0 | 0 | 0.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 12.3 | 0.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1.3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 17.3 | 0 | 0 | 0 | 0 | 0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 30.4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 18.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -2.9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 17.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 30.1 | 0 | 0 | 0 | 0 | 0 | -1.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 23.5 | 0 | -5.5 | 0 | -1.1 | 0.2 | 0 | 0.6 | 0.6 | 0.8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 22.9 | 0 | 0.3 | 0.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0