Spreadsheet: 826377d1681977358-apply-trend-function-if-the-level-is-between-of-certain-levels-values-test-example-2
Sheet: MM

1 |  | 2 |  | 3 |  |  |  |  |  |  |  | 7 |  | 26 |  | 27 |  | 28 |  | 29 |  | 30 |  | 31 |  | 33 |  |  |  | 39 |  | 41 |  | 42 |  | 1A |  | 2A |  | 3A |  | 4A |  | 5A |  | 6A |  | 7A |  | 8A |  | 9A |  | 10A |  | 11A
AVERAGE MILLIMETRES |  | AVERAGE MILLIMETRES |  |  |  |  |  |  |  |  |  |  |  |  |  | AVERAGE MILLIMETRES |  | AVERAGE MILLIMETRES |  | AVERAGE MILLIMETRES |  | AVERAGE MILLIMETRES |  | AVERAGE MILLIMETRES |  | AVERAGE MILLIMETRES |  |  |  | AVERAGE MILLIMETRES |  | AVERAGE MILLIMETRES |  | AVERAGE MILLIMETRES |  |  |  |  |  |  |  |  |  |  |  |  |  | AVERAGE MILLIMETRES |  |  |  |  |  | AVERAGE MILLIMETRES |  | AVERAGE MILLIMETRES
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
1 | 1019.586087371245 | 1 | 1019.454472661923 | 1 | 283.5432862936383 |  |  |  |  |  |  | 1 | 997.24514826056 | 1 | 446.3873397002191 | 1 | 728.4 | 1 | 286.3 | 1 | 262.1741150143367 | 1 | 115.6 | 1 | 262.3328769164669 | 1 | 3608.7 |  |  | 1 | 182.7820631499013 | 1 | 26917.6 | 1 | 31946.4 | 1 | 179.5384573927385 | 1 | 179.178739988212 | 1 | 180.25455828312 | 1 | 179.9300711484031 | 1 | 179.752792639953 | 1 | 179.3609853957498 | 1 | 179.9856336211626 | 1 | 180.0052276202323 | 1 | 178.7905015044878 | 1 | 346.6786769350782 | 1 | 345.0625016828602
2 | 2039.172174742491 | 2 | 2038.908945323846 | 2 | 567.0865725872766 |  |  |  |  |  |  | 2 | 1994.49029652112 | 2 | 892.7746794004381 | 2 | 784.8 | 2 | 335.6 | 2 | 524.3482300286735 | 2 | 129.2 | 2 | 524.6657538329339 | 2 | 3820.4 |  |  | 2 | 365.5641262998026 | 2 | 27347.2 | 2 | 32390.8 | 2 | 359.076914785477 | 2 | 358.3574799764239 | 2 | 360.5091165662399 | 2 | 359.8601422968062 | 2 | 359.5055852799061 | 2 | 358.7219707914996 | 2 | 359.9712672423252 | 2 | 360.0104552404647 | 2 | 357.5810030089756 | 2 | 693.3573538701564 | 2 | 690.1250033657204
3 | 3058.758262113736 | 3 | 3058.363417985768 | 3 | 850.6298588809149 |  |  |  |  |  |  | 3 | 2991.73544478168 | 3 | 1339.162019100657 | 3 | 841.1999999999999 | 3 | 384.9 | 3 | 786.5223450430102 | 3 | 142.8 | 3 | 786.9986307494008 | 3 | 4032.099999999999 |  |  | 3 | 548.3461894497038 | 3 | 27776.8 | 3 | 32835.2 | 3 | 538.6153721782155 | 3 | 537.5362199646358 | 3 | 540.7636748493599 | 3 | 539.7902134452092 | 3 | 539.2583779198592 | 3 | 538.0829561872494 | 3 | 539.9569008634877 | 3 | 540.0156828606971 | 3 | 536.3715045134635 | 3 | 1040.036030805235 | 3 | 1035.187505048581
4 | 4078.344349484982 | 4 | 4077.817890647691 | 4 | 1134.173145174553 |  |  |  |  |  |  | 4 | 3988.98059304224 | 4 | 1785.549358800876 | 4 | 897.5999999999999 | 4 | 434.2 | 4 | 1048.696460057347 | 4 | 156.4 | 4 | 1049.331507665868 | 4 | 4243.799999999999 |  |  | 4 | 731.1282525996052 | 4 | 28206.39999999999 | 4 | 33279.60000000001 | 4 | 718.153829570954 | 4 | 716.7149599528478 | 4 | 721.0182331324798 | 4 | 719.7202845936124 | 4 | 719.0111705598122 | 4 | 717.4439415829992 | 4 | 719.9425344846503 | 4 | 720.0209104809294 | 4 | 715.1620060179513 | 4 | 1386.714707740313 | 4 | 1380.250006731441
5 | 5097.930436856227 | 5 | 5097.272363309614 | 5 | 1417.716431468191 |  |  |  |  |  |  | 5 | 4986.2257413028 | 5 | 2231.936698501095 | 5 | 953.9999999999999 | 5 | 483.5000000000001 | 5 | 1310.870575071684 | 5 | 170 | 5 | 1311.664384582335 | 5 | 4455.499999999999 |  |  | 5 | 913.9103157495065 | 5 | 28635.99999999999 | 5 | 33724.00000000001 | 5 | 897.6922869636926 | 5 | 895.8936999410598 | 5 | 901.2727914155998 | 5 | 899.6503557420156 | 5 | 898.7639631997652 | 5 | 896.804926978749 | 5 | 899.9281681058129 | 5 | 900.0261381011617 | 5 | 893.9525075224391 | 5 | 1733.393384675391 | 5 | 1725.312508414301
6 | 6117.516524227472 | 6 | 6116.726835971536 | 6 | 1701.25971776183 |  |  |  |  |  |  | 6 | 5983.470889563359 | 6 | 2678.324038201315 | 6 | 1010.4 | 6 | 532.8000000000001 | 6 | 1573.04469008602 | 6 | 183.6 | 6 | 1573.997261498802 | 6 | 4667.199999999999 |  |  | 6 | 1096.692378899408 | 6 | 29065.59999999999 | 6 | 34168.40000000001 | 6 | 1077.230744356431 | 6 | 1075.072439929272 | 6 | 1081.52734969872 | 6 | 1079.580426890418 | 6 | 1078.516755839718 | 6 | 1076.165912374499 | 6 | 1079.913801726975 | 6 | 1080.031365721394 | 6 | 1072.743009026927 | 6 | 2080.072061610469 | 6 | 2070.375010097161
7 | 7137.102611598718 | 7 | 7136.18130863346 | 7 | 1984.803004055468 |  |  |  |  |  |  | 7 | 6980.71603782392 | 7 | 3124.711377901534 | 7 | 1066.8 | 7 | 582.1 | 7 | 1835.218805100357 | 7 | 197.2 | 7 | 1836.330138415269 | 7 | 4878.899999999999 |  |  | 7 | 1279.474442049309 | 7 | 29495.19999999999 | 7 | 34612.80000000001 | 7 | 1256.769201749169 | 7 | 1254.251179917484 | 7 | 1261.78190798184 | 7 | 1259.510498038822 | 7 | 1258.269548479671 | 7 | 1255.526897770249 | 7 | 1259.899435348138 | 7 | 1260.036593341626 | 7 | 1251.533510531415 | 7 | 2426.750738545547 | 7 | 2415.437511780021
8 | 8156.688698969963 | 8 | 8155.635781295382 | 8 | 2268.346290349106 |  |  |  |  |  |  | 8 | 7977.96118608448 | 8 | 3571.098717601752 | 8 | 1123.2 | 8 | 631.4 | 8 | 2097.392920114694 | 8 | 210.8 | 8 | 2098.663015331736 | 8 | 5090.599999999999 |  |  | 8 | 1462.25650519921 | 8 | 29924.79999999999 | 8 | 35057.20000000001 | 8 | 1436.307659141908 | 8 | 1433.429919905696 | 8 | 1442.03646626496 | 8 | 1439.440569187225 | 8 | 1438.022341119624 | 8 | 1434.887883165998 | 8 | 1439.885068969301 | 8 | 1440.041820961859 | 8 | 1430.324012035903 | 8 | 2773.429415480626 | 8 | 2760.500013462882
9 | 9176.274786341208 | 9 | 9175.090253957305 | 9 | 2551.889576642744 |  |  |  |  |  |  | 9 | 8975.206334345039 | 9 | 4017.486057301971 | 9 | 1179.6 | 9 | 680.6999999999999 | 9 | 2359.567035129031 | 9 | 224.3999999999999 | 9 | 2360.995892248202 | 9 | 5302.299999999998 |  |  | 9 | 1645.038568349112 | 9 | 30354.39999999999 | 9 | 35501.60000000001 | 9 | 1615.846116534647 | 9 | 1612.608659893908 | 9 | 1622.29102454808 | 9 | 1619.370640335628 | 9 | 1617.775133759577 | 9 | 1614.248868561748 | 9 | 1619.870702590463 | 9 | 1620.047048582091 | 9 | 1609.11451354039 | 9 | 3120.108092415704 | 9 | 3105.562515145742