Spreadsheet: 818942d1677136521-automating-results-across-sheets-pt-scoring-system_v1
Sheet: Scoring System 1.6km

Less than 30 BMI |  |  |  |  |  |  | More than 30 BMI
Sit Up # (2 mins) | Score % | Push Up # (2mins) | Score % | 1.6km Run Time | Score % |  | Sit Up # (2 mins) | Score % | Push Up # (2mins) | Score % | 1.6km Run Time | Score %
100 | 1 | 100 | 1 | 0 | 1 |  | 100 | 1 | 100 | 1 | 0 | 1
99 | 1 | 99 | 1 | 0.1 | 1 |  | 99 | 1 | 99 | 1 | 0.1 | 1
98 | 1 | 98 | 1 | 0.2 | 1 |  | 98 | 1 | 98 | 1 | 0.2 | 1
97 | 1 | 97 | 1 | 0.3 | 1 |  | 97 | 1 | 97 | 1 | 0.3 | 1
96 | 1 | 96 | 1 | 0.4 | 1 |  | 96 | 1 | 96 | 1 | 0.4 | 1
95 | 1 | 95 | 1 | 0.5 | 1 |  | 95 | 1 | 95 | 1 | 0.5 | 1
94 | 1 | 94 | 1 | 1 | 1 |  | 94 | 1 | 94 | 1 | 1 | 1
93 | 1 | 93 | 1 | 1.1 | 1 |  | 93 | 1 | 93 | 1 | 1.1 | 1
92 | 1 | 92 | 1 | 1.2 | 1 |  | 92 | 1 | 92 | 1 | 1.2 | 1
91 | 1 | 91 | 1 | 1.3 | 1 |  | 91 | 1 | 91 | 1 | 1.3 | 1
90 | 1 | 90 | 1 | 1.4 | 1 |  | 90 | 1 | 90 | 1 | 1.4 | 1
89 | 1 | 89 | 1 | 1.5 | 1 |  | 89 | 1 | 89 | 1 | 1.5 | 1
88 | 1 | 88 | 1 | 2 | 1 |  | 88 | 1 | 88 | 1 | 2 | 1
87 | 1 | 87 | 1 | 2.1 | 1 |  | 87 | 1 | 87 | 1 | 2.1 | 1
86 | 1 | 86 | 1 | 2.2 | 1 |  | 86 | 1 | 86 | 1 | 2.2 | 1
85 | 1 | 85 | 1 | 2.3 | 1 |  | 85 | 1 | 85 | 1 | 2.3 | 1
84 | 1 | 84 | 1 | 2.4 | 1 |  | 84 | 1 | 84 | 1 | 2.4 | 1
83 | 1 | 83 | 1 | 2.5 | 1 |  | 83 | 1 | 83 | 1 | 2.5 | 1
82 | 1 | 82 | 1 | 3 | 1 |  | 82 | 1 | 82 | 1 | 3 | 1
81 | 1 | 81 | 1 | 3.1 | 1 |  | 81 | 1 | 81 | 1 | 3.1 | 1
80 | 1 | 80 | 1 | 3.2 | 1 |  | 80 | 1 | 80 | 1 | 3.2 | 1
79 | 1 | 79 | 1 | 3.3 | 1 |  | 79 | 1 | 79 | 1 | 3.3 | 1
78 | 1 | 78 | 1 | 3.4 | 1 |  | 78 | 1 | 78 | 1 | 3.4 | 1
77 | 1 | 77 | 1 | 3.5 | 1 |  | 77 | 1 | 77 | 1 | 3.5 | 1
76 | 1 | 76 | 1 | 4 | 1 |  | 76 | 1 | 76 | 1 | 4 | 1
75 | 1 | 75 | 1 | 4.1 | 1 |  | 75 | 1 | 75 | 1 | 4.1 | 1
74 | 1 | 74 | 1 | 4.2 | 1 |  | 74 | 1 | 74 | 1 | 4.2 | 1
73 | 1 | 73 | 1 | 4.3 | 1 |  | 73 | 1 | 73 | 1 | 4.3 | 1
72 | 1 | 72 | 1 | 4.4 | 1 |  | 72 | 1 | 72 | 1 | 4.4 | 1
71 | 1 | 71 | 1 | 4.5 | 1 |  | 71 | 1 | 71 | 1 | 4.5 | 1
70 | 1 | 70 | 1 | 5 | 1 |  | 70 | 1 | 70 | 1 | 5 | 1
69 | 1 | 69 | 1 | 5.1 | 1 |  | 69 | 1 | 69 | 1 | 5.1 | 1
68 | 1 | 68 | 1 | 5.2 | 1 |  | 68 | 1 | 68 | 1 | 5.2 | 1
67 | 1 | 67 | 1 | 5.3 | 1 |  | 67 | 1 | 67 | 1 | 5.3 | 1
66 | 1 | 66 | 1 | 5.4 | 1 |  | 66 | 1 | 66 | 1 | 5.4 | 1
65 | 1 | 65 | 1 | 5.5 | 1 |  | 65 | 1 | 65 | 1 | 5.5 | 1
64 | 1 | 64 | 1 | 6 | 1 |  | 64 | 1 | 64 | 1 | 6 | 1
63 | 1 | 63 | 1 | 6.1 | 1 |  | 63 | 1 | 63 | 1 | 6.1 | 1
62 | 1 | 62 | 1 | 6.2 | 1 |  | 62 | 1 | 62 | 1 | 6.2 | 1
61 | 1 | 61 | 1 | 6.3 | 1 |  | 61 | 1 | 61 | 1 | 6.3 | 1
60 | 1 | 60 | 1 | 6.4 | 1 |  | 60 | 1 | 60 | 1 | 6.4 | 1
59 | 1 | 59 | 1 | 6.5 | 1 |  | 59 | 1 | 59 | 1 | 6.5 | 1
58 | 1 | 58 | 1 | 7 | 1 |  | 58 | 1 | 58 | 1 | 7 | 1
57 | 1 | 57 | 1 | 7.1 | 0.98 |  | 57 | 1 | 57 | 1 | 7.1 | 1
56 | 1 | 56 | 1 | 7.2 | 0.96 |  | 56 | 1 | 56 | 1 | 7.2 | 1
55 | 1 | 55 | 1 | 7.3 | 0.94 |  | 55 | 1 | 55 | 1 | 7.3 | 1
54 | 1 | 54 | 1 | 7.4 | 0.92 |  | 54 | 1 | 54 | 1 | 7.4 | 1
53 | 1 | 53 | 1 | 7.5 | 0.9 |  | 53 | 1 | 53 | 1 | 7.5 | 1
52 | 1 | 52 | 1 | 8 | 0.88 |  | 52 | 1 | 52 | 1 | 8 | 1
51 | 1 | 51 | 1 | 8.1 | 0.86 |  | 51 | 1 | 51 | 1 | 8.1 | 1
50 | 1 | 50 | 1 | 8.2 | 0.84 |  | 50 | 1 | 50 | 1 | 8.2 | 1
49 | 1 | 49 | 1 | 8.3 | 0.82 |  | 49 | 1 | 49 | 1 | 8.3 | 1
48 | 1 | 48 | 1 | 8.4 | 0.8 |  | 48 | 1 | 48 | 1 | 8.4 | 1
47 | 1 | 47 | 1 | 8.5 | 0.78 |  | 47 | 1 | 47 | 1 | 8.5 | 1
46 | 1 | 46 | 1 | 9 | 0.76 |  | 46 | 1 | 46 | 1 | 9 | 1
45 | 1 | 45 | 1 | 9.1 | 0.74 |  | 45 | 1 | 45 | 1 | 9.1 | 1
44 | 1 | 44 | 1 | 9.2 | 0.72 |  | 44 | 1 | 44 | 1 | 9.2 | 1
43 | 1 | 43 | 1 | 9.3 | 0.7 |  | 43 | 1 | 43 | 1 | 9.3 | 1
42 | 1 | 42 | 1 | 9.4 | 0.68 |  | 42 | 1 | 42 | 1 | 9.4 | 1
41 | 1 | 41 | 1 | 9.5 | 0.66 |  | 41 | 1 | 41 | 1 | 9.5 | 1
40 | 1 | 40 | 1 | 10 | 0.64 |  | 40 | 1 | 40 | 1 | 10 | 1
39 | 1 | 39 | 1 | 10.1 | 0.62 |  | 39 | 1 | 39 | 1 | 10.1 | 1
38 | 1 | 38 | 1 | 10.2 | 0.6 |  | 38 | 1 | 38 | 1 | 10.2 | 1
37 | 1 | 37 | 1 | 10.3 | 0.58 |  | 37 | 1 | 37 | 1 | 10.3 | 1
36 | 1 | 36 | 1 | 10.4 | 0.56 |  | 36 | 1 | 36 | 1 | 10.4 | 1
35 | 0.98 | 35 | 1 | 10.5 | 0.54 |  | 35 | 1 | 35 | 1 | 10.5 | 1
34 | 0.96 | 34 | 1 | 11 | 0.52 |  | 34 | 1 | 34 | 1 | 11 | 1
33 | 0.94 | 33 | 0.98 | 11.1 | 0.5 |  | 33 | 1 | 33 | 1 | 11.1 | 1
32 | 0.92 | 32 | 0.96 | 11.2 | 0.48 |  | 32 | 1 | 32 | 1 | 11.2 | 1
31 | 0.9 | 31 | 0.94 | 11.3 | 0.46 |  | 31 | 1 | 31 | 1 | 11.3 | 1
30 | 0.88 | 30 | 0.92 | 11.4 | 0.44 |  | 30 | 1 | 30 | 1 | 11.4 | 1
29 | 0.86 | 29 | 0.9 | 11.5 | 0.42 |  | 29 | 1 | 29 | 1 | 11.5 | 1
28 | 0.84 | 28 | 0.88 | 12 | 0.4 |  | 28 | 1 | 28 | 1 | 12 | 1
27 | 0.82 | 27 | 0.86 | 12.1 | 0.38 |  | 27 | 1 | 27 | 1 | 12.1 | 1
26 | 0.8 | 26 | 0.84 | 12.2 | 0.36 |  | 26 | 1 | 26 | 1 | 12.2 | 1
25 | 0.78 | 25 | 0.82 | 12.3 | 0.34 |  | 25 | 1 | 25 | 1 | 12.3 | 1
24 | 0.76 | 24 | 0.8 | 12.4 | 0.32 |  | 24 | 1 | 24 | 1 | 12.4 | 1
23 | 0.74 | 23 | 0.78 | 12.5 | 0.3 |  | 23 | 1 | 23 | 1 | 12.5 | 0.98
22 | 0.72 | 22 | 0.76 | 13 | 0.28 |  | 22 | 1 | 22 | 1 | 13 | 0.96
21 | 0.7 | 21 | 0.74 | 13.1 | 0.26 |  | 21 | 1 | 21 | 1 | 13.1 | 0.94
20 | 0.68 | 20 | 0.72 | 13.2 | 0.24 |  | 20 | 1 | 20 | 1 | 13.2 | 0.92
19 | 0.66 | 19 | 0.7 | 13.3 | 0.22 |  | 19 | 1 | 19 | 1 | 13.3 | 0.9
18 | 0.64 | 18 | 0.68 | 13.4 | 0.2 |  | 18 | 1 | 18 | 1 | 13.4 | 0.88
17 | 0.62 | 17 | 0.66 | 13.5 | 0.18 |  | 17 | 1 | 17 | 1 | 13.5 | 0.86
16 | 0.6 | 16 | 0.64 | 14 | 0.16 |  | 16 | 1 | 16 | 1 | 14 | 0.84
15 | 0.56 | 15 | 0.62 | 14.1 | 0.14 |  | 15 | 1 | 15 | 1 | 14.1 | 0.82
14 | 0.52 | 14 | 0.6 | 14.2 | 0.12 |  | 14 | 1 | 14 | 1 | 14.2 | 0.8
13 | 0.48 | 13 | 0.56 | 13.3 | 0.1 |  | 13 | 1 | 13 | 1 | 14.3 | 0.78
12 | 0.44 | 12 | 0.52 | 14.4 | 0.08 |  | 12 | 0.92 | 12 | 1 | 14.4 | 0.76
11 | 0.4 | 11 | 0.48 | 14.5 | 0.06 |  | 11 | 0.84 | 11 | 0.95 | 14.5 | 0.74
10 | 0.36 | 10 | 0.44 | 15 | 0.04 |  | 10 | 0.76 | 10 | 0.9 | 15 | 0.72
9 | 0.320000000000001 | 9 | 0.4 | 15.1 | 0.02 |  | 9 | 0.68 | 9 | 0.85 | 15.1 | 0.7
8 | 0.280000000000001 | 8 | 0.36 | 15.2 | 0 |  | 8 | 0.6 | 8 | 0.8 | 15.2 | 0.68
7 | 0.240000000000001 | 7 | 0.32 | 15.3 | 0 |  | 7 | 0.55 | 7 | 0.75 | 15.3 | 0.66
6 | 0.200000000000001 | 6 | 0.28 | 15.4 | 0 |  | 6 | 0.5 | 6 | 0.7 | 15.4 | 0.64
5 | 0.160000000000001 | 5 | 0.24 | 15.5 | 0 |  | 5 | 0.45 | 5 | 0.65 | 15.5 | 0.62
4 | 0.120000000000001 | 4 | 0.2 | 16 | 0 |  | 4 | 0.36 | 4 | 0.6 | 16 | 0.6
3 | 0.080000000000001 | 3 | 0.15 | 16.1 | 0 |  | 3 | 0.27 | 3 | 0.5 | 16.1 | 0.58
2 | 0.0400000000000009 | 2 | 0.1 | 16.2 | 0 |  | 2 | 0.18 | 2 | 0.4 | 16.2 | 0.56
1 | 0.02 | 1 | 0.05 | 16.3 | 0 |  | 1 | 0.09 | 1 | 0.3 | 16.3 | 0.54
0 | 0 | 0 | 0 | 16.4 | 0 |  | 0 | 0 | 0 | 0 | 16.4 | 0.52
 |  |  |  | 16.5 | 0 |  |  |  |  |  | 16.5 | 0.5
 |  |  |  | 17 | 0 |  |  |  |  |  | 17 | 0.48
 |  |  |  | 17.1 | 0 |  |  |  |  |  | 17 | 0.46
 |  |  |  | 17.2 | 0 |  |  |  |  |  | 17.2 | 0.44
 |  |  |  | 17.3 | 0 |  |  |  |  |  | 17.3 | 0.42
 |  |  |  | 17.4 | 0 |  |  |  |  |  | 17.4 | 0.4
 |  |  |  | 17.5 | 0 |  |  |  |  |  | 17.5 | 0.38
 |  |  |  | 18 | 0 |  |  |  |  |  | 18 | 0.36
 |  |  |  | 18.1 | 0 |  |  |  |  |  | 18.1 | 0.34
 |  |  |  | 18.2 | 0 |  |  |  |  |  | 18.2 | 0.32
 |  |  |  | 18.3 | 0 |  |  |  |  |  | 18.3 | 0.3
 |  |  |  | 18.4 | 0 |  |  |  |  |  | 18.4 | 0.28
 |  |  |  | 18.5 | 0 |  |  |  |  |  | 18.5 | 0.26
 |  |  |  | 19 | 0 |  |  |  |  |  | 19 | 0.24
 |  |  |  | 19.1 | 0 |  |  |  |  |  | 19.1 | 0.22
 |  |  |  | 19.2 | 0 |  |  |  |  |  | 19.2 | 0.2
 |  |  |  | 19.3 | 0 |  |  |  |  |  | 19.3 | 0.18
 |  |  |  | 19.4 | 0 |  |  |  |  |  | 19.4 | 0.16
 |  |  |  | 19.5 | 0 |  |  |  |  |  | 19.5 | 0.14
 |  |  |  | 20 | 0 |  |  |  |  |  | 20 | 0.12
 |  |  |  |  |  |  |  |  |  |  | 20.1 | 0.1
 |  |  |  |  |  |  |  |  |  |  | 20.2 | 0.08
 |  |  |  |  |  |  |  |  |  |  | 20.3 | 0.06
 |  |  |  |  |  |  |  |  |  |  | 20.4 | 0.04
 |  |  |  |  |  |  |  |  |  |  | 20.5 | 0.02
 |  |  |  |  |  |  |  |  |  |  | 21 | 0