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

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

{"sheet":"Data","index":1,"n_rows":83,"n_cols":22,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
["Well Designation:","YYY","Example E1"]
["Date:","date"," "," "]
[]
["Ground Surface Elev (ft msl)",0,"Enter These Data",null,"Drawdown"]
["Top of Casing Elev (ft msl)",0,null,null,"Adjustment"]
["Well Casing Radius, rc (ft):",8.3000000000000004E-2,"re1",null,"(ft)"]
["Well Radius, rw (ft):",0.33300000000000002,null,null,{"$f":"Figures!C28","v":1.7999999999999999E-2}]
["LNAPL Specific Yield, Sy:",0.17499999999999999]
["LNAPL Density Ratio, rr:",0.78]
["Top of Screen (ft bgs):",0]
["Bottom of Screen (ft bgs):",0]
["LNAPL Baildown Vol. (gal.):"," "]
["Effective Radius, re3 (ft):",{"$f":"SQRT(B8*(B7^2-B6^2)+B6^2)","v":0.15839507568103245},"Calculated Parameters"]
["Effective Radius, re2 (ft):",{"$f":"SQRT(-Figures!U27*B6^2+(Figures!U27+1)*B13^2)","v":0.14770835511214198}]
["Initial Casing LNAPL Vol. (gal.):",{"$f":"PI()*B6^2*(F21-E21)*7.48","v":0.2638731853634691}]
["Initial Filter LNAPL Vol. (gal.):",{"$f":"IF(E21<B10,PI()*(B7^2-B6^2)*B8*(F21-B10)*7.48,PI()*(B7^2-B6^2)*B8*(F21-E21)*7.48)","v":0.69712468770723435}]
[]
[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,33.76,35.39,{"$f":"C21+B4-B5","v":33.76},{"$f":"D21+B4-B5","v":35.39},null,null,{"$f":"E21+(1-B$9)*(F21-E21)","v":34.118600000000001},null,null,null,null,null,{"$f":"F21-E21","v":1.6300000000000026}]
[]
["Enter Test Data:",0.71666666666666667,34.22,35.020000000000003,{"$f":"IF(B23>0,C23+B$4-B$5,NA())","v":34.22},{"$f":"IF(B23>0,D23+B$4-B$5,NA())","v":35.020000000000003},null,null,{"$f":"E23+(1-B$9)*(F23-E23)","v":34.396000000000001},{"$f":"E23-E$21-E$7","v":0.44200000000000084},null,null,null,null,{"$f":"F23-E23","v":0.80000000000000426},null,null,null,null,null,0,{"$f":"MAX(V24:V81)/(MAX(L24:L81)-L24)","v":0.15839507568103245}]
[null,1,34.11,35.01,{"$f":"IF(B24>0,C24+B$4-B$5,NA())","v":34.11},{"$f":"IF(B24>0,D24+B$4-B$5,NA())","v":35.01},null,null,{"$f":"E24+(1-B$9)*(F24-E24)","v":34.308},0.33200000000000141,null,{"$f":"IF(B24>0,0.5*(B23+B24),0)","v":0.85833333333333339},{"$f":"IF(B24>0,1440*PI()*P24^2*(E23-E24+F24-F23)/(B24-B23),NA())","v":40.058810133074175},{"$f":"0.5*(J23+J24)","v":0.38700000000000112},{"$f":"F24-E24","v":0.89999999999999858},{"$f":"IF(B24>0,re(B$10,E24,F24,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,{"$f":"(E23+E24)/2","v":34.164999999999999},{"$f":"(F23+F24)/2","v":35.015000000000001},{"$f":"U23+M24*(B24-B23)*7.48/1440","v":5.8956924728260557E-2},0]
[null,2,34.03,34.99,34.03,34.99,null,null,34.241199999999999,0.25200000000000311,null,{"$f":"IF(B25>0,0.5*(B24+B25),0)","v":1.5},{"$f":"IF(B25>0,1440*PI()*P25^2*(E24-E25+F25-F24)/(B25-B24),NA())","v":6.8099977226232546},{"$f":"0.5*(J24+J25)","v":0.29200000000000226},{"$f":"F25-E25","v":0.96000000000000085},{"$f":"IF(B25>0,re(B$10,E25,F25,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,{"$f":"(E24+E25)/2","v":34.07},35,{"$f":"U24+M25*(B25-B24)*7.48/1440","v":9.4331079565220244E-2},{"$f":"IF(P25>0,V24+0.5*(P24+P25)*(L25-L24),0)","v":0.10163684022866248}]
[null,3.7,33.96,34.99,33.96,34.99,null,null,34.186599999999999,0.18200000000000285,null,2.85,4.6735278488589378,0.21700000000000297,1.0300000000000011,{"$f":"IF(B26>0,re(B$10,E26,F26,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,33.995000000000005,34.99,0.13560092687500513,{"$f":"IF(P26>0,V25+0.5*(P25+P26)*(L26-L25),0)","v":0.31547019239805629}]
[null,4.0999999999999996,33.92,35,33.92,35,null,null,34.157600000000002,0.14200000000000371,null,3.9,14.187495255463787,0.16200000000000328,1.0799999999999983,{"$f":"IF(B27>0,re(B$10,E27,F27,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,33.94,34.995000000000005,0.1650793892391354,0.48178502186314032]
[null,5.3,33.869999999999997,35.01,33.869999999999997,35.01,null,null,34.120799999999996,9.1999999999999429E-2,null,4.6999999999999993,5.6749981021860449,0.11700000000000157,1.1400000000000006,{"$f":"IF(B28>0,re(B$10,E28,F28,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,33.894999999999996,35.004999999999995,0.20045354407609509,0.60850108240796619]
[null,6.1833333333333336,33.86,35.03,33.86,35.03,null,null,34.117399999999996,8.2000000000001419E-2,null,5.7416666666666671,3.8547156920508971,8.7000000000000424E-2,1.1700000000000017,{"$f":"IF(B29>0,re(B$10,E29,F29,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,33.864999999999995,35.019999999999996,0.21814062149457492,0.77349595290904183]
[null,7.0333333333333332,33.840000000000003,35.04,33.840000000000003,35.04,null,null,34.103999999999999,6.2000000000005398E-2,null,6.6083333333333334,4.0058810133068494,7.2000000000003408E-2,1.1999999999999957,{"$f":"IF(B30>0,re(B$10,E30,F30,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,33.85,35.034999999999997,0.23582769891305055,0.91077168516593654]
[null,8.0500000000000007,33.840000000000003,35.06,33.840000000000003,35.06,null,null,34.108400000000003,6.2000000000005398E-2,null,7.541666666666667,2.2327861385652641,6.2000000000005398E-2,1.2199999999999989,{"$f":"IF(B31>0,re(B$10,E31,F31,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,33.840000000000003,35.049999999999997,0.24761908385870518,1.0586070891349002]
[null,9.0833333333333339,33.83,35.07,33.83,35.07,null,null,34.102800000000002,5.2000000000000282E-2,null,8.5666666666666664,2.1967734589109877,5.700000000000284E-2,1.240000000000002,{"$f":"IF(B32>0,re(B$10,E32,F32,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,33.835000000000001,35.064999999999998,0.25941046880435981,1.2209620417079583]
[null,10.199999999999999,33.83,35.090000000000003,33.83,35.090000000000003,null,null,34.107199999999999,5.2000000000000282E-2,null,9.6416666666666657,2.032835141081812,5.2000000000000282E-2,1.2600000000000051,{"$f":"IF(B33>0,re(B$10,E33,F33,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,33.83,35.08,0.27120185375001443,1.391236748065068]
[null,11.6,33.82,35.1,33.82,35.1,null,null,34.101599999999998,4.2000000000002272E-2,null,10.899999999999999,1.6214280291956287,4.7000000000001277E-2,1.2800000000000011,{"$f":"IF(B34>0,re(B$10,E34,F34,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,33.825000000000003,35.094999999999999,0.28299323869566484,1.5905505516303671]
[null,12.1,33.82,35.11,33.82,35.11,null,null,34.1038,4.2000000000002272E-2,null,11.85,2.2699992408738807,4.2000000000002272E-2,1.2899999999999991,{"$f":"IF(B35>0,re(B$10,E35,F35,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,33.82,35.105000000000004,0.28888893116849007,1.7410258735273481]
[null,13.1,33.82,35.119999999999997,33.82,35.119999999999997,null,null,34.106000000000002,4.2000000000002272E-2,null,12.6,1.1349996204369404,4.2000000000002272E-2,1.2999999999999972,{"$f":"IF(B36>0,re(B$10,E36,F36,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,33.82,35.114999999999995,0.2947846236413153,1.8598221802881223]
[null,14.3,33.81,35.130000000000003,33.81,35.130000000000003,null,null,34.1004,3.2000000000004261E-2,null,13.7,1.8916660340622375,3.7000000000003266E-2,1.3200000000000003,{"$f":"IF(B37>0,re(B$10,E37,F37,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,33.814999999999998,35.125,0.30657600858696993,2.034056763537258]
[null,16.2,33.81,35.14,33.81,35.14,null,null,34.102600000000002,3.2000000000004261E-2,null,15.25,0.59736822128260059,3.2000000000004261E-2,1.3299999999999983,{"$f":"IF(B38>0,re(B$10,E38,F38,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,33.81,35.135000000000005,0.31247170105979516,2.2795691308428583]
[null,17.100000000000001,33.81,35.15,33.81,35.15,null,null,34.104800000000004,3.2000000000004261E-2,null,16.649999999999999,1.2611106893743751,3.2000000000004261E-2,1.3399999999999963,{"$f":"IF(B39>0,re(B$10,E39,F39,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,33.81,35.144999999999996,0.31836739353262039,2.5013222367963035]
[null,18.2,33.81,35.159999999999997,33.81,35.159999999999997,null,null,34.106999999999999,3.2000000000004261E-2,null,17.649999999999999,1.0318178367608568,3.2000000000004261E-2,1.3499999999999943,{"$f":"IF(B40>0,re(B$10,E40,F40,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,33.81,35.155000000000001,0.32426308600544562,2.6597173124773361]
[null,21.2,33.799999999999997,35.17,33.799999999999997,35.17,null,null,34.101399999999998,2.1999999999999149E-2,null,19.7,0.75666641362516451,2.7000000000001703E-2,1.3700000000000045,{"$f":"IF(B41>0,re(B$10,E41,F41,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,33.805,35.164999999999999,0.33605447095110441,2.9844272176234528]
[null,23.1,33.799999999999997,35.18,33.799999999999997,35.18,null,null,34.1036,2.1999999999999149E-2,null,22.15,0.59736822128259948,2.1999999999999149E-2,1.3800000000000026,{"$f":"IF(B42>0,re(B$10,E42,F42,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,33.799999999999997,35.174999999999997,0.34195016342392964,3.372495153041982]
[null,25.2,33.799999999999997,35.19,33.799999999999997,35.19,null,null,{"$f":"E43+(1-B$9)*(F43-E43)","v":34.105799999999995},2.1999999999999149E-2,null,24.15,0.54047600973187693,{"$f":"0.5*(J42+J43)","v":2.1999999999999149E-2},{"$f":"F43-E43","v":1.3900000000000006},{"$f":"IF(B43>0,re(B$10,E43,F43,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,33.799999999999997,35.185000000000002,0.34784585589675487,3.6892853044040468]
[null,27.5,33.799999999999997,35.21,33.799999999999997,35.21,null,null,34.110199999999999,2.1999999999999149E-2,null,26.35,0.98695619168464632,2.1999999999999149E-2,1.4100000000000037,{"$f":"IF(B44>0,re(B$10,E44,F44,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,33.799999999999997,35.200000000000003,0.3596372408424095,4.0377544709023185]
[null,28.2,33.799999999999997,35.22,33.799999999999997,35.22,null,null,{"$f":"E45+(1-B$9)*(F45-E45)","v":34.112400000000001},2.1999999999999149E-2,null,27.85,1.6214280291956307,{"$f":"0.5*(J44+J45)","v":2.1999999999999149E-2},{"$f":"F45-E45","v":1.4200000000000017},{"$f":"IF(B45>0,re(B$10,E45,F45,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,33.799999999999997,35.215000000000003,0.36553293331523473,4.275347084423867]
[null,32.4,33.799999999999997,35.229999999999997,33.799999999999997,35.229999999999997,null,null,{"$f":"E46+(1-B$9)*(F46-E46)","v":34.114599999999996},{"$f":"E46-E$21-E$7","v":2.1999999999999149E-2},null,30.299999999999997,0.27023800486593824,{"$f":"0.5*(J45+J46)","v":2.1999999999999149E-2},{"$f":"F46-E46","v":1.4299999999999997},{"$f":"IF(B46>0,re(B$10,E46,F46,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,{"$f":"(E45+E46)/2","v":33.799999999999997},{"$f":"(F45+F46)/2","v":35.224999999999994},{"$f":"U45+M46*(B46-B45)*7.48/1440","v":0.37142862578805996},4.6634150198423958]
[null,34.299999999999997,33.79,35.24,33.79,35.24,null,null,34.109000000000002,1.2000000000001138E-2,null,33.349999999999994,1.1947364425656257,1.7000000000000143E-2,1.4500000000000028,{"$f":"IF(B47>0,re(B$10,E47,F47,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,33.795000000000002,35.234999999999999,0.38322001073371459,5.1465200006695442]
[null,38.299999999999997,33.79,35.25,33.79,35.25,null,null,34.111199999999997,1.2000000000001138E-2,null,36.299999999999997,0.28374990510923509,1.2000000000001138E-2,1.4600000000000009,{"$f":"IF(B48>0,re(B$10,E48,F48,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,33.79,35.245000000000005,0.38911570320653982,5.6137854739285906]
[null,40.1,33.79,35.26,33.79,35.26,null,null,34.113399999999999,1.2000000000001138E-2,null,39.200000000000003,0.63055534468718755,1.2000000000001138E-2,1.4699999999999989,{"$f":"IF(B49>0,re(B$10,E49,F49,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,33.79,35.254999999999995,0.39501139567936505,6.0731311934035856]
[null,49.1,33.79,35.28,33.79,35.28,null,null,34.117800000000003,1.2000000000001138E-2,null,44.6,0.25222213787496522,1.2000000000001138E-2,1.490000000000002,{"$f":"IF(B50>0,re(B$10,E50,F50,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,33.79,35.269999999999996,0.40680278062501968,6.9284646020811609]
[null,59.4,33.78,35.29,33.78,35.29,null,null,34.112200000000001,2.0000000000031277E-3,null,54.25,0.22038827581299819,7.000000000002133E-3,1.509999999999998,{"$f":"IF(B51>0,re(B$10,E51,F51,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,33.784999999999997,35.284999999999997,0.41859416557067008,8.4569770824031245]
[null,64.2,33.78,35.299999999999997,33.78,35.299999999999997,null,null,34.114400000000003,2.0000000000031277E-3,null,61.8,0.2364582542576957,2.0000000000031277E-3,1.519999999999996,{"$f":"IF(B52>0,re(B$10,E52,F52,B$6,B$14,B$13), )","v":0.15839507568103245},null,null,33.78,35.295000000000002,0.42448985804349532,9.6528599037949192]
[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"},{"$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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(P24:P81)","v":7.9197537840516266E-2}]

{"sheet":"Figures","index":2,"n_rows":88,"n_cols":22,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Figure 1",null,null,null,null,null,null,null,"Figure 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"0.8*MIN(Data!B23:B81)","v":0.57333333333333336},{"$f":"Data!E21","v":33.76}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(Data!B23:B81)","v":64.2},{"$f":"U3","v":33.76}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T3","v":0.57333333333333336},{"$f":"Data!F21","v":35.39}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T4","v":64.2},{"$f":"U5","v":35.39}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T4/4","v":16.05},{"$f":"IF(V8<V9,V8,NA())","v":{"$error":"#N/A"}},{"$f":"IF(Data!B10>Data!E21,Data!B10,Data!E21-1)","v":32.76}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T8","v":16.05},{"$f":"IF(V8<V9,V9,NA())","v":{"$error":"#N/A"}},{"$f":"IF(Data!B11<Data!F21,Data!B11,Data!F21+1)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Figure 3",null,null,null,null,null,null,null,"Figure 4"]
[null,"Qn (ft3/d)","sn (ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bn","sn"]
[null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.53,0]
[null,6,0.12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.27500000000000002]
[]
[]
[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.17973856209150327}]
[null,"Dsn (ft)",1.7999999999999999E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Figure 5",null,null,null,null,null,null,null,"Figure 6"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Figure 7",null,null,null,null,null,null,null,"Figure 8"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Figure 9",null,null,null,null,null,null,null,"Figure 10"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"t (min)","sn (ft)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,0.115]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,0]

{"sheet":"B&R","index":3,"n_rows":64,"n_cols":28,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["Generalized Bouwer and Rice (1976)"]
["Well Designation:",null,{"$f":"IF(Data!B1 > 0,Data!B1,\"\")","v":"YYY"}]
["Date:",null,{"$f":"IF(Data!B2 > 0,Data!B2,\"\")","v":"date"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"y = A + B x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B&R Type Curve"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Xi","Yi","X2","XY","(y-A-Bx)2","e","count","s/s0","SX",{"$f":"SUM(M6:M64)","v":355.79999999999995},null,"t (min)","s/s0",null,"Xi","Yi"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B23>=D$9,Data!B23-D$9,0)","v":0},{"$f":"IF(S6>0,LN(Data!J23),0)","v":0},{"$f":"M6^2","v":0},{"$f":"M6*N6","v":0},{"$f":"IF(M6>0,(N6-V$11-V$12*M6)^2,0)","v":0},{"$f":"IF(M6>0,(N6-V$11-V$12*M6)/SQRT(V$14),0)","v":0},{"$f":"IF(Data!B23>'B&R'!D$9,1,0)","v":0},{"$f":"IF(S6=0,NA(),EXP(N6)/EXP(V$19))","v":{"$error":"#N/A"}},"SY",{"$f":"SUM(N6:N64)","v":-79.25573371458654},null,0,{"$f":"EXP(-2*E$12*(X6/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":1},null,{"$f":"IF(S6>0,M6,NA())","v":{"$error":"#N/A"}},{"$f":"IF(T6>0,N6,NA())","v":{"$error":"#N/A"}}]
[null,"Enter early time cut-off for least-squares model fit",null,null,null,null,null,null,null,"Le/re",null,null,{"$f":"IF(Data!B24>=D$9,Data!B24-D$9,0)","v":0},{"$f":"IF(S7>0,LN(Data!J24),0)","v":0},{"$f":"M7^2","v":0},{"$f":"M7*N7","v":0},{"$f":"IF(M7>0,(N7-V$11-V$12*M7)^2,0)","v":0},{"$f":"IF(M7>0,(N7-V$11-V$12*M7)/SQRT(V$14),0)","v":0},{"$f":"IF(Data!B24>'B&R'!D$9,1,0)","v":0},{"$f":"IF(S7=0,NA(),EXP(N7)/EXP(V$19))","v":{"$error":"#N/A"}},"SX2",{"$f":"SUM(O6:O64)","v":11062.74},null,{"$f":"X6+1.05*(MAX(M$6:M$64)/30)","v":1.8970000000000002},{"$f":"EXP(-2*E$12*(X7/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.90246956126300826},null,{"$f":"IF(S7>0,M7,NA())","v":{"$error":"#N/A"}},{"$f":"IF(T7>0,N7,NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!E21<Data!B10,(Data!F21-Data!B10)/Data!B13,(Data!F21-Data!E21)/Data!B13)","v":10.290723957116001},null,null,{"$f":"IF(Data!B25>=D$9,Data!B25-D$9,0)","v":0},{"$f":"IF(S8>0,LN(Data!J25),0)","v":0},0,0,0,0,{"$f":"IF(Data!B25>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},"SXY",{"$f":"SUM(P6:P64)","v":-1665.9995185234341},null,{"$f":"X7+1.05*(MAX(M$6:M$64)/30)","v":3.7940000000000005},{"$f":"EXP(-2*E$12*(X8/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.81445130900624652},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"Timecut",10,"<-  Enter or change value here",null,null,null,null,"C",null,null,{"$f":"IF(Data!B26>=D$9,Data!B26-D$9,0)","v":0},{"$f":"IF(S9>0,LN(Data!J26),0)","v":0},0,0,0,0,{"$f":"IF(Data!B26>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},"N",{"$f":"SUM(S6:S64)","v":20},null,5.6910000000000007,{"$f":"EXP(-2*E$12*(X9/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.73501751550895011},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J8<2000,0.792+0.03993*J8-0.00005743^J8^2+0.00000003858*J8^3-0.000000000009659*J8^4,13.5)","v":1.2029505428968437},null,null,{"$f":"IF(Data!B27>=D$9,Data!B27-D$9,0)","v":0},{"$f":"IF(S10>0,LN(Data!J27),0)","v":0},0,0,0,0,{"$f":"IF(Data!B27>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},"D",{"$f":"V9*V7-V5^2","v":94661.160000000018},null,7.588000000000001,{"$f":"EXP(-2*E$12*(X10/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.66333093474198856},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,"R/re",null,null,{"$f":"IF(Data!B28>=D$9,Data!B28-D$9,0)","v":0},{"$f":"IF(S11>0,LN(Data!J28),0)","v":0},0,0,0,0,{"$f":"IF(Data!B28>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},"A",{"$f":"(V7*V6-V5*V8)/V10","v":-3.0004169281579398},null,9.4850000000000012,{"$f":"EXP(-2*E$12*(X11/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.59863597764878362},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Model Results:",null,"Tn (ft2/d) =",{"$f":"1440*V22*(-V12)","v":9.2344543334196096},"+/-",{"$f":"1440*V22*SQRT(V15)","v":0.65329503917636378},"ft2/d",null,{"$f":"EXP(((1.1/LN(J8))+J10/J8)^-1)","v":5.4658512835676119},null,null,{"$f":"IF(Data!B29>=D$9,Data!B29-D$9,0)","v":0},{"$f":"IF(S12>0,LN(Data!J29),0)","v":0},0,0,0,0,{"$f":"IF(Data!B29>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},"B",{"$f":"(V9*V8-V5*V6)/V10","v":-5.4096107789285405E-2},null,11.382000000000001,{"$f":"EXP(-2*E$12*(X12/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.54025074810494977},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B30>=D$9,Data!B30-D$9,0)","v":0},{"$f":"IF(S13>0,LN(Data!J30),0)","v":0},0,0,0,0,{"$f":"IF(Data!B30>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,13.279000000000002,{"$f":"EXP(-2*E$12*(X13/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.487559855614286},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,"J-Ratio",null,null,{"$f":"IF(Data!B31>=D$9,Data!B31-D$9,0)","v":0},{"$f":"IF(S14>0,LN(Data!J31),0)","v":0},0,0,0,0,{"$f":"IF(Data!B31>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},"sy2",{"$f":"SUM(Q6:Q64)/(V9-2)","v":6.9321844346280637E-2},null,15.176000000000002,{"$f":"EXP(-2*E$12*(X14/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.44000792898568025},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,{"$f":"Figures!U27","v":-0.17973856209150327},null,null,{"$f":"IF(Data!B32>=D$9,Data!B32-D$9,0)","v":0},{"$f":"IF(S15>0,LN(Data!J32),0)","v":0},0,0,0,0,{"$f":"IF(Data!B32>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},"sB2",{"$f":"V9*V14/V10","v":1.464631203468891E-5},null,17.073,{"$f":"EXP(-2*E$12*(X15/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.3970937626239518},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B33>=D$9,Data!B33-D$9,0)","v":0.19999999999999929},{"$f":"IF(S16>0,LN(Data!J33),0)","v":-2.9565115604007044},3.9999999999999716E-2,-0.59130231208013873,2.9947806757055313E-3,0.20784876896485932,{"$f":"IF(Data!B33>'B&R'!D$9,1,0)","v":1},1.0448834705434487,null,null,null,18.97,{"$f":"EXP(-2*E$12*(X16/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.35836503373551504},null,0.19999999999999929,-2.9565115604007044]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B34>=D$9,Data!B34-D$9,0)","v":1.5999999999999996},{"$f":"IF(S17>0,LN(Data!J34),0)","v":-3.1700856606987147},2.5599999999999987,-5.072137057117942,6.9080965887539413E-3,-0.3156778762704095,{"$f":"IF(Data!B34>'B&R'!D$9,1,0)","v":1},0.84394434159282672,null,null,null,20.866999999999997,{"$f":"EXP(-2*E$12*(X17/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.3234135347672934},null,1.5999999999999996,-3.1700856606987147]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B35>=D$9,Data!B35-D$9,0)","v":2.0999999999999996},{"$f":"IF(S18>0,LN(Data!J35),0)","v":-3.1700856606987147},4.4099999999999984,-6.6571798874672998,3.1434979689642186E-3,-0.21294700564611058,{"$f":"IF(Data!B35>'B&R'!D$9,1,0)","v":1},0.84394434159282672,"Plot Model Line",null,null,22.763999999999996,{"$f":"EXP(-2*E$12*(X18/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.29187087082795793},null,2.0999999999999996,-3.1700856606987147]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B36>=D$9,Data!B36-D$9,0)","v":3.0999999999999996},{"$f":"IF(S19>0,LN(Data!J36),0)","v":-3.1700856606987147},9.6099999999999977,-9.8272655481660145,3.8840463097540132E-6,-7.4852643975127277E-3,{"$f":"IF(Data!B36>'B&R'!D$9,1,0)","v":1},0.84394434159282672,0,{"$f":"V11","v":-3.0004169281579398},null,24.660999999999994,{"$f":"EXP(-2*E$12*(X19/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.26340457674155937},null,3.0999999999999996,-3.1700856606987147]
[null,null,null,null,null,null,null,null,null,"Coef. Of",null,null,{"$f":"IF(Data!B37>=D$9,Data!B37-D$9,0)","v":4.3000000000000007},{"$f":"IF(S20>0,LN(Data!J37),0)","v":-3.4420193761822775},18.490000000000006,-14.800683317583795,4.3676479250685935E-2,-0.79375917252677941,{"$f":"IF(Data!B37>'B&R'!D$9,1,0)","v":1},0.64300521264220434,{"$f":"MAX(M6:M64)","v":54.2},{"$f":"V11+V12*U20","v":-5.9324259703372091},null,26.557999999999993,{"$f":"EXP(-2*E$12*(X20/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.23771461280662354},null,4.3000000000000007,-3.4420193761822775]
[null,null,null,null,null,null,null,null,null,"Variation",null,null,{"$f":"IF(Data!B38>=D$9,Data!B38-D$9,0)","v":6.1999999999999993},{"$f":"IF(S21>0,LN(Data!J38),0)","v":-3.4420193761822775},38.439999999999991,-21.340520132330116,1.1279837578108021E-2,-0.40338186415444371,{"$f":"IF(Data!B38>'B&R'!D$9,1,0)","v":1},0.64300521264220434,null,null,null,28.454999999999991,{"$f":"EXP(-2*E$12*(X21/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.21453020232539941},null,6.1999999999999993,-3.4420193761822775]
[null,null,null,null,null,null,null,null,null,{"$f":"G12/E12","v":7.0745386309625305E-2},null,null,{"$f":"IF(Data!B39>=D$9,Data!B39-D$9,0)","v":7.1000000000000014},{"$f":"IF(S22>0,LN(Data!J39),0)","v":-3.4420193761822775},50.410000000000018,-24.438337570894173,3.3085599161629476E-3,-0.21846629703070519,{"$f":"IF(Data!B39>'B&R'!D$9,1,0)","v":1},0.64300521264220434,"factor",{"$f":"Data!V23^2*LN('B&R'!J12)/(2*(-Figures!U27))","v":0.11854485972074565},null,30.35199999999999,{"$f":"EXP(-2*E$12*(X22/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.19360697757026765},null,7.1000000000000014,-3.4420193761822775]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B40>=D$9,Data!B40-D$9,0)","v":8.1999999999999993},{"$f":"IF(S23>0,LN(Data!J40),0)","v":-3.4420193761822775},67.239999999999995,-28.224558884694673,3.9427497200787159E-6,7.5416183427518537E-3,{"$f":"IF(Data!B40>'B&R'!D$9,1,0)","v":1},0.64300521264220434,null,null,null,32.248999999999988,{"$f":"EXP(-2*E$12*(X23/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.17472440410529655},null,8.1999999999999993,-3.4420193761822775]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B41>=D$9,Data!B41-D$9,0)","v":11.2},{"$f":"IF(S24>0,LN(Data!J41),0)","v":-3.8167128256238598},125.43999999999998,-42.747183646987224,4.4276361866937536E-2,-0.79919159845772825,{"$f":"IF(Data!B41>'B&R'!D$9,1,0)","v":1},0.44206608369143963,null,null,null,34.145999999999987,{"$f":"EXP(-2*E$12*(X24/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.15768345631484754},null,11.2,-3.8167128256238598]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B42>=D$9,Data!B42-D$9,0)","v":13.100000000000001},{"$f":"IF(S25>0,LN(Data!J42),0)","v":-3.8167128256238598},171.61000000000004,-49.998938015672572,1.1585699104270373E-2,-0.40881429008539183,{"$f":"IF(Data!B42>'B&R'!D$9,1,0)","v":1},0.44206608369143963,"s0 (ft)",{"$f":"EXP(V19)","v":4.9766315063779154E-2},null,36.042999999999985,{"$f":"EXP(-2*E$12*(X25/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.14230451963889523},null,13.100000000000001,-3.8167128256238598]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B43>=D$9,Data!B43-D$9,0)","v":15.2},{"$f":"IF(S26>0,LN(Data!J43),0)","v":-3.8167128256238598},231.04,-58.014034949482664,3.5580520312921439E-5,2.2655366536663349E-2,{"$f":"IF(Data!B43>'B&R'!D$9,1,0)","v":1},0.44206608369143963,null," ",null,37.939999999999984,{"$f":"EXP(-2*E$12*(X26/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.12842549740425688},null,15.2,-3.8167128256238598]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B44>=D$9,Data!B44-D$9,0)","v":17.5},{"$f":"IF(S27>0,LN(Data!J44),0)","v":-3.8167128256238598},306.25,-66.792474448417551,1.7000506087499076E-2,0.49521737140843852,{"$f":"IF(Data!B44>'B&R'!D$9,1,0)","v":1},0.44206608369143963,null,null,null,39.836999999999982,{"$f":"EXP(-2*E$12*(X27/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.11590010229740332},null,17.5,-3.8167128256238598]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B45>=D$9,Data!B45-D$9,0)","v":18.2},{"$f":"IF(S28>0,LN(Data!J45),0)","v":-3.8167128256238598},331.23999999999995,-69.46417342635425,2.8309160947294142E-2,0.63904059028245663,{"$f":"IF(Data!B45>'B&R'!D$9,1,0)","v":1},0.44206608369143963,null,null,null,41.73399999999998,{"$f":"EXP(-2*E$12*(X28/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.10459631447067534},null,18.2,-3.8167128256238598]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B46>=D$9,Data!B46-D$9,0)","v":22.4},{"$f":"IF(S29>0,LN(Data!J46),0)","v":-3.8167128256238598},501.75999999999993,-85.494367293974449,0.15638617321427536,1.5019799035265673,{"$f":"IF(Data!B46>'B&R'!D$9,1,0)","v":1},0.44206608369143963,null,null,null,43.630999999999979,{"$f":"EXP(-2*E$12*(X29/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":9.4394990030078049E-2},null,22.4,-3.8167128256238598]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B47>=D$9,Data!B47-D$9,0)","v":24.299999999999997},{"$f":"IF(S30>0,LN(Data!J47),0)","v":-4.4228486291940419},590.4899999999999,-107.47522168941521,1.1641607616870874E-2,-0.40979949999884885,{"$f":"IF(Data!B47>'B&R'!D$9,1,0)","v":1},0.24112695474081747,null,null,null,45.527999999999977,{"$f":"EXP(-2*E$12*(X30/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":8.5188605237870543E-2},null,24.299999999999997,-4.4228486291940419]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B48>=D$9,Data!B48-D$9,0)","v":28.299999999999997},{"$f":"IF(S31>0,LN(Data!J48),0)","v":-4.4228486291940419},800.88999999999987,-125.16661620619138,1.1769678560383148E-2,0.41204746499554273,{"$f":"IF(Data!B48>'B&R'!D$9,1,0)","v":1},0.24112695474081747,null,null,null,47.424999999999976,{"$f":"EXP(-2*E$12*(X31/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":7.6880123193628663E-2},null,28.299999999999997,-4.4228486291940419]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B49>=D$9,Data!B49-D$9,0)","v":30.1},{"$f":"IF(S32>0,LN(Data!J49),0)","v":-4.4228486291940419},906.0100000000001,-133.12774373874066,4.2378810370761535E-2,0.78187859924301895,{"$f":"IF(Data!B49>'B&R'!D$9,1,0)","v":1},0.24112695474081747,null,null,null,49.321999999999974,{"$f":"EXP(-2*E$12*(X32/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":6.9381971048400076E-2},null,30.1,-4.4228486291940419]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B50>=D$9,Data!B50-D$9,0)","v":39.1},{"$f":"IF(S33>0,LN(Data!J50),0)","v":-4.4228486291940419},1528.8100000000002,-172.93338140148705,0.47986946835939215,2.6310342704804,{"$f":"IF(Data!B50>'B&R'!D$9,1,0)","v":1},0.24112695474081747,null,null,null,51.218999999999973,{"$f":"EXP(-2*E$12*(X33/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":6.2615116971612386E-2},null,39.1,-4.4228486291940419]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B51>=D$9,Data!B51-D$9,0)","v":49.4},{"$f":"IF(S34>0,LN(Data!J51),0)","v":-6.2146080984206282},2440.3599999999997,-307.001640061979,0.29359431940095698,-2.0579687216030162,{"$f":"IF(Data!B51>'B&R'!D$9,1,0)","v":1},4.018782579019526E-2,null,null,null,53.115999999999971,{"$f":"EXP(-2*E$12*(X34/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":5.6508237141802968E-2},null,49.4,-6.2146080984206282]
[null,"C coefficient calculated from Eq. 6.5(c) of Butler, The Design, Performance, and",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B52>=D$9,Data!B52-D$9,0)","v":54.2},{"$f":"IF(S35>0,LN(Data!J52),0)","v":-6.2146080984206282},2937.6400000000003,-336.83175893439807,7.9626753409687168E-2,-1.0717523636097448,{"$f":"IF(Data!B52>'B&R'!D$9,1,0)","v":1},4.018782579019526E-2,null,null,null,55.01299999999997,{"$f":"EXP(-2*E$12*(X35/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":5.0996963981108978E-2},null,54.2,-6.2146080984206282]
[null,"Analysis of Slug Tests, CRC Press, 2000.",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B53>=D$9,Data!B53-D$9,0)","v":0},{"$f":"IF(S36>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,56.909999999999968,{"$f":"EXP(-2*E$12*(X36/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":4.6023207709776852E-2},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,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(S37>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,null,null,null,{"$error":"#N/A"},{"$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(S38>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,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(S39>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,{"$f":"TRUNC(100*E12)/100","v":9.23},null,null,{"$error":"#N/A"},{"$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(S40>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":"X39","v":9.23},null,null,{"$error":"#N/A"},{"$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(S41>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":"CONCATENATE(\" T = \",X40,\" ft2/d\")","v":" T = 9.23 ft2/d"},null,null,{"$error":"#N/A"},{"$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(S42>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,null,null,null,{"$error":"#N/A"},{"$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(S43>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,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(S44>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,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(S45>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,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(S46>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,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(S47>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,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(S48>0,LN(Data!J65),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!B65>'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,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(S49>0,LN(Data!J66),0)","v":0},0,0,0,0,{"$f":"IF(Data!B66>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B67>=D$9,Data!B67-D$9,0)","v":0},{"$f":"IF(S50>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,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(S51>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,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(S52>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,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(S53>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,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(S54>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,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(S55>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,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(S56>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,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(S57>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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B75>=D$9,Data!B75-D$9,0)","v":0},{"$f":"IF(S58>0,LN(Data!J75),0)","v":0},0,0,0,0,{"$f":"IF(Data!B75>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B76>=D$9,Data!B76-D$9,0)","v":0},{"$f":"IF(S59>0,LN(Data!J76),0)","v":0},0,0,0,0,{"$f":"IF(Data!B76>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B77>=D$9,Data!B77-D$9,0)","v":0},{"$f":"IF(S60>0,LN(Data!J77),0)","v":0},0,0,0,0,{"$f":"IF(Data!B77>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B78>=D$9,Data!B78-D$9,0)","v":0},{"$f":"IF(S61>0,LN(Data!J78),0)","v":0},{"$f":"M61^2","v":0},{"$f":"M61*N61","v":0},0,{"$f":"IF(M61>0,(N61-V$11-V$12*M61)/SQRT(V$14),0)","v":0},{"$f":"IF(Data!B78>'B&R'!D$9,1,0)","v":0},{"$f":"IF(S61=0,NA(),EXP(N61)/EXP(V$19))","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B79>=D$9,Data!B79-D$9,0)","v":0},{"$f":"IF(S62>0,LN(Data!J79),0)","v":0},0,0,0,0,{"$f":"IF(Data!B79>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B80>=D$9,Data!B80-D$9,0)","v":0},{"$f":"IF(S63>0,LN(Data!J80),0)","v":0},0,0,0,0,{"$f":"IF(Data!B80>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B81>=D$9,Data!B81-D$9,0)","v":0},{"$f":"IF(S64>0,LN(Data!J81),0)","v":0},0,0,0,0,{"$f":"IF(Data!B81>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"C&J","index":4,"n_rows":66,"n_cols":26,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
["Cooper and Jacob (1946)"]
["Well Designation:",null,{"$f":"IF(Data!B1 > 0,Data!B1,\"\")","v":"YYY"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E10","v":6},{"$f":"E9","v":10},0]
["Date:",null,{"$f":"IF(Data!B2 > 0,Data!B2,\"\")","v":"date"},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"MAX(P9:Q58)","v":0.1532880042934808},null,null,null,null,null,{"$f":"W2","v":6},{"$f":"X2","v":10},{"$f":"J50","v":70}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"Q3","v":0.1532880042934808}]
[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":71.8}]
[]
[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,10,"<-  Enter or change values here",null,null,null,null,null,null,null,1,{"$f":"IF(Data!L24>=E$9,Data!L24-E$10,0)","v":0},{"$f":"IF(O9>0,7.48*Data!M24*(Data!B24-Data!B23)/1440,0)","v":0},{"$f":"IF(O9>0,7.48*(4*PI()*(E$16/1440)*Data!N24)*(Data!B24-Data!B23)/LN(0.56146/((Data!P24^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O9))),0)","v":0},{"$f":"(P9-Q9)^2","v":0},null,{"$f":"Data!L24","v":0.85833333333333339},{"$f":"Data!M24/Data!N24","v":103.51113729476501},null,0,{"$f":"2+(X$5-2)*W9/50","v":2},{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X9/1440)))","v":52.640998970134603},{"$f":"X9+E$10","v":8}]
[null,"  Time Adjustment (min):",null,null,6,null,null,null,null,null,null,null,null,2,{"$f":"IF(Data!L25>=E$9,Data!L25-E$10,0)","v":0},{"$f":"IF(O10>0,P9+7.48*Data!M25*(Data!B25-Data!B24)/1440,0)","v":0},{"$f":"IF(O10>0,Q9+7.48*(4*PI()*(E$16/1440)*Data!N25)*(Data!B25-Data!B24)/LN(0.56146/((Data!P25^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O10))),0)","v":0},{"$f":"(P10-Q10)^2","v":0},null,{"$f":"Data!L25","v":1.5},{"$f":"Data!M25/Data!N25","v":23.321910008983568},null,1,{"$f":"2+(X$5-2)*W10/50","v":3.3959999999999999},{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X10/1440)))","v":44.375837634214172},{"$f":"X10+E$10","v":9.3960000000000008}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(Data!L26>=E$9,Data!L26-E$10,0)","v":0},{"$f":"IF(O11>0,P10+7.48*Data!M26*(Data!B26-Data!B25)/1440,0)","v":0},{"$f":"IF(O11>0,Q10+7.48*(4*PI()*(E$16/1440)*Data!N26)*(Data!B26-Data!B25)/LN(0.56146/((Data!P26^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O11))),0)","v":0},0,null,{"$f":"Data!L26","v":2.85},{"$f":"Data!M26/Data!N26","v":21.536994695202182},null,2,4.7919999999999998,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X11/1440)))","v":40.264155473480258},10.792]
[null,"Trial Sn:",null,null,"d","<-- Enter d for default or enter Sn value",null,null,null,null,null,null,null,4,{"$f":"IF(Data!L27>=E$9,Data!L27-E$10,0)","v":0},{"$f":"IF(O12>0,P11+7.48*Data!M27*(Data!B27-Data!B26)/1440,0)","v":0},{"$f":"IF(O12>0,Q11+7.48*(4*PI()*(E$16/1440)*Data!N27)*(Data!B27-Data!B26)/LN(0.56146/((Data!P27^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O12))),0)","v":0},0,null,{"$f":"Data!L27","v":3.9},{"$f":"Data!M27/Data!N27","v":87.577131206564815},null,3,6.1879999999999997,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X12/1440)))","v":37.67255430136607},12.187999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(Data!L28>=E$9,Data!L28-E$10,0)","v":0},{"$f":"IF(O13>0,P12+7.48*Data!M28*(Data!B28-Data!B27)/1440,0)","v":0},{"$f":"IF(O13>0,Q12+7.48*(4*PI()*(E$16/1440)*Data!N28)*(Data!B28-Data!B27)/LN(0.56146/((Data!P28^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O13))),0)","v":0},0,null,{"$f":"Data!L28","v":4.6999999999999993},{"$f":"Data!M28/Data!N28","v":48.504257283640754},null,4,7.5839999999999996,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X13/1440)))","v":35.837173730678863},13.584]
[null,"Root-Mean-Square Error:",null,null,{"$f":"SQRT(SUM(R9:R58))","v":1.5737324911994394E-2},"<-- Minimize this using \"Solver\"",null,null,null,null,null,null,null,6,{"$f":"IF(Data!L29>=E$9,Data!L29-E$10,0)","v":0},{"$f":"IF(O14>0,P13+7.48*Data!M29*(Data!B29-Data!B28)/1440,0)","v":0},{"$f":"IF(O14>0,Q13+7.48*(4*PI()*(E$16/1440)*Data!N29)*(Data!B29-Data!B28)/LN(0.56146/((Data!P29^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O14))),0)","v":0},0,null,{"$f":"Data!L29","v":5.7416666666666671},{"$f":"Data!M29/Data!N29","v":44.307076920125041},null,5,8.98,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X14/1440)))","v":34.443449570065347},14.98]
[null,null,null,null,{"$f":"IF(E12=\"d\",0.025*SQRT(E16),E12)","v":8.6269578179132153E-2},"<-- Working Sn",null,null,null,null,null,null,null,7,{"$f":"IF(Data!L30>=E$9,Data!L30-E$10,0)","v":0},{"$f":"IF(O15>0,P14+7.48*Data!M30*(Data!B30-Data!B29)/1440,0)","v":0},{"$f":"IF(O15>0,Q14+7.48*(4*PI()*(E$16/1440)*Data!N30)*(Data!B30-Data!B29)/LN(0.56146/((Data!P30^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O15))),0)","v":0},0,null,{"$f":"Data!L30","v":6.6083333333333334},{"$f":"Data!M30/Data!N30","v":55.637236295925831},null,6,10.375999999999999,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X15/1440)))","v":33.334751767934129},16.375999999999998]
[null,"Trial Tn (ft2/d):",null,null,11.90790419072863,"<-- By changing Tn through \"Solver\"",null,null,null,null,null,null,null,8,{"$f":"IF(Data!L31>=E$9,Data!L31-E$10,0)","v":0},{"$f":"IF(O16>0,P15+7.48*Data!M31*(Data!B31-Data!B30)/1440,0)","v":0},{"$f":"IF(O16>0,Q15+7.48*(4*PI()*(E$16/1440)*Data!N31)*(Data!B31-Data!B30)/LN(0.56146/((Data!P31^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O16))),0)","v":0},0,null,{"$f":"Data!L31","v":7.541666666666667},{"$f":"Data!M31/Data!N31","v":36.012679654275317},null,7,11.771999999999998,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X16/1440)))","v":32.423029338482117},17.771999999999998]
[null,null,null,null,null,null,"Add constraint Tn > 0.00001",null,null,null,null,null,null,9,{"$f":"IF(Data!L32>=E$9,Data!L32-E$10,0)","v":0},{"$f":"IF(O17>0,P16+7.48*Data!M32*(Data!B32-Data!B31)/1440,0)","v":0},{"$f":"IF(O17>0,Q16+7.48*(4*PI()*(E$16/1440)*Data!N32)*(Data!B32-Data!B31)/LN(0.56146/((Data!P32^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O17))),0)","v":0},0,null,{"$f":"Data!L32","v":8.5666666666666664},{"$f":"Data!M32/Data!N32","v":38.539885244050495},null,8,13.167999999999999,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X17/1440)))","v":31.654402297284054},19.167999999999999]
[null,"Model Result:",null,"Tn (ft2/d) =",{"$f":"E16","v":11.90790419072863},null,null,null,null,null,null,null,null,10,{"$f":"IF(Data!L33>=E$9,Data!L33-E$10,0)","v":0},{"$f":"IF(O18>0,P17+7.48*Data!M33*(Data!B33-Data!B32)/1440,0)","v":0},{"$f":"IF(O18>0,Q17+7.48*(4*PI()*(E$16/1440)*Data!N33)*(Data!B33-Data!B32)/LN(0.56146/((Data!P33^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O18))),0)","v":0},0,null,{"$f":"Data!L33","v":9.6416666666666657},{"$f":"Data!M33/Data!N33","v":39.092983482342326},null,9,14.563999999999998,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X18/1440)))","v":30.993762571790477},20.564]
[null,null,null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"IF(Data!L34>=E$9,Data!L34-E$10,0)","v":4.8999999999999986},{"$f":"IF(O19>0,P18+7.48*Data!M34*(Data!B34-Data!B33)/1440,0)","v":1.1791384945650435E-2},{"$f":"IF(O19>0,Q18+7.48*(4*PI()*(E$16/1440)*Data!N34)*(Data!B34-Data!B33)/LN(0.56146/((Data!P34^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O19))),0)","v":1.3680025975066188E-2},3.5669649379925944E-6,null,{"$f":"Data!L34","v":10.899999999999999},{"$f":"Data!M34/Data!N34","v":34.498468706289032},null,10,15.96,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X19/1440)))","v":30.417097149302467},21.96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,12,{"$f":"IF(Data!L35>=E$9,Data!L35-E$10,0)","v":5.85},{"$f":"IF(O20>0,P19+7.48*Data!M35*(Data!B35-Data!B34)/1440,0)","v":1.7687077418475652E-2},{"$f":"IF(O20>0,Q19+7.48*(4*PI()*(E$16/1440)*Data!N35)*(Data!B35-Data!B34)/LN(0.56146/((Data!P35^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O20))),0)","v":1.7848419883020356E-2},2.6031390865358788E-8,null,{"$f":"Data!L35","v":11.85},{"$f":"Data!M35/Data!N35","v":54.047600973184714},null,11,17.356000000000002,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X20/1440)))","v":29.907335431979714},23.356000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,13,{"$f":"IF(Data!L36>=E$9,Data!L36-E$10,0)","v":6.6},{"$f":"IF(O21>0,P20+7.48*Data!M36*(Data!B36-Data!B35)/1440,0)","v":2.358276989130087E-2},{"$f":"IF(O21>0,Q20+7.48*(4*PI()*(E$16/1440)*Data!N36)*(Data!B36-Data!B35)/LN(0.56146/((Data!P36^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O21))),0)","v":2.5936072145084352E-2},5.5380314976624157E-6,null,{"$f":"Data!L36","v":12.6},{"$f":"Data!M36/Data!N36","v":27.023800486592357},null,12,18.751999999999999,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X21/1440)))","v":29.451954179284535},24.751999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,14,{"$f":"IF(Data!L37>=E$9,Data!L37-E$10,0)","v":7.6999999999999993},{"$f":"IF(O22>0,P21+7.48*Data!M37*(Data!B37-Data!B36)/1440,0)","v":3.5374154836955496E-2},{"$f":"IF(O22>0,Q21+7.48*(4*PI()*(E$16/1440)*Data!N37)*(Data!B37-Data!B36)/LN(0.56146/((Data!P37^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O22))),0)","v":3.4171380639322256E-2},1.4466657704922839E-6,null,{"$f":"Data!L37","v":13.7},{"$f":"Data!M37/Data!N37","v":51.126109028704612},null,13,20.148,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X22/1440)))","v":29.04152270388737},26.148]
[null,null,null,null,null,null,null,null,null,null,null,null,null,15,{"$f":"IF(Data!L38>=E$9,Data!L38-E$10,0)","v":9.25},{"$f":"IF(O23>0,P22+7.48*Data!M38*(Data!B38-Data!B37)/1440,0)","v":4.1269847309780713E-2},{"$f":"IF(O23>0,Q22+7.48*(4*PI()*(E$16/1440)*Data!N38)*(Data!B38-Data!B37)/LN(0.56146/((Data!P38^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O23))),0)","v":4.4975716119900436E-2},1.3733463637818166E-5,null,{"$f":"Data!L38","v":15.25},{"$f":"Data!M38/Data!N38","v":18.667756915078783},null,14,21.543999999999997,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X23/1440)))","v":28.668780579584386},27.543999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,16,{"$f":"IF(Data!L39>=E$9,Data!L39-E$10,0)","v":10.649999999999999},{"$f":"IF(O24>0,P23+7.48*Data!M39*(Data!B39-Data!B38)/1440,0)","v":4.7165539782605931E-2},{"$f":"IF(O24>0,Q23+7.48*(4*PI()*(E$16/1440)*Data!N39)*(Data!B39-Data!B38)/LN(0.56146/((Data!P39^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O24))),0)","v":4.993380675362586E-2},7.6633020228398559E-6,null,{"$f":"Data!L39","v":16.649999999999999},{"$f":"Data!M39/Data!N39","v":39.409709042943973},null,15,22.94,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X24/1440)))","v":28.328031544685725},28.94]
[null,null,null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"IF(Data!L40>=E$9,Data!L40-E$10,0)","v":11.649999999999999},{"$f":"IF(O25>0,P24+7.48*Data!M40*(Data!B40-Data!B39)/1440,0)","v":5.3061232255431148E-2},{"$f":"IF(O25>0,Q24+7.48*(4*PI()*(E$16/1440)*Data!N40)*(Data!B40-Data!B39)/LN(0.56146/((Data!P40^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O25))),0)","v":5.5875589583482134E-2},7.9206071699542835E-6,null,{"$f":"Data!L40","v":17.649999999999999},{"$f":"Data!M40/Data!N40","v":32.244307398772484},null,16,24.335999999999999,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X25/1440)))","v":28.014732802718676},30.335999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,18,{"$f":"IF(Data!L41>=E$9,Data!L41-E$10,0)","v":13.7},{"$f":"IF(O26>0,P25+7.48*Data!M41*(Data!B41-Data!B40)/1440,0)","v":6.4852617201089965E-2},{"$f":"IF(O26>0,Q25+7.48*(4*PI()*(E$16/1440)*Data!N41)*(Data!B41-Data!B40)/LN(0.56146/((Data!P41^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O26))),0)","v":6.9083520345323363E-2},1.7900541415884047E-5,null,{"$f":"Data!L41","v":19.7},{"$f":"Data!M41/Data!N41","v":28.024681986115436},null,17,25.731999999999999,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X26/1440)))","v":27.72520926837198},31.731999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,19,{"$f":"IF(Data!L42>=E$9,Data!L42-E$10,0)","v":16.149999999999999},{"$f":"IF(O27>0,P26+7.48*Data!M42*(Data!B42-Data!B41)/1440,0)","v":7.0748309673915183E-2},{"$f":"IF(O27>0,Q26+7.48*(4*PI()*(E$16/1440)*Data!N42)*(Data!B42-Data!B41)/LN(0.56146/((Data!P42^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O27))),0)","v":7.5672067736929888E-2},2.4243393463102318E-5,null,{"$f":"Data!L42","v":22.15},{"$f":"Data!M42/Data!N42","v":27.153100967391936},null,18,27.127999999999997,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X27/1440)))","v":27.456450107977471},33.128]
[null,null,null,null,null,null,null,null,null,null,null,null,null,20,{"$f":"IF(Data!L43>=E$9,Data!L43-E$10,0)","v":18.149999999999999},{"$f":"IF(O28>0,P27+7.48*Data!M43*(Data!B43-Data!B42)/1440,0)","v":7.66440021467404E-2},{"$f":"IF(O28>0,Q27+7.48*(4*PI()*(E$16/1440)*Data!N43)*(Data!B43-Data!B42)/LN(0.56146/((Data!P43^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O28))),0)","v":8.278573126576845E-2},3.7720836571517068E-5,null,{"$f":"Data!L43","v":24.15},{"$f":"Data!M43/Data!N43","v":24.567091351449903},null,19,28.524000000000001,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X28/1440)))","v":27.205960904119575},34.524000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,21,{"$f":"IF(Data!L44>=E$9,Data!L44-E$10,0)","v":20.350000000000001},{"$f":"IF(O29>0,P28+7.48*Data!M44*(Data!B44-Data!B43)/1440,0)","v":8.8435387092395026E-2},{"$f":"IF(O29>0,Q28+7.48*(4*PI()*(E$16/1440)*Data!N44)*(Data!B44-Data!B43)/LN(0.56146/((Data!P44^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O29))),0)","v":9.0404222738497006E-2},3.8763138013617991E-6,null,{"$f":"Data!L44","v":26.35},{"$f":"Data!M44/Data!N44","v":44.861645076576572},null,20,29.92,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X29/1440)))","v":26.97165428601534},35.92]
[null,null,null,null,null,null,null,null,null,null,null,null,null,22,{"$f":"IF(Data!L45>=E$9,Data!L45-E$10,0)","v":21.85},{"$f":"IF(O30>0,P29+7.48*Data!M45*(Data!B45-Data!B44)/1440,0)","v":9.4331079565220244E-2},{"$f":"IF(O30>0,Q29+7.48*(4*PI()*(E$16/1440)*Data!N45)*(Data!B45-Data!B44)/LN(0.56146/((Data!P45^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O30))),0)","v":9.2691385890641048E-2},2.6885953464550251E-6,null,{"$f":"Data!L45","v":27.85},{"$f":"Data!M45/Data!N45","v":73.701274054349696},null,21,31.315999999999999,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X30/1440)))","v":26.751767705839281},37.316000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,23,{"$f":"IF(Data!L46>=E$9,Data!L46-E$10,0)","v":24.299999999999997},{"$f":"IF(O31>0,P30+7.48*Data!M46*(Data!B46-Data!B45)/1440,0)","v":0.10022677203804546},{"$f":"IF(O31>0,Q30+7.48*(4*PI()*(E$16/1440)*Data!N46)*(Data!B46-Data!B45)/LN(0.56146/((Data!P46^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O31))),0)","v":0.10614125145147443},3.4981066731875115E-5,null,{"$f":"Data!L46","v":30.299999999999997},{"$f":"Data!M46/Data!N46","v":12.283545675724941},null,22,32.712000000000003,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X31/1440)))","v":26.544800723809619},38.712000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,24,{"$f":"IF(Data!L47>=E$9,Data!L47-E$10,0)","v":27.349999999999994},{"$f":"IF(O32>0,P31+7.48*Data!M47*(Data!B47-Data!B46)/1440,0)","v":0.11201815698370009},{"$f":"IF(O32>0,Q31+7.48*(4*PI()*(E$16/1440)*Data!N47)*(Data!B47-Data!B46)/LN(0.56146/((Data!P47^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O32))),0)","v":0.11074103129784599},1.6310500174683046E-6,null,{"$f":"Data!L47","v":33.349999999999994},{"$f":"Data!M47/Data!N47","v":70.278614268565619},null,23,34.107999999999997,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X32/1440)))","v":26.349466544848092},40.107999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,25,{"$f":"IF(Data!L48>=E$9,Data!L48-E$10,0)","v":30.299999999999997},{"$f":"IF(O33>0,P32+7.48*Data!M48*(Data!B48-Data!B47)/1440,0)","v":0.1179138494565253},{"$f":"IF(O33>0,Q32+7.48*(4*PI()*(E$16/1440)*Data!N48)*(Data!B48-Data!B47)/LN(0.56146/((Data!P48^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O33))),0)","v":0.11745070068877331},2.1450678107019365E-7,null,{"$f":"Data!L48","v":36.299999999999997},{"$f":"Data!M48/Data!N48","v":23.645825425767349},null,24,35.503999999999998,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X33/1440)))","v":26.164654121734593},41.503999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,26,{"$f":"IF(Data!L49>=E$9,Data!L49-E$10,0)","v":33.200000000000003},{"$f":"IF(O34>0,P33+7.48*Data!M49*(Data!B49-Data!B48)/1440,0)","v":0.12380954192935052},{"$f":"IF(O34>0,Q33+7.48*(4*PI()*(E$16/1440)*Data!N49)*(Data!B49-Data!B48)/LN(0.56146/((Data!P49^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O34))),0)","v":0.12042122434892087},1.1480696025848641E-5,null,{"$f":"Data!L49","v":39.200000000000003},{"$f":"Data!M49/Data!N49","v":52.546278723927308},null,25,36.9,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X34/1440)))","v":25.989398198848093},42.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,27,{"$f":"IF(Data!L50>=E$9,Data!L50-E$10,0)","v":38.6},{"$f":"IF(O35>0,P34+7.48*Data!M50*(Data!B50-Data!B49)/1440,0)","v":0.13560092687500513},{"$f":"IF(O35>0,Q34+7.48*(4*PI()*(E$16/1440)*Data!N50)*(Data!B50-Data!B49)/LN(0.56146/((Data!P50^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O35))),0)","v":0.13488810672837248},5.0811256144539744E-7,null,{"$f":"Data!L50","v":44.6},{"$f":"Data!M50/Data!N50","v":21.01851148957844},null,26,38.295999999999999,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X35/1440)))","v":25.822855397089679},44.295999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,28,{"$f":"IF(Data!L51>=E$9,Data!L51-E$10,0)","v":48.25},{"$f":"IF(O36>0,P35+7.48*Data!M51*(Data!B51-Data!B50)/1440,0)","v":0.14739231182065557},{"$f":"IF(O36>0,Q35+7.48*(4*PI()*(E$16/1440)*Data!N51)*(Data!B51-Data!B50)/LN(0.56146/((Data!P51^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O36))),0)","v":0.14418844696159594},1.0264750035117182E-5,null,{"$f":"Data!L51","v":54.25},{"$f":"Data!M51/Data!N51","v":31.484039401847291},null,27,39.692,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X36/1440)))","v":25.664284947129932},45.692]
[null,null,null,null,null,null,null,null,null,null,null,null,null,29,{"$f":"IF(Data!L52>=E$9,Data!L52-E$10,0)","v":55.8},{"$f":"IF(O37>0,P36+7.48*Data!M52*(Data!B52-Data!B51)/1440,0)","v":0.1532880042934808},{"$f":"IF(O37>0,Q36+7.48*(4*PI()*(E$16/1440)*Data!N52)*(Data!B52-Data!B51)/LN(0.56146/((Data!P52^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O37))),0)","v":0.14539760086862924},6.2258466206909245E-5,null,{"$f":"Data!L52","v":61.8},{"$f":"Data!M52/Data!N52","v":118.22912712866295},null,28,41.087999999999994,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X37/1440)))","v":25.513033036641367},47.087999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,30,{"$f":"IF(Data!L53>=E$9,Data!L53-E$10,0)","v":0},{"$f":"IF(O38>0,P37+7.48*Data!M53*(Data!B53-Data!B52)/1440,0)","v":0},{"$f":"IF(O38>0,Q37+7.48*(4*PI()*(E$16/1440)*Data!N53)*(Data!B53-Data!B52)/LN(0.56146/((Data!P53^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O38))),0)","v":0},0,null,{"$f":"Data!L53","v":0},{"$f":"Data!M53/Data!N53","v":{"$error":"#N/A"}},null,29,42.483999999999995,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X38/1440)))","v":25.368519994449557},48.483999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,31,{"$f":"IF(Data!L54>=E$9,Data!L54-E$10,0)","v":0},{"$f":"IF(O39>0,P38+7.48*Data!M54*(Data!B54-Data!B53)/1440,0)","v":0},{"$f":"IF(O39>0,Q38+7.48*(4*PI()*(E$16/1440)*Data!N54)*(Data!B54-Data!B53)/LN(0.56146/((Data!P54^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O39))),0)","v":0},0,null,{"$f":"Data!L54","v":0},{"$f":"Data!M54/Data!N54","v":{"$error":"#N/A"}},null,30,43.88,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X39/1440)))","v":25.230229721520189},49.88]
[null,null,null,null,null,null,null,null,null,null,null,null,null,32,{"$f":"IF(Data!L55>=E$9,Data!L55-E$10,0)","v":0},{"$f":"IF(O40>0,P39+7.48*Data!M55*(Data!B55-Data!B54)/1440,0)","v":0},{"$f":"IF(O40>0,Q39+7.48*(4*PI()*(E$16/1440)*Data!N55)*(Data!B55-Data!B54)/LN(0.56146/((Data!P55^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O40))),0)","v":0},0,null,{"$f":"Data!L55","v":0},{"$f":"Data!M55/Data!N55","v":{"$error":"#N/A"}},null,31,45.275999999999996,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X40/1440)))","v":25.097700916207742},51.275999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,33,{"$f":"IF(Data!L56>=E$9,Data!L56-E$10,0)","v":0},{"$f":"IF(O41>0,P40+7.48*Data!M56*(Data!B56-Data!B55)/1440,0)","v":0},{"$f":"IF(O41>0,Q40+7.48*(4*PI()*(E$16/1440)*Data!N56)*(Data!B56-Data!B55)/LN(0.56146/((Data!P56^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O41))),0)","v":0},0,null,{"$f":"Data!L56","v":0},{"$f":"Data!M56/Data!N56","v":{"$error":"#N/A"}},null,32,46.671999999999997,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X41/1440)))","v":24.970519743428351},52.671999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,34,{"$f":"IF(Data!L57>=E$9,Data!L57-E$10,0)","v":0},{"$f":"IF(O42>0,P41+7.48*Data!M57*(Data!B57-Data!B56)/1440,0)","v":0},{"$f":"IF(O42>0,Q41+7.48*(4*PI()*(E$16/1440)*Data!N57)*(Data!B57-Data!B56)/LN(0.56146/((Data!P57^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O42))),0)","v":0},0,null,{"$f":"Data!L57","v":0},{"$f":"Data!M57/Data!N57","v":{"$error":"#N/A"}},null,33,48.068000000000005,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X42/1440)))","v":24.848313674210079},54.068000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,35,{"$f":"IF(Data!L58>=E$9,Data!L58-E$10,0)","v":0},{"$f":"IF(O43>0,P42+7.48*Data!M58*(Data!B58-Data!B57)/1440,0)","v":0},{"$f":"IF(O43>0,Q42+7.48*(4*PI()*(E$16/1440)*Data!N58)*(Data!B58-Data!B57)/LN(0.56146/((Data!P58^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O43))),0)","v":0},0,null,{"$f":"Data!L58","v":0},{"$f":"Data!M58/Data!N58","v":{"$error":"#N/A"}},null,34,49.463999999999999,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X43/1440)))","v":24.730746280302473},55.463999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,36,{"$f":"IF(Data!L59>=E$9,Data!L59-E$10,0)","v":0},{"$f":"IF(O44>0,P43+7.48*Data!M59*(Data!B59-Data!B58)/1440,0)","v":0},{"$f":"IF(O44>0,Q43+7.48*(4*PI()*(E$16/1440)*Data!N59)*(Data!B59-Data!B58)/LN(0.56146/((Data!P59^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O44))),0)","v":0},0,null,{"$f":"Data!L59","v":0},{"$f":"Data!M59/Data!N59","v":{"$error":"#N/A"}},null,35,50.86,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X44/1440)))","v":24.617512813075521},56.86]
[null,null,null,null,null,null,null,null,null,null,null,null,null,37,{"$f":"IF(Data!L60>=E$9,Data!L60-E$10,0)","v":0},{"$f":"IF(O45>0,P44+7.48*Data!M60*(Data!B60-Data!B59)/1440,0)","v":0},{"$f":"IF(O45>0,Q44+7.48*(4*PI()*(E$16/1440)*Data!N60)*(Data!B60-Data!B59)/LN(0.56146/((Data!P60^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O45))),0)","v":0},0,null,{"$f":"Data!L60","v":0},{"$f":"Data!M60/Data!N60","v":{"$error":"#N/A"}},null,36,52.255999999999993,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X45/1440)))","v":24.508336430305089},58.255999999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,38,{"$f":"IF(Data!L61>=E$9,Data!L61-E$10,0)","v":0},{"$f":"IF(O46>0,P45+7.48*Data!M61*(Data!B61-Data!B60)/1440,0)","v":0},{"$f":"IF(O46>0,Q45+7.48*(4*PI()*(E$16/1440)*Data!N61)*(Data!B61-Data!B60)/LN(0.56146/((Data!P61^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O46))),0)","v":0},0,null,{"$f":"Data!L61","v":0},{"$f":"Data!M61/Data!N61","v":{"$error":"#N/A"}},null,37,53.652000000000001,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X46/1440)))","v":24.402964961163221},59.652000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,39,{"$f":"IF(Data!L62>=E$9,Data!L62-E$10,0)","v":0},{"$f":"IF(O47>0,P46+7.48*Data!M62*(Data!B62-Data!B61)/1440,0)","v":0},{"$f":"IF(O47>0,Q46+7.48*(4*PI()*(E$16/1440)*Data!N62)*(Data!B62-Data!B61)/LN(0.56146/((Data!P62^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O47))),0)","v":0},0,null,{"$f":"Data!L62","v":0},{"$f":"Data!M62/Data!N62","v":{"$error":"#N/A"}},null,38,55.048000000000002,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X47/1440)))","v":24.30116812066203},61.048000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,40,{"$f":"IF(Data!L63>=E$9,Data!L63-E$10,0)","v":0},{"$f":"IF(O48>0,P47+7.48*Data!M63*(Data!B63-Data!B62)/1440,0)","v":0},{"$f":"IF(O48>0,Q47+7.48*(4*PI()*(E$16/1440)*Data!N63)*(Data!B63-Data!B62)/LN(0.56146/((Data!P63^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O48))),0)","v":0},0,null,{"$f":"Data!L63","v":0},{"$f":"Data!M63/Data!N63","v":{"$error":"#N/A"}},null,39,56.443999999999996,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X48/1440)))","v":24.202735101308388},62.443999999999996]
[null,null,null,null,null,null,null,null,null,"Height",null,null,null,41,{"$f":"IF(Data!L64>=E$9,Data!L64-E$10,0)","v":0},{"$f":"IF(O49>0,P48+7.48*Data!M64*(Data!B64-Data!B63)/1440,0)","v":0},{"$f":"IF(O49>0,Q48+7.48*(4*PI()*(E$16/1440)*Data!N64)*(Data!B64-Data!B63)/LN(0.56146/((Data!P64^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O49))),0)","v":0},0,null,{"$f":"Data!L64","v":0},{"$f":"Data!M64/Data!N64","v":{"$error":"#N/A"}},null,40,57.84,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X49/1440)))","v":24.107472482833796},63.84]
[null,null,null,null,null,null,null,null,null,70,null,null,null,42,{"$f":"IF(Data!L65>=E$9,Data!L65-E$10,0)","v":0},{"$f":"IF(O50>0,P49+7.48*Data!M65*(Data!B65-Data!B64)/1440,0)","v":0},{"$f":"IF(O50>0,Q49+7.48*(4*PI()*(E$16/1440)*Data!N65)*(Data!B65-Data!B64)/LN(0.56146/((Data!P65^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O50))),0)","v":0},0,null,{"$f":"Data!L65","v":0},{"$f":"Data!M65/Data!N65","v":{"$error":"#N/A"}},null,41,59.235999999999997,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X50/1440)))","v":24.01520241133467},65.23599999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43,{"$f":"IF(Data!L66>=E$9,Data!L66-E$10,0)","v":0},{"$f":"IF(O51>0,P50+7.48*Data!M66*(Data!B66-Data!B65)/1440,0)","v":0},{"$f":"IF(O51>0,Q50+7.48*(4*PI()*(E$16/1440)*Data!N66)*(Data!B66-Data!B65)/LN(0.56146/((Data!P66^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O51))),0)","v":0},0,null,{"$f":"Data!L66","v":0},{"$f":"Data!M66/Data!N66","v":{"$error":"#N/A"}},null,42,60.631999999999998,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X51/1440)))","v":23.925761007572984},66.632000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,44,{"$f":"IF(Data!L67>=E$9,Data!L67-E$10,0)","v":0},{"$f":"IF(O52>0,P51+7.48*Data!M67*(Data!B67-Data!B66)/1440,0)","v":0},{"$f":"IF(O52>0,Q51+7.48*(4*PI()*(E$16/1440)*Data!N67)*(Data!B67-Data!B66)/LN(0.56146/((Data!P67^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O52))),0)","v":0},0,null,{"$f":"Data!L67","v":0},{"$f":"Data!M67/Data!N67","v":{"$error":"#N/A"}},null,43,62.027999999999999,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X52/1440)))","v":23.838996970987111},68.027999999999992]
[null,null,null,null,null,null,null,null,null,null,null,null,null,45,{"$f":"IF(Data!L68>=E$9,Data!L68-E$10,0)","v":0},{"$f":"IF(O53>0,P52+7.48*Data!M68*(Data!B68-Data!B67)/1440,0)","v":0},{"$f":"IF(O53>0,Q52+7.48*(4*PI()*(E$16/1440)*Data!N68)*(Data!B68-Data!B67)/LN(0.56146/((Data!P68^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O53))),0)","v":0},0,null,{"$f":"Data!L68","v":0},{"$f":"Data!M68/Data!N68","v":{"$error":"#N/A"}},null,44,63.423999999999999,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X53/1440)))","v":23.754770351487174},69.424000000000007]
[null,null,null,null,null,null,null,null,null,null,null,null,null,46,{"$f":"IF(Data!L69>=E$9,Data!L69-E$10,0)","v":0},{"$f":"IF(O54>0,P53+7.48*Data!M69*(Data!B69-Data!B68)/1440,0)","v":0},{"$f":"IF(O54>0,Q53+7.48*(4*PI()*(E$16/1440)*Data!N69)*(Data!B69-Data!B68)/LN(0.56146/((Data!P69^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O54))),0)","v":0},0,null,{"$f":"Data!L69","v":0},{"$f":"Data!M69/Data!N69","v":{"$error":"#N/A"}},null,45,64.819999999999993,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X54/1440)))","v":23.672951465619825},70.819999999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,47,{"$f":"IF(Data!L70>=E$9,Data!L70-E$10,0)","v":0},{"$f":"IF(O55>0,P54+7.48*Data!M70*(Data!B70-Data!B69)/1440,0)","v":0},{"$f":"IF(O55>0,Q54+7.48*(4*PI()*(E$16/1440)*Data!N70)*(Data!B70-Data!B69)/LN(0.56146/((Data!P70^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O55))),0)","v":0},0,null,{"$f":"Data!L70","v":0},{"$f":"Data!M70/Data!N70","v":{"$error":"#N/A"}},null,46,66.215999999999994,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X55/1440)))","v":23.593419937388493},72.215999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,48,{"$f":"IF(Data!L71>=E$9,Data!L71-E$10,0)","v":0},{"$f":"IF(O56>0,P55+7.48*Data!M71*(Data!B71-Data!B70)/1440,0)","v":0},{"$f":"IF(O56>0,Q55+7.48*(4*PI()*(E$16/1440)*Data!N71)*(Data!B71-Data!B70)/LN(0.56146/((Data!P71^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O56))),0)","v":0},0,null,{"$f":"Data!L71","v":0},{"$f":"Data!M71/Data!N71","v":{"$error":"#N/A"}},null,47,67.611999999999995,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X56/1440)))","v":23.51606384706545},73.611999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,49,{"$f":"IF(Data!L72>=E$9,Data!L72-E$10,0)","v":0},{"$f":"IF(O57>0,P56+7.48*Data!M72*(Data!B72-Data!B71)/1440,0)","v":0},{"$f":"IF(O57>0,Q56+7.48*(4*PI()*(E$16/1440)*Data!N72)*(Data!B72-Data!B71)/LN(0.56146/((Data!P72^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O57))),0)","v":0},0,null,{"$f":"Data!L72","v":0},{"$f":"Data!M72/Data!N72","v":{"$error":"#N/A"}},null,48,69.007999999999996,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X57/1440)))","v":23.440778973857345},75.007999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,50,{"$f":"IF(Data!L73>=E$9,Data!L73-E$10,0)","v":0},{"$f":"IF(O58>0,P57+7.48*Data!M73*(Data!B73-Data!B72)/1440,0)","v":0},{"$f":"IF(O58>0,Q57+7.48*(4*PI()*(E$16/1440)*Data!N73)*(Data!B73-Data!B72)/LN(0.56146/((Data!P73^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O58))),0)","v":0},0,null,{"$f":"Data!L73","v":0},{"$f":"Data!M73/Data!N73","v":{"$error":"#N/A"}},null,49,70.403999999999996,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X58/1440)))","v":23.36746812038535},76.403999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L74","v":0},{"$f":"Data!M74/Data!N74","v":{"$error":"#N/A"}},null,50,71.8,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X59/1440)))","v":23.296040508693096},77.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L75","v":0},{"$f":"Data!M75/Data!N75","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L76","v":0},{"$f":"Data!M76/Data!N76","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L77","v":0},{"$f":"Data!M77/Data!N77","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L78","v":0},{"$f":"Data!M78/Data!N78","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L79","v":0},{"$f":"Data!M79/Data!N79","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L80","v":0},{"$f":"Data!M80/Data!N80","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L81","v":0},{"$f":"Data!M81/Data!N81","v":{"$error":"#N/A"}}]

