{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Dry Sorbent Injection","Spray Dry Absorber","Wet Scrubber","ESRI_MAPINFO_SHEET"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":9,"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":"Dry Sorbent Injection","index":0,"n_rows":103,"n_cols":5,"rows_kept":103,"cut":false,"hidden":false,"merged":[[56,0,56,5],[72,4,72,5],[40,4,40,5],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[17,4,17,5],[19,4,19,5],[20,4,20,5],[18,4,18,5],[15,4,15,5],[16,4,16,5],[21,0,21,5],[0,0,0,5],[2,4,2,5],[3,4,3,5],[4,4,4,5],[5,4,5,5],[6,4,6,5],[11,4,11,5],[12,4,12,5],[13,4,13,5],[14,4,14,5]]}
["Four Boilers Dry Sorbent Injection System - Chena Power Plant"]
[]
["Variable","Designation","Units","Value","Calculation"]
["Unit Size (Gross)","A","(MW)",49.7,"<-- User Input (Conservative assumption based on total heat input of 497 MMBtu/hour)"]
["Retrofit Factor","B",null,1.5,"<-- User Input (An \"average\" retrofit has a factor of 1.0. Site-specific considerations provided by Aurora in 12/22/17 BACT Addendum) "]
["Gross Heat Rate","C","(Btu/kWh)",10000,"<-- User Input"]
["SO2 Rate","D","(lb/MMBtu)",0.39,"<-- User Input"]
["Type of Coal","E",null,"sub-bituminous","<-- User Input"]
["Particulate Capture","F",null,"Baghouse","<-- User Input"]
["Milled Trona","G",null,true,"Based on in-line milling equipment"]
["Removal Target","H","(%)",80,"Maximum Removal Targets:\nUnmilled Trona with an ESP = 65%\nMilled Trona with an ESP = 80%\nUnmilled Trona with a Baghouse = 80%\nMilled Trona with Baghouse = 90%"]
["Heat Input","J","(Btu/hr)",{"$f":"D4*D6*1000","v":497000000},"A*C*1000"]
["NSR","K",null,{"$f":"IF(D11<40,0.016*D11,0.208*EXP(0.0281*D11))","v":1.9695061001228062},"Unmilled Trona with an ESP = if(H<40,0.0350*H,0.352e^(0.0345*H))                                                                                                                    Milled Trona with an ESP =      if(H<40,0.0270*H,0.353e^(0.0280*H))                                                                                                                       Unmilled Trona with an BGH = if(H<40,0.0215*H,0.295e^(0.0267*H))                                                                                                                         Milled Trona with an BGH =      if(H<40,0.0160*H,0.208e^(0.0281*H))"]
["Trona Feed Rate","M","(ton/hr)",{"$f":"(0.0000012011)*D13*D4*D6*D7","v":0.45851916516828983},"(1.2011x10^-06)*K*A*C*D"]
["Sorbent Waste Rate","N","(ton/hr)",{"$f":"(0.7035-0.00073696*D11/D13)*D14","v":0.30884254648689347},"(0.7035-0.00073696*H/K)*M  Based on a final reaction product of Na2SO4 and unreacted dry sorbent as Na2CO3. "]
["Fly Ash Waste Rate ","P","(ton/hr)",{"$f":"(D12/1000)*0.07*(1-0.6)/(2*7560)","v":0.92037037037037039},"(A*C)*Ash incoal*(1-Boiler Ash Removal)/(2*HHV)\nFor Bituminous Coal: Ash in Coal = 0.12; Boiler Ash Removal = 0.2, HHV = 11,000\nFor PRB Coal: Ash in Coal = 0.06; Boiler Ash Removal = 0.2, HHV = 8,400\nFor Lignite Coal: Ash in Coal = 0.08; Boiler Ash Removal = 0.2, HHV = 7,200\n<-- User Input (Usibelli Coal: Ash in Coal = 0.07; Boiler Ash Removal = 0.6; HHV = 7,560)"]
["Aux Power","Q","(%)",{"$f":"D14*20/D4","v":0.18451475459488523},"=if Milled Trona M*20/A else M*18/A"]
["Trona Cost","R","($/ton)",451,"<-- User Input (based on delivered price paid by Healy)"]
["Waste Disposal Cost","S","($/ton)",50]
["Aux Power Cost","T","($/kWh)",0.21,"<-- User Input (http://www.gvea.com/rates/rates) "]
["Operating Labor Rate","U","($/hr)",60,"<-- User Input (Labor cost including all benefits)"]
["IPM Model - Updates to Cost and Performance for APC Technologies - Dry Sorbent Injection for SO2 Control Cost Development Methodology, March 2013, prepared by Sargent & Lundy LLC for USEPA. https://www.epa.gov/sites/production/files/2015-07/documents/append5_4.pdf  "]
["Capital Cost Calculation (2012 dollars)",null,null,null,"Comments"]
[]
["Includes - Equipment, installation, building, foundations, electrical, and a retrofit difficulty factor of 1.5"]
[]
["Base Module (BM) ($)",null,"=",{"$f":"IF(D14>25,(750000*D5*D14),(7516000*D5*D14^0.284))","v":9034488.2729631551},"Base DSI module includes all equipment from unloading to injection"]
["Unmilled Trona = if(M>25 then (682,000*B*M) else 6,833,000*B*(M^0.284)"]
["Milled Trona = if(M>25 then (750,000*B*M) else 7,516,000*B*(M^0.284)"]
["BM ($/kW)",null,"=",{"$f":"D27/(D4*1000)","v":181.780448148152},"Base module cost per kW"]
[]
["Total Project Cost"]
[]
["A1 = 10% of BM",null,"=",{"$f":"0.1*$D$27","v":903448.82729631558},"Engineering and construction management costs (CC Manual)"]
["A2 = 10% of BM",null,"=",{"$f":"0.1*$D$27","v":903448.82729631558},"Labor adjustment for 6 x 10 hour shift premium, per diem, etc. (CC Manual)"]
["A3 = 10% of BM",null,"=",{"$f":"0.1*$D$27","v":903448.82729631558},"Contractor profit and fees (CC Manual)"]
[]
["CECC ($) - Excludes Owner's Costs = BM + A1 + A2 + A3",null,"=",{"$f":"D27+D34+D35+D36","v":11744834.754852099},"Capital, engineering, and construction costs subtotal"]
["CECC ($/kW) - Excludes Owner's Costs",null,"=",{"$f":"D38/(D4*1000)","v":236.31458259259756},"Capital, engineering, and construction costst subtotal per kW"]
[]
["B1 = 5% of CECC",null,"=",{"$f":"0.05*D38","v":587241.73774260504},"Owner's costs including all \"home office\" costs (owner's engineering, management, and procurement activities)"]
[]
["TPC ($) - Includes Owners Costs = CECC + B1",null,"=",{"$f":"D38+D41","v":12332076.492594704},"Total project cost without Allowance for Funds Used During Construction (AFUDC)"]
["TPC ($/kW) - Include Owner's Costs",null,"=",{"$f":"D43/(D4*1000)","v":248.13031172222745},"Total project cost per kW without AFUDC"]
[]
["B2 = 0% of (CECC + B1)",null,"=",null,"AFUDC (Zero for less than 1 year engineering and construction cycle)"]
[]
["TPC ($) = CECC + B1 + B2",null,"=",{"$f":"D43+D46","v":12332076.492594704},"Total project cost"]
["TPC ($/kW)",null,"=",{"$f":"D48/(D4*1000)","v":248.13031172222745},"Total project cost per kW"]
[]
[]
[]
[]
[]
[]
[]
["Dry Sorbent Injection System - Chena Power Plant"]
[]
[]
["Direct Annual Costs"]
["Fixed Operating and Maintenance (O&M) Cost"]
[]
["FOMO ($/kW yr) = (1 additional operators)*(2080)*U/(A*1000)",null,"=",{"$f":"1*2080*D21/(D4*1000)","v":2.5110663983903421},"Fixed O&M additional operating labor costs"]
["FOMM ($/kW yr) = BM*0.01/(B*A*1000)",null,"=",{"$f":"D27*0.01/(D5*D4*1000)","v":1.2118696543210132},"Fixed O&M additional maintenance material and labor costs"]
["FOMA ($/kW yr) = 0.03*(FOMO+0.4*FOMM)",null,"=",{"$f":"0.03*(D63+0.4*D64)","v":8.9874427803562418E-2},"Fixed O&M additional administrative labor costs"]
[]
["FOM ($/kW yr) = FOMO + FOMM + FOMA",null,"=",{"$f":"D63+D64+D65","v":3.8128104805149174},"Total Fixed O&M costs ($/kW yr)"]
[]
["Variable O&M Cost"]
[]
["VOMR ($/MWh) = M*R/A",null,"=",{"$f":"D14*D18/D4","v":4.1608077161146619},"Variable O&M costs for Trona reagent"]
["VOMW ($/MWh) = (N+P)*S/A",null,"=",{"$f":"(D15+D16)*D19/D4","v":1.2366327131360804},"Variable O&M costs for waste disposal that includes both the sorbent and the fly ash waste not removed prior to the sorbent injection"]
["VOMP ($/MWh) = Q*T*10",null,"=",{"$f":"D17*D20*10","v":0.38748098464925895},"Variable O&M costs for additional auxiliary power required (Refer to Aux Power % above)"]
[]
["VOM ($/MWh) = VOMR + VOMW + VOMP",null,"=",{"$f":"D71+D72+D73","v":5.7849214139000011},"Total Variable O&M Costs ($/MW yr)"]
[]
["Indirect Annual Costs"]
[]
["Overhead (60% of total labor and material costs)",null,"=",{"$f":"0.6*D67*D4*1000","v":113698.00852895484},"CC Manual"]
["Administrative charges (2% of total capital investment)",null,"=",{"$f":"0.02*D48","v":246641.5298518941},"CC Manual"]
["Property tax (1% of total capital investment)",null,"=",{"$f":"0.01*D48","v":123320.76492594705},"CC Manual"]
["Insurance (1% of total capital investment)",null,"=",{"$f":"0.01*D48","v":123320.76492594705},"CC Manual"]
["Capital Recovery Factor (CRF) = [ i (1+i)n ] / [ (1+i)n - 1 ]"]
["i  = Interest rate (%)                               ",7]
["n = Equipment life (years)",15]
["CRF =",{"$f":"((B84/100)*((1+(B84/100))^B85))/(((1+(B84/100))^B85)-1)","v":0.10979462470100652},"=",{"$f":"B86*D48","v":1353995.7102885405},"CC Manual"]
[]
["TOTAL INDIRECT ANNUAL OPERATING COSTS",null,"=",{"$f":"SUM(D79:D86)","v":1960976.7785212835}]
[]
["TOTAL ANNUALIZED OPERATING COSTS (2012 $)",null,"=",{"$f":"D67*D4*1000+D75*D4*8760+D88","v":4669066.2652153466}]
[]
[]
["Composite CE Index for 2012 (cost year of equation)",null,"=",584.6]
["Composite CE Index for 2016 (cost year of review)",null,"=",536.4]
[]
["TOTAL ANNUALIZED OPERATING COSTS (2016 $)",null,"=",{"$f":"D90*D94/D93","v":4284103.9080764828}]
[]
[]
["TOTAL UNCONTROLLED SO2 EMISSIONS, tons",null,"=",{"$f":"D7*(D12/1000000)*8760/2000","v":848.97540000000004}]
["SO2 REMOVAL EFFICIENCY, %",null,"=",{"$f":"D11","v":80}]
["TOTAL SO2 REMOVED, tons",null,"=",{"$f":"D99*D100/100","v":679.18032000000005}]
[]
["SO2 COST-EFFECTIVENESS, $/ton removed",null,"=",{"$f":"D96/D101","v":6307.7562495869761}]

