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

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

{"sheet":"Data","index":1,"n_rows":83,"n_cols":22,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
["Well Designation:","YYY","Beckett and Lyverse (2002)"]
["Date:","date"," "," "]
[]
["Ground Surface Elev (m msl)",0,"Enter These Data",null,"Drawdown"]
["Top of Casing Elev (m msl)",0,null,null,"Adjustment"]
["Well Casing Radius, rc (m):",5.1999999999999998E-2,"re1",null,"(m)"]
["Well Radius, rw (m):",0.152,null,null,{"$f":"Figures!C28","v":2.5000000000000001E-2}]
["LNAPL Specific Yield, Sy:",0.17499999999999999]
["LNAPL Density Ratio, rr:",0.78]
["Top of Screen (m bgs):",0]
["Bottom of Screen (m bgs):",0]
["LNAPL Baildown Vol. (liter):"," "]
["Effective Radius, re3 (m):",{"$f":"SQRT(B8*(B7^2-B6^2)+B6^2)","v":7.9208585393251402E-2},"Calculated Parameters"]
["Effective Radius, re2 (m):",{"$f":"SQRT(-Figures!U27*B6^2+(Figures!U27+1)*B13^2)","v":7.4846509604656913E-2}]
["Initial Casing LNAPL Vol. (liter):",{"$f":"PI()*B6^2*(F21-E21)*1000","v":8.0021642762590055}]
["Initial Filter LNAPL Vol. (liter):",{"$f":"IF(E21<B10,PI()*(B7^2-B6^2)*B8*(F21-B10)*1000,PI()*(B7^2-B6^2)*B8*(F21-E21)*1000)","v":10.564987598463262}]
[]
[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 (m btoc)","DTW (m btoc)","DTP (m bgs)","DTW (m bgs)",null,null,"(m)","sn (m)",null,"Time (min)","Qn (m3/d)","(m)","(m)","(m)",null,null,"(m bgs)","(m bgs)","(liters)","(m)"]
["Initial Fluid Levels:",0,6.7960000000000003,7.7380000000000004,{"$f":"C21+B4-B5","v":6.7960000000000003},{"$f":"D21+B4-B5","v":7.7380000000000004},null,null,{"$f":"E21+(1-B$9)*(F21-E21)","v":7.0032399999999999},null,null,null,null,null,{"$f":"F21-E21","v":0.94200000000000017}]
[]
["Enter Test Data:",1,6.9509999999999996,7.1040000000000001,{"$f":"IF(B23>=0,C23+B$4-B$5,NA())","v":6.9509999999999996},{"$f":"IF(B23>=0,D23+B$4-B$5,NA())","v":7.1040000000000001},null,null,{"$f":"E23+(1-B$9)*(F23-E23)","v":6.9846599999999999},{"$f":"E23-E$21-E$7","v":0.12999999999999937},null,null,null,null,{"$f":"F23-E23","v":0.15300000000000047},null,null,null,null,null,0,{"$f":"MAX(V24:V81)/(MAX(L24:L81)-L24)","v":7.9208585393251388E-2}]
[null,1.5,6.9480000000000004,7.1280000000000001,{"$f":"IF(B24>0,C24+B$4-B$5,NA())","v":6.9480000000000004},{"$f":"IF(B24>0,D24+B$4-B$5,NA())","v":7.1280000000000001},null,null,{"$f":"E24+(1-B$9)*(F24-E24)","v":6.9876000000000005},0.12700000000000014,null,{"$f":"IF(B24>0,0.5*(B23+B24),0)","v":1.25},{"$f":"IF(B24>0,1440*PI()*P24^2*(E23-E24+F24-F23)/(B24-B23),NA())","v":1.5326769955184318},{"$f":"0.5*(J23+J24)","v":0.12849999999999975},{"$f":"F24-E24","v":0.17999999999999972},{"$f":"IF(B24>0,re(B$10,E24,F24,B$6,B$14,B$13), )","v":7.9208585393251402E-2},null,null,{"$f":"(E23+E24)/2","v":6.9495000000000005},{"$f":"(F23+F24)/2","v":7.1159999999999997},{"$f":"U23+M24*(B24-B23)*1000/1440","v":0.53217951233278882},0]
[null,2,6.9329999999999998,7.1369999999999996,6.9329999999999998,7.1369999999999996,null,null,6.9778799999999999,0.11199999999999957,null,{"$f":"IF(B25>0,0.5*(B24+B25),0)","v":1.75},{"$f":"IF(B25>0,1440*PI()*P25^2*(E24-E25+F25-F24)/(B25-B24),NA())","v":1.3623795515719788},{"$f":"0.5*(J24+J25)","v":0.11949999999999986},{"$f":"F25-E25","v":0.20399999999999974},{"$f":"IF(B25>0,re(B$10,E25,F25,B$6,B$14,B$13), )","v":7.9208585393251402E-2},null,null,{"$f":"(E24+E25)/2","v":6.9405000000000001},7.1325000000000003,{"$f":"U24+M25*(B25-B24)*1000/1440","v":1.0052279677397258},{"$f":"IF(P25>0,V24+0.5*(P24+P25)*(L25-L24),0)","v":3.9604292696625701E-2}]
[null,3,6.93,7.165,6.93,7.165,null,null,6.9817,0.10899999999999946,null,2.5,0.87987012705691869,0.11049999999999952,0.23500000000000032,{"$f":"IF(B26>0,re(B$10,E26,F26,B$6,B$14,B$13), )","v":7.9208585393251402E-2},null,null,6.9314999999999998,7.1509999999999998,1.6162488893070304,{"$f":"IF(P26>0,V25+0.5*(P25+P26)*(L26-L25),0)","v":9.9010731741564245E-2}]
[null,4,6.9269999999999996,7.1769999999999996,6.9269999999999996,7.1769999999999996,null,null,6.9819999999999993,0.10599999999999934,null,3.5,0.42574360986623389,0.1074999999999994,0.25,{"$f":"IF(B27>0,re(B$10,E27,F27,B$6,B$14,B$13), )","v":7.9208585393251402E-2},null,null,6.9284999999999997,7.1709999999999994,1.9119041739363594,0.17821931713481565]
[null,5,6.9269999999999996,7.1920000000000002,6.9269999999999996,7.1920000000000002,null,null,6.9852999999999996,0.10599999999999934,null,4.5,0.42574360986625909,0.10599999999999934,0.26500000000000057,{"$f":"IF(B28>0,re(B$10,E28,F28,B$6,B$14,B$13), )","v":7.9208585393251402E-2},null,null,6.9269999999999996,7.1844999999999999,2.2075594585657061,0.25742790252806702]
[null,7.5,6.9180000000000001,7.2130000000000001,6.9180000000000001,7.2130000000000001,null,null,6.9828999999999999,9.6999999999999892E-2,null,6.25,0.34059488789298709,0.10149999999999962,0.29499999999999993,{"$f":"IF(B29>0,re(B$10,E29,F29,B$6,B$14,B$13), )","v":7.9208585393251402E-2},null,null,6.9224999999999994,7.2025000000000006,2.7988700278243641,0.39604292696625698]
[null,12,6.9119999999999999,7.2839999999999998,6.9119999999999999,7.2839999999999998,null,null,6.9938399999999996,9.0999999999999664E-2,null,9.75,0.4856630808844547,9.3999999999999778E-2,0.37199999999999989,{"$f":"IF(B30>0,re(B$10,E30,F30,B$6,B$14,B$13), )","v":7.9208585393251402E-2},null,null,6.915,7.2484999999999999,4.3165671555882854,0.6732729758426369]
[null,15,6.9119999999999999,7.2869999999999999,6.9119999999999999,7.2869999999999999,null,null,6.9944999999999995,9.0999999999999664E-2,null,13.5,2.8382907324417273E-2,9.0999999999999664E-2,0.375,{"$f":"IF(B31>0,re(B$10,E31,F31,B$6,B$14,B$13), )","v":7.9208585393251402E-2},null,null,6.9119999999999999,7.2854999999999999,4.3756982125141546,0.97030517106732961]
[null,20,6.9020000000000001,7.3109999999999999,6.9020000000000001,7.3109999999999999,null,null,6.9919799999999999,8.0999999999999878E-2,null,17.5,0.19300376980602907,8.5999999999999771E-2,0.40899999999999981,{"$f":"IF(B32>0,re(B$10,E32,F32,B$6,B$14,B$13), )","v":7.9208585393251402E-2},null,null,6.907,7.2989999999999995,5.045850191007311,1.2871395126403353]
[null,25,6.8959999999999999,7.3289999999999997,6.8959999999999999,7.3289999999999997,null,null,6.9912599999999996,7.499999999999965E-2,null,22.5,0.13623795515719789,7.7999999999999764E-2,0.43299999999999983,{"$f":"IF(B33>0,re(B$10,E33,F33,B$6,B$14,B$13), )","v":7.9208585393251402E-2},null,null,6.899,7.32,5.5188986464142484,1.6831824396065924]
[null,30,6.8929999999999998,7.3380000000000001,6.8929999999999998,7.3380000000000001,null,null,6.9908999999999999,7.1999999999999537E-2,null,27.5,6.8118977578601456E-2,7.3499999999999593E-2,0.44500000000000028,{"$f":"IF(B34>0,re(B$10,E34,F34,B$6,B$14,B$13), )","v":7.9208585393251402E-2},null,null,6.8944999999999999,7.3334999999999999,5.755422874117726,2.0792253665728495]
[null,40,6.89,7.3630000000000004,6.89,7.3630000000000004,null,null,6.9940600000000002,6.8999999999999423E-2,null,35,7.9472140508366679E-2,7.049999999999948E-2,0.47300000000000075,{"$f":"IF(B35>0,re(B$10,E35,F35,B$6,B$14,B$13), )","v":7.9208585393251402E-2},null,null,6.8914999999999997,7.3505000000000003,6.307312738759161,2.6732897570222351]
[null,52,6.8840000000000003,7.3840000000000003,6.8840000000000003,7.3840000000000003,null,null,6.9940000000000007,6.3000000000000084E-2,null,46,6.3861541479934655E-2,6.5999999999999753E-2,0.5,{"$f":"IF(B36>0,re(B$10,E36,F36,B$6,B$14,B$13), )","v":7.9208585393251402E-2},null,null,6.8870000000000005,7.3734999999999999,6.8394922510919498,3.5445841963480005]
[null,70,6.875,7.4119999999999999,6.875,7.4119999999999999,null,null,6.9931400000000004,5.3999999999999736E-2,null,61,5.8342642833522057E-2,5.8499999999999913E-2,0.53699999999999992,{"$f":"IF(B37>0,re(B$10,E37,F37,B$6,B$14,B$13), )","v":7.9208585393251402E-2},null,null,6.8795000000000002,7.3979999999999997,7.5687752865109754,4.7327129772467718]
[null,80,6.8719999999999999,7.4269999999999996,6.8719999999999999,7.4269999999999996,null,null,6.9940999999999995,5.0999999999999622E-2,null,75,5.1089233183948569E-2,5.2499999999999679E-2,0.55499999999999972,{"$f":"IF(B38>0,re(B$10,E38,F38,B$6,B$14,B$13), )","v":7.9208585393251402E-2},null,null,6.8734999999999999,7.4194999999999993,7.9235616280661736,5.8416331727522914]
[null,90,6.8689999999999998,7.4359999999999999,6.8689999999999998,7.4359999999999999,null,null,6.9937399999999998,4.7999999999999508E-2,null,85,3.4059488789300728E-2,4.9499999999999565E-2,0.56700000000000017,{"$f":"IF(B39>0,re(B$10,E39,F39,B$6,B$14,B$13), )","v":7.9208585393251402E-2},null,null,6.8704999999999998,7.4314999999999998,8.1600858557696512,6.6337190266848056]
[null,101,6.8659999999999997,7.4509999999999996,6.8659999999999997,7.4509999999999996,null,null,6.9946999999999999,4.4999999999999395E-2,null,95.5,4.6444757439953244E-2,4.6499999999999451E-2,0.58499999999999996,{"$f":"IF(B40>0,re(B$10,E40,F40,B$6,B$14,B$13), )","v":7.9208585393251402E-2},null,null,6.8674999999999997,7.4435000000000002,8.5148721973248502,7.4654091733139456]
[null,120,6.86,7.47,6.86,7.47,null,null,6.9942000000000002,3.9000000000000055E-2,null,110.5,3.7345930690020512E-2,4.1999999999999725E-2,0.60999999999999943,{"$f":"IF(B41>0,re(B$10,E41,F41,B$6,B$14,B$13), )","v":7.9208585393251402E-2},null,null,6.8629999999999995,7.4604999999999997,9.0076310050403983,8.653537954212716]
[null,140,6.8570000000000002,7.4909999999999997,6.8570000000000002,7.4909999999999997,null,null,6.99648,3.5999999999999942E-2,null,130,3.4059488789299472E-2,3.7499999999999999E-2,0.63399999999999945,{"$f":"IF(B42>0,re(B$10,E42,F42,B$6,B$14,B$13), )","v":7.9208585393251402E-2},null,null,6.8585000000000003,7.4804999999999993,9.4806794604473357,10.198105369381118]
[null,170,6.851,7.5149999999999997,6.851,7.5149999999999997,null,null,{"$f":"E43+(1-B$9)*(F43-E43)","v":6.9970799999999995},2.9999999999999714E-2,null,155,2.8382907324416434E-2,{"$f":"0.5*(J42+J43)","v":3.2999999999999828E-2},{"$f":"F43-E43","v":0.6639999999999997},{"$f":"IF(B43>0,re(B$10,E43,F43,B$6,B$14,B$13), )","v":7.9208585393251402E-2},null,null,6.8540000000000001,7.5030000000000001,10.071990029706011,12.178320004212402]
[null,201,6.8479999999999999,7.5430000000000001,6.8479999999999999,7.5430000000000001,null,null,7.0008999999999997,2.6999999999999601E-2,null,185.5,2.8382907324416732E-2,2.8499999999999658E-2,0.69500000000000028,{"$f":"IF(B44>0,re(B$10,E44,F44,B$6,B$14,B$13), )","v":7.9208585393251402E-2},null,null,6.8494999999999999,7.5289999999999999,10.683010951273316,14.59418185870657]
[null,226,6.8410000000000002,7.5579999999999998,6.8410000000000002,7.5579999999999998,null,null,{"$f":"E45+(1-B$9)*(F45-E45)","v":6.9987399999999997},1.9999999999999928E-2,null,213.5,2.497695844548552E-2,{"$f":"0.5*(J44+J45)","v":2.3499999999999764E-2},{"$f":"F45-E45","v":0.71699999999999964},{"$f":"IF(B45>0,re(B$10,E45,F45,B$6,B$14,B$13), )","v":7.9208585393251402E-2},null,null,6.8445,7.5504999999999995,11.116638702062994,16.812022249717607]
[null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$f":"E46+(1-B$9)*(F46-E46)","v":{"$error":"#N/A"}},{"$f":"E46-E$21-E$7","v":{"$error":"#N/A"}},null,0,{"$error":"#N/A"},{"$f":"0.5*(J45+J46)","v":{"$error":"#N/A"}},{"$f":"F46-E46","v":{"$error":"#N/A"}},{"$f":"IF(B46>0,re(B$10,E46,F46,B$6,B$14,B$13), )","v":0},null,null,{"$f":"(E45+E46)/2","v":{"$error":"#N/A"}},{"$f":"(F45+F46)/2","v":{"$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(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":3.004463583881949E-2}]

{"sheet":"Figures","index":2,"n_rows":88,"n_cols":22,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Figure 1",null,null,null,null,null,null,null,"Figure 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"0.8*MIN(Data!B23:B81)","v":0.8},{"$f":"Data!E21","v":6.7960000000000003}]
[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":226},{"$f":"U3","v":6.7960000000000003}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T3","v":0.8},{"$f":"Data!F21","v":7.7380000000000004}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T4","v":226},{"$f":"U5","v":7.7380000000000004}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T4/4","v":56.5},{"$f":"IF(V8<V9,V8,NA())","v":{"$error":"#N/A"}},{"$f":"IF(Data!B10>Data!E21,Data!B10,Data!E21-0.1)","v":6.6960000000000006}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T8","v":56.5},{"$f":"IF(V8<V9,V9,NA())","v":{"$error":"#N/A"}},{"$f":"IF(Data!B11<Data!F21,Data!B11,Data!F21+0.1)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Figure 3",null,null,null,null,null,null,null,"Figure 4"]
[null,"Qn (m3/d)","sn (m)",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,0.85,0]
[null,0.1,0.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.16]
[]
[]
[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.18823529411764706}]
[null,"Dsn (m)",2.5000000000000001E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Figure 5",null,null,null,null,null,null,null,"Figure 6"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Figure 7",null,null,null,null,null,null,null,"Figure 8"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Figure 9",null,null,null,null,null,null,null,"Figure 10"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"t (min)","sn (m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,8.5000000000000006E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,0]

{"sheet":"B&R","index":3,"n_rows":64,"n_cols":28,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["Generalized Bouwer and Rice (1976)"]
["Well Designation:",null,{"$f":"IF(Data!B1 > 0,Data!B1,\"\")","v":"YYY"}]
["Date:",null,{"$f":"IF(Data!B2 > 0,Data!B2,\"\")","v":"date"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"y = A + B x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B&R Type Curve"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Xi","Yi","X2","XY","(y-A-Bx)2","e","count","s/s0","SX",{"$f":"SUM(M6:M64)","v":1020},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":-37.700635712007823},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":130682},null,{"$f":"X6+1.05*(MAX(M$6:M$64)/30)","v":7.0350000000000001},{"$f":"EXP(-2*E$12*(X7/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.95736752919070434},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":11.892650213650438},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":-3476.935581911493},null,{"$f":"X7+1.05*(MAX(M$6:M$64)/30)","v":14.07},{"$f":"EXP(-2*E$12*(X8/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.91655258594871403},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"Timecut",25,"<-  Enter or change value here",null,null,null,null,"C",null,null,{"$f":"IF(Data!B26>=D$9,Data!B26-D$9,0)","v":0},{"$f":"IF(S9>0,LN(Data!J26),0)","v":0},0,0,0,0,{"$f":"IF(Data!B26>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},"N",{"$f":"SUM(S6:S64)","v":12},null,21.105,{"$f":"EXP(-2*E$12*(X9/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.87747768458307096},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.2588156033950146},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":527784},null,28.14,{"$f":"EXP(-2*E$12*(X10/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.84006864280927485},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.6153126706510297},null,35.174999999999997,{"$f":"EXP(-2*E$12*(X11/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.80425444091690379},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Model Results:",null,"Tn (m2/d) =",{"$f":"1440*V22*(-V12)","v":0.27015648074584209},"+/-",{"$f":"1440*V22*SQRT(V15)","v":8.4362393667999133E-3},"m2/d",null,{"$f":"EXP(((1.1/LN(J8))+J10/J8)^-1)","v":6.1580537772639454},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":-6.1930232001916235E-3},null,42.209999999999994,{"$f":"EXP(-2*E$12*(X12/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.76996708694126748},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,49.24499999999999,{"$f":"EXP(-2*E$12*(X13/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.73714148758312548},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.6449299011679138E-3},null,56.279999999999987,{"$f":"EXP(-2*E$12*(X14/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.70571532463141706},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,{"$f":"Figures!U27","v":-0.18823529411764706},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":3.7400070509933925E-8},null,63.314999999999984,{"$f":"EXP(-2*E$12*(X15/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.67562893665439561},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,70.34999999999998,{"$f":"EXP(-2*E$12*(X16/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.64682520573456159},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":5},{"$f":"IF(S17>0,LN(Data!J34),0)","v":-2.6310891599660882},25,-13.15544579983044,2.3069438060362244E-4,0.37449395372533922,{"$f":"IF(Data!B34>'B&R'!D$9,1,0)","v":1},0.98434730761052902,null,null,null,77.384999999999977,{"$f":"EXP(-2*E$12*(X17/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.61924944903236623},null,5,-2.6310891599660882]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B35>=D$9,Data!B35-D$9,0)","v":15},{"$f":"IF(S18>0,LN(Data!J35),0)","v":-2.673648774384886},225,-40.104731615773289,1.1943413644456549E-3,0.85209994897558783,{"$f":"IF(Data!B35>'B&R'!D$9,1,0)","v":1},0.94333283646008848,"Plot Model Line",null,null,84.419999999999973,{"$f":"EXP(-2*E$12*(X18/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.59284931497282145},null,15,-2.673648774384886]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B36>=D$9,Data!B36-D$9,0)","v":27},{"$f":"IF(S19>0,LN(Data!J36),0)","v":-2.7646205525906029},729,-74.64475491994628,3.2054406588952455E-4,0.44143846511385909,{"$f":"IF(Data!B36>'B&R'!D$9,1,0)","v":1},0.86130389415921971,0,{"$f":"V11","v":-2.6153126706510297},null,91.45499999999997,{"$f":"EXP(-2*E$12*(X19/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.56757468385793175},null,27,-2.7646205525906029]
[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":45},{"$f":"IF(S20>0,LN(Data!J37),0)","v":-2.9187712324178676},2025,-131.34470545880404,6.1367763608107125E-4,-0.61079637487025196,{"$f":"IF(Data!B37>'B&R'!D$9,1,0)","v":1},0.73826048070789785,{"$f":"MAX(M6:M64)","v":201},{"$f":"V11+V12*U20","v":-3.8601103338895459},null,98.489999999999966,{"$f":"EXP(-2*E$12*(X20/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.5433775727162633},null,45,-2.9187712324178676]
[null,null,null,null,null,null,null,null,null,"Variation",null,null,{"$f":"IF(Data!B38>=D$9,Data!B38-D$9,0)","v":55},{"$f":"IF(S21>0,LN(Data!J38),0)","v":-2.9759296462578186},3025,-163.67613054418001,4.0002798433942178E-4,-0.49314142904215363,{"$f":"IF(Data!B38>'B&R'!D$9,1,0)","v":1},0.6972460095574573,null,null,null,105.52499999999996,{"$f":"EXP(-2*E$12*(X21/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.52021204420901113},null,55,-2.9759296462578186]
[null,null,null,null,null,null,null,null,null,{"$f":"G12/E12","v":3.1227232985525013E-2},null,null,{"$f":"IF(Data!B39>=D$9,Data!B39-D$9,0)","v":65},{"$f":"IF(S22>0,LN(Data!J39),0)","v":-3.0365542680742563},4225,-197.37602742482667,3.4950636807672711E-4,-0.46095003145926089,{"$f":"IF(Data!B39>'B&R'!D$9,1,0)","v":1},0.65623153840701687,"factor",{"$f":"Data!V23^2*LN('B&R'!J12)/(2*(-Figures!U27))","v":3.0293551488521409E-2},null,112.55999999999996,{"$f":"EXP(-2*E$12*(X22/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.4980341194196265},null,65,-3.0365542680742563]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B40>=D$9,Data!B40-D$9,0)","v":76},{"$f":"IF(S23>0,LN(Data!J40),0)","v":-3.101092789211831},5776,-235.68305198009915,2.2832283868958004E-4,-0.3725640792172959,{"$f":"IF(Data!B40>'B&R'!D$9,1,0)","v":1},0.61521706725657621,null,null,null,119.59499999999996,{"$f":"EXP(-2*E$12*(X23/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.47680169436143605},null,76,-3.101092789211831]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B41>=D$9,Data!B41-D$9,0)","v":95},{"$f":"IF(S24>0,LN(Data!J41),0)","v":-3.2441936328524892},9025,-308.19839512098645,1.6437963276222799E-3,-0.99965537470394583,{"$f":"IF(Data!B41>'B&R'!D$9,1,0)","v":1},0.53318812495570744,null,null,null,126.62999999999995,{"$f":"EXP(-2*E$12*(X24/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.45647446004474934},null,95,-3.2441936328524892]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B42>=D$9,Data!B42-D$9,0)","v":115},{"$f":"IF(S25>0,LN(Data!J42),0)","v":-3.3242363405260287},13225,-382.28717916049328,1.0719063866806031E-5,8.0724382521812271E-2,{"$f":"IF(Data!B42>'B&R'!D$9,1,0)","v":1},0.49217365380526684,"s0 (ft)",{"$f":"EXP(V19)","v":7.314491485203245E-2},null,133.66499999999996,{"$f":"EXP(-2*E$12*(X25/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.43701382595170257},null,115,-3.3242363405260287]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B43>=D$9,Data!B43-D$9,0)","v":145},{"$f":"IF(S26>0,LN(Data!J43),0)","v":-3.5065578973199911},21025,-508.45089511139872,4.5469901439966903E-5,0.16626020391714169,{"$f":"IF(Data!B43>'B&R'!D$9,1,0)","v":1},0.41014471150438586,null," ",null,140.69999999999996,{"$f":"EXP(-2*E$12*(X26/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.41838284677355791},null,145,-3.5065578973199911]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B44>=D$9,Data!B44-D$9,0)","v":176},{"$f":"IF(S27>0,LN(Data!J44),0)","v":-3.6119184129778228},30976,-635.69764068409677,8.7172736143495411E-3,2.302060013336487,{"$f":"IF(Data!B44>'B&R'!D$9,1,0)","v":1},0.36913024035394532,null,null,null,147.73499999999996,{"$f":"EXP(-2*E$12*(X27/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.40054615227137425},null,176,-3.6119184129778228]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B45>=D$9,Data!B45-D$9,0)","v":201},{"$f":"IF(S28>0,LN(Data!J45),0)","v":-3.9120230054281495},40401,-786.31662409105809,2.6949254662749413E-3,-1.2799696782978136,{"$f":"IF(Data!B45>'B&R'!D$9,1,0)","v":1},0.27342980766959218,null,null,null,154.76999999999995,{"$f":"EXP(-2*E$12*(X28/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.38346988012688915},null,201,-3.9120230054281495]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B46>=D$9,Data!B46-D$9,0)","v":0},{"$f":"IF(S29>0,LN(Data!J46),0)","v":0},0,0,0,0,{"$f":"IF(Data!B46>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,161.80499999999995,{"$f":"EXP(-2*E$12*(X29/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.36712161165613544},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B47>=D$9,Data!B47-D$9,0)","v":0},{"$f":"IF(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,168.83999999999995,{"$f":"EXP(-2*E$12*(X30/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.35147031026374365},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,175.87499999999994,{"$f":"EXP(-2*E$12*(X31/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.33648626252109054},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,182.90999999999994,{"$f":"EXP(-2*E$12*(X32/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.32214102175643111},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,189.94499999999994,{"$f":"EXP(-2*E$12*(X33/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.30840735404992348},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,196.97999999999993,{"$f":"EXP(-2*E$12*(X34/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.29525918653101796},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,204.01499999999993,{"$f":"EXP(-2*E$12*(X35/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.28267155788005793},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,211.04999999999993,{"$f":"EXP(-2*E$12*(X36/1440)*(-J$15)/(Data!V$23^2*LN('B&R'!J$12)))","v":0.27062057094011821},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":0.27},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":0.27},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,\" m2/d\")","v":" T = 0.27 m2/d"},null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B59>=D$9,Data!B59-D$9,0)","v":0},{"$f":"IF(S42>0,LN(Data!J59),0)","v":0},0,0,0,0,{"$f":"IF(Data!B59>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B60>=D$9,Data!B60-D$9,0)","v":0},{"$f":"IF(S43>0,LN(Data!J60),0)","v":0},0,0,0,0,{"$f":"IF(Data!B60>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B61>=D$9,Data!B61-D$9,0)","v":0},{"$f":"IF(S44>0,LN(Data!J61),0)","v":0},0,0,0,0,{"$f":"IF(Data!B61>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B62>=D$9,Data!B62-D$9,0)","v":0},{"$f":"IF(S45>0,LN(Data!J62),0)","v":0},0,0,0,0,{"$f":"IF(Data!B62>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B63>=D$9,Data!B63-D$9,0)","v":0},{"$f":"IF(S46>0,LN(Data!J63),0)","v":0},0,0,0,0,{"$f":"IF(Data!B63>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B64>=D$9,Data!B64-D$9,0)","v":0},{"$f":"IF(S47>0,LN(Data!J64),0)","v":0},0,0,0,0,{"$f":"IF(Data!B64>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B65>=D$9,Data!B65-D$9,0)","v":0},{"$f":"IF(S48>0,LN(Data!J65),0)","v":0},{"$f":"M48^2","v":0},{"$f":"M48*N48","v":0},0,{"$f":"IF(M48>0,(N48-V$11-V$12*M48)/SQRT(V$14),0)","v":0},{"$f":"IF(Data!B65>'B&R'!D$9,1,0)","v":0},{"$f":"IF(S48=0,NA(),EXP(N48)/EXP(V$19))","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B66>=D$9,Data!B66-D$9,0)","v":0},{"$f":"IF(S49>0,LN(Data!J66),0)","v":0},0,0,0,0,{"$f":"IF(Data!B66>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B67>=D$9,Data!B67-D$9,0)","v":0},{"$f":"IF(S50>0,LN(Data!J67),0)","v":0},0,0,0,0,{"$f":"IF(Data!B67>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B68>=D$9,Data!B68-D$9,0)","v":0},{"$f":"IF(S51>0,LN(Data!J68),0)","v":0},0,0,0,0,{"$f":"IF(Data!B68>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B69>=D$9,Data!B69-D$9,0)","v":0},{"$f":"IF(S52>0,LN(Data!J69),0)","v":0},0,0,0,0,{"$f":"IF(Data!B69>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B70>=D$9,Data!B70-D$9,0)","v":0},{"$f":"IF(S53>0,LN(Data!J70),0)","v":0},0,0,0,0,{"$f":"IF(Data!B70>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B71>=D$9,Data!B71-D$9,0)","v":0},{"$f":"IF(S54>0,LN(Data!J71),0)","v":0},0,0,0,0,{"$f":"IF(Data!B71>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B72>=D$9,Data!B72-D$9,0)","v":0},{"$f":"IF(S55>0,LN(Data!J72),0)","v":0},0,0,0,0,{"$f":"IF(Data!B72>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B73>=D$9,Data!B73-D$9,0)","v":0},{"$f":"IF(S56>0,LN(Data!J73),0)","v":0},0,0,0,0,{"$f":"IF(Data!B73>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B74>=D$9,Data!B74-D$9,0)","v":0},{"$f":"IF(S57>0,LN(Data!J74),0)","v":0},0,0,0,0,{"$f":"IF(Data!B74>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B75>=D$9,Data!B75-D$9,0)","v":0},{"$f":"IF(S58>0,LN(Data!J75),0)","v":0},0,0,0,0,{"$f":"IF(Data!B75>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B76>=D$9,Data!B76-D$9,0)","v":0},{"$f":"IF(S59>0,LN(Data!J76),0)","v":0},0,0,0,0,{"$f":"IF(Data!B76>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B77>=D$9,Data!B77-D$9,0)","v":0},{"$f":"IF(S60>0,LN(Data!J77),0)","v":0},0,0,0,0,{"$f":"IF(Data!B77>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B78>=D$9,Data!B78-D$9,0)","v":0},{"$f":"IF(S61>0,LN(Data!J78),0)","v":0},{"$f":"M61^2","v":0},{"$f":"M61*N61","v":0},0,{"$f":"IF(M61>0,(N61-V$11-V$12*M61)/SQRT(V$14),0)","v":0},{"$f":"IF(Data!B78>'B&R'!D$9,1,0)","v":0},{"$f":"IF(S61=0,NA(),EXP(N61)/EXP(V$19))","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B79>=D$9,Data!B79-D$9,0)","v":0},{"$f":"IF(S62>0,LN(Data!J79),0)","v":0},0,0,0,0,{"$f":"IF(Data!B79>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B80>=D$9,Data!B80-D$9,0)","v":0},{"$f":"IF(S63>0,LN(Data!J80),0)","v":0},0,0,0,0,{"$f":"IF(Data!B80>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!B81>=D$9,Data!B81-D$9,0)","v":0},{"$f":"IF(S64>0,LN(Data!J81),0)","v":0},0,0,0,0,{"$f":"IF(Data!B81>'B&R'!D$9,1,0)","v":0},{"$error":"#N/A"},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"C&J","index":4,"n_rows":66,"n_cols":26,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
["Cooper and Jacob (1946)"]
["Well Designation:",null,{"$f":"IF(Data!B1 > 0,Data!B1,\"\")","v":"YYY"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E10","v":15},{"$f":"E9","v":25},0]
["Date:",null,{"$f":"IF(Data!B2 > 0,Data!B2,\"\")","v":"date"},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"MAX(P9:Q58)","v":5.597740055648746},null,null,null,null,null,{"$f":"W2","v":15},{"$f":"X2","v":25},{"$f":"J50","v":15}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"Q3","v":5.597740055648746}]
[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":223.5}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Index","ti","Vi (meas)","Vi (calc)","SE",null,"Time","Qn/sn",null,"Index","Time","Qn/sn","A-Time"]
[null,"Enter early time cut-off for least-squares model fit"]
[null,null,"    Timecut (min):",null,25,"<-  Enter or change values here",null,null,null,null,null,null,null,1,{"$f":"IF(Data!L24>=E$9,Data!L24-E$10,0)","v":0},{"$f":"IF(O9>0,1000*Data!M24*(Data!B24-Data!B23)/1440,0)","v":0},{"$f":"IF(O9>0,1000*(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":1.25},{"$f":"Data!M24/Data!N24","v":11.927447435941128},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":3.3528347315445157},{"$f":"X9+E$10","v":17}]
[null,"  Time Adjustment (min):",null,null,15,null,null,null,null,null,null,null,null,2,{"$f":"IF(Data!L25>=E$9,Data!L25-E$10,0)","v":0},{"$f":"IF(O10>0,P9+1000*Data!M25*(Data!B25-Data!B24)/1440,0)","v":0},{"$f":"IF(O10>0,Q9+1000*(4*PI()*(E$16/1440)*Data!N25)*(Data!B25-Data!B24)/LN(0.56146/((Data!P25^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O10))),0)","v":0},{"$f":"(P10-Q10)^2","v":0},null,{"$f":"Data!L25","v":1.75},{"$f":"Data!M25/Data!N25","v":11.400665703531217},null,1,{"$f":"2+(X$5-2)*W10/50","v":6.43},{"$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":1.7369165877566344},{"$f":"X10+E$10","v":21.43}]
[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+1000*Data!M26*(Data!B26-Data!B25)/1440,0)","v":0},{"$f":"IF(O11>0,Q10+1000*(4*PI()*(E$16/1440)*Data!N26)*(Data!B26-Data!B25)/LN(0.56146/((Data!P26^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O11))),0)","v":0},0,null,{"$f":"Data!L26","v":2.5},{"$f":"Data!M26/Data!N26","v":7.9626255842255436},null,2,10.86,{"$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":1.4280354008522096},25.86]
[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+1000*Data!M27*(Data!B27-Data!B26)/1440,0)","v":0},{"$f":"IF(O12>0,Q11+1000*(4*PI()*(E$16/1440)*Data!N27)*(Data!B27-Data!B26)/LN(0.56146/((Data!P27^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O12))),0)","v":0},0,null,{"$f":"Data!L27","v":3.5},{"$f":"Data!M27/Data!N27","v":3.9604056731742907},null,3,15.29,{"$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":1.2795097758808913},30.29]
[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+1000*Data!M28*(Data!B28-Data!B27)/1440,0)","v":0},{"$f":"IF(O13>0,Q12+1000*(4*PI()*(E$16/1440)*Data!N28)*(Data!B28-Data!B27)/LN(0.56146/((Data!P28^2*'C&J'!E$15)/(4*('C&J'!E$16/1440)*O13))),0)","v":0},0,null,{"$f":"Data!L28","v":4.5},{"$f":"Data!M28/Data!N28","v":4.0164491496817147},null,4,19.72,{"$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":1.1876437151749872},34.72]
[null,"Root-Mean-Square Error:",null,null,{"$f":"SQRT(SUM(R9:R58))","v":0.560015644045738},"<-- 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+1000*Data!M29*(Data!B29-Data!B28)/1440,0)","v":0},{"$f":"IF(O14>0,Q13+1000*(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.25},{"$f":"Data!M29/Data!N29","v":3.3556146590442202},null,5,24.15,{"$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":1.1234016277420762},39.15]
[null,null,null,null,{"$f":"IF(E12=\"d\",0.025*SQRT(E16)*3.28,E12)","v":4.7455233959449658E-2},"<-- Working Sn",null,null,null,null,null,null,null,7,{"$f":"IF(Data!L30>=E$9,Data!L30-E$10,0)","v":0},{"$f":"IF(O15>0,P14+1000*Data!M30*(Data!B30-Data!B29)/1440,0)","v":0},{"$f":"IF(O15>0,Q14+1000*(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":9.75},{"$f":"Data!M30/Data!N30","v":5.1666285200474027},null,6,28.58,{"$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":1.0750709758962234},43.58]
[null,"Trial Tn (m2/d):",null,null,0.33491957616688056,"<-- 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+1000*Data!M31*(Data!B31-Data!B30)/1440,0)","v":0},{"$f":"IF(O16>0,Q15+1000*(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":13.5},{"$f":"Data!M31/Data!N31","v":0.31190008048810303},null,7,33.010000000000005,{"$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":1.036903009373535},48.010000000000005]
[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+1000*Data!M32*(Data!B32-Data!B31)/1440,0)","v":0},{"$f":"IF(O17>0,Q16+1000*(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":17.5},{"$f":"Data!M32/Data!N32","v":2.2442298814654604},null,8,37.44,{"$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":1.0057009877176961},52.44]
[null,"Model Result:",null,"Tn (m2/d) =",{"$f":"E16","v":0.33491957616688056},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+1000*Data!M33*(Data!B33-Data!B32)/1440,0)","v":0},{"$f":"IF(O18>0,Q17+1000*(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":22.5},{"$f":"Data!M33/Data!N33","v":1.7466404507333115},null,9,41.87,{"$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":0.97952564730698255},56.87]
[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":12.5},{"$f":"IF(O19>0,P18+1000*Data!M34*(Data!B34-Data!B33)/1440,0)","v":0.23652422770347728},{"$f":"IF(O19>0,Q18+1000*(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.34784711020107828},1.2392784167574679E-2,null,{"$f":"Data!L34","v":27.5},{"$f":"Data!M34/Data!N34","v":0.92678881059322216},null,10,46.3,{"$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":0.95712236701718933},61.3]
[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":20},{"$f":"IF(O20>0,P19+1000*Data!M35*(Data!B35-Data!B34)/1440,0)","v":0.78841409234491255},{"$f":"IF(O20>0,Q19+1000*(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.92699353233284154},1.920426118736801E-2,null,{"$f":"Data!L35","v":35},{"$f":"Data!M35/Data!N35","v":1.1272644043740037},null,11,50.73,{"$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":0.93763818952144351},65.72999999999999]
[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":31},{"$f":"IF(O21>0,P20+1000*Data!M36*(Data!B36-Data!B35)/1440,0)","v":1.3205936046777014},{"$f":"IF(O21>0,Q20+1000*(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":1.5062558848081409},3.4470482263233793E-2,null,{"$f":"Data!L36","v":46},{"$f":"Data!M36/Data!N36","v":0.96759911333234683},null,12,55.16,{"$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":0.92046990804835471},70.16]
[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":46},{"$f":"IF(O22>0,P21+1000*Data!M37*(Data!B37-Data!B36)/1440,0)","v":2.049876640096727},{"$f":"IF(O22>0,Q21+1000*(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":2.2071878166544225},2.4746806269966462E-2,null,{"$f":"Data!L37","v":61},{"$f":"Data!M37/Data!N37","v":0.99731013390636147},null,13,59.59,{"$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":0.90517701539423145},74.59]
[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":60},{"$f":"IF(O23>0,P22+1000*Data!M38*(Data!B38-Data!B37)/1440,0)","v":2.4046629816519256},{"$f":"IF(O23>0,Q22+1000*(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":2.5367143173092979},1.7437555248895995E-2,null,{"$f":"Data!L38","v":75},{"$f":"Data!M38/Data!N38","v":0.97312825112283585},null,14,64.02000000000001,{"$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":0.8914291239416714},79.02000000000001]
[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":70},{"$f":"IF(O24>0,P23+1000*Data!M39*(Data!B39-Data!B38)/1440,0)","v":2.6411872093554027},{"$f":"IF(O24>0,Q23+1000*(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":2.8374548323069848},3.8520979819064383E-2,null,{"$f":"Data!L39","v":85},{"$f":"Data!M39/Data!N39","v":0.68807048059193998},null,15,68.45,{"$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":0.87897279650454119},83.45]
[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":80.5},{"$f":"IF(O25>0,P24+1000*Data!M40*(Data!B40-Data!B39)/1440,0)","v":2.9959735509106009},{"$f":"IF(O25>0,Q24+1000*(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":3.1394463370245806},2.0584440355307775E-2,null,{"$f":"Data!L40","v":95.5},{"$f":"Data!M40/Data!N40","v":0.99881198795599546},null,16,72.88,{"$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":0.86760984467746161},87.88]
[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":95.5},{"$f":"IF(O26>0,P25+1000*Data!M41*(Data!B41-Data!B40)/1440,0)","v":3.4887323586261494},{"$f":"IF(O26>0,Q25+1000*(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":3.5948689897233801},1.126498446066964E-2,null,{"$f":"Data!L41","v":110.5},{"$f":"Data!M41/Data!N41","v":0.88918882595287518},null,17,77.31,{"$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":0.85718268169965983},92.31]
[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":115},{"$f":"IF(O27>0,P26+1000*Data!M42*(Data!B42-Data!B41)/1440,0)","v":3.9617808140330864},{"$f":"IF(O27>0,Q26+1000*(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":4.0079120442182647},2.1280903983979145E-3,null,{"$f":"Data!L42","v":130},{"$f":"Data!M42/Data!N42","v":0.90825303438131932},null,18,81.739999999999995,{"$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":0.84756416792350009},96.74]
[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":140},{"$f":"IF(O28>0,P27+1000*Data!M43*(Data!B43-Data!B42)/1440,0)","v":4.5530913832917621},{"$f":"IF(O28>0,Q27+1000*(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":4.5336422707593078},3.7826797830007068E-4,null,{"$f":"Data!L43","v":155},{"$f":"Data!M43/Data!N43","v":0.86008810073989639},null,19,86.17,{"$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":0.83865040438317862},101.17]
[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":170.5},{"$f":"IF(O29>0,P28+1000*Data!M44*(Data!B44-Data!B43)/1440,0)","v":5.1641123048590671},{"$f":"IF(O29>0,Q28+1000*(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":4.9865961505849956},3.1511985028255959E-2,null,{"$f":"Data!L44","v":185.5},{"$f":"Data!M44/Data!N44","v":0.99589148506726577},null,20,90.6,{"$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":0.83035551229878535},105.6]
[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":198.5},{"$f":"IF(O30>0,P29+1000*Data!M45*(Data!B45-Data!B44)/1440,0)","v":5.597740055648746},{"$f":"IF(O30>0,Q29+1000*(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":5.279971453677236},0.10097688439892796,null,{"$f":"Data!L45","v":213.5},{"$f":"Data!M45/Data!N45","v":1.0628492955525861},null,21,95.03,{"$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":0.82260778164902459},110.03]
[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":0},{"$f":"IF(O31>0,P30+1000*Data!M46*(Data!B46-Data!B45)/1440,0)","v":0},{"$f":"IF(O31>0,Q30+1000*(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},0,null,{"$f":"Data!L46","v":0},{"$f":"Data!M46/Data!N46","v":{"$error":"#N/A"}},null,22,99.46,{"$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":0.81534678314467979},114.46]
[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+1000*Data!M47*(Data!B47-Data!B46)/1440,0)","v":0},{"$f":"IF(O32>0,Q31+1000*(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,103.89,{"$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":0.80852117071578544},118.89]
[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+1000*Data!M48*(Data!B48-Data!B47)/1440,0)","v":0},{"$f":"IF(O33>0,Q32+1000*(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,108.32,{"$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":0.8020869871802685},123.32]
[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+1000*Data!M49*(Data!B49-Data!B48)/1440,0)","v":0},{"$f":"IF(O34>0,Q33+1000*(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,112.75,{"$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":0.79600634211710775},127.75]
[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+1000*Data!M50*(Data!B50-Data!B49)/1440,0)","v":0},{"$f":"IF(O35>0,Q34+1000*(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,117.18,{"$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":0.79024636883589283},132.18]
[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+1000*Data!M51*(Data!B51-Data!B50)/1440,0)","v":0},{"$f":"IF(O36>0,Q35+1000*(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,121.61,{"$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":0.7847783932460235},136.61000000000001]
[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+1000*Data!M52*(Data!B52-Data!B51)/1440,0)","v":0},{"$f":"IF(O37>0,Q36+1000*(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,126.04,{"$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":0.77957726545360384},141.04000000000002]
[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+1000*Data!M53*(Data!B53-Data!B52)/1440,0)","v":0},{"$f":"IF(O38>0,Q37+1000*(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,130.47,{"$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":0.77462081764384705},145.47]
[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+1000*Data!M54*(Data!B54-Data!B53)/1440,0)","v":0},{"$f":"IF(O39>0,Q38+1000*(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,134.9,{"$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":0.76988942092296886},149.9]
[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+1000*Data!M55*(Data!B55-Data!B54)/1440,0)","v":0},{"$f":"IF(O40>0,Q39+1000*(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,139.33000000000001,{"$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":0.76536562040620515},154.33000000000001]
[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+1000*Data!M56*(Data!B56-Data!B55)/1440,0)","v":0},{"$f":"IF(O41>0,Q40+1000*(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,143.76,{"$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":0.76103383269262503},158.76]
[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+1000*Data!M57*(Data!B57-Data!B56)/1440,0)","v":0},{"$f":"IF(O42>0,Q41+1000*(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,148.19,{"$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":0.75688009347001117},163.19]
[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+1000*Data!M58*(Data!B58-Data!B57)/1440,0)","v":0},{"$f":"IF(O43>0,Q42+1000*(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,152.62,{"$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":0.75289184569450018},167.62]
[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+1000*Data!M59*(Data!B59-Data!B58)/1440,0)","v":0},{"$f":"IF(O44>0,Q43+1000*(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,157.05000000000001,{"$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":0.74905776083483555},172.05]
[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+1000*Data!M60*(Data!B60-Data!B59)/1440,0)","v":0},{"$f":"IF(O45>0,Q44+1000*(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,161.47999999999999,{"$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":0.74536758723335461},176.48]
[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+1000*Data!M61*(Data!B61-Data!B60)/1440,0)","v":0},{"$f":"IF(O46>0,Q45+1000*(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,165.91,{"$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":0.74181202083930009},180.91]
[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+1000*Data!M62*(Data!B62-Data!B61)/1440,0)","v":0},{"$f":"IF(O47>0,Q46+1000*(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,170.34,{"$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":0.73838259450445987},185.34]
[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+1000*Data!M63*(Data!B63-Data!B62)/1440,0)","v":0},{"$f":"IF(O48>0,Q47+1000*(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,174.77,{"$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":0.73507158276206641},189.77]
[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+1000*Data!M64*(Data!B64-Data!B63)/1440,0)","v":0},{"$f":"IF(O49>0,Q48+1000*(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,179.2,{"$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":0.73187191958565356},194.2]
[null,null,null,null,null,null,null,null,null,15,null,null,null,42,{"$f":"IF(Data!L65>=E$9,Data!L65-E$10,0)","v":0},{"$f":"IF(O50>0,P49+1000*Data!M65*(Data!B65-Data!B64)/1440,0)","v":0},{"$f":"IF(O50>0,Q49+1000*(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,183.63,{"$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":0.72877712708113029},198.63]
[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+1000*Data!M66*(Data!B66-Data!B65)/1440,0)","v":0},{"$f":"IF(O51>0,Q50+1000*(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,188.06,{"$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":0.72578125342962974},203.06]
[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+1000*Data!M67*(Data!B67-Data!B66)/1440,0)","v":0},{"$f":"IF(O52>0,Q51+1000*(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,192.49,{"$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":0.72287881869111636},207.49]
[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+1000*Data!M68*(Data!B68-Data!B67)/1440,0)","v":0},{"$f":"IF(O53>0,Q52+1000*(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,196.92,{"$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":0.72006476731477298},211.92]
[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+1000*Data!M69*(Data!B69-Data!B68)/1440,0)","v":0},{"$f":"IF(O54>0,Q53+1000*(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,201.35,{"$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":0.71733442639375011},216.35]
[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+1000*Data!M70*(Data!B70-Data!B69)/1440,0)","v":0},{"$f":"IF(O55>0,Q54+1000*(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,205.78,{"$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":0.71468346885810485},220.78]
[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+1000*Data!M71*(Data!B71-Data!B70)/1440,0)","v":0},{"$f":"IF(O56>0,Q55+1000*(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,210.21,{"$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":0.71210788092782618},225.21]
[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+1000*Data!M72*(Data!B72-Data!B71)/1440,0)","v":0},{"$f":"IF(O57>0,Q56+1000*(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,214.64,{"$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":0.70960393325329463},229.64]
[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+1000*Data!M73*(Data!B73-Data!B72)/1440,0)","v":0},{"$f":"IF(O58>0,Q57+1000*(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,219.07,{"$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":0.70716815525774213},234.07]
[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,223.5,{"$f":"4*PI()*E$18/LN(0.56146/(Data!V$23^2*'C&J'!E$15/(4*'C&J'!E$18*'C&J'!X59/1440)))","v":0.70479731226871534},238.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L75","v":0},{"$f":"Data!M75/Data!N75","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L76","v":0},{"$f":"Data!M76/Data!N76","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L77","v":0},{"$f":"Data!M77/Data!N77","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L78","v":0},{"$f":"Data!M78/Data!N78","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L79","v":0},{"$f":"Data!M79/Data!N79","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L80","v":0},{"$f":"Data!M80/Data!N80","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!L81","v":0},{"$f":"Data!M81/Data!N81","v":{"$error":"#N/A"}}]

{"sheet":"CB&P","index":5,"n_rows":108,"n_cols":25,"rows_kept":108,"cut":false,"hidden":false,"merged":[]}
["Cooper, Bredehoeft and Papadopulos (1967)"]
["Well Designation:",null,{"$f":"IF(Data!B1 > 0,Data!B1,\"\")","v":"YYY"},null,null,null,null,null,null,null,null,null,null,null,null,"e",9.9999999999999995E-7]
["Date:",null,{"$f":"IF(Data!B2 > 0,Data!B2,\"\")","v":"date"}]
[]
[null,"Enter early time cut-off for least-squares model fit"]
[null,null,"Timecut (min):",null,20,"<-  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 (m):",null,null,7.0000000000000007E-2,null,null,null,null,null,null,null,null,null,"(min)",null,null,null,null,"Index","Time (min)","G( )",null,"(min)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O8>0,1,0)","v":0},{"$f":"IF(Data!B23>E$6,Data!B23-E$6,0)","v":0},{"$f":"IF(N8>0,Data!J23/'CB&P'!E$7,0)","v":0},{"$f":"IF(N8>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O8/Data!V$23^2,'CB&P'!Q$2),0)","v":0},{"$f":"N8*(P8-Q8)^2","v":0},null,0,{"$f":"EXP(LN(J$15)+(LN(J$16)-LN(J$15))*T8/100)","v":3.0000000000000004},{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U8/Data!V$23^2,0.00001)","v":0.92910762068371011},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,3.1330499620379677,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U9/Data!V$23^2,0.00001)","v":0.927406997111206},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,3.2720006882087023,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U10/Data!V$23^2,0.00001)","v":0.92565582752018394},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Root-Mean-Square Error:",null,null,{"$f":"SQRT(SUM(R8:R48))","v":0.41940588661533679},"<-- 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,3.4171138773268255,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U11/Data!V$23^2,0.00001)","v":0.92385303484904102},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,3.5686628345460734,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U12/Data!V$23^2,0.00001)","v":0.92199752599598361},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Trial Tn (m2/d):",null,null,0.26588791034086756,"<-- 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,3.7269329861002931,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U13/Data!V$23^2,0.00001)","v":0.92008819073484405},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"IF(E9=\"d\",0.025*SQRT(E13)*3.28,E9)","v":4.2282742450460722E-2},"<-- Working Sn",null,"Add constraint Tn > 0.00001",null,null,null,null,null,0,{"$f":"IF(Data!B29>E$6,Data!B29-E$6,0)","v":0},{"$f":"IF(N14>0,Data!J29/'CB&P'!E$7,0)","v":0},{"$f":"IF(N14>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O14/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,6,3.8922224168731896,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U14/Data!V$23^2,0.00001)","v":0.91812390056744797},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Model Result:",null,"Tn (m2/d) =",{"$f":"E13","v":0.26588791034086756},null,null,null,"Tmin",3,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,4.0648424318092902,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U15/Data!V$23^2,0.00001)","v":0.91610350752250191},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,"Tmax",230,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,4.2451181422234718,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U16/Data!V$23^2,0.00001)","v":0.91402584291256095},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,4.4333890781133114,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U17/Data!V$23^2,0.00001)","v":0.91188971606203628},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Data!B33>E$6,Data!B33-E$6,0)","v":5},{"$f":"IF(N18>0,Data!J33/'CB&P'!E$7,0)","v":1.0714285714285663},{"$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.90565375895550726},2.7481288450477887E-2,null,10,4.6300098276274824,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U18/Data!V$23^2,0.00001)","v":0.90969391302053726},null,5,1.0714285714285663]
[null,null,null,null,null,null,null,null,null,"J-Ratio",null,null,null,1,{"$f":"IF(Data!B34>E$6,Data!B34-E$6,0)","v":10},{"$f":"IF(N19>0,Data!J34/'CB&P'!E$7,0)","v":1.0285714285714218},{"$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.85931691909062768},2.8647088979584227E-2,null,11,4.835350704894565,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U19/Data!V$23^2,0.00001)","v":0.90743719527708466},null,10,1.0285714285714218]
[null,null,null,null,null,null,null,null,null,{"$f":"Figures!U27","v":-0.18823529411764706},null,null,null,1,{"$f":"IF(Data!B35>E$6,Data!B35-E$6,0)","v":20},{"$f":"IF(N20>0,Data!J35/'CB&P'!E$7,0)","v":0.98571428571427733},{"$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.79040576376702354},3.8145418745220913E-2,null,12,5.0497984474700583,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U20/Data!V$23^2,0.00001)","v":0.90511829849166014},null,20,0.98571428571427733]
[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":32},{"$f":"IF(N21>0,Data!J36/'CB&P'!E$7,0)","v":0.90000000000000113},{"$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.72702679155698402},2.9919730839071446E-2,null,13,5.2737569447151511,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U21/Data!V$23^2,0.00001)","v":0.90273593126149365},null,32,0.90000000000000113]
[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":50},{"$f":"IF(N22>0,Data!J37/'CB&P'!E$7,0)","v":0.77142857142856758},{"$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.65237923689944866},1.4172744051826067E-2,null,14,5.50764799847909,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U22/Data!V$23^2,0.00001)","v":0.90028877393998297},null,50,0.77142857142856758]
[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":60},{"$f":"IF(N23>0,Data!J38/'CB&P'!E$7,0)","v":0.7285714285714231},{"$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.61771756853020732},1.2288578286037457E-2,null,15,5.7519121175177981,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U23/Data!V$23^2,0.00001)","v":0.89777547752660658},null,60,0.7285714285714231]
[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":70},{"$f":"IF(N24>0,Data!J39/'CB&P'!E$7,0)","v":0.68571428571427862},{"$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.58660422937878531},9.8228032668246559E-3,null,16,6.0070093471449519,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U24/Data!V$23^2,0.00001)","v":0.89519466264624514},null,70,0.68571428571427862]
[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":81},{"$f":"IF(N25>0,Data!J40/'CB&P'!E$7,0)","v":0.64285714285713413},{"$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.55572043836088414},7.5928052704667941E-3,null,17,6.2734201356780694,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U25/Data!V$23^2,0.00001)","v":0.89254491863623098},null,81,0.64285714285713413]
[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":100},{"$f":"IF(N26>0,Data!J41/'CB&P'!E$7,0)","v":0.55714285714285783},{"$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.50897109364141924},2.3205187988385311E-3,null,18,6.5516462393114647,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U26/Data!V$23^2,0.00001)","v":0.88982480275905096},null,100,0.55714285714285783]
[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":120},{"$f":"IF(N27>0,Data!J42/'CB&P'!E$7,0)","v":0.51428571428571346},{"$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.46685801762806678},{"$f":"N27*(P27-Q27)^2","v":2.2493864102497499E-3},null,19,6.842211667120325,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U27/Data!V$23^2,0.00001)","v":0.88703283955800472},null,120,0.51428571428571346]
[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":150},{"$f":"IF(N28>0,Data!J43/'CB&P'!E$7,0)","v":0.42857142857142444},{"$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.41396702840733951},{"$f":"N28*(P28-Q28)^2","v":2.1328850415272392E-4},null,20,7.1456636679756889,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U28/Data!V$23^2,0.00001)","v":0.88416752037228907},null,150,0.42857142857142444]
[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":181},{"$f":"IF(N29>0,Data!J44/'CB&P'!E$7,0)","v":0.38571428571427996},{"$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.36905505444310588},2.7752998654646436E-4,null,21,7.4625737612291028,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U29/Data!V$23^2,0.00001)","v":0.88122730302692509},null,181,0.38571428571427996]
[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":206},{"$f":"IF(N30>0,Data!J45/'CB&P'!E$7,0)","v":0.28571428571428464},{"$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.33834617850088111},2.7701161382997852E-3,null,22,7.7935388131081238,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U30/Data!V$23^2,0.00001)","v":0.87821061171172421},null,206,0.28571428571428464]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B46>E$6,Data!B46-E$6,0)","v":0},{"$f":"IF(N31>0,Data!J46/'CB&P'!E$7,0)","v":0},{"$f":"IF(N31>0,G(E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!O31/Data!V$23^2,'CB&P'!Q$2),0)","v":0},0,null,23,8.1391821608499431,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U31/Data!V$23^2,0.00001)","v":0.87511583706217144},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(Data!B47>E$6,Data!B47-E$6,0)","v":0},{"$f":"IF(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,8.5001547866903344,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U32/Data!V$23^2,0.00001)","v":0.87194133645364469},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,8.8771365439190042,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U33/Data!V$23^2,0.00001)","v":0.86868543451891611},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,9.2708374373104245,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U34/Data!V$23^2,0.00001)","v":0.86534642389741623},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,9.681998960341863,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U35/Data!V$23^2,0.00001)","v":0.86192256622326757},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,10.111395491716904,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U36/Data!V$23^2,0.00001)","v":0.85841209335778268},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,10.559835753824835,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U37/Data!V$23^2,0.00001)","v":0.85481320887086054},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,11.028164335882694,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U38/Data!V$23^2,0.00001)","v":0.85112405964920856},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,11.517263284628575,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U39/Data!V$23^2,0.00001)","v":0.84734286894281874},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":12.028053765562277},{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U40/Data!V$23^2,0.00001)","v":0.84346772271825576},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,12.56149779786184,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U41/Data!V$23^2,0.00001)","v":0.83949673232761102},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,13.118600066243676,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U42/Data!V$23^2,0.00001)","v":0.83542799177531668},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,13.700409813178682,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U43/Data!V$23^2,0.00001)","v":0.83125958080886875},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,14.308022815028014,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U44/Data!V$23^2,0.00001)","v":0.82698956825842562},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,14.942583445820629,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U45/Data!V$23^2,0.00001)","v":0.82261601562808617},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,15.605286832559161,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U46/Data!V$23^2,0.00001)","v":0.81813698094240339},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,16.297381106113683,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U47/Data!V$23^2,0.00001)","v":0.81355052285233731},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,17.020169751942593,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U48/Data!V$23^2,0.00001)","v":0.80885470500550927},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,17.775014065067825,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U49/Data!V$23^2,0.00001)","v":0.80404760068616199}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,18.56333571392836,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U50/Data!V$23^2,0.00001)","v":0.79912729773078228}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,19.38661941794043,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U51/Data!V$23^2,0.00001)","v":0.79409190372570315}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,20.246415743807585,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U52/Data!V$23^2,0.00001)","v":0.78893955149337658}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,21.144344025847097,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U53/Data!V$23^2,0.00001)","v":0.7836684048741891}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,22.082095415832644,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U54/Data!V$23^2,0.00001)","v":0.77827666481077629}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,23.061436068097755,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U55/Data!V$23^2,0.00001)","v":0.77276257574168838}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,24.084210465898217,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U56/Data!V$23^2,0.00001)","v":0.76712443231102145}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,25.152344895298928,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U57/Data!V$23^2,0.00001)","v":0.76136058640010684}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,26.2678510731274,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U58/Data!V$23^2,0.00001)","v":0.75546945448671288}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,27.432829935826916,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U59/Data!V$23^2,0.00001)","v":0.74944952533621734}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,28.649475596345521,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U60/Data!V$23^2,0.00001)","v":0.74329936802804819}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,29.920079476512655,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U61/Data!V$23^2,0.00001)","v":0.73701764031922967}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,31.247034622686964,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U62/Data!V$23^2,0.00001)","v":0.73060309734509021}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,32.632840212802826,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U63/Data!V$23^2,0.00001)","v":0.72405460065522576}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,34.080106263304302,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U64/Data!V$23^2,0.00001)","v":0.71737112758042754}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,35.591558544831827,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U65/Data!V$23^2,0.00001)","v":0.7105517809237526}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,37.170043715919128,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U66/Data!V$23^2,0.00001)","v":0.70359579896593372}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,38.818534684369986,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U67/Data!V$23^2,0.00001)","v":0.69650256577218739}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,40.540136206411653,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U68/Data!V$23^2,0.00001)","v":0.68927162178395185}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,42.338090734170663,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U69/Data!V$23^2,0.00001)","v":0.68190267467526966}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,44.215784522484491,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U70/Data!V$23^2,0.00001)","v":0.67439561044947915}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,46.176754006549636,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U71/Data!V$23^2,0.00001)","v":0.66675050474743758}]
[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":48.224692462418943},{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U72/Data!V$23^2,0.00001)","v":0.65896763433386052}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,50.363456962891462,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U73/Data!V$23^2,0.00001)","v":0.65104748872335905}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,52.597075641895941,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U74/Data!V$23^2,0.00001)","v":0.64299078190257486}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,54.929755281050078,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U75/Data!V$23^2,0.00001)","v":0.63479846409928353}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68,57.365889232682903,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U76/Data!V$23^2,0.00001)","v":0.62647171884136899}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69,59.910065694243769,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U77/Data!V$23^2,0.00001)","v":0.6180120397598925}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,62.567076349680882,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U78/Data!V$23^2,0.00001)","v":0.60942113243863749}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,71,65.341925394064731,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U79/Data!V$23^2,0.00001)","v":0.60070100967015527}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72,68.239838958454101,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U80/Data!V$23^2,0.00001)","v":0.59185397753501856}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73,71.266274952753832,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U81/Data!V$23^2,0.00001)","v":0.58288264621738251}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74,74.426933345104217,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U82/Data!V$23^2,0.00001)","v":0.57378994031517128}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,77.727766897160393,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U83/Data!V$23^2,0.00001)","v":0.56457910855743731}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,76,81.174992375481409,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U84/Data!V$23^2,0.00001)","v":0.55525373283315993}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,77,84.775102260144806,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U85/Data!V$23^2,0.00001)","v":0.54581773642801379}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78,88.534876972637122,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U86/Data!V$23^2,0.00001)","v":0.53627539135861846}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79,92.461397646052234,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U87/Data!V$23^2,0.00001)","v":0.52663132468756146}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,96.562059461647166,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U88/Data!V$23^2,0.00001)","v":0.51689052369727639}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81,100.84458557687381,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U89/Data!V$23^2,0.00001)","v":0.50705833979663939}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82,105.31704167111972,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U90/Data!V$23^2,0.00001)","v":0.49714049103109592}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,83,109.98785113655084,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U91/Data!V$23^2,0.00001)","v":0.48714306306532323}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,84,114.86581094266936,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U92/Data!V$23^2,0.00001)","v":0.47707250850694305}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,85,119.96010820446357,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U93/Data!V$23^2,0.00001)","v":0.46693564444081886}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,86,125.28033748535495,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U94/Data!V$23^2,0.00001)","v":0.45673964804605888}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,87,130.83651886753174,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U95/Data!V$23^2,0.00001)","v":0.44649205017219024}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,88,136.63911682369996,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U96/Data!V$23^2,0.00001)","v":0.43620099834912807}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,89,142.69905992579814,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U97/Data!V$23^2,0.00001)","v":0.42587415694927511}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,149.02776142779189,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U98/Data!V$23^2,0.00001)","v":0.41552033127061738}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,91,155.63714076131546,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U99/Data!V$23^2,0.00001)","v":0.40514835786738451}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,92,162.5396459846458,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U100/Data!V$23^2,0.00001)","v":0.39476736046198835}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,93,169.74827722728631,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U101/Data!V$23^2,0.00001)","v":0.38438672917976863}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94,177.27661117431998,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U102/Data!V$23^2,0.00001)","v":0.37401609717447348}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95,185.1388266366408,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U103/Data!V$23^2,0.00001)","v":0.36366531463369661}]
[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":193.349731255227},{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U104/Data!V$23^2,0.00001)","v":0.35334442017843581}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97,201.92478938974679,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U105/Data!V$23^2,0.00001)","v":0.34306360969831751}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98,210.88015124402349,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U106/Data!V$23^2,0.00001)","v":0.33283320269355637}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99,220.23268328321629,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U107/Data!V$23^2,0.00001)","v":0.32266360622630191}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,230.00000000000006,{"$f":"G('CB&P'!E$14,((-J$20)*'CB&P'!E$13/1440)*'CB&P'!U108/Data!V$23^2,0.00001)","v":0.31256527661730726}]

