{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["MathFunctions","Dispersion","Hydraulics","Theis(1935)(Jenkins)","Hunt(1999)","Hunt(2003)","Ward-Lough(2011)","Disclaimer","ScaleDepDispersion"],"not_rendered":{"charts":4,"images":6,"macros":1,"external_links":0,"defined_names":44,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"MathFunctions","index":0,"reason":"part_missing"},{"sheet":"Dispersion","index":1,"reason":"part_missing"},{"sheet":"Hydraulics","index":2,"reason":"part_missing"},{"sheet":"ScaleDepDispersion","index":8,"reason":"part_missing"}],"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":"Theis(1935)(Jenkins)","index":3,"n_rows":32,"n_cols":18,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,14]]}
["Stream depletion analysis - Theis (Jenkins) solution"]
["Pumped aquifer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time","Depletion Rate"]
["Transmissivity (T) ",1000,"(m2/d)",null,null,null,null,null,null,null,null,null,null,null,null,null,"(days)","(L/s)"]
["Storage coefficient (S)",0.1,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"q*erfc1(SQRT(sdf/(4*Q4)))","v":2.035177316970033E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0.62096801114380107]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,2.0613349235039116]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,3.8549890028526366]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,5.6923154384201551]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,7.4457381441010382]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,9.0724668570725164]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,10.564984220537601]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,11.929647648963565]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,13.177628781475335]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,18.065518991362634]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,21.459758826417051]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,23.974999184762641]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,25.93024468937908]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,30.853753727600591]
["Well",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,32.403845609030292]
["Pumping rate (Q) ",50,"(L/s)",null,null,null,null,null,null,null,null,null,null,null,null,null,70,33.630194789182596]
["Separation distance (L)",500,"(m)",null,null,null,null,null,null,null,null,null,null,null,null,null,80,34.631644320186872]
["Stream depletion factor (sdf)",{"$f":"L^2*S/T","v":25},"(days)",null,null,null,null,null,null,null,null,null,null,null,null,null,90,35.469411676969983]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,36.183686932323639]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,38.641506312663111]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,40.129372931588634]
[null,{"$f":"B25^2*S/T","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,250,41.153167789772418]
["Stream depletion after",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,41.912827106339762]
["Time (days)","q (L/s)","%",null,null,null,null,null,null,null,null,null,null,null,null,null,400,42.98419037610438]
[7,{"$f":"q*C29","v":9.0724668570725164},{"$f":"erfc1(SQRT(sdf/(4*A29)))","v":0.18144933714145034}]
[30,{"$f":"q*C30","v":25.93024468937908},{"$f":"erfc1(SQRT(sdf/(4*A30)))","v":0.51860489378758157}]
[150,{"$f":"q*C31","v":38.641506312663111},{"$f":"erfc1(SQRT(sdf/(4*A31)))","v":0.7728301262532622}]
[365,{"$f":"q*C32","v":42.659166626051984},{"$f":"erfc1(SQRT(sdf/(4*A32)))","v":0.85318333252103973}]

{"sheet":"Hunt(1999)","index":4,"n_rows":38,"n_cols":18,"rows_kept":38,"cut":false,"hidden":false,"merged":[[26,0,26,1],[1,0,1,1],[0,0,0,14]]}
["Stream depletion analysis - Hunt (1999) solution"]
["Pumped aquifer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time","Depletion Rate"]
["Transmissivity (T) ",1000,"(m2/d)",null,null,null,null,null,null,null,null,null,null,null,null,null,"(days)","(L/s)"]
["Storage coefficient (S)",0.1,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"q*q_4(Q4*T/(S*L^2),0,1,lambda*L/T)","v":4.085347074141093E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0.60409366054461711]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,2.0502288910279849]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,3.8283214552138554]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,5.6442478316744644]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,7.3783408281297103]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,8.9898804663554834]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,10.471233042976895]
["Streambed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,11.828041654117879]
["Hydraulic conductivity (K\") ",1000,"(m/d)",null,null,null,null,null,null,null,null,null,null,null,null,null,10,13.070720169472494]
["Thickness (B\") ",1,"(m)",null,null,null,null,null,null,null,null,null,null,null,null,null,15,17.952424862284733]
["Width (W) ",1,"(m)",null,null,null,null,null,null,null,null,null,null,null,null,null,20,21.352310040320031]
["Stream bed conductance (λ) ",{"$f":"Condbed*bedwidth/Thickbed","v":1000},"(m/d)",null,null,null,null,null,null,null,null,null,null,null,null,null,25,23.874871413686066]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,25.836901673968772]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,30.779243284537973]
["Well",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,32.335357252757255]
["Pumping rate (Q) ",50,"(L/s)",null,null,null,null,null,null,null,null,null,null,null,null,null,70,33.566432868482444]
["Separation distance (L)",500,"(m)",null,null,null,null,null,null,null,null,null,null,null,null,null,80,34.571711113240454]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,35.412660660750149]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,36.12963619121625]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,38.596698838832175]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,40.090172597619741]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,250,41.117855046724308]
["Stream depletion after",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,41.880422112257307]
["Time (days)","q (L/s)","%",null,null,null,null,null,null,null,null,null,null,null,null,null,400,42.955927382787948]
[7,{"$f":"q*C29","v":8.9898804663554834},{"$f":"q_4(A29*T/(S*L^2),0,1,lambda*L/T)","v":0.17979760932710967}]
[30,{"$f":"q*C30","v":25.836901673968772},{"$f":"q_4(A30*T/(S*L^2),0,1,lambda*L/T)","v":0.51673803347937541}]
[150,{"$f":"q*C31","v":38.596698838832175},{"$f":"q_4(A31*T/(S*L^2),0,1,lambda*L/T)","v":0.77193397677664344}]
[365,{"$f":"q*C32","v":42.629641580423595},{"$f":"q_4(A32*T/(S*L^2),0,1,lambda*L/T)","v":0.85259283160847188}]
[]
[]
[]
[]
[]
["Setting lambda to a very high value will give Theis solution"]

