{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Read Me","Data Inputs","Design Parameters","Cost Estimate","Table A","Table B"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Read Me","index":0,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[[17,1,17,13],[18,1,18,13],[14,1,14,13],[15,1,15,13],[16,1,16,13],[0,0,0,14],[1,0,1,14],[2,0,2,14],[3,0,3,14],[4,0,4,14],[5,0,5,14],[6,0,6,14],[8,1,8,13],[10,1,10,13],[12,1,12,13]]}
["Air Pollution Control Cost Estimation Spreadsheet"]
["For Carbon Adsorbers"]
["U.S. Environmental Protection Agency "]
["Air Economics Group"]
["Health and Environmental Impacts Division"]
["Office of Air Quality Planning and Standards"]
["(November 2020)"]
[]
[null,"This spreadsheet allows users to estimate the capital and annualized costs for installing and operating carbon adsorbers to control emissions of volatile organic compounds (VOCs) and hazardous air pollutants (HAP) from industrial waste gas streams. Carbon adsorbers are a non-destructive control technology employed to remove volatile organic compounds (VOCs) from low to medium concentration gas streams. Adsorption is generally used when a stringent outlet concentration must be met and/or when recovery of the VOC is desired. Carbon adsorbers may be operated in either intermittent or continuous modes. The carbon is regenerated by desorbing the VOC from the carbon. This can be done off-site or onsite. The basic equipment required for a carbon adsorber system includes one or more carbon vessels or canisters and auxiliary equipment, such as duct work, pumps and storage vessels to collect VOC desorbed from the activated carbon. The desorbed VOC can be reused onsite, sold to a recycler or disposed.  "]
[]
[null,"The calculation methodologies used in this spreadsheet are those presented in the U.S. EPA's Air Pollution Control Cost Manual.  This spreadsheet is intended to be used in combination with the Control Cost Manual. For a detailed description of the technology and cost methodology, see Section 3.1 (VOC Recapture Controls), Chapter 1 (Carbon Adsorbers) of the Air Pollution Control Cost Manual (as updated in 2018). Additional control technologies may be necessary for some industrial waste gas streams.  Costs for additional control technologies can be estimated using the methods provided in other chapters of the cost manual.  A copy of the Control Cost Manual is available on the U.S. EPA's \"Technology Transfer Network\" website at: https://www.epa.gov/economic-and-cost-analysis-air-pollution-regulations/cost-reports-and-guidance-air-pollution.  "]
[]
[null,"The spreadsheet can be used to estimate capital and annualized costs for three types of carbon adsorbers: fixed-bed carbon adsorbers with steam regeneration; large carbon canisters with carbon replacement, and small carbon canisters with canister replacement. The methodology is designed to provide study-level (+-30%) cost estimates.  Actual costs, particularly those for installation, can deviate significantly from the costs generated using this spreadsheet due to site conditions. Units of measures in this spreadsheet are English units.  "]
[]
[null,"Instructions "]
[null,"Step 1: Please select the Data Inputs tab and click on the Reset Form button. This will reset the values on the Data Inputs tab.  "]
[null,"Step 2:  Use the drop down menus on the Data Inputs tab to select the type of carbon adsorber system (i.e., fixed-bed or canister). For fixed-bed adsorbers, use the drop down menus to enter the operating method (i.e., continuous or intermittent), material used for adsorber vessel fabrication and to specify whether the vessels are horizontal or vertical.    "]
[null,"Step 3:  Complete all of the yellow data entry cells on the Data Inputs tab. Many of the fields are pre-populated with default values.  Where possible, replace default values provided with site-specific values in accordance with the recommendations provided in the Control Cost Manual. Use of actual values other than the default values in this spreadsheet is recommended. Sources for all values used should be appropriately documented. "]
[null,"Step 4: Once all of the data fields are complete, select the Design Parameters tab to see the calculated design parameters for your condenser. Select the Cost Estimate tab to view the estimated installation and operation costs for the carbon adsorber. "]

