{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["HOME","Data","Figures","B&R","C&J","CB&P","B&R Type Curve","Confined","Perched","Flowchart"],"not_rendered":{"charts":18,"images":9,"macros":1,"external_links":0,"defined_names":119,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"HOME","index":0,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[11,1,11,4],[3,1,3,4],[5,6,5,10],[10,1,10,4]]}
[null,null,null,null,null,"API LNAPL Transmissivity Workbook"]
[null,null,null,null,null,"Calculation of LNAPL Transmissivity from Baildown Test Data"]
[]
[null,"STEP 1: RESET OUTPUT SUMMARY"]
[]
[null,null,null,null,null,null,"STEP 4: LNAPL TRANSMISSIVITY SUMMARY"]
[]
[]
[]
[]
[null,"STEP 2: ENTER DATA & VIEW FIGURES"]
[null,"STEP 3: CHOOSE WELL CONDITIONS",null,null,null,null,null,null,"Mean LNAPL Transmissivity (ft2/d)"]
[null,null,null,null,null,null,null,null,0]
[]
[]
[null,null,null,null,null,null,null,null,"Standard Deviation (ft2/d)"]
[null,null,null,null,null,null,null,null,0]
[]
[]
[null,null,null,null,null,null,null,null,"Coefficient of Variation"]
[null,null,null,null,null,null,null,null,"NA"]

