{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Cover Page","ReadMe","Release Summary","Release Point Summary","Release Parameters","Release Calcs","Release Results","Static Release Results"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":327,"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":"Cover Page","index":0,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Repackaging Release Model for 1,2-Dichloroethane"]
[]
["CASRN 107-06-2"]

{"sheet":"ReadMe","index":1,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,1,17,2],[3,1,3,2],[16,1,16,2],[15,1,15,2],[13,1,13,2],[14,1,14,2]]}
[]
[null,"Instructions for Using this Spreadsheet"]
[]
[null,"Table of Contents"]
[null,"Worksheet","Description"]
[null,"Instructions (this worksheet)","Provides instructions to the user on the use of this spreadsheet"]
[null,"Release Point Summary","Summarizes the Release Points and associated parameters used to calculate the amount of annual release from each Release Point"]
[null,"Release Parameters","A list of parameters for the release calculations. Allows an advanced user to select between performing a deterministic or Monte Carlo simulation. Monte Carlo formulas on this worksheet are based on the Monte Carlo simulator @Risk. Certain cells will appear with the \"#NAME?\" error indicator if a user does not have the program @Risk. The user must not alter parameters in this worksheet. Turn Monte Carlo \"Off\" using the toggle at the top of the sheet to view deterministic calculations (@Risk not needed for this)."]
[null,"Release Calcs","Performs the release calculations. This worksheet contains @Risk formulas to capture results during a Monte Carlo simulation iteration. Certain cells will appear with the \"#NAME?\" error indicator if a user does not have the program @Risk. The user must not alter this worksheet."]
[null,"Release Results","Provides the release results for the baseline scenario from the Monte Carlo simulation. The user must not alter this worksheet."]
[null,"Static Release Results","Fixed number of sites, PV=25,000 lbs\n\nProvides static release results from running the simulation with the specified parameters for the given scenario. @Risk not needed to view."]
[]
[]
[null,"General Notes/Assumptions"]
[null,"General 1,2-Dichloroethane (1,2-DCA) Info:  \n -  Total PV = 30,000,000,000 - <40,000,000,000 lb (each year from 2016-2019) (Manufactured domestically)\n -  Number of sites that repackage 1,2-dichloroethane are unknown; assume 1,2-dichloroethane only has one import site based on 2020 CDR (only one manufacturing site). \n -  PV for Repackaging is unknown; assumed  PV of 2,500 to 25,000 lb/site based on CDR reporting threshold of 25,000 lb/yr\n - # of days calculated to be: 119 days (50th percentile) to 24 days (95th percentile) \n - 1,2-Dichloroethane is a volatile liquid, VP = 78.9 torr; MW = 98.96 g/mol; assume 1,2-dichloroethane imported in pure liquid form\n - No dust or solid releases for 1,2-dichloroethane are expected since it is assumed to be managed as a liquid."]
[null,"Applied ESD on Transport and Storage of Chemicals to address importing pure 1,2-dichloroethane in containers."]
[null,"Potential for 1,2-dichloroethane to be imported and stored in drums, which would only constitute repackaging into smaller containers; conservative estimate that 1,2-dichloroethane imported in larger quantity and transferred to drums first."]
[null,"Assume one imported container unloaded per day for repackaging, so number of containers unloaded per year is equal to number of release days per year. Note that the annual production volume per site that is selected for the simulation should not exceed 35,000 kg/site-yr, or the number of release days will begin to approach 365 days/year. "]

