{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["MST Calculation","Parameter Explanation","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"MST Calculation","index":0,"n_rows":9,"n_cols":20,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,15,0,19],[0,0,0,2],[0,3,0,7],[0,8,0,9],[0,10,0,12],[0,13,0,14]]}
["Well Information",null,null,"Aquifer Information",null,null,null,null,"Pumping Information          Target Well",null,"Pumping Information                                                 Neighboring Wells (Four Identical Wells)",null,null,"**Results**                          CTRL+Shift+T to run",null,"Other Calculation Products                                                                                                                              (Parameter Names Consistent with Those Presented in KGS OFR 2016-3)"]
["Well ID","Effective Radius of Well (ft)","Well Efficiency (%)","Hydraulic Conductivity (ft/day)","Specific Yield","Minimum Thickness to Test (ft)","Maximum Thickness to Test (ft)","Thickness Increments (ft)","Pumping Rate (gpm)","Duration of Pumping (days)","Distance from Target Well (ft)","Pumping Rate (gpm)","Duration of Pumping (days)","Minimum Saturated Thickness (ft)","Total Drawdown (ft)  (Stotal)","Drawdown Due to Pumping in Target Well (ft) (Saquifer)","Drawdown Due to Pumping in Target Well with Jacob Correction (ft) (Starg-jacob)","Additional Drawdown Due to Well Inefficiencies (ft) (Seff)","Drawdown Due to Pumping in Neighboring Wells (ft) (Sneighbor)","Drawdown Due to Pumping in Target and Neighboring Wells with Jacob Correction (ft) (Sall-jacob)"]
[1,1,70,25,0.1,5,165,1,400,90,2640,400,90]
[2,1,70,25,0.1,5,165,1,400,25,2640,400,90]
[3,1,70,30,5.0000000000000001E-3,5,165,1,400,90,2640,400,90]
[4,1,70,20,1E-4,5,165,1,1000,90,2640,400,90]
[5,1,65,60,1E-3,5,165,1,500,90,2640,400,90]
[6,1,70,25,5.0000000000000001E-3,5,165,1,100,90,2640,400,90]
[7,1,70,30,1E-4,5,165,1,400,90,2640,400,90]

{"sheet":"Parameter Explanation","index":1,"n_rows":57,"n_cols":2,"rows_kept":57,"cut":false,"hidden":false,"merged":[[24,0,24,1],[31,0,31,1],[56,0,56,1],[52,0,52,1]]}
["PARAMETER","DEFINITION"]
["Well ID","Any well identifier - not used for calculations"]
["Effective Radius of Well","Radius of well. Measured from center of well to outer radius of gravel pack"]
["Well Efficiency","The ratio of the theoretical drawdown in the formation to the actual drawdown in the well. \"70-80% is usually obtainable if good design, construction and development practices are followed\"1 Decreased efficiency is caused by design factors and/or construction factors, which are further described in a table below."]
["Hydraulic Conductivity","A measure of the soil/rock/formation's ability to transmit water when subjected to a hydraulic gradient. Sample values are given in a table below."]
["Specific Yield","The drainable porosity; the ratio of the volume of water that drains from a saturated rock/soil due to gravity to the total volume of the rock/soil.2 Sample values are given in a table below."]
["Minimum Thickness to Test","The smallest thickness the code will test"]
["Maximum Thickness to Test","The largest thickness the code will test."]
["Thickness Increments","The increase in thickness when current thickness does not suffice (if minimum=5ft and increment =5ft then the code will test a thickness of 5ft, then 10ft, then 15ft, etc.)"]
["Pumping Rate","Desired pumping rate; this is held constant."]
["Duration of Pumping","The amount of time the water will be pumped at the given pumping rate."]
["Distance from Target Well","4 wells are located this distance from the target well. If no neighboring wells are desired, make neighboring well pumping rate = 0 gpm."]
[]
["Causes of Decreased Well Efficiency1"]
["Design Factors:"]
["1) Well screen with insufficient open areas"]
["2) Poor distribution of screen openings"]
["3) Insufficient length of well screen"]
["4) Improperly sized filter packs that restrict flow"]
["Construction Factors:"]
["1) Inadequate development of well"]
["2) Improper placement of well screen"]
[]
["Example Hydraulic Conductivity Ranges (ft/d) adapted from Freeze and Cherry (1979)3"]
["Unconsolidated Deposits"]
["Gravel","1x102 - 1x105"]
["Clean Sand","1x100 - 1x103"]
["Silty Sand","1x10-1 - 1x102"]
["Silt, loess","1x10-4 - 1x100"]
["Glacial Till","1x10-7 - 1x10-1"]
["Unweather Marine Clay","1x10-7 - 1x10-4"]
["Rocks"]
["Shale","1x10-8 - 1x10-4"]
["Unfractured metamorphic and igneous rocks","1x102 - 1x105"]
["Sandstone","1x10-5 - 1x10-1"]
["Limestone and Dolomite","1x10-4 - 1x10-1"]
["Fractured metamorphic and igneous rocks","1x10-3 - 1x101"]
["Pemeable Basalt","1x10-1 - 1x103"]
["Karst Limestone","1x10-1 - 1x103"]
[]
["Example Specific Yield Ranges** adapted from Fetter (1994)1"]
["Material","Average (max, min)"]
["Clay","0.02 (0.05,0.00)"]
["Sandy Clay","0.07 (0.12,0.03)"]
["Silt ","0.18 (0.19,0.03)"]
["Fine Sand","0.21 (0.28, 0.10)"]
["Medium Sand","0.26 (0.32, 0.15)"]
["Coarse Sand","0.27 (0.35, 0.20)"]
["Gravelly Sand","0.25 (0.35, 0.20)"]
["Fine Gravel","0.25 (0.35, 0.21)"]
["Medium Gravel","0.23 (0.26, 0.13)"]
["Coarse Gravel","0.22 (0.26, 0.12)"]
["** Mixtures of sediments will have lower specific yields"]
[]
["1 From \"Groundwater and Wells\" 2nd Edition by F.G. Driscoll (1995), Johnson Screens, St. Paul, MN."]
["2 From \"Applied Hydrogeology\" 4th Edition by C.W. Fetter (2001), Prentice-Hall, Inc., Englewood Cliffs, NJ."]
["3 From \"Groundwater\" by Freeze, R.A. and Cherry, J.A. (1979), Prentice-Hall, Inc., Englewood Cliffs, NJ."]

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