{"sheet":"Data","index":1,"n_rows":83,"n_cols":22,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
["Well Designation:","YYY","Example E2"]
["Date:","date"," "," "]
[]
["Ground Surface Elev (ft msl)",16.7,"Enter These Data",null,"Drawdown"]
["Top of Casing Elev (ft msl)",19,null,null,"Adjustment"]
["Well Casing Radius, rc (ft):",0.17,"re1",null,"(ft)"]
["Well Radius, rw (ft):",0.5,null,null,{"$f":"Figures!C28","v":0.4}]
["LNAPL Specific Yield, Sy:",0.161]
["LNAPL Density Ratio, rr:",0.878]
["Top of Screen (ft bgs):",7]
["Bottom of Screen (ft bgs):",27]
["LNAPL Baildown Vol. (gal.):"," "]
["Effective Radius, re3 (ft):",{"$f":"SQRT(B8*(B7^2-B6^2)+B6^2)","v":0.25396279255040494},"Calculated Parameters"]
["Effective Radius, re2 (ft):",{"$f":"SQRT(-Figures!U27*B6^2+(Figures!U27+1)*B13^2)","v":0.14453599032766892}]
["Initial Casing LNAPL Vol. (gal.):",{"$f":"PI()*B6^2*(F21-E21)*7.48","v":5.3922474748677933}]
["Initial Filter LNAPL Vol. (gal.):",{"$f":"IF(E21<B10,PI()*(B7^2-B6^2)*B8*(F21-B10)*7.48,PI()*(B7^2-B6^2)*B8*(F21-E21)*7.48)","v":6.6418122002635389}]
[]
[null,null,"Enter Data Here",null,null,null,null,null,"Water Table","LNAPL",null,null,"LNAPL",null,null,null,null,null,null,null,"LNAPL","Ave."]
[null,null,null,null,null,null,null,null,"Depth","Drawdown",null,"Average ","Discharge","sn","bn","re",null,null,"DTP","DTW","Volume","re"]
[null,"Time (min)","DTP (ft btoc)","DTW (ft btoc)","DTP (ft bgs)","DTW (ft bgs)",null,null,"(ft)","sn (ft)",null,"Time (min)","Qn (ft3/d)","(ft)","(ft)","(ft)",null,null,"(ft bgs)","(ft bgs)","(gallons)","(ft)"]
["Initial Fluid Levels:",0,19.079999999999998,27.02,{"$f":"C21+B4-B5","v":16.78},{"$f":"D21+B4-B5","v":24.72},null,null,{"$f":"E21+(1-B$9)*(F21-E21)","v":17.74868},null,null,null,null,null,{"$f":"F21-E21","v":7.9399999999999977}]
[]
["Enter Test Data:",0.5,28.81,29.12,{"$f":"IF(B23>0,C23+B$4-B$5,NA())","v":26.509999999999998},{"$f":"IF(B23>0,D23+B$4-B$5,NA())","v":26.82},null,null,{"$f":"E23+(1-B$9)*(F23-E23)","v":26.547819999999998},{"$f":"E23-E$21-E$7","v":9.3299999999999965},null,null,null,null,{"$f":"F23-E23","v":0.31000000000000227},null,null,null,null,null,0,{"$f":"MAX(V24:V81)/(MAX(L24:L81)-L24)","v":0.25396279255040505}]
[null,1,28.67,29.17,{"$f":"IF(B24>0,C24+B$4-B$5,NA())","v":26.370000000000005},{"$f":"IF(B24>0,D24+B$4-B$5,NA())","v":26.870000000000005},null,null,{"$f":"E24+(1-B$9)*(F24-E24)","v":26.431000000000004},9.1900000000000031,null,{"$f":"IF(B24>0,0.5*(B23+B24),0)","v":0.75},{"$f":"IF(B24>0,1440*PI()*P24^2*(E23-E24+F24-F23)/(B24-B23),NA())","v":110.87564242230816},{"$f":"0.5*(J23+J24)","v":9.26},{"$f":"F24-E24","v":0.5},{"$f":"IF(B24>0,re(B$10,E24,F24,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,{"$f":"(E23+E24)/2","v":26.44},{"$f":"(F23+F24)/2","v":26.845000000000002},{"$f":"U23+M24*(B24-B23)*7.48/1440","v":0.28796868240238371},0]
[null,1.5,28.4,29.11,26.099999999999994,26.810000000000002,null,null,26.186619999999994,8.9199999999999928,null,{"$f":"IF(B25>0,0.5*(B24+B25),0)","v":1.25},{"$f":"IF(B25>0,1440*PI()*P25^2*(E24-E25+F25-F24)/(B25-B24),NA())","v":122.54676267729408},{"$f":"0.5*(J24+J25)","v":9.0549999999999979},{"$f":"F25-E25","v":0.71000000000000796},{"$f":"IF(B25>0,re(B$10,E25,F25,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,{"$f":"(E24+E25)/2","v":26.234999999999999},26.840000000000003,{"$f":"U24+M25*(B25-B24)*7.48/1440","v":0.60624985768924478},{"$f":"IF(P25>0,V24+0.5*(P24+P25)*(L25-L24),0)","v":0.12698139627520247}]
[null,6.5,26.91,28.82,24.61,26.519999999999996,null,null,24.843019999999999,7.4299999999999979,null,4,70.026721529879012,8.1749999999999954,1.9099999999999966,{"$f":"IF(B26>0,re(B$10,E26,F26,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,25.354999999999997,26.664999999999999,2.424999430756936,{"$f":"IF(P26>0,V25+0.5*(P25+P26)*(L26-L25),0)","v":0.82537907578881597}]
[null,7.5,26.59,28.73,24.29,26.43,null,null,24.551079999999999,7.1099999999999977,null,7,67.108941466135846,7.2699999999999978,2.1400000000000006,{"$f":"IF(B27>0,re(B$10,E27,F27,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,24.45,26.474999999999998,2.7735930989282527,1.5872674534400308]
[null,8.5,26.35,28.72,24.049999999999997,26.42,null,null,24.339139999999997,6.8699999999999957,null,8,67.108941466135846,6.9899999999999967,2.3700000000000045,{"$f":"IF(B28>0,re(B$10,E28,F28,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,24.169999999999998,26.425000000000001,3.1221867670995693,1.8412302459904357]
[null,9.5,26.14,28.66,23.840000000000003,26.36,null,null,24.147440000000003,6.6600000000000019,null,9,43.766700956172308,6.7649999999999988,2.519999999999996,{"$f":"IF(B29>0,re(B$10,E29,F29,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,23.945,26.39,3.3495304637330201,2.0951930385408408]
[null,10.5,25.94,28.6,23.64,26.299999999999997,null,null,23.96452,6.4599999999999991,null,10,40.84892089242998,6.5600000000000005,2.6599999999999966,{"$f":"IF(B30>0,re(B$10,E30,F30,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,23.740000000000002,26.33,3.5617179139242534,2.3491558310912457]
[null,11.5,25.76,28.55,23.46,26.25,null,null,23.800380000000001,6.2799999999999994,null,11,37.931140828685571,6.3699999999999992,2.7899999999999991,{"$f":"IF(B31>0,re(B$10,E31,F31,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,23.55,26.274999999999999,3.758749117673259,2.6031186236416506]
[null,12.5,25.56,28.54,23.259999999999998,26.239999999999995,null,null,23.623559999999998,6.0799999999999965,null,12,55.43782121115408,6.1799999999999979,2.9799999999999969,{"$f":"IF(B32>0,re(B$10,E32,F32,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,23.36,26.244999999999997,4.0467178000756423,2.8570814161920555]
[null,13.5,25.4,28.48,23.099999999999994,26.18,null,null,23.475759999999994,5.9199999999999928,null,13,29.177800637452354,5.9999999999999947,3.0800000000000054,{"$f":"IF(B33>0,re(B$10,E33,F33,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,23.179999999999996,26.209999999999997,4.1982802644979644,3.1110442087424603]
[null,14.5,25.23,28.45,22.93,26.15,null,null,23.322839999999999,5.7499999999999982,null,14,40.848920892427905,5.8349999999999955,3.2199999999999989,{"$f":"IF(B34>0,re(B$10,E34,F34,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,23.014999999999997,26.164999999999999,4.4104677146891875,3.3650070012928652]
[null,15.5,25.04,28.39,22.739999999999995,26.090000000000003,null,null,23.148699999999995,5.5599999999999934,null,15,37.931140828687646,5.6549999999999958,3.3500000000000085,{"$f":"IF(B35>0,re(B$10,E35,F35,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,22.834999999999997,26.12,4.6074989184382042,3.6189697938432701]
[null,16.5,24.84,28.34,22.54,26.04,null,null,22.966999999999999,5.3599999999999977,null,16,43.766700956172308,5.4599999999999955,3.5,{"$f":"IF(B36>0,re(B$10,E36,F36,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,22.639999999999997,26.065000000000001,4.834842615071655,3.872932586393675]
[null,17.5,24.67,28.31,22.370000000000005,26.009999999999998,null,null,22.814080000000004,5.1900000000000031,null,17,40.848920892427905,5.2750000000000004,3.6399999999999935,{"$f":"IF(B37>0,re(B$10,E37,F37,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,22.455000000000002,26.024999999999999,5.0470300652628781,4.1268953789440799]
[null,18.5,24.53,28.29,22.230000000000004,25.989999999999995,null,null,22.688720000000004,5.0500000000000025,null,18,35.013360764939094,5.1200000000000028,3.7599999999999909,{"$f":"IF(B38>0,re(B$10,E38,F38,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,22.300000000000004,25.999999999999996,5.228905022569645,4.3808581714944852]
[null,19.5,24.4,28.22,22.099999999999994,25.92,null,null,22.566039999999994,4.9199999999999928,null,19,17.50668038247473,4.9849999999999977,3.8200000000000074,{"$f":"IF(B39>0,re(B$10,E39,F39,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,22.164999999999999,25.954999999999998,5.3198425012230555,4.6348209640448905]
[null,20.5,24.28,28.18,21.980000000000004,25.879999999999995,null,null,22.455800000000004,4.8000000000000025,null,20,23.34224050995525,4.8599999999999977,3.8999999999999915,{"$f":"IF(B40>0,re(B$10,E40,F40,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,22.04,25.9,5.4410924727608787,4.8887837565952958]
[null,21.5,24.11,28.12,21.810000000000002,25.82,null,null,22.299220000000002,4.6300000000000008,null,21,32.095580701196759,4.7150000000000016,4.009999999999998,{"$f":"IF(B41>0,re(B$10,E41,F41,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,21.895000000000003,25.849999999999998,5.6078111836254285,5.1427465491457012]
[null,22.5,23.98,28.1,21.68,25.799999999999997,null,null,22.182639999999999,4.4999999999999982,null,22,32.095580701194685,4.5649999999999995,4.1199999999999974,{"$f":"IF(B42>0,re(B$10,E42,F42,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,21.745000000000001,25.81,5.7745298944899677,5.3967093416961065]
[null,23.5,23.76,28.04,21.46,25.739999999999995,null,null,{"$f":"E43+(1-B$9)*(F43-E43)","v":21.98216},4.2799999999999994,null,23,46.684481019918792,{"$f":"0.5*(J42+J43)","v":4.3899999999999988},{"$f":"F43-E43","v":4.279999999999994},{"$f":"IF(B43>0,re(B$10,E43,F43,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,21.57,25.769999999999996,6.0170298375656568,5.6506721342465118]
[null,24.5,23.54,28.03,21.239999999999995,25.730000000000004,null,null,21.787779999999994,4.0599999999999934,null,24,61.273381338649116,4.1699999999999964,4.4900000000000091,{"$f":"IF(B44>0,re(B$10,E44,F44,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,21.349999999999998,25.734999999999999,6.3353110128525287,5.9046349267969171]
[null,25.5,23.35,28,21.049999999999997,25.700000000000003,null,null,{"$f":"E45+(1-B$9)*(F45-E45)","v":21.617299999999997},3.8699999999999961,null,25,46.684481019918792,{"$f":"0.5*(J44+J45)","v":3.9649999999999945},{"$f":"F45-E45","v":4.6500000000000057},{"$f":"IF(B45>0,re(B$10,E45,F45,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,21.144999999999996,25.715000000000003,6.5778109559282179,6.1585977193473225]
[null,26.6,23.17,27.97,20.870000000000005,25.67,null,null,{"$f":"E46+(1-B$9)*(F46-E46)","v":21.455600000000004},{"$f":"E46-E$21-E$7","v":3.6900000000000035},null,26.05,39.78790996015659,{"$f":"0.5*(J45+J46)","v":3.78},{"$f":"F46-E46","v":4.7999999999999972},{"$f":"IF(B46>0,re(B$10,E46,F46,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,{"$f":"(E45+E46)/2","v":20.96},{"$f":"(F45+F46)/2","v":25.685000000000002},{"$f":"U45+M46*(B46-B45)*7.48/1440","v":6.8051546525616686},6.4252586515252474]
[null,27.5,22.98,27.95,20.68,25.65,null,null,21.286339999999999,3.4999999999999987,null,27.05,55.113623426294829,3.5950000000000011,4.9699999999999989,{"$f":"IF(B47>0,re(B$10,E47,F47,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,20.775000000000002,25.66,7.062810842079597,6.6792214440756528]
[null,28.5,22.81,27.92,20.509999999999998,25.620000000000005,null,null,21.133419999999997,3.329999999999997,null,28,40.848920892432048,3.4149999999999978,5.1100000000000065,{"$f":"IF(B48>0,re(B$10,E48,F48,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,20.594999999999999,25.635000000000002,7.2749982922708414,6.9204860969985376]
[null,29.5,22.62,27.85,20.32,25.549999999999997,null,null,20.95806,3.1399999999999992,null,29,35.013360764937019,3.2349999999999981,5.2299999999999969,{"$f":"IF(B49>0,re(B$10,E49,F49,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,20.414999999999999,25.585000000000001,7.4568732495775976,7.1744488895489429]
[null,30.5,22.45,27.82,20.149999999999999,25.519999999999996,null,null,20.805139999999998,2.9699999999999975,null,30,40.84892089242998,3.0549999999999984,5.3699999999999974,{"$f":"IF(B50>0,re(B$10,E50,F50,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,20.234999999999999,25.534999999999997,7.6690606997688313,7.4284116820993482]
[null,31.5,22.31,27.8,20.009999999999998,25.5,null,null,20.679779999999997,2.829999999999997,null,31,35.013360764941169,2.8999999999999972,5.490000000000002,{"$f":"IF(B51>0,re(B$10,E51,F51,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,20.079999999999998,25.509999999999998,7.8509356570756088,7.6823744746497535]
[null,32.5,22.16,27.77,19.86,25.47,null,null,20.544419999999999,2.6799999999999984,null,32,35.013360764939094,2.7549999999999977,5.6099999999999994,{"$f":"IF(B52>0,re(B$10,E52,F52,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,19.934999999999999,25.484999999999999,8.0328106143823756,7.9363372672001589]
[null,33.5,22.02,27.76,19.72,25.46,null,null,20.420279999999998,2.5399999999999978,null,33,37.931140828685571,2.6099999999999981,5.740000000000002,{"$f":"IF(B53>0,re(B$10,E53,F53,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,19.79,25.465,8.2298418181313817,8.1903000597505642]
[null,34.5,21.91,27.75,19.61,25.450000000000003,null,null,20.322479999999999,2.4299999999999984,null,34,29.177800637450282,2.4849999999999981,5.8400000000000034,{"$f":"IF(B54>0,re(B$10,E54,F54,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,19.664999999999999,25.455000000000002,8.3814042825536923,8.4442628523009695]
[null,35.5,21.8,27.72,19.5,25.42,null,null,20.222239999999999,2.319999999999999,null,35,23.342240509959396,2.3749999999999987,5.9200000000000017,{"$f":"IF(B55>0,re(B$10,E55,F55,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,19.555,25.435000000000002,8.5026542540915369,8.6982256448513748]
[null,36.5,21.71,27.74,19.409999999999997,25.439999999999998,null,null,20.145659999999996,2.2299999999999955,null,36,32.095580701194685,2.2749999999999972,6.0300000000000011,{"$f":"IF(B56>0,re(B$10,E56,F56,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,19.454999999999998,25.43,8.6693729649560751,8.9521884374017802]
[null,37.5,21.6,27.73,19.299999999999997,25.43,null,null,20.047859999999996,2.1199999999999961,null,37,29.177800637450282,2.1749999999999958,6.1300000000000026,{"$f":"IF(B57>0,re(B$10,E57,F57,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,19.354999999999997,25.434999999999999,8.8209354293783857,9.2061512299521855]
[null,38.5,21.52,27.73,19.22,25.43,null,null,19.977619999999998,2.0399999999999978,null,38,23.342240509959396,2.079999999999997,6.2100000000000009,{"$f":"IF(B58>0,re(B$10,E58,F58,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,19.259999999999998,25.43,8.9421854009162303,9.4601140225025908]
[null,39.5,21.45,27.72,19.149999999999999,25.42,null,null,19.914939999999998,1.9699999999999975,null,39,17.506680382470584,2.0049999999999977,6.2700000000000031,{"$f":"IF(B59>0,re(B$10,E59,F59,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,19.184999999999999,25.425000000000001,9.0331228795696195,9.7140768150529961]
[null,40.5,21.38,27.73,19.079999999999998,25.43,null,null,19.854699999999998,1.8999999999999972,null,40,23.342240509959396,1.9349999999999974,6.3500000000000014,{"$f":"IF(B60>0,re(B$10,E60,F60,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,19.114999999999998,25.425000000000001,9.154372851107464,9.9680396076034015]
[null,41.5,21.31,27.73,19.009999999999998,25.43,null,null,19.793239999999997,1.829999999999997,null,41,20.42446044621499,1.8649999999999971,6.4200000000000017,{"$f":"IF(B61>0,re(B$10,E61,F61,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,19.044999999999998,25.43,9.2604665762030809,10.222002400153807]
[null,42.5,21.25,27.73,18.950000000000003,25.43,null,null,19.740560000000002,1.7700000000000018,null,42,17.50668038246851,1.7999999999999994,6.4799999999999969,{"$f":"IF(B62>0,re(B$10,E62,F62,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,18.98,25.43,9.3514040548564594,10.475965192704212]
[null,47.5,20.98,27.72,18.68,25.42,null,null,19.502279999999999,1.4999999999999987,null,45,15.172456331474228,1.6350000000000002,6.740000000000002,{"$f":"IF(B63>0,re(B$10,E63,F63,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,18.815000000000001,25.425000000000001,9.7454664623544716,11.237853570355426]
[null,52.5,20.76,27.7,18.46,25.4,null,null,19.30668,1.2799999999999998,null,50,11.671120254979698,1.3899999999999992,6.9399999999999977,{"$f":"IF(B64>0,re(B$10,E64,F64,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,18.57,25.41,10.048591391199084,12.507667533107451]
[null,57.5,20.57,27.71,18.269999999999996,25.409999999999997,null,null,19.141079999999995,1.089999999999995,null,55,11.671120254980114,1.1849999999999974,7.1400000000000006,{"$f":"IF(B65>0,re(B$10,E65,F65,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,18.364999999999998,25.404999999999998,10.351716320043707,13.777481495859476]
[null,62.5,20.41,27.71,18.11,25.409999999999997,null,null,19.000599999999999,0.92999999999999827,null,60,9.3368962039837591,1.0099999999999967,7.2999999999999972,{"$f":"IF(B66>0,re(B$10,E66,F66,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,18.189999999999998,25.409999999999997,10.594216263119396,15.047295458611501]
[null,67.5,20.32,27.7,18.019999999999996,25.4,null,null,18.920359999999995,0.83999999999999486,null,65,4.6684481019922934,0.88499999999999657,7.3800000000000026,{"$f":"IF(B67>0,re(B$10,E67,F67,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,18.064999999999998,25.404999999999998,10.715466234657251,16.317109421363526]
[null,72.5,20.190000000000001,27.17,17.89,24.870000000000005,null,null,18.74156,0.70999999999999941,null,70,-23.342240509959812,0.77499999999999714,6.980000000000004,{"$f":"IF(B68>0,re(B$10,E68,F68,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,17.954999999999998,25.135000000000002,10.109216376968018,17.586923384115551]
[null,77.5,20.100000000000001,27.68,17.799999999999997,25.379999999999995,null,null,18.724759999999996,0.619999999999996,null,75,35.013360764939506,0.6649999999999977,7.5799999999999983,{"$f":"IF(B69>0,re(B$10,E69,F69,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,17.844999999999999,25.125,11.018591163501863,18.856737346867575]
[null,82.5,20.010000000000002,27.68,17.71,25.379999999999995,null,null,18.64574,0.52999999999999969,null,80,5.2520041147407603,0.57499999999999785,7.6699999999999946,{"$f":"IF(B70>0,re(B$10,E70,F70,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,17.754999999999999,25.379999999999995,11.154997381481936,20.1265513096196]
[null,87.5,19.940000000000001,27.61,17.64,25.310000000000002,null,null,18.57574,0.45999999999999941,null,85,4.1464148576792847E-13,0.49499999999999955,7.6700000000000017,{"$f":"IF(B71>0,re(B$10,E71,F71,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,17.675000000000001,25.344999999999999,11.154997381481946,21.396365272371625]
[null,97.5,19.82,27.58,17.519999999999996,25.28,null,null,18.466719999999995,0.33999999999999486,null,92.5,2.6260020573705871,0.39999999999999714,7.7600000000000051,{"$f":"IF(B72>0,re(B$10,E72,F72,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,17.579999999999998,25.295000000000002,11.291403599462029,23.301086216499662]
[null,107.5,19.72,27.58,17.420000000000002,25.28,null,null,18.378920000000001,0.24000000000000055,null,102.5,2.9177800637448206,0.2899999999999977,7.8599999999999994,{"$f":"IF(B73>0,re(B$10,E73,F73,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,17.47,25.28,11.442966063884329,25.840714142003712]
[null,117.5,19.649999999999999,27.6,17.349999999999994,25.299999999999997,null,null,18.319899999999993,0.16999999999999316,null,112.5,2.6260020573705871,0.20499999999999685,7.9500000000000028,{"$f":"IF(B74>0,re(B$10,E74,F74,B$6,B$14,B$13), )","v":0.25396279255040494},null,null,17.384999999999998,25.29,11.579372281864412,28.380342067507762]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(B75>0,re(B$10,E75,F75,B$6,B$14,B$13), )","v":0},null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(B76>0,re(B$10,E76,F76,B$6,B$14,B$13), )","v":0},null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(B77>0,re(B$10,E77,F77,B$6,B$14,B$13), )","v":0},null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(B78>0,re(B$10,E78,F78,B$6,B$14,B$13), )","v":0},null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(B79>0,re(B$10,E79,F79,B$6,B$14,B$13), )","v":0},null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(B80>0,re(B$10,E80,F80,B$6,B$14,B$13), )","v":0},null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(B81>0,re(B$10,E81,F81,B$6,B$14,B$13), )","v":0},null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(P24:P81)","v":0.22331211069087353}]

{"sheet":"Figures","index":2,"n_rows":88,"n_cols":22,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Figure 1",null,null,null,null,null,null,null,"Figure 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"0.8*MIN(Data!B23:B81)","v":0.4},{"$f":"Data!E21","v":16.78}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(Data!B23:B81)","v":117.5},{"$f":"U3","v":16.78}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T3","v":0.4},{"$f":"Data!F21","v":24.72}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T4","v":117.5},{"$f":"U5","v":24.72}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T4/4","v":29.375},{"$f":"IF(V8<V9,V8,NA())","v":15.780000000000001},{"$f":"IF(Data!B10>Data!E21,Data!B10,Data!E21-1)","v":15.780000000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T8","v":29.375},{"$f":"IF(V8<V9,V9,NA())","v":25.72},{"$f":"IF(Data!B11<Data!F21,Data!B11,Data!F21+1)","v":25.72}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Figure 3",null,null,null,null,null,null,null,"Figure 4"]
[null,"Qn (ft3/d)","sn (ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bn","sn"]
[null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,0]
[null,50,4.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,9.8000000000000007]
[]
[]
[null,"Drawdown Adjust.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J-ratio",{"$f":"(U23-U24)/(T23-T24)","v":-1.2250000000000001}]
[null,"Dsn (ft)",0.4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Figure 5",null,null,null,null,null,null,null,"Figure 6"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Figure 7",null,null,null,null,null,null,null,"Figure 8"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Figure 9",null,null,null,null,null,null,null,"Figure 10"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"t (min)","sn (ft)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,0.115]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,0]

{"sheet":"B&R","index":3,"n_rows":64,"n_cols":28,"rows_kept":64,"cut":false,"hidden":true,"merged":[]}
["Generalized Bouwer and Rice (1976)"]
["Well Designation:",null,{"$f":"IF(Data!B1 > 0,Data!B1,\"\")","v":"YYY"}]
["Date:",null,{"$f":"IF(Data!B2 > 0,Data!B2,\"\")","v":"date"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"y = A + B x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B&R Type Curve"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Xi","Yi","X2","XY","(y-A-Bx)2","e","count","s/s0","SX",{"$f":"SUM(M6:M64)","v":792.1},null,"t (min)","s/s0",null,"Xi","Yi"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B23>=D$9,Data!B23-D$9,0)","v":0},{"$f":"IF(S6>0,LN(Data!J23),0)","v":0},{"$f":"M6^2","v":0},{"$f":"M6*N6","v":0},{"$f":"IF(M6>0,(N6-V$11-V$12*M6)^2,0)","v":0},{"$f":"IF(M6>0,(N6-V$11-V$12*M6)/SQRT(V$14),0)","v":0},{"$f":"IF(Data!B23>'B&R'!D$9,1,0)","v":0},{"$f":"IF(S6=0,NA(),EXP(N6)/EXP(V$19))","v":{"$error":"#N/A"}},"SY",{"$f":"SUM(N6:N64)","v":10.778430216461434},null,0,{"$f":"EXP(-2*E$12*(X6/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":1},null,{"$f":"IF(S6>0,M6,NA())","v":{"$error":"#N/A"}},{"$f":"IF(T6>0,N6,NA())","v":{"$error":"#N/A"}}]
[null,"Enter early time cut-off for least-squares model fit",null,null,null,null,null,null,null,"Le/re",null,null,{"$f":"IF(Data!B24>=D$9,Data!B24-D$9,0)","v":0},{"$f":"IF(S7>0,LN(Data!J24),0)","v":0},{"$f":"M7^2","v":0},{"$f":"M7*N7","v":0},{"$f":"IF(M7>0,(N7-V$11-V$12*M7)^2,0)","v":0},{"$f":"IF(M7>0,(N7-V$11-V$12*M7)/SQRT(V$14),0)","v":0},{"$f":"IF(Data!B24>'B&R'!D$9,1,0)","v":0},{"$f":"IF(S7=0,NA(),EXP(N7)/EXP(V$19))","v":{"$error":"#N/A"}},"SX2",{"$f":"SUM(O6:O64)","v":40317.81},null,{"$f":"X6+1.05*(MAX(M$6:M$64)/30)","v":3.2375000000000003},{"$f":"EXP(-2*E$12*(X7/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.89966718158278536},null,{"$f":"IF(S7>0,M7,NA())","v":{"$error":"#N/A"}},{"$f":"IF(T7>0,N7,NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!E21<Data!B10,(Data!F21-Data!B10)/Data!B13,(Data!F21-Data!E21)/Data!B13)","v":31.264422320541765},null,null,{"$f":"IF(Data!B25>=D$9,Data!B25-D$9,0)","v":0},{"$f":"IF(S8>0,LN(Data!J25),0)","v":0},0,0,0,0,{"$f":"IF(Data!B25>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},"SXY",{"$f":"SUM(P6:P64)","v":-349.10116068223448},null,{"$f":"X7+1.05*(MAX(M$6:M$64)/30)","v":6.4750000000000005},{"$f":"EXP(-2*E$12*(X8/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.80940103761711257},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"Timecut",25,"<-  Enter or change value here",null,null,null,null,"C",null,null,{"$f":"IF(Data!B26>=D$9,Data!B26-D$9,0)","v":0},{"$f":"IF(S9>0,LN(Data!J26),0)","v":0},0,0,0,0,{"$f":"IF(Data!B26>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},"N",{"$f":"SUM(S6:S64)","v":30},null,9.7125000000000004,{"$f":"EXP(-2*E$12*(X9/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.72819155028316973},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J8<2000,0.792+0.03993*J8-0.00005743^J8^2+0.00000003858*J8^3-0.000000000009659*J8^4,13.5)","v":2.0415581537352878},null,null,{"$f":"IF(Data!B27>=D$9,Data!B27-D$9,0)","v":0},{"$f":"IF(S10>0,LN(Data!J27),0)","v":0},0,0,0,0,{"$f":"IF(Data!B27>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},"D",{"$f":"V9*V7-V5^2","v":582111.88999999978},null,12.950000000000001,{"$f":"EXP(-2*E$12*(X10/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.65513003969565842},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,"R/re",null,null,{"$f":"IF(Data!B28>=D$9,Data!B28-D$9,0)","v":0},{"$f":"IF(S11>0,LN(Data!J28),0)","v":0},0,0,0,0,{"$f":"IF(Data!B28>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},"A",{"$f":"(V7*V6-V5*V8)/V10","v":1.2215619422272053},null,16.1875,{"$f":"EXP(-2*E$12*(X11/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.58939899638321147},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Model Results:",null,"Tn (ft2/d) =",{"$f":"1440*V22*(-V12)","v":3.2169929262324679},"+/-",{"$f":"1440*V22*SQRT(V15)","v":4.9729889978667237E-2},"ft2/d",null,{"$f":"EXP(((1.1/LN(J8))+J10/J8)^-1)","v":13.443619010125339},null,null,{"$f":"IF(Data!B29>=D$9,Data!B29-D$9,0)","v":0},{"$f":"IF(S12>0,LN(Data!J29),0)","v":0},0,0,0,0,{"$f":"IF(Data!B29>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},"B",{"$f":"(V9*V8-V5*V6)/V10","v":-3.2658033140202901E-2},null,19.425000000000001,{"$f":"EXP(-2*E$12*(X12/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.53026293390380619},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B30>=D$9,Data!B30-D$9,0)","v":0},{"$f":"IF(S13>0,LN(Data!J30),0)","v":0},0,0,0,0,{"$f":"IF(Data!B30>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,22.662500000000001,{"$f":"EXP(-2*E$12*(X13/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.47706015924305611},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,"J-Ratio",null,null,{"$f":"IF(Data!B31>=D$9,Data!B31-D$9,0)","v":0},{"$f":"IF(S14>0,LN(Data!J31),0)","v":0},0,0,0,0,{"$f":"IF(Data!B31>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},"sy2",{"$f":"SUM(Q6:Q64)/(V9-2)","v":4.9453843612814246E-3},null,25.900000000000002,{"$f":"EXP(-2*E$12*(X14/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.42919536891163501},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,{"$f":"Figures!U27","v":-1.2250000000000001},null,null,{"$f":"IF(Data!B32>=D$9,Data!B32-D$9,0)","v":0},{"$f":"IF(S15>0,LN(Data!J32),0)","v":0},0,0,0,0,{"$f":"IF(Data!B32>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},"sB2",{"$f":"V9*V14/V10","v":2.5486772111533883E-7},null,29.137500000000003,{"$f":"EXP(-2*E$12*(X15/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.38613298789711453},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B33>=D$9,Data!B33-D$9,0)","v":0},{"$f":"IF(S16>0,LN(Data!J33),0)","v":0},0,0,0,0,{"$f":"IF(Data!B33>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,32.375,{"$f":"EXP(-2*E$12*(X16/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.34739117693753691},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B34>=D$9,Data!B34-D$9,0)","v":0},{"$f":"IF(S17>0,LN(Data!J34),0)","v":0},0,0,0,0,{"$f":"IF(Data!B34>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,35.612499999999997,{"$f":"EXP(-2*E$12*(X17/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.31253644106212058},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B35>=D$9,Data!B35-D$9,0)","v":0},{"$f":"IF(S18>0,LN(Data!J35),0)","v":0},0,0,0,0,{"$f":"IF(Data!B35>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},"Plot Model Line",null,null,38.849999999999994,{"$f":"EXP(-2*E$12*(X18/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.28117877907227234},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B36>=D$9,Data!B36-D$9,0)","v":0},{"$f":"IF(S19>0,LN(Data!J36),0)","v":0},0,0,0,0,{"$f":"IF(Data!B36>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},0,{"$f":"V11","v":1.2215619422272053},null,42.087499999999991,{"$f":"EXP(-2*E$12*(X19/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.25296731968883995},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,"Coef. Of",null,null,{"$f":"IF(Data!B37>=D$9,Data!B37-D$9,0)","v":0},{"$f":"IF(S20>0,LN(Data!J37),0)","v":0},0,0,0,0,{"$f":"IF(Data!B37>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},{"$f":"MAX(M6:M64)","v":92.5},{"$f":"V11+V12*U20","v":-1.799306123241563},null,45.324999999999989,{"$f":"EXP(-2*E$12*(X20/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.22758639553701013},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,"Variation",null,null,{"$f":"IF(Data!B38>=D$9,Data!B38-D$9,0)","v":0},{"$f":"IF(S21>0,LN(Data!J38),0)","v":0},0,0,0,0,{"$f":"IF(Data!B38>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,48.562499999999986,{"$f":"EXP(-2*E$12*(X21/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.20475201103936694},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,{"$f":"G12/E12","v":1.5458501500936665E-2},null,null,{"$f":"IF(Data!B39>=D$9,Data!B39-D$9,0)","v":0},{"$f":"IF(S22>0,LN(Data!J39),0)","v":0},0,0,0,0,{"$f":"IF(Data!B39>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},"factor",{"$f":"Data!V23^2*LN('B&R'!J12)/(2*(-Figures!U27))","v":6.8406534338685349E-2},null,51.799999999999983,{"$f":"EXP(-2*E$12*(X22/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.18420866469519462},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B40>=D$9,Data!B40-D$9,0)","v":0},{"$f":"IF(S23>0,LN(Data!J40),0)","v":0},0,0,0,0,{"$f":"IF(Data!B40>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,55.03749999999998,{"$f":"EXP(-2*E$12*(X23/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.16572649018945418},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B41>=D$9,Data!B41-D$9,0)","v":0},{"$f":"IF(S24>0,LN(Data!J41),0)","v":0},0,0,0,0,{"$f":"IF(Data!B41>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,58.274999999999977,{"$f":"EXP(-2*E$12*(X24/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.14909868434235338},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B42>=D$9,Data!B42-D$9,0)","v":0},{"$f":"IF(S25>0,LN(Data!J42),0)","v":0},0,0,0,0,{"$f":"IF(Data!B42>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},"s0 (ft)",{"$f":"EXP(V19)","v":3.3924824591251768},null,61.512499999999974,{"$f":"EXP(-2*E$12*(X25/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.13413919311998643},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B43>=D$9,Data!B43-D$9,0)","v":0},{"$f":"IF(S26>0,LN(Data!J43),0)","v":0},0,0,0,0,{"$f":"IF(Data!B43>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null," ",null,64.749999999999972,{"$f":"EXP(-2*E$12*(X26/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.1206806298140472},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B44>=D$9,Data!B44-D$9,0)","v":0},{"$f":"IF(S27>0,LN(Data!J44),0)","v":0},0,0,0,0,{"$f":"IF(Data!B44>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,67.987499999999969,{"$f":"EXP(-2*E$12*(X27/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.10857240209643931},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B45>=D$9,Data!B45-D$9,0)","v":0.5},{"$f":"IF(S28>0,LN(Data!J45),0)","v":1.3532545070416895},0.25,0.67662725352084474,2.1910388555593515E-2,2.1048687194939055,{"$f":"IF(Data!B45>'B&R'!D$9,1,0)","v":1},1.1407575563406029,null,null,null,71.224999999999966,{"$f":"EXP(-2*E$12*(X28/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":9.767902699177651E-2},null,0.5,1.3532545070416895]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B46>=D$9,Data!B46-D$9,0)","v":1.6000000000000014},{"$f":"IF(S29>0,LN(Data!J46),0)","v":1.3056264580524368},2.5600000000000045,2.0890023328839007,1.8582425050065968E-2,1.9384346723715222,{"$f":"IF(Data!B46>'B&R'!D$9,1,0)","v":1},1.087699065348019,null,null,null,74.462499999999963,{"$f":"EXP(-2*E$12*(X29/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":8.7878614913440359E-2},null,1.6000000000000014,1.3056264580524368]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B47>=D$9,Data!B47-D$9,0)","v":2.5},{"$f":"IF(S30>0,LN(Data!J47),0)","v":1.2527629684953676},6.25,3.1319074212384193,1.2734244343222687E-2,1.6046730684720183,{"$f":"IF(Data!B47>'B&R'!D$9,1,0)","v":1},1.0316928804113987,null,null,null,77.69999999999996,{"$f":"EXP(-2*E$12*(X30/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":7.9061505800573861E-2},null,2.5,1.2527629684953676]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B48>=D$9,Data!B48-D$9,0)","v":3.5},{"$f":"IF(S31>0,LN(Data!J48),0)","v":1.2029723039923514},12.25,4.2104030639732297,9.1610698241208037E-3,1.3610468384258012,{"$f":"IF(Data!B48>'B&R'!D$9,1,0)","v":1},0.98158208336284436,null,null,null,80.937499999999957,{"$f":"EXP(-2*E$12*(X31/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":7.1129042095293291E-2},null,3.5,1.2029723039923514]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B49>=D$9,Data!B49-D$9,0)","v":4.5},{"$f":"IF(S32>0,LN(Data!J49),0)","v":1.1442227999201617},20.25,5.1490025996407276,4.8472238341829331E-3,0.99002579881378561,{"$f":"IF(Data!B49>'B&R'!D$9,1,0)","v":1},0.92557589842622634,null,null,null,84.174999999999955,{"$f":"EXP(-2*E$12*(X32/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":6.3992464830555845E-2},null,4.5,1.1442227999201617]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B50>=D$9,Data!B50-D$9,0)","v":5.5},{"$f":"IF(S33>0,LN(Data!J50),0)","v":1.0885619528146073},30.25,5.9870907404803404,2.1733491427796967E-3,0.66292549949859403,{"$f":"IF(Data!B50>'B&R'!D$9,1,0)","v":1},0.87546510137767208,null,null,null,87.412499999999952,{"$f":"EXP(-2*E$12*(X33/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":5.7571920476641676E-2},null,5.5,1.0885619528146073]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B51>=D$9,Data!B51-D$9,0)","v":6.5},{"$f":"IF(S34>0,LN(Data!J51),0)","v":1.0402767116551452},42.25,6.7617986257584439,9.6050312427684915E-4,0.44070640803178496,{"$f":"IF(Data!B51>'B&R'!D$9,1,0)","v":1},0.83419738616121608,null,null,null,90.649999999999949,{"$f":"EXP(-2*E$12*(X34/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":5.1795567433528492E-2},null,6.5,1.0402767116551452]
[null,"C coefficient calculated from Eq. 6.5(c) of Butler, The Design, Performance, and",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B52>=D$9,Data!B52-D$9,0)","v":7.5},{"$f":"IF(S35>0,LN(Data!J52),0)","v":0.98581679452276472},56.25,7.3936259589207349,8.4457953579522902E-5,0.13068334780018839,{"$f":"IF(Data!B52>'B&R'!D$9,1,0)","v":1},0.78998197700072792,null,null,null,93.887499999999946,{"$f":"EXP(-2*E$12*(X35/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":4.6598772171403686E-2},null,7.5,0.98581679452276472]
[null,"Analysis of Slug Tests, CRC Press, 2000.",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B53>=D$9,Data!B53-D$9,0)","v":8.5},{"$f":"IF(S36>0,LN(Data!J53),0)","v":0.93216408103044435},72.25,7.9233946887587772,1.393480972907224E-4,-0.16786126667821949,{"$f":"IF(Data!B53>'B&R'!D$9,1,0)","v":1},0.74871426178427181,null,null,null,97.124999999999943,{"$f":"EXP(-2*E$12*(X36/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":4.1923386024665089E-2},null,8.5,0.93216408103044435]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B54>=D$9,Data!B54-D$9,0)","v":9.5},{"$f":"IF(S37>0,LN(Data!J54),0)","v":0.88789125735245644},90.25,8.4349669448483358,5.48466893202593E-4,-0.33302373189292533,{"$f":"IF(Data!B54>'B&R'!D$9,1,0)","v":1},0.71628962839991372,null,null,null,null,null,null,9.5,0.88789125735245644]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B55>=D$9,Data!B55-D$9,0)","v":10.5},{"$f":"IF(S38>0,LN(Data!J55),0)","v":0.84156718567821809},110.25,8.8364554496212904,1.3753275293123977E-3,-0.52735496900457746,{"$f":"IF(Data!B55>'B&R'!D$9,1,0)","v":1},0.68386499501555564,null,null,null,null,null,null,10.5,0.84156718567821809]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B56>=D$9,Data!B56-D$9,0)","v":11.5},{"$f":"IF(S39>0,LN(Data!J56),0)","v":0.80200158547202538},132.25,9.2230182329282915,1.9353819059120892E-3,-0.62558065818453623,{"$f":"IF(Data!B56>'B&R'!D$9,1,0)","v":1},0.65733574951926155,null,null,null,{"$f":"TRUNC(100*E12)/100","v":3.21},null,null,11.5,0.80200158547202538]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B57>=D$9,Data!B57-D$9,0)","v":12.5},{"$f":"IF(S40>0,LN(Data!J57),0)","v":0.75141608868391929},156.25,9.3927011085489909,3.8341408019594188E-3,-0.88050941316313291,{"$f":"IF(Data!B57>'B&R'!D$9,1,0)","v":1},0.62491111613490347,null,null,null,{"$f":"X39","v":3.21},null,null,12.5,0.75141608868391929]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B58>=D$9,Data!B58-D$9,0)","v":13.5},{"$f":"IF(S41>0,LN(Data!J58),0)","v":0.71294980785612394},182.25,9.6248224060576728,4.5871750398102555E-3,-0.96310276717495091,{"$f":"IF(Data!B58>'B&R'!D$9,1,0)","v":1},0.60132956458264342,null,null,null,{"$f":"CONCATENATE(\" T = \",X40,\" ft2/d\")","v":" T = 3.21 ft2/d"},null,null,13.5,0.71294980785612394]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B59>=D$9,Data!B59-D$9,0)","v":14.5},{"$f":"IF(S42>0,LN(Data!J59),0)","v":0.67803354274989591},210.25,9.83148636987349,4.8981688233254404E-3,-0.99521485368413176,{"$f":"IF(Data!B59>'B&R'!D$9,1,0)","v":1},0.5806957069744153,null,null,null,null,null,null,14.5,0.67803354274989591]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B60>=D$9,Data!B60-D$9,0)","v":15.5},{"$f":"IF(S43>0,LN(Data!J60),0)","v":0.64185388617239336},240.25,9.9487352356720979,5.4035058030773237E-3,-1.0452923825530436,{"$f":"IF(Data!B60>'B&R'!D$9,1,0)","v":1},0.5600618493661873,null,null,null,null,null,null,15.5,0.64185388617239336]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B61>=D$9,Data!B61-D$9,0)","v":16.5},{"$f":"IF(S44>0,LN(Data!J61),0)","v":0.60431596685332789},272.25,9.9712134530799101,6.1447457321892407E-3,-1.1146844244195018,{"$f":"IF(Data!B61>'B&R'!D$9,1,0)","v":1},0.53942799175795919,null,null,null,null,null,null,16.5,0.60431596685332789]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B62>=D$9,Data!B62-D$9,0)","v":17.5},{"$f":"IF(S45>0,LN(Data!J62),0)","v":0.5709795465857388},306.25,9.9921420652504285,6.2515613430268379E-3,-1.1243310977679819,{"$f":"IF(Data!B62>'B&R'!D$9,1,0)","v":1},0.52174182809376524,null,null,null,null,null,null,17.5,0.5709795465857388]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B63>=D$9,Data!B63-D$9,0)","v":22.5},{"$f":"IF(S46>0,LN(Data!J63),0)","v":0.4054651081081635},506.25,9.1229649324336783,6.6082410637393479E-3,-1.155960284182634,{"$f":"IF(Data!B63>'B&R'!D$9,1,0)","v":1},0.44215409160488495,null,null,null,null,null,null,22.5,0.4054651081081635]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B64>=D$9,Data!B64-D$9,0)","v":27.5},{"$f":"IF(S47>0,LN(Data!J64),0)","v":0.24686007793152565},756.25,6.7886521431169555,5.8684720258607949E-3,-1.0893375990335814,{"$f":"IF(Data!B64>'B&R'!D$9,1,0)","v":1},0.37730482483616873,null,null,null,null,null,null,27.5,0.24686007793152565]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B65>=D$9,Data!B65-D$9,0)","v":32.5},{"$f":"IF(S48>0,LN(Data!J65),0)","v":8.6177696241047722E-2},{"$f":"M48^2","v":1056.25},{"$f":"M48*N48","v":2.8007751278340511},5.475729004928178E-3,{"$f":"IF(M48>0,(N48-V$11-V$12*M48)/SQRT(V$14),0)","v":-1.0522548781247063},{"$f":"IF(Data!B65>'B&R'!D$9,1,0)","v":1},{"$f":"IF(S48=0,NA(),EXP(N48)/EXP(V$19))","v":0.32129863989954849},null,null,null,null,null,null,32.5,8.6177696241047722E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B66>=D$9,Data!B66-D$9,0)","v":37.5},{"$f":"IF(S49>0,LN(Data!J66),0)","v":-7.2570692834837289E-2},1406.25,-2.7214009813063984,4.8241904319474092E-3,-0.98767075829743989,{"$f":"IF(Data!B66>'B&R'!D$9,1,0)","v":1},0.27413553679502839,null,null,null,null,null,null,37.5,-7.2570692834837289E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B67>=D$9,Data!B67-D$9,0)","v":42.5},{"$f":"IF(S50>0,LN(Data!J67),0)","v":-0.17435338714478388},1806.25,-7.4100189536533145,6.3185343686948569E-5,-0.11303375377948448,{"$f":"IF(Data!B67>'B&R'!D$9,1,0)","v":1},0.24760629129873427,null,null,null,null,null,null,42.5,-0.17435338714478388]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B68>=D$9,Data!B68-D$9,0)","v":47.5},{"$f":"IF(S51>0,LN(Data!J68),0)","v":-0.34249030894677679},2256.25,-16.268289674971896,1.6372935025541787E-4,-0.18195468552834354,{"$f":"IF(Data!B68>'B&R'!D$9,1,0)","v":1},0.2092862700263122,null,null,null,null,null,null,47.5,-0.34249030894677679]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B69>=D$9,Data!B69-D$9,0)","v":52.5},{"$f":"IF(S52>0,LN(Data!J69),0)","v":-0.47803580094300624},2756.25,-25.096879549507829,2.2347250205081022E-4,0.21257491797613967,{"$f":"IF(Data!B69>'B&R'!D$9,1,0)","v":1},0.18275702453001808,null,null,null,null,null,null,52.5,-0.47803580094300624]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B70>=D$9,Data!B70-D$9,0)","v":57.5},{"$f":"IF(S53>0,LN(Data!J70),0)","v":-0.63487827243597006},3306.25,-36.505500665068276,4.5781838140558894E-4,0.30426120942391643,{"$f":"IF(Data!B70>'B&R'!D$9,1,0)","v":1},0.15622777903372606,null,null,null,null,null,null,57.5,-0.63487827243597006]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B71>=D$9,Data!B71-D$9,0)","v":62.5},{"$f":"IF(S54>0,LN(Data!J71),0)","v":-0.77652878949899762},3906.25,-48.533049343687352,1.8521265206990678E-3,0.61197728091078085,{"$f":"IF(Data!B71>'B&R'!D$9,1,0)","v":1},0.13559392142549798,null,null,null,null,null,null,62.5,-0.77652878949899762]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B72>=D$9,Data!B72-D$9,0)","v":72.5},{"$f":"IF(S55>0,LN(Data!J72),0)","v":-1.0788096613719451},5256.25,-78.213700449466018,4.5341098357974527E-3,0.95751589619203603,{"$f":"IF(Data!B72>'B&R'!D$9,1,0)","v":1},0.10022159409710582,null,null,null,null,null,null,72.5,-1.0788096613719451]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B73>=D$9,Data!B73-D$9,0)","v":82.5},{"$f":"IF(S56>0,LN(Data!J73),0)","v":-1.4271163556401434},6806.25,-117.73709934031183,2.0802206704262833E-3,0.64856674730707586,{"$f":"IF(Data!B73>'B&R'!D$9,1,0)","v":1},7.0744654656781814E-2,null,null,null,null,null,null,82.5,-1.4271163556401434]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B74>=D$9,Data!B74-D$9,0)","v":92.5},{"$f":"IF(S57>0,LN(Data!J74),0)","v":-1.7719568419319156},8556.25,-163.90600787870218,7.4798318815424199E-4,0.38890711875147821,{"$f":"IF(Data!B74>'B&R'!D$9,1,0)","v":1},5.0110797048551654E-2,null,null,null,null,null,null,92.5,-1.7719568419319156]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B75>=D$9,Data!B75-D$9,0)","v":0},{"$f":"IF(S58>0,LN(Data!J75),0)","v":0},0,0,0,0,{"$f":"IF(Data!B75>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B76>=D$9,Data!B76-D$9,0)","v":0},{"$f":"IF(S59>0,LN(Data!J76),0)","v":0},0,0,0,0,{"$f":"IF(Data!B76>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B77>=D$9,Data!B77-D$9,0)","v":0},{"$f":"IF(S60>0,LN(Data!J77),0)","v":0},0,0,0,0,{"$f":"IF(Data!B77>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B78>=D$9,Data!B78-D$9,0)","v":0},{"$f":"IF(S61>0,LN(Data!J78),0)","v":0},{"$f":"M61^2","v":0},{"$f":"M61*N61","v":0},0,{"$f":"IF(M61>0,(N61-V$11-V$12*M61)/SQRT(V$14),0)","v":0},{"$f":"IF(Data!B78>'B&R'!D$9,1,0)","v":0},{"$f":"IF(S61=0,NA(),EXP(N61)/EXP(V$19))","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B79>=D$9,Data!B79-D$9,0)","v":0},{"$f":"IF(S62>0,LN(Data!J79),0)","v":0},0,0,0,0,{"$f":"IF(Data!B79>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B80>=D$9,Data!B80-D$9,0)","v":0},{"$f":"IF(S63>0,LN(Data!J80),0)","v":0},0,0,0,0,{"$f":"IF(Data!B80>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B81>=D$9,Data!B81-D$9,0)","v":0},{"$f":"IF(S64>0,LN(Data!J81),0)","v":0},0,0,0,0,{"$f":"IF(Data!B81>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"C&J","index":4,"n_rows":66,"n_cols":26,"rows_kept":66,"cut":false,"hidden":true,"merged":[]}
["Cooper and Jacob (1946)"]
["Well Designation:",null,{"$f":"IF(Data!B1 > 0,Data!B1,\"\")","v":"YYY"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E10","v":15},{"$f":"E9","v":25},0]
["Date:",null,{"$f":"IF(Data!B2 > 0,Data!B2,\"\")","v":"date"},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"MAX(P9:Q58)","v":5.1446884125323935},null,null,null,null,null,{"$f":"W2","v":15},{"$f":"X2","v":25},{"$f":"J50","v":70}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"Q3","v":5.1446884125323935}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(T9:T66)+10","v":122.5}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Index","ti","Vi (meas)","Vi (calc)","SE",null,"Time","Qn/sn",null,"Index","Time","Qn/sn","A-Time"]
[null,"Enter early time cut-off for least-squares model fit"]
[null,null,"    Timecut (min):",null,25,"<-  Enter or change values here",null,null,null,null,null,null,null,1,{"$f":"IF(Data!L24>=E$9,Data!L24-E$10,0)","v":0},{"$f":"IF(O9>0,7.48*Data!M24*(Data!B24-Data!B23)/1440,0)","v":0},{"$f":"IF(O9>0,7.48*(4*PI()*(E$16/1440)*Data!N24)*(Data!B24-Data!B23)/LN(0.56146/((Data!P24^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O9))),0)","v":0},{"$f":"(P9-Q9)^2","v":0},null,{"$f":"Data!L24","v":0.75},{"$f":"Data!M24/Data!N24","v":11.973611492689866},null,0,{"$f":"2+(X$5-2)*W9/50","v":2},{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X9/1440)))","v":31.254320999686197},{"$f":"X9+E$10","v":17}]
[null,"  Time Adjustment (min):",null,null,15,null,null,null,null,null,null,null,null,2,{"$f":"IF(Data!L25>=E$9,Data!L25-E$10,0)","v":0},{"$f":"IF(O10>0,P9+7.48*Data!M25*(Data!B25-Data!B24)/1440,0)","v":0},{"$f":"IF(O10>0,Q9+7.48*(4*PI()*(E$16/1440)*Data!N25)*(Data!B25-Data!B24)/LN(0.56146/((Data!P25^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O10))),0)","v":0},{"$f":"(P10-Q10)^2","v":0},null,{"$f":"Data!L25","v":1.25},{"$f":"Data!M25/Data!N25","v":13.533601620904927},null,1,{"$f":"2+(X$5-2)*W10/50","v":4.41},{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X10/1440)))","v":18.909554229454059},{"$f":"X10+E$10","v":19.41}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(Data!L26>=E$9,Data!L26-E$10,0)","v":0},{"$f":"IF(O11>0,P10+7.48*Data!M26*(Data!B26-Data!B25)/1440,0)","v":0},{"$f":"IF(O11>0,Q10+7.48*(4*PI()*(E$16/1440)*Data!N26)*(Data!B26-Data!B25)/LN(0.56146/((Data!P26^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O11))),0)","v":0},0,null,{"$f":"Data!L26","v":4},{"$f":"Data!M26/Data!N26","v":8.5659598201686915},null,2,6.82,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X11/1440)))","v":15.527894692231117},21.82]
[null,"Trial Sn:",null,null,"d","<-- Enter d for default or enter Sn value",null,null,null,null,null,null,null,4,{"$f":"IF(Data!L27>=E$9,Data!L27-E$10,0)","v":0},{"$f":"IF(O12>0,P11+7.48*Data!M27*(Data!B27-Data!B26)/1440,0)","v":0},{"$f":"IF(O12>0,Q11+7.48*(4*PI()*(E$16/1440)*Data!N27)*(Data!B27-Data!B26)/LN(0.56146/((Data!P27^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O12))),0)","v":0},0,null,{"$f":"Data!L27","v":7},{"$f":"Data!M27/Data!N27","v":9.2309410544891151},null,3,9.23,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X12/1440)))","v":13.813364816573809},24.23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(Data!L28>=E$9,Data!L28-E$10,0)","v":0},{"$f":"IF(O13>0,P12+7.48*Data!M28*(Data!B28-Data!B27)/1440,0)","v":0},{"$f":"IF(O13>0,Q12+7.48*(4*PI()*(E$16/1440)*Data!N28)*(Data!B28-Data!B27)/LN(0.56146/((Data!P28^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O13))),0)","v":0},0,null,{"$f":"Data!L28","v":8},{"$f":"Data!M28/Data!N28","v":9.6007069336388948},null,4,11.64,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X13/1440)))","v":12.735312063013769},26.64]
[null,"Root-Mean-Square Error:",null,null,{"$f":"SQRT(SUM(R9:R58))","v":0.84132536136977432},"<-- Minimize this using \"Solver\"",null,null,null,null,null,null,null,6,{"$f":"IF(Data!L29>=E$9,Data!L29-E$10,0)","v":0},{"$f":"IF(O14>0,P13+7.48*Data!M29*(Data!B29-Data!B28)/1440,0)","v":0},{"$f":"IF(O14>0,Q13+7.48*(4*PI()*(E$16/1440)*Data!N29)*(Data!B29-Data!B28)/LN(0.56146/((Data!P29^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O14))),0)","v":0},0,null,{"$f":"Data!L29","v":9},{"$f":"Data!M29/Data!N29","v":6.4695788553100249},null,5,14.05,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X14/1440)))","v":11.977104799953626},29.05]
[null,null,null,null,{"$f":"IF(E12=\"d\",0.025*SQRT(E16),E12)","v":4.339130738138023E-2},"<-- Working Sn",null,null,null,null,null,null,null,7,{"$f":"IF(Data!L30>=E$9,Data!L30-E$10,0)","v":0},{"$f":"IF(O15>0,P14+7.48*Data!M30*(Data!B30-Data!B29)/1440,0)","v":0},{"$f":"IF(O15>0,Q14+7.48*(4*PI()*(E$16/1440)*Data!N30)*(Data!B30-Data!B29)/LN(0.56146/((Data!P30^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O15))),0)","v":0},0,null,{"$f":"Data!L30","v":10},{"$f":"Data!M30/Data!N30","v":6.2269696482362766},null,6,16.46,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X15/1440)))","v":11.405818849670345},31.46]
[null,"Trial Tn (ft2/d):",null,null,3.0124888900246756,"<-- By changing Tn through \"Solver\"",null,null,null,null,null,null,null,8,{"$f":"IF(Data!L31>=E$9,Data!L31-E$10,0)","v":0},{"$f":"IF(O16>0,P15+7.48*Data!M31*(Data!B31-Data!B30)/1440,0)","v":0},{"$f":"IF(O16>0,Q15+7.48*(4*PI()*(E$16/1440)*Data!N31)*(Data!B31-Data!B30)/LN(0.56146/((Data!P31^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O16))),0)","v":0},0,null,{"$f":"Data!L31","v":11},{"$f":"Data!M31/Data!N31","v":5.9546531913164165},null,7,18.87,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X16/1440)))","v":10.954820659631984},33.870000000000005]
[null,null,null,null,null,null,"Add constraint Tn > 0.00001",null,null,null,null,null,null,9,{"$f":"IF(Data!L32>=E$9,Data!L32-E$10,0)","v":0},{"$f":"IF(O17>0,P16+7.48*Data!M32*(Data!B32-Data!B31)/1440,0)","v":0},{"$f":"IF(O17>0,Q16+7.48*(4*PI()*(E$16/1440)*Data!N32)*(Data!B32-Data!B31)/LN(0.56146/((Data!P32^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O17))),0)","v":0},0,null,{"$f":"Data!L32","v":12},{"$f":"Data!M32/Data!N32","v":8.9705212315783331},null,8,21.28,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X17/1440)))","v":10.586598199332338},36.28]
[null,"Model Result:",null,"Tn (ft2/d) =",{"$f":"E16","v":3.0124888900246756},null,null,null,null,null,null,null,null,10,{"$f":"IF(Data!L33>=E$9,Data!L33-E$10,0)","v":0},{"$f":"IF(O18>0,P17+7.48*Data!M33*(Data!B33-Data!B32)/1440,0)","v":0},{"$f":"IF(O18>0,Q17+7.48*(4*PI()*(E$16/1440)*Data!N33)*(Data!B33-Data!B32)/LN(0.56146/((Data!P33^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O18))),0)","v":0},0,null,{"$f":"Data!L33","v":13},{"$f":"Data!M33/Data!N33","v":4.86296677290873},null,9,23.69,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X18/1440)))","v":10.278222901750834},38.69]
[null,null,null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"IF(Data!L34>=E$9,Data!L34-E$10,0)","v":0},{"$f":"IF(O19>0,P18+7.48*Data!M34*(Data!B34-Data!B33)/1440,0)","v":0},{"$f":"IF(O19>0,Q18+7.48*(4*PI()*(E$16/1440)*Data!N34)*(Data!B34-Data!B33)/LN(0.56146/((Data!P34^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O19))),0)","v":0},0,null,{"$f":"Data!L34","v":14},{"$f":"Data!M34/Data!N34","v":7.0006719609987895},null,10,26.1,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X19/1440)))","v":10.014790609640558},41.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,12,{"$f":"IF(Data!L35>=E$9,Data!L35-E$10,0)","v":0},{"$f":"IF(O20>0,P19+7.48*Data!M35*(Data!B35-Data!B34)/1440,0)","v":0},{"$f":"IF(O20>0,Q19+7.48*(4*PI()*(E$16/1440)*Data!N35)*(Data!B35-Data!B34)/LN(0.56146/((Data!P35^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O20))),0)","v":0},0,null,{"$f":"Data!L35","v":15},{"$f":"Data!M35/Data!N35","v":6.7075403764257606},null,11,28.51,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X20/1440)))","v":9.7861386347548684},43.510000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,13,{"$f":"IF(Data!L36>=E$9,Data!L36-E$10,0)","v":0},{"$f":"IF(O21>0,P20+7.48*Data!M36*(Data!B36-Data!B35)/1440,0)","v":0},{"$f":"IF(O21>0,Q20+7.48*(4*PI()*(E$16/1440)*Data!N36)*(Data!B36-Data!B35)/LN(0.56146/((Data!P36^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O21))),0)","v":0},0,null,{"$f":"Data!L36","v":16},{"$f":"Data!M36/Data!N36","v":8.0158792960022609},null,12,30.92,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X21/1440)))","v":9.5850670329080643},45.92]
[null,null,null,null,null,null,null,null,null,null,null,null,null,14,{"$f":"IF(Data!L37>=E$9,Data!L37-E$10,0)","v":0},{"$f":"IF(O22>0,P21+7.48*Data!M37*(Data!B37-Data!B36)/1440,0)","v":0},{"$f":"IF(O22>0,Q21+7.48*(4*PI()*(E$16/1440)*Data!N37)*(Data!B37-Data!B36)/LN(0.56146/((Data!P37^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O22))),0)","v":0},0,null,{"$f":"Data!L37","v":17},{"$f":"Data!M37/Data!N37","v":7.7438712592280385},null,13,33.33,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X22/1440)))","v":9.4063125454128862},48.33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,15,{"$f":"IF(Data!L38>=E$9,Data!L38-E$10,0)","v":0},{"$f":"IF(O23>0,P22+7.48*Data!M38*(Data!B38-Data!B37)/1440,0)","v":0},{"$f":"IF(O23>0,Q22+7.48*(4*PI()*(E$16/1440)*Data!N38)*(Data!B38-Data!B37)/LN(0.56146/((Data!P38^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O23))),0)","v":0},0,null,{"$f":"Data!L38","v":18},{"$f":"Data!M38/Data!N38","v":6.8385470244021631},null,14,35.74,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X23/1440)))","v":9.2459258228435441},50.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,16,{"$f":"IF(Data!L39>=E$9,Data!L39-E$10,0)","v":0},{"$f":"IF(O24>0,P23+7.48*Data!M39*(Data!B39-Data!B38)/1440,0)","v":0},{"$f":"IF(O24>0,Q23+7.48*(4*PI()*(E$16/1440)*Data!N39)*(Data!B39-Data!B38)/LN(0.56146/((Data!P39^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O24))),0)","v":0},0,null,{"$f":"Data!L39","v":19},{"$f":"Data!M39/Data!N39","v":3.5118716915696568},null,15,38.15,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X24/1440)))","v":9.1008771421079633},53.15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"IF(Data!L40>=E$9,Data!L40-E$10,0)","v":0},{"$f":"IF(O25>0,P24+7.48*Data!M40*(Data!B40-Data!B39)/1440,0)","v":0},{"$f":"IF(O25>0,Q24+7.48*(4*PI()*(E$16/1440)*Data!N40)*(Data!B40-Data!B39)/LN(0.56146/((Data!P40^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O25))),0)","v":0},0,null,{"$f":"Data!L40","v":20},{"$f":"Data!M40/Data!N40","v":4.8029301460813292},null,16,40.56,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X25/1440)))","v":8.9687977494527296},55.56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,18,{"$f":"IF(Data!L41>=E$9,Data!L41-E$10,0)","v":0},{"$f":"IF(O26>0,P25+7.48*Data!M41*(Data!B41-Data!B40)/1440,0)","v":0},{"$f":"IF(O26>0,Q25+7.48*(4*PI()*(E$16/1440)*Data!N41)*(Data!B41-Data!B40)/LN(0.56146/((Data!P41^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O26))),0)","v":0},0,null,{"$f":"Data!L41","v":21},{"$f":"Data!M41/Data!N41","v":6.8071220999356834},null,17,42.97,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X26/1440)))","v":8.84780494046041},57.97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,19,{"$f":"IF(Data!L42>=E$9,Data!L42-E$10,0)","v":0},{"$f":"IF(O27>0,P26+7.48*Data!M42*(Data!B42-Data!B41)/1440,0)","v":0},{"$f":"IF(O27>0,Q26+7.48*(4*PI()*(E$16/1440)*Data!N42)*(Data!B42-Data!B41)/LN(0.56146/((Data!P42^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O27))),0)","v":0},0,null,{"$f":"Data!L42","v":22},{"$f":"Data!M42/Data!N42","v":7.0307953343252327},null,18,45.38,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X27/1440)))","v":8.7363806173772751},60.38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,20,{"$f":"IF(Data!L43>=E$9,Data!L43-E$10,0)","v":0},{"$f":"IF(O28>0,P27+7.48*Data!M43*(Data!B43-Data!B42)/1440,0)","v":0},{"$f":"IF(O28>0,Q27+7.48*(4*PI()*(E$16/1440)*Data!N43)*(Data!B43-Data!B42)/LN(0.56146/((Data!P43^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O28))),0)","v":0},0,null,{"$f":"Data!L43","v":23},{"$f":"Data!M43/Data!N43","v":10.634278136655764},null,19,47.79,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X28/1440)))","v":8.6332850154959822},62.79]
[null,null,null,null,null,null,null,null,null,null,null,null,null,21,{"$f":"IF(Data!L44>=E$9,Data!L44-E$10,0)","v":0},{"$f":"IF(O29>0,P28+7.48*Data!M44*(Data!B44-Data!B43)/1440,0)","v":0},{"$f":"IF(O29>0,Q28+7.48*(4*PI()*(E$16/1440)*Data!N44)*(Data!B44-Data!B43)/LN(0.56146/((Data!P44^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O29))),0)","v":0},0,null,{"$f":"Data!L44","v":24},{"$f":"Data!M44/Data!N44","v":14.693856436126898},null,20,50.2,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X29/1440)))","v":8.5374941605072348},65.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,22,{"$f":"IF(Data!L45>=E$9,Data!L45-E$10,0)","v":10},{"$f":"IF(O30>0,P29+7.48*Data!M45*(Data!B45-Data!B44)/1440,0)","v":0.24249994307568928},{"$f":"IF(O30>0,Q29+7.48*(4*PI()*(E$16/1440)*Data!N45)*(Data!B45-Data!B44)/LN(0.56146/((Data!P45^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O30))),0)","v":0.27641795222869037},1.1504313449030652E-3,null,{"$f":"Data!L45","v":25},{"$f":"Data!M45/Data!N45","v":11.774144015111943},null,21,52.61,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X30/1440)))","v":8.4481537067144217},67.61]
[null,null,null,null,null,null,null,null,null,null,null,null,null,23,{"$f":"IF(Data!L46>=E$9,Data!L46-E$10,0)","v":11.05},{"$f":"IF(O31>0,P30+7.48*Data!M46*(Data!B46-Data!B45)/1440,0)","v":0.46984363970913989},{"$f":"IF(O31>0,Q30+7.48*(4*PI()*(E$16/1440)*Data!N46)*(Data!B46-Data!B45)/LN(0.56146/((Data!P46^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O31))),0)","v":0.55638073140359823},7.48866823893509E-3,null,{"$f":"Data!L46","v":26.05},{"$f":"Data!M46/Data!N46","v":10.525902105861531},null,22,55.02,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X31/1440)))","v":8.3645443135731288},70.02000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,24,{"$f":"IF(Data!L47>=E$9,Data!L47-E$10,0)","v":12.05},{"$f":"IF(O32>0,P31+7.48*Data!M47*(Data!B47-Data!B46)/1440,0)","v":0.7274998292270678},{"$f":"IF(O32>0,Q31+7.48*(4*PI()*(E$16/1440)*Data!N47)*(Data!B47-Data!B46)/LN(0.56146/((Data!P47^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O32))),0)","v":0.76795441710417389},1.6365736803064996E-3,null,{"$f":"Data!L47","v":27.05},{"$f":"Data!M47/Data!N47","v":15.330632385617472},null,23,57.43,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X32/1440)))","v":8.2860552982489875},72.430000000000007]
[null,null,null,null,null,null,null,null,null,null,null,null,null,25,{"$f":"IF(Data!L48>=E$9,Data!L48-E$10,0)","v":13},{"$f":"IF(O33>0,P32+7.48*Data!M48*(Data!B48-Data!B47)/1440,0)","v":0.93968727941831198},{"$f":"IF(O33>0,Q32+7.48*(4*PI()*(E$16/1440)*Data!N48)*(Data!B48-Data!B47)/LN(0.56146/((Data!P48^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O33))),0)","v":0.98576933075861484},2.1235554557303082E-3,null,{"$f":"Data!L48","v":28},{"$f":"Data!M48/Data!N48","v":11.961616659570154},null,24,59.84,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X33/1440)))","v":8.2121643220553278},74.84]
[null,null,null,null,null,null,null,null,null,null,null,null,null,26,{"$f":"IF(Data!L49>=E$9,Data!L49-E$10,0)","v":14},{"$f":"IF(O34>0,P33+7.48*Data!M49*(Data!B49-Data!B48)/1440,0)","v":1.1215622367250682},{"$f":"IF(O34>0,Q33+7.48*(4*PI()*(E$16/1440)*Data!N49)*(Data!B49-Data!B48)/LN(0.56146/((Data!P49^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O34))),0)","v":1.1872602011470239},4.3162225291885625E-3,null,{"$f":"Data!L49","v":29},{"$f":"Data!M49/Data!N49","v":10.823295445111913},null,25,62.25,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X34/1440)))","v":8.1424215416929151},77.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,27,{"$f":"IF(Data!L50>=E$9,Data!L50-E$10,0)","v":15},{"$f":"IF(O35>0,P34+7.48*Data!M50*(Data!B50-Data!B49)/1440,0)","v":1.3337496869163017},{"$f":"IF(O35>0,Q34+7.48*(4*PI()*(E$16/1440)*Data!N50)*(Data!B50-Data!B49)/LN(0.56146/((Data!P50^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O35))),0)","v":1.3734705792985651},1.5777492916433501E-3,null,{"$f":"Data!L50","v":30},{"$f":"Data!M50/Data!N50","v":13.37116886822586},null,26,64.66,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X35/1440)))","v":8.0764371090794338},79.66]
[null,null,null,null,null,null,null,null,null,null,null,null,null,28,{"$f":"IF(Data!L51>=E$9,Data!L51-E$10,0)","v":16},{"$f":"IF(O36>0,P35+7.48*Data!M51*(Data!B51-Data!B50)/1440,0)","v":1.5156246442230794},{"$f":"IF(O36>0,Q35+7.48*(4*PI()*(E$16/1440)*Data!N51)*(Data!B51-Data!B50)/LN(0.56146/((Data!P51^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O36))),0)","v":1.5467665201555314},9.698164365922325E-4,null,{"$f":"Data!L51","v":31},{"$f":"Data!M51/Data!N51","v":12.073572677565931},null,27,67.069999999999993,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X36/1440)))","v":8.0138712137558628},82.07]
[null,null,null,null,null,null,null,null,null,null,null,null,null,29,{"$f":"IF(Data!L52>=E$9,Data!L52-E$10,0)","v":17},{"$f":"IF(O37>0,P36+7.48*Data!M52*(Data!B52-Data!B51)/1440,0)","v":1.6974996015298465},{"$f":"IF(O37>0,Q36+7.48*(4*PI()*(E$16/1440)*Data!N52)*(Data!B52-Data!B51)/LN(0.56146/((Data!P52^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O37))),0)","v":1.7084194991881205},1.1924416486717926E-4,null,{"$f":"Data!L52","v":32},{"$f":"Data!M52/Data!N52","v":12.709023871121278},null,28,69.48,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X37/1440)))","v":7.9544260778285985},84.48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,30,{"$f":"IF(Data!L53>=E$9,Data!L53-E$10,0)","v":18},{"$f":"IF(O38>0,P37+7.48*Data!M53*(Data!B53-Data!B52)/1440,0)","v":1.8945308052788521},{"$f":"IF(O38>0,Q37+7.48*(4*PI()*(E$16/1440)*Data!N53)*(Data!B53-Data!B52)/LN(0.56146/((Data!P53^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O38))),0)","v":1.8589962449102582},1.262704980589246E-3,null,{"$f":"Data!L53","v":33},{"$f":"Data!M53/Data!N53","v":14.533004148921686},null,29,71.89,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X38/1440)))","v":7.8978394660390157},86.89]
[null,null,null,null,null,null,null,null,null,null,null,null,null,31,{"$f":"IF(Data!L54>=E$9,Data!L54-E$10,0)","v":19},{"$f":"IF(O39>0,P38+7.48*Data!M54*(Data!B54-Data!B53)/1440,0)","v":2.0460932697011631},{"$f":"IF(O39>0,Q38+7.48*(4*PI()*(E$16/1440)*Data!N54)*(Data!B54-Data!B53)/LN(0.56146/((Data!P54^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O39))),0)","v":2.0001228126958521},2.1132829172771468E-3,null,{"$f":"Data!L54","v":34},{"$f":"Data!M54/Data!N54","v":11.741569673018232},null,30,74.3,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X39/1440)))","v":7.8438793829167102},89.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,32,{"$f":"IF(Data!L55>=E$9,Data!L55-E$10,0)","v":20},{"$f":"IF(O40>0,P39+7.48*Data!M55*(Data!B55-Data!B54)/1440,0)","v":2.1673432412390077},{"$f":"IF(O40>0,Q39+7.48*(4*PI()*(E$16/1440)*Data!N55)*(Data!B55-Data!B54)/LN(0.56146/((Data!P55^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O40))),0)","v":2.1330334087776603},1.1771646035257232E-3,null,{"$f":"Data!L55","v":35},{"$f":"Data!M55/Data!N55","v":9.8283117936671189},null,31,76.709999999999994,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X40/1440)))","v":7.7923397083370789},91.71]
[null,null,null,null,null,null,null,null,null,null,null,null,null,33,{"$f":"IF(Data!L56>=E$9,Data!L56-E$10,0)","v":21},{"$f":"IF(O41>0,P40+7.48*Data!M56*(Data!B56-Data!B55)/1440,0)","v":2.3340619521035468},{"$f":"IF(O41>0,Q40+7.48*(4*PI()*(E$16/1440)*Data!N56)*(Data!B56-Data!B55)/LN(0.56146/((Data!P56^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O41))),0)","v":2.2586041870084204},5.6938743131512868E-3,null,{"$f":"Data!L56","v":36},{"$f":"Data!M56/Data!N56","v":14.107947560964714},null,32,79.12,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X41/1440)))","v":7.7430365810794886},94.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,34,{"$f":"IF(Data!L57>=E$9,Data!L57-E$10,0)","v":22},{"$f":"IF(O42>0,P41+7.48*Data!M57*(Data!B57-Data!B56)/1440,0)","v":2.4856244165258579},{"$f":"IF(O42>0,Q41+7.48*(4*PI()*(E$16/1440)*Data!N57)*(Data!B57-Data!B56)/LN(0.56146/((Data!P57^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O42))),0)","v":2.3771079627228069},1.1775820745989696E-2,null,{"$f":"Data!L57","v":37},{"$f":"Data!M57/Data!N57","v":13.415080752850731},null,33,81.53,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X42/1440)))","v":7.6958053832436413},96.53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,35,{"$f":"IF(Data!L58>=E$9,Data!L58-E$10,0)","v":23},{"$f":"IF(O43>0,P42+7.48*Data!M58*(Data!B58-Data!B57)/1440,0)","v":2.6068743880637024},{"$f":"IF(O43>0,Q42+7.48*(4*PI()*(E$16/1440)*Data!N58)*(Data!B58-Data!B57)/LN(0.56146/((Data!P58^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O43))),0)","v":2.4890568919016576},1.3880962401893451E-2,null,{"$f":"Data!L58","v":38},{"$f":"Data!M58/Data!N58","v":11.222231014403572},null,34,83.94,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X43/1440)))","v":7.6504982108258046},98.94]
[null,null,null,null,null,null,null,null,null,null,null,null,null,36,{"$f":"IF(Data!L59>=E$9,Data!L59-E$10,0)","v":24},{"$f":"IF(O44>0,P43+7.48*Data!M59*(Data!B59-Data!B58)/1440,0)","v":2.6978118667170912},{"$f":"IF(O44>0,Q43+7.48*(4*PI()*(E$16/1440)*Data!N59)*(Data!B59-Data!B58)/LN(0.56146/((Data!P59^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O44))),0)","v":2.5957266303626061},1.0421395481551082E-2,null,{"$f":"Data!L59","v":39},{"$f":"Data!M59/Data!N59","v":8.7315114127035436},null,35,86.35,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X44/1440)))","v":7.6069817403208217},101.35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,37,{"$f":"IF(Data!L60>=E$9,Data!L60-E$10,0)","v":25},{"$f":"IF(O45>0,P44+7.48*Data!M60*(Data!B60-Data!B59)/1440,0)","v":2.8190618382549357},{"$f":"IF(O45>0,Q44+7.48*(4*PI()*(E$16/1440)*Data!N60)*(Data!B60-Data!B59)/LN(0.56146/((Data!P60^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O45))),0)","v":2.6975476742563274},1.4765692052280691E-2,null,{"$f":"Data!L60","v":40},{"$f":"Data!M60/Data!N60","v":12.063173390159911},null,36,88.76,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X45/1440)))","v":7.5651354199803844},103.76]
[null,null,null,null,null,null,null,null,null,null,null,null,null,38,{"$f":"IF(Data!L61>=E$9,Data!L61-E$10,0)","v":26},{"$f":"IF(O46>0,P45+7.48*Data!M61*(Data!B61-Data!B60)/1440,0)","v":2.9251555633505526},{"$f":"IF(O46>0,Q45+7.48*(4*PI()*(E$16/1440)*Data!N61)*(Data!B61-Data!B60)/LN(0.56146/((Data!P61^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O46))),0)","v":2.7946659772803084},1.7027532072783666E-2,null,{"$f":"Data!L61","v":41},{"$f":"Data!M61/Data!N61","v":10.951453322367303},null,37,91.17,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X46/1440)))","v":7.5248499288123787},106.17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,39,{"$f":"IF(Data!L62>=E$9,Data!L62-E$10,0)","v":27},{"$f":"IF(O47>0,P46+7.48*Data!M62*(Data!B62-Data!B61)/1440,0)","v":3.0160930420039307},{"$f":"IF(O47>0,Q46+7.48*(4*PI()*(E$16/1440)*Data!N62)*(Data!B62-Data!B61)/LN(0.56146/((Data!P62^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O47))),0)","v":2.8874719272073026},1.6543391171527377E-2,null,{"$f":"Data!L62","v":42},{"$f":"Data!M62/Data!N62","v":9.7259335458158418},null,38,93.58,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X47/1440)))","v":7.4860258576280438},108.58]
[null,null,null,null,null,null,null,null,null,null,null,null,null,40,{"$f":"IF(Data!L63>=E$9,Data!L63-E$10,0)","v":30},{"$f":"IF(O48>0,P47+7.48*Data!M63*(Data!B63-Data!B62)/1440,0)","v":3.4101554495019419},{"$f":"IF(O48>0,Q47+7.48*(4*PI()*(E$16/1440)*Data!N63)*(Data!B63-Data!B62)/LN(0.56146/((Data!P63^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O48))),0)","v":3.2976347512388799},1.2660907537607041E-2,null,{"$f":"Data!L63","v":45},{"$f":"Data!M63/Data!N63","v":9.2797898051830128},null,39,95.99,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X48/1440)))","v":7.4485725752207301},110.99]
[null,null,null,null,null,null,null,null,null,"Height",null,null,null,41,{"$f":"IF(Data!L64>=E$9,Data!L64-E$10,0)","v":35},{"$f":"IF(O49>0,P48+7.48*Data!M64*(Data!B64-Data!B63)/1440,0)","v":3.7132803783465533},{"$f":"IF(O49>0,Q48+7.48*(4*PI()*(E$16/1440)*Data!N64)*(Data!B64-Data!B63)/LN(0.56146/((Data!P64^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O49))),0)","v":3.6331399730967409},6.4224845536041712E-3,null,{"$f":"Data!L64","v":50},{"$f":"Data!M64/Data!N64","v":8.3964893920717305},null,40,98.4,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X49/1440)))","v":7.4124072496727402},113.4]
[null,null,null,null,null,null,null,null,null,70,null,null,null,42,{"$f":"IF(Data!L65>=E$9,Data!L65-E$10,0)","v":40},{"$f":"IF(O50>0,P49+7.48*Data!M65*(Data!B65-Data!B64)/1440,0)","v":4.0164053071911754},{"$f":"IF(O50>0,Q49+7.48*(4*PI()*(E$16/1440)*Data!N65)*(Data!B65-Data!B64)/LN(0.56146/((Data!P65^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O50))),0)","v":3.9100856276522444},1.1303874257260973E-2,null,{"$f":"Data!L65","v":55},{"$f":"Data!M65/Data!N65","v":9.8490466286752234},null,41,100.81,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X50/1440)))","v":7.3774540002672637},115.81]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43,{"$f":"IF(Data!L66>=E$9,Data!L66-E$10,0)","v":45},{"$f":"IF(O51>0,P50+7.48*Data!M66*(Data!B66-Data!B65)/1440,0)","v":4.2589052502668645},{"$f":"IF(O51>0,Q50+7.48*(4*PI()*(E$16/1440)*Data!N66)*(Data!B66-Data!B65)/LN(0.56146/((Data!P66^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O51))),0)","v":4.1397034791760676},1.4209062231182739E-2,null,{"$f":"Data!L66","v":60},{"$f":"Data!M66/Data!N66","v":9.2444516871126634},null,42,103.22,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X51/1440)))","v":7.3436431598544498},118.22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,44,{"$f":"IF(Data!L67>=E$9,Data!L67-E$10,0)","v":50},{"$f":"IF(O52>0,P51+7.48*Data!M67*(Data!B67-Data!B66)/1440,0)","v":4.3801552218047197},{"$f":"IF(O52>0,Q51+7.48*(4*PI()*(E$16/1440)*Data!N67)*(Data!B67-Data!B66)/LN(0.56146/((Data!P67^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O52))),0)","v":4.3361181721769144},1.9392617399217871E-3,null,{"$f":"Data!L67","v":65},{"$f":"Data!M67/Data!N67","v":5.2750826011212562},null,43,105.63,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X52/1440)))","v":7.3109106310292669},120.63]
[null,null,null,null,null,null,null,null,null,null,null,null,null,45,{"$f":"IF(Data!L68>=E$9,Data!L68-E$10,0)","v":55},{"$f":"IF(O53>0,P52+7.48*Data!M68*(Data!B68-Data!B67)/1440,0)","v":3.7739053641154858},{"$f":"IF(O53>0,Q52+7.48*(4*PI()*(E$16/1440)*Data!N68)*(Data!B68-Data!B67)/LN(0.56146/((Data!P68^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O53))),0)","v":4.5044971964780514},0.53376442551489101,null,{"$f":"Data!L68","v":70},{"$f":"Data!M68/Data!N68","v":-30.119020012851482},null,44,108.04,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X53/1440)))","v":7.2791973223101181},123.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,46,{"$f":"IF(Data!L69>=E$9,Data!L69-E$10,0)","v":60},{"$f":"IF(O54>0,P53+7.48*Data!M69*(Data!B69-Data!B68)/1440,0)","v":4.6832801506493311},{"$f":"IF(O54>0,Q53+7.48*(4*PI()*(E$16/1440)*Data!N69)*(Data!B69-Data!B68)/LN(0.56146/((Data!P69^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O54))),0)","v":4.6462517084911763},1.3711055286598169E-3,null,{"$f":"Data!L69","v":75},{"$f":"Data!M69/Data!N69","v":52.651670323217481},null,45,110.45,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X54/1440)))","v":7.2484486528043757},125.45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,47,{"$f":"IF(Data!L70>=E$9,Data!L70-E$10,0)","v":65},{"$f":"IF(O55>0,P54+7.48*Data!M70*(Data!B70-Data!B69)/1440,0)","v":4.8196863686294034},{"$f":"IF(O55>0,Q54+7.48*(4*PI()*(E$16/1440)*Data!N70)*(Data!B70-Data!B69)/LN(0.56146/((Data!P70^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O55))),0)","v":4.7667306416409394},2.8043090208767301E-3,null,{"$f":"Data!L70","v":80},{"$f":"Data!M70/Data!N70","v":9.1339201995491823},null,46,112.86,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X55/1440)))","v":7.2186141157200865},127.86]
[null,null,null,null,null,null,null,null,null,null,null,null,null,48,{"$f":"IF(Data!L71>=E$9,Data!L71-E$10,0)","v":70},{"$f":"IF(O56>0,P55+7.48*Data!M71*(Data!B71-Data!B70)/1440,0)","v":4.819686368629414},{"$f":"IF(O56>0,Q55+7.48*(4*PI()*(E$16/1440)*Data!N71)*(Data!B71-Data!B70)/LN(0.56146/((Data!P71^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O56))),0)","v":4.8688347612906187},2.4155645011799533E-3,null,{"$f":"Data!L71","v":85},{"$f":"Data!M71/Data!N71","v":8.3765956720793707E-13},null,47,115.27,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X56/1440)))","v":7.1896468926179598},130.26999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,49,{"$f":"IF(Data!L72>=E$9,Data!L72-E$10,0)","v":77.5},{"$f":"IF(O57>0,P56+7.48*Data!M72*(Data!B72-Data!B71)/1440,0)","v":4.9560925866094969},{"$f":"IF(O57>0,Q56+7.48*(4*PI()*(E$16/1440)*Data!N72)*(Data!B72-Data!B71)/LN(0.56146/((Data!P72^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O57))),0)","v":5.0304015164364548},5.5218170520277554E-3,null,{"$f":"Data!L72","v":92.5},{"$f":"Data!M72/Data!N72","v":6.5650051434265144},null,48,117.68,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X57/1440)))","v":7.1615035115611363},132.68]
[null,null,null,null,null,null,null,null,null,null,null,null,null,50,{"$f":"IF(Data!L73>=E$9,Data!L73-E$10,0)","v":87.5},{"$f":"IF(O58>0,P57+7.48*Data!M73*(Data!B73-Data!B72)/1440,0)","v":5.1076550510317977},{"$f":"IF(O58>0,Q57+7.48*(4*PI()*(E$16/1440)*Data!N73)*(Data!B73-Data!B72)/LN(0.56146/((Data!P73^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O58))),0)","v":5.1446884125323935},1.3714698640338093E-3,null,{"$f":"Data!L73","v":102.5},{"$f":"Data!M73/Data!N73","v":10.061310564637392},null,49,120.09,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X58/1440)))","v":7.1341435433648313},135.09]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L74","v":112.5},{"$f":"Data!M74/Data!N74","v":12.809766133515256},null,50,122.5,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X59/1440)))","v":7.1075293310151855},137.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L75","v":0},{"$f":"Data!M75/Data!N75","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L76","v":0},{"$f":"Data!M76/Data!N76","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L77","v":0},{"$f":"Data!M77/Data!N77","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L78","v":0},{"$f":"Data!M78/Data!N78","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L79","v":0},{"$f":"Data!M79/Data!N79","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L80","v":0},{"$f":"Data!M80/Data!N80","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L81","v":0},{"$f":"Data!M81/Data!N81","v":{"$error":"#N/A"}}]