{"sheet":"Release Summary","index":2,"n_rows":22,"n_cols":19,"rows_kept":22,"cut":false,"hidden":false,"merged":[[3,5,4,5],[3,6,4,6],[3,7,3,12],[3,0,4,0],[3,1,4,1],[3,2,4,2],[16,3,20,3],[21,0,22,5],[3,13,3,18],[5,3,9,3],[10,0,11,5],[14,0,15,0],[14,1,15,1],[14,2,15,2],[14,3,15,3],[14,4,15,4],[14,5,15,5],[14,6,15,6],[14,7,14,12],[14,13,14,18],[3,3,4,3],[3,4,4,4]]}
["Release Summary - 50th and 95th Percentile estimates"]
[]
["50th Percentile"]
["Release Source","Media of Release","Daily Release (kg/site-day)","Days per Year","Annual Release (kg/site-yr)","Release Duration (hr/day)","Release Pattern","Daily Release Estimate by Media (kg/site-day)",null,null,null,null,null,"Annual Release Estimate by Media (kg/site-yr)"]
[null,null,null,null,null,null,null,"Water (Direct)","Water (Indirect)","Hazardous Waste Incineration","Hazardous Waste Landfill","Stack Air","Fugitive Air","Water (Direct)","Water (Indirect)","Hazardous Waste Incineration","Hazardous Waste Landfill","Stack Air","Fugitive Air"]
["1. Emptying (drums)","Fugitive or Stack Air",{"$f":"INDEX('Static Release Results'!$B$43:$I$49,MATCH(A$3,'Static Release Results'!$A$43:$A$49, 0), MATCH($A6, 'Static Release Results'!$B$30:$F$30, 0))","v":7.0689253963578225E-2},{"$f":"'Static Release Results'!$F$11","v":119},{"$f":"INDEX('Static Release Results'!$B$34:$I$40,MATCH(A$3,'Static Release Results'!$A$43:$A$49, 0), MATCH($A6, 'Static Release Results'!$B$30:$F$30, 0))","v":2.9858998149280684},"mean: 1.12\nrange: 0.597 to 2.97","unknown - see operating days",null,null,null,null,{"$f":"C6","v":7.0689253963578225E-2},{"$f":"C6","v":7.0689253963578225E-2},null,null,null,null,{"$f":"E6","v":2.9858998149280684},{"$f":"E6","v":2.9858998149280684}]
["2. Storage","N/A","n/a",null,"n/a","N/A","unknown - see operating days"]
["3. Filling (small containers)","Fugitive or Stack Air",{"$f":"INDEX('Static Release Results'!$B$43:$I$49,MATCH(A$3,'Static Release Results'!$A$43:$A$49, 0), MATCH($A8, 'Static Release Results'!$B$30:$F$30, 0))","v":1.1729298893252856E-2},null,{"$f":"INDEX('Static Release Results'!$B$34:$I$40,MATCH(A$3,'Static Release Results'!$A$43:$A$49, 0), MATCH($A8, 'Static Release Results'!$B$30:$F$30, 0))","v":0.50198347739758897},"mean: 2.25\nrange: 0.994 to 3.97","unknown - see operating days",null,null,null,null,{"$f":"C8","v":1.1729298893252856E-2},{"$f":"C8","v":1.1729298893252856E-2},null,null,null,null,{"$f":"E8","v":0.50198347739758897},{"$f":"E8","v":0.50198347739758897}]
["4. Open Surface Losses to Air During Container Cleaning","Fugitive or Stack Air",{"$f":"INDEX('Static Release Results'!$B$43:$I$49,MATCH(A$3,'Static Release Results'!$A$43:$A$49, 0), MATCH($A9, 'Static Release Results'!$B$30:$F$30, 0))","v":9.0556809334665954E-4},null,{"$f":"INDEX('Static Release Results'!$B$34:$I$40,MATCH(A$3,'Static Release Results'!$A$43:$A$49, 0), MATCH($A9, 'Static Release Results'!$B$30:$F$30, 0))","v":3.8232542549967323E-2},"mean: 1.12\nrange: 0.597 to 2.97","unknown - see operating days",null,null,null,null,{"$f":"C9","v":9.0556809334665954E-4},{"$f":"C9","v":9.0556809334665954E-4},null,null,null,null,3.8232542549967323E-2,3.8232542549967323E-2]
["5. Container Cleaning (drums)","Hazardous Waste Landfill or Hazardous Waste Incineration*",{"$f":"INDEX('Static Release Results'!$B$43:$I$49,MATCH(A$3,'Static Release Results'!$A$43:$A$49, 0), MATCH($A10, 'Static Release Results'!$B$30:$F$30, 0))","v":6.4475837461718539},null,{"$f":"INDEX('Static Release Results'!$B$34:$I$40,MATCH(A$3,'Static Release Results'!$A$43:$A$49, 0), MATCH($A10, 'Static Release Results'!$B$30:$F$30, 0))","v":274.54943894509927},"N/A","unknown - see operating days",null,null,{"$f":"C10","v":6.4475837461718539},{"$f":"C10","v":6.4475837461718539},null,null,null,null,{"$f":"E10","v":274.54943894509927},{"$f":"E10","v":274.54943894509927}]
["* Note that incineration release estimates represent the amount of chemical sent for incineration and do not account for destruction efficiency. Water releases are not expected as 1,1-DCA is classified as hazardous by RCRA; according to the GS hazardous wastes are likely sent to hazardous landfill or incineration - water releases are not expected.",null,null,null,null,null,"Total Releases by Media:","","",{"$f":"SUM(J6:J10)","v":6.4475837461718539},{"$f":"SUM(K6:K10)","v":6.4475837461718539},{"$f":"SUM(L6:L10)","v":8.3324120950177744E-2},{"$f":"SUM(M6:M10)","v":8.3324120950177744E-2},"","",{"$f":"SUM(P6:P10)","v":274.54943894509927},{"$f":"SUM(Q6:Q10)","v":274.54943894509927},{"$f":"SUM(R6:R10)","v":3.526115834875625},{"$f":"SUM(S6:S10)","v":3.526115834875625}]
[]
[]
["95th Percentile"]
["Release Source","Media of Release","Daily Release (kg/site-day)","Days per Year","Annual Release (kg/site-yr)","Release Duration (hr/day)","Release Pattern","Daily Release Estimate by Media (kg/site-day)",null,null,null,null,null,"Annual Release Estimate by Media (kg/site-yr)"]
[null,null,null,null,null,null,null,"Water (Direct)","Water (Indirect)","Hazardous Waste Incineration","Hazardous Waste Landfill","Stack Air","Fugitive Air","Water (Direct)","Water (Indirect)","Hazardous Waste Incineration","Hazardous Waste Landfill","Stack Air","Fugitive Air"]
["1. Emptying (drums)","Fugitive or Stack Air",{"$f":"INDEX('Static Release Results'!$B$43:$I$49,MATCH(A$14,'Static Release Results'!$A$43:$A$49, 0), MATCH($A17, 'Static Release Results'!$B$30:$F$30, 0))","v":0.13346088666204448},{"$f":"'Static Release Results'!$F$12","v":24},{"$f":"INDEX('Static Release Results'!$B$34:$I$40,MATCH(A$14,'Static Release Results'!$A$43:$A$49, 0), MATCH($A17, 'Static Release Results'!$B$30:$F$30, 0))","v":4.7462066106253493},"mean: 1.12\nrange: 0.597 to 2.97","unknown - see operating days",null,null,null,null,{"$f":"C17","v":0.13346088666204448},{"$f":"C17","v":0.13346088666204448},null,null,null,null,{"$f":"E17","v":4.7462066106253493},{"$f":"E17","v":4.7462066106253493}]
["2. Storage","N/A","n/a",null,"n/a","N/A","unknown - see operating days"]
["3. Filling (small containers)","Fugitive or Stack Air",{"$f":"INDEX('Static Release Results'!$B$43:$I$49,MATCH(A$14,'Static Release Results'!$A$43:$A$49, 0), MATCH($A19, 'Static Release Results'!$B$30:$F$30, 0))","v":2.4774005911712773E-2},null,{"$f":"INDEX('Static Release Results'!$B$34:$I$40,MATCH(A$14,'Static Release Results'!$A$43:$A$49, 0), MATCH($A19, 'Static Release Results'!$B$30:$F$30, 0))","v":1.2507103802604036},"mean: 2.25\nrange: 0.994 to 3.97","unknown - see operating days",null,null,null,null,{"$f":"C19","v":2.4774005911712773E-2},{"$f":"C19","v":2.4774005911712773E-2},null,null,null,null,{"$f":"E19","v":1.2507103802604036},{"$f":"E19","v":1.2507103802604036}]
["4. Open Surface Losses to Air During Container Cleaning","Fugitive or Stack Air",{"$f":"INDEX('Static Release Results'!$B$43:$I$49,MATCH(A$14,'Static Release Results'!$A$43:$A$49, 0), MATCH($A20, 'Static Release Results'!$B$30:$F$30, 0))","v":1.5077276880048293E-3},null,{"$f":"INDEX('Static Release Results'!$B$34:$I$40,MATCH(A$14,'Static Release Results'!$A$43:$A$49, 0), MATCH($A20, 'Static Release Results'!$B$30:$F$30, 0))","v":8.107524543074919E-2},"mean: 1.12\nrange: 0.597 to 2.97","unknown - see operating days",null,null,null,null,{"$f":"C20","v":1.5077276880048293E-3},{"$f":"C20","v":1.5077276880048293E-3},null,null,null,null,8.107524543074919E-2,8.107524543074919E-2]
["5. Container Cleaning (drums)","Hazardous Waste Landfill or Hazardous Waste Incineration*",{"$f":"INDEX('Static Release Results'!$B$43:$I$49,MATCH(A$14,'Static Release Results'!$A$43:$A$49, 0), MATCH($A21, 'Static Release Results'!$B$30:$F$30, 0))","v":10.05489750158541},null,{"$f":"INDEX('Static Release Results'!$B$34:$I$40,MATCH(A$14,'Static Release Results'!$A$43:$A$49, 0), MATCH($A21, 'Static Release Results'!$B$30:$F$30, 0))","v":319.74973325445524},"N/A","unknown - see operating days",null,null,{"$f":"C21","v":10.05489750158541},{"$f":"C21","v":10.05489750158541},null,null,null,null,{"$f":"E21","v":319.74973325445524},{"$f":"E21","v":319.74973325445524}]
["* Note that incineration release estimates represent the amount of chemical sent for incineration and do not account for destruction efficiency. Water releases are not expected as 1,1-DCA is classified as hazardous by RCRA; according to the GS hazardous wastes are likely sent to hazardous landfill or incineration - water releases are not expected.",null,null,null,null,null,"Total Releases by Media:","","",{"$f":"SUM(J17:J21)","v":10.05489750158541},{"$f":"SUM(K17:K21)","v":10.05489750158541},{"$f":"SUM(L17:L21)","v":0.15974262026176209},{"$f":"SUM(M17:M21)","v":0.15974262026176209},"","",{"$f":"SUM(P17:P21)","v":319.74973325445524},{"$f":"SUM(Q17:Q21)","v":319.74973325445524},{"$f":"SUM(R17:R21)","v":6.0779922363165015},{"$f":"SUM(S17:S21)","v":6.0779922363165015}]

