Creating dynamic chart showing last 90 calendar days entries

Ironman

Ironman

Well-known Member
Joined
Jan 31, 2004
Messages
1,069
Office Version
  1. 365
Platform
  1. Windows
Hello

I have literally rubbed my eyebrows away trying desperately to create a dynamic line chart with columns A, G and H from the below data, so the chart shows only the most recent 90 calendar days entries (NOT the last 90 entries - please let me know if it's necessary to insert a daily entry with a zero value for this to work as I would like).

I've looked in the forum and on the net and I just don't understand if I am able to do this directly from this data or if I have to convert the below to a table with just 3 columns and work from that. However, if I create a separate table I cannot understand how the data would copy from the data sheet below to the table.

After many very late hours trying to work it out it myself I've been on the verge of just giving up and I would be so grateful for a solution that will make this work as it's my exercise bike fitness tracker!

Thank you so much!


Book1
ABCDEFGH
10DATETIME (h:mm)DIST. (km)DIST. (mls)SPEED (mph)LEVELHR BPMPower (W)
11Sat, 6 Jan 20180:3315.29.417.2
12Wed, 10 Jan 20180:4321.213.218.4
13Tue, 16 Jan 20180:4821.213.216.5
14Fri, 19 Jan 20180:5222.213.815.9
15Tue, 23 Jan 20180:5326.316.318.5>100
16Thu, 25 Jan 20180:4621.313.217.3
17Sat, 27 Jan 20180:4520.012.416.6
18Sun, 28 Jan 20180:4620.712.916.8
19Wed, 31 Jan 20180:5023.614.717.6122
20Wed, 14 Feb 20180:4521.013.017.4
21Thu, 22 Feb 20180:4520.913.017.3<120
22Sun, 4 Mar 20180:4521.013.017.4<110
23Tue, 6 Mar 20180:4822.013.717.1111
24Sat, 10 Mar 20180:4720.812.916.5
25Sat, 17 Mar 20181:0125.816.015.8110
26Thu, 12 Apr 20180:4519.312.016.0110
27Mon, 23 Jul 20180:3011.87.314.411090
28Sat, 11 Aug 20180:3013.48.316.6120
29Tue, 25 Sep 20180:3012.47.715.45 (42%)108100
30Wed, 26 Sep 20180:4014.69.113.65 (42%)10795
31Wed, 3 Oct 20180:3012.07.514.95 (42%)113100
32Mon, 8 Oct 20180:3010.96.813.55 (42%)10391
33Sun, 14 Oct 20180:4015.29.414.25 (42%)10795
34Thu, 18 Oct 20180:3512.87.913.65 (42%)12091
35Sun, 21 Oct 20181:0023.214.414.45 (42%)11897
36Wed, 24 Oct 20180:3512.27.613.05 (42%)9587
37Sat, 27 Oct 20180:4518.011.214.95 (42%)10499
38Tue, 30 Oct 20181:0024.515.215.25 (42%)111102
39Fri, 2 Nov 20181:0024.115.015.05 (42%)106100
40Mon, 5 Nov 20181:0024.815.415.45 (42%)105103
41Wed, 7 Nov 20180:4519.111.915.85 (42%)105106
42Fri, 9 Nov 20181:0025.215.615.65 (42%)115102
43Sun, 11 Nov 20181:0026.916.716.75 (42%)111112
44Wed, 14 Nov 20181:0026.416.416.45 (42%)110111
45Mon, 19 Nov 20180:4518.711.615.55 (42%)103104
46Wed, 21 Nov 20181:0026.216.316.35 (42%)108109
47Fri, 23 Nov 20181:0022.814.214.26 (50%)105117
48Sun, 25 Nov 20181:0023.114.314.36 (50%)108118
49Wed, 28 Nov 20181:0223.914.814.46 (50%)105118
50Sat, 1 Dec 20181:0023.614.714.76 (50%)107121
51Tue, 4 Dec 20181:0023.814.814.86 (50%)109122
52Thu, 6 Dec 20181:0022.714.114.16 (50%)110117
53Sat, 8 Dec 20181:0023.414.514.56 (50%)107121
54Mon, 10 Dec 20181:0025.615.915.96 (50%)131131
55Wed, 12 Dec 20181:0024.215.015.06 (50%)110124
56Fri, 14 Dec 20181:0023.314.514.56 (50%)104120
57Mon, 17 Dec 20181:0025.315.715.76 (50%)108130
58Wed, 19 Dec 20181:0024.415.215.26 (50%)108125
59Fri, 21 Dec 20181:0021.513.413.46 (50%)90110
60Sun, 23 Dec 20181:0024.014.914.96 (50%)99123
61Wed, 26 Dec 20181:0023.714.714.76 (50%)94122
62Fri, 28 Dec 20181:0024.915.515.56 (50%)102128
63Sun, 30 Dec 20181:0023.114.314.36 (50%)97119
64Wed, 2 Jan 20191:0021.313.213.26 (50%)90109
65Fri, 4 Jan 20191:0023.614.714.76 (50%)95121
66Sun, 6 Jan 20191:0024.915.515.56 (50%)109128
67Tue, 8 Jan 20191:0023.014.314.36 (50%)89119
68Thu, 10 Jan 20191:0026.716.616.66 (50%)110137
69Sat, 12 Jan 20191:0023.514.614.66 (50%)92121
70Mon, 14 Jan 20191:0025.015.515.56 (50%)101128
Exercise Bike
 
Last edited:

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Sort by date Sort by votes
Re: Help with creating dynamic chart showing last 90 calendar days entries please?

Hi Ironman :cool:,

So just to clarify you want 90 rows back from the last row?
 
Upvote 0
Re: Help with creating dynamic chart showing last 90 calendar days entries please?

For example 90 Days prior to 16/01/19 = 18-10-18. Did you only want to list this range?
 
Upvote 0
Re: Help with creating dynamic chart showing last 90 calendar days entries please?

Hi RasGhul, thanks for replying.

To clarify, I don't want 90 rows back from the last row, only the most recent 90 day range i.e. unless there are 90 entries in the last 90 days there will always be less than 90 entries displayed.

For your second post, yes, if the latest entry is 16 Jan 2019, the earliest entry in the range will be 18 October 2018 as rows 11 to 33 won't appear in the chart.

If it helps you, A1 contains current date formula =UPPER(TEXT(TODAY(),"d mmm yyyy"))

Thanks again.
 
Last edited:
Upvote 0
Re: Help with creating dynamic chart showing last 90 calendar days entries please?

Hi Ironman,

I had to create a helper column to convert your text date back to a real date for the array and the pivot to calculate properly. In my mock up I converted your data into a table and the the array formula on Last 90 tab is table referenced so will dynamically update as you add new rows from your tracker data. When you add rows you may need to hit Refresh All to update the Pivot table & Chart.

See if you can use this;

https://www.dropbox.com/s/vspz1e75th2f3jt/Last 90 Calendar entries array.xlsx?dl=0
 
Last edited:
Upvote 0
Re: Help with creating dynamic chart showing last 90 calendar days entries please?

Hi RasGhul

Many thanks, it works perfectly!

The only remaining issue is I'm having issues copying your 3 sheets into my existing workbook.

Is there something different I need to do, with there being an array formula a pivot table?

Thanks again!
 
Upvote 0
Re: Help with creating dynamic chart showing last 90 calendar days entries please?

Hi RasGhul - thank you SO MUCH, that's BRILLIANT!!!!

I'm just looking at the Last 90 Bike sheet, which now looks like the below - are all the #REF ! cells now redundant? I've posted just a few rows so you can see any trends - I think the issue is with K2 but I will send the complete sheet to Dropbox if you need me to. Thanks again!


Book1
ABCDEFGHIJKL
1DATETIME (h:mm)DIST. (km)DIST. (mls)SPEED (mph)LEVELHR BPMPower (W)90 Days from TodayCountChart Label
2[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !19/10/2018[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !HR BPM & Power (W) Fri, 19 Oct 18 - Thu, 17 Jan 19
3[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !
4[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !DATEHR BPMPower (W)
5[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !21/10/201811897
6[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !24/10/20189587
7[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !27/10/201810499
8[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !30/10/2018111102
9[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !02/11/2018106100
10[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !05/11/2018105103
11[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !07/11/2018105106
12[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !09/11/2018115102
13[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !11/11/2018111112
14[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !14/11/2018110111
15[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !19/11/2018103104
16[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !21/11/2018108109
17[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !23/11/2018105117
18[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !25/11/2018108118
19[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !28/11/2018105118
20[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !01/12/2018107121
21[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !04/12/2018109122
22[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !06/12/2018110117
23[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !08/12/2018107121
24[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !10/12/2018131131
25[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !12/12/2018110124
26[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !14/12/2018104120
27[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !17/12/2018108130
28[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !19/12/2018108125
29[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !21/12/201890110
30[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !23/12/201899123
31[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !26/12/201894122
32[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !28/12/2018102128
33[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !30/12/201897119
34[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !02/01/201990109
35[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !04/01/201995121
36[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !06/01/2019109128
37[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !08/01/201989119
38[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !10/01/2019110137
39[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !12/01/201992121
40[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !14/01/2019101128
41[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !Grand Total37714161
42[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] ![URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=REF]#REF[/URL] !
Last 90 Bike
Cell Formulas
RangeFormula
J2=TODAY()-90
K2=COUNTIF('C:\Users\Jason Pitfield\Dropbox (OMEGA POWER)\Jason\Last 90 Calendar entries array.xlsx'!Table1[Date Value],">="&J2)
L2=CONCATENATE("HR BPM & Power (W) "&TEXT(J2,"ddd, d mmm yy")&" - "&TEXT(TODAY(),"ddd, d mmm yy"))
A2{=IF(ROWS($A$2:A2)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A2))))}
A3{=IF(ROWS($A$2:A3)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A3))))}
A4{=IF(ROWS($A$2:A4)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A4))))}
A5{=IF(ROWS($A$2:A5)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A5))))}
A6{=IF(ROWS($A$2:A6)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A6))))}
A7{=IF(ROWS($A$2:A7)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A7))))}
A8{=IF(ROWS($A$2:A8)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A8))))}
A9{=IF(ROWS($A$2:A9)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A9))))}
A10{=IF(ROWS($A$2:A10)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A10))))}
A11{=IF(ROWS($A$2:A11)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A11))))}
A12{=IF(ROWS($A$2:A12)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A12))))}
A13{=IF(ROWS($A$2:A13)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A13))))}
A14{=IF(ROWS($A$2:A14)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A14))))}
A15{=IF(ROWS($A$2:A15)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A15))))}
A16{=IF(ROWS($A$2:A16)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A16))))}
A17{=IF(ROWS($A$2:A17)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A17))))}
A18{=IF(ROWS($A$2:A18)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A18))))}
A19{=IF(ROWS($A$2:A19)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A19))))}
A20{=IF(ROWS($A$2:A20)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A20))))}
A21{=IF(ROWS($A$2:A21)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A21))))}
A22{=IF(ROWS($A$2:A22)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A22))))}
A23{=IF(ROWS($A$2:A23)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A23))))}
A24{=IF(ROWS($A$2:A24)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A24))))}
A25{=IF(ROWS($A$2:A25)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A25))))}
A26{=IF(ROWS($A$2:A26)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A26))))}
A27{=IF(ROWS($A$2:A27)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A27))))}
A28{=IF(ROWS($A$2:A28)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A28))))}
A29{=IF(ROWS($A$2:A29)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A29))))}
A30{=IF(ROWS($A$2:A30)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A30))))}
A31{=IF(ROWS($A$2:A31)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A31))))}
A32{=IF(ROWS($A$2:A32)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A32))))}
A33{=IF(ROWS($A$2:A33)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A33))))}
A34{=IF(ROWS($A$2:A34)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A34))))}
A35{=IF(ROWS($A$2:A35)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A35))))}
A36{=IF(ROWS($A$2:A36)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A36))))}
A37{=IF(ROWS($A$2:A37)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A37))))}
A38{=IF(ROWS($A$2:A38)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A38))))}
A39{=IF(ROWS($A$2:A39)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A39))))}
A40{=IF(ROWS($A$2:A40)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A40))))}
A41{=IF(ROWS($A$2:A41)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A41))))}
A42{=IF(ROWS($A$2:A42)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A42))))}
B2{=IF(ROWS($A$2:A2)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A2))))}
B3{=IF(ROWS($A$2:A3)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A3))))}
B4{=IF(ROWS($A$2:A4)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A4))))}
B5{=IF(ROWS($A$2:A5)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A5))))}
B6{=IF(ROWS($A$2:A6)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A6))))}
B7{=IF(ROWS($A$2:A7)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A7))))}
B8{=IF(ROWS($A$2:A8)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A8))))}
B9{=IF(ROWS($A$2:A9)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A9))))}
B10{=IF(ROWS($A$2:A10)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A10))))}
B11{=IF(ROWS($A$2:A11)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A11))))}
B12{=IF(ROWS($A$2:A12)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A12))))}
B13{=IF(ROWS($A$2:A13)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A13))))}
B14{=IF(ROWS($A$2:A14)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A14))))}
B15{=IF(ROWS($A$2:A15)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A15))))}
B16{=IF(ROWS($A$2:A16)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A16))))}
B17{=IF(ROWS($A$2:A17)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A17))))}
B18{=IF(ROWS($A$2:A18)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A18))))}
B19{=IF(ROWS($A$2:A19)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A19))))}
B20{=IF(ROWS($A$2:A20)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A20))))}
B21{=IF(ROWS($A$2:A21)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A21))))}
B22{=IF(ROWS($A$2:A22)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A22))))}
B23{=IF(ROWS($A$2:A23)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A23))))}
B24{=IF(ROWS($A$2:A24)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A24))))}
B25{=IF(ROWS($A$2:A25)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A25))))}
B26{=IF(ROWS($A$2:A26)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A26))))}
B27{=IF(ROWS($A$2:A27)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A27))))}
B28{=IF(ROWS($A$2:A28)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A28))))}
B29{=IF(ROWS($A$2:A29)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A29))))}
B30{=IF(ROWS($A$2:A30)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A30))))}
B31{=IF(ROWS($A$2:A31)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A31))))}
B32{=IF(ROWS($A$2:A32)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A32))))}
B33{=IF(ROWS($A$2:A33)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A33))))}
B34{=IF(ROWS($A$2:A34)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A34))))}
B35{=IF(ROWS($A$2:A35)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A35))))}
B36{=IF(ROWS($A$2:A36)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A36))))}
B37{=IF(ROWS($A$2:A37)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A37))))}
B38{=IF(ROWS($A$2:A38)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A38))))}
B39{=IF(ROWS($A$2:A39)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A39))))}
B40{=IF(ROWS($A$2:A40)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A40))))}
B41{=IF(ROWS($A$2:A41)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A41))))}
B42{=IF(ROWS($A$2:A42)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A42))))}
C2{=IF(ROWS($A$2:A2)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A2))))}
C3{=IF(ROWS($A$2:A3)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A3))))}
C4{=IF(ROWS($A$2:A4)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A4))))}
C5{=IF(ROWS($A$2:A5)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A5))))}
C6{=IF(ROWS($A$2:A6)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A6))))}
C7{=IF(ROWS($A$2:A7)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A7))))}
C8{=IF(ROWS($A$2:A8)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A8))))}
C9{=IF(ROWS($A$2:A9)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A9))))}
C10{=IF(ROWS($A$2:A10)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A10))))}
C11{=IF(ROWS($A$2:A11)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A11))))}
C12{=IF(ROWS($A$2:A12)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A12))))}
C13{=IF(ROWS($A$2:A13)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A13))))}
C14{=IF(ROWS($A$2:A14)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A14))))}
C15{=IF(ROWS($A$2:A15)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A15))))}
C16{=IF(ROWS($A$2:A16)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A16))))}
C17{=IF(ROWS($A$2:A17)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A17))))}
C18{=IF(ROWS($A$2:A18)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A18))))}
C19{=IF(ROWS($A$2:A19)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A19))))}
C20{=IF(ROWS($A$2:A20)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A20))))}
C21{=IF(ROWS($A$2:A21)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A21))))}
C22{=IF(ROWS($A$2:A22)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A22))))}
C23{=IF(ROWS($A$2:A23)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A23))))}
C24{=IF(ROWS($A$2:A24)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A24))))}
C25{=IF(ROWS($A$2:A25)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A25))))}
C26{=IF(ROWS($A$2:A26)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A26))))}
C27{=IF(ROWS($A$2:A27)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A27))))}
C28{=IF(ROWS($A$2:A28)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A28))))}
C29{=IF(ROWS($A$2:A29)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A29))))}
C30{=IF(ROWS($A$2:A30)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A30))))}
C31{=IF(ROWS($A$2:A31)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A31))))}
C32{=IF(ROWS($A$2:A32)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A32))))}
C33{=IF(ROWS($A$2:A33)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A33))))}
C34{=IF(ROWS($A$2:A34)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A34))))}
C35{=IF(ROWS($A$2:A35)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A35))))}
C36{=IF(ROWS($A$2:A36)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A36))))}
C37{=IF(ROWS($A$2:A37)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A37))))}
C38{=IF(ROWS($A$2:A38)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A38))))}
C39{=IF(ROWS($A$2:A39)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A39))))}
C40{=IF(ROWS($A$2:A40)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A40))))}
C41{=IF(ROWS($A$2:A41)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A41))))}
C42{=IF(ROWS($A$2:A42)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A42))))}
D2{=IF(ROWS($A$2:A2)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A2))))}
D3{=IF(ROWS($A$2:A3)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A3))))}
D4{=IF(ROWS($A$2:A4)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A4))))}
D5{=IF(ROWS($A$2:A5)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A5))))}
D6{=IF(ROWS($A$2:A6)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A6))))}
D7{=IF(ROWS($A$2:A7)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A7))))}
D8{=IF(ROWS($A$2:A8)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A8))))}
D9{=IF(ROWS($A$2:A9)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A9))))}
D10{=IF(ROWS($A$2:A10)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A10))))}
D11{=IF(ROWS($A$2:A11)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A11))))}
D12{=IF(ROWS($A$2:A12)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A12))))}
D13{=IF(ROWS($A$2:A13)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A13))))}
D14{=IF(ROWS($A$2:A14)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A14))))}
D15{=IF(ROWS($A$2:A15)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A15))))}
D16{=IF(ROWS($A$2:A16)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A16))))}
D17{=IF(ROWS($A$2:A17)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A17))))}
D18{=IF(ROWS($A$2:A18)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A18))))}
D19{=IF(ROWS($A$2:A19)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A19))))}
D20{=IF(ROWS($A$2:A20)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A20))))}
D21{=IF(ROWS($A$2:A21)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A21))))}
D22{=IF(ROWS($A$2:A22)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A22))))}
D23{=IF(ROWS($A$2:A23)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A23))))}
D24{=IF(ROWS($A$2:A24)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A24))))}
D25{=IF(ROWS($A$2:A25)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A25))))}
D26{=IF(ROWS($A$2:A26)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A26))))}
D27{=IF(ROWS($A$2:A27)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A27))))}
D28{=IF(ROWS($A$2:A28)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A28))))}
D29{=IF(ROWS($A$2:A29)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A29))))}
D30{=IF(ROWS($A$2:A30)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A30))))}
D31{=IF(ROWS($A$2:A31)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A31))))}
D32{=IF(ROWS($A$2:A32)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A32))))}
D33{=IF(ROWS($A$2:A33)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A33))))}
D34{=IF(ROWS($A$2:A34)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A34))))}
D35{=IF(ROWS($A$2:A35)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A35))))}
D36{=IF(ROWS($A$2:A36)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A36))))}
D37{=IF(ROWS($A$2:A37)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A37))))}
D38{=IF(ROWS($A$2:A38)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A38))))}
D39{=IF(ROWS($A$2:A39)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A39))))}
D40{=IF(ROWS($A$2:A40)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A40))))}
D41{=IF(ROWS($A$2:A41)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A41))))}
D42{=IF(ROWS($A$2:A42)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A42))))}
E2{=IF(ROWS($A$2:A2)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A2))))}
E3{=IF(ROWS($A$2:A3)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A3))))}
E4{=IF(ROWS($A$2:A4)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A4))))}
E5{=IF(ROWS($A$2:A5)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A5))))}
E6{=IF(ROWS($A$2:A6)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A6))))}
E7{=IF(ROWS($A$2:A7)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A7))))}
E8{=IF(ROWS($A$2:A8)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A8))))}
E9{=IF(ROWS($A$2:A9)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A9))))}
E10{=IF(ROWS($A$2:A10)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A10))))}
E11{=IF(ROWS($A$2:A11)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A11))))}
E12{=IF(ROWS($A$2:A12)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A12))))}
E13{=IF(ROWS($A$2:A13)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A13))))}
E14{=IF(ROWS($A$2:A14)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A14))))}
E15{=IF(ROWS($A$2:A15)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A15))))}
E16{=IF(ROWS($A$2:A16)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A16))))}
E17{=IF(ROWS($A$2:A17)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A17))))}
E18{=IF(ROWS($A$2:A18)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A18))))}
E19{=IF(ROWS($A$2:A19)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A19))))}
E20{=IF(ROWS($A$2:A20)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A20))))}
E21{=IF(ROWS($A$2:A21)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A21))))}
E22{=IF(ROWS($A$2:A22)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A22))))}
E23{=IF(ROWS($A$2:A23)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A23))))}
E24{=IF(ROWS($A$2:A24)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A24))))}
E25{=IF(ROWS($A$2:A25)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A25))))}
E26{=IF(ROWS($A$2:A26)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A26))))}
E27{=IF(ROWS($A$2:A27)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A27))))}
E28{=IF(ROWS($A$2:A28)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A28))))}
E29{=IF(ROWS($A$2:A29)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A29))))}
E30{=IF(ROWS($A$2:A30)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A30))))}
E31{=IF(ROWS($A$2:A31)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A31))))}
E32{=IF(ROWS($A$2:A32)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A32))))}
E33{=IF(ROWS($A$2:A33)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A33))))}
E34{=IF(ROWS($A$2:A34)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A34))))}
E35{=IF(ROWS($A$2:A35)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A35))))}
E36{=IF(ROWS($A$2:A36)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A36))))}
E37{=IF(ROWS($A$2:A37)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A37))))}
E38{=IF(ROWS($A$2:A38)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A38))))}
E39{=IF(ROWS($A$2:A39)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A39))))}
E40{=IF(ROWS($A$2:A40)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A40))))}
E41{=IF(ROWS($A$2:A41)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A41))))}
E42{=IF(ROWS($A$2:A42)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A42))))}
F2{=IF(ROWS($A$2:A2)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A2))))}
F3{=IF(ROWS($A$2:A3)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A3))))}
F4{=IF(ROWS($A$2:A4)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A4))))}
F5{=IF(ROWS($A$2:A5)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A5))))}
F6{=IF(ROWS($A$2:A6)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A6))))}
F7{=IF(ROWS($A$2:A7)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A7))))}
F8{=IF(ROWS($A$2:A8)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A8))))}
F9{=IF(ROWS($A$2:A9)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A9))))}
F10{=IF(ROWS($A$2:A10)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A10))))}
F11{=IF(ROWS($A$2:A11)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A11))))}
F12{=IF(ROWS($A$2:A12)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A12))))}
F13{=IF(ROWS($A$2:A13)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A13))))}
F14{=IF(ROWS($A$2:A14)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A14))))}
F15{=IF(ROWS($A$2:A15)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A15))))}
F16{=IF(ROWS($A$2:A16)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A16))))}
F17{=IF(ROWS($A$2:A17)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A17))))}
F18{=IF(ROWS($A$2:A18)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A18))))}
F19{=IF(ROWS($A$2:A19)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A19))))}
F20{=IF(ROWS($A$2:A20)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A20))))}
F21{=IF(ROWS($A$2:A21)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A21))))}
F22{=IF(ROWS($A$2:A22)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A22))))}
F23{=IF(ROWS($A$2:A23)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A23))))}
F24{=IF(ROWS($A$2:A24)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A24))))}
F25{=IF(ROWS($A$2:A25)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A25))))}
F26{=IF(ROWS($A$2:A26)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A26))))}
F27{=IF(ROWS($A$2:A27)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A27))))}
F28{=IF(ROWS($A$2:A28)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A28))))}
F29{=IF(ROWS($A$2:A29)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A29))))}
F30{=IF(ROWS($A$2:A30)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A30))))}
F31{=IF(ROWS($A$2:A31)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A31))))}
F32{=IF(ROWS($A$2:A32)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A32))))}
F33{=IF(ROWS($A$2:A33)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A33))))}
F34{=IF(ROWS($A$2:A34)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A34))))}
F35{=IF(ROWS($A$2:A35)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A35))))}
F36{=IF(ROWS($A$2:A36)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A36))))}
F37{=IF(ROWS($A$2:A37)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A37))))}
F38{=IF(ROWS($A$2:A38)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A38))))}
F39{=IF(ROWS($A$2:A39)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A39))))}
F40{=IF(ROWS($A$2:A40)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A40))))}
F41{=IF(ROWS($A$2:A41)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A41))))}
F42{=IF(ROWS($A$2:A42)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A42))))}
G2{=IF(ROWS($A$2:A2)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A2))))}
G3{=IF(ROWS($A$2:A3)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A3))))}
G4{=IF(ROWS($A$2:A4)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A4))))}
G5{=IF(ROWS($A$2:A5)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A5))))}
G6{=IF(ROWS($A$2:A6)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A6))))}
G7{=IF(ROWS($A$2:A7)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A7))))}
G8{=IF(ROWS($A$2:A8)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A8))))}
G9{=IF(ROWS($A$2:A9)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A9))))}
G10{=IF(ROWS($A$2:A10)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A10))))}
G11{=IF(ROWS($A$2:A11)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A11))))}
G12{=IF(ROWS($A$2:A12)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A12))))}
G13{=IF(ROWS($A$2:A13)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A13))))}
G14{=IF(ROWS($A$2:A14)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A14))))}
G15{=IF(ROWS($A$2:A15)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A15))))}
G16{=IF(ROWS($A$2:A16)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A16))))}
G17{=IF(ROWS($A$2:A17)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A17))))}
G18{=IF(ROWS($A$2:A18)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A18))))}
G19{=IF(ROWS($A$2:A19)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A19))))}
G20{=IF(ROWS($A$2:A20)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A20))))}
G21{=IF(ROWS($A$2:A21)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A21))))}
G22{=IF(ROWS($A$2:A22)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A22))))}
G23{=IF(ROWS($A$2:A23)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A23))))}
G24{=IF(ROWS($A$2:A24)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A24))))}
G25{=IF(ROWS($A$2:A25)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A25))))}
G26{=IF(ROWS($A$2:A26)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A26))))}
G27{=IF(ROWS($A$2:A27)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A27))))}
G28{=IF(ROWS($A$2:A28)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A28))))}
G29{=IF(ROWS($A$2:A29)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A29))))}
G30{=IF(ROWS($A$2:A30)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A30))))}
G31{=IF(ROWS($A$2:A31)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A31))))}
G32{=IF(ROWS($A$2:A32)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A32))))}
G33{=IF(ROWS($A$2:A33)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A33))))}
G34{=IF(ROWS($A$2:A34)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A34))))}
G35{=IF(ROWS($A$2:A35)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A35))))}
G36{=IF(ROWS($A$2:A36)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A36))))}
G37{=IF(ROWS($A$2:A37)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A37))))}
G38{=IF(ROWS($A$2:A38)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A38))))}
G39{=IF(ROWS($A$2:A39)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A39))))}
G40{=IF(ROWS($A$2:A40)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A40))))}
G41{=IF(ROWS($A$2:A41)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A41))))}
G42{=IF(ROWS($A$2:A42)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A42))))}
H2{=IF(ROWS($A$2:A2)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A2))))}
H3{=IF(ROWS($A$2:A3)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A3))))}
H4{=IF(ROWS($A$2:A4)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A4))))}
H5{=IF(ROWS($A$2:A5)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A5))))}
H6{=IF(ROWS($A$2:A6)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A6))))}
H7{=IF(ROWS($A$2:A7)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A7))))}
H8{=IF(ROWS($A$2:A8)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A8))))}
H9{=IF(ROWS($A$2:A9)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A9))))}
H10{=IF(ROWS($A$2:A10)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A10))))}
H11{=IF(ROWS($A$2:A11)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A11))))}
H12{=IF(ROWS($A$2:A12)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A12))))}
H13{=IF(ROWS($A$2:A13)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A13))))}
H14{=IF(ROWS($A$2:A14)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A14))))}
H15{=IF(ROWS($A$2:A15)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A15))))}
H16{=IF(ROWS($A$2:A16)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A16))))}
H17{=IF(ROWS($A$2:A17)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A17))))}
H18{=IF(ROWS($A$2:A18)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A18))))}
H19{=IF(ROWS($A$2:A19)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A19))))}
H20{=IF(ROWS($A$2:A20)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A20))))}
H21{=IF(ROWS($A$2:A21)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A21))))}
H22{=IF(ROWS($A$2:A22)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A22))))}
H23{=IF(ROWS($A$2:A23)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A23))))}
H24{=IF(ROWS($A$2:A24)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A24))))}
H25{=IF(ROWS($A$2:A25)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A25))))}
H26{=IF(ROWS($A$2:A26)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A26))))}
H27{=IF(ROWS($A$2:A27)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A27))))}
H28{=IF(ROWS($A$2:A28)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A28))))}
H29{=IF(ROWS($A$2:A29)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A29))))}
H30{=IF(ROWS($A$2:A30)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A30))))}
H31{=IF(ROWS($A$2:A31)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A31))))}
H32{=IF(ROWS($A$2:A32)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A32))))}
H33{=IF(ROWS($A$2:A33)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A33))))}
H34{=IF(ROWS($A$2:A34)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A34))))}
H35{=IF(ROWS($A$2:A35)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A35))))}
H36{=IF(ROWS($A$2:A36)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A36))))}
H37{=IF(ROWS($A$2:A37)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A37))))}
H38{=IF(ROWS($A$2:A38)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A38))))}
H39{=IF(ROWS($A$2:A39)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A39))))}
H40{=IF(ROWS($A$2:A40)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A40))))}
H41{=IF(ROWS($A$2:A41)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A41))))}
H42{=IF(ROWS($A$2:A42)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A42))))}
Press CTRL+SHIFT+ENTER to enter array formulas.
Named Ranges
NameRefers ToCells
x=OFFSET(LastLogDate,0,0,-90)
 