{"sheet":"CB&P","index":5,"n_rows":108,"n_cols":25,"rows_kept":108,"cut":false,"hidden":true,"merged":[]}
["Cooper, Bredehoeft and Papadopulos (1967)"]
["Well Designation:",null,{"$f":"IF(Data!B1 > 0,Data!B1,\"\")","v":"YYY"},null,null,null,null,null,null,null,null,null,null,null,null,"e",9.9999999999999995E-7]
["Date:",null,{"$f":"IF(Data!B2 > 0,Data!B2,\"\")","v":"date"}]
[]
[null,"Enter early time cut-off for least-squares model fit"]
[null,null,"Timecut (min):",null,25,"<-  Enter or change values here",null,null,null,null,null,null,null,"Count","Time ","H/Ho","G (a,b,e)","SE",null,null,null,null,null,"Time ","H/Ho"]
[null,"Initial Drawdown sn (ft):",null,null,4.0999999999999996,null,null,null,null,null,null,null,null,null,"(min)",null,null,null,null,"Index","Time (min)","G( )",null,"(min)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O8>0,1,0)","v":0},{"$f":"IF(Data!B23>E$6,Data!B23-E$6,0)","v":0},{"$f":"IF(N8>0,Data!J23/'CB&P'!E$7,0)","v":0},{"$f":"IF(N8>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O8/Data!V$23^2,'CB&P'!Q$2),0)","v":0},{"$f":"N8*(P8-Q8)^2","v":0},null,0,{"$f":"EXP(LN(J$15)+(LN(J$16)-LN(J$15))*T8/100)","v":1},{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U8/Data!V$23^2,0.00001)","v":0.88368535103610923},null,{"$f":"IF(N8>0,O8,NA())","v":{"$error":"#N/A"}},{"$f":"IF(N8>0,P8,NA())","v":{"$error":"#N/A"}}]
[null,"Trial Sn:",null,null,"d","<-- Enter d for default",null,null,null,null,null,null,null,{"$f":"IF(O9>0,1,0)","v":0},{"$f":"IF(Data!B24>E$6,Data!B24-E$6,0)","v":0},{"$f":"IF(N9>0,Data!J24/'CB&P'!E$7,0)","v":0},{"$f":"IF(N9>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O9/Data!V$23^2,'CB&P'!Q$2),0)","v":0},{"$f":"N9*(P9-Q9)^2","v":0},null,1,1.032712419896443,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U9/Data!V$23^2,0.00001)","v":0.88150820737292934},null,{"$f":"IF(N9>0,O9,NA())","v":{"$error":"#N/A"}},{"$f":"IF(N9>0,P9,NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B25>E$6,Data!B25-E$6,0)","v":0},{"$f":"IF(N10>0,Data!J25/'CB&P'!E$7,0)","v":0},{"$f":"IF(N10>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O10/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,2,1.0664949422083674,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U10/Data!V$23^2,0.00001)","v":0.87928915388842577},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Root-Mean-Square Error:",null,null,{"$f":"SQRT(SUM(R8:R48))","v":0.12512421004236959},"<-- Minimize this using \"Solver\"",null,null,null,null,null,null,null,0,{"$f":"IF(Data!B26>E$6,Data!B26-E$6,0)","v":0},{"$f":"IF(N11>0,Data!J26/'CB&P'!E$7,0)","v":0},{"$f":"IF(N11>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O11/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,3,1.1013825725753201,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U11/Data!V$23^2,0.00001)","v":0.87702754502604408},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B27>E$6,Data!B27-E$6,0)","v":0},{"$f":"IF(N12>0,Data!J27/'CB&P'!E$7,0)","v":0},{"$f":"IF(N12>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O12/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,4,1.1374114617560287,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U12/Data!V$23^2,0.00001)","v":0.87472272527383532},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Trial Tn (ft2/d):",null,null,2.9848859780012722,"<-- By changing Tn through \"Solver\"",null,null,null,null,null,null,null,0,{"$f":"IF(Data!B28>E$6,Data!B28-E$6,0)","v":0},{"$f":"IF(N13>0,Data!J28/'CB&P'!E$7,0)","v":0},{"$f":"IF(N13>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O13/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,5,1.174618943088019,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U13/Data!V$23^2,0.00001)","v":0.87237402923226293},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"IF(E9=\"d\",0.025*SQRT(E13),E9)","v":4.3192056402199641E-2},"<-- Working Sn",null,"Add constraint Tn > 0.00001",null,null,null,null,null,0,{"$f":"IF(Data!B29>E$6,Data!B29-E$6,0)","v":0},{"$f":"IF(N14>0,Data!J29/'CB&P'!E$7,0)","v":0},{"$f":"IF(N14>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O14/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,6,1.2130435711726304,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U14/Data!V$23^2,0.00001)","v":0.86998078171963455},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Model Result:",null,"Tn (ft2/d) =",{"$f":"E13","v":2.9848859780012722},null,null,null,"Tmin",1,null,null,null,0,{"$f":"IF(Data!B30>E$6,Data!B30-E$6,0)","v":0},{"$f":"IF(N15>0,Data!J30/'CB&P'!E$7,0)","v":0},{"$f":"IF(N15>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O15/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,7,1.2527251618255104,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U15/Data!V$23^2,0.00001)","v":0.86754229791632476},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,"Tmax",25,null,null,null,0,{"$f":"IF(Data!B31>E$6,Data!B31-E$6,0)","v":0},{"$f":"IF(N16>0,Data!J31/'CB&P'!E$7,0)","v":0},{"$f":"IF(N16>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O16/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,8,1.293704833333986,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U16/Data!V$23^2,0.00001)","v":0.86505788354882451},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B32>E$6,Data!B32-E$6,0)","v":0},{"$f":"IF(N17>0,Data!J32/'CB&P'!E$7,0)","v":0},{"$f":"IF(N17>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O17/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,9,1.3360250490640651,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U17/Data!V$23^2,0.00001)","v":0.86252683511447836},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B33>E$6,Data!B33-E$6,0)","v":0},{"$f":"IF(N18>0,Data!J33/'CB&P'!E$7,0)","v":0},{"$f":"IF(N18>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O18/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,10,1.3797296614612149,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U18/Data!V$23^2,0.00001)","v":0.85994844014771554},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,"J-Ratio",null,null,null,0,{"$f":"IF(Data!B34>E$6,Data!B34-E$6,0)","v":0},{"$f":"IF(N19>0,Data!J34/'CB&P'!E$7,0)","v":0},{"$f":"IF(N19>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O19/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,11,1.4248639574905113,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U19/Data!V$23^2,0.00001)","v":0.85732197752837191},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,{"$f":"Figures!U27","v":-1.2250000000000001},null,null,null,0,{"$f":"IF(Data!B35>E$6,Data!B35-E$6,0)","v":0},{"$f":"IF(N20>0,Data!J35/'CB&P'!E$7,0)","v":0},{"$f":"IF(N20>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O20/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,12,1.4714747055632484,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U20/Data!V$23^2,0.00001)","v":0.85464671783265722},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B36>E$6,Data!B36-E$6,0)","v":0},{"$f":"IF(N21>0,Data!J36/'CB&P'!E$7,0)","v":0},{"$f":"IF(N21>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O21/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,13,1.5196102039986283,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U21/Data!V$23^2,0.00001)","v":0.85192192372717712},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B37>E$6,Data!B37-E$6,0)","v":0},{"$f":"IF(N22>0,Data!J37/'CB&P'!E$7,0)","v":0},{"$f":"IF(N22>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O22/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,14,1.5693203310707511,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U22/Data!V$23^2,0.00001)","v":0.8491468165010021},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B38>E$6,Data!B38-E$6,0)","v":0},{"$f":"IF(N23>0,Data!J38/'CB&P'!E$7,0)","v":0},{"$f":"IF(N23>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O23/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,15,1.6206565966927624,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U23/Data!V$23^2,0.00001)","v":0.84632072133694947},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B39>E$6,Data!B39-E$6,0)","v":0},{"$f":"IF(N24>0,Data!J39/'CB&P'!E$7,0)","v":0},{"$f":"IF(N24>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O24/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,16,1.6736721957917162,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U24/Data!V$23^2,0.00001)","v":0.8434428345942202},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B40>E$6,Data!B40-E$6,0)","v":0},{"$f":"IF(N25>0,Data!J40/'CB&P'!E$7,0)","v":0},{"$f":"IF(N25>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O25/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,17,1.7284220634294569,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U25/Data!V$23^2,0.00001)","v":0.84051239264147926},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B41>E$6,Data!B41-E$6,0)","v":0},{"$f":"IF(N26>0,Data!J41/'CB&P'!E$7,0)","v":0},{"$f":"IF(N26>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O26/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,18,1.7849629317266378,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U26/Data!V$23^2,0.00001)","v":0.83752862645603288},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B42>E$6,Data!B42-E$6,0)","v":0},{"$f":"IF(N27>0,Data!J42/'CB&P'!E$7,0)","v":0},{"$f":"IF(N27>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O27/Data!V$23^2,'CB&P'!Q$2),0)","v":0},{"$f":"N27*(P27-Q27)^2","v":0},null,19,1.8433533886488656,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U27/Data!V$23^2,0.00001)","v":0.83449076229963493},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B43>E$6,Data!B43-E$6,0)","v":0},{"$f":"IF(N28>0,Data!J43/'CB&P'!E$7,0)","v":0},{"$f":"IF(N28>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O28/Data!V$23^2,'CB&P'!Q$2),0)","v":0},{"$f":"N28*(P28-Q28)^2","v":0},null,20,1.9036539387158786,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U28/Data!V$23^2,0.00001)","v":0.83139802243640837},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B44>E$6,Data!B44-E$6,0)","v":0},{"$f":"IF(N29>0,Data!J44/'CB&P'!E$7,0)","v":0},{"$f":"IF(N29>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O29/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,21,1.9659270656966696,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U29/Data!V$23^2,0.00001)","v":0.82824962589308659},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B45>E$6,Data!B45-E$6,0)","v":0.5},{"$f":"IF(N30>0,Data!J45/'CB&P'!E$7,0)","v":0.94390243902438942},{"$f":"IF(N30>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O30/Data!V$23^2,'CB&P'!Q$2),0)","v":0.92151639252588213},5.0113507783333027E-4,null,22,2.0302372973555216,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U30/Data!V$23^2,0.00001)","v":0.82504478926187863},null,0.5,0.94390243902438942]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B46>E$6,Data!B46-E$6,0)","v":1.6000000000000014},{"$f":"IF(N31>0,Data!J46/'CB&P'!E$7,0)","v":0.90000000000000091},{"$f":"IF(N31>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O31/Data!V$23^2,'CB&P'!Q$2),0)","v":0.84745347101187296},2.7611377087001709E-3,null,23,2.0966512723160351,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U31/Data!V$23^2,0.00001)","v":0.8217827275463121},null,1.6000000000000014,0.90000000000000091]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B47>E$6,Data!B47-E$6,0)","v":2.5},{"$f":"IF(N32>0,Data!J47/'CB&P'!E$7,0)","v":0.85365853658536561},{"$f":"IF(N32>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O32/Data!V$23^2,'CB&P'!Q$2),0)","v":0.80290621846048227},2.5757977950493626E-3,null,24,2.1652378091124485,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U32/Data!V$23^2,0.00001)","v":0.81846265505047511},null,2.5,0.85365853658536561]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B48>E$6,Data!B48-E$6,0)","v":3.5},{"$f":"IF(N33>0,Data!J48/'CB&P'!E$7,0)","v":0.81219512195121879},{"$f":"IF(N33>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O33/Data!V$23^2,'CB&P'!Q$2),0)","v":0.76152450115375114},2.5675118120007607E-3,null,25,2.2360679774997898,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U33/Data!V$23^2,0.00001)","v":0.81508378631212508},null,3.5,0.81219512195121879]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B49>E$6,Data!B49-E$6,0)","v":4.5},{"$f":"IF(N34>0,Data!J49/'CB&P'!E$7,0)","v":0.76585365853658527},{"$f":"IF(N34>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O34/Data!V$23^2,'CB&P'!Q$2),0)","v":0.72569578832180504},1.6126545401871333E-3,null,26,2.3092151720967529,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U34/Data!V$23^2,0.00001)","v":0.81164533708021647},null,4.5,0.76585365853658527]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B50>E$6,Data!B50-E$6,0)","v":5.5},{"$f":"IF(N35>0,Data!J50/'CB&P'!E$7,0)","v":0.72439024390243845},{"$f":"IF(N35>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O35/Data!V$23^2,'CB&P'!Q$2),0)","v":0.6938712526699834},9.3140882584666828E-4,null,27,2.384755188437619,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U35/Data!V$23^2,0.00001)","v":0.80814652533741949},null,5.5,0.72439024390243845]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B51>E$6,Data!B51-E$6,0)","v":6.5},{"$f":"IF(N36>0,Data!J51/'CB&P'!E$7,0)","v":0.69024390243902367},{"$f":"IF(N36>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O36/Data!V$23^2,'CB&P'!Q$2),0)","v":0.66514400353542569},6.3000492497083927E-4,null,28,2.4627663015120116,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U36/Data!V$23^2,0.00001)","v":0.80458657236827169},null,6.5,0.69024390243902367]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B52>E$6,Data!B52-E$6,0)","v":7.5},{"$f":"IF(N37>0,Data!J52/'CB&P'!E$7,0)","v":0.65365853658536555},{"$f":"IF(N37>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O37/Data!V$23^2,'CB&P'!Q$2),0)","v":0.63892125650272003},2.1718742423434037E-4,null,29,2.5433293468738825,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U37/Data!V$23^2,0.00001)","v":0.80096470387363838},null,7.5,0.65365853658536555]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B53>E$6,Data!B53-E$6,0)","v":8.5},{"$f":"IF(N38>0,Data!J53/'CB&P'!E$7,0)","v":0.61951219512195077},{"$f":"IF(N38>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O38/Data!V$23^2,'CB&P'!Q$2),0)","v":0.61478636348729709},2.2333484639093442E-5,null,30,2.626527804403767,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U38/Data!V$23^2,0.00001)","v":0.79728015113219508},null,8.5,0.61951219512195077]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B54>E$6,Data!B54-E$6,0)","v":9.5},{"$f":"IF(N39>0,Data!J54/'CB&P'!E$7,0)","v":0.59268292682926793},{"$f":"IF(N39>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O39/Data!V$23^2,'CB&P'!Q$2),0)","v":0.59243102334746611},6.3455364143879073E-8,null,31,2.7124478848111058,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U39/Data!V$23^2,0.00001)","v":0.79353215220967466},null,9.5,0.59268292682926793]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B55>E$6,Data!B55-E$6,0)","v":10.5},{"$f":"IF(N40>0,Data!J55/'CB&P'!E$7,0)","v":0.5658536585365852},{"$f":"IF(N40>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O40/Data!V$23^2,'CB&P'!Q$2),0)","v":0.57161820746396697},3.3230024336178233E-5,null,32,{"$f":"EXP(LN(J$15)+(LN(J$16)-LN(J$15))*T40/100)","v":2.8011786189662651},{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U40/Data!V$23^2,0.00001)","v":0.78971995321664779},null,10.5,0.5658536585365852]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B56>E$6,Data!B56-E$6,0)","v":11.5},{"$f":"IF(N41>0,Data!J56/'CB&P'!E$7,0)","v":0.54390243902438917},{"$f":"IF(N41>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O41/Data!V$23^2,'CB&P'!Q$2),0)","v":0.55216022324806924},6.8191000284859374E-5,null,33,2.8928119501548286,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U41/Data!V$23^2,0.00001)","v":0.78584280961561925},null,11.5,0.54390243902438917]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B57>E$6,Data!B57-E$6,0)","v":12.5},{"$f":"IF(N42>0,Data!J57/'CB&P'!E$7,0)","v":0.51707317073170644},{"$f":"IF(N42>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O42/Data!V$23^2,'CB&P'!Q$2),0)","v":0.5339049165755485},2.8330766815169451E-4,null,34,2.9874428293497415,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U42/Data!V$23^2,0.00001)","v":0.78189998757822698},null,12.5,0.51707317073170644]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B58>E$6,Data!B58-E$6,0)","v":13.5},{"$f":"IF(N43>0,Data!J58/'CB&P'!E$7,0)","v":0.4975609756097556},{"$f":"IF(N43>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O43/Data!V$23^2,'CB&P'!Q$2),0)","v":0.51672657672498701},3.6732026610815957E-4,null,35,3.0851693136000478,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U43/Data!V$23^2,0.00001)","v":0.77789076539332469},null,13.5,0.4975609756097556]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B59>E$6,Data!B59-E$6,0)","v":14.5},{"$f":"IF(N44>0,Data!J59/'CB&P'!E$7,0)","v":0.48048780487804821},{"$f":"IF(N44>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O44/Data!V$23^2,'CB&P'!Q$2),0)","v":0.50051969316389799},4.012765482967659E-4,null,36,3.1860926676381536,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U44/Data!V$23^2,0.00001)","v":0.77381443492671675},null,14.5,0.48048780487804821]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B60>E$6,Data!B60-E$6,0)","v":15.5},{"$f":"IF(N45>0,Data!J60/'CB&P'!E$7,0)","v":0.46341463414634082},{"$f":"IF(N45>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O45/Data!V$23^2,'CB&P'!Q$2),0)","v":0.48519453292914655},4.7436399098926249E-4,null,37,3.2903174688109118,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U45/Data!V$23^2,0.00001)","v":0.76967030313327678},null,15.5,0.46341463414634082]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B61>E$6,Data!B61-E$6,0)","v":16.5},{"$f":"IF(N46>0,Data!J61/'CB&P'!E$7,0)","v":0.44634146341463343},{"$f":"IF(N46>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O46/Data!V$23^2,'CB&P'!Q$2),0)","v":0.47067391984365087},5.9206843587003186E-4,null,38,3.3979517154432557,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U46/Data!V$23^2,0.00001)","v":0.76545769362215399},null,16.5,0.44634146341463343]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B62>E$6,Data!B62-E$6,0)","v":17.5},{"$f":"IF(N47>0,Data!J62/'CB&P'!E$7,0)","v":0.43170731707317123},{"$f":"IF(N47>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O47/Data!V$23^2,'CB&P'!Q$2),0)","v":0.45689083354746785},6.3420950201116923E-4,null,39,3.5091069387466742,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U47/Data!V$23^2,0.00001)","v":0.76117594827568946},null,17.5,0.43170731707317123]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B63>E$6,Data!B63-E$6,0)","v":22.5},{"$f":"IF(N48>0,Data!J63/'CB&P'!E$7,0)","v":0.36585365853658508},{"$f":"IF(N48>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O48/Data!V$23^2,'CB&P'!Q$2),0)","v":0.3972043435985268},9.828654538530557E-4,null,40,3.6238983183884779,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U48/Data!V$23^2,0.00001)","v":0.75682442892260615},null,22.5,0.36585365853658508]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,3.7424448018416152,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U49/Data!V$23^2,0.00001)","v":0.75240251906595301}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,3.8648692276387178,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U50/Data!V$23^2,0.00001)","v":0.74790962566614305}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,3.9912984526580777,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U51/Data!V$23^2,0.00001)","v":0.74334518097934021}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,4.1218634835734518,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U52/Data!V$23^2,0.00001)","v":0.73870864445126438}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,4.2566996126039234,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U53/Data!V$23^2,0.00001)","v":0.73399950466634423}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,4.3959465577044483,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U54/Data!V$23^2,0.00001)","v":0.72921728135195441}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,4.5397486073423998,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U55/Data!V$23^2,0.00001)","v":0.72436152743726634}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,4.6882547700100767,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U56/Data!V$23^2,0.00001)","v":0.71943183116602061}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,4.841618928628149,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U57/Data!V$23^2,0.00001)","v":0.71442781826227486}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,4.9999999999999991,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U58/Data!V$23^2,0.00001)","v":0.7093491541479372}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,5.163562099482216,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U59/Data!V$23^2,0.00001)","v":0.70419554621058422}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,5.3324747110418356,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U60/Data!V$23^2,0.00001)","v":0.69896674611976073}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,5.5069128628765993,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U61/Data!V$23^2,0.00001)","v":0.69366255218965533}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,5.687057308780143,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U62/Data!V$23^2,0.00001)","v":0.68828281178566397}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,5.8730947154400956,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U63/Data!V$23^2,0.00001)","v":0.68282742377201078}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,6.0652178558631524,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U64/Data!V$23^2,0.00001)","v":0.67729634099719593}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,6.2636258091275501,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U65/Data!V$23^2,0.00001)","v":0.67168957281364206}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,6.4685241666699289,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U66/Data!V$23^2,0.00001)","v":0.66600718762747313}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,6.6801252453203244,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U67/Data!V$23^2,0.00001)","v":0.66024931547392129}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,6.8986483073060736,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U68/Data!V$23^2,0.00001)","v":0.65441615061339253}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,7.1243197874525563,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U69/Data!V$23^2,0.00001)","v":0.64850795414273998}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,7.3573735278162413,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U70/Data!V$23^2,0.00001)","v":0.64252505661578641}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,7.5980510199931421,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U71/Data!V$23^2,0.00001)","v":0.63646786066664218}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64,{"$f":"EXP(LN(J$15)+(LN(J$16)-LN(J$15))*T72/100)","v":7.8466016553537532},{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U72/Data!V$23^2,0.00001)","v":0.63033684362881237}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,8.1032829834638118,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U73/Data!V$23^2,0.00001)","v":0.6241325601425679}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,8.3683609789585827,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U74/Data!V$23^2,0.00001)","v":0.61785563229635398}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,8.6421103171472833,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U75/Data!V$23^2,0.00001)","v":0.61150680622811748}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68,8.9248146586331885,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U76/Data!V$23^2,0.00001)","v":0.60508686580883719}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69,9.2167669432443251,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U77/Data!V$23^2,0.00001)","v":0.59859670087718542}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,9.5182696935793913,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U78/Data!V$23^2,0.00001)","v":0.59203729101348257}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,71,9.8296353284833504,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U79/Data!V$23^2,0.00001)","v":0.58540970791935953}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72,10.151186486777606,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U80/Data!V$23^2,0.00001)","v":0.57871511770945916}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73,10.483256361580175,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U81/Data!V$23^2,0.00001)","v":0.57195478310463232}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74,10.826189045562245,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U82/Data!V$23^2,0.00001)","v":0.56513006551531775}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,11.180339887498945,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U83/Data!V$23^2,0.00001)","v":0.55824242700305104}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,76,11.546075860483764,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U84/Data!V$23^2,0.00001)","v":0.55129343210734638}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,77,11.92377594218809,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U85/Data!V$23^2,0.00001)","v":0.54428474952455796}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78,12.313831507560055,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U86/Data!V$23^2,0.00001)","v":0.53721815362471337}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79,12.716646734369412,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U87/Data!V$23^2,0.00001)","v":0.53009552579180352}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,13.132639022018838,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U88/Data!V$23^2,0.00001)","v":0.52291885557254025}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81,13.562239424055527,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U89/Data!V$23^2,0.00001)","v":0.51569024161821808}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82,14.005893094831327,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U90/Data!V$23^2,0.00001)","v":0.50841189240400564}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,83,14.464059750774139,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U91/Data!V$23^2,0.00001)","v":0.50108612670977504}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,84,14.937214146748699,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U92/Data!V$23^2,0.00001)","v":0.4937153738464431}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,85,15.425846568000242,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U93/Data!V$23^2,0.00001)","v":0.48630217361177025}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,86,15.930463338190766,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U94/Data!V$23^2,0.00001)","v":0.47884917595960746}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,87,16.451587344054555,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U95/Data!V$23^2,0.00001)","v":0.4713591403667759}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,88,16.989758577216271,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U96/Data!V$23^2,0.00001)","v":0.46383493488202671}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,89,17.545534693733362,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U97/Data!V$23^2,0.00001)","v":0.4562795348419374}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,18.119491591942388,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U98/Data!V$23^2,0.00001)","v":0.44869602123913616}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,91,18.712224009208072,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U99/Data!V$23^2,0.00001)","v":0.4410875787288982}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,92,19.32434613819359,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U100/Data!V$23^2,0.00001)","v":0.43345749326096594}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,93,19.956492263290393,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U101/Data!V$23^2,0.00001)","v":0.42580914932439529}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94,20.60931741786726,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U102/Data!V$23^2,0.00001)","v":0.41814602679432988}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95,21.283498063019614,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U103/Data!V$23^2,0.00001)","v":0.41047169737086353}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,96,{"$f":"EXP(LN(J$15)+(LN(J$16)-LN(J$15))*T104/100)","v":21.979732788522238},{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U104/Data!V$23^2,0.00001)","v":0.40278982060157947}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97,22.698743036712006,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U105/Data!V$23^2,0.00001)","v":0.39510413948092932}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98,23.441273850050386,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U106/Data!V$23^2,0.00001)","v":0.38741847562138637}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99,24.208094643140736,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U107/Data!V$23^2,0.00001)","v":0.37973672399321179}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,24.999999999999996,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U108/Data!V$23^2,0.00001)","v":0.3720628472317748}]

