{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Ogata-Banks"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":8,"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":"Ogata-Banks","index":0,"n_rows":57,"n_cols":10,"rows_kept":57,"cut":false,"hidden":false,"merged":[[1,9,3,15],[0,1,0,7],[1,1,1,7],[14,1,14,2],[14,4,14,5],[10,1,10,7],[3,1,3,7]]}
[null,"Ogata-Banks 1D Transport Solution"]
[null,"Developed by Prof. J.R.Craig, Dept. of Civil & Environmental Engineering, University of Waterloo © James R. Craig, 2008-2014",null,null,null,null,null,null,null,"Sourced from van Genuchten M. Th., Analytical solutions for chemical transport with simultaneous adsorption, zero-order production and first order decay, Journal of Hydrology 49: 213-233, 1981. This simplifies to the Ogata Banks solution when the decay coefficient is equal to zero"]
[null,"**note: keep length ([L]) and time ([T]) units consistent throughout!"]
[null,"Specified Parameters"]
[null,"C0",1,"[mg/L]","Source concentration"]
[null,"v",1,"[L/T]","Velocity"]
[null,"D",0.1,"[L2/T]","Longitudinal Dispersion coefficient"]
[null,"R",1.25,"[-]","Retardation Factor"]
[null,"k",0.2,"[1/T]","decay coefficient"]
[null,"tspill",1.5,"[T]","Duration of spill"]
[null,"Plotting Options"]
[null,"tplot",2,"[T]","Snapshot time"]
[null,"xplot",1,"[L]","Fixed location for breakthrough curve"]
[]
[null,"Fixed Time Plot",null,null,"Fixed location plot"]
[null,"x [L]","C(x,tplot)",null,"t [T]","C(xplot,t)"]
[null,0,{"$f":"OgataBanks($B17,t,v/Rf,D/Rf,Co,k/Rf)-OgataBanks($B17,t-tspill,v/Rf,D/Rf,Co,k/Rf)","v":0},null,0,{"$f":"OgataBanks(x,$E17,v/Rf,D/Rf,Co,k/Rf)-OgataBanks(x,$E17-tspill,v/Rf,D/Rf,Co,k/Rf)","v":0}]
[null,{"$f":"B17+2*v*t/40","v":0.1},3.4721050606398851E-2,null,{"$f":"x/v/5+E17","v":0.2},2.2401275376214924E-6]
[null,0.2,0.10008962646224306,null,0.4,5.278820376319179E-3]
[null,0.30000000000000004,0.19839464852884392,null,0.60000000000000009,6.109387215849716E-2]
[null,0.4,0.32185614966446741,null,0.8,0.18714165037892697]
[null,0.5,0.45352409881614481,null,1,0.33951402126041336]
[null,0.6,0.57304283747063001,null,1.2,0.47809842594485291]
[null,0.7,0.66410184798982275,null,1.4,0.58700792928548229]
[null,0.79999999999999993,0.7192466028840202,null,1.5999999999999999,0.66583667726404072]
[null,0.89999999999999991,0.73992607624227391,null,1.7999999999999998,0.71972499621559127]
[null,0.99999999999999989,0.73294052547234123,null,1.9999999999999998,0.73294052547234112]
[null,1.0999999999999999,0.70631696120940402,null,2.1999999999999997,0.66257930625233552]
[null,1.2,0.66663574926567881,null,2.4,0.53224515857904664]
[null,1.3,0.61834181561628576,null,2.6,0.39312139632740922]
[null,1.4000000000000001,0.56425501260074906,null,2.8000000000000003,0.27483029342910625]
[null,1.5000000000000002,0.50636761858775858,null,3.0000000000000004,0.18536836368929144]
[null,1.6000000000000003,0.44641942438704235,null,3.2000000000000006,0.12209543160495495]
[null,1.7000000000000004,0.38614617910857107,null,3.4000000000000008,7.9143144628381457E-2]
[null,1.8000000000000005,0.32729254566908667,null,3.600000000000001,5.074179672105994E-2]
[null,1.9000000000000006,0.27150482082245497,null,3.8000000000000012,3.228631053265707E-2]
[null,2.0000000000000004,0.22019507754499223,null,4.0000000000000009,2.0434752335366291E-2]
[null,2.1000000000000005,0.17442516379407355,null,4.2000000000000011,1.2885898689954045E-2]
[null,2.2000000000000006,0.13483827288555122,null,4.4000000000000012,8.1049105616355366E-3]
[null,2.3000000000000007,0.10164704271820302,null,4.6000000000000014,5.0889189937770585E-3]
[null,2.4000000000000008,7.467381947573988E-2,null,4.8000000000000016,3.1915816166955269E-3]
[null,2.5000000000000009,5.3429815880380288E-2,null,5.0000000000000018,2.0002325646939489E-3]
[null,2.600000000000001,3.7215280808481958E-2,null,5.200000000000002,1.2531151782217975E-3]
[null,2.7000000000000011,2.5222550710675754E-2,null,5.4000000000000021,7.8495251381505149E-4]
[null,2.8000000000000012,1.6627167028281792E-2,null,5.6000000000000023,4.9171912116141581E-4]
[null,2.9000000000000012,1.0657642795441253E-2,null,5.8000000000000025,3.0808584824193463E-4]
[null,3.0000000000000013,6.6403000461597592E-3,null,6.0000000000000027,1.9308656212002617E-4]
[null,3.1000000000000014,4.0205309967602425E-3,null,6.2000000000000028,1.2105740929591047E-4]
[null,3.2000000000000015,2.3650878505321552E-3,null,6.400000000000003,7.5929598939872278E-5]
[null,3.3000000000000016,1.3514187595858669E-3,null,6.6000000000000032,4.7647920660587317E-5]
[null,3.4000000000000017,7.4994979134960105E-4,null,6.8000000000000034,2.9915186695483875E-5]
[null,3.5000000000000018,4.0411370691730182E-4,null,7.0000000000000036,1.8791582710564469E-5]
[null,3.6000000000000019,2.1141769676243243E-4,null,7.2000000000000037,1.1810403240053446E-5]
[null,3.700000000000002,1.0737157816009296E-4,null,7.4000000000000039,7.4267573644259954E-6]
[null,3.800000000000002,5.2929437385313048E-5,null,7.6000000000000041,4.6727055812434415E-6]
[null,3.9000000000000021,2.5323279623030132E-5,null,7.8000000000000043,2.9415235469620882E-6]
[null,4.0000000000000018,1.175754392510725E-5,null,8.0000000000000036,1.8526321156064895E-6]