{"sheet":"Release Point Summary","index":3,"n_rows":20,"n_cols":18,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,16,0,17],[1,12,1,13],[1,6,1,7],[1,4,1,5],[1,8,1,9],[1,10,1,11],[0,0,0,1],[0,3,0,13],[2,4,2,5],[2,6,2,7],[2,8,2,9],[2,10,2,11],[2,12,2,13]]}
["Parameter Definition",null,null,"Release Points (from ESD/GS)",null,null,null,null,null,null,null,null,null,null,null,null,"General Parameters"]
["Possible Parameters","Variable",null,"Release Point","1. Emptying (drums)",null,"2. Storage",null,"3. Filling (small containers)",null,"4. Open Surface Losses to Air During Container Cleaning",null,"5. Container Cleaning (drums)",null,null,null,"Number of Sites","Ns"]
["Saturation Factor Unloading","Fsaturation_unloading",null,"Expected/Conservative Release Media","fugitive air or stack air",null,"Not expected to lead to significant losses to the environment",null,"fugitive air or stack air",null,"fugitive air or stack air",null,"landfill or incineration",null,null,null,"Production Volume","PV"]
["1,2-DCA Molecular Weight","MW",null,"Input Parameters:","Saturation Factor Unloading","Fsaturation_unloading","-","-","Saturation Factor Loading","Fsaturation_loading","1,2-DCA Molecular Weight","MW","Container Loss Fraction","Floss_cont"]
["Import Container Volume","Vimport_cont",null,null,"1,2-DCA  Molecular Weight","MW",null,null,"1,2-DCA Molecular Weight","MW","1,2-DCA Mass Fraction/VP Correction Factor","F11DCA","Production Volume","PV"]
["Fill Rate of Drum","RATEfill_drum",null,null,"Import Container Volume","Vimport_cont",null,null,"Small Container Volume","Vfill_cont","1,2-DCA Vapor Pressure","VP"]
["1,1-DCA Vapor Pressure","VP",null,null,"Fill Rate of Drum","RATEfill_drum",null,null,"Fill Rate of Small Container","RATEfill_smallcont","Air Speed","RATEair_speed"]
["Gas Constant","R",null,null,"1,2-DCA Vapor Pressure","VP",null,null,"1,2-DCA Vapor Pressure","VP","Diameter of Opening for Container Cleaning","Dopening_cont-cleaning"]
["Temperature","T",null,null,"Gas Constant","R",null,null,"Gas Constant","R","Temperature","T"]
["Production Volume","PV",null,null,"Temperature","T",null,null,"Temperature","T","Pressure","P"]
["1,2-DCA Density","r",null,null,"Production Volume","PV",null,null,"Production Volume","PV","Fill Rate of Drum","RATEfill_drum"]
["Saturation Factor Loading","Fsaturation_loading",null,null,"1,2-DCA Density","r",null,null,"1,2-DCA Density","r","Import Container Volume","Vimport_cont"]
["Small Container Volume","Vfill_cont",null,null,null,null,null,null,null,null,"Production Volume","PV"]
["Fill Rate of Small Container","RATEfill_smallcont",null,null,null,null,null,null,null,null,"1,2-DCA Density","r"]
["1,2-DCA Mass Fraction/VP Correction Factor","F12-DCA"]
["Air Speed","RATEair_speed"]
["Diameter of Opening for Container Cleaning","Dopening_cont-cleaning"]
["Pressure","P"]
["Container Loss Fraction","Floss_cont"]
["Number of Sites","Ns"]

