{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Read Me","Data Inputs","SNCR Design Parameters","Cost Estimate"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[[25,1,25,13],[26,1,26,13],[0,0,0,14],[1,0,1,14],[8,1,8,13],[10,1,10,13],[22,1,22,13],[2,0,2,14],[3,0,3,14],[4,0,4,14],[5,0,5,14],[6,0,6,14],[21,1,21,13],[19,1,19,13],[12,1,12,13],[14,2,14,12],[15,2,15,12],[16,2,16,12],[17,2,17,12],[23,1,23,13],[24,1,24,13]]}
["Air Pollution Control Cost Estimation Spreadsheet"]
["For Selective Non-Catalytic Reduction (SNCR)"]
["U.S. Environmental Protection Agency "]
["Air Economics Group"]
["Health and Environmental Impacts Division"]
["Office of Air Quality Planning and Standards"]
["(March 2021)"]
[]
[null,"This spreadsheet allows users to estimate the capital and annualized costs for installing and operating a Selective Non-Catalytic Reduction (SNCR) control device. SNCR is a post-combustion control technology for reducing NOx emissions by injecting an ammonia-base reagent (urea or ammonia) into the furnace at a location where the temperature is in the appropriate range for ammonia radicals to react with NOx to form nitrogen and water.  "]
[]
[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 SNCR chapter and cost estimation methodology in the Control Cost Manual. For a detailed description of the SNCR control technology and the cost methodologies, see Section 4, Chapter 1 of the Air Pollution Control Cost Manual (as updated April 2019).  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 applying SNCR, and particularly to the following types of combustion units:"]
[]
[null,"(1)   ","Coal-fired utility boilers with full load capacities greater than or equal to 25 MW."]
[null,"(2)   ","Fuel oil- and natural gas-fired utility boilers with full load capacities greater than or equal to 25 MW."]
[null,"(3)   ","Coal-fired industrial boilers with maximum heat input capacities greater than or equal to 250 MMBtu/hour."]
[null,"(4)   ","Fuel oil- and natural gas-fired industrial boilers with maximum heat input capacities greater than or equal to 250 MMBtu/hour."]
[]
[null,"The methodology used in this spreadsheet is based on the U.S. EPA Clean Air Markets Division (CAMD)'s Integrated Planning Model (IPM version 6). The size and costs of the SNCR are based primarily on four parameters: the boiler size or heat input, the type of fuel burned, the required level of NOx reduction, and the reagent consumption. This approach provides study-level estimates (±30%) of SNCR capital and annual costs. Default data in the spreadsheet is taken from the SNCR Control Cost Manual and other sources such as the U.S. Energy Information Administration (EIA).  The actual costs may vary from those calculated here due to site-specific conditions, such as the boiler configuration and fuel type. Selection of the most cost-effective control option should be based on a detailed engineering study and cost quotations from system suppliers.  For additional information regarding the IPM, see the EPA Clean Air Markets webpage at http://www.epa.gov/airmarkets/power-sector-modeling.  The Agency wishes to note that all spreadsheet data inputs other than default data are merely available to show an example calculation.  "]
[]
[null,"Instructions "]
[null,"Step 1: Please select on the Data Inputs tab and click on the Reset Form button. This will reset the NSR, plant elevation, estimated equipment life, desired dollar year, cost index (to match desired dollar year), annual interest rate, unit costs for fuel, electricity, reagent, water and ash disposal, and the cost factors for maintenance cost and administrative charges. All other data entry fields will be blank.  "]
[null,"Step 2:  Select the type of combustion unit (utility or industrial) using the pull down menu.  Indicate whether the SNCR is for new construction or retrofit of an existing boiler. If the SNCR will be installed on an existing boiler, enter a retrofit factor equal to or greater than 0.84. Use 1 for retrofits with an average level of difficulty. For more difficult retrofits, you may use a retrofit factor greater than 1; however, you must document why the value used is appropriate."]
[null,"Step 3:  Select the type of fuel burned (coal, fuel oil, and natural gas) using the pull down menu. If you selected coal, select the type of coal burned from the drop down menu. The NOx emissions rate, weight percent coal ash and NPHR will be pre-populated with default factors based on the type of coal selected. However, we encourage you to enter your own values for these parameters, if they are known, since the actual fuel parameters may vary from the default values provided. "]
[null,"Step 4: Complete all of the cells highlighted in yellow. As noted in step 1 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 what is recommended in the Control Cost Manual, and the use of actual values other than the default values in this spreadsheet, if appropriately documented, is acceptable. You may also adjust the maintenance and administrative charges cost factors (cells highlighted in blue) from their default values of 0.015 and 0.03, respectively. The default values for these two factors were developed for the CAMD Integrated Planning Model (IPM). If you elect to adjust these factors, you must document why the alternative values used are appropriate.   "]
[null,"Step 5: Once all of the data fields are complete, select the SNCR 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 SNCR. "]

{"sheet":"Data Inputs","index":1,"n_rows":75,"n_cols":22,"rows_kept":75,"cut":false,"hidden":false,"merged":[[10,1,10,3],[74,3,74,8],[74,9,74,13],[0,0,0,13],[2,0,2,13],[20,6,20,7],[21,6,21,7],[22,6,22,7],[24,6,24,9],[6,0,6,2],[6,4,6,8],[56,1,56,12],[14,5,14,7],[12,1,12,3],[66,9,66,13],[11,5,11,7],[12,5,12,8],[11,9,11,10],[55,2,55,7],[15,6,15,11],[13,6,13,11],[30,6,30,7],[30,9,30,10],[14,9,14,10],[40,7,40,8],[16,5,16,13],[17,6,17,12],[18,6,18,12],[41,7,41,8],[39,7,39,8],[33,4,33,7],[73,9,73,13],[65,3,65,8],[66,3,66,8],[67,3,67,8],[68,3,68,8],[69,3,69,8],[70,3,70,8],[71,3,71,8],[72,3,72,8],[73,3,73,8],[67,9,67,13],[68,9,68,13],[69,9,69,13],[70,9,70,13],[71,9,71,13],[65,9,65,13],[63,0,63,14],[58,0,58,14],[45,0,45,14],[28,0,28,14],[72,9,72,13],[49,8,49,13]]}
["Data Inputs"]
[]
["Enter the following data for your combustion unit:"]
["Is the combustion unit a utility or industrial boiler?",null,null,null,null,"What type of fuel does the unit burn?"]
["Is the SNCR for a new boiler or retrofit of an existing boiler?"]
[]
[{"$f":"IF(S8=3, \"Please enter a retrofit factor equal to or greater than  0.84 based on the level of difficulty.  Enter 1 for projects of average retrofit difficulty.\", \" \")","v":"Please enter a retrofit factor equal to or greater than  0.84 based on the level of difficulty.  Enter 1 for projects of average retrofit difficulty."},null,null,1,{"$f":"IF(D7>1, \"* NOTE: You must document why a retrofit factor of \"&D7&\" is appropriate for the proposed project.\", \" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null," "]
["Complete all of the highlighted data fields:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Utility","New Construction",3]
[null,null,null,null,null,"Provide the following information for coal-fired boilers:",null,null,null,null,null,null,null,null,null,null,"Industrial","Retrofit"]
[null,"What is the maximum heat input rate (QB)?",242.3,"MMBtu/hour","company report","Type of coal burned:",null,null,null,null,null,null,null,null,null,null,null,null,null,"SO2 Emission Rate (lbs SO2/MMBtu) = ",null,{"$f":"((I12/100)*(64/32)*1000000)/C12","v":1.8764302059496563}]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"< 3lb/MMBtu","Bituminous",null,"SO2 Emission Rate",null,{"$f":"IF(I12=\"\",P12,(IF(V10<3,2,(IF(OR(V10>3,V10=3),3)))))","v":2}]
[null,"What is the higher heating value (HHV) of the fuel?",{"$f":"17480000/2000","v":8740},"Btu/lb","company report","Enter the sulfur content (%S) =",null,null,0.82,"percent by weight",null,null,null,null,null,4,"≥ 3lb/MMBtu","Sub-Bituminous",4]
[null,{"$f":"IF(C12=R21,\"*HHV is the weighted average value calculated using the values entered in the coal blend composition table.\",(IF(OR(C12=C74,C12=1033,C12=11814,C12=6534,C12=8730,C12=141468),\"*HHV value of \"&C12&\" \"&D12&\" is a default value. See below for data source. Enter actual HHV for fuel burned, if known. \",\" \")))","v":" "},null,null,null,"or                                                                                   Select the appropriate SO2 emission rate:",null,null,null,null,null,null,null,null,null,null,"Not Applicable","Lignite"]
[null,"What is the estimated actual annual fuel consumption?",150000000,"lbs/Year","estimate",null,{"$f":"IF(OR(P17=1,P17>2,P12=1,I12=\" \"),\" \",(IF(OR(I12=C72,I12=0.82,I12=0.41,I12=1.84),\"*The sulfur content of \"&I12&\"% is a default value. See below for data source. Enter actual value, if known.\",(IF(AND(V11=3,P12=2),\"*Error! Based on the %S value entered, the sulfur dioxide emission rate is ≥ 3 lb/MMBtu. Please correct sulfur content or emission rate, as appropriate.\",(IF(AND(V11=2,P12=3),\"Error! Based on the %S value entered, the sulfur dioxide emission rate is < 3 lb/MMBtu. Please correct sulfur content or emission rate, as appropriate.\",\" \")))))))","v":"*The sulfur content of 0.82% is a default value. See below for data source. Enter actual value, if known."},null,null,null,null,null,null,null,null,null,null,"Coal blend"]
[null,null," ",null,null,"Ash content (%Ash):",null,null,13.6,"percent by weight",null,null,null,null,null,null,null,"Not Applicable"]
[null,"Is the boiler a fluid-bed boiler? ",null,null,null,null,{"$f":"IF(OR(I15=C73, I15=9.23,I15=5.84,I15=13.6),\"*The ash content of \"&I15&\"% is a default value. See below for data source. Enter actual value, if known.\",\" \")","v":"*The ash content of 13.6% is a default value. See below for data source. Enter actual value, if known."},null,null,null,null,null,null,null,null,null,"Coal"]
[null,null,null,null,null,"For units burning coal blends:",null,null,null,null,null,null,null,null,null,2,"Fuel Oil"]
[null,"Enter the net plant heat input rate (NPHR)",10,"MMBtu/MW","company report",null,"Note: The table below is pre-populated with default values for HHV, %S, %Ash and cost. Please enter the actual  values for these parameters in the table below. If the actual value for any parameter is not known, you may use the default values provided.   ",null,null,null,null,null,null,null,null,null,"Natural Gas"]
[null,null,null,null,null,null,"Coal Blend Composition Table"]
[null,null," ",null,null,null,null,null,"Fraction in Coal Blend","%S","%Ash","HHV (Btu/lb)","Fuel Cost ($/MMBtu)"]
[null,"If the NPHR is not known, use the default NPHR value:  ","Fuel Type","Default NPHR",null,null,"Bituminous",null,0,1.84,9.23,11841,2.4,null,null,null,null,10500]
[null,null,"Coal","10 MMBtu/MW",null,null,"Sub-Bituminous",null,0,0.41,5.84,8826,1.89]
[null,null,"Fuel Oil","11 MMBtu/MW",null,null,"Lignite",null,0,0.82,13.6,6626,1.74]
[null,null,"Natural Gas","8.2 MMBtu/MW"]
[null,null,null,null,null,null,"Please click the calculate button to calculate weighted values based on the data in the table above.  ",null,null,null,null,null,null,null,null,3,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note:  If P25= Yes, then BTF = 0.75 for fluid bed boilers; Else BTF=1","No"]
[]
[]
["Enter the following design parameters for the proposed SNCR:"]
[]
[null,"Number of days the SNCR operates (tSNCR)",{"$f":"8592/24","v":358},"days","company report",null,"Plant Elevation  ",null,4555,"Feet above sea level",null,"Goggle Earth"]
[null,"Number of days the boiler operates (tplant)",{"$f":"8592/24","v":358},"days","company report"]
[null,"Inlet NOx Emissions (NOxin) to SNCR",0.19,"lb/MMBtu","company report"]
[null,"Oulet NOx Emissions (NOxout) from SNCR",0.14000000000000001,"lb/MMBtu","based on consultant estimate"]
[null,"Estimated Normalized Stoichiometric Ratio (NSR)",1.05]
[]
[null,"Concentration of reagent as stored (Cstored)",29,"Percent"]
[null,"Density of reagent as stored (ρstored)",56,"lb/ft3"]
[null,"Concentration of reagent injected (Cinj)",10,"percent",null,null,null,"Densities of typical SNCR reagents: "]
[null,"Number of days reagent is stored (tstorage)",14,"days",null,null,null,"50% urea solution",null,71,"lbs/ft3"]
[null,"Estimated equipment life",20,"Years",null,null,null,"29.4% aqueous NH3",null,56,"lbs/ft3",null,null,null,null,1,"Urea"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Ammonia"]
[null,"Select the reagent used"]
[]
[]
["Enter the cost data for the proposed SNCR:"]
[]
[null,"Desired dollar-year",2020]
[null,{"$f":"\"CEPCI for \" & C48","v":"CEPCI for 2020"},596.20000000000005,{"$f":"IF(C48=2016,\" \",\"Enter the CEPCI value for \"&C48)","v":"Enter the CEPCI value for 2020"},null,541.70000000000005,"2016 CEPCI",null,"CEPCI = Chemical Engineering Plant Cost Index"]
[null,"Annual Interest Rate (i)",3.5,{"$f":"IF(C50=3.25, \"Percent*\", \"Percent\")","v":"Percent"},null,null,null,null,{"$f":"IF(C50=3.25,\"* 3.25 percent is the default bank prime rate. User should enter current bank prime rate (available at https://www.federalreserve.gov/releases/h15/.)\",\" \")","v":" "}]
[null,"Fuel (Costfuel)",null,{"$f":"\"$/MMBtu\"&(IF(OR(C51=C70,C51=5.14,C51=20.01, C51=2.79,C51=2.04, C51=1.85),\"*\",\" \"))","v":"$/MMBtu "}]
[null,"Reagent (Costreag)",0.29299999999999998,{"$f":"\"$/gallon for a \"&C37&\" percent solution of \"&(IF(P42=1,\"urea\",(IF(P42=2,\"ammonia\", \" \"))))&(IF(C52=1.66,\"*\",\" \"))","v":"$/gallon for a 29 percent solution of ammonia "}]
[null,"Water (Costwater)",4.5799999999999999E-3,{"$f":"\"$/gallon\"&(IF(C53=0.00417, \"*\",\" \"))","v":"$/gallon "},null,null,null,null,"company report"]
[null,"Electricity (Costelect)",0.12,{"$f":"\"$/kWh\"&(IF(OR(C54=0.0676, C54=0.0361), \"*\",\" \"))","v":"$/kWh "},null,null,null,null,"company report"]
[null,"Ash Disposal (for coal-fired boilers only) (Costash)",48.8,{"$f":"\"$/ton\"&(IF(C55=48.8, \"*\",\"\"))","v":"$/ton*"}]
[null,null," "]
[null,"Note:  The use of CEPCI in this spreadsheet is not an endorsement of the index, 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."]
[]
["Maintenance and Administrative Charges Cost Factors:"]
[null,null,1.4999999999999999E-2]
[null,"Maintenance Cost Factor (MCF) =",1.4999999999999999E-2,{"$f":"IF(C61>0.015,\"*MCF is greater than the IPM default value of 0.015. User must document why the value entered is appropriate.\",(IF(C61<0.015,\"*MCF is less than the IPM default value of 0.015. User must document why the value entered is appropriate.\",\" \")))","v":" "}]
[null,"Administrative Charges Factor (ACF) =",0.03,{"$f":"IF(C62>0.03,\"*ACF is greater than the IPM default value of 0.03. User must document why the value entered is appropriate.\",(IF(C62<0.03,\"*ACF is less than the IPM default value of 0.03. User must document why the value entered is appropriate.\",\" \")))","v":" "}]
[]
["Data Sources for Default Values Used in Calculations: "]
[]
[null,"Data Element","Default Value","Sources for Default Value",null,null,null,null,null,"If you used your own site-specific values, please enter the  value used and the reference  source . . . ",null,null,null,null,"Recommended data sources for site-specific information"]
[null,"Reagent Cost ","$0.293/gallon of 29% Ammonia","U.S. Geological Survey, Minerals Commodity Summaries, January 2017 (https://minerals.usgs.gov/minerals/pubs/commodity/nitrogen/mcs-2017-nitro.pdf",null,null,null,null,null," ",null,null,null,null,"Check with reagent vendors for current prices. "]
[null,"Water Cost ($/gallon)",4.1700000000000001E-3,"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," ",null,null,null,null,"Plant's utility bill or  Black & Veatch's \"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,"Electricity Cost ($/kWh)",6.7599999999999993E-2,"U.S. Energy Information Administration. Electric Power Monthly. Table 5.3. Published December 2017. Available at: https://www.eia.gov/electricity/monthly/epm_table_grapher.php?t=epmt_5_6_a.",null,null,null,null,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. "]
[null,"Fuel Cost ($/MMBtu)",1.74,"U.S. Energy Information Administration. Electric Power Annual 2016. Table 7.4. Published December 2017. Available at: https://www.eia.gov/electricity/annual/pdf/epa.pdf.",null,null,null,null,null," ",null,null,null,null,"Check with fuel supplier or use  U.S. Energy Information Administration (EIA) data for most recent year. Available at http://www.eia.gov/electricity/data/eia923/."]
[null,"Ash Disposal Cost ($/ton)",48.8,"Waste Business Journal.  The Cost to Landfill MSW Continues to Rise Despite Soft Demand.  July 11, 2017.  Available at:  http://www.wastebusinessjournal.com/news/wbj20170711A.htm.",null,null,null,null,null," ",null,null,null,null,"Use plant data or use Waste Business Journal.  The Cost to Landfill MSW Continues to Rise Despite Soft Demand.  July 11, 2017.  Available at:  http://www.wastebusinessjournal.com/news/wbj20170711A.htm."]
[null,"Percent sulfur content for Coal (% weight)",0.82,"Average sulfur content based on U.S. coal data for 2016 compiled by the U.S. Energy Information Administration (EIA) from data reported on EIA Form EIA-923, Power Plant Operations Report. Available at http://www.eia.gov/electricity/data/eia923/.",null,null,null,null,null," ",null,null,null,null,"Check with fuel supplier or use  U.S. Energy Information Administration (EIA) data for most recent year. Available at http://www.eia.gov/electricity/data/eia923/."]
[null,"Percent ash content for Coal (% weight)",13.6,"Average ash content based on U.S. coal data for 2016 compiled by the U.S. Energy Information Administration (EIA) from data reported on EIA Form EIA-923, Power Plant Operations Report. Available at http://www.eia.gov/electricity/data/eia923/.",null,null,null,null,null," ",null,null,null,null,"Check with fuel supplier or use  U.S. Energy Information Administration (EIA) data for most recent year. Available at http://www.eia.gov/electricity/data/eia923/."]
[null,"Higher Heating Value (HHV) (Btu/lb)",6685,"Select type of coal",null,null,null,null,null," ",null,null,null,null,"Fuel supplier or use  U.S. Energy Information Administration (EIA) data for most recent year. Available at http://www.eia.gov/electricity/data/eia923/."]
[null,"Interest Rate",3.25,"Default bank prime rate",null,null,null,null,null,"Bank prime rate is as of March 2, 2021 and is available as the rates listed under 'bank prime loan' at https://www.federalreserve.gov/releases/h15/.",null,null,null,null,"Use current bank prime rate available at https://www.federalreserve.gov/releases/h15/."]

{"sheet":"SNCR Design Parameters","index":2,"n_rows":49,"n_cols":13,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,0,0,7],[2,0,2,7],[48,4,48,7],[14,4,14,7],[24,3,24,7],[25,3,25,7],[27,3,27,7],[28,3,28,7],[29,3,29,7],[21,2,21,4],[15,4,15,7],[16,4,17,7],[19,0,19,3]]}
["SNCR Design Parameters"]
[]
["The following design parameters for the SNCR 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."]
[]
["Parameter","Equation","Calculated Value","Units"]
["Maximum Annual Heat Input Rate (QB) = ",{"$f":"IF('Data Inputs'!P8=2,\"Bmw x NPHR =\", \"HHV x Max. Fuel Rate =\")","v":"HHV x Max. Fuel Rate ="},{"$f":"IF('Data Inputs'!P8=2,('Data Inputs'!C10*'Data Inputs'!C18),'Data Inputs'!C10)","v":242.3},"MMBtu/hour"]
[{"$f":"IF('Data Inputs'!P8=2,\"Maximum Annual MWh Output =\",(IF('Data Inputs'!P8=3,\"Maximum Annual fuel consumption (mfuel) =\",\" \")))","v":"Maximum Annual fuel consumption (mfuel) ="},{"$f":"IF('Data Inputs'!P8=2, \"Bmw x 8760 = \", (IF('Data Inputs'!P8=3, \"(QB x 1.0E6 Btu/MMBtu x 8760)/HHV =\", \" \")))","v":"(QB x 1.0E6 Btu/MMBtu x 8760)/HHV ="},{"$f":"IF('Data Inputs'!P8=3,((('SNCR Design Parameters'!C6/'Data Inputs'!C12)*1000000)*8760),(IF('Data Inputs'!P8=2,('Data Inputs'!C10*8760),\" \")))","v":242854462.24256292},{"$f":"'Data Inputs'!$D$14","v":"lbs/Year"}]
[{"$f":"IF('Data Inputs'!P8=2,\"Estimated Actual Annual MWh Output (Boutput) =\",(IF('Data Inputs'!P8=3,\"Actual Annual fuel consumption (Mactual) =\",\" \")))","v":"Actual Annual fuel consumption (Mactual) ="},null,{"$f":"'Data Inputs'!C14","v":150000000},{"$f":"'Data Inputs'!$D$14","v":"lbs/Year"}]
["Heat Rate Factor (HRF) =","NPHR/10 =",{"$f":"'Data Inputs'!C18/10","v":1}]
["Total System Capacity Factor (CFtotal) =",{"$f":"IF('Data Inputs'!P8=2, \"(Boutput/Bmw)*(tsncr/tplant) =\", (IF('Data Inputs'!P8=3, \"(Mactual/Mfuel) x (tSNCR/tplant) =\", \" \")))","v":"(Mactual/Mfuel) x (tSNCR/tplant) ="},{"$f":"(C8/C7)*('Data Inputs'!C31/'Data Inputs'!C32)","v":0.61765387637876745},"fraction"]
["Total operating time for the SNCR (top) =","CFtotal x 8760 =",{"$f":"C10*8760","v":5410.6479570780029},"hours"]
["NOx Removal Efficiency (EF) =","(NOxin - NOxout)/NOxin =",{"$f":"(('Data Inputs'!C33-'Data Inputs'!C34)/'Data Inputs'!C33)*100","v":26.315789473684205},"percent"]
["NOx removed per hour =","NOxin x EF x QB  =",{"$f":"(C12/100)*'Data Inputs'!C33*'SNCR Design Parameters'!C6","v":12.114999999999998},"lb/hour"]
["Total NOx removed per year =","(NOxin x EF x QB x top)/2000 =",{"$f":"C13*C11/2000","v":32.774999999999999},"tons/year",{"$f":"+C14/C12*100","v":124.54500000000002},"tpy uncontrolled"]
["Coal Factor (CoalF) =","1 for bituminous; 1.05 for sub-bituminous; 1.07 for lignite (weighted average is used for coal blends)",{"$f":"IF('Data Inputs'!P17=2, (IF('Data Inputs'!S12=2,1,(IF('Data Inputs'!S12=3,1.05,(IF('Data Inputs'!S12=4,1.07,L15)))))), \" \")","v":1.07},null,{"$f":"IF('Data Inputs'!P17<>2,\"Not applicable; factor applies only to coal-fired boilers\", \" \")","v":" "},null,null,null,null,null,null,{"$f":"((1*'Data Inputs'!I21)+(1.05*'Data Inputs'!I22)+(1.07*'Data Inputs'!I23))/SUM('Data Inputs'!I21:I23)","v":{"$error":"#DIV/0!"}}]
["SO2 Emission rate =  ","(%S/100)x(64/32)*(1x106)/HHV =",{"$f":"IF('Data Inputs'!V11=2,\"< 3\",(IF('Data Inputs'!V11=3,\"> 3\",\" \")))","v":"< 3"},{"$f":"IF('Data Inputs'!P17=2, \"lbs/MMBtu\", \" \")","v":"lbs/MMBtu"},{"$f":"IF('Data Inputs'!P17<>2,\"Not applicable; factor applies only to coal-fired boilers\", \" \")","v":" "}]
["Elevation Factor (ELEVF)  = ","14.7 psia/P =",{"$f":"IF('Data Inputs'!I31<500, \" \", (14.7/C18))","v":1.1809308268376499},null,{"$f":"IF('Data Inputs'!I31<500, \"Not applicable; elevation factor does not apply to plants located at elevations below 500 feet.\", \" \")","v":" "}]
[{"$f":"IF('Data Inputs'!I31=0,\"Atmospheric pressure at sea level (P) =\",\"Atmospheric pressure at \"&'Data Inputs'!I31&\" feet above sea level (P) =\")","v":"Atmospheric pressure at 4555 feet above sea level (P) ="},"2116x[(59-(0.00356xh)+459.7)/518.6]5.256 x (1/144)* =",{"$f":"(2116)*(((59-(0.00356*'Data Inputs'!I31)+459.7)/518.6)^5.256)*(1/144)","v":12.447807835929158},"psia"]
["Retrofit Factor (RF) =",{"$f":"IF('Data Inputs'!S8=2,\"New Construction\",(IF('Data Inputs'!S8=3,\"Retrofit to existing boiler\",\" \")))","v":"Retrofit to existing boiler"},{"$f":"IF('Data Inputs'!S8=2,0.84,(IF('Data Inputs'!S8=3,'Data Inputs'!D7,\" \")))","v":1}]
["* Equation is from the National Aeronautics and Space Administration (NASA), Earth Atmosphere Model. Available at https://spaceflightsystems.grc.nasa.gov/education/rocket/atmos.html. "]
["Reagent Data:"]
["Type of reagent used",{"$f":"IF('Data Inputs'!P42=1,\"Urea\",\"Ammonia\")","v":"Ammonia"},"Molecular Weight of Reagent (MW) = ",null,null,{"$f":"IF('Data Inputs'!P42=1, 60.06, 17.03)","v":17.03},"g/mole",null,null,null,null,{"$f":"IF('Data Inputs'!P42=1,2,1)","v":1},{"$f":"IF('Data Inputs'!P43=1,71,56)","v":56}]
[null,null,null,null,"Density  =",{"$f":"'Data Inputs'!C38","v":56},"lb/gallon"]
[]
["Parameter","Equation","Calculated Value","Units"]
["Reagent consumption rate (mreagent) = ","(NOxin x QB x NSR x MWR)/(MWNOx x SR) =",{"$f":"('Data Inputs'!C33*'SNCR Design Parameters'!C6*'Data Inputs'!C35*'SNCR Design Parameters'!F22)/(46.01*'SNCR Design Parameters'!L22)","v":17.891993381873512},"lb/hour"]
[null,"(whre SR = 1 for NH3; 2 for Urea)"]
["Reagent Usage Rate (msol) =","mreagent/Csol =",{"$f":"C26/('Data Inputs'!C37/100)","v":61.696528903012116},"lb/hour"]
[null,"(msol x 7.4805)/Reagent Density =",{"$f":"(C28*7.4805/F23)","v":8.2414443653389675},"gal/hour"]
["Estimated tank volume for reagent storage =","(msol x 7.4805 x tstorage x 24 hours/day)/Reagent Density =",{"$f":"ROUNDUP(C29*'Data Inputs'!C40*24,-2)","v":2800},{"$f":"\"gallons (storage needed to store a \"& 'Data Inputs'!C40 &\" day reagent supply rounded up to the nearest 100 gallons)\"","v":"gallons (storage needed to store a 14 day reagent supply rounded up to the nearest 100 gallons)"}]
[]
["Capital Recovery Factor:"]
[]
["Parameter","Equation","Calculated Value"]
["Capital Recovery Factor (CRF) = ","i (1+ i)n/(1+ i)n - 1 =",{"$f":"ROUND((('Data Inputs'!C50/100)*((1+'Data Inputs'!C50/100)^'Data Inputs'!C41))/(((1+'Data Inputs'!C50/100)^'Data Inputs'!C41)-1),4)","v":7.0400000000000004E-2}]
[null,"Where n = Equipment Life and i= Interest Rate"]
[]
["Parameter","Equation","Calculated Value","Units"]
["Electricity Usage:"]
["Electricity Consumption (P) = ","(0.47 x NOxin x NSR x QB)/NPHR =",{"$f":"(0.47*'Data Inputs'!C33*'Data Inputs'!C35*'SNCR Design Parameters'!C6)/'Data Inputs'!C18","v":2.27192595},"kW/hour"]
[]
["Water Usage:"]
["Water consumption (qw) =                                                                          ","(msol/Density of water) x ((Cstored/Cinj) - 1) =",{"$f":" (C28/8.345)*(('Data Inputs'!C37/'Data Inputs'!C39)-1)","v":14.047142590260396},"gallons/hour"]
[]
["Fuel Data:"]
["Additional Fuel required to evaporate water in injected reagent (ΔFuel) =","Hv x mreagent x ((1/Cinj)-1) =",{"$f":"(900*C26*((100/'Data Inputs'!C39)-1))/1000000","v":0.14492514639317544},"MMBtu/hour"]
[]
["Ash Disposal:"]
["Additional ash produced due to increased fuel consumption (Δash) =","(Δfuel x %Ash x 1x106)/HHV =",{"$f":"IF('Data Inputs'!P17=2,(C46*('Data Inputs'!I15/100)*(1/'Data Inputs'!C12)*1000000), 0)","v":2.2551281360951787},"lb/hour",{"$f":"IF('Data Inputs'!P17<>2,\"Not applicable - Ash disposal cost applies only to coal-fired boilers\", \" \")","v":" "}]

{"sheet":"Cost Estimate","index":3,"n_rows":86,"n_cols":7,"rows_kept":86,"cut":false,"hidden":false,"merged":[[83,2,83,3],[36,0,36,2],[51,0,51,3],[29,0,29,3],[30,0,30,3],[31,0,31,3],[32,0,32,3],[33,0,33,3],[72,0,72,3],[79,0,79,3],[81,0,81,3],[38,0,38,3],[39,0,39,3],[40,0,40,3],[41,0,41,3],[42,0,42,3],[0,0,0,3],[24,0,24,3],[23,0,23,3],[2,0,2,3],[4,0,4,3],[5,0,5,3],[7,0,7,3],[18,0,18,3],[19,0,19,3],[20,0,20,3],[21,0,21,3],[22,0,22,3],[16,0,16,3],[17,0,17,3],[13,0,13,2],[60,0,60,3],[61,0,61,3],[71,0,71,3],[44,0,44,3],[45,0,45,3],[46,0,46,3],[53,0,53,3],[54,0,54,3]]}
["Cost Estimate"]
[]
["Total Capital Investment (TCI)"]
[]
["For Coal-Fired Boilers:"]
["TCI = 1.3 x (SNCRcost + APHcost + BOPcost)"]
["For Fuel Oil and Natural Gas-Fired Boilers:"]
["TCI = 1.3 x (SNCRcost + BOPcost)"]
[]
["Capital costs for the SNCR (SNCRcost) =",{"$f":"B27","v":1167058.1292048041},{"$f":"\"in \"&'Data Inputs'!$C$48 & \" dollars\"","v":"in 2020 dollars"}]
["Air Pre-Heater Costs (APHcost)* = ",{"$f":"B36","v":0},{"$f":"\"in \"&'Data Inputs'!$C$48 & \" dollars\"","v":"in 2020 dollars"}]
["Balance of Plant Costs (BOPcost) =",{"$f":"B49","v":1360249.4259929268},{"$f":"\"in \"&'Data Inputs'!$C$48 & \" dollars\"","v":"in 2020 dollars"}]
["Total Capital Investment (TCI) =",{"$f":"1.3*(SUM(B10:B12))","v":3285499.8217570498},{"$f":"\"in \"&'Data Inputs'!$C$48 & \" dollars\"","v":"in 2020 dollars"}]
[{"$f":"IF(AND('Data Inputs'!P17=2,'Data Inputs'!V11=3),\"* This factor applies because the boiler burns bituminous coal and emits equal to or greater than 0.3lb/MMBtu of sulfur dioxide. \", \"* Not applicable - This factor applies only to coal-fired boilers that burn bituminous coal and emits equal to or greater than 0.3lb/MMBtu of sulfur dioxide.\")","v":"* Not applicable - This factor applies only to coal-fired boilers that burn bituminous coal and emits equal to or greater than 0.3lb/MMBtu of sulfur dioxide."}]
[]
[]
["SNCR Capital Costs (SNCRcost)"]
["For Coal-Fired Utility Boilers:"]
["SNCRcost = 220,000 x (BMW x HRF)0.42 x CoalF x BTF x ELEVF x RF"]
["For Fuel Oil and Natural Gas-Fired Utility Boilers:"]
["SNCRcost = 147,000 x (BMW x HRF)0.42 x ELEVF x RF"]
["For Coal-Fired Industrial Boilers:"]
["SNCRcost = 220,000 x (0.1 x QB x HRF)0.42 x CoalF x BTF x ELEVF x RF"]
["For Fuel Oil and Natural Gas-Fired Industrial Boilers:"]
["SNCRcost = 147,000 x ((QB/NPHR)x HRF)0.42 x ELEVF x RF"]
[]
["SNCR Capital Costs (SNCRcost) = ",{"$f":"(IF('Data Inputs'!P17=2,(220000*(((IF('Data Inputs'!P8=2,'Data Inputs'!C10,(0.1*'SNCR Design Parameters'!C6)))*'SNCR Design Parameters'!C9)^0.42)*'SNCR Design Parameters'!C15*F49),(147000*(((IF('Data Inputs'!P8=2,('Data Inputs'!C10),('SNCR Design Parameters'!C6/'Data Inputs'!C18))*'SNCR Design Parameters'!C9)^0.42)))))*(('Data Inputs'!C49/'Data Inputs'!F49)*(F27)*'SNCR Design Parameters'!C19)","v":1167058.1292048041},{"$f":"\"in \"&'Data Inputs'!$C$48 & \" dollars\"","v":"in 2020 dollars"},null,"ELEVF",{"$f":"IF('Data Inputs'!I31<500, 1,'SNCR Design Parameters'!C17)","v":1.1809308268376499}]
[]
[]
["Air Pre-Heater Costs (APHcost)*"]
["For Coal-Fired Utility Boilers:"]
[" APHcost = 69,000 x (BMW x HRF x CoalF)0.78 x AHF x RF"]
["For Coal-Fired Industrial Boilers:"]
[" APHcost = 69,000 x (0.1 x QB x HRF x CoalF)0.78 x AHF x RF"]
[]
["Air Pre-Heater Costs (APHcost) = ",{"$f":"IF('Data Inputs'!P17=2,(69000*(((IF('Data Inputs'!P8=2,'Data Inputs'!C10,(0.1*'SNCR Design Parameters'!C6)))*'SNCR Design Parameters'!C9*'SNCR Design Parameters'!C15)^0.78)*(IF('Data Inputs'!V11=3,1,0))*('Data Inputs'!C49/'Data Inputs'!F49)*('SNCR Design Parameters'!C19)), 0)","v":0},{"$f":"\"in \"&'Data Inputs'!$C$48 & \" dollars\"","v":"in 2020 dollars"}]
[{"$f":"IF(AND('Data Inputs'!P17=2,'Data Inputs'!V11=3),\"* This factor applies because the boiler burns bituminous coal and emits equal to or greater than 3lb/MMBtu of sulfur dioxide. \", \"* Not applicable - This factor applies only to coal-fired boilers that burn bituminous coal and emit equal to or greater than 3lb/MMBtu of sulfur dioxide.\")","v":"* Not applicable - This factor applies only to coal-fired boilers that burn bituminous coal and emit equal to or greater than 3lb/MMBtu of sulfur dioxide."}]
[]
["Balance of Plant Costs (BOPcost)"]
["For Coal-Fired Utility Boilers:"]
["BOPcost = 320,000 x (BMW)0.33 x (NOxRemoved/hr)0.12 x BTF x RF"]
["For Fuel Oil and Natural Gas-Fired Utility Boilers:"]
["BOPcost = 213,000 x (BMW)0.33 x (NOxRemoved/hr)0.12 x RF"]
["For Coal-Fired Industrial Boilers:"]
["BOPcost = 320,000 x (0.1 x QB)0.33 x (NOxRemoved/hr)0.12 x BTF x RF"]
["For Fuel Oil and Natural Gas-Fired Industrial Boilers:"]
["BOPcost = 213,000 x (QB/NPHR)0.33 x (NOxRemoved/hr)0.12 x RF"]
[]
["Balance of Plant Costs (BOPcost) =",{"$f":"(IF('Data Inputs'!P8=2,(F50*(('Data Inputs'!C10)^0.33)*(('SNCR Design Parameters'!C13)^0.12)*'Cost Estimate'!F49),(F50*(F51^0.33)*(('SNCR Design Parameters'!C13)^0.12)*'Cost Estimate'!F49)))*('Data Inputs'!C49/'Data Inputs'!F49)*('SNCR Design Parameters'!C19)","v":1360249.4259929268},{"$f":"\"in \"&'Data Inputs'!$C$48 & \" dollars\"","v":"in 2020 dollars"},null,null,{"$f":"IF('Data Inputs'!P25=2,0.75,1)","v":1},"BTF"]
[null,null,null,null,null,{"$f":"IF('Data Inputs'!P17=2,320000,213000)","v":320000}]
[null,null,null,null,null,{"$f":"IF('Data Inputs'!P17=2,(0.1*'SNCR Design Parameters'!C6),('SNCR Design Parameters'!C6/'Data Inputs'!C18))","v":24.230000000000004}]
["Annual Costs"]
[]
["Total Annual Cost (TAC)"]
["TAC = Direct Annual Costs + Indirect Annual Costs"]
[]
["Direct Annual Costs (DAC) =",{"$f":"C70","v":64468.754228113379},{"$f":"\"in \"&'Data Inputs'!$C$48 & \" dollars\"","v":"in 2020 dollars"}]
["Indirect Annual Costs (IDAC) =",{"$f":"C77","v":232777.66237148698},{"$f":"\"in \"&'Data Inputs'!$C$48 & \" dollars\"","v":"in 2020 dollars"}]
["Total annual costs (TAC) = DAC + IDAC",{"$f":"B57+B58","v":297246.41659960034},{"$f":"\"in \"&'Data Inputs'!$C$48 & \" dollars\"","v":"in 2020 dollars"}]
[]
["Direct Annual Costs (DAC)"]
["DAC = (Annual Maintenance Cost) + (Annual Reagent Cost) + (Annual Electricity Cost) + (Annual Water Cost) + (Annual Fuel Cost) + (Annual Ash Cost)"]
[]
["Annual Maintenance Cost =",{"$f":"'Data Inputs'!C61&\" x TCI =\"","v":"0.015 x TCI ="},{"$f":"'Data Inputs'!C61*B13","v":49282.497326355748},{"$f":"\"in \"&'Data Inputs'!$C$48 & \" dollars\"","v":"in 2020 dollars"}]
["Annual Reagent Cost =","qsol x Costreag x top =",{"$f":"'Data Inputs'!C52*'SNCR Design Parameters'!C29*'SNCR Design Parameters'!C11","v":13065.325356777139},{"$f":"\"in \"&'Data Inputs'!$C$48 & \" dollars\"","v":"in 2020 dollars"}]
["Annual Electricity Cost =","P x Costelect x top = ",{"$f":"'SNCR Design Parameters'!C40*'Data Inputs'!C54*'SNCR Design Parameters'!C11","v":1475.1109800000002},{"$f":"\"in \"&'Data Inputs'!$C$48 & \" dollars\"","v":"in 2020 dollars"}]
["Annual Water Cost =","qwater x Costwater x top =",{"$f":"'SNCR Design Parameters'!C43*'Data Inputs'!C53*'SNCR Design Parameters'!C11","v":348.09897658319329},{"$f":"\"in \"&'Data Inputs'!$C$48 & \" dollars\"","v":"in 2020 dollars"}]
["Additional Fuel Cost  =","ΔFuel x Costfuel x top =",{"$f":"'SNCR Design Parameters'!C46*'Data Inputs'!C51*'SNCR Design Parameters'!C11","v":0},{"$f":"\"in \"&'Data Inputs'!$C$48 & \" dollars\"","v":"in 2020 dollars"}]
["Additional Ash Cost =","ΔAsh x Costash x top x (1/2000) =",{"$f":"IF('Data Inputs'!P17=2,('SNCR Design Parameters'!C49*'SNCR Design Parameters'!C11*'Data Inputs'!C55*(1/2000)), 0)","v":297.72158839730514},{"$f":"\"in \"&'Data Inputs'!$C$48 & \" dollars\"","v":"in 2020 dollars"}]
["Direct Annual Cost = ",null,{"$f":"SUM(C64:C69)","v":64468.754228113379},{"$f":"\"in \"&'Data Inputs'!$C$48 & \" dollars\"","v":"in 2020 dollars"}]
[]
["Indirect Annual Cost (IDAC)"]
["IDAC = Administrative Charges + Capital Recovery Costs"]
[]
["Administrative Charges (AC) = ",{"$f":"'Data Inputs'!C62 &\" x Annual Maintenance Cost =\"","v":"0.03 x Annual Maintenance Cost ="},{"$f":"'Data Inputs'!C62*C64","v":1478.4749197906724},{"$f":"\"in \"&'Data Inputs'!$C$48 & \" dollars\"","v":"in 2020 dollars"}]
["Capital Recovery Costs (CR)=","CRF x TCI =",{"$f":"'SNCR Design Parameters'!C35*B13","v":231299.18745169631},{"$f":"\"in \"&'Data Inputs'!$C$48 & \" dollars\"","v":"in 2020 dollars"}]
["Indirect Annual Cost (IDAC) =","AC + CR =",{"$f":"C75+C76","v":232777.66237148698},{"$f":"\"in \"&'Data Inputs'!$C$48 & \" dollars\"","v":"in 2020 dollars"}]
[]
[]
["Cost Effectiveness"]
[]
["Cost Effectiveness = Total Annual Cost/ NOx Removed/year"]
[]
["Total Annual Cost (TAC) =",{"$f":"B59","v":297246.41659960034},{"$f":"\"per year in \"&'Data Inputs'!$C$48 & \" dollars\"","v":"per year in 2020 dollars"}]
["NOx Removed =",{"$f":"'SNCR Design Parameters'!C14","v":32.774999999999999},"tons/year"]
["Cost Effectiveness = ",{"$f":"B84/B85","v":9069.3033287444814},{"$f":"\"per ton of NOx removed in \"&'Data Inputs'!$C$48 & \" dollars\"","v":"per ton of NOx removed in 2020 dollars"}]