{"sheet":"B&R Type Curve","index":6,"n_rows":56,"n_cols":30,"rows_kept":56,"cut":false,"hidden":true,"merged":[[4,3,4,4]]}
["Bouwer and Rice Short Term LNAPL Mobility Test Type Curves"]
[{"$f":"CONCATENATE(\"B&R Type Curves:  Casing Rad. (ft) = \",Data!B6,\" ;  Borehole Rad. (ft) = \",Data!B7)","v":"B&R Type Curves:  Casing Rad. (ft) = 0.17 ;  Borehole Rad. (ft) = 0.5"}]
[]
[]
[null,null,null,"Enter these values"]
["Type Curve ID","Type Curve Name","Notes","Max Time (min)","Transmissivity (ft2/day)"]
[1,{"$f":"CONCATENATE(\"T=\",E7,\" ft2/day\")","v":"T=10 ft2/day"},null,150,10,null,"J-Ratio",null,null,null,"Type Curve 1",null,null,"Type Curve 2",null,null,"Type Curve 3",null,null,"Type Curve 4",null,null,"Type Curve 5",null,null,"Type Curve 6",null,null,"Type Curve 7"]
[2,"T=5 ft2/day",null,200,5,null,{"$f":"Figures!U27","v":-1.2250000000000001},"<--  If uncertain use",null,null,null,"T (ft2/day)",null,null,"T (ft2/day)",null,null,"T (ft2/day)",null,null,"T (ft2/day)",null,null,"T (ft2/day)",null,null,"T (ft2/day)",null,null,"T (ft2/day)"]
[3,"T=2 ft2/day",null,200,2,null,null,{"$f":"-(1-Data!B9)","v":-0.122},null,null,null,{"$f":"E7","v":10},null,null,{"$f":"E8","v":5},null,null,{"$f":"E9","v":2},null,null,{"$f":"E10","v":1},null,null,{"$f":"E11","v":0.5},null,null,{"$f":"E12","v":0.2},null,null,{"$f":"E13","v":0.1}]
[4,"T=1 ft2/day",null,200,1]
[5,"T=0.5 ft2/day",null,200,0.5,null,null,null,null,null,"t (min)","s(t)/s0",null,"t (min)","s(t)/s0",null,"t (min)","s(t)/s0",null,"t (min)","s(t)/s0",null,"t (min)","s(t)/s0",null,"t (min)","s(t)/s0",null,"t (min)","s(t)/s0"]
[6,"T=0.2 ft2/day",null,200,0.2,null,null,null,null,null,0,{"$f":"EXP(-(2*L$9*(K12/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":1},null,0,{"$f":"EXP(-(2*O$9*(N12/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1},null,0,{"$f":"EXP(-(2*R$9*(Q12/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1},null,0,{"$f":"EXP(-(2*U$9*(T12/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":1},null,0,{"$f":"EXP(-(2*X$9*(W12/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1},null,0,{"$f":"EXP(-(2*AA$9*(Z12/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1},null,0,{"$f":"EXP(-(2*AD$9*(AC12/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1}]
[7,"T=0.1 ft2/day",null,200,0.1,null,null,null,null,null,{"$f":"(K$42-K$12)/30+K12","v":5},{"$f":"EXP(-(2*L$9*(K13/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.60194672308758357},null,{"$f":"(N$42-N$12)/30+N12","v":6.666666666666667},{"$f":"EXP(-(2*O$9*(N13/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.71291656030977091},null,{"$f":"(Q$42-Q$12)/30+Q12","v":6.666666666666667},{"$f":"EXP(-(2*R$9*(Q13/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.87340461268116942},null,{"$f":"(T$42-T$12)/30+T12","v":6.666666666666667},{"$f":"EXP(-(2*U$9*(T13/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.93456118723236592},null,{"$f":"(W$42-W$12)/30+W12","v":6.666666666666667},{"$f":"EXP(-(2*X$9*(W13/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.96672704898144124},null,{"$f":"(Z$42-Z$12)/30+Z12","v":6.666666666666667},{"$f":"EXP(-(2*AA$9*(Z13/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.98655555912772697},null,{"$f":"(AC$42-AC$12)/30+AC12","v":6.666666666666667},{"$f":"EXP(-(2*AD$9*(AC13/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.99325503226901746}]
[null,null,null,null,null,null,null,null,null,null,10,{"$f":"EXP(-(2*L$9*(K14/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.36233985743588004},null,13.333333333333334,{"$f":"EXP(-(2*O$9*(N14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.50825002196391522},null,13.333333333333334,{"$f":"EXP(-(2*R$9*(Q14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.76283561745274353},null,13.333333333333334,{"$f":"EXP(-(2*U$9*(T14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.87340461268116942},null,13.333333333333334,{"$f":"EXP(-(2*X$9*(W14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.93456118723236592},null,13.333333333333334,{"$f":"EXP(-(2*AA$9*(Z14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.97329187124582195},null,13.333333333333334,{"$f":"EXP(-(2*AD$9*(AC14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.98655555912772697}]
[null,null,null,null,null,null,null,null,null,null,15,{"$f":"EXP(-(2*L$9*(K15/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.21810928982755023},null,20,{"$f":"EXP(-(2*O$9*(N15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.36233985743588004},null,20,{"$f":"EXP(-(2*R$9*(Q15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.66626414700071412},null,20,{"$f":"EXP(-(2*U$9*(T15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.81625005176153842},null,20,{"$f":"EXP(-(2*X$9*(W15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.9034655786257374},null,20,{"$f":"EXP(-(2*AA$9*(Z15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.96020650623139348},null,20,{"$f":"EXP(-(2*AD$9*(AC15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.97990127371658897}]
[null,null,null,null,null,null,null,null,null,null,20,{"$f":"EXP(-(2*L$9*(K16/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.13129017228665388},null,26.666666666666668,{"$f":"EXP(-(2*O$9*(N16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.25831808482632029},null,26.666666666666668,{"$f":"EXP(-(2*R$9*(Q16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.58191817925450851},null,26.666666666666668,{"$f":"EXP(-(2*U$9*(T16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.76283561745274353},null,26.666666666666668,{"$f":"EXP(-(2*X$9*(W16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.87340461268116942},null,26.666666666666668,{"$f":"EXP(-(2*AA$9*(Z16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.94729706663319369},null,26.666666666666668,{"$f":"EXP(-(2*AD$9*(AC16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.97329187124582195}]
[null,null,null,null,null,null,null,null,null,null,25,{"$f":"EXP(-(2*L$9*(K17/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":7.9029688981555546E-2},null,33.333333333333336,{"$f":"EXP(-(2*O$9*(N17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.18415924050018789},null,33.333333333333336,{"$f":"EXP(-(2*R$9*(Q17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.50825002196391522},null,33.333333333333336,{"$f":"EXP(-(2*U$9*(T17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.71291656030977091},null,33.333333333333336,{"$f":"EXP(-(2*X$9*(W17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.84434386378404558},null,33.333333333333336,{"$f":"EXP(-(2*AA$9*(Z17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.93456118723236592},null,33.333333333333336,{"$f":"EXP(-(2*AD$9*(AC17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.96672704898144124}]
[null,null,null,null,null,null,null,null,null,null,30,{"$f":"EXP(-(2*L$9*(K18/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":4.7571662309078312E-2},null,40,{"$f":"EXP(-(2*O$9*(N18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.13129017228665388},null,40,{"$f":"EXP(-(2*R$9*(Q18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.44390791357858922},null,40,{"$f":"EXP(-(2*U$9*(T18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.66626414700071412},null,40,{"$f":"EXP(-(2*X$9*(W18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.81625005176153842},null,40,{"$f":"EXP(-(2*AA$9*(Z18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.92199653460909914},null,40,{"$f":"EXP(-(2*AD$9*(AC18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.96020650623139348}]
[null,null,null,null,null,null,null,null,null,null,35,{"$f":"EXP(-(2*L$9*(K19/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":2.8635606238778786E-2},null,46.666666666666664,{"$f":"EXP(-(2*O$9*(N19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":9.3598938029078482E-2},null,46.666666666666664,{"$f":"EXP(-(2*R$9*(Q19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.3877112193252138},null,46.666666666666664,{"$f":"EXP(-(2*U$9*(T19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.62266461223134706},null,46.666666666666664,{"$f":"EXP(-(2*X$9*(W19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.78909100377038077},null,46.666666666666664,{"$f":"EXP(-(2*AA$9*(Z19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.90960080671510646},null,46.666666666666664,{"$f":"EXP(-(2*AD$9*(AC19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.95372994433178326}]
[null,null,null,null,null,null,null,null,null,null,40,{"$f":"EXP(-(2*L$9*(K20/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":1.723710933905926E-2},null,53.333333333333329,{"$f":"EXP(-(2*O$9*(N20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":6.6728232948338045E-2},null,53.333333333333329,{"$f":"EXP(-(2*R$9*(Q20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.33862876734688224},null,53.333333333333329,{"$f":"EXP(-(2*U$9*(T20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.58191817925450851},null,53.333333333333329,{"$f":"EXP(-(2*X$9*(W20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.76283561745274353},null,53.333333333333329,{"$f":"EXP(-(2*AA$9*(Z20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.89737173245185331},null,53.333333333333329,{"$f":"EXP(-(2*AD$9*(AC20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.94729706663319369}]
[null,null,null,null,null,null,null,null,null,null,45,{"$f":"EXP(-(2*L$9*(K21/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":1.0375821482149101E-2},null,59.999999999999993,{"$f":"EXP(-(2*O$9*(N21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":4.7571662309078312E-2},null,59.999999999999993,{"$f":"EXP(-(2*R$9*(Q21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.29575992738730555},null,59.999999999999993,{"$f":"EXP(-(2*U$9*(T21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.54383814447619028},null,59.999999999999993,{"$f":"EXP(-(2*X$9*(W21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.73745382531802639},null,59.999999999999993,{"$f":"EXP(-(2*AA$9*(Z21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.88530707125445518},null,59.999999999999993,{"$f":"EXP(-(2*AD$9*(AC21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.94090757848709838}]
[null,null,null,null,null,null,null,null,null,null,50,{"$f":"EXP(-(2*L$9*(K22/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":6.2456917405214023E-3},null,66.666666666666657,{"$f":"EXP(-(2*O$9*(N22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":3.3914625861606089E-2},null,66.666666666666657,{"$f":"EXP(-(2*R$9*(Q22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.2583180848263204},null,66.666666666666657,{"$f":"EXP(-(2*U$9*(T22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.50825002196391533},null,66.666666666666657,{"$f":"EXP(-(2*X$9*(W22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.71291656030977102},null,66.666666666666657,{"$f":"EXP(-(2*AA$9*(Z22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.87340461268116942},null,66.666666666666657,{"$f":"EXP(-(2*AD$9*(AC22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.93456118723236603}]
[null,null,null,null,null,null,null,null,null,null,55,{"$f":"EXP(-(2*L$9*(K23/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":3.7595736766220427E-3},null,73.333333333333329,{"$f":"EXP(-(2*O$9*(N23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":2.4178298413449009E-2},null,73.333333333333329,{"$f":"EXP(-(2*R$9*(Q23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.22561620682627381},null,73.333333333333329,{"$f":"EXP(-(2*U$9*(T23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.47499074393747276},null,73.333333333333329,{"$f":"EXP(-(2*X$9*(W23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.68919572251826455},null,73.333333333333329,{"$f":"EXP(-(2*AA$9*(Z23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.86166217600840689},null,73.333333333333329,{"$f":"EXP(-(2*AD$9*(AC23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.92825760218185493}]
[null,null,null,null,null,null,null,null,null,null,60,{"$f":"EXP(-(2*L$9*(K24/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":2.2630630548489822E-3},null,80,{"$f":"EXP(-(2*O$9*(N24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.723710933905926E-2},null,80,{"$f":"EXP(-(2*R$9*(Q24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.19705423573769626},null,80,{"$f":"EXP(-(2*U$9*(T24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.44390791357858922},null,80,{"$f":"EXP(-(2*X$9*(W24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.66626414700071412},null,80,{"$f":"EXP(-(2*AA$9*(Z24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.85007760983118774},null,80,{"$f":"EXP(-(2*AD$9*(AC24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.92199653460909914}]
[null,null,null,null,null,null,null,null,null,null,65,{"$f":"EXP(-(2*L$9*(K25/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":1.3622433900069193E-3},null,86.666666666666671,{"$f":"EXP(-(2*O$9*(N25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.2288620699685554E-2},null,86.666666666666671,{"$f":"EXP(-(2*R$9*(Q25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.17210807844166645},null,86.666666666666671,{"$f":"EXP(-(2*U$9*(T25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.41485910673584886},null,86.666666666666671,{"$f":"EXP(-(2*X$9*(W25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.64409557267213757},null,86.666666666666671,{"$f":"EXP(-(2*AA$9*(Z25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.83864879166896911},null,86.666666666666671,{"$f":"EXP(-(2*AD$9*(AC25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.915777697735083}]
[null,null,null,null,null,null,null,null,null,null,70,{"$f":"EXP(-(2*L$9*(K26/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":8.1999794466238655E-4},null,93.333333333333343,{"$f":"EXP(-(2*O$9*(N26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":8.7607612001712725E-3},null,93.333333333333343,{"$f":"EXP(-(2*R$9*(Q26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.15031998959064399},null,93.333333333333343,{"$f":"EXP(-(2*U$9*(T26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.38771121932521374},null,93.333333333333343,{"$f":"EXP(-(2*X$9*(W26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.62266461223134706},null,93.333333333333343,{"$f":"EXP(-(2*AA$9*(Z26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.82737362757677235},null,93.333333333333343,{"$f":"EXP(-(2*AD$9*(AC26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.90960080671510635}]
[null,null,null,null,null,null,null,null,null,null,75,{"$f":"EXP(-(2*L$9*(K27/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":4.9359507572807701E-4},null,100.00000000000001,{"$f":"EXP(-(2*O$9*(N27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":6.2456917405214023E-3},null,100.00000000000001,{"$f":"EXP(-(2*R$9*(Q27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.13129017228665388},null,100.00000000000001,{"$f":"EXP(-(2*U$9*(T27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.36233985743588004},null,100.00000000000001,{"$f":"EXP(-(2*X$9*(W27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.60194672308758357},null,100.00000000000001,{"$f":"EXP(-(2*AA$9*(Z27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.81625005176153842},null,100.00000000000001,{"$f":"EXP(-(2*AD$9*(AC27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.9034655786257374}]
[null,null,null,null,null,null,null,null,null,null,80,{"$f":"EXP(-(2*L$9*(K28/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":2.9711793836668401E-4},null,106.66666666666669,{"$f":"EXP(-(2*O$9*(N28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":4.4526570724076637E-3},null,106.66666666666669,{"$f":"EXP(-(2*R$9*(Q28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.1146694420748689},null,106.66666666666669,{"$f":"EXP(-(2*U$9*(T28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.33862876734688224},null,106.66666666666669,{"$f":"EXP(-(2*X$9*(W28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.58191817925450851},null,106.66666666666669,{"$f":"EXP(-(2*AA$9*(Z28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.80527602620364058},null,106.66666666666669,{"$f":"EXP(-(2*AD$9*(AC28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.89737173245185331}]
[null,null,null,null,null,null,null,null,null,null,85,{"$f":"EXP(-(2*L$9*(K29/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":1.7884916937036397E-4},null,113.33333333333336,{"$f":"EXP(-(2*O$9*(N29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":3.1743729642998452E-3},null,113.33333333333336,{"$f":"EXP(-(2*R$9*(Q29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.10015281964176662},null,113.33333333333336,{"$f":"EXP(-(2*U$9*(T29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.31646930284273483},null,113.33333333333336,{"$f":"EXP(-(2*X$9*(W29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.56255604417936422},null,113.33333333333336,{"$f":"EXP(-(2*AA$9*(Z29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.79444954028348669},null,113.33333333333336,{"$f":"EXP(-(2*AD$9*(AC29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.89131898907376961}]
[null,null,null,null,null,null,null,null,null,null,90,{"$f":"EXP(-(2*L$9*(K30/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":1.0765767142942676E-4},null,120.00000000000003,{"$f":"EXP(-(2*O$9*(N30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":2.2630630548489761E-3},null,120.00000000000003,{"$f":"EXP(-(2*R$9*(Q30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":8.7473934648144153E-2},null,120.00000000000003,{"$f":"EXP(-(2*U$9*(T30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.29575992738730539},null,120.00000000000003,{"$f":"EXP(-(2*X$9*(W30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.54383814447619006},null,120.00000000000003,{"$f":"EXP(-(2*AA$9*(Z30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.78376861041314083},null,120.00000000000003,{"$f":"EXP(-(2*AD$9*(AC30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.88530707125445507}]
[null,null,null,null,null,null,null,null,null,null,95,{"$f":"EXP(-(2*L$9*(K31/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":6.4804182532183174E-5},null,126.6666666666667,{"$f":"EXP(-(2*O$9*(N31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.6133751288270541E-3},null,126.6666666666667,{"$f":"EXP(-(2*R$9*(Q31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":7.640013801106027E-2},null,126.6666666666667,{"$f":"EXP(-(2*U$9*(T31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.27640574887483849},null,126.6666666666667,{"$f":"EXP(-(2*X$9*(W31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.52574304453300991},null,126.6666666666667,{"$f":"EXP(-(2*AA$9*(Z31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.77323127967289773},null,126.6666666666667,{"$f":"EXP(-(2*AD$9*(AC31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.87933570362683311}]
[null,null,null,null,null,null,null,null,null,null,100,{"$f":"EXP(-(2*L$9*(K32/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":3.9008665317617266E-5},null,133.33333333333337,{"$f":"EXP(-(2*O$9*(N32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.1502018473327177E-3},null,133.33333333333337,{"$f":"EXP(-(2*R$9*(Q32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":6.6728232948338018E-2},null,133.33333333333337,{"$f":"EXP(-(2*U$9*(T32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.25831808482632029},null,133.33333333333337,{"$f":"EXP(-(2*X$9*(W32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.50825002196391522},null,133.33333333333337,{"$f":"EXP(-(2*AA$9*(Z32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.76283561745274353},null,133.33333333333337,{"$f":"EXP(-(2*AD$9*(AC32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.87340461268116931}]
[null,null,null,null,null,null,null,null,null,null,105,{"$f":"EXP(-(2*L$9*(K33/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":2.3481138259959977E-5},null,140.00000000000003,{"$f":"EXP(-(2*O$9*(N33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":8.1999794466238655E-4},null,140.00000000000003,{"$f":"EXP(-(2*R$9*(Q33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":5.8280746453142018E-2},null,140.00000000000003,{"$f":"EXP(-(2*U$9*(T33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.24141405603887695},null,140.00000000000003,{"$f":"EXP(-(2*X$9*(W33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.49133904387792848},null,140.00000000000003,{"$f":"EXP(-(2*AA$9*(Z33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.75257971909863619},null,140.00000000000003,{"$f":"EXP(-(2*AD$9*(AC33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.86751352675254356}]
[null,null,null,null,null,null,null,null,null,null,110,{"$f":"EXP(-(2*L$9*(K34/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":1.4134394229949384E-5},null,146.66666666666669,{"$f":"EXP(-(2*O$9*(N34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":5.8459011416979033E-4},null,146.66666666666669,{"$f":"EXP(-(2*R$9*(Q34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":5.0902672782675941E-2},null,146.66666666666669,{"$f":"EXP(-(2*U$9*(T34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.22561620682627376},null,146.66666666666669,{"$f":"EXP(-(2*X$9*(W34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.4749907439374727},null,146.66666666666669,{"$f":"EXP(-(2*AA$9*(Z34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.74246170556354274},null,146.66666666666669,{"$f":"EXP(-(2*AD$9*(AC34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.86166217600840689}]
[null,null,null,null,null,null,null,null,null,null,115,{"$f":"EXP(-(2*L$9*(K35/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":8.5081522895460916E-6},null,153.33333333333334,{"$f":"EXP(-(2*O$9*(N35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":4.1676397338502309E-4},null,153.33333333333334,{"$f":"EXP(-(2*R$9*(Q35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":4.4458629206189405E-2},null,153.33333333333334,{"$f":"EXP(-(2*U$9*(T35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.21085215011042549},null,153.33333333333334,{"$f":"EXP(-(2*X$9*(W35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.45918640018017248},null,153.33333333333334,{"$f":"EXP(-(2*AA$9*(Z35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.73247972306316667},null,153.33333333333334,{"$f":"EXP(-(2*AD$9*(AC35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.85585029243622202}]
[null,null,null,null,null,null,null,null,null,null,120,{"$f":"EXP(-(2*L$9*(K36/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":5.1214543902224071E-6},null,160,{"$f":"EXP(-(2*O$9*(N36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":2.9711793836668401E-4},null,160,{"$f":"EXP(-(2*R$9*(Q36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":3.8830371822167566E-2},null,160,{"$f":"EXP(-(2*U$9*(T36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.19705423573769626},null,160,{"$f":"EXP(-(2*X$9*(W36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.44390791357858922},null,160,{"$f":"EXP(-(2*AA$9*(Z36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.72263194273630504},null,160,{"$f":"EXP(-(2*AD$9*(AC36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.85007760983118774}]
[null,null,null,null,null,null,null,null,null,null,125,{"$f":"EXP(-(2*L$9*(K37/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":3.0828426876368895E-6},null,166.66666666666666,{"$f":"EXP(-(2*O$9*(N37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":2.1182029862670682E-4},null,166.66666666666666,{"$f":"EXP(-(2*R$9*(Q37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":3.3914625861606075E-2},null,166.66666666666666,{"$f":"EXP(-(2*U$9*(T37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.18415924050018798},null,166.66666666666666,{"$f":"EXP(-(2*X$9*(W37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.42913778731333829},null,166.66666666666666,{"$f":"EXP(-(2*AA$9*(Z37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.71291656030977091},null,166.66666666666666,{"$f":"EXP(-(2*AD$9*(AC37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.84434386378404558}]
[null,null,null,null,null,null,null,null,null,null,130,{"$f":"EXP(-(2*L$9*(K38/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":1.8557070536175437E-6},null,173.33333333333331,{"$f":"EXP(-(2*O$9*(N38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.5101019870074028E-4},null,173.33333333333331,{"$f":"EXP(-(2*R$9*(Q38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":2.9621190664882828E-2},null,173.33333333333331,{"$f":"EXP(-(2*U$9*(T38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.17210807844166651},null,173.33333333333331,{"$f":"EXP(-(2*X$9*(W38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.41485910673584891},null,173.33333333333331,{"$f":"EXP(-(2*AA$9*(Z38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.7033317957678219},null,173.33333333333331,{"$f":"EXP(-(2*AD$9*(AC38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.83864879166896911}]
[null,null,null,null,null,null,null,null,null,null,135,{"$f":"EXP(-(2*L$9*(K39/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":1.1170367799355968E-6},null,179.99999999999997,{"$f":"EXP(-(2*O$9*(N39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.0765767142942695E-4},null,179.99999999999997,{"$f":"EXP(-(2*R$9*(Q39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":2.5871284559817069E-2},null,179.99999999999997,{"$f":"EXP(-(2*U$9*(T39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.16084553012072506},null,179.99999999999997,{"$f":"EXP(-(2*X$9*(W39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.40105551999782407},null,179.99999999999997,{"$f":"EXP(-(2*AA$9*(Z39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.69387589302603181},null,179.99999999999997,{"$f":"EXP(-(2*AD$9*(AC39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.83299213263153449}]
[null,null,null,null,null,null,null,null,null,null,140,{"$f":"EXP(-(2*L$9*(K40/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":6.7239662925053833E-7},null,186.66666666666663,{"$f":"EXP(-(2*O$9*(N40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":7.6750936806426671E-5},null,186.66666666666663,{"$f":"EXP(-(2*R$9*(Q40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":2.2596099270531345E-2},null,186.66666666666663,{"$f":"EXP(-(2*U$9*(T40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.15031998959064408},null,186.66666666666663,{"$f":"EXP(-(2*X$9*(W40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.38771121932521385},null,186.66666666666663,{"$f":"EXP(-(2*AA$9*(Z40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.68454711960954773},null,186.66666666666663,{"$f":"EXP(-(2*AD$9*(AC40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.82737362757677246}]
[null,null,null,null,null,null,null,null,null,null,145,{"$f":"EXP(-(2*L$9*(K41/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":4.0474694759249892E-7},null,193.33333333333329,{"$f":"EXP(-(2*O$9*(N41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":5.4717013868590383E-5},null,193.33333333333329,{"$f":"EXP(-(2*R$9*(Q41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.9735537331483696E-2},null,193.33333333333329,{"$f":"EXP(-(2*U$9*(T41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.14048322793658927},null,193.33333333333329,{"$f":"EXP(-(2*X$9*(W41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.37481092291526041},null,193.33333333333329,{"$f":"EXP(-(2*AA$9*(Z41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.67534376633567228},null,193.33333333333329,{"$f":"EXP(-(2*AD$9*(AC41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.82179301915730119}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"$D$7","v":150},{"$f":"EXP(-(2*L$9*(K42/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":2.4363609878300611E-7},null,{"$f":"$D$8","v":200},{"$f":"EXP(-(2*O$9*(N42/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":3.9008665317617266E-5},null,{"$f":"$D$9","v":200},{"$f":"EXP(-(2*R$9*(Q42/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.723710933905926E-2},null,{"$f":"$D$10","v":200},{"$f":"EXP(-(2*U$9*(T42/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.13129017228665388},null,{"$f":"$D$11","v":200},{"$f":"EXP(-(2*X$9*(W42/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.36233985743588004},null,{"$f":"$D$12","v":200},{"$f":"EXP(-(2*AA$9*(Z42/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.66626414700071412},null,{"$f":"$D$13","v":200},{"$f":"EXP(-(2*AD$9*(AC42/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.81625005176153842}]
[]
[]
[]
[]
[]
[]
["Field Data"]
[]
["Record Data in Fields Below",null,null,null,null,null,"Calculate and Plot Fields Below"]
["Well ID",null,"Well Dia. (ft)",null,"Total Depth (ft)"]
["Notes","Date","Time","Elapsed Time (min)","Depth To Product (TOC)","Depth to Water (TOC)","Product Thickness (ft)","Drawdown (s) DTP-DTP(initial) (ft)","Normalized Drawdown (s/sinitial)"]
["Initial Measurement"]
["Stopped Bailing/Start Gauging",null,null,0]
["Well Starts recovering"]

{"sheet":"Confined","index":7,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Confined LNAPL Model:",null,null,null,"Well Designation:",null,{"$f":"IF(Data!B1 > 0,Data!B1,\"\")","v":"YYY"}]
[null,null,null,null,"Date:",null,{"$f":"IF(Data!B2 > 0,Data!B2,\"\")","v":"date"}]
[]
[]
["Depth to base of confining bed (ft bgs) [from boring log]:",7]
["Constant LNAPL discharge to well (ft3/d):",40]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!N24","v":9.26},{"$f":"B6","v":40}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"B14","v":2.4622323462414575},{"$f":"M9","v":40}]
["Depth to top of screen (ft bgs):",{"$f":"Data!B10","v":7},null,null,null,null,null,null,null,null,null,0,0]
["Corrected water table elevation (ft bgs):",{"$f":"Data!I21","v":17.74868}]
["Limiting effective LNAPL thickness in well, bnW (ft):",{"$f":"IF(B5>B11,(B5-B12)/Data!B9,(B11-B12)/Data!B9)","v":-12.242232346241458}]
["Limiting effective LNAPL drawdown, snW (ft):",{"$f":"(1-Data!B9)*(Confined!B15-Confined!B13)","v":2.4622323462414575}]
["Initial LNAPL thickness, bnR (ft):",{"$f":"Data!O21","v":7.9399999999999977}]
["Radius of influence ratio (from Bouwer and Rice), R/rw:",{"$f":"'B&R'!J12","v":13.443619010125339}]
[]
[]
["LNAPL Transmissivity, Tn (ft2/d):",{"$f":"B6*LN(B16)/(2*PI()*(1-Data!B9)*(B15-B13))","v":6.7185348720294398}]

{"sheet":"Perched","index":8,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Perched LNAPL Model:",null,null,null,"Well Designation:",null,{"$f":"IF(Data!B1 > 0,Data!B1,\"\")","v":"YYY"}]
[null,null,null,null,"Date:",null,{"$f":"IF(Data!B2 > 0,Data!B2,\"\")","v":"date"}]
[]
[]
["Depth to top of perching layer, DZ12 (ft bgs):",22.63]
["Constant LNAPL discharge to well (ft3/d):",3.53]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!N24","v":9.26},{"$f":"B6","v":3.53}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"B13","v":5.8499999999999979},{"$f":"M9","v":3.53}]
["Depth to top of screen (ft bgs):",{"$f":"Data!B10","v":7},null,null,null,null,null,null,null,null,null,0,0]
["Corrected water table elevation (ft bgs):",{"$f":"Data!I21","v":17.74868}]
["Limiting effective LNAPL drawdown, snW (ft):",{"$f":"B5-B14","v":5.8499999999999979}]
["Initial depth to product (DTP0) (ft bgs):",{"$f":"Data!E21","v":16.78}]
["Radius of influence ratio (from Bouwer and Rice), R/rw:",{"$f":"'B&R'!J12","v":13.443619010125339}]
[]
[]
["LNAPL Transmissivity, Tn (ft2/d):",{"$f":"B6*LN(B15)/(2*PI()*B13)","v":0.2495528051318599}]

{"sheet":"Flowchart","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}