{"sheet":"Spray Dry Absorber","index":1,"n_rows":121,"n_cols":5,"rows_kept":121,"cut":false,"hidden":false,"merged":[[12,4,12,5],[6,4,6,5],[4,0,4,5],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[11,4,11,5],[24,0,24,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[18,4,18,5],[19,4,19,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[23,4,23,5],[47,4,47,5],[70,0,70,5],[86,4,86,5],[88,4,88,5],[90,4,90,5]]}
[]
[]
[]
[]
["Four Boilers Spray Dry Absorber - Chena Power Plant"]
[]
["Variable","Designation","Units","Value","Calculation"]
["Unit Size (Gross)","A","(MW)",49.7,"<-- User Input (Conservative assumption based on total heat input of 497 MMBtu/hour)"]
["Retrofit Factor","B",null,1.5,"<-- User Input (An \"average\" retrofit has a factor of 1.0. Site-specific considerations provided by Aurora in 12/22/17 BACT Addendum) "]
["Gross Heat Rate","C","(Btu/kWh)",10000,"<-- User Input "]
["SO2 Rate","D","(lb/MMBtu)",0.39,"<-- User Input (SDA FGD Estimation only valid up to 3lb/MMBtu SO2 Rate)"]
["Type of Coal","E",null,"sub-bituminous","<-- User Input"]
["Coal Factor","F",null,1.05,"Bituminous = 1, Sub-Bituminous=1.05, Lignite=1.07"]
["Heat Rate Factor","G",null,{"$f":"D10/10000","v":1},"C/10000"]
["Heat Input","H","(Btu/hr)",{"$f":"D8*D10*1000","v":497000000},"A*C*1000"]
["Lime Rate","K","(ton/hr)",{"$f":"(0.6702*(D11^2)+13.42*D11)*D8*D14/2000","v":0.13259307488700001},"(0.6702*(D^2)+13.42*D)*A*G/2000 (Based on 95% SO2 Removal)"]
["Waste Rate","L","(ton/hr)",{"$f":"(0.8016*(D11^2)+31.1917*D11)*D8*D14/2000","v":0.30532415604600005},"(0.8016*(D^2)+31.1917*D)*A*G/2000 "]
["Aux Power","M","(%)",{"$f":"(0.000547*(D11^2)+0.00649*D11+1.3)*D13*D14","v":1.367745013635},"(0.000547*(D^2)+0.00649*D+1.3)*F*G Should be used for model input"]
["Makeup Water Rate","N","(1000 gph)",{"$f":"(0.04898*(D11^2)+0.5925*D11+55.11)*D8*D13*D14/1000","v":2.8883627697147305},"(0.04898*(D^2)+0.5925*D+55.11)*A*F*G/1000"]
["Lime Cost","P","($/ton)",80,"<-- User Input (https://www3.epa.gov/ttncatc1/dir1/ffdg.pdf)"]
["Waste Disposal Cost","Q","($/ton)",30,"<-- User Input (https://www3.epa.gov/ttncatc1/dir1/ffdg.pdf)"]
["Aux Power Cost","R","($/kWh)",0.21,"<-- User Input (http://www.gvea.com/rates/rates) "]
["Makeup Water Cost","S","($/1000 gal)",7.17,"<-- User Input (http://www.newsminer.com/water-rates/article_11a2ba10-c211-562e-8da9-87dd16a7b104.html)"]
["Operating Labor Rate","T","($/hr)",60,"Labor cost including all benefits"]
["IPM Model - Updates to Cost and Performance for APC Technologies - SDA FGD for SO2 Control Cost Development Methodology, March 2013, prepared by Sargent & Lundy LLC for US EPA.                                                            https://www.epa.gov/sites/production/files/2015-07/documents/chapter_5_appendix_5-1b_sda_fgd.pdf  "]
["Capital Cost Calculation (2012 dollars)",null,null,null,"Comments"]
[]
["Includes - Equipment, installation, building, foundations, electrical, and a retrofit difficulty factor of 1.5"]
[]
["BMR ($) = if(A>600 then (A*92,000) else 566,000*(A^0.716))*B*(F*G)^0.6*(D/4)^0.01",null,"=",{"$f":"IF(D8>600,(D8*92000),(566000*(D8^0.716))*D9*(D13*D14)^0.6*(D11/4)^0.01)","v":13999176.53452052},"Base module absorber island cost"]
[]
["BMF ($) = if(A>600 then (A*48,700) else 300,000*(A^0.716))*B*(D*G)^0.2",null,"=",{"$f":"IF(D8>600,(D8*48700),(300000*(D8^0.716))*D9*(D11*D14)^0.2)","v":6109653.9071933944},"Base module reagent preparation and waste recycle/handling cost"]
[]
["BMB ($) = if(A>600 then (A*129,900) else 799,000*(A^0.716))*B*(F*G)^0.4",null,"=",{"$f":"IF(D8>600,(D8*129900),(799000*(D8^0.716))*D9*(D13*D14)^0.4)","v":20031106.146907546},"Base module balance of plan costs inlcuding: ID or booster fans, piping, ductwork, electrical, etc."]
[]
["BM ($) =   BMR + BMF + BMB",null,"=",{"$f":"D30+D32+D34","v":40139936.58862146},"Total base module cost including retrofit factor"]
["BM ($/kW)",null,"=",{"$f":"D36/(D8*1000)","v":807.64459936864102},"Base module cost per kW"]
[]
["Total Project Cost"]
[]
["A1 = 10% of BM",null,"=",{"$f":"0.1*$D$36","v":4013993.6588621461},"Engineering and construction management costs"]
["A2 = 10% of BM",null,"=",{"$f":"0.1*$D$36","v":4013993.6588621461},"Labor adjustment for 6 x 10 hour shift premium, per diem, etc."]
["A3 = 10% of BM",null,"=",{"$f":"0.1*$D$36","v":4013993.6588621461},"Contractor profit and fees"]
[]
["CECC ($) - Excludes Owner's Costs = BM + A1 + A2 + A3",null,"=",{"$f":"D36+D41+D42+D43","v":52181917.565207891},"Capital, engineering, and construction costs subtotal"]
["CECC ($/kW) - Excludes Owner's Costs =",null,"=",{"$f":"D45/(D8*1000)","v":1049.9379791792333},"Capital, engineering, and construction costst subtotal per kW"]
[]
["B1 = 5% of CECC",null,"=",{"$f":"0.05*D45","v":2609095.8782603946},"Owner's costs including all \"home office\" costs (owner's engineering, management, and procurement activities)"]
[]
["TPC ($) - Includes Owners Costs = CECC + B1",null,"=",{"$f":"D45+D48","v":54791013.443468288},"Total project cost without Allowance for Funds Used During Construction (AFUDC)"]
["TPC ($/kW) - Include Owner's Costs =",null,"=",{"$f":"D50/(D8*1000)","v":1102.434878138195},"Total project cost per kW without AFUDC"]
[]
["B2 = 10% of (CECC + B1)",null,"=",{"$f":"0.1*D50","v":5479101.3443468288},"AFUDC (based on a 3 year engineering and construction cycle)"]
[]
["TPC ($) - Includes Owner's Costs and AFUDC = CECC + B1 + B2",null,"=",{"$f":"D45+D48+D53","v":60270114.787815116},"Total project cost"]
["TPC ($/kW) - Includes Owner's Costs and AFUDC =",null,"=",{"$f":"D55/(D8*1000)","v":1212.6783659520145},"Total project cost per kW"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Spray Dry Absorber - Chena Power Plant"]
[]
[]
["Direct Annual Costs"]
["Fixed Operating and Maintenance (O&M) Cost"]
[]
["FOMO ($/kW yr) = (4 additional operators)*(2080)*T/(A*1000)",null,"=",{"$f":"8*2080*D24/(D8*1000)","v":20.088531187122737},"Fixed O&M additional operating labor costs"]
["FOMM ($/kW yr) = BM*0.015/(B*A*1000)",null,"=",{"$f":"D36*0.015/(D9*D8*1000)","v":8.0764459936864093},"Fixed O&M additional maintenance material and labor costs"]
["FOMA ($/kW yr) = 0.03*(FOMO+0.4*FOMM)",null,"=",{"$f":"0.03*(D77+0.4*D78)","v":0.69957328753791892},"Fixed O&M additional administrative labor costs"]
[]
["FOM ($/kW yr) = FOMO + FOMM + FOMA",null,"=",{"$f":"D77+D78+D79","v":28.864550468347066},"Total Fixed O&M costs"]
[]
["Variable O&M Cost"]
[]
["VOMR ($/MWh) = K*P/A",null,"=",{"$f":"D16*D20/D8","v":0.21342949680000001},"Variable O&M costs for lime reagent"]
[]
["VOMW ($/MWh) = L*Q/A",null,"=",{"$f":"D17*D21/D8","v":0.18430029540000004},"Variable O&M costs for waste disposal"]
[]
["VOMP ($/MWh) = M*R*10",null,"=",{"$f":"D18*D22*10","v":2.8722645286334996},"Variable O&M costs for additional auxiliary power required including additional fan power (Refer to Aux Power % above)"]
[]
["VOMM ($/MWh) = N*S/A",null,"=",{"$f":"D19*D23/D8","v":0.41669136939345303},"Variable O&M costs for makeup water"]
[]
["VOM ($/MWh) = VOMR + VOMW + VOMP + VOMM",null,"=",{"$f":"D85+D87+D89+D91","v":3.6866856902269527},"Total Variable O&M Costs"]
[]
["Indirect Annual Costs"]
[]
["Overhead (60% of total labor and material costs)",null,"=",{"$f":"0.6*D81*D8*1000","v":860740.89496610954},"CC Manual"]
["Administrative charges (2% of total capital investment)",null,"=",{"$f":"0.02*D55","v":1205402.2957563023},"CC Manual"]
["Property tax (1% of total capital investment)",null,"=",{"$f":"0.01*D55","v":602701.14787815115},"CC Manual"]
["Insurance (1% of total capital investment)",null,"=",{"$f":"0.01*D55","v":602701.14787815115},"CC Manual"]
["Capital Recovery Factor (CRF) = [ i (1+i)n ] / [ (1+i)n - 1 ]"]
["i  = Interest rate (%)                               ",7]
["n = Equipment life (years)",15]
["CRF =",{"$f":"((B102/100)*((1+(B102/100))^B103))/(((1+(B102/100))^B103)-1)","v":0.10979462470100652},"=",{"$f":"B104*D55","v":6617334.6338147437},"CC Manual"]
[]
["TOTAL INDIRECT ANNUAL OPERATING COSTS",null,"=",{"$f":"SUM(D97:D104)","v":9888880.1202934571}]
[]
["TOTAL ANNUALIZED OPERATING COSTS (2012 $)",null,"=",{"$f":"D81*D8*1000+D93*D8*8760+D106","v":12928528.000895794}]
[]
[]
["Composite CE Index for 2012 (cost year of equation)",null,"=",584.6]
["Composite CE Index for 2016 (cost year of review)",null,"=",536.4]
[]
["TOTAL ANNUALIZED OPERATING COSTS (2016 $)",null,"=",{"$f":"D108*D112/D111","v":11862576.838317659}]
[]
[]
["TOTAL UNCONTROLLED SO2 EMISSIONS, tons",null,"=",{"$f":"D11*(D15/1000000)*8760/2000","v":848.97540000000004}]
["SO2 REMOVAL EFFICIENCY, %",null,"=",90]
["TOTAL SO2 REMOVED, tons",null,"=",{"$f":"D117*D118/100","v":764.0778600000001}]
[]
["SO2 COST-EFFECTIVENESS, $/ton removed",null,"=",{"$f":"D114/D119","v":15525.350830499992}]

{"sheet":"Wet Scrubber","index":2,"n_rows":120,"n_cols":5,"rows_kept":120,"cut":false,"hidden":false,"merged":[[66,0,66,5],[85,4,85,5],[17,4,17,5],[18,4,18,5],[19,4,19,5],[20,4,20,5],[21,4,21,5],[2,0,2,5],[4,4,4,5],[5,4,5,5],[22,0,22,5],[49,4,49,5],[11,4,11,5],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[6,4,6,5],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,4,10,5]]}
[]
[]
["Four Boilers Wet Scrubber - Chena Power Plant"]
[]
["Variable","Designation","Units","Value","Calculation"]
["Unit Size (Gross)","A","(MW)",49.7,"<-- User Input (Conservative assumption based on a total heat input of 497 MMBtu/hr)"]
["Retrofit Factor","B",null,1.5,"<-- User Input (An \"average\" retrofit has a factor of 1.0) Sargent and Lundy has a drop down menu for selection of an additional waste water treatment plant facility, but no capital or operational cost are implemented so it is not reproduced here."]
["Gross Heat Rate","C","(Btu/kWh)",10000,"<-- User Input"]
["SO2 Rate","D","(lb/MMBtu)",0.39,"<-- User Input"]
["Type of Coal","E",null,"sub-bituminous","<-- User Input"]
["Coal Factor","F",null,1.05,"Bituminous = 1, Sub-Bituminous = 1.05, Lignite = 1.07"]
["Heat Rate Factor","G",null,{"$f":"D8/10000","v":1},"C/10000"]
["Heat Input","H","(Btu/hr)",{"$f":"D6*D8*1000","v":497000000},"A*C*1000"]
["Limestone Rate","K","(ton/hr)",{"$f":"17.52*D6*D9*D12/2000","v":0.16979508000000001},"17.52*A*D*G/2000"]
["Waste Rate","L","(ton/hr)",{"$f":"1.811*D14","v":0.30749888988000001},"1.811*K"]
["Aux Power","M","(%)",{"$f":"(1.05*EXP(0.155*D9))*D11*D12","v":1.1712017147715181},"(1.05e^(0.155*D))*F*G "]
["Makeup Water Rate","N","(1000 gph)",{"$f":"(1.674*D9+74.68)*D6*D11*D12/1000","v":3.9312452991000009},"(1.674*D+74.68)*A*F*G/1000"]
["Limestone Cost","P","($/ton)",20,"<-- User Input (https://www3.epa.gov/ttncatc1/dir1/ffdg.pdf)"]
["Waste Disposal Cost","Q","($/ton)",30,"<-- User Input (https://www3.epa.gov/ttncatc1/dir1/ffdg.pdf)"]
["Aux Power Cost","R","($/kWh)",0.21,"<-- User Input (http://www.gvea.com/rates/rates) "]
["Makeup Water Cost","S","($/1000 gal)",7.17,"<-- User Input (http://www.newsminer.com/water-rates/article_11a2ba10-c211-562e-8da9-87dd16a7b104.html)"]
["Operating Labor Rate","T","($/hr)",60,"Labor cost including all benefits"]
["IPM Model - Updates to Cost and Performance for APC Technologies - Wet FGD for SO2 Control Cost Development Methodology, August 2010, prepared by Sargent & Lundy LLC for US EPA.                                                          https://www.epa.gov/sites/production/files/2015-07/documents/chapter_5_appendix_5-1a_wet_fgd.pdf"]
["Capital Cost Calculation (2012 dollars)",null,null,null,"Comments"]
[]
["Includes - Equipment, installation, building, foundations, electrical, minor physical/chemical waste water treatment, and a retrofit difficulty factor of 1.5"]
[]
["BMR ($) = 550,000*(B)*((F*G)^0.6)*((D/2)^0.02)*(A^0.716)",null,"=",{"$f":"550000*(D7)*((D11*D12)^0.6)*((D9/2)^0.02)*(D6^0.716)","v":13475950.111980477},"Base absorber island cost"]
[]
["BMF ($) = 190,000*(B)*((D*G)^0.3)*(A^0.716)",null,"=",{"$f":"190000*(D7)*((D9*D12)^0.3)*(D6^0.716)","v":3521724.8064490589},"Base reagent preparation cost"]
[]
["BMW ($) = 100,000*(B)*((D*G)^0.45)*(A^0.716)",null,"=",{"$f":"100000*(D7)*((D9*D12)^0.45)*(D6^0.716)","v":1609390.7710016216},"Base waste handling cost"]
[]
["BMB ($) = 1,010,000*(B)*((F*G)^0.4)*(A^0.716)",null,"=",{"$f":"1010000*(D7)*((D11*D12)^0.4)*(D6^0.716)","v":25320922.663800523},"Base balance of plan cost including: ID or booster fans, new wet chimney, piping, ductwork, minor waste water treatment, etc…"]
[]
["BMWW ($) = ",null,"=",0,"Base wastewater treatment facility, beyond minor physical/chemcial treatment"]
[]
["Base Module (BM) ($) = BMR + BMF + BMW + BMB + BMWW",null,"=",{"$f":"D28+D30+D32+D34+D36","v":43927988.353231683},"Total base cost including retrofit factor"]
["BM ($/kW)",null,"=",{"$f":"D38/(D6*1000)","v":883.8629447330319},"Base cost per kW"]
[]
["Total Project Cost"]
[]
["A1 = 10% of BM",null,"=",{"$f":"0.1*$D$38","v":4392798.8353231689},"Engineering and construction management costs (CC Manual)"]
["A2 = 10% of BM",null,"=",{"$f":"0.1*$D$38","v":4392798.8353231689},"Labor adjustment for 6 x 10 hour shift premium, per diem, etc. (CC Manual)"]
["A3 = 10% of BM",null,"=",{"$f":"0.1*$D$38","v":4392798.8353231689},"Contractor profit and fees (CC Manual)"]
[]
["CECC ($) - Excludes Owner's Costs = BM + A1 + A2 + A3",null,"=",{"$f":"D38+D43+D44+D45","v":57106384.859201193},"Capital, engineering, and construction costs subtotal"]
["CECC ($/kW) - Excludes Owner's Costs =",null,"=",{"$f":"D47/(D6*1000)","v":1149.0218281529415},"Capital, engineering, and construction costst subtotal per kW"]
[]
["B1 = 5% of CECC",null,"=",{"$f":"0.05*D47","v":2855319.24296006},"Owner's costs including all \"home office\" costs (owner's engineering, management, and procurement activities)"]
[]
["TPC ($) - Includes Owners Costs = CECC + B1",null,"=",{"$f":"D47+D50","v":59961704.102161251},"Total project cost without Allowance for Funds Used During Construction (AFUDC)"]
["TPC ($/kW) - Include Owner's Costs =",null,"=",{"$f":"D52/(D6*1000)","v":1206.4729195605885},"Total project cost per kW without AFUDC"]
[]
["B2 = 10% of (CECC + B1)",null,"=",{"$f":"0.1*(D47+D50)","v":5996170.4102161257},"AFUDC (based on a 3 year engineering and construction cycle)"]
[]
["TPC ($) - Includes Owner's Costs and AFUDC = CECC + B1 + B2",null,"=",{"$f":"D52+D55","v":65957874.512377374},"Total project cost"]
["TPC ($/kW) - Includes Owner's Costs and AFUDC = ",null,"=",{"$f":"D57/(D6*1000)","v":1327.1202115166473},"Total project cost per kW"]
[]
[]
[]
[]
[]
[]
[]
[]
["Wet Scrubber - Chena Power Plant"]
[]
[]
["Direct Annual Costs"]
["Fixed O&M Cost"]
[]
["FOMO ($/kW yr) = (6 additional operators)*(2080)*T/(A*1000)",null,"=",{"$f":"6*2080*D22/(D6*1000)","v":15.066398390342052},"Fixed O&M additional operating labor costs"]
["FOMM ($/kW yr) = BM*0.015/(B*A*1000)",null,"=",{"$f":"D38*0.015/(D7*D6*1000)","v":8.838629447330316},"Fixed O&M additional maintenance material and labor costs"]
["FOMA ($/kW yr) = 0.03*(FOMO+0.4*FOMM)",null,"=",{"$f":"0.03*(D73+0.4*D74)","v":0.55805550507822532},"Fixed O&M additional administrative labor costs"]
["FOMWW ($/kW yr) =",null,null,0,"Fixed O&M costs for wastewater treatment facility"]
[]
["FOM ($/kW yr) = FOMO + FOMM + FOMA + FOMWW",null,"=",{"$f":"D73+D74+D75+D76","v":24.463083342750593},"Total Fixed O&M costs ($/kW yr)"]
[]
["Variable O&M Cost"]
[]
["VOMR ($/MWh) = K*P/A",null,"=",{"$f":"D14*D18/D6","v":6.8328E-2},"Variable O&M costs for limestone reagent"]
[]
["VOMW ($/MWh) = L*Q/A",null,"=",{"$f":"D15*D19/D6","v":0.18561301200000002},"Variable O&M costs for waste disposal "]
[]
["VOMP ($/MWh) = M*R*10",null,"=",{"$f":"D16*D20*10","v":2.4595236010201877},"Variable O&M costs for additional auxiliary power required including additional fan power (Refer to Aux Power % above)"]
[]
["VOMM ($/MWh) = N*S/A",null,"=",{"$f":"D17*D21/D6","v":0.5671434365100001},"Variable O&M costs for makeup water"]
[]
["VOMWW ($/MWh) =",null,"=",0,"Variable O&M costs for wastewater treatment facility"]
[]
["VOM ($/MWh) = VOMR + VOMW + VOMP + VOMM + VOMWW",null,"=",{"$f":"D82+D84+D86+D88+D90","v":3.2806080495301879},"Total Variable O&M Costs ($/MW yr)"]
[]
["Indirect Annual Costs"]
[]
["Overhead (60% of total labor and material costs)",null,"=",{"$f":"0.6*D78*D6*1000","v":729489.14528082276},"CC Manual"]
["Administrative charges (2% of total capital investment)",null,"=",{"$f":"0.02*D57","v":1319157.4902475474},"CC Manual"]
["Property tax (1% of total capital investment)",null,"=",{"$f":"0.01*D57","v":659578.7451237737},"CC Manual"]
["Insurance (1% of total capital investment)",null,"=",{"$f":"0.01*D57","v":659578.7451237737},"CC Manual"]
["Capital Recovery Factor (CRF) = [ i (1+i)n ] / [ (1+i)n - 1 ]"]
["i  = Interest rate (%)                               ",7]
["n = Equipment life (years)",15]
["CRF =",{"$f":"((B101/100)*((1+(B101/100))^B102))/(((1+(B101/100))^B102)-1)","v":0.10979462470100652},"=",{"$f":"B103*D57","v":7241820.0781625574},"CC Manual"]
[]
["TOTAL INDIRECT ANNUAL OPERATING COSTS",null,"=",{"$f":"SUM(D96:D103)","v":10609624.203938475}]
[]
["TOTAL ANNUALIZED OPERATING COSTS (2012 $)",null,"=",{"$f":"D78*D6*1000+D92*D6*8760+D105","v":13253724.333813237}]
[]
[]
["Composite CE Index for 2012 (cost year of equation)",null,"=",584.6]
["Composite CE Index for 2016 (cost year of review)",null,"=",536.4]
[]
["TOTAL ANNUALIZED OPERATING COSTS (2016 $)",null,"=",{"$f":"D107*D111/D110","v":12160960.883779371}]
[]
[]
["TOTAL UNCONTROLLED SO2 EMISSIONS, tons",null,"=",{"$f":"D9*(D13/1000000)*8760/2000","v":848.97540000000004}]
["SO2 REMOVAL EFFICIENCY, %",null,"=",99]
["TOTAL SO2 REMOVED, tons",null,"=",{"$f":"D116*D117/100","v":840.48564599999997}]
[]
["SO2 COST-EFFECTIVENESS, $/ton removed",null,"=",{"$f":"D113/D118","v":14468.969150937019},"Does not include costs associated with building and maintaining a wastewater treatment facility"]

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