{"sheet":"CB&P","index":5,"n_rows":108,"n_cols":25,"rows_kept":108,"cut":false,"hidden":false,"merged":[]}
["Cooper, Bredehoeft and Papadopulos (1967)"]
["Well Designation:",null,{"$f":"IF(Data!B1 > 0,Data!B1,\"\")","v":"YYY"},null,null,null,null,null,null,null,null,null,null,null,null,"e",9.9999999999999995E-7]
["Date:",null,{"$f":"IF(Data!B2 > 0,Data!B2,\"\")","v":"date"}]
[]
[null,"Enter early time cut-off for least-squares model fit"]
[null,null,"Timecut (min):",null,10,"<-  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,5.5E-2,null,null,null,null,null,null,null,null,null,"(min)",null,null,null,null,"Index","Time (min)","G( )",null,"(min)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O8>0,1,0)","v":0},{"$f":"IF(Data!B23>E$6,Data!B23-E$6,0)","v":0},{"$f":"IF(N8>0,Data!J23/'CB&P'!E$7,0)","v":0},{"$f":"IF(N8>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O8/Data!V$23^2,'CB&P'!Q$2),0)","v":0},{"$f":"N8*(P8-Q8)^2","v":0},null,0,{"$f":"EXP(LN(J$15)+(LN(J$16)-LN(J$15))*T8/100)","v":0.2},{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U8/Data!V$23^2,0.00001)","v":0.92076474828033128},null,{"$f":"IF(N8>0,O8,NA())","v":{"$error":"#N/A"}},{"$f":"IF(N8>0,P8,NA())","v":{"$error":"#N/A"}}]
[null,"Trial Sn:",null,null,"d","<-- Enter d for default",null,null,null,null,null,null,null,{"$f":"IF(O9>0,1,0)","v":0},{"$f":"IF(Data!B24>E$6,Data!B24-E$6,0)","v":0},{"$f":"IF(N9>0,Data!J24/'CB&P'!E$7,0)","v":0},{"$f":"IF(N9>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O9/Data!V$23^2,'CB&P'!Q$2),0)","v":0},{"$f":"N9*(P9-Q9)^2","v":0},null,1,0.21206581998072535,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U9/Data!V$23^2,0.00001)","v":0.9190656187953794},null,{"$f":"IF(N9>0,O9,NA())","v":{"$error":"#N/A"}},{"$f":"IF(N9>0,P9,NA())","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B25>E$6,Data!B25-E$6,0)","v":0},{"$f":"IF(N10>0,Data!J25/'CB&P'!E$7,0)","v":0},{"$f":"IF(N10>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O10/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,2,0.22485956002048701,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U10/Data!V$23^2,0.00001)","v":0.91728350748531118},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Root-Mean-Square Error:",null,null,{"$f":"SQRT(SUM(R8:R48))","v":0.2502960251080325},"<-- Minimize this using \"Solver\"",null,null,null,null,null,null,null,0,{"$f":"IF(Data!B26>E$6,Data!B26-E$6,0)","v":0},{"$f":"IF(N11>0,Data!J26/'CB&P'!E$7,0)","v":0},{"$f":"IF(N11>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O11/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,3,0.23842513488124845,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U11/Data!V$23^2,0.00001)","v":0.91541564385600183},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B27>E$6,Data!B27-E$6,0)","v":0},{"$f":"IF(N12>0,Data!J27/'CB&P'!E$7,0)","v":0},{"$f":"IF(N12>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O12/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,4,0.25280910866303491,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U12/Data!V$23^2,0.00001)","v":0.91345859253930051},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Trial Tn (ft2/d):",null,null,10.154569836140173,"<-- By changing Tn through \"Solver\"",null,null,null,null,null,null,null,0,{"$f":"IF(Data!B28>E$6,Data!B28-E$6,0)","v":0},{"$f":"IF(N13>0,Data!J28/'CB&P'!E$7,0)","v":0},{"$f":"IF(N13>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O13/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,5,0.26806085463611395,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U13/Data!V$23^2,0.00001)","v":0.91140909881677268},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"IF(E9=\"d\",0.025*SQRT(E13),E9)","v":7.966558948245854E-2},"<-- Working Sn",null,"Add constraint Tn > 0.00001",null,null,null,null,null,0,{"$f":"IF(Data!B29>E$6,Data!B29-E$6,0)","v":0},{"$f":"IF(N14>0,Data!J29/'CB&P'!E$7,0)","v":0},{"$f":"IF(N14>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O14/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,6,0.2842327247157076,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U14/Data!V$23^2,0.00001)","v":0.90926386946502913},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Model Result:",null,"Tn (ft2/d) =",{"$f":"E13","v":10.154569836140173},null,null,null,"Tmin",0.2,null,null,null,0,{"$f":"IF(Data!B30>E$6,Data!B30-E$6,0)","v":0},{"$f":"IF(N15>0,Data!J30/'CB&P'!E$7,0)","v":0},{"$f":"IF(N15>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O15/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,7,0.30138022916096152,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U15/Data!V$23^2,0.00001)","v":0.90701957772197495},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,"Tmax",70,null,null,null,0,{"$f":"IF(Data!B31>E$6,Data!B31-E$6,0)","v":0},{"$f":"IF(N16>0,Data!J31/'CB&P'!E$7,0)","v":0},{"$f":"IF(N16>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O16/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,8,0.31956222711499099,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U16/Data!V$23^2,0.00001)","v":0.90467286835366612},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B32>E$6,Data!B32-E$6,0)","v":0},{"$f":"IF(N17>0,Data!J32/'CB&P'!E$7,0)","v":0},{"$f":"IF(N17>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O17/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,9,0.33884112864003674,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U17/Data!V$23^2,0.00001)","v":0.90222036275722073},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B33>E$6,Data!B33-E$6,0)","v":0.19999999999999929},{"$f":"IF(N18>0,Data!J33/'CB&P'!E$7,0)","v":0.94545454545455054},{"$f":"IF(N18>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O18/Data!V$23^2,'CB&P'!Q$2),0)","v":0.92076483767578465},6.0958167020085292E-4,null,10,0.35928310894121906,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U18/Data!V$23^2,0.00001)","v":0.89965866402983863},null,0.19999999999999929,0.94545454545455054]
[null,null,null,null,null,null,null,null,null,"J-Ratio",null,null,null,1,{"$f":"IF(Data!B34>E$6,Data!B34-E$6,0)","v":1.5999999999999996},{"$f":"IF(N19>0,Data!J34/'CB&P'!E$7,0)","v":0.76363636363640497},{"$f":"IF(N19>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O19/Data!V$23^2,'CB&P'!Q$2),0)","v":0.78698625059701355},5.4521722107319856E-4,null,11,0.38095833551421943,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U19/Data!V$23^2,0.00001)","v":0.89698436192997055},null,1.5999999999999996,0.76363636363640497]
[null,null,null,null,null,null,null,null,null,{"$f":"Figures!U27","v":-0.17973856209150327},null,null,null,1,{"$f":"IF(Data!B35>E$6,Data!B35-E$6,0)","v":2.0999999999999996},{"$f":"IF(N20>0,Data!J35/'CB&P'!E$7,0)","v":0.76363636363640497},{"$f":"IF(N20>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O20/Data!V$23^2,'CB&P'!Q$2),0)","v":0.75428479974044926},8.7451747300142259E-5,null,12,0.40394120899657598,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U20/Data!V$23^2,0.00001)","v":0.89419403765427985},null,2.0999999999999996,0.76363636363640497]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B36>E$6,Data!B36-E$6,0)","v":3.0999999999999996},{"$f":"IF(N21>0,Data!J36/'CB&P'!E$7,0)","v":0.76363636363640497},{"$f":"IF(N21>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O21/Data!V$23^2,'CB&P'!Q$2),0)","v":0.69954086358012502},4.1082331274645834E-3,null,13,0.42831061854932206,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U21/Data!V$23^2,0.00001)","v":0.89128426835366514},null,3.0999999999999996,0.76363636363640497]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B37>E$6,Data!B37-E$6,0)","v":4.3000000000000007},{"$f":"IF(N22>0,Data!J37/'CB&P'!E$7,0)","v":0.58181818181825928},{"$f":"IF(N22>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O22/Data!V$23^2,'CB&P'!Q$2),0)","v":0.64603154330513424},4.1233557934440756E-3,null,14,0.45415021264556826,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U22/Data!V$23^2,0.00001)","v":0.88825163131372309},null,4.3000000000000007,0.58181818181825928]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B38>E$6,Data!B38-E$6,0)","v":6.1999999999999993},{"$f":"IF(N23>0,Data!J38/'CB&P'!E$7,0)","v":0.58181818181825928},{"$f":"IF(N23>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O23/Data!V$23^2,'CB&P'!Q$2),0)","v":0.57818737143337195},1.3182784051005671E-5,null,15,0.481548686195516,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U23/Data!V$23^2,0.00001)","v":0.88509270772964688},null,6.1999999999999993,0.58181818181825928]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B39>E$6,Data!B39-E$6,0)","v":7.1000000000000014},{"$f":"IF(N24>0,Data!J39/'CB&P'!E$7,0)","v":0.58181818181825928},{"$f":"IF(N24>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O24/Data!V$23^2,'CB&P'!Q$2),0)","v":0.55107958472704288},9.4486135113613749E-4,null,16,0.51060008499346543,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U24/Data!V$23^2,0.00001)","v":0.88180408601327065},null,7.1000000000000014,0.58181818181825928]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B40>E$6,Data!B40-E$6,0)","v":8.1999999999999993},{"$f":"IF(N25>0,Data!J40/'CB&P'!E$7,0)","v":0.58181818181825928},{"$f":"IF(N25>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O25/Data!V$23^2,'CB&P'!Q$2),0)","v":0.52124688762971738},3.6688816796748899E-3,null,17,0.54140412853183639,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U25/Data!V$23^2,0.00001)","v":0.87838236458068086},null,8.1999999999999993,0.58181818181825928]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B41>E$6,Data!B41-E$6,0)","v":11.2},{"$f":"IF(N26>0,Data!J41/'CB&P'!E$7,0)","v":0.39999999999998453},{"$f":"IF(N26>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O26/Data!V$23^2,'CB&P'!Q$2),0)","v":0.45377742651637532},2.8920116027258101E-3,null,18,0.57406655229026937,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U26/Data!V$23^2,0.00001)","v":0.87482415408271907},null,11.2,0.39999999999998453]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B42>E$6,Data!B42-E$6,0)","v":13.100000000000001},{"$f":"IF(N27>0,Data!J42/'CB&P'!E$7,0)","v":0.39999999999998453},{"$f":"IF(N27>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O27/Data!V$23^2,'CB&P'!Q$2),0)","v":0.41887353785979697},{"$f":"N27*(P27-Q27)^2","v":3.5621043134577353E-4},null,19,0.60869947067471952,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U27/Data!V$23^2,0.00001)","v":0.87112607905776851},null,13.100000000000001,0.39999999999998453]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B43>E$6,Data!B43-E$6,0)","v":15.2},{"$f":"IF(N28>0,Data!J43/'CB&P'!E$7,0)","v":0.39999999999998453},{"$f":"IF(N28>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O28/Data!V$23^2,'CB&P'!Q$2),0)","v":0.38552138631548699},{"$f":"N28*(P28-Q28)^2","v":2.0963025422491953E-4},null,20,0.64542176185233935,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U28/Data!V$23^2,0.00001)","v":0.8672847790061986},null,15.2,0.39999999999998453]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B44>E$6,Data!B44-E$6,0)","v":17.5},{"$f":"IF(N29>0,Data!J44/'CB&P'!E$7,0)","v":0.39999999999998453},{"$f":"IF(N29>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O29/Data!V$23^2,'CB&P'!Q$2),0)","v":0.35399044020254511},2.1168795927541543E-3,null,21,0.68435947580310363,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U29/Data!V$23^2,0.00001)","v":0.86329690890847555},null,17.5,0.39999999999998453]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B45>E$6,Data!B45-E$6,0)","v":18.2},{"$f":"IF(N30>0,Data!J45/'CB&P'!E$7,0)","v":0.39999999999998453},{"$f":"IF(N30>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O30/Data!V$23^2,'CB&P'!Q$2),0)","v":0.34526610030265703},2.9957997760771079E-3,null,22,0.72564626698882273,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U30/Data!V$23^2,0.00001)","v":0.85915913923377418},null,18.2,0.39999999999998453]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B46>E$6,Data!B46-E$6,0)","v":22.4},{"$f":"IF(N31>0,Data!J46/'CB&P'!E$7,0)","v":0.39999999999998453},{"$f":"IF(N31>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O31/Data!V$23^2,'CB&P'!Q$2),0)","v":0.29980505758919068},1.0039026484702297E-2,null,23,0.76942385312468498,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U31/Data!V$23^2,0.00001)","v":0.85486815551232431},null,22.4,0.39999999999998453]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B47>E$6,Data!B47-E$6,0)","v":24.299999999999997},{"$f":"IF(N32>0,Data!J47/'CB&P'!E$7,0)","v":0.21818181818183888},{"$f":"IF(N32>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O32/Data!V$23^2,'CB&P'!Q$2),0)","v":0.28245016342561741},4.1304202003735104E-3,null,24,0.81584250162807737,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U32/Data!V$23^2,0.00001)","v":0.85042065757193763},null,24.299999999999997,0.21818181818183888]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B48>E$6,Data!B48-E$6,0)","v":28.299999999999997},{"$f":"IF(N33>0,Data!J48/'CB&P'!E$7,0)","v":0.21818181818183888},{"$f":"IF(N33>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O33/Data!V$23^2,'CB&P'!Q$2),0)","v":0.25095274841609605},1.0739338684185508E-3,null,25,0.86506154541442226,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U33/Data!V$23^2,0.00001)","v":0.84581335856635331},null,28.299999999999997,0.21818181818183888]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B49>E$6,Data!B49-E$6,0)","v":30.1},{"$f":"IF(N34>0,Data!J49/'CB&P'!E$7,0)","v":0.21818181818183888},{"$f":"IF(N34>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O34/Data!V$23^2,'CB&P'!Q$2),0)","v":0.23863710024187743},4.1841856415573487E-4,null,26,0.91724992981051434,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U34/Data!V$23^2,0.00001)","v":0.84104298394933263},null,30.1,0.21818181818183888]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B50>E$6,Data!B50-E$6,0)","v":39.1},{"$f":"IF(N35>0,Data!J50/'CB&P'!E$7,0)","v":0.21818181818183888},{"$f":"IF(N35>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O35/Data!V$23^2,'CB&P'!Q$2),0)","v":0.18974321280478421},8.0875427579184288E-4,null,27,0.97258679246264756,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U35/Data!V$23^2,0.00001)","v":0.8361062705725526},null,39.1,0.21818181818183888]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B51>E$6,Data!B51-E$6,0)","v":49.4},{"$f":"IF(N36>0,Data!J51/'CB&P'!E$7,0)","v":3.6363636363693233E-2},{"$f":"IF(N36>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O36/Data!V$23^2,'CB&P'!Q$2),0)","v":0.15139222420099163},1.3231576019843073E-2,null,28,1.0312620782300741,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U36/Data!V$23^2,0.00001)","v":0.83099996610671234},null,49.4,3.6363636363693233E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B52>E$6,Data!B52-E$6,0)","v":54.2},{"$f":"IF(N37>0,Data!J52/'CB&P'!E$7,0)","v":3.6363636363693233E-2},{"$f":"IF(N37>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O37/Data!V$23^2,'CB&P'!Q$2),0)","v":0.13772770169319334},1.0274673740123166E-2,null,29,1.0934771911744381,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U37/Data!V$23^2,0.00001)","v":0.82572082900242316},null,54.2,3.6363636363693233E-2]
[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(N38>0,Data!J53/'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$23^2,'CB&P'!Q$2),0)","v":0},0,null,30,1.1594456858831375,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U38/Data!V$23^2,0.00001)","v":0.8202656292198508},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(N39>0,Data!J54/'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$23^2,'CB&P'!Q$2),0)","v":0},0,null,31,1.2293940004996105,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U39/Data!V$23^2,0.00001)","v":0.81463114996284347},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(N40>0,Data!J55/'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$23^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":1.3035622339766704},{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U40/Data!V$23^2,0.00001)","v":0.80881419065389815},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(N41>0,Data!J56/'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$23^2,'CB&P'!Q$2),0)","v":0},0,null,33,1.3822049702208432,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U41/Data!V$23^2,0.00001)","v":0.80281157138045345},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(N42>0,Data!J57/'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$23^2,'CB&P'!Q$2),0)","v":0},0,null,34,1.465592151956586,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U42/Data!V$23^2,0.00001)","v":0.7966201390308546},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(N43>0,Data!J58/'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$23^2,'CB&P'!Q$2),0)","v":0},0,null,35,1.5540100073099457,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U43/Data!V$23^2,0.00001)","v":0.79023677531986181},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(N44>0,Data!J59/'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$23^2,'CB&P'!Q$2),0)","v":0},0,null,36,1.6477620322921829,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U44/Data!V$23^2,0.00001)","v":0.78365840687971877},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(N45>0,Data!J60/'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$23^2,'CB&P'!Q$2),0)","v":0},0,null,37,1.7471700325557407,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U45/Data!V$23^2,0.00001)","v":0.77688201756413033},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(N46>0,Data!J61/'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$23^2,'CB&P'!Q$2),0)","v":0},0,null,38,1.8525752279984185,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U46/Data!V$23^2,0.00001)","v":0.76990466308021266},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(N47>0,Data!J62/'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$23^2,'CB&P'!Q$2),0)","v":0},0,null,39,1.9643394240073189,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U47/Data!V$23^2,0.00001)","v":0.76272348802868406},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(N48>0,Data!J63/'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$23^2,'CB&P'!Q$2),0)","v":0},0,null,40,2.0828462533628889,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U48/Data!V$23^2,0.00001)","v":0.75533574539661763},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,2.2085024930659127,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U49/Data!V$23^2,0.00001)","v":0.74773881851102175}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,2.3417394606074935,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U50/Data!V$23^2,0.00001)","v":0.73993020292573186}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,2.483014494474749,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U51/Data!V$23^2,0.00001)","v":0.73190772241740432}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,2.632812523974069,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U52/Data!V$23^2,0.00001)","v":0.72366923707028918}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,2.7916477337604184,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U53/Data!V$23^2,0.00001)","v":0.71521292206289533}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,2.9600653287861833,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U54/Data!V$23^2,0.00001)","v":0.70653722632679528}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,3.1386434057277879,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U55/Data!V$23^2,0.00001)","v":0.69764090807015433}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,3.3279949373137967,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U56/Data!V$23^2,0.00001)","v":0.68852307186777939}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,3.5287698763657644,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U57/Data!V$23^2,0.00001)","v":0.67918320714143077}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,3.7416573867739427,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U58/Data!V$23^2,0.00001)","v":0.66962122783651168}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,3.9673882090657702,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U59/Data!V$23^2,0.00001)","v":0.659837513081033}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,4.206737168686967,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U60/Data!V$23^2,0.00001)","v":0.64983294859006557}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,4.4605258356049848,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U61/Data!V$23^2,0.00001)","v":0.63960896855382865}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,4.7296253443639049,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U62/Data!V$23^2,0.00001)","v":0.62916759772016662}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,5.0149593842707594,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U63/Data!V$23^2,0.00001)","v":0.6185114933522371}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,5.3175073699770579,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U64/Data!V$23^2,0.00001)","v":0.6076439867098139}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,5.638307803338674,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U65/Data!V$23^2,0.00001)","v":0.59656912366761805}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,5.9784618380936934,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U66/Data!V$23^2,0.00001)","v":0.58529170404677056}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,6.3391370595940639,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U67/Data!V$23^2,0.00001)","v":0.57381731919623025}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,6.7215714925650953,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U68/Data!V$23^2,0.00001)","v":0.5621523873206401}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,7.1270778506494237,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U69/Data!V$23^2,0.00001)","v":0.5503041860102813}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,7.5570480423221786,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U70/Data!V$23^2,0.00001)","v":0.53828088138900887}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,8.0129579486439351,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U71/Data!V$23^2,0.00001)","v":0.52609155325848078}]
[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":8.4963724892512378},{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U72/Data!V$23^2,0.00001)","v":0.51374621558324118}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,9.0089509939736967,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U73/Data!V$23^2,0.00001)","v":0.50125583163297238}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,9.5524528985160071,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U74/Data!V$23^2,0.00001)","v":0.48863232307726634}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,10.128743783755272,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U75/Data!V$23^2,0.00001)","v":0.4758885723165503}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68,10.739801779383685,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U76/Data!V$23^2,0.00001)","v":0.46303841733222234}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69,11.387724353877266,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U77/Data!V$23^2,0.00001)","v":0.45009663835170155}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,12.074735514097283,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U78/Data!V$23^2,0.00001)","v":0.43707891387521519}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,71,12.80319343923713,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U79/Data!V$23^2,0.00001)","v":0.42400188782705622}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72,13.575598575318319,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U80/Data!V$23^2,0.00001)","v":0.41088295581649109}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73,14.394602218020221,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U81/Data!V$23^2,0.00001)","v":0.39774035048063849}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74,15.263015613304136,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U82/Data!V$23^2,0.00001)","v":0.38459303406944584}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,16.183819607069779,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U83/Data!V$23^2,0.00001)","v":0.37146062472797792}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,76,17.160174876966956,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U84/Data!V$23^2,0.00001)","v":0.35836331122195386}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,77,18.195432781483191,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U85/Data!V$23^2,0.00001)","v":0.34532175629148615}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78,19.293146863547022,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U86/Data!V$23^2,0.00001)","v":0.33235698897680332}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79,20.45708504813328,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U87/Data!V$23^2,0.00001)","v":0.31949028644699778}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,21.691242575739107,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U88/Data!V$23^2,0.00001)","v":0.30674304607511754}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81,22.99985571612466,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U89/Data!V$23^2,0.00001)","v":0.29413664873475531}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82,24.387416309391753,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U90/Data!V$23^2,0.00001)","v":0.28169231453783189}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,83,25.85868718431237,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U91/Data!V$23^2,0.00001)","v":0.26943095248283089}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,84,27.418718506831368,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U92/Data!V$23^2,0.00001)","v":0.2573730057289571}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,85,29.072865114859425,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U93/Data!V$23^2,0.00001)","v":0.24553829444569711}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,86,30.826804898858452,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U94/Data!V$23^2,0.00001)","v":0.23394585839983029}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,87,32.686558291311272,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U95/Data!V$23^2,0.00001)","v":0.2226138016235315}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,88,34.658508931973522,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U96/Data!V$23^2,0.00001)","v":0.21155914164830952}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,89,36.749425579841237,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U97/Data!V$23^2,0.00001)","v":0.20079766588082565}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,38.966485347048391,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U98/Data!V$23^2,0.00001)","v":0.19034379772955407}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,91,41.317298334443691,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U99/Data!V$23^2,0.00001)","v":0.18021047505833401}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,92,43.80993375341027,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U100/Data!V$23^2,0.00001)","v":0.17040904343828114}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,93,46.452947623591044,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U101/Data!V$23^2,0.00001)","v":0.16094879609605425}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94,49.255412141592622,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U102/Data!V$23^2,0.00001)","v":0.15183843527308524}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95,52.226946821477043,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U103/Data!V$23^2,0.00001)","v":0.14308391896708716}]
[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":55.377751513931294},{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U104/Data!V$23^2,0.00001)","v":0.1346889278965375}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97,58.718641417453441,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U105/Data!V$23^2,0.00001)","v":0.12665624934450645}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98,62.261084201732238,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U106/Data!V$23^2,0.00001)","v":0.11898649597167552}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99,66.017239370646621,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U107/Data!V$23^2,0.00001)","v":0.11167852487982788}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,70.000000000000028,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U108/Data!V$23^2,0.00001)","v":0.10472948276700823}]

