| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Time (mins) | VO2max (watts) | ||||||||||||||||||||
2 | 0 | Very low | -20 | -5.1 | -0.5 | -5.7 | -20 | 0 | #REF! | |||||||||||||
3 | Effect of Temp on Endurance Performance | 0.15 | Low | -19 | -4.9 | -0.5 | -5.4 | -19 | 5 | #REF! | ||||||||||||
4 | Effect of temperature of cycling speed and watts (VO2max vs aero)....also works with running | 0.29 | Medium | -18 | -4.6 | -0.5 | -5.1 | -18 | 10 | #REF! | Woa, are you sure?! | |||||||||||
5 | .........................INPUTS.................................................. | 0.44 | High | -17 | -4.4 | -0.5 | -4.8 | -17 | 15 | #REF! | That's a big change! | |||||||||||
6 | 0.63 | Very high | -16 | -4.1 | -0.5 | -4.6 | -16 | #REF! | That's a definate improvement! | |||||||||||||
7 | Temp during event ☀️ | 30.0 deg | #REF! | #REF! | 0.79 | Extreme | -15 | -3.9 | -0.5 | -4.3 | -15 | #REF! | A small improvement | |||||||||
8 | Likley Temp during your race? | #REF! | 30 | 72.0 deg | #REF! | -14 | -3.6 | -0.4 | -4.1 | -14 | #REF! | No change | ||||||||||
9 | #REF! | #REF! | ||||||||||||||||||||
10 | Humidity (if known) | 80 | #REF! | #ERROR! | #REF! | #ERROR! | if e10 > 85.0 and h9 >= 80.0 and h9 <= 87.0 then ((-42.379 + 2.04901523*h9 + 10.14333127*e10 - .22475541*h9*e10 - .00683783*h9*e10 - .05481717*h9*e10 + .00122874*h9*h9*e10 + .00085282*h9*e10*e10 - .00000199*h9*h9*e10*e10) + (( e10-85.0 )/10.0) *((87.0-h9)/5.0)), (-42.379 + 2.04901523*h9 + 10.14333127*e10 - .22475541*h9*e10 - .00683783*h9*e10 - .05481717*h9*e10 + .00122874*h9*h9*e10 + .00085282*h9*e10*e10 - .00000199*h9*h9*e10*e10) | 0 | Heat Index = OK | |||||||||||||
11 | humidity | #REF! | #REF! | 80 | Heat Index = Caution | -13 | -3.4 | -0.4 | -3.8 | -13 | #REF! | A small increase | ||||||||||
12 | 90 | Heat Index = Risky | ||||||||||||||||||||
13 | Event Duration ⏳ | 20 mins | aka 0.3hrs | 0.5 | 106 | Heat Index = Danger | -12 | -3.2 | -0.4 | -3.6 | -12 | #REF! | A big deterioration in aero! | |||||||||
14 | Estimate time to complete | 20 | 130 | Heat Index = Extreme | -11 | -3.0 | -0.4 | -3.4 | -11 | #REF! | ||||||||||||
15 | -10 | -2.8 | -0.4 | -3.2 | -10 | #REF! | ||||||||||||||||
16 | Your average solo speed | 15.0 | kph | #REF! | -9 | -2.6 | -0.4 | -3.0 | -9 | #REF! | ||||||||||||
17 | Usual riding (or running) speed | 15.0 | 30.2488537 | -8 | -2.5 | -0.3 | -2.8 | -8 | #REF! | |||||||||||||
18 | .........................OUTPUTS.................................................. | -7 | -2.3 | -0.3 | -2.6 | -7 | #REF! | |||||||||||||||
19 | -6 | -2.1 | -0.3 | -2.4 | -6 | #REF! | ||||||||||||||||
20 | allow 10s to calculate | #REF! | -5 | -2.0 | -0.3 | -2.3 | -5 | #REF! | ||||||||||||||
21 | Effect on performance@Tempo | 0.0 watts | FALSE | -4 | -1.8 | -0.3 | -2.1 | -4 | #REF! | |||||||||||||
22 | Effect on overall performance over your event | 0 | 0 | -3 | -1.7 | -0.3 | -2.0 | -3 | #REF! | |||||||||||||
23 | Effect on performance@VO2max (will be up to 2x) | -2 | -1.6 | -0.3 | -1.8 | -2 | #REF! | |||||||||||||||
24 | Effect on aero drag | 0.0 watts | drag | #REF! | -1 | -1.5 | -0.2 | -1.7 | -1 | #REF! | ||||||||||||
25 | Effect on aero translated into watts | 0 | -1.4 | -0.2 | -1.6 | 0 | #REF! | |||||||||||||||
26 | OVERALL EFFECT@ 30deg | 0.00 watts | 1 | -1.3 | -0.2 | -1.5 | 1 | #REF! | ||||||||||||||
27 | 2 | -1.2 | -0.2 | -1.4 | 2 | #REF! | ||||||||||||||||
28 | Chance of Heat Exhaustion | Very low (0%) | 0.03 | 3 | -1.1 | -0.2 | -1.3 | 3 | #REF! | |||||||||||||
29 | 4 | -1.1 | -0.2 | -1.2 | 4 | #REF! | ||||||||||||||||
30 | For your event the optimal temp is..... | -4.0 deg | #REF! | 5 | -1.0 | -0.2 | -1.1 | 5 | #REF! | |||||||||||||
31 | (this is the optimal temp for max speed) | 13 | 6 | -0.9 | -0.1 | -1.1 | 6 | #REF! | ||||||||||||||
32 | -0.9 | 7 | -0.9 | -0.1 | -1.0 | 7 | #REF! | |||||||||||||||
33 | 8 | -0.9 | -0.1 | -1.0 | 8 | #REF! | ||||||||||||||||
34 | 9 | -0.8 | -0.1 | -0.9 | 9 | #REF! | ||||||||||||||||
35 | References | 10 | -0.8 | -0.1 | -0.9 | 10 | #REF! | |||||||||||||||
36 | Heat Index | 11 | -0.8 | -0.1 | -0.9 | 11 | #REF! | |||||||||||||||
37 | Blog | 12 | -0.8 | 0.0 | -0.9 | 12 | #REF! | |||||||||||||||
38 | Lancet | 13 | -0.8 | 0.0 | -0.9 | 13 | #REF! | |||||||||||||||
39 | Heat Index Formula | 14 | -0.9 | 0.0 | -0.9 | 14 | #REF! | |||||||||||||||
40 | 15 | -0.9 | 0.0 | -0.9 | 15 | #REF! | ||||||||||||||||
41 | 16 | -0.9 | 0.0 | -0.9 | 16 | #REF! | ||||||||||||||||
42 | 17 | -1.0 | 0.0 | -1.0 | 17 | #REF! | ||||||||||||||||
43 | 18 | -1.1 | 0.0 | -1.0 | 18 | #REF! | ||||||||||||||||
44 | 19 | -1.1 | 0.1 | -1.1 | 19 | #REF! | ||||||||||||||||
45 | 20 | -1.2 | 0.1 | -1.1 | 20 | #REF! | ||||||||||||||||
46 | 21 | -1.3 | 0.1 | -1.2 | 21 | #REF! | ||||||||||||||||
47 | 22 | -1.4 | 0.1 | -1.3 | 22 | #REF! | ||||||||||||||||
48 | 23 | -1.5 | 0.1 | -1.4 | 23 | #REF! | ||||||||||||||||
49 | 24 | -1.6 | 0.1 | -1.5 | 24 | #REF! | ||||||||||||||||
50 | 25 | -1.7 | 0.2 | -1.6 | 25 | #REF! | ||||||||||||||||
51 | 26 | -1.8 | 0.2 | -1.7 | 26 | #REF! | ||||||||||||||||
52 | 27 | -2.0 | 0.2 | -1.8 | 27 | #REF! | ||||||||||||||||
53 | 28 | -2.1 | 0.2 | -1.9 | 28 | #REF! | ||||||||||||||||
54 | 29 | -2.3 | 0.2 | -2.1 | 29 | #REF! | ||||||||||||||||
55 | 30 | -2.5 | 0.2 | -2.2 | 30 | #REF! | ||||||||||||||||
56 | 31 | -2.6 | 0.2 | -2.4 | 31 | #REF! | ||||||||||||||||
57 | 32 | -2.8 | 0.3 | -2.6 | 32 | #REF! | ||||||||||||||||
58 | 33 | -3.0 | 0.3 | -2.7 | 33 | #REF! | ||||||||||||||||
59 | 34 | -3.2 | 0.3 | -2.9 | 34 | #REF! | ||||||||||||||||
60 | 35 | -3.4 | 0.3 | -3.1 | 35 | #REF! | ||||||||||||||||
61 | 36 | -3.6 | 0.3 | -3.3 | 36 | #REF! | ||||||||||||||||
62 | 37 | -3.9 | 0.3 | -3.5 | 37 | #REF! | ||||||||||||||||
63 | 38 | -4.1 | 0.3 | -3.8 | 38 | #REF! | ||||||||||||||||
64 | 39 | -4.4 | 0.4 | -4.0 | 39 | #REF! | ||||||||||||||||
65 | 40 | -4.6 | 0.4 | -4.2 | 40 | #REF! | ||||||||||||||||
66 | 41 | -4.9 | 0.4 | -4.5 | 41 | #REF! | ||||||||||||||||
67 | 42 | -5.1 | 0.4 | -4.7 | 42 | #REF! | ||||||||||||||||
68 | 43 | -5.4 | 0.4 | -5.0 | 43 | #REF! | ||||||||||||||||
69 | 44 | -5.7 | 0.4 | -5.3 | 44 | #REF! | ||||||||||||||||
70 | 45 | -6.0 | 0.5 | -5.6 | 45 | #REF! | ||||||||||||||||
71 | 46 | -6.3 | 0.5 | -5.9 | 46 | #REF! | ||||||||||||||||
72 | 47 | -6.6 | 0.5 | -6.2 | 47 | #REF! |