{"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":118,"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,25.674491403951937]
[]
[]
[null,null,null,null,null,null,null,null,"Standard Deviation (ft2/d)"]
[null,null,null,null,null,null,null,null,"NA"]
[]
[]
[null,null,null,null,null,null,null,null,"Coefficient of Variation"]
[null,null,null,null,null,null,null,null,"NA"]

{"sheet":"Data","index":1,"n_rows":83,"n_cols":22,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
["Well Designation:","HMW-44C","Example E3"]
["Date:","2009-08-12"," "," "]
[]
["Ground Surface Elev (ft msl)",429.8,"Enter These Data",null,"Drawdown"]
["Top of Casing Elev (ft msl)",429.4,null,null,"Adjustment"]
["Well Casing Radius, rc (ft):",8.3000000000000004E-2,"re1",null,"(ft)"]
["Well Radius, rw (ft):",0.35399999999999998,null,null,{"$f":"Figures!C28","v":-0.01}]
["LNAPL Specific Yield, Sy:",0.17499999999999999]
["LNAPL Density Ratio, rr:",0.76400000000000001]
["Top of Screen (ft bgs):",27.2]
["Bottom of Screen (ft bgs):",42.1]
["LNAPL Baildown Vol. (gal.):"," "]
["Effective Radius, re3 (ft):",{"$f":"SQRT(B8*(B7^2-B6^2)+B6^2)","v":0.16617377952011561},"Calculated Parameters"]
["Effective Radius, re2 (ft):",{"$f":"SQRT(-Figures!U27*B6^2+(Figures!U27+1)*B13^2)","v":0.14926033390431537}]
["Initial Casing LNAPL Vol. (gal.):",{"$f":"PI()*B6^2*(F21-E21)*7.48","v":0.34157817246436961}]
["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":1.0275967034876803}]
[]
[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,27.14,29.25,{"$f":"C21+B4-B5","v":27.54000000000002},{"$f":"D21+B4-B5","v":29.650000000000034},null,null,{"$f":"E21+(1-B$9)*(F21-E21)","v":28.037960000000023},null,null,null,null,null,{"$f":"F21-E21","v":2.1100000000000136}]
[]
["Enter Test Data:",2.7666666638106108,27.38,28.4,{"$f":"IF(B23>0,C23+B$4-B$5,NA())","v":27.78000000000003},{"$f":"IF(B23>0,D23+B$4-B$5,NA())","v":28.800000000000011},null,null,{"$f":"E23+(1-B$9)*(F23-E23)","v":28.020720000000026},{"$f":"E23-E$21-E$7","v":0.2500000000000091},null,null,null,null,{"$f":"F23-E23","v":1.0199999999999818},null,null,null,null,null,0,{"$f":"MAX(V24:V81)/(MAX(L24:L81)-L24)","v":0.16617377952011558}]
[null,3.4666666598059237,27.37,28.45,{"$f":"IF(B24>0,C24+B$4-B$5,NA())","v":27.770000000000039},{"$f":"IF(B24>0,D24+B$4-B$5,NA())","v":28.850000000000023},null,null,{"$f":"E24+(1-B$9)*(F24-E24)","v":28.024880000000035},0.2400000000000182,null,{"$f":"IF(B24>0,0.5*(B23+B24),0)","v":3.1166666618082672},{"$f":"IF(B24>0,1440*PI()*P24^2*(E23-E24+F24-F23)/(B24-B23),NA())","v":10.707561392242019},{"$f":"0.5*(J23+J24)","v":0.24500000000001365},{"$f":"F24-E24","v":1.0799999999999841},{"$f":"IF(B24>0,re(B$10,E24,F24,B$6,B$14,B$13), )","v":0.16617377952011561},null,null,{"$f":"(E23+E24)/2","v":27.775000000000034},{"$f":"(F23+F24)/2","v":28.825000000000017},{"$f":"U23+M24*(B24-B23)*7.48/1440","v":3.8933882728495538E-2},0]
[null,4.1999999969266355,27.36,28.47,27.760000000000048,28.870000000000005,null,null,28.021960000000039,0.23000000000002729,null,{"$f":"IF(B25>0,0.5*(B24+B25),0)","v":3.8333333283662796},{"$f":"IF(B25>0,1440*PI()*P25^2*(E24-E25+F25-F24)/(B25-B24),NA())","v":5.1104269724806617},{"$f":"0.5*(J24+J25)","v":0.23500000000002275},{"$f":"F25-E25","v":1.1099999999999568},{"$f":"IF(B25>0,re(B$10,E25,F25,B$6,B$14,B$13), )","v":0.16617377952011561},null,null,{"$f":"(E24+E25)/2","v":27.765000000000043},28.860000000000014,{"$f":"U24+M25*(B25-B24)*7.48/1440","v":5.840082409272486E-2},{"$f":"IF(P25>0,V24+0.5*(P24+P25)*(L25-L24),0)","v":0.11909120863802736}]
[null,4.7666666598524898,27.35,28.49,27.750000000000057,28.890000000000043,null,null,28.019040000000054,0.22000000000003639,null,4.4833333283895627,6.6134938069197879,0.22500000000003184,1.1399999999999864,{"$f":"IF(B26>0,re(B$10,E26,F26,B$6,B$14,B$13), )","v":0.16617377952011561},null,null,27.755000000000052,28.880000000000024,7.7867765456991075E-2,{"$f":"IF(P26>0,V25+0.5*(P25+P26)*(L26-L25),0)","v":0.22710416532997152}]
[null,5.5333333380986005,27.34,28.53,27.740000000000009,28.930000000000064,null,null,28.020840000000021,0.20999999999998864,null,5.1499999989755452,8.1470574114052692,0.21500000000001251,1.1900000000000546,{"$f":"IF(B27>0,re(B$10,E27,F27,B$6,B$14,B$13), )","v":0.16617377952011561},null,null,27.745000000000033,28.910000000000053,0.11031266773078038,0.33788668566133612]
[null,6.1833333328831941,27.33,28.56,27.730000000000018,28.960000000000036,null,null,28.020280000000021,0.19999999999999774,null,5.8583333354908973,7.6874799916121832,0.20499999999999319,1.2300000000000182,{"$f":"IF(B28>0,re(B$10,E28,F28,B$6,B$14,B$13), )","v":0.16617377952011561},null,null,27.735000000000014,28.94500000000005,0.13626858954975282,0.4555931133501861]
[null,6.8499999982304871,27.32,28.59,27.720000000000027,28.990000000000009,null,null,28.019720000000024,0.19000000000000683,null,6.5166666655568406,7.4952929465155176,0.19500000000000228,1.2699999999999818,{"$f":"IF(B29>0,re(B$10,E29,F29,B$6,B$14,B$13), )","v":0.16617377952011561},null,null,27.725000000000023,28.975000000000023,0.16222451136872526,0.56499085099130764]
[null,7.5166666635777801,27.31,28.62,27.710000000000036,29.020000000000039,null,null,28.019160000000038,0.18000000000001593,null,7.1833333309041336,7.4952929465261695,0.18500000000001138,1.3100000000000023,{"$f":"IF(B30>0,re(B$10,E30,F30,B$6,B$14,B$13), )","v":0.16617377952011561},null,null,27.715000000000032,29.005000000000024,0.18818043318773459,0.67577337045213937]
[null,8.3500000031199306,27.3,28.66,27.700000000000045,29.060000000000059,null,null,28.020960000000048,0.17000000000002502,null,7.9333333333488554,7.4952928758461166,0.17500000000002047,1.3600000000000136,{"$f":"IF(B31>0,re(B$10,E31,F31,B$6,B$14,B$13), )","v":0.16617377952011561},null,null,27.705000000000041,29.040000000000049,0.22062533546148702,0.80040370549847473]
[null,8.8666666648350656,27.29,28.68,27.690000000000055,29.080000000000041,null,null,28.018040000000052,0.16000000000003411,null,8.6083333339774981,7.2535093582392021,0.16500000000002957,1.3899999999999864,{"$f":"IF(B32>0,re(B$10,E32,F32,B$6,B$14,B$13), )","v":0.16617377952011561},null,null,27.69500000000005,29.07000000000005,0.24009227682571635,0.9125710067790167]
[null,9.9666666705161333,27.28,28.73,27.680000000000064,29.130000000000052,null,null,28.022200000000062,0.15000000000004321,null,9.4166666676755995,6.8139026299806709,0.15500000000003866,1.4499999999999886,{"$f":"IF(B33>0,re(B$10,E33,F33,B$6,B$14,B$13), )","v":0.16617377952011561},null,null,27.685000000000059,29.105000000000047,0.27902615955421189,1.046894811951725]
[null,10.716666667722166,27.27,28.77,27.670000000000016,29.170000000000016,null,null,28.024000000000015,0.13999999999999546,null,10.341666669119149,8.3281032884583794,0.14500000000001934,1.5,{"$f":"IF(B34>0,re(B$10,E34,F34,B$6,B$14,B$13), )","v":0.16617377952011561},null,null,27.67500000000004,29.150000000000034,0.3114710618279643,1.200605558247712]
[null,11.350000002421439,27.26,28.8,27.660000000000025,29.200000000000045,null,null,28.023440000000029,0.13000000000000456,null,11.033333335071802,7.8897820163442951,0.13500000000000001,1.5400000000000205,{"$f":"IF(B35>0,re(B$10,E35,F35,B$6,B$14,B$13), )","v":0.16617377952011561},null,null,27.66500000000002,29.185000000000031,0.3374269836469736,1.3155424222971415]
[null,12.016666667768732,27.24,28.87,27.640000000000043,29.270000000000039,null,null,28.024680000000043,0.11000000000002273,null,11.683333335095085,16.864409129670566,0.12000000000001365,1.6299999999999955,{"$f":"IF(B36>0,re(B$10,E36,F36,B$6,B$14,B$13), )","v":0.16617377952011561},null,null,27.650000000000034,29.235000000000042,0.39582780773969845,1.4235553789890856]
[null,12.333333335118368,27.23,28.88,27.630000000000052,29.28000000000003,null,null,28.019400000000047,0.10000000000003183,null,12.17500000144355,7.8897820163330836,0.10500000000002728,1.6499999999999773,{"$f":"IF(B37>0,re(B$10,E37,F37,B$6,B$14,B$13), )","v":0.16617377952011561},null,null,27.635000000000048,29.275000000000034,0.40880576864918466,1.5052574872002655]
[null,12.716666674241424,27.22,28.9,27.620000000000005,29.300000000000011,null,null,28.016480000000005,8.9999999999984079E-2,null,12.525000004679896,9.7764688936826172,9.5000000000007953E-2,1.6800000000000068,{"$f":"IF(B38>0,re(B$10,E38,F38,B$6,B$14,B$13), )","v":0.16617377952011561},null,null,27.625000000000028,29.29000000000002,0.42827271001345085,1.5634183105701018]
[null,13.13333333353512,27.21,28.91,27.610000000000014,29.310000000000059,null,null,28.011200000000024,7.9999999999993174E-2,null,12.925000003888272,5.9962344514666874,8.4999999999988626E-2,1.7000000000000455,{"$f":"IF(B39>0,re(B$10,E39,F39,B$6,B$14,B$13), )","v":0.16617377952011561},null,null,27.615000000000009,29.305000000000035,0.44125067092297393,1.6298878222466009]
[null,13.883333330741152,27.2,28.95,27.600000000000023,29.350000000000023,null,null,28.013000000000023,7.0000000000002269E-2,null,13.508333332138136,8.3281032884489115,7.4999999999997721E-2,1.75,{"$f":"IF(B40>0,re(B$10,E40,F40,B$6,B$14,B$13), )","v":0.16617377952011561},null,null,27.605000000000018,29.330000000000041,0.47369557319668948,1.726822526121929]
[null,14.466666664229706,27.19,28.97,27.590000000000032,29.370000000000005,null,null,28.010080000000027,6.0000000000011371E-2,null,14.174999997485429,6.4245367968749489,6.5000000000006816E-2,1.7799999999999727,{"$f":"IF(B41>0,re(B$10,E41,F41,B$6,B$14,B$13), )","v":0.16617377952011561},null,null,27.595000000000027,29.360000000000014,0.49316251456091881,1.8376050455827608]
[null,15.749999993713573,27.18,28.99,27.580000000000041,29.390000000000043,null,null,28.007160000000042,5.0000000000020466E-2,null,15.108333328971639,2.9202440081216281,5.5000000000015918E-2,1.8100000000000023,{"$f":"IF(B42>0,re(B$10,E42,F42,B$6,B$14,B$13), )","v":0.16617377952011561},null,null,27.585000000000036,29.380000000000024,0.51262945592518505,1.9927005728279252]
[null,17.066666674800217,27.17,29.03,27.57000000000005,29.430000000000064,null,null,{"$f":"E43+(1-B$9)*(F43-E43)","v":28.008960000000052},4.0000000000029561E-2,null,16.408333334256895,4.7438562339258468,{"$f":"0.5*(J42+J43)","v":4.5000000000025013E-2},{"$f":"F43-E43","v":1.8600000000000136},{"$f":"IF(B43>0,re(B$10,E43,F43,B$6,B$14,B$13), )","v":0.16617377952011561},null,null,27.575000000000045,29.410000000000053,0.54507435819893746,2.2087264870823464]
[null,19.183333333348855,27.16,29.05,27.560000000000059,29.450000000000045,null,null,28.006040000000056,3.0000000000038655E-2,null,18.125000004074536,1.7705416441957074,3.5000000000034108E-2,1.8899999999999864,{"$f":"IF(B44>0,re(B$10,E44,F44,B$6,B$14,B$13), )","v":0.16617377952011561},null,null,27.565000000000055,29.440000000000055,0.56454129956316679,2.4939914757821544]
[null,23.583333324640989,27.15,29.08,27.550000000000011,29.480000000000018,null,null,{"$f":"E45+(1-B$9)*(F45-E45)","v":28.005480000000013},1.9999999999990907E-2,null,21.383333328994922,1.135650446443359,{"$f":"0.5*(J44+J45)","v":2.5000000000014781E-2},{"$f":"F45-E45","v":1.9300000000000068},{"$f":"IF(B45>0,re(B$10,E45,F45,B$6,B$14,B$13), )","v":0.16617377952011561},null,null,27.555000000000035,29.465000000000032,0.59049722138217609,3.0354410393205198]
[null,27.23333332920447,27.14,29.11,27.54000000000002,29.510000000000048,null,null,{"$f":"E46+(1-B$9)*(F46-E46)","v":28.004920000000027},{"$f":"E46-E$21-E$7","v":0.01},null,25.40833332692273,1.369003273483361,{"$f":"0.5*(J45+J46)","v":1.4999999999995454E-2},{"$f":"F46-E46","v":1.9700000000000273},{"$f":"IF(B46>0,re(B$10,E46,F46,B$6,B$14,B$13), )","v":0.16617377952011561},null,null,{"$f":"(E45+E46)/2","v":27.545000000000016},{"$f":"(F45+F46)/2","v":29.495000000000033},{"$f":"U45+M46*(B46-B45)*7.48/1440","v":0.61645314320118538},3.7042905015446408]
[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(B47>0,re(B$10,E47,F47,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(B48>0,re(B$10,E48,F48,B$6,B$14,B$13), )","v":0},null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(B49>0,re(B$10,E49,F49,B$6,B$14,B$13), )","v":0},null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(B50>0,re(B$10,E50,F50,B$6,B$14,B$13), )","v":0},null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(B51>0,re(B$10,E51,F51,B$6,B$14,B$13), )","v":0},null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(B52>0,re(B$10,E52,F52,B$6,B$14,B$13), )","v":0},null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(B53>0,re(B$10,E53,F53,B$6,B$14,B$13), )","v":0},null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(B54>0,re(B$10,E54,F54,B$6,B$14,B$13), )","v":0},null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(B55>0,re(B$10,E55,F55,B$6,B$14,B$13), )","v":0},null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},{"$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":6.5896498775218276E-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":2.2133333310484886},{"$f":"Data!E21","v":27.54000000000002}]
[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":27.23333332920447},{"$f":"U3","v":27.54000000000002}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T3","v":2.2133333310484886},{"$f":"Data!F21","v":29.650000000000034}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T4","v":27.23333332920447},{"$f":"U5","v":29.650000000000034}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T4/4","v":6.8083333323011175},{"$f":"IF(V8<V9,V8,NA())","v":26.54000000000002},{"$f":"IF(Data!B10>Data!E21,Data!B10,Data!E21-1)","v":26.54000000000002}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T8","v":6.8083333323011175},{"$f":"IF(V8<V9,V9,NA())","v":30.650000000000034},{"$f":"IF(Data!B11<Data!F21,Data!B11,Data!F21+1)","v":30.650000000000034}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,2.02,0]
[null,7.5,7.4999999999999997E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.52]
[]
[]
[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.25742574257425743}]
[null,"Dsn (ft)",-0.01]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Figure 5",null,null,null,null,null,null,null,"Figure 6"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Figure 7",null,null,null,null,null,null,null,"Figure 8"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Figure 9",null,null,null,null,null,null,null,"Figure 10"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"t (min)","sn (ft)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,0.115]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,0]