{"sheet":"Data Inputs","index":1,"n_rows":70,"n_cols":18,"rows_kept":70,"cut":false,"hidden":false,"merged":[[50,3,50,8],[67,2,67,3],[67,4,67,8],[64,2,64,3],[65,2,65,3],[61,2,61,3],[37,3,37,8],[69,2,69,3],[63,2,63,3],[62,2,62,3],[62,4,62,8],[39,0,39,6],[69,4,69,8],[63,4,63,8],[64,4,64,8],[65,4,65,8],[61,4,61,8],[68,2,68,3],[68,4,68,8],[66,2,66,3],[66,4,66,8],[49,3,49,8]]}
[null,null,"Data Inputs",null,null,null,null,null,null,null,null,3,"Carbon Canister Adsorber with Canister Replacement",null,null,null,null,{"$f":"IF(L1=1,M1,(IF(L1=2,M2,M3)))","v":"Fixed-Bed Carbon Adsorber with Steam Regeneration"}]
["Select the type of carbon adsorber system: ",null,null,null,null,null,null,null,null,null,null,null,"Carbon Canister Adsorber with Carbon Replacement"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fixed-Bed Carbon Adsorber with Steam Regeneration"]
["For fixed-bed carbon adsorbers, provide the following information:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Cell L4=","Fm Value"]
["Select the type of operation: ",null,null,null,null,null,null,null,null,null,null,2,"Not Applicable",null,1,0,{"$f":"IF($L$5=1, 0,  0)","v":0},{"$f":"IF($L$5=1, \"Not Applicable\",\" \")","v":" "}]
["Select the type of material used to fabricate the carbon adsorber vessels: ",null,null,null,null,null,null,null,null,null,null,null,"Stainless Steel, 304",null,2,1,{"$f":"IF($L$5=2, 1,  0)","v":1},{"$f":"IF($L$5=2, \"(* Stainless Steel, 304)\", \" \")","v":"(* Stainless Steel, 304)"}]
["Select the orientation for the adsorber vessels: ",null,null,null,null,null,null,null,null,null,null,null,"Stainless Steel, 316",null,3,1.3,{"$f":"IF($L$5=3, 1.3,  0)","v":0},{"$f":"IF($L$5=3, \"(* Stainless Steel, 316)\", \" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Carpenter 20 CB-3",null,4,1.9,{"$f":"IF($L$5=4, 1.9,  0)","v":0},{"$f":"IF($L$5=4, \"(* Carpenter 20 CB-3)\", \" \")","v":" "}]
[{"$f":"\"Enter the design data for the proposed \"&R1","v":"Enter the design data for the proposed Fixed-Bed Carbon Adsorber with Steam Regeneration"},null,null,null,null,null,null,null,null,null,null,null,"Monel-400",null,5,2.2999999999999998,{"$f":"IF($L$5=5, 2.3,  0)","v":0},{"$f":"IF($L$5=5, \"(* Monel-400)\", \" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Nickel-200",null,6,3.2,{"$f":"IF($L$5=6,3.2,  0)","v":0},{"$f":"IF($L$5=6, \"(* Nickel-200)\", \" \")","v":" "}]
["Number of operating hours per year (Ɵs)",8640,"hours/year",null,null,null,null,null,null,null,null,null,"Titanium ",null,7,4.5,{"$f":"IF($L$5=7,4.5,  0)","v":0},{"$f":"IF($L$5=7, \"(* Titanium)\", \" \")","v":" "}]
["Waste Gas Flow Rate (Q)",10000,"acfm*","*acfm is actual cubic feet/min"]
["VOC Emission Rate (mvoc)",100,"lbs/hour",null,null,null,null,null,null,null,null,null,"Fm =",null,null,{"$f":"SUM(Q5:Q11)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R5&R6&R7&R8&R9&R10&R11","v":" (* Stainless Steel, 304)     "}]
["Required VOC removal efficiency (E)",98,{"$f":"\"percent\"&(IF(B15=98, \"*\",\"\"))","v":"percent*"},{"$f":"IF(B15=98,\"* 98 percent is a default control efficiency. User should enter actual value, if known.\",\" \")","v":"* 98 percent is a default control efficiency. User should enter actual value, if known."},null,null,null,null,null,null,null,2,"Not Applicable",null,null,{"$f":"IF(L15=1, \"Not Applicable\", IF(L15=2,\"Horizontal\", \"Vertical\"))","v":"Horizontal"}]
["Superficial Bed Velocity (vb)",75,"ft/min",{"$f":"IF(B16=0.65,\"* 0.65 Btu/lb-mole-°F is a default value. User should enter actual value, if known.\",\" \")","v":" "},null,null,null,null,null,null,null,null,"Horizontal"]
[{"$f":"\"Estimated equipment life of\"&(IF(L1>1,\" adsorber vessels and auxiliary Equipment (n)\",\" auxiliary Equipment (n)\"))","v":"Estimated equipment life of adsorber vessels and auxiliary Equipment (n)"},15,{"$f":"\"Years\"&IF(B17=15,\"*\",\"\")","v":"Years*"},{"$f":"IF(AND(B17=15,L1>1),\"* 15 years is a default equipment life. User should enter actual value, if known.\",(IF(AND(B17=10,L1=1), \"*10 years is a default equipment life. User should enter actual value , if known.\")))","v":"* 15 years is a default equipment life. User should enter actual value, if known."},null,null,null,null,null,null,null,null,"Vertical"]
["Estimated Carbon life (n)",5,"Years"]
["Total Number of carbon beds (Ntotal)",3,{"$f":"IF(B19=3,\"Beds*\", \"Beds\")","v":"Beds*"},{"$f":"IF(B19=3,\"* 3 beds is the default. User should enter actual number of beds, if known.\",\" \")","v":"* 3 beds is the default. User should enter actual number of beds, if known."},null,null,null,null,null,null,null,2,"Not Applicable",null,null,{"$f":"IF(L19=2, \"Continuous Operation\", (IF(L19=3, \"Intermittent Operation\", \"Not Applicable\")))","v":"Continuous Operation"}]
["Number of carbon beds adsorbing VOC when system is operating (NA)",2,{"$f":"IF(B20=2,\"Beds*\", \"Beds\")","v":"Beds*"},{"$f":"IF(B20=2,\"* 2 beds is the default. User should enter actual number of beds, if known.\",\" \")","v":"* 2 beds is the default. User should enter actual number of beds, if known."},null,null,null,null,null,null,null,null,"Continuous Operation"]
["Total time for adsorption (ƟA)",12,{"$f":"IF(B21=12,\"hours*\", \"hours\")","v":"hours*"},{"$f":"IF(B21=12,\"* 12 hours is a default value. User should enter actual value, if known.\",\" \")","v":"* 12 hours is a default value. User should enter actual value, if known."},null,null,null,null,null,null,null,null,"Intermittent Operation"]
["Total time for desorption (ƟD)",5,{"$f":"IF(B22=5,\"hours*\", \"hours\")","v":"hours*"},{"$f":"IF(B22=5,\"* 5 hours is a default value. User should enter actual value, if known.\",\" \")","v":"* 5 hours is a default value. User should enter actual value, if known."}]
["Estimated Carbon Replacement Rate (CRR) ",379,{"$f":"IF(B23=379,\"lbs/hour*\",\"lbs/hour\")","v":"lbs/hour*"},{"$f":"IF(B23=379,\"* 379 lbs./hour is a default value. User should enter actual value, if known.\",\" \")","v":"* 379 lbs./hour is a default value. User should enter actual value, if known."}]
["Carbon Canister Size",3000,{"$f":"IF(B24=3000,\"lbs carbon per canister*\", \"lbs of carbon per canister\")","v":"lbs carbon per canister*"},{"$f":"IF(B24=3000,\"* 3000 lbs of carbon per canister is a default value. User should enter prefered canister size, if known.\",\" \")","v":"* 3000 lbs of carbon per canister is a default value. User should enter prefered canister size, if known."}]
["Number of Operating Hours Before Carbon Canister Replacement  (ƟA)",4380,"hours"]
[]
["Enter the Characteristics of the VOC/HAP:"]
[]
["Name of VOC/HAP","Toluene"]
[{"$f":"\"Partial Pressure of \"&B29&\" in waste gas stream\"","v":"Partial Pressure of Toluene in waste gas stream"},1.04E-2,"psia"]
[{"$f":"\"Parameter \"\"k\"\" for \"&B29","v":"Parameter \"k\" for Toluene"},0.55100000000000005,"Note:"]
[{"$f":"\"Parameter \"\"m\"\" for \"&B29","v":"Parameter \"m\" for Toluene"},0.11,"Typical values of \"k\" and \"m\" for some common VOCs are shown in Table A. "]
[]
["Enter the cost data for the carbon adsorber:"]
[]
["Desired dollar-year ",2018]
[{"$f":"\"CEPCI* for \" & B36","v":"CEPCI* for 2018"},567.5,{"$f":"\"CEPCI value for \"&B36","v":"CEPCI value for 2018"},null,390.6,1999]
["Annual Interest Rate (i)",5,{"$f":"(IF(B38<>5,\"percent (Current bank prime rate)\",\"percent*\"))","v":"percent*"},{"$f":"IF(B38=5,\"* 5 percent is a default value. User should enter current prime bank rate.\", \"\")","v":"* 5 percent is a default value. User should enter current prime bank rate."}]
[]
["* CEPCI is the Chemical Engineering Plant Cost Index. The use of CEPCI in this spreadsheet is not an endorsement of the index for purpose of cost escalation or de-escalation, but is there merely to allow for availability of a well-known cost index to spreadsheet users. Use of other well-known cost indexes (e.g., M&S) is acceptable."]
[]
["Carbon Canister Cost ",13400,{"$f":"\"per canister (in \"&B36&\" dollars)\"","v":"per canister (in 2018 dollars)"},"Note: Typical costs for carbon canisters are shown in Table B. "]
["Electricity (Pelec)",6.7599999999999993E-2,{"$f":"\"per kWh\"&IF(B43=0.0676, \"*\",\"\")","v":"per kWh*"},{"$f":"IF(B43=0.0676,\"* $0.0676/kWh is a default value. User should enter actual value, if known.\",\"\")","v":"* $0.0676/kWh is a default value. User should enter actual value, if known."}]
["Steam (Ps)",5,{"$f":"\"per 1,000 lbs\"&IF(B44=5, \"*\",\"\")","v":"per 1,000 lbs*"},{"$f":"IF(B44=5,\"* $5.00/1,000 lbs is a default value. User should enter actual value, if known.\",\"\")","v":"* $5.00/1,000 lbs is a default value. User should enter actual value, if known."}]
["Cooling Water (Pcw)",3.55,{"$f":"\"per 1,000 gallons of water\"&IF(B45=3.55, \"*\",\"\")","v":"per 1,000 gallons of water*"},{"$f":"IF(B45=3.55,\"* $3.55/1,000 gallons is a default value. User should enter actual value, if known.\",\"\")","v":"* $3.55/1,000 gallons is a default value. User should enter actual value, if known."}]
["Operator Labor Rate",27.48,{"$f":"\"per hour\"&IF(B46=27.48,\"*\",\"\")","v":"per hour*"},{"$f":"IF(B46=27.48,\"* $27.48/hour is a default value. User should enter actual value, if known.\",\"\")","v":"* $27.48/hour is a default value. User should enter actual value, if known."}]
["Maintenance Labor Rate",30.23,{"$f":"\"per hour\"&IF(B47=30.23,\"*\",\"\")","v":"per hour*"},{"$f":"IF(B47=30.23,\"* $30.23/hour is a default value. User should enter actual value, if known. If the rate is not known, use 1.10 x operator labor rate.\",\"\")","v":"* $30.23/hour is a default value. User should enter actual value, if known. If the rate is not known, use 1.10 x operator labor rate."}]
["Carbon Cost (CC)",4.2,{"$f":"\"per lb\"&IF(B48=1.9,\"*\",\"\")","v":"per lb"},{"$f":"IF(B48=4.2,\"* $4.20/lb is a default value based on 2018 market price. User should enter actual value, if known.\",\"\")","v":"* $4.20/lb is a default value based on 2018 market price. User should enter actual value, if known."}]
[]
["Re-Sale Value of Recovered VOC (Pvoc)",0.33,{"$f":"\"per lb\"&IF(B50=0.33,\"*\",\"\")","v":"per lb*"},{"$f":"IF(B50=0.33,\"* $0.33/lb is a default value for recovered toluene based on 2018 data. User should enter actual value of recovered VOC/HAP, if known. Enter zero if the recovered VOC/HAP cannot be sold or re-used onsite.\",\"\")","v":"* $0.33/lb is a default value for recovered toluene based on 2018 data. User should enter actual value of recovered VOC/HAP, if known. Enter zero if the recovered VOC/HAP cannot be sold or re-used onsite."}]
["Disposal/Treatment Cost for Recovered VOC (Dvoc)",0,{"$f":"\"per lb\"&IF(B51=0,\"*\",\"\")","v":"per lb*"},{"$f":"IF(B51=0,\"* $0/lb is a default value for disposal and/or treatment of recovered VOC/HAP. User should enter actual value,  if known. Enter zero if the recovered VOC/HAP can be sold or re-used onsite without additional treatment.\",\"\")","v":"* $0/lb is a default value for disposal and/or treatment of recovered VOC/HAP. User should enter actual value,  if known. Enter zero if the recovered VOC/HAP can be sold or re-used onsite without additional treatment."}]
[]
["If known, enter any additional costs for site preparation and building construction/modification:"]
["Site Preparation (SP) =",0,{"$f":"IF(B54=0, \"* Default value. User should enter actual value, if known.\",\" \")","v":"* Default value. User should enter actual value, if known."}]
["Buildings (Bldg) =",0,{"$f":"IF(B55=0, \"* Default value. User should enter actual value, if known.\",\" \")","v":"* Default value. User should enter actual value, if known."}]
["Equipment Costs for auxiliary equipment (e.g., ductwork, dampers, and stack) (ECaux) =",32000,{"$f":"IF(OR(B56=32000,B56=2000), \"* Default value. User should enter actual value, if known.\",\" \")","v":"* Default value. User should enter actual value, if known."}]
["Contingency Factor (CF)",10,{"$f":"\"percent\"&IF(B57=10,\"*\",\"\")","v":"percent*"},{"$f":"IF(B57=10,\"* 10 percent is a default value. The contingency factor should be between 5 and 15 percent.\",\"\")","v":"* 10 percent is a default value. The contingency factor should be between 5 and 15 percent."}]
[]
[]
["Data Sources for Default Values Used in Calculations: "]
[]
["Data Element","Default Value","Sources for Default Value",null,"If you used your own site-specific values, please reference  the source from which the site-specific value was derived. ",null,null,null,null,"Recommended data sources for site-specific information"]
["Carbon Cost ($/lb)",1.9,"January 2018 market price for virgin carbon.",null," ",null,null,null,null,"Check with activated carbon vendors for current prices. "]
["Operator Labor Rate ($/hour)",27.48,"Bureau of Labor Statistics, May 2017 National Occupational Employment and Wage Estimates – United States, May 2017 (https://www.bls.gov/oes/current/oes_nat.htm). Hourly rates for operators based on data for plant and System Operators – other (51-8099).",null," ",null,null,null,null,"Use payroll data, if available, or check current edition of the Bureau of Labor Statistics, National Occupational Employment and Wage Estimates – United States (https://www.bls.gov/oes/current/oes_nat.htm)."]
["Maintenance Labor Rate ($/hour)",30.23,"Estimated as 110 percent of operator labor rate.",null," ",null,null,null,null,"Use payroll data, if available, or check current edition of the Bureau of Labor Statistics, National Occupational Employment and Wage Estimates – United States (https://www.bls.gov/oes/current/oes_nat.htm).  "]
["Value of Recovered VOC ($/lb.)",0.33,"January 2018 market price for recovered toluene.",null," ",null,null,null,null,"Check with reagent vendors for current prices. "]
["Disposal/Treatment Cost for Recovered VOC ($/lb)",0,"No additional treatment or disposal costs - Recovered VOC can be sold to a solvent recovery company.",null," ",null,null,null,null,"Check with reagent recyclers for current prices or enter estimated costs for onsite treatment, as applicable."]
["Steam ($/1,000 lb)",5,"Price of steam was estimated by multiplying the average price of natural gas for industrial facilities ($4.00/MMBtu) by 1.3 and converting to $/1,000 lb of steam. Natural gas price is the 2017 average price for industrial facilities published by the U.S. Department of Energy, Energy Information Administration (see https://www.eia.gov/dnav/ng/ng_pri_sum_dcu_nus_a.htm).",null," ",null,null,null,null,"Use actual values if known, or estimate steam cost as 1.3 x Fuel Cost for oil and gas-fired facilities. See also Department of Energy, Energy Efficiency and Renewable Energy, A Best Practices Steam Technical Brief: How to Calculate the True Cost of Steam, DOE/GO-102003-1736, September 2003 (available at https://www.energy.gov/sites/prod/files/2014/05/f15/tech_brief_true_cost.pdf)."]
["Cooling Water ($/1,000 gallons)",3.55,"Average water rates for industrial facilities in 2013, compiled by Black & Veatch. (see 2012/2013 \"50 Largest Cities Water/Wastewater Rate Survey.\" Available at http://www.saws.org/who_we_are/community/RAC/docs/2014/50-largest-cities-brochure-water-wastewater-rate-survey.pdf.",null," ",null,null,null,null,"Use actual values if known, or estimate steam cost as 1.3 x Fuel Cost for oil and gas-fired facilities. See also Department of Energy, Energy Efficiency and Renewable Energy, A Best Practices Steam Technical Brief: How to Calculate the True Cost of Steam, DOE/GO-102003-1736, September 2003 (available at https://www.energy.gov/sites/prod/files/2014/05/f15/tech_brief_true_cost.pdf)."]
["Electricity Cost ($/kWh)",6.7599999999999993E-2,"Average annual electricity cost for industrial plants is based on 2017 price data compiled by the U.S. Energy Information Administration from data reported on Form EIA-861 and 861S, (http://www.eia.gov/electricity/data.cfm#sales).  ",null," ",null,null,null,null,"Plant's utility bill or use U.S. Energy Information Administration (EIA) data for most recent year. Available at http://www.eia.gov/electricity/data.cfm#sales. "]

{"sheet":"Design Parameters","index":2,"n_rows":69,"n_cols":4,"rows_kept":69,"cut":false,"hidden":false,"merged":[[65,0,66,0],[0,0,0,5],[2,0,2,5],[63,0,64,0],[67,0,68,0]]}
["Design Parameters"]
[]
["The following design parameters for the carbon adsorber were calculated based on the values entered on the Data Inputs tab. These values were used to prepare the costs shown on the Cost Estimate tab."]
["Type of Carbon Adsorber:",{"$f":"'Data Inputs'!R1","v":"Fixed-Bed Carbon Adsorber with Steam Regeneration"}]
["Name of VOC Controlled:",{"$f":"'Data Inputs'!B29","v":"Toluene"}]
[]
["Parameter","Equation","Calculated Value","Units"]
[{"$f":"IF('Data Inputs'!B29=\" \", \"Quantity of VOC Recovered:\", IF('Data Inputs'!L1<3,\"Quantity of \"&'Data Inputs'!B29&\" Removed:\",\"Quantity of \"&'Data Inputs'!B29&\" Recovered:\" ))","v":"Quantity of Toluene Recovered:"}]
[{"$f":"IF('Data Inputs'!B29=\" \",\"Quantity of VOC Recovered (Wvoc) =\",IF('Data Inputs'!L1<3,\"Quantity of \"&'Data Inputs'!B29&\" Removed (Wvoc) =\",\"Quantity of \"&'Data Inputs'!B29&\" Recovered (Wvoc) =\"))","v":"Quantity of Toluene Recovered (Wvoc) ="},"Wvoc = mvoc x Ɵs x E =",{"$f":"('Data Inputs'!B13*'Data Inputs'!B11*('Data Inputs'!B15/100))/2000","v":423.36},"tons/year"]
["Time required for Desorption (ƟD) =",null,{"$f":"'Data Inputs'!B22","v":5},"hours"]
["Time for Adsorption (ƟA) =",null,{"$f":"'Data Inputs'!B21","v":12},"hours"]
["Time Available for Desorption = ","ƟA (ND/NA) = ",{"$f":"C11*C19/C20","v":6},"hours"]
[null,null,{"$f":"IF(C10>C12, \"* Warning: Time required for desorption is less than the amount of time available.\", \" \")","v":" "}]
[]
["Adsorber Parameters: "]
["Equilibrium Capacity at the Inlet (We(max)) =","k x Pm = ",{"$f":"'Data Inputs'!B31*('Data Inputs'!B30)^'Data Inputs'!B32","v":0.33344581124834016},"lb. VOC/lb. Carbon"]
["Working Capacity (wc) =","0.5 x we(max) = ",{"$f":"0.5*C16","v":0.16672290562417008},"lb. VOC/lb. Carbon"]
["Adjustment Factor for Adorber Vessel Material (Fm ) =",null,{"$f":"'Data Inputs'!P13","v":1},{"$f":"'Data Inputs'!P14","v":" (* Stainless Steel, 304)     "}]
["Number of Bed Desorbing (ND) = ","Ntotal - NA =",{"$f":"'Data Inputs'!B19-'Data Inputs'!B20","v":1},"Bed"]
["Number of Bed Adsorbing (NA) = ",null,{"$f":"'Data Inputs'!B20","v":2},"Bed"]
[]
["Volumetric Flow Rate for each Vessel (Q') =","Q/NA =",{"$f":"'Data Inputs'!B12/'Design Parameters'!C20","v":5000},"acfm/Bed"]
["Carbon Bed Thickness (tb) = ","(Mc'/ρb)/(Q'/vb), where the density of carbon (ρb) = 30 lb/sq.ft",{"$f":"(C29/30)/(C22/'Data Inputs'!B16)","v":1.7993928241405872},"ft. "]
["Pressure Drop (ΔPs) = ","tb x (0.03679vb +1.107x10-4vb2) + 1 =",{"$f":"1+(C23*((0.03679*'Data Inputs'!B16)+((0.0001107)*('Data Inputs'!B16^2))))","v":7.0854340691919573},"inches"]
["Cooling Fan Operating Time (Ɵcf) = ","0.4 x ƟD x  (NA x Ɵs)/ƟA = ",{"$f":"0.4*C10*(C20*'Data Inputs'!B11)/'Design Parameters'!C11","v":2880},"hours"]
["Estimated Carbon Required:"]
["Estimated Carbon Consumption (Mc) for a continuously operated system = ","(mvoc/wc) x ƟA (1 + ND/NA)  = ",{"$f":"('Data Inputs'!B13/C17)*'Data Inputs'!B21*(1+'Design Parameters'!C19/'Design Parameters'!C20)","v":10796.356944843523},"lbs."]
["Estimated Carbon Consumption (Mc) for an intermittently operated system = ","(mvoc/wc) x ƟA   = ",{"$f":"('Data Inputs'!B13/'Design Parameters'!C17)*'Data Inputs'!B21","v":7197.5712965623479},"lbs."]
["Carbon Required for each Vessel (Mc') =","Mc /(NA + ND) =",{"$f":"IF('Data Inputs'!L19=2,(C27/(C19+C20)),IF('Data Inputs'!L19=3,(C28),0))","v":3598.7856482811744},"lbs./Bed"]
[]
["Estimated Adsorber Vessel Dimensions and Surface Area: "]
["Vessel Orientation = ",null,{"$f":"'Data Inputs'!P15","v":"Horizontal"}]
["Vessel Diameter (D) =","(0.127 x Mc' x vb)/Q' =",{"$f":"(0.127*C29*'Data Inputs'!B16)/C22","v":6.8556866599756363},"ft."]
["Vessel Length (L) =","(7.87/Mc') x (Q'/vb)2 = ",{"$f":"(7.87/C29)*(C22/'Data Inputs'!B16)^2","v":9.7193279056460664},"ft."]
["Surface Area of Adsorber Vessel (S) ="," π x D x (L+D/2) =",{"$f":"PI()*C33*(C34+C33/2)","v":283.16081393874236},"sq.ft"]
["Vessel Diameter (D) =","(4Q'/πvb) =",{"$f":"((4*C22)/(PI()*'Data Inputs'!B16))^0.5","v":9.2131773192356121},"ft."]
["Vessel Length (L) =","tb + ta,g = ",{"$f":" C23+4","v":5.799392824140587},"ft."]
["Surface Area of Adsorber Vessel (S) ="," π x D x (L+D/2) =",{"$f":"PI()*C36*(C37+C36/2)","v":301.19125026230699},"sq.ft"]
[]
["Electricity Consumption:"]
["Electricity Consumed by the system fan (Qsf) =","(0.746kW/hp) x 2.5x10-4 x Q x ΔPs x Ɵs =",{"$f":"0.746*(0.00025)*C24*'Data Inputs'!B12*'Data Inputs'!B11","v":114171.85041733153},"kWh/year"]
["Electricity Consumed by the cooling fan (Qcf) = ","(0.746kW/hp) x 2.5x10-4 x Qcf x ΔPs x Ɵcf =",{"$f":"0.746*(0.00025)*C24*3000*C25","v":11417.185041733153},"kWh/year"]
["Electricity Consumed by the Cooling Water Fan (Qcwf) = ","(0.746kW/hp) x [2.52x10-4 x 100/η] x [Ɵcwp /(0.6 x ƟD x NA x ƟD/ƟA )x 60 mins/hour]  =",{"$f":"(0.746)*((0.000252*100)/0.63)*(C51/((0.6*C10*C20*'Data Inputs'!B11)/'Design Parameters'!C11)*60)","v":4298.7503999999999},"kWh/year"]
["Total Estimated Electricity Consumption (QElec) = ","Qsf + Qcf + Qcsf =",{"$f":"C41+C42+C43","v":129887.78585906469},"kWh/year"]
[]
["Steam Consumption:"]
["Total Steam Consumption (QSteam) = ","= 3.5 x Mvoc x Ɵs = ",{"$f":"3.5*'Data Inputs'!B13*'Data Inputs'!B11","v":3024000},"lbs./year"]
[]
[]
["Cooling Water Consumption:"]
["Total Cooling Water Consumption (Qcw) = ","= 3.43 x Cs/Ps = ",{"$f":"C47*3.43","v":10372320},"gallons/year"]
[]
[]
["Number of times canister(s) replaced per year =","Ɵs /  ƟA =",{"$f":"'Data Inputs'!B11/'Data Inputs'!B25","v":1.9726027397260273}]
[]
["Adsorber Parameters for Carbon Canisters: "]
["Time for Adsorption (ƟA) =","Number of operating hours before carbon canister replacement =",{"$f":"'Data Inputs'!B25","v":4380},"hours"]
["Equilibrium Capacity at the Inlet (We(max)) =","k x Pm = ",{"$f":"'Data Inputs'!B31*('Data Inputs'!B30)^'Data Inputs'!B32","v":0.33344581124834016},"lb. VOC/lb. Carbon"]
["Working Capacity (wc) =","0.5 x we(max) = ",{"$f":"0.5*C58","v":0.16672290562417008},"lb. VOC/lb. Carbon"]
["Estimated Total Carbon Required (Mc) = ","(mvoc/wc) x ƟA   = ",{"$f":"('Data Inputs'!B13/'Design Parameters'!C58)*C57","v":1313556.7616226287},"lbs."]
["Number of Carbon Canisters Required = ","Mc/Carbon Canister Capacity",{"$f":"ROUNDUP((C60/'Data Inputs'!B24),0.1)","v":438},"canisters"]
[{"$f":"\"Total Quantity of Carbon Required for \"&C61&\" Canisters =\"","v":"Total Quantity of Carbon Required for 438 Canisters ="},"Number of Carbon Canisters * Carbon Capacity per Canister =",{"$f":"C61*'Data Inputs'!B24","v":1314000},"lbs."]
["Capital Recovery Factor:"]
[{"$f":"\"Capital Recovery Factor for \"&(IF('Data Inputs'!L1>1,\"adsorber vessels and auxiliary equipment (CFRabsorber)=\",\"auxiliary equipment (CFRaux) =\"))","v":"Capital Recovery Factor for adsorber vessels and auxiliary equipment (CFRabsorber)="},"[i × (1 + i)n] / [(1 + i)n - 1] =",{"$f":"(('Data Inputs'!B38/100)*(1+('Data Inputs'!B38/100))^'Data Inputs'!B17)/(((1+('Data Inputs'!B38/100))^'Data Inputs'!B17)-1)","v":9.6342287609244348E-2}]
[null,"Where n = Equipment Life and i = Interest Rate"]
["Capital Recovery Factor for carbon (CRFCarbon) = ","[i × (1 + i)n] / [(1 + i)n - 1] =",{"$f":"((('Data Inputs'!B38/100)*(1+('Data Inputs'!B38/100))^'Data Inputs'!B18)/(((1+('Data Inputs'!B38/100))^'Data Inputs'!B18)-1))","v":0.23097479812826807}]
[null,"Where n = Carbon Life and i = Interest Rate"]
["Capital Recovery Factor for carbon (CRFCarbon canister) = ","[i × (1 + i)n] / [(1 + i)n - 1] =",{"$f":"IF(C54>1, \"Not applicable: Canisters are replaced \"&C54&\" times/year\", ((('Data Inputs'!B38/100)*(1+('Data Inputs'!B38/100))^(1/C54))/(((1+('Data Inputs'!B38/100))^(1/C54))-1)))","v":"Not applicable: Canisters are replaced 1.97260273972603 times/year"}]
[null,"Where n = Carbon Canister Life and i = Interest Rate"]

{"sheet":"Cost Estimate","index":3,"n_rows":203,"n_cols":16,"rows_kept":203,"cut":false,"hidden":false,"merged":[[97,3,103,3],[122,3,125,3],[169,0,169,1],[174,0,174,3],[196,0,196,3],[105,0,105,1],[113,0,113,1],[118,0,118,3],[144,0,144,3],[161,0,161,1],[153,3,158,3],[165,3,168,3],[178,3,180,3],[187,3,190,3],[0,0,0,3],[48,0,48,3],[88,0,88,3],[3,2,7,2],[43,0,43,1],[20,0,20,1],[2,0,2,3]]}
["Cost Estimate",null,null,null,null,null,null,null,null,null,null,3]
[]
["Capital Costs"]
[]
[{"$f":"\"Estimated capital costs for a \"&'Data Inputs'!R1&\" with the following characteristics:\"","v":"Estimated capital costs for a Fixed-Bed Carbon Adsorber with Steam Regeneration with the following characteristics:"},null,null,null,null,null,null,null,null,null,null,2]
["VOC Controlled/Recovered =",{"$f":"'Data Inputs'!B29","v":"Toluene"}]
["Adsorber Vessel Orientation =",{"$f":"'Data Inputs'!P15","v":"Horizontal"}]
["Operating Schedule  =",{"$f":"'Data Inputs'!P19","v":"Continuous Operation"}]
[]
[{"$f":"\"Total Capital Investment (TCI) (in \"&'Data Inputs'!B36&\" dollars)\"","v":"Total Capital Investment (TCI) (in 2018 dollars)"}]
["Parameter","Equation","Cost"]
["Costs for Each Carbon Adsorber Vessel (Cv) =","271 x Fm x S0.778 =",{"$f":"271*'Design Parameters'!C18*(IF('Data Inputs'!L15=2, ('Design Parameters'!C35^0.778), IF('Data Inputs'!L15=3, ('Design Parameters'!C38^0.778), 0)))*('Data Inputs'!B37/'Data Inputs'!E37)","v":31833.523412827559}]
["Total Cost for All Carbon Adsorber Vessels and Carbon(ECAdsorb) =","5.82 x Q-0.133 x [Cc + (NA + ND) x Cv] =",{"$f":"5.82*('Data Inputs'!B12^-0.133)*(('Data Inputs'!B48*'Design Parameters'!C27)+(('Design Parameters'!C19+'Design Parameters'!C20)*C12))","v":240804.86097227238}]
["Auxiliary Equipment (ECaux) =","(Based on design costs or estimated using methods provided in Section 2) ",{"$f":"'Data Inputs'!B56","v":32000}]
["Total Purchased Equipment Costs for Carbon Adsorber (A) =","= ECAdsorb + ECaux =",{"$f":"C13+C14","v":272804.86097227235},null,null,null,null,null,null,null,null,2,null,null,null,"Horizontal"]
[]
["Instrumentation =","0.10 × A =","Included in A"]
["Sales taxes =","0.03 × A =",{"$f":"0.03*C15","v":8184.1458291681702}]
["Freight =","0.05 × A =",{"$f":"0.05*C15","v":13640.243048613618},null,null,null,null,null,null,null,null,2]
[]
["Total Purchased Equipment Costs (B) = ",null,{"$f":"C15+C18+C19","v":294629.2498500541}]
[]
[{"$f":"\"Direct Installation Costs (in \"&'Data Inputs'!B36&\" dollars)\"","v":"Direct Installation Costs (in 2018 dollars)"}]
["Parameter","Equation","Cost"]
["Foundations and Supports =","0.08 × B =",{"$f":"0.08*C21","v":23570.339988004329}]
["Handling and Erection =","0.14 × B =",{"$f":"0.14*C21","v":41248.094979007576}]
["Electrical =","0.04 × B =",{"$f":"0.04*C21","v":11785.169994002164}]
["Piping =","0.02 × B =",{"$f":"0.02*C21","v":5892.5849970010822}]
["Insulation =","0.01 × B =",{"$f":"0.01*C21","v":2946.2924985005411}]
["Painting =","0.01 × B =",{"$f":"0.01*C21","v":2946.2924985005411}]
["Site Preparation (SP) =",null,{"$f":"'Data Inputs'!B54","v":0}]
["Buildings (Bldg) =",null,{"$f":"'Data Inputs'!B55","v":0}]
[]
[null,"Total Direct Costs (DC) =  B + (0.3 × B) + SP + Bldg = ",{"$f":"SUM(C25:C32)+C21","v":383018.02480507031}]
[]
[{"$f":"\"Total Indirect Installation Costs (in \"&'Data Inputs'!B36&\" dollars)\"","v":"Total Indirect Installation Costs (in 2018 dollars)"}]
["Parameter","Equation","Cost"]
["Engineering = ","0.10 × B =",{"$f":"(0.1*C$21)","v":29462.924985005411}]
["Construction and field expenses = ","0.05 × B =",{"$f":"(0.05*C$21)","v":14731.462492502706}]
["Contractor fees =","0.10 × B =",{"$f":"(0.1*C$21)","v":29462.924985005411}]
["Start-up =","0.02 × B =",{"$f":"(0.02*C$21)","v":5892.5849970010822}]
["Performance test =","0.01 × B =",{"$f":"(0.01*C$21)","v":2946.2924985005411}]
[]
["Total Indirect Costs (IC) =",null,{"$f":"(SUM(C38:C42))","v":82496.189958015151}]
["Contingency Cost (C) =","CF(IC+DC)=",{"$f":"(C34+C44)*('Data Inputs'!B57/100)","v":46551.421476308547}]
[]
["Total Capital Investment (TCI) =","DC + IC + C = (1.28 × B) + SP + Bldg. + C =",{"$f":"C34+C44+C45","v":512065.63623939402},{"$f":"\"in \"&'Data Inputs'!$B$36&\" dollars\"","v":"in 2018 dollars"}]
[]
["Annual Costs"]
[]
["Direct Annual Costs"]
["Parameter","Equation","Cost"]
["Annual Electricity Cost =","QElec  × Pelec =",{"$f":"'Data Inputs'!B43*'Design Parameters'!C44","v":8780.4143240727717}]
["Annual Steam Cost (Cs) =","3.50 x mvoc x Ɵs x Ps =",{"$f":"('Design Parameters'!C47/1000)*'Data Inputs'!B44","v":15120}]
["Annual Cooling Water Cost (Ccs) =","3.43 x Cs/Ps x Pwc = ",{"$f":"('Design Parameters'!C51/1000)*'Data Inputs'!B45","v":36821.735999999997}]
["Operating Labor Costs: ","Operator = 0.5 hours/shift × Labor Rate × (Operating hours/8 hours/shift)",{"$f":"0.5*'Data Inputs'!B46*'Data Inputs'!B11/8","v":14839.2}]
[null,"Supervisor = 15% of Operator",{"$f":"(0.15*C56)","v":2225.88}]
["Maintenance Costs:","Labor = 0.5 hours/shift × Labor Rate × (Operating Hours/8 hours/shift)",{"$f":"(0.5*'Data Inputs'!B47*'Data Inputs'!B11/8)","v":16324.2}]
[null,"Materials = 100% of maintenance labor",{"$f":"C58","v":16324.2}]
["Carbon Replacement Costs:","Labor = CRFcarbon x (Labor Rate × Mc)/CRR = ",{"$f":"IF(B8=\"Continuous Operation\",'Design Parameters'!C66*(('Data Inputs'!B47*'Design Parameters'!C27)/'Data Inputs'!B23),'Design Parameters'!C66*(('Data Inputs'!B47*'Design Parameters'!C28)/'Data Inputs'!B23))","v":198.90274100217837}]
[null,"Carbon = CRFcarbon x CC x Mc x 1.08 = ",{"$f":"IF(B8=\"Continuous Operation\",'Design Parameters'!C66*'Data Inputs'!B48*'Design Parameters'!C27*1.08, 'Design Parameters'!C66*'Data Inputs'!B48*'Design Parameters'!C27*1.08)","v":11311.361355522626}]
[]
[]
["Direct Annual Costs (DAC) =",null,{"$f":"SUM(C53:C61)","v":121945.89442059759},{"$f":"\"in \"&'Data Inputs'!$B$36&\" dollars\"","v":"in 2018 dollars"}]
[]
["Indirect Annual Costs"]
["Parameter","Equation","Cost"]
["Overhead","= 60% of sum of operator, supervisor, maintenance labor Plus maintenance materials",{"$f":"(0.6*(C56+C57+C58+C59))","v":29828.087999999996}]
["Administrative Charges","= 2% of TCI",{"$f":"(0.02*C47)","v":10241.31272478788}]
["Property Taxes","= 1% of TCI",{"$f":"0.01*C47","v":5120.6563623939401}]
["Insurance","= 1% of TCI",{"$f":"0.01*C47","v":5120.6563623939401}]
["Capital Recovery","= CRFAdsorber × (TCI - [(1.08 x CC x Mc) + (LR x Mc/CRR)] =",{"$f":"'Design Parameters'!$C$64*(C47-((C61/'Design Parameters'!C66)+(C60/'Design Parameters'!C66)))","v":44532.509130880091}]
[]
["Indirect Annual Costs (IAC) =",null,{"$f":"SUM(C68:C72)","v":94843.222580455855},{"$f":"\"in \"&'Data Inputs'!$B$36&\" dollars\"","v":"in 2018 dollars"}]
[]
["Recovered Solvent Credit/Disposal Costs"]
[]
["Disposal Cost"]
["Parameter","Equation","Cost"]
["VOC Disposal/Treatment Costs (Disposalcost)","= mvoc x Ɵs x Dvoc x E =",{"$f":"'Design Parameters'!C9*2000*'Data Inputs'!B51","v":0}]
[]
[]
[" VOC Recovery Credit"]
["Parameter","Equation","Cost"]
["Annual Recovery Credit for Condensate (RC)","= mvoc × Ɵs x Pvoc x E =",{"$f":"'Design Parameters'!C9*2000*'Data Inputs'!B50","v":279417.60000000003}]
[]
["Total Annual Cost  (TAC) =","DAC + IAC + C + DisposalCost - RC  =",{"$f":"C74+C64+C80-C85","v":-62628.482998946594},{"$f":"\"in \"&'Data Inputs'!$B$36&\" dollars\"","v":"in 2018 dollars"}]
[]
["Cost Effectiveness"]
[]
["Cost Effectiveness "]
["Parameter","Equation","Cost"]
["Total Annual Cost =","TAC =",{"$f":"C87","v":-62628.482998946594},{"$f":"\"per year in \"&'Data Inputs'!B36& \" dollars\"","v":"per year in 2018 dollars"}]
["Annual Quantity of VOC Removed/Recovered =","Wvoc = mvoc x Ɵs x E =",{"$f":"'Data Inputs'!B13*'Data Inputs'!B11*('Data Inputs'!B15/100)*(1/2000)","v":423.36},"tons/year"]
["Cost Effectiveness = ","Total Annual Cost (TAC) / Annual Quantity of VOC Removed/Recovered =",{"$f":"C93/C94","v":-147.93197987279524},{"$f":"\"per ton of pollutants removed/recovered in \"&'Data Inputs'!B36& \" dollars\"","v":"per ton of pollutants removed/recovered in 2018 dollars"}]
[]
["Canisters with carbon replacement"]
["Total Cost for All Carbon Adsorber Canisters (ECAdsorb) =","Canister Cost x Number of Canisters Required =",{"$f":"'Design Parameters'!C61*'Data Inputs'!B42","v":5869200}]
["Auxiliary Equipment (ECaux) =","(Based on design costs or estimated using methods provided in Section 2) ",{"$f":"'Data Inputs'!B56","v":32000}]
["Total Purchased Equipment Costs for Carbon Adsorber (A) =","= ECAdsorb + ECaux =",{"$f":"C98+C99","v":5901200}]
[]
["Instrumentation =","0.10 × A =",{"$f":"0.1*C100","v":590120}]
["Sales taxes =","0.03 × A =",{"$f":"0.03*C100","v":177036}]
["Freight =","0.05 × A =",{"$f":"0.05*C100","v":295060}]
[]
["Total Purchased Equipment Costs (B) = ",null,{"$f":"C100+C102+C103+C104","v":6963416}]
[]
[{"$f":"\"Installation Costs (in \"&'Data Inputs'!B36&\" dollars)\"","v":"Installation Costs (in 2018 dollars)"}]
["Parameter","Equation","Cost"]
["Direct and Indirect Installation =","0.20 × B =",{"$f":"0.08*C106","v":557073.28}]
["Site Preparation (SP) =",null,{"$f":"'Data Inputs'!B133","v":0}]
["Buildings (Bldg) =",null,{"$f":"'Data Inputs'!B134","v":0}]
[]
["Total Direct and Indirect Installation Costs =",null,{"$f":"(SUM(C110:C112))","v":557073.28}]
["Contingency Cost (C) =","CF(Purchase Equipment Cost + Installation costs)=",{"$f":"(C114+C106)*('Data Inputs'!B57/100)","v":752048.92800000007}]
[]
["Total Capital Investment (TCI) =","Purchace Equipment Costs + Installation Costs + Contingency Costs = ",{"$f":"C106+C114+C115","v":8272538.2080000006},{"$f":"\"in \"&'Data Inputs'!$B$36&\" dollars\"","v":"in 2018 dollars"}]
[]
["Annual Costs"]
[]
["Direct Annual Costs"]
["Parameter","Equation","Cost"]
["Operating Labor Costs: ","Operator = 0.5 hours/shift × Labor Rate × (Operating hours/8 hours/shift)",{"$f":"0.5*'Data Inputs'!B46*'Data Inputs'!B11/8","v":14839.2}]
[null,"Supervisor = 15% of Operator",{"$f":"(0.15*C123)","v":2225.88}]
["Maintenance Costs:","Labor = 0.5 hours/shift × Labor Rate × (Operating Hours/8 hours/shift)",{"$f":"(0.5*'Data Inputs'!B47*'Data Inputs'!B11/8)","v":16324.2}]
[null,"Materials = 100% of maintenance labor",{"$f":"C125","v":16324.2}]
["Carbon Replacement Costs:","Labor = CFRcarbon [Labor Rate × TC/CRR] = ",{"$f":"'Design Parameters'!C66*'Data Inputs'!B46*'Design Parameters'!C62/'Data Inputs'!B23","v":22005.8161284173}]
[null,"Carbon =  CRFcarbon[CC x Tc x 1.08] = ",{"$f":"'Design Parameters'!C66*'Data Inputs'!B48*'Design Parameters'!C62*1.08","v":1376680.013183109}]
[]
[]
["Direct Annual Costs (DAC) =",null,{"$f":"SUM(C123:C128)","v":1448399.3093115264},{"$f":"\"in \"&'Data Inputs'!$B$36&\" dollars\"","v":"in 2018 dollars"}]
[]
["Indirect Annual Costs"]
["Parameter","Equation","Cost"]
["Overhead","= 60% of sum of operator, supervisor, maintenance labor Plus maintenance materials",{"$f":"(0.6*(C123+C124+C125+C126))","v":29828.087999999996}]
["Administrative Charges","= 2% of TCI",{"$f":"(0.02*C117)","v":165450.76416000002}]
["Property Taxes","= 1% of TCI",{"$f":"0.01*C117","v":82725.38208000001}]
["Insurance","= 1% of TCI",{"$f":"0.01*C117","v":82725.38208000001}]
["Capital Recovery","= CRFAdsorber × [TCI - [(1.08 *CC *Tc) + (LR*Tc/CRR)] =",{"$f":"'Design Parameters'!$C$64*(C117-((1.08*'Data Inputs'!B48*'Design Parameters'!C62)+('Data Inputs'!B47*'Design Parameters'!C62/'Data Inputs'!B23)))","v":212668.49365773509}]
[]
["Indirect Annual Costs (IAC) =",null,{"$f":"SUM(C135:C139)","v":573398.10997773509},{"$f":"\"in \"&'Data Inputs'!$B$36&\" dollars\"","v":"in 2018 dollars"}]
[]
["Total Annual Cost  (TAC) =","DAC + IAC  =",{"$f":"C141+C131","v":2021797.4192892616},{"$f":"\"in \"&'Data Inputs'!$B$36&\" dollars\"","v":"in 2018 dollars"}]
[]
["Cost Effectiveness"]
[]
["Cost Effectiveness "]
["Parameter","Equation","Cost"]
["Total Annual Cost =","TAC =",{"$f":"C143","v":2021797.4192892616},{"$f":"\"per year in \"&'Data Inputs'!B36& \" dollars\"","v":"per year in 2018 dollars"}]
["Annual Quantity of VOC Removed =","Wvoc = mvoc x Ɵs x E =",{"$f":"'Design Parameters'!C9","v":423.36},"tons/year"]
["Cost Effectiveness = ","Total Annual Cost (TAC) / Annual Quantity of VOC Removed/Recovered =",{"$f":"C149/C150","v":4775.5985905358593},{"$f":"\"per ton of pollutants removed in \"&'Data Inputs'!B36& \" dollars\"","v":"per ton of pollutants removed in 2018 dollars"}]
[]
["Canisters with canister replacement"]
["Total Cost for All Carbon Adsorber Canisters (ECAdsorb) =","Canister Cost x Number of Canisters Required =",{"$f":"'Design Parameters'!C61*'Data Inputs'!B42","v":5869200}]
["Auxiliary Equipment (ECaux) =","(Based on design costs or estimated using methods provided in Section 2) ",{"$f":"'Data Inputs'!B56","v":32000}]
["Total Purchased Equipment Costs for Carbon Adsorber (A) =","= ECAdsorb + ECaux =",{"$f":"C154+C155","v":5901200}]
[]
["Instrumentation =","0.10 × A =",{"$f":"0.1*C156","v":590120}]
["Sales taxes =","0.03 × A =",{"$f":"0.03*C156","v":177036}]
["Freight =","0.05 × A =",{"$f":"0.05*C156","v":295060}]
[]
["Total Purchased Equipment Costs (B) = ",null,{"$f":"C156+C159+C160","v":6373296}]
[]
[{"$f":"\"Installation Costs (in \"&'Data Inputs'!B36&\" dollars)\"","v":"Installation Costs (in 2018 dollars)"}]
["Parameter","Equation","Cost"]
["Installation =","0.20 × B =",{"$f":"0.2*C162","v":1274659.2000000002}]
["Site Preparation (SP) =",null,{"$f":"'Data Inputs'!B54","v":0}]
["Buildings (Bldg) =",null,{"$f":"'Data Inputs'!B55","v":0}]
[]
["Total Direct and Indirect Installation Costs =",null,{"$f":"SUM(C166:C168)","v":1274659.2000000002}]
["Contingency Cost (C) =","CF(Purchase Equipment Cost + Installation costs)=",{"$f":"(C162+C170)*('Data Inputs'!B57/100)","v":764795.52}]
[]
["Total Capital Investment (TCI) =","Purchace Equipment Costs + Installation Costs + Contingency Costs = ",{"$f":"C162+C170+C171","v":8412750.7200000007},{"$f":"\"in \"&'Data Inputs'!$B$36&\" dollars\"","v":"in 2018 dollars"}]
[]
["Annual Costs"]
[]
["Direct Annual Costs"]
["Parameter","Equation","Cost"]
["Maintenance Costs:","0.06 x TCI",{"$f":"C173*0.06","v":504765.04320000001}]
["Carbon Canister Replacement Costs:",{"$f":"IF('Design Parameters'!C54<1,\"Installation Cost = 0.2 x Number of Canisters x Cost per Canister x CRF  =\", \"Installation Cost = 0.2 x Number of Canisters x Cost per canister x Number of times replaced/year =\")","v":"Installation Cost = 0.2 x Number of Canisters x Cost per canister x Number of times replaced/year ="},{"$f":"IF('Design Parameters'!C54<1,0.2*'Design Parameters'!C61*'Data Inputs'!B42*'Design Parameters'!C68,0.2*'Design Parameters'!C61*'Data Inputs'!B42*'Design Parameters'!C54)","v":2315520}]
[null,{"$f":"IF('Design Parameters'!C54<1,\"Canisters = number of canisters x Cost per Canister x 1.08 x CRF = \", \"Canisters = number of canisters x Cost per canister x 1.08 x Number of times replacemed/year = \")","v":"Canisters = number of canisters x Cost per canister x 1.08 x Number of times replacemed/year = "},{"$f":"IF('Design Parameters'!C54<1,'Design Parameters'!C61*'Data Inputs'!B42*1.08*'Design Parameters'!C68,'Design Parameters'!C61*'Data Inputs'!B42*1.08*'Design Parameters'!C54)","v":12503808}]
[]
[]
["Direct Annual Costs (DAC) =",null,{"$f":"SUM(C179:C181)","v":15324093.043200001},{"$f":"\"in \"&'Data Inputs'!$B$36&\" dollars\"","v":"in 2018 dollars"}]
[]
["Indirect Annual Costs"]
["Parameter","Equation","Cost"]
["Administrative Charges","= 2% of TCI",{"$f":"(0.02*C173)","v":168255.01440000001}]
["Property Taxes","= 1% of TCI",{"$f":"0.01*C173","v":84127.507200000007}]
["Insurance","= 1% of TCI",{"$f":"0.01*C173","v":84127.507200000007}]
["Capital Recovery",{"$f":"IF('Design Parameters'!C54>=1,\"= CRFAuxiliary Equipment × (TCI - 1.08(Canister Costs)) =\", \"= CRFAuxiliary Equipment × (TCI - 1.08(Canister Costs)) =\")","v":"= CRFAuxiliary Equipment × (TCI - 1.08(Canister Costs)) ="},{"$f":"'Design Parameters'!$C$64*(C173-(1.08*C154))","v":199815.32266004645}]
[]
["Indirect Annual Costs (IAC) =",null,{"$f":"SUM(C188:C191)","v":536325.35146004648},{"$f":"\"in \"&'Data Inputs'!$B$36&\" dollars\"","v":"in 2018 dollars"}]
[]
["Total Annual Cost  (TAC) =","DAC + IAC  =",{"$f":"C193+C184","v":15860418.394660048},{"$f":"\"in \"&'Data Inputs'!$B$36&\" dollars\"","v":"in 2018 dollars"}]
[]
["Cost Effectiveness"]
[]
["Cost Effectiveness "]
["Parameter","Equation","Cost"]
["Total Annual Cost =","TAC =",{"$f":"C195","v":15860418.394660048},{"$f":"\"per year in \"&'Data Inputs'!B36& \" dollars\"","v":"per year in 2018 dollars"}]
["Annual Quantity of VOC Removed =","Wvoc = mvoc x Ɵs x E =",{"$f":"'Design Parameters'!C9","v":423.36},"tons per year"]
["Cost Effectiveness = ","Total Annual Cost (TAC) / Annual Quantity of VOC Removed/Recovered =",{"$f":"C201/C202","v":37463.195376653552},{"$f":"\"per ton of pollutants removed in \"&'Data Inputs'!B102& \" dollars\"","v":"per ton of pollutants removed in  dollars"}]

{"sheet":"Table A","index":4,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[17,0,17,4],[3,2,3,3],[3,0,4,0],[3,1,4,1]]}
["Table A: Typical Parameters for Selected Adsorption Isothermsa"]
[]
[]
["Compound","Adsorption Temperature \n(°F)","Isotherm Parameters",null,"Range of Isothermb"]
[null,null,"k","m","(psia)"]
["Acetone",100,0.41199999999999998,0.38900000000000001,"0.0001 - 0.05"]
["Acrylonitrile",100,0.93500000000000005,0.42399999999999999,"0.0001 - 0.015"]
["Benzene",77,0.59699999999999998,0.17599999999999999,"0.0001 - 0.05"]
["Chlorobenzene",77,1.05,0.188,"0.0001 - 0.01"]
["Cyclohexane",100,0.505,0.21,"0.0001 - 0.05"]
["Dichloroethane",77,0.97599999999999998,0.28100000000000003,"0.0001 - 0.04"]
["m - Xylene",77,0.70799999999999996,0.113,"0.0001 - 0.001"]
["Phenol",104,0.85499999999999998,0.153,"0.0001 - 0.03"]
["Toluene",77,0.55100000000000005,0.11,"0.001 - 0.05"]
["Trichloroethane",77,1.06,0.161,"0.0001 - 0.04"]
["Vinyl Chloride",100,0.2,0.47699999999999998,"0.0001 - 0.05"]
[]
[" a Each isotherm is of the form w = kPm, where w is the equilibrium adsorptivity (lb adsorbated/lb adsorbant), P is the partial pressure of  VOC in the gas stream (psia), and k and m are empirical parameters based on Calgon BPL carbon.  "]
["b Adsorptivity equation should not be extrapolated outside these ranges."]

{"sheet":"Table B","index":5,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,0,17,4]]}
["Table B: Typical Equipment Costs for Carbon Adsorber Canistersa"]
[]
["Canister Size (in pounds of activated carbon)","Maximum Flow Rate (cfm)","Canister Type",{"$f":"\"Cost with Virgin Carbon (in \"&'Data Inputs'!B36&\" dollars)\"","v":"Cost with Virgin Carbon (in 2018 dollars)"},{"$f":"\"Cost with Reactivated Carbon (in \"&'Data Inputs'!B36&\" dollars)\"","v":"Cost with Reactivated Carbon (in 2018 dollars)"},null,null,null,null,null,"Cost with Virgin Carbon (in 2018 dollars)","Cost with Reactivated Carbon (in 2018 dollars)"]
[140,500,"Polyethylene",{"$f":"K4*('Data Inputs'!B$37/'Data Inputs'!E$37)","v":1046.0829493087556},"-",null,null,null,null,null,720,"-"]
[140,500,"Epoxy-Lined Steel",{"$f":"K5*('Data Inputs'!B$37/'Data Inputs'!E$37)","v":1605.4467485919097},"-",null,null,null,null,null,1105,"-"]
[170,300,"Epoxy-Lined Steel",{"$f":"K6*('Data Inputs'!B$37/'Data Inputs'!E$37)","v":1583.6533538146439},"-",null,null,null,null,null,1090,"-"]
[180,100,"Epoxy-Lined Steel",{"$f":"K7*('Data Inputs'!B$37/'Data Inputs'!E$37)","v":2324.6287762416791},{"$f":"L7*('Data Inputs'!B$37/'Data Inputs'!E$37)","v":1423.8351254480285},null,null,null,null,null,1600,980]
[200,100,"Epoxy-Lined Steel",{"$f":"K8*('Data Inputs'!B$37/'Data Inputs'!E$37)","v":1140.5209933435738},"-",null,null,null,null,null,785,"-"]
[1000,600,"Epoxy-Lined Steel",{"$f":"K9*('Data Inputs'!B$37/'Data Inputs'!E$37)","v":9589.093701996926},"-",null,null,null,null,null,6600,"-"]
[1000,1000,"Epoxy-Lined Steel",{"$f":"K10*('Data Inputs'!B$37/'Data Inputs'!E$37)","v":16708.269329237068},{"$f":"L10*('Data Inputs'!B$37/'Data Inputs'!E$37)","v":10170.250896057347},null,null,null,null,null,11500,7000]
[2000,2000,"Epoxy-Lined Steel",{"$f":"K11*('Data Inputs'!B$37/'Data Inputs'!E$37)","v":27604.966717869938},{"$f":"L11*('Data Inputs'!B$37/'Data Inputs'!E$37)","v":14528.929851510495},null,null,null,null,null,19000,10000]
[2000,750,"Carbon Steel",{"$f":"K12*('Data Inputs'!B$37/'Data Inputs'!E$37)","v":31963.645673323088},{"$f":"L12*('Data Inputs'!B$37/'Data Inputs'!E$37)","v":19178.187403993852},null,null,null,null,null,22000,13200]
[3000,2000,"Epoxy-Lined Steel",{"$f":"K13*('Data Inputs'!B$37/'Data Inputs'!E$37)","v":20195.212493599589},"-",null,null,null,null,null,13900,"-"]
[4100,8000,"Polypropylene",{"$f":"K14*('Data Inputs'!B$37/'Data Inputs'!E$37)","v":65380.184331797223},"-",null,null,null,null,null,45000,"-"]
[5000,2500,"Carbon Steel",{"$f":"K15*('Data Inputs'!B$37/'Data Inputs'!E$37)","v":61893.241167434709},{"$f":"L15*('Data Inputs'!B$37/'Data Inputs'!E$37)","v":29203.149001536094},null,null,null,null,null,42600,20100]
[8000,4500,"Carbon Steel",{"$f":"K16*('Data Inputs'!B$37/'Data Inputs'!E$37)","v":95890.937019969264},{"$f":"L16*('Data Inputs'!B$37/'Data Inputs'!E$37)","v":43586.789554531482},null,null,null,null,null,66000,30000]
[10000,18000,"Polypropylene",{"$f":"K17*('Data Inputs'!B$37/'Data Inputs'!E$37)","v":137298.38709677418},"-",null,null,null,null,null,94500,"-"]
["(a)  Equipment costs based on 2018 data provided by Calgon Carbon Corporation and Carbtrol Corporation. "]