{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["2DCLSAD-HUNT"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":2,"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":"2DCLSAD-HUNT","index":0,"n_rows":98,"n_cols":12,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
["Model Name:","2D_continuous_line_source_advection_dispersion_hunt"]
["Model Type:","Contaminant Transport"]
["Dispersion Dimension:",2]
["Advection:","Yes"]
["Dispersion:","Yes"]
["Source History:","Constant Injection"]
["Source Dimension:","Line (Point)"]
["Decay:","None"]
["Retardation:","None"]
["References: ","Hunt, B. 1978. Dispersive Sources in Uniform Groundwater Flow.  J. of Hydraulics, ASCE, Vol 104., No. HY1, pp 75-85."]
[null,"Bear, J. 1979.  Groundwater Hydrology"]
[null,"Yuan, D, 1995. ``Accurate approximations for one-, two-, and three-dimensional groundwater mass transport from an exponentially decaying contaminant source.'' MS Thesis, Department of Civil and Environmental Engineering, University of Houston"]
["Method: "]
["Author:","Dr. T.G. Cleveland for CIVE6361/7332 Students; Spring 1995"]
[null,"Rewrite in VBA Mac Excel 2011 Fall 2015"]
["Notes:","Model Graphics illustrate how to create plume maps and histories at specified location."]
[null,"VBA Macros are SLOW -- Make Changes and Wait for Recalculation"]
[]
["Macros:","W(U),LEAKY(U,V)",null,"Well Functions contained in Module1 as local to this worksheet macros"]
[]
["MODEL INPUT VALUES"]
[null,"Input Data"]
["Co",100000,"Input Concentration (mg/m^3)"]
["Co (computed)",{"$f":"B23/(100^3)","v":0.1},"mg/L"]
["Q",10,"Injection Rate (m^3/day)"]
["Q (computed)",{"$f":"B25*(3.25^3)/(7.48)/(1440)","v":3.1870288361556739E-2},"gpm"]
["m",1,"Aquifer Thickness (m)"]
["n",0.3,"Porosity"]
["q",0.3,"Specific discharge"]
["al",1,"Longitudinal Dispersivity (m)"]
["at",0.1,"Transverse Dispersivity (m)"]
[]
["Computed Constants"]
["M",{"$f":"B23*B25","v":1000000},"Mass Loading Rate (mg/day)"]
["B",{"$f":"2*B36/B40","v":2}]
["Dl",{"$f":"B30*B40","v":1}]
["Dt",{"$f":"B31*B40","v":0.1}]
["Dl/Dt",{"$f":"B36/B37","v":10}]
["Dl*Dt",{"$f":"B36*B37","v":0.1}]
["u",{"$f":"B29/B28","v":1},"Velocity"]
[]
[null,null,"Time Calculations"]
[null,null,null,"(mg/L)","(mg/m^3)"]
["x-coordinate","y-coordinate","t-coordinate","C(x.y.t)","C(x,y,t)"]
[0.1,0,1E-4,{"$f":"E45/(100^3)","v":1.4162210646443757E-13},{"$f":"$B$34*EXP(A45/$B$35)*LEAKY(((A45^2+$B$38*B45^2)/(4*$B$36*C45)),SQRT(A45^2+$B$38*B45^2)/$B$35)/(4*PI()*SQRT($B$39))","v":1.4162210646443757E-7}]
[0.1,0,1E-3,{"$f":"E46/(100^3)","v":6.590605396853356E-3},6590.6053968533561]
[0.1,0,0.01,0.27591599337605177,275915.99337605177]
[0.1,0,0.1,0.82386094591890757,823860.94591890753]
[0.1,0,1,1.3718059639871558,1371805.9639871558]
[0.1,0,2,1.4997485610085111,1499748.5610085111]
[0.1,0,4,1.5897155912616319,1589715.5912616318]
[0.1,0,8,1.6347961991416073,1634796.1991416074]
[0.1,0,16,1.6467304366873976,1646730.4366873975]
[0.1,0,32,1.6477302020798357,1647730.2020798356]
[0.1,0,64,1.6477302020798357,1647730.2020798356]
[0.1,0,128,1.6477302020798357,1647730.2020798356]
[0.1,0,256,1.6477302020798357,1647730.2020798356]
[0.1,0,512,1.6477302020798357,1647730.2020798356]
[0.1,0,1024,1.6477302020798357,1647730.2020798356]
[]
[]
["Plume Calculations"]
["Time",1]
["dx",0.25]
["dy",0.2]
[]
[null,null,null,null,null,null,"<= Y =>"]
[null,-1,{"$f":"B68+$B$65","v":-0.8},-0.60000000000000009,-0.40000000000000008,-0.20000000000000007,0,0.2,0.4,0.60000000000000009,0.8,1]
[-1.0001,{"$f":"$B$34*EXP($A69/$B$35)*LEAKY((($A69^2+$B$38*B$68^2)/(4*$B$36*$B$63)),SQRT($A69^2+$B$38*B$68^2)/$B$35)/(4*PI()*SQRT($B$39))/(100^3)","v":2.4218255185598225E-3},{"$f":"$B$34*EXP($A69/$B$35)*LEAKY((($A69^2+$B$38*C$68^2)/(4*$B$36*$B$63)),SQRT($A69^2+$B$38*C$68^2)/$B$35)/(4*PI()*SQRT($B$39))/(100^3)","v":7.9095405235118758E-3},2.2386680183613724E-2,5.3679435292550849E-2,0.10607508963593892,0.14101227233467192,0.10607508963593894,5.3679435292550919E-2,2.2386680183613724E-2,7.9095405235118758E-3,2.4218255185598225E-3]
[{"$f":"A69+$B$64","v":-0.75009999999999999},3.1498043425257668E-3,1.0449462693475173E-2,3.0343642648279042E-2,7.6457528721557921E-2,0.16456511124579243,0.23652449485781196,0.16456511124579243,7.6457528721557991E-2,3.0343642648279042E-2,1.0449462693475173E-2,3.1498043425257668E-3]
[-0.50009999999999999,3.9418561216170971E-3,1.323528907005884E-2,3.8482996758147252E-2,0.10323437148469015,0.24515217600961542,0.40567527732880809,0.24515217600961547,0.10323437148469021,3.8482996758147252E-2,1.323528907005884E-2,3.9418561216170971E-3]
[-0.25009999999999999,4.7427060095107804E-3,1.6045516946458328E-2,4.7347156038178913E-2,0.1307591557329679,0.33988366961912425,0.75029693712353707,0.33988366961912414,0.13075915573296795,4.7347156038178913E-2,1.6045516946458328E-2,4.7427060095107804E-3]
[-9.9999999999988987E-5,5.4830759559554099E-3,1.8598558345379088E-2,5.5163900823176751E-2,0.15396534643191517,0.41632907440389738,4.7796629956557064,0.41632907440389738,0.15396534643191523,5.5163900823176751E-2,1.8598558345379088E-2,5.4830759559554099E-3]
[0.24990000000000001,6.0899501949772759E-3,2.0603596725688317E-2,6.0797645202802952E-2,0.16790829122210346,0.4364713312329595,0.96384327427293226,0.43647133123295984,0.16790829122210346,6.0797645202802952E-2,2.0603596725688317E-2,6.0899501949772759E-3]
[0.49990000000000001,6.4994366118199297E-3,2.1822867815962665E-2,6.3453250042312115E-2,0.17022445490419541,0.40426680293783102,0.6690795638540592,0.40426680293783113,0.1702244549041951,6.3453250042312115E-2,2.1822867815962665E-2,6.4994366118199297E-3]
[0.74990000000000001,6.6687691512144244E-3,2.2123861284043918E-2,6.4245520036616155E-2,0.16188696202004199,0.34846717400368971,0.50088215275433468,0.34846717400368998,0.16188696202004199,6.4245520036616155E-2,2.2123861284043918E-2,6.6687691512144244E-3]
[0.99990000000000001,6.5840296868660414E-3,2.1503351447132002E-2,6.0863106404288179E-2,0.14594527597874873,0.28841791836698949,0.38343024328890168,0.28841791836698955,0.14594527597874873,6.0863106404288179E-2,2.1503351447132002E-2,6.5840296868660414E-3]
[1.2499,6.2615727303888509E-3,2.007770166724767E-2,5.5231264834640206E-2,0.12586985619307547,0.23223831717282548,0.29448091792412529,0.23223831717282553,0.12586985619307553,5.5231264834640206E-2,2.007770166724767E-2,6.2615727303888509E-3]
[1.4999,{"$f":"$B$34*EXP($A79/$B$35)*LEAKY((($A79^2+$B$38*B$68^2)/(4*$B$36*$B$63)),SQRT($A79^2+$B$38*B$68^2)/$B$35)/(4*PI()*SQRT($B$39))/(100^3)","v":5.743230413789868E-3},1.804732319552696E-2,4.8200157900845579E-2,0.10462581626253949,0.18275655641878485,0.22471810732590491,0.18275655641878499,0.10462581626253961,4.8200157900845579E-2,1.804732319552696E-2,5.743230413789868E-3]
[1.7499,5.087193724077922E-3,1.5650236804033761E-2,4.0591812124996476E-2,8.6364927439447098E-2,0.14078499270551031,0.16942223007785229,0.14078499270551031,8.6364927439447098E-2,4.0591812124996476E-2,1.5650236804033761E-2,5.087193724077922E-3]
[1.9999,4.3573383849544924E-3,1.3118927842975097E-2,3.3081765296513931E-2,6.7979177743727678E-2,0.10883471711530616,0.12593156485847823,0.10883471711530616,6.7979177743727678E-2,3.3081765296513931E-2,1.3118927842975097E-2,4.3573383849544924E-3]
[2.2499000000000002,3.6135870261085868E-3,1.0649282029567643E-2,2.6150877955112183E-2,5.2122786718246585E-2,8.1155464371060096E-2,9.4679071368062584E-2,8.1155464371060096E-2,5.2122786718246585E-2,2.6150877955112183E-2,1.0649282029567643E-2,3.6135870261085868E-3]
[2.4999000000000002,3.3154000050871391E-3,8.384314987895599E-3,2.0086717933478913E-2,3.8982270715768173E-2,5.9329215378991731E-2,6.8570669221941188E-2,5.9329215378991731E-2,3.8982270715768173E-2,2.0086717933478913E-2,8.384314987895599E-3,3.3154000050871391E-3]
[2.7499000000000002,2.5506947418129007E-3,6.4110174923785969E-3,1.5012986648752738E-2,2.8462967001002315E-2,4.2508840294753512E-2,4.8763779434956307E-2,4.2508840294753512E-2,2.8462967001002315E-2,1.5012986648752738E-2,6.4110174923785969E-3,2.5506947418129007E-3]
[2.9999000000000002,1.9001271215195704E-3,4.7664754954719075E-3,1.0930515032910548E-2,2.0301839626725569E-2,2.9842332190660861E-2,3.4024482137157461E-2,2.9842332190660861E-2,2.030183962672559E-2,1.0930515032910548E-2,4.7664754954719075E-3,1.9001271215195704E-3]
[3.2499000000000002,1.3712839948478682E-3,3.9074039110964884E-3,7.75904627585371E-3,1.4152318055964435E-2,2.052300642346511E-2,2.3279976033479359E-2,2.052300642346511E-2,1.4152318055964435E-2,7.75904627585371E-3,3.9074039110964884E-3,1.3712839948478682E-3]
[3.4999000000000002,9.5911682209374322E-4,2.701126252291347E-3,5.373640919954804E-3,9.6449963860495824E-3,1.3824236650532947E-2,1.5613626442194791E-2,1.3824236650532947E-2,9.6449963860495893E-3,5.373640919954804E-3,2.701126252291347E-3,9.5911682209374322E-4]
[3.7499000000000002,6.5036681484074738E-4,1.812156886223996E-3,4.0840753946148785E-3,6.4278701131493957E-3,9.1198595048425195E-3,1.0262121420316296E-2,9.1198595048425195E-3,6.4278701131493957E-3,4.0840753946148785E-3,1.812156886223996E-3,6.5036681484074738E-4]
[3.9999000000000002,{"$f":"$B$34*EXP($A89/$B$35)*LEAKY((($A89^2+$B$38*B$68^2)/(4*$B$36*$B$63)),SQRT($A89^2+$B$38*B$68^2)/$B$35)/(4*PI()*SQRT($B$39))/(100^3)","v":4.2766239505415116E-4},1.1801165131142335E-3,2.633138969896968E-3,4.7135340812280201E-3,6.7139505925729731E-3,6.6083545397278331E-3,6.7139505925729731E-3,4.7135340812280201E-3,2.633138969896968E-3,1.1801165131142335E-3,4.2766239505415116E-4]
[4.2499000000000002,2.7276401760091817E-4,7.4608285905219853E-4,1.6499830333551329E-3,2.9303650093689096E-3,4.1508376084226778E-3,4.6647710043950961E-3,4.1508376084226778E-3,2.9303650093689096E-3,1.6499830333551329E-3,7.4608285905219853E-4,2.7276401760091817E-4]
[4.4999000000000002,1.687651254755434E-4,4.5794686539199524E-4,1.0048054823257912E-3,1.7722947738704456E-3,2.4984856537976761E-3,2.8030143372003691E-3,2.4984856537976761E-3,1.7722947738704456E-3,1.0048054823257912E-3,4.5794686539199524E-4,1.687651254755434E-4]
[4.7499000000000002,1.0130639363374625E-4,2.7291351048606532E-4,5.9462480680759521E-4,1.0425154852419097E-3,1.4636388936262832E-3,1.6396198563146832E-3,1.4636388936262832E-3,1.0425154852419097E-3,5.9462480680759521E-4,2.7291351048606532E-4,1.0130639363374625E-4]
[4.9999000000000002,5.9004391461890857E-5,1.5791395039137715E-4,3.4191535797146202E-4,5.9629458025289546E-4,8.3417713831768301E-4,9.3328860712920227E-4,8.3417713831768301E-4,5.9629458025289546E-4,3.4191535797146202E-4,1.5791395039137715E-4,5.9004391461890857E-5]
[5.2499000000000002,3.3346375088622355E-5,8.871476583293089E-5,1.9101251908742778E-4,3.315715250880289E-4,4.6239969911025087E-4,5.1676875656329825E-4,4.6239969911025087E-4,3.315715250880289E-4,1.9101251908742778E-4,8.871476583293089E-5,3.3346375088622355E-5]
[5.4999000000000002,1.8287073081273996E-5,4.8388156892972123E-5,1.0366321143804725E-4,1.79202736020493E-4,2.4922615028811124E-4,2.782619934236699E-4,2.4922615028811124E-4,1.79202736020493E-4,1.0366321143804725E-4,4.8388156892972123E-5,1.8287073081273996E-5]
[5.7499000000000002,9.7314683833744073E-6,2.5623186240581596E-5,5.4646104044736305E-5,9.4120173333793662E-5,1.3058123673670736E-4,1.4567114630746196E-4,1.3058123673670736E-4,9.4120173333793662E-5,5.4646104044736305E-5,2.5623186240581596E-5,9.7314683833744073E-6]
[5.9999000000000002,5.0251948973337202E-6,1.3172190351396975E-5,2.7978123423960229E-5,4.8030529168570249E-5,6.6494264291480862E-5,7.412291717888844E-5,6.6494264291480862E-5,4.8030529168570249E-5,2.7978123423960229E-5,1.3172190351396975E-5,5.0251948973337202E-6]
[6.2499000000000002,2.5180551215537209E-6,6.5734221927984375E-6,1.3910971083399191E-5,2.3811149479118641E-5,3.2901709955755293E-5,3.6652114692857358E-5,3.2901709955755293E-5,2.3811149479118641E-5,1.3910971083399191E-5,6.5734221927984375E-6,2.5180551215537209E-6]