{"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.333"}]
[]
[]
[null,null,null,"Enter these values"]
["Type Curve ID","Type Curve Name","Notes","Max Time (min)","Transmissivity (ft2/day)"]
[1,{"$f":"CONCATENATE(\"T=\",E7,\" ft2/day\")","v":"T=10 ft2/day"},null,150,10,null,"J-Ratio",null,null,null,"Type Curve 1",null,null,"Type Curve 2",null,null,"Type Curve 3",null,null,"Type Curve 4",null,null,"Type Curve 5",null,null,"Type Curve 6",null,null,"Type Curve 7"]
[2,"T=5 ft2/day",null,200,5,null,{"$f":"Figures!U27","v":-0.17973856209150327},"<--  If uncertain use",null,null,null,"T (ft2/day)",null,null,"T (ft2/day)",null,null,"T (ft2/day)",null,null,"T (ft2/day)",null,null,"T (ft2/day)",null,null,"T (ft2/day)",null,null,"T (ft2/day)"]
[3,"T=2 ft2/day",null,200,2,null,null,{"$f":"-(1-Data!B9)","v":-0.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,200,1]
[5,"T=0.5 ft2/day",null,200,0.5,null,null,null,null,null,"t (min)","s(t)/s0",null,"t (min)","s(t)/s0",null,"t (min)","s(t)/s0",null,"t (min)","s(t)/s0",null,"t (min)","s(t)/s0",null,"t (min)","s(t)/s0",null,"t (min)","s(t)/s0"]
[6,"T=0.2 ft2/day",null,200,0.2,null,null,null,null,null,0,{"$f":"EXP(-(2*L$9*(K12/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":1},null,0,{"$f":"EXP(-(2*O$9*(N12/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1},null,0,{"$f":"EXP(-(2*R$9*(Q12/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1},null,0,{"$f":"EXP(-(2*U$9*(T12/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":1},null,0,{"$f":"EXP(-(2*X$9*(W12/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1},null,0,{"$f":"EXP(-(2*AA$9*(Z12/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1},null,0,{"$f":"EXP(-(2*AD$9*(AC12/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1}]
[7,"T=0.1 ft2/day",null,200,0.1,null,null,null,null,null,{"$f":"(K$42-K$12)/30+K12","v":5},{"$f":"EXP(-(2*L$9*(K13/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.74609402263007607},null,{"$f":"(N$42-N$12)/30+N12","v":6.666666666666667},{"$f":"EXP(-(2*O$9*(N13/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.82261326247851885},null,{"$f":"(Q$42-Q$12)/30+Q12","v":6.666666666666667},{"$f":"EXP(-(2*R$9*(Q13/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.92486486847864713},null,{"$f":"(T$42-T$12)/30+T12","v":6.666666666666667},{"$f":"EXP(-(2*U$9*(T13/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.96169894898489261},null,{"$f":"(W$42-W$12)/30+W12","v":6.666666666666667},{"$f":"EXP(-(2*X$9*(W13/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.9806625051386908},null,{"$f":"(Z$42-Z$12)/30+Z12","v":6.666666666666667},{"$f":"EXP(-(2*AA$9*(Z13/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.99221966072501022},null,{"$f":"(AC$42-AC$12)/30+AC12","v":6.666666666666667},{"$f":"EXP(-(2*AD$9*(AC13/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.99610223407289389}]
[null,null,null,null,null,null,null,null,null,null,10,{"$f":"EXP(-(2*L$9*(K14/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.55665629060432853},null,13.333333333333334,{"$f":"EXP(-(2*O$9*(N14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.67669257960555262},null,13.333333333333334,{"$f":"EXP(-(2*R$9*(Q14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.85537502494602535},null,13.333333333333334,{"$f":"EXP(-(2*U$9*(T14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.92486486847864713},null,13.333333333333334,{"$f":"EXP(-(2*X$9*(W14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.96169894898489261},null,13.333333333333334,{"$f":"EXP(-(2*AA$9*(Z14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.98449985512925442},null,13.333333333333334,{"$f":"EXP(-(2*AD$9*(AC14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.99221966072501022}]
[null,null,null,null,null,null,null,null,null,null,15,{"$f":"EXP(-(2*L$9*(K15/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.41531793107932014},null,20,{"$f":"EXP(-(2*O$9*(N15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.55665629060432853},null,20,{"$f":"EXP(-(2*R$9*(Q15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.79110630994662523},null,20,{"$f":"EXP(-(2*U$9*(T15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.889441571968966},null,20,{"$f":"EXP(-(2*X$9*(W15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.94310210050077081},null,20,{"$f":"EXP(-(2*AA$9*(Z15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.97684011224017064},null,20,{"$f":"EXP(-(2*AD$9*(AC15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.98835222073923157}]
[null,null,null,null,null,null,null,null,null,null,20,{"$f":"EXP(-(2*L$9*(K16/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.30986622586937063},null,26.666666666666668,{"$f":"EXP(-(2*O$9*(N16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.45791284729321718},null,26.666666666666668,{"$f":"EXP(-(2*R$9*(Q16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.73166643330141345},null,26.666666666666668,{"$f":"EXP(-(2*U$9*(T16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.85537502494602535},null,26.666666666666668,{"$f":"EXP(-(2*X$9*(W16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.92486486847864713},null,26.666666666666668,{"$f":"EXP(-(2*AA$9*(Z16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.96923996474952301},null,26.666666666666668,{"$f":"EXP(-(2*AD$9*(AC16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.98449985512925442}]
[null,null,null,null,null,null,null,null,null,null,25,{"$f":"EXP(-(2*L$9*(K17/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.23118933893607851},null,33.333333333333336,{"$f":"EXP(-(2*O$9*(N17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.37668518124270117},null,33.333333333333336,{"$f":"EXP(-(2*R$9*(Q17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.67669257960555262},null,33.333333333333336,{"$f":"EXP(-(2*U$9*(T17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.82261326247851885},null,33.333333333333336,{"$f":"EXP(-(2*X$9*(W17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.9069802988370359},null,33.333333333333336,{"$f":"EXP(-(2*AA$9*(Z17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.96169894898489261},null,33.333333333333336,{"$f":"EXP(-(2*AD$9*(AC17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.9806625051386908}]
[null,null,null,null,null,null,null,null,null,null,30,{"$f":"EXP(-(2*L$9*(K18/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.17248898387600689},null,40,{"$f":"EXP(-(2*O$9*(N18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.30986622586937063},null,40,{"$f":"EXP(-(2*R$9*(Q18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.62584919363736591},null,40,{"$f":"EXP(-(2*U$9*(T18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.79110630994662523},null,40,{"$f":"EXP(-(2*X$9*(W18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.889441571968966},null,40,{"$f":"EXP(-(2*AA$9*(Z18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.95421660488138915},null,40,{"$f":"EXP(-(2*AD$9*(AC18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.97684011224017064}]
[null,null,null,null,null,null,null,null,null,null,35,{"$f":"EXP(-(2*L$9*(K19/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.12869299983942431},null,46.666666666666664,{"$f":"EXP(-(2*O$9*(N19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.25490006699430862},null,46.666666666666664,{"$f":"EXP(-(2*R$9*(Q19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.57882593216088984},null,46.666666666666664,{"$f":"EXP(-(2*U$9*(T19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.76080610681098626},null,46.666666666666664,{"$f":"EXP(-(2*X$9*(W19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.87224200014158126},null,46.666666666666664,{"$f":"EXP(-(2*AA$9*(Z19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.94679247595358307},null,46.666666666666664,{"$f":"EXP(-(2*AD$9*(AC19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.97303261813445041}]
[null,null,null,null,null,null,null,null,null,null,40,{"$f":"EXP(-(2*L$9*(K20/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":9.6017077934527822E-2},null,53.333333333333329,{"$f":"EXP(-(2*O$9*(N20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.20968417571618123},null,53.333333333333329,{"$f":"EXP(-(2*R$9*(Q20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.53533576962001173},null,53.333333333333329,{"$f":"EXP(-(2*U$9*(T20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.73166643330141345},null,53.333333333333329,{"$f":"EXP(-(2*X$9*(W20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.85537502494602535},null,53.333333333333329,{"$f":"EXP(-(2*AA$9*(Z20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.93942610926765668},null,53.333333333333329,{"$f":"EXP(-(2*AD$9*(AC20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.96923996474952301}]
[null,null,null,null,null,null,null,null,null,null,45,{"$f":"EXP(-(2*L$9*(K21/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":7.1637767917357376E-2},null,59.999999999999993,{"$f":"EXP(-(2*O$9*(N21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.17248898387600689},null,59.999999999999993,{"$f":"EXP(-(2*R$9*(Q21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.49511324616152752},null,59.999999999999993,{"$f":"EXP(-(2*U$9*(T21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.70364283991349441},null,59.999999999999993,{"$f":"EXP(-(2*X$9*(W21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.83883421479663933},null,59.999999999999993,{"$f":"EXP(-(2*AA$9*(Z21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.93211705541377077},null,59.999999999999993,{"$f":"EXP(-(2*AD$9*(AC21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.96546209423973284}]
[null,null,null,null,null,null,null,null,null,null,50,{"$f":"EXP(-(2*L$9*(K22/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":5.3448510437700991E-2},null,66.666666666666657,{"$f":"EXP(-(2*O$9*(N22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.14189172576784673},null,66.666666666666657,{"$f":"EXP(-(2*R$9*(Q22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.4579128472932173},null,66.666666666666657,{"$f":"EXP(-(2*U$9*(T22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.67669257960555274},null,66.666666666666657,{"$f":"EXP(-(2*X$9*(W22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.82261326247851896},null,66.666666666666657,{"$f":"EXP(-(2*AA$9*(Z22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.92486486847864724},null,66.666666666666657,{"$f":"EXP(-(2*AD$9*(AC22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.96169894898489272}]
[null,null,null,null,null,null,null,null,null,null,55,{"$f":"EXP(-(2*L$9*(K23/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":3.9877614156049922E-2},null,73.333333333333329,{"$f":"EXP(-(2*O$9*(N23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.11672201545259571},null,73.333333333333329,{"$f":"EXP(-(2*R$9*(Q23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.4235075052865242},null,73.333333333333329,{"$f":"EXP(-(2*U$9*(T23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.65077454259253587},null,73.333333333333329,{"$f":"EXP(-(2*X$9*(W23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.80670598274249572},null,73.333333333333329,{"$f":"EXP(-(2*AA$9*(Z23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.91766910601836449},null,73.333333333333329,{"$f":"EXP(-(2*AD$9*(AC23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.95795047158940561}]
[null,null,null,null,null,null,null,null,null,null,60,{"$f":"EXP(-(2*L$9*(K24/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":2.9752449558577365E-2},null,80,{"$f":"EXP(-(2*O$9*(N24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":9.6017077934527822E-2},null,80,{"$f":"EXP(-(2*R$9*(Q24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.39168721317654115},null,80,{"$f":"EXP(-(2*U$9*(T24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.62584919363736591},null,80,{"$f":"EXP(-(2*X$9*(W24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.79110630994662523},null,80,{"$f":"EXP(-(2*AA$9*(Z24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.91052932903136508},null,80,{"$f":"EXP(-(2*AD$9*(AC24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.95421660488138915}]
[null,null,null,null,null,null,null,null,null,null,65,{"$f":"EXP(-(2*L$9*(K25/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":2.2198124774257418E-2},null,86.666666666666671,{"$f":"EXP(-(2*O$9*(N25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":7.8984921733376151E-2},null,86.666666666666671,{"$f":"EXP(-(2*R$9*(Q25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.36225774289928953},null,86.666666666666671,{"$f":"EXP(-(2*U$9*(T25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.60187851174409734},null,86.666666666666671,{"$f":"EXP(-(2*X$9*(W25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.77580829574328303},null,86.666666666666671,{"$f":"EXP(-(2*AA$9*(Z25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.90344510193167238},null,86.666666666666671,{"$f":"EXP(-(2*AD$9*(AC25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.95049729191180354}]
[null,null,null,null,null,null,null,null,null,null,70,{"$f":"EXP(-(2*L$9*(K26/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":1.6561888207670065E-2},null,93.333333333333343,{"$f":"EXP(-(2*O$9*(N26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":6.4974044153703003E-2},null,93.333333333333343,{"$f":"EXP(-(2*R$9*(Q26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.3350394597419229},null,93.333333333333343,{"$f":"EXP(-(2*U$9*(T26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.57882593216088973},null,93.333333333333343,{"$f":"EXP(-(2*X$9*(W26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.76080610681098615},null,93.333333333333343,{"$f":"EXP(-(2*AA$9*(Z26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.89641599252231619},null,93.333333333333343,{"$f":"EXP(-(2*AD$9*(AC26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.94679247595358307}]
[null,null,null,null,null,null,null,null,null,null,75,{"$f":"EXP(-(2*L$9*(K27/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":1.2356725795210174E-2},null,100.00000000000001,{"$f":"EXP(-(2*O$9*(N27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":5.3448510437700991E-2},null,100.00000000000001,{"$f":"EXP(-(2*R$9*(Q27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.30986622586937063},null,100.00000000000001,{"$f":"EXP(-(2*U$9*(T27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.55665629060432853},null,100.00000000000001,{"$f":"EXP(-(2*X$9*(W27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.74609402263007607},null,100.00000000000001,{"$f":"EXP(-(2*AA$9*(Z27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.889441571968966},null,100.00000000000001,{"$f":"EXP(-(2*AD$9*(AC27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.94310210050077081}]
[null,null,null,null,null,null,null,null,null,null,80,{"$f":"EXP(-(2*L$9*(K28/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":9.2192792550851877E-3},null,106.66666666666669,{"$f":"EXP(-(2*O$9*(N28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":4.3967453545774367E-2},null,106.66666666666669,{"$f":"EXP(-(2*R$9*(Q28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.28658438623465021},null,106.66666666666669,{"$f":"EXP(-(2*U$9*(T28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.53533576962001161},null,106.66666666666669,{"$f":"EXP(-(2*X$9*(W28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.73166643330141345},null,106.66666666666669,{"$f":"EXP(-(2*AA$9*(Z28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.88252141477376722},null,106.66666666666669,{"$f":"EXP(-(2*AD$9*(AC28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.93942610926765668}]
[null,null,null,null,null,null,null,null,null,null,85,{"$f":"EXP(-(2*L$9*(K29/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":6.8784491451765227E-3},null,113.33333333333336,{"$f":"EXP(-(2*O$9*(N29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":3.6168210404162147E-2},null,113.33333333333336,{"$f":"EXP(-(2*R$9*(Q29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.26505183068294352},null,113.33333333333336,{"$f":"EXP(-(2*U$9*(T29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.51483184699758378},null,113.33333333333336,{"$f":"EXP(-(2*X$9*(W29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.71751783740725483},null,113.33333333333336,{"$f":"EXP(-(2*AA$9*(Z29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.8756550987493833},null,113.33333333333336,{"$f":"EXP(-(2*AD$9*(AC29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.93576444618791932}]
[null,null,null,null,null,null,null,null,null,null,90,{"$f":"EXP(-(2*L$9*(K30/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":5.1319697921811576E-3},null,120.00000000000003,{"$f":"EXP(-(2*O$9*(N30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":2.9752449558577341E-2},null,120.00000000000003,{"$f":"EXP(-(2*R$9*(Q30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.24513712652460523},null,120.00000000000003,{"$f":"EXP(-(2*U$9*(T30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.49511324616152741},null,120.00000000000003,{"$f":"EXP(-(2*X$9*(W30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.7036428399134943},null,120.00000000000003,{"$f":"EXP(-(2*AA$9*(Z30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.8688422049932385},null,120.00000000000003,{"$f":"EXP(-(2*AD$9*(AC30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.93211705541377066}]
[null,null,null,null,null,null,null,null,null,null,95,{"$f":"EXP(-(2*L$9*(K31/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":3.828931986264477E-3},null,126.6666666666667,{"$f":"EXP(-(2*O$9*(N31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":2.4474759598108856E-2},null,126.6666666666667,{"$f":"EXP(-(2*R$9*(Q31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.22671871628241247},null,126.6666666666667,{"$f":"EXP(-(2*U$9*(T31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.47614988846203932},null,126.6666666666667,{"$f":"EXP(-(2*X$9*(W31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.6900361501124701},null,126.6666666666667,{"$f":"EXP(-(2*AA$9*(Z31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.86208231786196088},null,126.6666666666667,{"$f":"EXP(-(2*AD$9*(AC31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.9284838813151044}]
[null,null,null,null,null,null,null,null,null,null,100,{"$f":"EXP(-(2*L$9*(K32/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":2.8567432680090318E-3},null,133.33333333333337,{"$f":"EXP(-(2*O$9*(N32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":2.0133261841377773E-2},null,133.33333333333337,{"$f":"EXP(-(2*R$9*(Q32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.2096841757161812},null,133.33333333333337,{"$f":"EXP(-(2*U$9*(T32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.45791284729321713},null,133.33333333333337,{"$f":"EXP(-(2*X$9*(W32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.67669257960555262},null,133.33333333333337,{"$f":"EXP(-(2*AA$9*(Z32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.85537502494602524},null,133.33333333333337,{"$f":"EXP(-(2*AD$9*(AC32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.92486486847864713}]
[null,null,null,null,null,null,null,null,null,null,105,{"$f":"EXP(-(2*L$9*(K33/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":2.1313990764502454E-3},null,140.00000000000003,{"$f":"EXP(-(2*O$9*(N33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.6561888207670052E-2},null,140.00000000000003,{"$f":"EXP(-(2*R$9*(Q33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.19392952759579946},null,140.00000000000003,{"$f":"EXP(-(2*U$9*(T33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.44037430396856658},null,140.00000000000003,{"$f":"EXP(-(2*X$9*(W33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.66360704032474416},null,140.00000000000003,{"$f":"EXP(-(2*AA$9*(Z33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.84871991704459238},null,140.00000000000003,{"$f":"EXP(-(2*AD$9*(AC33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.92125996170711355}]
[null,null,null,null,null,null,null,null,null,null,110,{"$f":"EXP(-(2*L$9*(K34/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":1.5902241107787931E-3},null,146.66666666666669,{"$f":"EXP(-(2*O$9*(N34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.3624028891315977E-2},null,146.66666666666669,{"$f":"EXP(-(2*R$9*(Q34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.17935860703401529},null,146.66666666666669,{"$f":"EXP(-(2*U$9*(T34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.4235075052865242},null,146.66666666666669,{"$f":"EXP(-(2*X$9*(W34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.65077454259253575},null,146.66666666666669,{"$f":"EXP(-(2*AA$9*(Z34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.84211658814054435},null,146.66666666666669,{"$f":"EXP(-(2*AD$9*(AC34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.91766910601836449}]
[null,null,null,null,null,null,null,null,null,null,115,{"$f":"EXP(-(2*L$9*(K35/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":1.186456703694286E-3},null,153.33333333333334,{"$f":"EXP(-(2*O$9*(N35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.1207306854387032E-2},null,153.33333333333334,{"$f":"EXP(-(2*R$9*(Q35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.16588247450502794},null,153.33333333333334,{"$f":"EXP(-(2*U$9*(T35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.40728672272126415},null,153.33333333333334,{"$f":"EXP(-(2*X$9*(W35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.63819019321928172},null,153.33333333333334,{"$f":"EXP(-(2*AA$9*(Z35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.83556463537571413},null,153.33333333333334,{"$f":"EXP(-(2*AD$9*(AC35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.91409224664456823}]
[null,null,null,null,null,null,null,null,null,null,120,{"$f":"EXP(-(2*L$9*(K36/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":8.8520825473569051E-4},null,160,{"$f":"EXP(-(2*O$9*(N36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":9.2192792550851877E-3},null,160,{"$f":"EXP(-(2*R$9*(Q36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.1534188729660052},null,160,{"$f":"EXP(-(2*U$9*(T36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.39168721317654115},null,160,{"$f":"EXP(-(2*X$9*(W36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.62584919363736591},null,160,{"$f":"EXP(-(2*AA$9*(Z36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.82906365902630796},null,160,{"$f":"EXP(-(2*AD$9*(AC36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.91052932903136508}]
[null,null,null,null,null,null,null,null,null,null,125,{"$f":"EXP(-(2*L$9*(K37/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":6.6044858764110006E-4},null,166.66666666666666,{"$f":"EXP(-(2*O$9*(N37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":7.5839013857261607E-3},null,166.66666666666666,{"$f":"EXP(-(2*R$9*(Q37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.14189172576784673},null,166.66666666666666,{"$f":"EXP(-(2*U$9*(T37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.37668518124270128},null,166.66666666666666,{"$f":"EXP(-(2*X$9*(W37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.61374683807144892},null,166.66666666666666,{"$f":"EXP(-(2*AA$9*(Z37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.82261326247851885},null,166.66666666666666,{"$f":"EXP(-(2*AD$9*(AC37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.9069802988370359}]
[null,null,null,null,null,null,null,null,null,null,130,{"$f":"EXP(-(2*L$9*(K38/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":4.9275674349350093E-4},null,173.33333333333331,{"$f":"EXP(-(2*O$9*(N38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":6.2386178612275555E-3},null,173.33333333333331,{"$f":"EXP(-(2*R$9*(Q38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.13123067229048779},null,173.33333333333331,{"$f":"EXP(-(2*U$9*(T38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.36225774289928958},null,173.33333333333331,{"$f":"EXP(-(2*X$9*(W38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.60187851174409746},null,173.33333333333331,{"$f":"EXP(-(2*AA$9*(Z38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.81621305220432983},null,173.33333333333331,{"$f":"EXP(-(2*AD$9*(AC38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.90344510193167238}]
[null,null,null,null,null,null,null,null,null,null,135,{"$f":"EXP(-(2*L$9*(K39/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":3.6764286093116252E-4},null,179.99999999999997,{"$f":"EXP(-(2*O$9*(N39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":5.1319697921811663E-3},null,179.99999999999997,{"$f":"EXP(-(2*R$9*(Q39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.12137063846830645},null,179.99999999999997,{"$f":"EXP(-(2*U$9*(T39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.3483828906078863},null,179.99999999999997,{"$f":"EXP(-(2*X$9*(W39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.59023968911611346},null,179.99999999999997,{"$f":"EXP(-(2*AA$9*(Z39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.80986263773750522},null,179.99999999999997,{"$f":"EXP(-(2*AD$9*(AC39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.89992368439635217}]
[null,null,null,null,null,null,null,null,null,null,140,{"$f":"EXP(-(2*L$9*(K40/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":2.7429614100336078E-4},null,186.66666666666663,{"$f":"EXP(-(2*O$9*(N40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":4.2216264136873587E-3},null,186.66666666666663,{"$f":"EXP(-(2*R$9*(Q40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.11225143958415969},null,186.66666666666663,{"$f":"EXP(-(2*U$9*(T40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.33503945974192306},null,186.66666666666663,{"$f":"EXP(-(2*X$9*(W40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.57882593216088984},null,186.66666666666663,{"$f":"EXP(-(2*AA$9*(Z40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.80356163164976935},null,186.66666666666663,{"$f":"EXP(-(2*AD$9*(AC40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.8964159925223163}]
[null,null,null,null,null,null,null,null,null,null,145,{"$f":"EXP(-(2*L$9*(K41/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":2.0465071123310389E-4},null,193.33333333333329,{"$f":"EXP(-(2*O$9*(N41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":3.4727658771288492E-3},null,193.33333333333329,{"$f":"EXP(-(2*R$9*(Q41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.10381741290754271},null,193.33333333333329,{"$f":"EXP(-(2*U$9*(T41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.32220709630227373},null,193.33333333333329,{"$f":"EXP(-(2*X$9*(W41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.56763288867213624},null,193.33333333333329,{"$f":"EXP(-(2*AA$9*(Z41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.79730964952716987},null,193.33333333333329,{"$f":"EXP(-(2*AD$9*(AC41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.89292197281014973}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"$D$7","v":150},{"$f":"EXP(-(2*L$9*(K42/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":1.5268867237801251E-4},null,{"$f":"$D$8","v":200},{"$f":"EXP(-(2*O$9*(N42/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":2.8567432680090318E-3},null,{"$f":"$D$9","v":200},{"$f":"EXP(-(2*R$9*(Q42/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":9.6017077934527822E-2},null,{"$f":"$D$10","v":200},{"$f":"EXP(-(2*U$9*(T42/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.30986622586937063},null,{"$f":"$D$11","v":200},{"$f":"EXP(-(2*X$9*(W42/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.55665629060432853},null,{"$f":"$D$12","v":200},{"$f":"EXP(-(2*AA$9*(Z42/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.79110630994662523},null,{"$f":"$D$13","v":200},{"$f":"EXP(-(2*AD$9*(AC42/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.889441571968966}]
[]
[]
[]
[]
[]
[]
["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":"YYY"}]
[null,null,null,null,"Date:",null,{"$f":"IF(Data!B2 > 0,Data!B2,\"\")","v":"date"}]
[]
[]
["Depth to base of confining bed (ft bgs) [from boring log]:",24.27]
["Constant LNAPL discharge to well (ft3/d):",3.53]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!N24","v":0.38700000000000112},{"$f":"B6","v":3.53}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"B14","v":3.1364102564102572},{"$f":"M9","v":3.53}]
["Depth to top of screen (ft bgs):",{"$f":"Data!B10","v":0},null,null,null,null,null,null,null,null,null,0,0]
["Corrected water table elevation (ft bgs):",{"$f":"Data!I21","v":34.118600000000001}]
["Limiting effective LNAPL thickness in well, bnW (ft):",{"$f":"IF(B5>B11,(B5-B12)/Data!B9,(B11-B12)/Data!B9)","v":-12.626410256410258}]
["Limiting effective LNAPL drawdown, snW (ft):",{"$f":"(1-Data!B9)*(Confined!B15-Confined!B13)","v":3.1364102564102572}]
["Initial LNAPL thickness, bnR (ft):",{"$f":"Data!O21","v":1.6300000000000026}]
["Radius of influence ratio (from Bouwer and Rice), R/rw:",{"$f":"'B&R'!J12","v":5.4658512835676119}]
[]
[]
["LNAPL Transmissivity, Tn (ft2/d):",{"$f":"B6*LN(B16)/(2*PI()*(1-Data!B9)*(B15-B13))","v":0.30425141443545733}]

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

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