{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ProgrammerNotes","1DRFCAT-HYDM","FunctionList"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":1,"defined_names":28,"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":"1DRFCAT-HYDM","index":1,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[[2,1,2,10]]}
["Model Name","1D_radial_flow_confined_aquifer_transient"]
["Model Type:","Hydraulic Model"]
["References: ","Theis, C.V. 1935. The relation between the lowering of the piezometric surface and the rate and duration of discharge of a well using ground-water storage: American Geophysical Union Transactions, 16th Annual Meeting, v. 16, pt. 2, p. 519-524. "]
[null,"Walton, W. C. 1989.  Analytical Groundwater Modeling, Flow and Contaminant Migration, Lewis Publishers, Chelsea, MI."]
["Method: ","Polynomial approximation ot exponential integral"]
["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,"Computes Drawdown at radial distance, r, for different time values t"]
[null,"Uses Polynomial approximation to well function (see references)"]
["Macros:","W(U)","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":"B15/7.48","v":3.3422459893048124},"<=ft^3/min",{"$f":"D15*1440","v":4812.8342245989297},"<=ft^3/day",{"$f":"D15/(3.28^3)","v":9.4714589136271427E-2},"<=m^3/min",{"$f":"H15*1440","v":136.38900835623085},"<=m^3/day"]
["T",0.76,"<=ft^2/min",{"$f":"B16*1440","v":1094.4000000000001},"<=ft^2/day",{"$f":"B16*7.48","v":5.6848000000000001},"<=gpm/ft",{"$f":"D16/(3.28^2)","v":101.72516359309937},"<=m^2/day",{"$f":"H16/1440","v":7.0642474717430112E-2},"<=m^2/min"]
[]
["MODEL INPUT VALUES"]
["Input Data (must use consistent length and time units!)"]
["Item","Value","Units","Description"]
["Q",11,"ft^3/min","Pumping well discharge (L^3/t)"]
["T",0.76,"ft^2/min","Aquifer transmissivity (L^2/t)"]
["S",5.0000000000000001E-4,null,"Aquifer storage coefficient"]
["r",96,"Radial distance of observation well from pumping well (L)"]
["Computed Constants"]
["Q/(4pT)",{"$f":"B21/(4*PI()*B22)","v":1.15177919342819}]
["Chart Title",{"$f":"CONCATENATE(\"Drawdown history at \",B24,\" (feet) from pumping well \")","v":"Drawdown history at 96 (feet) from pumping well "}]
["Time","Drawdown"]
["Elapsed Time (min)","r (ft)","u = (r^2 S / 4 T t)","W(u)","Drawdown(ft) ","Observed Drawdown (ft)","Sq. Error"]
[5,96,{"$f":"(B30^2*$B$23)/(4*$B$22*A30)","v":0.30315789473684218},{"$f":"W(C30)","v":0.89793161367575303},{"$f":"$B$26*D30","v":1.034218949753132},0.96155025185460385,{"$f":"(E30-F30)^2","v":5.2807396542675486E-3}]
[28,96,{"$f":"(B31^2*$B$23)/(4*$B$22*A31)","v":5.4135338345864668E-2},{"$f":"W(C31)","v":2.3924636212598998},{"$f":"$B$26*D31","v":2.7555898200010138},2.6659802293444845,{"$f":"(E31-F31)^2","v":8.0298787376307419E-3}]
[41,96,3.6970474967907577E-2,2.7570513647840569,3.1755143971710713,3.0855088436859037,8.100999658171364E-3]
[60,96,2.5263157894736845E-2,3.1262968346253044,3.6008036466018365,3.5109705383628724,8.0699873358734339E-3]
[75,96,2.0210526315789477E-2,3.3444447830365926,3.8520619146710047,3.7625233338455732,8.0171574562323163E-3]
[244,96,6.2122519413287322E-3,4.5102187277789616,5.1947760884659697,5.1081853259300862,7.4979601565457639E-3]
[493,96,3.0746236788726381E-3,5.2104293440553233,6.0012641073106137,5.9170094618137989,7.0988452877939201E-3]
[669,96,2.2657540712768473E-3,5.5148964456300371,6.351942979987756,6.2687644111562282,6.9186743128612175E-3]
[958,96,1.5822437094824746E-3,5.8732773155049172,6.7647186092323386,6.6828359042083267,6.7047773820493352E-3]
[1129,96,1.3425947508274674E-3,6.0372776297449198,6.9536107588896581,6.8723290313452603,6.6067192326017118E-3]
[1185,96,1.279147235176549E-3,6.085624713713683,7.0092959242678052,6.9281921494756391,6.5778222855384016E-3]
[]
[null,null,null,null,null,"SSE =>",{"$f":"SUM(G30:G40)","v":7.8903561499565747E-2}]

{"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"]