{"sheet":"B&R","index":3,"n_rows":64,"n_cols":28,"rows_kept":64,"cut":false,"hidden":true,"merged":[]}
["Generalized Bouwer and Rice (1976)"]
["Well Designation:",null,{"$f":"IF(Data!B1 > 0,Data!B1,\"\")","v":"HMW-44C"}]
["Date:",null,{"$f":"IF(Data!B2 > 0,Data!B2,\"\")","v":"2009-08-12"},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":49.366666661342606},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":-33.154564199992656},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":469.10277747686229},null,{"$f":"X6+1.05*(MAX(M$6:M$64)/30)","v":0.5331666665221565},{"$f":"EXP(-2*E$12*(X7/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.92391061468351321},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":12.697550757365994},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":-185.53862264645232},null,{"$f":"X7+1.05*(MAX(M$6:M$64)/30)","v":1.066333333044313},{"$f":"EXP(-2*E$12*(X8/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.8536108239248672},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"Timecut",12,"<-  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":11},null,1.5994999995664694,{"$f":"EXP(-2*E$12*(X9/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.78866010103292417},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.299091931564915},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":2723.0627749933697},null,2.132666666088626,{"$f":"EXP(-2*E$12*(X10/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.72865143872169058},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":-2.3478984303896637},null,2.6658333326107826,{"$f":"EXP(-2*E$12*(X11/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.67320879863938343},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Model Results:",null,"Tn (ft2/d) =",{"$f":"1440*V22*(-V12)","v":21.422488875687097},"+/-",{"$f":"1440*V22*SQRT(V15)","v":0.95571773551052985},"ft2/d",null,{"$f":"EXP(((1.1/LN(J8))+J10/J8)^-1)","v":6.4796452758132288},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":-0.14843379067852711},null,3.1989999991329392,{"$f":"EXP(-2*E$12*(X12/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.62198475496126215},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,3.7321666656550958,{"$f":"EXP(-2*E$12*(X13/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.57465831728003403},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":1.0855503308324672E-2},null,4.265333332177252,{"$f":"EXP(-2*E$12*(X14/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.53093291915118956},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,{"$f":"Figures!U27","v":-0.25742574257425743},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":4.3851554759644551E-5},null,4.7984999986994081,{"$f":"EXP(-2*E$12*(X15/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.49053455968868764},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B33>=D$9,Data!B33-D$9,0)","v":0},{"$f":"IF(S16>0,LN(Data!J33),0)","v":0},0,0,0,0,{"$f":"IF(Data!B33>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,5.3316666652215643,{"$f":"EXP(-2*E$12*(X16/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.45321008656548201},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B34>=D$9,Data!B34-D$9,0)","v":0},{"$f":"IF(S17>0,LN(Data!J34),0)","v":0},0,0,0,0,{"$f":"IF(Data!B34>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,5.8648333317437205,{"$f":"EXP(-2*E$12*(X17/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.41872560965948269},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B35>=D$9,Data!B35-D$9,0)","v":0},{"$f":"IF(S18>0,LN(Data!J35),0)","v":0},0,0,0,0,{"$f":"IF(Data!B35>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},"Plot Model Line",null,null,6.3979999982658766,{"$f":"EXP(-2*E$12*(X18/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.38686503540422146},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B36>=D$9,Data!B36-D$9,0)","v":1.6666667768731713E-2},{"$f":"IF(S19>0,LN(Data!J36),0)","v":-2.2072749131895142},2.7777781451328055E-4,-3.6787917652385767E-2,2.0476869857725066E-2,1.3734308650058802,{"$f":"IF(Data!B36>'B&R'!D$9,1,0)","v":1},1.1509912380002756,0,{"$f":"V11","v":-2.3478984303896637},null,6.9311666647880328,{"$f":"EXP(-2*E$12*(X19/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.35742871265987336},null,1.6666667768731713E-2,-2.2072749131895142]
[null,null,null,null,null,null,null,null,null,"Coef. Of",null,null,{"$f":"IF(Data!B37>=D$9,Data!B37-D$9,0)","v":0.33333333511836827},{"$f":"IF(S20>0,LN(Data!J37),0)","v":-2.3025850929937275},0.11111111230113441,-0.76752836844143735,8.9853844676385415E-3,0.90979459043774713,{"$f":"IF(Data!B37>'B&R'!D$9,1,0)","v":1},1.0463556709094579,{"$f":"MAX(M6:M64)","v":15.23333332920447},{"$f":"V11+V12*U20","v":-4.6090398411130309},null,7.4643333313101889,{"$f":"EXP(-2*E$12*(X20/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.33023218161912044},null,0.33333333511836827,-2.3025850929937275]
[null,null,null,null,null,null,null,null,null,"Variation",null,null,{"$f":"IF(Data!B38>=D$9,Data!B38-D$9,0)","v":0.71666667424142361},{"$f":"IF(S21>0,LN(Data!J38),0)","v":-2.407945608652049},0.51361112196826275,-1.7256943711069044,2.1465034482571555E-3,0.44467305406771318,{"$f":"IF(Data!B38>'B&R'!D$9,1,0)","v":1},0.94172010381804583,null,null,null,7.9974999978323451,{"$f":"EXP(-2*E$12*(X21/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.3051050179079991},null,0.71666667424142361,-2.407945608652049]
[null,null,null,null,null,null,null,null,null,{"$f":"G12/E12","v":4.4612824450813326E-2},null,null,{"$f":"IF(Data!B39>=D$9,Data!B39-D$9,0)","v":1.1333333335351199},{"$f":"IF(S22>0,LN(Data!J39),0)","v":-2.5257286443083409},1.2844444449018273,-2.8624924640591112,9.2260849073032546E-5,-9.2189984408008616E-2,{"$f":"IF(Data!B39>'B&R'!D$9,1,0)","v":1},0.83708453672722849,"factor",{"$f":"Data!V23^2*LN('B&R'!J12)/(2*(-Figures!U27))","v":0.10022467470438273},null,8.5306666643545022,{"$f":"EXP(-2*E$12*(X22/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.28188976463840376},null,1.1333333335351199,-2.5257286443083409]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B40>=D$9,Data!B40-D$9,0)","v":1.8833333307411522},{"$f":"IF(S23>0,LN(Data!J40),0)","v":-2.6592600369327455},3.5469444346805621,-5.0082730626633865,1.0119588808532136E-3,-0.30532084174141233,{"$f":"IF(Data!B40>'B&R'!D$9,1,0)","v":1},0.73244896963641148,null,null,null,9.0638333308766583,{"$f":"EXP(-2*E$12*(X23/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.26044094572005844},null,1.8833333307411522,-2.6592600369327455]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B41>=D$9,Data!B41-D$9,0)","v":2.4666666642297059},{"$f":"IF(S24>0,LN(Data!J41),0)","v":-2.8134107167598468},6.0844444324221048,-6.9397464278181173,9.875510483182956E-3,-0.95379445912211136,{"$f":"IF(Data!B41>'B&R'!D$9,1,0)","v":1},0.62781340254559415,null,null,null,9.5969999973988145,{"$f":"EXP(-2*E$12*(X24/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.24062415424897476},null,2.4666666642297059,-2.8134107167598468]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B42>=D$9,Data!B42-D$9,0)","v":3.7499999937135726},{"$f":"IF(S25>0,LN(Data!J42),0)","v":-2.9957322735535818},14.062499952851795,-11.233996006993479,8.3187403900102756E-3,-0.8753944795868045,{"$f":"IF(Data!B42>'B&R'!D$9,1,0)","v":1},0.52317783545477659,"s0 (ft)",{"$f":"EXP(V19)","v":9.5569797899709472E-2},null,10.130166663920971,{"$f":"EXP(-2*E$12*(X25/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.22231521025987078},null,3.7499999937135726,-2.9957322735535818]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B43>=D$9,Data!B43-D$9,0)","v":5.0666666748002172},{"$f":"IF(S26>0,LN(Data!J43),0)","v":-3.2188758248674616},25.67111119353109,-16.308970872176026,1.414026680662126E-2,-1.1413105190166992,{"$f":"IF(Data!B43>'B&R'!D$9,1,0)","v":1},0.41854226836395941,null," ",null,10.663333330443127,{"$f":"EXP(-2*E$12*(X26/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.20539938256469173},null,5.0666666748002172,-3.2188758248674616]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B44>=D$9,Data!B44-D$9,0)","v":7.1833333333488554},{"$f":"IF(S27>0,LN(Data!J44),0)","v":-3.5065578973186931},51.60027777800078,-25.188774229127041,8.5396211395437072E-3,-0.88694015983542218,{"$f":"IF(Data!B44>'B&R'!D$9,1,0)","v":1},0.31390670127314202,null,null,null,11.196499996965283,{"$f":"EXP(-2*E$12*(X27/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.18977066980095839},null,7.1833333333488554,-3.5065578973186931]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B45>=D$9,Data!B45-D$9,0)","v":11.583333324640989},{"$f":"IF(S28>0,LN(Data!J45),0)","v":-3.9120230054286007},134.17361090973847,-45.314266445543311,2.4097439221230869E-2,1.4899114741334938,{"$f":"IF(Data!B45>'B&R'!D$9,1,0)","v":1},0.20927113418172988,null,null,null,11.729666663487439,{"$f":"EXP(-2*E$12*(X28/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.17533113618470544},null,11.583333324640989,-3.9120230054286007]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B46>=D$9,Data!B46-D$9,0)","v":15.23333332920447},{"$f":"IF(S29>0,LN(Data!J46),0)","v":-4.6051701859880909},232.05444431865175,-70.152092480871133,1.4974230785970774E-5,3.7140460065624485E-2,{"$f":"IF(Data!B46>'B&R'!D$9,1,0)","v":1},0.10463556709091255,null,null,null,12.262833330009595,{"$f":"EXP(-2*E$12*(X29/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.16199029780557003},null,15.23333332920447,-4.6051701859880909]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B47>=D$9,Data!B47-D$9,0)","v":0},{"$f":"IF(S30>0,LN(Data!J47),0)","v":0},0,0,0,0,{"$f":"IF(Data!B47>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,12.795999996531751,{"$f":"EXP(-2*E$12*(X30/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.14966455561830957},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B48>=D$9,Data!B48-D$9,0)","v":0},{"$f":"IF(S31>0,LN(Data!J48),0)","v":0},0,0,0,0,{"$f":"IF(Data!B48>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,13.329166663053908,{"$f":"EXP(-2*E$12*(X31/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.1382766715776472},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B49>=D$9,Data!B49-D$9,0)","v":0},{"$f":"IF(S32>0,LN(Data!J49),0)","v":0},0,0,0,0,{"$f":"IF(Data!B49>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,13.862333329576064,{"$f":"EXP(-2*E$12*(X32/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.12775528463369437},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B50>=D$9,Data!B50-D$9,0)","v":0},{"$f":"IF(S33>0,LN(Data!J50),0)","v":0},0,0,0,0,{"$f":"IF(Data!B50>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,14.39549999609822,{"$f":"EXP(-2*E$12*(X33/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.11803446355498379},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B51>=D$9,Data!B51-D$9,0)","v":0},{"$f":"IF(S34>0,LN(Data!J51),0)","v":0},0,0,0,0,{"$f":"IF(Data!B51>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,14.928666662620376,{"$f":"EXP(-2*E$12*(X34/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.10905329377692374},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"C coefficient calculated from Eq. 6.5(c) of Butler, The Design, Performance, and",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B52>=D$9,Data!B52-D$9,0)","v":0},{"$f":"IF(S35>0,LN(Data!J52),0)","v":0},0,0,0,0,{"$f":"IF(Data!B52>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,15.461833329142532,{"$f":"EXP(-2*E$12*(X35/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.10075549568669939},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[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,15.994999995664688,{"$f":"EXP(-2*E$12*(X36/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":9.3089071952640476E-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":21.42},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":21.42},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 = 21.42 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":true,"merged":[]}
["Cooper and Jacob (1946)"]
["Well Designation:",null,{"$f":"IF(Data!B1 > 0,Data!B1,\"\")","v":"HMW-44C"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E10","v":8},{"$f":"E9","v":12},0]
["Date:",null,{"$f":"IF(Data!B2 > 0,Data!B2,\"\")","v":"2009-08-12"},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"MAX(P9:Q58)","v":0.22414377187854395},null,null,null,null,null,{"$f":"W2","v":8},{"$f":"X2","v":12},{"$f":"J50","v":70}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"Q3","v":0.22414377187854395}]
[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":35.40833332692273}]
[]
[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,12,"<-  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":3.1166666618082672},{"$f":"Data!M24/Data!N24","v":43.704332213230295},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":109.12209961911509},{"$f":"X9+E$10","v":10}]
[null,"  Time Adjustment (min):",null,null,8,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":3.8333333283662796},{"$f":"Data!M25/Data!N25","v":21.746497755234753},null,1,{"$f":"2+(X$5-2)*W10/50","v":2.6681666665384545},{"$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":100.01344963989024},{"$f":"X10+E$10","v":10.668166666538454}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(Data!L26>=E$9,Data!L26-E$10,0)","v":0},{"$f":"IF(O11>0,P10+7.48*Data!M26*(Data!B26-Data!B25)/1440,0)","v":0},{"$f":"IF(O11>0,Q10+7.48*(4*PI()*(E$16/1440)*Data!N26)*(Data!B26-Data!B25)/LN(0.56146/((Data!P26^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O11))),0)","v":0},0,null,{"$f":"Data!L26","v":4.4833333283895627},{"$f":"Data!M26/Data!N26","v":29.393305808528233},null,2,3.3363333330769089,{"$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":93.934273760217749},11.336333333076908]
[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":5.1499999989755452},{"$f":"Data!M27/Data!N27","v":37.893290285603697},null,3,4.0044999996153638,{"$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":89.491044172388953},12.004499999615364]
[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":5.8583333354908973},{"$f":"Data!M28/Data!N28","v":37.499902398109455},null,4,4.6726666661538179,{"$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":86.050307433099448},12.672666666153818]
[null,"Root-Mean-Square Error:",null,null,{"$f":"SQRT(SUM(R9:R58))","v":1.9865587938709888E-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":6.5166666655568406},{"$f":"Data!M29/Data!N29","v":38.437399725720155},null,5,5.3408333326922728,{"$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":83.27714721758116},13.340833332692274]
[null,null,null,null,{"$f":"IF(E12=\"d\",0.025*SQRT(E16),E12)","v":0.13106118195934355},"<-- 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":7.1833333309041336},{"$f":"Data!M30/Data!N30","v":40.515097008247075},null,6,6.0089999992307277,{"$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":80.975548978332625},14.008999999230728]
[null,"Trial Tn (ft2/d):",null,null,27.483253466528257,"<-- 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.9333333333488554},{"$f":"Data!M31/Data!N31","v":42.830245004829941},null,7,6.6771666657691817,{"$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":79.022061195561776},14.677166665769182]
[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.6083333339774981},{"$f":"Data!M32/Data!N32","v":43.96066277719941},null,8,7.3453333323076366,{"$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":77.334490641713288},15.345333332307636]
[null,"Model Result:",null,"Tn (ft2/d) =",{"$f":"E16","v":27.483253466528257},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.4166666676755995},{"$f":"Data!M33/Data!N33","v":43.960662128896587},null,9,8.0134999988460915,{"$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":75.855674862864248},16.013499998846093]
[null,null,null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"IF(Data!L34>=E$9,Data!L34-E$10,0)","v":0},{"$f":"IF(O19>0,P18+7.48*Data!M34*(Data!B34-Data!B33)/1440,0)","v":0},{"$f":"IF(O19>0,Q18+7.48*(4*PI()*(E$16/1440)*Data!N34)*(Data!B34-Data!B33)/LN(0.56146/((Data!P34^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O19))),0)","v":0},0,null,{"$f":"Data!L34","v":10.341666669119149},{"$f":"Data!M34/Data!N34","v":57.435195092808748},null,10,8.6816666653845456,{"$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":74.544437284168751},16.681666665384547]
[null,null,null,null,null,null,null,null,null,null,null,null,null,12,{"$f":"IF(Data!L35>=E$9,Data!L35-E$10,0)","v":0},{"$f":"IF(O20>0,P19+7.48*Data!M35*(Data!B35-Data!B34)/1440,0)","v":0},{"$f":"IF(O20>0,Q19+7.48*(4*PI()*(E$16/1440)*Data!N35)*(Data!B35-Data!B34)/LN(0.56146/((Data!P35^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O20))),0)","v":0},0,null,{"$f":"Data!L35","v":11.033333335071802},{"$f":"Data!M35/Data!N35","v":58.442829750698479},null,11,9.3498333319230014,{"$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":73.370245472240626},17.349833331923001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,13,{"$f":"IF(Data!L36>=E$9,Data!L36-E$10,0)","v":0},{"$f":"IF(O21>0,P20+7.48*Data!M36*(Data!B36-Data!B35)/1440,0)","v":0},{"$f":"IF(O21>0,Q20+7.48*(4*PI()*(E$16/1440)*Data!N36)*(Data!B36-Data!B35)/LN(0.56146/((Data!P36^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O21))),0)","v":0},0,null,{"$f":"Data!L36","v":11.683333335095085},{"$f":"Data!M36/Data!N36","v":140.53674274723872},null,12,10.017999998461455,{"$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":72.309903645568596},18.017999998461455]
[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":4.17500000144355},{"$f":"IF(O22>0,P21+7.48*Data!M37*(Data!B37-Data!B36)/1440,0)","v":1.2977960909486219E-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":1.52912609376228E-2},5.3513570201767051E-6,null,{"$f":"Data!L37","v":12.17500000144355},{"$f":"Data!M37/Data!N37","v":75.140781107914606},null,13,10.686166664999909,{"$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":71.345422427773158},18.686166664999909]
[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":4.5250000046798959},{"$f":"IF(O23>0,P22+7.48*Data!M38*(Data!B38-Data!B37)/1440,0)","v":3.2444902273752435E-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":3.1700200421415109E-2},5.5458084887464467E-7,null,{"$f":"Data!L38","v":12.525000004679896},{"$f":"Data!M38/Data!N38","v":102.91019888086105},null,14,11.354333331538363,{"$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":70.462600266403129},19.354333331538363]
[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":4.9250000038882717},{"$f":"IF(O24>0,P23+7.48*Data!M39*(Data!B39-Data!B38)/1440,0)","v":4.5422863183275541E-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.7326100908382102E-2},3.6223138382687945E-6,null,{"$f":"Data!L39","v":12.925000003888272},{"$f":"Data!M39/Data!N39","v":70.543934723146933},null,15,12.022499998076819,{"$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":69.650051325338907},20.022499998076817]
[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":5.508333332138136},{"$f":"IF(O25>0,P24+7.48*Data!M40*(Data!B40-Data!B39)/1440,0)","v":7.7867765456991089E-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":7.1478798084132461E-2},4.0818904091452081E-5,null,{"$f":"Data!L40","v":13.508333332138136},{"$f":"Data!M40/Data!N40","v":111.0413771793222},null,16,12.690666664615273,{"$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":68.89852257121224},20.690666664615271]
[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":6.174999997485429},{"$f":"IF(O26>0,P25+7.48*Data!M41*(Data!B41-Data!B40)/1440,0)","v":9.7334706821220418E-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":8.7326166761499791E-2},1.0017087412703258E-4,null,{"$f":"Data!L41","v":14.174999997485429},{"$f":"Data!M41/Data!N41","v":98.839027644219613},null,17,13.358833331153727,{"$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":68.200403461867964},21.358833331153726]
[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":7.1083333289716393},{"$f":"IF(O27>0,P26+7.48*Data!M42*(Data!B42-Data!B41)/1440,0)","v":0.11680164818548663},{"$f":"IF(O27>0,Q26+7.48*(4*PI()*(E$16/1440)*Data!N42)*(Data!B42-Data!B41)/LN(0.56146/((Data!P42^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O27))),0)","v":0.11588995070926487},8.3119228814912561E-7,null,{"$f":"Data!L42","v":15.108333328971639},{"$f":"Data!M42/Data!N42","v":53.095345602196055},null,18,14.026999997692183,{"$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":67.549367080353292},22.026999997692183]
[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":8.4083333342568949},{"$f":"IF(O28>0,P27+7.48*Data!M43*(Data!B43-Data!B42)/1440,0)","v":0.14924655045923907},{"$f":"IF(O28>0,Q27+7.48*(4*PI()*(E$16/1440)*Data!N43)*(Data!B43-Data!B42)/LN(0.56146/((Data!P43^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O28))),0)","v":0.13899207142303219},1.0515434030400641E-4,null,{"$f":"Data!L43","v":16.408333334256895},{"$f":"Data!M43/Data!N43","v":105.41902742051577},null,19,14.695166664230637,{"$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":66.940102940100374},22.695166664230637]
[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":10.125000004074536},{"$f":"IF(O29>0,P28+7.48*Data!M44*(Data!B44-Data!B43)/1440,0)","v":0.1687134918234684},{"$f":"IF(O29>0,Q28+7.48*(4*PI()*(E$16/1440)*Data!N44)*(Data!B44-Data!B43)/LN(0.56146/((Data!P44^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O29))),0)","v":0.16675673584174511},3.8288939720098786E-6,null,{"$f":"Data!L44","v":18.125000004074536},{"$f":"Data!M44/Data!N44","v":50.586904119828056},null,20,15.363333330769091,{"$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":66.368114969249504},23.363333330769091]
[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":13.383333328994922},{"$f":"IF(O30>0,P29+7.48*Data!M45*(Data!B45-Data!B44)/1440,0)","v":0.19466941364247772},{"$f":"IF(O30>0,Q29+7.48*(4*PI()*(E$16/1440)*Data!N45)*(Data!B45-Data!B44)/LN(0.56146/((Data!P45^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O30))),0)","v":0.20571159335663622},1.2192973283977339E-4,null,{"$f":"Data!L45","v":21.383333328994922},{"$f":"Data!M45/Data!N45","v":45.4260178577075},null,21,16.031499997307549,{"$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":65.829566648714504},24.031499997307549]
[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":17.40833332692273},{"$f":"IF(O31>0,P30+7.48*Data!M46*(Data!B46-Data!B45)/1440,0)","v":0.22062533546148705},{"$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.22414377187854395},1.2379394820872215E-5,null,{"$f":"Data!L46","v":25.40833332692273},{"$f":"Data!M46/Data!N46","v":91.266884898918391},null,22,16.699666663846003,{"$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":65.321160801928983},24.699666663846003]
[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":0},{"$f":"IF(O32>0,P31+7.48*Data!M47*(Data!B47-Data!B46)/1440,0)","v":0},{"$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},0,null,{"$f":"Data!L47","v":0},{"$f":"Data!M47/Data!N47","v":{"$error":"#N/A"}},null,23,17.367833330384457,{"$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":64.840045213377195},25.367833330384457]
[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":0},{"$f":"IF(O33>0,P32+7.48*Data!M48*(Data!B48-Data!B47)/1440,0)","v":0},{"$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},0,null,{"$f":"Data!L48","v":0},{"$f":"Data!M48/Data!N48","v":{"$error":"#N/A"}},null,24,18.035999996922911,{"$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":64.383737750506612},26.035999996922911]
[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":0},{"$f":"IF(O34>0,P33+7.48*Data!M49*(Data!B49-Data!B48)/1440,0)","v":0},{"$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},0,null,{"$f":"Data!L49","v":0},{"$f":"Data!M49/Data!N49","v":{"$error":"#N/A"}},null,25,18.704166663461365,{"$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":63.950066388390624},26.704166663461365]
[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":0},{"$f":"IF(O35>0,P34+7.48*Data!M50*(Data!B50-Data!B49)/1440,0)","v":0},{"$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},0,null,{"$f":"Data!L50","v":0},{"$f":"Data!M50/Data!N50","v":{"$error":"#N/A"}},null,26,19.372333329999819,{"$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":63.537120746524877},27.372333329999819]
[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":0},{"$f":"IF(O36>0,P35+7.48*Data!M51*(Data!B51-Data!B50)/1440,0)","v":0},{"$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},0,null,{"$f":"Data!L51","v":0},{"$f":"Data!M51/Data!N51","v":{"$error":"#N/A"}},null,27,20.040499996538273,{"$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":63.143212608377773},28.040499996538273]
[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":0},{"$f":"IF(O37>0,P36+7.48*Data!M52*(Data!B52-Data!B51)/1440,0)","v":0},{"$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},0,null,{"$f":"Data!L52","v":0},{"$f":"Data!M52/Data!N52","v":{"$error":"#N/A"}},null,28,20.708666663076727,{"$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":62.766843515516818},28.708666663076727]
[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,21.376833329615184,{"$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":62.406677981743655},29.376833329615184]
[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,22.044999996153638,{"$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":62.061521207702953},30.044999996153638]
[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,22.713166662692093,{"$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":61.73030042652001},30.713166662692093]
[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,23.381333329230547,{"$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":61.412049199557487},31.381333329230547]
[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,24.049499995769001,{"$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":61.10589412483408},32.049499995768997]
[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,24.717666662307455,{"$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":60.811043530743881},32.717666662307451]
[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,25.385833328845912,{"$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":60.526777812900875},33.385833328845912]
[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,26.053999995384366,{"$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":60.25244113834907},34.053999995384366]
[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,26.72216666192282,{"$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":59.987434293535081},34.72216666192282]
[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,27.390333328461274,{"$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":59.731208493676576},35.390333328461274]
[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,28.058499994999728,{"$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":59.48326000397347},36.058499994999728]
[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,28.726666661538182,{"$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":59.243125449378596},36.726666661538182]
[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,29.39483332807664,{"$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":59.010377710796909},37.394833328076643]
[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,30.062999994615094,{"$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":58.784622322707961},38.062999994615097]
[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,30.731166661153548,{"$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":58.565494301143744},38.731166661153551]
[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,31.399333327692002,{"$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":58.35265534235355},39.399333327692005]
[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,32.067499994230459,{"$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":58.145791341854071},40.067499994230459]
[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,32.735666660768914,{"$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":57.944610191296277},40.735666660768914]
[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,33.403833327307368,{"$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":57.748839816989722},41.403833327307368]
[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,34.071999993845822,{"$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":57.558226429261872},42.071999993845822]
[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,34.740166660384276,{"$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":57.372532956288786},42.740166660384276]
[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,35.40833332692273,{"$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":57.191537639774744},43.40833332692273]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L75","v":0},{"$f":"Data!M75/Data!N75","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L76","v":0},{"$f":"Data!M76/Data!N76","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L77","v":0},{"$f":"Data!M77/Data!N77","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L78","v":0},{"$f":"Data!M78/Data!N78","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L79","v":0},{"$f":"Data!M79/Data!N79","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L80","v":0},{"$f":"Data!M80/Data!N80","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L81","v":0},{"$f":"Data!M81/Data!N81","v":{"$error":"#N/A"}}]

{"sheet":"CB&P","index":5,"n_rows":108,"n_cols":25,"rows_kept":108,"cut":false,"hidden":true,"merged":[]}
["Cooper, Bredehoeft and Papadopulos (1967)"]
["Well Designation:",null,{"$f":"IF(Data!B1 > 0,Data!B1,\"\")","v":"HMW-44C"},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":"2009-08-12"}]
[]
[null,"Enter early time cut-off for least-squares model fit"]
[null,null,"Timecut (min):",null,12,"<-  Enter or change values here",null,null,null,null,null,null,null,"Count","Time ","H/Ho","G (a,b,e)","SE",null,null,null,null,null,"Time ","H/Ho"]
[null,"Initial Drawdown sn (ft):",null,null,0.115,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.84909039538162434},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.20895891065396949,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U9/Data!V$23^2,0.00001)","v":0.84634470655321548},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.21831913170846798,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U10/Data!V$23^2,0.00001)","v":0.8435139355466722},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Root-Mean-Square Error:",null,null,{"$f":"SQRT(SUM(R8:R48))","v":0.13629403772318835},"<-- 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.22809863968360972,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U11/Data!V$23^2,0.00001)","v":0.84059646374406671},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.23831621634969688,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U12/Data!V$23^2,0.00001)","v":0.83759069307663203},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Trial Tn (ft2/d):",null,null,21.767600128241821,"<-- 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.24899148479804184,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U13/Data!V$23^2,0.00001)","v":0.83449504821820786},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"IF(E9=\"d\",0.025*SQRT(E13),E9)","v":0.11663940191955349},"<-- 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.26014494712756608,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U14/Data!V$23^2,0.00001)","v":0.8313079787071056},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Model Result:",null,"Tn (ft2/d) =",{"$f":"E13","v":21.767600128241821},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.27179802381955342,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U15/Data!V$23^2,0.00001)","v":0.82802796098759601},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,"Tmax",16,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.28397309487617767,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U16/Data!V$23^2,0.00001)","v":0.82465350036381579},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.29669354280181198,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U17/Data!V$23^2,0.00001)","v":0.82118313286070488},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B33>E$6,Data!B33-E$6,0)","v":0},{"$f":"IF(N18>0,Data!J33/'CB&P'!E$7,0)","v":0},{"$f":"IF(N18>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O18/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,10,0.30998379750966742,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U18/Data!V$23^2,0.00001)","v":0.81761542698871092},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,"J-Ratio",null,null,null,0,{"$f":"IF(Data!B34>E$6,Data!B34-E$6,0)","v":0},{"$f":"IF(N19>0,Data!J34/'CB&P'!E$7,0)","v":0},{"$f":"IF(N19>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O19/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,11,0.32386938324000381,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U19/Data!V$23^2,0.00001)","v":0.81394898541133565},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,{"$f":"Figures!U27","v":-0.25742574257425743},null,null,null,0,{"$f":"IF(Data!B35>E$6,Data!B35-E$6,0)","v":0},{"$f":"IF(N20>0,Data!J35/'CB&P'!E$7,0)","v":0},{"$f":"IF(N20>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O20/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,12,0.33837696758002067,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U20/Data!V$23^2,0.00001)","v":0.81018244651714477},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[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":1.6666667768731713E-2},{"$f":"IF(N21>0,Data!J36/'CB&P'!E$7,0)","v":0.95652173913063243},{"$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.91551726880586748},1.6813665866145296E-3,null,13,0.35353441267957331,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U21/Data!V$23^2,0.00001)","v":0.80631448590062083},null,1.6666667768731713E-2,0.95652173913063243]
[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":0.33333333511836827},{"$f":"IF(N22>0,Data!J37/'CB&P'!E$7,0)","v":0.8695652173915811},{"$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.81148515395901488},3.3732937683309157E-3,null,14,0.36937082876107263,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U22/Data!V$23^2,0.00001)","v":0.80234381775913433},null,0.33333333511836827,0.8695652173915811]
[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":0.71666667424142361},{"$f":"IF(N23>0,Data!J38/'CB&P'!E$7,0)","v":0.78260869565203539},{"$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.72900163990539757},2.8737164258231351E-3,null,15,0.38591663002633814,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U23/Data!V$23^2,0.00001)","v":0.7982691962162457},null,0.71666667424142361,0.78260869565203539]
[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":1.1333333335351199},{"$f":"IF(N24>0,Data!J39/'CB&P'!E$7,0)","v":0.69565217391298406},{"$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.66285418123954876},1.075708323406716E-3,null,16,0.40320359306777293,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U24/Data!V$23^2,0.00001)","v":0.7940894165846113},null,1.1333333335351199,0.69565217391298406]
[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":1.8833333307411522},{"$f":"IF(N25>0,Data!J40/'CB&P'!E$7,0)","v":0.60869565217393273},{"$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.57481715250948939},1.1477527395136874E-3,null,17,0.42126491789604104,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U25/Data!V$23^2,0.00001)","v":0.78980331658473291},null,1.8833333307411522,0.60869565217393273]
[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":2.4666666642297059},{"$f":"IF(N26>0,Data!J41/'CB&P'!E$7,0)","v":0.52173913043488152},{"$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.52242980336720668},4.7702909944664168E-7,null,18,0.4401352917014531,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U26/Data!V$23^2,0.00001)","v":0.78540977753873165},null,2.4666666642297059,0.52173913043488152]
[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":3.7499999937135726},{"$f":"IF(N27>0,Data!J42/'CB&P'!E$7,0)","v":0.43478260869583013},{"$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.43555034695904415},{"$f":"N27*(P27-Q27)^2","v":5.8942204080288594E-7},null,19,0.45985095547151367,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U27/Data!V$23^2,0.00001)","v":0.78090772556104382},null,3.7499999937135726,0.43478260869583013]
[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":5.0666666748002172},{"$f":"IF(N28>0,Data!J43/'CB&P'!E$7,0)","v":0.34782608695677875},{"$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.3711703818521524},{"$f":"N28*(P28-Q28)^2","v":5.4495610416216834E-4},null,20,0.48044977359257252,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U28/Data!V$23^2,0.00001)","v":0.77629613277053289},null,5.0666666748002172,0.34782608695677875]
[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":7.1833333333488554},{"$f":"IF(N29>0,Data!J44/'CB&P'!E$7,0)","v":0.26086956521772742},{"$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.29770011616861525},1.3564894833459444E-3,null,21,0.50197130656925104,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U29/Data!V$23^2,0.00001)","v":0.77157401855070407},null,7.1833333333488554,0.26086956521772742]
[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":11.583333324640989},{"$f":"IF(N30>0,Data!J45/'CB&P'!E$7,0)","v":0.17391304347818179},{"$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.20598760511970818},1.028777504496076E-3,null,22,0.52445688700130222,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U30/Data!V$23^2,0.00001)","v":0.76674045088663934},null,11.583333324640989,0.17391304347818179]
[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":15.23333332920447},{"$f":"IF(N31>0,Data!J46/'CB&P'!E$7,0)","v":8.6956521739130432E-2},{"$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.16107087481636148},5.4929373320564672E-3,null,23,0.5479496989638204,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U31/Data!V$23^2,0.00001)","v":0.76179454780871159},null,15.23333332920447,8.6956521739130432E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B47>E$6,Data!B47-E$6,0)","v":0},{"$f":"IF(N32>0,Data!J47/'CB&P'!E$7,0)","v":0},{"$f":"IF(N32>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O32/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,24,0.57249486094325186,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U32/Data!V$23^2,0.00001)","v":0.75673547897414684},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B48>E$6,Data!B48-E$6,0)","v":0},{"$f":"IF(N33>0,Data!J48/'CB&P'!E$7,0)","v":0},{"$f":"IF(N33>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O33/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,25,0.59813951248848818,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U33/Data!V$23^2,0.00001)","v":0.75156246741792399},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B49>E$6,Data!B49-E$6,0)","v":0},{"$f":"IF(N34>0,Data!J49/'CB&P'!E$7,0)","v":0},{"$f":"IF(N34>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O34/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,26,0.6249329047434542,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U34/Data!V$23^2,0.00001)","v":0.74627479150444209},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B50>E$6,Data!B50-E$6,0)","v":0},{"$f":"IF(N35>0,Data!J50/'CB&P'!E$7,0)","v":0},{"$f":"IF(N35>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O35/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,27,0.65292649503506539,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U35/Data!V$23^2,0.00001)","v":0.74087178711061319},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B51>E$6,Data!B51-E$6,0)","v":0},{"$f":"IF(N36>0,Data!J51/'CB&P'!E$7,0)","v":0},{"$f":"IF(N36>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O36/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,28,0.68217404569820816,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U36/Data!V$23^2,0.00001)","v":0.73535285006975992},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B52>E$6,Data!B52-E$6,0)","v":0},{"$f":"IF(N37>0,Data!J52/'CB&P'!E$7,0)","v":0},{"$f":"IF(N37>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O37/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,29,0.71273172732754375,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U37/Data!V$23^2,0.00001)","v":0.72971743890372542},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B53>E$6,Data!B53-E$6,0)","v":0},{"$f":"IF(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,0.74465822665442771,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U38/Data!V$23^2,0.00001)","v":0.72396507786807052},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,0.77801485925612957,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U39/Data!V$23^2,0.00001)","v":0.71809536033211618},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":0.81286568731381104},{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U40/Data!V$23^2,0.00001)","v":0.71210795251192527},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,0.84927764264542038,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U41/Data!V$23^2,0.00001)","v":0.70600259757019923},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,0.88732065524979098,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U42/Data!V$23^2,0.00001)","v":0.6997791200925132},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,0.92706778760881359,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U43/Data!V$23^2,0.00001)","v":0.69343743094443955},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,0.96859537500561588,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U44/Data!V$23^2,0.00001)","v":0.68697753250896176},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.0119831721282329,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U45/Data!V$23^2,0.00001)","v":0.68039952429828021},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.05731450624032,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U46/Data!V$23^2,0.00001)","v":0.67370360892871239},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.1046764372130842,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U47/Data!V$23^2,0.00001)","v":0.66689009844197433},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,1.1541599247257708,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U48/Data!V$23^2,0.00001)","v":0.65995942095083682},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,1.2058600029558222,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U49/Data!V$23^2,0.00001)","v":0.65291205377219075}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,1.2598759630942049,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U50/Data!V$23^2,0.00001)","v":0.64574885212559996}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,1.3163115440364284,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U51/Data!V$23^2,0.00001)","v":0.63847052618380784}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,1.3752751316154834,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U52/Data!V$23^2,0.00001)","v":0.63107804294508507}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,1.4368799667593291,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U53/Data!V$23^2,0.00001)","v":0.62357252169309296}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,1.5012443629727066,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U54/Data!V$23^2,0.00001)","v":0.61595524203655128}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,1.5684919335609453,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U55/Data!V$23^2,0.00001)","v":0.60822765195296558}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,1.6387518290321663,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U56/Data!V$23^2,0.00001)","v":0.6003913757843109}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,1.7121589851338079,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U57/Data!V$23^2,0.00001)","v":0.59244822213029968}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,1.7888543819998315,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U58/Data!V$23^2,0.00001)","v":0.58440019158247647}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,1.8689853149063225,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U59/Data!V$23^2,0.00001)","v":0.57624948423991551}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,1.9527056771554556,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U60/Data!V$23^2,0.00001)","v":0.56799850694489029}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,2.0401762556311294,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U61/Data!V$23^2,0.00001)","v":0.5596503672301224}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,2.1315650395938759,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U62/Data!V$23^2,0.00001)","v":0.5512069294717955}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,2.2270475433081076,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U63/Data!V$23^2,0.00001)","v":0.54267174944889096}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,2.3268071431213047,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U64/Data!V$23^2,0.00001)","v":0.53404812544242652}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,2.4310354296425136,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U65/Data!V$23^2,0.00001)","v":0.52533959214048231}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,2.539932575696521,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U66/Data!V$23^2,0.00001)","v":0.51654992477953177}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,2.6537077207603796,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U67/Data!V$23^2,0.00001)","v":0.50768314251950164}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,2.772579372620585,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U68/Data!V$23^2,0.00001)","v":0.49874351097865305}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,2.8967758270223185,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U69/Data!V$23^2,0.00001)","v":0.48973554385438611}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,3.026535606116675,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U70/Data!V$23^2,0.00001)","v":0.48066400355659367}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,3.1621079165479573,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U71/Data!V$23^2,0.00001)","v":0.47153390078121138}]
[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":3.3037531280607713},{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U72/Data!V$23^2,0.00001)","v":0.46235049295329433}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,3.4517432735461138,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U73/Data!V$23^2,0.00001)","v":0.45311928147125796}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,3.6063625714868115,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U74/Data!V$23^2,0.00001)","v":0.44384600768701532}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,3.7679079718056618,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U75/Data!V$23^2,0.00001)","v":0.43453664756064136}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68,3.9366897261645919,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U76/Data!V$23^2,0.00001)","v":0.42519740493302105}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69,4.1130319838101315,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U77/Data!V$23^2,0.00001)","v":0.41583470336568368}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,4.297273414109501,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U78/Data!V$23^2,0.00001)","v":0.40645517650386342}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,71,4.4897678569729269,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U79/Data!V$23^2,0.00001)","v":0.39706565692667667}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72,4.6908850024113473,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U80/Data!V$23^2,0.00001)","v":0.38767316345733938}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73,4.9010111005345935,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U81/Data!V$23^2,0.00001)","v":0.37828488691646472}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74,5.1205497033536025,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U82/Data!V$23^2,0.00001)","v":0.36890817431279893}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,5.3499224398113752,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U83/Data!V$23^2,0.00001)","v":0.35955051147815609}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,76,5.5895698255310586,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U84/Data!V$23^2,0.00001)","v":0.35021473226259725}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,77,5.8399521088363393,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U85/Data!V$23^2,0.00001)","v":0.34092285765451885}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78,6.1015501546689643,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U86/Data!V$23^2,0.00001)","v":0.33166835488659746}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79,6.3748663681009301,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U87/Data!V$23^2,0.00001)","v":0.32246380412158726}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,6.660425659214984,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U88/Data!V$23^2,0.00001)","v":0.31331714366719482}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81,6.9587764512065453,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U89/Data!V$23^2,0.00001)","v":0.3042361976733382}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82,7.2704917336430777,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U90/Data!V$23^2,0.00001)","v":0.29522881711147769}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,83,7.5961701629037375,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U91/Data!V$23^2,0.00001)","v":0.28630280172797334}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,84,7.9364372119127511,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U92/Data!V$23^2,0.00001)","v":0.27746587179581267}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,85,8.2919463713745731,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U93/Data!V$23^2,0.00001)","v":0.26872563915725839}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,86,8.6633804048178273,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U94/Data!V$23^2,0.00001)","v":0.26008957777347586}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,87,9.0514526598583895,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U95/Data!V$23^2,0.00001)","v":0.25156499400659593}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,88,9.4569084381999229,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U96/Data!V$23^2,0.00001)","v":0.2431589968684903}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,89,9.8805264270029358,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U97/Data!V$23^2,0.00001)","v":0.23487846847856308}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,10.32312019437145,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U98/Data!V$23^2,0.00001)","v":0.22673003497971572}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,91,10.785539751829265,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U99/Data!V$23^2,0.00001)","v":0.218720038166936}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,92,11.268673186786636,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U100/Data!V$23^2,0.00001)","v":0.21085450808618367}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,93,11.773448368132646,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U101/Data!V$23^2,0.00001)","v":0.20313913686197549}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94,12.300834728228759,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U102/Data!V$23^2,0.00001)","v":0.19557925400988554}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95,12.851845124725987,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U103/Data!V$23^2,0.00001)","v":0.18817980348471103}]
[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":13.42753778578135},{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U104/Data!V$23^2,0.00001)","v":0.18094509973293127}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97,14.029018342409417,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U105/Data!V$23^2,0.00001)","v":0.17387971486203893}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98,14.657441951872149,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U106/Data!V$23^2,0.00001)","v":0.16698708295793457}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99,15.314015516184979,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U107/Data!V$23^2,0.00001)","v":0.1602704191245127}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,15.999999999999991,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U108/Data!V$23^2,0.00001)","v":0.15373247211848023}]

