Spreadsheet: 763973d1642514777-counting-days-until-threshold-reached-sample1
Sheet: Sheet1

Plant | date | rain | TEMP | 200 | 300 | 400
A | 2018-01-01 00:00:00 | 0.5 | 8 | how many days will pass from DATE until it reaches the number above? (200, 300, 400)
A | 2018-01-02 00:00:00 | 2.2 | 2
A | 2018-01-03 00:00:00 | 1.1 | 9
A | 2018-01-04 00:00:00 | 0.25 | 55
A | 2018-01-05 00:00:00 | 0.33 | 4
A | 2018-01-06 00:00:00 | 2.2 | 15
A | 2018-01-07 00:00:00 | 1.1 | 23
A | 2018-01-08 00:00:00 | 2.2 | 32
A | 2018-01-09 00:00:00 | 1.1 | 31.3571428571429
A | 2018-01-10 00:00:00 | 2.2 | 34.2142857142857
A | 2018-01-11 00:00:00 | 1.1 | 37.0714285714286
A | 2018-01-12 00:00:00 | 0.25 | 39.9285714285714
A | 2018-01-13 00:00:00 | 4.3 | 42.7857142857143
A | 2018-01-14 00:00:00 | 2.23461538461538 | 45.6428571428572
A | 2018-01-15 00:00:00 | 2.34692307692307 | 48.5
A | 2018-01-16 00:00:00 | 2.45923076923076 | 51.3571428571429
A | 2018-01-17 00:00:00 | 2.57153846153846 | 54.2142857142857
A | 2018-01-18 00:00:00 | 2.68384615384615 | 57.0714285714286
A | 2018-01-19 00:00:00 | 2.79615384615384 | 59.9285714285714
A | 2018-01-20 00:00:00 | 2.90846153846153 | 62.7857142857143
A | 2018-01-21 00:00:00 | 3.02076923076923 | 65.6428571428572
A | 2018-01-22 00:00:00 | 3.13307692307692 | 68.5
A | 2018-01-23 00:00:00 | 3.24538461538461 | 71.3571428571429
A | 2018-01-24 00:00:00 | 3.3576923076923 | 74.2142857142857
A | 2018-01-25 00:00:00 | 3.47 | 77.0714285714286
A | 2018-01-26 00:00:00 | 3.58230769230769 | 79.9285714285714
A | 2018-01-27 00:00:00 | 3.69461538461538 | 82.7857142857143
B | 2018-01-01 00:00:00 | 3.80692307692307 | 25
B | 2018-01-02 00:00:00 | 3.91923076923076 | 23
B | 2018-01-03 00:00:00 | 4.03153846153846 | 44
B | 2018-01-04 00:00:00 | 4.14384615384616 | 55
B | 2018-01-05 00:00:00 | 4.25615384615385 | 22
B | 2018-01-06 00:00:00 | 4 | 21
B | 2018-01-07 00:00:00 | 2 | 22
B | 2018-01-08 00:00:00 | 2.79615384615384 | 23
B | 2018-01-09 00:00:00 | 2.90846153846153 | 22.8928571428572
B | 2018-01-10 00:00:00 | 3.02076923076923 | 21.452380952381
B | 2018-01-11 00:00:00 | 3.13307692307692 | 20.0119047619048
B | 2018-01-12 00:00:00 | 3.24538461538461 | 18.5714285714286
B | 2018-01-13 00:00:00 | 3.3576923076923 | 17.1309523809524
B | 2018-01-14 00:00:00 | 3.47 | 15.6904761904762
B | 2018-01-15 00:00:00 | 3.58230769230769 | 14.25
B | 2018-01-16 00:00:00 | 3.69461538461538 | 12.8095238095238
B | 2018-01-17 00:00:00 | 3.80692307692307 | 11.3690476190477
B | 2018-01-18 00:00:00 | 3.91923076923076 | 9.92857142857146
B | 2018-01-19 00:00:00 | 4.03153846153846 | 8.48809523809527
B | 2018-01-20 00:00:00 | 4.14384615384616 | 7.04761904761907
B | 2018-01-21 00:00:00 | 4.25615384615385 | 5.60714285714286
B | 2018-01-22 00:00:00 | 4 | 4.16666666666666
B | 2018-01-23 00:00:00 | 2 | 2.72619047619046
B | 2018-01-24 00:00:00 | 2.79615384615384 | 1.28571428571426
B | 2018-01-25 00:00:00 | 2.90846153846153 | 12
B | 2018-01-26 00:00:00 | 3.02076923076923 | 12
B | 2018-01-27 00:00:00 | 3.13307692307692 | 20
C | 2018-01-01 00:00:00 | 3.24538461538461 | 50
C | 2018-01-02 00:00:00 | 3.3576923076923 | 22
C | 2018-01-03 00:00:00 | 3.47 | 2
C | 2018-01-04 00:00:00 | 3.58230769230769 | 15
C | 2018-01-05 00:00:00 | 3.69461538461538 | 15
C | 2018-01-06 00:00:00 | 3.80692307692307 | 15
C | 2018-01-07 00:00:00 | 3.91923076923076 | 15
C | 2018-01-08 00:00:00 | 4.03153846153846 | 15
C | 2018-01-09 00:00:00 | 4.14384615384616 | 15
C | 2018-01-10 00:00:00 | 4.25615384615385 | 15
C | 2018-01-11 00:00:00 | 4 | 15
C | 2018-01-12 00:00:00 | 2 | 15
C | 2018-01-13 00:00:00 | 2.79615384615384 | 15
C | 2018-01-14 00:00:00 | 2.90846153846153 | 15
C | 2018-01-15 00:00:00 | 3.02076923076923 | 15
C | 2018-01-16 00:00:00 | 3.13307692307692 | 22
C | 2018-01-17 00:00:00 | 3.24538461538461 | 2
C | 2018-01-18 00:00:00 | 3.3576923076923 | 8.1
C | 2018-01-19 00:00:00 | 3.47 | 6.2
C | 2018-01-20 00:00:00 | 3.58230769230769 | 4.3
C | 2018-01-21 00:00:00 | 3.69461538461538 | 2.4
C | 2018-01-22 00:00:00 | 3.80692307692307 | 0.5
C | 2018-01-23 00:00:00 | 3.91923076923076 | 10
C | 2018-01-24 00:00:00 | 4.03153846153846 | 15
C | 2018-01-25 00:00:00 | 4.14384615384616 | 13.9642857142857
C | 2018-01-26 00:00:00 | 4.25615384615385 | 14.4285714285714
C | 2018-01-27 00:00:00 | 4 | 14.8928571428571