Spreadsheet: 54325d1254323777-use-of-match-and-index-to-find-first-and-last-instances-meeting-criteria-time-temp
Sheet: Sheet1

Time | Temperature (°C) |  |  | row number
0 | 17.07 |  |  | Start time
0.1 | 16.895
0.2 | 16.545 |  |  | row number
0.3 | 16.79 |  |  | End time
0.4 | 16.545
0.5 | 16.23
0.6000000000000001 | 16.37
0.7000000000000001 | 16.23
0.8 | 16.335
0.9 | 16.44
1 | 16.44
1.1 | 16.02
1.2 | 16.23
1.3 | 16.16
1.4 | 16.335
1.5 | 16.09
1.6 | 16.195
1.7 | 16.125
1.8 | 16.055
1.9 | 16.09
2 | 16.23
2.1 | 16.265
2.2 | 15.74
2.3 | 15.67
2.4 | 15.075
2.5 | 15.67
2.6 | 15.005
2.7 | 15.005
2.8 | 15.67
2.9 | 15.635
3 | 16.09
3.1 | 18.015
3.2 | 21.05
3.3 | 30.63
3.4 | 35.11
3.5 | 35.11
3.6 | 38.89
3.7 | 38.89
3.8 | 65.78
3.9 | 65.78
4 | 97.174
4.100000000000001 | 97.174
4.2 | 96.902
4.3 | 88.908
4.4 | 88.908
4.5 | 68.126
4.600000000000001 | 62.346
4.7 | 57.004
4.800000000000001 | 57.004
4.9 | 31.68
5 | 31.365
5.100000000000001 | 36.51
5.2 | 41.462
5.300000000000001 | 37.84
5.4 | 43.4
5.5 | 33.325
5.600000000000001 | 32.625
5.7 | 36.545
5.800000000000001 | 46.29
5.9 | 46.29
6 | 79.146
6.100000000000001 | 79.146
6.2 | 131.96
6.300000000000001 | 131.96
6.4 | 287.276
6.5 | 287.276
6.600000000000001 | 265.78
6.7 | 265.78
6.800000000000001 | 287.242
6.9 | 287.242
7 | 336.256
7.100000000000001 | 336.256
7.2 | 299.452
7.300000000000001 | 299.452
7.4 | 266.834
7.5 | 263.944
7.600000000000001 | 263.944
7.7 | 168.33
7.800000000000001 | 168.33
7.9 | 121.155
8 | 117.208
8.1 | 117.208
8.200000000000001 | 67.276
8.3 | 67.276
8.4 | 30.84
8.5 | 33.675
8.6 | 33.71
8.700000000000001 | 29.03
8.8 | 26.615
8.9 | 28.925
9 | 28.19
9.1 | 23.535
9.200000000000001 | 26.055
9.3 | 26.055
9.4 | 48.092
9.5 | 48.092
9.600000000000001 | 76.392
9.700000000000001 | 71.088
9.8 | 63.23
9.9 | 54.726
10 | 46.46
10.1 | 41.462
10.2 | 43.706
10.3 | 44.148
10.4 | 45.406
10.5 | 46.528
10.6 | 52.652
10.7 | 59.758
10.8 | 59.758
10.9 | 124.165
11 | 124.165
11.1 | 220.07
11.2 | 220.07
11.3 | 250.07
11.4 | 250.07
11.5 | 327.242
11.6 | 327.242
11.7 | 483.168
11.8 | 483.168
11.9 | 633.3
12 | 634.455
12.1 | 634.455
12.2 | 709.724
12.3 | 709.724
12.4 | 785.44
12.5 | 785.44
12.6 | 798.194
12.7 | 799.316
12.8 | 797.854
12.9 | 793.264
13 | 793.264
13.1 | 760.408
13.2 | 756.868
13.3 | 756.868
13.4 | 730.374
13.5 | 730.374
13.6 | 659.57
13.7 | 659.57
13.8 | 595.214
13.9 | 603.366
14 | 603.366
14.1 | 523.465
14.2 | 523.465
14.3 | 486.897
14.4 | 486.897
14.5 | 475.907
14.6 | 475.907
14.7 | 408.943
14.8 | 408.943
14.9 | 377.14
15 | 377.14
15.1 | 370.136
15.2 | 370.136
15.3 | 357.82
15.4 | 357.82
15.5 | 277.752
15.6 | 277.752
15.7 | 244.795
15.8 | 244.795
15.9 | 201.19
16 | 201.19
16.1 | 171.12
16.2 | 171.12
16.3 | 154.55
16.4 | 149.38
16.5 | 142.835
16.6 | 138.505
16.7 | 130.315
16.8 | 130.315
16.9 | 107.412
17 | 107.31
17.1 | 105.202
17.2 | 98.5
17.3 | 92.856
17.4 | 90.85
17.5 | 89.078
17.6 | 88.432
17.7 | 87.854
17.8 | 88.296
17.9 | 82.142
18 | 75.236
18.1 | 68.772
18.2 | 69.588
18.3 | 65.474
18.4 | 65.168
18.5 | 69.35
18.6 | 68.908
18.7 | 66.63
18.8 | 61.36
18.9 | 55.882
19 | 58.738
19.1 | 57.072
19.2 | 56.902
19.3 | 55.508
19.4 | 54.318
19.5 | 55.916
19.6 | 53.978
19.7 | 53.842
19.8 | 59.69
19.9 | 59.486
20 | 55.134
20.1 | 52.38
20.2 | 54.488
20.3 | 51.394
20.4 | 50.306
20.5 | 52.414
20.6 | 52.924
20.7 | 52.108
20.8 | 49.452
20.9 | 50.68
21 | 50.136
21.1 | 46.018
21.2 | 47.072
21.3 | 46.086
21.4 | 43.196
21.5 | 41.19
21.6 | 39.45
21.7 | 36.16
21.8 | 33.22
21.9 | 32.975
22 | 33.885
22.1 | 35.74
22.2 | 36.58
22.3 | 36.79
22.4 | 37.28
22.5 | 39.1
22.6 | 40.884
22.7 | 40.08
22.8 | 39.66
22.9 | 40.068
23 | 41.02
23.1 | 41.564
23.2 | 40.68
23.3 | 40.782
23.4 | 38.4
23.5 | 37.035
23.6 | 35.775
23.7 | 35.32
23.8 | 35.81
23.9 | 35.565
24 | 34.06
24.1 | 32.52
24.2 | 32.45
24.3 | 33.465
24.4 | 34.55
24.5 | 35.635
24.6 | 37.385
24.7 | 37.595
24.8 | 37.07
24.9 | 37.175
25 | 37.875
25.1 | 37.245
25.2 | 37.91
25.3 | 36.125
25.4 | 33.675
25.5 | 30.455
25.6 | 29.31
25.7 | 27.28
25.8 | 25.81
25.9 | 25.985
26 | 26.825
26.1 | 27.98
26.2 | 28.75
26.3 | 29.66
26.4 | 30.315
26.5 | 30.175
26.6 | 31.435
26.7 | 31.575
26.8 | 32.59
26.9 | 33.255
27 | 32.625
27.1 | 30.21
27.2 | 29.835
27.3 | 30.315
27.4 | 30.77
27.5 | 31.785
27.6 | 32.625
27.7 | 33.465
27.8 | 34.27
27.9 | 35.495
28 | 35.32
28.1 | 35.285
28.2 | 34.83
28.3 | 33.955
28.4 | 33.535
28.5 | 32.03
28.6 | 29.45
28.7 | 27.49
28.8 | 27.175
28.9 | 28.82
29 | 28.54
29.1 | 27.735
29.2 | 25.635
29.3 | 24.41
29.4 | 23.185
29.5 | 22.975
29.6 | 22.03
29.7 | 21.75
29.8 | 20.91
29.9 | 20.49
30 | 20.7
30.1 | 20.14
30.2 | 20.455
30.3 | 20.875
30.4 | 20.735
30.5 | 20.63
30.6 | 20.595
30.7 | 20.385
30.8 | 19.8
30.9 | 20.21
31 | 21.12
31.1 | 21.61
31.2 | 20.875
31.3 | 20.595
31.4 | 21.225
31.5 | 21.05
31.6 | 20.875
31.7 | 21.54
31.8 | 22.31
31.9 | 23.045
32 | 23.92
32.1 | 23.395
32.2 | 23.15
32.3 | 23.045
32.4 | 22.975
32.5 | 22.415
32.6 | 21.295
32.7 | 21.68
32.8 | 22.625
32.9 | 23.115
33 | 23.605
33.1 | 24.9
33.2 | 25.145
33.3 | 24.76
33.4 | 24.655
33.5 | 24.655
33.6 | 24.375
33.7 | 23.78
33.8 | 23.465
33.9 | 22.24
34 | 21.645
34.1 | 22.52
34.2 | 22.8
34.3 | 22.345
34.4 | 21.715
34.5 | 21.645
34.6 | 22.73
34.7 | 23.325
34.8 | 23.29
34.9 | 24.025
35 | 24.795
35.1 | 24.725
35.2 | 24.865
35.3 | 26.02
35.4 | 26.65
35.5 | 26.895
35.6 | 26.895
35.7 | 26.93
35.8 | 26.615
35.9 | 26.65
36 | 26.405
36.1 | 25.67
36.2 | 25.005
36.3 | 25.495
36.4 | 24.97
36.5 | 25.11
36.6 | 25.425
36.7 | 25.46
36.8 | 25.705
36.9 | 26.23
37 | 26.51
37.1 | 25.215
37.2 | 24.41
37.3 | 24.725
37.4 | 24.69
37.5 | 24.97
37.6 | 24.935
37.7 | 24.69
37.8 | 24.515
37.9 | 24.69
38 | 25.145
38.1 | 25.495
38.2 | 25.565
38.3 | 25.635
38.40000000000001 | 25.635
38.5 | 25.88
38.6 | 25.565
38.7 | 25.67
38.8 | 25.95
38.90000000000001 | 26.3
39 | 26.405
39.1 | 26.335
39.2 | 26.475
39.3 | 26.58
39.40000000000001 | 26.86
39.5 | 26.72
39.6 | 27
39.7 | 26.895
39.8 | 26.86
39.90000000000001 | 26.86
40 | 27.035
40.1 | 26.965
40.2 | 26.545
40.3 | 26.02
40.40000000000001 | 26.3
40.5 | 26.79
40.6 | 26.825
40.7 | 25.95
40.8 | 24.97
40.90000000000001 | 24.2
41 | 23.5
41.1 | 23.465
41.2 | 23.325
41.3 | 23.43
41.40000000000001 | 23.43
41.5 | 23.57
41.6 | 23.78
41.7 | 24.13
41.8 | 24.375
41.90000000000001 | 24.235
42 | 24.13
42.1 | 24.235
42.2 | 24.69
42.3 | 24.9
42.40000000000001 | 25.285
42.5 | 24.83
42.6 | 24.725
42.7 | 24.935
42.8 | 24.83
42.90000000000001 | 25.075
43 | 24.48
43.1 | 23.92
43.2 | 23.605
43.3 | 24.165
43.40000000000001 | 24.445
43.5 | 24.69
43.6 | 24.83
43.7 | 25.18
43.8 | 24.34
43.90000000000001 | 22.52
44 | 21.365
44.1 | 20.56
44.2 | 20.175
44.3 | 20.665
44.40000000000001 | 21.47
44.5 | 21.575
44.6 | 21.4
44.7 | 21.47
44.8 | 20.805
44.90000000000001 | 20.91
45 | 21.12
45.1 | 21.33
45.2 | 20.49
45.3 | 21.015
45.40000000000001 | 21.505
45.5 | 22.03
45.6 | 22.135
45.7 | 22.66
45.8 | 23.045
45.90000000000001 | 23.675
46 | 24.2
46.1 | 23.64
46.2 | 23.255
46.3 | 22.135
46.40000000000001 | 20.91
46.5 | 20.175
46.6 | 20.14
46.7 | 19.66
46.8 | 19.52
46.90000000000001 | 19.905
47 | 19.765
47.1 | 19.87
47.2 | 20
47.3 | 19.485
47.40000000000001 | 19.065
47.5 | 18.68
47.6 | 17.875
47.7 | 18.47
47.8 | 18.575
47.90000000000001 | 18.505
48 | 18.225
48.1 | 18.12
48.2 | 18.645
48.3 | 18.75
48.40000000000001 | 19.31
48.5 | 20
48.6 | 20.84
48.7 | 21.89
48.8 | 22.52
48.90000000000001 | 22.73
49 | 22.1
49.1 | 22.1
49.2 | 21.89
49.3 | 22.065
49.40000000000001 | 21.925
49.5 | 22.38
49.6 | 22.94
49.7 | 23.675
49.8 | 24.06
49.90000000000001 | 23.745
50 | 23.955
50.1 | 23.99
50.2 | 24.2
50.3 | 24.34
50.40000000000001 | 24.76
50.5 | 24.725
50.6 | 24.585
50.7 | 24.235
50.8 | 23.85
50.90000000000001 | 23.815
51 | 23.815
51.1 | 23.71
51.2 | 23.43
51.3 | 23.64
51.40000000000001 | 24.095
51.5 | 24.55
51.6 | 25.25
51.7 | 25.81
51.8 | 26.23
51.90000000000001 | 26.16
52 | 25.74
52.1 | 25.215
52.2 | 24.305
52.3 | 22.73
52.40000000000001 | 21.575
52.5 | 20.49
52.6 | 20.14
52.7 | 20.385
52.8 | 21.015
52.90000000000001 | 21.995
53 | 22.45
53.1 | 22.8
53.2 | 22.73
53.3 | 22.8
53.40000000000001 | 22.31
53.5 | 21.855
53.6 | 22.1
53.7 | 21.925
53.8 | 21.715
53.90000000000001 | 22.485
54 | 22.065
54.1 | 22.065
54.2 | 22.24
54.3 | 22.555
54.40000000000001 | 22.52
54.5 | 22.135
54.6 | 21.505
54.7 | 21.47
54.8 | 20.875
54.90000000000001 | 20.945
55 | 20.84
55.1 | 20.455
55.2 | 19.135
55.3 | 19.135
55.40000000000001 | 19.065
55.5 | 19.135
55.6 | 19.555
55.7 | 20.07
55.8 | 20.42
55.90000000000001 | 20.315
56 | 19.695
56.1 | 19.73
56.2 | 19.555
56.3 | 19.905
56.40000000000001 | 19.555
56.5 | 19.31
56.6 | 19.205
56.7 | 19.485
56.8 | 19.135
56.90000000000001 | 19.415
57 | 19.73
57.1 | 20.035
57.2 | 20.35
57.3 | 20.63
57.40000000000001 | 20.91
57.5 | 21.33
57.6 | 22.24
57.7 | 22.45
57.8 | 22.66
57.90000000000001 | 22.24
58 | 22.31
58.1 | 21.855
58.2 | 21.89
58.3 | 21.75
58.40000000000001 | 21.365
58.5 | 20.91
58.6 | 20.63
58.7 | 20.175
58.8 | 19.485
58.90000000000001 | 19.205
59 | 19.38
59.1 | 19.66
59.2 | 18.995
59.3 | 18.33
59.40000000000001 | 18.12
59.5 | 18.435
59.6 | 18.26
59.7 | 18.365
59.8 | 18.085
59.90000000000001 | 18.19
60 | 17.98
60.1 | 18.155
60.2 | 18.05
60.3 | 18.085
60.40000000000001 | 18.295
60.5 | 18.82
60.6 | 18.54
60.7 | 18.855
60.8 | 19.415
60.90000000000001 | 19.695
61 | 19.73
61.1 | 19.555
61.2 | 18.68
61.3 | 19.17
61.40000000000001 | 19.1
61.5 | 19.065
61.6 | 19.1
61.7 | 18.61
61.8 | 18.12
61.90000000000001 | 18.365
62 | 18.225
62.1 | 18.05
62.2 | 18.015
62.3 | 18.05
62.40000000000001 | 18.225
62.5 | 18.155
62.6 | 18.12
62.7 | 18.4
62.8 | 18.785
62.90000000000001 | 19.66
63 | 20.35
63.1 | 20.7
63.2 | 20.945
63.3 | 21.19
63.40000000000001 | 21.54
63.5 | 21.785
63.6 | 21.68
63.7 | 21.715
63.8 | 21.89
63.90000000000001 | 21.89
64 | 21.995
64.10000000000001 | 21.925
64.2 | 21.855
64.3 | 22.03
64.4 | 22.17
64.5 | 22.135
64.60000000000001 | 22.415
64.7 | 22.415
64.8 | 22.415
64.9 | 22.94
65 | 23.535
65.10000000000001 | 23.01
65.2 | 23.115
65.3 | 23.185
65.4 | 22.87
65.5 | 22.94
65.60000000000001 | 22.8
65.7 | 22.695
65.8 | 22.87
65.9 | 22.73
66 | 22.415
66.10000000000001 | 22.31
66.2 | 21.89
66.3 | 21.785
66.4 | 21.645
66.5 | 21.645
66.60000000000001 | 21.54
66.7 | 21.96
66.8 | 22.065
66.9 | 22.45
67 | 22.45
67.10000000000001 | 22.45
67.2 | 21.435
67.3 | 21.19
67.4 | 21.05
67.5 | 21.225
67.60000000000001 | 20.98
67.7 | 20.875
67.8 | 21.015
67.9 | 21.085
68 | 21.155
68.10000000000001 | 21.365
68.2 | 21.54
68.3 | 21.75
68.4 | 21.75
68.5 | 21.645
68.60000000000001 | 21.54
68.7 | 21.155
68.8 | 20.665
68.9 | 20.14
69 | 20.21
69.10000000000001 | 19.66
69.2 | 19.485
69.3 | 19.1
69.4 | 18.995
69.5 | 18.96
69.60000000000001 | 19.275
69.7 | 19.52
69.8 | 19.66
69.9 | 20.07
70 | 20.455
70.10000000000001 | 20.7
70.2 | 20.665
70.3 | 20.385
70.4 | 20.56
70.5 | 20.21
70.60000000000001 | 19.38
70.7 | 18.96
70.8 | 18.645
70.9 | 18.365
71 | 18.54
71.10000000000001 | 18.61
71.2 | 18.89
71.3 | 19.065
71.4 | 18.68
71.5 | 18.96
71.60000000000001 | 18.365
71.7 | 18.4
71.8 | 18.05
71.9 | 18.155
72 | 18.155
72.10000000000001 | 18.575
72.2 | 18.575
72.3 | 18.4
72.4 | 18.61
72.5 | 18.82
72.60000000000001 | 18.54
72.7 | 18.645
72.8 | 19.135
72.9 | 19.45
73 | 19.905
73.10000000000001 | 20.455
73.2 | 19.73
73.3 | 19.835
73.4 | 19.485
73.5 | 19.38
73.60000000000001 | 19.625
73.7 | 20.175
73.8 | 20.735
73.9 | 20.77
74 | 20.98
74.10000000000001 | 20.875
74.2 | 20.105
74.3 | 19.73
74.4 | 19.1
74.5 | 18.365
74.60000000000001 | 18.575
74.7 | 19.17
74.8 | 19.695
74.9 | 20.21
75 | 20.805
75.10000000000001 | 20.455
75.2 | 20.175
75.3 | 20.42
75.4 | 20.7
75.5 | 20.77
75.60000000000001 | 21.05
75.7 | 21.26
75.8 | 21.12
75.9 | 20.91
76 | 20.735
76.10000000000001 | 20.77
76.2 | 20.98
76.3 | 21.26
76.4 | 21.33
76.5 | 21.33
76.60000000000001 | 21.295
76.7 | 21.33
76.80000000000001 | 21.47
76.9 | 21.785
77 | 22.1
77.10000000000001 | 22.45
77.2 | 22.415
77.30000000000001 | 22.625
77.4 | 22.625
77.5 | 22.625
77.60000000000001 | 23.08
77.7 | 22.66
77.80000000000001 | 22.625
77.9 | 22.52
78 | 22.24
78.10000000000001 | 21.715
78.2 | 21.26
78.30000000000001 | 21.225
78.4 | 20.875
78.5 | 20.105
78.60000000000001 | 20.105
78.7 | 20.35
78.80000000000001 | 20.595
78.9 | 20.945
79 | 21.68
79.10000000000001 | 21.89
79.2 | 21.47
79.30000000000001 | 21.645
79.4 | 21.82
79.5 | 21.505
79.60000000000001 | 21.4
79.7 | 21.33
79.80000000000001 | 20.84
79.9 | 20.175
80 | 19.905
80.10000000000001 | 19.73
80.2 | 19.765
80.30000000000001 | 20.035
80.4 | 20.595
80.5 | 21.155
80.60000000000001 | 21.435
80.7 | 21.575
80.80000000000001 | 21.82
80.9 | 21.82
81 | 21.995
81.10000000000001 | 21.75
81.2 | 21.505
81.30000000000001 | 21.61
81.4 | 21.365
81.5 | 21.05
81.60000000000001 | 20.98
81.7 | 21.015
81.80000000000001 | 20.805
81.9 | 20.84
82 | 20.805
82.10000000000001 | 20.735
82.2 | 20.49
82.30000000000001 | 20.595
82.4 | 20.525
82.5 | 20.455
82.60000000000001 | 20.595
82.7 | 20.525
82.80000000000001 | 20.63
82.9 | 20.7
83 | 20.875
83.10000000000001 | 20.875
83.2 | 21.12
83.30000000000001 | 21.365
83.4 | 21.645
83.5 | 21.75
83.60000000000001 | 21.89
83.7 | 22.1
83.80000000000001 | 22.45
83.9 | 22.485
84 | 22.275
84.10000000000001 | 22.415
84.2 | 22.38
84.30000000000001 | 22.345
84.4 | 22.38
84.5 | 22.31
84.60000000000001 | 21.995
84.7 | 22.17
84.80000000000001 | 22.24
84.9 | 21.89
85 | 21.785
85.10000000000001 | 21.645
85.2 | 21.435
85.30000000000001 | 21.75
85.4 | 21.855
85.5 | 21.785
85.60000000000001 | 21.19
85.7 | 20.63
85.80000000000001 | 20.91
85.9 | 20.91
86 | 20.56
86.10000000000001 | 20.245
86.2 | 19.835
86.30000000000001 | 19.345
86.4 | 19.205
86.5 | 18.68
86.60000000000001 | 18.4
86.7 | 18.715
86.80000000000001 | 18.75
86.9 | 18.96
87 | 19.24
87.10000000000001 | 19.555
87.2 | 19.87
87.30000000000001 | 20.245
87.4 | 20.455
87.5 | 20.91
87.60000000000001 | 21.295
87.7 | 21.75
87.80000000000001 | 22.17
87.9 | 21.855
88 | 21.505
88.10000000000001 | 21.505