{"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":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":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"]
["(May 2016)"]
[]
[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 methodologoies, see Section 4, Chapter 1 of the Air Pollution Control Cost Manual (as updated in 2016).  A copy of the Control Cost Manual is available on the U.S. EPA's \"Technology Transfer Network\" website at: http://www3.epa.gov/ttn/catc/products.html#cccinfo."]
[]
[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). 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 retofit 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 the 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 2014 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, repectively. 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":73,"n_cols":22,"rows_kept":73,"cut":false,"hidden":false,"merged":[[0,0,0,13],[2,0,2,13],[62,0,62,13],[18,9,18,11],[20,6,20,7],[21,6,21,7],[22,6,22,7],[24,6,24,9],[19,6,19,7],[6,0,6,2],[6,4,6,8],[55,1,55,12],[14,5,14,7],[12,1,12,3],[16,5,16,13],[17,6,17,12],[65,9,65,13],[28,0,28,13],[44,0,44,13],[57,0,57,13],[40,7,40,8],[38,7,38,8],[64,9,64,13],[11,5,11,7],[12,5,12,8],[11,9,11,10],[54,2,54,7],[15,6,15,11],[13,6,13,11],[30,6,30,7],[30,9,30,10],[14,9,14,10],[39,7,39,8],[71,9,71,13],[72,9,72,13],[64,3,64,8],[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],[66,9,66,13],[67,9,67,13],[68,9,68,13],[69,9,69,13],[70,9,70,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 SCR 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.5,{"$f":"IF(D7>1, \"* NOTE: You must document why a retrofit factor of \"&D7&\" is appropriate for the proposed project.\", \" \")","v":"* NOTE: You must document why a retrofit factor of 1.5 is appropriate for the proposed project."},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)?",230,"MMBtu/hour",null,"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":0.34210526315789475}]
[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(V10>3,3)))))","v":2}]
[null,"What is the higher heating value (HHV) of the fuel?",{"$f":"L22","v":7600},"Btu/lb",null,"Enter the sulfur content (%S) =",null,null,{"$f":"J22","v":0.13},"percent by weight",null,null,null,null,null,4,"≥ 3lb/MMBtu","Sub-Bituminous",3]
[null,{"$f":"IF(OR(C12=C73, C12=1030,C12=11814,C12=6534,C12=8730,C12=139713),\"*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?",{"$f":"300000/6*2000","v":100000000},"lbs/year",null,null,{"$f":"IF(OR(I12=C71,I12=0.91,I12=0.31,I12=2.35),\"*The sulfur content of \"&I12&\"% is a default value. See below for data source. Enter actual value, if known.\",(IF(OR(V11=P12,P12=1,P12=4),\" \",(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":" "},null,null,null,null,null,null,null,null,null,null,"Coal blend"]
[null,null," ",null,null,"Ash content (%Ash):",null,null,{"$f":"K22","v":6.5},"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=C72, I15=10.4,I15=5.8,I15=14.3),\"*The ash content of \"&I15&\"% is a default value. See below for data source. Enter actual value, if known.\",\" \")","v":" "},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",null,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,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,2.35,10.4,11814,2.79]
[null,null,"Coal","10 MMBtu/MW",null,null,"Sub-Bituminous",null,1,0.13,6.5,7600,{"$f":"84.42/2000/L22*1000000","v":5.5539473684210527}]
[null,null,"Fuel Oil","11 MMBtu/MW",null,null,"Lignite",null,0,0.91,14.3,6534,1.85]
[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":"0.6*365","v":219},"days",null,null,"Plant Elevation  ",null,450,"Feet above sea level"]
[null,"Inlet NOx Emissions (NOxin) to SNCR",0.46,"lb/MMBtu"]
[null,"NOx Removal Efficiency (EF) provided by vendor (Enter \"UNK\" if value is not known) ",50,"percent"]
[null,"Estimated Normalized Stoichiometric Ratio (NSR)",1.05,null,{"$f":"IF(C34=1.05, \"*The NSR value of \"&C34&\" is a default value. User should enter actual value, if known.\", \" \")","v":"*The NSR value of 1.05 is a default value. User should enter actual value, if known."}]
[]
[null,"Concentration of reagent as stored (Cstored)",50,{"$f":"\"percent\"&(IF(B66<>\" \",\"*\", \" \"))","v":"percent*"},{"$f":"IF(D66=\"Not applicable\", \" \", \"*The reagent concentration of 50% is a default value. User should enter actual value, if known.\")","v":"*The reagent concentration of 50% is a default value. User should enter actual value, if known."}]
[null,"Denisty of reagent as stored (ρstored)",71,"lb/ft3"]
[null,"Concentration of reagent injected (Cinj)",50,"percent",null,null,null,"Densities of typical SNCR reagents: "]
[null,"Number of days reagent is stored (tstorage)",30,"days",null,null,null,"50% urea solution",null,71,"lbs/ft3"]
[null,"Estimated equipment life",10,"Years",null,null,null,"29.4% aqueous NH3",null,56,"lbs/ft3",null,null,null,null,null,"Urea"]
[null,null,null,null,null,null,null,"19% aqueous NH3",null,58,"lbs/ft3",null,null,null,null,1,"Ammonia"]
[null,"Select the reagent used"]
[]
[]
["Enter the cost data for the proposed SNCR:"]
[]
[null,"Desired dollar-year",2016]
[null,{"$f":"\"CEPCI for \" & C47","v":"CEPCI for 2016"},536.4,{"$f":"IF(C47=2014,\" \",\"Enter the CEPCI value for \"&C47)","v":"Enter the CEPCI value for 2016"},null,584.6,"2012 CEPCI",null,"CEPCI = Chemical Engineering Plant Cost Index"]
[null,"Annual Interest Rate (i)",7,"Percent"]
[null,"Fuel (Costfuel)",{"$f":"M22","v":5.5539473684210527},{"$f":"\"$/MMBtu\"&(IF(OR(C50=C69,C50=5.14,C50=20.01, C50=2.79,C50=2.04, C50=1.85),\"*\",\" \"))","v":"$/MMBtu "}]
[null,"Reagent (Costreag)",1.62,{"$f":"\"$/gallon for a \"&C36&\" percent solution of \"&(IF(P41=1,\"urea\",(IF(P41=2,\"ammonia\", \" \"))))&(IF(C51=1.62,\"*\",\" \"))","v":"$/gallon for a 50 percent solution of urea*"}]
[null,"Water (Costwater)",{"$f":"20.1476/1000","v":2.0147600000000002E-2},{"$f":"\"$/gallon\"&(IF(C52=0.0088, \"*\",\" \"))","v":"$/gallon "}]
[null,"Electricity (Costelect)",0.2671,{"$f":"\"$/kWh\"&(IF(OR(C53=0.071, C53=0.039), \"*\",\" \"))","v":"$/kWh "}]
[null,"Ash Disposal (for coal-fired boilers only) (Costash)",18,{"$f":"\"$/ton\"&(IF(C54=18, \"*\",\"\"))","v":"$/ton*"}]
[null,null,{"$f":"IF(OR(C50=C69, C50=5.14, C50=20.01, C50=2.79, C50=2.04, C50=1.85,C51=1.62, C52=0.0088,C53=0.039, C53=0.071, C54=18),\"* The values marked are default values. See the table below for the default values used and their references. Enter actual values, if known.\",\" \")","v":"* The values marked are default values. See the table below for the default values used and their references. Enter actual values, if known."}]
[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(C60>0.015,\"*MCF is greater than the IPM default value of 0.015. User must document why the value entered is appropriate.\",(IF(C60<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(C61>0.03,\"*ACF is greater than the IPM default value of 0.03. User must document why the value entered is appropriate.\",(IF(C61<0.03,\"*ACF is less than the IPM default value of 0.03. User must document why the value entered is appropriate.\",\" \")))","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"20.1476/1000","v":2.0147600000000002E-2}]
["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 the value used and the reference  source . . . ",null,null,null,null,"Recommended data sources for site-specific information"]
[null,"Reagent Cost ","$1.62/gallon of 50% urea solution","Based on vendor quotes collected in 2014.",null,null,null,null,null," ",null,null,null,null,"Check with reagent vendors for current prices. "]
[null,"Water Cost ($/gallon)",8.8000000000000005E-3,"Average combined water/wastewater 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,"Per Asish Agrwal 4/21/17, $20.1476/1000gal",null,null,null,null,"Plant's utiility 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)",3.9E-2,{"$f":"IF(P8=3, \"Average annual electricity cost for industrial plants is based on 2014 price data compiled by the U.S. Energy Information Administration (EIA) from data reported on EIA Form EIA-861 and 861S, (http://www.eia.gov/electricity/data.cfm#sales).\", \"Average annual electricity cost for utilities is based on 2014 electricity production cost data for fossil-fuel plants compiled by the U.S. Energy Information (EIA). Available at http://www.eia.gov/tools/faqs/faq.cfm?id=19&t=3.\")","v":"Average annual electricity cost for industrial plants is based on 2014 price data compiled by the U.S. Energy Information Administration (EIA) from data reported on EIA Form EIA-861 and 861S, (http://www.eia.gov/electricity/data.cfm#sales)."},null,null,null,null,null,"Asish Agrwal 4/21/17, 0.2671$/kwh",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)",2.79,"Weighted average cost based on average 2014 fuel cost data for power plants 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,"CHPP Jan 2016 report, $5.61",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)",18,"Average ash disposal costs based on U.S. coal data for 2014 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 sulfur content for Coal (% weight)",0.31,"Average sulfur content based on U.S. coal data for 2014 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,"From table D 2.10 citing Coal data sheet at http://www.usibelli.com/Coal_data.php lists sulfur content at 0.12-0.28 percent.",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)",10.4,"Average ash content based on U.S. coal data for 2014 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,"CHPP Jan 2016 report, 4.55",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)",11814,"2014 coal data compiled by the Office of Oil, Gas, and Coal Supply Statistics, 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,"D 2-7b from Doyon Tables, Usibelli.com/coal_data.php; 15.1 mmbtu/ton",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/."]

{"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":230},"MMBtu/hour"]
[{"$f":"IF('Data Inputs'!P8=2,\"Maximum Annual MW Output (Bmw) =\",(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 x 8760)/HHV =\", \" \")))","v":"(QB x 1.0E6 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":265105263.15789476},{"$f":"'Data Inputs'!D14","v":"lbs/year"}]
[{"$f":"IF('Data Inputs'!P8=2,\"Estimated Actual Annual MW Output (Boutput) =\",(IF('Data Inputs'!P8=3,\"Actual Annual fuel consumption (Mactual) =\",\" \")))","v":"Actual Annual fuel consumption (Mactual) ="},null,{"$f":"'Data Inputs'!C14","v":100000000},{"$f":"'Data Inputs'!D14","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/365) =\", (IF('Data Inputs'!P8=3, \"(Mactual/Mfuel) x (tSNCR/365) =\", \" \")))","v":"(Mactual/Mfuel) x (tSNCR/365) ="},{"$f":"(C8/C7)*('Data Inputs'!C31/365)","v":0.22632519356759973},"fraction"]
["Total operating time for the SNCR (top) =","CFtotal x 8760 =",{"$f":"C10*8760","v":1982.6086956521735},"hours"]
["NOx Removal Efficiency (EF) =",{"$f":"IF(OR('Data Inputs'!C33=\"UNK\",'Data Inputs'!C33=\" \"),\"22.554 x NOxinlet + 16.725=\", \"(Noxin - NOxout)/Noxin =\")","v":"(Noxin - NOxout)/Noxin ="},{"$f":"IF(OR('Data Inputs'!C33=\"UNK\", 'Data Inputs'!C33=\" \"), ((22.554*'Data Inputs'!C32)+16.725), 'Data Inputs'!C33)","v":50},"percent"]
["NOx removed per hour =","NOxin x EF x QB  =",{"$f":"(C12/100)*'Data Inputs'!C32*'SNCR Design Parameters'!C6","v":52.900000000000006},"lb/hour"]
["Total NOx removed per year =","(NOxin x EF x QB x top)/2000 =",{"$f":"C13*C11/2000","v":52.439999999999991},"tons/year"]
["Coal Factor (CoalF) =","1 for bituminuous; 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.05},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":1.05}]
["SO2 Emission rate =  ","(%S/100)x(64/32)*1E6)/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":" "},null,{"$f":"IF('Data Inputs'!I31<500, \"Not applicable; elevation factor does not apply to plants located at elevations below 500 feet.\", \" \")","v":"Not applicable; elevation factor does not apply to plants located at elevations below 500 feet."}]
[{"$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 450 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":14.472129091012603},"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.5}]
["* 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'!P41=1,\"Urea\",\"Ammonia\")","v":"Urea"},"Molecular Weight of Reagent (MW) = ",null,null,{"$f":"IF('Data Inputs'!P41=1, 60.06, 17.03)","v":60.06},"g/mole",null,null,null,null,{"$f":"IF('Data Inputs'!P41=1,2,1)","v":2},{"$f":"IF('Data Inputs'!P42=1,71,56)","v":56}]
[null,null,null,null,"Density  =",{"$f":"'Data Inputs'!C37","v":71},"lb/gallon"]
[]
["Parameter","Equation","Calculated Value","Units"]
["Reagent consumption rate (mreagent) = ","(NOxin x QB x NSR x MWR)/(MWNOx x SR) =",{"$f":"('Data Inputs'!C32*'SNCR Design Parameters'!C6*'Data Inputs'!C34*'SNCR Design Parameters'!F22)/(46.01*'SNCR Design Parameters'!L22)","v":72.506687676592065},"lb/hour"]
[null,"(whre SR = 1 for NH3; 2 for Urea"]
["Reagent Usage Rate (msol) =","mreagent/Csol =",{"$f":"C26/('Data Inputs'!C36/100)","v":145.01337535318413},"lb/hour"]
[null,"(msol x 7.4805)/Reagent Density",{"$f":"(C28*7.481/F23)","v":15.279507901650289},"gal/hour"]
["Estimated tank volume for reagent storage =","(msol x 7.4805 x tstorage x 24)/Reagent Density =",{"$f":"C29*'Data Inputs'!C39*24","v":11001.245689188208},{"$f":"\"gallons (storage needed to store a \"& 'Data Inputs'!C39 &\" day reagent supply)\"","v":"gallons (storage needed to store a 30 day reagent supply)"}]
[]
["Capital Recovery Factor:"]
[]
["Parameter","Equation","Calculated Value"]
["Capital Recovery Factor (CRF) = ","i (1+ i)n/(1+ i)n - 1 =",{"$f":"(('Data Inputs'!C49/100)*((1+'Data Inputs'!C49/100)^'Data Inputs'!C40))/(((1+'Data Inputs'!C49/100)^'Data Inputs'!C40)-1)","v":0.14237750272736471}]
[null,"Where n = Equipment Life and i= Interest Rate"]
[]
["Parameter","Equation","Calculated Value","Units"]
["Electricity Usage:"]
["Electrcity Consumption (P) = ","(0.47 x NOxin x NSR x QB)/NPHR =",{"$f":"(0.47*'Data Inputs'!C32*'Data Inputs'!C34*'SNCR Design Parameters'!C6)/'Data Inputs'!C18","v":5.2212300000000003},"kW/hour"]
[]
["Water Usage:"]
["Water consumption (qw) =                                                                          ","(msol/Density of water) x ((Cstored/Cinj) - 1) =",{"$f":" (C28/8.345)*(('Data Inputs'!C36/'Data Inputs'!C38)-1)","v":0},"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'!C38)-1))/1000000","v":6.5256018908932859E-2},"MMBtu/hour"]
[]
["Ash Disposal:"]
["Additional ash produced due to increased fuel consumption (Δash) =","(Δfuel x %Ash x 1E6)/HHV =",{"$f":"IF('Data Inputs'!P17=2,(C46*('Data Inputs'!I15/100)*(1/'Data Inputs'!C12)*1000000), 0)","v":0.55811068803692565},"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":2311000},{"$f":"\"in \"&'Data Inputs'!$C$47 & \" dollars\"","v":"in 2016 dollars"}]
["Air Pre-Heater Costs (APHcost)* = ",{"$f":"B36","v":0},{"$f":"\"in \"&'Data Inputs'!$C$47 & \" dollars\"","v":"in 2016 dollars"}]
["Balance of Plant Costs (BOPcost) =",{"$f":"B49","v":1995519.895361603},{"$f":"\"in \"&'Data Inputs'!$C$47 & \" dollars\"","v":"in 2016 dollars"}]
["Total Capital Investment (TCI) =",{"$f":"1.3*(SUM(B10:B12))","v":5598475.8639700841},{"$f":"\"in \"&'Data Inputs'!$C$47 & \" dollars\"","v":"in 2016 dollars"}]
[{"$f":"IF(AND('Data Inputs'!P17=2,'Data Inputs'!V11=3),\"* This factor applies because the boiler burns bituminous coal and emits  eqaal 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) = ",2311000,{"$f":"\"in \"&'Data Inputs'!$C$47 & \" dollars\"","v":"in 2016 dollars"},null,"ELEVF",{"$f":"IF('Data Inputs'!I31<500, 1,'SNCR Design Parameters'!C17)","v":1}]
[]
[]
["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'!C48/'Data Inputs'!F48)*('SNCR Design Parameters'!C19)), 0)","v":0},{"$f":"\"in \"&'Data Inputs'!$C$47 & \" dollars\"","v":"in 2016 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 emit 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 emit equal to or greater than 0.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 Plan 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'!C48/'Data Inputs'!F48)*('SNCR Design Parameters'!C19)","v":1995519.895361603},{"$f":"\"in \"&'Data Inputs'!$C$47 & \" dollars\"","v":"in 2016 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":23}]
["Annual Costs"]
[]
["Total Annual Cost (TAC)"]
["TAC = Direct Annual Costs + Indirect Annual Costs"]
[]
["Direct Annual Costs (DAC) =",{"$f":"C70","v":136545.69987219287},{"$f":"\"in \"&'Data Inputs'!$C$47 & \" dollars\"","v":"in 2016 dollars"}]
["Indirect Annual Costs (IDAC) =",{"$f":"C77","v":799616.32673027273},{"$f":"\"in \"&'Data Inputs'!$C$47 & \" dollars\"","v":"in 2016 dollars"}]
["Total annual costs (TAC) = DAC + IDAC",{"$f":"B57+B58","v":936162.02660246566},{"$f":"\"in \"&'Data Inputs'!$C$47 & \" dollars\"","v":"in 2016 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'!C60&\" x TCI =\"","v":"0.015 x TCI ="},{"$f":"'Data Inputs'!C60*B13","v":83977.137959551255},{"$f":"\"in \"&'Data Inputs'!$C$47 & \" dollars\"","v":"in 2016 dollars"}]
["Annual Reagent Cost =","qsol x Costreag x top =",{"$f":"'Data Inputs'!C51*'SNCR Design Parameters'!C29*'SNCR Design Parameters'!C11","v":49075.122074378698},{"$f":"\"in \"&'Data Inputs'!$C$47 & \" dollars\"","v":"in 2016 dollars"}]
["Annual Electricity Cost =","P x Costelect x top = ",{"$f":"'SNCR Design Parameters'!C40*'Data Inputs'!C53*'SNCR Design Parameters'!C11","v":2764.9273175999997},{"$f":"\"in \"&'Data Inputs'!$C$47 & \" dollars\"","v":"in 2016 dollars"}]
["Annual Water Cost =","qwater x Costwater x top =",{"$f":"'SNCR Design Parameters'!C43*'Data Inputs'!C52*'SNCR Design Parameters'!C11","v":0},{"$f":"\"in \"&'Data Inputs'!$C$47 & \" dollars\"","v":"in 2016 dollars"}]
["Additional Fuel Cost  =","ΔFuel x Costfuel x top =",{"$f":"'SNCR Design Parameters'!C46*'Data Inputs'!C50*'SNCR Design Parameters'!C11","v":718.55388473375353},{"$f":"\"in \"&'Data Inputs'!$C$47 & \" dollars\"","v":"in 2016 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'!C54*(1/2000)), 0)","v":9.9586359291458351},{"$f":"\"in \"&'Data Inputs'!$C$47 & \" dollars\"","v":"in 2016 dollars"}]
["Direct Annual Cost = ",null,{"$f":"SUM(C64:C69)","v":136545.69987219287},{"$f":"\"in \"&'Data Inputs'!$C$47 & \" dollars\"","v":"in 2016 dollars"}]
[]
["Indirect Annual Cost (IDAC)"]
["IDAC = Administrative Charges + Capital Recovery Costs"]
[]
["Administrative Charges (AC) = ",{"$f":"'Data Inputs'!C61 &\" x Annual Maintenance Cost =\"","v":"0.03 x Annual Maintenance Cost ="},{"$f":"'Data Inputs'!C61*C64","v":2519.3141387865376},{"$f":"\"in \"&'Data Inputs'!$C$47 & \" dollars\"","v":"in 2016 dollars"}]
["Capital Recovery Costs (CR)=","CRF x TCI =",{"$f":"'SNCR Design Parameters'!C35*B13","v":797097.01259148621},{"$f":"\"in \"&'Data Inputs'!$C$47 & \" dollars\"","v":"in 2016 dollars"}]
["Indirect Annual Cost (IDAC) =","AC + CR =",{"$f":"C75+C76","v":799616.32673027273},{"$f":"\"in \"&'Data Inputs'!$C$47 & \" dollars\"","v":"in 2016 dollars"}]
[]
[]
["Cost Effectiveness"]
[]
["Cost Effectiveness = Total Annual Cost/ NOx Removed/year"]
[]
["Total Annual Cost (TAC) =",{"$f":"B59","v":936162.02660246566},{"$f":"\"per year in \"&'Data Inputs'!$C$47 & \" dollars\"","v":"per year in 2016 dollars"}]
["NOx Removed =",{"$f":"'SNCR Design Parameters'!C14","v":52.439999999999991},"tons/year"]
["Cost Effectiveness = ",{"$f":"B84/B85","v":17852.060003860905},{"$f":"\"per ton of NOx removed in \"&'Data Inputs'!$C$47 & \" dollars\"","v":"per ton of NOx removed in 2016 dollars"}]