Custom Views greyed out in every sheet in workbook

Ironman

Ironman

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

I'm running Excel 2019 and I very recently added a pivot table/chart to my workbook, which has 15 other sheets.

I've been making good use of Custom Views and although I read that Custom Views won't work if there's a table in the sheet, every sheet in my workbook already contains tables and Custom Views that worked fine before, so I don't understand what difference the pivot table would make now.

Also. my workbook is not shared.

Does having the pivot table mean I have to forego Custom Views or is there a workaround? Else I don't understand why this has just happened.

An explanation/solution would be greatly appreciated.

Many thanks!
 
Last edited:

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Sort by date Sort by votes
i don't know how close your pivot is to the rest of the data, there is an issue when excel needs to adjust the pivot and is constrained by other data. i usually give it plenty of room, which i guess extends to beyond what might be displayed shoul you show ALL the columns permissible and then some i.e ten columns of data might have 15 allowed for. I don't use Tables, just data laid ut in a grid pattern
 
Upvote 0
Hi Mole, thanks for replying.

The existing first sheet below contains the raw data and was I believe converted to a table. The second sheet is the pivot table itself - could you tell me how I follow your suggestion please?

Thanks again.


Book1
ABCDEFGHIJK
120 JAN 2019THIS WEEK (WK 3) ?463hr 00m15.3BPM 7D AVPOWER 7DTOTAL NUMBER OF MILES ON EXERCISE BIKE JANUARY TO DATE135
2DAYS GONE THIS YEARLAST WK/YEAR ?453hr 00m15.3100126TOTAL NUMBER OF MILES ON EXERCISE BIKE IN DECEMBER207
319YEARS----------->20192018 Y/E TOTSSINCE JAN 2018MONTHLY AVERAGE MILEAGE ON EXERCISE BIKE 2019 TO DATE213
4EXERCISE BIKE DAYS LEFTMILES YTD----->1350829WEEKLY AVERAGE MILEAGE ON EXERCISE BIKE 2019 TO DATE50
5346HOURS YTD---->9062 SessionsAVERAGE DURATION OF EACH EXERCISE BIKE SESSION (MINUTES) 2019 TO DATE1:00
643,478.00434710.043464.0Sun 22 Oct0
7FURTHESTDISTANCE (MILES) 2019 TO DATE?Thu 10 Jan16.6AVERAGE DISTANCE (MILES) PER EXERCISE BIKE SESSION 2019 TO DATE15
8GREATESTPOWER (AV WATTS) 2019 TO DATE?Fri 18 Jan1:00No. IRON MAN SESSIONS 2019 TO DATE9
962
10DATETIME (h:mm)DIST. (km)DIST. (mls)SPEED (mph)LEVELHR BPMPower (W)RCOMMENTSColumn1
11Sat, 6 Jan 20180:3315.29.417.2KFirst session on JTX Cyclo 6 since built early Dec 2017. 4x4 min sessions with 2 min break (to adjust bike, volume, get towel etc), plus 1x17 minutes. First one drained my quads within a couple of minutes, just like when I ran out of steam halfway up Hallas Lane and was forced to stop. Following sessions got slightly easier, then Moby **** came on random playlist and it was inspirational. Felt good after!
12Wed, 10 Jan 20180:4321.213.218.4KFirst non-stop session, set out to cycle for full length of Unleashed In The East with bursts on endings - did it! Saddle-sore, perineum/prostate area numb.
13Tue, 16 Jan 20180:4821.213.216.5KFull length of Zep Spokane 30.12.1968 (boring), no bursts. Very saddle-sore, perineum/prostate area completely numb, very, very uncomfortable. Went for wee afterwards, felt I hadn't quite finished so pushed a bit and started seeping thick white semen-like fluid!!!
14Fri, 19 Jan 20180:5222.213.815.9KFull length of Zep Whiskey A Go Go 05.01.1969 (great), occasional short burst. First session on replacement saddle, shorts not padded. MUCH improved comfort. Surprised pace slightly slower than last time.
15Tue, 23 Jan 20180:5326.316.318.5>100KFull length of Zep Whiskey A Go Go 05.01.1969 again, occasional short burst. AM session. Aimed to keep heart rate over 100 and generally succeeded (also realised hands don't need to be in contact with sensors*) - later updates: 1) *WRONG! 2) Accuracy of JTX hand sensors is understated by 20% compared to Garmin 305 used from 31.01.
16Thu, 25 Jan 20180:4621.313.217.3KFillmore West 10.01.1969 early show. Didn't use heart sensor as not comfortable enough to put hands on sensors.
17Sat, 27 Jan 20180:4520.012.416.6KFillmore West 10.01.1969 late show. Didn't use heart sensor (just ordered handlebar mount for Garmin 305). Sat further back in saddle, much more comfortable. Sessions seemed much easier - but then the pace was slower! Defo need motivation from Heart Rate Monitor for faster pace.
18Sun, 28 Jan 20180:4620.712.916.8KFillmore West 10.01.1969 early show. Hard work after yesterday. Really knackered afterwards.
19Wed, 31 Jan 20180:5023.614.717.6122KFillmore West 10.01.1969 late show. Excellent session, really motivated by a) Garmin 305 HRM display b) finally figuring out how to stop console scrolling to hold on time elapsed (SHORT press of Mode button) and c) changing arm/shoulder posture to racing position. No discomfort. Raced through time elapsed 'stages' as concentrating on Garmin HR readout exceeding 120bpm (thrilled to see this, knowing it's correct, vs inaccurate bike sensor readings of only 100 or so). Stayed between 120-125bpm the whole session. Could have carried on well beyond 50 mins but didn't want to be late down for dinner! Biking is really building my general confidence, which seems to be growing almost daily.
20Wed, 14 Feb 20180:4521.013.017.4KFillmore West 10.01.1969 late show. Apprehensive about session following aborted run in Lanzarote last Thursday (either dehydration or blood loss from piles) and being up all night. Needn't have worried, I was fine, legs very strong. First session with fan, on lowest setting started out brilliant, but probably needed to be middle setting halfway onwards. First session with water bottle but couldn't get any water through straw!
21Thu, 22 Feb 20180:4520.913.017.3<120KFillmore West 11.01.1969. Learning points: 1) chest strap MUST be tight - took ages to get a correct readout from Garmin and 2) not enough to have (brand new) window wide open regardless of 3c temperature outside, as there's still no air circulation - fan is essential. Turned resistance dial round to 6 o'clock, less effort than before but fewer revolutions. Took at least 15 mins to get heart rate over 120bpm and seemed to struggle to keep it that way.
22Sun, 4 Mar 20180:4521.013.017.4<110KFillmore West 11.01.1969. Curious session - worked as hard as I could from start to finish yet took 30 minutes for heart rate to reach just 110bpm and didn't exceed it for the entire session. Window wide open, 0C, fan on 2nd setting, only one drop of sweat on mat! Took drink a couple of times.
23Tue, 6 Mar 20180:4822.013.717.1111KFillmore West 12.01.1969. Forgot to put headband on, definitely needed it. Tried water bottle without lid on, got water all over me! Going to use squeeze bottle next time. Turned resistence up around 25 mins to try and increase my heart rate and it made only 1bpm difference (111bpm). Legs like concrete afterwards. Know I'm dehydrated, only drinking about 1.5 pints of water a day, plus small amount of whisky last couple of nights to finish an old bottle.
24Sat, 10 Mar 20180:4720.812.916.5KFillmore West 12.01.1969. No time to put water bottle on (going down to Nottm straight after), didn't suffer for it. Repositioning of fan helped greatly, hardly any sweat. So-so session, pissed off cos HRM readings well below what they should have been and eventually went haywire. Read up online about this being solely the strap (not the chest unit or the monitor).
25Sat, 17 Mar 20181:0125.816.015.8110KFillmore West 12.01.1969. No water bottle again - definitely need some water to stop mouth going dry. Snowing outside but as ever, needed fan to keep me cool cos still sweating. First time I've done more than an hour, though surprised pace wasn't greater cos consciously pedalling really hard. That said, I was ill for 2 days on Wed/Thu.
26Thu, 12 Apr 20180:4519.312.016.0110KLast session on JTX Cyclo 6. Boston 23.01.1969. Took bottle of water, drank it all and needed it, probably cos of all the sweets I've been eating in last few days. Felt better than I thought I would after 3 weeks without a session and a 3 hour, 10.4 mile walk yesterday.
27Mon, 23 Jul 20180:3011.87.314.411090KFairlawns Hotel gym, Sutton Coldfield. Rode Technogym Bike Forma and fell in lust with it :-) Values shown are final readings, not average.
28Sat, 11 Aug 20180:3013.48.316.6120KKenwood Hall Hotel gym, Sheffield. Unknown equipment. Values shown are final readings, not average.
29Tue, 25 Sep 20180:3012.47.715.45 (42%)108100KFirst session on my own Technogym Bike Forma, Boston 23.01.1969.
30Wed, 26 Sep 20180:4014.69.113.65 (42%)10795KBoston 23.01.1969.
31Wed, 3 Oct 20180:3012.07.514.95 (42%)113100KBoston 23.01.1969.
32Mon, 8 Oct 20180:3010.96.813.55 (42%)10391KBoston 23.01.1969.
33Sun, 14 Oct 20180:4015.29.414.25 (42%)10795KNeil Young, Weld. Much better motivated with this music than meandering early Zep.
34Thu, 18 Oct 20180:3512.87.913.65 (42%)12091KBoston 26.01.1969. Very similar to last time - legs getting used to it, less time-watching.
35Sun, 21 Oct 20181:0023.214.414.45 (42%)11897JBoston 26.01.1969. Set out to do this and did it - could have gone for longer too. Intentionally hardly looked at progress for first 20 mins, which seemed to make session shorter.
36Wed, 24 Oct 20180:3512.27.613.05 (42%)9587LBoston 26.01.1969. Set out to do 60 mins but at around 30 mins I was starting to feel very drowsy and started closing my eyes, then my concentration started to go and decided to stop. Got up at 9am, far too early - getting up at anything up to 3pm!!! Seriously wanting to fall asleep in the afternoon and went to bed around 5, then came down at 8, then fell asleep in chair till 10.
37Sat, 27 Oct 20180:4518.011.214.95 (42%)10499JBoston 26.01.1969. 3:45pm, 2 hours after getting up. Exactly what I set out to do. Powered my way through the upbeat bits then slowed, really great session (12 hours sleep).
38Tue, 30 Oct 20181:0024.515.215.25 (42%)111102JBoston 26.01.1969. 6:00pm. Great session, again, exactly what I set out to do and powered my way through all upbeat bits then slowed. Was cold before starting and freezing cold outside so only had window partially open, but absolutely drenched in sweat from the effort. MUST OPEN THE WINDOW FULLY NEXT TIME!
39Fri, 2 Nov 20181:0024.115.015.05 (42%)106100JBoston 26.01.1969 (I love this show!). 5:30pm. Great session, again, exactly what I set out to do and powered my way through all upbeat bits then slowed. Window fully open, still absolutely drenched in sweat from the effort. MUST USE FAN NEXT TIME!
40Mon, 5 Nov 20181:0024.815.415.45 (42%)105103JBoston 26.01.1969. 6:00pm. Another pretty good session, exactly what I set out to do and powered my way through all upbeat bits then slowed. Heart felt slightly strained at times (not when I was pushing the pace though) and got really annoyed with bum chafing for no apparent reason. Fan/open window virtually eliminated sweat.
41Wed, 7 Nov 20180:4519.111.915.85 (42%)105106JBoston 26.01.1969. 4:00pm. Very good session, reduced from 60 mins as instead of outdoor cycling (too wet), plus want to see if it improves tomorrow's run at all. Wore cycling shorts only (no pants) - no noticeable chafing! Fan on, window half open (raining outside), perfect!
42Fri, 9 Nov 20181:0025.215.615.65 (42%)115102JBoston 26.01.1969. 11:15am. Excellent session, despite forgetting to take my pants off and switch fan on. Got bit uncomfortable but nothing too bad. I've never seen so much sweat on the floor though, 2 massive pools of sweat, even though window was wide open. Consciously breathing 1 in 4 for the fast parts, which I'm making longer each time. Can't believe my average HR - really in the zone now! Performance-wise, this has to the best session to date!
43Sun, 11 Nov 20181:0026.916.716.75 (42%)111112JBoston 26.01.1969. 5:00pm. Thought I'd try breathing 1 in 4 throughout (like I did with yesterday's run) as well as the sprints during all the fast bits. And it worked - really good session. Interesting to note average HR lower than 2 days ago and distance and power were significantly greater - the fact my power and distance has improved with an actual reduction in my HR means my fitness is improving.
44Wed, 14 Nov 20181:0026.416.416.45 (42%)110111JBoston 26.01.1969. 4:20pm, 35 mins after getting up! Breathed 1 in 4 from start - probably began too quickly but Train Kept A-Rollin' was a fast starter!
45Mon, 19 Nov 20180:4518.711.615.55 (42%)103104JBoston 26.01.1969. 5:10am, immediately after getting up! Had to get this session in before going to hospital for anal fissure op in case I was kept in overnight. Wore headphones, very comfortable, but unplugged them by mistake 5 mins in and had to stop previous 1hr timer to stop the sound coming out of the speakers - didn't want to be late for appt so reset time to 45 mins. Fan set to lowest setting to avoid too much noise but definitely needs to be middle setting - very thirsty, couldn't get enough water down.
46Wed, 21 Nov 20181:0026.216.316.35 (42%)108109JBoston 26.01.1969. 6:30pm. About 5C outside. Fan on second setting, window wide open but headband in the wash - I still needed it. Bursts on all fast parts, as usual now. Wondering if I should be increasing effort level as doing around 80rpm, feels slightly too easy. Wore old Polar Heart Monitor/chest strap and they match bike reading PERFECTLY. However, I stopped the watch and forget to check the bike distance and missed it!!!
47Fri, 23 Nov 20181:0022.814.214.26 (50%)105117JBoston 26.01.1969. Effort Level increased to 6/12, hence higher power output and lower distance. 10:45am, about 4C outside, wore headphones (after Helen burst in, screaming at me to turn it down). Definitely more of an effort now but surprised HR hasn't increased as well. Still, good to feel quads burning on the bike as they haven't been for quite a while.
48Sun, 25 Nov 20181:0023.114.314.36 (50%)108118JBoston 26.01.1969. 5pm, 5C outside. Tightened foot straps and raised seat 1 notch to 11, which definitely improved my performance. I felt I was able to push down and almost sprint for the fast bits. Breathing lightly 1 in 4 for at least half the session. Excellent session.
49Wed, 28 Nov 20181:0223.914.814.46 (50%)105118JBoston 26.01.1969. 5pm, extremely windy outside and daren't put fan on so got pretty sweaty. Purposely timed run at 1:02 to beat longstanding but irrelevent 1:01 previous record from months ago. Heart at the stage where it can't do much more because quads so heavy.
50Sat, 1 Dec 20181:0023.614.714.76 (50%)107121JBoston 26.01.1969. 1pm. Another excellent session.
51Tue, 4 Dec 20181:0023.814.814.86 (50%)109122JBoston 26.01.1969. 5pm. Legs felt bit heavy for first 5-10 mins, probably cos I'd been hanging around in cycling shorts all day, waiting for bathroom fitter to go.
52Thu, 6 Dec 20181:0022.714.114.16 (50%)110117JBoston 26.01.1969. 9am. Legs very heavy for first 15 mins (big spag bols last night/too little to drink?). Forgot to fill bottle but didn't feel any the worse for it.
53Sat, 8 Dec 20181:0023.414.514.56 (50%)107121JBoston 26.01.1969. 9:30am. Wore headphones, didn't even notice. Reset seat yesterday when moving mat and accidentally made it higher than before, which made pushing down on pedals much easier! First 5 mins was more of a warm-up, after that it was almost a breeze - hardly breathing, v alert, almost enjoyed it! Ate banana beforehand and pint of lemon squash. Window half open cos of v strong wind/rain. Barely sweating. Missed distance reading while chucking headphones on the bed!!!
54Mon, 10 Dec 20181:0025.615.915.96 (50%)131131JBoston 26.01.1969. 5:30pm. Amazing session, absolutely thrashed pedals almost from start to finish, as if the resistance was almost non-existent! Breathing 1 in 4 naturally but still couldn't BELIEVE the BPM (out earlier and had a caffeinated filter coffee). Angina hit me after about 10 mins, then faded away, purely because I've just unintentionally gone 3 days without taking any pills (too tired to sort boxes out). Angina returned really badly pretty soon afterwards, pain so intense I was forced into sorting my pills out straight after dinner.
55Wed, 12 Dec 20181:0024.215.015.06 (50%)110124JBoston 26.01.1969. 5:30pm. Good session, but much more like usual sessions this time, which can only be cos of yesterday's 7 mile, 90 min run (no additional rest at moment as being woken at 8:00am by bathroom fitter since 4 Dec). First session handwriting stats on phone attached to handlebar - worked very well.
56Fri, 14 Dec 20181:0023.314.514.56 (50%)104120JBoston 26.01.1969. 5:30pm. Increased my weight input from 76kg to 80kg. First 10 mins felt like a rusty warm-up and noticeably tired after 40 mins but still able to put in the sprints.
57Mon, 17 Dec 20181:0025.315.715.76 (50%)108130JBoston 26.01.1969. 5:45pm. FORGOT TO TURN FAN ON, DRENCHED IN SWEAT WITH POOLS ON MAT DESPITE WINDOW WIDE OPEN AND FREEZING OUTSIDE. First 5 mins or so was warming up after yesterday's 5 miler over Forth Road Bridge. Sensed my legs were powerful and they sure were, very much like 10.12, really able to push down and power - felt like there weren't enough fast bits for my legs to power through! And look at the BPM vs Watts compared to 10.12!
58Wed, 19 Dec 20181:0024.415.215.26 (50%)108125JBoston 26.01.1969. 6:05pm. Wore Muddyfox shorts (no padding), didn't suffer for it. Needed 5 mins to warm up properly then L quads became really strong. Breathing quite heavily this time though - probably lack of sleep (bed at 3am, up at 8am for bathroom fitter, pretty typical at the moment).
59Fri, 21 Dec 20181:0021.513.413.46 (50%)90110KBoston 26.01.1969. 5:20pm. Hardly any power in legs, sprints almost impossible, basically a pedalling session for an hour, although I completed it comfortably. Went for a walk to the Co-op a couple of hours ago and my legs were already knackered then. I dread to think about tomorrow's run.
60Sun, 23 Dec 20181:0024.014.914.96 (50%)99123JBoston 26.01.1969. 6:20pm. FORGOT HEADBAND (dripping loads of sweat, don't do that again!) AND PHONE (not a problem if you've still got pen and paper nearby). Much better than last time, although took a while to warm up properly, then tired a bit after 45 mins, but after 50 mins or so I was absolutely powering it.
61Wed, 26 Dec 20181:0023.714.714.76 (50%)94122JBoston 26.01.1969. 2:10pm. FORGOT HEADBAND AGAIN - same irritation as last time! About 4 hours' sleep and 2 JARs last night and dehydrated (+ regular night sweats) so was tired for first 10 mins, but legs really responsive on fast passages.
62Fri, 28 Dec 20181:0024.915.515.56 (50%)102128JBoston 26.01.1969. 5:30pm. About 5 hours' sleep last night (concentrating on improving this workbook). First 3 mins or so was warm-up, then legs really were warmed up. Thrashed pedals on every fast passage, even got up to 182 watts at one point! Surprised mileage and wattage weren't even higher but I still got in the top 10%.
63Sun, 30 Dec 20181:0023.114.314.36 (50%)97119JBoston 26.01.1969. 5:35pm. Good session, not feeling as strong as Friday though, took 5 mins+ to warm up and couldn't get burst power beyond 150 watts.
64Wed, 2 Jan 20191:0021.313.213.26 (50%)90109KBoston 26.01.1969. 6:30pm. Tired from the outset, possibly the 2 consecutive runs, late night and 2 JARs, but no power in legs at all, was more into the music than the session. However, at 45 mins I started experimenting with my pedalling and started pulling up in addition to pushing down and I could actually feel my quads working, as well as the motion propelling me forwards and backwards, rather than side to side.
65Fri, 4 Jan 20191:0023.614.714.76 (50%)95121JBoston 26.01.1969. 5:10pm. Quite apprehensive at start after last session but I was fine once I got into it during first fast break (T3 - Killing Floor). Legs became more and more responsive throughout, really enjoying it over last 15 mins or so. Re last session, legs pedalling too quickly to think about pulling up.
66Sun, 6 Jan 20191:0024.915.515.56 (50%)109128JBoston 26.01.1969. 5:45pm. Just over an hour after getting up, following a massive 15 hour sleep - up in the night just once and well dehydrated when I got up. Had a pint of water/lime juice and a banana about 30 mins beforehand. Excellent session, and very pleasantly surprised - power and strength in my legs was unbelievable, powering on every fast bit and even on some of the slower bits - it just HAS to be the length of bed rest. Top 10% performance and on a 'runner's high' all evening. Side issue of very bad chafing to back of thighs from wearing X-large women's shorts (bought by accident) a little lower down from my crotch to try and avoid chafing.
67Tue, 8 Jan 20191:0023.014.314.36 (50%)89119KBoston 26.01.1969. 6:55pm. Weight input decreased to 78kg. Back of thighs still v sore before I started, wore different cycling shorts tonight, no problems whatsoever. This was a session in 3 parts - First 30 mins were OK, good level of strength in legs for sprints. Over next 20 mins my strength drained away fast with much of this period spent with my eyes closed, even feeling a bit dizzy at times. 50 mins in, my energy was renewed and OK for all the sprints - was this the water I'd taken onboard?
68Thu, 10 Jan 20191:0026.716.616.66 (50%)110137JBoston 26.01.1969. 12:30pm. Stayed up late last night until 3:45 this morning updating this workbook and drank pint after pint of water/lime squash continuously from around midnight (knowing that going to the loo over the next 4 hours wouldn't disturb my sleep) to see if I could put an end to my constant dark/almost orange pee day after day. I didn't really think about the effect this would have on exercising until I got on the bike this morning...WHAT A SESSION AND A CONTRAST TO THE LAST ONE! The best session yet - wattage (previous PB smashed), related heart rate and distance (PB for effort level) are incredible and correct! Legs really up for it right from the start, full of effortless power right to the finish.
69Sat, 12 Jan 20191:0023.514.614.66 (50%)92121JBoston 26.01.1969. 5:25pm. Bit tired after yesterday's 105 min run and should probably have drunk more beforehand but felt bloated after porridge oats/banana at 1pm. Took most of session to really warm up and by 45 mins I was really enjoying it - sprint power increased to 130W from 120W.
70Mon, 14 Jan 20191:0025.015.515.56 (50%)101128JBoston 26.01.1969. 4:25pm. Excellent session, legs strong and up for it almost from the start. Sprints became more and more powerful - even managed 190 for a second or so towards the end. Slightly disappointed with the figures, thought the effort I put in was greater than it actually was.
71Wed, 16 Jan 20191:0024.615.315.36 (50%)104126JBoston 26.01.1969. 6:20pm. Very good session, legs needed a bit of a warm-up after yesterday's 75 min run but fine after 5 mins. Lots of power in all the sprints.
72Fri, 18 Jan 20191:0024.415.215.26 (50%)102125JBoston 26.01.1969. 5:45pm. Good session but could feel my legs tiring a bit in second half. Tried to keep power up to 128W and generally succeeded. Went all out on sprints but didn't sense it feeling quite as powerful as last time - surprised figure was so close to it, and HR was so low cos heart was going well over 115 at times. Painful chafing to R side of perineum - worn Muddyfox shorts twice in succession now - MUST NOT DO!
73
Exercise Bike
Cell Formulas
RangeFormula
J1="TOTAL NUMBER OF" & UPPER(" MILES ON EXERCISE BIKE "&TEXT(TODAY(),"MMMM")& " TO DATE")
J2="TOTAL NUMBER OF"&UPPER(" MILES ON EXERCISE BIKE IN "&TEXT(EOMONTH(TODAY(),-1),"MMMM"))
J3="MONTHLY AVERAGE MILEAGE ON EXERCISE BIKE "&YEAR(NOW())&" TO DATE"
J4="WEEKLY AVERAGE MILEAGE ON EXERCISE BIKE "&YEAR(NOW())&" TO DATE"
J5="AVERAGE DURATION OF EACH EXERCISE BIKE SESSION (MINUTES) "&YEAR(NOW())&" TO DATE"
J7="AVERAGE DISTANCE (MILES) PER EXERCISE BIKE SESSION "&YEAR(NOW())&" TO DATE"
J8="No. IRON MAN SESSIONS "&YEAR(NOW())&" TO DATE"
K1=SUMIF(All_Bike_Dates,">"&L1,All_Bike_Miles)
K2=SUMIF(All_Bike_Dates,">"&L2,All_Bike_Miles)-K1
K3=C4/A3*30
K4=C4/A3*7
K5=C5/COUNTIFS(All_Bike_Miles,">0.01",All_Bike_Dates,">"&DATE(LogYear-1,12,31))
K7=C4/COUNTIFS(All_Bike_Miles,">0.01",All_Bike_Dates,">"&DATE(LogYear-1,12,31))
K8=COUNTIFS(All_Bike_Times,">="&1/24,All_Bike_Dates,">"&DATE(LogYear-1,12,31))
G2=AVERAGEIF(All_Bike_Dates,">"&$B$6,All_Bike_Heart_Rates)
H2=AVERAGEIF(All_Bike_Dates,">"&$B$6,All_Bike_Watts)
A3=VBADaysGone
A1=UPPER(TEXT(TODAY(),"d mmm yyyy"))
A5=VBADaysLeft
A6=A1-WEEKDAY(A1,2)
D1=SUMIF(All_Bike_Dates,">"&A6,All_Bike_Times)
D2=SUMIF(All_Bike_Dates,">"&B6,All_Bike_Times)-D1
D3=YEAR(NOW())-1 & " Y/E TOTS"
D6=B6-7
D11=IF(B11>0,C11*0.621,"")
D12=IF(B12>0,C12*0.621,"")
D13=IF(B13>0,C13*0.621,"")
D14=IF(B14>0,C14*0.621,"")
D15=IF(B15>0,C15*0.621,"")
D16=IF(B16>0,C16*0.621,"")
D17=IF(B17>0,C17*0.621,"")
D18=IF(B18>0,C18*0.621,"")
D19=IF(B19>0,C19*0.621,"")
D20=IF(B20>0,C20*0.621,"")
D21=IF(B21>0,C21*0.621,"")
D22=IF(B22>0,C22*0.621,"")
D23=IF(B23>0,C23*0.621,"")
D24=IF(B24>0,C24*0.621,"")
D25=IF(B25>0,C25*0.621,"")
D26=IF(B26>0,C26*0.621,"")
D27=IF(B27>0,C27*0.621,"")
D28=IF(B28>0,C28*0.621,"")
D29=IF(B29>0,C29*0.621,"")
D30=IF(B30>0,C30*0.621,"")
D31=IF(B31>0,C31*0.621,"")
D32=IF(B32>0,C32*0.621,"")
D33=IF(B33>0,C33*0.621,"")
D34=IF(B34>0,C34*0.621,"")
D35=IF(B35>0,C35*0.621,"")
D36=IF(B36>0,C36*0.621,"")
D37=IF(B37>0,C37*0.621,"")
D38=IF(B38>0,C38*0.621,"")
D39=IF(B39>0,C39*0.621,"")
D40=IF(B40>0,C40*0.621,"")
D41=IF(B41>0,C41*0.621,"")
D42=IF(B42>0,C42*0.621,"")
D43=IF(B43>0,C43*0.621,"")
D44=IF(B44>0,C44*0.621,"")
D45=IF(B45>0,C45*0.621,"")
D46=IF(B46>0,C46*0.621,"")
D47=IF(B47>0,C47*0.621,"")
D48=IF(B48>0,C48*0.621,"")
D49=IF(B49>0,C49*0.621,"")
D50=IF(B50>0,C50*0.621,"")
D51=IF(B51>0,C51*0.621,"")
D52=IF(B52>0,C52*0.621,"")
D53=IF(B53>0,C53*0.621,"")
D54=IF(B54>0,C54*0.621,"")
D55=IF(B55>0,C55*0.621,"")
D56=IF(B56>0,C56*0.621,"")
D57=IF(B57>0,C57*0.621,"")
D58=IF(B58>0,C58*0.621,"")
D59=IF(B59>0,C59*0.621,"")
D60=IF(B60>0,C60*0.621,"")
D61=IF(B61>0,C61*0.621,"")
D62=IF(B62>0,C62*0.621,"")
D63=IF(B63>0,C63*0.621,"")
D64=IF(B64>0,C64*0.621,"")
D65=IF(B65>0,C65*0.621,"")
D66=IF(B66>0,C66*0.621,"")
D67=IF(B67>0,C67*0.621,"")
D68=IF(B68>0,C68*0.621,"")
D69=IF(B69>0,C69*0.621,"")
D70=IF(B70>0,C70*0.621,"")
D71=IF(B71>0,C71*0.621,"")
D72=IF(B72>0,C72*0.621,"")
D7{=INDEX(LogYear_Bike_Dates,MATCH(2,INDEX(1/(LogYear_Bike_Miles=E7),0)))}
D8{=INDEX(LogYear_Bike_Dates,MATCH(2,INDEX(1/(LogYear_Bike_Times=E8),0)))}
E1=IF(D1>0,C1/(D1*24),"AVE SPEED")
E2=IF(SUM(Last365_Bike_Times)>0,SUM(Last365_Bike_Miles)/(SUM(Last365_Bike_Times)*24),"")
E4=SUM(All_Bike_Miles)
E5=COUNTIF(All_Bike_Miles,">0.01") & " Sessions"
E7=MAX(LogYear_Bike_Miles)
E8=MAX(LogYear_Bike_Times)
E11=IF(B11>0,D11/(B11*24),"")
E12=IF(B12>0,D12/(B12*24),"")
E13=IF(B13>0,D13/(B13*24),"")
E14=IF(B14>0,D14/(B14*24),"")
E15=IF(B15>0,D15/(B15*24),"")
E16=IF(B16>0,D16/(B16*24),"")
E17=IF(B17>0,D17/(B17*24),"")
E18=IF(B18>0,D18/(B18*24),"")
E19=IF(B19>0,D19/(B19*24),"")
E20=IF(B20>0,D20/(B20*24),"")
E21=IF(B21>0,D21/(B21*24),"")
E22=IF(B22>0,D22/(B22*24),"")
E23=IF(B23>0,D23/(B23*24),"")
E24=IF(B24>0,D24/(B24*24),"")
E25=IF(B25>0,D25/(B25*24),"")
E26=IF(B26>0,D26/(B26*24),"")
E27=IF(B27>0,D27/(B27*24),"")
E28=IF(B28>0,D28/(B28*24),"")
E29=IF(B29>0,D29/(B29*24),"")
E30=IF(B30>0,D30/(B30*24),"")
E31=IF(B31>0,D31/(B31*24),"")
E32=IF(B32>0,D32/(B32*24),"")
E33=IF(B33>0,D33/(B33*24),"")
E34=IF(B34>0,D34/(B34*24),"")
E35=IF(B35>0,D35/(B35*24),"")
E36=IF(B36>0,D36/(B36*24),"")
E37=IF(B37>0,D37/(B37*24),"")
E38=IF(B38>0,D38/(B38*24),"")
E39=IF(B39>0,D39/(B39*24),"")
E40=IF(B40>0,D40/(B40*24),"")
E41=IF(B41>0,D41/(B41*24),"")
E42=IF(B42>0,D42/(B42*24),"")
E43=IF(B43>0,D43/(B43*24),"")
E44=IF(B44>0,D44/(B44*24),"")
E45=IF(B45>0,D45/(B45*24),"")
E46=IF(B46>0,D46/(B46*24),"")
E47=IF(B47>0,D47/(B47*24),"")
E48=IF(B48>0,D48/(B48*24),"")
E49=IF(B49>0,D49/(B49*24),"")
E50=IF(B50>0,D50/(B50*24),"")
E51=IF(B51>0,D51/(B51*24),"")
E52=IF(B52>0,D52/(B52*24),"")
E53=IF(B53>0,D53/(B53*24),"")
E54=IF(B54>0,D54/(B54*24),"")
E55=IF(B55>0,D55/(B55*24),"")
E56=IF(B56>0,D56/(B56*24),"")
E57=IF(B57>0,D57/(B57*24),"")
E58=IF(B58>0,D58/(B58*24),"")
E59=IF(B59>0,D59/(B59*24),"")
E60=IF(B60>0,D60/(B60*24),"")
E61=IF(B61>0,D61/(B61*24),"")
E62=IF(B62>0,D62/(B62*24),"")
E63=IF(B63>0,D63/(B63*24),"")
E64=IF(B64>0,D64/(B64*24),"")
E65=IF(B65>0,D65/(B65*24),"")
E66=IF(B66>0,D66/(B66*24),"")
E67=IF(B67>0,D67/(B67*24),"")
E68=IF(B68>0,D68/(B68*24),"")
E69=IF(B69>0,D69/(B69*24),"")
E70=IF(B70>0,D70/(B70*24),"")
E71=IF(B71>0,D71/(B71*24),"")
E72=IF(B72>0,D72/(B72*24),"")
B1="THIS WEEK " & "(WK " & INT((A1-DATE(YEAR(A1-WEEKDAY(A1-1)+4),1,3)+WEEKDAY(DATE(YEAR(A1-WEEKDAY(A1-1)+4),1,3))+5)/7) & ") ►"
B6=A6-7
B7="DISTANCE (MILES) "& YEAR(NOW())&" TO DATE"
B8="POWER (AV WATTS) "& YEAR(NOW())&" TO DATE"
B9=COUNTA(OFFSET(A11, 0, 0, A1-36684))
C1=SUMIF(All_Bike_Dates,">"&A6,All_Bike_Miles)
C2=SUMIF(All_Bike_Dates,">"&B6,All_Bike_Miles)-C1
C3=YEAR(NOW())
C4=SUM(LogYear_Bike_Miles)
C5=SUM(LogYear_Bike_Times)
Press CTRL+SHIFT+ENTER to enter array formulas.
Named Ranges
NameRefers ToCells
All_Bike_Dates='Exercise Bike'!$A$11:INDEX('Exercise Bike'!$A$11:$A$9997,COUNTA('Exercise Bike'!$A$11:$A$9997))
All_Bike_Heart_Rates='Exercise Bike'!$G$11:INDEX('Exercise Bike'!$G$11:$G$9997,COUNTA('Exercise Bike'!$A$11:$A$9997))
All_Bike_Miles='Exercise Bike'!$D$11:INDEX('Exercise Bike'!$D$11:$D$9997,COUNTA('Exercise Bike'!$A$11:$A$9997))
All_Bike_Times='Exercise Bike'!$B$11:INDEX('Exercise Bike'!$B$11:$B$9997,COUNTA('Exercise Bike'!$A$11:$A$9997))
All_Bike_Watts='Exercise Bike'!$H$11:INDEX('Exercise Bike'!$H$11:$H$9997,COUNTA('Exercise Bike'!$A$11:$A$9997))
Last365_Bike_Miles=INDEX(All_Bike_Miles,BikeLast365TopIndex):INDEX(All_Bike_Miles,BikeLast365BottomIndex)
Last365_Bike_Times=INDEX(All_Bike_Times,BikeLast365TopIndex):INDEX(All_Bike_Times,BikeLast365BottomIndex)
LogYear='Training Log'!$C$4
LogYear_Bike_Dates=INDEX(All_Bike_Dates,IFERROR(MATCH(DATE(LogYear-1,12,31),All_Bike_Dates,1),0)+1):INDEX(All_Bike_Dates,ROWS(All_Bike_Dates))
LogYear_Bike_Miles=INDEX(All_Bike_Miles,IFERROR(MATCH(DATE(LogYear-1,12,31),All_Bike_Dates,1),0)+1):INDEX(All_Bike_Miles,ROWS(All_Bike_Dates))
LogYear_Bike_Times=INDEX(All_Bike_Times,IFERROR(MATCH(DATE(LogYear-1,12,31),All_Bike_Dates,1),0)+1):INDEX(All_Bike_Times,ROWS(All_Bike_Dates))
VBADaysGone='Training Log'!$A$4
VBADaysLeft='Training Log'!$A$6
x=OFFSET(LastLogDate,0,0,-90)



Book1
ABCDEFGHIJKL
1DATETIME (h:mm)DIST. (km)DIST. (mls)SPEED (mph)LEVELHR BPMPower (W)90 Days from TodayCountChart Label
2Wed, 24 Oct 180:3512.27.576213.05 (42%)958722/10/201837
3Sat, 27 Oct 180:451811.17814.95 (42%)10499
4Tue, 30 Oct 181:0024.515.214515.25 (42%)111102DATEHR BPMPower (W)
5Fri, 2 Nov 181:0024.114.966115.05 (42%)10610021/10/201811897
6Mon, 5 Nov 181:0024.815.400815.45 (42%)10510324/10/20189587
7Wed, 7 Nov 180:4519.111.861115.85 (42%)10510627/10/201810499
8Fri, 9 Nov 181:0025.215.649215.65 (42%)11510230/10/2018111102
9Sun, 11 Nov 181:0026.916.704916.75 (42%)11111202/11/2018106100
10Wed, 14 Nov 181:0026.416.394416.45 (42%)11011105/11/2018105103
11Mon, 19 Nov 180:4518.711.612715.55 (42%)10310407/11/2018105106
12Wed, 21 Nov 181:0026.216.270216.35 (42%)10810909/11/2018115102
13Fri, 23 Nov 181:0022.814.158814.26 (50%)10511711/11/2018111112
14Sun, 25 Nov 181:0023.114.345114.36 (50%)10811814/11/2018110111
15Wed, 28 Nov 181:0223.914.841914.46 (50%)10511819/11/2018103104
16Sat, 1 Dec 181:0023.614.655614.76 (50%)10712121/11/2018108109
17Tue, 4 Dec 181:0023.814.779814.86 (50%)10912223/11/2018105117
18Thu, 6 Dec 181:0022.714.096714.16 (50%)11011725/11/2018108118
19Sat, 8 Dec 181:0023.414.531414.56 (50%)10712128/11/2018105118
20Mon, 10 Dec 181:0025.615.897615.96 (50%)13113101/12/2018107121
21Wed, 12 Dec 181:0024.215.028215.06 (50%)11012404/12/2018109122
22Fri, 14 Dec 181:0023.314.469314.56 (50%)10412006/12/2018110117
23Mon, 17 Dec 181:0025.315.711315.76 (50%)10813008/12/2018107121
24Wed, 19 Dec 181:0024.415.152415.26 (50%)10812510/12/2018131131
25Fri, 21 Dec 181:0021.513.351513.46 (50%)9011012/12/2018110124
26Sun, 23 Dec 181:002414.90414.96 (50%)9912314/12/2018104120
27Wed, 26 Dec 181:0023.714.717714.76 (50%)9412217/12/2018108130
28Fri, 28 Dec 181:0024.915.462915.56 (50%)10212819/12/2018108125
29Sun, 30 Dec 181:0023.114.345114.36 (50%)9711921/12/201890110
30Wed, 2 Jan 191:0021.313.227313.26 (50%)9010923/12/201899123
31Fri, 4 Jan 191:0023.614.655614.76 (50%)9512126/12/201894122
32Sun, 6 Jan 191:0024.915.462915.56 (50%)10912828/12/2018102128
33Tue, 8 Jan 191:002314.28314.36 (50%)8911930/12/201897119
34Thu, 10 Jan 191:0026.716.580716.66 (50%)11013702/01/201990109
35Sat, 12 Jan 191:0023.514.593514.66 (50%)9212104/01/201995121
36Mon, 14 Jan 191:002515.52515.56 (50%)10112806/01/2019109128
37Wed, 16 Jan 191:0024.615.276615.36 (50%)10412608/01/201989119
38Fri, 18 Jan 191:0024.415.152415.26 (50%)10212510/01/2019110137
39        12/01/201992121
40        14/01/2019101128
41        16/01/2019104126
42        18/01/2019102125
43        Grand Total39774412
Last 90 Bike
Cell Formulas
RangeFormula
J2=TODAY()-90
K2=COUNTIF(Table1[DATE],">="&J2)
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))))}
A43{=IF(ROWS($A$2:A43)>$K$2,"",INDEX(Table1[DATE],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A43))))}
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))))}
B43{=IF(ROWS($A$2:A43)>$K$2,"",INDEX(Table1[TIME (h:mm)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A43))))}
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))))}
C43{=IF(ROWS($A$2:A43)>$K$2,"",INDEX(Table1[DIST. (km)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A43))))}
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))))}
D43{=IF(ROWS($A$2:A43)>$K$2,"",INDEX(Table1[DIST. (mls)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A43))))}
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))))}
E43{=IF(ROWS($A$2:A43)>$K$2,"",INDEX(Table1[SPEED (mph)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A43))))}
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))))}
F43{=IF(ROWS($A$2:A43)>$K$2,"",INDEX(Table1[LEVEL],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A43))))}
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))))}
G43{=IF(ROWS($A$2:A43)>$K$2,"",INDEX(Table1[HR BPM],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A43))))}
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))))}
H43{=IF(ROWS($A$2:A43)>$K$2,"",INDEX(Table1[Power (W)],SMALL(IF(Table1[DATE]>=$J$2,ROW(Table1[DATE])-ROW(Table1[#Headers])),ROWS($A$2:A43))))}
Press CTRL+SHIFT+ENTER to enter array formulas.
Named Ranges
NameRefers ToCells
x=OFFSET(LastLogDate,0,0,-90)
 
Last edited:
Upvote 0
I would potentially select all the Table data make that a named range. Then say in column Z insert your pivot and use your named range, if z won't take it try bigger (my first thought)
 
Upvote 0
Hi Mole, I'm sorry for the delay, I've looked into the reason and I've finally realised all I needed to do was right click in the table and convert to a range - I'd previously been trying to do this in the pivot data - doh!

Many thanks for your help.
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question Question
Custom View Fails with "Can't push objects off the sheet", but there are no objects!
Replies
5
Views
162
BoredTrevor
B
Y
  • Question Question
Pivot Table deletes on opening of workbook
Replies
3
Views
221
cooleomter
C
M
  • Question Question
I actually need to show duplicates in pivot tables
Replies
3
Views
361
matts12
M
S
  • Question Question
Help with tables
Replies
0
Views
188
SCPbrito
S
A
  • Question Question
Building a nested chart using a pivot table
Replies
1
Views
298
AnthoHead
A

Forum statistics

Threads
1,223,705
Messages
6,173,985
Members
452,540
Latest member
haasro02

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