{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Read Me","Data Inputs","SCR Design Parameters","Cost Estimate","ESRI_MAPINFO_SHEET"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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 Catalytic Reduction (SCR)"]
["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 Catalytic Reduction (SCR) control device. SCR is a post-combustion control technology for reducing NOx emissions that employs a metal-based catalyst and an ammonia-based reducing reagent (urea or ammonia). The reagent reacts selectively with the flue gas NOx within a specific temperature range to produce N2 and water vapor. "]
[]
[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 SCR chapter and cost estimation methodology in the Control Cost Manual. For a detailed description of the SCR control technology and the cost methodologies, see Section 4, Chapter 2 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 SCR, 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 5.13). The size and costs of the SCR are based primarily on five parameters: the boiler size or heat input, the type of fuel burned, the required level of NOx reduction, reagent consumption rate, and catalyst costs. The equations for utility boilers are identical to those used in the IPM. However, the equations for industrial boilers were developed based on the IPM equations for utility boilers. This approach provides study-level estimates (±30%) of SCR capital and annual costs. Default data in the spreadsheet is taken from the SCR 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. 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 clear many of the input cells and reset others to default values.   "]
[null,"Step 2:  Select the type of combustion unit (utility or industrial) using the pull down menu. Indicate whether the SCR is for new construction or retofit of an existing boiler. If the SCR will be installed on an existing boiler, enter a retrofit factor between 0.8 and 1.5. 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 select fuel oil or natural gas, the HHV and NPHR fields will be prepopulated with default values. If you select coal, then you must complete the coal input box by first selecting the type of coal burned from the drop down menu. The weight percent sulfur content, HHV, 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. Method 1 is pre-selected as the default method for calculating the catalyst replacement cost. For coal-fired units, you choose either method 1 or method 2 for calculating the catalyst replacement cost by selecting appropriate radio button. "]
[null,"Step 4: Complete all of the cells highlighted in yellow. If you do not know the catalyst volume (Volcatalyst) or flue gas flow rate (Qflue gas), please enter \"UNK\" and these values will be calculated for you. 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.005 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 SCR 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 SCR. "]

