ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Lap 1 is shown in a separate cell (I2) due to the graphs breaking when placed in the table below.Current Try's Lap 1Best LapMedian LapWorst Lap
2
E05 HUNTCurrent tryPace (in secs)Current paceWR - lap timesWR - final time57,2753,2553,2553,25
3
Lap 0253,253199,0219,0253,2525,14
4
Lap 033199,02#DIV/0!53,1425,14
5
Lap 043199,02#DIV/0!53,2525,14
6
Lap 053199,02#DIV/0!53,3425,14
7
Lap 063199,02#DIV/0!53,3125,14
8
Lap 073199,02#DIV/0!53,2025,14
9
Lap 083199,02#DIV/0!53,5325,14
10
Lap 093199,02#DIV/0!53,1625,14
11
Lap 103199,02#DIV/0!53,1225,14
12
Lap 113199,02#DIV/0!53,2025,14
13
Lap 123199,02#DIV/0!53,2925,14
14
Lap 133199,02#DIV/0!53,3125,14
15
Lap 143199,02#DIV/0!53,2825,14
16
Lap 153199,02#DIV/0!53,2725,14
17
Lap 163199,02#DIV/0!53,2825,14
18
Lap 173199,02#DIV/0!53,3325,14
19
Lap 183199,02#DIV/0!53,2625,14
20
Lap 193199,02#DIV/0!53,5325,14
21
Lap 203199,02#DIV/0!53,1725,14
22
Lap 213199,02#DIV/0!53,2525,14
23
Lap 223199,02#DIV/0!53,3025,14
24
Lap 233199,02#DIV/0!53,1825,14
25
Lap 243199,02#DIV/0!53,3925,14
26
Lap 253199,02#DIV/0!54,4525,14
27
Lap 263199,02#DIV/0!53,5625,14
28
Lap 273199,02#DIV/0!53,5625,14
29
Lap 283199,02#DIV/0!53,5125,14
30
Lap 293199,02#DIV/0!53,2325,14
31
Lap 303199,02#DIV/0!53,2625,14
32
Lap 313199,02#DIV/0!53,3225,14
33
Lap 323199,02#DIV/0!53,4425,14
34
Lap 333199,02#DIV/0!53,5525,14
35
Lap 343199,02#DIV/0!53,3125,14
36
Lap 353199,02#DIV/0!53,2825,14
37
Lap 363199,02#DIV/0!53,1925,14
38
Lap 373199,02#DIV/0!53,1825,14
39
Lap 383199,02#DIV/0!53,3025,14
40
Lap 393199,02#DIV/0!54,0625,14
41
Lap 403199,02#DIV/0!53,2525,14
42
Lap 413199,02#DIV/0!53,3925,14
43
Lap 423199,02#DIV/0!53,3125,14
44
Lap 433199,02#DIV/0!53,4725,14
45
Lap 443199,02#DIV/0!53,4125,14
46
Lap 453199,02#DIV/0!53,2825,14
47
Lap 463199,02#DIV/0!53,2025,14
48
Lap 473199,02#DIV/0!53,2525,14
49
Lap 483199,02#DIV/0!53,2625,14
50
Lap 493199,02#DIV/0!53,1525,14
51
Lap 503199,02#DIV/0!53,5025,14
52
Lap 513199,02#DIV/0!53,5025,14
53
Lap 523199,02#DIV/0!53,3325,14
54
Lap 533199,02#DIV/0!53,3025,14
55
Lap 543199,02#DIV/0!53,2325,14
56
Lap 553199,02#DIV/0!53,3725,14
57
Lap 563199,02#DIV/0!53,4025,14
58
Lap 573199,02#DIV/0!53,4325,14
59
Lap 583199,02#DIV/0!53,4925,14
60
Lap 593199,02#DIV/0!53,3425,14
61
Lap 603199,02#DIV/0!53,4725,14
62
63
Laps remaining:58
64
Current average lap:53,250(excluding lap 1)
65
In order to get 53:1x.xx, the average lap time of53,267
is required for the remaining laps.
<-- This is more useful than the pace in the last laps | The formula here is:
(goal time - Sum of all finished laps) / Laps remaining
66
In order to get 53:20.xx, the average lap time of53,284
is required for the remaining laps.
67
In order to get 53:21.xx, the average lap time of53,301
is required for the remaining laps.
68
In order to get 53:22.xx, the average lap time of53,318
is required for the remaining laps.
69
In order to get 53:23.xx, the average lap time of53,336
is required for the remaining laps.
70
In order to get 53:24.xx, the average lap time of53,353
is required for the remaining laps.
71
In order to beat the WR, the average lap time of53,355
is required for the remaining laps.
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100