{"sheet":"Hunt(2003)","index":5,"n_rows":38,"n_cols":18,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,14]]}
["Stream depletion analysis - Hunt (2003) solution"]
["Pumped aquifer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time","Depletion Rate"]
["Transmissivity (T) ",1000,"(m2/d)",null,null,null,null,null,null,null,null,null,null,null,null,null,"(days)","(L/s)"]
["Storage coefficient (S)",0.1,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"q*q_4(Q4*T/(S*L^2),KB*L^2/T,S/Sy,lambda*L/T)","v":4.085347074141093E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0.60409366054461711]
["Aquitard",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,2.0502288910279849]
["Hydraulic conductivity (K') ",0,"(m/d)",null,null,null,null,null,null,null,null,null,null,null,null,null,4,3.8283214552138554]
["Thickness (B') ",1,"(m)",null,null,null,null,null,null,null,null,null,null,null,null,null,5,5.6442478316744644]
["K'/B'",{"$f":"K_prime/B_prime","v":0},"(d-1)",null,null,null,null,null,null,null,null,null,null,null,null,null,6,7.3783408281297103]
["Specific yield (Sy) ",0.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,8.9898804663554834]
[null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,8,10.471233042976895]
["Streambed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,11.828041654117879]
["Hydraulic conductivity (K\") ",1000,"(m/d)",null,null,null,null,null,null,null,null,null,null,null,null,null,10,13.070720169472494]
["Thickness (B\") ",1,"(m)",null,null,null,null,null,null,null,null,null,null,null,null,null,20,21.352310040320031]
["Width (W) ",1,"(m)",null,null,null,null,null,null,null,null,null,null,null,null,null,30,25.836901673968772]
["Stream bed conductance (λ) ",{"$f":"Condbed*bedwidth/Thickbed","v":1000},"(m/d)",null,null,null,null,null,null,null,null,null,null,null,null,null,40,28.725030635947125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,30.779243284537973]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,32.335357252757255]
["Well",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,33.566432868482444]
["Pumping rate (Q) ",50,"(L/s)",null,null,null,null,null,null,null,null,null,null,null,null,null,80,34.571711113240454]
["Separation distance (L)",500,"(m)",null,null,null,null,null,null,null,null,null,null,null,null,null,90,35.412660660750149]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,36.12963619121625]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,38.596698838832175]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,40.090172597619741]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,250,41.117855046724308]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,41.880422112257307]
["Stream depletion after",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,350,42.475217930278006]
["Time (days)","q (L/s)","%",null,null,null,null,null,null,null,null,null,null,null,null,null,400,42.955927382787948]
[7,{"$f":"q*C29","v":8.9898804663554834},{"$f":"q_4(A29*T/(S*L^2),KB*L^2/T,S/Sy,lambda*L/T)","v":0.17979760932710967}]
[30,{"$f":"q*C30","v":25.836901673968772},{"$f":"q_4(A30*T/(S*L^2),KB*L^2/T,S/Sy,lambda*L/T)","v":0.51673803347937541}]
[150,{"$f":"q*C31","v":38.596698838832175},{"$f":"q_4(A31*T/(S*L^2),KB*L^2/T,S/Sy,lambda*L/T)","v":0.77193397677664344}]
[365,{"$f":"q*C32","v":42.629641580423595},{"$f":"q_4(A32*T/(S*L^2),KB*L^2/T,S/Sy,lambda*L/T)","v":0.85259283160847188}]
[]
[]
[]
[]
[]
["Setting K'/B' to zreo gives Hunt 1999 solution"]

