{"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":19,"images":9,"macros":1,"external_links":1,"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,2.9922458337886781]
[]
[]
[null,null,null,null,null,null,null,null,"Standard Deviation (ft2/d)"]
[null,null,null,null,null,null,null,null,0.48270293551829135]
[]
[]
[null,null,null,null,null,null,null,null,"Coefficient of Variation"]
[null,null,null,null,null,null,null,null,0.16131794054738799]

{"sheet":"Data","index":1,"n_rows":84,"n_cols":22,"rows_kept":84,"cut":false,"hidden":false,"merged":[]}
["Well Designation:","MW16"]
["Date:","2021-11-09"," "," "]
[]
["Ground Surface Elev (ft msl)",100.5,"Enter These Data",null,"Drawdown"]
["Top of Casing Elev (ft msl)",100.31,null,null,"Adjustment"]
["Well Casing Radius, rc (ft):",8.3000000000000004E-2,"re1",null,"(ft)"]
["Well Radius, rw (ft):",0.16700000000000001,null,null,{"$f":"Figures!C28","v":0}]
["LNAPL Specific Yield, Sy:",0.17499999999999999]
["LNAPL Density Ratio, rr:",0.78]
["Top of Screen (ft bgs):",30.7]
["Bottom of Screen (ft bgs):",40.700000000000003]
["LNAPL Baildown Vol. (gal.):",0.48]
["Effective Radius, re3 (ft):",{"$f":"SQRT(B8*(B7^2-B6^2)+B6^2)","v":0.10278132126023679},"Calculated Parameters"]
["Effective Radius, re2 (ft):",{"$f":"SQRT(-Figures!U27*B6^2+(Figures!U27+1)*B13^2)","v":9.3134311615000409E-2}]
["Initial Casing LNAPL Vol. (gal.):",{"$f":"PI()*B6^2*(F22-E22)*7.48","v":0.22178298401714927}]
["Initial Filter LNAPL Vol. (gal.):",{"$f":"IF(E22<B10,PI()*(B7^2-B6^2)*B8*(F22-B10)*7.48,PI()*(B7^2-B6^2)*B8*(F22-E22)*7.48)","v":0.11831215942270627}]
["Expected Thickness Recharged from Filter Pack (ft)",{"$f":"MAX(0,IFERROR(O22*(SUM(B15:B16)-B12)/SUM(B15:B16),O22))","v":0}]
[]
[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,34.93,36.299999999999997,{"$f":"C22+B4-B5","v":35.120000000000005},{"$f":"D22+B4-B5","v":36.490000000000009},null,null,{"$f":"E22+(1-B$9)*(F22-E22)","v":35.421400000000006},null,null,null,null,null,{"$f":"F22-E22","v":1.3700000000000045}]
[]
["Enter Test Data:",1,36.33,36.35,{"$f":"IF(B24>0,C24+B$4-B$5,NA())","v":36.519999999999982},{"$f":"IF(B24>0,D24+B$4-B$5,NA())","v":36.539999999999992},null,null,{"$f":"E24+(1-B$9)*(F24-E24)","v":36.524399999999986},{"$f":"E24-E$22-E$7","v":1.3999999999999773},null,null,null,null,{"$f":"F24-E24","v":2.0000000000010232E-2},null,null,null,null,null,0,{"$f":"MAX(V25:V82)/(MAX(L25:L82)-L25)","v":0.1027813212602368}]
[null,7,35.380000000000003,35.450000000000003,{"$f":"IF(B25>0,C25+B$4-B$5,NA())","v":35.569999999999993},{"$f":"IF(B25>0,D25+B$4-B$5,NA())","v":35.639999999999986},null,null,{"$f":"E25+(1-B$9)*(F25-E25)","v":35.585399999999993},0.44999999999998863,null,{"$f":"IF(B25>0,0.5*(B24+B25),0)","v":4},{"$f":"IF(B25>0,1440*PI()*P25^2*(E24-E25+F25-F24)/(B25-B24),NA())","v":0.39825341751013515},{"$f":"0.5*(J24+J25)","v":0.92499999999998295},{"$f":"F25-E25","v":6.9999999999993179E-2},{"$f":"IF(B25>0,re(B$10,E25,F25,B$6,B$14,B$13), )","v":0.10278132126023679},null,null,{"$f":"(E24+E25)/2","v":36.044999999999987},{"$f":"(F24+F25)/2","v":36.089999999999989},{"$f":"U24+M25*(B25-B24)*7.48/1440","v":1.2412231512399213E-2},0]
[null,15,35.24,35.4,35.430000000000007,35.590000000000003,null,null,35.465200000000003,0.31000000000000227,null,{"$f":"IF(B26>0,0.5*(B25+B26),0)","v":11},{"$f":"IF(B26>0,1440*PI()*P26^2*(E25-E26+F26-F25)/(B26-B25),NA())","v":0.53764211363888614},{"$f":"0.5*(J25+J26)","v":0.37999999999999545},{"$f":"F26-E26","v":0.15999999999999659},{"$f":"IF(B26>0,re(B$10,E26,F26,B$6,B$14,B$13), )","v":0.10278132126023679},null,null,{"$f":"(E25+E26)/2","v":35.5},35.614999999999995,{"$f":"U25+M26*(B26-B25)*7.48/1440","v":3.4754248234726261E-2},{"$f":"IF(P26>0,V25+0.5*(P25+P26)*(L26-L25),0)","v":0.71946924882165753}]
[null,61,35.21,35.42,35.400000000000006,35.610000000000014,null,null,35.446200000000005,0.28000000000000114,null,38,5.1946097936134111E-2,0.29500000000000171,0.21000000000000796,{"$f":"IF(B27>0,re(B$10,E27,F27,B$6,B$14,B$13), )","v":0.10278132126023679},null,null,35.415000000000006,35.600000000000009,4.7166479747132534E-2,{"$f":"IF(P27>0,V26+0.5*(P26+P27)*(L27-L26),0)","v":3.4945649228480509}]
[null,121,35.19,35.44,35.379999999999995,35.629999999999995,null,null,35.434999999999995,0.25999999999999091,null,91,3.1860273400815341E-2,0.26999999999999602,0.25,{"$f":"IF(B28>0,re(B$10,E28,F28,B$6,B$14,B$13), )","v":0.10278132126023679},null,null,35.39,35.620000000000005,5.7096264957053319E-2,8.9419749496406009]
[null,301,35.17,35.479999999999997,35.360000000000014,35.669999999999987,null,null,35.428200000000011,0.24000000000000909,null,211,1.5930136700403899E-2,0.25,0.30999999999997385,{"$f":"IF(B29>0,re(B$10,E29,F29,B$6,B$14,B$13), )","v":0.10278132126023679},null,null,35.370000000000005,35.649999999999991,7.1990942771930966E-2,21.275733500869016]
[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(B30>0,re(B$10,E30,F30,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(B31>0,re(B$10,E31,F31,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(B32>0,re(B$10,E32,F32,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(B33>0,re(B$10,E33,F33,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(B34>0,re(B$10,E34,F34,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(B35>0,re(B$10,E35,F35,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(B36>0,re(B$10,E36,F36,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(B37>0,re(B$10,E37,F37,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(B38>0,re(B$10,E38,F38,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(B39>0,re(B$10,E39,F39,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(B40>0,re(B$10,E40,F40,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(B41>0,re(B$10,E41,F41,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(B42>0,re(B$10,E42,F42,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(B43>0,re(B$10,E43,F43,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,{"$f":"E44+(1-B$9)*(F44-E44)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,0,{"$error":"#N/A"},{"$f":"0.5*(J43+J44)","v":{"$error":"#N/A"}},{"$f":"F44-E44","v":{"$error":"#N/A"}},{"$f":"IF(B44>0,re(B$10,E44,F44,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(B45>0,re(B$10,E45,F45,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,{"$f":"E46+(1-B$9)*(F46-E46)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,0,{"$error":"#N/A"},{"$f":"0.5*(J45+J46)","v":{"$error":"#N/A"}},{"$f":"F46-E46","v":{"$error":"#N/A"}},{"$f":"IF(B46>0,re(B$10,E46,F46,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,{"$f":"E47+(1-B$9)*(F47-E47)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,0,{"$error":"#N/A"},{"$f":"0.5*(J46+J47)","v":{"$error":"#N/A"}},{"$f":"F47-E47","v":{"$error":"#N/A"}},{"$f":"IF(B47>0,re(B$10,E47,F47,B$6,B$14,B$13), )","v":0},null,null,{"$f":"(E46+E47)/2","v":{"$error":"#N/A"}},{"$f":"(F46+F47)/2","v":{"$error":"#N/A"}},{"$f":"U46+M47*(B47-B46)*7.48/1440","v":{"$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(B48>0,re(B$10,E48,F48,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(B49>0,re(B$10,E49,F49,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(B50>0,re(B$10,E50,F50,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(B51>0,re(B$10,E51,F51,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(B52>0,re(B$10,E52,F52,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(B53>0,re(B$10,E53,F53,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(B54>0,re(B$10,E54,F54,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(B55>0,re(B$10,E55,F55,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"},{"$f":"E56-E$22-E$7","v":{"$error":"#N/A"}},null,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(B56>0,re(B$10,E56,F56,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(B57>0,re(B$10,E57,F57,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(B58>0,re(B$10,E58,F58,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(B59>0,re(B$10,E59,F59,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(B60>0,re(B$10,E60,F60,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(B61>0,re(B$10,E61,F61,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(B62>0,re(B$10,E62,F62,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(B63>0,re(B$10,E63,F63,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(B64>0,re(B$10,E64,F64,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(B65>0,re(B$10,E65,F65,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(B66>0,re(B$10,E66,F66,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(B67>0,re(B$10,E67,F67,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(B68>0,re(B$10,E68,F68,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(B69>0,re(B$10,E69,F69,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(B70>0,re(B$10,E70,F70,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(B71>0,re(B$10,E71,F71,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(B72>0,re(B$10,E72,F72,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(B73>0,re(B$10,E73,F73,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(B74>0,re(B$10,E74,F74,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(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,{"$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(B82>0,re(B$10,E82,F82,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(P25:P82)","v":8.8604587293307571E-3}]

{"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!B24:B82)","v":0.8},{"$f":"Data!E22","v":35.120000000000005}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(Data!B24:B82)","v":301},{"$f":"U3","v":35.120000000000005}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T3","v":0.8},{"$f":"Data!F22","v":36.490000000000009}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T4","v":301},{"$f":"U5","v":36.490000000000009}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T4/4","v":75.25},{"$f":"IF(V8<V9,V8,NA())","v":34.120000000000005},{"$f":"IF(Data!B10>Data!E22,Data!B10,Data!E22-1)","v":34.120000000000005}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T8","v":75.25},{"$f":"IF(V8<V9,V9,NA())","v":37.490000000000009},{"$f":"IF(Data!B11<Data!F22,Data!B11,Data!F22+1)","v":37.490000000000009}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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.22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35,0]
[null,0.55000000000000004,0.97,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.18]
[]
[]
[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":-0.51428571428571435}]
[null,"Dsn (ft)",0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":32,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["Generalized Bouwer and Rice (1976)"]
["Well Designation:",null,{"$f":"IF(Data!B1 > 0,Data!B1,\"\")","v":"MW16"}]
["Date:",null,{"$f":"IF(Data!B2 > 0,Data!B2,\"\")","v":"2021-11-09"},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,"Zfactor"]
[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":470},null,"t (min)","s/s0",null,"Xi","Yi",null,"t (min)","Tn_a (ft2/day)","Tn_b(ft2/day)"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B24>=D$9,Data!B24-D$9,0)","v":0},{"$f":"IF(S6>0,LN(Data!J24),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!B24>'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":-5.2183386609225728},null,0,{"$f":"EXP(-2*E$12*(X6/1440)*(-J$15)/(Data!V$24^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!B25>=D$9,Data!B25-D$9,0)","v":0},{"$f":"IF(S7>0,LN(Data!J25),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!B25>'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":102412},null,{"$f":"X6+1.05*(MAX(M$6:M$64)/30)","v":10.290000000000001},{"$f":"EXP(-2*E$12*(X7/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.99172743080641779},null,{"$f":"IF(S7>0,M7,NA())","v":{"$error":"#N/A"}},{"$f":"IF(T7>0,N7,NA())","v":{"$error":"#N/A"}},null,{"$f":"IF($D$9<Data!B25,(Data!B26+Data!B24)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B25,LN('B&R'!$J$12)/(2*PI()*Data!N25/Data!M25),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B25,LN('B&R'!$J$12)/(2*PI()*(Data!N25-Data!N26)/(Data!M25-Data!M26)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!E22<Data!B10,(Data!F22-Data!B10)/Data!B13,(Data!F22-Data!E22)/Data!B13)","v":13.329270174794097},null,null,{"$f":"IF(Data!B26>=D$9,Data!B26-D$9,0)","v":8},{"$f":"IF(S8>0,LN(Data!J26),0)","v":-1.1711829815029378},64,-9.3694638520235021,2.0253443377086138E-3,0.91268585887160936,{"$f":"IF(Data!B26>'B&R'!D$9,1,0)","v":1},1.0392980515329824,"SXY",{"$f":"SUM(P6:P64)","v":-651.2482147723083},null,{"$f":"X7+1.05*(MAX(M$6:M$64)/30)","v":20.580000000000002},{"$f":"EXP(-2*E$12*(X8/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.98352329701389829},null,8,-1.1711829815029378,null,{"$f":"IF($D$9<Data!B26,(Data!B27+Data!B25)/2,NA())","v":34},{"$f":"IF($D$9<Data!B26,LN('B&R'!$J$12)/(2*PI()*Data!N26/Data!M26),NA())","v":0.42967416905310429},{"$f":"IF($D$9<Data!B26,LN('B&R'!$J$12)/(2*PI()*(Data!N26-Data!N27)/(Data!M26-Data!M27)),NA())","v":1.7353024412000482}]
[null,null,"Timecut",7,"<-  Enter or change value here",null,null,null,null,"C",null,null,{"$f":"IF(Data!B27>=D$9,Data!B27-D$9,0)","v":54},{"$f":"IF(S9>0,LN(Data!J27),0)","v":-1.2729656758128833},2916,-68.740146493895693,3.8587476541898272E-4,-0.3983777512615454,{"$f":"IF(Data!B27>'B&R'!D$9,1,0)","v":1},0.93872082073946495,"N",{"$f":"SUM(S6:S64)","v":4},null,30.870000000000005,{"$f":"EXP(-2*E$12*(X9/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.97538703248585079},null,54,-1.2729656758128833,null,{"$f":"IF($D$9<Data!B27,(Data!B28+Data!B26)/2,NA())","v":68},{"$f":"IF($D$9<Data!B27,LN('B&R'!$J$12)/(2*PI()*Data!N27/Data!M27),NA())","v":5.3476192332828187E-2},{"$f":"IF($D$9<Data!B27,LN('B&R'!$J$12)/(2*PI()*(Data!N27-Data!N28)/(Data!M27-Data!M28)),NA())","v":0.24399404021736162}]
[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":1.3243288184901834},null,null,{"$f":"IF(Data!B28>=D$9,Data!B28-D$9,0)","v":114},{"$f":"IF(S10>0,LN(Data!J28),0)","v":-1.3470736479666443},12996,-153.56639586819745,2.0534025547858637E-3,-0.9189860851917262,{"$f":"IF(Data!B28>'B&R'!D$9,1,0)","v":1},0.87166933354375487,"D",{"$f":"V9*V7-V5^2","v":188748},null,41.160000000000004,{"$f":"EXP(-2*E$12*(X10/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.96731807576908879},null,114,-1.3470736479666443,null,{"$f":"IF($D$9<Data!B28,(Data!B29+Data!B27)/2,NA())","v":181},{"$f":"IF($D$9<Data!B28,LN('B&R'!$J$12)/(2*PI()*Data!N28/Data!M28),NA())","v":3.5835650862033781E-2},{"$f":"IF($D$9<Data!B28,LN('B&R'!$J$12)/(2*PI()*(Data!N28-Data!N29)/(Data!M28-Data!M29)),NA())","v":0.24189064331882984}]
[null,null,null,null,null,null,null,null,null,"R/re",null,null,{"$f":"IF(Data!B29>=D$9,Data!B29-D$9,0)","v":294},{"$f":"IF(S11>0,LN(Data!J29),0)","v":-1.4271163556401079},86436,-419.57220855819173,3.9817626517061065E-4,0.40467797758164764,{"$f":"IF(Data!B29>'B&R'!D$9,1,0)","v":1},0.80461784634814004,"A",{"$f":"(V7*V6-V5*V8)/V10","v":-1.2097285163255644},null,51.45,{"$f":"EXP(-2*E$12*(X11/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.95931587005508623},null,294,-1.4271163556401079,null,{"$f":"IF($D$9<Data!B29,(Data!B30+Data!B28)/2,NA())","v":60.5},{"$f":"IF($D$9<Data!B29,LN('B&R'!$J$12)/(2*PI()*Data!N29/Data!M29),NA())","v":1.9351251465493376E-2},{"$f":"IF($D$9<Data!B29,LN('B&R'!$J$12)/(2*PI()*(Data!N29-Data!N30)/(Data!M29-Data!M30)),NA())","v":{"$error":"#N/A"}}]
[null,"Model Results:",null,"Tn (ft2/d) =",{"$f":"1440*V22*(-V12)","v":2.2782085697834811E-2},"+/-",{"$f":"1440*V22*SQRT(V15)","v":6.4059388557498676E-3},"ft2/d",null,{"$f":"EXP(((1.1/LN(J8))+J10/J8)^-1)","v":6.7405158957944886},null,null,{"$f":"IF(Data!B30>=D$9,Data!B30-D$9,0)","v":0},{"$f":"IF(S12>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"},"B",{"$f":"(V9*V8-V5*V6)/V10","v":-8.0728637366024418E-4},null,61.74,{"$f":"EXP(-2*E$12*(X12/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.95137986314155409},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B30,(Data!B31+Data!B29)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B30,LN('B&R'!$J$12)/(2*PI()*Data!N30/Data!M30),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B30,LN('B&R'!$J$12)/(2*PI()*(Data!N30-Data!N31)/(Data!M30-Data!M31)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B31>=D$9,Data!B31-D$9,0)","v":0},{"$f":"IF(S13>0,LN(Data!J31),0)","v":0},{"$f":"M13^2","v":0},{"$f":"M13*N13","v":0},{"$f":"IF(M13>0,(N13-V$11-V$12*M13)^2,0)","v":0},{"$f":"IF(M13>0,(N13-V$11-V$12*M13)/SQRT(V$14),0)","v":0},{"$f":"IF(Data!B31>'B&R'!D$9,1,0)","v":0},{"$f":"IF(S13=0,NA(),EXP(N13)/EXP(V$19))","v":{"$error":"#N/A"}},null,null,null,72.03,{"$f":"EXP(-2*E$12*(X13/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.94350950739433481},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B31,(Data!B32+Data!B30)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B31,LN('B&R'!$J$12)/(2*PI()*Data!N31/Data!M31),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B31,LN('B&R'!$J$12)/(2*PI()*(Data!N31-Data!N32)/(Data!M31-Data!M32)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,"J-Ratio",null,null,{"$f":"IF(Data!B32>=D$9,Data!B32-D$9,0)","v":0},{"$f":"IF(S14>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"},"sy2",{"$f":"SUM(Q6:Q64)/(V9-2)","v":2.4313989615420352E-3},null,82.320000000000007,{"$f":"EXP(-2*E$12*(X14/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.93570425970961257},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B32,(Data!B33+Data!B31)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B32,LN('B&R'!$J$12)/(2*PI()*Data!N32/Data!M32),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B32,LN('B&R'!$J$12)/(2*PI()*(Data!N32-Data!N33)/(Data!M32-Data!M33)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"Figures!U27","v":-0.51428571428571435},null,null,{"$f":"IF(Data!B33>=D$9,Data!B33-D$9,0)","v":0},{"$f":"IF(S15>0,LN(Data!J33),0)","v":0},{"$f":"M15^2","v":0},{"$f":"M15*N15","v":0},{"$f":"IF(M15>0,(N15-V$11-V$12*M15)^2,0)","v":0},{"$f":"IF(M15>0,(N15-V$11-V$12*M15)/SQRT(V$14),0)","v":0},{"$f":"IF(Data!B33>'B&R'!D$9,1,0)","v":0},{"$f":"IF(S15=0,NA(),EXP(N15)/EXP(V$19))","v":{"$error":"#N/A"}},"sB2",{"$f":"V9*V14/V10","v":5.1526881589040099E-8},null,92.610000000000014,{"$f":"EXP(-2*E$12*(X15/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.92796358147643521},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B33,(Data!B34+Data!B32)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B33,LN('B&R'!$J$12)/(2*PI()*Data!N33/Data!M33),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B33,LN('B&R'!$J$12)/(2*PI()*(Data!N33-Data!N34)/(Data!M33-Data!M34)),NA())","v":{"$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(S16>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,102.90000000000002,{"$f":"EXP(-2*E$12*(X16/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.92028693853954713},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B34,(Data!B35+Data!B33)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B34,LN('B&R'!$J$12)/(2*PI()*Data!N34/Data!M34),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B34,LN('B&R'!$J$12)/(2*PI()*(Data!N34-Data!N35)/(Data!M34-Data!M35)),NA())","v":{"$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(S17>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"},null,null,null,113.19000000000003,{"$f":"EXP(-2*E$12*(X17/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.91267380116252872},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B35,(Data!B36+Data!B34)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B35,LN('B&R'!$J$12)/(2*PI()*Data!N35/Data!M35),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B35,LN('B&R'!$J$12)/(2*PI()*(Data!N35-Data!N36)/(Data!M35-Data!M36)),NA())","v":{"$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(S18>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"},"Plot Model Line",null,null,123.48000000000003,{"$f":"EXP(-2*E$12*(X18/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.90512364399124212},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B36,(Data!B37+Data!B35)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B36,LN('B&R'!$J$12)/(2*PI()*Data!N36/Data!M36),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B36,LN('B&R'!$J$12)/(2*PI()*(Data!N36-Data!N37)/(Data!M36-Data!M37)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B37>=D$9,Data!B37-D$9,0)","v":0},{"$f":"IF(S19>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"},0,{"$f":"V11","v":-1.2097285163255644},null,133.77000000000004,{"$f":"EXP(-2*E$12*(X19/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.89763594601757735},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B37,(Data!B38+Data!B36)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B37,LN('B&R'!$J$12)/(2*PI()*Data!N37/Data!M37),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B37,LN('B&R'!$J$12)/(2*PI()*(Data!N37-Data!N38)/(Data!M37-Data!M38)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,"Coef. Of",null,null,{"$f":"IF(Data!B38>=D$9,Data!B38-D$9,0)","v":0},{"$f":"IF(S20>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"},{"$f":"MAX(M6:M64)","v":294},{"$f":"V11+V12*U20","v":-1.4470707101816762},null,144.06000000000003,{"$f":"EXP(-2*E$12*(X20/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.89021019054350037},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B38,(Data!B39+Data!B37)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B38,LN('B&R'!$J$12)/(2*PI()*Data!N38/Data!M38),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B38,LN('B&R'!$J$12)/(2*PI()*(Data!N38-Data!N39)/(Data!M38-Data!M39)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,"Variation",null,null,{"$f":"IF(Data!B39>=D$9,Data!B39-D$9,0)","v":0},{"$f":"IF(S21>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"},null,null,null,154.35000000000002,{"$f":"EXP(-2*E$12*(X21/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.88284586514539731},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B39,(Data!B40+Data!B38)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B39,LN('B&R'!$J$12)/(2*PI()*Data!N39/Data!M39),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B39,LN('B&R'!$J$12)/(2*PI()*(Data!N39-Data!N40)/(Data!M39-Data!M40)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"G12/E12","v":0.28118316034421215},null,null,{"$f":"IF(Data!B40>=D$9,Data!B40-D$9,0)","v":0},{"$f":"IF(S22>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"},"factor",{"$f":"Data!V24^2*LN('B&R'!J12)/(2*(-Figures!U27))","v":1.9597621565178337E-2},null,164.64000000000001,{"$f":"EXP(-2*E$12*(X22/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.87554246163871408},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B40,(Data!B41+Data!B39)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B40,LN('B&R'!$J$12)/(2*PI()*Data!N40/Data!M40),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B40,LN('B&R'!$J$12)/(2*PI()*(Data!N40-Data!N41)/(Data!M40-Data!M41)),NA())","v":{"$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(S23>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,174.93,{"$f":"EXP(-2*E$12*(X23/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.8682994760428886},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B41,(Data!B42+Data!B40)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B41,LN('B&R'!$J$12)/(2*PI()*Data!N41/Data!M41),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B41,LN('B&R'!$J$12)/(2*PI()*(Data!N41-Data!N42)/(Data!M41-Data!M42)),NA())","v":{"$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(S24>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"},null,null,null,185.22,{"$f":"EXP(-2*E$12*(X24/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.86111640854657268},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B42,(Data!B43+Data!B41)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B42,LN('B&R'!$J$12)/(2*PI()*Data!N42/Data!M42),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B42,LN('B&R'!$J$12)/(2*PI()*(Data!N42-Data!N43)/(Data!M42-Data!M43)),NA())","v":{"$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(S25>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"},"s0 (ft)",{"$f":"EXP(V19)","v":0.29827824611308273},null,195.51,{"$f":"EXP(-2*E$12*(X25/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.85399276347314212},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B43,(Data!B44+Data!B42)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B43,LN('B&R'!$J$12)/(2*PI()*Data!N43/Data!M43),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B43,LN('B&R'!$J$12)/(2*PI()*(Data!N43-Data!N44)/(Data!M43-Data!M44)),NA())","v":{"$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(S26>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,205.79999999999998,{"$f":"EXP(-2*E$12*(X26/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.84692804924649212},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B44,(Data!B45+Data!B43)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B44,LN('B&R'!$J$12)/(2*PI()*Data!N44/Data!M44),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B44,LN('B&R'!$J$12)/(2*PI()*(Data!N44-Data!N45)/(Data!M44-Data!M45)),NA())","v":{"$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},{"$f":"IF(S27>0,LN(Data!J45),0)","v":0},0,0,0,0,{"$f":"IF(Data!B45>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,216.08999999999997,{"$f":"EXP(-2*E$12*(X27/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.83992177835711501},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B45,(Data!B46+Data!B44)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B45,LN('B&R'!$J$12)/(2*PI()*Data!N45/Data!M45),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B45,LN('B&R'!$J$12)/(2*PI()*(Data!N45-Data!N46)/(Data!M45-Data!M46)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B46>=D$9,Data!B46-D$9,0)","v":0},{"$f":"IF(S28>0,LN(Data!J46),0)","v":0},0,0,0,0,{"$f":"IF(Data!B46>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,226.37999999999997,{"$f":"EXP(-2*E$12*(X28/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.83297346732845912},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B46,(Data!B47+Data!B45)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B46,LN('B&R'!$J$12)/(2*PI()*Data!N46/Data!M46),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B46,LN('B&R'!$J$12)/(2*PI()*(Data!N46-Data!N47)/(Data!M46-Data!M47)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B47>=D$9,Data!B47-D$9,0)","v":0},{"$f":"IF(S29>0,LN(Data!J47),0)","v":0},0,0,0,0,{"$f":"IF(Data!B47>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,236.66999999999996,{"$f":"EXP(-2*E$12*(X29/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.82608263668356641},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B47,(Data!B48+Data!B46)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B47,LN('B&R'!$J$12)/(2*PI()*Data!N47/Data!M47),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B47,LN('B&R'!$J$12)/(2*PI()*(Data!N47-Data!N48)/(Data!M47-Data!M48)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B48>=D$9,Data!B48-D$9,0)","v":0},{"$f":"IF(S30>0,LN(Data!J48),0)","v":0},0,0,0,0,{"$f":"IF(Data!B48>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,246.95999999999995,{"$f":"EXP(-2*E$12*(X30/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.81924881091198487},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B48,(Data!B49+Data!B47)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B48,LN('B&R'!$J$12)/(2*PI()*Data!N48/Data!M48),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B48,LN('B&R'!$J$12)/(2*PI()*(Data!N48-Data!N49)/(Data!M48-Data!M49)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B49>=D$9,Data!B49-D$9,0)","v":0},{"$f":"IF(S31>0,LN(Data!J49),0)","v":0},0,0,0,0,{"$f":"IF(Data!B49>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,257.24999999999994,{"$f":"EXP(-2*E$12*(X31/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.81247151843695553},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B49,(Data!B50+Data!B48)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B49,LN('B&R'!$J$12)/(2*PI()*Data!N49/Data!M49),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B49,LN('B&R'!$J$12)/(2*PI()*(Data!N49-Data!N50)/(Data!M49-Data!M50)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B50>=D$9,Data!B50-D$9,0)","v":0},{"$f":"IF(S32>0,LN(Data!J50),0)","v":0},0,0,0,0,{"$f":"IF(Data!B50>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,267.53999999999996,{"$f":"EXP(-2*E$12*(X32/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.80575029158287104},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B50,(Data!B51+Data!B49)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B50,LN('B&R'!$J$12)/(2*PI()*Data!N50/Data!M50),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B50,LN('B&R'!$J$12)/(2*PI()*(Data!N50-Data!N51)/(Data!M50-Data!M51)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B51>=D$9,Data!B51-D$9,0)","v":0},{"$f":"IF(S33>0,LN(Data!J51),0)","v":0},0,0,0,0,{"$f":"IF(Data!B51>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,277.83,{"$f":"EXP(-2*E$12*(X33/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.7990846665430027},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B51,(Data!B52+Data!B50)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B51,LN('B&R'!$J$12)/(2*PI()*Data!N51/Data!M51),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B51,LN('B&R'!$J$12)/(2*PI()*(Data!N51-Data!N52)/(Data!M51-Data!M52)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B52>=D$9,Data!B52-D$9,0)","v":0},{"$f":"IF(S34>0,LN(Data!J52),0)","v":0},0,0,0,0,{"$f":"IF(Data!B52>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,288.12,{"$f":"EXP(-2*E$12*(X34/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.7924741833474952},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B52,(Data!B53+Data!B51)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B52,LN('B&R'!$J$12)/(2*PI()*Data!N52/Data!M52),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B52,LN('B&R'!$J$12)/(2*PI()*(Data!N52-Data!N53)/(Data!M52-Data!M53)),NA())","v":{"$error":"#N/A"}}]
[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!B53>=D$9,Data!B53-D$9,0)","v":0},{"$f":"IF(S35>0,LN(Data!J53),0)","v":0},0,0,0,0,{"$f":"IF(Data!B53>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,298.41000000000003,{"$f":"EXP(-2*E$12*(X35/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.78591838583162543},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B53,(Data!B54+Data!B52)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B53,LN('B&R'!$J$12)/(2*PI()*Data!N53/Data!M53),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B53,LN('B&R'!$J$12)/(2*PI()*(Data!N53-Data!N54)/(Data!M53-Data!M54)),NA())","v":{"$error":"#N/A"}}]
[null,"Analysis of Slug Tests, CRC Press, 2000.",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B54>=D$9,Data!B54-D$9,0)","v":0},{"$f":"IF(S36>0,LN(Data!J54),0)","v":0},0,0,0,0,{"$f":"IF(Data!B54>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,308.70000000000005,{"$f":"EXP(-2*E$12*(X36/1440)*(-J$15)/(Data!V$24^2*LN('B&R'!J$12)))","v":0.77941682160432502},null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B54,(Data!B55+Data!B53)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B54,LN('B&R'!$J$12)/(2*PI()*Data!N54/Data!M54),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B54,LN('B&R'!$J$12)/(2*PI()*(Data!N54-Data!N55)/(Data!M54-Data!M55)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B55>=D$9,Data!B55-D$9,0)","v":0},{"$f":"IF(S37>0,LN(Data!J55),0)","v":0},0,0,0,0,{"$f":"IF(Data!B55>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B55,(Data!B56+Data!B54)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B55,LN('B&R'!$J$12)/(2*PI()*Data!N55/Data!M55),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B55,LN('B&R'!$J$12)/(2*PI()*(Data!N55-Data!N56)/(Data!M55-Data!M56)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B56>=D$9,Data!B56-D$9,0)","v":0},{"$f":"IF(S38>0,LN(Data!J56),0)","v":0},0,0,0,0,{"$f":"IF(Data!B56>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B56,(Data!B57+Data!B55)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B56,LN('B&R'!$J$12)/(2*PI()*Data!N56/Data!M56),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B56,LN('B&R'!$J$12)/(2*PI()*(Data!N56-Data!N57)/(Data!M56-Data!M57)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B57>=D$9,Data!B57-D$9,0)","v":0},{"$f":"IF(S39>0,LN(Data!J57),0)","v":0},0,0,0,0,{"$f":"IF(Data!B57>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,{"$f":"TRUNC(100*E12)/100","v":0.02},null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B57,(Data!B58+Data!B56)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B57,LN('B&R'!$J$12)/(2*PI()*Data!N57/Data!M57),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B57,LN('B&R'!$J$12)/(2*PI()*(Data!N57-Data!N58)/(Data!M57-Data!M58)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B58>=D$9,Data!B58-D$9,0)","v":0},{"$f":"IF(S40>0,LN(Data!J58),0)","v":0},0,0,0,0,{"$f":"IF(Data!B58>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,{"$f":"X39","v":0.02},null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B58,(Data!B59+Data!B57)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B58,LN('B&R'!$J$12)/(2*PI()*Data!N58/Data!M58),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B58,LN('B&R'!$J$12)/(2*PI()*(Data!N58-Data!N59)/(Data!M58-Data!M59)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B59>=D$9,Data!B59-D$9,0)","v":0},{"$f":"IF(S41>0,LN(Data!J59),0)","v":0},0,0,0,0,{"$f":"IF(Data!B59>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,{"$f":"CONCATENATE(\" T = \",X40,\" ft2/d\")","v":" T = 0.02 ft2/d"},null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B59,(Data!B60+Data!B58)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B59,LN('B&R'!$J$12)/(2*PI()*Data!N59/Data!M59),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B59,LN('B&R'!$J$12)/(2*PI()*(Data!N59-Data!N60)/(Data!M59-Data!M60)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B60>=D$9,Data!B60-D$9,0)","v":0},{"$f":"IF(S42>0,LN(Data!J60),0)","v":0},0,0,0,0,{"$f":"IF(Data!B60>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B60,(Data!B61+Data!B59)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B60,LN('B&R'!$J$12)/(2*PI()*Data!N60/Data!M60),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B60,LN('B&R'!$J$12)/(2*PI()*(Data!N60-Data!N61)/(Data!M60-Data!M61)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B61>=D$9,Data!B61-D$9,0)","v":0},{"$f":"IF(S43>0,LN(Data!J61),0)","v":0},0,0,0,0,{"$f":"IF(Data!B61>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B61,(Data!B62+Data!B60)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B61,LN('B&R'!$J$12)/(2*PI()*Data!N61/Data!M61),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B61,LN('B&R'!$J$12)/(2*PI()*(Data!N61-Data!N62)/(Data!M61-Data!M62)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B62>=D$9,Data!B62-D$9,0)","v":0},{"$f":"IF(S44>0,LN(Data!J62),0)","v":0},0,0,0,0,{"$f":"IF(Data!B62>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B62,(Data!B63+Data!B61)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B62,LN('B&R'!$J$12)/(2*PI()*Data!N62/Data!M62),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B62,LN('B&R'!$J$12)/(2*PI()*(Data!N62-Data!N63)/(Data!M62-Data!M63)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B63>=D$9,Data!B63-D$9,0)","v":0},{"$f":"IF(S45>0,LN(Data!J63),0)","v":0},0,0,0,0,{"$f":"IF(Data!B63>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B63,(Data!B64+Data!B62)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B63,LN('B&R'!$J$12)/(2*PI()*Data!N63/Data!M63),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B63,LN('B&R'!$J$12)/(2*PI()*(Data!N63-Data!N64)/(Data!M63-Data!M64)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B64>=D$9,Data!B64-D$9,0)","v":0},{"$f":"IF(S46>0,LN(Data!J64),0)","v":0},0,0,0,0,{"$f":"IF(Data!B64>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B64,(Data!B65+Data!B63)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B64,LN('B&R'!$J$12)/(2*PI()*Data!N64/Data!M64),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B64,LN('B&R'!$J$12)/(2*PI()*(Data!N64-Data!N65)/(Data!M64-Data!M65)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B65>=D$9,Data!B65-D$9,0)","v":0},{"$f":"IF(S47>0,LN(Data!J65),0)","v":0},0,0,0,0,{"$f":"IF(Data!B65>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B65,(Data!B66+Data!B64)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B65,LN('B&R'!$J$12)/(2*PI()*Data!N65/Data!M65),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B65,LN('B&R'!$J$12)/(2*PI()*(Data!N65-Data!N66)/(Data!M65-Data!M66)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B66>=D$9,Data!B66-D$9,0)","v":0},{"$f":"IF(S48>0,LN(Data!J66),0)","v":0},{"$f":"M48^2","v":0},{"$f":"M48*N48","v":0},0,{"$f":"IF(M48>0,(N48-V$11-V$12*M48)/SQRT(V$14),0)","v":0},{"$f":"IF(Data!B66>'B&R'!D$9,1,0)","v":0},{"$f":"IF(S48=0,NA(),EXP(N48)/EXP(V$19))","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B66,(Data!B67+Data!B65)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B66,LN('B&R'!$J$12)/(2*PI()*Data!N66/Data!M66),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B66,LN('B&R'!$J$12)/(2*PI()*(Data!N66-Data!N67)/(Data!M66-Data!M67)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B67>=D$9,Data!B67-D$9,0)","v":0},{"$f":"IF(S49>0,LN(Data!J67),0)","v":0},0,0,0,0,{"$f":"IF(Data!B67>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B67,(Data!B68+Data!B66)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B67,LN('B&R'!$J$12)/(2*PI()*Data!N67/Data!M67),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B67,LN('B&R'!$J$12)/(2*PI()*(Data!N67-Data!N68)/(Data!M67-Data!M68)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B68>=D$9,Data!B68-D$9,0)","v":0},{"$f":"IF(S50>0,LN(Data!J68),0)","v":0},0,0,0,0,{"$f":"IF(Data!B68>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B68,(Data!B69+Data!B67)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B68,LN('B&R'!$J$12)/(2*PI()*Data!N68/Data!M68),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B68,LN('B&R'!$J$12)/(2*PI()*(Data!N68-Data!N69)/(Data!M68-Data!M69)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B69>=D$9,Data!B69-D$9,0)","v":0},{"$f":"IF(S51>0,LN(Data!J69),0)","v":0},0,0,0,0,{"$f":"IF(Data!B69>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B69,(Data!B70+Data!B68)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B69,LN('B&R'!$J$12)/(2*PI()*Data!N69/Data!M69),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B69,LN('B&R'!$J$12)/(2*PI()*(Data!N69-Data!N70)/(Data!M69-Data!M70)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B70>=D$9,Data!B70-D$9,0)","v":0},{"$f":"IF(S52>0,LN(Data!J70),0)","v":0},0,0,0,0,{"$f":"IF(Data!B70>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B70,(Data!B71+Data!B69)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B70,LN('B&R'!$J$12)/(2*PI()*Data!N70/Data!M70),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B70,LN('B&R'!$J$12)/(2*PI()*(Data!N70-Data!N71)/(Data!M70-Data!M71)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B71>=D$9,Data!B71-D$9,0)","v":0},{"$f":"IF(S53>0,LN(Data!J71),0)","v":0},0,0,0,0,{"$f":"IF(Data!B71>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B71,(Data!B72+Data!B70)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B71,LN('B&R'!$J$12)/(2*PI()*Data!N71/Data!M71),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B71,LN('B&R'!$J$12)/(2*PI()*(Data!N71-Data!N72)/(Data!M71-Data!M72)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B72>=D$9,Data!B72-D$9,0)","v":0},{"$f":"IF(S54>0,LN(Data!J72),0)","v":0},0,0,0,0,{"$f":"IF(Data!B72>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B72,(Data!B73+Data!B71)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B72,LN('B&R'!$J$12)/(2*PI()*Data!N72/Data!M72),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B72,LN('B&R'!$J$12)/(2*PI()*(Data!N72-Data!N73)/(Data!M72-Data!M73)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B73>=D$9,Data!B73-D$9,0)","v":0},{"$f":"IF(S55>0,LN(Data!J73),0)","v":0},0,0,0,0,{"$f":"IF(Data!B73>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B73,(Data!B74+Data!B72)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B73,LN('B&R'!$J$12)/(2*PI()*Data!N73/Data!M73),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B73,LN('B&R'!$J$12)/(2*PI()*(Data!N73-Data!N74)/(Data!M73-Data!M74)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B74>=D$9,Data!B74-D$9,0)","v":0},{"$f":"IF(S56>0,LN(Data!J74),0)","v":0},0,0,0,0,{"$f":"IF(Data!B74>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B74,(Data!B75+Data!B73)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B74,LN('B&R'!$J$12)/(2*PI()*Data!N74/Data!M74),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B74,LN('B&R'!$J$12)/(2*PI()*(Data!N74-Data!N75)/(Data!M74-Data!M75)),NA())","v":{"$error":"#N/A"}}]
[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(S57>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,{"$f":"IF($D$9<Data!B75,(Data!B76+Data!B74)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B75,LN('B&R'!$J$12)/(2*PI()*Data!N75/Data!M75),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B75,LN('B&R'!$J$12)/(2*PI()*(Data!N75-Data!N76)/(Data!M75-Data!M76)),NA())","v":{"$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(S58>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,{"$f":"IF($D$9<Data!B76,(Data!B77+Data!B75)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B76,LN('B&R'!$J$12)/(2*PI()*Data!N76/Data!M76),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B76,LN('B&R'!$J$12)/(2*PI()*(Data!N76-Data!N77)/(Data!M76-Data!M77)),NA())","v":{"$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(S59>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,{"$f":"IF($D$9<Data!B77,(Data!B78+Data!B76)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B77,LN('B&R'!$J$12)/(2*PI()*Data!N77/Data!M77),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B77,LN('B&R'!$J$12)/(2*PI()*(Data!N77-Data!N78)/(Data!M77-Data!M78)),NA())","v":{"$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(S60>0,LN(Data!J78),0)","v":0},0,0,0,0,{"$f":"IF(Data!B78>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B78,(Data!B79+Data!B77)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B78,LN('B&R'!$J$12)/(2*PI()*Data!N78/Data!M78),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B78,LN('B&R'!$J$12)/(2*PI()*(Data!N78-Data!N79)/(Data!M78-Data!M79)),NA())","v":{"$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(S61>0,LN(Data!J79),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!B79>'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,{"$f":"IF($D$9<Data!B79,(Data!B80+Data!B78)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B79,LN('B&R'!$J$12)/(2*PI()*Data!N79/Data!M79),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B79,LN('B&R'!$J$12)/(2*PI()*(Data!N79-Data!N80)/(Data!M79-Data!M80)),NA())","v":{"$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(S62>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,{"$f":"IF($D$9<Data!B80,(Data!B81+Data!B79)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B80,LN('B&R'!$J$12)/(2*PI()*Data!N80/Data!M80),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B80,LN('B&R'!$J$12)/(2*PI()*(Data!N80-Data!N81)/(Data!M80-Data!M81)),NA())","v":{"$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(S63>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"},null,{"$f":"IF($D$9<Data!B81,(Data!B82+Data!B80)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B81,LN('B&R'!$J$12)/(2*PI()*Data!N81/Data!M81),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B81,LN('B&R'!$J$12)/(2*PI()*(Data!N81-Data!N82)/(Data!M81-Data!M82)),NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B82>=D$9,Data!B82-D$9,0)","v":0},{"$f":"IF(S64>0,LN(Data!J82),0)","v":0},0,0,0,0,{"$f":"IF(Data!B82>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"IF($D$9<Data!B82,(Data!B83+Data!B81)/2,NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B82,LN('B&R'!$J$12)/(2*PI()*Data!N82/Data!M82),NA())","v":{"$error":"#N/A"}},{"$f":"IF($D$9<Data!B82,LN('B&R'!$J$12)/(2*PI()*(Data!N82-Data!N83)/(Data!M82-Data!M83)),NA())","v":{"$error":"#N/A"}}]

{"sheet":"C&J","index":4,"n_rows":66,"n_cols":26,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
["Cooper and Jacob (1946)"]
["Well Designation:",null,{"$f":"IF(Data!B1 > 0,Data!B1,\"\")","v":"MW16"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E10","v":4},{"$f":"E9","v":20},0]
["Date:",null,{"$f":"IF(Data!B2 > 0,Data!B2,\"\")","v":"2021-11-09"},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"MAX(P9:Q58)","v":4.0092043759494378E-2},null,null,null,null,null,{"$f":"W2","v":4},{"$f":"X2","v":20},{"$f":"J50","v":70}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"Q3","v":4.0092043759494378E-2}]
[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":221}]
[]
[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,20,"<-  Enter or change values here",null,null,null,null,null,null,null,1,{"$f":"IF(Data!L25>=E$9,Data!L25-E$10,0)","v":0},{"$f":"IF(O9>0,7.48*Data!M25*(Data!B25-Data!B24)/1440,0)","v":0},{"$f":"IF(O9>0,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)*O9))),0)","v":0},{"$f":"(P9-Q9)^2","v":0},null,{"$f":"Data!L25","v":4},{"$f":"Data!M25/Data!N25","v":0.43054423514610002},null,0,{"$f":"2+(X$5-2)*W9/50","v":2},{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X9/1440)))","v":0.58477254396835854},{"$f":"X9+E$10","v":6}]
[null,"  Time Adjustment (min):",null,null,4,null,null,null,null,null,null,null,null,2,{"$f":"IF(Data!L26>=E$9,Data!L26-E$10,0)","v":0},{"$f":"IF(O10>0,P9+7.48*Data!M26*(Data!B26-Data!B25)/1440,0)","v":0},{"$f":"IF(O10>0,Q9+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)*O10))),0)","v":0},{"$f":"(P10-Q10)^2","v":0},null,{"$f":"Data!L26","v":11},{"$f":"Data!M26/Data!N26","v":1.41484766747077},null,1,{"$f":"2+(X$5-2)*W10/50","v":6.38},{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X10/1440)))","v":0.24888902818022229},{"$f":"X10+E$10","v":10.379999999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(Data!L27>=E$9,Data!L27-E$10,0)","v":34},{"$f":"IF(O11>0,P10+7.48*Data!M27*(Data!B27-Data!B26)/1440,0)","v":1.2412231512406269E-2},{"$f":"IF(O11>0,Q10+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)*O11))),0)","v":9.59477070761992E-3},7.9380853865073444E-6,null,{"$f":"Data!L27","v":38},{"$f":"Data!M27/Data!N27","v":0.17608846758011462},null,2,10.76,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X11/1440)))","v":0.19771955163927799},14.76]
[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!L28>=E$9,Data!L28-E$10,0)","v":87},{"$f":"IF(O12>0,P11+7.48*Data!M28*(Data!B28-Data!B27)/1440,0)","v":2.2342016722327052E-2},{"$f":"IF(O12>0,Q11+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)*O12))),0)","v":1.8725891639498143E-2},1.3076360614664379E-5,null,{"$f":"Data!L28","v":91},{"$f":"Data!M28/Data!N28","v":0.11800101259561412},null,3,15.14,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X12/1440)))","v":0.17430497921318253},19.14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(Data!L29>=E$9,Data!L29-E$10,0)","v":207},{"$f":"IF(O13>0,P12+7.48*Data!M29*(Data!B29-Data!B28)/1440,0)","v":3.7236694537204698E-2},{"$f":"IF(O13>0,Q12+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)*O13))),0)","v":4.0092043759494378E-2},8.15301918123028E-6,null,{"$f":"Data!L29","v":211},{"$f":"Data!M29/Data!N29","v":6.3720546801615596E-2},null,4,19.52,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X13/1440)))","v":0.16019004117390742},23.52]
[null,"Root-Mean-Square Error:",null,null,{"$f":"SQRT(SUM(R9:R58))","v":5.4006911763590047E-3},"<-- Minimize this using \"Solver\"",null,null,null,null,null,null,null,6,{"$f":"IF(Data!L30>=E$9,Data!L30-E$10,0)","v":0},{"$f":"IF(O14>0,P13+7.48*Data!M30*(Data!B30-Data!B29)/1440,0)","v":0},{"$f":"IF(O14>0,Q13+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)*O14))),0)","v":0},0,null,{"$f":"Data!L30","v":0},{"$f":"Data!M30/Data!N30","v":{"$error":"#N/A"}},null,5,23.9,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X14/1440)))","v":0.15048173700260956},27.9]
[null,null,null,null,{"$f":"IF(E12=\"d\",0.025*SQRT(E16),E12)","v":5.000000000000001E-3},"<-- Working Sn",null,null,null,null,null,null,null,7,{"$f":"IF(Data!L31>=E$9,Data!L31-E$10,0)","v":0},{"$f":"IF(O15>0,P14+7.48*Data!M31*(Data!B31-Data!B30)/1440,0)","v":0},{"$f":"IF(O15>0,Q14+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)*O15))),0)","v":0},0,null,{"$f":"Data!L31","v":0},{"$f":"Data!M31/Data!N31","v":{"$error":"#N/A"}},null,6,28.28,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X15/1440)))","v":0.14326442519981861},32.28]
[null,"Trial Tn (ft2/d):",null,null,0.04,"<-- By changing Tn through \"Solver\"",null,null,null,null,null,null,null,8,{"$f":"IF(Data!L32>=E$9,Data!L32-E$10,0)","v":0},{"$f":"IF(O16>0,P15+7.48*Data!M32*(Data!B32-Data!B31)/1440,0)","v":0},{"$f":"IF(O16>0,Q15+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)*O16))),0)","v":0},0,null,{"$f":"Data!L32","v":0},{"$f":"Data!M32/Data!N32","v":{"$error":"#N/A"}},null,7,32.659999999999997,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X16/1440)))","v":0.13761648438632451},36.659999999999997]
[null,null,null,null,null,null,"Add constraint Tn > 0.00001",null,null,null,null,null,null,9,{"$f":"IF(Data!L33>=E$9,Data!L33-E$10,0)","v":0},{"$f":"IF(O17>0,P16+7.48*Data!M33*(Data!B33-Data!B32)/1440,0)","v":0},{"$f":"IF(O17>0,Q16+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)*O17))),0)","v":0},0,null,{"$f":"Data!L33","v":0},{"$f":"Data!M33/Data!N33","v":{"$error":"#N/A"}},null,8,37.04,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X17/1440)))","v":0.13303291622416258},41.04]
[null,"Model Result:",null,"Tn (ft2/d) =",{"$f":"E16","v":0.04},null,null,null,null,null,null,null,null,10,{"$f":"IF(Data!L34>=E$9,Data!L34-E$10,0)","v":0},{"$f":"IF(O18>0,P17+7.48*Data!M34*(Data!B34-Data!B33)/1440,0)","v":0},{"$f":"IF(O18>0,Q17+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)*O18))),0)","v":0},0,null,{"$f":"Data!L34","v":0},{"$f":"Data!M34/Data!N34","v":{"$error":"#N/A"}},null,9,41.42,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X18/1440)))","v":0.12921087061705874},45.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"IF(Data!L35>=E$9,Data!L35-E$10,0)","v":0},{"$f":"IF(O19>0,P18+7.48*Data!M35*(Data!B35-Data!B34)/1440,0)","v":0},{"$f":"IF(O19>0,Q18+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)*O19))),0)","v":0},0,null,{"$f":"Data!L35","v":0},{"$f":"Data!M35/Data!N35","v":{"$error":"#N/A"}},null,10,45.8,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X19/1440)))","v":0.12595623506587622},49.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,12,{"$f":"IF(Data!L36>=E$9,Data!L36-E$10,0)","v":0},{"$f":"IF(O20>0,P19+7.48*Data!M36*(Data!B36-Data!B35)/1440,0)","v":0},{"$f":"IF(O20>0,Q19+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)*O20))),0)","v":0},0,null,{"$f":"Data!L36","v":0},{"$f":"Data!M36/Data!N36","v":{"$error":"#N/A"}},null,11,50.18,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X20/1440)))","v":0.12313806468596013},54.18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,13,{"$f":"IF(Data!L37>=E$9,Data!L37-E$10,0)","v":0},{"$f":"IF(O21>0,P20+7.48*Data!M37*(Data!B37-Data!B36)/1440,0)","v":0},{"$f":"IF(O21>0,Q20+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)*O21))),0)","v":0},0,null,{"$f":"Data!L37","v":0},{"$f":"Data!M37/Data!N37","v":{"$error":"#N/A"}},null,12,54.56,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X21/1440)))","v":0.12066436829551576},58.56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,14,{"$f":"IF(Data!L38>=E$9,Data!L38-E$10,0)","v":0},{"$f":"IF(O22>0,P21+7.48*Data!M38*(Data!B38-Data!B37)/1440,0)","v":0},{"$f":"IF(O22>0,Q21+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)*O22))),0)","v":0},0,null,{"$f":"Data!L38","v":0},{"$f":"Data!M38/Data!N38","v":{"$error":"#N/A"}},null,13,58.94,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X22/1440)))","v":0.11846835226679504},62.94]
[null,null,null,null,null,null,null,null,null,null,null,null,null,15,{"$f":"IF(Data!L39>=E$9,Data!L39-E$10,0)","v":0},{"$f":"IF(O23>0,P22+7.48*Data!M39*(Data!B39-Data!B38)/1440,0)","v":0},{"$f":"IF(O23>0,Q22+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)*O23))),0)","v":0},0,null,{"$f":"Data!L39","v":0},{"$f":"Data!M39/Data!N39","v":{"$error":"#N/A"}},null,14,63.32,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X23/1440)))","v":0.11650017287882225},67.319999999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,16,{"$f":"IF(Data!L40>=E$9,Data!L40-E$10,0)","v":0},{"$f":"IF(O24>0,P23+7.48*Data!M40*(Data!B40-Data!B39)/1440,0)","v":0},{"$f":"IF(O24>0,Q23+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)*O24))),0)","v":0},0,null,{"$f":"Data!L40","v":0},{"$f":"Data!M40/Data!N40","v":{"$error":"#N/A"}},null,15,67.7,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X24/1440)))","v":0.11472176687738866},71.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"IF(Data!L41>=E$9,Data!L41-E$10,0)","v":0},{"$f":"IF(O25>0,P24+7.48*Data!M41*(Data!B41-Data!B40)/1440,0)","v":0},{"$f":"IF(O25>0,Q24+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)*O25))),0)","v":0},0,null,{"$f":"Data!L41","v":0},{"$f":"Data!M41/Data!N41","v":{"$error":"#N/A"}},null,16,72.08,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X25/1440)))","v":0.11310348845282797},76.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,18,{"$f":"IF(Data!L42>=E$9,Data!L42-E$10,0)","v":0},{"$f":"IF(O26>0,P25+7.48*Data!M42*(Data!B42-Data!B41)/1440,0)","v":0},{"$f":"IF(O26>0,Q25+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)*O26))),0)","v":0},0,null,{"$f":"Data!L42","v":0},{"$f":"Data!M42/Data!N42","v":{"$error":"#N/A"}},null,17,76.459999999999994,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X26/1440)))","v":0.11162185092630256},80.459999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,19,{"$f":"IF(Data!L43>=E$9,Data!L43-E$10,0)","v":0},{"$f":"IF(O27>0,P26+7.48*Data!M43*(Data!B43-Data!B42)/1440,0)","v":0},{"$f":"IF(O27>0,Q26+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)*O27))),0)","v":0},0,null,{"$f":"Data!L43","v":0},{"$f":"Data!M43/Data!N43","v":{"$error":"#N/A"}},null,18,80.84,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X27/1440)))","v":0.11025796825145127},84.84]
[null,null,null,null,null,null,null,null,null,null,null,null,null,20,{"$f":"IF(Data!L44>=E$9,Data!L44-E$10,0)","v":0},{"$f":"IF(O28>0,P27+7.48*Data!M44*(Data!B44-Data!B43)/1440,0)","v":0},{"$f":"IF(O28>0,Q27+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)*O28))),0)","v":0},0,null,{"$f":"Data!L44","v":0},{"$f":"Data!M44/Data!N44","v":{"$error":"#N/A"}},null,19,85.22,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X28/1440)))","v":0.10899645356059331},89.22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,21,{"$f":"IF(Data!L45>=E$9,Data!L45-E$10,0)","v":0},{"$f":"IF(O29>0,P28+7.48*Data!M45*(Data!B45-Data!B44)/1440,0)","v":0},{"$f":"IF(O29>0,Q28+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)*O29))),0)","v":0},0,null,{"$f":"Data!L45","v":0},{"$f":"Data!M45/Data!N45","v":{"$error":"#N/A"}},null,20,89.6,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X29/1440)))","v":0.10782462426181062},93.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,22,{"$f":"IF(Data!L46>=E$9,Data!L46-E$10,0)","v":0},{"$f":"IF(O30>0,P29+7.48*Data!M46*(Data!B46-Data!B45)/1440,0)","v":0},{"$f":"IF(O30>0,Q29+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)*O30))),0)","v":0},0,null,{"$f":"Data!L46","v":0},{"$f":"Data!M46/Data!N46","v":{"$error":"#N/A"}},null,21,93.98,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X30/1440)))","v":0.10673191763281142},97.98]
[null,null,null,null,null,null,null,null,null,null,null,null,null,23,{"$f":"IF(Data!L47>=E$9,Data!L47-E$10,0)","v":0},{"$f":"IF(O31>0,P30+7.48*Data!M47*(Data!B47-Data!B46)/1440,0)","v":0},{"$f":"IF(O31>0,Q30+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)*O31))),0)","v":0},0,null,{"$f":"Data!L47","v":0},{"$f":"Data!M47/Data!N47","v":{"$error":"#N/A"}},null,22,98.36,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X31/1440)))","v":0.10570945400205466},102.36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,24,{"$f":"IF(Data!L48>=E$9,Data!L48-E$10,0)","v":0},{"$f":"IF(O32>0,P31+7.48*Data!M48*(Data!B48-Data!B47)/1440,0)","v":0},{"$f":"IF(O32>0,Q31+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)*O32))),0)","v":0},0,null,{"$f":"Data!L48","v":0},{"$f":"Data!M48/Data!N48","v":{"$error":"#N/A"}},null,23,102.74,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X32/1440)))","v":0.10474970535795641},106.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,25,{"$f":"IF(Data!L49>=E$9,Data!L49-E$10,0)","v":0},{"$f":"IF(O33>0,P32+7.48*Data!M49*(Data!B49-Data!B48)/1440,0)","v":0},{"$f":"IF(O33>0,Q32+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)*O33))),0)","v":0},0,null,{"$f":"Data!L49","v":0},{"$f":"Data!M49/Data!N49","v":{"$error":"#N/A"}},null,24,107.12,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X33/1440)))","v":0.10384624054527436},111.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,26,{"$f":"IF(Data!L50>=E$9,Data!L50-E$10,0)","v":0},{"$f":"IF(O34>0,P33+7.48*Data!M50*(Data!B50-Data!B49)/1440,0)","v":0},{"$f":"IF(O34>0,Q33+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)*O34))),0)","v":0},0,null,{"$f":"Data!L50","v":0},{"$f":"Data!M50/Data!N50","v":{"$error":"#N/A"}},null,25,111.5,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X34/1440)))","v":0.10299352694910945},115.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,27,{"$f":"IF(Data!L51>=E$9,Data!L51-E$10,0)","v":0},{"$f":"IF(O35>0,P34+7.48*Data!M51*(Data!B51-Data!B50)/1440,0)","v":0},{"$f":"IF(O35>0,Q34+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)*O35))),0)","v":0},0,null,{"$f":"Data!L51","v":0},{"$f":"Data!M51/Data!N51","v":{"$error":"#N/A"}},null,26,115.88,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X35/1440)))","v":0.10218677442127599},119.88]
[null,null,null,null,null,null,null,null,null,null,null,null,null,28,{"$f":"IF(Data!L52>=E$9,Data!L52-E$10,0)","v":0},{"$f":"IF(O36>0,P35+7.48*Data!M52*(Data!B52-Data!B51)/1440,0)","v":0},{"$f":"IF(O36>0,Q35+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)*O36))),0)","v":0},0,null,{"$f":"Data!L52","v":0},{"$f":"Data!M52/Data!N52","v":{"$error":"#N/A"}},null,27,120.26,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X36/1440)))","v":0.10142181119709626},124.26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,29,{"$f":"IF(Data!L53>=E$9,Data!L53-E$10,0)","v":0},{"$f":"IF(O37>0,P36+7.48*Data!M53*(Data!B53-Data!B52)/1440,0)","v":0},{"$f":"IF(O37>0,Q36+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)*O37))),0)","v":0},0,null,{"$f":"Data!L53","v":0},{"$f":"Data!M53/Data!N53","v":{"$error":"#N/A"}},null,28,124.64,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X37/1440)))","v":0.10069498432046912},128.63999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,30,{"$f":"IF(Data!L54>=E$9,Data!L54-E$10,0)","v":0},{"$f":"IF(O38>0,P37+7.48*Data!M54*(Data!B54-Data!B53)/1440,0)","v":0},{"$f":"IF(O38>0,Q37+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)*O38))),0)","v":0},0,null,{"$f":"Data!L54","v":0},{"$f":"Data!M54/Data!N54","v":{"$error":"#N/A"}},null,29,129.01999999999998,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X38/1440)))","v":0.10000307904584896},133.01999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,31,{"$f":"IF(Data!L55>=E$9,Data!L55-E$10,0)","v":0},{"$f":"IF(O39>0,P38+7.48*Data!M55*(Data!B55-Data!B54)/1440,0)","v":0},{"$f":"IF(O39>0,Q38+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)*O39))),0)","v":0},0,null,{"$f":"Data!L55","v":0},{"$f":"Data!M55/Data!N55","v":{"$error":"#N/A"}},null,30,133.4,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X39/1440)))","v":9.9343253079192409E-2},137.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,32,{"$f":"IF(Data!L56>=E$9,Data!L56-E$10,0)","v":0},{"$f":"IF(O40>0,P39+7.48*Data!M56*(Data!B56-Data!B55)/1440,0)","v":0},{"$f":"IF(O40>0,Q39+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)*O40))),0)","v":0},0,null,{"$f":"Data!L56","v":0},{"$f":"Data!M56/Data!N56","v":{"$error":"#N/A"}},null,31,137.78,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X40/1440)))","v":9.8712982528236293E-2},141.78]
[null,null,null,null,null,null,null,null,null,null,null,null,null,33,{"$f":"IF(Data!L57>=E$9,Data!L57-E$10,0)","v":0},{"$f":"IF(O41>0,P40+7.48*Data!M57*(Data!B57-Data!B56)/1440,0)","v":0},{"$f":"IF(O41>0,Q40+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)*O41))),0)","v":0},0,null,{"$f":"Data!L57","v":0},{"$f":"Data!M57/Data!N57","v":{"$error":"#N/A"}},null,32,142.16,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X41/1440)))","v":9.8110017170916414E-2},146.16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,34,{"$f":"IF(Data!L58>=E$9,Data!L58-E$10,0)","v":0},{"$f":"IF(O42>0,P41+7.48*Data!M58*(Data!B58-Data!B57)/1440,0)","v":0},{"$f":"IF(O42>0,Q41+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)*O42))),0)","v":0},0,null,{"$f":"Data!L58","v":0},{"$f":"Data!M58/Data!N58","v":{"$error":"#N/A"}},null,33,146.54,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X42/1440)))","v":9.7532343197611199E-2},150.54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,35,{"$f":"IF(Data!L59>=E$9,Data!L59-E$10,0)","v":0},{"$f":"IF(O43>0,P42+7.48*Data!M59*(Data!B59-Data!B58)/1440,0)","v":0},{"$f":"IF(O43>0,Q42+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)*O43))),0)","v":0},0,null,{"$f":"Data!L59","v":0},{"$f":"Data!M59/Data!N59","v":{"$error":"#N/A"}},null,34,150.91999999999999,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X43/1440)))","v":9.6978151992118705E-2},154.91999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,36,{"$f":"IF(Data!L60>=E$9,Data!L60-E$10,0)","v":0},{"$f":"IF(O44>0,P43+7.48*Data!M60*(Data!B60-Data!B59)/1440,0)","v":0},{"$f":"IF(O44>0,Q43+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)*O44))),0)","v":0},0,null,{"$f":"Data!L60","v":0},{"$f":"Data!M60/Data!N60","v":{"$error":"#N/A"}},null,35,155.30000000000001,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X44/1440)))","v":9.6445813825477844E-2},159.30000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,37,{"$f":"IF(Data!L61>=E$9,Data!L61-E$10,0)","v":0},{"$f":"IF(O45>0,P44+7.48*Data!M61*(Data!B61-Data!B60)/1440,0)","v":0},{"$f":"IF(O45>0,Q44+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)*O45))),0)","v":0},0,null,{"$f":"Data!L61","v":0},{"$f":"Data!M61/Data!N61","v":{"$error":"#N/A"}},null,36,159.68,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X45/1440)))","v":9.593385557249548E-2},163.68]
[null,null,null,null,null,null,null,null,null,null,null,null,null,38,{"$f":"IF(Data!L62>=E$9,Data!L62-E$10,0)","v":0},{"$f":"IF(O46>0,P45+7.48*Data!M62*(Data!B62-Data!B61)/1440,0)","v":0},{"$f":"IF(O46>0,Q45+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)*O46))),0)","v":0},0,null,{"$f":"Data!L62","v":0},{"$f":"Data!M62/Data!N62","v":{"$error":"#N/A"}},null,37,164.06,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X46/1440)))","v":9.5440941742122323E-2},168.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,39,{"$f":"IF(Data!L63>=E$9,Data!L63-E$10,0)","v":0},{"$f":"IF(O47>0,P46+7.48*Data!M63*(Data!B63-Data!B62)/1440,0)","v":0},{"$f":"IF(O47>0,Q46+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)*O47))),0)","v":0},0,null,{"$f":"Data!L63","v":0},{"$f":"Data!M63/Data!N63","v":{"$error":"#N/A"}},null,38,168.44,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X47/1440)))","v":9.496585825333248E-2},172.44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,40,{"$f":"IF(Data!L64>=E$9,Data!L64-E$10,0)","v":0},{"$f":"IF(O48>0,P47+7.48*Data!M64*(Data!B64-Data!B63)/1440,0)","v":0},{"$f":"IF(O48>0,Q47+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)*O48))),0)","v":0},0,null,{"$f":"Data!L64","v":0},{"$f":"Data!M64/Data!N64","v":{"$error":"#N/A"}},null,39,172.82,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X48/1440)))","v":9.4507498497892764E-2},176.82]
[null,null,null,null,null,null,null,null,null,"Height",null,null,null,41,{"$f":"IF(Data!L65>=E$9,Data!L65-E$10,0)","v":0},{"$f":"IF(O49>0,P48+7.48*Data!M65*(Data!B65-Data!B64)/1440,0)","v":0},{"$f":"IF(O49>0,Q48+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)*O49))),0)","v":0},0,null,{"$f":"Data!L65","v":0},{"$f":"Data!M65/Data!N65","v":{"$error":"#N/A"}},null,40,177.2,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X49/1440)))","v":9.4064851317709516E-2},181.2]
[null,null,null,null,null,null,null,null,null,70,null,null,null,42,{"$f":"IF(Data!L66>=E$9,Data!L66-E$10,0)","v":0},{"$f":"IF(O50>0,P49+7.48*Data!M66*(Data!B66-Data!B65)/1440,0)","v":0},{"$f":"IF(O50>0,Q49+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)*O50))),0)","v":0},0,null,{"$f":"Data!L66","v":0},{"$f":"Data!M66/Data!N66","v":{"$error":"#N/A"}},null,41,181.58,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X50/1440)))","v":9.3636990592771863E-2},185.58]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43,{"$f":"IF(Data!L67>=E$9,Data!L67-E$10,0)","v":0},{"$f":"IF(O51>0,P50+7.48*Data!M67*(Data!B67-Data!B66)/1440,0)","v":0},{"$f":"IF(O51>0,Q50+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)*O51))),0)","v":0},0,null,{"$f":"Data!L67","v":0},{"$f":"Data!M67/Data!N67","v":{"$error":"#N/A"}},null,42,185.96,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X51/1440)))","v":9.3223066190152415E-2},189.96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,44,{"$f":"IF(Data!L68>=E$9,Data!L68-E$10,0)","v":0},{"$f":"IF(O52>0,P51+7.48*Data!M68*(Data!B68-Data!B67)/1440,0)","v":0},{"$f":"IF(O52>0,Q51+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)*O52))),0)","v":0},0,null,{"$f":"Data!L68","v":0},{"$f":"Data!M68/Data!N68","v":{"$error":"#N/A"}},null,43,190.34,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X52/1440)))","v":9.282229606816661E-2},194.34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,45,{"$f":"IF(Data!L69>=E$9,Data!L69-E$10,0)","v":0},{"$f":"IF(O53>0,P52+7.48*Data!M69*(Data!B69-Data!B68)/1440,0)","v":0},{"$f":"IF(O53>0,Q52+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)*O53))),0)","v":0},0,null,{"$f":"Data!L69","v":0},{"$f":"Data!M69/Data!N69","v":{"$error":"#N/A"}},null,44,194.72,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X53/1440)))","v":9.2433959364970744E-2},198.72]
[null,null,null,null,null,null,null,null,null,null,null,null,null,46,{"$f":"IF(Data!L70>=E$9,Data!L70-E$10,0)","v":0},{"$f":"IF(O54>0,P53+7.48*Data!M70*(Data!B70-Data!B69)/1440,0)","v":0},{"$f":"IF(O54>0,Q53+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)*O54))),0)","v":0},0,null,{"$f":"Data!L70","v":0},{"$f":"Data!M70/Data!N70","v":{"$error":"#N/A"}},null,45,199.1,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X54/1440)))","v":9.205739032938913E-2},203.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,47,{"$f":"IF(Data!L71>=E$9,Data!L71-E$10,0)","v":0},{"$f":"IF(O55>0,P54+7.48*Data!M71*(Data!B71-Data!B70)/1440,0)","v":0},{"$f":"IF(O55>0,Q54+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)*O55))),0)","v":0},0,null,{"$f":"Data!L71","v":0},{"$f":"Data!M71/Data!N71","v":{"$error":"#N/A"}},null,46,203.48,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X55/1440)))","v":9.169197297498885E-2},207.48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,48,{"$f":"IF(Data!L72>=E$9,Data!L72-E$10,0)","v":0},{"$f":"IF(O56>0,P55+7.48*Data!M72*(Data!B72-Data!B71)/1440,0)","v":0},{"$f":"IF(O56>0,Q55+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)*O56))),0)","v":0},0,null,{"$f":"Data!L72","v":0},{"$f":"Data!M72/Data!N72","v":{"$error":"#N/A"}},null,47,207.86,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X56/1440)))","v":9.1337136357434151E-2},211.86]
[null,null,null,null,null,null,null,null,null,null,null,null,null,49,{"$f":"IF(Data!L73>=E$9,Data!L73-E$10,0)","v":0},{"$f":"IF(O57>0,P56+7.48*Data!M73*(Data!B73-Data!B72)/1440,0)","v":0},{"$f":"IF(O57>0,Q56+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)*O57))),0)","v":0},0,null,{"$f":"Data!L73","v":0},{"$f":"Data!M73/Data!N73","v":{"$error":"#N/A"}},null,48,212.24,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X57/1440)))","v":9.0992350390791191E-2},216.24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,50,{"$f":"IF(Data!L74>=E$9,Data!L74-E$10,0)","v":0},{"$f":"IF(O58>0,P57+7.48*Data!M74*(Data!B74-Data!B73)/1440,0)","v":0},{"$f":"IF(O58>0,Q57+7.48*(4*PI()*(E$16/1440)*Data!N74)*(Data!B74-Data!B73)/LN(0.56146/((Data!P74^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O58))),0)","v":0},0,null,{"$f":"Data!L74","v":0},{"$f":"Data!M74/Data!N74","v":{"$error":"#N/A"}},null,49,216.62,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X58/1440)))","v":9.0657122131373447E-2},220.62]
[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,50,221,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$24^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X59/1440)))","v":9.0330992468436275E-2},225]
[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"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L82","v":0},{"$f":"Data!M82/Data!N82","v":{"$error":"#N/A"}}]

{"sheet":"CB&P","index":5,"n_rows":108,"n_cols":25,"rows_kept":108,"cut":false,"hidden":false,"merged":[]}
["Cooper, Bredehoeft and Papadopulos (1967)"]
["Well Designation:",null,{"$f":"IF(Data!B1 > 0,Data!B1,\"\")","v":"MW16"},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":"2021-11-09"}]
[]
[null,"Enter early time cut-off for least-squares model fit"]
[null,null,"Timecut (min):",null,7,"<-  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,0.33,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!B24>E$6,Data!B24-E$6,0)","v":0},{"$f":"IF(N8>0,Data!J24/'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$24^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":3.0000000000000004},{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U8/Data!V$24^2,0.00001)","v":0.98124706136131679},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!B25>E$6,Data!B25-E$6,0)","v":0},{"$f":"IF(N9>0,Data!J25/'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$24^2,'CB&P'!Q$2),0)","v":0},{"$f":"N9*(P9-Q9)^2","v":0},null,1,3.143413702359656,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U9/Data!V$24^2,0.00001)","v":0.98068992568561641},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,1,{"$f":"IF(Data!B26>E$6,Data!B26-E$6,0)","v":8},{"$f":"IF(N10>0,Data!J26/'CB&P'!E$7,0)","v":0.93939393939394622},{"$f":"IF(N10>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O10/Data!V$24^2,'CB&P'!Q$2),0)","v":0.96487574472831494},6.4932240309866233E-4,null,2,3.2936832347274798,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U10/Data!V$24^2,0.00001)","v":0.98011497228242916},null,8,0.93939393939394622]
[null,"Root-Mean-Square Error:",null,null,{"$f":"SQRT(SUM(R8:R48))","v":0.11730378601932097},"<-- Minimize this using \"Solver\"",null,null,null,null,null,null,null,1,{"$f":"IF(Data!B27>E$6,Data!B27-E$6,0)","v":54},{"$f":"IF(N11>0,Data!J27/'CB&P'!E$7,0)","v":0.84848484848485184},{"$f":"IF(N11>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O11/Data!V$24^2,'CB&P'!Q$2),0)","v":0.8729099853461022},5.9658731069081117E-4,null,3,3.4511363370915449,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U11/Data!V$24^2,0.00001)","v":0.97952162250454122},null,54,0.84848484848485184]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B28>E$6,Data!B28-E$6,0)","v":114},{"$f":"IF(N12>0,Data!J28/'CB&P'!E$7,0)","v":0.78787878787876031},{"$f":"IF(N12>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O12/Data!V$24^2,'CB&P'!Q$2),0)","v":0.78924756033362198},1.8735380331880326E-6,null,4,3.6161164169082913,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U12/Data!V$24^2,0.00001)","v":0.97890927431850427},null,114,0.78787878787876031]
[null,"Trial Tn (ft2/d):",null,null,0.06,"<-- By changing Tn through \"Solver\"",null,null,null,null,null,null,null,1,{"$f":"IF(Data!B29>E$6,Data!B29-E$6,0)","v":294},{"$f":"IF(N13>0,Data!J29/'CB&P'!E$7,0)","v":0.72727272727275483},{"$f":"IF(N13>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O13/Data!V$24^2,'CB&P'!Q$2),0)","v":0.61541391017439651},1.251239496264398E-2,null,5,3.7889832980790752,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U13/Data!V$24^2,0.00001)","v":0.97827730152833736},null,294,0.72727272727275483]
[null,null,null,null,{"$f":"IF(E9=\"d\",0.025*SQRT(E13),E9)","v":6.1237243569579455E-3},"<-- Working Sn",null,"Add constraint Tn > 0.00001",null,null,null,null,null,0,{"$f":"IF(Data!B30>E$6,Data!B30-E$6,0)","v":0},{"$f":"IF(N14>0,Data!J30/'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$24^2,'CB&P'!Q$2),0)","v":0},0,null,6,3.9701140057312139,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U14/Data!V$24^2,0.00001)","v":0.97762505300380909},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Model Result:",null,"Tn (ft2/d) =",{"$f":"E13","v":0.06},null,null,null,"Tmin",3,null,null,null,0,{"$f":"IF(Data!B31>E$6,Data!B31-E$6,0)","v":0},{"$f":"IF(N15>0,Data!J31/'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$24^2,'CB&P'!Q$2),0)","v":0},0,null,7,4.1599035885151592,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U15/Data!V$24^2,0.00001)","v":0.9769518519114565},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,"Tmax",320,null,null,null,0,{"$f":"IF(Data!B32>E$6,Data!B32-E$6,0)","v":0},{"$f":"IF(N16>0,Data!J32/'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$24^2,'CB&P'!Q$2),0)","v":0},0,null,8,4.3587659802112189,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U16/Data!V$24^2,0.00001)","v":0.97625699046925385},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(N17>0,Data!J33/'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$24^2,'CB&P'!Q$2),0)","v":0},0,null,9,4.5671349025250212,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U17/Data!V$24^2,0.00001)","v":0.97553974874801364},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B34>E$6,Data!B34-E$6,0)","v":0},{"$f":"IF(N18>0,Data!J34/'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$24^2,'CB&P'!Q$2),0)","v":0},0,null,10,4.7854648110407263,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U18/Data!V$24^2,0.00001)","v":0.97479936146347501},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!B35>E$6,Data!B35-E$6,0)","v":0},{"$f":"IF(N19>0,Data!J35/'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$24^2,'CB&P'!Q$2),0)","v":0},0,null,11,5.0142318863951267,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U19/Data!V$24^2,0.00001)","v":0.9740350414428407},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,{"$f":"Figures!U27","v":-0.51428571428571435},null,null,null,0,{"$f":"IF(Data!B36>E$6,Data!B36-E$6,0)","v":0},{"$f":"IF(N20>0,Data!J36/'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$24^2,'CB&P'!Q$2),0)","v":0},0,null,12,5.2539350728343823,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U20/Data!V$24^2,0.00001)","v":0.97324597186790818},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(N21>0,Data!J37/'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$24^2,'CB&P'!Q$2),0)","v":0},0,null,13,5.5050971664185244,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U21/Data!V$24^2,0.00001)","v":0.97243130548386802},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(N22>0,Data!J38/'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$24^2,'CB&P'!Q$2),0)","v":0},0,null,14,5.7682659552471014,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U22/Data!V$24^2,0.00001)","v":0.97159016378944663},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(N23>0,Data!J39/'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$24^2,'CB&P'!Q$2),0)","v":0},0,null,15,6.0440154141928151,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U23/Data!V$24^2,0.00001)","v":0.97072163620617735},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(N24>0,Data!J40/'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$24^2,'CB&P'!Q$2),0)","v":0},0,null,16,6.3329469567488896,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U24/Data!V$24^2,0.00001)","v":0.96982477922488763},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(N25>0,Data!J41/'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$24^2,'CB&P'!Q$2),0)","v":0},0,null,17,6.6356907467204476,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U25/Data!V$24^2,0.00001)","v":0.96889861552780121},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(N26>0,Data!J42/'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$24^2,'CB&P'!Q$2),0)","v":0},0,null,18,6.9529070726207429,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U26/Data!V$24^2,0.00001)","v":0.96794213308505161},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(N27>0,Data!J43/'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$24^2,'CB&P'!Q$2),0)","v":0},{"$f":"N27*(P27-Q27)^2","v":0},null,19,7.2852877877698008,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U27/Data!V$24^2,0.00001)","v":0.96695428422467833},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(N28>0,Data!J44/'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$24^2,'CB&P'!Q$2),0)","v":0},{"$f":"N28*(P28-Q28)^2","v":0},null,20,7.6335578192363505,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U28/Data!V$24^2,0.00001)","v":0.96593398467563996},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B45>E$6,Data!B45-E$6,0)","v":0},{"$f":"IF(N29>0,Data!J45/'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$24^2,'CB&P'!Q$2),0)","v":0},0,null,21,7.9984767489140802,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U29/Data!V$24^2,0.00001)","v":0.96488011258367334},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B46>E$6,Data!B46-E$6,0)","v":0},{"$f":"IF(N30>0,Data!J46/'CB&P'!E$7,0)","v":0},{"$f":"IF(N30>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O30/Data!V$24^2,'CB&P'!Q$2),0)","v":0},0,null,22,8.3808404701805461,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U30/Data!V$24^2,0.00001)","v":0.9637915075002248},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B47>E$6,Data!B47-E$6,0)","v":0},{"$f":"IF(N31>0,Data!J47/'CB&P'!E$7,0)","v":0},{"$f":"IF(N31>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O31/Data!V$24^2,'CB&P'!Q$2),0)","v":0},0,null,23,8.7814829237519536,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U31/Data!V$24^2,0.00001)","v":0.96266696934505513},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B48>E$6,Data!B48-E$6,0)","v":0},{"$f":"IF(N32>0,Data!J48/'CB&P'!E$7,0)","v":0},{"$f":"IF(N32>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O32/Data!V$24^2,'CB&P'!Q$2),0)","v":0},0,null,24,9.2012779165197394,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U32/Data!V$24^2,0.00001)","v":0.96150525734346681},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B49>E$6,Data!B49-E$6,0)","v":0},{"$f":"IF(N33>0,Data!J49/'CB&P'!E$7,0)","v":0},{"$f":"IF(N33>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O33/Data!V$24^2,'CB&P'!Q$2),0)","v":0},0,null,25,9.64114102733582,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U33/Data!V$24^2,0.00001)","v":0.96030508893948119},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B50>E$6,Data!B50-E$6,0)","v":0},{"$f":"IF(N34>0,Data!J50/'CB&P'!E$7,0)","v":0},{"$f":"IF(N34>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O34/Data!V$24^2,'CB&P'!Q$2),0)","v":0},0,null,26,10.102031603903091,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U34/Data!V$24^2,0.00001)","v":0.95906513868661936},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B51>E$6,Data!B51-E$6,0)","v":0},{"$f":"IF(N35>0,Data!J51/'CB&P'!E$7,0)","v":0},{"$f":"IF(N35>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O35/Data!V$24^2,'CB&P'!Q$2),0)","v":0},0,null,27,10.584954855126419,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U35/Data!V$24^2,0.00001)","v":0.95778403711830107},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B52>E$6,Data!B52-E$6,0)","v":0},{"$f":"IF(N36>0,Data!J52/'CB&P'!E$7,0)","v":0},{"$f":"IF(N36>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O36/Data!V$24^2,'CB&P'!Q$2),0)","v":0},0,null,28,11.090964043487583,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U36/Data!V$24^2,0.00001)","v":0.95646036960018943},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B53>E$6,Data!B53-E$6,0)","v":0},{"$f":"IF(N37>0,Data!J53/'CB&P'!E$7,0)","v":0},{"$f":"IF(N37>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O37/Data!V$24^2,'CB&P'!Q$2),0)","v":0},0,null,29,11.621162782225708,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U37/Data!V$24^2,0.00001)","v":0.95509267516712959},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B54>E$6,Data!B54-E$6,0)","v":0},{"$f":"IF(N38>0,Data!J54/'CB&P'!E$7,0)","v":0},{"$f":"IF(N38>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O38/Data!V$24^2,'CB&P'!Q$2),0)","v":0},0,null,30,12.176707442333448,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U38/Data!V$24^2,0.00001)","v":0.9536794453476809},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B55>E$6,Data!B55-E$6,0)","v":0},{"$f":"IF(N39>0,Data!J55/'CB&P'!E$7,0)","v":0},{"$f":"IF(N39>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O39/Data!V$24^2,'CB&P'!Q$2),0)","v":0},0,null,31,12.758809674618584,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U39/Data!V$24^2,0.00001)","v":0.95221912297952482},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B56>E$6,Data!B56-E$6,0)","v":0},{"$f":"IF(N40>0,Data!J56/'CB&P'!E$7,0)","v":0},{"$f":"IF(N40>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O40/Data!V$24^2,'CB&P'!Q$2),0)","v":0},0,null,32,{"$f":"EXP(LN(J$15)+(LN(J$16)-LN(J$15))*T40/100)","v":13.368739052331669},{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U40/Data!V$24^2,0.00001)","v":0.95071010101936393},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B57>E$6,Data!B57-E$6,0)","v":0},{"$f":"IF(N41>0,Data!J57/'CB&P'!E$7,0)","v":0},{"$f":"IF(N41>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O41/Data!V$24^2,'CB&P'!Q$2),0)","v":0},0,null,33,14.00782584012334,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U41/Data!V$24^2,0.00001)","v":0.94915072135131151},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B58>E$6,Data!B58-E$6,0)","v":0},{"$f":"IF(N42>0,Data!J58/'CB&P'!E$7,0)","v":0},{"$f":"IF(N42>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O42/Data!V$24^2,'CB&P'!Q$2),0)","v":0},0,null,34,14.677463895370458,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U42/Data!V$24^2,0.00001)","v":0.94753927359802248},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B59>E$6,Data!B59-E$6,0)","v":0},{"$f":"IF(N43>0,Data!J59/'CB&P'!E$7,0)","v":0},{"$f":"IF(N43>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O43/Data!V$24^2,'CB&P'!Q$2),0)","v":0},0,null,35,15.379113708198872,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U43/Data!V$24^2,0.00001)","v":0.94587399393930194},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B60>E$6,Data!B60-E$6,0)","v":0},{"$f":"IF(N44>0,Data!J60/'CB&P'!E$7,0)","v":0},{"$f":"IF(N44>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O44/Data!V$24^2,'CB&P'!Q$2),0)","v":0},0,null,36,16.114305586833179,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U44/Data!V$24^2,0.00001)","v":0.94415306394321741},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B61>E$6,Data!B61-E$6,0)","v":0},{"$f":"IF(N45>0,Data!J61/'CB&P'!E$7,0)","v":0},{"$f":"IF(N45>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O45/Data!V$24^2,'CB&P'!Q$2),0)","v":0},0,null,37,16.884642995220727,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U45/Data!V$24^2,0.00001)","v":0.9423746094152281},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B62>E$6,Data!B62-E$6,0)","v":0},{"$f":"IF(N46>0,Data!J62/'CB&P'!E$7,0)","v":0},{"$f":"IF(N46>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O46/Data!V$24^2,'CB&P'!Q$2),0)","v":0},0,null,38,17.691806050209259,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U46/Data!V$24^2,0.00001)","v":0.94053669927126182},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B63>E$6,Data!B63-E$6,0)","v":0},{"$f":"IF(N47>0,Data!J63/'CB&P'!E$7,0)","v":0},{"$f":"IF(N47>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O47/Data!V$24^2,'CB&P'!Q$2),0)","v":0},0,null,39,18.537555185905752,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U47/Data!V$24^2,0.00001)","v":0.93863734444117752},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B64>E$6,Data!B64-E$6,0)","v":0},{"$f":"IF(N48>0,Data!J64/'CB&P'!E$7,0)","v":0},{"$f":"IF(N48>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O48/Data!V$24^2,'CB&P'!Q$2),0)","v":0},0,null,40,19.42373499320815,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U48/Data!V$24^2,0.00001)","v":0.93667449680951065},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,20.352278242884417,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U49/Data!V$24^2,0.00001)","v":0.93464604820108355}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,21.325210100973056,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U50/Data!V$24^2,0.00001)","v":0.93254982941950981}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,22.344652545699073,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U51/Data!V$24^2,0.00001)","v":0.93038360934734476}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,23.412828995538682,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U52/Data!V$24^2,0.00001)","v":0.92814509270499279}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,24.532069158526589,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U53/Data!V$24^2,0.00001)","v":0.92583192560640559}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,25.70481411338238,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U54/Data!V$24^2,0.00001)","v":0.92344168417716566}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,26.933621633538021,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U55/Data!V$24^2,0.00001)","v":0.92097188232059968}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,28.221171765677962,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U56/Data!V$24^2,0.00001)","v":0.91841996875114829}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,29.570272674959163,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U57/Data!V$24^2,0.00001)","v":0.91578332670881168}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,30.983866769659322,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U58/Data!V$24^2,0.00001)","v":0.91305927381160323}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,32.46503711861105,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U59/Data!V$24^2,0.00001)","v":0.91024506206365197}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,34.017014175418943,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U60/Data!V$24^2,0.00001)","v":0.9073378780369985}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,35.643182824124828,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U61/Data!V$24^2,0.00001)","v":0.90433484324593361}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,37.34708976168811,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U62/Data!V$24^2,0.00001)","v":0.9012330147334171}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,39.132451233382149,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U63/Data!V$24^2,0.00001)","v":0.89802938589014358}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,41.003161137978125,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U64/Data!V$24^2,0.00001)","v":0.89472088752777224}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,42.963299520393804,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U65/Data!V$24^2,0.00001)","v":0.89130438922903876}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,45.017141470329314,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U66/Data!V$24^2,0.00001)","v":0.88777670099862915}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,47.169166446298767,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U67/Data!V$24^2,0.00001)","v":0.88413457523997963}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,49.424068045392914,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U68/Data!V$24^2,0.00001)","v":0.8803747090844114}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,51.786764240081382,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U69/Data!V$24^2,0.00001)","v":0.87649374710035688}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,54.262408104380292,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U70/Data!V$24^2,0.00001)","v":0.87248828441170001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,56.856399052780226,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U71/Data!V$24^2,0.00001)","v":0.86835487025556823}]
[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":59.574394616445936},{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U72/Data!V$24^2,0.00001)","v":0.86409001201116475}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,62.422322782372504,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U73/Data!V$24^2,0.00001)","v":0.85969017973241646}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,65.406394922409021,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U74/Data!V$24^2,0.00001)","v":0.85515181121837935}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,68.533119340349202,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U75/Data!V$24^2,0.00001)","v":0.85047131765640827}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68,71.809315466634416,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U76/Data!V$24^2,0.00001)","v":0.84564508987397502}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69,75.24212873162854,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U77/Data!V$24^2,0.00001)","v":0.84066950523592521}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,78.839046149903453,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U78/Data!V$24^2,0.00001)","v":0.83554093522447825}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,71,82.607912649523954,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U79/Data!V$24^2,0.00001)","v":0.83025575373980331}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72,86.556948181947732,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U80/Data!V$24^2,0.00001)","v":0.82481034615916915}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73,90.694765649856336,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U81/Data!V$24^2,0.00001)","v":0.81920111919256799}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74,95.030389692018758,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U82/Data!V$24^2,0.00001)","v":0.81342451157232543}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,99.573276366156463,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U83/Data!V$24^2,0.00001)","v":0.80747700561348212}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,76,104.33333377274039,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U84/Data!V$24^2,0.00001)","v":0.80135513900956679}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,77,109.32094366469855,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U85/Data!V$24^2,0.00001)","v":0.79505552125679491}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78,114.54698409016706,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U86/Data!V$24^2,0.00001)","v":0.78857484284586432}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79,120.02285311766823,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U87/Data!V$24^2,0.00001)","v":0.78190989472245198}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,125.76049369545959,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U88/Data!V$24^2,0.00001)","v":0.77505758342029207}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81,131.77241969927428,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U89/Data!V$24^2,0.00001)","v":0.76801494852926067}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82,138.07174322526211,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U90/Data!V$24^2,0.00001)","v":0.76077918122208776}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,83,144.67220318765752,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U91/Data!V$24^2,0.00001)","v":0.75334764385226205}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,84,151.58819528354769,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U92/Data!V$24^2,0.00001)","v":0.74571789062831173}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,85,158.83480339009174,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U93/Data!V$24^2,0.00001)","v":0.73788768936130933}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,86,166.42783246267214,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U94/Data!V$24^2,0.00001)","v":0.72985504427324321}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,87,174.38384300572696,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U95/Data!V$24^2,0.00001)","v":0.72161821984362451}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,88,182.72018719144558,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U96/Data!V$24^2,0.00001)","v":0.71317576566022289}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,89,191.45504670510383,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U97/Data!V$24^2,0.00001)","v":0.70452654222719724}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,200.60747239957712,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U98/Data!V$24^2,0.00001)","v":0.69566974766986123}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,91,210.19742584552245,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U99/Data!V$24^2,0.00001)","v":0.68660494526000659}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,92,220.24582286784747,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U100/Data!V$24^2,0.00001)","v":0.67733209166893205}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,93,230.77457916342317,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U101/Data!V$24^2,0.00001)","v":0.66785156583716088}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94,241.80665809952924,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U102/Data!V$24^2,0.00001)","v":0.65816419833026418}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95,253.36612079728559,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U103/Data!V$24^2,0.00001)","v":0.64827130102923414}]
[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":265.47817860929962},{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U104/Data!V$24^2,0.00001)","v":0.63817469698159857}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97,278.16924810598556,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U105/Data!V$24^2,0.00001)","v":0.62787675021599598}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98,291.46700869047902,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U106/Data!V$24^2,0.00001)","v":0.61738039529839783}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99,305.40046296781094,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U107/Data!V$24^2,0.00001)","v":0.60668916638271664}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,319.99999999999994,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U108/Data!V$24^2,0.00001)","v":0.59580722548250797}]

