{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Read Me","Data Inputs","Design Parameters","Cost Estimate"],"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":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[[5,0,5,14],[6,0,6,14],[8,1,8,13],[10,1,10,13],[12,1,12,13],[0,0,0,14],[1,0,1,14],[2,0,2,14],[3,0,3,14],[4,0,4,14],[20,1,20,13],[26,1,26,13],[27,1,27,13],[23,1,23,13],[24,1,24,13],[25,1,25,13],[21,1,21,12]]}
["Air Pollution Control Cost Estimation Spreadsheet"]
["For Thermal and Catalytic Oxidizers"]
["U.S. Environmental Protection Agency "]
["Air Economics Group"]
["Health and Environmental Impacts Division"]
["Office of Air Quality Planning and Standards"]
["(January 2018)"]
[]
[null,"This spreadsheet allows users to estimate the capital and annualized costs for installing and operating oxidizers. Oxidizers control volatile organic compounds (VOCs) and hazardous air pollutants (HAP) from industrial waste gas streams by oxidizing organic compounds to carbon dioxide and water. If the waste gas contains chlorinated or sulfonated organic compounds, HCl and SO2 will be generated, which may require acid gas controls, such as a wet scrubber.  There are two major types of oxidizers: thermal and catalytic oxidizers. "]
[]
[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 oxidizer control technology and cost methodology, see Section 3.2, Chapter 2 (Incinerators and Oxidizers) of the Air Pollution Control Cost Manual (as updated in 2016). Additional controls may be necessary for some industrial waste gas streams (e.g., chlorinated and sulfur-containing organic compounds that produce acid gases when oxidized).  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 \"Clean Air Technology Center\" website at: http://www3.epa.gov/ttn/catc/products.html#cccinfo."]
[]
[null,"The spreadsheet can be used to estimate capital and annualized costs for the following types of oxidizers:"]
[]
[null,null,null,"Incinerator Type","Total Waste Gas Flowrate (scfm)"]
[null,null,null,"Thermal Recuperative","500 - 50,000"]
[null,null,null,"Thermal Regenerative","10,000 - 100,000"]
[null,null,null,"Fixed-Bed/Monolith Catalytic","2,000 - 50,000"]
[null,null,null,"Fluid-Bed Catalytic","2,000 - 25,000"]
[]
[null,"Installation costs for a given incinerator could deviate significantly from costs generated using this spreadsheet depending on the site conditions. "]
[null,"Note: This spreadsheet is designed to calculate the design parameters and costs for thermal and catalytic oxidizers used to control waste gas streams that have an oxygen content of at least 20%. If the oxygen content is less than 20%, the waste stream parameters should be adjusted to include auxiliary air sufficient to increase the oxygen content of the waste gas stream above 20%.   "]
[]
[null,"Instructions "]
[null,"Step 1: Please select on the Data Inputs tab and click on the Reset Form button. This will reset the inlet flow rate, pressure drop, fan efficiency, inlet temperature, control efficiency, interest rate, labor rates, electricity and natural gas prices, and the contingency factor to default factors. All other data entry fields will be blank.  "]
[null,"Step 2:  Select the type of oxidizer from the options provided in the pull down menu. The operating temperature will be set to a default value of 2000oF for a regenerative thermal oxidizer, 1600oF for a recuperative thermal oxidizer and 900oF for a catalytic oxidizer. If you select a catalytic oxidizer, the catalyst life, catalyst unit cost, and space velocity factor will be set to default values. You may use site-specific values instead of the default values; however, you should document the source of each value you use. "]
[null,"Step 3:  Complete all of the cells highlighted in yellow. As noted above, some of the highlighted cells are pre-populated with default values based on 2016 data. Users should document the source of all values entered in accordance with the recommendations provided in the Control Cost Manual. Use of actual values other than the default values in this spreadsheet, if appropriately documented, is acceptable.  "]
[null,"Step 4: Once all of the data fields are complete, select the Design Parameters tab to see the calculated design parameters and the Cost Estimate tab to view the calculated cost data for the installation and operation of the oxidizer. If the %LEL for the waste gas exceeds 25%, the spreadsheet adjusts the concentrations and waste gas flow rate to account for the dilution air needed to reduce the %LEL of the waste gas below the 25% threshold. If the oxygen content is less than 20%, auxiliary air must be added."]

{"sheet":"Data Inputs","index":1,"n_rows":80,"n_cols":25,"rows_kept":80,"cut":false,"hidden":false,"merged":[[0,0,0,8],[4,0,4,8],[1,0,1,8],[22,3,22,8],[24,3,24,8],[6,0,6,4],[19,0,19,8],[7,6,7,8],[20,7,21,8],[23,3,23,8],[76,5,76,7],[77,5,77,7],[74,2,74,4],[46,6,46,11],[28,3,28,8],[76,2,76,4],[50,1,50,8],[47,1,47,7],[33,3,33,8],[34,3,34,8],[75,2,75,4],[29,3,29,8],[32,3,32,8],[27,3,27,8],[25,3,25,8],[30,3,30,8],[26,3,26,8],[79,2,79,4],[78,2,78,4],[78,5,78,7],[79,5,79,7],[37,0,37,8],[42,6,42,11],[43,6,43,11],[44,6,44,11],[45,6,45,11],[77,2,77,4],[74,5,74,7],[75,5,75,7]]}
["Data Inputs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type of Oxidizer:"]
["Select the type of oxidizer ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Click to select oxidizer type"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Recuperative Thermal Oxidizer"]
["Enter the following information for your emission source:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Catalytic Oxidizer - Fixed Bed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Catalytic Oxidizer - Monolith"]
["Composition of Inlet Gas Stream",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Catalytic Oxidizer - Fluid Bed"]
["Pollutant Name","Concentration (ppmv)","Lower Explosive Limit (LEL) (ppmv)*","Heat of Combustion (Btu/scf)","Molecular Weight",null,"Note: The lower explosion limit (LEL), heat of combustion and molecular weight for some commonly used VOC/HAP are provided in the table below. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regenerative Thermal Oxidizer"]
["Benzene",1000,14000,3475,78.11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculation of Mass of constituent Controlled",{"$f":"((B9*E9*60*$B$23)/(386.5*1000000))*($B$22/2000)*($B$29/100)","v":1051.5930100905564}]
["Chloromethane",1000,82500,705,50.49,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,679.74562897800786]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Mass of VOC/HAP controlled =",{"$f":"SUM(X9:X18)","v":1731.3386390685641},"tons/year"]
["Enter the design data for the proposed oxidizer:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heat Recovery:"]
[null,null,null,null,null,null,null,{"$f":"IF(AND(V3>1,V3<6,X21=5),\"* The Heat Recovery value you selected is not valid for the type of oxidizer selected.  You must select a value between 0 and 70 percent for a \"&(IF(V3=2,\"recuperative thermal \",\"catalytic \"))&\"oxidizer.\", \" \")","v":" "},null,null,null,null,null,null,null,null,4,null,null,null,null,null,"0 percent",1]
["Number of operating hours/year",8760,"hours/year",null,"Percent Energy Recovery (HR) = ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"35 percent"]
["Inlet volumetric flow rate(Qwi) at 77oF and 1 atm.",20000,{"$f":"IF(B23=20000, \"scfm*\", \"scfm\")","v":"scfm*"},{"$f":"IF(B23=20000,\"* 20,000 scfm is a default volumetric flow rate. User should enter actual value, if known.\",\" \")","v":"* 20,000 scfm is a default volumetric flow rate. User should enter actual value, if known."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50 percent"]
["Inlet volumetric flow rate(Qwi) (actual conditions)",20900,{"$f":"IF(B24=20900, \"acfm*\", \"acfm\")","v":"acfm*"},{"$f":"IF(B24=20900,\"* 20,900 acfm is a default volumetric flow rate. User should enter actual value, if known.\",\" \")","v":"* 20,900 acfm is a default volumetric flow rate. User should enter actual value, if known."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70 percent"]
["Pressure drop (ΔP)",23,{"$f":"IF(B25=23, \"inches of water*\", \"inches of water\")","v":"inches of water*"},{"$f":" IF(OR(B25=23,B25=19),\"* 23 inches of water is the default pressure drop for thermal oxidizers; 19 inches of water is the default pressure drop for catalytic oxidizers. Enter actual value, if known.\",\" \")","v":"* 23 inches of water is the default pressure drop for thermal oxidizers; 19 inches of water is the default pressure drop for catalytic oxidizers. Enter actual value, if known."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Applicable"]
["Motor/Fan Efficiency (ε)",60,{"$f":"IF(B26=60,\"percent*\",\"percent\")","v":"percent*"},{"$f":"IF(B26=60,\"* 60% is a default fan efficiency. User should enter actual value, if known.\",\" \")","v":"* 60% is a default fan efficiency. User should enter actual value, if known."}]
["Inlet Waste Gas Temperature (Twi)",100,{"$f":"IF(B27=100, \" °F*\", \" °F\")","v":" °F*"},{"$f":"IF(B27=100,\"* 100°F is a default temperature. User should enter actual value, if known.\",\" \")","v":"* 100°F is a default temperature. User should enter actual value, if known."}]
["Operating Temperature (Tfi)",900,{"$f":"IF(B28=2000, \" °F*\", \" °F\")","v":" °F"},{"$f":"IF(V3=2,\"* Note: Default value for Tfi is 1600°F for thermal recuperative oxidizers. Use actual value if known.\",IF(OR(V3=3,V3=4,V3=5),\"* Note: Default value for Tfi is 900°F for catalytic oxidizers. Use actual value if known. Tfi for catalytic oxidizers is typically between 300 and 900°F.\",(IF(V3=6,\"* Note: Default value for Tfi is 2000°F for thermal regenerative oxidizers. Use actual value if known. Tfi for regenerative oxidizers typically between 1800 and 2000°F.\",\" \"))))","v":"* Note: Default value for Tfi is 900°F for catalytic oxidizers. Use actual value if known. Tfi for catalytic oxidizers is typically between 300 and 900°F."}]
["Destruction and Removal Efficiency (DRE)",99,{"$f":"IF(B29=99, \"percent*\", \"percent\")","v":"percent*"},{"$f":"IF(B29=99,\"* 99 percent is a default control efficiency. User should enter actual value, if known.\",\" \")","v":"* 99 percent is a default control efficiency. User should enter actual value, if known."}]
["Estimated Equipment Life",20,{"$f":"IF(B30=20, \"Years*\", \"Years\")","v":"Years*"},{"$f":"IF(B30=20,\"* 20 years is the typical equipment life. User should enter actual value, if known.\",\" \")","v":"* 20 years is the typical equipment life. User should enter actual value, if known."}]
["Heat Loss (η)",0,{"$f":"IF(B31=1, \"percent*\", \"percent\")","v":"percent"},{"$f":"IF(B31=1,\"* 1 percent is a default value for the heat loss. User should enter actual value, if known. Heat loss is typically between 0.2 and 1.5%.\",\" \")","v":" "}]
["Catalyst Data:"]
["Estimated catalyst life (y)",4,"years",{"$f":"IF(B33=4,\"* 4 years is a default value. User should enter actual value, if known.\",\" \")","v":"* 4 years is a default value. User should enter actual value, if known."}]
["Catalyst Unit Cost (CC)",350,"$/ft3"]
["Space velocity for catalyst (Φ)",30000,"/hour",{"$f":"IF(B35=30000,\"* 30,000 per hour is a default value. User should enter actual value, if known.\",\" \")","v":"* 30,000 per hour is a default value. User should enter actual value, if known."}]
[]
[]
["Enter the cost data:"]
[]
["Desired dollar-year",2016]
[{"$f":"\"CEPCI* for \" & B40","v":"CEPCI* for 2016"},541.70000000000005,{"$f":"IF(B40=2014,\" \",\"Enter the CEPCI value for \"&B40)","v":"Enter the CEPCI value for 2016"},null,390.6,"1999 CEPCI"]
["Annual Interest Rate (i)",4.25,"Percent"]
["Electricity (Costelect)",6.7400000000000002E-2,"$/kWh",null,null,null,{"$f":"IF(B43=0.0674,\"* $0.0674/kWh is a default price for electicity. User should enter actual value, if known.\",\" \")","v":"* $0.0674/kWh is a default price for electicity. User should enter actual value, if known."}]
["Natural Gas Fuel Cost (Costfuel)",3.8400000000000001E-3,"$/scf",null,null,null,{"$f":"IF(B44=0.00384,\"* $0.00384/scf is a default price for natural gas. User should enter actual value, if known.\",\" \")","v":"* $0.00384/scf is a default price for natural gas. User should enter actual value, if known."}]
["Operator Labor Rate",26.61,"per hour",null,null,null,{"$f":"IF(B45=26.61,\"* $26.61 per hour is a default labor rate. User should enter actual value, if known.\",\" \")","v":"* $26.61 per hour is a default labor rate. User should enter actual value, if known."}]
["Maintenance Labor rate",27.4,"per hour",null,null,null,{"$f":"IF(B46=27.4,\"* $27.40 per hour is a default labor rate. User should enter actual value, if known.\",\" \")","v":"* $27.40 per hour is a default labor rate. User should enter actual value, if known."}]
["Contingency Factor (CF)",10,"Percent",null,null,null,{"$f":"IF(B47=10,\"* 10 percent is a default value for construction contingencies. User may enter values between 5 and 15 percent.\",\" \")","v":"* 10 percent is a default value for construction contingencies. User may enter values between 5 and 15 percent."}]
[null,"* CEPCI is the Chemical Engineering Plant Cost Escalation/De-escalation Index. The use of CEPCI in this spreadsheet is not an endorsement of the index for purposes 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."]
[]
[]
["Data Sources for Default Values Used in Calculations: "]
[]
["Parameters for Common Compounds:"]
[]
["Compound","LEL (ppmv)","Heat of Combustion (Btu/scf)","Molecular Weight"]
["Methane*",50000,911,16.04]
["Ethane",30000,1631,30.07]
["Propane",21000,2353,44.09]
["Butane",19000,3101,58.12]
["Pentane",14000,3709,72.150000000000006]
["Hexane",11000,4404,86.17]
["Octane",10000,5796,114.23]
["Nonane",8000,6493,128.25]
["Decane",8000,7190,142.28]
["Ethylene**",27000,1499,28.05]
["Propylene",20000,2182,42.08]
["Cyclohexane",13000,4180,84.16]
["Benzene**",14000,3475,78.11]
["Toluene**",11000,4274,92.13]
["Methyl Chloride (Chloromethane)**",82500,705,50.49]
["Footnotes"]
["* Greenhouse gas."]
["** Hazardous air pollutant."]
[]
["Data Element","Default Value","Sources for Default Values used in the calculation . . . ",null,null,"If you used your own site-specific values, please enter the  value used and the reference  source . . . ",null,null,"Recommended data sources for site-specific information"]
["Catalyst Cost ($/ft3)",null,null,null,null," ",null,null,"Check with catalyst vendor."]
["Electricity Cost ($/kWh)",6.7400000000000002E-2,"Average annual electricity cost for industrial plants is based on 2016 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,"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. "]
["Fuel Cost ($/MMBtu)",3.34,"Annual average price paid for natural gas by industrial facilities in 2016 from the U.S. Energy Information Administration. Available at http://www.eia.gov/dnav/ng/hist/n3035us3A.htm.",null,null," ",null,null,"Check with fuel supplier or use  U.S. Energy Information Administration (EIA) data for most recent year.\" Available at Available at http://www.eia.gov/dnav/ng/hist/n3035us3A.htm."]
["Operator Labor ($/hour)",26.61,"Bureau of Labor Statistics, May 2016 National Occupational Employment and Wage Estimates – United States, May 2016 (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,"Use plant-specific labor rate."]
["Maintenance Labor ($/hour)",27.4,"Bureau of Labor Statistics, May 2016 National Occupational Employment and Wage Estimates – United States, May 2016 (https://www.bls.gov/oes/current/oes_nat.htm). Hourly rates for maintenance workers based on electrical and electronics commercial and industrial equipment repairers (49-2094).",null,null," ",null,null,"Use plant-specific labor rate."]

{"sheet":"Design Parameters","index":2,"n_rows":67,"n_cols":23,"rows_kept":67,"cut":false,"hidden":false,"merged":[[2,0,2,7],[0,0,0,9],[49,1,49,2],[53,1,53,2],[31,1,31,2],[32,5,33,9],[47,0,47,1],[51,0,51,2],[44,5,45,7],[47,5,48,7],[60,1,60,2],[65,1,65,2],[66,1,66,2],[64,1,64,2],[5,0,5,2],[28,1,28,2],[37,1,37,2],[40,1,40,2],[43,1,43,2],[44,1,44,2],[46,1,46,2],[54,1,54,2],[58,1,58,2],[59,1,59,2]]}
["Design Parameters"]
[]
["The following design parameters for the oxidizer 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."]
[]
[]
["Composition of Inlet Gas Stream"]
["Pollutant Name","Concentration in Waste Stream (ppmv) From Data Inputs Tab","Adjusted Concentration with Dilution Air (ppmv)"]
[{"$f":"'Data Inputs'!A9","v":"Benzene"},{"$f":"'Data Inputs'!B9","v":1000},{"$f":"IF(OR($D$33<25, B8=0), \"NA\", B8*$R$9)","v":"NA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dilution Air Factor",null,null,null,null,{"$f":"IF(C8=\"NA\", B8, C8)","v":1000}]
[{"$f":"'Data Inputs'!A10","v":"Chloromethane"},{"$f":"'Data Inputs'!B10","v":1000},"NA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Inputs'!B9/(Q$9*'Data Inputs'!C9)","v":3.5714285714285717E-5},{"$f":"SUM('Data Inputs'!B9:B18)","v":2000},{"$f":"(P28*0.249)/Q9","v":2.9802590673575127},{"$f":"C8/($C$18*'Data Inputs'!C9)","v":{"$error":"#VALUE!"}},null,null,null,1000]
[{"$f":"'Data Inputs'!A11","v":0},{"$f":"'Data Inputs'!B11","v":0},"NA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Inputs'!B10/(Q$9*'Data Inputs'!C10)","v":6.060606060606061E-6},null,null,{"$f":"C9/($C$18*'Data Inputs'!C10)","v":{"$error":"#VALUE!"}},null,null,null,0]
[{"$f":"'Data Inputs'!A12","v":0},{"$f":"'Data Inputs'!B12","v":0},"NA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Inputs'!B11/(Q$9*'Data Inputs'!C11)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"C10/($C$18*'Data Inputs'!C11)","v":{"$error":"#VALUE!"}},null,null,null,0]
[{"$f":"'Data Inputs'!A13","v":0},{"$f":"'Data Inputs'!B13","v":0},"NA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Inputs'!B12/(Q$9*'Data Inputs'!C12)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"C11/($C$18*'Data Inputs'!C12)","v":{"$error":"#VALUE!"}},null,null,null,0]
[{"$f":"'Data Inputs'!A14","v":0},{"$f":"'Data Inputs'!B14","v":0},"NA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Inputs'!B13/(Q$9*'Data Inputs'!C13)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"C12/($C$18*'Data Inputs'!C13)","v":{"$error":"#VALUE!"}},null,null,null,0]
[{"$f":"'Data Inputs'!A15","v":0},{"$f":"'Data Inputs'!B15","v":0},"NA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Inputs'!B14/(Q$9*'Data Inputs'!C14)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"C13/($C$18*'Data Inputs'!C14)","v":{"$error":"#VALUE!"}},null,null,null,0]
[{"$f":"'Data Inputs'!A16","v":0},{"$f":"'Data Inputs'!B16","v":0},"NA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Inputs'!B15/(Q$9*'Data Inputs'!C15)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"C14/($C$18*'Data Inputs'!C15)","v":{"$error":"#VALUE!"}},null,null,null,0]
[{"$f":"'Data Inputs'!A17","v":0},{"$f":"'Data Inputs'!B17","v":0},"NA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Inputs'!B16/(Q$9*'Data Inputs'!C16)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"C15/($C$18*'Data Inputs'!C16)","v":{"$error":"#VALUE!"}},null,null,null,0]
[{"$f":"'Data Inputs'!A18","v":0},{"$f":"'Data Inputs'!B18","v":0},"NA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Inputs'!B17/(Q$9*'Data Inputs'!C17)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"C16/($C$18*'Data Inputs'!C17)","v":{"$error":"#VALUE!"}},null,null,null,0]
["Total ",{"$f":"SUM(B8:B17)","v":2000},{"$f":"SUM(C8:C17)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Inputs'!B18/(Q$9*'Data Inputs'!C18)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"C17/($C$18*'Data Inputs'!C18)","v":{"$error":"#VALUE!"}}]
[]
["Constants used in calculations:"]
[]
["Temperature of auxiliary fuel (Taf) =","Reference Temperature (Tref) =",77,"°F"]
["Density of auxiliary Fuel at 77 °F (ρaf) =",null,4.0800000000000003E-2,"lb/ft3"]
["Heat Input of auxiliary fuel (-Δhcaf) =",null,21502,"Btu/lb"]
["Density of waste gas at 77 °F (ρwi) =",null,7.3899999999999993E-2,"lb/ft3"]
["Mean Heat Capacity of Air (Cpmair) =","(For catalytic oxidizers)",0.248,"Btu/lb °F"]
["Mean Heat Capacity of Air (Cpmair)","(For thermal oxidizers)",0.255,"Btu/lb °F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEL of Mix",{"$f":"1/(SUMIF(P9:P18,\">0\"))","v":23937.82383419689},null,null,{"$f":"(SUMIF(S9:S18,\">0\"))^-1","v":{"$error":"#DIV/0!"}}]
["Parameter","Equation",null,"Calculated Value","Units","Calculated Value","Units"]
["Sum of volume fraction of combustible components ="," = (∑xi) =",null,{"$f":"SUM('Data Inputs'!B9:B18)","v":2000},"ppmv"]
["Lower Explosive Limit of waste gas (LELmix)","= [∑((xj)/((∑xi) × LELj))]-1 =",null,{"$f":"P28","v":23937.82383419689},"ppmv"]
[null,"Where xj is the volume fraction and LELj the lower explosive limit for each combustible component in the waste gas."]
["% LELmix ","= (Total Combustible Conc. In Mixture/LELmix) × 100 =",null,{"$f":"(D30/D31)*100","v":8.3549783549783552},{"$f":"IF(D33<25,\"percent\",\"percent*\")","v":"percent"},{"$f":"IF(D33>25, \"*Note: Since the LEL of the waste gas stream is above 25%, dilution air must be added to bring the LEL of the mixture below 25%. The concentrations of each pollutant adjusted for dilution air are shown in the table above.\", \"* Note: Since the LEL of the waste gas stream is below 25%, no dilution air is needed.\")","v":"* Note: Since the LEL of the waste gas stream is below 25%, no dilution air is needed."}]
["Dilution Factor "," = (LELmix x 0.249)/(∑xi) =",null,{"$f":"IF(D33>25,D31*0.249/D30, \"Not applicable\")","v":"Not applicable"},{"$f":"IF(D33<25,\" \",\"*\")","v":" "}]
["Lower Explosive Limit (LEL) of waste gas after addition of dilution air","= (Total Adjusted Conc. With Dilution Air/LELmix) × 100 =",null,{"$f":"IF(D33<25, \"Not Applicable\", (C18/S28)*100)","v":"Not Applicable"},{"$f":"IF(D33<25,\" \",\"percent*\")","v":" "}]
[{"$f":"\"Inlet volumetric flow rate(Qwi)\"&IF(D33>25, \" (Adjusted for dilution air)\", \" \")&\"at 77°F and 1 atm.\"","v":"Inlet volumetric flow rate(Qwi) at 77°F and 1 atm."},{"$f":"\"(From Data Inputs Tab\"&(IF(D34=\"Not applicable\",\") = \",\"; adjusted for dilution air) =\"))","v":"(From Data Inputs Tab) = "},null,{"$f":"IF(D35=\"Not applicable\", 'Data Inputs'!B23, (('Data Inputs'!B23*(1-D34))+'Data Inputs'!B23))","v":20000},"scfm"]
["Oxygen Content of gas stream","=  100 - (∑xj × 100/106)  x 0.209 =",null,{"$f":"IF(D33<25, (100-((B18/1000000))*100)*0.209, (100-(C18/1000000)*100)*0.209)","v":20.8582},"percent",{"$f":"IF(D37<20, \"* Stop: Waste gas contains less than 20% oxygen. Cost methodology applies only to waste gas streams with an oxygen content of at least 20% by volume. Please correct the concentrations entered on the Data Inputs sheet before continuing.\", \" \")","v":" "}]
["Fan Power Consumption (FP)","= [(1.17 × 10-4) × Qwi × ΔP]/ε",null,{"$f":"((0.000117)*('Data Inputs'!B24)*('Data Inputs'!B25))/('Data Inputs'!B26/100)","v":93.736500000000007},"kW"]
["Qwo","≈ Qwi =",null,{"$f":"D36","v":20000},"scfm"]
["Operating temperature of oxidizer (Tfi) ","(From Data Inputs Tab)",null,{"$f":"'Data Inputs'!B28","v":900},"°F",null,null,null,null,null,null,null,null,null,"HR =",{"$f":"IF('Data Inputs'!X21=1,0,(IF('Data Inputs'!X21=2,0.35,(IF('Data Inputs'!X21=3,0.5,(IF('Data Inputs'!X21=4,0.7)))))))","v":0}]
["Temperature of waste gas at outlet to preheater (Two)"," = Heat Recovery × (Tfi - Twi) + Twi =",null,{"$f":"(P40*('Design Parameters'!D40-'Data Inputs'!B27)+'Data Inputs'!B27)","v":100},"°F"]
["Temperature of flue gas exiting the oxidizer (Tfo) "," = Tfi - Two + Twi =",null,{"$f":"D40-D41+'Data Inputs'!B27","v":900},"°F","Recuperative/catalytic oxidizer"]
["Temperature of flue gas exiting the regenerative oxidizer (Tfo) "," = Tfi - 0.95(Tfi - Twi) =",null,{"$f":"D40-(0.95*(D40-'Data Inputs'!B27))","v":140},"°F","Regenerative oxidizer"]
["Heat Input of waste gas (-Δhcwi)","= ∑ (-∆hci) xi \nWhere (-∆hci) is the heat of combustion and xi the fraction of component \"i\" at 77 °F. ",null,{"$f":"(W8/1000000)*'Data Inputs'!D9+(W9/1000000)*'Data Inputs'!D10+(W10/1000000)*'Data Inputs'!D11+(W11/1000000)*'Data Inputs'!D12+(W12/1000000)*'Data Inputs'!D13+(W13/1000000)*'Data Inputs'!D14+(W14/1000000)*'Data Inputs'!D15+(W15/1000000)*'Data Inputs'!D16+(W16/1000000)*'Data Inputs'!D17+(W17/1000000)*'Data Inputs'!D18","v":4.18},"Btu/scf",{"$f":"D44/0.0739","v":56.562922868741545},"Btu/lb"]
["Estimated Auxiliary Fuel Flow (Qaf) at 77 °F and 1 atm.",{"$f":"IF('Data Inputs'!V3=6,\"(Calculated using Equation 2.45 in Appendix B)\",\"(Calculated using Equation 2.21 in Chapter 2 of the Cost Manual)\")","v":"(Calculated using Equation 2.21 in Chapter 2 of the Cost Manual)"},null,{"$f":"IF('Data Inputs'!V3=6,T45,(IF('Data Inputs'!V3=1,\" \",P45)))","v":276.23068358024699},{"$f":"IF(P45<0, \"scfm*\", \"scfm\")","v":"scfm"},{"$f":"IF(D45<0, \"Note: Negative value for calculated Qaf indicates that the waste gas is sufficient to support combustion.\", \" \")","v":" "},null,null,null,null,null,null,null,null,"Calculated Qaf =",{"$f":"((C25*D39*((IF('Data Inputs'!V3=2, C27, C26))*((1.1*D40)-D41-(0.1*C22))-F44))/(C24-(1.1*(IF('Data Inputs'!V3=2, C27, C26))*(D40-C22))))/C23","v":276.23068358024699},"Recuperative Ox",{"$f":"IF($D$46<D47, $D$47, $P$45)","v":276.23068358024699},"Calculated Qaf for Regen. =",{"$f":"V49","v":-8.7980598400454024},"Regenerative Ox",{"$f":"IF($T$45<D47, $D$47, $T$45)","v":15291.608914596203}]
["Auxiliary fuel Energy Input =",null,null,{"$f":"IF(D45>0,(C23*D45*C24), 0)","v":242332.09606037283},"Btu/min",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qaf calc. for Regenerative oxidizers:"]
["Minimum Energy required for combustion stabilization =","= 5% × Total Energy Input = 0.05 × ρfi × Qfi × Cpmfi × (Tfi - Tref) =",null,{"$f":"((D39+(IF(D45<0, 0, D45)))*(C25)*(IF(OR('Data Inputs'!V3=2,'Data Inputs'!V3=6), C27, C26))*(D40-C22)*(5/100))","v":15291.608914596203},"Btu/min",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Numerator to Eq. 2.45 =",{"$f":"(C24-C27*(('Data Inputs'!B31/100)*('Data Inputs'!B28-'Design Parameters'!C22)+('Design Parameters'!D43-'Design Parameters'!C22)))","v":21485.935000000001}]
["Is the calculated auxiliary fuel sufficient to stabilize combustion?                                                                 (Note: If the auxiliary fuel energy input > 5% of Total Energy Input, then the auxilary fuel is sufficient.) ",null,null,{"$f":"IF(D46>D47, \"Yes\", \"No\")","v":"Yes"},null,{"$f":"IF(D48=\"Yes\", \" \", \"Note: Additional auxiliary fuel equivalent to 5% of total energy input is required to stabilize combustion.\")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Demonimator for Eq.2.45 =",{"$f":"D39*C25*(C27*((('Data Inputs'!B31/100)*('Data Inputs'!B28-C22))+(D43-C22))-F44)","v":-59855.929999999986}]
[{"$f":"\"Auxiliary fuel flow (Qaf) \"&(IF(D48=\"No\", \"(adjusted for fuel required for combustion stabilization)\", \" \"))&\"at 77°F and 1 atm. =\"","v":"Auxiliary fuel flow (Qaf)  at 77°F and 1 atm. ="},null,null,{"$f":"IF(D48=\"Yes\", D45, (IF(D48=\"No\",D47/( C23*C24))))","v":276.23068358024699},"scfm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qaf =",{"$f":"(V47/V48)/C23","v":-8.7980598400454024}]
["Total Volumetric Throughput (Qtot) at 77 °F and 1 atm."," = Qfi = Qwo + Qa + Qaf = Qwi + Qaf =",null,{"$f":"D39+D49","v":20276.230683580248},{"$f":"IF(P45<0, \"scfm*\", \"scfm\")","v":"scfm"}]
[]
["Calculation of Catalyst Volume and Estimated Temperature of Waste Gas Entering the Catalyst Bed"]
["Volumetric Flow Rate at 60 °F and 1 atm (Qft)","= Qtot × (519)/(77 °F + 460) =",null,{"$f":"D50*(519/(77+460))","v":19596.580493069177},"scfm"]
["Catalyst Volume (Volcat)","= Qft/Φ \nWhere Qft is the volumetric flow rate of the waste gas (Qfi) corrected to 60 °F and 1 atm and Φ is the space velocity for the catalyst.",null,{"$f":"IF(OR('Data Inputs'!V3=3,'Data Inputs'!V3=4,'Data Inputs'!V3=5),((D53/'Data Inputs'!B35)*60),0)","v":39.193160986138352},"ft3"]
["Estimated inlet temperature to the catalyst bed (Tri) =","(Calculated using Equation 2.27 in Chapter 2 of the Cost Manual)",null,{"$f":"(C23*D49*(C24+(1.1*C26*C22))+(C25*D39*C26*(D41+(0.1*C22))))/(1.1*C26*(C23*D49+C25*D39))","v":694.22699087340266},"°F"]
[]
["Capital Recovery Factor:"]
[]
["Parameter","Equation",null,"Calculated Value"]
["Capital Recovery Factor (CRF) = ","i (1+ i)n/(1+ i)n - 1 =",null,{"$f":"(('Data Inputs'!B42/100)*(1+('Data Inputs'!B42/100))^'Data Inputs'!B30)/(((1+('Data Inputs'!B42/100))^'Data Inputs'!B30)-1)","v":7.5219834810246411E-2}]
[null,"Where n = Equipment Life and i= Interest Rate"]
[]
["Future Worth Factor"]
[]
["Parameter","Equation",null,"Calculated Value"]
["Future Worth Factor (FWF) = ","i [1/(1+ i)y - 1] =",null,{"$f":"IF(OR('Data Inputs'!V3=3,'Data Inputs'!V3=4,'Data Inputs'!V3=5),('Data Inputs'!B42/100)*(1/(((1+('Data Inputs'!B42/100))^'Data Inputs'!B33)-1)), \" \")","v":0.23461501671817142}]
[null,"Where y = Catalyst Life and i= Interest Rate"]

{"sheet":"Cost Estimate","index":3,"n_rows":76,"n_cols":9,"rows_kept":76,"cut":false,"hidden":false,"merged":[[0,0,0,3],[39,0,39,1],[14,0,14,1],[69,0,69,3],[71,0,71,3],[56,0,56,3],[73,2,73,3],[44,0,44,3],[2,0,2,3],[3,0,3,3],[19,0,19,3],[31,0,31,3]]}
["Cost Estimate",null,null,null,null,null,"Catalytic - Fixed and Monolith","Catalytic - Fluid-Bed","Thermal - Recuperative"]
[null,null,null,null,null,0,{"$f":"IF(AND('Data Inputs'!$X$21=1, OR('Data Inputs'!$V$3=3, 'Data Inputs'!$V$3=4)),(1105*('Design Parameters'!D50)^(0.5471)),0)","v":251023.85109073066},{"$f":"IF(AND('Data Inputs'!$X$21=1, 'Data Inputs'!$V$3=5),((84800)+(13.2*'Design Parameters'!D50)),0)","v":0},{"$f":"IF(AND('Data Inputs'!$X$21=1, 'Data Inputs'!$V$3=2),(10294*('Design Parameters'!D50)^(0.2355)),0)","v":0}]
["Direct Costs",null,null,null,null,0.35,{"$f":"IF(AND('Data Inputs'!X$21=2, OR('Data Inputs'!V$3=3, 'Data Inputs'!V$3=4)),(3623*('Design Parameters'!D50)^(0.4189)),0)","v":0},{"$f":"IF(AND('Data Inputs'!X$21=2, 'Data Inputs'!$V$3=5),((88400)+(14.6*'Design Parameters'!D50)),0)","v":0},{"$f":"IF(AND('Data Inputs'!$X$21=2, 'Data Inputs'!$V$3=2),(13149*('Design Parameters'!D50)^(0.2609)),0)","v":0}]
[{"$f":"\"Total Purchased equipment costs (in \"&'Data Inputs'!B40&\" dollars)\"","v":"Total Purchased equipment costs (in 2016 dollars)"},null,null,null,null,0.5,{"$f":"IF(AND('Data Inputs'!X$21=3, OR('Data Inputs'!V$3=3, 'Data Inputs'!V$3=4)),(1215*('Design Parameters'!D50)^(0.5575)),0)","v":0},{"$f":"IF(AND('Data Inputs'!X$21=3, 'Data Inputs'!$V$3=5),((86600)+(15.8*'Design Parameters'!D50)),0)","v":0},{"$f":"IF(AND('Data Inputs'!$X$21=3, 'Data Inputs'!$V$3=2),(17056*('Design Parameters'!D50)^(0.2502)),0)","v":0}]
["Incinerator + auxiliary equipmenta (A) =",{"$f":" IF('Data Inputs'!V3=1,\"Please select oxidzer type on the Data Inputs tab.\", \" \")","v":" "},null,null,null,0.7,{"$f":"IF(AND('Data Inputs'!X$21=4, OR('Data Inputs'!V$3=3, 'Data Inputs'!V$3=4)),(1443*('Design Parameters'!D50)^(0.5527)),0)","v":0},{"$f":"IF(AND('Data Inputs'!X$21=4,'Data Inputs'!$V$3=5),((83900)+(19.2*'Design Parameters'!D50)),0)","v":0},{"$f":"IF(AND('Data Inputs'!$X$21=4, 'Data Inputs'!$V$3=2),(21342*('Design Parameters'!D50)^(0.25)),0)","v":0}]
["Equipment Costs  (EC) for Regenerative Oxidizer ",{"$f":"IF('Data Inputs'!V3=6,\"=[2.664 x 100,000 + (13.98 x Qtot)] x (\"&'Data Inputs'!B40&\" CEPI/2016 CEPCI) = \",\" \")","v":" "},{"$f":"IF('Data Inputs'!V3=6,G12*G14, \" \")","v":" "},{"$f":"\"in \"&'Data Inputs'!$B$40&\" dollars\"","v":"in 2016 dollars"}]
["Equipment Costs  (EC) for Recuperative Thermal Oxidizer ",{"$f":"IF(AND('Data Inputs'!$X$21=1,'Data Inputs'!$V$3=2),\"= (10,294 x Qtot^(0.2355))x (\"&'Data Inputs'!B40&\" CEPI/1999 CEPCI) =\",IF(AND('Data Inputs'!$X$21=2,'Data Inputs'!$V$3=2),\"= (13,149 x Qtot^(0.2609)) x (\"&'Data Inputs'!B40&\" CEPI/1999 CEPCI)  =\",IF(AND('Data Inputs'!$X$21=3,'Data Inputs'!$V$3=2),\"= (17,056 x Qtot^(0.2502)) x (\"&'Data Inputs'!B40&\" CEPI/1999 CEPCI)  =\",IF(AND('Data Inputs'!$X$21=4,'Data Inputs'!$V$3=2),\"= (21,342 x Qtot^(0.25)) x (\"&'Data Inputs'!B40&\" CEPI/1999 CEPCI)  =\",\" \"))))","v":" "},{"$f":"IF('Data Inputs'!V3=2,I14, \" \")","v":" "},{"$f":"\"in \"&'Data Inputs'!$B$40&\" dollars\"","v":"in 2016 dollars"}]
[{"$f":"\"Equipment Costs  (EC) for a \"&(IF('Data Inputs'!V3=3,\"Fixed Bed\",IF('Data Inputs'!V3=4,\"Monlith\",\"Fixed Bed/Monolith\")))&\" Catalytic Oxidizer\"","v":"Equipment Costs  (EC) for a Fixed Bed Catalytic Oxidizer"},{"$f":"IF(AND('Data Inputs'!$X$21=1,OR('Data Inputs'!$V$3=3,'Data Inputs'!V3=4 )),\"= (1,105 x Qtot ^(0.5471)) x (\"&'Data Inputs'!B40&\" CEPI/1999 CEPCI)  =\",IF(AND('Data Inputs'!$X$21=2,OR('Data Inputs'!$V$3=3,'Data Inputs'!V3=4)),\"= (3,623 x Qtot^(0.4189)) x (\"&'Data Inputs'!B40&\" CEPI/1999 CEPCI)  =\",IF(AND('Data Inputs'!$X$21=3,OR('Data Inputs'!$V$3=3, 'Data Inputs'!V3=4)),\"= (1,215 x Qtot^(0.5575)) x (\"&'Data Inputs'!B40&\" CEPI/1999 CEPCI)  =\",IF(AND('Data Inputs'!$X$21=4,OR('Data Inputs'!$V$3=3,'Data Inputs'!V3=4)),\"= (1,443 x Qtot^(0.5527)) x (\"&'Data Inputs'!B40&\" CEPI/1999 CEPCI)  =\",\" \"))))","v":"= (1,105 x Qtot ^(0.5471)) x (2016 CEPI/1999 CEPCI)  ="},{"$f":"IF(OR('Data Inputs'!V3=3,'Data Inputs'!V3=4),I14, \" \")","v":348130.10787467693},{"$f":"\"in \"&'Data Inputs'!$B$40&\" dollars\"","v":"in 2016 dollars"}]
["Equipment Costs  (EC) for Fluid Bed Catalytic Oxidizer ",{"$f":"IF(AND('Data Inputs'!$X$21=1,'Data Inputs'!$V$3=5),\"= ((8.48 x 10,000) + (13.2 x Qtot)) x (\"&'Data Inputs'!B40&\" CEPI/1999 CEPCI)  = \",IF(AND('Data Inputs'!$X$21=2,'Data Inputs'!$V$3=5),\"= ((8.84 x 10,000) + (14.6 x Qtot)) x (\"&'Data Inputs'!B40&\" CEPI/1999 CEPCI)  =\",IF(AND('Data Inputs'!$X$21=3,'Data Inputs'!$V$3=5),\"= ((8.66 x 10,000) + (15.8 x Qtot)) x (\"&'Data Inputs'!B40&\" CEPI/1999 CEPCI)  =\",IF(AND('Data Inputs'!$X$21=4,'Data Inputs'!$V$3=5),\"= ((8.39 x 10,000) + (19.2 x Qtot)) x (\"&'Data Inputs'!B40&\" CEPI/1999 CEPCI)  =\",\" \"))))","v":" "},{"$f":"IF('Data Inputs'!V3=5,I14, \" \")","v":" "},{"$f":"\"in \"&'Data Inputs'!$B$40&\" dollars\"","v":"in 2016 dollars"}]
[]
["Instrumentationb =","0.10 × A =",{"$f":"0.1*I14","v":34813.010787467698},null,null,"Regenerative TO",{"$f":"IF('Data Inputs'!V3=6,266400+(13.98*'Design Parameters'!D50),0)","v":0}]
["Sales taxes =","0.03 × A =",{"$f":"0.03*I14","v":10443.903236240307},null,null,"EC",{"$f":"SUM(G2:G5)+SUM(H2:H5)+SUM(I2:I5)+G11","v":251023.85109073066}]
["Freight =","0.05 × A =",{"$f":"0.05*I14","v":17406.505393733849}]
[null,null,null,null,null,"Escalation Factor",{"$f":"'Data Inputs'!B41/'Data Inputs'!E41","v":1.3868407578084998},"A scaled to cost year =",{"$f":"(G12*G14)","v":348130.10787467693}]
["Total Purchased equipment costs (B) = ",null,{"$f":"SUM(C11:C13)+I14","v":410793.52729211876},{"$f":"\"in \"&'Data Inputs'!$B$40&\" dollars\"","v":"in 2016 dollars"}]
["Footnotes"]
["a - Auxiliary equipment includes equipment (e.g., duct work) normally not included with unit furnished by incinerator vendor."]
["b - Includes the instrumentation and controls furnished by the incinerator vendor."]
[]
[{"$f":"\"Direct Installation Costs (in \"&'Data Inputs'!B40&\" dollars)\"","v":"Direct Installation Costs (in 2016 dollars)"}]
["Foundations and Supports =","0.08 × B =",{"$f":"0.08*C$15","v":32863.482183369502}]
["Handlong and Errection =","0.14 × B =",{"$f":"0.14*C$15","v":57511.093820896633}]
["Electrical =","0.04 × B =",{"$f":"0.04*C$15","v":16431.741091684751}]
["Piping =","0.02 × B =",{"$f":"0.02*C$15","v":8215.8705458423756}]
["Insulation for Ductwork =","0.01 × B =",{"$f":"0.01*C$15","v":4107.9352729211878}]
["Painting =","0.01 × B =",{"$f":"0.01*C$15","v":4107.9352729211878}]
["Site Preparation (SP) =",null,0]
["Buildings (Bldg) =",null,0]
[null,"Total Direct Installaton Costs = ",{"$f":"SUM(C21:C28)","v":123238.05818763563}]
["Total Direct Costs (DC) = ","Total Purchase Equipment Costs (B) + Total Direct Installation Costs =",{"$f":"SUM(C21:C28)+C15","v":534031.58547975437},{"$f":"\"in \"&'Data Inputs'!$B$40&\" dollars\"","v":"in 2016 dollars"}]
[]
[{"$f":"\"Total Indirect Installation Costs (in \"&'Data Inputs'!B40&\" dollars)\"","v":"Total Indirect Installation Costs (in 2016 dollars)"}]
[]
["Engineering = ","0.10 × B =",{"$f":"0.1*C$15","v":41079.352729211882}]
["Construction and field expenses = ","0.05 × B =",{"$f":"0.05*C$15","v":20539.676364605941}]
["Contractor fees =","0.10 × B =",{"$f":"0.1*C$15","v":41079.352729211882}]
["Start-up =","0.02 × B =",{"$f":"0.02*C$15","v":8215.8705458423756}]
["Performance test =","0.01 × B =",{"$f":"0.01*C$15","v":4107.9352729211878}]
[]
["Total Indirect Costs (IC) =",null,{"$f":"SUM(C34:C38)","v":115022.18764179327}]
[]
["Continency Cost (C ) =","CF(IC+DC)=",{"$f":"(C40+C30)*('Data Inputs'!B47/100)","v":64905.377312154771}]
["Total Capital Investment =","DC + IC +C =",{"$f":"C30+C40+C42","v":713959.15043370239},{"$f":"\"in \"&'Data Inputs'!$B$40&\" dollars\"","v":"in 2016 dollars"}]
[]
["Direct Annual Costs"]
[]
["Catalyst Replacement Cost","= 1.08 × CC × Volcat × FWF\nWhere CC is the $/ft3 cost for the replacement catalyst; Volcat is the volume of catalyst required based on the waste gas flow rate (Qft) and the catalyst space velocity (Φ); and FWF is the future worth factor.",{"$f":"IF(OR('Data Inputs'!V3=3,'Data Inputs'!V3=4,'Data Inputs'!V3=5), (1.08*'Data Inputs'!B34*'Design Parameters'!D54*'Design Parameters'!D66), 0)","v":3475.8249573603152}]
["Annual Electricity Cost ","= Fan Power Consumption × Operating Hours/year × Electricity Price =",{"$f":"('Design Parameters'!D38*'Data Inputs'!B22*'Data Inputs'!B43)","v":55344.279276000008}]
["Annual Fuel Costs for Natural Gas","= Costfuel × Fuel Usage Rate × 60 min/hr × Operating hours/year",{"$f":"'Data Inputs'!B44*'Design Parameters'!D49*60*'Data Inputs'!B22","v":557517.49359274679}]
["Operating Labor","Operator = 0.5hours/shift × Labor Rate × (Operating hours/8 hours/shift)",{"$f":"0.5*'Data Inputs'!B45*'Data Inputs'!B22/8","v":14568.975}]
[null,"Supervisor = 15% of Operator",{"$f":"0.15*C50","v":2185.3462500000001}]
["Maintenance Costs","Labor = 0.5 hours/shift × Labor Rate × (Operating Hours/8 hours/shift)",{"$f":"0.5*'Data Inputs'!B46*'Data Inputs'!B22/8","v":15001.5}]
[null,"Materials = 100% of maintenance labor",{"$f":"C52","v":15001.5}]
[]
["Direct Annual Costs (DC) =",null,{"$f":"SUM(C47:C53)","v":663094.91907610709},{"$f":"\"in \"&'Data Inputs'!$B$40&\" dollars\"","v":"in 2016 dollars"}]
[]
["Indirect Annual Costs"]
[]
["Overhead","= 60% of sum of operating, supervisor, maintenance labor and maintenance materials",{"$f":"0.6*(C50+C51+C52+C53)","v":28054.392749999999}]
["Administrative Charges","= 2% of TCI",{"$f":"0.02*C43","v":14279.183008674048}]
["Property Taxes","= 1% of TCI",{"$f":"0.01*C43","v":7139.5915043370242}]
["Insurance","= 1% of TCI",{"$f":"0.01*C43","v":7139.5915043370242}]
["Capital Recovery",{"$f":"IF('Data Inputs'!V3=2, \"= CRF x TCI\",\"= CRF[TCI-1.08(cat. Cost)]\")","v":"= CRF[TCI-1.08(cat. Cost)]"},{"$f":"'Design Parameters'!D60*(C43-1.08*(C47))","v":53421.522299435223}]
[]
[]
["Indirect Annual Costs (IC) =",null,{"$f":"SUM(C59:C63)","v":110034.28106678333},{"$f":"\"in \"&'Data Inputs'!$B$40&\" dollars\"","v":"in 2016 dollars"}]
[]
["Total Annual Cost =","DC + IC =",{"$f":"C66+C55","v":773129.20014289045},{"$f":"\"in \"&'Data Inputs'!$B$40&\" dollars\"","v":"in 2016 dollars"}]
[]
["Cost Effectiveness"]
[]
["Cost Effectiveness = (Total Annual Cost)/(Annual Quantity of VOC/HAP Pollutants Destroyed)"]
[]
["Total Annual Cost (TAC) =",{"$f":"C68","v":773129.20014289045},{"$f":"\"per year in \"&'Data Inputs'!B40& \" dollars\"","v":"per year in 2016 dollars"}]
["VOC/HAP Pollutants Destroyed =",{"$f":"'Data Inputs'!X19","v":1731.3386390685641},"tons/year"]
["Cost Effectiveness = ",{"$f":"B74/B75","v":446.54996006952348},{"$f":"\"per ton of pollutants removed in \"&'Data Inputs'!B40& \" dollars\"","v":"per ton of pollutants removed in 2016 dollars"}]