{"sheet":"Ward-Lough(2011)","index":6,"n_rows":41,"n_cols":18,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,14]]}
["Stream depletion analysis - Ward Lough (2011) solution"]
["Pumped aquifer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time","Depletion Rate"]
["Transmissivity (T2) ",500,"(m2/d)",null,null,null,null,null,null,null,null,null,null,null,null,null,"(days)","(L/s)"]
["Storage coefficient (S2)",0.05,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"q*q_16(Q4*T_2/(S_2*L^2),T_1/T_2,S_1/S_2,KB*L^2/T_2,lambda*L/T_2)","v":4.0802742636766995E-3}]
["Aquitard",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0.60395701142014302]
["Hydraulic conductivity (K') ",1000000,"(m/d)",null,null,null,null,null,null,null,null,null,null,null,null,null,3,2.0499176747041408]
["Thickness (B') ",1,"(m)",null,null,null,null,null,null,null,null,null,null,null,null,null,4,3.8278663485160491]
["K'/B'",{"$f":"K_prime/B_prime","v":1000000},"(d-1)",null,null,null,null,null,null,null,null,null,null,null,null,null,5,5.6436954326470774]
["Upper Aquifer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,7.3777194478661574]
["Overlying T (T1)",500,"(m2/d)",null,null,null,null,null,null,null,null,null,null,null,null,null,7,8.989175597405282]
["Specific yield (S1) ",0.05,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,8,10.470546782317182]
["Streambed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,11.827340595702742]
["Hydraulic conductivity (K\") ",1000,"(m/d)",null,null,null,null,null,null,null,null,null,null,null,null,null,10,13.06995603087141]
["Thickness (B\") ",1,"(m)",null,null,null,null,null,null,null,null,null,null,null,null,null,20,21.351583282485436]
["Width (W) ",1,"(m)",null,null,null,null,null,null,null,null,null,null,null,null,null,30,25.836241806451987]
["Stream bed conductance (λ) ",{"$f":"Condbed*bedwidth/Thickbed","v":1000},"(m/d)",null,null,null,null,null,null,null,null,null,null,null,null,null,40,28.724428222378094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,30.778687210982696]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,32.334838869138466]
["Well",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,33.566142964598633]
["Pumping rate (Q) ",50,"(L/s)",null,null,null,null,null,null,null,null,null,null,null,null,null,80,34.570097084861651]
["Separation distance (L)",500,"(m)",null,null,null,null,null,null,null,null,null,null,null,null,null,90,35.412222361678069]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,36.129217469671509]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,38.596349704302909]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,40.089867039781794]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,250,41.11758001195161]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,41.880169977023399]
["Stream depletion after",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,350,42.478735381755357]
["Time (days)","q (L/s)","%",null,null,null,null,null,null,null,null,null,null,null,null,null,400,42.951040539146533]
[7,{"$f":"q*C29","v":8.989175597405282},{"$f":"q_16(A29*T_2/(S_2*L^2),T_1/T_2,S_1/S_2,KB*L^2/T_2,lambda*L/T_2)","v":0.17978351194810566}]
[30,{"$f":"q*C30","v":25.836241806451987},{"$f":"q_16(A30*T_2/(S_2*L^2),T_1/T_2,S_1/S_2,KB*L^2/T_2,lambda*L/T_2)","v":0.51672483612903974}]
[150,{"$f":"q*C31","v":38.596349704302909},{"$f":"q_16(A31*T_2/(S_2*L^2),T_1/T_2,S_1/S_2,KB*L^2/T_2,lambda*L/T_2)","v":0.77192699408605825}]
[365,{"$f":"q*C32","v":42.631206369595098},{"$f":"q_16(A32*T_2/(S_2*L^2),T_1/T_2,S_1/S_2,KB*L^2/T_2,lambda*L/T_2)","v":0.85262412739190196}]
[]
[]
[]
[]
[]
["Setting K'/B' to a large number and either:"]
["Double lambda or "]
["Set T1=T2 = T/2 and S1=S2=S/2 (effective T and S)"]
["will approximate Hunt 1999 solution"]

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