{"sheet":"Data Inputs","index":1,"n_rows":74,"n_cols":22,"rows_kept":74,"cut":false,"hidden":false,"merged":[[57,8,57,13],[73,3,73,8],[68,3,68,8],[69,3,69,8],[70,3,70,8],[70,9,70,13],[71,9,71,13],[72,9,72,13],[73,9,73,13],[71,3,71,8],[72,3,72,8],[68,9,68,13],[69,9,69,13],[59,1,59,7],[58,8,58,13],[0,0,0,13],[2,0,2,13],[16,9,16,11],[18,6,18,7],[19,6,19,7],[11,5,11,7],[11,9,11,10],[6,0,6,2],[5,0,5,2],[17,6,17,7],[12,1,12,3],[14,5,14,13],[15,6,15,12],[12,6,12,11],[6,4,6,8],[34,7,34,9],[35,7,35,9],[34,11,34,13],[35,11,35,13],[20,6,20,7],[22,6,22,9],[24,11,24,13],[24,5,24,10],[25,5,25,10],[37,4,37,8],[54,8,54,13],[55,8,55,13],[56,8,56,13],[36,11,36,13],[38,11,38,13],[39,11,39,13],[39,7,39,9],[40,4,42,8],[56,3,56,7]]}
["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 between 0.8 and 1.5 based on the level of difficulty.  Enter 1 for projects of average retrofit difficulty.\", \" \")","v":"Please enter a retrofit factor between 0.8 and 1.5 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",null,3,"New Construction"]
[null,null,null,null,null,"Provide the following information for coal-fired boilers:",null,null,null,null,null,null,null,null,null,null,"Industrial",null,null,"Retrofit"]
[null,"What is the rating at full load capacity (MMBtu/hr)?",230,"MMBtu/hr",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":"IF(I12=\" \", \"NA\",((I12/100)*(64/32)*1000000)/C12)","v":0.52910052910052907}]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bituminous",null,"SO2 Emission Rate",null,{"$f":"IF(V10=\"NA\",1, (IF(V10<3,2,(IF(V10>3,3)))))","v":2}]
[null,"What is the higher heating value (HHV) of the fuel?",7560,"Btu/lb",null,"Enter the sulfur content (%S) =",null,null,0.2,"percent by weight",null,null,null,null,null,1,null,"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,null,{"$f":"IF(P17=2, (IF(OR(I12=0.91,I12=0.31,I12=2.35,I12=C72),\"*The sulfur content of \"&I12&\"% is a default value. See below for data source. Enter actual value, if known.\", \" \")), \" \")","v":" "},null,null,null,null,null,null,null,null,null,null,"Lignite"]
[null,"What is the estimated actual annual fuel consumption?",{"$f":"660000000/6","v":110000000},"lbs/year",null,null,null,null,null,null,null,null,null,null,null,null,null,"Coal blend"]
[null,null," ",null,null,"For units burning coal blends:",null,null,null,null,null,null,null,null,null,null,null,"Not Applicable"]
[null,null,null,null,null,null,"Note: The table below is pre-populated with default values for HHV and  %S. 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,"Coal"]
[null,"Enter the net plant heat input rate (NPHR)",10,"MMBtu/MW",null,null,null,null,null,null,null,null,null,null,null,2,"Fuel Oil"]
[null,null," ",null,null,null,null,null,"Fraction in Coal Blend","%S","HHV (Btu/lb)",null,null,null,null,null,"Natural Gas"]
[null,"If the NPHR is not known, use the default NPHR value:  ","Fuel Type","Default NPHR",null,null,"Bituminous",null,0,2.35,11814]
[null,null,"Coal","10 MMBtu/MW",null,null,"Sub-Bituminous",null,1,0.2,{"$f":"C12","v":7560}]
[null,null,"Fuel Oil","11 MMBtu/MW",null,null,"Lignite",null,0,0.91,6534]
[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,"Plant Elevation  ",450,"Feet above sea level"]
[null,null,null,null,null,"For coal-fired boilers, you may use either Method 1 or Method 2 to calculate the catalyst replacement cost.  The equations for both methods are shown on rows 85 and 86 on the Cost Estimate tab. Please select your preferred method: "]
[null,null,null,null,null,{"$f":"IF(AND(P17=2,P26=3), \"* You must select either method 1 or method 2 for a coal-fired boiler!\", \" \")","v":" "},null,null,null,null,null,null,null,null,null,1]
[]
["Enter the following design parameters for the proposed SCR:"]
[]
[]
[null,"Number of days the SCR operates (tSCR)",365,"days",null,null,null,"Number of SCR reactor chambers (nscr)",null,null,1]
[null,"Number of days the boiler operates (tplant)",365,"days",null,null,null,"Number of catalyst layers (Rlayer)",null,null,3]
[null,"Inlet NOx Emissions (NOxin) to SCR",0.57999999999999996,"lb/MMBtu",null,null,null,"Number of empty catalyst layers (Rempty)",null,null,1]
[null,"NOx Removal Efficiency (EF) provided by vendor",90,"percent",null,null,null,"Ammonia Slip (Slip) provided by vendor",null,null,10,"ppm"]
[null,"Stoichiometric Ratio Factor (SRF)",0.52500000000000002,null,null,null,null,"Volume of the catalyst layers (Volcatalyst)                         (Enter \"UNK\" if value is not known) ",null,null,"UNK","Cubic feet"]
[null,{"$f":"IF(OR(C35=1.05, C35=0.525), \"*The SRF value of \"&C35&\" is a default value. User should enter actual value, if known.\", \" \")","v":"*The SRF value of 0.525 is a default value. User should enter actual value, if known."},null,null,null,null,null,"Flue gas flow rate (Qfluegas)                                              (Enter \"UNK\" if value is not known) ",null,null,240000,"acfm"]
[null,null,null,null,null,null,null,null,null,null," "]
[null,"Estimated operating life of the catalyst (Hcatalyst)",24000,{"$f":"\"hours\"&(IF(C38=26000,\"*\", \" \"))","v":"hours "},{"$f":"IF(C38=26000, \"* 24,000 hours is a default value for the operating life of a catalyst. User should enter actual value, if known.\", \" \")","v":" "},null,null,null,null,null," "]
[null,"Estimated SCR equipment life",20,"Years*",null,null,null,"Gas temperature at the SCR inlet (T)",null,null,300,"oF",null,null,{"$f":"IF(K39=650,\"*The SCR inlet temperature of 650 deg.F is a default value. Enter actual temperature, if known.\", \" \")","v":" "}]
[null,{"$f":"IF(P8=2,\"* For utility boilers, the typical equipment life of an SCR is at least 30 years.\",(IF(P8=3,\"* For industrial boilers, the typical equipment life is between 20 and 25 years.\", \" \")))","v":"* For industrial boilers, the typical equipment life is between 20 and 25 years."},null,null,null,null,null,"Base case fuel gas volumetric flow rate factor (Qfuel)",null,null,516,"ft3/min-MMBtu/hour"]
[null,"Concentration of reagent as stored (Cstored)",50,{"$f":"\"percent\"&(IF(OR(C41=29, C41=50),\"*\", \" \"))","v":"percent*"},{"$f":"IF(AND(C41=29,C42=56), \"*The reagent concentration of 29% and density of 56 lbs/cft are default values for ammonia reagent. User should enter actual values for reagent, if different from the default values provided.\", (IF(AND(C41=50,C42=71), \"*The reagent concentration of 50% and density of 71 lbs/cft are default values for urea reagent. User should enter actual values for reagent, if different from the default values provided.\", \" \")))","v":"*The reagent concentration of 50% and density of 71 lbs/cft are default values for urea reagent. User should enter actual values for reagent, if different from the default values provided."}]
[null,"Density of reagent as stored (ρstored)",71,{"$f":"\"lb/cubic feet\"&(IF(OR(C42=56,C42=71),\"*\",\" \"))","v":"lb/cubic feet*"}]
[null,"Number of days reagent is stored (tstorage)",30,"days",null,null,null,null,null,"Densities of typical SCR reagents: "]
[null,null,null,null,null,null,null,null,null,"50% urea solution",null,71,"lbs/ft3"]
[null,null,null,null,null,null,null,null,null,"29.4% aqueous NH3",null,56,"lbs/ft3",null,null,null,"Ammonia"]
[null,null,null,null,null,null,null,null,null,"19% aqueous NH3",null,58,"lbs/ft3",null,null,2,"Urea"]
[null,"Select the reagent used"]
[]
[]
["Enter the cost data for the proposed SCR:"]
[]
[null,"Desired dollar-year",2016]
[null,{"$f":"\"CEPCI for \" & C52","v":"CEPCI for 2016"},536.4,{"$f":"IF(C52=2014,\" \",\"Enter the CEPCI value for \"&C52)","v":"Enter the CEPCI value for 2016"},null,584.6,"2012 CEPCI",null,"CEPCI = Chemical Engineering Plant Cost Index"]
[null,"Annual Interest Rate (i)",5,"Percent"]
[null,"Reagent (Costreag)",1.62,{"$f":"\"$/gallon for a \"&C41&\" percent solution of \"&(IF(P46=2,\"urea\",(IF(P46=1,\"ammonia\", \" \"))))&(IF(C55=200,\"*\",\" \"))","v":"$/gallon for a 50 percent solution of urea "},null,null,null,null,{"$f":"IF(C55=3.56, \"* $3.56/gallon is a default value for the reagent cost. User should enter actual value, if known.\", \" \")","v":" "}]
[null,"Electricity (Costelect)",0.21,{"$f":"\"$/kWh\"&(IF(OR(C56=0.071, C56=0.039), \"*\",\" \"))","v":"$/kWh "},null,null,null,null,{"$f":"IF(C56=0.039,\"* $0.0390/kWh is a default value for electicity cost. User should enter actual value, if known.\",(IF(C56=0.071,\"* $0.071/kWh is a default value for electrity cost. User should enter actual value, if known.\",\" \")))","v":" "}]
[null,"Catalyst cost (CC replace)",160,{"$f":"\"$/cubic foot (includes removal and disposal/regeneration of existing catalyst and installation of new catalyst\"&(IF(C57=160,\"*\",\" \"))","v":"$/cubic foot (includes removal and disposal/regeneration of existing catalyst and installation of new catalyst*"},null,null,null,null,{"$f":"IF(C57=160, \"*  $160/cf is a default value for the catalyst cost. User should enter actual value, if known.\", \" \")","v":"*  $160/cf is a default value for the catalyst cost. User should enter actual value, if known."}]
[null,"Operator Labor Rate",60,{"$f":"\"$/hour (including benefits)\"&(IF(C58=60,\"*\",\" \"))","v":"$/hour (including benefits)*"},null,null,null,null,{"$f":"IF(C58=60, \"*  $60/hour is a default value for the operator labor rate. User should enter actual value, if known.\", \" \")","v":"*  $60/hour is a default value for the operator labor rate. User should enter actual value, if known."}]
[null,"Operator Hours/Day",4,{"$f":"\"hours/day\"&(IF(C59=4,\"*\",\" \"))","v":"hours/day*"},null,null,null,null,{"$f":"IF(C59=4, \"*  4 hours/day is a default value for the operator labor. User should enter actual value, if known.\", \" \")","v":"*  4 hours/day is a default value for the operator labor. User should enter actual value, 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) =",5.0000000000000001E-3,{"$f":"IF(C64>0.005,\"*MCF is greater than the IPM default value of 0.005. User must document why the value entered is appropriate.\",(IF(C64<0.005,\"*MCF is less than the IPM default value of 0.005. User must document why the value entered is appropriate.\",\" \")))","v":" "}]
[null,"Administrative Charges Factor (ACF) =",0.03,{"$f":"IF(C65>0.03,\"*ACF is greater than the IPM default value of 0.03. User must document why the value entered is appropriate.\",(IF(C65<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 ($/gallon)",1.62,"Based on the average of vendor quotes from 2011 - 2013.",null,null,null,null,null," ",null,null,null,null,"Check with reagent vendors for current prices. "]
[null,"Electricity Cost ($/kWh)",3.9E-2,"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.",null,null,null,null,null,"$0.210/kWh GVEA rates. http://www.gvea.com/rates/rates",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,"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," 0.20 percent (Typical Gross As Received). Coal data sheet at http://www.usibelli.com/Coal_data.php ",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)",8730,"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,"7,560 Btu/lb (Typical Gross As Received). Coal data sheet at http://www.usibelli.com/Coal_data.php ",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,"Catalyst Cost ($/cubic foot)",160,"Cichanowicz, J.E. \"Current Capital Cost and Cost-Effectiveness of Power Plant Emissions Control Technologies\", July 2013. ",null,null,null,null,null,null,null,null,null,null,"Check with vendors for current prices. "]

{"sheet":"SCR Design Parameters","index":2,"n_rows":65,"n_cols":12,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,0,2,5],[0,0,0,5],[50,3,50,5],[51,3,51,5],[52,3,52,5],[53,3,53,5],[18,4,18,5],[19,4,19,5],[24,0,24,3],[20,4,23,5],[46,2,46,3],[49,3,49,5]]}
["SCR Design Parameters"]
[]
["The following design parameters for the SCR 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'!C17),'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,((('SCR Design Parameters'!C6/'Data Inputs'!C12)*1000000)*8760),(IF('Data Inputs'!P8=2,('Data Inputs'!C10*8760),\" \")))","v":266507936.50793651},{"$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":"660000000/6","v":110000000},{"$f":"'Data Inputs'!D14","v":"lbs/year"}]
["Heat Rate Factor (HRF) =","NPHR/10 =",{"$f":"'Data Inputs'!C17/10","v":1}]
["Total System Capacity Factor (CFtotal) =",{"$f":"IF('Data Inputs'!P8=2, \"(Boutput/Bmw)*(tscr/tplant) =\", (IF('Data Inputs'!P8=3, \"(Mactual/Mfuel) x (tscr/tplant)  =\", \" \")))","v":"(Mactual/Mfuel) x (tscr/tplant)  ="},{"$f":"(C8/C7)*('Data Inputs'!C31/'Data Inputs'!C32)","v":0.41274568195354377},"fraction"]
["Total operating time for the SCR (top) =","CFtotal x 8760 =",{"$f":"C10*8760","v":3615.6521739130435},"hours"]
["NOx Removal Efficiency (EF) =","(NOxin- NOxout)/NOxin =",{"$f":"'Data Inputs'!C34","v":90},"percent"]
["NOx removed per hour =","NOxin x EF x QB  =",{"$f":"(C12/100)*'Data Inputs'!C33*'SCR Design Parameters'!C6","v":120.06},"lb/hour"]
["Total NOx removed per year =","(NOxin x EF x QB x top)/2000 =",{"$f":"C13*C11/2000","v":217.04760000000002},"tons/year"]
["NOx removal factor (NRF) = ","EF/80",{"$f":"C12/80","v":1.125}]
["Volumetric flue gas flow rate (qflue gas) =","Qfuel x QB x (460 + T)/(460 + 700)nscr",{"$f":"IF(OR('Data Inputs'!K36=\"UNK\", 'Data Inputs'!K36=\" \"), ('Data Inputs'!K40*'SCR Design Parameters'!C6*(460+'Data Inputs'!K39))/((460+700)*'Data Inputs'!K31), 'Data Inputs'!K36)","v":240000},"acfm"]
["Space velocity (Vspace) =","qflue gas/Volcatalyst ",{"$f":"C16/C34","v":71.208928932787529},"/hour"]
["Residence Time ","1/Vspace",{"$f":"1/C17","v":1.4043182715806285E-2},"hour"]
["Coal Factor (CoalF) =","1 for oil and natural gas; 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,J19)))))), 1)","v":1.05},null,null,null,null,null,null,{"$f":"((1*'Data Inputs'!I19)+(1.05*'Data Inputs'!I20)+(1.07*'Data Inputs'!I21))/SUM('Data Inputs'!I19:I21)","v":1.05},"CoalF for blended fuel"]
["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 =",null,null,{"$f":"IF('[1]Data Inputs'!C24<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'!I32=0,\"Atmospheric pressure at sea level (P) =\",\"Atmospheric pressure at \"&'Data Inputs'!I32&\" feet above sea level (P) =\")","v":"Atmospheric pressure at sea level (P) ="},"2116x[(59-(0.00356xh)+459.7)/518.6]5.256 x (1/144)* =",{"$f":"(2116)*(((59-(0.00356*'Data Inputs'!C24)+459.7)/518.6)^5.256)*(1/144)","v":14.472129091012603},"psia"]
[null,{"$f":"IF('Data Inputs'!S8=2,\"New Construction\",(IF('Data Inputs'!S8=3,\"SNCR Retrofit\",\" \")))","v":"SNCR Retrofit"},{"$f":"IF('Data Inputs'!S8=2,1,(IF('Data Inputs'!S8=3,1.19,\" \")))","v":1.19}]
["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":"'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. "]
[]
[]
[]
[]
["Catalyst Data:"]
[]
["Parameter","Equation","Calculated Value","Units",null,null,null,null,null,{"$f":"(0.2869+(1.058*C12/100))","v":1.2390999999999999},"EF adj"]
["Future worth factor (FWF) =","(interest rate)(1/((1+ interest rate)Y -1) , where Y = Hcatalyts/(tSCR x 24 hours) rounded to the nearest integer",{"$f":"('Data Inputs'!C54/100)/(((1+('Data Inputs'!C54/100))^L33)-1)","v":0.3172085646312448},"Fraction",null,null,null,null,null,{"$f":"(1.2835-(0.0567*'Data Inputs'!K34))","v":0.71650000000000014},"Slipadj",{"$f":"ROUND('Data Inputs'!C38/('Data Inputs'!C31*24),0)","v":3}]
["Catalyst volume (Volcatalyst) =","2.81 x QB x EF adj x Slipadj x Noxadj x Sadj x (Tadj/Nscr)",{"$f":"IF(OR('Data Inputs'!K35=\"UNK\",'Data Inputs'!K35=\" \"),(2.81*C6*'SCR Design Parameters'!J32*'SCR Design Parameters'!J33*'SCR Design Parameters'!J34*'SCR Design Parameters'!J35*('SCR Design Parameters'!J37/'Data Inputs'!K31)), 'Data Inputs'!K35)","v":3370.3638517935087},"Cubic feet",null,null,null,null,null,{"$f":"(0.8524+(0.3208*'Data Inputs'!C33))","v":1.0384640000000001},"Noxadj"]
["Cross sectional area of the catalyst (Acatalyst) =","qflue gas /(16ft/sec x 60 sec/min)",{"$f":"C16/(16*60)","v":250},"ft2",null,null,null,null,null,{"$f":"IF('Data Inputs'!P17=2, (0.9636+(0.0455*'Data Inputs'!I12)), 0.9636)","v":0.97270000000000001},"Sadj"]
["Height of each catalyst layer (Hlayer) = ","(Volcatalyst/(Rlayer x Acatalyst)) + 1",{"$f":"(C34/('Data Inputs'!K32*'SCR Design Parameters'!C35))+1","v":5.4938184690580121},"feet"]
[null,null,null,null,null,null,null,null,null,{"$f":"(15.16-(0.03937*'Data Inputs'!K39)+(0.0000274*('Data Inputs'!K39)^2))","v":5.8149999999999995},"Tadj"]
["SCR Reactor Data:"]
[]
["Parameter","Equation","Calculated Value","Units"]
["Cross sectional area of the reactor (ASCR) = ","1.15 x Acatalyst",{"$f":"1.15*C35","v":287.5},"ft2"]
["Reactor length and width dimentions for a square reactor = ","(ASCR)0.5",{"$f":"(C41)^0.5","v":16.955824957813171},"feet"]
["Reactor height =","(Rlayer  + Rempty) x (7ft + hlayer) + 9ft",{"$f":"('Data Inputs'!K32+'Data Inputs'!K33)*(7+C36)+9","v":58.975273876232052},"feet"]
[]
[]
["Reagent Data:"]
["Type of reagent used",{"$f":"IF('Data Inputs'!P46=1,\"Ammonia\",\"Urea\")","v":"Urea"},"Molecular Weight of Reagent (MW) = ",null,{"$f":"IF('Data Inputs'!P46=2, 60.06, 17.03)","v":60.06},"g/mole",null,null,null,{"$f":"IF('Data Inputs'!P46=1,1,2)","v":2},{"$f":"IF('Data Inputs'!P47=1,71,56)","v":56}]
[null,null,null,"Density  =",{"$f":"'Data Inputs'!C42","v":71},"lb/ft3"]
[]
["Parameter","Equation","Calculated Value","Units"]
["Reagent consumption rate (mreagent) = ","(NOxin x QB x EF x SFR x MWR)/MWNOx =",{"$f":"('Data Inputs'!C33*'SCR Design Parameters'!C6*('SCR Design Parameters'!C12/100)*'Data Inputs'!C35*'SCR Design Parameters'!E47)/(46.01)","v":82.279328189524009},"lb/hour"]
["Reagent Usage Rate (msol) =","mreagent/Csol =",{"$f":"C51/('Data Inputs'!C41/100)","v":164.55865637904802},"lb/hour"]
[null,"(msol x 7.4805)/Reagent Density",{"$f":"(C52*7.4805/E48)","v":17.33776097244322},"gal/hour"]
["Estimated tank volume for reagent storage =","(msol x 7.4805 x tstorage x 24)/Reagent Density =",{"$f":"C53*'Data Inputs'!C43*24","v":12483.187900159119},{"$f":"\"gallons (storage needed to store a \"& 'Data Inputs'!C43 &\" 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'!C54/100)*((1+'Data Inputs'!C54/100)^'Data Inputs'!C39))/(((1+'Data Inputs'!C54/100)^'Data Inputs'!C39)-1)","v":8.0242587190691314E-2}]
[null,"Where n = Equipment Life and i= Interest Rate"]
[]
["Other parameters","Equation","Calculated Value","Units"]
["Electricity Usage:"]
["Electricity Consumption (P) = ","A x 1,000 x 0.0056 x (CoalF x HRF)0.43 =",{"$f":"('Data Inputs'!C10*1000*0.0056*('SCR Design Parameters'!C19*'SCR Design Parameters'!C9)^0.43)*(IF('Data Inputs'!P8=3, 0.1, 1))","v":131.53073943512041},"kW"]
[null,{"$f":"IF('Data Inputs'!P8=2, \"where A = Bmw for utility boilers\", \"where A = (0.1 x QB) for industrial boilers.\")","v":"where A = (0.1 x QB) for industrial boilers."}]

{"sheet":"Cost Estimate","index":3,"n_rows":104,"n_cols":10,"rows_kept":104,"cut":false,"hidden":false,"merged":[[82,0,82,1],[68,0,68,4],[6,0,6,4],[101,3,101,4],[55,0,55,3],[66,0,66,4],[90,0,90,4],[97,0,97,4],[99,0,99,4],[57,0,57,4],[58,0,58,4],[59,0,59,4],[75,0,75,4],[76,0,76,4],[89,0,89,4],[69,0,69,4],[0,0,0,4],[2,0,2,4],[21,0,21,4],[4,0,4,4],[7,0,7,4],[8,0,8,4],[13,0,13,4],[15,0,15,4],[16,0,16,4],[14,0,14,4],[20,0,20,4],[12,0,12,4],[5,0,5,4],[42,0,42,4],[61,0,61,4],[51,0,51,4],[33,0,33,4],[49,0,49,4],[48,0,48,4],[50,0,50,4],[34,0,34,4],[43,0,43,4],[44,0,44,4],[52,0,52,4],[35,0,35,4],[36,0,36,4],[29,0,29,3],[10,0,10,4],[32,0,32,4],[40,0,40,4],[41,0,41,4],[22,0,22,4]]}
["Cost Estimate"]
[]
["Total Capital Investment (TCI)",null,null,null,null,null,{"$f":"IF('Data Inputs'!C24<500, 1,'SCR Design Parameters'!C21)","v":1},"ELEVF"]
[]
["TCI for Oil and Natural Gas Boilers"]
["For Oil and Natural Gas-Fired Utility Boilers between 25MW and 500 MW:",null,null,null,null,null,"New ","Retrofit"]
["TCI = 80,000 x (200/BMW )0.35 x BMW x ELEVF x RF",null,null,null,null,null,{"$f":"IF(AND('Data Inputs'!S8=2,'Data Inputs'!P8=2,'Data Inputs'!P17>2,'Data Inputs'!C10<500.1),(80000*((200/'Data Inputs'!C10)^0.35)*'Data Inputs'!C10*G3*0.8), 0)","v":0},{"$f":"IF(AND('Data Inputs'!S8=3,'Data Inputs'!P8=2,'Data Inputs'!P17>2,'Data Inputs'!C10<500.1),(80000*((200/'Data Inputs'!C10)^0.35)*'Data Inputs'!C10*G3*'Data Inputs'!D7), 0)","v":0}]
["For Oil and Natural Gas-Fired Utility Boilers >500 MW:"]
["TCI = 60,670 x BMW x ELEVF x RF",null,null,null,null,null,{"$f":"IF(AND('Data Inputs'!S8=2,'Data Inputs'!P8=2, 'Data Inputs'!P17>2, 'Data Inputs'!C10>500), (60670*'Data Inputs'!C10*G3*0.8), 0)","v":0},{"$f":"IF(AND('Data Inputs'!S8=3,'Data Inputs'!P8=2, 'Data Inputs'!P17>2, 'Data Inputs'!C10>500), (60670*'Data Inputs'!C10*G3*'Data Inputs'!D7), 0)","v":0}]
["For Oil-Fired Industrial Boilers between 275 and 5,500 MMBTU/hour :"]
["TCI = 7,270 x (2,200/QB )0.35 x QB x ELEVF x RF",null,null,null,null,null,{"$f":"IF(AND('Data Inputs'!S8=2,'Data Inputs'!P8=3, 'Data Inputs'!P17=3, 'Data Inputs'!C10<5500.1),(7270*((2200/'Data Inputs'!C10)^0.35)*'Data Inputs'!C10*G3*0.8), 0)","v":0},{"$f":"IF(AND('Data Inputs'!S8=3,'Data Inputs'!P8=3, 'Data Inputs'!P17=3, 'Data Inputs'!C10<5500.1),(7270*((2200/'Data Inputs'!C10)^0.35)*'Data Inputs'!C10*G3*'Data Inputs'!D7), 0)","v":0}]
["For Natural Gas-Fired Industrial Boilers between 205 and 4,100 MMBTU/hour :",null,null,null,null,null,null,null,null," "]
["TCI = 9,760 x (1,640/QB )0.35 x QB x ELEVF x RF",null,null,null,null,null,{"$f":"IF(AND('Data Inputs'!S8=2,'Data Inputs'!P8=3, 'Data Inputs'!P17=4, 'Data Inputs'!C10<4100.1),(9760*((1640/'Data Inputs'!C10)^0.35)*'Data Inputs'!C10*G3*0.8), 0)","v":0},{"$f":"IF(AND('Data Inputs'!S8=3,'Data Inputs'!P8=3, 'Data Inputs'!P17=4, 'Data Inputs'!C10<4100.1),(9760*((1640/'Data Inputs'!C10)^0.35)*'Data Inputs'!C10*G3*'Data Inputs'!D7), 0)","v":0}]
["For Oil-Fired Industrial Boilers >5,500 MMBtu/hour: "]
["TCI = 5,275 x QB x ELEVF x RF",null,null,null,null,null,{"$f":"IF(AND('Data Inputs'!S8=2,'Data Inputs'!P8=3, 'Data Inputs'!P17=3, 'Data Inputs'!C10>5500),(5275*'Data Inputs'!C10*G3*0.8), 0)","v":0},{"$f":"IF(AND('Data Inputs'!S8=3,'Data Inputs'!P8=3, 'Data Inputs'!P17=3, 'Data Inputs'!C10>5500),(5275*'Data Inputs'!C10*G3*'Data Inputs'!D7), 0)","v":0}]
["For Natural Gas-Fired Industrial Boilers >4,100 MMBtu/hour:"]
["TCI = 7,082 x QB x ELEVF x RF",null,null,null,null,null,{"$f":"IF(AND('Data Inputs'!S8=2,'Data Inputs'!P8=3, 'Data Inputs'!P17=4, 'Data Inputs'!C10>4100), (7082*'Data Inputs'!C10*G3*0.8), 0)","v":0},{"$f":"IF(AND('Data Inputs'!S8=3,'Data Inputs'!P8=3, 'Data Inputs'!P17=4, 'Data Inputs'!C10>4100), (7082*'Data Inputs'!C10*G3*'Data Inputs'!D7), 0)","v":0}]
[]
["Total Capital Investment (TCI) =",{"$f":"(G19+H19)*('Data Inputs'!C53/'Data Inputs'!F53)","v":0},null,{"$f":"\"in \"&'Data Inputs'!$C$52 & \" dollars\"","v":"in 2016 dollars"},null,null,{"$f":"SUM(G7:G17)","v":0},{"$f":"SUM(H7:H17)","v":0}]
[]
["TCI for Coal-Fired Boilers"]
["For Coal-Fired Boilers:"]
["TCI = 1.3 x (SCRcost + RPC + APHC + BPC)"]
[]
["Capital costs for the SCR (SCRcost) =",{"$f":"D39","v":7121955.4080239451},null,{"$f":"\"in \"&'Data Inputs'!$C$52 & \" dollars\"","v":"in 2016 dollars"}]
["Reagent Preparation Cost (RPC) =",{"$f":"D47","v":2232373.6209674566},null,{"$f":"\"in \"&'Data Inputs'!$C$52 & \" dollars\"","v":"in 2016 dollars"}]
["Air Pre-Heater Costs (APHC)* = ",{"$f":"D55","v":0},null,{"$f":"\"in \"&'Data Inputs'!$C$52 & \" dollars\"","v":"in 2016 dollars"}]
["Balance of Plant Costs (BPC) =",{"$f":"D64","v":2411594.2829420199},null,{"$f":"\"in \"&'Data Inputs'!$C$52 & \" dollars\"","v":"in 2016 dollars"}]
["Total Capital Investment (TCI) =",{"$f":"1.3*(SUM(B25:B28))","v":15295700.305513447},null,{"$f":"\"in \"&'Data Inputs'!$C$52 & \" 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 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 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 3lb/MMBtu of sulfur dioxide."}]
[]
[]
["SCR Capital Costs (SCRcost)"]
["For Coal-Fired Utility Boilers >25  MW:"]
["SCRcost = 270,000 x (NRF)0.2 x (BMW x HRF x CoalF)0.92 x ELEVF x RF",null,null,null,null,null,{"$f":"IF(AND('Data Inputs'!S8=2,'Data Inputs'!P8=2, 'Data Inputs'!P17=2),(270000*(('SCR Design Parameters'!C15)^0.2)*(('Data Inputs'!C10*'SCR Design Parameters'!C9*'SCR Design Parameters'!C19)^0.92)*'Cost Estimate'!G3*0.8), 0)","v":0},{"$f":"IF(AND('Data Inputs'!S8=3,'Data Inputs'!P8=2, 'Data Inputs'!P17=2),(270000*(('SCR Design Parameters'!C15)^0.2)*(('Data Inputs'!C10*'SCR Design Parameters'!C9*'SCR Design Parameters'!C19)^0.92)*'Cost Estimate'!G3*'SCR Design Parameters'!C24), 0)","v":0}]
["For Coal-Fired Industrial Boilers >250 MMBtu/hour:"]
["SCRcost = 270,000 x (NRF)0.2 x (0.1 x QB x CoalF)0.92 x ELEVF x RF",null,null,null,null,null,{"$f":"IF(AND('Data Inputs'!S8=2,'Data Inputs'!P8=3, 'Data Inputs'!P17=2),(270000*(('SCR Design Parameters'!C15)^0.2)*((0.1*'Data Inputs'!C10*'SCR Design Parameters'!C19)^0.92)*'Cost Estimate'!G3*0.8), 0)","v":0},{"$f":"IF(AND('Data Inputs'!S8=3,'Data Inputs'!P8=3, 'Data Inputs'!P17=2),(270000*(('SCR Design Parameters'!C15)^0.2)*((0.1*'Data Inputs'!C10*'SCR Design Parameters'!C19)^0.92)*'Cost Estimate'!G3*'SCR Design Parameters'!C24), 0)","v":7761922.318290079}]
[null,null,null,null,null,null,{"$f":"SUM(G35:G37)","v":0},{"$f":"SUM(H35:H37)","v":7761922.318290079}]
["SCR Capital Costs (SCRcost) = ",null,null,{"$f":"(G38+H38)*('Data Inputs'!C53/'Data Inputs'!F53)","v":7121955.4080239451},{"$f":"\"in \"&'Data Inputs'!$C$52 & \" dollars\"","v":"in 2016 dollars"}]
[]
["Reagent Preparation Costs (RPC)"]
["For Coal-Fired Utility Boilers >25  MW:"]
["RPC = 490,000 x (NOxin x BMW x NPHR x EF)0.25 x RF",null,null,null,null,null,{"$f":"IF(AND('Data Inputs'!S8=2,'Data Inputs'!P8=2,'Data Inputs'!P17=2),(490000*(('Data Inputs'!C33*'Data Inputs'!C10*'Data Inputs'!C17*('SCR Design Parameters'!C12/100))^0.25)*0.8), 0)","v":0},{"$f":"IF(AND('Data Inputs'!S8=3,'Data Inputs'!P8=2,'Data Inputs'!P17=2),(490000*(('Data Inputs'!C33*'Data Inputs'!C10*'Data Inputs'!C17*('SCR Design Parameters'!C12/100))^0.25)*'SCR Design Parameters'!C24), 0)","v":0}]
["For Coal-Fired Industrial Boilers >250 MMBtu/hour:"]
["RPC = 490,000 x (NOxin x QB x EF)0.25 x RF",null,null,null,null,null,{"$f":"IF(AND('Data Inputs'!S8=2,'Data Inputs'!P8=3,'Data Inputs'!P17=2),(490000*(('Data Inputs'!C33*'Data Inputs'!C10*('SCR Design Parameters'!C12/100))^0.25)*0.8), 0)","v":0},{"$f":"IF(AND('Data Inputs'!S8=3,'Data Inputs'!P8=3,'Data Inputs'!P17=2),(490000*(('Data Inputs'!C33*'Data Inputs'!C10*('SCR Design Parameters'!C12/100))^0.25)*'SCR Design Parameters'!C24), 0)","v":2432970.952307187}]
[]
["Reagent Preparation Costs (RPC) = ",null,null,{"$f":"(G47+H47)*('Data Inputs'!C53/'Data Inputs'!F53)","v":2232373.6209674566},{"$f":"\"in \"&'Data Inputs'!$C$52 & \" dollars\"","v":"in 2016 dollars"},null,{"$f":"SUM(G43:G45)","v":0},{"$f":"SUM(H43:H45)","v":2432970.952307187}]
[]
["Air Pre-Heater Costs (APHC)*"]
["For Coal-Fired Utility Boilers >25MW:"]
[" APHC = 69,000 x (BMW x HRF x CoalF)0.78 x AHF x RF",null,null,null,null,null,{"$f":"IF(AND('Data Inputs'!S8=2,'Data Inputs'!P8=2,'Data Inputs'!P17=2),(69000*('Data Inputs'!C10*'SCR Design Parameters'!C9*'SCR Design Parameters'!C19)^0.78)*(IF('Data Inputs'!V11=3,1,0))*0.8,0)","v":0},{"$f":"IF(AND('Data Inputs'!S8=3, 'Data Inputs'!P8=2,'Data Inputs'!P17=2),(69000*('Data Inputs'!C10*'SCR Design Parameters'!C9*'SCR Design Parameters'!C19)^0.78)*(IF('Data Inputs'!V11=3,1,0))*'SCR Design Parameters'!C24, 0)","v":0}]
["For Coal-Fired Industrial Boilers >250 MMBtu/hour:"]
[" APHC = 69,000 x (0.1 x QB x CoalF)0.78 x AHF x RF",null,null,null,null,null,{"$f":"IF(AND('Data Inputs'!S8=2,'Data Inputs'!P8=3,'Data Inputs'!P17=2), (69000*((0.1*'Data Inputs'!C10*'SCR Design Parameters'!C19)^0.78)*(IF('Data Inputs'!V11=3, 1, 0))*0.8), 0)","v":0},{"$f":"IF(AND('Data Inputs'!S8=3,'Data Inputs'!P8=3,'Data Inputs'!P17=2), (69000*((0.1*'Data Inputs'!C10*'SCR Design Parameters'!C19)^0.78)*(IF('Data Inputs'!V11=3, 1, 0))*'SCR Design Parameters'!C24), 0)","v":0}]
[]
["Air Pre-Heater Costs (APHcost) = ",null,null,{"$f":"(G55+H55)*('Data Inputs'!C53/'Data Inputs'!F53)","v":0},{"$f":"\"in \"&'Data Inputs'!$C$52 & \" dollars\"","v":"in 2016 dollars"},null,{"$f":"SUM(G51:G53)","v":0},{"$f":"SUM(H51:H53)","v":0}]
[{"$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 (BPC)"]
["For Coal-Fired Utility Boilers >25MW:"]
["BPC = 460,000 x (BMW x HRFx CoalF)0.42 x ELEVF x RF",null,null,null,null,null,{"$f":"IF(AND('Data Inputs'!S8=2,'Data Inputs'!P8=2,'Data Inputs'!P17=2),(460000*(('Data Inputs'!C10*'SCR Design Parameters'!C9*'SCR Design Parameters'!C19)^0.42)*G3*0.8), 0)","v":0},{"$f":"IF(AND('Data Inputs'!S8=3,'Data Inputs'!P8=2,'Data Inputs'!P17=2),(460000*(('Data Inputs'!C10*'SCR Design Parameters'!C9*'SCR Design Parameters'!C19)^0.42)*G3*'SCR Design Parameters'!C24), 0)","v":0}]
["For Coal-Fired Industrial Boilers >250 MMBtu/hour:"]
["BPC = 460,000 x (0.1 x QB x CoalF)0.42 ELEVF x RF",null,null,null,null,null,{"$f":"IF(AND('Data Inputs'!S8=2,'Data Inputs'!P8=3,'Data Inputs'!P17=2),(460000*((0.1*'Data Inputs'!C10*'SCR Design Parameters'!C19)^0.42)*G3*0.8), 0)","v":0},{"$f":"IF(AND('Data Inputs'!S8=3,'Data Inputs'!P8=3,'Data Inputs'!P17=2),(460000*((0.1*'Data Inputs'!C10*'SCR Design Parameters'!C19)^0.42)*G3*'SCR Design Parameters'!C24), 0)","v":2628296.0809245058}]
[]
["Balance of Plant Costs (BOPcost) =",null,null,{"$f":"(G64+H64)*('Data Inputs'!C53/'Data Inputs'!F53)","v":2411594.2829420199},{"$f":"\"in \"&'Data Inputs'!$C$52 & \" dollars\"","v":"in 2016 dollars"},null,{"$f":"SUM(G60:G62)","v":0},{"$f":"SUM(H60:H62)","v":2628296.0809245058}]
[]
[]
["Annual Costs"]
[]
["Total Annual Cost (TAC)"]
["TAC = Direct Annual Costs + Indirect Annual Costs"]
[]
["Direct Annual Costs (DAC) =",null,{"$f":"D88","v":334920.631917939},{"$f":"\"in \"&'Data Inputs'!$C$52 & \" dollars\"","v":"in 2016 dollars"}]
["Indirect Annual Costs (IDAC) =",null,{"$f":"D95","v":1230912.3074261774},{"$f":"\"in \"&'Data Inputs'!$C$52 & \" dollars\"","v":"in 2016 dollars"}]
["Total annual costs (TAC) = DAC + IDAC",null,{"$f":"C72+C73","v":1565832.9393441165},{"$f":"\"in \"&'Data Inputs'!$C$52 & \" dollars\"","v":"in 2016 dollars"}]
[]
["Direct Annual Costs (DAC)"]
["DAC = (Annual Maintenance Cost) + (Annual Reagent Cost) + (Annual Electricity Cost) + (Annual Catalyst Cost)"]
[]
["Annual Maintenance Cost =",{"$f":"'Data Inputs'!C64&\" x TCI =\"","v":"0.005 x TCI ="},null,{"$f":"IF('Data Inputs'!P17>2, (B19*'Data Inputs'!C64), (IF('Data Inputs'!P17=2, (B29*'Data Inputs'!C64), 0)))","v":76478.501527567234},{"$f":"\"in \"&'Data Inputs'!$C$52 & \" dollars\"","v":"in 2016 dollars"}]
["Annual Reagent Cost =","qsol x Costreag x top =",null,{"$f":"'Data Inputs'!C55*'SCR Design Parameters'!C53*'SCR Design Parameters'!C11","v":101553.44730429447},{"$f":"\"in \"&'Data Inputs'!$C$52 & \" dollars\"","v":"in 2016 dollars"}]
["Annual Electricity Cost =","P x Costelect x top = ",null,{"$f":"'SCR Design Parameters'!C64*'Data Inputs'!C56*'SCR Design Parameters'!C11","v":99869.574834746469},{"$f":"\"in \"&'Data Inputs'!$C$52 & \" dollars\"","v":"in 2016 dollars"}]
["Annual Catalyst Replacement Cost =",null,null,{"$f":"IF(H83= 1, H85,H88)","v":57019.108251330799},{"$f":"\"in \"&'Data Inputs'!$C$52 & \" dollars\"","v":"in 2016 dollars"}]
[null,null,null,null,null,null,null,{"$f":"IF('Data Inputs'!P17=2,'Data Inputs'!P26,1)","v":1}]
[{"$f":"IF(OR('Data Inputs'!P17=2, 'Data Inputs'!P17=1), \"For coal-fired boilers, the following methods may be used to calcuate the catalyst replacement cost.\", \" \")","v":"For coal-fired boilers, the following methods may be used to calcuate the catalyst replacement cost."}]
[{"$f":"IF(OR('Data Inputs'!P17=1,'Data Inputs'!P17=2), \"Method 1 (for all fuel types):\", \" \")","v":"Method 1 (for all fuel types):"},"nscr x Volcat x (CCreplace/Rlayer) x FWF",null,{"$f":"IF('Data Inputs'!P17=2, \"* Calculation Method \"&H83&\" selected.\", \" \")","v":"* Calculation Method 1 selected."},null,null,"Method 1",{"$f":"'Data Inputs'!K31*'SCR Design Parameters'!C34*('Data Inputs'!C57/'Data Inputs'!K32)*'SCR Design Parameters'!C33","v":57019.108251330799}]
[{"$f":"IF(OR('Data Inputs'!P17=1, 'Data Inputs'!P17=2), \"Method 2 (for coal-fired utility boilers):\", \" \")","v":"Method 2 (for coal-fired utility boilers):"},"BMW x 0.4 x (CoalF)2.9 x (NRF)0.71 x (CCreplace) x 35.3      ",null,null,null,null,"Method 2 (utility)",{"$f":"('Data Inputs'!C10)*(('SCR Design Parameters'!C19)^2.9)*(('SCR Design Parameters'!C15)^0.71)*('Data Inputs'!C57)*(35.3)","v":1627008.3519045771}]
[{"$f":"IF(OR('Data Inputs'!P17=1, 'Data Inputs'!P17=2), \"Method 2 (for coal-fired industrial boilers):\", \" \")","v":"Method 2 (for coal-fired industrial boilers):"},"(QB/NPHR) x 0.4 x (CoalF)2.9 x (NRF)0.71 x (CCreplace) x 35.3 ",null,null,null,null,"Method 2 (industrial)",{"$f":"('Data Inputs'!C10/'Data Inputs'!C17)*(('SCR Design Parameters'!C19)^2.9)*(('SCR Design Parameters'!C15)^0.71)*('Data Inputs'!C57)*(35.3)","v":162700.83519045773}]
["Direct Annual Cost = ",null,null,{"$f":"SUM(D79:D82)","v":334920.631917939},{"$f":"\"in \"&'Data Inputs'!$C$52 & \" dollars\"","v":"in 2016 dollars"},null,null,{"$f":"IF('Data Inputs'!P8=2, 'Cost Estimate'!H86, 'Cost Estimate'!H87)","v":162700.83519045773}]
[]
["Indirect Annual Cost (IDAC)"]
["IDAC = Administrative Charges + Capital Recovery Costs"]
[]
["Administrative Charges (AC) = ",{"$f":"'Data Inputs'!C65 &\" x (Operator Cost + 0.4 x Annual Maintenance Cost) =\"","v":"0.03 x (Operator Cost + 0.4 x Annual Maintenance Cost) ="},null,{"$f":"'Data Inputs'!C65*(('Data Inputs'!C31*'Data Inputs'!C58*'Data Inputs'!C59)+(0.4*D79))","v":3545.7420183308068},{"$f":"\"in \"&'Data Inputs'!$C$52 & \" dollars\"","v":"in 2016 dollars"}]
["Capital Recovery Costs (CR)=","CRF x TCI =",null,{"$f":"IF('Data Inputs'!P17>2, B19*'SCR Design Parameters'!C59, (IF('Data Inputs'!P17=2, B29*'SCR Design Parameters'!C59, 0)))","v":1227366.5654078466},{"$f":"\"in \"&'Data Inputs'!$C$52 & \" dollars\"","v":"in 2016 dollars"}]
["Indirect Annual Cost (IDAC) =","AC + CR =",null,{"$f":"D93+D94","v":1230912.3074261774},{"$f":"\"in \"&'Data Inputs'!$C$52 & \" dollars\"","v":"in 2016 dollars"}]
[]
[]
["Cost Effectiveness"]
[]
["Cost Effectiveness = Total Annual Cost/ NOx Removed/year"]
[]
["Total Annual Cost (TAC) =",null,{"$f":"C74","v":1565832.9393441165},{"$f":"\"per year in \"&'Data Inputs'!$C$52 & \" dollars\"","v":"per year in 2016 dollars"}]
["NOx Removed =",null,{"$f":"'SCR Design Parameters'!C14","v":217.04760000000002},"tons/year"]
["Cost Effectiveness = ",null,{"$f":"C102/C103","v":7214.2375190700859},{"$f":"\"per ton of NOx removed in \"&'Data Inputs'!$C$52 & \" dollars\"","v":"per ton of NOx removed in 2016 dollars"}]

{"sheet":"ESRI_MAPINFO_SHEET","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}