{"sheet":"B&R Type Curve","index":6,"n_rows":56,"n_cols":30,"rows_kept":56,"cut":false,"hidden":true,"merged":[[4,3,4,4]]}
["Bouwer and Rice Short Term LNAPL Mobility Test Type Curves"]
[{"$f":"CONCATENATE(\"B&R Type Curves:  Casing Rad. (ft) = \",Data!B6,\" ;  Borehole Rad. (ft) = \",Data!B7)","v":"B&R Type Curves:  Casing Rad. (ft) = 0.083 ;  Borehole Rad. (ft) = 0.354"}]
[]
[]
[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.25742574257425743},"<--  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.23599999999999999},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.70719852699834584},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.79376917862745067},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.91175403221109819},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.95485812150868687},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.97716842023710881},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.99080404117058818},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.99539140099288992}]
[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.50012975658863013},null,13.333333333333334,{"$f":"EXP(-(2*O$9*(N14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.63006950893889779},null,13.333333333333334,{"$f":"EXP(-(2*R$9*(Q14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.83129541525319617},null,13.333333333333334,{"$f":"EXP(-(2*U$9*(T14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.91175403221109819},null,13.333333333333334,{"$f":"EXP(-(2*X$9*(W14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.95485812150868687},null,13.333333333333334,{"$f":"EXP(-(2*AA$9*(Z14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.98169264799996869},null,13.333333333333334,{"$f":"EXP(-(2*AD$9*(AC14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.99080404117058818}]
[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.35369102716752049},null,20,{"$f":"EXP(-(2*O$9*(N15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.50012975658863013},null,20,{"$f":"EXP(-(2*R$9*(Q15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.7579369468157009},null,20,{"$f":"EXP(-(2*U$9*(T15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.87059574247506},null,20,{"$f":"EXP(-(2*X$9*(W15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.93305720214521681},null,20,{"$f":"EXP(-(2*AA$9*(Z15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.97266504282582478},null,20,{"$f":"EXP(-(2*AD$9*(AC15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.98623782265020887}]
[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.25012977342540244},null,26.666666666666668,{"$f":"EXP(-(2*O$9*(N16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.39698758609450374},null,26.666666666666668,{"$f":"EXP(-(2*R$9*(Q16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.69105206742098391},null,26.666666666666668,{"$f":"EXP(-(2*U$9*(T16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.83129541525319617},null,26.666666666666668,{"$f":"EXP(-(2*X$9*(W16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.91175403221109819},null,26.666666666666668,{"$f":"EXP(-(2*AA$9*(Z16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.9637204551371904},null,26.666666666666668,{"$f":"EXP(-(2*AD$9*(AC16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.98169264799996869}]
[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.17689140732487457},null,33.333333333333336,{"$f":"EXP(-(2*O$9*(N17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.31511651013952857},null,33.333333333333336,{"$f":"EXP(-(2*R$9*(Q17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.63006950893889779},null,33.333333333333336,{"$f":"EXP(-(2*U$9*(T17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.79376917862745067},null,33.333333333333336,{"$f":"EXP(-(2*X$9*(W17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.89093724730053281},null,33.333333333333336,{"$f":"EXP(-(2*AA$9*(Z17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.95485812150868687},null,33.333333333333336,{"$f":"EXP(-(2*AD$9*(AC17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.97716842023710881}]
[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.12509734269881573},null,40,{"$f":"EXP(-(2*O$9*(N18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.25012977342540244},null,40,{"$f":"EXP(-(2*R$9*(Q18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.57446841534830662},null,40,{"$f":"EXP(-(2*U$9*(T18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.7579369468157009},null,40,{"$f":"EXP(-(2*X$9*(W18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.87059574247506},null,40,{"$f":"EXP(-(2*AA$9*(Z18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.94607728553536352},null,40,{"$f":"EXP(-(2*AD$9*(AC18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.97266504282582478}]
[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":8.846865648800975E-2},null,46.666666666666664,{"$f":"EXP(-(2*O$9*(N19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.19854530480215202},null,46.666666666666664,{"$f":"EXP(-(2*R$9*(Q19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.52377389407173847},null,46.666666666666664,{"$f":"EXP(-(2*U$9*(T19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.72372224925846962},null,46.666666666666664,{"$f":"EXP(-(2*X$9*(W19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.8507186663395071},null,46.666666666666664,{"$f":"EXP(-(2*AA$9*(Z19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.93737719776813866},null,46.666666666666664,{"$f":"EXP(-(2*AD$9*(AC19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.96818241967520702}]
[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":6.2564903553843143E-2},null,53.333333333333329,{"$f":"EXP(-(2*O$9*(N20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.15759914351314108},null,53.333333333333329,{"$f":"EXP(-(2*R$9*(Q20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.47755295988681612},null,53.333333333333329,{"$f":"EXP(-(2*U$9*(T20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.69105206742098391},null,53.333333333333329,{"$f":"EXP(-(2*X$9*(W20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.83129541525319617},null,53.333333333333329,{"$f":"EXP(-(2*AA$9*(Z20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.92875711564983343},null,53.333333333333329,{"$f":"EXP(-(2*AD$9*(AC20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.9637204551371904}]
[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":4.4245807635071445E-2},null,59.999999999999993,{"$f":"EXP(-(2*O$9*(N21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.12509734269881573},null,59.999999999999993,{"$f":"EXP(-(2*R$9*(Q21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.43541083677114945},null,59.999999999999993,{"$f":"EXP(-(2*U$9*(T21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.65985667896229516},null,59.999999999999993,{"$f":"EXP(-(2*X$9*(W21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.81231562767331711},null,59.999999999999993,{"$f":"EXP(-(2*AA$9*(Z21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.92021630345179439},null,59.999999999999993,{"$f":"EXP(-(2*AD$9*(AC21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.95927905400451352}]
[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":3.1290569985374689E-2},null,66.666666666666657,{"$f":"EXP(-(2*O$9*(N22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":9.9298414962515749E-2},null,66.666666666666657,{"$f":"EXP(-(2*R$9*(Q22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.39698758609450391},null,66.666666666666657,{"$f":"EXP(-(2*U$9*(T22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.6300695089388979},null,66.666666666666657,{"$f":"EXP(-(2*X$9*(W22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.79376917862745078},null,66.666666666666657,{"$f":"EXP(-(2*AA$9*(Z22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.91175403221109819},null,66.666666666666657,{"$f":"EXP(-(2*AD$9*(AC22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.95485812150868687}]
[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":2.2128645002595631E-2},null,73.333333333333329,{"$f":"EXP(-(2*O$9*(N23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":7.8820021283803832E-2},null,73.333333333333329,{"$f":"EXP(-(2*R$9*(Q23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.36195503235941434},null,73.333333333333329,{"$f":"EXP(-(2*U$9*(T23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.60162698772529677},null,73.333333333333329,{"$f":"EXP(-(2*X$9*(W23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.77564617431229343},null,73.333333333333329,{"$f":"EXP(-(2*AA$9*(Z23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.90336957966833475},null,73.333333333333329,{"$f":"EXP(-(2*AD$9*(AC23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.95045756331797093}]
[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":1.5649345150304944E-2},null,80,{"$f":"EXP(-(2*O$9*(N24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":6.2564903553843143E-2},null,80,{"$f":"EXP(-(2*R$9*(Q24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.33001396023279456},null,80,{"$f":"EXP(-(2*U$9*(T24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.57446841534830662},null,80,{"$f":"EXP(-(2*X$9*(W24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.7579369468157009},null,80,{"$f":"EXP(-(2*AA$9*(Z24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.89506223020596165},null,80,{"$f":"EXP(-(2*AD$9*(AC24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.94607728553536352}]
[null,null,null,null,null,null,null,null,null,null,65,{"$f":"EXP(-(2*L$9*(K25/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":1.1067193838784357E-2},null,86.666666666666671,{"$f":"EXP(-(2*O$9*(N25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":4.9662092104839739E-2},null,86.666666666666671,{"$f":"EXP(-(2*R$9*(Q25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.30089155892820335},null,86.666666666666671,{"$f":"EXP(-(2*U$9*(T25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.54853583194555611},null,86.666666666666671,{"$f":"EXP(-(2*X$9*(W25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.74063204895923596},null,86.666666666666671,{"$f":"EXP(-(2*AA$9*(Z25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.88683127478722612},null,86.666666666666671,{"$f":"EXP(-(2*AD$9*(AC25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.94171719469659587}]
[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":7.8267031807934696E-3},null,93.333333333333343,{"$f":"EXP(-(2*O$9*(N26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":3.9420238058979422E-2},null,93.333333333333343,{"$f":"EXP(-(2*R$9*(Q26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.27433909211107266},null,93.333333333333343,{"$f":"EXP(-(2*U$9*(T26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.52377389407173847},null,93.333333333333343,{"$f":"EXP(-(2*X$9*(W26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.72372224925846962},null,93.333333333333343,{"$f":"EXP(-(2*AA$9*(Z26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.87867601089564806},null,93.333333333333343,{"$f":"EXP(-(2*AD$9*(AC26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.93737719776813866}]
[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":5.5350329607104023E-3},null,100.00000000000001,{"$f":"EXP(-(2*O$9*(N27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":3.1290569985374689E-2},null,100.00000000000001,{"$f":"EXP(-(2*R$9*(Q27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.25012977342540244},null,100.00000000000001,{"$f":"EXP(-(2*U$9*(T27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.50012975658863013},null,100.00000000000001,{"$f":"EXP(-(2*X$9*(W27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.70719852699834584},null,100.00000000000001,{"$f":"EXP(-(2*AA$9*(Z27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.87059574247505989},null,100.00000000000001,{"$f":"EXP(-(2*AD$9*(AC27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.93305720214521681}]
[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":3.9143671567016943E-3},null,106.66666666666669,{"$f":"EXP(-(2*O$9*(N28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":2.4837490036075625E-2},null,106.66666666666669,{"$f":"EXP(-(2*R$9*(Q28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.22805682949665895},null,106.66666666666669,{"$f":"EXP(-(2*U$9*(T28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.47755295988681606},null,106.66666666666669,{"$f":"EXP(-(2*X$9*(W28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.69105206742098391},null,106.66666666666669,{"$f":"EXP(-(2*AA$9*(Z28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.86258977987019814},null,106.66666666666669,{"$f":"EXP(-(2*AD$9*(AC28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.92875711564983343}]
[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":2.7682346873501404E-3},null,113.33333333333336,{"$f":"EXP(-(2*O$9*(N29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.9715234065103227E-2},null,113.33333333333336,{"$f":"EXP(-(2*R$9*(Q29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.20793173386685768},null,113.33333333333336,{"$f":"EXP(-(2*U$9*(T29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.45599532219843841},null,113.33333333333336,{"$f":"EXP(-(2*X$9*(W29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.67527425702335075},null,113.33333333333336,{"$f":"EXP(-(2*AA$9*(Z29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.85465743976784037},null,113.33333333333336,{"$f":"EXP(-(2*AD$9*(AC29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.92447684652880324}]
[null,null,null,null,null,null,null,null,null,null,90,{"$f":"EXP(-(2*L$9*(K30/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":1.9576914932797466E-3},null,120.00000000000003,{"$f":"EXP(-(2*O$9*(N30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.5649345150304916E-2},null,120.00000000000003,{"$f":"EXP(-(2*R$9*(Q30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.18958259677775244},null,120.00000000000003,{"$f":"EXP(-(2*U$9*(T30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.43541083677114933},null,120.00000000000003,{"$f":"EXP(-(2*X$9*(W30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.65985667896229505},null,120.00000000000003,{"$f":"EXP(-(2*AA$9*(Z30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.84679804513848478},null,120.00000000000003,{"$f":"EXP(-(2*AD$9*(AC30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.92021630345179428}]
[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":1.384476540364628E-3},null,126.6666666666667,{"$f":"EXP(-(2*O$9*(N31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.2421967846015004E-2},null,126.6666666666667,{"$f":"EXP(-(2*R$9*(Q31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.17285269704916653},null,126.6666666666667,{"$f":"EXP(-(2*U$9*(T31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.4157555736838251},null,126.6666666666667,{"$f":"EXP(-(2*X$9*(W31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.64479110856449096},null,126.6666666666667,{"$f":"EXP(-(2*AA$9*(Z31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.8390109251785649},null,126.6666666666667,{"$f":"EXP(-(2*AD$9*(AC31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.9159753955093799}]
[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":9.7909977000963135E-4},null,133.33333333333337,{"$f":"EXP(-(2*O$9*(N32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":9.8601752140679445E-3},null,133.33333333333337,{"$f":"EXP(-(2*R$9*(Q32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.157599143513141},null,133.33333333333337,{"$f":"EXP(-(2*U$9*(T32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.39698758609450374},null,133.33333333333337,{"$f":"EXP(-(2*X$9*(W32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.63006950893889768},null,133.33333333333337,{"$f":"EXP(-(2*AA$9*(Z32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.83129541525319617},null,133.33333333333337,{"$f":"EXP(-(2*AD$9*(AC32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.91175403221109819}]
[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":6.924179151352295E-4},null,140.00000000000003,{"$f":"EXP(-(2*O$9*(N33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":7.8267031807934626E-3},null,140.00000000000003,{"$f":"EXP(-(2*R$9*(Q33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.14369165457112182},null,140.00000000000003,{"$f":"EXP(-(2*U$9*(T33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.37906682072046588},null,140.00000000000003,{"$f":"EXP(-(2*X$9*(W33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.61568402668939359},null,140.00000000000003,{"$f":"EXP(-(2*AA$9*(Z33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.82365085683944905},null,140.00000000000003,{"$f":"EXP(-(2*AD$9*(AC33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.90755212348352154}]
[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":4.8967692965090051E-4},null,146.66666666666669,{"$f":"EXP(-(2*O$9*(N34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":6.2125957551792789E-3},null,146.66666666666669,{"$f":"EXP(-(2*R$9*(Q34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.1310114454503046},null,146.66666666666669,{"$f":"EXP(-(2*U$9*(T34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.36195503235941423},null,146.66666666666669,{"$f":"EXP(-(2*X$9*(W34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.60162698772529666},null,146.66666666666669,{"$f":"EXP(-(2*AA$9*(Z34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.81607659747014372},null,146.66666666666669,{"$f":"EXP(-(2*AD$9*(AC34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.90336957966833475}]
[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":3.4629880335418996E-4},null,153.33333333333334,{"$f":"EXP(-(2*O$9*(N35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":4.9313670297330484E-3},null,153.33333333333334,{"$f":"EXP(-(2*R$9*(Q35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.11945021365511962},null,153.33333333333334,{"$f":"EXP(-(2*U$9*(T35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.34561570226932636},null,153.33333333333334,{"$f":"EXP(-(2*X$9*(W35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.58789089316753862},null,153.33333333333334,{"$f":"EXP(-(2*AA$9*(Z35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.80857199067816188},null,153.33333333333334,{"$f":"EXP(-(2*AD$9*(AC35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.89920631152042174}]
[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":2.4490200363337287E-4},null,160,{"$f":"EXP(-(2*O$9*(N36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":3.9143671567016943E-3},null,160,{"$f":"EXP(-(2*R$9*(Q36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.10890921394853251},null,160,{"$f":"EXP(-(2*U$9*(T36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.33001396023279456},null,160,{"$f":"EXP(-(2*X$9*(W36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.57446841534830662},null,160,{"$f":"EXP(-(2*AA$9*(Z36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.80113639594126995},null,160,{"$f":"EXP(-(2*AD$9*(AC36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.89506223020596165}]
[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":1.7319433622846474E-4},null,166.66666666666666,{"$f":"EXP(-(2*O$9*(N37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":3.1071040028213775E-3},null,166.66666666666666,{"$f":"EXP(-(2*R$9*(Q37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":9.9298414962515652E-2},null,166.66666666666666,{"$f":"EXP(-(2*U$9*(T37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.31511651013952863},null,166.66666666666666,{"$f":"EXP(-(2*X$9*(W37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.56135239390201996},null,166.66666666666666,{"$f":"EXP(-(2*AA$9*(Z37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.79376917862745078},null,166.66666666666666,{"$f":"EXP(-(2*AD$9*(AC37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.89093724730053281}]
[null,null,null,null,null,null,null,null,null,null,130,{"$f":"EXP(-(2*L$9*(K38/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":1.2248277946522645E-4},null,173.33333333333331,{"$f":"EXP(-(2*O$9*(N38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":2.4663233922295855E-3},null,173.33333333333331,{"$f":"EXP(-(2*R$9*(Q38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":9.0535730234244507E-2},null,173.33333333333331,{"$f":"EXP(-(2*U$9*(T38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.30089155892820341},null,173.33333333333331,{"$f":"EXP(-(2*X$9*(W38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.54853583194555611},null,173.33333333333331,{"$f":"EXP(-(2*AA$9*(Z38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.78646970994073673},null,173.33333333333331,{"$f":"EXP(-(2*AD$9*(AC38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.88683127478722623}]
[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":8.6619641220471501E-5},null,179.99999999999997,{"$f":"EXP(-(2*O$9*(N39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.9576914932797483E-3},null,179.99999999999997,{"$f":"EXP(-(2*R$9*(Q39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":8.2546317100248706E-2},null,179.99999999999997,{"$f":"EXP(-(2*U$9*(T39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.2873087487360047},null,179.99999999999997,{"$f":"EXP(-(2*X$9*(W39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.53601189234568736},null,179.99999999999997,{"$f":"EXP(-(2*AA$9*(Z39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.7792373668675423},null,179.99999999999997,{"$f":"EXP(-(2*AD$9*(AC39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.88274422505476768}]
[null,null,null,null,null,null,null,null,null,null,140,{"$f":"EXP(-(2*L$9*(K40/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":6.1257282680242617E-5},null,186.66666666666663,{"$f":"EXP(-(2*O$9*(N40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.5539551686266149E-3},null,186.66666666666663,{"$f":"EXP(-(2*R$9*(Q40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":7.526193746032768E-2},null,186.66666666666663,{"$f":"EXP(-(2*U$9*(T40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.27433909211107282},null,186.66666666666663,{"$f":"EXP(-(2*X$9*(W40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.52377389407173858},null,186.66666666666663,{"$f":"EXP(-(2*AA$9*(Z40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.77207153212348911},null,186.66666666666663,{"$f":"EXP(-(2*AD$9*(AC40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.87867601089564806}]
[null,null,null,null,null,null,null,null,null,null,145,{"$f":"EXP(-(2*L$9*(K41/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":4.3321060079388839E-5},null,193.33333333333329,{"$f":"EXP(-(2*O$9*(N41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":1.2334817178246301E-3},null,193.33333333333329,{"$f":"EXP(-(2*R$9*(Q41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":6.8620374951473273E-2},null,193.33333333333329,{"$f":"EXP(-(2*U$9*(T41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.26195491014957761},null,193.33333333333329,{"$f":"EXP(-(2*X$9*(W41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.51181530863151958},null,193.33333333333329,{"$f":"EXP(-(2*AA$9*(Z41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.76497159410072069},null,193.33333333333329,{"$f":"EXP(-(2*AD$9*(AC41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.874626545504263}]
[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":3.0636589876150559E-5},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":9.7909977000963135E-4},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":6.2564903553843143E-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.25012977342540244},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.50012975658863013},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.7579369468157009},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.87059574247505989}]
[]
[]
[]
[]
[]
[]
["Field Data"]
[]
["Record Data in Fields Below",null,null,null,null,null,"Calculate and Plot Fields Below"]
["Well ID",null,"Well Dia. (ft)",null,"Total Depth (ft)"]
["Notes","Date","Time","Elapsed Time (min)","Depth To Product (TOC)","Depth to Water (TOC)","Product Thickness (ft)","Drawdown (s) DTP-DTP(initial) (ft)","Normalized Drawdown (s/sinitial)"]
["Initial Measurement"]
["Stopped Bailing/Start Gauging",null,null,0]
["Well Starts recovering"]

{"sheet":"Confined","index":7,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Confined LNAPL Model:",null,null,null,"Well Designation:",null,{"$f":"IF(Data!B1 > 0,Data!B1,\"\")","v":"HMW-44C"}]
[null,null,null,null,"Date:",null,{"$f":"IF(Data!B2 > 0,Data!B2,\"\")","v":"2009-08-12"}]
[]
[]
["Depth to base of confining bed (ft bgs) [from boring log]:",29.35]
["Constant LNAPL discharge to well (ft3/d):",8]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!N24","v":0.24500000000001365},{"$f":"B6","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"B14","v":9.2670157068072731E-2},{"$f":"M9","v":8}]
["Depth to top of screen (ft bgs):",{"$f":"Data!B10","v":27.2},null,null,null,null,null,null,null,null,null,0,0]
["Corrected water table elevation (ft bgs):",{"$f":"Data!I21","v":28.037960000000023}]
["Limiting effective LNAPL thickness in well, bnW (ft):",{"$f":"IF(B5>B11,(B5-B12)/Data!B9,(B11-B12)/Data!B9)","v":1.7173298429319088}]
["Limiting effective LNAPL drawdown, snW (ft):",{"$f":"(1-Data!B9)*(Confined!B15-Confined!B13)","v":9.2670157068072731E-2}]
["Initial LNAPL thickness, bnR (ft):",{"$f":"Data!O21","v":2.1100000000000136}]
["Radius of influence ratio (from Bouwer and Rice), R/rw:",{"$f":"'B&R'!J12","v":6.4796452758132288}]
[]
[]
["LNAPL Transmissivity, Tn (ft2/d):",{"$f":"B6*LN(B16)/(2*PI()*(1-Data!B9)*(B15-B13))","v":25.674491403951937}]

{"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":"HMW-44C"}]
[null,null,null,null,"Date:",null,{"$f":"IF(Data!B2 > 0,Data!B2,\"\")","v":"2009-08-12"}]
[]
[]
["Depth to top of perching layer, DZ12 (ft bgs):",37.5]
["Constant LNAPL discharge to well (ft3/d):",0.4]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!N24","v":0.24500000000001365},{"$f":"B6","v":0.4}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"B13","v":9.9599999999999795},{"$f":"M9","v":0.4}]
["Depth to top of screen (ft bgs):",{"$f":"Data!B10","v":27.2},null,null,null,null,null,null,null,null,null,0,0]
["Corrected water table elevation (ft bgs):",{"$f":"Data!I21","v":28.037960000000023}]
["Limiting effective LNAPL drawdown, snW (ft):",{"$f":"B5-B14","v":9.9599999999999795}]
["Initial depth to product (DTP0) (ft bgs):",{"$f":"Data!E21","v":27.54000000000002}]
["Radius of influence ratio (from Bouwer and Rice), R/rw:",{"$f":"'B&R'!J12","v":6.4796452758132288}]
[]
[]
["LNAPL Transmissivity, Tn (ft2/d):",{"$f":"B6*LN(B15)/(2*PI()*B13)","v":1.1944072043409209E-2}]

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