{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ProgrammerNotes","1DRFLAH-HYDM","FunctionList"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":1,"defined_names":2,"comments":0,"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":"ProgrammerNotes","index":0,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["ProgrammerNotes"]
[]
["NOTE_ID","DATE","NOTE"]
[1,"2015-11-11","Put VBA functions into a code module saved with the spreadsheet"]
[2,"2015-11-11","Coded EEXP,ERFCC, and ERFF from 1996 spreadsheets (that still work -- go figure!)"]
[3,"2015-11-11","Some built-in functions need \"WorksheetFunction.NAME\" to access in VBA code"]

{"sheet":"1DRFLAH-HYDM","index":1,"n_rows":46,"n_cols":11,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Model Name","1D_radial_flow_leaky_aquifer_transient_hantush"]
["Model Type:","Hydraulic Model"]
["References: ","Hantush"]
[]
["Method: "]
["Author:","Dr. T.G. Cleveland for CIVE6361/7332 Students; Spring 1995"]
[null,"Rewrite in VBA Mac Excel 2011 Fall 2015"]
["Notes:","Infinite Confined Aquifer"]
[null,"Steady Pumping at Origin"]
[null,"Drawdown at radial distance, r, for different time values t in leaky aquifer system"]
[null,"Uses Polynomial approximation to well function (see references)"]
["Macros:","W(U),LEAKY(U,V)",null,"Well Functions contained in Module1 as local to this worksheet macros"]
[]
[]
["Conversion Calculator (Use GoalSeek to find U.S Customary values for SI Units)"]
["Q",25,"<=gpm",{"$f":"B16/7.48","v":3.3422459893048124},"<=ft^3/min",{"$f":"D16*1440","v":4812.8342245989297},"<=ft^3/day",{"$f":"D16/(3.25^3)","v":9.736174024374511E-2},"<=m^3/min",{"$f":"H16*1440","v":140.20090595099296},"<=m^3/day"]
["T",0.17219999999999999,"<=ft^2/min",{"$f":"B17*1440","v":247.96799999999999},"<=ft^2/day",{"$f":"B17*7.48","v":1.2880560000000001},"<=gpm/ft",{"$f":"D17/(3.28^2)","v":23.04878048780488},"<=m^2/day",{"$f":"H17/1440","v":1.600609756097561E-2},"<=m^2/min"]
[]
["Input Data (must use consistent length and time units!)"]
["Item","Value","Units","Description"]
["Q",3.34,"ft^3/min","Pumping well discharge (L^3/t)"]
["T",0.17,"ft^2/min","Aquifer transmissivity (L^2/t)"]
["S",1.6563911372582396E-4,null,"Aquifer storage coefficient"]
["K'",5.658357608673422E-6,"ft/min","Aquitard vertical hydraulic conductivity (L/t)"]
["b'",14,"ft","Thickness of aquitard (L)"]
["r",96,"Radial distance of observation well from pumping well (L)"]
["Computed Constants"]
["B",{"$f":"SQRT(B22*B25/B24)","v":648.54972991601153}]
["r/B",{"$f":"B26/B28","v":0.14802257339993372}]
["Q/4pT",{"$f":"B21/(4*PI()*B22)","v":1.5634632644909716}]
["Chart Title",{"$f":"CONCATENATE(\"Drawdown history at \",B26,\" (feet) from pumping well \")","v":"Drawdown history at 96 (feet) from pumping well "}]
["Time"]
["Elapsed Time (min)","Radial Distance (ft) ","u","r/B","W(u,r/B)","Drawdown (ft)","Observed Drawdown (ft)","Error^2"]
[5,96,{"$f":"(B34^2*$B$23)/(4*$B$22*A34)","v":0.44897943296976273},{"$f":"B34/$B$28","v":0.14802257339993372},{"$f":"LEAKY(C34,D34)","v":0.6223919491938279},{"$f":"$B$30*E34","v":0.97308694867948109},0.96,{"$f":"(F34-G34)^2","v":1.7126822573937278E-4}]
[28,96,8.0174898744600487E-2,0.14802257339993372,1.973923943716406,{"$f":"$B$30*E35","v":3.086157572899745},3.3,{"$f":"(F35-G35)^2","v":4.5728583628127789E-2}]
[41,96,5.4753589386556431E-2,0.14802257339993372,2.3022287866465145,3.5994501343754481,3.59,8.9305039714029306E-5]
[60,96,3.7414952747480232E-2,0.14802257339993372,2.6243590493898648,4.103088966555501,4.08,5.3310037660104224E-4]
[75,96,2.9931962197984181E-2,0.14802257339993372,2.8075081805702715,4.3894359050795053,4.3899999999999997,3.18203079327541E-7]
[244,96,9.2003982165934986E-3,0.14802257339993372,3.6297558229203637,5.6749898882081853,5.47,4.20208542676044E-2]
[493,96,4.5535439449265998E-3,0.14802257339993372,3.9286780350692445,6.1423437858433365,5.96,3.3249256235680584E-2]
[669,96,3.3556011432717696E-3,0.14802257339993372,4.0037265476578519,6.2596793783303131,6.11,2.2403916297348898E-2]
[958,96,2.3433164560008493E-3,0.14802257339993372,4.0549986137857754,6.3398413702158729,6.27,4.8778169936306787E-3]
[1129,96,1.9883943001318101E-3,0.14802257339993372,4.0680114150709663,6.3601864069933898,6.4,1.5851221880960309E-3]
[1185,96,1.8944279872141888E-3,0.14802257339993372,4.0708862923495266,6.3646811720083383,6.42,3.0601727303710491E-3]
[]
[null,null,null,null,null,null,"SSE",{"$f":"SUM(H34:H44)","v":0.1537197141859932}]

{"sheet":"FunctionList","index":2,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["List of VBA Macro functions"]
[null,null,null,"ARGUMENTS"]
["NAME","FUNCTION","REFERENCE","ARG-1","ARG-2","ARG-3","ARG-4","RESULT","REMARKS"]
["W(U)","Exponential Integral",null,1,null,null,null,{"$f":"W(D4)","v":0.21938392999999995},"Tested 11 Nov 2015 against Wenzel tabulation"]
["W(U,B)","Exponential Integral",null,1,1,null,null,{"$f":"LEAKY(D5,E5)","v":0.18407607348524879},"Tested 11 Nov 2015 against 1995 Hunt solution"]