Spreadsheet: 707420d1607261797-using-a-list-to-reduce-worksheets-midshires-master-ans
Sheet: css

coefficient | catergories
 | 1 | 2 | 3 | 3 "ro" | 3 | 2 | 1 | 0 | -1
 | 0 | 0 | 100 | 6 | 9 | 15 | 22 | 45 | 46
 | 0 | 10 | 90 | 6 | 9 | 15 | 22 | 45 | 46
 | 0 | 20 | 80 | 6 | 9 | 15 | 22 | 45 | 46
 | 0 | 30 | 70 | 6 | 10 | 16 | 23 | 47 | 48
 | 0 | 40 | 60 | 6 | 10 | 16 | 23 | 47 | 48
 | 0 | 50 | 50 | 6 | 10 | 16 | 23 | 47 | 48
 | 0 | 60 | 40 | 6 | 11 | 17 | 25 | 49 | 50
 | 0 | 70 | 30 | 6 | 11 | 17 | 25 | 49 | 50
 | 0 | 80 | 20 | 6 | 11 | 17 | 25 | 49 | 50
 | 0 | 90 | 10 | 6 | 11 | 17 | 25 | 49 | 50
 | 0 | 100 | 0 | 6 | 11 | 18 | 26 | 51 | 52
 | 10 | 0 | 90 | 6 | 9 | 15 | 22 | 45 | 46
 | 10 | 10 | 80 | 6 | 10 | 16 | 23 | 47 | 48
 | 10 | 20 | 70 | 6 | 10 | 16 | 23 | 47 | 48
 | 10 | 30 | 60 | 6 | 10 | 16 | 23 | 47 | 48
 | 10 | 40 | 50 | 6 | 11 | 17 | 25 | 49 | 50
 | 10 | 50 | 40 | 6 | 11 | 17 | 25 | 49 | 50
 | 10 | 60 | 30 | 6 | 11 | 17 | 25 | 49 | 50
 | 10 | 70 | 20 | 6 | 11 | 17 | 25 | 49 | 50
 | 10 | 80 | 10 | 6 | 11 | 18 | 26 | 51 | 52
 | 10 | 90 | 0 | 6 | 11 | 18 | 26 | 51 | 52
 | 20 | 0 | 80 | 6 | 10 | 16 | 23 | 47 | 48
 | 20 | 10 | 70 | 6 | 10 | 16 | 23 | 47 | 48
 | 20 | 20 | 60 | 6 | 10 | 16 | 23 | 47 | 48
 | 20 | 30 | 50 | 6 | 11 | 17 | 25 | 49 | 50
 | 20 | 40 | 40 | 6 | 11 | 17 | 25 | 49 | 50
 | 20 | 50 | 30 | 6 | 11 | 17 | 25 | 49 | 50
 | 20 | 60 | 20 | 6 | 11 | 18 | 26 | 51 | 52
 | 20 | 70 | 10 | 6 | 11 | 18 | 26 | 51 | 52
 | 20 | 80 | 0 | 6 | 11 | 18 | 26 | 51 | 52
 | 30 | 0 | 70 | 6 | 10 | 16 | 23 | 47 | 48
 | 30 | 10 | 60 | 6 | 11 | 17 | 25 | 49 | 50
 | 30 | 20 | 50 | 6 | 11 | 17 | 25 | 49 | 50
 | 30 | 30 | 40 | 6 | 11 | 17 | 25 | 49 | 50
 | 30 | 40 | 30 | 6 | 11 | 18 | 26 | 51 | 52
 | 30 | 50 | 20 | 6 | 11 | 18 | 26 | 51 | 52
 | 30 | 60 | 10 | 6 | 11 | 18 | 26 | 51 | 52
 | 30 | 70 | 0 | 7 | 12 | 19 | 28 | 55 | 56
 | 40 | 0 | 60 | 6 | 11 | 17 | 25 | 49 | 50
 | 40 | 10 | 50 | 6 | 11 | 17 | 25 | 49 | 50
 | 40 | 20 | 40 | 6 | 11 | 18 | 26 | 51 | 52
 | 40 | 30 | 30 | 6 | 11 | 18 | 26 | 51 | 52
 | 40 | 40 | 20 | 6 | 11 | 18 | 26 | 51 | 52
 | 40 | 50 | 10 | 6 | 11 | 18 | 26 | 51 | 52
 | 40 | 60 | 0 | 7 | 12 | 19 | 28 | 55 | 56
 | 50 | 0 | 50 | 6 | 11 | 18 | 26 | 51 | 52
 | 50 | 10 | 40 | 6 | 11 | 18 | 26 | 51 | 52
 | 50 | 20 | 30 | 6 | 11 | 18 | 26 | 51 | 52
 | 50 | 30 | 20 | 6 | 11 | 18 | 26 | 51 | 52
 | 50 | 40 | 10 | 7 | 12 | 19 | 28 | 55 | 56
 | 50 | 50 | 0 | 7 | 12 | 19 | 28 | 55 | 56
 | 60 | 0 | 40 | 6 | 11 | 18 | 26 | 51 | 52
 | 60 | 10 | 30 | 6 | 11 | 18 | 26 | 51 | 52
 | 60 | 20 | 20 | 7 | 12 | 19 | 28 | 55 | 56
 | 60 | 30 | 10 | 7 | 12 | 19 | 28 | 55 | 56
 | 60 | 40 | 0 | 7 | 12 | 19 | 28 | 55 | 56
 | 70 | 0 | 30 | 7 | 12 | 19 | 28 | 55 | 56
 | 70 | 10 | 20 | 7 | 12 | 19 | 28 | 55 | 56
 | 70 | 20 | 10 | 7 | 12 | 19 | 28 | 55 | 56
 | 70 | 30 | 0 | 7 | 12 | 19 | 29 | 57 | 58
 | 80 | 0 | 20 | 7 | 12 | 19 | 28 | 55 | 56
 | 80 | 10 | 10 | 7 | 12 | 19 | 28 | 55 | 56
 | 80 | 20 | 0 | 7 | 12 | 19 | 29 | 57 | 58
 | 90 | 0 | 10 | 7 | 12 | 19 | 29 | 57 | 58
 | 90 | 10 | 0 | 7 | 12 | 19 | 29 | 57 | 58
 | 100 | 0 | 0 | 7 | 12 | 19 | 29 | 57 | 58
competition scratch score
PLAYER | attendance | Category | POINTS | Buffer Zone | CATERGORY 1 |  | PERCENTAGES |  | ROUNDED |  |  | Buffer Zone
 | 0 |  |  |  | CATERGORY 2
 |  |  |  |  | CATERGORY 3
 |  |  |  |  | TOTAL |  |  | I |  |  |  | 36
 |  |  |  |  |  |  |  | J |  |  |  | 36
 |  |  |  |  | par |  |  | K
 |  |  |  |  |  |  |  | L
 |  |  |  |  | sss
 |  |  |  |  |  |  |  | 1 | 0 | -1 | RO
 |  |  |  |  |  | 3 | 2
 |  |  | total