{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["tbl","Table of Contents","Introduction","Data Entry","Report","SCR","SNCR","HPWI"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":10,"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":"tbl","index":0,"n_rows":70,"n_cols":16,"rows_kept":70,"cut":false,"hidden":true,"merged":[[62,4,63,15],[38,3,38,14],[40,5,40,7],[40,8,40,10],[40,15,41,15],[4,3,5,3],[4,4,5,4],[4,5,4,6],[60,4,61,15],[40,11,40,12],[13,6,13,7],[24,3,24,5],[36,3,36,15],[25,3,26,3],[25,4,26,4],[13,3,15,3],[13,4,15,4]]}
[]
[]
[]
[null,null,null,"Molecular Weight of Various Reagents and NO₂"]
[null,null,null,"No.","Component","Molecular Weight"]
[null,null,null,null,null,"Symbol","lb/mole"]
[null,null,null,1,2,3,4]
[null,null,null,1,"ammonia","MNH3",17.03]
[null,null,null,{"$f":"1+D8","v":2},"urea","Murea",60.06]
[null,null,null,{"$f":"1+D9","v":3},"NO₂","MNO2",46.01]
[]
[]
[null,null,null,"Various Reagent Aqueous Solutions and Water Selected Properties"]
[null,null,null,"No.","Component","Concentration","Density",null,"Heat of Vap"]
[null,null,null,null,null,"c","ρ","ρ","Hv"]
[null,null,null,null,null,"% by weight","lb/ft³","lb/gal","Btu/lb"]
[null,null,null,1,{"$f":"1+D17","v":2},{"$f":"1+E17","v":3},{"$f":"1+F17","v":4},{"$f":"1+G17","v":5},{"$f":"1+H17","v":6}]
[null,null,null,1,"ammonia 29%",29,56]
[null,null,null,{"$f":"1+D18","v":2},"urea 50%",50,71]
[null,null,null,{"$f":"1+D19","v":3},"urea 10%",10,null,null,900]
[null,null,null,{"$f":"1+D20","v":4},"water","-",{"$f":"+H21*7.481","v":62.428945000000006},8.3450000000000006,900]
[]
[null,null,null,null,null,null,7.4809999999999999,"gal/ft³"]
[]
[null,null,null,"EQUIPMENT BOOK LIFE [1]"]
[null,null,null,"No.","Technology","Book Life"]
[null,null,null,null,null,"Yrs"]
[null,null,null,1,2,3]
[null,null,null,1,"Combined cycle",30]
[null,null,null,{"$f":"1+D29","v":2},"Combustion turbine",30]
[null,null,null,{"$f":"1+D30","v":3},"Engine",30,"assumed"]
[null,null,null,4,"Boiler",40]
[]
[]
[]
[]
[null,null,null,"FUELS"]
[]
[null,null,null,"Lower and Higher Heating Values of Selected Fuels"]
[]
[null,null,null,null,"Fuels","Lower Heating Value (LHV) [1]",null,null,"Higher Heating Value (HHV) [1]",null,null,"Density",null,"Fuel Cost","Comments","Base case Flue Gas Fctr\n(reclc)"]
[null,null,null,1,{"$f":"1+D42","v":2},{"$f":"1+E42","v":3},{"$f":"1+F42","v":4},5,6,7,8,9,10,{"$f":"1+M42","v":11},{"$f":"1+N42","v":12}]
[null,null,null,1,"Gaseous Fuels @ 32 F and 1 atm","Btu/ft3 [2]","Btu/lb [3]","MJ/kg [4]","Btu/ft3 [2]","Btu/lb [3]","MJ/kg [4]","gr/ft3","grams/cm3","$/MMBtu",null,"CFM/MMBtu/hr"]
[null,null,null,{"$f":"1+D43","v":2},"Natural Gas",983,20267.225909090906,47.141269049911173,1089,22452.704999999998,52.224661236371581,22,null,4.21,null,1003.8903718416029]
[null,null,null,{"$f":"1+D44","v":3},"Liquid Fuels","Btu/gal [2]","Btu/lb [3]","MJ/kg [4]","Btu/gal [2]","Btu/lb [3]","MJ/kg [4]","gr/gal"]
[null,null,null,4,"Jet Fuel A (Kerosene K1)",null,18500,43.1,null,19861,46.2,null,{"$f":"(0.78+0.81)/2","v":0.79500000000000004},23.63,null,4177.5828655170972]
[null,null,null,5,"No. 2 oil",128450,18397.106251973477,42.791398263097854,137380,19676.095421534574,45.766308239660439,3167,{"$f":"+L47/(12*2.54)^3","v":0.11184154950695435},24.07,"U.S. conventional diesel",1466.2110725803798]
[null,null,null,6,"Ultra low sulfur kerosene oil (ULSD)",129487.84757606639,18320.147467881456,42.612393264440954,138490,19593.786369307545,45.574858596098856,3206,{"$f":"+L48/(12*2.54)^3","v":0.11321882150909242},20.94,"Low-sulfur diesel",1931.8902664650345]
[null,null,null,7,"No. 6 Oil",140352.52220119376,16967.617416108602,39.466428278669781,150110,18147.226785714287,42.210182303804245,3752,null,16.95,"Residual oil",401.16368445010244]
[null,null,null,8,"Solid Fuels","Btu/ton [2]","Btu/lb [5]","MJ/kg [4]","Btu/ton [2]","Btu/lb [5]","MJ/kg [4]"]
[null,null,null,9,"Coal",22460600,11230.3,26.121512445062798,23445900,11722.95,27.267409091284208,null,null,2.3018950008317018,"Bituminous coal (wet basis) [7]",499.96790483223708]
[]
[null,null,null,"Source:"]
[null,null,null,"GREET, The Greenhouse Gases, Regulated Emissions, and Energy Use In Transportation Model, GREET 1.8d.1, developed by Argonne National Laboratory, Argonne, IL, released August 26, 2010."]
[null,null,null,"http://greet.es.anl.gov/"]
[null,null,null,"From:"]
[null,null,null,null,"US DOE - Energy Efficiency & Renewable Energy",null,"http://cta.ornl.gov/bedb"]
[null,null,null,null,"Biomass Energy Data Book",null,"http://cta.ornl.gov/bedb/appendix_a.shtml"]
[]
[null,null,null,"Notes:"]
[null,null,null,1,"The lower heating value (also known as net calorific value) of a fuel is defined as the amount of heat released by combusting a specified quantity (initially at 25°C) and returning the temperature of the combustion products to 150°C, which assumes the latent heat of vaporization of water in the reaction products is not recovered. The LHV are the useful calorific values in boiler combustion plants and are frequently used in Europe."]
[]
[null,null,null,null,"The higher heating value (also known as gross calorific value or gross energy) of a fuel is defined as the amount of heat released by a specified quantity (initially at 25°C) once it is combusted and the products have returned to a temperature of 25°C, which takes into account the latent heat of vaporization of water in the combustion products. The HHV are derived only under laboratory conditions, and are frequently used in the US for solid fuels. "]
[]
[null,null,null,{"$f":"1+D61","v":2},"Btu =  British thermal unit. "]
[null,null,null,{"$f":"1+D65","v":3},"The heating values for gaseous fuels in units of Btu/lb are calculated based on the heating values in units of Btu/ft3 and the corresponding fuel density values. The heating values for liquid fuels in units of Btu/lb are calculated based on heating values in units of Btu/gal and the corresponding fuel density values."]
[null,null,null,{"$f":"1+D66","v":4},"The heating values in units of MJ/kg, are converted from the heating values in units of Btu/lb."]
[null,null,null,{"$f":"1+D67","v":5},"For solid fuels, the heating values in units of Btu/lb are converted from the heating values in units of Btu/ton."]
[null,null,null,{"$f":"1+D68","v":6},"Coal characteristics assumed by GREET for electric power production."]
[null,null,null,{"$f":"1+D69","v":7},"Coal characteristics assumed by GREET for hydrogen and Fischer-Tropsch diesel production."]

{"sheet":"Table of Contents","index":1,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":false,"merged":[[30,6,30,13],[4,4,6,14],[8,14,8,15],[17,6,17,13],[20,6,20,13],[21,6,21,13],[24,6,24,13],[18,6,18,13],[22,6,22,13],[19,6,19,13],[26,4,28,15]]}
[]
[]
[]
[]
[null,null,null,null,"AIR POLLUTION CONTROL\nCOST EFFECTIVENESS ASSESSMENT FOR USE WITH \nRCSA SECTION 22a-174-22e(h)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Revision:","01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev. Date:","2016-08-31"]
[]
[]
[]
[null,null,null,null,"TABLE OF CONTENTS"]
[]
[]
[null,null,null,null,"SECTION",null,null,null,null,null,null,null,null,null,"Page"]
[]
[null,null,null,null,1,null,"INTRODUCTION",null,null,null,null,null,null,null,1]
[null,null,null,null,2,null,"DATA ENTRY",null,null,null,null,null,null,null,2]
[null,null,null,null,3,null,"REPORT",null,null,null,null,null,null,null,3]
[null,null,null,null,4,null,"SELECTIVE CATALYTIC REDUCTION, SCR",null,null,null,null,null,null,null,4]
[null,null,null,null,5,null,"SELECTIVE NON-CATALYTIC REDUCTION, SNCR",null,null,null,null,null,null,null,5]
[null,null,null,null,6,null,"HIGH PRESSURE WATER INJECTION, HPWI",null,null,null,null,null,null,null,6]
[]
[]
[null,null,null,null,"INSTRUCTIONS"]
[null,null,null,null,"To use this calculator, fill in the user inputs on the \"data entry\" tab. If an entry is not applicable to the emission unit, leave the entry field blank. The \"report\" page containing data entry specifications and the assessment results, is filled automatically. To review the calculations sequence refer to the tab specific for each individual control technology selected. To understand the equations, default values and assumptions used in calculating the resulting cost value, refer to the Explanation file, checking tabs specific to each individual control technology."]

{"sheet":"Introduction","index":2,"n_rows":87,"n_cols":19,"rows_kept":87,"cut":false,"hidden":false,"merged":[[38,6,38,19],[36,6,37,18],[15,5,22,18],[6,9,8,17],[24,5,24,18],[26,5,26,18],[10,18,10,19],[39,6,41,18],[46,6,48,19],[69,6,70,19],[71,6,72,19],[73,6,73,19],[79,5,82,19],[74,6,75,19],[49,6,51,19],[52,6,53,19],[55,6,56,19],[54,6,54,19],[63,6,65,19]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"AIR POLLUTION CONTROL\nCOST EFFECTIVENESS ASSESSMENT FOR USE WITH \nRCSA SECTION 22a-174-22e(h)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revision:","02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev. date:","2016-08-31"]
[]
[]
[]
[]
[null,null,null,null,null,"This template provides a method acceptable to the Commissioner for calculating the cost effectiveness of certain NOx control equipment to support a request for a case-by-case RACT determination pursuant to RCSA section 22a-174-22e(h).  NOx controls addressed in this template include selective catalytic reduction (SCR), selective non-catalytic reduction (SNCR) and high-pressure water injection (HPWI).  The cost per ton of NOx reduced value obtained from this calculator is presumptively acceptable by the commissioner. An owner may use an alternative method to estimate the cost ($/ton of NOx removed) of the post-combustion NOx controls addressed in this template, if the owner justifies such an alternative approach to the commissioner. For control scenarios not addressed in this template, an owner or operator may use any generally accepted method recognized by the U.S. Environmental Protection Agency (EPA) or by an industrial association and must document the method used to the Commissioner's satisfaction."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"References"]
[]
[null,null,null,null,null,"The method used in this template is based on the following documents prepared by EPA:"]
[null,null,null,null,null,1,"EPA Air Pollution Control Cost Manual - Seventh Edition, Section 4 - NOx Controls: \nChapter 1 - Selective Noncatalytic Reduction, May 2016."]
[null,null,null,null,null,{"$f":"1+F28","v":2},"EPA Air Pollution Control Cost Manual - Seventh Edition, Section 4 - NOx Controls: \nChapter 2 - Selective Catalytic Reduction, May 2016."]
[null,null,null,null,null,{"$f":"1+F29","v":3},"EPA’s Power Sector Modeling - Integrated Planning Model (IPM) Platform v.5.13, \nChapter 8: Financial Assumptions."]
[null,null,null,null,null,{"$f":"1+F30","v":4},"EPA Air Pollution Control Cost Manual - Sixth Edition (EPA 452/B-02-001), January 2002."]
[null,null,null,null,null,{"$f":"1+F31","v":5},"Alternative Control Techniques Document - NOx Emissions from Stationary Gas Turbines - EPA ACT Document No.:  EPA-453/R-93-007."]
[]
[null,null,null,null,null,"General Assumptions"]
[]
[null,null,null,null,null,"General assumptions used in this template include the following:"]
[null,null,null,null,null,"●","The default operating time for each emission source, NOx control, and facility is 8,760 hours per year (365 days per year).  Deviation from this assumption is acceptable only for an emission source subject to an enforceable limitation on annual operating hours.  "]
[]
[null,null,null,null,null,"●","The control design configuration assumed for each control is the most commonly used design configuration for which data was available.  "]
[null,null,null,null,null,"●","All results are adjusted by the Consumer Price Index (CPI) for 2012 and corrected to future years based on a projected CPI assuming a rate of inflation. Consequently the cost effectiveness may be scaled to 2017$ for the RCSA 22a-174-22e(h), Phase 1 determination and to 2020$ for the Phase 2 determination."]
[]
[]
[]
[null,null,null,null,null,"Selective Catalytic Reduction, SCR Specifications"]
[]
[null,null,null,null,null,"●","The template is based on the 2016 Cost Manual, Ref. 2."]
[null,null,null,null,null,"●","Both the 2016 (Ref. 2) and 2002 (Ref. 4) Cost Manuals address utility/industrial boilers of a similar size firing coal or fuel oil.   The results achieved using the method of the 2016 Cost Manual with the 2002 Cost Manual were in a similar price range for similarly sized utility and industrial boilers firing coal or fuel oil.  "]
[]
[]
[null,null,null,null,null,"●","The calculation was projected to address the use of SCR for simple cycle turbines.  It was assumed that SCR used as a turbine control will have a total capital investment within the same range as utility boilers, where an acceptable range was ±30%.  The extended 2002 calculation resulted in a higher overall cost than the 2016 calculation method in a ratio of 1:1.1 for natural gas and 1:1.5 for fuel oil."]
[]
[]
[null,null,null,null,null,"●","The method assumes a high dust design (configuration of the majority of SCR's, 88% reported in 1997, per Ref. 2 and the use of aqueous ammonia as the reductant. The cost values resulting from other designs are assumed to be in a comparative price range.  "]
[]
[null,null,null,null,null,"●","The method also assumes the use of aqueous ammonia as the reductant. No other reductant selection for SCR is available. "]
[null,null,null,null,null,"●","The catalyst is assumed to be a configuration with a ratio of 2:1 for full and empty layers (per Ref. 4), as this configuration results in a lower maintenance cost than other configurations."]
[]
[null,null,null,null,null,"●","Complete replacement of the catalyst every 24,000 hrs of operation is assumed in the resulting cost estimate.  "]
[]
[null,null,null,null,null,"Selective Non Catalytic Reduction, SNCR Specifications"]
[]
[null,null,null,null,null,"●","The template is based on the 2016 Cost Manual draft, Ref. 1 mentioned above."]
[null,null,null,null,null,"●","Urea is assumed to be used as the reductant, per the 2016 Cost Manual, Ref. 1.  No other reductant selection is available within the template. "]
[null,null,null,null,null,"●","The 2016 manual, Ref. 1, addresses the use of SNCR to control NOx from utility/industrial boilers firing coal or fuel oil.  For turbines, calculations comparing the results of the 2016 (Ref. 1) and 2002 (Ref. 4) Cost Manual methods resulted in a similar price (within 20%), when adjusted to the same year.  This variation is acceptable ( ±30%), according to EPA's methods.  "]
[]
[]
[]
[null,null,null,null,null,"High Pressure Water Injection, HPWI Specifications"]
[]
[null,null,null,null,null,"●","EPA provided no 2016 cost manual draft for HPWI, so the total capital investment (TCI) estimation method used is developed from the 1996 Alternative Control Techniques (ACT) Document - NOx Emission from Stationary Gas Turbines, which used 1990 pricing.  "]
[]
[null,null,null,null,null,"●","The TCI calculated for several specific emissions sources, using the 1996 ACT approach, demonstrated a linear relationship with the nominal output of the emission source (MW).  The 2012 investment cost, was calculated using this relationship, and adjusted to 2012$ with the cost of inflation."]
[]
[null,null,null,null,null,"●","The cost of utilities (electricity and water consumption) are the 2012$ cost specified in EPA's recent updates of the cost manuals (Ref. 1 and Ref. 2)."]
[null,null,null,null,null,"●","Water treatment (materials and labor) and water disposal are the 1990$ costs specified in Ref. 5, only. Since the document has not been updated, the template uses the 1990$ specific costs adjusted to 2012$ by the U.S Consumer Price Index (CPI)."]
[]
[]
[null,null,null,null,null,"Instructions"]
[]
[null,null,null,null,null,"To use this calculator, fill in the user inputs on the \"data entry\" tab. If an entry is not applicable to the emission unit, leave the entry field blank. The \"report\" page containing data entry specifications and the assessment results, is filled automatically. To review the calculations sequence refer to the tab specific for each individual control technology selected. To understand the equations, default values and assumptions used in calculating the resulting cost value, refer to the Explanation file, checking tabs specific to each individual control technology."]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Questions concerning this template may be addressed to Daniel Vesa, P.E., 860-424-3282,"]
[null,null,null,null,null,"Daniel.Vesa@ct.gov."]

{"sheet":"Data Entry","index":3,"n_rows":161,"n_cols":27,"rows_kept":161,"cut":false,"hidden":false,"merged":[[156,19,158,26],[152,19,153,26],[113,7,114,10],[125,19,127,26],[136,19,137,26],[118,19,119,26],[116,7,117,10],[122,15,123,26],[129,19,130,26],[133,19,134,26],[142,19,143,26],[145,19,146,26],[107,15,108,15],[107,17,108,17],[99,19,100,26],[113,19,114,26],[103,19,104,26],[110,19,111,26],[101,19,102,26],[55,15,55,17],[48,7,49,10],[51,7,52,10],[95,19,96,26],[97,19,98,26],[74,19,75,26],[77,19,78,26],[69,15,70,26],[83,19,85,26],[87,19,91,26],[33,19,35,26],[48,19,48,26],[8,11,9,22],[40,19,42,26],[37,19,37,26],[10,23,10,25],[11,23,11,25],[13,19,15,26],[18,15,19,26],[45,19,47,26],[10,13,11,20],[160,19,162,26],[57,15,59,26],[13,3,15,3],[13,13,15,13],[13,15,15,17],[21,15,21,17],[23,15,23,17],[24,15,24,17],[31,15,31,17],[25,15,25,17],[13,12,15,12],[13,5,15,10],[79,7,80,10],[31,19,32,26],[51,19,52,26],[28,19,29,26]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revision:","02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev. Date:","2016-08-31"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"AIR POLLUTION CONTROLS COST EFFECTIVENESS ASSESSMENT \nFOR USE WITH RCSA SECTION 22a-174-22e(h)"]
[]
[null,null,null,null,null,null,null,null,null,null,"DATA ENTRY"]
[]
[]
[null,null,null,"Line",null,"Item Description",null,null,null,null,null,null,"Symbol","Units",null,"Input",null,null,null,"Comments"]
[]
[]
[]
[null,null,null,null,"I.","Data Required"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: If an entry is not applicable to the emission unit, leave the entry field blank. All fields marked with an asterisk \n           are required."]
[]
[null,null,null,null,null,null,"Emission Unit ID"]
[null,null,null,1,null,null,null,"Owner/Operator",null,null,null,null,null,null,null,null,null,null,"*",{"$f":"IF(AND(P22=\"\",OR(P$23>0,P$24>0,P$25>0, P$26>0,P$27>0,P$28>0,P$29>0,P$31>0,P$32>0,P$34>0,P$38>0,P$41>0,P$42>0,P$43>0,P$46>0,P$49>0,P$52>0,P$56>0,P$74>0,P$75>0,P$78>0,P$80>0)),\"Error: Company name is required\",\"Enter the full legal company / firm name\")","v":"Enter the full legal company / firm name"}]
[null,null,null,{"$f":"1+D22","v":2},null,null,null,"Owner/Operator Initials"]
[null,null,null,3,null,null,null,"Facility Name",null,null,null,null,null,null,null,null,null,null,"*",{"$f":"IF(AND(P24=\"\",OR(P$25>0, P$26>0,P$27>0,P$28>0,P$29>0,P$31>0,P$32>0,P$34>0,P$38>0,P$41>0,P$42>0,P$43>0,P$46>0,P$49>0,P$52>0,P$56>0,P$74>0,P$75>0,P$78>0,P$80>0,)),\"Error: Facility name is required\",\"Enter facility name\")","v":"Enter facility name"}]
[null,null,null,4,null,null,null,"Town"]
[null,null,null,5,null,null,null,"DEEP Permit/Registration No."]
[null,null,null,6,null,null,null,"Town Code",null,null,null,null,null,null,null,null,null,null,null,"Per DEEP emission unit permit or registration."]
[null,null,null,7,null,null,null,"Premises No.",null,null,null,null,null,null,null,null,null,null,null,"Per DEEP emission unit permit or registration."]
[null,null,null,8,null,null,null,"Facility Altitude",null,null,null,null,"h","ft",null,null,"*",null,null,{"$f":"IF(AND(P29=\"\",OR(P$31>0,P$32>0,P$34>0,P$38>0,P$41>0,P$42>0,P$43>0,P$46>0,P$49>0,P$52>0,P$56>0,P$74>0,P$75>0,P$78>0,P$80>0)),\"Error: Facility altitude is required. If not known, enter ''0'' - sea level.\",\"Enter elevation with respect to sea level. If elevation is not known and is estimated to be less than 500 ft, assume sea level ''0'' ft.\")","v":"Enter elevation with respect to sea level. If elevation is not known and is estimated to be less than 500 ft, assume sea level ''0'' ft."}]
[]
[null,null,null,{"$f":"1+D29","v":9},null,null,null,"Unit Tag",null,null,null,null,null,null,null,null,"*",null,null,{"$f":"IF(AND(P31=\"\",OR(P$32>0,P$34>0,P$38>0,P$41>0,P$42>0,P$43>0,P$46>0,P$49>0,P$52>0,P$56>0,P$74>0,P$75>0,P$78>0,P$80>0)),\"Error: Emission unit tag is required.\",\"Enter unit DEEP permit or registration tag, if any. If none, assign an ID tag.\")","v":"Enter unit DEEP permit or registration tag, if any. If none, assign an ID tag."}]
[null,null,null,{"$f":"1+D31","v":10},null,null,null,"Unit Type",null,null,null,null,null,null,null,null,null,null,"*",{"$f":"IF(AND(P32=\"\",OR(P$34>0,P$38>0,P$41>0,P$42>0,P$43>0,P$46>0,P$49>0,P$52>0,P$56>0,P$74>0,P$75>0,P$78>0,P$80>0)),\"Error: Emission unit type is required. Select from the drop down list.\",\"Select from the drop down list : Combined Cycle Turbine, Combustion Turbine, Engine or Boiler.\")","v":"Select from the drop down list : Combined Cycle Turbine, Combustion Turbine, Engine or Boiler."}]
[]
[null,null,null,{"$f":"1+D32","v":11},null,null,null,"No. of identical Units w/ same controls",null,null,null,null,null,null,null,null,null,null,null,"Enter number of identical units at the same location with the same type of air pollution control. \nNote: Control Cost Effectiveness assessment performed for a single emission unit."]
[]
[]
[]
[null,null,null,{"$f":"1+D34","v":12},null,null,null,{"$f":"+IF(P32=\"Boiler\",\"Type of Combustion\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(P32=\"Boiler\",IF(P38>0,\"Indicate whether the combustion type is a Fluidized Bed (FB) or not (non-FB).\",\"Select whether the combustion type is a Fluidized Bed (FB) or not (non-FB).\"),IF(P38>0,\"Delete entry, since refers to boilers only\",\"Line 12 should be left blank, unless the emission unit is a boiler.\"))","v":"Line 12 should be left blank, unless the emission unit is a boiler."}]
[]
[null,null,null,null,null,null,"Air Pollution Control(s) Selected"]
[null,null,null,{"$f":"1+D38","v":13},null,null,null,"Selective Catalytic Reduction - SCR",null,null,null,null,null,null,null,null,"*",null,null,{"$f":"+IF(AND(AND(P41=\"\",P42=\"\",P43=\"\"),OR(P$46>0,P$49>0,P$52>0,P$56>0,P$74>0,P$75>0,P$78>0,P$80>0)),\"Error: Select at least one control.\",\"Select the control(s) to be assessed by choosing ''Yes'' or ''No'' from the corresponding adjacent drop down list.\")","v":"Select the control(s) to be assessed by choosing ''Yes'' or ''No'' from the corresponding adjacent drop down list."}]
[null,null,null,{"$f":"1+D41","v":14},null,null,null,"Selective Noncatalytic Reduction - SNCR",null,null,null,null,null,null,null,null,"*"]
[null,null,null,{"$f":"1+D42","v":15},null,null,null,"High Pressure Water Injection - HPWI",null,null,null,null,null,null,null,null,"*"]
[]
[null,null,null,null,null,null,"Performance Data"]
[null,null,null,{"$f":"1+D43","v":16},null,null,null,"Maximum Heat Rate Input",null,null,null,null,"QB","MMBtu/hr",null,null,"*",null,null,{"$f":"+IF(OR(P32=\"Combustion Turbine\",P32=\"Boiler\"),\"It may be left blank, if not known\",IF(P46>0,\"Enter value if the emission unit is a combined cycle turbine or a boiler. If not, it may be left blank. Note: Use as entry data ''Nominal Heat Input Capacity'', if available. \",IF(OR(P49=\"\",P52=\"\"),\"Enter value if the emission unit is a combined cycle turbine or a boiler. If not, it may be left blank. Note: Use as entry data ''Nominal Heat Input Capacity'', if available.\",\"Enter value \"&IF(AND(P49>0,P52>0),\"(of \"&ROUND(P49*P52,0)&\" MMBtu/hr).\"))))","v":"Enter value if the emission unit is a combined cycle turbine or a boiler. If not, it may be left blank. Note: Use as entry data ''Nominal Heat Input Capacity'', if available."}]
[]
[]
[null,null,null,{"$f":"1+D46","v":17},null,null,null,"Power Output (MW Rating) \nat full load capacity.",null,null,null,null,"BMW","MW",null,null,"*",null,null,{"$f":"+IF(P46=\"\",IF(P32=\"Combustion Turbine\",IF(P49>0,\"\",\"Enter unit Nominal Plate MW\"),\"\"),IFERROR(IF(ROUND(P49,1)=ROUND(P46/P52,1),\"\",\"It may be left blank or enter MW as ''Max. Heat Rate Input / NPHR = \"&ROUND(P46/P52,1)&\"MW''\"),\"Enter NPHR below\"))","v":""}]
[]
[]
[null,null,null,{"$f":"1+D49","v":18},null,null,null,{"$f":"+IF(P32=\"Boiler\",\"Net Plant Heat Rate\",\"Nominal Plate Heat Rate\")","v":"Nominal Plate Heat Rate"},null,null,null,null,"NPHR","MMBtu/MWh",null,null,"*",null,null,{"$f":"+IF(P52=IF(AND(P46>0,P49>0),ROUND(P46/P49,2),P52),\"Provided by the unit's manufacturer. If not known it can be assessed from EPA's AMPD data.\",\"Error: Check all Performance Data Entries or Select a NPHR value equal to =\"&ROUND(P46/P49,2)&\" MMBtu/MWh\")","v":"Provided by the unit's manufacturer. If not known it can be assessed from EPA's AMPD data."}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\"Error: Coal is fired in boilers only, Check the unit type and the fuel.\""]
[null,null,null,null,null,null,"Fuel"]
[null,null,null,{"$f":"1+D52","v":19},null,null,null,"Fuel (Primary)",null,null,null,null,null,null,null,null,null,null,"*",{"$f":"IF(AND(P56=\"\",OR(P$74>0,P$75>0,P$78>0,P$80>0)),\"Error: Fuel is required. Select from the drop down list.\",IF(AND(P56=\"No. 6 oil\",OR(P32=\"Combined Cycle\",P32=\"Combustion Turbine\")),\"Error: No. 6 oil is not fired in turbines.\", IF(AND(P56=\"Coal\",OR(P32=\"Combined Cycle\",P32=\"Combustion Turbine\",P32=\"Engine\")),\"Error: Coal is fired in boilers only, Check the unit type and the fuel.\",\"Select from the drop down list\")))","v":"Select from the drop down list"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(P56=\"Coal\",\"Special Note (for emission units burning coal, only):\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(P56=\"Coal\",\"Connecticut has only one emission unit that burns coal and that unit burns a mix of bituminous and sub-bituminous coal.\"&\" The specifications of the calculation for coal is designed to address that unit's coal inputs.  For other coal types, this calculator may require adjustment.\",\"\")","v":""}]
[]
[]
[]
[null,null,null,{"$f":"1+D56","v":20},null,null,null,"Fuel Sulfur Content",null,null,null,null,null,"% by weight",null,0,"*",null,null,{"$f":"IF(AND(P62=\"\",OR(P$74>0,P$75>0,P$78>0,P$80>0)),\"Error: A value of sulfur content is required. Enter ''0'' if sulfur content is not known.\",\"Enter ''0'' if sulfur content is less than 1%.\")","v":"Enter ''0'' if sulfur content is less than 1%."}]
[]
[null,null,null,{"$f":"1+D62","v":21},null,null,null,"SO₂ Content of Fuel",null,null,null,null,null,"lb/MMBtu",null,0,"*",null,null,{"$f":"IF(AND(P64=\"\",OR(P$74>0,P$75>0,P$78>0,P$80>0)),\"Error: A value of SO₂ content is required. Enter ''0'' if SO₂ content is not known.\",\"Enter ''0'' for coals with SO₂ ≤ 3lb/MMBtu and also ''0'' if fuel is other than coal.\")","v":"Enter ''0'' for coals with SO₂ ≤ 3lb/MMBtu and also ''0'' if fuel is other than coal."}]
[]
[null,null,null,{"$f":"1+D64","v":22},null,null,null,"Percent Fuel Ash Weight",null,null,null,null,"% FAW","% by weight",null,7.4999999999999997E-2,"*",{"$f":"+IF(P66=7.5/100,\"default value\",IF(P66>0,\"actual value\",\"\"))","v":"default value"},null,{"$f":"IF(AND(P66=\"\",OR(P$74>0,P$75>0,P$78>0,P$80>0)),\"Error: A value of % Ash Fuel Weight is required. Enter 7.5% for coal or ''0'' for all other fuels.\",\"Enter actual value or if not known enter ''7.5%'' for coal, or ''0'' for all other fuels''.\")","v":"Enter actual value or if not known enter ''7.5%'' for coal, or ''0'' for all other fuels''."}]
[]
[]
[null,null,null,null,null,null,"Exhaust Flue Flow",null,null,null,null,null,null,null,null,"Note:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exhaust flow temperature and flow rate at the max. capacity are required, only if SCR is selected on Line 13. Data entry fields at Lines 23, 24 and 25 may be left blank for SNCR and HPWI."]
[]
[]
[null,null,null,{"$f":"1+D66","v":23},null,null,null,"Most Recent Stack Test Date"]
[null,null,null,{"$f":"1+D73","v":24},null,null,null,"Stack Temperature",null,null,null,null,"Tout","ºF",null,null,{"$f":"+IF(P41=\"Yes\",\"*\",\"\")","v":""},null,null,{"$f":"+IF(P41=\"Yes\",IF(AND(P74=\"\",OR(P$75>0,P$78>0,P$80>0)),\"Error: The exhaust gas temperature associated with the exhaust flow is required.\",\"\"),\"\")","v":""}]
[null,null,null,{"$f":"1+D74","v":25},null,null,null,"Exhaust Flue Flow at Max. Capacity",null,null,null,null,null,"ACFM",null,null,{"$f":"+IF(P41=\"Yes\",\"*\",\"\")","v":""},null,null,{"$f":"+IF(P41=\"Yes\",IF(AND(P75=\"\",OR(P$78>0,P$80>0)),\"Error: The exhaust gas flow rate is required. If not available, use DEEP Emissions Inventory (EMIT) Data.\",\"If not available, use DEEP Emissions Inventory (EMIT) Data.\"),\"If not available, use DEEP Emissions Inventory (EMIT) Data for SCR assessment.\")","v":"If not available, use DEEP Emissions Inventory (EMIT) Data for SCR assessment."}]
[]
[null,null,null,null,null,null,"NOx Removal Specifications"]
[null,null,null,{"$f":"1+D75","v":26},null,null,null,"Uncontrolled NOx Emission Level",null,null,null,null,"NOxin","lb/MMBtu",null,null,"*",null,null,{"$f":"IF(AND(P78=\"\",P$80>0),\"Error: NOxin is rate is required. If not available, use EPA's AMPD data (max. value of the last five years)\",\"From the stack test or from EPA's AMPD data (max. value of the last five years).\")","v":"From the stack test or from EPA's AMPD data (max. value of the last five years)."}]
[]
[null,null,null,{"$f":"1+D78","v":27},null,null,null,"Required Annual Average Controlled NOx Emission Level",null,null,null,null,"NOxout","lb/MMBtu",null,null,"*",null,null,{"$f":"IF(AND(P80=\"\",P$78>0),\"NOx(out) rate is required. Enter NOx limit as required by RCSA 22a-174-22e.\",\"Enter NOx limit as required by RCSA 22a-174-22e.\")","v":"Enter NOx limit as required by RCSA 22a-174-22e."}]
[]
[]
[null,null,null,null,null,null,"Cost Adjustment"]
[null,null,null,{"$f":"1+D80","v":28},null,null,null,"Year Control is Effective (or Current Year)",null,null,null,null,null,"$year",null,2016,"*",null,null,{"$f":"IF(OR(AND(P84=\"\",OR(P$78>0,P$80>0)),AND(P85=\"\",OR(P$78>0,P$80>0))),\"Error: An entry is required. If CFI data is not availabe, enter the last year posted on the U.S. Dept. of Labor website, Ref.6, below.\",\"Year posted may be adjusted to a future year. Corresponding CPI may be projected, if not available on the U.S. Department of Labor website, see Ref. 6, below.\")","v":"Year posted may be adjusted to a future year. Corresponding CPI may be projected, if not available on the U.S. Department of Labor website, see Ref. 6, below."}]
[null,null,null,{"$f":"1+D84","v":29},null,null,null,"Consumer Price Index (CPI Multiplier)",null,null,null,null,{"$f":"+\"CPI\"&\"(\"&P84&\"$)\"","v":"CPI(2016$)"},null,null,1.04,"*"]
[]
[null,null,null,null,null,null,"Retrofit Factors"]
[null,null,null,{"$f":"1+D85","v":30},null,null,null,"Selective Catalytic Reduction System",null,null,null,null,"RFSCR",null,null,1,"*",null,null,{"$f":"IF(AND(P88=\"\",P$41=\"Yes\"),\"Error: An entry is required for RF(SCR). Enter ''1'' as default or a value between 0.8 and 1.5, based on the level of difficulty.\",IF(AND(P89=\"\",P$42=\"Yes\"),\"Error: An entry is required for RF(SNCR). Enter ''1'' as default or a value between 0.8 and 1.5, based on the level of difficulty.\",IF(AND(P90=\"\",P$43=\"Yes\"),\"Error: An entry is required for RF(HPWI). Enter ''1'' as default or a value between 0.8 and 1.5, based on the level of difficulty.\",\"Enter, for each of the selected controls, a retrofit factor between 0.8 and 1.5, based on the level of difficulty,\"&\" per Ref. 1, §1.4.1-Total Capital Investment, p1-44 (p44-pdf) and Ref. 2, §2.4-Cost Analysis, p2-63 (p64-pdf).  Enter 1 (default value) for projects of average retrofit difficulty. Enter a value less than 1 for new construction.\"&\" Note: You must document any retrofit factor greater than ''1'. \")))","v":"Enter, for each of the selected controls, a retrofit factor between 0.8 and 1.5, based on the level of difficulty, per Ref. 1, §1.4.1-Total Capital Investment, p1-44 (p44-pdf) and Ref. 2, §2.4-Cost Analysis, p2-63 (p64-pdf).  Enter 1 (default value) for projects of average retrofit difficulty. Enter a value less than 1 for new construction. Note: You must document any retrofit factor greater than ''1'. "}]
[null,null,null,{"$f":"1+D88","v":31},null,null,null,"Selective Noncatalytic Reduction System",null,null,null,null,"RFSNCR",null,null,1,"*"]
[null,null,null,{"$f":"1+D89","v":32},null,null,null,"High Pressure Water Injection System",null,null,null,null,"RFHPWI",null,null,1,"*"]
[]
[]
[]
[]
[null,null,null,null,"II.","General Assumptions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"References:",1,"EPA Air Pollution Control Cost Manual - Seventh Edition, Section 4 - NOx Controls: \nChapter 1 - Selective Noncatalytic Reduction, May 2016."]
[null,null,null,null,null,null,null,null,null,null,"EPA Air Pollution Control Cost Manual - Seventh Edition, Section 4 - NOx Controls: \nChapter 1 - Selective Noncatalytic Reduction, May 2016."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+S96","v":2},"EPA Air Pollution Control Cost Manual - Seventh Edition, Section 4 - NOx Controls: \nChapter 2 - Selective Catalytic Reduction, May 2016."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+S98","v":3},"EPA’s Power Sector Modeling - Integrated Planning Model (IPM) Platform v.5.13, \nChapter 8: Financial Assumptions."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+S100","v":4},"EPA Air Pollution Control Cost Manual - Sixth Edition (EPA 452/B-02-001), January 2002."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+S102","v":5},"Alternative Control Techniques Document - NOx Emissions from Stationary Gas Turbines - EPA ACT Document No.:  EPA-453/R-93-007."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+S104","v":6},"U.S Department of Labor - Bureau of Labor Statistics: CPI Inflation Calculator."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Column 1.",null,"Column 2."]
[null,null,null,null,null,null,"Operation Data",null,null,null,null,null,null,null,null,"Default Operation",null,"Limited Operation"]
[]
[]
[null,null,null,{"$f":"1+D90","v":33},null,null,null,"Emission Unit Annual Hrs of Operation",null,null,null,null,"top, ems unit","hrs",null,8760,null,null,null,"Default operation time for RACT determination is 8,760 hrs. If the emission unit is subject to enforceable limit on hours of operation, enter the enforceable limit."]
[]
[]
[null,null,null,{"$f":"1+D111","v":34},null,null,null,"Air Pollution Control Annual Hrs of Operation",null,null,null,null,"t op, control","hrs",null,{"$f":"+P111","v":8760},null,{"$f":"+IF(R111=\"\",\"\",R111)","v":""},null,"The air pollution control is assumed to operate at all times the emission unit is operating. Therefore, the control and emission unit hrs of operation are equal."]
[]
[]
[null,null,null,{"$f":"1+D114","v":35},null,null,null,"Emission Unit Total Operating Time ",null,null,null,null,"tems unit","days",null,{"$f":"+P111/24","v":365},null,{"$f":"+IF(R111=\"\",\"\",R111/24)","v":""},null,"Emission unit \"Default Operation\" and \"Limited Operation\" time, in days."]
[]
[null,null,null,{"$f":"1+D117","v":36},null,null,null,"Emission Control Total Operating Time",null,null,null,null,"tcontrol","days",null,{"$f":"+P114/24","v":365},null,{"$f":"+IF(R111=\"\",\"\",R114/24)","v":""},null,"It is assumed that the air pollution control is on when the emission unit is running. Therefore, the control and emission unit hrs of operation are equal."]
[]
[]
[null,null,null,null,"III.","Economic Factors and Specific Costs",null,null,null,null,null,null,null,null,null,"Note:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Economic Factors and all Specific Cost listed below apply for both Default Operation and Limited Operation cost effectiveness calculations."]
[]
[null,null,null,null,null,null,"Economic Factors"]
[null,null,null,{"$f":"1+D119","v":37},null,null,null,"Cost Year base",null,null,null,null,null,"$year",null,2012,null,null,null,"Per Ref. 1, § 1.4 Cost Analysis, page 1-43 (p43-pdf) & § 1.5-Ex. Problem, \npage 1-58 (p58-pdf) and Ref. 2, § 2.4 Cost Analysis, page 2-62 (p63-pdf) & § 2.5 - Ex. Problem, page 2-80 (p81-pdf)."]
[]
[]
[]
[null,null,null,{"$f":"1+D126","v":38},null,null,null,"Annual Interest Rate",null,null,null,null,"i","%",null,7.0000000000000007E-2,null,null,null,"Per Ref. 1, § 1.5-Ex. Problem, p1-58 (p58-pdf) and Ref. 2, § 2.5-Ex. Problem, \npage 2-80 (p81-pdf)."]
[]
[]
[null,null,null,{"$f":"1+D130","v":39},null,null,null,"Equipment Life",null,null,null,null,"n","years",null,{"$f":"+IFERROR(VLOOKUP(MATCH(IF(RIGHT(P32,6)=\"boiler\",RIGHT(P32,6),P32),bk_id,0),bk_life,tbl!$F$28,FALSE),\"\")","v":""},null,null,null,"Per Ref. 3, Chapter 8, Table 8-4, page 8-14 (p9-pdf):"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Power Sector Modeling Platform v.5.13 Documentation - Chapter 8: Financial Assumptions."]
[]
[]
[null,null,null,{"$f":"1+D133","v":40},null,null,null,"Capital Recovery Factor",null,null,null,null,"CRF",null,null,{"$f":"+IFERROR((P130*(1+P130)^P133)/((1+P130)^P133-1),\"\")","v":""},null,null,null,"Calculated per Ref. 1, § 1.4.2 Total Annual Cost, eq. (1.55), p1-57 (p57-pdf) and \nRef. 2, § 2.4.2 Total Annual Cost, Capital Recovery, eq. (2.71), p2-79 (p80-pdf)."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter actual value or EPA's value of 0.067 $/kWh, per Ref.1, §1.5-Ex. Problem, page 1-58 (p58,pdf)."]
[null,null,null,null,null,null,"Utilities Specific Costs",null,null,null,null,null,null,null,null,"Note:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"User has the option to enter the local actual utilities values, instead of the default values."]
[]
[null,null,null,{"$f":"1+D137","v":41},null,null,null,"Electrical Power Cost",null,null,null,null,"Costelect.","$/kWh",null,6.7000000000000004E-2,"*",{"$f":"+IF(P143=6.7/100,\"default value\",IF(P143>0,\"actual value\",\"\"))","v":"default value"},null,{"$f":"IF(AND(P143=\"\",OR(P$22>0,P$24>0,P$29>0,P$31>0,P$32>0,P$41>0,P$42>0,P$43>0,P$46>0,P$49>0,P$52>0,P$56>0,P$62>0,P$64>0,P$66>0,P$74>0,P$75>0,P$78>0,P$80>0,P$84>0,P$85>0,P$88>0,P$89>0,P$90>0,P$146>0)),\"Error: An entry is required. Enter actual value or EPA's value of 0.067 $/kWh, per Ref.1, §1.5-Ex. Problem, page 1-58 (p58,pdf).\", \"Enter actual value or EPA's value of 0.067 $/kWh, per Ref.1, §1.5-Ex. Problem, page 1-58 (p58,pdf).\")","v":"Enter actual value or EPA's value of 0.067 $/kWh, per Ref.1, §1.5-Ex. Problem, page 1-58 (p58,pdf)."}]
[]
[]
[null,null,null,{"$f":"1+D143","v":42},null,null,null,"Water Consumption Cost",null,null,null,null,"Costwater","$/gal",null,6.4999999999999997E-3,"*",{"$f":"+IF(P146=6.5/1000,\"default value\",IF(P146>0,\"actual value\",\"\"))","v":"default value"},null,{"$f":"IF(AND(P146=\"\",OR(P$22>0,P$24>0,P$29>0,P$31>0,P$32>0,P$41>0,P$42>0,P$43>0,P$46>0,P$49>0,P$52>0,P$56>0,P$62>0,P$64>0,P$66>0,P$74>0,P$75>0,P$78>0,P$80>0,P$84>0,P$85>0,P$88>0,P$89>0,P$90>0,P$143>0)),\"Error: An entry is required. Enter actual value or EPA's value of 0.0065 $/gal, per Ref. 1, § 1.5-Ex. Problem, page1-58 (p58-pdf).\", \"Enter actual value or EPA's value of 0.0065 $/gal, per Ref. 1, § 1.5-Ex. Problem, page1-58 (p58-pdf).\")","v":"Enter actual value or EPA's value of 0.0065 $/gal, per Ref. 1, § 1.5-Ex. Problem, page1-58 (p58-pdf)."}]
[]
[null,null,null,null,null,null,"Reagent Costs"]
[null,null,null,{"$f":"1+D146","v":43},null,null,null,"29% Ammonia Solution Cost",null,null,null,null,"Cost29% NH₃","$/lb",null,0.47499999999999998,null,null,null,"Per Ref. 2, § 2.5 - Ex. Problem, page 2-80 (p81-pdf)."]
[null,null,null,{"$f":"1+D149","v":44},null,null,null,"50% Urea Solution Cost",null,null,null,null,"Cost50% urea","$/gal",null,1.62,null,null,null,"Per Ref. 1, § 1.5 - Ex. Problem, page1-58 (p58-pdf)."]
[]
[null,null,null,null,null,null,"Labor Costs"]
[null,null,null,{"$f":"1+D150","v":45},null,null,null,"Labor Rate",null,null,null,null,null,"$/hr",null,60,null,null,null,"The suggested rate is the operator labor cost, including benefits, per Ref. 2, § 2.5 & 2.6 - Example Problem(s) 1 and 2, page 2-80 (p81-pdf) and page 2-88 (p89-pdf)."]
[]
[]
[null,null,null,null,null,null,"Other Specifications"]
[null,null,null,{"$f":"1+D153","v":46},null,null,null,"NOx properties are provided as ",null,null,null,null,null,null,null,"NO₂",null,null,null,"Per Ref. 1, §1.3.1 - Design parameters for Study-Level Estimates, Uncontrolled NOx and Stack NOx, p1-36 (p36-pdf), and Ref. 2, § 2.3.4 - Inlet NOx and Stack NOx, page 2-54 (p55-pdf)."]
[]
[]
[]
[null,null,null,{"$f":"1+D157","v":47},null,null,null,"NOx (as NO₂) Molecular Weight",null,null,null,null,"MNOx","lb/mole",null,{"$f":"+VLOOKUP(MATCH(P157,c_id,0),cmp,tbl!$G$7,FALSE)","v":46.01},null,null,null,"Provided in eq. (1.18), Ref. 1, §1.3.1-Design parameters for Study-Level Estimates, Estimating Reagent Consumption and Tank Size, p1-41 (p41-pdf), and in eq. (2.35), Ref. 2, §2.3.13 - Estimating Reagent Consumption and Tank Size, p2-61 (p62-pdf). "]

{"sheet":"Report","index":4,"n_rows":67,"n_cols":26,"rows_kept":67,"cut":false,"hidden":false,"merged":[[66,9,66,11],[61,12,62,12],[65,12,66,12],[61,13,62,13],[65,13,66,13],[50,9,50,11],[51,9,51,11],[55,9,55,11],[56,9,56,11],[64,15,64,17],[62,9,62,11],[64,19,64,21],[64,23,64,25],[29,15,29,17],[29,19,29,21],[29,23,29,25],[60,15,60,17],[30,15,31,15],[30,17,31,17],[30,25,31,25],[30,23,31,23],[30,21,31,21],[30,19,31,19],[60,19,60,21],[60,23,60,25],[4,23,4,24],[5,23,5,24],[10,23,10,24],[12,19,13,26],[16,15,16,17],[8,10,9,23],[25,19,26,26],[10,14,10,16],[12,3,13,3],[12,5,13,10],[12,12,13,12],[12,13,13,13],[12,15,13,17],[24,15,24,17],[24,19,24,26],[18,15,18,17],[19,15,19,17],[20,15,20,17]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revision:",null,"00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev. Date:",null,"2016-08-31"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"AIR POLLUTION CONTROLS COST EFFECTIVENESS ASSESSMENT \nFOR USE WITH RCSA SECTION 22a-174-22e(h)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REPORT"]
[]
[null,null,null,null,null,"Item Description",null,null,null,null,null,null,null,null,null,"Input",null,null,null,"Comments"]
[]
[]
[null,null,null,null,null,null,"Emission Unit ID"]
[null,null,null,null,null,null,null,"Owner/Operator",null,null,null,null,null,null,null,{"$f":"+IF('Data Entry'!P22=\"\",\"\",'Data Entry'!P22)","v":""}]
[null,null,null,null,null,null,null,"Owner/Operator Initials",null,null,null,null,null,null,null,{"$f":"+IF('Data Entry'!P23=\"\",\"\",'Data Entry'!P23)","v":""}]
[null,null,null,null,null,null,null,"Facility Name",null,null,null,null,null,null,null,{"$f":"+IF('Data Entry'!P24=\"\",\"\",'Data Entry'!P24)","v":""}]
[null,null,null,null,null,null,null,"Town",null,null,null,null,null,null,null,{"$f":"+IF('Data Entry'!P25=\"\",\"\",'Data Entry'!P25)","v":""}]
[null,null,null,null,null,null,null,"DEEP Permit/Registration No.",null,null,null,null,null,null,null,{"$f":"+IF('Data Entry'!P26=\"\",\"\",'Data Entry'!P26)","v":""}]
[null,null,null,null,null,null,null,"Town Code",null,null,null,null,null,null,null,{"$f":"+IF('Data Entry'!P27=\"\",\"\",'Data Entry'!P27)","v":""},null,null,null,"DEEP emission unit permit or registration."]
[null,null,null,null,null,null,null,"Premises No.",null,null,null,null,null,null,null,{"$f":"+IF('Data Entry'!P28=\"\",\"\",'Data Entry'!P28)","v":""},null,null,null,"DEEP emission unit permit or registration."]
[null,null,null,null,null,null,null,"Unit Tag",null,null,null,null,null,null,null,{"$f":"+IF('Data Entry'!P31=\"\",\"\",'Data Entry'!P31)","v":""},null,null,null,"Emission unit tag."]
[null,null,null,null,null,null,null,"Unit Type",null,null,null,null,null,null,null,{"$f":"+IF('Data Entry'!P32=\"\",\"\",'Data Entry'!P32)","v":""}]
[null,null,null,null,null,null,null,"No identical Units w/ same controls",null,null,null,null,null,null,null,{"$f":"+IF('Data Entry'!P34=\"\",\"\",'Data Entry'!P34)","v":""},null,null,null,"Number of identical units at the same location with the same of air pollution control. \nNote: Control Cost Effectiveness assesment is performed for a single emission unit."]
[]
[]
[]
[null,null,null,null,null,null,null,"Control Type",null,null,null,null,null,null,null,{"$f":"+IF(SCR!P30=\"\",IF(SNCR!P30=\"\",IF(HPWI!P30=\"\",\"\",HPWI!P30),SNCR!P30),SCR!P30)","v":""},null,null,null,{"$f":"+IF(P30=\"SNCR\",IF(P30=\"HPWI\",\"\",IF(HPWI!P30=\"\",\"\",HPWI!P30)),IF(SNCR!P30=\"\",IF(P30=\"HPWI\",\"\",IF(HPWI!P30=\"\",\"\",HPWI!P30)),SNCR!P30))","v":""},null,null,null,{"$f":"+IF(OR(P30=\"HPWI\",T30=\"HPWI\"),\"\",IF(HPWI!P30=\"\",\"\",HPWI!P30))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(P30=\"SCR\",SCR!$P22,IF(P30=\"SNCR\",SNCR!$P22,IF(P30=\"HPWI\",HPWI!$P22,\"\")))","v":""},null,{"$f":"+IF('Data Entry'!R111=\"\",\"\",\"Limited Operation\")","v":""},null,{"$f":"+IF(T30=\"SCR\",SCR!$P22,IF(T30=\"SNCR\",SNCR!$P22,IF(T30=\"HPWI\",HPWI!$P22,\"\")))","v":""},null,{"$f":"+IF(V34=\"\",\"\",\"Limited Operation\")","v":""},null,{"$f":"+IF(X30=\"SCR\",SCR!$P22,IF(X30=\"SNCR\",SNCR!$P22,IF(X30=\"HPWI\",HPWI!$P22,\"\")))","v":""},null,{"$f":"+IF(Z34=\"\",\"\",\"Limited Operation\")","v":""}]
[]
[]
[null,null,null,null,null,null,null,"Control Operating Time",null,null,null,null,"top, control","hrs",null,{"$f":"+IF(P$30=\"SCR\",SCR!$P36,IF(P$30=\"SNCR\",SNCR!$P36,IF(P$30=\"HPWI\",HPWI!$P36,\"\")))","v":""},null,{"$f":"+IF(P$30=\"SCR\",SCR!$R36,IF(P$30=\"SNCR\",SNCR!$R36,IF(P$30=\"HPWI\",HPWI!$R36,\"\")))","v":""},null,{"$f":"+IF(T$30=\"SNCR\",SNCR!$P36,IF(T$30=\"HPWI\",HPWI!$P36,\"\"))","v":""},null,{"$f":"IF(T$30=\"SNCR\",SNCR!$R36,IF(T$30=\"HPWI\",HPWI!$R36,\"\"))","v":""},null,{"$f":"+IF(X$30=\"HPWI\",HPWI!$P36,\"\")","v":""},null,{"$f":"IF(X$30=\"HPWI\",HPWI!$R36,\"\")","v":""}]
[]
[null,null,null,null,null,null,null,"Control Nominal Efficiency (default value)",null,null,null,null,"h NOxR","%",null,{"$f":"+IF(P$30=\"SCR\",SCR!$P43,IF(P$30=\"SNCR\",SNCR!$P38,IF(P$30=\"HPWI\",HPWI!$P38,\"\")))","v":""},null,{"$f":"+IF(P$30=\"SCR\",SCR!$R43,IF(P$30=\"SNCR\",SNCR!$R38,IF(P$30=\"HPWI\",HPWI!$R38,\"\")))","v":""},null,{"$f":"IF(T$30=\"SNCR\",SNCR!$P38,IF(T$30=\"HPWI\",HPWI!$P38,\"\"))","v":""},null,{"$f":"IF(T$30=\"SNCR\",SNCR!$R38,IF(T$30=\"HPWI\",HPWI!$R38,\"\"))","v":""},null,{"$f":"+IF(X$30=\"HPWI\",HPWI!$P38,\"\")","v":""},null,{"$f":"IF(X$30=\"HPWI\",HPWI!$R38,\"\")","v":""}]
[null,null,null,null,null,null,null,"Control Lowest Attained NOxout Rate",null,null,null,null,"NOxout, min","lb/MMBtu",null,{"$f":"+IF(P$30=\"SCR\",SCR!$P47,IF(P$30=\"SNCR\",SNCR!$P43,IF(P$30=\"HPWI\",HPWI!$P41,\"\")))","v":""},null,{"$f":"+IF(P$30=\"SCR\",SCR!$R47,IF(P$30=\"SNCR\",SNCR!$R43,IF(P$30=\"HPWI\",HPWI!$R41,\"\")))","v":""},null,{"$f":"IF(T$30=\"SNCR\",SNCR!$P43,IF(T$30=\"HPWI\",HPWI!$P41,\"\"))","v":""},null,{"$f":"IF(T$30=\"SNCR\",SNCR!$R43,IF(T$30=\"HPWI\",HPWI!$R41,\"\"))","v":""},null,{"$f":"IF(X$30=\"HPWI\",HPWI!$P41,\"\")","v":""},null,{"$f":"IF(X$30=\"HPWI\",HPWI!$R41,\"\")","v":""}]
[]
[null,null,null,null,null,null,"NOx Removal Performance"]
[null,null,null,null,null,null,null,"Uncontrolled NOx Emission Level",null,null,null,null,"NOxin","lb/MMBtu",null,{"$f":"+IF(P$30=\"SCR\",SCR!$P178,IF(P$30=\"SNCR\",SNCR!$P154,IF(P$30=\"HPWI\",HPWI!$P119,\"\")))","v":""},null,{"$f":"+IF(P$30=\"SCR\",SCR!$R178,IF(P$30=\"SNCR\",SNCR!$R154,IF(P$30=\"HPWI\",HPWI!$R119,\"\")))","v":""},null,{"$f":"IF(T$30=\"SNCR\",SNCR!$P154,IF(T$30=\"HPWI\",HPWI!$P119,\"\"))","v":""},null,{"$f":"IF(T$30=\"SNCR\",SNCR!$R154,IF(T$30=\"HPWI\",HPWI!$R119,\"\"))","v":""},null,{"$f":"IF(X$30=\"HPWI\",HPWI!$P119,\"\")","v":""},null,{"$f":"+IF(X$30=\"HPWI\",HPWI!$R119,\"\")","v":""}]
[null,null,null,null,null,null,null,"Controlled NOx Outlet (required rate)",null,null,null,null,"NOxout","lb/MMBtu",null,{"$f":"+IF(P$30=\"SCR\",SCR!$P180,IF(P$30=\"SNCR\",SNCR!$P156,IF(P$30=\"HPWI\",HPWI!$P121,\"\")))","v":""},null,{"$f":"+IF(P$30=\"SCR\",SCR!$R180,IF(P$30=\"SNCR\",SNCR!$R156,IF(P$30=\"HPWI\",HPWI!$R121,\"\")))","v":""},null,{"$f":"IF(T$30=\"SNCR\",SNCR!$P156,IF(T$30=\"HPWI\",HPWI!$P121,\"\"))","v":""},null,{"$f":"IF(T$30=\"SNCR\",SNCR!$R156,IF(T$30=\"HPWI\",HPWI!$R121,\"\"))","v":""},null,{"$f":"IF(X$30=\"HPWI\",HPWI!$P121,\"\")","v":""},null,{"$f":"IF(X$30=\"HPWI\",HPWI!$R121,\"\")","v":""}]
[null,null,null,null,null,null,null,"Controlled NOx Outlet (selected)",null,null,null,null,"NOxout,sel","lb/MMBtu",null,{"$f":"+IF(P$30=\"SCR\",SCR!$P183,IF(P$30=\"SNCR\",SNCR!$P159,IF(P$30=\"HPWI\",HPWI!$P124,\"\")))","v":""},null,{"$f":"+IF(P$30=\"SCR\",SCR!$R183,IF(P$30=\"SNCR\",SNCR!$R159,IF(P$30=\"HPWI\",HPWI!$R124,\"\")))","v":""},null,{"$f":"+IF(T$30=\"SNCR\",SNCR!$P159,IF(T$30=\"HPWI\",HPWI!$P124,\"\"))","v":""},null,{"$f":"IF(T$30=\"SNCR\",SNCR!$R159,IF(T$30=\"HPWI\",HPWI!$R124,\"\"))","v":""},null,{"$f":"IF(X$30=\"HPWI\",HPWI!$P124,\"\")","v":""},null,{"$f":"IF(X$30=\"HPWI\",HPWI!$R124,\"\")","v":""}]
[null,null,null,null,null,null,null,"NOx Removal Efficiency\n(selected)",null,null,null,null,"h NOxR,sel","%",null,{"$f":"+IF(P$30=\"SCR\",SCR!$P186,IF(P$30=\"SNCR\",SNCR!$P162,IF(P$30=\"HPWI\",HPWI!$P127,\"\")))","v":""},null,{"$f":"+IF(P$30=\"SCR\",SCR!$R186,IF(P$30=\"SNCR\",SNCR!$R162,IF(P$30=\"HPWI\",HPWI!$R127,\"\")))","v":""},null,{"$f":"IF(T$30=\"SNCR\",SNCR!$P162,IF(T$30=\"HPWI\",HPWI!$P127,\"\"))","v":""},null,{"$f":"IF(T$30=\"SNCR\",SNCR!$R162,IF(T$30=\"HPWI\",HPWI!$R127,\"\"))","v":""},null,{"$f":"IF(X$30=\"HPWI\",HPWI!$P127,\"\")","v":""},null,{"$f":"IF(X$30=\"HPWI\",HPWI!$R127,\"\")","v":""}]
[null,null,null,null,null,null,null,"NOx Removed Hourly Rate",null,null,null,null,"NOxR/hr","lb/hr",null,{"$f":"+IF(P$30=\"SCR\",SCR!$P192,IF(P$30=\"SNCR\",SNCR!$P166,IF(P$30=\"HPWI\",HPWI!$P132,\"\")))","v":""},null,{"$f":"+IF(P$30=\"SCR\",SCR!$R192,IF(P$30=\"SNCR\",SNCR!$R166,IF(P$30=\"HPWI\",HPWI!$R132,\"\")))","v":""},null,{"$f":"IF(T$30=\"SNCR\",SNCR!$P166,IF(T$30=\"HPWI\",HPWI!$P132,\"\"))","v":""},null,{"$f":"IF(T$30=\"SNCR\",SNCR!$R166,IF(T$30=\"HPWI\",HPWI!$R132,\"\"))","v":""},null,{"$f":"IF(X$30=\"HPWI\",HPWI!$P132,\"\")","v":""},null,{"$f":"IF(X$30=\"HPWI\",HPWI!$R132,\"\")","v":""}]
[null,null,null,null,null,null,null,"NOx Removed / yr",null,null,null,null,"NOxR","tons",null,{"$f":"+IF(P$30=\"SCR\",SCR!$P195,IF(P$30=\"SNCR\",SNCR!$P169,IF(P$30=\"HPWI\",HPWI!$P135,\"\")))","v":""},null,{"$f":"+IF(P$30=\"SCR\",SCR!$R195,IF(P$30=\"SNCR\",SNCR!$R169,IF(P$30=\"HPWI\",HPWI!$R135,\"\")))","v":""},null,{"$f":"IF(T$30=\"SNCR\",SNCR!$P169,IF(T$30=\"HPWI\",HPWI!$P135,\"\"))","v":""},null,{"$f":"IF(T$30=\"SNCR\",SNCR!$R169,IF(T$30=\"HPWI\",HPWI!$R135,\"\"))","v":""},null,{"$f":"IF(X$30=\"HPWI\",HPWI!$P135,\"\")","v":""},null,{"$f":"IF(X$30=\"HPWI\",HPWI!$R135,\"\")","v":""}]
[]
[null,null,null,null,null,"Total Capital Investment (TCI) Estimate"]
[null,null,null,null,null,null,"Total Capital Investment",null,null,null,null,null,"TCI2012$","2012$",null,{"$f":"+IF(P$30=\"SCR\",SCR!$P280,IF(P$30=\"SNCR\",SNCR!$P241,IF(P$30=\"HPWI\",HPWI!$P183,\"\")))","v":""},null,{"$f":"+IF(P$30=\"SCR\",SCR!$R280,IF(P$30=\"SNCR\",SNCR!$R241,IF(P$30=\"HPWI\",HPWI!$R183,\"\")))","v":""},null,{"$f":"IF(T$30=\"SNCR\",SNCR!$P241,IF(T$30=\"HPWI\",HPWI!$P183,\"\"))","v":""},null,{"$f":"+IF(T$30=\"SNCR\",SNCR!$R241,IF(T$30=\"HPWI\",HPWI!$R183,\"\"))","v":""},null,{"$f":"IF(X$30=\"HPWI\",HPWI!$P183,\"\")","v":""},null,{"$f":"IF(X$30=\"HPWI\",HPWI!$R183,\"\")","v":""}]
[]
[null,null,null,null,null,"Annual Costs"]
[null,null,null,null,null,null,"Direct Annual Cost",null,null,{"$f":"+IF(P30=\"SCR\",\"Method 1\",\"\")","v":""},null,null,{"$f":"+IF(P30=\"SCR\",\"DAC1\",\"DAC\")","v":"DAC"},"$/yr",null,{"$f":"+IF(P$30=\"SCR\",SCR!$P313,IF(P$30=\"SNCR\",SNCR!$P265,IF(P$30=\"HPWI\",HPWI!$P212,\"\")))","v":""},null,{"$f":"+IF(P$30=\"SCR\",SCR!$R313,IF(P$30=\"SNCR\",SNCR!$R265,IF(P$30=\"HPWI\",HPWI!$R212,\"\")))","v":""},null,{"$f":"IF(T$30=\"SNCR\",SNCR!$P265,IF(T$30=\"HPWI\",HPWI!$P212,\"\"))","v":""},null,{"$f":"+IF(T$30=\"SNCR\",SNCR!$R265,IF(T$30=\"HPWI\",HPWI!$R212,\"\"))","v":""},null,{"$f":"IF(X$30=\"HPWI\",HPWI!$P212,\"\")","v":""},null,{"$f":"IF(X$30=\"HPWI\",HPWI!$R212,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"+IF(P30=\"SCR\",\"Method 2 (SCR only)\",\"\")","v":""},null,null,{"$f":"+IF(P30=\"SCR\",\"DAC2\",\"\")","v":""},"$/yr",null,{"$f":"+IF(P$30=\"SCR\",SCR!$P314,\"\")","v":""},null,{"$f":"+IF(P$30=\"SCR\",SCR!$R314,\"\")","v":""}]
[]
[null,null,null,null,null,null,"Indirect Annual Cost",null,null,null,null,null,"IDAC","$/yr",null,{"$f":"+IF(P$30=\"SCR\",SCR!$P321,IF(P$30=\"SNCR\",SNCR!$P272,IF(P$30=\"HPWI\",HPWI!$P221,\"\")))","v":""},null,{"$f":"+IF(P$30=\"SCR\",SCR!$R321,IF(P$30=\"SNCR\",SNCR!$R272,IF(P$30=\"HPWI\",HPWI!$R221,\"\")))","v":""},null,{"$f":"IF(T$30=\"SNCR\",SNCR!$P272,IF(T$30=\"HPWI\",HPWI!$P221,\"\"))","v":""},null,{"$f":"IF(T$30=\"SNCR\",SNCR!$R272,IF(T$30=\"HPWI\",HPWI!$R221,\"\"))","v":""},null,{"$f":"IF(X$30=\"HPWI\",HPWI!$P221,\"\")","v":""},null,{"$f":"IF(X$30=\"HPWI\",HPWI!$R221,\"\")","v":""}]
[]
[null,null,null,null,null,null,"Total Annual Cost",null,null,{"$f":"+IF(P30=\"SCR\",\"Method 1\",\"\")","v":""},null,null,{"$f":"+IF(P30=\"SCR\",\"TAC1\",\"TAC\")","v":"TAC"},"$/yr",null,{"$f":"+IF(P$30=\"SCR\",SCR!$P324,IF(P$30=\"SNCR\",SNCR!$P275,IF(P$30=\"HPWI\",HPWI!$P223,\"\")))","v":""},null,{"$f":"+IF(P$30=\"SCR\",SCR!$R324,IF(P$30=\"SNCR\",SNCR!$R275,IF(P$30=\"HPWI\",HPWI!$R223,\"\")))","v":""},null,{"$f":"IF(T$30=\"SNCR\",SNCR!$P275,IF(T$30=\"HPWI\",HPWI!$P223,\"\"))","v":""},null,{"$f":"IF(T$30=\"SNCR\",SNCR!$R275,IF(T$30=\"HPWI\",HPWI!$R223,\"\"))","v":""},null,{"$f":"+IF(X$30=\"HPWI\",HPWI!$P223,\"\")","v":""},null,{"$f":"IF(X$30=\"HPWI\",HPWI!$R223,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"+IF(P30=\"SCR\",\"Method 2 (SCR only)\",\"\")","v":""},null,null,{"$f":"+IF(P30=\"SCR\",\"TAC2\",\"\")","v":""},"$/yr",null,{"$f":"+IF(P$30=\"SCR\",SCR!$P326,\"\")","v":""},null,{"$f":"+IF(P$30=\"SCR\",SCR!$R326,\"\")","v":""}]
[]
[null,null,null,null,null,"Control Cost Effectiveness (2012$)"]
[]
[null,null,null,null,null,null,"Base Year",null,null,null,null,null,null,null,null,{"$f":"+IF(P$30=\"SCR\",SCR!$P332,IF(P$30=\"SNCR\",SNCR!$P282,IF(P$30=\"HPWI\",HPWI!$P229,\"\")))","v":""},null,null,null,{"$f":"+IF(T$30=\"SNCR\",SNCR!$P282,IF(T$30=\"HPWI\",HPWI!$P229,\"\"))","v":""},null,null,null,{"$f":"IF(X$30=\"HPWI\",HPWI!$P229,\"\")","v":""}]
[null,null,null,null,null,null,null,"Cost Effectiveness",null,{"$f":"+IF(P30=\"SCR\",\"Method 1\",\"\")","v":""},null,null,"Costeffect,$2012","2012$/ton NOxR",null,{"$f":"+IF(P$30=\"SCR\",SCR!$P333,IF(P$30=\"SNCR\",SNCR!$P283,IF(P$30=\"HPWI\",HPWI!$P230,\"\")))","v":""},null,{"$f":"+IF(P$30=\"SCR\",SCR!$R333,IF(P$30=\"SNCR\",SNCR!$R283,IF(P$30=\"HPWI\",HPWI!$R230,\"\")))","v":""},null,{"$f":"IF(T$30=\"SNCR\",SNCR!$P283,IF(T$30=\"HPWI\",HPWI!$P230,\"\"))","v":""},null,{"$f":"IF(T$30=\"SNCR\",SNCR!$R283,IF(T$30=\"HPWI\",HPWI!$R230,\"\"))","v":""},null,{"$f":"+IF(X$30=\"HPWI\",HPWI!$P230,\"\")","v":""},null,{"$f":"IF(X$30=\"HPWI\",HPWI!$R230,\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(P30=\"SCR\",H62,\"\")","v":""},null,{"$f":"+IF(P30=\"SCR\",\"Method 2 (SCR only)\",\"\")","v":""},null,null,null,null,null,{"$f":"+IF(P$30=\"SCR\",SCR!$P334,\"\")","v":""},null,{"$f":"+IF(P$30=\"SCR\",SCR!$R334,\"\")","v":""}]
[]
[null,null,null,null,null,null,"Year Control is effective",null,null,null,null,null,null,null,null,{"$f":"+IF(P$30=\"SCR\",SCR!$P336,IF(P$30=\"SNCR\",SNCR!$P286,IF(P$30=\"HPWI\",HPWI!$P233,\"\")))","v":""},null,null,null,{"$f":"IF(T$30=\"SNCR\",SNCR!$P286,IF(T$30=\"HPWI\",HPWI!$P233,\"\"))","v":""},null,null,null,{"$f":"+IF(X$30=\"HPWI\",HPWI!$P233,\"\")","v":""}]
[null,null,null,null,null,null,null,"Cost Effectiveness",null,{"$f":"+IF(P30=\"SCR\",\"Method 1\",\"\")","v":""},null,null,"Costeffect,yr","$/ton NOxR",null,{"$f":"+IF(P$30=\"SCR\",SCR!$P337,IF(P$30=\"SNCR\",SNCR!$P287,IF(P$30=\"HPWI\",HPWI!$P234,\"\")))","v":""},null,{"$f":"+IF(P$30=\"SCR\",SCR!$R337,IF(P$30=\"SNCR\",SNCR!$R287,IF(P$30=\"HPWI\",HPWI!$R234,\"\")))","v":""},null,{"$f":"IF(T$30=\"SNCR\",SNCR!$P287,IF(T$30=\"HPWI\",HPWI!$P234,\"\"))","v":""},null,{"$f":"IF(T$30=\"SNCR\",SNCR!$R287,IF(T$30=\"HPWI\",HPWI!$R234,\"\"))","v":""},null,{"$f":"IF(X$30=\"HPWI\",HPWI!$P234,\"\")","v":""},null,{"$f":"+IF(X$30=\"HPWI\",HPWI!$R234,\"\")","v":""}]
[null,null,null,null,null,null,null,"Cost Effectiveness",null,{"$f":"+IF(P30=\"SCR\",\"Method 2 (SCR only)\",\"\")","v":""},null,null,null,null,null,{"$f":"+IF(P$30=\"SCR\",SCR!$P338,\"\")","v":""},null,{"$f":"+IF(P$30=\"SCR\",SCR!$R338,\"\")","v":""}]

{"sheet":"SCR","index":5,"n_rows":338,"n_cols":27,"rows_kept":338,"cut":false,"hidden":false,"merged":[[325,19,326,26],[203,19,204,26],[205,19,206,26],[207,19,208,26],[210,19,211,26],[251,19,254,26],[285,19,287,26],[215,19,216,26],[218,19,219,26],[266,15,266,19],[267,15,267,26],[19,3,22,3],[103,19,104,26],[115,19,119,26],[160,19,161,26],[57,19,58,26],[112,15,112,17],[80,19,81,26],[59,19,61,26],[68,19,69,26],[71,19,72,26],[125,19,126,26],[25,19,26,26],[172,7,173,10],[172,19,175,26],[152,19,156,26],[121,19,123,26],[163,7,164,10],[142,15,142,17],[130,19,131,26],[133,19,135,26],[142,19,145,26],[163,19,164,26],[11,19,12,26],[8,10,9,15],[116,7,117,10],[46,19,47,26],[19,15,19,17],[21,15,22,15],[21,17,22,17],[15,19,16,26],[19,5,22,10],[19,12,22,12],[19,13,22,13],[19,19,22,26],[80,13,81,13],[37,19,38,26],[83,19,84,26],[87,19,88,26],[331,15,331,17],[335,15,335,17],[336,19,337,26],[272,19,273,26],[332,19,333,26],[275,19,277,26],[304,19,305,26],[294,19,296,26],[289,19,292,26],[320,19,321,26],[300,19,302,26],[307,19,308,26],[309,19,310,26],[312,19,314,26],[323,19,324,26],[279,19,281,26],[13,19,14,26],[42,19,44,26],[49,19,50,26],[55,19,56,26],[264,15,264,17],[185,19,186,26],[147,19,151,26],[128,19,129,26],[167,19,168,26],[179,19,180,26],[188,19,189,26],[199,19,200,26],[201,19,202,26],[196,19,197,26],[182,19,183,26],[29,19,31,26]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revision:","02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev. Date:","2016-08-31"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"AIR POLLUTION CONTROL COST EFFECTIVENESS ASSESSMENT \nFOR USE WITH RCSA SECTION 22a-174-22e(h)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"References:",1,"EPA Air Pollution Control Cost Manual - Seventh Edition, Section 4 - NOx Controls: \nChapter 2 - Selective Catalytic Reduction, May 2016."]
[]
[null,null,null,null,null,null,null,null,null,null,"SELECTIVE CATALYTIC REDUCTION - SCR",null,null,null,null,null,null,null,{"$f":"1+S12","v":2},"EPA Air Pollution Control Cost Manual - Sixth Edition (EPA 452/B-02-001), January 2002."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+S14","v":3},"Alternative Control Techniques Document - NOx Emissions from Stationary Gas Turbines - EPA ACT Document No.:  EPA-453/R-93-007."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+S16","v":4},"U.S Department of Labor - Bureau of Labor Statistics: CPI Inflation Calculator."]
[]
[null,null,null,"Line",null,"Item Description",null,null,null,null,null,null,"Symbol","Units",null,"Input",null,null,null,"Comments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Column 1.",null,"Column 2."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Default Operation",null,"Limited Operation"]
[]
[]
[null,null,null,null,"SCR ASSUMPTIONS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF('Data Entry'!P41=\"Yes\",\"\",\"Note:\")","v":"Note:"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF('Data Entry'!P41=\"Yes\",\"\",\"Select SCR on Data Entry, Line 13, in order to see control cost effectiveness calculation.\")","v":"Select SCR on Data Entry, Line 13, in order to see control cost effectiveness calculation."}]
[null,null,null,null,"I.","Air Pollution Control Assumptions"]
[]
[null,null,null,null,null,null,"Control Unit Specifications"]
[null,null,null,1,null,null,null,"Control Type",null,null,null,null,null,null,null,{"$f":"+IF('Data Entry'!P41=\"Yes\",IF(OR('Data Entry'!P56=\"\",'Data Entry'!P78=\"\",'Data Entry'!P80=\"\"),\"\",IF(OR('Data Entry'!P$22=\"\",'Data Entry'!P$24=\"\",'Data Entry'!P$29=\"\",'Data Entry'!P$31=\"\",'Data Entry'!P$32=\"\",'Data Entry'!P$41=\"\",AND('Data Entry'!P$46=\"\",'Data Entry'!P$49=\"\"),'Data Entry'!P$52=\"\",'Data Entry'!P$56=\"\",'Data Entry'!P$62=\"\",'Data Entry'!P$64=\"\",'Data Entry'!P$66=\"\",'Data Entry'!P$74=\"\",'Data Entry'!P$75=\"\",'Data Entry'!P$78=\"\",'Data Entry'!P$80=\"\",'Data Entry'!P$84=\"\",'Data Entry'!P$85=\"\",'Data Entry'!P$88=\"\",'Data Entry'!P$143=\"\",'Data Entry'!P$146=\"\"),\"\",IF(LEFT('Data Entry'!T56,5)=\"Error\",\"\",\"SCR\"))),\"\")","v":""},null,{"$f":"+IF(P30=\"\",\"\",IF(AND('Data Entry'!P41=\"Yes\",'Data Entry'!R111>0),\"SCR\",\"\"))","v":""},null,{"$f":"IF(AND('Data Entry'!P41=\"Yes\",OR('Data Entry'!P$22=\"\",'Data Entry'!P$24=\"\",'Data Entry'!P$29=\"\",'Data Entry'!P$31=\"\",'Data Entry'!P$32=\"\",AND('Data Entry'!P$46=\"\",'Data Entry'!P$49=\"\"),'Data Entry'!P$52=\"\",'Data Entry'!P$56=\"\",'Data Entry'!P$62=\"\",'Data Entry'!P$64=\"\",'Data Entry'!P$66=\"\",'Data Entry'!P$74=\"\",'Data Entry'!P$75=\"\",'Data Entry'!P$78=\"\",'Data Entry'!P$80=\"\",'Data Entry'!P$84=\"\",'Data Entry'!P$85=\"\",'Data Entry'!P$88=\"\",'Data Entry'!P$143=\"\",'Data Entry'!P$146=\"\")),\"Error: Check Data Entry page and ensure that SCR is selected on Line 13 and all other required fields are specified. \",IF(AND('Data Entry'!P41=\"Yes\",'Data Entry'!R111>0),\"SCR cost effectiveness calculation is displayed down the column, for both ''Default Operation'' and ''Limited Operation''.\",\"SCR cost effectiveness calculation is displayed down the column, for ''Default Operation''. To show calculation on ''Limited Operation'' column, enter no. of hours on Data Entry page, Line 33, Column 2, otherwise the entire column is blank.\"))","v":"SCR cost effectiveness calculation is displayed down the column, for ''Default Operation''. To show calculation on ''Limited Operation'' column, enter no. of hours on Data Entry page, Line 33, Column 2, otherwise the entire column is blank."}]
[]
[]
[]
[null,null,null,{"$f":"1+D30","v":2},null,null,null,"Number of SCRs per Combustion Unit",null,null,null,null,"NSCR",null,null,{"$f":"+IF(P$30=\"SCR\",1,\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",1,\"\")","v":""},null,"Selected design criteria: one SCR system per emission unit."]
[]
[null,null,null,{"$f":"1+D34","v":3},null,null,null,"SCR Operating Time",null,null,null,null,"top, control","hrs",null,{"$f":"+IF(P$30=\"SCR\",'Data Entry'!P114,\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",'Data Entry'!R114,\"\")","v":""},null,"Air Pollution Control Annual Hrs of Operation, as entered on Data Entry, Line 34."]
[]
[null,null,null,{"$f":"1+D36","v":4},null,null,null,"SCR Configuration",null,null,null,null,null,null,null,{"$f":"+IF(P$30=\"SCR\",\"High-Dust\",\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",\"High-Dust\",\"\")","v":""},null,"Configuration of the majority of SCR's (88%) reported in 1997, per Ref. 1, § 2.2.3 - SCR System Configurations, page 2-29 (p30-pdf)."]
[]
[]
[null,null,null,{"$f":"1+D38","v":5},null,null,null,"SCR Temperature Inlet (Default)",null,null,null,null,"Tin ","ºF",null,{"$f":"+IF(P$30=\"SCR\",700,\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",700,\"\")","v":""},null,"Selected default value of SCR Temperature Inlet."]
[]
[null,null,null,{"$f":"1+D41","v":6},null,null,null,"SCR Removal Efficiency at selected Tin",null,null,null,null,"h NOxR","%",null,{"$f":"+IF(P$30=\"SCR\",90%,\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",90%,\"\")","v":""},null,"SCR Efficiency at 700ºF, per Ref. 1, Fig. 2.2 - NOx Removal vs. Temperature, page 2-17 (p18-pdf). Selected efficiency may be adjusted if the calculated NOxout value falls below the SCR attainable limit."]
[]
[]
[]
[null,null,null,{"$f":"1+D43","v":7},null,null,null,"SCR Lowest Attained NOxout Rate",null,null,null,null,"NOxout, min","lb/MMBtu",null,{"$f":"+IF(P$30=\"SCR\",0.04,\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",0.04,\"\")","v":""},null,"Lowest attainable value suggested in EPA's Clean Air Markets Division (CAMD) database, per Ref. 1, § 2.1- Introduction, footnote #2, page 2-2 (p3-pdf)."]
[]
[null,null,null,null,null,null,"Catalyst Design Specifications"]
[null,null,null,{"$f":"1+D47","v":8},null,null,null,"Min. Number of Layers",null,null,null,null,null,null,null,{"$f":"+IF(P$30=\"SCR\",2,\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",2,\"\")","v":""},null,"Min. two layers required, per Ref. 1, § 2.3.12 - SCR Reactor Dimensions, page 2-60 (p61 pdf)."]
[]
[]
[null,null,null,{"$f":"1+D50","v":9},null,null,null,"Catalyst Layers Ratio",null,null,null,null,"Full/Empty",null,null,{"$f":"+IF(P$30=\"SCR\",2,\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",2,\"\")","v":""},null,"Two full, one empty layer ratio, per Ref. 2, §2.5 Ex. Problem, p2-50 (p.54-pdf)."]
[]
[null,null,null,null,null,null,null,"Flue Gas Superficial Velocity"]
[null,null,null,{"$f":"1+D53","v":10},null,null,null,null,"Recommended",null,null,null,"vsuperficial","ft/sec",null,{"$f":"+IF(P$30=\"SCR\",16,\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",16,\"\")","v":""},null,"Typical flue gas face velocity, per Ref. 1, § 2.3.12-SCR Reactor Dimensions, \npage 2-59 (p60-pdf). "]
[]
[null,null,null,{"$f":"1+D56","v":11},null,null,null,null,"Selected",null,null,null,"vsuperficial, sel","ft/sec",null,{"$f":"+P56","v":""},null,{"$f":"+IF(R56=\"\",\"\",P58)","v":""},null,{"$f":"+IF(OR(AND(P$30=\"SCR\",P58=\"\"),AND(R$30=\"SCR\",R58=\"\")), \"Error: Select a face velocity. Default value = 16 ft/sec\", \"Line 10 value. Selected value may be changed if the resulting catalyst height is out of range. Field allows a new entry value, if necessary.\")","v":"Line 10 value. Selected value may be changed if the resulting catalyst height is out of range. Field allows a new entry value, if necessary."}]
[]
[null,null,null,{"$f":"1+D58","v":12},null,null,null,"Aspect Ratio Cross-sectional Area",null,null,null,null,"l / w",null,null,{"$f":"+IF(P$30=\"SCR\",1,\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",1,\"\")","v":""},null,"Cross-sectional area assumed square, length (l) = width (w), hence l / w = 1. Industry standard aspect ratios are between 1.0 - 1.5, per Ref. 1, § 2.3.12 - SCR Reactor Dim's., p2-59 (p60 pdf)."]
[]
[]
[]
[null,null,null,{"$f":"1+D60","v":13},null,null,null,"Catalyst Layer's Height Range",null,null,null,null,"hlayer","ft",null,{"$f":"+IF(P$30=\"SCR\",\"2.5-5.0\",\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",\"2.5-5.0\",\"\")","v":""},null,"Standard industry range, per Ref. 1, § 2.3.12 - SCR Reactor Dim's, p2-60 (p61 pdf)."]
[]
[null,null,null,{"$f":"1+D64","v":14},null,null,null,"Nominal Height of Catalyst Layer",null,null,null,null,"h´layer","ft",null,{"$f":"+IF(P$30=\"SCR\",3.1,\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",3.1,\"\")","v":""},null,"Nom.height, per Ref. 1, § 2.3.12 -SCR Reactor Dim's, footnote #23, p2-60 (p61 pdf)."]
[]
[null,null,null,null,null,null,null,"Catalyst Additional Height Clearance"]
[null,null,null,{"$f":"1+D66","v":15},null,null,null,null,"Catalyst Layer Clearance",null,null,null,"c1","ft",null,{"$f":"+IF(P$30=\"SCR\",7,\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",7,\"\")","v":""},null,"Both c1 and c2 clearances are based on common industry practice, per Ref. 1, \n§ 2.3.12 - SCR Reactor Dimensions, page 2-61 (p62 pdf)."]
[null,null,null,{"$f":"1+D69","v":16},null,null,null,null,"SCR Module Clearance",null,null,null,"c2","ft",null,{"$f":"+IF(P$30=\"SCR\",9,\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",9,\"\")","v":""}]
[]
[null,null,null,{"$f":"1+D70","v":17},null,null,null,"Pressure Drop for SCR Ductwork",null,null,null,null,"ΔPduct","in w.g",null,{"$f":"+IF(P$30=\"SCR\",3,\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",3,\"\")","v":""},null,"Typical pressure drop values, per Ref. 1, § 2.5 & 2.6 - Example Problem(s) 1 and 2, \npage 2-80 (p81 pdf) and respectively page 2-87 (p88-pdf)."]
[null,null,null,{"$f":"1+D72","v":18},null,null,null,"Pressure Drop for each Catalyst Layer",null,null,null,null,"ΔPcatalyst","in w.g",null,{"$f":"+IF(P$30=\"SCR\",1,\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",1,\"\")","v":""}]
[]
[null,null,null,null,"II.","Reagent Specifications"]
[]
[null,null,null,null,null,null,"Reagent Data"]
[null,null,null,{"$f":"1+D73","v":19},null,null,null,"Reagent type",null,null,null,null,null,null,null,{"$f":"+IF(P$30=\"SCR\",\"ammonia\",\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",\"ammonia\",\"\")","v":""},null,"Selected design criteria per Ref.1, §2.2.1-Reduction Chemistry, p2-12 (p13-pdf)."]
[null,null,null,{"$f":"1+D78","v":20},null,null,null,"Reagent Molecular Weight",null,null,null,null,"Mreagent","lb/mole",null,{"$f":"+IF(P$30=\"SCR\",VLOOKUP(MATCH(P78,c_id,0),cmp,tbl!$G$7,FALSE),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",VLOOKUP(MATCH(R78,c_id,0),cmp,tbl!$G$7,FALSE),\"\")","v":""},null,"Ammonia Molecular Weight, per Ref. 1, Table 2.2, page 2-13 (p14-pdf)."]
[null,null,null,{"$f":"1+D79","v":21},null,null,null,"Acceptable Ammonia Slip",null,null,null,null,"Slip","ppm",null,{"$f":"+IF(P$30=\"SCR\",2,\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",2,\"\")","v":""},null,"Acceptable levels of 2-3 ppm, per Ref. 1, Ammonia Slip, page 2-21 (p22-pdf)."]
[null,null,null,{"$f":"1+D80","v":22},null,null,null,"Stoichiometric Ratio Factor",null,null,null,null,"SRF","moles reagent / moles NOx",null,{"$f":"+IF(P$30=\"SCR\",1.05,\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",1.05,\"\")","v":""},null,"Defined by eq. (2.13) per Ref. 1, §2.3.7- Stoichiometric Ratio Factor, p2-55 (p56-pdf). Typically SCR systems employ 1.05 moles of ammonia to one mole of NOx."]
[]
[null,null,null,null,null,null,"Storage"]
[null,null,null,{"$f":"1+D81","v":23},null,null,null,"Stored Ammonia Solution Concentration",null,null,null,null,"Csol","% by weight",null,{"$f":"+IF(P$30=\"SCR\",29.4%,\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",29.4%,\"\")","v":""},null,"Typical SCR ammonia concentration, per Ref.1, §2.2.1 - Reduction Chemistry, \npage 2-12 (p13-pdf)."]
[]
[null,null,null,{"$f":"1+D84","v":24},null,null,null,"Ammonia 29% Solution Density",null,null,null,null,"ρsol","lb/ft³",null,{"$f":"+IF(P$30=\"SCR\",56,\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",56,\"\")","v":""},null,"Per Ref. 1, § 2.3.12 - SCR Reactor Dim's, page 2-62 (p63 pdf)."]
[]
[null,null,null,{"$f":"1+D86","v":25},null,null,null,"No. Storage Days",null,null,null,null,"tstorage","days",null,{"$f":"+IF(P$30=\"SCR\",14,\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",14,\"\")","v":""},null,"Common onsite storage requirement, per Ref. 1, § 2.3.12 - SCR Reactor Dim's, \npage 2-62 (p63-pdf)."]
[]
[null,null,null,null,"III.","Specific Economic Factors"]
[]
[null,null,null,null,null,null,"SCR Costs Factors"]
[null,null,null,null,null,null,null,"Catalyst Cost "]
[null,null,null,{"$f":"1+D88","v":26},null,null,null,null,"Catalyst Cost, dollars per ft³",null,null,null,"CCreplace, IP","$/ft³",null,{"$f":"+IF(P$30=\"SCR\",160,\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",160,\"\")","v":""},null,"Per Ref. 1, § 2.5 & 2.6 - Ex. Problem(s) 1 and 2, p2-80 (p81 pdf) & p2-88 (p89-pdf)."]
[null,null,null,{"$f":"1+D94","v":27},null,null,null,null,"Catalyst Cost, dollars per m³",null,null,null,"CCreplace, SI","$/m³",null,{"$f":"+IF(P$30=\"SCR\",5500,\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",5500,\"\")","v":""},null,"$5,500 $/m³ is equivalent to 160$/ft³. Changing the units, results ~156$/ft³."]
[null,null,null,{"$f":"1+D95","v":28},null,null,null,"Operating Life of Catalyst",null,null,null,null,"CLife","hrs",null,{"$f":"+IF(P$30=\"SCR\",IF(P143=\"Coal\",24000,32000),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF(P143=\"Coal\",24000,32000),\"\")","v":""},null,"Vendor data, per Ref. 1, §2.2.1 - Reduction Chemistry, page 2-14 (p15-pdf)."]
[]
[null,null,null,null,null,null,"Labor Costs"]
[null,null,null,{"$f":"1+D96","v":29},null,null,null,"Number of hours of operator labor",null,null,null,null,"top, labor","hrs/day",null,{"$f":"+IF(P$30=\"SCR\",4,\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",4,\"\")","v":""},null,"Per Ref.1, § 2.5 & 2.6 - Ex. Problem(s) 1 and 2, p2-80 (p81 pdf) & p2-88 (p89-pdf)."]
[]
[null,null,null,{"$f":"1+D99","v":30},null,null,null,"Labor Rate",null,null,null,null,"LR","$/hr",null,{"$f":"+IF(P$30=\"SCR\",'Data Entry'!$P$153,\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",'Data Entry'!$P$153,\"\")","v":""},null,"EPA suggested \"Labor Rate\", listed on Data Entry page, Line 45."]
[]
[null,null,null,null,null,null,"Capital Cost Elevation Factor"]
[null,null,null,{"$f":"1+D101","v":31},null,null,null,"Elevation Factor",null,null,null,null,"ELEVF",null,null,{"$f":"+IF(P$30=\"SCR\",IF('Data Entry'!P29=\"\",\"\",14.696/(2116*((59-0.00356*'Data Entry'!P29+459.7)/518.6)^5.256/144)),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF('Data Entry'!P29=\"\",\"\",14.696/(2116*((59-0.00356*'Data Entry'!P29+459.7)/518.6)^5.256/144)),\"\")","v":""},null,"Calculated per eq's. (2.39a) & (2.39b), Ref. 1, §2.4.1 - Total Capital Investment, pages 2-64 & 2-65 (p65/p66-pdf). "]
[]
[]
[]
[null,null,null,null,"SCR SIZING"]
[]
[null,null,null,null,"I.","Emission Unit Performance Data"]
[]
[null,null,null,null,null,null,"Emission Unit Data"]
[null,null,null,{"$f":"1+D104","v":32},null,null,null,"Unit Type",null,null,null,null,null,null,null,{"$f":"+IF(P$30=\"SCR\",IF('Data Entry'!P32=\"\",\"\",'Data Entry'!P32),\"\")","v":""},null,null,null,{"$f":"+IF(P30=\"\",\"\",IF('Data Entry'!P32=\"\",\"Error: Enter Emission Unit Type on Data Entry page, Line 10\",\"Emission unit type selected on Data Entry page Line 10.\"))","v":""}]
[]
[null,null,null,{"$f":"1+D113","v":33},null,null,null,"Maximum Heat Rate Input",null,null,null,null,"QB","MMBtu/hr",null,{"$f":"+IF(P$30=\"SCR\",IF(OR(P113=\"Combined cycle\",P113=\"Boiler\"),'Data Entry'!P46,IFERROR('Data Entry'!P49*'Data Entry'!P52,\"\")),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF(OR(P113=\"Combined cycle\",P113=\"Boiler\"),'Data Entry'!P46,IFERROR('Data Entry'!P49*'Data Entry'!P52,\"\")),\"\")","v":""},null,{"$f":"+IF(T116=\"\",\"Space intentionally left blank\",\"\")","v":"Space intentionally left blank"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(P30=\"\",\"\",IF(P115='Data Entry'!P46,\"\",\"Error: Check, Max. Heat Rate Input should be \"&P115&\" MMBtu/hr, instead of \"&IF('Data Entry'!P46=\"\",\"''Blank''\",'Data Entry'!P46)&\" MMBtu/hr, as selected on ''Data Entry'' page, if NPHR is listed as \"&'Data Entry'!P52&\" MMBtu/MWh\"&\" and Nominal Power Output is \"&'Data Entry'!P49&\" MW.\"))","v":""}]
[null,null,null,{"$f":"1+D115","v":34},null,null,null,"Power Output (MW Rating) \nat full load capacity.",null,null,null,null,"BMW","MW",null,{"$f":"+IF(P$30=\"SCR\",IF(OR(P113=\"Combined cycle\",P113=\"Boiler\"),'Data Entry'!P46/'Data Entry'!P52,'Data Entry'!P49),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF(OR(P113=\"Combined cycle\",P113=\"Boiler\"),'Data Entry'!P46/'Data Entry'!P52,'Data Entry'!P49),\"\")","v":""}]
[]
[]
[null,null,null,{"$f":"1+D117","v":35},null,null,null,{"$f":"+IF(OR(P113=\"Combustion Turbine\",P113=\"Engine\"),\"Nominal Plate Heat Rate\",\"Heat Rate\")","v":"Heat Rate"},null,null,null,null,"NPHR","MMBtu/MWh",null,{"$f":"+IF(P$30=\"SCR\",IF('Data Entry'!P52=\"\",\"\",'Data Entry'!P52),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF('Data Entry'!P52=\"\",\"\",'Data Entry'!P52),\"\")","v":""}]
[]
[null,null,null,{"$f":"1+D120","v":36},null,null,null,"Heat Rate Factor",null,null,null,null,"HRF",null,null,{"$f":"+IF(P$30=\"SCR\",IF(P120=0,\"\",P120/10),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF(R120=0,\"\",R120/10),\"\")","v":""},null,"Defined by eq. (2.6), Ref. 1, §2.3.2- Heat Rate Factor, page 2-52 (p53-pdf), as the ratio of actual NPHR to a typical heat rate of 10 MMBtu/MWh used in developing capital cost equations."]
[]
[]
[]
[null,null,null,{"$f":"1+D122","v":37},null,null,null,"Annual Hrs of Operation",null,null,null,null,"top, ems unit","hrs",null,{"$f":"+IF(P$30=\"SCR\",IF('Data Entry'!P111=\"\",\"\",'Data Entry'!P111),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF('Data Entry'!R111=\"\",\"\",'Data Entry'!R111),\"\")","v":""},null,"Data Entry - Emission Unit Annual Hrs of Operation, Line 33,  Columns 1 & 2. The air pollution control is assumed to operate at all times the emission unit is operating. "]
[]
[]
[null,null,null,{"$f":"1+D126","v":38},null,null,null,"Heat Input Max Annual",null,null,null,null,"HI","MMBtu/yr",null,{"$f":"+IF(P$30=\"SCR\",IF(P126=\"\",\"\",IF(P113=\"Combined cycle\",P115*P126,P117*P120*P126)),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF(R126=\"\",\"\",IF(P113=\"Combined cycle\",R115*R126,R117*R120*R126)),\"\")","v":""},null,"Calculated based on BMW, NPHR and emission unit operating time, top,ems unit or \nQB multiplied by top,ems unit."]
[]
[null,null,null,{"$f":"1+D129","v":39},null,null,null,"Annual Actual MW Output",null,null,null,null,"Boutput","MW/yr",null,{"$f":"+IF(P$30=\"SCR\",P117*P126,\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",R117*R126,\"\")","v":""},null,"Power Output, BMW, (Line 34) multiplied by the emission Annual Hrs. of Operation, top, ems unit (Line 37)."]
[]
[null,null,null,null,null,null,"Operating Capacity Factors"]
[null,null,null,{"$f":"1+D131","v":40},null,null,null,"Emission Unit Capacity Factor",null,null,null,null,"CF ems unit",null,null,{"$f":"+IF(P$30=\"SCR\",IF(P126=0,\"\",P131/(P117*8760)),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF(R126=0,\"\",R131/(R117*8760)),\"\")","v":""},null,"Per Ref. 1, § 2.3.3-System Capacity Factor,  eq. (2.8a), p2-53 (p54-pdf). Since max. MW output is selected, eq. (2.8a) is also equivalent with the selected the hrs of operation divided by 8,760 hrs."]
[]
[]
[]
[null,null,null,{"$f":"1+D134","v":41},null,null,null,"SCR Capacity Factor",null,null,null,null,"CF SCR",null,null,{"$f":"+IF(P$30=\"SCR\",IF(P36=\"\",\"\",P36/P126),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF(R36=\"\",\"\",R36/R126),\"\")","v":""},null,"Defined by eq. (2.9), Ref. 1, §2.3.3 - System Capacity Factor, page 2-53 (p54-pdf)."]
[]
[null,null,null,{"$f":"1+D138","v":42},null,null,null,"Total System Capacity Factor",null,null,null,null,"CF Total",null,null,{"$f":"+IF(P$30=\"SCR\",IF(P138*P134=0,\"\",P138*P134),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF(R138*R134=0,\"\",R138*R134),\"\")","v":""},null,"Defined by eq. (2.7), Ref. 1, §2.3.3 - System Capacity Factor, page 2-53 (p54-pdf)."]
[]
[null,null,null,null,null,null,"Fuel Data"]
[null,null,null,{"$f":"1+D140","v":43},null,null,null,"Fuel Type",null,null,null,null,null,null,null,{"$f":"+IF(P$30=\"SCR\",IF('Data Entry'!P56=\"\",\"\",'Data Entry'!P56),\"\")","v":""},null,null,null,{"$f":"+IF(P143=\"Coal\",\"Emission unit fuel type selected on Data Entry, Line 19. See also note on Line 19:   Since Connecticut has only one coal-fired emission unit that burns a mix of bituminous and sub-bituminous coal only, \"&\"all specifications of this calculation for emission units burning coal are selected for bituminous coal.\",\"Emission unit fuel type selected on Data Entry, Line 19.\")","v":"Emission unit fuel type selected on Data Entry, Line 19."}]
[]
[]
[]
[]
[null,null,null,{"$f":"1+D143","v":44},null,null,null,"Air Heater Factor",null,null,null,null,"AHF",null,null,{"$f":"+IF(P$30=\"SCR\",IF(AND(P143=\"Coal\",'Data Entry'!P64=3,'Data Entry'!P64>3),1,0),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF(AND(P143=\"Coal\",'Data Entry'!P64=3,'Data Entry'!P64>3),1,0),\"\")","v":""},null,{"$f":"+\"Defined in Eq. (2.43), Ref 1, §2.4.1.1 - Utility Boilers, page 2-67 (p68-pdf), as multiplier for Air Pre-Heater Cost. AHF=1, if bituminous coal and SO2> 3lb/MMBtu, =0 if not true.\"&IF(P143=\"Coal\",\" Note: Since Connecticut has only one coal-fired emission unit that burns a mix of bituminous and (sub)bituminous coal, AHF is ''0'', and the air pre-heater term drops out of the overall SNCR cost eq. for all CT emission units.\",\"\")","v":"Defined in Eq. (2.43), Ref 1, §2.4.1.1 - Utility Boilers, page 2-67 (p68-pdf), as multiplier for Air Pre-Heater Cost. AHF=1, if bituminous coal and SO2> 3lb/MMBtu, =0 if not true."}]
[]
[]
[]
[]
[null,null,null,{"$f":"1+D148","v":45},null,null,null,{"$f":"+IF(P143=\"Coal\",\"Coal\",\"Fuel\")&\" Factor\"","v":"Fuel Factor"},null,null,null,null,{"$f":"+IF(P143=\"Coal\",\"CoalF\",\"Fuel(F)\")","v":"Fuel(F)"},null,null,{"$f":"+IF(P$30=\"SCR\",1,\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",1,\"\")","v":""},null,"Defined in Eq's. (2.41), (2.43) and (2.44), Ref 1, §2.4.1.1 - Utility Boilers, p2-66 \n(p67-pdf) & p2-67 (p68-pdf), as \"CoalF\" multiplier for coal units costs. In eq. (2.60) Ref 1, §2.4.2.-Total Annual Costs, p2-74 (p75-pdf), CoalF is replaced with a (Fuel) factor equal to 1, for oil- and gas fired emission units. CoalF (or FuelF) multiplier applied to CT units is = 1."]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"1+D153","v":46},null,null,null,"Fuel High Heating Value",null,null,null,null,"HHV",{"$f":"+IF(P143=\"Natural Gas\",\"Btu/ft³\",\"Btu/lb\")","v":"Btu/lb"},null,{"$f":"+IF(P$30=\"SCR\",IF(P143=\"Natural Gas\",VLOOKUP(MATCH(P143,fuels_id,0),fuels,tbl!$I$42,FALSE),IF(P143=\"Coal\",VLOOKUP(MATCH(P143,fuels_id,0),fuels,tbl!$J$42,FALSE),IF(OR(P143=\"Natural Gas\",P143=\"Coal\",P143=\"\"),\"\",VLOOKUP(MATCH(P143,fuels_id,0),fuels,tbl!$J$42,FALSE)))),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF(P143=\"Natural Gas\",VLOOKUP(MATCH(P143,fuels_id,0),fuels,tbl!$I$42,FALSE),IF(P143=\"Coal\",VLOOKUP(MATCH(P143,fuels_id,0),fuels,tbl!$J$42,FALSE),IF(OR(P143=\"Natural Gas\",P143=\"Coal\",P143=\"\"),\"\",VLOOKUP(MATCH(P143,fuels_id,0),fuels,tbl!$J$42,FALSE)))),\"\")","v":""},null,"Per US DOE-Biomass Energy Databook:",null,null,null,"http://cta.ornl.gov/bedb/appendix_a.shtml"]
[]
[null,null,null,{"$f":"1+D159","v":47},null,null,null,"Max. Fuel Consumption Rate",null,null,null,null,{"$f":"+IF(P143=\"Natural Gas\",\"V(fuel)\",\"m(fuel)\")","v":"m(fuel)"},{"$f":"+IF(P143=\"Natural Gas\",\"CFH\",\"lb/hr\")","v":"lb/hr"},null,{"$f":"+IF(P$30=\"SCR\",P129*10^6/P126/P159,\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",P129*10^6/P126/P159,\"\")","v":""},null,"Calculated as hourly heat input (Line 38 divided by Line 37), and divided by the fuel HHV (Line 46), or Maximum Heat Rate Input (QB) on Line 33, divided by fuel HHV - Line 46."]
[]
[]
[null,null,null,{"$f":"1+D161","v":48},null,null,null,"Annual Fuel Consumption \n(estimate based on selected HHV) ",null,null,null,null,"Annual Fuel",{"$f":"+IF(P143=\"Natural Gas\",\"CF/yr\",\"lb/yr\")","v":"lb/yr"},null,{"$f":"+IF(P$30=\"SCR\",IF(P161=\"\",\"\",P161*P126),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF(R161=\"\",\"\",R161*R126),\"\")","v":""},null,"Fuel consumption rate (Line 47) multiplied by the total annual hours of operation, (Line 37)."]
[]
[]
[null,null,null,null,null,null,"Exhaust Flue Gas Flow Specifications"]
[null,null,null,{"$f":"1+D164","v":49},null,null,null,"Exhaust Flow Temp Correction Factor",null,null,null,null,"Tin","ºF",null,{"$f":"+IF(P$30=\"SCR\",IFERROR((459.67+P41)/(459.67+'Data Entry'!P74),\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR((459.67+R41)/(459.67+'Data Entry'!P74),\"\"),\"\")","v":""},null,"Adjustment factor to determine exhaust flow rate at temperatures other than 700ᵒF (SCR default Tin), based on physics Charles' Law (V/T = constant)."]
[]
[]
[null,null,null,{"$f":"1+D168","v":50},null,null,null,"Flue Gas Flow Rate\n(selected)",null,null,null,null,"q flue gas","CFM",null,{"$f":"+IF(P$30=\"SCR\",IF('Data Entry'!P75=\"\",\"\",P168*'Data Entry'!P75),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",R168*'Data Entry'!P75,\"\")","v":""},null,"Flue Gas Flow provided on Data Entry, Line 25, corrected for 700ᵒF."]
[]
[null,null,null,{"$f":"1+D171","v":51},null,null,null,"Base case Flue Gas Volumetric \nFlow Rate Factor(calculated)",null,null,null,null,"q fuel","CFM/MMBtu/hr",null,{"$f":"+IF(P$30=\"SCR\",IFERROR(P171/P115,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(R171/R115,\"\"),\"\")","v":""},null,"Defined in eq. (2.14), Ref. 1, §2.3.8 - Flue Gas Flow Rate, page 2-56 (p57-pdf). Factor is determined for comparison with EPA data (see Ref. 1, p2-56). \nNote: If the calculated base case factor is different from EPA data, then the flue flow rate entry (Data Entry, Line 25) ought to be revised."]
[]
[]
[]
[null,null,null,null,null,null,"NOx Removal Performance"]
[null,null,null,{"$f":"1+D173","v":52},null,null,null,"Uncontrolled NOx Emission Level",null,null,null,null,"NOxin","lb/MMBtu",null,{"$f":"+IF(P$30=\"SCR\",IF('Data Entry'!P78=\"\",\"\",'Data Entry'!P78),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF('Data Entry'!P78=\"\",\"\",'Data Entry'!P78),\"\")","v":""},null,"Uncontrolled NOx rate entered on Data Entry page, Line 26."]
[]
[null,null,null,{"$f":"1+D178","v":53},null,null,null,"Controlled NOx Outlet (required rate)",null,null,null,null,"NOxout","lb/MMBtu",null,{"$f":"+IF(P$30=\"SCR\",IF('Data Entry'!P80=\"\",\"\",'Data Entry'!P80),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF('Data Entry'!P80=\"\",\"\",'Data Entry'!P80),\"\")","v":""},null,"Controlled NOx rate, as required by RCSA 22a-174-22e, and listed on Data Entry, \nLine 27."]
[]
[]
[null,null,null,{"$f":"1+D180","v":54},null,null,null,"Controlled NOx Outlet (selected)",null,null,null,null,"NOxout,sel","lb/MMBtu",null,{"$f":"+IF(P$30=\"SCR\",MAX(P180,P47,P178-P43*P178),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",MAX(R180,R47,R178-R43*R178),\"\")","v":""},null,{"$f":"+\"Determined as the highest among: the required controlled NOx out, the SCR lowest attained NOx out rate, or the NOx out value based on the \"&IF(P$30=\"SCR\",P43*100&\"% \",\"\")&\"default efficiency.\"","v":"Determined as the highest among: the required controlled NOx out, the SCR lowest attained NOx out rate, or the NOx out value based on the default efficiency."}]
[]
[]
[null,null,null,{"$f":"1+D183","v":55},null,null,null,"NOx Removal Efficiency\n(selected)",null,null,null,null,"h NOxR,sel","%",null,{"$f":"+IF(P$30=\"SCR\",IFERROR((P178-P183)/P178,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR((R178-R183)/R178,\"\"),\"\")","v":""},null,"Defined by eq. (2.10) Ref. 1, § 2.3.5 - NOx Removal Efficiency, p2-54 (p55-pdf) and calculated based on NOxin on Line 52 and the value of NOxout sel, on Line 54."]
[]
[]
[null,null,null,{"$f":"1+D186","v":56},null,null,null,"NOx Removal Factor",null,null,null,null,"NRF",null,null,{"$f":"+IF(P$30=\"SCR\",P186/0.8,\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",R186/0.8,\"\")","v":""},null,"For use with eq. (2.41) to calculate SCR cost, per Ref. 1, § 2.4.1.1-Utility Boilers, page 2-66 (p67-pdf)."]
[]
[]
[null,null,null,{"$f":"1+D189","v":57},null,null,null,"NOx Removed Hourly Rate",null,null,null,null,"NOxR/hr","lb/hr",null,{"$f":"+IF(P$30=\"SCR\",IFERROR(P178*P186*P115,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(R178*R186*R115,\"\"),\"\")","v":""},null,"Defined by eq. (2.12), Ref. 1, §2.3.6 - NOx Removal Rates, page 2-55 (p56-pdf)."]
[]
[]
[null,null,null,{"$f":"1+D192","v":58},null,null,null,"NOx Removed / yr",null,null,null,null,"NOxR","tons",null,{"$f":"+IF(P$30=\"SCR\",IFERROR((P178*P186*P115*P140*8760)/2000,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR((R178*R186*R115*R140*8760)/2000,\"\"),\"\")","v":""},null,"Defined by eq. (2.11), Ref. 1, § 2.3.6 - NOx Removal Rates, page 2-54 (p55-pdf)."]
[]
[null,null,null,null,"II.","SCR Reactor Calculations"]
[]
[null,null,null,null,null,null,"Catalyst Volume"]
[null,null,null,{"$f":"1+D195","v":59},null,null,null,"NOx Efficiency Adjustment Factor",null,null,null,null,"hadj",null,null,{"$f":"+IF(P$30=\"SCR\",IFERROR(0.2869+(1.058*P186),\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(0.2869+(1.058*R186),\"\"),\"\")","v":""},null,"Factor in eq. (2.22), and defined by eq. (2.23), Ref. 1, §2.3.11 - Catalyst Volume, \npage 2-58 (p59-pdf)."]
[]
[null,null,null,{"$f":"1+D200","v":60},null,null,null,"Ammonia Slip Adjustment Factor",null,null,null,null,"Slipadj",null,null,{"$f":"+IF(P$30=\"SCR\",IF(P80=\"\",\"\",1.2835-(0.0567*P80)),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF(R80=\"\",\"\",1.2835-(0.0567*R80)),\"\")","v":""},null,"Factor in eq.(2.22), and defined by eq.(2.24), Ref. 1, §2.3.11 - Catalyst Volume, \npage 2-58 (p59-pdf)."]
[]
[null,null,null,{"$f":"1+D202","v":61},null,null,null,"NOx adjustment factor for inlet NOx",null,null,null,null,"NOxadj",null,null,{"$f":"+IF(P$30=\"SCR\",IFERROR(0.8524+(0.3208*P178),\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(0.8524+(0.3208*R178),\"\"),\"\")","v":""},null,"Factor in eq. (2.22), and defined by eq. (2.25), Ref. 1, §2.3.11 - Catalyst Volume, \npage 2-58 (p59-pdf)."]
[]
[null,null,null,{"$f":"1+D204","v":62},null,null,null,"Sulfur in Coal Adjustment Factor",null,null,null,null,"Sadj",null,null,{"$f":"+IF(P$30=\"SCR\",IF(OR('Data Entry'!P62=\"\",'Data Entry'!P62=0),1,0.9636+(0.0455*'Data Entry'!P62*100)),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF(OR('Data Entry'!P62=\"\",'Data Entry'!P62=0),1,0.9636+(0.0455*'Data Entry'!P62*100)),\"\")","v":""},null,"Factor in eq. (2.22), and defined by eq. (2.26), Ref. 1, §2.3.11 - Catalyst Volume, \npage 2-58 (p59-pdf)."]
[]
[null,null,null,{"$f":"1+D206","v":63},null,null,null,"Temperature Adjustment Factor",null,null,null,null,"Tadj",null,null,{"$f":"+IF(P$30=\"SCR\",IF(P41=\"\",\"\",IF(P41=700,1,15.16-(0.03937*P41)+(0.0000274*P41^2))),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF(R41=\"\",\"\",IF(R41=700,1,15.16-(0.03937*R41)+(0.0000274*R41^2))),\"\")","v":""},null,"Factor in eq. (2.22), and defined by eq. (2.27), Ref. 1  §2.3.11 - Catalyst Volume, page 2-59 (p60-pdf)."]
[]
[]
[null,null,null,{"$f":"1+D208","v":64},null,null,null,"Volume estimate of the catalyst",null,null,null,null,"Volcatalyst","ft³",null,{"$f":"+IF(P$30=\"SCR\",IF(P34=\"\",\"\",2.81*P115*P200*P202*P204*P206*P208/P34),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF(R34=\"\",\"\",2.81*R115*R200*R202*R204*R206*R208/R34),\"\")","v":""},null,"Defined by empirical eq. (2.22), per Ref. 1, §2.3.11 - Catalyst Volume, page 2-58 (p59-pdf)."]
[]
[null,null,null,null,null,null,"Configuration & Dimensions"]
[null,null,null,{"$f":"1+D211","v":65},null,null,null,"Catalyst Cross-sectional Area",null,null,null,null,"Acatalyst","ft²",null,{"$f":"+IF(P$30=\"SCR\",IFERROR(ROUNDUP(P171/($P$58*60),0),\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(ROUNDUP(R171/($R$58*60),0),\"\"),\"\")","v":""},null,"Defined by eq. (2.28), per Ref. 1  §2.3.12 - SCR Reactor Dim's, p2-59 (p60-pdf)."]
[]
[null,null,null,{"$f":"1+D214","v":66},null,null,null,"SCR Cross-sectional Area",null,null,null,null,"ASCR","ft²",null,{"$f":"+IF(P$30=\"SCR\",IFERROR(ROUNDUP(1.15*P214,0),\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(ROUNDUP(1.15*R214,0),\"\"),\"\")","v":""},null,"Per eq. (2.29), Ref. 1  §2.3.12 - SCR Reactor Dim's, page 2-59 (p60-pdf). \nASCR > Acatalyst by 15% to account for module geometry and hardware."]
[]
[]
[null,null,null,{"$f":"1+D216","v":67},null,null,null,"Reactor Length (l) & Width (w)",null,null,null,null,"l = w","ft",null,{"$f":"+IF(P$30=\"SCR\",IFERROR(P216^0.5,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(R216^0.5,\"\"),\"\")","v":""},null,{"$f":"+\"Square root from Catalyst Cross-Sectional Area. Area aspect ratio is l/w = \"&P60&\".0. \nPer Ref. 1, §2.3.12 - SCR Reactor Dim's, eq (2.30), page 2-59 (p60-pdf).\"","v":"Square root from Catalyst Cross-Sectional Area. Area aspect ratio is l/w = .0. \nPer Ref. 1, §2.3.12 - SCR Reactor Dim's, eq (2.30), page 2-59 (p60-pdf)."}]
[]
[null,null,null,null,null,null,null,"No. of Catalyst layers"]
[null,null,null,{"$f":"1+D219","v":68},null,null,null,null,"Required",null,null,null,"nlayer req.",null,null,{"$f":"+IF(P$30=\"SCR\",IFERROR(P211/($P$66*P214),\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(R211/($R$66*R214),\"\"),\"\")","v":""},null,"Defined by eq. (2.31), per Ref. 1, §2.3.12 - SCR Reactor Dim's, p2-60 (p61-pdf)."]
[null,null,null,{"$f":"1+D222","v":69},null,null,null,null,"Selected",null,null,null,"nlayer, sel",null,null,{"$f":"+IF(P$30=\"SCR\",IFERROR(IF(ROUND(P222,0)<2,2,ROUND(P222,0)),\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(IF(ROUND(R222,0)<2,2,ROUND(R222,0)),\"\"),\"\")","v":""},null,{"$f":"+IF(O222<2,\"Min. number of layers selected should be ''2'', if the above result is less than ''2''.\",\"\")","v":"Min. number of layers selected should be ''2'', if the above result is less than ''2''."}]
[]
[null,null,null,{"$f":"1+D223","v":70},null,null,null,"No. of additional empty layers",null,null,null,null,"nlayer empty",null,null,{"$f":"+IF(P$30=\"SCR\",ROUNDDOWN(P223/$P$53,0),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",ROUNDDOWN(R223/$R$53,0),\"\")","v":""},null,"Selected based on the criteria, on Line 9, above: \"Two full, one empty layer\"."]
[]
[null,null,null,null,null,null,null,"Height of catalyst layer"]
[null,null,null,{"$f":"1+D225","v":71},null,null,null,null,"hlayer (calculated)",null,null,null,"hlayer(clc)","ft",null,{"$f":"+IF(P$30=\"SCR\",IFERROR(P211/(P223*P214)+1,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(R211/(R223*R214)+1,\"\"),\"\")","v":""},null,"Defined by eq. (2.32), per Ref. 1  §2.3.12 - SCR Reactor Dim's, p2-60 (p61-pdf)."]
[null,null,null,{"$f":"1+D228","v":72},null,null,null,null,"hlayer\n(selected)",null,null,null,"hlayer, sel","ft",null,{"$f":"+IF(P$30=\"SCR\",IF(P228=\"\",\"\",IF(P228<5,IF(P228<2.5,2.5,P228),\"recalculate\")),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF(R228=\"\",\"\",IF(R228<5,IF(R228<2.5,2.5,R228),\"recalculate\")),\"\")","v":""},null,{"$f":"+IF(P228=\"\",\"\",IF(P228<5,IF(P228<2.5,\"Min. height should be 2.5ft, if the result above is less than 2.5ft\",\"Height of catalyst layer, h(layer,sel) is within standard industry range, 2.5 - 5.0 ft.\"),\"Select a new superficial (face) velocity and recalculate V(calayst) and h(layer)\"))","v":""}]
[]
[null,null,null,{"$f":"1+D229","v":73},null,null,null,"Volcatalyst (re)calculated",null,null,null,null,"Volcatalyst,(clc)","ft³",null,{"$f":"+IF(P$30=\"SCR\",IFERROR(P223*P214*(P229-1),\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(R223*R214*(R229-1),\"\"),\"\")","v":""},null,"Volume catalyst (re)calculated using, the selected height, on Line 72. "]
[]
[null,null,null,{"$f":"1+D231","v":74},null,null,null,"ntotal\n(incl. empty layers)",null,null,null,null,"ntotal",null,null,{"$f":"+IF(P$30=\"SCR\",IFERROR(P223+$P$225,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(R223+$R$225,\"\"),\"\")","v":""},null,"Eq. (2.33), per Ref. 1  §2.3.12 - SCR Reactor Dim's, page 2-60 (p61-pdf)."]
[]
[null,null,null,{"$f":"1+D233","v":75},null,null,null,"SCR height",null,null,null,null,"hSCR","ft",null,{"$f":"+IF(P$30=\"SCR\",IFERROR(P233*($P$69+P229)+$P$70,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(R233*($R$69+R229)+$R$70,\"\"),\"\")","v":""},null,"Eq. (2.34), per Ref. 1  §2.3.12 - SCR Reactor Dim's, page 2-61 (p62-pdf)."]
[]
[null,null,null,null,"III.","Reagent Calculations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eq.(2.37), Ref.1, §2.3.13-Estim. Reagent Consumption & Tank Size,p2-62(p63-pdf). "]
[null,null,null,null,null,null,"Flow Rates"]
[null,null,null,{"$f":"1+D235","v":76},null,null,null,{"$f":"+PROPER(P78)&\" Consumption\"","v":" Consumption"},null,null,null,null,"ṁreagent","lb/hr",null,{"$f":"+IF(P$30=\"SCR\",IFERROR(P178*P115*P186*$P$81*$P$79/'Data Entry'!$P$161,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(R178*R115*R186*$R$81*$R$79/'Data Entry'!$P$161,\"\"),\"\")","v":""},null,"Eq.(2.35), Ref.1, §2.3.13-Estim. Reagent Consumption & Tank Size,p2-61(p62-pdf). "]
[]
[null,null,null,null,null,null,null,"Ammonia 29% Solution"]
[null,null,null,{"$f":"1+D240","v":77},null,null,null,null,"Mass Flow Rate",null,null,null,"ṁsol","lb/hr",null,{"$f":"+IF(P$30=\"SCR\",IFERROR(P240/$P$84,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(R240/$R$84,\"\"),\"\")","v":""},null,"Eq.(2.36), Ref.1, §2.3.13-Estim. Reagent Consumption & Tank Size,p2-61(p62-pdf). "]
[]
[null,null,null,{"$f":"1+D243","v":78},null,null,null,null,"Volumetric Flow Rate",null,null,null,"qsol","gph",null,{"$f":"+IF(P$30=\"SCR\",IFERROR(P243*7.4805/$P$86,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(R243*7.4805/$R$86,\"\"),\"\")","v":""},null,"Eq.(2.37), Ref.1, §2.3.13-Estim. Reagent Consumption & Tank Size,p2-62(p63-pdf). "]
[]
[null,null,null,null,null,null,"Storage"]
[null,null,null,{"$f":"1+D245","v":79},null,null,null,"Storage Tank Volume",null,null,null,null,"Voltank","gal",null,{"$f":"+IF(P$30=\"SCR\",IFERROR(P245*P88*24,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(R245*R88*24,\"\"),\"\")","v":""},null,"Eq.(2.38), Ref.1, §2.3.13-Estim. Reagent Consumption & Tank Size,p2-62(p63-pdf). "]
[]
[null,null,null,null,"IV.","Utilities"]
[]
[null,null,null,{"$f":"1+D248","v":80},null,null,null,"Power Consumption",null,null,null,null,"P","kW",null,{"$f":"+IF(P$30=\"SCR\",IFERROR(P117*1000*0.56/100*(P122*IF(P143=\"Coal\",P153,1))^0.43,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(R117*1000*0.56/100*(R122*IF(P143=\"Coal\",R153,1))^0.43,\"\"),\"\")","v":""},null,"Estimated for SCR equipment, ammonia vaporization, water vaporization, and additional ID fan power, using eq. (2.60) or eq. (2.61), Ref. 1, §2.4.2. Total Annual Costs, page 2-74, (p75-pdf). Note: Eqs. (2.60) and (2.61), are equivalent since their first terms are equal, BMW = QB/NPHR."]
[]
[]
[]
[]
[]
[null,null,null,null,"SCR COST ESTIMATION"]
[]
[null,null,null,null,"TOTAL CAPITAL COST"]
[]
[null,null,null,null,"I.","Total Capital Investment (TCI) Estimate"]
[]
[null,null,null,null,null,null,"Retrofit Factor"]
[null,null,null,{"$f":"1+D252","v":81},null,null,null,"Selective Catalytic Reduction System",null,null,null,null,"RFSCR",null,null,{"$f":"+IF(P$30=\"SCR\",IF('Data Entry'!P88=\"\",\"\",'Data Entry'!P88),\"\")","v":""},null,null,null,"SCR System Retrofit Factor entered on Data Entry page, Line 30."]
[]
[null,null,null,null,null,null,{"$f":"+IF(AND(P113=\"Boiler\",P143=\"Coal\"),\"SCR Partial Costs\",\"Space intentionally left blank\")","v":"Space intentionally left blank"},null,null,null,null,null,null,null,null,{"$f":"+IF(AND(P113=\"Boiler\",P143=\"Coal\"),\"Note:\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(AND(P113=\"Boiler\",P143=\"Coal\"),\"The SCR partial costs for coal-fired emission units are calculated using EPA's proposed formulas for utility boliers.\",\"\")","v":""}]
[]
[null,null,null,{"$f":"1+D265","v":82},null,null,null,{"$f":"+IF(P$30=\"SCR\",IF(AND(P113=\"Boiler\",P143=\"Coal\"),\"Capital Cost of SCR Base Unit\",\"\"),\"\")","v":""},null,null,null,null,{"$f":"+IF(P$30=\"SCR\",IF(AND(P113=\"Boiler\",P143=\"Coal\"),\"SCRcost\",\"\"),\"\")","v":""},{"$f":"+IF(P$30=\"SCR\",IF(AND(P113=\"Boiler\",P143=\"Coal\"),\"$\",\"\"),\"\")","v":""},null,{"$f":"+IF(P$30=\"SCR\",IF(AND($P$113=\"Boiler\",$P$143=\"Coal\"),270000*(P189)^0.2*(P117*P122*P153)^0.92*P104*$P$265,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF(AND($P$113=\"Boiler\",$P$143=\"Coal\"),270000*(R189)^0.2*(R117*R122*R153)^0.92*R104*$P$265,\"\"),\"\")","v":""},null,{"$f":"+IF(P$30=\"SCR\",IF(AND(P113=\"Boiler\",P143=\"Coal\"),\"Calculated with eq. (2.41), Ref. 1  §2.4.1.1 - Utility Boilers, page 2-66 (p67-pdf).\",\"Line 82 - intentionally left blank\"),\"\")","v":""}]
[null,null,null,{"$f":"1+D270","v":83},null,null,null,{"$f":"+IF(P$30=\"SCR\",IF(AND(P113=\"Boiler\",P143=\"Coal\"),\"Reagent Preparation Cost\",\"\"),\"\")","v":""},null,null,null,null,{"$f":"+IF(P$30=\"SCR\",IF(AND(P113=\"Boiler\",P143=\"Coal\"),\"RPC\",\"\"),\"\")","v":""},{"$f":"+IF(P$30=\"SCR\",IF(AND(P113=\"Boiler\",P143=\"Coal\"),\"$\",\"\"),\"\")","v":""},null,{"$f":"+IF(P$30=\"SCR\",IF(AND($P$113=\"Boiler\",$P$143=\"Coal\"),490000*((P178*P117*P120)*P186)^0.25,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF(AND($P$113=\"Boiler\",$P$143=\"Coal\"),490000*((R178*R117*R120)*R186)^0.25,\"\"),\"\")","v":""},null,{"$f":"+IF(P$30=\"SCR\",IF(AND(P113=\"Boiler\",P143=\"Coal\"),\"Eq. (2.42), Ref. 1  §2.4.1.1 - Utility Boilers, page 2-66 (p67-pdf).\",\"Line 83 - intentionally left blank\"),\"\")","v":""}]
[null,null,null,{"$f":"1+D271","v":84},null,null,null,{"$f":"+IF(P$30=\"SCR\",IF(AND(P113=\"Boiler\",P143=\"Coal\"),\"Balance of Plant Cost\",\"\"),\"\")","v":""},null,null,null,null,{"$f":"+IF(P$30=\"SCR\",IF(AND(P113=\"Boiler\",P143=\"Coal\"),\"BPC\",\"\"),\"\")","v":""},{"$f":"+IF(P$30=\"SCR\",IF(AND(P113=\"Boiler\",P143=\"Coal\"),\"$\",\"\"),\"\")","v":""},null,{"$f":"+IF(P$30=\"SCR\",IF(AND($P$113=\"Boiler\",$P$143=\"Coal\"),460000*(P117*P122*P153)^0.42*P104*$P$265,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF(AND($P$113=\"Boiler\",$P$143=\"Coal\"),460000*(R117*R122*R153)^0.42*R104*$P$265,\"\"),\"\")","v":""},null,{"$f":"+IF(P$30=\"SCR\",IF(AND(P113=\"Boiler\",P143=\"Coal\"),\"Eq. (2.44), Ref. 1  §2.4.1.1 - Utility Boilers, page 2-67 (p68-pdf).\",\"Line 84 - intentionally left blank\"),\"\")","v":""}]
[null,null,null,{"$f":"1+D272","v":85},null,null,null,{"$f":"+IF(P$30=\"SCR\",IF(AND(P113=\"Boiler\",P143=\"Coal\"),\"Air Pre-Heater Modification Cost\",\"\"),\"\")","v":""},null,null,null,null,{"$f":"+IF(P$30=\"SCR\",IF(AND(P113=\"Boiler\",P143=\"Coal\"),\"APHC\",\"\"),\"\")","v":""},{"$f":"+IF(P$30=\"SCR\",IF(AND(P113=\"Boiler\",P143=\"Coal\"),\"$\",\"\"),\"\")","v":""},null,{"$f":"+IF(P$30=\"SCR\",IF(AND($P$113=\"Boiler\",$P$143=\"Coal\"),69000*(P115/10*P153)^0.78*P148,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF(AND($P$113=\"Boiler\",$P$143=\"Coal\"),69000*(R115/10*R153)^0.78*R148,\"\"),\"\")","v":""},null,{"$f":"+IF(P$30=\"SCR\",IF(AND(P113=\"Boiler\",P143=\"Coal\"),\"Eq. (2.43), Ref. 1  §2.4.1.1 - Utility Boilers, page 2-67 (p68-pdf). APHC is zero for coal with SO₂ content less than 3 lb/MMBtu and all other fuels.\",\"Line 85 - intentionally left blank\"),\"\")","v":""}]
[]
[]
[null,null,null,{"$f":"1+D273","v":86},null,null,{"$f":"+IF($P$113=\"Boiler\",\"\",\"Cost Adjustment Factor\")","v":"Cost Adjustment Factor"},null,null,null,null,null,{"$f":"+IF($P$113=\"Boiler\",\"\",\"CAF\")","v":"CAF"},null,null,{"$f":"+IF(P$30=\"SCR\",IF(P113=\"Boiler\",\"\",IF(P143=\"Natural Gas\",1.1,IF(P143=\"Coal\",0,1.5))),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF(P113=\"Boiler\",\"\",IF(P143=\"Natural Gas\",1.1,IF(P143=\"Coal\",0,1.5))),\"\")","v":""},null,{"$f":"+IF($P$113=\"Boiler\",\"Line 86 - intentionally left blank\",IF(P276=0,\"Error: Emission units other than boliers are oil- and gas- fired units; Select other fuel than coal on Data Entry, Line 19.\",\"Multiplier used with the TCI for utility boilers so that it may be applied to all other units (i.e., engines and turbines). EPA has not provided a specific formula for the turbines and engines in the 2016 referenced documents.\"))","v":"Multiplier used with the TCI for utility boilers so that it may be applied to all other units (i.e., engines and turbines). EPA has not provided a specific formula for the turbines and engines in the 2016 referenced documents."}]
[]
[]
[]
[null,null,null,{"$f":"1+D276","v":87},null,null,"Total Capital Investment",null,null,null,null,null,"TCI","$",null,{"$f":"+IF(P$30=\"SCR\",IF($P$113=\"Boiler\",IF($P$143=\"Coal\",1.3*(P270+P271+P273+P272),80000*(200/P117)^0.35*P117*P104*P265),80000*(200/P117)^0.35*P117*P104*P265*P276),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF($P$113=\"Boiler\",IF($P$143=\"Coal\",1.3*(R270+R271+R273+R272),80*(200/(R115/R120))^0.35*(R115/R120)*R104*1000),80*(200/(R115/R120))^0.35*(R115/R120)*R104*1000*R276),\"\")","v":""},null,{"$f":"+IF(P280=0,\"Error: Check unit type selected on Data Entry , Line 10, and fuel on Data Entry, Line 19 - Only boilers may burn coal, all other emission units are oil- and gas-fired emission units. All field cost elements below are blank since TCI is zero by error. \",IF(P143=\"Coal\",\"Calculated with eq. (2.40), Ref. 1, §2.4.1.1 - Utility Boilers, page 2-65 (p66-pdf) for coal-fired boilers.\",\"Calculated with eq. (2.45), Ref. 1, §2.4.1.1 - Utility Boilers, page 2-68 (p69-pdf) for oil- and gas-fired utility boilers\")&IF(G276=\"\",\"(≥25MW to 500 MW). \",\", multiplied by CAF to assess TCI for gas- and oil-fired turbines, combined cycle units or engines.\"))","v":"Calculated with eq. (2.45), Ref. 1, §2.4.1.1 - Utility Boilers, page 2-68 (p69-pdf) for oil- and gas-fired utility boilers, multiplied by CAF to assess TCI for gas- and oil-fired turbines, combined cycle units or engines."}]
[]
[]
[null,null,null,null,"II.","Annual Costs"]
[]
[null,null,null,null,null,null,"Direct Annual Elements Cost "]
[null,null,null,{"$f":"1+D280","v":88},null,null,null,"Annual Maintenance (0.5% TCI)",null,null,null,null,"AMC","$/yr",null,{"$f":"+IF(P$30=\"SCR\",IF(P280=0,\"\",0.005*P280),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF(R280=0,\"\",0.005*R280),\"\")","v":""},null,"Annual maintenance labor and material (including nozzle tips for injectors) is assumed 0.5% of TCI, per Ref. 1, §2.4.2 -Total Annual Costs, eq. (2.57), page 2-73 (p74-pdf)."]
[]
[]
[]
[null,null,null,{"$f":"1+D286","v":89},null,null,null,"Annual Reagent Cost",null,null,null,null,"ARC","$/yr",null,{"$f":"+IF(P$30=\"SCR\",IF(P280=0,\"\",IFERROR(P240*P140*8760*'Data Entry'!$P$149,\"\")),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF(R280=0,\"\",IFERROR(R240*R140*8760*'Data Entry'!$P$149,\"\")),\"\")","v":""},null,"Calculated based on annual ammonia consumption (in lb/yr) and specific cost, per eq's. (2.58) and (2.59), Ref. 1 §2.4.2. - Total Annual Cost, p2-74 (p75-pdf), where qsol is replaced with ṁreagent, estimated by eq. (2.35). Note: Eq. (2.35) applies since the \"Reagent Cost\" is provided (in Data Entry, Line 43) in $/lb, instead of $/gal."]
[]
[]
[]
[]
[null,null,null,{"$f":"1+D290","v":90},null,null,null,"Annual Electricity",null,null,null,null,"AEC","$/yr",null,{"$f":"+IF(P$30=\"SCR\",IF(P280=0,\"\",IFERROR(P252*P140*8760*'Data Entry'!$P$143,\"\")),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF(R280=0,\"\",IFERROR(R252*R140*8760*'Data Entry'!P143,\"\")),\"\")","v":""},null,"Based on the annual power consumption (P, Line 77), multiplied by the control operating time, top,control, Line 3 (or equivalent CFTotal x 8,760) and electricity specific cost (Data Entry, Line 41), \nper eq (2.62),  Ref. 1 §2.4.2. - Total Annual Cost, page 2-74 (p75-pdf)."]
[]
[]
[]
[null,null,null,{"$f":"1+D295","v":91},null,null,null,"Catalyst Replacement Cost",null,null,null,null,"CRC","$",null,{"$f":"+IF(P$30=\"SCR\",IF(P280=0,\"\",IFERROR(P231*P34*P94/P223,\"\")),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF(R280=0,\"\",IFERROR(R231*R34*R94/R223,\"\")),\"\")","v":""},null,"Per eq. (2.63), Ref. 1, §2.4.2. - Total Annual Cost, page 2-76 (p77-pdf)."]
[]
[null,null,null,{"$f":"1+D299","v":92},null,null,null,null,"Yrs of catalyst life",null,null,null,"Y","yrs",null,{"$f":"+IF(P$30=\"SCR\",IF(P280=0,\"\",IF(P96=\"\",\"\",ROUNDUP(P96/P36,0))),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF(R280=0,\"\",IF(R96=\"\",\"\",ROUNDUP(R96/R36,0))),\"\")","v":""},null,"Operating life of the catalyst, CLife, Line 28 (in hrs) divided by the control operating time, top,control, Line 3 (in hrs) per eq.(2.66), Ref. 1, §2.4.2. - Total Annual Cost, \npage 2-77 (p78-pdf). "]
[]
[]
[]
[null,null,null,{"$f":"1+D301","v":93},null,null,null,null,"Catalyst Future Worth Factor",null,null,null,"FWF",null,null,{"$f":"+IF(P$30=\"SCR\",IFERROR('Data Entry'!$P$130/((1+'Data Entry'!$P$130)^P301-1),\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR('Data Entry'!$P$130/((1+'Data Entry'!$P$130)^R301-1),\"\"),\"\")","v":""},null,"FWF applied to catalyst replacement, assuming the same interest rate listed in Data Entry, on Line 38. FWF calculated per eq. (2.65), Ref. 1, §2.4.2. page 2-76 (p77-pdf)."]
[]
[null,null,null,null,null,null,null,"Annual Catalyst Cost"]
[null,null,null,{"$f":"1+D305","v":94},null,null,null,null,"Method 1",null,null,null,"ACRC1","$/yr",null,{"$f":"+IF(P$30=\"SCR\",IFERROR(P305*P299,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(R305*R299,\"\"),\"\")","v":""},null,"Method 1 - Catalyst Replacement Cost (ACR) times Catalyst FWF, per eq. (2.64), Ref. 1, §2.4.2. p2-76 (p77-pdf)."]
[]
[null,null,null,{"$f":"1+D308","v":95},null,null,null,null,"Method 2",null,null,null,"ACRC2","$/yr",null,{"$f":"+IF(P$30=\"SCR\",IF(P280=0,\"\",IFERROR(P117*0.4*P153^2.9*(P189)^0.71*$P$95,\"\")),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF(R280=0,\"\",IFERROR(R117*0.4*R153^2.9*(R189)^0.71*$R$95,\"\")),\"\")","v":""},null,"Method 2 - Per Sargent & Lundy, LLC, empirical eq. (2.67), Ref. 1, §2.4.2. p2-77 (p78-pdf)."]
[]
[null,null,null,null,null,null,"Direct Annual Cost - DAC"]
[null,null,null,{"$f":"1+D310","v":96},null,null,null,"Method 1",null,null,null,null,"DAC1","$/yr",null,{"$f":"+IF(P$30=\"SCR\",IFERROR(P286+P290+P295+P308,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(R286+R290+R295+R308,\"\"),\"\")","v":""},null,"Sum of the above direct annual costs (maintenance, reagent, electricity and catalyst- Method 1, - Method 2), per Ref. 1, §2.4.2. - Total Annual Cost, \neq. (2.56), page 2-73 (p74-pdf)."]
[null,null,null,{"$f":"1+D313","v":97},null,null,null,"Method 2",null,null,null,null,"DAC2","$/yr",null,{"$f":"+IF(P$30=\"SCR\",IFERROR(P286+P290+P295+P310,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(R286+R290+R295+R310,\"\"),\"\")","v":""}]
[]
[null,null,null,null,null,null,"Indirect Annual Cost (IDAC)"]
[null,null,null,{"$f":"1+D314","v":98},null,null,null,"Administrative Charges",null,null,null,null,"AC","$/yr",null,{"$f":"+IF(P$30=\"SCR\",IFERROR(0.03*('Data Entry'!P119*P99*P101+0.4*P286),\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(0.03*('Data Entry'!R119*R99*R101+0.4*R286),\"\"),\"\")","v":""},null,"Per Ref. 1, §2.4.2. - Total Annual Cost, eq. (2.69), page 2-78 (p79-pdf)."]
[]
[null,null,null,{"$f":"1+D317","v":99},null,null,null,"Capital Recovery",null,null,null,null,"CR","$/yr",null,{"$f":"+IF(P$30=\"SCR\",IFERROR('Data Entry'!P137*P280,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR('Data Entry'!P137*R280,\"\"),\"\")","v":""},null,"Per Ref. 1 §2.4.2. - Total Annual Cost, eq. (2.70), page 2-79 (p80-pdf)."]
[]
[null,null,null,{"$f":"1+D319","v":100},null,null,null,"Indirect Annual Costs",null,null,null,null,"IDAC","$/yr",null,{"$f":"+IF(P$30=\"SCR\",IFERROR(P319+P317,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(R319+R317,\"\"),\"\")","v":""},null,"Total of the above indirect costs, Line 98 and Line 99, per Ref. 1 §2.4.2. - Total Annual Cost, eq. (2.68), page 2-78 (p79-pdf)."]
[]
[null,null,null,null,null,null,"Total Annual Cost"]
[null,null,null,{"$f":"1+D321","v":101},null,null,null,"Method 1",null,null,null,null,"TAC1","$/yr",null,{"$f":"+IF(P$30=\"SCR\",IFERROR(P313+P321,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(R313+R321,\"\"),\"\")","v":""},null,"Total of direct (Method 1) and indirect costs, per eq. (2.72), Ref. 1 §2.4.2. p2-79 (p80-pdf)."]
[]
[null,null,null,{"$f":"1+D324","v":102},null,null,null,"Method 2",null,null,null,null,"TAC2","$/yr",null,{"$f":"+IF(P$30=\"SCR\",IFERROR(P314+P321,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(R314+R321,\"\"),\"\")","v":""},null,"Total of direct (Method 2) and indirect costs, per eq. (2.72), Ref. 1 §2.4.2. p2-79 (p80-pdf)."]
[]
[null,null,null,{"$f":"1+D326","v":103},"III.","Nox Removal per year",null,null,null,null,null,null,"NOxR","tons",null,{"$f":"+IF(P$30=\"SCR\",IF(P280=0,\"\",P195),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IF(R280=0,\"\",R195),\"\")","v":""},null,"Tons of NOx removed calculated above, on Line 58."]
[]
[null,null,null,null,"IV.","Control Cost Effectiveness"]
[]
[null,null,null,{"$f":"1+D328","v":104},null,null,"Base Year",null,null,null,null,null,null,null,null,{"$f":"+IF(P$30=\"SCR\",'Data Entry'!P126,\"\")","v":""},null,null,null,"Data Entry, Line 36 - Selected base year of EPA's cost analysis."]
[null,null,null,{"$f":"1+D332","v":105},null,null,null,"Cost Effectiveness Method 1",null,null,null,null,"Costeffect,$2012,1 ","2012$/ton NOxR",null,{"$f":"+IF(P$30=\"SCR\",IFERROR(P324/P328,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(R324/R328,\"\"),\"\")","v":""},null,"Control cost effectiveness based on either TAC (method 1 or method 2) divided by the annual tons of NOx removed, per eq. (2.73), Ref. 1 §2.4.2. p2-79 (p80-pdf). "]
[null,null,null,{"$f":"1+D333","v":106},null,null,null,"Cost Effectiveness Method 2",null,null,null,null,"Costeffect,$2012,2 ","2012$/ton NOxR",null,{"$f":"+IF(P$30=\"SCR\",IFERROR(P326/P328,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(R326/R328,\"\"),\"\")","v":""}]
[]
[null,null,null,{"$f":"1+D334","v":107},null,null,"Year Control is effective",null,null,null,null,null,null,null,null,{"$f":"+IF(P$30=\"SCR\",'Data Entry'!$P$84,\"\")","v":""},null,null,null,"Year control is effective (or current year), as entered on Data Entry, Line 28."]
[null,null,null,{"$f":"1+D336","v":108},null,null,null,"Cost Effectiveness Method 1",null,null,null,null,"Costeffect,yr,1 ","$/ton NOxR",null,{"$f":"+IF(P$30=\"SCR\",IFERROR(P333*'Data Entry'!$P$85,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(R333*'Data Entry'!$P$85,\"\"),\"\")","v":""},null,"Control cost effectiveness adjusted for the year air pollution  control is effective (or current year), for either Method 1 or Method 2."]
[null,null,null,{"$f":"1+D337","v":109},null,null,null,"Cost Effectiveness Method 2",null,null,null,null,"Costeffect,yr,2 ","$/ton NOxR",null,{"$f":"+IF(P$30=\"SCR\",IFERROR(P334*'Data Entry'!$P$85,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SCR\",IFERROR(R334*'Data Entry'!$P$85,\"\"),\"\")","v":""}]

{"sheet":"SNCR","index":6,"n_rows":287,"n_cols":27,"rows_kept":287,"cut":false,"hidden":false,"merged":[[149,7,150,10],[240,19,242,26],[158,19,159,26],[140,19,142,26],[161,19,163,26],[221,15,221,17],[177,19,179,26],[173,19,175,26],[185,19,186,26],[216,19,218,26],[181,19,183,26],[202,19,203,26],[205,19,206,26],[194,19,196,26],[198,19,199,26],[223,15,223,19],[101,19,102,26],[245,19,247,26],[274,19,275,26],[19,3,22,3],[85,15,85,17],[53,19,54,26],[67,19,69,26],[57,19,59,26],[65,19,66,26],[21,15,22,15],[21,17,22,17],[42,19,44,26],[37,19,40,26],[63,19,64,26],[76,19,77,26],[92,7,93,10],[281,15,281,17],[285,15,285,17],[120,15,120,17],[257,19,258,26],[282,19,283,26],[249,19,250,26],[264,19,265,26],[188,19,189,26],[191,19,192,26],[230,19,231,26],[236,19,238,26],[271,19,272,26],[233,19,234,26],[120,19,123,26],[132,19,136,26],[252,19,255,26],[15,19,16,26],[8,10,9,15],[11,19,12,26],[19,5,22,10],[19,12,22,12],[19,13,22,13],[13,19,14,26],[48,19,49,26],[19,15,19,17],[19,19,22,26],[87,19,88,26],[29,19,31,26],[25,19,26,26],[224,15,225,26],[227,19,228,26],[9,19,10,26],[113,19,115,26],[97,19,99,26],[209,19,211,26],[145,19,147,26],[149,19,150,26],[155,19,156,26],[109,19,111,26],[125,19,130,26],[165,19,166,26],[168,19,169,26],[106,19,107,26],[117,19,118,26],[91,19,95,26]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revision:","02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev. Date:","2016-08-31"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"AIR POLLUTION CONTROL COST EFFECTIVENESS ASSESSMENT \nFOR USE WITH RCSA SECTION 22a-174-22e(h)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"References:",1,"EPA Air Pollution Control Cost Manual - Seventh Edition, Section 4 - NOx Controls: \nChapter 1 - Selective Noncatalytic Reduction, May 2016."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+S10","v":2},"EPA Air Pollution Control Cost Manual - Seventh Edition, Section 4 - NOx Controls: \nChapter 2 - Selective Catalytic Reduction, May 2016."]
[]
[null,null,null,null,null,null,null,null,null,null,"SELECTIVE NONCATALYTIC REDUCTION - SNCR",null,null,null,null,null,null,null,{"$f":"1+S12","v":3},"EPA Air Pollution Control Cost Manual - Sixth Edition (EPA 452/B-02-001), January 2002."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+S14","v":4},"Alternative Control Techniques Document - NOx Emissions from Stationary Gas Turbines - EPA ACT Document No.:  EPA-453/R-93-007."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+S16","v":5},"U.S Department of Labor - Bureau of Labor Statistics: CPI Inflation Calculator."]
[]
[null,null,null,"Line",null,"Item Description",null,null,null,null,null,null,"Symbol","Units",null,"Input",null,null,null,"Comments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Column 1.",null,"Column 2."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Default Operation",null,"Limited Operation"]
[]
[null,null,null,0]
[null,null,null,null,"SNCR ASSUMPTIONS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF('Data Entry'!P42=\"Yes\",\"\",\"Note:\")","v":"Note:"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF('Data Entry'!P42=\"Yes\",\"\",\"Select SNCR on Data Entry, Line 14, in order to see control cost effectiveness calculation.\")","v":"Select SNCR on Data Entry, Line 14, in order to see control cost effectiveness calculation."}]
[null,null,null,null,"I.","Air Pollution Control Assumptions"]
[]
[null,null,null,null,null,null,"Control Unit Specifications"]
[null,null,null,1,null,null,null,"Control Type",null,null,null,null,null,null,null,{"$f":"+IF('Data Entry'!P42=\"Yes\",IF(OR('Data Entry'!P56=\"\",'Data Entry'!P78=\"\",'Data Entry'!P80=\"\"),\"\",IF(LEFT('Data Entry'!T56,5)=\"Error\",\"\",\"SNCR\")),\"\")","v":""},null,{"$f":"+IF(P30=\"\",\"\",IF(AND('Data Entry'!P42=\"Yes\",'Data Entry'!R111>0),\"SNCR\",\"\"))","v":""},null,{"$f":"IF(AND('Data Entry'!P42=\"Yes\",OR('Data Entry'!P$22=\"\",'Data Entry'!P$24=\"\",'Data Entry'!P$29=\"\",'Data Entry'!P$31=\"\",'Data Entry'!P$32=\"\",AND('Data Entry'!P$46=\"\",'Data Entry'!P$49=\"\"),'Data Entry'!P$52=\"\",'Data Entry'!P$56=\"\",'Data Entry'!P$62=\"\",'Data Entry'!P$64=\"\",'Data Entry'!P$66=\"\",'Data Entry'!P$78=\"\",'Data Entry'!P$80=\"\",'Data Entry'!P$84=\"\",'Data Entry'!P$85=\"\",'Data Entry'!P$89=\"\",'Data Entry'!P$143=\"\",'Data Entry'!P$146=\"\")),\"Error: Check Data Entry page and ensure that SNCR is selected on Line 14 and all other required fields are specified. \",IF(AND('Data Entry'!P42=\"Yes\",'Data Entry'!R111>0),\"SNCR cost effectiveness calculation is displayed down the column, for both ''Default Operation'' and ''Limited Operation''.\",\"SNCR cost effectiveness calculation is displayed down the column, for ''Default Operation''. To show calculation on ''Limited Operation'' column, enter no. of hours on Data Entry page, Line 33, Column 2, otherwise the entire column is blank.\"))","v":"SNCR cost effectiveness calculation is displayed down the column, for ''Default Operation''. To show calculation on ''Limited Operation'' column, enter no. of hours on Data Entry page, Line 33, Column 2, otherwise the entire column is blank."}]
[]
[]
[]
[null,null,null,{"$f":"1+D30","v":2},null,null,null,"Number of SNCRs per Combustion Unit",null,null,null,null,"NSNCR",null,null,{"$f":"+IF(P$30=\"SNCR\",1,\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",1,\"\")","v":""},null,"Selected design criteria: one SNCR system per emission unit."]
[]
[null,null,null,{"$f":"1+D34","v":3},null,null,null,"SNCR Operating Time",null,null,null,null,"top, control","hrs",null,{"$f":"+IF(P$30=\"SNCR\",'Data Entry'!P119*24,\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",'Data Entry'!R119*24,\"\")","v":""},null,"Air Pollution Control Annual Hrs of Operation, as entered on Data Entry, Line 34."]
[]
[null,null,null,{"$f":"1+D36","v":4},null,null,null,"SNCR Removal Efficiency (default value)",null,null,null,null,"h NOxR","%",null,{"$f":"+IF(P$30=\"SNCR\",40%,\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",40%,\"\")","v":""},null,"Assumed 40%. Per Ref. 1, §1.1 - Introduction, pages 1-3 (p3-pdf) through 1-7 \n(p7-pdf), urea based SNCR's exhibit NOx reduction efficiencies of 25% to 60%. Selected efficiency may be adjusted if NOxout calculated value falls below the SNCR attainable limit."]
[]
[]
[]
[]
[null,null,null,{"$f":"1+D38","v":5},null,null,null,"SNCR Lowest Attained NOxout Rate",null,null,null,null,"NOxout, min","lb/MMBtu",null,{"$f":"+IF(P$30=\"SNCR\",IF('Data Entry'!$P$38=\"non-FB\", 0.1,0.08),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF('Data Entry'!$P$38=\"non-FB\", 0.1,0.08),\"\")","v":""},null,"Lowest achievable NOxout rate, per Ref. 1, §1.4-Cost Analysis, page 1-43 \n(p43-pdf), for non-FB boilers (0.1 lb/MMBtu) and FB boilers (0.08 lb/MMBtu). The limit of 0.08 lb/MMBtu, also assumed for all other types of emission units."]
[]
[]
[null,null,null,null,"II.","Reagent and Reagent Solutions Specifications"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,"Reagent Properties"]
[null,null,null,{"$f":"1+D43","v":6},null,null,null,"Reagent type",null,null,null,null,null,null,null,{"$f":"+IF(P$30=\"SNCR\",\"urea\",\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",\"urea\",\"\")","v":""},null,"Selected SNCR default reagent, based on considerations in Ref. 1, §1.2.2 - Reagents, pages 1-13 through 1-15 (p13-p15, pdf). "]
[]
[]
[null,null,null,{"$f":"1+D49","v":7},null,null,null,"Reagent Molecular Weight",null,null,null,null,"Mreagent","lb/mole",null,{"$f":"+IF(P$30=\"SNCR\",VLOOKUP(MATCH(P49,c_id,0),cmp,tbl!$G$7,FALSE),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",VLOOKUP(MATCH(R49,c_id,0),cmp,tbl!$G$7,FALSE),\"\")","v":""},null,"Urea Molecular Weight, per Ref. 1, Table 1.4, page 1-14 (p14-pdf)."]
[]
[null,null,null,{"$f":"1+D52","v":8},null,null,null,"Theoretical Stoichiometric Ratio",null,null,null,null,"SRT",null,null,{"$f":"+IF(P$30=\"SNCR\",IF(P49=\"ammonia\",1,IF(P49=\"urea\",2,\"Check the reagent\")),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF(R49=\"ammonia\",1,IF(R49=\"urea\",2,\"Check the reagent\")),\"\")","v":""},null,"Term in eq. (1.15), Ref. 1, §1.3.1 - Design Parameters for Study-Level Estimate, Normalized Stoichiometric Ratio, page 1-38 (p38-pdf)."]
[]
[null,null,null,null,null,null,"Water Properties"]
[null,null,null,{"$f":"1+D54","v":9},null,null,null,"Water Standard Density",null,null,null,null,"ρwater","lb/gal",null,{"$f":"+IF(P$30=\"SNCR\",VLOOKUP(MATCH(LEFT(H57,5),p_id,0),prp,tbl!$H$17,FALSE),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",VLOOKUP(MATCH(LEFT(H57,5),p_id,0),prp,tbl!$H$17,FALSE),\"\")","v":""},null,"Per Ref.1, §1.4.2-Total Annual Cost, Water Consumption, eq.(1.44), p1-54(p54-pdf)."]
[null,null,null,{"$f":"1+D57","v":10},null,null,null,"Water Heat of Vaporization (at 310ºF)",null,null,null,null,"Hv","Btu/lb",null,{"$f":"+IF(P$30=\"SNCR\",VLOOKUP(MATCH(LEFT(H58,5),p_id,0),prp,tbl!$I$17,FALSE),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",VLOOKUP(MATCH(LEFT(H58,5),p_id,0),prp,tbl!$I$17,FALSE),\"\")","v":""},null,"Per Ref. 1, §1.4.2 - Total Annual Cost, Additional Fuel to Vaporize Water in Reagent Solution, eq. (1.47) pages 1-54 & 1-55 (p54-p55, pdf); Note: Urea 10% solution has same Hv as water. 310ºF is the representative temperature for an exiting flue gas."]
[]
[]
[null,null,null,null,null,null,"Storage"]
[null,null,null,{"$f":"1+D58","v":11},null,null,null,"Stored Urea Solution Concentration",null,null,null,null,"Curea sol stored","% by weight",null,{"$f":"+IF(P$30=\"SNCR\",50%,\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",50%,\"\")","v":""},null,"Typical value, per Ref. 1, §1.2.2 - Reagents, page 1-14 (p14-pdf)."]
[]
[null,null,null,{"$f":"1+D62","v":12},null,null,null,"Urea 50% Solution Density",null,null,null,null,"ρ50% urea","lb/ft³",null,{"$f":"+IF(P$30=\"SNCR\",VLOOKUP(MATCH(P49&\" \"&P62*100&\"%\",p_id,0),prp,tbl!$G$17,FALSE),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",VLOOKUP(MATCH(R49&\" \"&R62*100&\"%\",p_id,0),prp,tbl!$G$17,FALSE),\"\")","v":""},null,"Per Table 1-4-Urea and Ammonia Reagent Properties, Ref. 1, §1.2.2-Reagents, \npage 1-14 (p14-pdf)."]
[]
[null,null,null,{"$f":"1+D64","v":13},null,null,null,"Injected Urea Concentration",null,null,null,null,"Curea sol injected","% by weight",null,{"$f":"+IF(P$30=\"SNCR\",10%,\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",10%,\"\")","v":""},null,"Per Ref. 1, §1.2.4 - SNCR System, Diluting, Metering and Mixing of the Reagent, \npage 1-26 (p26-pdf). Selected 10% as default."]
[]
[null,null,null,{"$f":"1+D66","v":14},null,null,null,"No. Storage Days",null,null,null,null,"tstorage","days",null,{"$f":"+IF(P$30=\"SNCR\",14,\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",14,\"\")","v":""},null,"Common onsite storage requirement, per Ref. 1, §1.3.1 - Design Parameters for Study-Level Estimate, Estimating Reagent Consumption and Tank Size, eq.(1.21), page 1-41 (p41-pdf)."]
[]
[]
[null,null,null,null,"III.","Specific Economic Factors"]
[]
[null,null,null,null,null,null,"SNCR Costs Factors"]
[null,null,null,{"$f":"1+D68","v":15},null,null,null,"Ash Disposal Cost",null,null,null,null,"Costash","$/ton",null,{"$f":"+IF(P$30=\"SNCR\",IF(P121=\"coal\",15,\"N/A\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF(P121=\"coal\",15,\"N/A\"),\"\")","v":""},null,"For coal unit only, per Ref. 1, § 1.5-Example Problem, p1-58 (p58-pdf)."]
[]
[null,null,null,null,null,null,"Capital Cost Elevation Factor"]
[null,null,null,{"$f":"1+D74","v":16},null,null,null,"Elevation Factor",null,null,null,null,"ELEVF",null,null,{"$f":"+IF(P$30=\"SNCR\",IF('Data Entry'!P29=\"\",\"\",14.696/(2116*((59-0.00356*'Data Entry'!P29+459.7)/518.6)^5.256/144)),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF('Data Entry'!P29=\"\",\"\",14.696/(2116*((59-0.00356*'Data Entry'!P29+459.7)/518.6)^5.256/144)),\"\")","v":""},null,"Calculated per eq's. (1.22) & (1.23), Ref. 1, §1.4.1 - Total Capital Investment, \npage 1-45 (p45-pdf). "]
[]
[]
[]
[null,null,null,null,"SNCR SIZING"]
[]
[null,null,null,null,"I.","Emission Unit Performance Data at 8760 hrs"]
[]
[null,null,null,null,null,null,"Emission Unit Data"]
[null,null,null,{"$f":"1+D77","v":17},null,null,null,"Unit Type",null,null,null,null,null,null,null,{"$f":"+IF(P$30=\"SNCR\",IF('Data Entry'!P32=\"\",\"\",'Data Entry'!P32),\"\")","v":""},null,null,null,"Emission unit type selected on Data Entry page Line 10."]
[]
[null,null,null,{"$f":"1+D86","v":18},null,null,null,{"$f":"+IF(P86=\"Boiler\",\"Boiler Type Factor (for boilers only)\",\"\")","v":""},null,null,null,null,{"$f":"+IF(P86=\"Boiler\",\"BTF\",\"\")","v":""},null,null,{"$f":"+IF(P$30=\"SNCR\",IF($P$86=\"Boiler\",IF('Data Entry'!$P$38=\"non-FB\",1,0.75),\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF($P$86=\"Boiler\",IF('Data Entry'!$P$38=\"non-FB\",1,0.75),\"\"),\"\")","v":""},null,{"$f":"+IF(P86=\"Boiler\",\"Based on the specification in the Data Entry ''Combustion Type'' field, whether the boiler is ''FB'' (BTF=0.75) or ''non-FB'' (BTF=1).\",\"Line 18 - intentionally left blank\")","v":"Line 18 - intentionally left blank"}]
[]
[]
[null,null,null,{"$f":"1+D88","v":19},null,null,null,"Maximum Heat Rate Input",null,null,null,null,"QB","MMBtu/hr",null,{"$f":"+IF(P$30=\"SNCR\",IF(OR(P86=\"Combined cycle\",P86=\"Boiler\"),'Data Entry'!P46,IFERROR('Data Entry'!P49*'Data Entry'!P52,\"\")),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF(OR(P86=\"Combined cycle\",P86=\"Boiler\"),'Data Entry'!P46,IFERROR('Data Entry'!P49*'Data Entry'!P52,\"\")),\"\")","v":""},null,{"$f":"+IF(T92=\"\",\"Space intentionally left blank\",\"\")","v":"Space intentionally left blank"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(P30=\"\",\"\",IF(P91='Data Entry'!P46,\"\",\"Error: Check, Max. Heat Rate Input should be \"&P91&\" MMBtu/hr, instead of \"&IF('Data Entry'!P46=\"\",\"''Blank''\",'Data Entry'!P46)&\" MMBtu/hr, as selected on ''Data Entry'' page, if NPHR is listed as \"&'Data Entry'!P52&\" MMBtu/MWh\"&\" and Nominal Power Output is \"&'Data Entry'!P49&\" MW.\"))","v":""}]
[null,null,null,{"$f":"1+D91","v":20},null,null,null,"Power Output (MW Rating) \nat full load capacity.",null,null,null,null,"BMW","MW",null,{"$f":"+IF(P$30=\"SNCR\",IF(OR(P86=\"Combined cycle\",P86=\"Boiler\"),'Data Entry'!P46/'Data Entry'!P52,'Data Entry'!P49),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF(OR(P86=\"Combined cycle\",P86=\"Boiler\"),'Data Entry'!P46/'Data Entry'!P52,'Data Entry'!P49),\"\")","v":""}]
[]
[]
[null,null,null,{"$f":"1+D93","v":21},null,null,null,{"$f":"+IF(OR(P86=\"Combustion Turbine\",P86=\"Engine\"),\"Nominal Plate Heat Rate\",\"Heat Rate\")","v":"Heat Rate"},null,null,null,null,"NPHR","MMBtu/MWh",null,{"$f":"+IF(P$30=\"SNCR\",IF('Data Entry'!P52=\"\",\"\",'Data Entry'!P52),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF('Data Entry'!P52=\"\",\"\",'Data Entry'!P52),\"\")","v":""}]
[]
[null,null,null,{"$f":"1+D96","v":22},null,null,null,"Heat Rate Factor",null,null,null,null,"HRF",null,null,{"$f":"+IF(P$30=\"SNCR\",IF(P96=0,\"\",P96/10),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF(R96=0,\"\",R96/10),\"\")","v":""},null,"Defined by eq. (1.6), Ref. 1, §1.3.1 - Design Parameters for Study-Level Estimates, \np1-35 (p35-pdf), as the ratio of actual NPHR to a typical heat rate of 10 MMBtu/MWh, used in developing capital cost equations."]
[]
[]
[]
[null,null,null,{"$f":"1+D98","v":23},null,null,null,"Annual Hrs of Operation",null,null,null,null,"top, ems unit","hrs",null,{"$f":"+IF(P$30=\"SNCR\",IF('Data Entry'!P111=\"\",\"\",'Data Entry'!P111),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF('Data Entry'!P111=\"\",\"\",'Data Entry'!R111),\"\")","v":""},null,"Data Entry - Emission Unit Annual Hrs of Operation. The air pollution control is assumed to operate at all times the emission unit is operating. "]
[]
[]
[null,null,null,{"$f":"1+D102","v":24},null,null,null,"Heat Input Max Annual",null,null,null,null,"HI","MMBtu/yr",null,{"$f":"+IF(P$30=\"SNCR\",IF(P102=\"\",\"\",IF(P86=\"Combined cycle\",P91*P102,P93*P96*P102)),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF(R102=\"\",\"\",IF(P86=\"Combined cycle\",R91*R102,R93*R96*R102)),\"\")","v":""},null,"Calculated based on BMW and NPHR, or QB, multiplied by the emission unit top, ems unit."]
[]
[null,null,null,{"$f":"1+D105","v":25},null,null,null,"Annual Actual MW Output",null,null,null,null,"Boutput","MW/yr",null,{"$f":"+IF(P$30=\"SNCR\",P93*P102,\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",R93*R102,\"\")","v":""},null,"Power Output, BMW, (Line 20) multiplied by the Annual Hrs. of Operation, top, ems unit (Line 23)."]
[]
[null,null,null,null,null,null,"Operating Capacity Factors"]
[null,null,null,{"$f":"1+D107","v":26},null,null,null,"Emission Unit Capacity Factor",null,null,null,null,"CF ems unit",null,null,{"$f":"+IF(P$30=\"SNCR\",IF(P102=0,\"\",P107/(P93*8760)),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF(R102=0,\"\",R107/(R93*8760)),\"\")","v":""},null,"Per Ref. 1, § 1.3.1 - Design Parameters for Study-Level Estimates, System Capacity Factor, eq. (1.8a), p1-36 (p36-pdf). Since max. MW output is selected, eq. (1.8a) is equivalent with the selected hrs. of operation divided by 8,760 hrs."]
[]
[]
[]
[null,null,null,{"$f":"1+D110","v":27},null,null,null,"SNCR Capacity Factor",null,null,null,null,"CF SNCR",null,null,{"$f":"+IF(P$30=\"SNCR\",IF(P36=\"\",\"\",P36/P102),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF(R36=\"\",\"\",R36/R102),\"\")","v":""},null,"SNCR Capacity Factor is the ratio between SNCR operating time and emission unit operating time, similar to the SCR Capacity Factor defined by eq. (2.9), Ref. 2, §2.3.3 - System Capacity Factor, p2-53 (p54-pdf)."]
[]
[]
[]
[null,null,null,{"$f":"1+D114","v":28},null,null,null,"Total Capacity Factor",null,null,null,null,"CF Total",null,null,{"$f":"+IF(P$30=\"SNCR\",IF(P114*P110=0,\"\",P114*P110),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF(R114*R110=0,\"\",R114*R110),\"\")","v":""},null,"Defined by eq. (1.7),  Ref. 1, § 1.3.1 - Design Parameters for Study-Level Estimates, System Capacity Factor, page 1-35 (p35-pdf)."]
[]
[null,null,null,null,null,null,"Fuel Data"]
[null,null,null,{"$f":"1+D118","v":29},null,null,null,"Fuel Type",null,null,null,null,null,null,null,{"$f":"+IF(P$30=\"SNCR\",IF('Data Entry'!P56=\"\",\"\",'Data Entry'!P56),\"\")","v":""},null,null,null,{"$f":"+IF(P121=\"Coal\",\"Emission unit fuel type selected on Data Entry, Line 19. See also note on Line 19: Since Connecticut has only one coal-fired emission unit that burns a mix of bituminous and sub-bituminous coal only, \"&\"all specifications of this calculation for emission units burning coal are selected for bituminous coal.\",\"Emmision unit fuel type selected on Data Entry, Line 19.\")","v":"Emmision unit fuel type selected on Data Entry, Line 19."}]
[]
[]
[]
[]
[null,null,null,{"$f":"1+D121","v":30},null,null,null,"Air Heater Factor",null,null,null,null,"AHF",null,null,{"$f":"+IF(P$30=\"SNCR\",IF(AND(P121=\"Coal\",'Data Entry'!P64=3,'Data Entry'!P64>3),1,0),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF(AND(P121=\"Coal\",'Data Entry'!P64=3,'Data Entry'!P64>3),1,0),\"\")","v":""},null,{"$f":"+\"Defined in Eq. (1.26), Ref 1, §1.4.1.1 - Utility Boilers, p1-46 (p46-pdf) & 1-47 \n(p47-pdf), as multiplier for Air Pre-Heater Cost. AHF=1, if bituminous coal and SO2>3lb/MMBtu=0 if not true.\"&IF(P121=\"Coal\",\" Note: Since Connecticut has only one coal-fired emission unit that burns a mix of bituminous and (sub)bituminous coal, AHF is ''0'', and the air pre-heater term drops out of the overall SNCR cost eq. for all CT emission units.\",\"\")","v":"Defined in Eq. (1.26), Ref 1, §1.4.1.1 - Utility Boilers, p1-46 (p46-pdf) & 1-47 \n(p47-pdf), as multiplier for Air Pre-Heater Cost. AHF=1, if bituminous coal and SO2>3lb/MMBtu=0 if not true."}]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"1+D126","v":31},null,null,null,{"$f":"+IF(P121=\"Coal\",\"Coal\",\"Fuel\")&\" Factor\"","v":"Fuel Factor"},null,null,null,null,{"$f":"+IF(P121=\"Coal\",\"Coal F\",\"F(factor)\")","v":"F(factor)"},null,null,{"$f":"+IF(P$30=\"SNCR\",1,\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",1,\"\")","v":""},null,"Defined in eq's. (1.25) and (1.26), Ref 1, §1.4.1.1 - Utility Boilers, p1-46 (p46-pdf) and eq's (1.32) and (1.33), Ref 1, §1.4.1.3 - Industrial Boilers, p1-49 (p49-pdf) & 1-50 (p50-pdf), as \"CoalF\" multiplier for coal units. CoalF is replaced with a (Fuel) factor equal to 1, for oil- and gas-fired emission units. CoalF (or FuelF) multiplier applied to CT units is = 1."]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"1+D133","v":32},null,null,null,"Fuel High Heating Value",null,null,null,null,"HHV",{"$f":"+IF(P121=\"Natural Gas\",\"Btu/ft³\",\"Btu/lb\")","v":"Btu/lb"},null,{"$f":"+IF(P$30=\"SNCR\",IF(P121=\"Natural Gas\",VLOOKUP(MATCH(P121,fuels_id,0),fuels,tbl!$I$42,FALSE),IF(P121=\"Coal\",VLOOKUP(MATCH(P121,fuels_id,0),fuels,tbl!$J$42,FALSE),IF(OR(P121=\"Natural Gas\",P121=\"Coal\",P121=\"\"),\"\",VLOOKUP(MATCH(P121,fuels_id,0),fuels,tbl!$J$42,FALSE)))),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF(P121=\"Natural Gas\",VLOOKUP(MATCH(P121,fuels_id,0),fuels,tbl!$I$42,FALSE),IF(P121=\"Coal\",VLOOKUP(MATCH(P121,fuels_id,0),fuels,tbl!$J$42,FALSE),IF(OR(P121=\"Natural Gas\",P121=\"Coal\",P121=\"\"),\"\",VLOOKUP(MATCH(P121,fuels_id,0),fuels,tbl!$J$42,FALSE)))),\"\")","v":""},null,"Per US DOE - Biomass Energy Databook:",null,null,null,"http://cta.ornl.gov/bedb/appendix_a.shtml"]
[]
[null,null,null,{"$f":"1+D139","v":33},null,null,null,"Fuel Cost",null,null,null,null,"Costfuel","$/MMBtu",null,{"$f":"+IF(P$30=\"SNCR\",VLOOKUP(MATCH(P121,fuels_id,0),fuels,tbl!$N$42,FALSE),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",VLOOKUP(MATCH(P121,fuels_id,0),fuels,tbl!$N$42,FALSE),\"\")","v":""},null,"Input from U.S. Energy Information Administration - EIA 2011-2012 data. In the web page below, select year in the Annual Energy Review archives and in Data categories select fuel:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"http://www.eia.gov/totalenergy/data/annual/index.cfm"]
[]
[null,null,null,{"$f":"1+D141","v":34},null,null,null,"Max. Fuel Consumption Rate",null,null,null,null,{"$f":"+IF(P121=\"Natural Gas\",\"V(fuel)\",\"m(fuel)\")","v":"m(fuel)"},{"$f":"+IF(P121=\"Natural Gas\",\"CFH\",\"lb/hr\")","v":"lb/hr"},null,{"$f":"+IF(P$30=\"SNCR\",P105*10^6/P139/P102,\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",P105*10^6/P139/P102,\"\")","v":""},null,"Calculated as hourly heat input (Line 24 divided by Line 23) and divided by the fuel HHV (Line 32), or Maximum Heat Rate Input (QB) on Line 19, divided by fuel HHV - Line 32."]
[]
[]
[]
[null,null,null,{"$f":"1+D146","v":35},null,null,null,"Annual Fuel Consumption \n(estimate based on selected HHV) ",null,null,null,null,"Annual Fuel",{"$f":"+IF(P121=\"Natural Gas\",\"CF/yr\",\"lb/yr\")","v":"lb/yr"},null,{"$f":"+IF(P$30=\"SNCR\",IF(P146=\"\",\"\",P146*P102),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF(R146=\"\",\"\",R146*R102),\"\")","v":""},null,"Fuel consumption rate (Line 33) multiplied by the total annual hours of operation (Line 23)."]
[]
[]
[null,null,null,null,null,null,"NOx Removal Performance"]
[null,null,null,{"$f":"1+D150","v":36},null,null,null,"Uncontrolled NOx Emission Level",null,null,null,null,"NOxin","lb/MMBtu",null,{"$f":"+IF(P$30=\"SNCR\",IF('Data Entry'!P78=\"\",\"\",'Data Entry'!P78),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF('Data Entry'!P78=\"\",\"\",'Data Entry'!P78),\"\")","v":""},null,"Uncontrolled NOx rate,  entered on Data Entry, Line 26."]
[]
[null,null,null,{"$f":"1+D154","v":37},null,null,null,"Controlled NOx Outlet (required rate)",null,null,null,null,"NOxout","lb/MMBtu",null,{"$f":"+IF(P$30=\"SNCR\",IF('Data Entry'!P80=\"\",\"\",'Data Entry'!P80),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF('Data Entry'!P80=\"\",\"\",'Data Entry'!P80),\"\")","v":""},null,"Controlled NOx rate, as required by RCSA 22a-174-22e, and listed on \nData Entry, Line 27."]
[]
[]
[null,null,null,{"$f":"1+D156","v":38},null,null,null,"Controlled NOx Outlet (selected)",null,null,null,null,"NOxout,sel","lb/MMBtu",null,{"$f":"+IF(P$30=\"SNCR\",MAX(P156,P43,P154-P38*P154),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",MAX(R156,R43,R154-R38*R154),\"\")","v":""},null,{"$f":"+\"Determined as the highest among: the required controlled NOx out, the SNCR lowest attained NOx out rate, or the NOx out value based on the \"&IF(P$30=\"SNCR\",P38*100&\"% \",\"\")&\"default efficiency.\"","v":"Determined as the highest among: the required controlled NOx out, the SNCR lowest attained NOx out rate, or the NOx out value based on the default efficiency."}]
[]
[]
[null,null,null,{"$f":"1+D159","v":39},null,null,null,"NOx Removal Efficiency\n(selected)",null,null,null,null,"h NOxR,sel","%",null,{"$f":"+IF(P$30=\"SNCR\",IFERROR((P154-P159)/P154,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IFERROR((R154-R159)/R154,\"\"),\"\")","v":""},null,"Defined by eq. (1.10) Ref. 1, §1.3.1. - Design Parameters for Study-Level Estimates, NOx Removal Efficiency, p1-37 (p37-pdf) and calculated based on NOxin on Line 35 and the value of NOxout sel, on Line 37."]
[]
[]
[]
[null,null,null,{"$f":"1+D162","v":40},null,null,null,"NOx Removed Hourly Rate",null,null,null,null,"NOxR/hr","lb/hr",null,{"$f":"+IF(P$30=\"SNCR\",IFERROR(P154*P162*P91,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IFERROR(R154*R162*R91,\"\"),\"\")","v":""},null,"Defined by eq. (1.12), Ref. 1, §1.3.1 - Design Parameters for Study-Level, NOx Removal Rates, \npage 1-37 (p37-pdf)."]
[]
[]
[null,null,null,{"$f":"1+D166","v":41},null,null,null,"NOx Removed (annually)",null,null,null,null,"NOxR","tons",null,{"$f":"+IF(P$30=\"SNCR\",IFERROR((P154*P162*P91*P118*8760)/2000,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IFERROR((R154*R162*R91*R118*8760)/2000,\"\"),\"\")","v":""},null,"Defined by eq. (1.11), Ref. 1, §1.3 - Design Parameters for Study-Level, NOx Removal Rates, page 1-37 (p37-pdf)."]
[]
[null,null,null,null,"II.","Reagent Calculations"]
[]
[null,null,null,null,null,null,"Reagent Data"]
[null,null,null,{"$f":"1+D169","v":42},null,null,null,"Normalized Stoichiometric Ratio",null,null,null,null,"NSR",null,null,{"$f":"+IF(P$30=\"SNCR\",IFERROR((2*P154+0.7)*P162/P154,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IFERROR((2*R154+0.7)*R162/R154,\"\"),\"\")","v":""},null,"Ratio of moles of equivalent NH3 injected to the moles of uncontrolled NOx, defined by empirical eq. (1.17), Ref. 1, §1.3.1 - Design Parameters for Study-Level, Normalized Stoichiometric Ratio, page 1-38 (P38-pdf)."]
[]
[]
[]
[null,null,null,{"$f":"1+D174","v":43},null,null,null,"Actual Stoichiometric Ratio",null,null,null,null,"ASR",null,null,{"$f":"+IF(P$30=\"SNCR\",P174/P54,\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",R174/R54,\"\")","v":""},null,"Ratio of moles of reagent reacted to the moles of uncontrolled NOx, defined by eq. (1.15), Ref. 1, §1.3.1 - Design Parameters for Study-Level, Normalized Stoichiometric Ratio, page 1-38 (P38-pdf)."]
[]
[]
[]
[null,null,null,{"$f":"1+D178","v":44},null,null,null,"Utilization",null,null,null,null,"Utilization",null,null,{"$f":"+IF(P$30=\"SNCR\",IFERROR(P162/P174,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IFERROR(R162/R174,\"\"),\"\")","v":""},null,"Ratio of moles of reagent reacted to the mole injected - defined by eq. (1.16), Ref. 1, §1.3.1 - Design Parameters for Study-Level, Normalized Stoichiometric Ratio, page 1-38 (P38-pdf)."]
[]
[]
[null,null,null,null,null,null,"Flow Rates"]
[null,null,null,{"$f":"1+D182","v":45},null,null,null,{"$f":"+PROPER(P49)&\" Consumption\"","v":" Consumption"},null,null,null,null,"ṁreagent","lb/hr",null,{"$f":"+IF(P$30=\"SNCR\",IFERROR(P154*P91*P162*$P$178*$P$52/'Data Entry'!$P$161,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IFERROR(R154*R91*R162*$R$178*$R$52/'Data Entry'!$P$161,\"\"),\"\")","v":""},null,"Eq. (1.18), Ref. 1, §1.3.1 - Design Parameters for Study-Level, Estimating Reagent Consumption and Tank Size, page 1-40 (p40-pdf)."]
[]
[null,null,null,null,null,null,null,"Aqueous Urea 50% Solution"]
[null,null,null,{"$f":"1+D186","v":46},null,null,null,null,"Mass Flow Rate",null,null,null,"ṁsol","lb/hr",null,{"$f":"+IF(P$30=\"SNCR\",IFERROR(P186/$P$62,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IFERROR(R186/$R$62,\"\"),\"\")","v":""},null,"Eq. (1.19), Ref. 1, §1.3.1 - Design Parameters for Study-Level, Estimating Reagent Consumption and Tank Size, page 1-40 (p40-pdf)."]
[]
[]
[null,null,null,{"$f":"1+D189","v":47},null,null,null,null,"Volumetric Flow Rate",null,null,null,"qsol","gph",null,{"$f":"+IF(P$30=\"SNCR\",IFERROR(P189*7.4805/$P$64,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IFERROR(R189*7.4805/$R$64,\"\"),\"\")","v":""},null,"Eq. (1.20), Ref. 1, §1.3.1 - Design Parameters for Study-Level, Estimating Reagent Consumption and Tank Size, page 1-40 (p40-pdf)."]
[]
[null,null,null,null,null,null,"Fuel Rq'd to Vaporize Water in Reagent Solution"]
[null,null,null,{"$f":"1+D192","v":48},null,null,null,"Fuel to Prepare 10% Reagent Sol.",null,null,null,null,"ΔFuelReagent","MMBtu/hr",null,{"$f":"+IF(P$30=\"SNCR\",IFERROR(P58*P186*(1/P66-1)/10^6,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IFERROR(R58*R186*(1/R66-1)/10^6,\"\"),\"\")","v":""},null,"Additional fuel to evaporate the injected water in 10% urea solution, estimated by eq's (1.47) and (1.48), Ref.1,  §1.4.2. - Total Annual Cost, Additional Fuel to Vaporize Water in Reagent Solution, pages: 1-54, 1-55 (p54-55, pdf). "]
[]
[]
[null,null,null,null,null,null,"Storage"]
[null,null,null,{"$f":"1+D195","v":49},null,null,null,"Storage Tank Volume",null,null,null,null,null,"gal",null,{"$f":"+IF(P$30=\"SNCR\",IFERROR(P192*P68*24,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IFERROR(R192*R68*24,\"\"),\"\")","v":""},null,"Eq. (1.21), Ref. 1, §1.3.1 - Design Parameters for Study-Level, Estimating Reagent Consumption and Tank Size, page 1-41 (p41-pdf)."]
[]
[null,null,null,null,"III.","Utilities"]
[]
[null,null,null,{"$f":"1+D199","v":50},null,null,null,"Power Consumption",null,null,null,null,"P","kW",null,{"$f":"+IF(P$30=\"SNCR\",IFERROR(0.47*P154*P174*P91/P96,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IFERROR(0.47*R154*R174*R91/R96,\"\"),\"\")","v":""},null,"Estimated by eq. (1.42), Ref. 1, §1.4.2. Total Annual Costs, Utilities, page 1-53 \n(p53-pdf)."]
[]
[]
[null,null,null,{"$f":"1+D203","v":51},null,null,null,"Water Consumption",null,null,null,null,"q water","gph",null,{"$f":"+IF(P$30=\"SNCR\",P189/P57*(P62/P66-1),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",R189/R57*(R62/R66-1),\"\")","v":""},null,"Estimated by eq. (1.44), Ref. 1, §1.4.2. Total Annual Costs, Water Consumption, page 1-54 (p54-pdf)."]
[]
[null,null,null,null,{"$f":"+IF(Q121=\"Coal\",\"IV.\",\"\")","v":""},{"$f":"+IF(P121=\"Coal\",\"Ash Disposal\",\"\")","v":""}]
[]
[null,null,null,{"$f":"1+D206","v":52},null,null,null,{"$f":"+IF(P121=\"Coal\",\"Coal Ash Disposal\",\"\")","v":""},null,null,null,null,{"$f":"+IF(P121=\"Coal\",\"ΔAsh\",\"\")","v":""},{"$f":"+IF(P121=\"Coal\",\"lb/hr\",\"\")","v":""},null,{"$f":"+IF(P121=\"Coal\",IF(P$30=\"SNCR\",P195*'Data Entry'!$P$66*10^6/P139,\"\"),\"\")","v":""},null,{"$f":"+IF(P121=\"Coal\",IF(R$30=\"SNCR\",R195*'Data Entry'!$P$66*10^6/R139,\"\"),\"\")","v":""},null,"Disposal of ash in added fuel used to vaporize water in reagent solution, estimated by eq. (1.50), Ref. 1, §1.4.2. Total Annual Costs, Coal Ash Disposal, page 1-55 (p55-pdf)."]
[]
[]
[]
[]
[null,null,null,null,"SNCR COST ESTIMATION"]
[]
[null,null,null,null,"TOTAL CAPITAL COST",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+\"Calculated with eq. (1-24), Ref. 1, §1.4.1.1 - Utility Boilers, Coal-fired Units, p1-45 (p45-pdf), or with eq. (1-28), Ref. 1, §1.4.1.2 - Utility Boilers, Oil- and gas-fired units,p1-47 (p47-pdf) for units ≥25MW)\"&\" and in addition, with the above cost adj. multiplier, for turbines and combined cycle units.\"","v":"Calculated with eq. (1-24), Ref. 1, §1.4.1.1 - Utility Boilers, Coal-fired Units, p1-45 (p45-pdf), or with eq. (1-28), Ref. 1, §1.4.1.2 - Utility Boilers, Oil- and gas-fired units,p1-47 (p47-pdf) for units ≥25MW) and in addition, with the above cost adj. multiplier, for turbines and combined cycle units."}]
[]
[null,null,null,null,"I.","Total Capital Investment (TCI) Estimate"]
[]
[null,null,null,null,null,null,"Retrofit Factor"]
[null,null,null,{"$f":"1+D210","v":53},null,null,null,"Selective Noncatalytic Reduction System",null,null,null,null,"RFSNCR",null,null,{"$f":"+IF(P$30=\"SNCR\",IF('Data Entry'!P89=\"\",\"\",'Data Entry'!P89),\"\")","v":""},null,null,null,"SNCR System Retrofit Factor entered on Data Entry page, Line 31."]
[]
[null,null,null,null,null,null,"SNCR Partial Costs",null,null,null,null,null,null,null,null,{"$f":"+IF(P86=\"Boiler\",\"Note:\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(P86=\"Boiler\",\"Connecticut has no industrial boliers and only one utility bolier. Therefore, SNCR partial costs for that unit are determined using EPA's formulas for utility boliers.\",\"\")","v":""}]
[]
[]
[null,null,null,{"$f":"1+D222","v":54},null,null,null,"Capital Cost of SNCR Base Unit",null,null,null,null,"SNCRcost","$",null,{"$f":"+IF(P$30=\"SNCR\",IFERROR(IF(P121=\"Coal\",220000*(P93*P98)^0.42*P133*P88*P77*P222,147000*(P93*P98)^0.42*P77*P222),\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IFERROR(IF(P121=\"Coal\",220000*(R91/10)^0.42*R133*R88*R77,147000*R77*(R91/10)^0.42),\"\"),\"\")","v":""},null,{"$f":"+IF(P$30=\"SNCR\",IF(AND(P86=\"Boiler\",P121=\"Coal\"),\"Calculated with eq. (1.25), Ref. 1, §1.4.1.1 - Utility Boilers, Coal-fired Units, page 1-46 (p46-pdf).\",\"Calculated with eq. (1.29), Ref. 1, §1.4.1.2 - Utility Boilers, Oil- and gas-fired units, page 1-48 (p48-pdf).\"),\"\")","v":""}]
[]
[]
[null,null,null,{"$f":"1+D228","v":55},null,null,null,"Balance of Plant Cost",null,null,null,null,"BOPCost","$",null,{"$f":"+IF(P$30=\"SNCR\",IFERROR(IF($P$121=\"Coal\",320000*P93^0.33*P166^0.12*P88*$P$222,213000*(P91/P96)^0.33*P166^0.12*$P$222),\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IFERROR(IF($P$121=\"Coal\",320000*R93^0.33*R166^0.12*R88*$P$222,213000*(R91/R96)^0.33*R166^0.12*$P$222),\"\"),\"\")","v":""},null,{"$f":"+IF(P$30=\"SNCR\",IF(AND(P86=\"Boiler\",P121=\"Coal\"),\"Calculated withEq. (1.27), Ref. 1, §1.4.1.1 - Utility Boilers, Coal-fired Units, page 1-47 (p47-pdf).\",\"Calculated with Eq. (1.30), Ref. 1, §1.4.1.2 - Utility Boilers, Oil- and gas-fired units, page 1-48 (p48-pdf).\"),\"\")","v":""}]
[]
[]
[null,null,null,{"$f":"1+D231","v":56},null,null,null,{"$f":"+IF(OR(AND(P86=\"Boiler\",P121=\"Coal\"),$P$86=\"\"),\"Air Pre-Heater Modification Cost\",\"\")","v":"Air Pre-Heater Modification Cost"},null,null,null,null,{"$f":"+IF(AND(P86=\"Boiler\",P121=\"Coal\"),\"APHC(cost)\",\"\")","v":""},{"$f":"+IF(P$30=\"SNCR\",IF(AND(P86=\"Boiler\",P121=\"Coal\"),\"$\",\"\"),\"\")","v":""},null,{"$f":"+IF(P$30=\"SNCR\",IF(AND(P86=\"Boiler\",P121=\"Coal\"),69000*(P93*P98*P133)^0.78*P126*$P$222,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF(AND(P86=\"Boiler\",P121=\"Coal\"),69000*(R93*R98*R133)^0.78*R126*$P$222,\"\"),\"\")","v":""},null,{"$f":"+IF(P$30=\"SNCR\",IF(AND(P86=\"Boiler\",P121=\"Coal\"),\"Eq. (1.26), Ref. 1  §1.4.1.1 - Utility Boilers, Coal-fired Units, page 1-46 (p46-pdf). APHC(cost) is zero for units burning coal with SO₂ content less than 3 lb/MMBtu.\",\"Line 56 - intentionally left blank\"),\"\")","v":""}]
[]
[]
[null,null,null,{"$f":"1+D234","v":57},null,null,{"$f":"+IF($P$86=\"Boiler\",\"\",\"Cost Adjustment Factor\")","v":"Cost Adjustment Factor"},null,null,null,null,null,{"$f":"+IF($P$86=\"Boiler\",\"\",\"CAF\")","v":"CAF"},null,null,{"$f":"+IF(P$30=\"SNCR\",IF($P$86=\"Boiler\",\"\",IF($P$121=\"Natural Gas\",1.1,IF($P$121=\"Coal\",0,1.1))),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF($P$86=\"Boiler\",\"\",IF($P$121=\"Natural Gas\",1.1,IF($P$121=\"Coal\",0,1.1))),\"\")","v":""},null,{"$f":"+IF($P$86=\"Boiler\",\"Line 57 - intentionally left blank\",IF(P237=0,\"Error - Emission units other than boliers are oil- and gas- fired units; Select other fuel than coal on Data Entry, Line 19\",\"Multiplier used with the TCI for utility boilers so that it may be applied to all other units (i.e., engines and turbines).  EPA has not provided a specific fomula for the turbines and engines in the 2016 referenced documents.\"))","v":"Multiplier used with the TCI for utility boilers so that it may be applied to all other units (i.e., engines and turbines).  EPA has not provided a specific fomula for the turbines and engines in the 2016 referenced documents."}]
[]
[]
[]
[null,null,null,{"$f":"1+D237","v":58},null,null,"Total Capital Investment",null,null,null,null,null,"TCI","$",null,{"$f":"+IF(P$30=\"SNCR\",IFERROR(IF(P121=\"Coal\",1.3*(P228+P234+P231),IF(P86=\"Boiler\",1.3*(P228+P231),1.3*(P228+P231)*P237)),\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IFERROR(IF(P121=\"Coal\",1.3*(R228+R234+R231),1.3*(R228+R231)),\"\"),\"\")","v":""},null,{"$f":"+IF(P241=0,\"Error - Check unit type selected on Data Entry , Line 10, and fuel on Data Entry, Line 19 - Only boilers are burning coal, all other emission units are oil- and gas-fired emission units. All field cost elements below are blank since TCI is zero by error. \",IF(P121=\"Coal\",\"Calculated with eq. (1.24), Ref. 1, page 1-45 (p45-pdf) for utility boilers ≥25MW, on coal. \",\"Calculated with eq. (1.28), Ref. 1, page 1-47 (p47-pdf) for oil- and gas-fired utility boilers (≥25MW to 500 MW). \")&IF(G237=\"\",\"\",\"Eq. (1.28), is multiplied by CAF to estimate TCI for gas- and oil-fired turbines, combined cycle units and engines.\"))","v":"Calculated with eq. (1.28), Ref. 1, page 1-47 (p47-pdf) for oil- and gas-fired utility boilers (≥25MW to 500 MW). Eq. (1.28), is multiplied by CAF to estimate TCI for gas- and oil-fired turbines, combined cycle units and engines."}]
[]
[null,null,null,null,"II.","Annual Costs"]
[]
[null,null,null,null,null,null,"Direct Annual Elements Cost "]
[null,null,null,{"$f":"1+D241","v":59},null,null,null,"Annual Maintenance",null,null,null,null,"AMC","$/yr",null,{"$f":"+IF(P$30=\"SNCR\",IF(P241=\"\",\"\",0.015*P241),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF(R241=\"\",\"\",0.015*R241),\"\")","v":""},null,"Annual maintenance labor and material (including nozzle tips for injectors) is assumed 1.5% of TCI, per Ref. 1, §1.4.2 -Total Annual Costs, Maintenance, eq. (1.39), page 1-52 (p52-pdf)."]
[]
[]
[]
[null,null,null,{"$f":"1+D246","v":60},null,null,null,"Annual Reagent Cost",null,null,null,null,"ARC","$/yr",null,{"$f":"+IF(P$30=\"SNCR\",IF(P241=\"\",\"\",IFERROR(P192*P118*8760*'Data Entry'!$P$150,\"\")),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF(R241=\"\",\"\",IFERROR(R192*R118*8760*'Data Entry'!$P$150,\"\")),\"\")","v":""},null,"Calculated based on 50% sol. urea consumption (in gal/yr) and specific cost, per eq's. (1.40) and (1.41), Ref. 1 §2.4.2. - Total Annual Cost, p1-53 (p53-pdf)."]
[]
[]
[null,null,null,{"$f":"1+D250","v":61},null,null,null,"Annual Electricity",null,null,null,null,"AEC","$/yr",null,{"$f":"+IF(P$30=\"SNCR\",IF(P241=\"\",\"\",IFERROR(P203*P118*8760*'Data Entry'!$P$143,\"\")),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF(R241=\"\",\"\",IFERROR(R203*R118*8760*'Data Entry'!$P$143,\"\")),\"\")","v":""},null,"Based on the annual power consumption (P, Line 50), multiplied by the control operating time, top,control, Line 3 (or equivalent CFTotal x 8,760) and electricity specific cost (Data Entry, Line 41), per eq (1.43),  Ref. 1 § 1.4.2. - Total Annual Cost, \npage 1-53 (p53-pdf)."]
[]
[]
[]
[]
[null,null,null,{"$f":"1+D253","v":62},null,null,null,"Annual Water Cost",null,null,null,null,"AWC","$/yr",null,{"$f":"+IF(P$30=\"SNCR\",IF(P241=\"\",\"\",IFERROR(P206*P118*8760*'Data Entry'!$P$146,\"\")),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF(R241=\"\",\"\",IFERROR(R206*R118*8760*'Data Entry'!$P$146,\"\")),\"\")","v":""},null,"Annual water consumption times water specific cost, per eq. (1.46), Ref. 1, §1.4.2. - Total Annual Cost, page 1-54 (p54-pdf)."]
[]
[]
[null,null,null,{"$f":"1+D258","v":63},null,null,null,"Annual ΔFuel Reagent Cost",null,null,null,null,"ΔFuelReagent","$/yr",null,{"$f":"+IF(P$30=\"SNCR\",IF(P241=\"\",\"\",IFERROR(P195*P36*P141,\"\")),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF(R241=\"\",\"\",IFERROR(R195*R36*R141,\"\")),\"\")","v":""},null,"Per eq. (1.49), Ref. 1, §1.4.2. - Total Annual Cost, page 1-55 (p55-pdf)."]
[]
[null,null,null,{"$f":"1+D261","v":64},null,null,null,{"$f":"+IF($P$121=\"Coal\",\"Annual ΔAsh Cost\",\"\")","v":""},null,null,null,null,{"$f":"+IF(P121=\"Coal\",\"ΔAsh Cost\",\"\")","v":""},{"$f":"+IF($P$121=\"Coal\",\"$/yr\",\"\")","v":""},null,{"$f":"+IF(P$30=\"SNCR\",IF(P241=\"\",\"\",IF($P$121=\"Coal\",P210*P36/2000*P74,\"\")),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF(R241=\"\",\"\",IF($P$121=\"Coal\",R210*R36/2000*R74,\"\")),\"\")","v":""},null,{"$f":"+IF($P$121=\"Coal\",\"Per eq. (1.51), Ref. 1, §1.4.2. - Total Annual Cost, page 1-56 (p56-pdf).\",\"Line 64 - intentionally left blank\")","v":"Line 64 - intentionally left blank"}]
[]
[null,null,null,{"$f":"1+D263","v":65},null,null,"Direct Annual Cost - DAC",null,null,null,null,null,"DAC",{"$f":"+IF($P$121=\"Coal\",\"$/yr\",\"\")","v":""},null,{"$f":"+IF(P$30=\"SNCR\",IF(P241=\"\",\"\",IFERROR(P246+P250+P253+P258+P261+IF($P$121=\"Coal\",P263,0),\"\")),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF(R241=\"\",\"\",IFERROR(R246+R250+R253+R258+R261+IF($P$121=\"Coal\",R263,0),\"\")),\"\")","v":""},null,"Sum of the above direct annual costs, Line 59 through Line 64, per eq. (1.38), \nRef. 1, §2.4.2.-Total Annual Cost, page 1-52, (p52-pdf)."]
[]
[null,null,null,null,null,null,"Indirect Annual Cost (IDAC)"]
[null,null,null,{"$f":"1+D265","v":66},null,null,null,"Administrative Charges",null,null,null,null,"AC","$/yr",null,{"$f":"+IF(P$30=\"SNCR\",IFERROR(0.03*(0+0.4*P246),\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IFERROR(0.03*(0+0.4*R246),\"\"),\"\")","v":""},null,"Per eq. (1.53), Ref. 1 §1.4.2. - Total Annual Cost, page 1-56 (p56-pdf)."]
[]
[null,null,null,{"$f":"1+D268","v":67},null,null,null,"Capital Recovery",null,null,null,null,"CR","$/yr",null,{"$f":"+IF(P$30=\"SNCR\",IFERROR('Data Entry'!P137*P241,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IFERROR('Data Entry'!P137*R241,\"\"),\"\")","v":""},null,"Per eq. (1.54), Ref. 1 §1.4.2. - Total Annual Cost, page 1-57 (p57-pdf)."]
[]
[null,null,null,{"$f":"1+D270","v":68},null,null,null,"Indirect Annual Costs",null,null,null,null,"IDAC","$/yr",null,{"$f":"+IF(P$30=\"SNCR\",IFERROR(P270+P268,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IFERROR(R270+R268,\"\"),\"\")","v":""},null,"Total of the above indirect costs, Line 66 and Line 67, per eq. (1.52), Ref. 1 §1.4.2. - Total Annual Cost, page 1-56 (p56-pdf)."]
[]
[]
[null,null,null,{"$f":"1+D272","v":69},null,null,"Total Annual Cost",null,null,null,null,null,"TAC1",null,null,{"$f":"+IF(P$30=\"SNCR\",IFERROR(P265+P272,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IFERROR(R265+R272,\"\"),\"\")","v":""},null,"Total of direct and indirect costs, per eq.(1.56), Ref. 1, §1.4.2-Total Annual Costs, page 1-57(p57-pdf)."]
[]
[]
[null,null,null,{"$f":"1+D275","v":70},"III.","NOx Removal per year",null,null,null,null,null,null,"NOx R","tons",null,{"$f":"+IF(P$30=\"SNCR\",IF(P241=\"\",\"\",P169),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF(R241=\"\",\"\",R169),\"\")","v":""},null,"Tons of NOx removed calculated above, on Line 41."]
[]
[null,null,null,null,"IV.","Control Cost Effectiveness"]
[]
[null,null,null,{"$f":"1+D278","v":71},null,null,"Base Year",null,null,null,null,null,null,null,null,{"$f":"+IF(P$30=\"SNCR\",'Data Entry'!P126,\"\")","v":""},null,null,null,"Data Entry, Line 36 - Selected base year of EPA's cost analysis."]
[null,null,null,{"$f":"1+D282","v":72},null,null,null,"Cost Effectiveness",null,null,null,null,"Costeffect,$2012","2012$/ton NOxR",null,{"$f":"+IF(P$30=\"SNCR\",IF(P241=\"\",\"\",P275/P278),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF(R241=\"\",\"\",R275/R278),\"\")","v":""},null,"Control cost effectiveness based on TAC divided by the annual tons of NOx removed, per eq. (1.57), Ref. 1, §1.4.2.  - Total Annual Cost, page 1-57 (p57-pdf)."]
[]
[]
[null,null,null,{"$f":"1+D283","v":73},null,null,"Year Control is effective",null,null,null,null,null,null,null,null,{"$f":"+IF(P$30=\"SNCR\",'Data Entry'!$P$84,\"\")","v":""},null,null,null,"Year control is effective (or current year), as entered on Data Entry, Line 28."]
[null,null,null,{"$f":"1+D286","v":74},null,null,null,"Cost Effectiveness",null,null,null,null,"Costeffect,yr","$/ton NOxR",null,{"$f":"+IF(P$30=\"SNCR\",IF(P241=\"\",\"\",P283*'Data Entry'!$P$85),\"\")","v":""},null,{"$f":"+IF(R$30=\"SNCR\",IF(R241=\"\",\"\",R283*'Data Entry'!$P$85),\"\")","v":""},null,"Control cost effectiveness adjusted for the year control is effective (or current year)."]

{"sheet":"HPWI","index":7,"n_rows":234,"n_cols":27,"rows_kept":234,"cut":false,"hidden":false,"merged":[[131,19,132,26],[123,19,124,26],[8,10,9,15],[9,19,10,26],[11,19,12,26],[19,5,22,10],[19,12,22,12],[19,13,22,13],[19,15,19,17],[15,19,16,26],[19,19,22,26],[13,19,14,26],[29,19,31,26],[25,19,26,26],[232,15,232,17],[214,19,215,26],[217,19,218,26],[196,19,199,26],[126,19,129,26],[176,15,176,17],[165,19,166,26],[179,19,180,26],[151,19,152,26],[154,19,155,26],[182,19,183,26],[193,19,194,26],[229,19,230,26],[134,19,136,26],[204,19,209,26],[159,19,160,26],[19,3,22,3],[228,15,228,17],[101,15,101,17],[88,19,88,26],[77,15,77,17],[80,19,83,26],[21,15,22,15],[21,17,22,17],[46,19,48,26],[37,19,38,26],[40,19,42,26],[140,19,141,26],[143,19,144,26],[146,19,147,26],[81,7,82,10],[120,19,121,26],[162,19,163,26],[189,19,191,26],[186,19,187,26],[201,19,202,26],[51,19,53,26],[55,19,56,26],[58,19,59,26],[61,19,62,26],[64,19,65,26],[96,19,97,26],[98,19,99,26],[93,19,95,26],[106,19,108,26],[85,19,86,26],[111,19,112,26],[114,19,115,26]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revision:","02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev. Date:","2016-08-31"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"AIR POLLUTION CONTROL COST EFFECTIVENESS ASSESSMENT \nFOR USE WITH RCSA SECTION 22a-174-22e(h)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"References:",1,"EPA Air Pollution Control Cost Manual - Seventh Edition, Section 4 - NOx Controls: \nChapter 1 - Selective Noncatalytic Reduction, May 2016."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+S10","v":2},"EPA Air Pollution Control Cost Manual - Seventh Edition, Section 4 - NOx Controls: \nChapter 2 - Selective Catalytic Reduction, May 2016."]
[]
[null,null,null,null,null,null,null,null,null,null,"HIGH PRESSURE WATER INJECTION",null,null,null,null,null,null,null,{"$f":"1+S12","v":3},"EPA Air Pollution Control Cost Manual - Sixth Edition (EPA 452/B-02-001), January 2002."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+S14","v":4},"Alternative Control Techniques Document - NOx Emissions from Stationary Gas Turbines - EPA ACT Document No.:  EPA-453/R-93-007."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+S16","v":5},"U.S Department of Labor - Bureau of Labor Statistics: CPI Inflation Calculator."]
[]
[null,null,null,"Line",null,"Item Description",null,null,null,null,null,null,"Symbol","Units",null,"Input",null,null,null,"Comments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Column 1.",null,"Column 2."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Default Operation",null,"Limited Operation"]
[]
[]
[null,null,null,null,"HPWI ASSUMPTIONS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF('Data Entry'!P43=\"Yes\",\"\",\"Note:\")","v":"Note:"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF('Data Entry'!P43=\"Yes\",\"\",\"Select HPWI on Data Entry, Line 15, in order to see control cost effectiveness calculation.\")","v":"Select HPWI on Data Entry, Line 15, in order to see control cost effectiveness calculation."}]
[null,null,null,null,"I.","Air Pollution Control Assumptions"]
[]
[null,null,null,null,null,null,"Control Unit Specifications"]
[null,null,null,1,null,null,null,"Control Type",null,null,null,null,null,null,null,{"$f":"+IF('Data Entry'!P43=\"Yes\",IF(OR('Data Entry'!P56=\"\",'Data Entry'!P56=\"Coal\",'Data Entry'!P78=\"\",'Data Entry'!P80=\"\"),\"\",IF(LEFT('Data Entry'!T56,5)=\"Error\",\"\",\"HPWI\")),\"\")","v":""},null,{"$f":"+IF(P30=\"\",\"\",IF(AND('Data Entry'!P43=\"Yes\",'Data Entry'!R111>0),\"HPWI\",\"\"))","v":""},null,{"$f":"IF(AND('Data Entry'!P43=\"Yes\",OR('Data Entry'!P$22=\"\",'Data Entry'!P$24=\"\",'Data Entry'!P$29=\"\",'Data Entry'!P$31=\"\",'Data Entry'!P$32=\"\",AND('Data Entry'!P$46=\"\",'Data Entry'!P$49=\"\"),'Data Entry'!P$52=\"\",'Data Entry'!P$56=\"\",'Data Entry'!P$62=\"\",'Data Entry'!P$64=\"\",'Data Entry'!P$66=\"\",'Data Entry'!P$78=\"\",'Data Entry'!P$80=\"\",'Data Entry'!P$84=\"\",'Data Entry'!P$85=\"\",'Data Entry'!P$90=\"\",'Data Entry'!P$143=\"\",'Data Entry'!P$146=\"\")),\"Error: Check Data Entry page and ensure that HPWI is selected on Line 15 and all other required fields are specified. \",IF(AND('Data Entry'!P56=\"coal\",R30=\"\"),\"Note: HPWI Cost Effectiveness Calculation is disabled for emission units on coal, since no Connecticut unit burning coal will install HPWI to control NOx emissions.\",IF(AND('Data Entry'!P43=\"Yes\",'Data Entry'!R111>0),\"HPWI cost effectiveness calculation is displayed down the column, for both ''Default Operation'' and ''Limited Operation''.\",\"HPWI cost effectiveness calculation is displayed down the column, for ''Default Operation''. To show calculation on ''Limited Operation'' colum, enter no. of hours on Data Entry page Line 31, Column 2, otherwise the entire column is blank.\")))","v":"HPWI cost effectiveness calculation is displayed down the column, for ''Default Operation''. To show calculation on ''Limited Operation'' colum, enter no. of hours on Data Entry page Line 31, Column 2, otherwise the entire column is blank."}]
[]
[]
[]
[null,null,null,{"$f":"1+D30","v":2},null,null,null,"Number of HPWI per Combustion Unit",null,null,null,null,"NHPWI",null,null,{"$f":"+IF(P$30=\"HPWI\",1,\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",1,\"\")","v":""},null,"Selected design criteria: one HPWI system per emission unit."]
[]
[null,null,null,{"$f":"1+D34","v":3},null,null,null,"HPWI Operating Time",null,null,null,null,"top, control","hrs",null,{"$f":"+IF(P$30=\"HPWI\",'Data Entry'!P119*24,\"\")","v":""},null,{"$f":"+IFERROR(IF(R$30=\"HPWI\",'Data Entry'!R119*24,\"\"),\"\")","v":""},null,"Air Pollution Control Annual Hrs of Operation, as entered on Data Entry, Line 34."]
[]
[null,null,null,{"$f":"1+D36","v":4},null,null,null,"HPWI Removal Efficiency (default value)",null,null,null,null,"h NOxR","%",null,{"$f":"+IF(P$30=\"HPWI\",60%,\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",60%,\"\")","v":""},null,"Selected 60% as default. Control efficiency needs to be recalculated if NOxout falls below the HPWI attainable limit."]
[]
[]
[null,null,null,{"$f":"1+D38","v":5},null,null,null,"HPWI Lowest Attained NOxout Rate",null,null,null,null,"NOxout, min","lb/MMBtu",null,{"$f":"+IF(P$30=\"HPWI\",0.17,\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",0.17,\"\")","v":""},null,"Per Ref. 4, §5.1.4 - Achievable NOx Emissions Using Wet Controls, page 5-53 \n(p144-pdf), 0.17 lb/MMBtu approx. corresponds to 42 ppm (for both natural gas and oils) and is considered a practical achievable lowest NOx rate of a HPWI system."]
[]
[null,null,null,null,"II.","Reagent and Reagent Solutions Specifications"]
[]
[null,null,null,null,null,null,"Water Properties"]
[null,null,null,{"$f":"1+D41","v":6},null,null,null,"Water Standard Density",null,null,null,null,"ρwater","lb/gal",null,{"$f":"+IF(P$30=\"HPWI\",VLOOKUP(MATCH(LEFT(H46,5),p_id,0),prp,tbl!$H$17,FALSE),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",VLOOKUP(MATCH(LEFT(H46,5),p_id,0),prp,tbl!$H$17,FALSE),\"\")","v":""},null,"Defined in eq. (1.44), Ref. 1 (SNCR), §1.4.2-Total Annual Cost, p1-54 (p54-pdf)."]
[null,null,null,{"$f":"1+D46","v":7},null,null,null,"Water Heat of Vaporization (at 310ºF)",null,null,null,null,"Hv","Btu/lb",null,{"$f":"+IF(P$30=\"HPWI\",VLOOKUP(MATCH(LEFT(H47,5),p_id,0),prp,tbl!$I$17,FALSE),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",VLOOKUP(MATCH(LEFT(H47,5),p_id,0),prp,tbl!$I$17,FALSE),\"\")","v":""},null,"Per Ref. 1 (SNCR), §1.4.2 - Total Annual Cost, Additional Fuel to Vaporize Water in Reagent Solution, eq. (1.47) pages 1-54 & 1-55 (p54-p55, pdf); Note: 310ºF is the representative temperature for an exiting flue gas."]
[]
[null,null,null,null,"III.","Specific Economic Factors and Costs"]
[]
[null,null,null,null,null,null,"Capital Cost Elevation Factor"]
[null,null,null,{"$f":"1+D47","v":8},null,null,null,"Elevation Factor",null,null,null,null,"ELEVF",null,null,{"$f":"+IF(P$30=\"HPWI\",IF('Data Entry'!P29=\"\",\"\",14.696/(14.696-0.0005*'Data Entry'!P29)),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IF('Data Entry'!P29=\"\",\"\",14.696/(14.696-0.0005*'Data Entry'!P29)),\"\")","v":""},null,"Multiplier defined by eq. (1.22), Ref. 1 (SNCR), §1.4.1-TCI, p1-41 (p41-pdf) and by eq's. (2.39a) & (2.39b), Ref. 2 (SCR), §2.4.1-TCI, p2-64 & p2-65 (p65/p66-pdf), to be also applied to HPWI."]
[]
[]
[null,null,null,null,null,null,"Cost Adjustment Multiplier 2012$/1990$"]
[null,null,null,{"$f":"1+D52","v":9},null,null,null,"Consumer Price Index Inflation",null,null,null,null,"CPI Inflation","2012$/1990$",null,{"$f":"+IF(P$30=\"HPWI\",1.76,\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",1.76,\"\")","v":""},null,"CPIInflation to convert 1990$ to 2012$ (base year of 2016 EPA's SNCR & SCR Cost Manuals) - see Ref. 5 web link."]
[]
[null,null,null,null,null,null,"HPWI Water Treatment and Disposal Costs"]
[null,null,null,{"$f":"1+D56","v":10},null,null,null,"Water Treatment Cost, $/gal",null,null,null,null,"WTC$/gal","$/gal",null,{"$f":"+IF(P$30=\"HPWI\",1.97/1000*P56,\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",1.97/1000*R56,\"\")","v":""},null,"Water Treatment Cost, WTC$/gal, in 1990$, published on Table 6-3, Ref. 4, p6-213 (p304-pdf), taken as default, times CPIInflation, to convert in 2012$."]
[]
[]
[null,null,null,{"$f":"1+D59","v":11},null,null,null,"Water Treatment Labor Cost, $/gal",null,null,null,null,"WTLC$/gal","$/gal",null,{"$f":"+IF(P$30=\"HPWI\",0.7/1000*P56,\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",0.7/1000*R56,\"\")","v":""},null,"Water Treatment Labor Cost, WTLC$/gal, in 1990$, published on Table 6-5, Ref. 4, p6-222 (p313-pdf), taken as default, times CPIInflation, to convert in 2012$."]
[]
[]
[null,null,null,{"$f":"1+D62","v":12},null,null,null,"Water Disposal Cost, $/gal",null,null,null,null,"WDC$/gal","$/gal",null,{"$f":"+IF(P$30=\"HPWI\",3.82/1000*P56,\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",3.82/1000*R56,\"\")","v":""},null,"Water Disposal Cost, WDC$/gal, in 1990$, published on Table 6-3, Ref. 4, p6-213 (p304-pdf), taken as default, times CPIInflation., to convert in 2012$."]
[]
[null,null,null,null,null,null,"Labor Costs"]
[null,null,null,{"$f":"1+D65","v":13},null,null,null,"Number of hours of operator labor",null,null,null,null,"top, labor","hrs/day",null,{"$f":"+IF(P$30=\"HPWI\",4,\"\")","v":""},null,{"$f":"+IF(P$30=\"HPWI\",4,\"\")","v":""},null,"Per Ref. 2, § 2.5 & 2.6-Ex. Problem(s) 1 and 2, p2-80(p81-pdf) and p2-88(p89-pdf)."]
[]
[null,null,null,{"$f":"1+D68","v":14},null,null,null,"Labor Rate",null,null,null,null,"LR","$/hr",null,{"$f":"+IF(P$30=\"HPWI\",'Data Entry'!$P$153,\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",'Data Entry'!$P$153,\"\")","v":""},null,"EPA suggested \"Labor Rate\" listed on Data Entry, Line 45."]
[]
[]
[null,null,null,null,"HPWI SIZING"]
[]
[null,null,null,null,"I.","Emission Unit Performance Data at 8760 hrs"]
[]
[null,null,null,null,null,null,"Emission Unit Data"]
[null,null,null,{"$f":"1+D70","v":15},null,null,null,"Unit Type",null,null,null,null,null,null,null,{"$f":"+IF(P$30=\"HPWI\",IF('Data Entry'!P32=\"\",\"\",'Data Entry'!P32),\"\")","v":""},null,null,null,"Emission unit type selected on Data Entry page Line 10."]
[]
[null,null,null,{"$f":"1+D78","v":16},null,null,null,"Maximum Heat Rate Input",null,null,null,null,"QB","MMBtu/hr",null,{"$f":"+IF(P$30=\"HPWI\",IF(OR(P78=\"Combined cycle\",P78=\"Boiler\"),'Data Entry'!P46,IFERROR('Data Entry'!P49*'Data Entry'!P52,\"\")),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IF(OR(P78=\"Combined cycle\",P78=\"Boiler\"),'Data Entry'!P46,IFERROR('Data Entry'!P49*'Data Entry'!P52,\"\")),\"\")","v":""},null,{"$f":"+IF(T81=\"\",\"Space intentionally left blank\",\"\")","v":"Space intentionally left blank"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(P30=\"\",\"\",IF(P80='Data Entry'!P46,\"\",\"Error: Check, Max. Heat Rate Input should be \"&P80&\" MMBtu/hr, instead of \"&IF('Data Entry'!P46=\"\",\"''Blank''\",'Data Entry'!P46)&\" MMBtu/hr, as selected on ''Data Entry'' page, if NPHR is listed as \"&'Data Entry'!P52&\" MMBtu/MWh\"&\" and Nominal Power Output is \"&'Data Entry'!P49&\" MW.\"))","v":""}]
[null,null,null,{"$f":"1+D80","v":17},null,null,null,"Power Output (MW Rating) \nat full load capacity.",null,null,null,null,"BMW","MW",null,{"$f":"+IF(P$30=\"HPWI\",IF(OR(P78=\"Combined cycle\",P78=\"Boiler\"),'Data Entry'!P46/'Data Entry'!P52,'Data Entry'!P49),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IF(OR(P78=\"Combined cycle\",P78=\"Boiler\"),'Data Entry'!P46/'Data Entry'!P52,'Data Entry'!P49),\"\")","v":""}]
[]
[null,null,null,{"$f":"1+D82","v":18},null,null,null,{"$f":"+IF(OR(P78=\"Combustion Turbine\",P78=\"Engine\"),\"Nominal Plate Heat Rate\",\"Net Plant Heat Rate\")","v":"Net Plant Heat Rate"},null,null,null,null,"NPHR","MMBtu/MWh",null,{"$f":"+IF(P$30=\"HPWI\",IF('Data Entry'!P52=\"\",\"\",'Data Entry'!P52),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IF('Data Entry'!P52=\"\",\"\",'Data Entry'!P52),\"\")","v":""}]
[]
[null,null,null,{"$f":"1+D84","v":19},null,null,null,"Annual Hrs of Operation",null,null,null,null,"top, ems unit","hrs",null,{"$f":"+IF(P$30=\"HPWI\",IF('Data Entry'!P111=\"\",\"\",'Data Entry'!P111),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IF('Data Entry'!R111=\"\",\"\",'Data Entry'!R111),\"\")","v":""},null,"Data Entry page - Emission Unit Annual Hrs of Operation, Line 33. The air pollution control is assumed to operate any time the emission unit is operating. "]
[]
[]
[null,null,null,{"$f":"1+D86","v":20},null,null,null,"Heat Input Max Annual",null,null,null,null,"HI","MMBtu/yr",null,{"$f":"+IF(P$30=\"HPWI\",IF(P86=\"\",\"\",IF(P78=\"Combined cycle\",P80*P86,P82*P84*P86)),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IF(R86=\"\",\"\",IF(P78=\"Combined cycle\",R80*R86,R82*R84*R86)),\"\")","v":""},null,"Calculated based on BMW and NPHR, or QB, multiplied by top,ems unit."]
[]
[null,null,null,{"$f":"1+D89","v":21},null,null,null,"Annual Actual MW Output",null,null,null,null,"Boutput","MW/yr",null,{"$f":"+IF(P$30=\"HPWI\",P82*P86,\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",R82*R86,\"\")","v":""},null,"Power Output, BMW, (Line 32) multiplied by top, ems unit (Line 35)."]
[]
[null,null,null,null,null,null,"Operating Capacity Factors"]
[null,null,null,{"$f":"1+D91","v":22},null,null,null,"Emission Unit Capacity Factor",null,null,null,null,"CF ems unit",null,null,{"$f":"+IF(P$30=\"HPWI\",IF('Data Entry'!P111=0,\"\",'Data Entry'!P111/8760),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IF('Data Entry'!R111=0,\"\",'Data Entry'!R111/8760),\"\")","v":""},null,"See Ref. 1, § 1.3.1, eq. (1.8a), p1-36 (p36-pdf) and Ref. 2 §2.3.3,  eq. (2.8a), p2-53 (p54-pdf). "]
[]
[]
[null,null,null,{"$f":"1+D94","v":23},null,null,null,"HPWI Capacity Factor",null,null,null,null,"CF HPWI",null,null,{"$f":"+IF(P$30=\"HPWI\",IF(P36=\"\",\"\",P36/P86),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IF(R36=\"\",\"\",R36/R86),\"\")","v":""},null,"See eq. (2.9), Ref. 2, §2.3.3 - System Capacity Factor, page 2-53 (p54-pdf)"]
[]
[null,null,null,{"$f":"1+D97","v":24},null,null,null,"Total Capacity Factor",null,null,null,null,"CF Total",null,null,{"$f":"+IF(P$30=\"HPWI\",IF(P97*P94=0,\"\",P97*P94),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IF(R97*R94=0,\"\",R97*R94),\"\")","v":""},null,"See Ref. 1, § 1.3.1, eq. (1.7), p1-35 (p35-pdf) and Ref. 2, §2.3.3, eq. (2.7), p2-53 \n(p54-pdf)."]
[]
[null,null,null,null,null,null,"Fuel Data"]
[null,null,null,{"$f":"1+D99","v":25},null,null,null,"Fuel Type",null,null,null,null,null,null,null,{"$f":"+IF(P$30=\"HPWI\",IF('Data Entry'!P56=\"\",\"\",'Data Entry'!P56),\"\")","v":""},null,null,null,"Data Entry input, Line 19."]
[]
[null,null,null,{"$f":"1+D102","v":26},null,null,null,"Fuel Low Heating Value",null,null,null,null,"LHV","BTU/lb",null,{"$f":"+IF(P$30=\"HPWI\",VLOOKUP(MATCH(P102,fuels_id,0),fuels,tbl!$G$42,FALSE),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",VLOOKUP(MATCH(P102,fuels_id,0),fuels,tbl!$G$42,FALSE),\"\")","v":""},null,"Per US DOE Biomass Energy Databook:",null,null,null,"http://cta.ornl.gov/bedb/appendix_a.shtml"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: Cost analysis in ACT (Ref. 4) is based on fuel LHV."]
[]
[null,null,null,{"$f":"1+D104","v":27},null,null,null,"Fuel Cost",null,null,null,null,"Costfuel","$/MMBtu",null,{"$f":"+IF(P$30=\"HPWI\",VLOOKUP(MATCH(P102,fuels_id,0),fuels,tbl!$N$42,FALSE),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",VLOOKUP(MATCH(HPWI!$P$102,fuels_id,0),fuels,tbl!$N$42,FALSE),\"\")","v":""},null,"Input from U.S. Energy Information Administration - EIA 2011-2012 data. In the web page below, select year in the Annual Emery Review archives and in Data Categories select fuel:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"http://www.eia.gov/totalenergy/data/annual/index.cfm"]
[]
[null,null,null,{"$f":"1+D107","v":28},null,null,null,"Max. Fuel Consumption Rate",null,null,null,null,{"$f":"+IF(P102=\"Natural Gas\",\"V(fuel)\",\"m(fuel)\")","v":"m(fuel)"},{"$f":"+IF(P102=\"Natural Gas\",\"CFH\",\"lb/hr\")","v":"lb/hr"},null,{"$f":"+IF(P$30=\"HPWI\",P89*10^6/P104/P86,\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IF(P102=\"Natural Gas\",R89*10^6/R104/R86,IF(P102=\"\",\"\",IF(P102=\"Natural Gas\",\"\",IF(P102=\"Coal\",R89*10^6/R104/R86,R89*10^6/R104/R86)))),\"\")","v":""},null,"Hourly heat input divided by the fuel LHV, or Maximum Heat Rate Input (QB) divided by fuel LHV. "]
[]
[]
[null,null,null,{"$f":"1+D112","v":29},null,null,null,"Annual Fuel Consumption ",null,null,null,null,"Annual Fuel",{"$f":"+IF(P102=\"Natural Gas\",\"CF/yr\",\"lb/yr\")","v":"lb/yr"},null,{"$f":"+IF(P$30=\"HPWI\",IF(P112=\"\",\"\",P112*P86),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IF(R112=\"\",\"\",R112*R86),\"\")","v":""},null,"Equal to Max. Fuel Consumption Rate, Line 28, multiplied by Annual Hours of Operation, Line 19."]
[null,null,null,null,null,null,null,"(estimate based on selected LHV) "]
[]
[null,null,null,null,null,null,"NOx Removal Performance"]
[null,null,null,{"$f":"1+D115","v":30},null,null,null,"Uncontrolled NOx Emission Level",null,null,null,null,"NOxin","lb/MMBtu",null,{"$f":"+IF(P$30=\"HPWI\",IF('Data Entry'!P78=\"\",\"\",'Data Entry'!P78),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IF('Data Entry'!P78=\"\",\"\",'Data Entry'!P78),\"\")","v":""},null,"Uncontrolled NOx rate entered on Data Entry page, Line 26."]
[]
[null,null,null,{"$f":"1+D119","v":31},null,null,null,"Controlled NOx Outlet (required)",null,null,null,null,"NOxout","lb/MMBtu",null,{"$f":"+IF(P$30=\"HPWI\",IF('Data Entry'!P80=\"\",\"\",'Data Entry'!P80),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IF('Data Entry'!P80=\"\",\"\",'Data Entry'!P80),\"\")","v":""},null,"Controlled NOx rate, as required by RCSA 22a-174-22e, and listed on Data Entry, Line 27."]
[]
[]
[null,null,null,{"$f":"1+D121","v":32},null,null,null,"Controlled NOx Outlet (selected)",null,null,null,null,"NOxout,sel","lb/MMBtu",null,{"$f":"+IF(P$30=\"HPWI\",MAX(P121,P41,P119-P38*P119),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",MAX(R121,R41,R119-R38*R119),\"\")","v":""},null,{"$f":"+\"Determined as the highest among: the required controlled NOx out, the HPWI lowest attained NOx out rate, or the NOx out value based on the \"&IF(P$30=\"HPWI\",P38*100&\"% \",\"\")&\"default efficiency.\"","v":"Determined as the highest among: the required controlled NOx out, the HPWI lowest attained NOx out rate, or the NOx out value based on the default efficiency."}]
[]
[]
[null,null,null,{"$f":"1+D124","v":33},null,null,null,"NOx Removal Efficiency\n(selected)",null,null,null,null,"h NOxR,sel","%",null,{"$f":"+IF(P$30=\"HPWI\",IFERROR((P119-P124)/P119,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IFERROR((R119-R124)/R119,\"\"),\"\")","v":""},null,"Defined by either eq. (1.10) Ref. 1, § 1.3.1. - Design Parameters for Study-Level Estimates, NOx Removal Efficiency, page 1-37 (p37-pdf) or eq. (2.10) Ref. 2, § 2.3.5 - NOx Removal Efficiency, page 2-54 (p55-pdf), and determined based on NOxin on Line 30 and NOxout sel, on Line 32."]
[]
[]
[]
[]
[null,null,null,{"$f":"1+D127","v":34},null,null,null,"NOx Removed Hourly Rate",null,null,null,null,"NOxR/hr","lb/hr",null,{"$f":"+IF(P$30=\"HPWI\",IFERROR(P119*P127*P80,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IFERROR(R119*R127*R80,\"\"),\"\")","v":""},null,"Applied the SNCR's eq. (1.12), Ref. 1, §1.3.1 - Design Parameters for Study-Level, NOx Removal Rates, page 1-37 (p37-pdf)."]
[]
[]
[null,null,null,{"$f":"1+D132","v":35},null,null,null,"NOx Removed (annually)",null,null,null,null,"NOxR","tons",null,{"$f":"+IF(P$30=\"HPWI\",IFERROR((P119*P127*P80*P99*8760)/2000,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IFERROR((R119*R127*R80*R99*8760)/2000,\"\"),\"\")","v":""},null,"Defined either by SNCR's eq. (1.11), Ref. 1, §1.3 - Design Parameters for Study-Level, NOx Removal Rates, p1-37 (p37-pdf), or by SCR's eq. (2.11), Ref. 1, §2.3.6 - NOx Removal Rates, p2-54 (p55-pdf)."]
[]
[]
[null,null,null,null,"II.","Water Specifications Calculations"]
[]
[null,null,null,null,null,null,"Flow Rates"]
[null,null,null,{"$f":"1+D135","v":36},null,null,null,"Estimated Water Flow Factor/Rate",null,null,null,null,"WFR","lbwater/lbfuel",null,{"$f":"+IF(P$30=\"HPWI\",0.7,\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",0.7,\"\")","v":""},null,"Bulk average of the WFR data, HPWI control, in Table 6-2, Ref. 4, §6.0 - Control Costs, page 6-211, (p302-pdf)."]
[]
[]
[null,null,null,{"$f":"1+D141","v":37},null,null,null,"Water Flow",null,null,null,null,"qwater","gpm",null,{"$f":"+IF(P$30=\"HPWI\",P112/60/VLOOKUP(MATCH(LEFT($H$144,5),p_id,0),prp,tbl!$H$17,FALSE)*P141,\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",R112/60/VLOOKUP(MATCH(LEFT($H$144,5),p_id,0),prp,tbl!$H$17,FALSE)*R141,\"\")","v":""},null,"Based of Max. Fuel Consumption Rate, lb(fuel)/hr, on Line 28 and WFR, lb(water)/lb (fuel), on Line 36, in gal/min (gpm)."]
[]
[null,null,null,null,null,null,"Treatment System Capacity"]
[null,null,null,{"$f":"1+D144","v":38},null,null,null,"Design Factor",null,null,null,null,"DF",null,null,{"$f":"+IF(P$30=\"HPWI\",1.3,\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",1.3,\"\")","v":""},null,"Recommended by a HPWI system supplier, per Table 6-2, footnote [c], Ref. 4, §6.0 - Control Costs, page 6-211, (p302-pdf)."]
[]
[]
[null,null,null,{"$f":"1+D147","v":39},null,null,null,"Waste Stream Factor",null,null,null,null,"WSF",null,null,{"$f":"+IF(P$30=\"HPWI\",1.29,\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",1.29,\"\")","v":""},null,"Factor to account for waste stream, per same reference mentioned at Line 38."]
[]
[null,null,null,{"$f":"1+D150","v":40},null,null,null,"Treatment System Design Capacity",null,null,null,null,"Qwater","gpm",null,{"$f":"+IF(P$30=\"HPWI\",P147*P150*P144,\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",R147*R150*R144,\"\")","v":""},null,"Treatment system design capacity is the system water flow increased by the above two multipliers, on Line 38 and Line 39, respectively."]
[]
[null,null,null,null,null,null,"Water Injection Electricity Consumption"]
[null,null,null,{"$f":"1+D152","v":41},null,null,null,"Pumping Factor",null,null,null,null,"PF","kW/gpm",null,{"$f":"+IF(P$30=\"HPWI\",0.161,\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",0.161,\"\")","v":""},null,"Per Ref. 4, pages 6-224, 6-225, (p3154-316, pdf), based on a pump head H = 200 psig, \nt(water) = 130ºF, 60% pump efficiency and 90 % electric motor efficiency."]
[]
[]
[null,null,null,{"$f":"1+D155","v":42},null,null,null,"Power Injection Pump",null,null,null,null,"P","kW",null,{"$f":"+IF(P$30=\"HPWI\",P155*P144,\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",R155*R144,\"\")","v":""},null,"Determined as water flow (Line 37) multiplied by the pumping factor (Line 41)."]
[]
[null,null,null,{"$f":"1+D158","v":43},null,null,null,"Electricity HPWI Consumption",null,null,null,null,"E","kWh",null,{"$f":"+IF(P$30=\"HPWI\",P158*P36,\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",R158*R36,\"\")","v":""},null,"Annual water injection electricity is the injection pump power times the annual HPWI hrs of operation."]
[]
[null,null,null,null,null,null,"Water Injection Fuel Penalty"]
[null,null,null,{"$f":"1+D160","v":44},null,null,null,"Fuel Penalty Impact",null,null,null,null,"FPpercentage","%",null,{"$f":"+IF(P$30=\"HPWI\",3.5%,\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",3.5%,\"\")","v":""},null,"Per Ref. 4, page  6-223 (p314-pdf), is 3.5 % of Annual Heat Input, at WFR=1, for HPWI."]
[]
[]
[null,null,null,{"$f":"1+D163","v":45},null,null,null,"Fuel Penalty",null,null,null,null,"FP","MMBtu/yr",null,{"$f":"+IF(P$30=\"HPWI\",P89*P141*P163,\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",R89*R141*R163,\"\")","v":""},null,"Annual fuel penalty, is the reduction percent (FPpercenrage x WFR) of the  max. annual heat input, corrected for the actual WFR = 0.7 lbwater/lbfuel."]
[]
[]
[]
[null,null,null,null,"HPWI COST ESTIMATION"]
[]
[null,null,null,null,"TOTAL CAPITAL COST"]
[]
[null,null,null,null,"I.","Total Capital Investment (TCI) Estimate"]
[]
[null,null,null,null,null,null,"Retrofit Factor"]
[null,null,null,{"$f":"1+D166","v":46},null,null,null,"High Pressure Water Injection System",null,null,null,null,"RFHPWI",null,null,{"$f":"+IF(P$30=\"HPWI\",IF('Data Entry'!P90=\"\",\"\",'Data Entry'!P90),\"\")","v":""},null,null,null,"HPWI System Retrofit Factor entered on Data Entry page, Line 32."]
[]
[null,null,null,null,null,null,"HPWI Available Cost Data"]
[null,null,null,{"$f":"1+D177","v":47},null,null,null,"HPWI 1990 Investment Cost",null,null,null,null,"TCI 1990$","1990$",null,{"$f":"+IF(P$30=\"HPWI\",ROUNDUP((43.638*P82+191.14),0)*1000,\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",ROUNDUP((43.638*R82+191.14),0)*1000,\"\")","v":""},null,"Cost estimate based on a linear variation of HPWI Systems TCI vs. unit nom. plate power capacity, BMW, on Line 15, per data in Table 6-5, Ref. 4, §6.0 - Control Costs, page 6-222, (p313-pdf)."]
[]
[]
[null,null,null,{"$f":"1+D180","v":48},null,null,"Total Capital Investment",null,null,null,null,null,"TCI2012$","2012$",null,{"$f":"+IF(P$30=\"HPWI\",P56*P180*P52*$P$177,\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",R56*R180*R52*$P$177,\"\")","v":""},null,"2012$ HPWI suggested cost is: 1990$ HPWI Cost (TCI1990$, Line 47) x (CPI2012$/1990$, Line 9) x (ELEVF, Line 8) x (RFHPWI, Line 46)."]
[]
[null,null,null,null,"II.","Annual Costs"]
[]
[null,null,null,null,null,null,"Direct Annual Elements Cost ",null,null,null,null,null,null,null,null,null,null,null,null,"Note: Direct Annual Elements Costs estimated below, are determined per Table 6-5, Ref. 4, §6.0 - Control Costs, page 6-222, (p313-pdf)."]
[]
[]
[null,null,null,{"$f":"1+D183","v":49},null,null,null,"Annual Maintenance",null,null,null,null,"AMC","$/yr",null,{"$f":"+IF(P$30=\"HPWI\",IF(P183=0,\"\",P56*ROUNDUP((340*P82+23000)/1000,0)*1000),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IF(R183=0,\"\",R56*ROUNDUP((340*R82+23000)/1000,0)*1000),\"\")","v":""},null,"Cost estimate based on a linear variation of HPWI Systems maintenance costs vs. nom. plate power capacity, BMW , per data in Table 6-5, Ref. 4, §6.0 - Control Costs, page 6-222, (p313-pdf)."]
[]
[]
[]
[null,null,null,{"$f":"1+D190","v":50},null,null,null,"Annual Electricity",null,null,null,null,"AEC","$/yr",null,{"$f":"+IF(P$30=\"HPWI\",IF(P183=0,\"\",P160*'Data Entry'!$P$143),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IF(R183=0,\"\",R160*'Data Entry'!$P$143),\"\")","v":""},null,"Water injection electricity annual consumption, on Line 43, times the 2012 kWh cost, listed on Data Entry, Line 41."]
[]
[]
[null,null,null,{"$f":"1+D194","v":51},null,null,null,"Annual Water Cost",null,null,null,null,"AWC","$/yr",null,{"$f":"+IF(P$30=\"HPWI\",IF(P183=0,\"\",P144*60*P36*P150*'Data Entry'!$P$146),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IF(R183=0,\"\",R144*60*R36*R150*'Data Entry'!$P$146),\"\")","v":""},null,"Based on actual water injection flow, qwater (Line 37), control operating time, top,control (Line 3), waste stream factor (suggested by system suppliers), WSF (Line 39) and water 2012$ specific cost, on Data Entry, Line 41, per Table 6-5, Ref. 4, page 6-222, (p313-pdf)."]
[]
[]
[]
[]
[null,null,null,{"$f":"1+D197","v":52},null,null,null,"Fuel Penalty Cost",null,null,null,null,"FPcost","$/yr",null,{"$f":"+IF(P$30=\"HPWI\",IF(P183=0,\"\",P166*P107),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IF(R183=0,\"\",R166*R107),\"\")","v":""},null,"Fuel penalty, FP (Line45),in MMBtu/hr times fuel specific cost, per EIA 2012$data, Costfuel (Line27)."]
[]
[]
[null,null,null,{"$f":"1+D202","v":53},null,null,null,"Water Treatment Cost",null,null,null,null,null,"$/yr",null,{"$f":"+IF(P$30=\"HPWI\",IF(P183=0,\"\",P144*60*P36*P150*P59),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IF(R183=0,\"\",R144*60*R36*R150*R59),\"\")","v":""},null,"Based on actual water injection flow, qwater (Line 37), control operating time, top,control (Line 3), waste stream factor (suggested by system suppliers), WSF (Line 39) and specific costs, water treatment cost, WTC$/gal (Line 10), or water treatment labor cost, WTLC$/gal (Line 11) and water disposal cost, WDC$/gal (Line 12), respectively, per Table 6-5, Ref. 4, page 6-222, (p313-pdf)."]
[]
[null,null,null,{"$f":"1+D205","v":54},null,null,null,"Water Treatment Labor Cost",null,null,null,null,null,"$/yr",null,{"$f":"+IF(P$30=\"HPWI\",IF(P183=0,\"\",P144*60*P36*P150*P62),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IF(R183=0,\"\",R144*60*R36*R150*R62),\"\")","v":""}]
[]
[null,null,null,{"$f":"1+D207","v":55},null,null,null,"Water Disposal Cost",null,null,null,null,null,"$/yr",null,{"$f":"+IF(P$30=\"HPWI\",IF(P183=0,\"\",P144*60*P36*P150*P65),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IF(R183=0,\"\",R144*60*R36*R150*R65),\"\")","v":""}]
[]
[]
[null,null,null,{"$f":"1+D209","v":56},null,null,"Direct Annual Cost - DAC",null,null,null,null,null,"DAC","$/yr",null,{"$f":"+IF(P$30=\"HPWI\",IF(P183=0,\"\",P190+P194+P197+P202+P205+P207+P209),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IF(R183=0,\"\",R190+R194+R197+R202+R205+R207+R209),\"\")","v":""},null,"Sum of the above direct annual costs, Line 49 through Line 55."]
[]
[null,null,null,null,null,null,"Indirect Annual Cost (IDAC)"]
[null,null,null,{"$f":"1+D212","v":57},null,null,null,"Administrative Charges",null,null,null,null,"AC","$/yr",null,{"$f":"+IF(P$30=\"HPWI\",IFERROR(0.03*(0+0.4*P190),\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IFERROR(0.03*(0+0.4*R190),\"\"),\"\")","v":""},null,"Calculated based on the same assumptions proposed for SCR, see eq. (2.69), Ref. 2, §2.4.2. - Total Annual Cost, page 2-78 (p79-pdf)."]
[]
[]
[null,null,null,{"$f":"1+D215","v":58},null,null,null,"Capital Recovery",null,null,null,null,"CR","$/yr",null,{"$f":"+IF(P$30=\"HPWI\",IFERROR('Data Entry'!$P$137*P183,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IFERROR('Data Entry'!$P$137*R183,\"\"),\"\")","v":""},null,"Calculated based on the same eq. proposed for SCR, see eq. (2.70), Ref. 2, §2.4.2. - Total Annual Cost, page 2-79 (p80-pdf). "]
[]
[]
[null,null,null,{"$f":"1+D218","v":59},null,null,null,"Indirect Annual Costs",null,null,null,null,"IDAC","$/yr",null,{"$f":"+IF(P$30=\"HPWI\",IFERROR(P218+P215,\"\"),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IFERROR(R218+R215,\"\"),\"\")","v":""},null,"Total of the above indirect costs, Line 57 and Line 58."]
[]
[null,null,null,{"$f":"1+D221","v":60},null,null,"Total Annual Cost",null,null,null,null,null,"TAC","$/yr",null,{"$f":"+IF(P$30=\"HPWI\",IF(P183=0,\"\",P221+P212),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",R221+R212,\"\")","v":""},null,"Total of direct and indirect costs, per eq. (1.55), Ref. 1 §1.4.2. page 1-53."]
[]
[null,null,null,{"$f":"1+D223","v":61},"III.","NOx Removal per year",null,null,null,null,null,null,"NOx R","tons",null,{"$f":"+IF(P$30=\"HPWI\",IF(P183=0,\"\",P135),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IF(R183=0,\"\",R135),\"\")","v":""},null,"Tons of NOx removed calculated above, on Line 35."]
[]
[null,null,null,null,"IV.","Control Cost Effectiveness"]
[]
[null,null,null,{"$f":"1+D225","v":62},null,"Base Year",null,null,null,null,null,null,null,null,null,{"$f":"+IF(P$30=\"HPWI\",'Data Entry'!P126,\"\")","v":""},null,null,null,"Data Entry, Line 36 - Selected base year of EPA's cost analysis."]
[null,null,null,{"$f":"1+D229","v":63},null,null,"Cost Effectiveness",null,null,null,null,null,"Costeffect,$2012","2012$/ton NOxR",null,{"$f":"+IF(P$30=\"HPWI\",IF(P183=0,\"\",P223/P225),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IF(R183=0,\"\",R223/R225),\"\")","v":""},null,"Control cost effectiveness based on TAC divided by the annual tons of NOx removed, per eq. (2.73), Ref. 2, §2.4.2. page 2-79 (p80-pdf). "]
[]
[]
[null,null,null,{"$f":"1+D230","v":64},null,"Year Control is effective",null,null,null,null,null,null,null,null,null,{"$f":"+IF(P$30=\"HPWI\",'Data Entry'!$P$84,\"\")","v":""},null,null,null,"Year control is effective (or current year), as entered on Data Entry, Line 28."]
[null,null,null,{"$f":"1+D233","v":65},null,null,"Cost Effectiveness",null,null,null,null,null,"Costeffect,yr","$/ton NOxR",null,{"$f":"+IF(P$30=\"HPWI\",IF(P183=0,\"\",P230*'Data Entry'!$P$85),\"\")","v":""},null,{"$f":"+IF(R$30=\"HPWI\",IF(R183=0,\"\",R230*'Data Entry'!$P$85),\"\")","v":""},null,"Control cost effectiveness adjusted for the year control is effective (or current year)."]