Last edited:
Upvote 0
Re: Help with creating dynamic chart showing last 90 calendar days entries please?

Sorry mate broken link,

Put this into K2 on the Last 90 Bike tab;

=COUNTIF(Table1[DATE],">="&J2)
 
Upvote 0
Re: Help with creating dynamic chart showing last 90 calendar days entries please?

Many thanks, that worked.

However, now the status bar is constantly showing 'Calculate' and when I click it I keep getting VBA error - "can't find project or library". I clicked OK and I get the VBA reference project entries but I don't know what's missing or maybe a broken link still?

My existing workbook runs without any such error so it has to be something in your combined one - I've tried renaming it to exactly the same name as mine (and renaming mine temporarily) and putting the file in exactly the same location, all in vain - Sorry about this!
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
adding cells based on criteria across several columns
Replies
5
Views
866
Cubist
Cubist
V
  • Solved
Week Number
Replies
2
Views
342
vmjan02
V
S
  • Question Question
Prevent pivot line chart dropping
Replies
8
Views
419
sharshra
S
ExcelNewbie2020
  • Solved
transpose data
2
Replies
15
Views
588
kvsrinivasamurthy
K
C
  • Question Question
Automate a data table into a Gannt Chart
Replies
1
Views
489
Cantrecallmyusername
C

Forum statistics

Threads
1,223,895
Messages
6,175,257
Members
452,625
Latest member
saadat28

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top