{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["About...","Chemical Properties Worksheet","Chemical Database","Environment Database","Inputs - Chemical Properties","Inputs - Environment","Emissions & File Options","Results","Diagram"],"not_rendered":{"charts":0,"images":20,"macros":1,"external_links":3,"defined_names":77,"comments":1,"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":1,"cells_raw":0,"read":"whole","date_system":"1900"}

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

{"sheet":"Chemical Properties Worksheet","index":1,"n_rows":42,"n_cols":12,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Henry's Law Constant and KAW: Calculate from Solubility and Vapor Pressure",null,null,null,null,null,null,"Enter Property Value at 25°C:",200]
[null,null,null,null,null,null,null,null,null,"Enter Desired Temperature (°C):",45]
[null,null,"Enter Molar Mass (g/mol):",165.83,null,null,null,null,null,"Enter Enthalpy of Phase Change (J/mol):",-40000]
[null,null,"Enter Temperature (°C):",25]
[null,null,"Enter Solubility (mg/L or g/m³):",206,null,null,null,null,null,{"$f":"\"Property at \" & K14 & \" °C =\"","v":"Property at 45 °C ="},{"$f":"K13*EXP(K15/8.314*(1/(298.15)-1/(K14+273.15)))","v":72.523312253697881}]
[null,null,"Enter Vapor Pressure (Pa):",2470]
[]
[null,null,"Henry's Law Constant =",{"$f":"D18/D17*D15","v":1988.3500000000001},"Pa·m³/mol"]
[null,null,null,null,null,null,null,null,null,"Estimate Reaction Half-Life at a Different Temperature Using Activation Energies"]
[null,null,"Air-Water Partition Coefficient (KAW) =",{"$f":"D20/(8.314*(D16+273.15))","v":0.8021359848324553}]
[null,null,null,null,null,null,null,null,null,"Note: Activation energies are always positive, and are input in J/mol (not kJ/mol)."]
[]
[]
[null,null,"Organic Carbon-Water Partition Coefficient (KOC): Calculate from logKOW",null,null,null,null,null,null,"Enter Reaction Half Life at 25°C (h):",720]
[null,null,null,null,null,null,null,null,null,"Enter Desired Temperature (°C):",10]
[null,null,"Enter logKOW:",7.2,null,null,null,null,null,"Enter Activation Energy (J/mol):",1000]
[]
[null,null,"(Karickhoff method)                  KOC = ",{"$f":"0.41*10^D28","v":6498062.0890905801},"L/kg",null,null,null,null,{"$f":"\"Reaction Half-Life at \" & K27 & \" °C =\"","v":"Reaction Half-Life at 10 °C ="},{"$f":"K26*EXP(K28/8.314*(1/(K27+273.15)-1/298.15))","v":735.55289814084574}]
[]
[null,null,"(Seth et al. method)                  KOC = ",{"$f":"0.35*10^D28","v":5547126.1736139096},"L/kg"]
[]
[null,null,null,null,null,null,null,null,null,"Aerosol-Air Partition Coefficient (KQA): Calculate from Melting Point and Vapor Pressure"]
[]
[null,null,"Converting from Solid-Air Partition Coefficients to Solid-Water Partition Coefficients",null,null,null,null,null,null,"Enter Temperature:",25,"°C"]
[null,null,null,null,null,null,null,null,null,"Enter Melting Point:",110,"°C"]
[null,null,"Enter Solid-Air Partition Coefficient:",5000,"(dimensionless)",null,null,null,null,"Enter Vapor Pressure:",209000,"Pa"]
[null,null,"Enter KAW (see above, or 1/KWA):",1.67E-2,"(dimensionless)"]
[null,null,"Enter Density of Solid:",2.4,"kg/L",null,null,null,null,"Subcooled Liquid Vapor Pressure =",{"$f":"IF(K37>K36,K38*EXP(6.79*((K37+273.15)/(K36+273.15)-1)),K38)","v":1448240.7707144166},"Pa"]
[]
[null,null,"Solid-Water Partition Coefficient =",{"$f":"D38*D39*1/D40","v":34.791666666666671},"L/kg",null,null,null,null,"KQA =",{"$f":"6000000/K40","v":4.142957525660738}]

{"sheet":"Chemical Database","index":2,"n_rows":27,"n_cols":35,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Half-Lives",null,null,null,"Partition Coefficients"]
["CAS","Chemical Name","Molar Mass","Data Temp.","Melting Point",null,"Vapor pressure",null,"Solubility in Water",null,"Henry's Law Constant",null,"In Water",null,"In Sediment",null,"logKOW",null,"Air-Water (KAW)",null,"Aerosol-Air",null,"Aerosol-Water",null,"KOC",null,"Suspended Particles-Water",null,"Susp. Part.-Water (Inflow)",null,"Sediment-Water",null,"Resuspended Sediment-Water",null,"NOTES"]
[null,null,"(g/mol)","°C","°C","Ref.","(Pa)","Ref.","(g/m³ or mg/L)","Ref.","(Pa·m³/mol)","Ref.","(hours)","Ref.","(hours)","Ref.",null,"Ref.","unitless (m³/m³)","Ref.","unitless","Ref.","unitless","Ref.","L/kg","Ref.","L/kg","Ref.","L/kg","Ref.","L/kg","Ref.","L/kg","Ref."]
[null,"Hypothene",250,25,275,null,0.02,null,30,null,0.16700000000000001,null,55,null,170,null,2.5,null,6.7199999999999994E-5,"calculated",1010000,null,null,null,130,null,100,null,null,null,25.9,null,5.19,null,"Hypothetical chemical"]
[null,"Chlorobenzene",112.56,25,-45.3,null,1580,null,495,null,359,"H = P*M/S",602.20000000000005,"EAS-E Suite Database",5419.8,"EAS-E Suite Database",2.9,null,0.14499999999999999,"Kaw = H/RT",3800,null,null,null,300,null,60,null,null,null,12,null,60]
[null,"Benzene (example)",78.11,25,5.53,null,12700,null,1780,null,557.29999999999995,"H = P*M/S",331.1,"EAS-E Suite Database",2979.92,"EAS-E Suite Database",2.13,null,0.22500000000000001,"Kaw = H/RT",472.4,"Kqa=6E+06/Pliq",null,null,55.31,"Koc=0.41Kow",22.12,"Ksus=foc*Koc; foc = 0.4",22.12,"Ksus=foc*Koc; foc = 0.4",1.66,"Ksus=foc*Koc; foc = 0.03",1.38,"Ksus=foc*Koc; foc = 0.025","from the QWASI model DB (version 3.10); using \"Lake Superior\" fOCs"]
[null,"1,2,4-Trichlorobenzene",181.45,25,16.95,null,61,null,40,null,276.7,"H = P*M/S",2272.1999999999998,"EAS-E Suite Database",22722,"EAS-E Suite Database",4.0999999999999996,null,0.11600000000000001,"Kaw = H/RT",98360,"Kqa=6E+06/Pliq",null,null,5162,"Koc=0.41Kow",null,null,null,null,null,null,null,null,"from the QWASI model DB (version 3.10)"]
[null,"Tetrachloroethylene",165.83,25,null,"assumed to be less than 25°C",2470,null,206,null,1998,null,1550.1,"EAS-E Suite Database",13951,"EAS-E Suite Database",3.4,null,0.80200000000000005,null,2429,null,null,null,1030,"Karickhoff",null,null,null,null,null,null,null,null,"all properties from Arnot et al. Env Mod Soft 2010"]
[null,"LAS (linear alkylbenzene sulfonates)",348,25,null,null,null,null,null,null,0,"KAW=0",24,null,96,null,null,null,0,"no appreciable Pv",null,null,100,null,null,null,570,null,570,null,570,null,570,null,"EQC v2.02 database (software version, released 2003)"]
[null,"D5",370.77,25,-38,"PhysProp Database 2011",33.200000000000003,"IUCLID (2005)",1.7000000000000001E-2,"Varaprath et al. (1996)",3340000,"H = KAW * RT",1689.6,"Kozerski (2008)",74400,"Xu (2010)",8.0299999999999994,"Kozerski (2007), slow-stir direct analysis",1348.96,"Xu and Kropscott (2007), double syringe method",181000,"6E+06/(liquid vapour pressure)",null,null,147900,"Durham and Kozerski (2007), batch equilibrium method"]
["35065-29-3","PCB 180",395.32299999999998,25,110,"Hutzinger et al. 1974 \"The Chemistry of PCBs\" CRC Press",209000,"solid - Paasivirta et al. 1999. Chemosphere 39 811-832",null,null,37,"Bamford et al. 2000. J. Chem. Eng. Data 45, 1069–1074.",100000,"Sinkkonen & Paasivirta 2000 Chemosphere 40 943-949. (est., order of mag.)",100000,"Sinkkonen & Paasivirta 2000 Chemosphere 40 943-949. (est., order of mag.)",7.2,"Paasivirta et al. 1999. Chemosphere 39 811-832",1.49E-2,"KAW = H/RT",4.1429999999999998,"calculated from P(liq) and melting point",null,null,5500000,"Seth et al. 1999. ES&T 33 2390-2394 (Koc = 0.35 * Kow)",null,null,null,null,null,null,null,null,"2,2',3,4,4',5,5'-Heptachlorobiphenyl, values are found in Handbook (Mackay et al. 2006)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$cut":{"chars":32767,"head":"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                "}}]

{"sheet":"Environment Database","index":3,"n_rows":18,"n_cols":27,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Dimensions",null,null,"Concentration of Solids",null,null,null,"Density (kg/m³)",null,null,"OC Content (g/g)",null,null,null,"Rates",null,null,null,null,null,null,null,"Volatilization Mass Transfer",null,"Diffusion"]
["Name","Water",null,"Sediment","Aerosols in Air","in Water Column","in Inflow Water","in Sediment","Aerosols","Particles in Water","Sediment Solids","Particles in Water","Particles in Water","Sediment Solids","Resuspended Sediment","Water Inflow","Water Outflow","Sedimentation","Sediment Burial","Sediment Resuspension","Aerosol Deposition","Scavenging Ratio","Rain Rate","Air Side Coefficient","Water Side Coefficient","Sed-Water MTC","NOTES"]
[null,"Surface Area (m²)","Volume (m³)","Active Layer Depth (m)","µg/m³","mg/L","mg/L","m³/m³",null,null,null,null,"(inflow)",null,null,"m³/h","m³/h","g/(m²·day)","g/(m²·day)","g/(m²·day)","m/h","vol air/vol rain","m/year","m/h","m/h","m/h"]
["Lake Superior",82100000000,12100000000000,5.0000000000000001E-3,10,0.3,10,0.15,1500,2600,2600,0.4,0.4,0.03,2.5000000000000001E-2,6000000,8000000,0.14000000000000001,0.09,0.03,7.2,200000,0.79,1,0.01,4.0000000000000002E-4]
["Lake Michigan",57800000000,4920000000000,5.0000000000000001E-3,20,1.3,15,0.15,1500,2400,2400,0.15,0.15,0.04,3.5000000000000003E-2,3000000,6500000,1.2,0.4,0.6,7.2,200000,0.79,1,0.01,4.0000000000000002E-4]
["Lake Huron (excluding Georgian Bay)",46600000000,3460000000000,5.0000000000000001E-3,15,1.3,5,0.15,1500,2400,2400,0.14000000000000001,0.14000000000000001,0.03,2.5000000000000001E-2,6000000,20000000,1.2,0.4,0.6,7.2,200000,0.97,1,0.01,4.0000000000000002E-4]
["Georgian Bay",13000000000,600000000000,5.0000000000000001E-3,15,1.3,5,0.15,1500,2400,2400,0.14000000000000001,0.14000000000000001,0.03,2.5000000000000001E-2,700000,5000000,1.2,0.4,0.6,7.2,200000,1.1000000000000001,1,0.01,4.0000000000000002E-4]
["Lake Erie",25700000000,484000000000,5.0000000000000001E-3,30,4,30,0.15,1500,2400,2400,0.1,0.1,0.04,3.5000000000000003E-2,20000000,22000000,1.4,0.6,0.6,7.2,200000,0.98,1,0.01,4.0000000000000002E-4]
["Lake Ontario",19100000000,1640000000000,5.0000000000000001E-3,30,0.64,24,0.15,1500,2400,2400,0.25,0.25,0.04,3.5000000000000003E-2,22000000,26000000,1.4,0.6,0.6,7.2,200000,0.92,1,0.01,4.0000000000000002E-4]
["Rihand Reservoir",463000000,10200000000,0.02,165,67.77,0.5,7.0000000000000007E-2,1940,1940,1940,0.2,0.2,0.02,0.114,578000,578000,12.89,4.72,0.69,10,200000,0.2,1,0.01,2.9999999999999997E-4]
["Shield Lake",20000000,200000000,0.01,30,2,2,0.1,1500,2400,2400,0.3,0.3,0.05,0.05,10000,10000,2,0.5,0.5,10,200000,1,1,0.01,4.0000000000000002E-4]
["Lake Ontario 1990s data",19500000000,1670000000000,5.0000000000000001E-3,30,0.5,24,0.15,1500,2400,2400,0.2,0.2,3.5900000000000001E-2,3.5900000000000001E-2,24000000,24400000,1.4,0.58899999999999997,0.58099999999999996,7.2,200000,0.84,1,0.01,4.0000000000000002E-4]

{"sheet":"Inputs - Chemical Properties","index":4,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[8,5,9,5]]}
[]
[null,null,null,"        hover cursor over red triangle for info"]
[null,null,"CHEMICAL PROPERTIES","Please complete all required fields below"]
[null,null,null,"or"]
[null,null,null,"Select a chemical from the database:"]
[null,null,"* indicates required input"]
[null,null,null,null,null,"References and Notes"]
[]
[null,"*","Chemical Name","Benzene (example)",null,"from the QWASI model DB (version 3.10); using \"Lake Superior\" fOCs"]
[null,null,"CAS"]
[]
[null,"*","Molar Mass (g/mol)",78.11]
[null,"*","Data Temperature (°C)",25]
[null,null,"Melting Point (°C)",5.53]
[null,null,"Vapor Pressure (Pa)",12700]
[null,"*","Henry's Law Constant (Pa·m³/mol)",557.29999999999995,null,"H = P*M/S"]
[]
[null,null,"Reaction Half-Lives (hours)"]
[null,"*","In Water",170]
[null,"*","In Sediment",1700]
[]
[null,null,"Partition Coefficients"]
[null,null,null,"unitless"]
[null,null,"logKOW",2.13]
[null,"*","Air-Water (KAW)",0.22500000000000001,null,"Kaw = H/RT"]
[null,"*","Aerosol-Air (KQA)",472.4,null,"Kqa=6E+06/Pliq"]
[null,null,"OR       "]
[null,"*","Aerosol-Water (KQW)"]
[null,null,null,"L/kg"]
[null,"*","KOC",55.31,null,"Koc=0.41Kow"]
[null,null,"Suspended Particles-Water",22.12,null,"Ksus=foc*Koc; foc = 0.4"]
[null,null,"Suspended Particles-Water (Inflow)",22.12,null,"Ksus=foc*Koc; foc = 0.4"]
[null,null,"Sediment-Water",1.66,null,"Ksus=foc*Koc; foc = 0.03"]
[null,null,"Resuspended Sediment-Water",1.38,null,"Ksus=foc*Koc; foc = 0.025"]

{"sheet":"Inputs - Environment","index":5,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[[24,5,25,6]]}
[]
[]
[null,null,"ENVIRONMENTAL PROPERTIES"]
[]
[null,null,"Please complete all fields or select an environment from the database:"]
[]
[null,null,"Environment Name","Lake Ontario 1990s data"]
[]
[null,null,"Dimensions",null,null,"Rates"]
[null,null,"Water Surface Area (m²)",19500000000,null,"Water Inflow (m³/h)",24000000]
[null,null,"Water Volume (m³)",1670000000000,null,"Water Outflow (m³/h)",24400000]
[null,null,"Sediment Active Layer Depth (m)",5.0000000000000001E-3,null,"Sedimentation (g/m²·day)",1.4]
[null,null,null,null,null,"Sediment Burial (g/m²·day)",0.58899999999999997]
[null,null,"Concentration of Solids",null,null,"Sediment Resuspension (g/m²·day)",0.58099999999999996]
[null,null,"Aerosols in Air (µg/m³)",30,null,"Aerosol Deposition (m/h)",7.2]
[null,null,"in Water Column (mg/L)",0.5,null,"Scavenging Ratio (vol air/ vol rain)",200000]
[null,null,"in Inflow Water (mg/L)",24,null,"Rain Rate (m/year)",0.84]
[null,null,"in Sediment (vol/vol)",0.15]
[null,null,null,null,null,"Mass Transfer Coefficients (m/h)"]
[null,null,"Density (kg/m³)",null,null,"Volatilization - Air Side",1]
[null,null,"Aerosols",1500,null,"Volatilization - Water Side",0.01]
[null,null,"Particles in Water",2400,null,"Sediment-Water Diffusion",4.0000000000000002E-4]
[null,null,"Sediment Solids",2400]
[null,null,null,null,null,"Additional Comments"]
[null,null,"Organic Carbon (OC) Content (mass/mass)"]
[null,null,"Particles in Water",0.2]
[null,null,"Particles in Water (inflow)",0.2]
[null,null,"Sediment Solids",3.5900000000000001E-2]
[null,null,"Resuspended Sediment",3.5900000000000001E-2]

{"sheet":"Emissions & File Options","index":6,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[9,2,10,6]]}
[]
[]
[null,null,"EMISSION RATES"]
[]
[null,null,"Directly Discharged into Water",1000,"kg/year",{"$f":"Emis_kgpy*1000/MolarMass/365/24","v":1.4614678164326274},"mol/h"]
[null,null,"Concentration in Inflow Water",5,"ng/L",{"$f":"ConcInf_ngpL/10^6/MolarMass","v":6.4012290359749078E-8},"mol/m³"]
[null,null,"Concentration in Air",8,"ng/m³",{"$f":"ConcAir_ngpm3/10^9/MolarMass","v":1.0241966457559852E-10},"mol/m³"]
[]
[null,null,"Additional Comments"]

{"sheet":"Results","index":7,"n_rows":123,"n_cols":9,"rows_kept":123,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"QWASI RESULTS"]
[]
[null,null,"Chemical Name",{"$f":"ChemName","v":"Benzene (example)"}]
[null,null,"Environment Name",{"$f":"EnvName","v":"Lake Ontario 1990s data"}]
[]
[]
[null,null,"Fugacity Ratio",{"$f":"IF(Pv=0,\"N/A\",IF(MeltPt>DataTemp,EXP(6.79*(1-(MeltPt+273.15)/(DataTemp+273.15))),1))","v":1}]
[]
[null,null,"Subcooled Liq. Vap. Press.",{"$f":"IF(Pv=0,\"N/A\",Pv/D9)","v":12700},"Pa"]
[]
[null,null,"Partition Coefficients","dimensionless","L/kg"]
[null,null,"Suspended Particles-Water",{"$f":"E14*DensWatP/1000","v":53.088000000000001},{"$f":"IF(KSus=\"\",KOC*OCSus,KSus)","v":22.12},{"$f":"IF(KSus=\"\",\"   (estimated using Koc and OC content of suspended particles)\",\"\")","v":""}]
[null,null,"Suspended Particles-Water (Inflow)",{"$f":"E15*DensWatP/1000","v":53.088000000000001},{"$f":"IF(KSus_Inf=\"\",KOC*OCSus_Inf,KSus_Inf)","v":22.12},{"$f":"IF(KSus_Inf=\"\",\"   (estimated using Koc and OC content of inflow particles)\",\"\")","v":""}]
[null,null,"Sediment-Water",{"$f":"E16*DensSedS/1000","v":3.984},{"$f":"IF(KSed=\"\",KOC*OCSed,KSed)","v":1.66},{"$f":"IF(KSed=\"\",\"   (estimated using Koc and OC content of sediment solids)\",\"\")","v":""}]
[null,null,"Resuspended Sediment-Water",{"$f":"E17*DensSedS/1000","v":3.3119999999999994},{"$f":"IF(KResus=\"\",KOC*OCResus,KResus)","v":1.38},{"$f":"IF(KResus=\"\",\"   (estimated using Koc and OC content of resuspended sediment)\",\"\")","v":""}]
[]
[null,null,null,"Volume Fraction","Volume","Z Value","VZ"]
[null,null,null,null,"m³","mol/m³·Pa","mol/Pa"]
[null,null,"Air: Bulk","-","-",{"$f":"F22*D22+F23*D23","v":4.0341790549701677E-4},"-"]
[null,null,"    Gas Phase",{"$f":"1-D23","v":0.99999999998},"-",{"$f":"IF(H=0,KAW,1/(8.314*(DataTemp+273.15)))","v":4.0341790169359277E-4},"-"]
[null,null,"    Aerosols",{"$f":"Air_S/DensAersl/10^9","v":2.0000000000000002E-11},"-",{"$f":"IF(KQA=0,KQW*F25,KQA*F22)","v":0.19057461676005322},"-"]
[null,null,"Water: Bulk","-",{"$f":"Vol_Wat","v":1670000000000},{"$f":"D25*F25+D26*F26","v":1.794385163586339E-3},{"$f":"E24*F24","v":2996623223.1891861}]
[null,null,"    Liquid Phase",{"$f":"1-D26","v":0.99999979166666664},{"$f":"D25*E24","v":1669999652083.3333},{"$f":"IF(H=0,1,1/H)","v":1.7943656917279744E-3},{"$f":"E25*F25","v":2996590080.895987}]
[null,null,"    Suspended Particles",{"$f":"Wat_S/DensWatP/1000","v":2.0833333333333336E-7},{"$f":"D26*E24","v":347916.66666666669},{"$f":"D14*F25","v":9.5259285842454702E-2},{"$f":"E26*F26","v":33142.293199354033}]
[null,null,"Inflow Water: Bulk","-","-",{"$f":"D28*F28+D29*F29","v":1.7953003409294816E-3},"-"]
[null,null,"    Liquid Phase",{"$f":"1-D29","v":0.99999000000000005},"-",{"$f":"F25","v":1.7943656917279744E-3},"-"]
[null,null,"    Suspended Particles",{"$f":"Inf_S/DensWatP/1000","v":1.0000000000000001E-5},"-",{"$f":"D15*F28","v":9.5259285842454702E-2},"-"]
[null,null,"Sediment: Bulk","-",{"$f":"Area*Depth_Sed","v":97500000},{"$f":"D31*F31+D32*F32","v":2.5975237753454155E-3},{"$f":"E30*F30","v":253258.568096178}]
[null,null,"    Pore Water",{"$f":"1-D32","v":0.85},{"$f":"D31*E30","v":82875000},{"$f":"F25","v":1.7943656917279744E-3},{"$f":"E31*F31","v":148708.05670195588}]
[null,null,"    Solids",{"$f":"Sed_S","v":0.15},{"$f":"D32*E30","v":14625000},{"$f":"D16*F31","v":7.1487529158442498E-3},{"$f":"E32*F32","v":104550.51139422215}]
[null,null,"Resuspended Sediment","-","-",{"$f":"D17*F31","v":5.9429391710030498E-3},"-"]
[null,null,"Rain","-","-",{"$f":"F25","v":1.7943656917279744E-3},"-"]
[]
[null,null,"Advection, Reaction and ","Flow Rate (G)","D Value",null,"Rate Constants","h-1"]
[null,null,"Intercompartmental Transfers","m³/h","mol/Pa·h",null,"Reaction in Water",{"$f":"LN(2)/HL_Wat","v":4.0773363562349721E-3}]
[null,null,"Water Inflow",{"$f":"Inflow*D28","v":23999760},{"$f":"D38*F28","v":43064.345953705371},null,"Reaction in Sediment",{"$f":"LN(2)/HL_Sed","v":4.0773363562349722E-4}]
[null,null,"Suspended Particle Inflow",{"$f":"Inflow*D29","v":240.00000000000003},{"$f":"D39*F29","v":22.862228602189131}]
[null,null,"Water Outflow",{"$f":"Outflow*D25","v":24399994.916666664},{"$f":"D40*F25","v":43782.513756803637},null,"Total D values","mol/Pa·h"]
[null,null,"Suspended Particle Outflow",{"$f":"Outflow*D26","v":5.0833333333333339},{"$f":"D41*F26","v":0.48423470303247812},null,"From Air",{"$f":"E42+E43+E44+E45","v":338369.0710122016}]
[null,null,"Rain Dissolution and Deposition",{"$f":"Rain*Area/365/24","v":1869863.01369863},{"$f":"D42*F25","v":3355.2180400118973},null,"From Water",{"$f":"E40+E41+E45+E46+E47+E50","v":12611076.905611588}]
[null,null,"Dry Aerosol Deposition",{"$f":"AerslDep*Area*D23","v":2.8080000000000003},{"$f":"D43*F23","v":0.53513352386222945},null,"Inflow",{"$f":"E38+E39","v":43087.208182307557}]
[null,null,"Wet Aerosol Deposition",{"$f":"D42*D23*ScavRatio","v":7.4794520547945202},{"$f":"D44*F23","v":1.4253937089176583},null,"From Sediment",{"$f":"E47+E49+E48+E51","v":14101.908833779898}]
[null,null,"Volatilization",{"$f":"Area*KAW/(KAW/VolWatMTC+1/VolAMTC)","v":186702127.65957448},{"$f":"D45*F25","v":335011.89244495693}]
[null,null,"Sedimentation",{"$f":"SedRate*Area/DensSedS/24/1000","v":473.95833333333331},{"$f":"D46*F26","v":45.148932352413425},null,"Intercompartmental D Values"]
[null,null,"Water-Sediment Diffusion",{"$f":"Diffusion*Area","v":7800000},{"$f":"D47*F31","v":13996.0523954782},null,null,"mol/Pa·h"]
[null,null,"Sediment Resuspension",{"$f":"ReSusRate*Area/DensSedS/24/1000","v":196.69270833333334},{"$f":"D48*F33","v":1.1689328010048448},null,"air to water",{"$f":"H41","v":338369.0710122016}]
[null,null,"Sediment Burial",{"$f":"Burial*Area/DensSedS/24/1000","v":199.40104166666666},{"$f":"D49*F32","v":1.4254687780369639},null,"water to air",{"$f":"E45","v":335011.89244495693}]
[null,null,"Reaction in Water","-",{"$f":"H37*G24","v":12218240.813847294},null,"water to sediment",{"$f":"E46+E47","v":14041.201327830613}]
[null,null,"Reaction in Sediment","-",{"$f":"H38*G30","v":103.26203672265569},null,"sediment to water",{"$f":"E47+E48","v":13997.221328279205}]
[]
[]
[null,null,null,"Fugacity","Activity"]
[null,null,null,"Pa",null,null,"Total Chemical Mass in Water-Sediment System"]
[null,null,"Air: Bulk",{"$f":"D63/F21","v":2.5387981837200805E-7},{"$f":"IF(Pv=0,\"N/A\",D56/D11)","v":1.9990536879685672E-11},null,null,{"$f":"G66+G72","v":733.60845227213247},"mol"]
[null,null,"Water: Bulk",{"$f":"(Emis_molph+H41*D56+H43*D58)/(H42-H50*H51/H44)","v":2.447911095511796E-7},{"$f":"IF(Pv=0,\"N/A\",D57/D11)","v":1.9274890515840913E-11},null,null,{"$f":"H66+H72","v":57.302156206976271},"kg"]
[null,null,"Inflow Water: Bulk",{"$f":"D69/F27","v":3.5655477192528117E-5},{"$f":"IF(Pv=0,\"N/A\",D58/D11)","v":2.8075178891754421E-9}]
[null,null,"Sediment: Bulk",{"$f":"D57*H50/H44","v":2.4373730485604405E-7},{"$f":"IF(Pv=0,\"N/A\",D59/D11)","v":1.9191913768192447E-11}]
[]
[null,null,null,"Concentrations",null,null,"Amounts"]
[null,null,null,"mol/m³","g/m³","µg/g dry wgt","mol","kg","%"]
[null,null,"Air: Bulk",{"$f":"ConcAir","v":1.0241966457559852E-10},{"$f":"D63*MolarMass","v":8.0000000000000005E-9},"-","-","-","-"]
[null,null,"    Gas Phase",{"$f":"D56*F22","v":1.0241966360998594E-10},7.9999999245760013E-9,"-","-","-","-"]
[null,null,"    Aerosols",{"$f":"D56*F23","v":4.8383049089357353E-8},3.7791999643697028E-6,{"$f":"E65*1000/DensAersl","v":2.5194666429131355E-6},"-","-","-"]
[null,null,"Water: Bulk",{"$f":"$D$57*F24","v":4.3924953515647481E-10},3.430978119107225E-8,"-",{"$f":"$D$57*G24","v":733.54672371131301},{"$f":"G66*MolarMass/1000","v":57.29733458909066},{"$f":"G66/$H$56*100","v":99.991585625734231}]
[null,null,"    Liquid Phase",{"$f":"$D$57*F25","v":4.3924476861866072E-10},3.4309408876803592E-8,"-",{"$f":"$D$57*G25","v":733.53861077258773},{"$f":"G67*MolarMass/1000","v":57.296700887446832},{"$f":"G67/$H$56*100","v":99.990479730798029}]
[null,null,"    Suspended Particles",{"$f":"$D$57*F26","v":2.331862627642746E-8},1.8214178984517489E-6,{"$f":"E68*1000/DensWatP","v":7.5892412435489537E-7},{"$f":"$D$57*G26","v":8.1129387253403868E-3},{"$f":"G68*MolarMass/1000","v":6.3370164383633762E-4},{"$f":"G68/$H$56*100","v":1.1058949362174044E-3}]
[null,null,"Inflow Water: Bulk",{"$f":"ConcInf","v":6.4012290359749078E-8},5.0000000000000004E-6,"-","-","-","-"]
[null,null,"    Liquid Phase",{"$f":"D58*F28","v":6.397896499646173E-8},{"$f":"D70*MolarMass","v":4.9973969558736254E-6},"-","-","-","-"]
[null,null,"    Suspended Particles",{"$f":"D58*F29","v":3.3965152937321604E-6},2.6530180959341906E-4,{"$f":"E71*1000/DensWatP","v":1.1054242066392462E-4},"-","-","-"]
[null,null,"Sediment: Bulk",{"$f":"$D$59*F30","v":6.33113444302188E-10},4.9452491134443901E-8,"-",{"$f":"$D$59*G30","v":6.1728560819463332E-2},{"$f":"G72*MolarMass/1000","v":4.8216178856082806E-3},{"$f":"G72/$H$56*100","v":8.4143742657650147E-3}]
[null,null,"    Pore Water",{"$f":"$D$59*F31","v":4.3735385762792768E-10},3.4161709819317429E-8,"-",{"$f":"$D$59*G31","v":3.6245700950914506E-2},{"$f":"G73*MolarMass/1000","v":2.8311517012759324E-3},{"$f":"G73/$H$56*100","v":4.9407420046285325E-3}]
[null,null,"    Solids",{"$f":"$D$59*F32","v":1.7424177687896638E-9},1.3610025192016063E-7,{"$f":"E74*1000/DensSedS","v":5.6708438300066929E-8},{"$f":"$D$59*G32","v":2.548285986854883E-2},{"$f":"G74*MolarMass/1000","v":1.9904661843323491E-3},{"$f":"G74/$H$56*100","v":3.473632261136483E-3}]
[null,null,"Rain",{"$f":"D56*F34","v":4.5555323590886075E-10},3.5583263256841112E-8,"-","-","-","-"]
[]
[]
[null,null,"MASS BALANCES",null,null,null,"Rate Details","kg/year","mol/h"]
[null,null,null,null,null,null,"Emission to Water",{"$f":"Emis_kgpy","v":1000},{"$f":"Emis_molph","v":1.4614678164326274}]
[null,null,"System","kg/year","mol/h",null,"Water Inflow",{"$f":"I80*MolarMass*365*24/1000","v":1050.6422294755112},{"$f":"E38*D58","v":1.5354798049634824}]
[null,null,"Total Chemical Inputs",{"$f":"SUM(D82:D84)","v":2109.980000028309},{"$f":"SUM(E82:E84)","v":3.083667863357888},null,"Particle Inflow",0.55777052448920428,{"$f":"E39*D58","v":8.1516367049571856E-4}]
[null,null,"    Emission",{"$f":"Emis_kgpy","v":1000},{"$f":"Emis_molph","v":1.4614678164326274},null,"Water Outflow",7.3334287631655277,{"$f":"E40*D57","v":1.0717570121467746E-2}]
[null,null,"    Inflow",{"$f":"E83*MolarMass/1000*365*24","v":1051.2},{"$f":"H43*D58","v":1.536294968633978},null,"Particle Outflow",8.1107739018056407E-5,{"$f":"E41*D57","v":1.1853635023850628E-7}]
[null,null,"    Air to water transfer",{"$f":"E84*MolarMass/1000*365*24","v":58.780000028309217},{"$f":"H41*D56","v":8.5905078291282841E-2},null,"Rain Dissolution",0.58285385214705743,{"$f":"E42*D56","v":8.5182214659670528E-4}]
[null,null,null,null,null,null,"Dry Aerosol Deposition",9.2961063059563085E-5,{"$f":"E43*D56","v":1.3585960184291545E-7}]
[null,null,"Total Chemical Losses",{"$f":"SUM(D87:D90)","v":2109.9800000283099},{"$f":"SUM(E87:E90)","v":3.0836678633578889},null,"Wet Aerosol Deposition",2.4761318166550294E-4,{"$f":"E44*D56","v":3.6187869592861798E-7}]
[null,null,"    Outflow",{"$f":"E87*MolarMass*24*365/1000","v":7.333509870904547},{"$f":"(E40+E41)*D57","v":1.0717688657817985E-2},null,"Absorption",58.19680560191744,{"$f":"E45*D56","v":8.505275840638836E-2}]
[null,null,"    Water to air transfer",{"$f":"E88*MolarMass*24*365/1000","v":56.113403211723728},{"$f":"E45*D57","v":8.2007932864441455E-2},null,"Volatilization",56.113403211723735,{"$f":"E45*D57","v":8.2007932864441455E-2}]
[null,null,"    Total Transformation",{"$f":"E89*MolarMass*24*365/1000","v":2046.5328492121409},{"$f":"E50*D57+E51*D59","v":2.9909418943957111},null,"Sedimentation",7.5622994371343545E-3,{"$f":"E46*D57","v":1.1052057245598431E-5}]
[null,null,"    Sediment Burial",{"$f":"E90*MolarMass*24*365/1000","v":2.3773354035482779E-4},{"$f":"E49*D59","v":3.4743991811516807E-7},null,"Water-Sediment Diffusion",2.3442932897342357,{"$f":"E47*D57","v":3.4261091952255537E-3}]
[null,null,null,null,null,null,"Sediment-Water Diffusion",2.3342013085343214,{"$f":"E47*D59","v":3.4113600894978358E-3}]
[null,null,"Residence Time","h","d",null,"Sediment Resuspension",1.9494957553715088E-4,{"$f":"E48*D59","v":2.8491253047474735E-7}]
[null,null,"   Water",{"$f":"G66/(E87+I94+E88)","v":237.88320471062508},{"$f":"D93/24","v":9.9118001962760456},null,"Sediment Burial",2.3773354035482779E-4,{"$f":"E49*D59","v":3.4743991811516807E-7}]
[null,null,"   Sediment",{"$f":"G72/(E90+I95)","v":2419.1861949991953},{"$f":"D94/24","v":100.79942479163314},null,"Water Transformation",2046.5156276146201,{"$f":"E50*D57","v":2.9909167255851865}]
[null,null,"   System",{"$f":"H56/E86","v":237.90125421396274},{"$f":"D95/24","v":9.9125522589151149},null,"Sediment Transformation",1.7221597521156373E-2,{"$f":"E51*D59","v":2.5168810524725946E-5}]
[]
[null,null,"Water","kg/year","mol/h"]
[null,null,"Total Chemical Inputs",{"$f":"SUM(D99:D102)","v":2112.3143962864187},{"$f":"SUM(E99:E102)","v":3.0870795083599165}]
[null,null,"    Emission",{"$f":"Emis_kgpy","v":1000},{"$f":"Emis_molph","v":1.4614678164326274},null,"Water Response Times"]
[null,null,"    Inflow",{"$f":"D83","v":1051.2},{"$f":"E83","v":1.536294968633978},null,null,"h","d"]
[null,null,"    Air to water transfer",{"$f":"D84","v":58.780000028309217},{"$f":"E84","v":8.5905078291282841E-2},null,"Water Inflow",{"$f":"IF(E38=0,\"N/A\",$G$24/E38)","v":69584.784276314982},{"$f":"IF(H101 = \"N/A\",H101,H101/24)","v":2899.3660115131242}]
[null,null,"    Sediment to water transfer",{"$f":"H91+H92","v":2.3343962581098587},{"$f":"I91+I92","v":3.4116450020283107E-3},null,"Particle Inflow",131073102.07292083,5461379.2530383682]
[null,null,null,null,null,null,"Water Outflow",68443.379926387221,2851.8074969328009]
[null,null,"Total Chemical Losses",{"$f":"SUM(D105:D108)","v":2112.3143962864197},{"$f":"SUM(E105:E108)","v":3.087079508359917},null,"Particle Outflow",6188369409.3444586,257848725.38935244]
[null,null,"    Outflow",{"$f":"D87","v":7.333509870904547},{"$f":"E87","v":1.0717688657817985E-2},null,"Rain Dissolution",893123.24488412694,37213.46853683862]
[null,null,"    Water to air transfer",{"$f":"D88","v":56.113403211723728},{"$f":"E88","v":8.2007932864441455E-2},null,"Dry Aerosol Deposition",5599767328.2765017,233323638.67818758]
[null,null,"    Water to sediment transfer",{"$f":"H89+H90","v":2.3518555891713699},{"$f":"I90+I89","v":3.4371612524711523E-3},null,"Wet Aerosol Deposition",{"$f":"IF(E44=0,\"N/A\",$G$24/E44)","v":2102312648.3872352},87596360.349468127]
[null,null,"    Transformation in water",{"$f":"H94","v":2046.5156276146201},{"$f":"I94","v":2.9909167255851865},null,"Volatilization/Absorption",{"$f":"IF(E45=0,\"N/A\",$G$24/E45)","v":8944.8264099506159},{"$f":"IF(H108 = \"N/A\",H108,H108/24)","v":372.70110041460902}]
[null,null,null,null,null,null,"Sedimentation",{"$f":"IF(E46=0,\"N/A\",$G$24/E46)","v":66371962.016705416},{"$f":"IF(H109 = \"N/A\",H109,H109/24)","v":2765498.4173627258}]
[null,null,null,"h","d",null,"Water-Sediment Diffusion",{"$f":"IF(E47=0,\"N/A\",$G$24/E47)","v":214104.88747222221},{"$f":"IF(H110 = \"N/A\",H110,H110/24)","v":8921.0369780092587}]
[null,null,"Response Time",{"$f":"G66/E104","v":237.61834501665518},{"$f":"D111/24","v":9.9007643756939654},null,"Sediment Resuspension",{"$f":"IF(E48=0,\"N/A\",$G$24/E48)","v":2563554740.3693452},{"$f":"IF(H111 = \"N/A\",H111,H111/24)","v":106814780.84872271}]
[null,null,null,null,null,null,"Transformation",{"$f":"IF(E50=0,\"N/A\",G24/E50)","v":245.25815695112379},{"$f":"IF(H112 = \"N/A\",H112,H112/24)","v":10.219089872963492}]
[null,null,"Sediment","kg/year","mol/h"]
[null,null,"Total Chemical Inputs",{"$f":"D115","v":2.3518555891713699},{"$f":"E115","v":3.4371612524711523E-3}]
[null,null,"    Water to sediment transfer",{"$f":"D107","v":2.3518555891713699},{"$f":"E107","v":3.4371612524711523E-3},null,"Sediment Response Times"]
[null,null,null,null,null,null,null,"h","d"]
[null,null,"Total Chemical Losses",{"$f":"SUM(D118:D120)","v":2.3518555891713699},{"$f":"SUM(E118:E120)","v":3.4371612524711518E-3},null,"Sedimentation",{"$f":"IF(E46=0,\"N/A\",$G$30/E46)","v":5609.4032549728745},{"$f":"IF(H117=\"N/A\",H117,H117/24)","v":233.72513562386976}]
[null,null,"    Sediment to water transfer",{"$f":"D102","v":2.3343962581098587},{"$f":"E102","v":3.4116450020283107E-3},null,"Water-Sediment Diffusion",{"$f":"IF(E47=0,\"N/A\",$G$30/E47)","v":18.094999999999999},{"$f":"IF(H118=\"N/A\",H118,H118/24)","v":0.75395833333333329}]
[null,null,"    Transformation in sediment",{"$f":"H95","v":1.7221597521156373E-2},{"$f":"I95","v":2.5168810524725946E-5},null,"Sediment Resuspension",{"$f":"IF(E48=0,\"N/A\",$G$30/E48)","v":216657.93609219487},{"$f":"IF(H119=\"N/A\",H119,H119/24)","v":9027.4140038414535}]
[null,null,"    Sediment Burial",{"$f":"H93","v":2.3773354035482779E-4},{"$f":"I93","v":3.4743991811516807E-7},null,"Sediment Burial",{"$f":"IF(E49=0,\"N/A\",$G$30/E49)","v":177666.86440157917},{"$f":"IF(H120=\"N/A\",H120,H120/24)","v":7402.7860167324652}]
[null,null,null,null,null,null,"Transformation",{"$f":"IF(E51=0,\"N/A\",G30/E51)","v":2452.5815695112378},{"$f":"IF(H121=\"N/A\",H121,H121/24)","v":102.19089872963491}]
[null,null,null,"h","d"]
[null,null,"Response Time",{"$f":"G72/E117","v":17.959169292707315},{"$f":"D123/24","v":0.74829872052947144}]

{"sheet":"Diagram","index":8,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Chemical Name:",null,{"$f":"ChemName","v":"Benzene (example)"}]
[]
[null,null,null,"Lake Name:",null,{"$f":"EnvName","v":"Lake Ontario 1990s data"}]
[]
[]
[null,null,null,null,null,"Air"]
[null,{"$f":"Results!H57","v":57.302156206976271},"kg"]
[null,null,null,null,null,"Fugacity",{"$f":"Results!D56*10^6","v":0.25387981837200807},"µPa"]
[null,null,null,null,null,"Concentration",{"$f":"Results!E63*10^9","v":8},"ng/m³"]
[null,{"$f":"Results!D95","v":237.90125421396274},"h"]
[null,{"$f":"Results!E95","v":9.9125522589151149},"d",null,{"$f":"Results!D99","v":1000}]
[]
[null,null,null,null,null,{"$f":"Results!D106","v":56.113403211723728},null,{"$f":"Results!D101","v":58.780000028309217}]
[]
[]
[null,"Inflow Water"]
[null,null,null,null,null,"Water",null,null,{"$f":"Results!D87","v":7.333509870904547}]
[null,"Fugacity",{"$f":"Results!D58*10^6","v":35.655477192528117},"µPa",{"$f":"Results!D100","v":1051.2}]
[null,"Concentration",{"$f":"Results!E69*10^6","v":5},"ng/L",null,"Chemical Mass",{"$f":"Results!H66","v":57.29733458909066},"kg"]
[null,null,null,null,null,"% of total chem.",{"$f":"Results!I66","v":99.991585625734231},null,{"$f":"Results!D108","v":2046.5156276146201}]
[null,null,null,null,null,"Fugacity",{"$f":"Results!D57*10^6","v":0.24479110955117961},"µPa"]
[null,null,null,null,null,"Concentration",{"$f":"Results!E66*10^6","v":3.4309781191072253E-2},"ng/L"]
[]
[]
[]
[null,"LEGEND",null,null,null,{"$f":"Results!D118","v":2.3343962581098587},null,{"$f":"Results!D115","v":2.3518555891713699}]
[]
[null,"Emissions (kg/y)"]
[]
[null,"Advection (kg/y)",null,null,null,"Sediment",null,null,{"$f":"Results!D90","v":2.3773354035482779E-4}]
[]
[null,"Reaction (kg/y)",null,null,null,"Chemical Mass",{"$f":"Results!H72","v":4.8216178856082806E-3},"kg"]
[null,null,null,null,null,"% of total chem.",{"$f":"Results!I72","v":8.4143742657650147E-3},null,{"$f":"Results!D119","v":1.7221597521156373E-2}]
[null,"Exchange (kg/y)",null,null,null,"Fugacity",{"$f":"Results!D59*10^6","v":0.24373730485604406},"µPa"]
[null,null,null,null,null,"Concentration",{"$f":"Results!E72*10^6","v":4.9452491134443902E-2},"ng/L"]
[null,null,null,null,null,null,{"$f":"Results!F74","v":5.6708438300066929E-8},"µg/g dry wt"]