{"sheet":"Release Parameters","index":4,"n_rows":31,"n_cols":16,"rows_kept":31,"cut":false,"hidden":false,"merged":[[3,9,4,9],[3,11,4,11],[3,12,4,12],[10,1,11,1],[10,2,11,2],[10,12,11,12],[3,1,4,1],[3,3,4,3],[3,2,4,2],[3,6,3,8],[3,4,3,5]]}
[]
[null,"Turn Monte Carlo On or Off","On"]
[]
[null,"Input Parameter","Symbol","Unit","Deterministic Values",null,"Uncertainty Analysis Distribution Parameters",null,null,"Distribution Type",null,"Selected Value (Deterministic or @Risk Formula)","Notes/Comments"]
[null,null,null,null,"Value","Basis","Lower Bound","Upper Bound","Mode",null,"@Risk Formulas",null,null,null,null,"On/Off Drop Down"]
[null,"Container Loss Fraction","Floss_cont","kg/kg",2.5000000000000001E-2,"Typical",1.7000000000000001E-2,0.03,2.5000000000000001E-2,"Triangular",{"$f":"_xll.RiskTriang(G6,I6,H6,_xll.RiskStatic(E6))","v":{"$error":"#NAME?"}},{"$f":"IF($C$2=$P$6, K6, E6)","v":{"$error":"#NAME?"}},"Loss fractions for container residual are consistent with EPA/OPPT Drum residual Model using 0.03 loss fraction as high-end and 0.025 as central tendency. Minimum of 0.017 is per review of data used to develop drum model and preliminary EPA guidance on 5/25/2022.",null,null,"On"]
[null,"Saturation Factor Unloading","Fsaturation_unloading","kg/kg",0.5,"Typical",0.5,1.45,0.5,"Triangular",{"$f":"_xll.RiskTriang(G7,I7,H7,_xll.RiskStatic(E7))","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},"AP-42 provided values",null,null,"Off"]
[null,"Saturation Factor Loading","Fsaturation_loading","kg/kg",0.5,"Typical",0.5,1.45,0.5,"Triangular",{"$f":"_xll.RiskTriang(G8,I8,H8,_xll.RiskStatic(E8))","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},"AP-42 provided values"]
[null,"Import Container Volume","Vimport_cont","gal/container",55,"Typical",20,100,55,"Triangular",{"$f":"_xll.RiskTriang(G9,I9,H9,_xll.RiskStatic(E9))","v":{"$error":"#NAME?"}},{"$f":"IF($C$2=$P$6, K9, E9)","v":{"$error":"#NAME?"}},"Standard EPA values for Vapor Generation Rate/Volatile Air Release Models given as 20 to <100 gallons for drum volume, with 55 gallons as default value. Typically use drums for given throughput as suggested in ESD on Transport and Storage (HERO ID 6393282)."]
[null,"Small Container Volume","Vfill_cont","gal/container",5,"Typical",5,20,5,"Triangular",{"$f":"_xll.RiskTriang(G10,I10,H10,_xll.RiskStatic(E10))","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},"Standard EPA values for Vapor Generation Rate/Volatile Air Release Models given as 5 to <20 gallons for small container volume, with 5 gallons as default value. "]
[null,"Air Speed","RATEair_speed","cm/s",10,"50th percentile",1.3,202.2,"—","Lognormal",{"$f":"_xll.RiskLognorm(22.414,19.958,_xll.RiskTruncate(G11,H11),_xll.RiskName(B11),_xll.RiskStatic(E11))","v":{"$error":"#NAME?"}},{"$f":"IF($C$2=$P$6, K11, E11)","v":{"$error":"#NAME?"}},"Distribution using EPA's air speed model for industrial uses; converted to ft/min for model use. For industrial facilities, it’s a lognormal distribution with mean of 22.414 cm/s, standard deviation of 19.958 cm/s, max truncated at 202.2 cm/s."]
[null,null,null,"ft/min",{"$f":"E11*ft_per_cm*60","v":19.684799999999999},"50th percentile",{"$f":"G11*ft_per_cm*60","v":2.559024},{"$f":"H11*ft_per_cm*60","v":398.02665599999995},"—","Lognormal",{"$f":"(K11*ft_per_cm*60)","v":{"$error":"#NAME?"}},{"$f":"IF($C$2=$P$6, K12, E12)","v":{"$error":"#NAME?"}}]
[]
[null,"Constants and Unit Conversions","Symbol","Value","Unit","Notes/Comments"]
[null,"Number of Sites","Ns",1,"sites","what-if scenario "]
[null,"Production Volume Assessed","PV_lbs",25000,"lbs/yr","what-if scenario"]
[null,"Production Volume","PV",{"$f":"D16/lbs_per_kg","v":11339.822735890993},"kg/yr","used for calcs"]
[null,"1,2-DCA Import Mass Fraction","F12DCA",1,"kg/kg","also use for vapor pressure correction factor"]
[null,"1,2-DCA Molecular Weight","MW",98.96,"g/mol","Final Scope (mmHg)"]
[null,"Fill Rate of Drum","RATEfill_drum",20,"containers/hr"]
[null,"Fill Rate of Small Container","RATEfill_smallcont",60,"containers/hr"]
[null,"Diameter of Opening for Container Cleaning","Dopening_cont-cleaning",5.08,"cm"]
[null,"1,2-DCA Vapor Pressure","VP",78.900000000000006,"Torr","Final Scope (mmHg)"]
[null,"1,2-DCA Density","rho12DCA",1256.9000000000001,"kg/m^3","Final Scope (mmHg)"]
[null,"Gas Constant","R",62.363669999999999,"L*torr/mol-K"]
[null,"Temperature","T",298,"K"]
[null,"Pressure","P",760,"torr"]
[null,"lb/kg","—",2.2046199999999998,"lb/kg"]
[null,"ft/cm","—",3.2807999999999997E-2,"ft/cm"]
[null,"m^3/gal","—",3.7854099999999999E-3,"m^3/gal"]
[null,"L/gal","—",3.7854000000000001,"L/gal"]

{"sheet":"Release Calcs","index":5,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Calculation of Baseline Releases"]
[]
[null,"Parameter Name","Symbol","Equation","Stochastic Value","Unit"]
[null,"Facility Production Rate","PVsite","PV/Ns",{"$f":"PV/Ns","v":11339.822735890993},"kg/site-year"]
[null,"Release Days per site/Number of Import Containers","RD","(PVsite/(rho11DCA*0.00378541 m3/gal*Vimport_cont)",{"$f":"_xll.RiskOutput(\"Release Days\")+ROUNDUP((PV/Ns)/(r_12DCA*m3_per_gal*V_importcont),0)","v":{"$error":"#NAME?"}},"days"]
[null,"Facility Daily Production Rate","Qchem_site_day","PV/(Nsites * RD)",{"$f":"PV/(2*RD)","v":{"$error":"#NAME?"}},"kg/site-day"]
[null,"Facility Annual Production Rate","Qchem_site_yr","PV/(Nsites)",{"$f":"PV/2","v":5669.9113679454967},"kg/site-day"]
[null,"Mass of Chemical in Unloaded Container","Qproc_container_unload","Vimport_container * RHO12DCA * m^3_per_gal",{"$f":"V_importcont*r_12DCA*m3_per_gal","v":{"$error":"#NAME?"}},"kg chemical/unload container"]
[null,"Mass of Chemical in Filled Container","Qproc_container_fill","Vsmall_container * RHO12DCA * m^3_per_gal",{"$f":"V_smallcont*r_12DCA*m3_per_gal","v":{"$error":"#NAME?"}},"kg chemical/fill container"]
[null,"Number of Transport Containers Unloaded Daily per Site","Ncont_unload_day","(Qchem_site_day * RD)/(Fchem * Qproc_cont_unload)",{"$f":"(Q_chem_site_day*RD)/(F_12DCA*Q_proc_container_unload)","v":{"$error":"#NAME?"}},"containers unloaded/day"]
[null,"Number of Transport Containers Unloaded Annually per Site","Ncont_unload_yr","(Qchem_site_yr * RD)/(Fchem * Qproc_cont_unload)",{"$f":"(Q_chem_site_yr*RD)/(F_12DCA*Q_proc_container_unload)","v":{"$error":"#NAME?"}},"containers unloaded/day"]
[null,"Number of Transport Containers Unloaded Daily per Site","Ncont_load_day","(Qchem_site_day * RD)/(Fchem * Qproc_cont_fill)",{"$f":"(Q_chem_site_day*RD)/(F_12DCA*Q_proc_container_load)","v":{"$error":"#NAME?"}},"containers loaded/day"]
[null,"Number of Transport Containers Unloaded Annually per Site","Ncont_load_yr","(Qchem_site_yr * RD)/(Fchem * Qproc_cont_fill)",{"$f":"(Q_chem_site_yr*RD)/(F_12DCA*Q_proc_container_load)","v":{"$error":"#NAME?"}},"containers loaded/day"]
[null,"Daily Hours Spent Unloading Containers","OHunload_day","Ncont_unload_day/RATEfill_drum",{"$f":"N_cont_unload_day/Rate_filldrum","v":{"$error":"#NAME?"}},"hours/day"]
[null,"Daily Hours Spent Filling Containers","OHload_day","Ncont_fill_day/RATEfill_smallcont",{"$f":"N_cont_load_day/Rate_fillsmallcont","v":{"$error":"#NAME?"}},"hours/day"]
[null,"Annual Hours Spent Unloading Containers","OHunload_yr","Ncont_unload_yr/RATEfill_drum",{"$f":"N_cont_unload_yr/Rate_filldrum","v":{"$error":"#NAME?"}},"hours/yr"]
[null,"Annual Hours Spent Filling Containers","OHload_yr","Ncont_fill_yr/RATEfill_smallcont",{"$f":"N_cont_load_yr/Rate_fillsmallcont","v":{"$error":"#NAME?"}},"hours/yr"]
[null,"Release Point 1 annual release per site (Emptying drums)","Release_YearRP1","(RD/RATEfill_drum)*(3600 s/hr)*(0.001 kg/g)*[Fsaturation_unloading*MW11DCA*(Vimport_cont*(3.7854 L/gal))*(RATEfill_drum/(3600 s/hr))*F11DCA*(VP)]/(R*T)",{"$f":"_xll.RiskOutput(,\"Annual Releases\",1)+(RD/Rate_filldrum)*3600*0.001*((Fsat_unload*MW_12DCA*(V_importcont*L_per_gal)*(Rate_filldrum/3600)*F_12DCA*VP_12DCA)/(R_Ltorr_molK*Temp))","v":{"$error":"#NAME?"}},"kg/site-yr"]
[null,"Release Point 3 annual release per site (Filling small containers)","Release_YearRP3","(RD/RATEfill_smallcont)*(3600 s/hr)*(0.001 kg/g)*[Fsaturation_loading*MW11DCA*(Vfill_cont*(3.7854 L/gal))*(RATEfill_smallcont/(3600 s/hr))*F11DCA*(VP)]/(R*T)",{"$f":"_xll.RiskOutput(,\"Annual Releases\",2)+(RD/Rate_fillsmallcont)*3600*0.001*((Fsat_unload*MW_12DCA*(V_smallcont*L_per_gal)*(Rate_fillsmallcont/3600)*F_12DCA*VP_12DCA)/(R_Ltorr_molK*Temp))","v":{"$error":"#NAME?"}},"kg/site-yr"]
[null,"Release Point 4 annual release per site (Open surface losses during container cleaning)","Release_YearRP4","Penetration Model (if air speed <= 100 ft/min):\n(RD/RATEfill_drum*(3600 s/hr))*(0.001 kg/g)*[[(8.24E-8*(MW11DCA^0.835)*F11DCA*VP*((1/29+1/MW11DCA)^0.25)*(RATEair_speed^0.5)*(0.25*pi*Dopening_cont-cleaning^2)]/(T^0.05*Dopening_cont-cleaning^0.5*P^0.5)]\n\nMass Transfer Coefficient Model (if air speed >100 ft/min):\n(RD/RATEfill_drum*(3600 s/hr))*(0.001 kg/g)*[[(1.93E-7*(MW11DCA^0.78)*F11DCA*VP*((1/29+1/MW11DCA)^0.33)*(RATEair_speed^0.78)*(0.25*pi*Dopening_cont-cleaning^2)]/(T^0.4*Dopening_cont-cleaning^0.11*(T^0.5-5.87)^(2/3)]",{"$f":"_xll.RiskOutput(,\"Annual Releases\",3)+(RD/Rate_filldrum)*3600*0.001*IF(Air_speed>100,((1.93*10^-7)*(MW_12DCA^0.78)*F_12DCA*VP_12DCA*(((1/29)+(1/MW_12DCA))^0.33)*(Air_speed^0.78)*(0.25*PI()*(D_contcleaning^2)))/((Temp^0.4)*(D_contcleaning^0.11)*(((Temp^0.5)-5.87)^(2/3))),((8.24*10^-8)*(MW_12DCA^0.835)*F_12DCA*VP_12DCA*(((1/29)+(1/MW_12DCA))^0.25)*(Air_speed^0.5)*(0.25*PI()*(D_contcleaning^2)))/((Temp^0.05)*(D_contcleaning^0.5)*((Pressure_Torr/760)^0.5)))","v":{"$error":"#NAME?"}},"kg/site-yr"]
[null,"Release Point 5 annual release per site (Drum cleaning)","Release_YearRP5","PVsite*Floss_cont",{"$f":"_xll.RiskOutput(,\"Annual Releases\",4)+(PV/Ns)*F_contloss","v":{"$error":"#NAME?"}},"kg/site-yr"]
[null,"Release Point 1 site release per release day (Emptying drums)","Release_per DayRP1","Release_YearRP1/RD",{"$f":"_xll.RiskOutput(,\"Releases per Release Day\",1)+RY_RP1/RD","v":{"$error":"#NAME?"}},"kg/site-day"]
[null,"Release Point 3 site release per release day (Filling small containers)","Release_per DayRP3","Release_YearRP3/RD",{"$f":"_xll.RiskOutput(,\"Releases per Release Day\",2)+RY_RP3/RD","v":{"$error":"#NAME?"}},"kg/site-day"]
[null,"Release Point 4 site release per release day (Open surface losses during container cleaning)","Release_per DayRP4","Release_YearRP4/RD",{"$f":"_xll.RiskOutput(,\"Releases per Release Day\",3)+RY_RP4/RD","v":{"$error":"#NAME?"}},"kg/site-day"]
[null,"Release Point 5 site release per release day (Drum cleaning)","Release_per DayRP5","Release_YearRP5/RD",{"$f":"_xll.RiskOutput(,\"Releases per Release Day\",4)+RY_RP5/RD","v":{"$error":"#NAME?"}},"kg/site-day"]
[null,"Total Annual Release to fugitive or stack air","Release_totalair","Release_YearRP1 + Release_YearRP3 + Release_YearRP4",{"$f":"_xll.RiskOutput(\"Total Annual Air Releases\")+RY_RP1+RY_RP3+RY_RP4","v":{"$error":"#NAME?"}},"kg/site-yr"]
[null,"Total Annual Release to landfill or incineration","Release_total lan_inc","Release_YearRP5 ",{"$f":"_xll.RiskOutput(\"Total Annual Water Releases\")+RY_RP5","v":{"$error":"#NAME?"}},"kg/site-yr"]
[null,"Total Daily Release to fugitive or stack air","Release_airday","Release_totalair/RD",{"$f":"_xll.RiskOutput()+Total_air/RD","v":{"$error":"#NAME?"}},"kg/site-day"]
[null,"Total Daily Release to landfill or incineration","Release_lan_inc_day","Release_totalwater/RD",{"$f":"_xll.RiskOutput()+Total_lan_inc/RD","v":{"$error":"#NAME?"}},"kg/site-day"]

{"sheet":"Release Results","index":6,"n_rows":67,"n_cols":6,"rows_kept":67,"cut":false,"hidden":false,"merged":[[4,0,4,1],[0,0,0,1],[8,1,8,2],[28,1,28,5]]}
["What-If Scenario"]
["Production Volume Assessed (kg/yr)",{"$f":"ROUND(PV,0)","v":11340}]
["Number of Sites",{"$f":"Ns","v":1}]
[]
["Monte Carlo Simulation Parameters"]
["Number of Iterations",100000]
["Sampling Method","Latin Hypercube"]
[]
[null,"Release Media"]
["Total Annual Release (kg/site-yr)","fugitive air or stack air","wastewater to onsite treatment or discharge to POTW (with or without pretreatment)",null,"Release Days (days/yr)","RD"]
["Maximum",{"$f":"_xll.RiskMax(Total_air)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskMax(Total_lan_inc)","v":{"$error":"#NAME?"}},null,"Maximum",{"$f":"_xll.RiskMax(RD)","v":{"$error":"#NAME?"}}]
["99th Percentile",{"$f":"_xll.RiskPercentile(Total_air,0.99)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(Total_lan_inc,0.99)","v":{"$error":"#NAME?"}},null,"Minimum",{"$f":"_xll.RiskMin(RD)","v":{"$error":"#NAME?"}}]
["95th Percentile",{"$f":"_xll.RiskPercentile(Total_air,0.95)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(Total_lan_inc,0.95)","v":{"$error":"#NAME?"}}]
["50th Percentile",{"$f":"_xll.RiskPercentile(Total_air,0.5)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(Total_lan_inc,0.5)","v":{"$error":"#NAME?"}}]
["5th Percentile",{"$f":"_xll.RiskPercentile(Total_air,0.05)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(Total_lan_inc,0.05)","v":{"$error":"#NAME?"}}]
["Minimum",{"$f":"_xll.RiskMin(Total_air)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskMin(Total_lan_inc)","v":{"$error":"#NAME?"}}]
["Mean",{"$f":"_xll.RiskMean(Total_air)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskMean(Total_lan_inc)","v":{"$error":"#NAME?"}}]
[]
["Total Release per-Day (kg/site-day)"]
["Maximum",{"$f":"_xll.RiskMax(Daily_air)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskMax(Daily_lan_inc)","v":{"$error":"#NAME?"}}]
["99th Percentile",{"$f":"_xll.RiskPercentile(Daily_air,0.99)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(Daily_lan_inc,0.99)","v":{"$error":"#NAME?"}}]
["95th Percentile",{"$f":"_xll.RiskPercentile(Daily_air,0.95)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(Daily_lan_inc,0.95)","v":{"$error":"#NAME?"}}]
["50th Percentile",{"$f":"_xll.RiskPercentile(Daily_air,0.5)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(Daily_lan_inc,0.5)","v":{"$error":"#NAME?"}}]
["5th Percentile",{"$f":"_xll.RiskPercentile(Daily_air,0.05)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(Daily_lan_inc,0.05)","v":{"$error":"#NAME?"}}]
["Minimum",{"$f":"_xll.RiskMin(Daily_air)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskMin(Daily_lan_inc)","v":{"$error":"#NAME?"}}]
["Mean",{"$f":"_xll.RiskMean(Daily_air)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskMean(Daily_lan_inc)","v":{"$error":"#NAME?"}}]
[]
[]
[null,"Release Point"]
["Release Point","1. Emptying (drums)","2. Storage","3. Filling (small containers)","4. Open Surface Losses to Air During Container Cleaning","5. Container Cleaning (drums)"]
["Expected/Conservative Release Media","fugitive air or stack air","Not expected to lead to significant losses to the environment","fugitive air or stack air","fugitive air or stack air","landfill or incineration"]
[]
["Release (kg/site-yr)","Release_YearRP1","-","Release_YearRP3","Release_YearRP4","Release_YearRP5"]
["Maximum",{"$f":"_xll.RiskMax(RY_RP1)","v":{"$error":"#NAME?"}},"-",{"$f":"_xll.RiskMax(RY_RP3)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskMax(RY_RP4)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskMax(RY_RP5)","v":{"$error":"#NAME?"}}]
["99th Percentile",{"$f":"_xll.RiskPercentile(RY_RP1,0.99)","v":{"$error":"#NAME?"}},"-",{"$f":"_xll.RiskPercentile(RY_RP3,0.99)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(RY_RP4,0.99)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(RY_RP5,0.99)","v":{"$error":"#NAME?"}}]
["95th Percentile",{"$f":"_xll.RiskPercentile(RY_RP1,0.95)","v":{"$error":"#NAME?"}},"-",{"$f":"_xll.RiskPercentile(RY_RP3,0.95)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(RY_RP4,0.95)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(RY_RP5,0.95)","v":{"$error":"#NAME?"}}]
["50th Percentile",{"$f":"_xll.RiskPercentile(RY_RP1,0.5)","v":{"$error":"#NAME?"}},"-",{"$f":"_xll.RiskPercentile(RY_RP3,0.5)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(RY_RP4,0.5)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(RY_RP5,0.5)","v":{"$error":"#NAME?"}}]
["5th Percentile",{"$f":"_xll.RiskPercentile(RY_RP1,0.05)","v":{"$error":"#NAME?"}},"-",{"$f":"_xll.RiskPercentile(RY_RP3,0.05)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(RY_RP4,0.05)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(RY_RP5,0.05)","v":{"$error":"#NAME?"}}]
["Minimum",{"$f":"_xll.RiskMin(RY_RP1)","v":{"$error":"#NAME?"}},"-",{"$f":"_xll.RiskMin(RY_RP3)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskMin(RY_RP4)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskMin(RY_RP5)","v":{"$error":"#NAME?"}}]
["Mean",{"$f":"_xll.RiskMean(RY_RP1)","v":{"$error":"#NAME?"}},"-",{"$f":"_xll.RiskMean(RY_RP3)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskMean(RY_RP4)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskMean(RY_RP5)","v":{"$error":"#NAME?"}}]
[]
["Release (kg/site-day)","Release_per DayRP1","-","Release_per DayRP3","Release_per DayRP4","Release_per DayRP5"]
["Maximum",{"$f":"_xll.RiskMax(RD_RP1)","v":{"$error":"#NAME?"}},"-",{"$f":"_xll.RiskMax(RD_RP3)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskMax(RD_RP4)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskMax(RD_RP5)","v":{"$error":"#NAME?"}}]
["99th Percentile",{"$f":"_xll.RiskPercentile(RD_RP1,0.99)","v":{"$error":"#NAME?"}},"-",{"$f":"_xll.RiskPercentile(RD_RP3,0.99)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(RD_RP4,0.99)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(RD_RP5,0.99)","v":{"$error":"#NAME?"}}]
["95th Percentile",{"$f":"_xll.RiskPercentile(RD_RP1,0.95)","v":{"$error":"#NAME?"}},"-",{"$f":"_xll.RiskPercentile(RD_RP3,0.95)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(RD_RP4,0.95)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(RD_RP5,0.95)","v":{"$error":"#NAME?"}}]
["50th Percentile",{"$f":"_xll.RiskPercentile(RD_RP1,0.5)","v":{"$error":"#NAME?"}},"-",{"$f":"_xll.RiskPercentile(RD_RP3,0.5)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(RD_RP4,0.5)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(RD_RP5,0.5)","v":{"$error":"#NAME?"}}]
["5th Percentile",{"$f":"_xll.RiskPercentile(RD_RP1,0.05)","v":{"$error":"#NAME?"}},"-",{"$f":"_xll.RiskPercentile(RD_RP3,0.05)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(RD_RP4,0.05)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(RD_RP5,0.05)","v":{"$error":"#NAME?"}}]
["Minimum",{"$f":"_xll.RiskMin(RD_RP1)","v":{"$error":"#NAME?"}},"-",{"$f":"_xll.RiskMin(RD_RP3)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskMin(RD_RP4)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskMin(RD_RP5)","v":{"$error":"#NAME?"}}]
["Mean",{"$f":"_xll.RiskMean(RD_RP1)","v":{"$error":"#NAME?"}},"-",{"$f":"_xll.RiskMean(RD_RP3)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskMean(RD_RP4)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskMean(RD_RP5)","v":{"$error":"#NAME?"}}]
[]
["Daily Release Duration (hours/day)","Release_Duration per Day_RP1","-","Release_Duration per Day_RP3","Release_Duration per Day_RP4","Release_Duration per Day_RP5"]
["Maximum",{"$f":"_xll.RiskMax(OH_unload_day)","v":{"$error":"#NAME?"}},"-",{"$f":"_xll.RiskMax(OH_load_day)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskMax(OH_unload_day)","v":{"$error":"#NAME?"}},"-"]
["99th Percentile",{"$f":"_xll.RiskPercentile(OH_unload_day,0.99)","v":{"$error":"#NAME?"}},"-",{"$f":"_xll.RiskPercentile(OH_load_day,0.99)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(OH_unload_day,0.99)","v":{"$error":"#NAME?"}},"-"]
["95th Percentile",{"$f":"_xll.RiskPercentile(OH_unload_day,0.95)","v":{"$error":"#NAME?"}},"-",{"$f":"_xll.RiskPercentile(OH_load_day,0.95)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(OH_unload_day,0.95)","v":{"$error":"#NAME?"}},"-"]
["50th Percentile",{"$f":"_xll.RiskPercentile(OH_unload_day,0.5)","v":{"$error":"#NAME?"}},"-",{"$f":"_xll.RiskPercentile(OH_load_day,0.5)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(OH_unload_day,0.5)","v":{"$error":"#NAME?"}},"-"]
["5th Percentile",{"$f":"_xll.RiskPercentile(OH_unload_day,0.05)","v":{"$error":"#NAME?"}},"-",{"$f":"_xll.RiskPercentile(OH_load_day,0.05)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(OH_unload_day,0.05)","v":{"$error":"#NAME?"}},"-"]
["Minimum",{"$f":"_xll.RiskMin(OH_unload_day)","v":{"$error":"#NAME?"}},"-",{"$f":"_xll.RiskMin(OH_load_day)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskMin(OH_unload_day)","v":{"$error":"#NAME?"}},"-"]
["Mean",{"$f":"_xll.RiskMean(OH_unload_day)","v":{"$error":"#NAME?"}},"-",{"$f":"_xll.RiskMean(OH_load_day)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskMean(OH_unload_day)","v":{"$error":"#NAME?"}},"-"]
[]
["Annual Release Duration (hours/yr)","Release_Duration per Year_RP1","-","Release_Duration per Year_RP3","Release_Duration per Year_RP4","Release_Duration per Year_RP5"]
["Maximum",{"$f":"_xll.RiskMax(OH_unload_yr)","v":{"$error":"#NAME?"}},"-",{"$f":"_xll.RiskMax(OH_load_yr)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskMax(OH_unload_yr)","v":{"$error":"#NAME?"}},"-"]
["99th Percentile",{"$f":"_xll.RiskPercentile(OH_unload_yr,0.99)","v":{"$error":"#NAME?"}},"-",{"$f":"_xll.RiskPercentile(OH_load_yr,0.99)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(OH_unload_yr,0.99)","v":{"$error":"#NAME?"}},"-"]
["95th Percentile",{"$f":"_xll.RiskPercentile(OH_unload_yr,0.95)","v":{"$error":"#NAME?"}},"-",{"$f":"_xll.RiskPercentile(OH_load_yr,0.95)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(OH_unload_yr,0.95)","v":{"$error":"#NAME?"}},"-"]
["50th Percentile",{"$f":"_xll.RiskPercentile(OH_unload_yr,0.5)","v":{"$error":"#NAME?"}},"-",{"$f":"_xll.RiskPercentile(OH_load_yr,0.5)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(OH_unload_yr,0.5)","v":{"$error":"#NAME?"}},"-"]
["5th Percentile",{"$f":"_xll.RiskPercentile(OH_unload_yr,0.05)","v":{"$error":"#NAME?"}},"-",{"$f":"_xll.RiskPercentile(OH_load_yr,0.05)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskPercentile(OH_unload_yr,0.05)","v":{"$error":"#NAME?"}},"-"]
["Minimum",{"$f":"_xll.RiskMin(OH_unload_yr)","v":{"$error":"#NAME?"}},"-",{"$f":"_xll.RiskMin(OH_load_yr)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskMin(OH_unload_yr)","v":{"$error":"#NAME?"}},"-"]
["Mean",{"$f":"_xll.RiskMean(OH_unload_yr)","v":{"$error":"#NAME?"}},"-",{"$f":"_xll.RiskMean(OH_load_yr)","v":{"$error":"#NAME?"}},{"$f":"_xll.RiskMean(OH_unload_yr)","v":{"$error":"#NAME?"}},"-"]

{"sheet":"Static Release Results","index":7,"n_rows":67,"n_cols":6,"rows_kept":67,"cut":false,"hidden":false,"merged":[[0,0,0,1],[4,0,4,1],[8,1,8,2],[28,1,28,5]]}
["What-If Scenario"]
["Production Volume Assessed (kg/yr)",11340]
["Number of Sites",1]
[]
["Monte Carlo Simulation Parameters"]
["Number of Iterations",100000]
["Sampling Method","Latin Hypercube"]
[]
[null,"Release Media"]
["Total Annual Release (kg/site-yr)","fugitive air or stack air","landfill or incineration",null,"Release Days (days/yr)","RD"]
["Maximum",9.5401481186348871,339.99392272595264,null,"Maximum",119]
["99th Percentile",6.494247166720168,331.04891424657296,null,"Minimum",24]
["95th Percentile",5.7457109840823444,319.74973325445524]
["50th Percentile",3.5809362829423184,274.54943894509927]
["5th Percentile",2.37116999920574,218.63550865612623]
["Minimum",2.0520302076577348,193.08176282505366]
["Mean",3.7636237193144702,272.15574883303952]
[]
["Total Release per-Day (kg/site-day)"]
["Maximum",0.25179644746436108,13.51274434634162]
["99th Percentile",0.18458477042756877,11.362005500764198]
["95th Percentile",0.15248059406217418,10.05489750158541]
["50th Percentile",8.3986249140997574E-2,6.4475837461718539]
["5th Percentile",4.5448516559256948E-2,3.4927563506070163]
["Minimum",2.2306303043779785E-2,1.7320643364138539]
["Mean",8.9662937360627498E-2,6.5745107313389921]
[]
[]
[null,"Release Point"]
["Release Point","1. Emptying (drums)","2. Storage","3. Filling (small containers)","4. Open Surface Losses to Air During Container Cleaning","5. Container Cleaning (drums)"]
["Expected/Conservative Release Media","fugitive air or stack air","Not expected to lead to significant losses to the environment","fugitive air or stack air","fugitive air or stack air","landfill or incineration"]
[]
["Release (kg/site-yr)","Release_YearRP1","-","Release_YearRP3","Release_YearRP4","Release_YearRP5"]
["Maximum",5.661000331431711,"-",3.9237298506787428,0.1981700207299136,339.99392272595264]
["99th Percentile",5.2036084220516798,"-",1.800751964738355,0.10957608440017691,331.04891424657296]
["95th Percentile",4.7462066106253493,"-",1.2507103802604036,8.107524543074919E-2,319.74973325445524]
["50th Percentile",2.9858998149280684,"-",0.50198347739758897,3.8232542549967323E-2,274.54943894509927]
["5th Percentile",2.0107195450980613,"-",0.21437933714124593,1.796665700263592E-2,218.63550865612623]
["Minimum",1.896690858939643,"-",0.10887253021606015,7.5765720025365623E-3,193.08176282505366]
["Mean",3.1334458999870147,"-",0.58784212632719657,4.2335693000238227E-2,272.15574883303952]
[]
["Release (kg/site-day)","Release_per DayRP1","-","Release_per DayRP3","Release_per DayRP4","Release_per DayRP5"]
["Maximum",0.22529914906594656,"-",4.4649631470603128E-2,1.6864105719469758E-3,13.51274434634162]
["99th Percentile",0.16354867130137152,"-",3.1134334156642199E-2,1.6428468917441331E-3,11.362005500764198]
["95th Percentile",0.13346088666204448,"-",2.4774005911712773E-2,1.5077276880048293E-3,10.05489750158541]
["50th Percentile",7.0689253963578225E-2,"-",1.1729298893252856E-2,9.0556809334665954E-4,6.4475837461718539]
["5th Percentile",3.5290913220559814E-2,"-",5.6740109340824123E-3,4.7885351316260871E-4,3.4927563506070163]
["Minimum",1.6833371187664991E-2,"-",3.9831041689437361E-3,2.6983923014192506E-4,1.7320643364138539]
["Mean",7.5735933861803981E-2,"-",1.299039753965577E-2,9.366059591668568E-4,6.5745107313389921]
[]
["Daily Release Duration (hours/day)","Release_Duration per Day_RP1","-","Release_Duration per Day_RP3","Release_Duration per Day_RP4","Release_Duration per Day_RP5"]
["Maximum",2.9679445271915705,"-",3.9722434551616326,2.9679445271915705,"-"]
["99th Percentile",2.3558740633088258,"-",3.913432003723242,2.3558740633088258,"-"]
["95th Percentile",1.8717753311014775,"-",3.6918523534886249,1.8717753311014775,"-"]
["50th Percentile",1.0349214746639752,"-",2.1143970999201618,1.0349214746639752,"-"]
["5th Percentile",0.68817005054948777,"-",1.1931704221188084,0.68817005054948777,"-"]
["Minimum",0.59673470431277331,"-",0.99443457981766925,0.59673470431277331,"-"]
["Mean",1.1179063186115958,"-",2.2467094456484404,1.1179063186115958,"-"]
[]
["Annual Release Duration (hours/yr)","Release_Duration per Year_RP1","-","Release_Duration per Year_RP3","Release_Duration per Year_RP4","Release_Duration per Year_RP5"]
["Maximum",353.18539873579687,"-",443.32243569371946,353.18539873579687,"-"]
["99th Percentile",223.80803601433846,"-",269.59042503449149,223.80803601433846,"-"]
["95th Percentile",140.3831498326108,"-",197.09139308457557,140.3831498326108,"-"]
["50th Percentile",43.46670193588696,"-",90.769230793576298,43.46670193588696,"-"]
["5th Percentile",19.268761415385658,"-",43.510154095941488,19.268761415385658,"-"]
["Minimum",14.321632903506559,"-",26.120972957249332,14.321632903506559,"-"]
["Mean",56.006311597297703,"-",101.57442978291046,56.006311597297703,"-"]