{"sheet":"B&R Type Curve","index":6,"n_rows":56,"n_cols":30,"rows_kept":56,"cut":false,"hidden":false,"merged":[[4,3,4,4]]}
["Bouwer and Rice Short Term LNAPL Mobility Test Type Curves"]
[{"$f":"CONCATENATE(\"B&R Type Curves:  Casing Rad. (m) = \",Data!B6,\" ;  Borehole Rad. (m) = \",Data!B7)","v":"B&R Type Curves:  Casing Rad. (m) = 0.052 ;  Borehole Rad. (m) = 0.152"}]
[]
[]
[null,null,null,"Enter these values"]
["Type Curve ID","Type Curve Name","Notes","Max Time (min)","Transmissivity (ft2/day)"]
[1,{"$f":"CONCATENATE(\"T=\",E7,\" m2/day\")","v":"T=2 m2/day"},null,50,2,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=1.25 m2/day",null,100,1.25,null,{"$f":"Figures!U27","v":-0.18823529411764706},"<--  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=0.8 m2/day",null,150,0.8,null,null,{"$f":"-(1-Data!B9)","v":-0.21999999999999997},null,null,null,{"$f":"E7","v":2},null,null,{"$f":"E8","v":1.25},null,null,{"$f":"E9","v":0.8},null,null,{"$f":"E10","v":0.4},null,null,{"$f":"E11","v":0.2},null,null,{"$f":"E12","v":0.1},null,null,{"$f":"E13","v":0.05}]
[4,"T=0.4 m2/day",null,200,0.4]
[5,"T=0.2 m2/day",null,200,0.2,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.1 m2/day",null,200,0.1,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.05 m2/day",null,200,0.05,null,null,null,null,null,{"$f":"(K$42-K$12)/30+K12","v":1.6666666666666667},{"$f":"EXP(-(2*L$9*(K13/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.92643370423680049},null,{"$f":"(N$42-N$12)/30+N12","v":3.3333333333333335},{"$f":"EXP(-(2*O$9*(N13/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.90890382944110781},null,{"$f":"(Q$42-Q$12)/30+Q12","v":5},{"$f":"EXP(-(2*R$9*(Q13/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.91238306557472282},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.94070072180184239},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.96989727383978264},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.98483362749237124},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.99238784126588897}]
[null,null,null,null,null,null,null,null,null,null,3.3333333333333335,{"$f":"EXP(-(2*L$9*(K14/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.85827940834591943},null,6.666666666666667,{"$f":"EXP(-(2*O$9*(N14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.82610617117271046},null,10,{"$f":"EXP(-(2*R$9*(Q14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.83244285834752885},null,13.333333333333334,{"$f":"EXP(-(2*U$9*(T14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.88491784799850737},null,13.333333333333334,{"$f":"EXP(-(2*X$9*(W14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.94070072180184239},null,13.333333333333334,{"$f":"EXP(-(2*AA$9*(Z14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.96989727383978264},null,13.333333333333334,{"$f":"EXP(-(2*AD$9*(AC14/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.98483362749237124}]
[null,null,null,null,null,null,null,null,null,null,5,{"$f":"EXP(-(2*L$9*(K15/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.79513897154407964},null,10,{"$f":"EXP(-(2*O$9*(N15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.75085106250380784},null,15,{"$f":"EXP(-(2*R$9*(Q15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.75950676701490316},null,20,{"$f":"EXP(-(2*U$9*(T15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.83244285834752885},null,20,{"$f":"EXP(-(2*X$9*(W15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.91238306557472282},null,20,{"$f":"EXP(-(2*AA$9*(Z15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.95518745049059495},null,20,{"$f":"EXP(-(2*AD$9*(AC15/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.97733691759320895}]
[null,null,null,null,null,null,null,null,null,null,6.666666666666667,{"$f":"EXP(-(2*L$9*(K16/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.7366435427906215},null,13.333333333333334,{"$f":"EXP(-(2*O$9*(N16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.6824514060496355},null,20,{"$f":"EXP(-(2*R$9*(Q16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.69296111241380409},null,26.666666666666668,{"$f":"EXP(-(2*U$9*(T16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.7830795977063093},null,26.666666666666668,{"$f":"EXP(-(2*X$9*(W16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.88491784799850737},null,26.666666666666668,{"$f":"EXP(-(2*AA$9*(Z16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.94070072180184239},null,26.666666666666668,{"$f":"EXP(-(2*AD$9*(AC16/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.96989727383978264}]
[null,null,null,null,null,null,null,null,null,null,8.3333333333333339,{"$f":"EXP(-(2*L$9*(K17/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.6824514060496355},null,16.666666666666668,{"$f":"EXP(-(2*O$9*(N17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.62028269636598221},null,25,{"$f":"EXP(-(2*R$9*(Q17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.63224598406817667},null,33.333333333333336,{"$f":"EXP(-(2*U$9*(T17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.7366435427906215},null,33.333333333333336,{"$f":"EXP(-(2*X$9*(W17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.85827940834591943},null,33.333333333333336,{"$f":"EXP(-(2*AA$9*(Z17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.92643370423680049},null,33.333333333333336,{"$f":"EXP(-(2*AD$9*(AC17/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.96251426183553268}]
[null,null,null,null,null,null,null,null,null,null,10,{"$f":"EXP(-(2*L$9*(K18/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.63224598406817667},null,20,{"$f":"EXP(-(2*O$9*(N18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.56377731806309717},null,30,{"$f":"EXP(-(2*R$9*(Q18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.57685052914143042},null,40,{"$f":"EXP(-(2*U$9*(T18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.69296111241380409},null,40,{"$f":"EXP(-(2*X$9*(W18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.83244285834752885},null,40,{"$f":"EXP(-(2*AA$9*(Z18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.91238306557472282},null,40,{"$f":"EXP(-(2*AD$9*(AC18/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.95518745049059495}]
[null,null,null,null,null,null,null,null,null,null,11.666666666666666,{"$f":"EXP(-(2*L$9*(K19/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.5857339890091221},null,23.333333333333332,{"$f":"EXP(-(2*O$9*(N19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.51241936333958649},null,35,{"$f":"EXP(-(2*R$9*(Q19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.52630865415645922},null,46.666666666666664,{"$f":"EXP(-(2*U$9*(T19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.65186901862827318},null,46.666666666666664,{"$f":"EXP(-(2*X$9*(W19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.80738405893866472},null,46.666666666666664,{"$f":"EXP(-(2*AA$9*(Z19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.89854552413256428},null,46.666666666666664,{"$f":"EXP(-(2*AD$9*(AC19/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.94791641199662979}]
[null,null,null,null,null,null,null,null,null,null,13.333333333333332,{"$f":"EXP(-(2*L$9*(K20/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.54264370913511828},null,26.666666666666664,{"$f":"EXP(-(2*O$9*(N20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.46573992161912459},null,40,{"$f":"EXP(-(2*R$9*(Q20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.48019510331777676},null,53.333333333333329,{"$f":"EXP(-(2*U$9*(T20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.61321365634387515},null,53.333333333333329,{"$f":"EXP(-(2*X$9*(W20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.7830795977063093},null,53.333333333333329,{"$f":"EXP(-(2*AA$9*(Z20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.88491784799850737},null,53.333333333333329,{"$f":"EXP(-(2*AD$9*(AC20/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.94070072180184239}]
[null,null,null,null,null,null,null,null,null,null,14.999999999999998,{"$f":"EXP(-(2*L$9*(K21/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.50272342153484451},null,29.999999999999996,{"$f":"EXP(-(2*O$9*(N21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.42331279828322382},null,45,{"$f":"EXP(-(2*R$9*(Q21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.43812188043904393},null,59.999999999999993,{"$f":"EXP(-(2*U$9*(T21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.57685052914143042},null,59.999999999999993,{"$f":"EXP(-(2*X$9*(W21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.75950676701490316},null,59.999999999999993,{"$f":"EXP(-(2*AA$9*(Z21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.87149685427711276},null,59.999999999999993,{"$f":"EXP(-(2*AD$9*(AC21/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.93353995858619399}]
[null,null,null,null,null,null,null,null,null,null,16.666666666666664,{"$f":"EXP(-(2*L$9*(K22/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.46573992161912464},null,33.333333333333329,{"$f":"EXP(-(2*O$9*(N22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.38475062341105337},null,50,{"$f":"EXP(-(2*R$9*(Q22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.39973498437033711},null,66.666666666666657,{"$f":"EXP(-(2*U$9*(T22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.54264370913511839},null,66.666666666666657,{"$f":"EXP(-(2*X$9*(W22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.73664354279062161},null,66.666666666666657,{"$f":"EXP(-(2*AA$9*(Z22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.85827940834591954},null,66.666666666666657,{"$f":"EXP(-(2*AD$9*(AC22/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.92643370423680049}]
[null,null,null,null,null,null,null,null,null,null,18.333333333333332,{"$f":"EXP(-(2*L$9*(K23/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.43147716079656268},null,36.666666666666664,{"$f":"EXP(-(2*O$9*(N23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.34970131499815993},null,55,{"$f":"EXP(-(2*R$9*(Q23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.36471143045727206},null,73.333333333333329,{"$f":"EXP(-(2*U$9*(T23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.5104653288646348},null,73.333333333333329,{"$f":"EXP(-(2*X$9*(W23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.71446856394430314},null,73.333333333333329,{"$f":"EXP(-(2*AA$9*(Z23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.84526242312331801},null,73.333333333333329,{"$f":"EXP(-(2*AD$9*(AC23/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.91938154382351944}]
[null,null,null,null,null,null,null,null,null,null,20,{"$f":"EXP(-(2*L$9*(K24/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.39973498437033717},null,40,{"$f":"EXP(-(2*O$9*(N24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.3178448643624186},null,60,{"$f":"EXP(-(2*R$9*(Q24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.33275653297074825},null,80,{"$f":"EXP(-(2*U$9*(T24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.48019510331777676},null,80,{"$f":"EXP(-(2*X$9*(W24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.69296111241380409},null,80,{"$f":"EXP(-(2*AA$9*(Z24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.83244285834752885},null,80,{"$f":"EXP(-(2*AD$9*(AC24/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.91238306557472282}]
[null,null,null,null,null,null,null,null,null,null,21.666666666666668,{"$f":"EXP(-(2*L$9*(K25/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.37032796228325093},null,43.333333333333336,{"$f":"EXP(-(2*O$9*(N25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.28889041438719182},null,65,{"$f":"EXP(-(2*R$9*(Q25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.30360142564186759},null,86.666666666666671,{"$f":"EXP(-(2*U$9*(T25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.45171988029674293},null,86.666666666666671,{"$f":"EXP(-(2*X$9*(W25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.67210109380713179},null,86.666666666666671,{"$f":"EXP(-(2*AA$9*(Z25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.81981771986651508},null,86.666666666666671,{"$f":"EXP(-(2*AD$9*(AC25/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.90543786085325317}]
[null,null,null,null,null,null,null,null,null,null,23.333333333333336,{"$f":"EXP(-(2*L$9*(K26/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.34308430588053829},null,46.666666666666671,{"$f":"EXP(-(2*O$9*(N26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.26257360392534707},null,70,{"$f":"EXP(-(2*R$9*(Q26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.2770007994399834},null,93.333333333333343,{"$f":"EXP(-(2*U$9*(T26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.42493321744738788},null,93.333333333333343,{"$f":"EXP(-(2*X$9*(W26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.65186901862827318},null,93.333333333333343,{"$f":"EXP(-(2*AA$9*(Z26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.80738405893866461},null,93.333333333333343,{"$f":"EXP(-(2*AD$9*(AC26/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.89854552413256428}]
[null,null,null,null,null,null,null,null,null,null,25.000000000000004,{"$f":"EXP(-(2*L$9*(K27/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.3178448643624186},null,50.000000000000007,{"$f":"EXP(-(2*O$9*(N27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.23865415411790075},null,75,{"$f":"EXP(-(2*R$9*(Q27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.25273083855970097},null,100.00000000000001,{"$f":"EXP(-(2*U$9*(T27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.39973498437033711},null,100.00000000000001,{"$f":"EXP(-(2*X$9*(W27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.63224598406817667},null,100.00000000000001,{"$f":"EXP(-(2*AA$9*(Z27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.79513897154407964},null,100.00000000000001,{"$f":"EXP(-(2*AD$9*(AC27/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.89170565297304227}]
[null,null,null,null,null,null,null,null,null,null,26.666666666666671,{"$f":"EXP(-(2*L$9*(K28/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.29446219506391885},null,53.333333333333343,{"$f":"EXP(-(2*O$9*(N28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.21691367458978825},null,80,{"$f":"EXP(-(2*R$9*(Q28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.23058733725037031},null,106.66666666666669,{"$f":"EXP(-(2*U$9*(T28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.37603098832662429},null,106.66666666666669,{"$f":"EXP(-(2*X$9*(W28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.61321365634387515},null,106.66666666666669,{"$f":"EXP(-(2*AA$9*(Z28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.7830795977063093},null,106.66666666666669,{"$f":"EXP(-(2*AD$9*(AC28/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.88491784799850737}]
[null,null,null,null,null,null,null,null,null,null,28.333333333333339,{"$f":"EXP(-(2*L$9*(K29/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.2727997021307656},null,56.666666666666679,{"$f":"EXP(-(2*O$9*(N29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.19715366949280086},null,85,{"$f":"EXP(-(2*R$9*(Q29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.2103839816432054},null,113.33333333333336,{"$f":"EXP(-(2*U$9*(T29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.35373262213871559},null,113.33333333333336,{"$f":"EXP(-(2*X$9*(W29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.59475425356924982},null,113.33333333333336,{"$f":"EXP(-(2*AA$9*(Z29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.77120312082437137},null,113.33333333333336,{"$f":"EXP(-(2*AD$9*(AC29/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.8781817128728947}]
[null,null,null,null,null,null,null,null,null,null,30.000000000000007,{"$f":"EXP(-(2*L$9*(K30/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.25273083855970097},null,60.000000000000014,{"$f":"EXP(-(2*O$9*(N30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.17919372519037313},null,90,{"$f":"EXP(-(2*R$9*(Q30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.19195078211944391},null,120.00000000000003,{"$f":"EXP(-(2*U$9*(T30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.33275653297074814},null,120.00000000000003,{"$f":"EXP(-(2*X$9*(W30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.57685052914143031},null,120.00000000000003,{"$f":"EXP(-(2*AA$9*(Z30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.75950676701490305},null,120.00000000000003,{"$f":"EXP(-(2*AD$9*(AC30/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.87149685427711276}]
[null,null,null,null,null,null,null,null,null,null,31.666666666666675,{"$f":"EXP(-(2*L$9*(K31/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.23413836694173651},null,63.33333333333335,{"$f":"EXP(-(2*O$9*(N31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.16286986303734763},null,95,{"$f":"EXP(-(2*R$9*(Q31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.17513264302960388},null,126.6666666666667,{"$f":"EXP(-(2*U$9*(T31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.31302431074986126},null,126.6666666666667,{"$f":"EXP(-(2*X$9*(W31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.55948575562730929},null,126.6666666666667,{"$f":"EXP(-(2*AA$9*(Z31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.74798780446429025},null,126.6666666666667,{"$f":"EXP(-(2*AD$9*(AC31/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.86486288188607696}]
[null,null,null,null,null,null,null,null,null,null,33.333333333333343,{"$f":"EXP(-(2*L$9*(K32/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.21691367458978819},null,66.666666666666686,{"$f":"EXP(-(2*O$9*(N32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.14803304221519403},null,100,{"$f":"EXP(-(2*R$9*(Q32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.15978805772955365},null,133.33333333333337,{"$f":"EXP(-(2*U$9*(T32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.29446219506391874},null,133.33333333333337,{"$f":"EXP(-(2*X$9*(W32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.54264370913511817},null,133.33333333333337,{"$f":"EXP(-(2*AA$9*(Z32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.7366435427906215},null,133.33333333333337,{"$f":"EXP(-(2*AD$9*(AC32/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.85827940834591943}]
[null,null,null,null,null,null,null,null,null,null,35.000000000000007,{"$f":"EXP(-(2*L$9*(K33/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.20095613904983342},null,70.000000000000014,{"$f":"EXP(-(2*O$9*(N33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.13454779895320709},null,105,{"$f":"EXP(-(2*R$9*(Q33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.14578791795352092},null,140.00000000000003,{"$f":"EXP(-(2*U$9*(T33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.27700079943998335},null,140.00000000000003,{"$f":"EXP(-(2*X$9*(W33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.52630865415645911},null,140.00000000000003,{"$f":"EXP(-(2*AA$9*(Z33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.72547133241531958},null,140.00000000000003,{"$f":"EXP(-(2*AD$9*(AC33/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.85174604925137143}]
[null,null,null,null,null,null,null,null,null,null,36.666666666666671,{"$f":"EXP(-(2*L$9*(K34/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.1861725402890628},null,73.333333333333343,{"$f":"EXP(-(2*O$9*(N34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.1222910097114422},null,110,{"$f":"EXP(-(2*R$9*(Q34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.13301442750618958},null,146.66666666666669,{"$f":"EXP(-(2*U$9*(T34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.26057485197287977},null,146.66666666666669,{"$f":"EXP(-(2*X$9*(W34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.5104653288646348},null,146.66666666666669,{"$f":"EXP(-(2*AA$9*(Z34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.71446856394430314},null,146.66666666666669,{"$f":"EXP(-(2*AD$9*(AC34/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.84526242312331801}]
[null,null,null,null,null,null,null,null,null,null,38.333333333333336,{"$f":"EXP(-(2*L$9*(K35/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.17247651612717144},null,76.666666666666671,{"$f":"EXP(-(2*O$9*(N35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.11115076703294953},null,115,{"$f":"EXP(-(2*R$9*(Q35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.12136011113376403},null,153.33333333333334,{"$f":"EXP(-(2*U$9*(T35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.24512295133429618},null,153.33333333333334,{"$f":"EXP(-(2*X$9*(W35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.49509893085553741},null,153.33333333333334,{"$f":"EXP(-(2*AA$9*(Z35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.70363266755853326},null,153.33333333333334,{"$f":"EXP(-(2*AD$9*(AC35/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.838828151386524}]
[null,null,null,null,null,null,null,null,null,null,40,{"$f":"EXP(-(2*L$9*(K36/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.15978805772955368},null,80,{"$f":"EXP(-(2*O$9*(N36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.10102535780156426},null,120,{"$f":"EXP(-(2*R$9*(Q36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.11072691023471268},null,160,{"$f":"EXP(-(2*U$9*(T36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.23058733725037031},null,160,{"$f":"EXP(-(2*X$9*(W36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.48019510331777676},null,160,{"$f":"EXP(-(2*AA$9*(Z36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.69296111241380409},null,160,{"$f":"EXP(-(2*AD$9*(AC36/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.83244285834752885}]
[null,null,null,null,null,null,null,null,null,null,41.666666666666664,{"$f":"EXP(-(2*L$9*(K37/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.14803304221519414},null,83.333333333333329,{"$f":"EXP(-(2*O$9*(N37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":9.1822334576499937E-2},null,125,{"$f":"EXP(-(2*R$9*(Q37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.10102535780156426},null,166.66666666666666,{"$f":"EXP(-(2*U$9*(T37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.21691367458978833},null,166.66666666666666,{"$f":"EXP(-(2*X$9*(W37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.46573992161912459},null,166.66666666666666,{"$f":"EXP(-(2*AA$9*(Z37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.68245140604963561},null,166.66666666666666,{"$f":"EXP(-(2*AD$9*(AC37/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.82610617117271046}]
[null,null,null,null,null,null,null,null,null,null,43.333333333333329,{"$f":"EXP(-(2*L$9*(K38/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.13714279964886497},null,86.666666666666657,{"$f":"EXP(-(2*O$9*(N38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":8.3457671524803392E-2},null,130,{"$f":"EXP(-(2*R$9*(Q38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":9.2173825651774441E-2},null,173.33333333333331,{"$f":"EXP(-(2*U$9*(T38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.20405085025530381},null,173.33333333333331,{"$f":"EXP(-(2*X$9*(W38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.45171988029674298},null,173.33333333333331,{"$f":"EXP(-(2*AA$9*(Z38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.67210109380713179},null,173.33333333333331,{"$f":"EXP(-(2*AD$9*(AC38/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.81981771986651508}]
[null,null,null,null,null,null,null,null,null,null,44.999999999999993,{"$f":"EXP(-(2*L$9*(K39/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.12705371188810338},null,89.999999999999986,{"$f":"EXP(-(2*O$9*(N39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":7.5854997245131936E-2},null,135,{"$f":"EXP(-(2*R$9*(Q39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":8.4097837613915954E-2},null,179.99999999999997,{"$f":"EXP(-(2*U$9*(T39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.19195078211944397},null,179.99999999999997,{"$f":"EXP(-(2*X$9*(W39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.43812188043904399},null,179.99999999999997,{"$f":"EXP(-(2*AA$9*(Z39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.66190775825566817},null,179.99999999999997,{"$f":"EXP(-(2*AD$9*(AC39/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.81357713724985425}]
[null,null,null,null,null,null,null,null,null,null,46.666666666666657,{"$f":"EXP(-(2*L$9*(K40/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.11770684094153085},null,93.333333333333314,{"$f":"EXP(-(2*O$9*(N40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":6.8944897478345132E-2},null,140,{"$f":"EXP(-(2*R$9*(Q40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":7.672944289038991E-2},null,186.66666666666663,{"$f":"EXP(-(2*U$9*(T40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.1805682392901892},null,186.66666666666663,{"$f":"EXP(-(2*X$9*(W40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.4249332174473881},null,186.66666666666663,{"$f":"EXP(-(2*AA$9*(Z40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.65186901862827329},null,186.66666666666663,{"$f":"EXP(-(2*AD$9*(AC40/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.80738405893866472}]
[null,null,null,null,null,null,null,null,null,null,48.333333333333321,{"$f":"EXP(-(2*L$9*(K41/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.10904758466747433},null,96.666666666666643,{"$f":"EXP(-(2*O$9*(N41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":6.2664281338492472E-2},null,145,{"$f":"EXP(-(2*R$9*(Q41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":7.0006644324174555E-2},null,193.33333333333329,{"$f":"EXP(-(2*U$9*(T41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!J$12)))","v":0.16986067303476879},null,193.33333333333329,{"$f":"EXP(-(2*X$9*(W41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.41214156916618927},null,193.33333333333329,{"$f":"EXP(-(2*AA$9*(Z41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.6419825302655745},null,193.33333333333329,{"$f":"EXP(-(2*AD$9*(AC41/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":0.80123812332263278}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"$D$7","v":50},{"$f":"EXP(-(2*L$9*(K42/1440)*(-G$8)/(Data!B$13^2*LN('B&R'!$J$12))))","v":0.10102535780156426},null,{"$f":"$D$8","v":100},{"$f":"EXP(-(2*O$9*(N42/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":5.6955805277730732E-2},null,{"$f":"$D$9","v":150},{"$f":"EXP(-(2*R$9*(Q42/1440)*(-G$8))/(Data!B$13^2*LN('B&R'!$J$12)))","v":6.3872876759089633E-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.15978805772955365},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.39973498437033711},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.63224598406817667},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.79513897154407964}]
[]
[]
[]
[]
[]
[]
["Field Data"]
[]
["Record Data in Fields Below",null,null,null,null,null,"Calculate and Plot Fields Below"]
["Well ID",null,"Well Dia. (ft)",null,"Total Depth (ft)"]
["Notes","Date","Time","Elapsed Time (min)","Depth To Product (TOC)","Depth to Water (TOC)","Product Thickness (ft)","Drawdown (s) DTP-DTP(initial) (ft)","Normalized Drawdown (s/sinitial)"]
["Initial Measurement"]
["Stopped Bailing/Start Gauging",null,null,0]
["Well Starts recovering"]

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

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

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