Spreadsheet: 719171d1613539871-return-a-value-based-on-cells-above-the-referenced-cell-book2
Sheet: Sheet1

Inflow (kL) | Rain (mm)
7035.899597 | 13
6756.986633 | 0
6941.468384 | 0
6649.845459 | 0
6530.407898 | 0
8818.685791 | 1
7943.085511 | 0
7675.616212 | 0
7523.627869 | 0
7390.686767 | 0
8460.363892 | 1.5
9382.307678 | 15
13712.64404 | 20.5
15384.90369 | 19
28226.00574 | 50
19232.28259 | 20
12264.18823 | 2.5
10735.74799 | 5
9309.708923 | 1
8633.476929 | 0
15677.041137 | 2
14294.723999 | 36
9712.812012 | 1
8664.788636 | 0
7968.595704 | 0
7662.675964 | 1
7403.126526 | 0
7163.989563 | 0
7043.419738 | 0
7351.115844 | 1.5
6994.301758 | 0
7143.469177 | 0
6975.561707 | 0
6761.24823 | 0
6708.609375 | 0
6755.680481 | 0
6551.626282 | 0
6639.035644 | 0
6792.097107 | 0
7017.636718 | 0
6961.631287 | 0
6929.439576 | 0
7063.676941 | 0
6880.882263 | 0
6889.730591 | 0
6795.72992 | 0
6855.503418 | 0
6590.867005 | 0
6746.209716 | 3
7031.568603 | 0
6839.417664 | 0
2955.903015 | 0
6866.136169 | 11.5
6692.083618 | 0
6779.290345 | 0
6732.9599 | 0
6962.047729 | 0
6895.874329 | 0
6893.627747 | 0
6841.878967 | 0
6690.802124 | 0
6701.738097 | 0
6612.004028 | 0
6837.963501 | 0
6759.481506 | 0
6805.529296 | 4
6830.548522 | 1
6858.520142 | 0
6635.421692 | 0
6601.083069 | 0
6892.016906 | 0
6827.006043 | 0
6800.30658 | 0
6692.260804 | 0
6666.412537 | 1
6965.40912 | 12
8551.811645 | 20
9256.768066 | 12.5
8283.581055 | 3
7705.404114 | 1
7342.50055 | 0
7020.39563 | 0
6522.140441 | 2.5
6617.174744 | 0
6882.872559 | 0
5912.009704 | 0
6039.841919 | 0
6217.094116 | 0
6135.312377 | 0
5975.458801 | 0
5952.736694 | 0
6001.266114 | 0
5884.436706 | 0
6106.652466 | 0
6349.063904 | 5
6819.317872 | 5.5
6340.528747 | 0
6421.568664 | 0
6937.382569 | 15
6602.03778 | 1
6699.923279 | 2
6754.216919 | 0
6696.318299 | 0
6434.966065 | 0
6514.068787 | 0
6587.700196 | 0
6550.442016 | 0
6519.887634 | 0
6540.801635 | 0
6514.779725 | 0
6505.976868 | 0
6396.826172 | 0
6697.269104 | 0
6552.994385 | 0
6523.367553 | 0
6522.985108 | 0
6496.705505 | 0
6158.393616 | 0
6003.338989 | 0
6851.423279 | 0
6649.808105 | 1
7004.848205 | 0
6629.52716 | 0
6503.853394 | 0
6503.306823 | 0
6716.25122 | 2
7057.097107 | 4.5
6867.677551 | 6
10231.721924 | 41
8153.263061 | 11.5
7111.819153 | 1.5
7222.458496 | 0
7080.481751 | 0
6975.685973 | 0
6843.200074 | 0
6854.19342 | 1
6592.356262 | 0
6417.320069 | 0
6610.466248 | 0
6727.184143 | 0
6592.513183 | 0
6586.757568 | 0
6634.426758 | 0
6587.427369 | 0
6392.763 | 0
6538.733521 | 0
6573.882813 | 0
6478.144348 | 0
6552.816345 | 2
6615.382507 | 1
6531.744018 | 2
6384.800414 | 2
6437.859435 | 5
6804.170105 | 0
6705.166138 | 0
6633.662781 | 3.5
6629.360779 | 1
6432.017578 | 0
6359.698181 | 1
6472.642945 | 0
6519.943237 | 0
6384.303955 | 0
6283.063538 | 1
5661.518219 | 0
5378.776612 | 0
8018.429871 | 1
11310.057983 | 62
21013.15918 | 42.5
16704.671631 | 22
10001.500611 | 0
7275.757019 | 0
6580.450256 | 0
3803.310059 | 26
7231.527404 | 0
6819.74524 | 0
6112.33313 | 0
3025.268524 | 0
2173.099823 | 0
8360.263672 | 24
7153.117615 | 2
7323.549499 | 3.5
7620.70166 | 4
6444.168091 | 0
6393.376221 | 0
6898.100891 | 13.5
5722.186523 | 13
6201.14978 | 1
5596.206054 | 0
5295.095703 | 0
4888.797608 | 0
5199.738038 | 0
5001.198059 | 0
5121.94989 | 0
5360.713134 | 0
5509.485474 | 0
5529.236694 | 0
5221.293701 | 0
5255.23236 | 0
5262.630127 | 5
5154.772003 | 0
5858.305115 | 4.5
6898.039368 | 19
6732.02887 | 8
6607.480041 | 2.5
6192.270447 | 1
5845.119628 | 0.5
5989.667725 | 12
5595.134399 | 0
5882.346801 | 0
6028.137451 | 0
5625.383545 | 0
5689.179321 | 0
6346.498779 | 10
5863.85968 | 2
6127.79895 | 0
6239.598389 | 0
6422.390137 | 5
6625.533203 | 0
6036.533386 | 0
5975.901794 | 0
5997.227295 | 0
5713.480469 | 0
5943.005249 | 0
5966.091615 | 0
5801.734253 | 0
5680.071838 | 15
5652.86023 | 1.5
5661.884033 | 0
5449.491394 | 1.5
5874.848938 | 0
5712.062011 | 4
5724.618713 | 0
5873.373168 | 12
5810.947326 | 0
5583.14563 | 0
5490.419007 | 0
5799.561523 | 0
5857.18689 | 0
5599.828124 | 0
5563.211669 | 0
5565.907227 | 0
5466.95813 | 0
5188.529113 | 0
5307.808167 | 0
5304.649963 | 0
5479.357544 | 0
5474.264283 | 0
5502.997803 | 0
5602.587525 | 0
5469.265015 | 0
5470.765442 | 0
6179.205018 | 0
5733.453674 | 0
5565.903443 | 0
5578.055054 | 0
5462.802002 | 0
5131.918397 | 0
5265.542297 | 0
5363.889954 | 0
5343.571533 | 12
5132.025879 | 0
5053.601501 | 0
4946.380554 | 0
5013.504212 | 0
5291.632568 | 0
5364.812989 | 0
5152.202881 | 0
4977.684936 | 1.5
5525.120057 | 12.5
5451.66272 | 0
5406.665467 | 7
5419.154236 | 0
5453.733582 | 0
5236.321594 | 0
5108.303345 | 0
5113.979187 | 0
4836.398865 | 0
4936.738525 | 7
5288.431092 | 1
5665.799804 | 8
5267.401123 | 0
5277.747924 | 0
5272.439454 | 0
5359.829468 | 0
5327.0802 | 0
5578.091797 | 0
5737.867798 | 0
5515.011718 | 0
5510.206238 | 0
5609.880799 | 0
5482.900513 | 0
5353.643615 | 0
5680.50354 | 0
5902.321044 | 0
5561.517395 | 0
5475.347473 | 0
5512.905029 | 0
5325.428955 | 0
5202.34851 | 0
5556.628662 | 0
5659.445556 | 0
5542.13501 | 0
5553.246277 | 0
5508.83783 | 0
5539.705871 | 0
5524.892211 | 0
5872.378723 | 0
6011.09436 | 0
5741.878174 | 0
5563.848817 | 0
5587.277649 | 6.5
3704.276428 | 0
5497.987 | 0
5765.704773 | 0
5786.508606 | 0
5568.896057 | 0
5408.782043 | 0
5850.890503 | 0
5350.216187 | 0
5430.342407 | 0
5591.91565 | 0
5738.579407 | 0
10012.93097 | 0
9159.696167 | 0
6000.455932 | 0
5261.305847 | 0
5251.513732 | 0
5561.501953 | 0
5794.763793 | 0
5557.776367 | 0
5518.864624 | 0
5434.009705 | 0
5134.935303 | 0
5195.439941 | 0
5648.957581 | 0
5628.766052 | 0
5262.14972 | 0
5318.452881 | 0
5346.50177 | 0
5171.233093 | 0
5103.210083 | 0
5391.520447 | 0
5687.382752 | 0
5229.510864 | 0
5254.964538 | 0
5389.645569 | 0
5337.622803 | 0
5298.398743 | 0
5491.503784 | 0
5658.724274 | 0
5231.981933 | 0
5249.894837 | 0
5343.057312 | 7
5194.930298 | 0
5118.391235 | 0
5206.760559 | 0
5217.165528 | 0
5138.523925 | 0
4937.277648 | 0
4824.525451 | 0
4917.075562 | 0
5128.842469 | 0
5137.64441 | 0
5216.885254 | 0
5098.586669 | 0
4932.43982 | 3
5003.101929 | 4
5106.719116 | 0
5032.043396 | 0
5024.657898 | 0
4808.747071 | 0
5563.892394 | 0
4939.811707 | 0
5016.316834 | 0
4973.238648 | 0
5374.672974 | 1
5755.515442 | 24
5861.073058 | 7
5246.311523 | 0
5212.261108 | 3.5
5258.947143 | 0
5444.238769 | 0
5295.164795 | 9
5464.084045 | 0
6025.490234 | 3.5
5533.984253 | 9
5656.556519 | 0
5415.808228 | 3.5
5378.599854 | 0
5345.275147 | 0
5575.634705 | 0
5738.023498 | 0
5140.90448 | 0
4648.142883 | 0
3990.853882 | 0
4805.108093 | 0
5498.094116 | 0
5831.340516 | 0
5878.41681 | 0
5608.215698 | 0
5569.480957 | 2
5619.742371 | 4
5483.690918 | 0
5424.696045 | 0
5628.730835 | 0
5826.324707 | 0
5497.120178 | 0
5446.931335 | 0
5496.278626 | 0
5436.784974 | 0
5452.305481 | 0
5522.575806 | 0
5907.523194 | 0
5588.989563 | 0
5440.448609 | 0
5506.637695 | 0
5330.72583 | 0
5419.131287 | 0
5577.41156 | 0
5738.481933 | 0
5433.55249 | 0
5377.49115 | 0
5434.855652 | 0
5366.430664 | 0
5475.750855 | 0
5596.837708 | 0
5859.574708 | 0
5669.824402 | 18
5426.563721 | 0
5452.347107 | 0
5363.309205 | 0
5287.692322 | 0
5405.487366 | 0
5553.34729 | 0
5415.337341 | 0
5327.56018 | 0
5378.258667 | 0
5611.815002 | 2
5511.336181 | 0
5711.442138 | 0
5556.104248 | 0
5399.941956 | 0
5319.496827 | 0
5251.778809 | 0
5280.029724 | 0
5271.31372 | 0
5347.171204 | 0
5226.126587 | 0
5286.492858 | 0
6030.878785 | 29
5467.384979 | 10.5
5580.643189 | 0
5225.210815 | 5
5092.556488 | 2
5118.848205 | 0
5191.456604 | 0
4958.637513 | 0
5012.700622 | 0
5076.646362 | 0
5072.176819 | 0
5118.53772 | 0
5273.742676 | 0
5232.150573 | 0
5205.401184 | 0
5169.746094 | 0
5193.917176 | 0
5298.144043 | 0
5495.99945 | 0
5359.504944 | 10.5
5322.256043 | 0
5230.449951 | 0
5567.202515 | 1
6487.952149 | 24
5988.594421 | 17
16303.216676 | 76
8293.194885 | 0
6272.312195 | 0
6677.803772 | 7
6944.932922 | 0
6938.236023 | 9
6638.617921 | 0
6272.059997 | 7
6036.375915 | 5
6591.850891 | 3
6233.624145 | 6
6015.856507 | 1.5
5799.82141 | 0
5719.27771 | 0
6026.990113 | 0
6183.695679 | 0
5894.886353 | 0
5924.477051 | 2.5
5879.520386 | 2.5
25172.649658 | 37
24042.274658 | 120
14086.28064 | 9.5
24686.509278 | 55
16662.494385 | 8.5
21329.269775 | 51
16661.246582 | 8
29854.716064 | 56
17934.926514 | 18
8846.44812 | 0
7061.982055 | 3
6089.07074 | 0
5534.286987 | 0
5392.834961 | 0
2199.60611 | 13.5
4966.126221 | 0
4863.997375 | 0
4937.939697 | 3
5089.232239 | 4
5187.161805 | 9
5051.079102 | 3
5836.46399 | 5
5416.353516 | 2
5019.858887 | 0
5091.613221 | 0
4726.727723 | 0
4605.783019 | 0
8268.371216 | 52
5660.013001 | 0
11098.863037 | 0
10386.727783 | 40
6857.542663 | 0
18925.254883 | 0
17886.648193 | 58.5
10473.671875 | 0
8385.778809 | 0
8184.815064 | 22
6844.516663 | 0
6158.644775 | 0
5532.205628 | 0
5238.346924 | 0
5068.143921 | 0
4823.026489 | 0
4766.823425 | 0
4955.210205 | 0
4881.821289 | 0
4450.974487 | 0
4414.092163 | 2
4527.009888 | 0
4610.260315 | 0
4391.518005 | 4
4587.945495 | 4
4482.198364 | 0
4427.550354 | 0
4314.73053 | 0
4349.97577 | 0
4296.709045 | 0
4293.107421 | 0
4339.624634 | 0
4314.401429 | 0
4388.108216 | 0
4217.272888 | 0
4188.013977 | 0
4111.243653 | 2
4070.308533 | 1
4200.451691 | 0
3985.516571 | 0
4155.773803 | 0
4224.745422 | 0
4201.150268 | 0
4255.786377 | 0
4372.8479 | 0
4019.103699 | 0
4173.869812 | 0
4466.106324 | 7.5
4184.590576 | 0
4225.860718 | 0
4151.80426 | 0
4122.962769 | 0
4178.93457 | 0
4200.533783 | 0
4259.844421 | 0
4072.456543 | 2
4237.480285 | 0
4242.74884 | 0
4203.506653 | 0
4288.687927 | 0
4159.805298 | 0
4258.771332 | 0
4255.546264 | 0
4231.555725 | 0
4206.334656 | 0
4254.44104 | 0
4323.576294 | 0
4152.308898 | 0
4348.238524 | 0
4256.736083 | 0
4131.866089 | 0
4278.713257 | 0
4230.360962 | 0
4280.993102 | 0
4303.431152 | 0
4182.291137 | 1.5
4168.283875 | 0
4226.033386 | 0
4268.549256 | 11.5
4350.605774 | 0
4110.840088 | 0
4607.111084 | 0
4442.123841 | 0
4250.01471 | 0
4245.047364 | 0
4177.211304 | 0
4245.714661 | 0
4384.241271 | 0
4337.459777 | 0
4281.817138 | 0
5140.108582 | 0
5911.767822 | 0
5821.886963 | 0
5778.055663 | 0
6086.421204 | 0
6154.077515 | 0
6006.652405 | 0
5879.727661 | 0
6076.479248 | 3.5
6002.62329 | 3
5958.105042 | 0
5978.046386 | 0
6727.08844 | 2
6583.367736 | 25
6052.465577 | 0
6059.163391 | 0
6169.172058 | 2
6106.656677 | 10
5966.219116 | 6
6497.949097 | 0
6254.694702 | 2
5975.424194 | 0
5889.980591 | 0
5889.712891 | 0
5828.333313 | 0
5892.305238 | 0
5550.970216 | 1.5
6106.463623 | 0
5642.107605 | 0
5783.436463 | 0
5755.038574 | 0
5703.109497 | 0
5695.224182 | 0
5807.423889 | 2
5976.744507 | 0
5840.430054 | 0
5843.207093 | 0
6277.397827 | 5
6244.402283 | 6
6087.789673 | 0
6350.62262 | 6
6302.858826 | 0
6192.696777 | 0
6213.422729 | 0
6040.021057 | 0
5999.39154 | 0
6106.499939 | 0
6262.431824 | 0
6061.14154 | 0
5929.673829 | 0
5807.113647 | 0
5816.997132 | 0
5999.524292 | 5.5
6960.308838 | 3
7926.959167 | 20
6787.483582 | 2
6330.387451 | 0
6187.934326 | 0
5966.292602 | 0
5796.815612 | 0
6289.544739 | 0
6046.306945 | 0
6124.019714 | 0
5789.009278 | 0
5738.637695 | 0
5645.887207 | 0
6161.604309 | 0
6393.145325 | 10
6380.344848 | 0
6075.330078 | 0
5869.997009 | 0
5997.85376 | 0
5667.779297 | 0
6012.352478 | 0
5546.624695 | 3
6285.963745 | 0
6065.640015 | 0
5230.998291 | 0
5478.513245 | 0
5736.307861 | 0
5371.962036 | 0
5429.229735 | 0
6272.979767 | 0
5940.839539 | 0
5897.549743 | 0
5857.414184 | 0
5838.419861 | 0
5757.944947 | 0
5968.923829 | 0
6016.109955 | 0
5937.982727 | 0
5743.832825 | 0
5752.888 | 0
5632.149048 | 0
5360.68402 | 0
5447.863403 | 0
5222.500244 | 4
5399.040649 | 0
5303.089112 | 0
5397.329529 | 0
5207.595642 | 0
5201.913331 | 3.5
5456.332398 | 0
5482.383484 | 0
4223.189758 | 0
5309.958618 | 0
5183.695495 | 0
5278.508789 | 0
5282.420227 | 0
5359.677002 | 0
5152.095642 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0