ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Intensity =icu_normalized_watts/icu_FTP)
3
(e9/e10)
4
5
load =(seconds*icu_normalized_watts *icu_intensity) / (icu_FTP*3600)*100
6
(b13*E9*E11) / (E10*3600)*100
7
8
Fields headings
Values
Excel formula
9
icu_normalized_watts
174
10
icu_FTP264
11
icu_intensity
0.65909=E9/E10
12
icu_ave_watts
137
13
moving_time (seconds)
11347
14
1 hour (in seconds)
3600
15
constant100
16
icu_training_load
137=(E13*E9*E11)/(E10*3600)*100
17
icu_fitness
= CTLyesterday + (TSStoday - CTLyesterday)(1/CTL time constant)
18
date:19/7/20266.4
=VLOOKUP(B15,$C$20:$E$92,3,FALSE)+(VLOOKUP(B15,$C$20:$D$92,2,FALSE)-VLOOKUP(B15,$C$20:$E$92,3,FALSE))*(1/42)
19
icu_fatigue
=ATLyesterday + (TSStoday - ATLyesterday)(1/ATL time constant)
20
date:19/7/20266.4
=VLOOKUP(B15,$C$20:$E$92,3,FALSE)+(VLOOKUP(B15,$C$20:$D$92,2,FALSE)-VLOOKUP(B15,$C$20:$E$92,3,FALSE))*(1/42)
21
22
DateLoadFitnessFatigue
23
26/4/202648.448.8
<---- add opening fitness and fatigue values, for this date.
24
25
119/07/202606.40.0
26
218/07/202606.60.0
27
317/07/202606.70.0
<--- Fatigue of 0 =G28+($C27-G28)*(1/7)
28
416/07/202606.90.0
29
515/07/202607.00.0
<--- Fitness of 7 =E28+($C27-E28)*(1/42)
30
614/07/202607.20.0
31
713/07/202607.40.0
32
812/07/202607.60.0
33
911/07/202607.80.0
34
1010/07/202607.90.0
35
1109/07/202608.10.0
36
1208/07/202608.30.0
37
1307/07/202608.50.0
38
1406/07/202608.80.0
39
1505/07/202609.00.0
40
1604/07/202609.20.0
41
1703/07/202609.40.0
42
1802/07/202609.60.0
43
1901/07/202609.90.0
44
2030/06/2026010.10.0
45
2129/06/2026010.40.0
46
2228/06/2026010.60.0
47
2327/06/2026010.90.0
48
2426/06/2026011.10.0
49
2525/06/2026011.40.0
50
2624/06/2026011.70.0
51
2723/06/2026012.00.0
52
2822/06/2026012.30.0
53
2921/06/2026012.60.0
54
3020/06/2026012.90.0
55
3119/06/2026013.20.0
56
3218/06/2026013.50.0
57
3317/06/2026013.80.0
58
3416/06/2026014.20.0
59
3515/06/2026014.50.0
60
3614/06/2026014.90.0
61
3713/06/2026015.20.0
62
3812/06/2026015.60.0
63
3911/06/2026016.00.0
64
4010/06/2026016.40.0
65
4109/06/2026016.80.1
66
4208/06/2026017.20.1
67
4307/06/2026017.60.1
68
4406/06/2026018.00.1
69
4505/06/2026018.50.1
70
4604/06/2026018.90.1
71
4703/06/2026019.40.1
72
4802/06/2026019.90.2
73
4901/06/2026020.30.2
74
5031/05/2026020.80.2
75
5130/05/2026021.30.3
76
5229/05/2026021.90.3
77
5328/05/2026022.40.4
78
5427/05/2026022.90.4
79
5526/05/2026023.50.5
80
5625/05/2026024.10.6
81
5724/05/2026024.70.7
82
5823/05/2026025.30.8
83
5922/05/2026025.90.9
84
6021/05/2026026.51.0
85
6120/05/2026027.21.2
86
6219/05/2026027.81.4
87
6318/05/2026028.51.6
88
6417/05/2026029.21.9
89
6516/05/2026029.92.2
90
6615/05/2026030.62.6
91
6714/05/2026031.43.0
92
6813/05/2026032.13.5
93
6912/05/2026032.94.1
94
7011/05/2026033.74.8
95
7110/05/2026034.65.6
96
7209/05/2026035.46.6
97
7308/05/2026036.37.7
98
7407/05/2026037.19.0
99
7506/05/2026038.110.4
100
7605/05/2026039.012.2