{"sheet":"B&R Type Curve","index":6,"n_rows":56,"n_cols":30,"rows_kept":56,"cut":false,"hidden":false,"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.083 ;  Borehole Rad. (ft) = 0.167"}]
[]
[]
[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,10,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,50,5,null,{"$f":"Figures!U27","v":-0.51428571428571435},"<--  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,150,2,null,null,{"$f":"-(1-Data!B9)","v":-0.21999999999999997},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,250,1]
[5,"T=0.5 ft2/day",null,400,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,400,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,400,0.1,null,null,null,null,null,{"$f":"(K$42-K$12)/30+K12","v":0.33333333333333331},{"$f":"EXP(-(2*L$9*(K13/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.88859196570975574},null,{"$f":"(N$42-N$12)/30+N12","v":1.6666666666666667},{"$f":"EXP(-(2*O$9*(N13/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.7443136018537766},null,{"$f":"(Q$42-Q$12)/30+Q12","v":5},{"$f":"EXP(-(2*R$9*(Q13/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.70162837876128126},null,{"$f":"(T$42-T$12)/30+T12","v":8.3333333333333339},{"$f":"EXP(-(2*U$9*(T13/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.7443136018537766},null,{"$f":"(W$42-W$12)/30+W12","v":13.333333333333334},{"$f":"EXP(-(2*X$9*(W13/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.78959568152392778},null,{"$f":"(Z$42-Z$12)/30+Z12","v":13.333333333333334},{"$f":"EXP(-(2*AA$9*(Z13/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.90983346289311584},null,{"$f":"(AC$42-AC$12)/30+AC12","v":13.333333333333334},{"$f":"EXP(-(2*AD$9*(AC13/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.95385190826098154}]
[null,null,null,null,null,null,null,null,null,null,0.66666666666666663,{"$f":"EXP(-(2*L$9*(K14/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.78959568152392778},null,3.3333333333333335,{"$f":"EXP(-(2*O$9*(N14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.55400273790454235},null,10,{"$f":"EXP(-(2*R$9*(Q14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.49228238188318396},null,16.666666666666668,{"$f":"EXP(-(2*U$9*(T14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.55400273790454235},null,26.666666666666668,{"$f":"EXP(-(2*X$9*(W14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.6234613402812359},null,26.666666666666668,{"$f":"EXP(-(2*AA$9*(Z14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.82779693020007883},null,26.666666666666668,{"$f":"EXP(-(2*AD$9*(AC14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.90983346289311584}]
[null,null,null,null,null,null,null,null,null,null,1,{"$f":"EXP(-(2*L$9*(K15/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.70162837876128126},null,5,{"$f":"EXP(-(2*O$9*(N15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.41235177328658373},null,15,{"$f":"EXP(-(2*R$9*(Q15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.34539928949344034},null,25,{"$f":"EXP(-(2*U$9*(T15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.41235177328658373},null,40,{"$f":"EXP(-(2*X$9*(W15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.49228238188318396},null,40,{"$f":"EXP(-(2*AA$9*(Z15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.75315734757622865},null,40,{"$f":"EXP(-(2*AD$9*(AC15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.86784638478029552}]
[null,null,null,null,null,null,null,null,null,null,1.3333333333333333,{"$f":"EXP(-(2*L$9*(K16/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.6234613402812359},null,6.666666666666667,{"$f":"EXP(-(2*O$9*(N16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.30691903360572903},null,20,{"$f":"EXP(-(2*R$9*(Q16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.24234194351258095},null,33.333333333333336,{"$f":"EXP(-(2*U$9*(T16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.30691903360572903},null,53.333333333333336,{"$f":"EXP(-(2*X$9*(W16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.38870404282527504},null,53.333333333333336,{"$f":"EXP(-(2*AA$9*(Z16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.68524775764867418},null,53.333333333333336,{"$f":"EXP(-(2*AD$9*(AC16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.82779693020007883}]
[null,null,null,null,null,null,null,null,null,null,1.6666666666666665,{"$f":"EXP(-(2*L$9*(K17/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.55400273790454235},null,8.3333333333333339,{"$f":"EXP(-(2*O$9*(N17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.22844401138056047},null,25,{"$f":"EXP(-(2*R$9*(Q17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.17003398493259014},null,41.666666666666671,{"$f":"EXP(-(2*U$9*(T17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.22844401138056047},null,66.666666666666671,{"$f":"EXP(-(2*X$9*(W17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.30691903360572903},null,66.666666666666671,{"$f":"EXP(-(2*AA$9*(Z17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.6234613402812359},null,66.666666666666671,{"$f":"EXP(-(2*AD$9*(AC17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.78959568152392778}]
[null,null,null,null,null,null,null,null,null,null,1.9999999999999998,{"$f":"EXP(-(2*L$9*(K18/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.49228238188318396},null,10,{"$f":"EXP(-(2*O$9*(N18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.17003398493259014},null,30,{"$f":"EXP(-(2*R$9*(Q18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.11930066918257339},null,50.000000000000007,{"$f":"EXP(-(2*U$9*(T18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.17003398493259014},null,80,{"$f":"EXP(-(2*X$9*(W18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.24234194351258095},null,80,{"$f":"EXP(-(2*AA$9*(Z18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.56724599020806021},null,80,{"$f":"EXP(-(2*AD$9*(AC18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.75315734757622865}]
[null,null,null,null,null,null,null,null,null,null,2.333333333333333,{"$f":"EXP(-(2*L$9*(K19/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.4374381694018592},null,11.666666666666666,{"$f":"EXP(-(2*O$9*(N19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.12655860776272701},null,35,{"$f":"EXP(-(2*R$9*(Q19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":8.370473510370488E-2},null,58.333333333333343,{"$f":"EXP(-(2*U$9*(T19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.12655860776272695},null,93.333333333333329,{"$f":"EXP(-(2*X$9*(W19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.19135215204964959},null,93.333333333333329,{"$f":"EXP(-(2*AA$9*(Z19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.51609938358323393},null,93.333333333333329,{"$f":"EXP(-(2*AD$9*(AC19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.71840057320636508}]
[null,null,null,null,null,null,null,null,null,null,2.6666666666666665,{"$f":"EXP(-(2*L$9*(K20/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.3887040428252751},null,13.333333333333332,{"$f":"EXP(-(2*O$9*(N20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":9.4199293189474662E-2},null,40,{"$f":"EXP(-(2*R$9*(Q20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":5.8729617585454981E-2},null,66.666666666666671,{"$f":"EXP(-(2*U$9*(T20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":9.419929318947462E-2},null,106.66666666666666,{"$f":"EXP(-(2*X$9*(W20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.15109083290871328},null,106.66666666666666,{"$f":"EXP(-(2*AA$9*(Z20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.4695644893625362},null,106.66666666666666,{"$f":"EXP(-(2*AD$9*(AC20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.68524775764867429}]
[null,null,null,null,null,null,null,null,null,null,3,{"$f":"EXP(-(2*L$9*(K21/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.34539928949344034},null,14.999999999999998,{"$f":"EXP(-(2*O$9*(N21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":7.0113815205937818E-2},null,45,{"$f":"EXP(-(2*R$9*(Q21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":4.1206366371752796E-2},null,75,{"$f":"EXP(-(2*U$9*(T21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":7.0113815205937791E-2},null,119.99999999999999,{"$f":"EXP(-(2*X$9*(W21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.11930066918257339},null,119.99999999999999,{"$f":"EXP(-(2*AA$9*(Z21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.42722548540835403},null,119.99999999999999,{"$f":"EXP(-(2*AD$9*(AC21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.6536248812647466}]
[null,null,null,null,null,null,null,null,null,null,3.3333333333333335,{"$f":"EXP(-(2*L$9*(K22/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.30691903360572903},null,16.666666666666664,{"$f":"EXP(-(2*O$9*(N22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":5.2186666335641715E-2},null,50,{"$f":"EXP(-(2*R$9*(Q22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":2.891155603205629E-2},null,83.333333333333329,{"$f":"EXP(-(2*U$9*(T22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":5.2186666335641695E-2},null,133.33333333333331,{"$f":"EXP(-(2*X$9*(W22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":9.4199293189474703E-2},null,133.33333333333331,{"$f":"EXP(-(2*AA$9*(Z22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.38870404282527515},null,133.33333333333331,{"$f":"EXP(-(2*AD$9*(AC22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.62346134028123601}]
[null,null,null,null,null,null,null,null,null,null,3.666666666666667,{"$f":"EXP(-(2*L$9*(K23/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.27272578738545339},null,18.333333333333332,{"$f":"EXP(-(2*O$9*(N23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":3.8843245589022697E-2},null,55,{"$f":"EXP(-(2*R$9*(Q23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":2.0285168186237598E-2},null,91.666666666666657,{"$f":"EXP(-(2*U$9*(T23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":3.8843245589022697E-2},null,146.66666666666666,{"$f":"EXP(-(2*X$9*(W23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":7.437935510501556E-2},null,146.66666666666666,{"$f":"EXP(-(2*AA$9*(Z23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.35365594532427408},null,146.66666666666666,{"$f":"EXP(-(2*AD$9*(AC23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.59468978915420612}]
[null,null,null,null,null,null,null,null,null,null,4,{"$f":"EXP(-(2*L$9*(K24/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.24234194351258093},null,20,{"$f":"EXP(-(2*O$9*(N24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":2.891155603205629E-2},null,60,{"$f":"EXP(-(2*R$9*(Q24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.4232649667409817E-2},null,99.999999999999986,{"$f":"EXP(-(2*U$9*(T24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":2.8911556032056317E-2},null,160,{"$f":"EXP(-(2*X$9*(W24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":5.8729617585454981E-2},null,160,{"$f":"EXP(-(2*AA$9*(Z24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.32176801340712269},null,160,{"$f":"EXP(-(2*AD$9*(AC24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.56724599020806021}]
[null,null,null,null,null,null,null,null,null,null,4.333333333333333,{"$f":"EXP(-(2*L$9*(K25/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.21534310395976689},null,21.666666666666668,{"$f":"EXP(-(2*O$9*(N25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":2.1519264405417099E-2},null,65,{"$f":"EXP(-(2*R$9*(Q25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":9.986030911622033E-3},null,108.33333333333331,{"$f":"EXP(-(2*U$9*(T25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":2.1519264405417109E-2},null,173.33333333333334,{"$f":"EXP(-(2*X$9*(W25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":4.6372652423026975E-2},null,173.33333333333334,{"$f":"EXP(-(2*AA$9*(Z25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.29275530588644094},null,173.33333333333334,{"$f":"EXP(-(2*AD$9*(AC25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.54106867021334815}]
[null,null,null,null,null,null,null,null,null,null,4.6666666666666661,{"$f":"EXP(-(2*L$9*(K26/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.19135215204964967},null,23.333333333333336,{"$f":"EXP(-(2*O$9*(N26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.601708119883977E-2},null,70,{"$f":"EXP(-(2*R$9*(Q26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":7.0064826787814031E-3},null,116.66666666666664,{"$f":"EXP(-(2*U$9*(T26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":1.6017081198839784E-2},null,186.66666666666669,{"$f":"EXP(-(2*X$9*(W26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":3.6615646094032193E-2},null,186.66666666666669,{"$f":"EXP(-(2*AA$9*(Z26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.26635857373499394},null,186.66666666666669,{"$f":"EXP(-(2*AD$9*(AC26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.51609938358323382}]
[null,null,null,null,null,null,null,null,null,null,4.9999999999999991,{"$f":"EXP(-(2*L$9*(K27/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.17003398493259023},null,25.000000000000004,{"$f":"EXP(-(2*O$9*(N27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.1921731398292846E-2},null,75,{"$f":"EXP(-(2*R$9*(Q27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":4.9159470827323925E-3},null,124.99999999999997,{"$f":"EXP(-(2*U$9*(T27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":1.1921731398292857E-2},null,200.00000000000003,{"$f":"EXP(-(2*X$9*(W27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":2.891155603205629E-2},null,200.00000000000003,{"$f":"EXP(-(2*AA$9*(Z27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.24234194351258093},null,200.00000000000003,{"$f":"EXP(-(2*AD$9*(AC27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.49228238188318391}]
[null,null,null,null,null,null,null,null,null,null,5.3333333333333321,{"$f":"EXP(-(2*L$9*(K28/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.15109083290871336},null,26.666666666666671,{"$f":"EXP(-(2*O$9*(N28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":8.8735068373965997E-3},null,80,{"$f":"EXP(-(2*R$9*(Q28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":3.4491679817337832E-3},null,133.33333333333331,{"$f":"EXP(-(2*U$9*(T28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":8.8735068373966171E-3},null,213.33333333333337,{"$f":"EXP(-(2*X$9*(W28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":2.2828439789048707E-2},null,213.33333333333337,{"$f":"EXP(-(2*AA$9*(Z28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.22049080967029933},null,213.33333333333337,{"$f":"EXP(-(2*AD$9*(AC28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.46956448936253614}]
[null,null,null,null,null,null,null,null,null,null,5.6666666666666652,{"$f":"EXP(-(2*L$9*(K29/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.13425810021507786},null,28.333333333333339,{"$f":"EXP(-(2*O$9*(N29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":6.604671835216778E-3},null,85,{"$f":"EXP(-(2*R$9*(Q29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":2.4200341390991937E-3},null,141.66666666666666,{"$f":"EXP(-(2*U$9*(T29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":6.6046718352167832E-3},null,226.66666666666671,{"$f":"EXP(-(2*X$9*(W29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.8025237473361846E-2},null,226.66666666666671,{"$f":"EXP(-(2*AA$9*(Z29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.2006099168984353},null,226.66666666666671,{"$f":"EXP(-(2*AD$9*(AC29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.44789498423004837}]
[null,null,null,null,null,null,null,null,null,null,5.9999999999999982,{"$f":"EXP(-(2*L$9*(K30/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.11930066918257344},null,30.000000000000007,{"$f":"EXP(-(2*O$9*(N30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":4.9159470827323882E-3},null,90,{"$f":"EXP(-(2*R$9*(Q30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.6979646295631195E-3},null,150,{"$f":"EXP(-(2*U$9*(T30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":4.9159470827323925E-3},null,240.00000000000006,{"$f":"EXP(-(2*X$9*(W30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.4232649667409791E-2},null,240.00000000000006,{"$f":"EXP(-(2*AA$9*(Z30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.18252161538240361},null,240.00000000000006,{"$f":"EXP(-(2*AD$9*(AC30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.42722548540835387}]
[null,null,null,null,null,null,null,null,null,null,6.3333333333333313,{"$f":"EXP(-(2*L$9*(K31/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.10600961613943223},null,31.666666666666675,{"$f":"EXP(-(2*O$9*(N31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":3.6590062796711094E-3},null,95,{"$f":"EXP(-(2*R$9*(Q31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.1913401702343715E-3},null,158.33333333333334,{"$f":"EXP(-(2*U$9*(T31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":3.6590062796711159E-3},null,253.3333333333334,{"$f":"EXP(-(2*X$9*(W31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.1238038714029732E-2},null,253.3333333333334,{"$f":"EXP(-(2*AA$9*(Z31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.16606427337621765},null,253.3333333333334,{"$f":"EXP(-(2*AD$9*(AC31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.40750984451448241}]
[null,null,null,null,null,null,null,null,null,null,6.6666666666666643,{"$f":"EXP(-(2*L$9*(K32/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":9.4199293189474703E-2},null,33.333333333333343,{"$f":"EXP(-(2*O$9*(N32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":2.7234481432275907E-3},null,100,{"$f":"EXP(-(2*R$9*(Q32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":8.3587807219473052E-4},null,166.66666666666669,{"$f":"EXP(-(2*U$9*(T32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":2.7234481432275928E-3},null,266.66666666666674,{"$f":"EXP(-(2*X$9*(W32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":8.8735068373965928E-3},null,266.66666666666674,{"$f":"EXP(-(2*AA$9*(Z32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.1510908329087132},null,266.66666666666674,{"$f":"EXP(-(2*AD$9*(AC32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.38870404282527493}]
[null,null,null,null,null,null,null,null,null,null,6.9999999999999973,{"$f":"EXP(-(2*L$9*(K33/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":8.3704735103704991E-2},null,35.000000000000007,{"$f":"EXP(-(2*O$9*(N33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":2.0270994969477114E-3},null,105,{"$f":"EXP(-(2*R$9*(Q33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":5.8647577663609423E-4},null,175.00000000000003,{"$f":"EXP(-(2*U$9*(T33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":2.0270994969477114E-3},null,280.00000000000006,{"$f":"EXP(-(2*X$9*(W33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":7.006482678781397E-3},null,280.00000000000006,{"$f":"EXP(-(2*AA$9*(Z33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.13746749571673969},null,280.00000000000006,{"$f":"EXP(-(2*AD$9*(AC33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.37076609299764679}]
[null,null,null,null,null,null,null,null,null,null,7.3333333333333304,{"$f":"EXP(-(2*L$9*(K34/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":7.4379355105015629E-2},null,36.666666666666671,{"$f":"EXP(-(2*O$9*(N34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.5087977278891284E-3},null,110,{"$f":"EXP(-(2*R$9*(Q34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":4.1148804834394587E-4},null,183.33333333333337,{"$f":"EXP(-(2*U$9*(T34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":1.5087977278891271E-3},null,293.33333333333337,{"$f":"EXP(-(2*X$9*(W34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":5.532288465837999E-3},null,293.33333333333337,{"$f":"EXP(-(2*AA$9*(Z34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.12507252766320592},null,293.33333333333337,{"$f":"EXP(-(2*AD$9*(AC34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.35365594532427408}]
[null,null,null,null,null,null,null,null,null,null,7.6666666666666634,{"$f":"EXP(-(2*L$9*(K35/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":6.6092897360989764E-2},null,38.333333333333336,{"$f":"EXP(-(2*O$9*(N35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.1230186713139536E-3},null,115,{"$f":"EXP(-(2*R$9*(Q35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":2.8871169223920707E-4},null,191.66666666666671,{"$f":"EXP(-(2*U$9*(T35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":1.1230186713139516E-3},null,306.66666666666669,{"$f":"EXP(-(2*X$9*(W35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":4.3682710815703208E-3},null,306.66666666666669,{"$f":"EXP(-(2*AA$9*(Z35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.11379517095660967},null,306.66666666666669,{"$f":"EXP(-(2*AD$9*(AC35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.33733539831540016}]
[null,null,null,null,null,null,null,null,null,null,7.9999999999999964,{"$f":"EXP(-(2*L$9*(K36/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":5.8729617585455036E-2},null,40,{"$f":"EXP(-(2*O$9*(N36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":8.3587807219473052E-4},null,120,{"$f":"EXP(-(2*R$9*(Q36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":2.0256831655522076E-4},null,200.00000000000006,{"$f":"EXP(-(2*U$9*(T36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":8.3587807219472976E-4},null,320,{"$f":"EXP(-(2*X$9*(W36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":3.4491679817337832E-3},null,320,{"$f":"EXP(-(2*AA$9*(Z36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.10353465445196629},null,320,{"$f":"EXP(-(2*AD$9*(AC36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.32176801340712269}]
[null,null,null,null,null,null,null,null,null,null,8.3333333333333304,{"$f":"EXP(-(2*L$9*(K37/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":5.2186666335641736E-2},null,41.666666666666664,{"$f":"EXP(-(2*O$9*(N37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":6.2215541862585208E-4},null,125,{"$f":"EXP(-(2*R$9*(Q37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.4212767953304149E-4},null,208.3333333333334,{"$f":"EXP(-(2*U$9*(T37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":6.2215541862584926E-4},null,333.33333333333331,{"$f":"EXP(-(2*X$9*(W37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":2.7234481432275976E-3},null,333.33333333333331,{"$f":"EXP(-(2*AA$9*(Z37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":9.4199293189474662E-2},null,333.33333333333331,{"$f":"EXP(-(2*AD$9*(AC37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.30691903360572909}]
[null,null,null,null,null,null,null,null,null,null,8.6666666666666643,{"$f":"EXP(-(2*L$9*(K38/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":4.6372652423027017E-2},null,43.333333333333329,{"$f":"EXP(-(2*O$9*(N38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":4.6307874055025134E-4},null,130,{"$f":"EXP(-(2*R$9*(Q38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":9.9720813367870778E-5},null,216.66666666666674,{"$f":"EXP(-(2*U$9*(T38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":4.630787405502501E-4},null,346.66666666666663,{"$f":"EXP(-(2*X$9*(W38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":2.1504228927468694E-3},null,346.66666666666663,{"$f":"EXP(-(2*AA$9*(Z38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":8.5705669124663625E-2},null,346.66666666666663,{"$f":"EXP(-(2*AD$9*(AC38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.292755305886441}]
[null,null,null,null,null,null,null,null,null,null,8.9999999999999982,{"$f":"EXP(-(2*L$9*(K39/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":4.1206366371752831E-2},null,44.999999999999993,{"$f":"EXP(-(2*O$9*(N39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":3.4467580532086898E-4},null,135,{"$f":"EXP(-(2*R$9*(Q39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":6.9966952612055442E-5},null,225.00000000000009,{"$f":"EXP(-(2*U$9*(T39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":3.4467580532086746E-4},null,359.99999999999994,{"$f":"EXP(-(2*X$9*(W39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.6979646295631225E-3},null,359.99999999999994,{"$f":"EXP(-(2*AA$9*(Z39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":7.797788572926434E-2},null,359.99999999999994,{"$f":"EXP(-(2*AD$9*(AC39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.27924520717330914}]
[null,null,null,null,null,null,null,null,null,null,9.3333333333333321,{"$f":"EXP(-(2*L$9*(K40/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":3.6615646094032242E-2},null,46.666666666666657,{"$f":"EXP(-(2*O$9*(N40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":2.5654689013022736E-4},null,140,{"$f":"EXP(-(2*R$9*(Q40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":4.9090799528063831E-5},null,233.33333333333343,{"$f":"EXP(-(2*U$9*(T40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":2.5654689013022595E-4},null,373.33333333333326,{"$f":"EXP(-(2*X$9*(W40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.3407055388834188E-3},null,373.33333333333326,{"$f":"EXP(-(2*AA$9*(Z40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":7.094688980214027E-2},null,373.33333333333326,{"$f":"EXP(-(2*AD$9*(AC40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.26635857373499405}]
[null,null,null,null,null,null,null,null,null,null,9.6666666666666661,{"$f":"EXP(-(2*L$9*(K41/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":3.2536368938428817E-2},null,48.333333333333321,{"$f":"EXP(-(2*O$9*(N41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.909513398372146E-4},null,145,{"$f":"EXP(-(2*R$9*(Q41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":3.444349808497048E-5},null,241.66666666666677,{"$f":"EXP(-(2*U$9*(T41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":1.9095133983721324E-4},null,386.66666666666657,{"$f":"EXP(-(2*X$9*(W41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.0586153036975573E-3},null,386.66666666666657,{"$f":"EXP(-(2*AA$9*(Z41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":6.4549854430177592E-2},null,386.66666666666657,{"$f":"EXP(-(2*AD$9*(AC41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.25406663383879746}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"$D$7","v":10},{"$f":"EXP(-(2*L$9*(K42/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":2.891155603205629E-2},null,{"$f":"$D$8","v":50},{"$f":"EXP(-(2*O$9*(N42/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.4212767953304149E-4},null,{"$f":"$D$9","v":150},{"$f":"EXP(-(2*R$9*(Q42/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":2.4166535720225121E-5},null,{"$f":"$D$10","v":250},{"$f":"EXP(-(2*U$9*(T42/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":1.4212767953304149E-4},null,{"$f":"$D$11","v":400},{"$f":"EXP(-(2*X$9*(W42/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":8.3587807219473052E-4},null,{"$f":"$D$12","v":400},{"$f":"EXP(-(2*AA$9*(Z42/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":5.872961758545496E-2},null,{"$f":"$D$13","v":400},{"$f":"EXP(-(2*AD$9*(AC42/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.24234194351258093}]
[]
[]
[]
[]
[]
[]
["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":true,"merged":[]}
["Confined LNAPL Model:",null,null,null,"Well Designation:",null,{"$f":"IF(Data!B1 > 0,Data!B1,\"\")","v":"MW16"}]
[null,null,null,null,"Date:",null,{"$f":"IF(Data!B2 > 0,Data!B2,\"\")","v":"2021-11-09"}]
[]
[]
["Depth to base of confining bed (ft bgs) [from boring log]:",24.27]
["Constant LNAPL discharge to well (ft3/d):",3.53]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!N25","v":0.92499999999998295},{"$f":"B6","v":3.53}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"B14","v":1.6330769230769258},{"$f":"M9","v":3.53}]
["Depth to top of screen (ft bgs):",{"$f":"Data!B10","v":30.7},null,null,null,null,null,null,null,null,null,0,0]
["Corrected water table elevation (ft bgs):",{"$f":"Data!I22","v":35.421400000000006}]
["Limiting effective LNAPL thickness in well, bnW (ft):",{"$f":"IF(B5>B11,(B5-B12)/Data!B9,(B11-B12)/Data!B9)","v":-6.0530769230769312}]
["Limiting effective LNAPL drawdown, snW (ft):",{"$f":"(1-Data!B9)*(Confined!B15-Confined!B13)","v":1.6330769230769258}]
["Initial LNAPL thickness, bnR (ft):",{"$f":"Data!O22","v":1.3700000000000045}]
["Radius of influence ratio (from Bouwer and Rice), R/rw:",{"$f":"'B&R'!J12","v":6.7405158957944886}]
[]
[]
["LNAPL Transmissivity, Tn (ft2/d):",{"$f":"B6*LN(B16)/(2*PI()*(1-Data!B9)*(B15-B13))","v":0.65644391380047684}]

{"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":"MW16"}]
[null,null,null,null,"Date:",null,{"$f":"IF(Data!B2 > 0,Data!B2,\"\")","v":"2021-11-09"}]
[]
[]
["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!N25","v":0.92499999999998295},{"$f":"B6","v":3.53}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"B13","v":-12.490000000000006},{"$f":"M9","v":3.53}]
["Depth to top of screen (ft bgs):",{"$f":"Data!B10","v":30.7},null,null,null,null,null,null,null,null,null,0,0]
["Corrected water table elevation (ft bgs):",{"$f":"Data!I22","v":35.421400000000006}]
["Limiting effective LNAPL drawdown, snW (ft):",{"$f":"B5-B14","v":-12.490000000000006}]
["Initial depth to product (DTP0) (ft bgs):",{"$f":"Data!E22","v":35.120000000000005}]
["Radius of influence ratio (from Bouwer and Rice), R/rw:",{"$f":"'B&R'!J12","v":6.7405158957944886}]
[]
[]
["LNAPL Transmissivity, Tn (ft2/d):",{"$f":"B6*LN(B15)/(2*PI()*B13)","v":-8.5830536983335232E-2}]

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