Spreadsheet: 738860d1625302673-adding-a-max-to-a-formula-to-prevent-a-return-of-a-minus-result-midshires-master
Sheet: CSS

coefficient | categories
 | 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 | Category | POINTS | Buffer Zone | Buffer Zone | CATEGORY 1 |  | PERCENTAGES |  | ROUNDED
 |  |  |  |  | CATEGORY 2
 |  |  |  |  | CATEGORY 3 & 4
 |  |  |  | 36 | TOTAL |  |  | I
 |  |  |  | 36 |  |  |  | J
 |  |  |  |  | par |  |  | K
 |  |  |  |  |  |  |  | L
 |  |  |  |  | sss
 |  |  |  |  |  | 3 | 2 | 1 | 0 | -1 | RO
 |  | total