{"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":108,"n_cols":5,"rows_kept":108,"cut":false,"hidden":false,"merged":[[9,4,9,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[3,0,3,5],[5,4,5,5],[6,4,6,5],[7,4,7,5],[8,4,8,5],[61,0,61,5],[77,4,77,5],[43,4,43,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[13,4,13,5],[20,4,20,5],[22,4,22,5],[23,4,23,5],[21,4,21,5],[18,4,18,5],[19,4,19,5],[24,0,24,5]]}
[]
[]
[]
["Dry Sorbent Injection System - Fort Wainwright"]
[]
["Variable","Designation","Units","Value","Calculation"]
["Unit Size (Gross)","A","(MW)",138,"<-- User Input (Conservative assumption based on a total heat input of 1380 MMBtu/hour)"]
["Retrofit Factor","B",null,1,"<-- User Input (An \"average\" retrofit has a factor of 1.0)"]
["Gross Heat Rate","C","(Btu/kWh)",10000,"<-- User Input"]
["SO2 Rate","D","(lb/MMBtu)",0.46,"<-- 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":"D7*D9*1000","v":1380000000},"A*C*1000"]
["NSR","K",null,{"$f":"IF(D14<40,0.016*D14,0.208*EXP(0.0281*D14))","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)*D16*D7*D9*D10","v":1.5016662335491429},"(1.2011x10^-06)*K*A*C*D"]
["Sorbent Waste Rate","N","(ton/hr)",{"$f":"(0.7035-0.00073696*D14/D16)*D17","v":1.0114700949795179},"(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":"(D15/1000)*0.07*(1-0.6)/(2*7560)","v":2.5555555555555562},"(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":"D17*20/D7","v":0.21763278747089027},"=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, August 2010, 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.0"]
[]
["Base Module (BM) ($)",null,"=",{"$f":"IF(D17>25,(750000*D8*D17),(7516000*D8*D17^0.284))","v":8435942.7037387528},"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":"D30/(D7*1000)","v":61.1300195923098},"Base module cost per kW"]
[]
["Total Project Cost"]
[]
["A1 = 10% of BM",null,"=",{"$f":"0.05*$D$30","v":421797.13518693764},"Engineering and construction management costs (CC Manual)"]
["A2 = 10% of BM",null,"=",{"$f":"0.05*$D$30","v":421797.13518693764},"Labor adjustment for 6 x 10 hour shift premium, per diem, etc. (CC Manual)"]
["A3 = 10% of BM",null,"=",{"$f":"0.05*$D$30","v":421797.13518693764},"Contractor profit and fees (CC Manual)"]
[]
["CECC ($) - Excludes Owner's Costs = BM + A1 + A2 + A3",null,"=",{"$f":"D30+D37+D38+D39","v":9701334.1092995629},"Capital, engineering, and construction costs subtotal"]
["CECC ($/kW) - Excludes Owner's Costs",null,"=",{"$f":"D41/(D7*1000)","v":70.299522531156256},"Capital, engineering, and construction costst subtotal per kW"]
[]
["B1 = 5% of CECC",null,"=",{"$f":"0.05*D41","v":485066.70546497818},"Owner's costs including all \"home office\" costs (owner's engineering, management, and procurement activities)"]
[]
["TPC ($) - Includes Owners Costs = CECC + B1",null,"=",{"$f":"D41+D44","v":10186400.814764541},"Total project cost without Allowance for Funds Used During Construction (AFUDC)"]
["TPC ($/kW) - Include Owner's Costs ",null,"=",{"$f":"D46/(D7*1000)","v":73.814498657714068},"Total project cost per kW without AFUDC"]
[]
["B2 = 0% of (CECC + B1)",null,"=",0,"AFUDC (Zero for less than 1 year engineering and construction cycle)"]
[]
["TPC ($) = CECC + B1 + B2",null,"=",{"$f":"D46+D49","v":10186400.814764541},"Total project cost"]
["TPC ($/kW)",null,"=",{"$f":"D51/(D7*1000)","v":73.814498657714068},"Total project cost per kW"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Dry Sorbent Injection System - Fort Wainwright"]
[]
[]
["Direct Annual Costs"]
["Fixed Operating and Maintenance (O&M) Cost"]
[]
["FOMO ($/kW yr) = (1 additional operators)*(2080)*U/(A*1000)",null,"=",{"$f":"1*2080*D24/(D7*1000)","v":0.90434782608695652},"Fixed O&M additional operating labor costs"]
["FOMM ($/kW yr) = BM*0.01/(B*A*1000)",null,"=",{"$f":"D30*0.01/(D8*D7*1000)","v":0.61130019592309803},"Fixed O&M additional maintenance material and labor costs"]
["FOMA ($/kW yr) = 0.03*(FOMO+0.4*FOMM)",null,"=",{"$f":"0.03*(D68+0.4*D69)","v":3.4466037133685873E-2},"Fixed O&M additional administrative labor costs"]
[]
["FOM ($/kW yr) = FOMO + FOMM + FOMA",null,"=",{"$f":"D68+D69+D70","v":1.5501140591437403},"Total Fixed O&M costs ($/kW yr)"]
[]
["Variable O&M Cost"]
[]
["VOMR ($/MWh) = M*R/A",null,"=",{"$f":"D17*D21/D7","v":4.907619357468576},"Variable O&M costs for Trona reagent"]
["VOMW ($/MWh) = (N+P)*S/A",null,"=",{"$f":"(D18+D19)*D22/D7","v":1.2924005980199542},"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":"D20*D23*10","v":0.45702885368886953},"Variable O&M costs for additional auxiliary power required (Refer to Aux Power % above)"]
[]
["VOM ($/MWh) = VOMR + VOMW + VOMP",null,"=",{"$f":"D76+D77+D78","v":6.6570488091773994},"Total Variable O&M Costs ($/MW yr)"]
[]
["Indirect Annual Costs"]
[]
["Overhead (60% of total labor and material costs)",null,"=",{"$f":"0.6*D72*D7*1000","v":128349.44409710169},"CC Manual"]
["Administrative charges (2% of total capital investment)",null,"=",{"$f":"0.02*D51","v":203728.01629529081},"CC Manual"]
["Property tax (1% of total capital investment)",null,"=",{"$f":"0.01*D51","v":101864.00814764541},"CC Manual"]
["Insurance (1% of total capital investment)",null,"=",{"$f":"0.01*D51","v":101864.00814764541},"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":"((B89/100)*((1+(B89/100))^B90))/(((1+(B89/100))^B90)-1)","v":0.10979462470100652},"=",{"$f":"B91*D51","v":1118412.0545110998},"CC Manual"]
[]
["TOTAL INDIRECT ANNUAL OPERATING COSTS",null,"=",{"$f":"SUM(D84:D91)","v":1654217.5311987831}]
[]
["TOTAL ANNUALIZED OPERATING COSTS (2012 $)",null,"=",{"$f":"D72*D7*1000+D80*D7*8760+D93","v":9915706.4357989933}]
[]
[]
["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":"D95*D99/D98","v":9098161.0197786167}]
[]
[]
["TOTAL UNCONTROLLED SO2 EMISSIONS, tons",null,"=",1767.2,"Statement of Basis for AQ1121TVP02 Revision 2 (includes 336,000 tpy combined limit for coal combustion)"]
["SO2 REMOVAL EFFICIENCY, %",null,"=",{"$f":"D14","v":80}]
["TOTAL SO2 REMOVED, tons",null,"=",{"$f":"D104*D105/100","v":1413.76}]
[]
["SO2 COST-EFFECTIVENESS, $/ton removed",null,"=",{"$f":"D101/D106","v":6435.4353071091391}]

{"sheet":"Spray Dry Absorber","index":1,"n_rows":115,"n_cols":5,"rows_kept":115,"cut":false,"hidden":false,"merged":[[4,0,4,5],[6,4,6,5],[24,0,24,5],[47,4,47,5],[67,0,67,5],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[11,4,11,5],[83,4,83,5],[19,4,19,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[23,4,23,5]]}
[]
[]
[]
[]
["Spray Dry Absorber - Fort Wainwright"]
[]
["Variable","Designation","Units","Value","Calculation"]
["Unit Size (Gross)","A","(MW)",138,"<-- User Input (Conservative assumption based on a total heat input of 1380 MMBtu/hr)"]
["Retrofit Factor","B",null,1,"<-- User Input (An \"average\" retrofit has a factor of 1.0)"]
["Gross Heat Rate","C","(Btu/kWh)",10000,"<-- User Input"]
["SO2 Rate","D","(lb/MMBtu)",0.46,"<-- 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":1380000000},"A*C*1000"]
["Lime Rate","K","(ton/hr)",{"$f":"(0.6702*(D11^2)+13.42*D11)*D8*D14/2000","v":0.43573598808000003},"(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":1.0017282386400002},"(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.3682562024600002},"(0.000547*(D^2)+0.00649*D+1.3)*F*G "]
["Makeup Water Rate","N","(1000 gph)",{"$f":"(0.04898*(D11^2)+0.5925*D11+55.11)*D8*D13*D14/1000","v":8.0264332629431987},"(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.0"]
[]
["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":19421841.917545024},"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":8746337.8063959684},"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":27744437.538158387},"Base module balance of plan cost including: ID or booster fans, piping, ductwork, electrical, etc…"]
[]
["Base Module (BM) ($)",null,"=",{"$f":"D30+D32+D34","v":55912617.262099378},"Base DSI module includes all equipment from unloading to injection"]
["BM ($/kW)",null,"=",{"$f":"D36/(D8*1000)","v":405.16389320361867},"Base module cost per kW"]
[]
["Total Project Cost"]
[]
["A1 = 10% of BM",null,"=",{"$f":"0.1*$D$36","v":5591261.7262099385},"Engineering and construction management costs (CC Manual)"]
["A2 = 10% of BM",null,"=",{"$f":"0.1*$D$36","v":5591261.7262099385},"Labor adjustment for 6 x 10 hour shift premium, per diem, etc. (CC Manual)"]
["A3 = 10% of BM",null,"=",{"$f":"0.1*$D$36","v":5591261.7262099385},"Contractor profit and fees (CC Manual)"]
[]
["CECC ($) - Excludes Owner's Costs = BM + A1 + A2 + A3",null,"=",{"$f":"D36+D41+D42+D43","v":72686402.440729201},"Capital, engineering, and construction costs subtotal"]
["CECC ($/kW) - Excludes Owner's Costs",null,"=",{"$f":"D45/(D8*1000)","v":526.7130611647043},"Capital, engineering, and construction costst subtotal per kW"]
[]
["B1 = 5% of CECC",null,"=",{"$f":"0.05*D45","v":3634320.1220364603},"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":76320722.562765658},"Total project cost without Allowance for Funds Used During Construction (AFUDC)"]
["TPC ($/kW) - Include Owner's Costs",null,"=",{"$f":"D50/(D8*1000)","v":553.04871422293957},"Total project cost per kW without AFUDC"]
[]
["B2 = 10% of (CECC + B1)",null,"=",{"$f":"0.1*(D45+D48)","v":7632072.2562765665},"AFUDC (Zero for less than 1 year engineering and construction cycle)"]
[]
["TPC ($) = CECC + B1 + B2",null,"=",{"$f":"D50+D53","v":83952794.819042221},"Total project cost"]
["TPC ($/kW)",null,"=",{"$f":"D55/(D8*1000)","v":608.35358564523347},"Total project cost per kW"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Spray Dry Absorber - Fort Wainwright"]
[]
[]
["Direct Annual Costs"]
["Fixed O&M Cost"]
[]
["FOMO ($/kW yr) = (4 additional operators)*(2080)*T/(A*1000)",null,"=",{"$f":"4*2080*D24/(D8*1000)","v":3.6173913043478261},"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":6.0774583980542793},"Fixed O&M additional maintenance material and labor costs"]
["FOMA ($/kW yr) = 0.03*(FOMO+0.4*FOMM)",null,"=",{"$f":"0.03*(D74+0.4*D75)","v":0.18145123990708614},"Fixed O&M additional administrative labor costs"]
[]
["FOM ($/kW yr) = FOMO + FOMM + FOMA",null,"=",{"$f":"D74+D75+D76","v":9.8763009423091912},"Total Fixed O&M costs ($/kW yr)"]
[]
["Variable O&M Cost"]
[]
["VOMR ($/MWh) = K*P/A",null,"=",{"$f":"D16*D20/D8","v":0.25260057280000003},"Variable O&M costs for lime reagent"]
["VOMW ($/MWh) = L*Q/A",null,"=",{"$f":"D17*D21/D8","v":0.21776700840000004},"Variable O&M costs for waste disposal "]
["VOMP ($/MWh) = M*R*10",null,"=",{"$f":"D18*D22*10","v":2.8733380251660003},"Variable O&M costs for additional auxiliary power required (Refer to Aux Power % above)"]
["VOMM ($/MWh) = N*S/A",null,"=",{"$f":"D19*D23/D8","v":0.41702555431378796},"Variable O&M costs for makeup water"]
[]
["VOM ($/MWh) = VOMR + VOMW + VOMP + VOMM",null,"=",{"$f":"D82+D83+D84+D85","v":3.7607311606797884},"Total Variable O&M Costs ($/MW yr)"]
[]
["Indirect Annual Costs"]
[]
["Overhead (60% of total labor and material costs)",null,"=",{"$f":"0.6*D78*D8*1000","v":817757.7180232011},"CC Manual"]
["Administrative charges (2% of total capital investment)",null,"=",{"$f":"0.02*D55","v":1679055.8963808445},"CC Manual"]
["Property tax (1% of total capital investment)",null,"=",{"$f":"0.01*D55","v":839527.94819042226},"CC Manual"]
["Insurance (1% of total capital investment)",null,"=",{"$f":"0.01*D55","v":839527.94819042226},"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":"((B96/100)*((1+(B96/100))^B97))/(((1+(B96/100))^B97)-1)","v":0.10979462470100652},"=",{"$f":"B98*D55","v":9217565.5997573454},"CC Manual"]
[]
["TOTAL INDIRECT ANNUAL OPERATING COSTS",null,"=",{"$f":"SUM(D91:D98)","v":13393435.110542236}]
[]
["TOTAL ANNUALIZED OPERATING COSTS (2012 $)",null,"=",{"$f":"D78*D8*1000+D87*D8*8760+D100","v":19302637.326103486}]
[]
[]
["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":"D102*D106/D105","v":17711143.793571517}]
[]
[]
["TOTAL UNCONTROLLED SO2 EMISSIONS, tons",null,"=",1767.2,"Statement of Basis for AQ1121TVP02 Revision 2 (includes 336,000 tpy combined limit for coal combustion)"]
["SO2 REMOVAL EFFICIENCY, %",null,"=",90]
["TOTAL SO2 REMOVED, tons",null,"=",{"$f":"D111*D112/100","v":1590.48}]
[]
["SO2 COST-EFFECTIVENESS, $/ton removed",null,"=",{"$f":"D108/D113","v":11135.722419377495}]

{"sheet":"Wet Scrubber","index":2,"n_rows":125,"n_cols":5,"rows_kept":125,"cut":false,"hidden":false,"merged":[[92,4,92,5],[4,0,4,5],[17,4,17,5],[23,4,23,5],[24,0,24,5],[51,4,51,5],[75,0,75,5],[16,4,16,5],[19,4,19,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[10,4,10,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]]}
[]
[]
[]
[]
["Wet Scrubber - Fort Wainwright"]
[]
["Variable","Designation","Units","Value","Calculation"]
["Unit Size (Gross)","A","(MW)",138,"<-- User Input (Conservative assumption based on a total heat input of 1380 MMBtu/hr)"]
["Retrofit Factor","B",null,1,"<-- 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.46,"<-- 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":"D10/10000","v":1},"C/10000"]
["Heat Input","H","(Btu/hr)",{"$f":"D8*D10*1000","v":1380000000},"A*C*1000"]
["Limestone Rate","K","(ton/hr)",{"$f":"17.52*D8*D11*D14/2000","v":0.55608479999999993},"17.52*A*D*G/2000"]
["Waste Rate","L","(ton/hr)",{"$f":"1.811*D16","v":1.0070695727999999},"1.811*K"]
["Aux Power","M","(%)",{"$f":"(1.05*EXP(0.155*D11))*D13*D14","v":1.1839784417786956},"(1.05e^(0.155*D))*F*G "]
["Makeup Water Rate","N","(1000 gph)",{"$f":"(1.674*D11+74.68)*D8*D13*D14/1000","v":10.932710796000002},"(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.0"]
[]
["BMR ($) = 550,000*(B)*((F*G)^0.6)*((D/2)^0.02)*(A^0.716)",null,"=",{"$f":"550000*(D9)*((D13*D14)^0.6)*((D11/2)^0.02)*(D8^0.716)","v":18726829.288050029},"Base absorber island cost"]
[]
["BMF ($) = 190,000*(B)*((D*G)^0.3)*(A^0.716)",null,"=",{"$f":"190000*(D9)*((D11*D14)^0.3)*(D8^0.716)","v":5125478.0304108495},"Base reagent preparation cost"]
[]
["BMW ($) = 100,000*(B)*((D*G)^0.45)*(A^0.716)",null,"=",{"$f":"100000*(D9)*((D11*D14)^0.45)*(D8^0.716)","v":2401012.6606620811},"Base waste handling cost"]
[]
["BMB ($) = 1,010,000*(B)*((F*G)^0.4)*(A^0.716)",null,"=",{"$f":"1010000*(D9)*((D13*D14)^0.4)*(D8^0.716)","v":35071191.381151401},"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":"D30+D32+D34+D36+D38","v":61324511.36027436},"Total base cost including retrofit factor"]
["BM ($/kW)",null,"=",{"$f":"D40/(D8*1000)","v":444.3805171034374},"Base cost per kW"]
[]
["Total Project Cost"]
[]
["A1 = 10% of BM",null,"=",{"$f":"0.1*$D$40","v":6132451.1360274367},"Engineering and construction management costs (CC Manual)"]
["A2 = 10% of BM",null,"=",{"$f":"0.1*$D$40","v":6132451.1360274367},"Labor adjustment for 6 x 10 hour shift premium, per diem, etc. (CC Manual)"]
["A3 = 10% of BM",null,"=",{"$f":"0.1*$D$40","v":6132451.1360274367},"Contractor profit and fees (CC Manual)"]
[]
["CECC ($) - Excludes Owner's Costs = BM + A1 + A2 + A3",null,"=",{"$f":"D40+D45+D46+D47","v":79721864.768356681},"Capital, engineering, and construction costs subtotal"]
["CECC ($/kW) - Excludes Owner's Costs =",null,"=",{"$f":"D49/(D8*1000)","v":577.69467223446873},"Capital, engineering, and construction costst subtotal per kW"]
[]
["B1 = 5% of CECC",null,"=",{"$f":"0.05*D49","v":3986093.238417834},"Owner's costs including all \"home office\" costs (owner's engineering, management, and procurement activities)"]
[]
["TPC ($) - Includes Owners Costs = CECC + B1",null,"=",{"$f":"D49+D52","v":83707958.006774515},"Total project cost without Allowance for Funds Used During Construction (AFUDC)"]
["TPC ($/kW) - Include Owner's Costs =",null,"=",{"$f":"D54/(D8*1000)","v":606.57940584619212},"Total project cost per kW without AFUDC"]
[]
["B2 = 10% of (CECC + B1)",null,"=",{"$f":"0.1*(D49+D52)","v":8370795.8006774522},"AFUDC (based on a 3 year engineering and construction cycle)"]
[]
["TPC ($) - Includes Owner's Costs and AFUDC = CECC + B1 + B2",null,"=",{"$f":"D54+D57","v":92078753.807451963},"Total project cost"]
["TPC ($/kW) - Includes Owner's Costs and AFUDC = ",null,"=",{"$f":"D59/(D8*1000)","v":667.23734643081139},"Total project cost per kW"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Wet Scrubber - Fort Wainwright"]
[]
[]
["Direct Annual Costs"]
["Fixed O&M Cost"]
[]
["FOMO ($/kW yr) = (6 additional operators)*(2080)*T/(A*1000)",null,"=",{"$f":"6*2080*D24/(D8*1000)","v":5.4260869565217389},"Fixed O&M additional operating labor costs"]
["FOMM ($/kW yr) = BM*0.015/(B*A*1000)",null,"=",{"$f":"D40*0.015/(D9*D8*1000)","v":6.6657077565515603},"Fixed O&M additional maintenance material and labor costs"]
["FOMA ($/kW yr) = 0.03*(FOMO+0.4*FOMM)",null,"=",{"$f":"0.03*(D82+0.4*D83)","v":0.24277110177427089},"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":"D82+D83+D84+D85","v":12.334565814847569},"Total Fixed O&M costs ($/kW yr)"]
[]
["Variable O&M Cost"]
[]
["VOMR ($/MWh) = K*P/A",null,"=",{"$f":"D16*D20/D8","v":8.0591999999999983E-2},"Variable O&M costs for limestone reagent"]
["VOMW ($/MWh) = L*Q/A",null,"=",{"$f":"D17*D21/D8","v":0.21892816799999998},"Variable O&M costs for waste disposal "]
["VOMP ($/MWh) = M*R*10",null,"=",{"$f":"D18*D22*10","v":2.4863547277352609},"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.56802562614000007},"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":"D91+D92+D93+D94+D95","v":3.3539005218752607},"Total Variable O&M Costs ($/MW yr)"]
[]
["Indirect Annual Costs"]
[]
["Overhead (60% of total labor and material costs)",null,"=",{"$f":"0.6*D87*D8*1000","v":1021302.0494693787},"CC Manual"]
["Administrative charges (2% of total capital investment)",null,"=",{"$f":"0.02*D59","v":1841575.0761490392},"CC Manual"]
["Property tax (1% of total capital investment)",null,"=",{"$f":"0.01*D59","v":920787.5380745196},"CC Manual"]
["Insurance (1% of total capital investment)",null,"=",{"$f":"0.01*D59","v":920787.5380745196},"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":"((B106/100)*((1+(B106/100))^B107))/(((1+(B106/100))^B107)-1)","v":0.10979462470100652},"=",{"$f":"B108*D59","v":10109752.217225565},"CC Manual"]
[]
["TOTAL INDIRECT ANNUAL OPERATING COSTS",null,"=",{"$f":"SUM(D101:D108)","v":14814204.418993022}]
[]
["TOTAL ANNUALIZED OPERATING COSTS (2012 $)",null,"=",{"$f":"D87*D8*1000+D97*D8*8760+D110","v":20570837.76432655}]
[]
[]
["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":"D112*D116/D115","v":18874781.691386864}]
[]
[]
["TOTAL UNCONTROLLED SO2 EMISSIONS, tons",null,"=",1767.2,"Statement of Basis for AQ1121TVP02 Revision 2 (includes 336,000 tpy combined limit for coal combustion)"]
["SO2 REMOVAL EFFICIENCY, %",null,"=",99]
["TOTAL SO2 REMOVED, tons",null,"=",{"$f":"D121*D122/100","v":1749.5280000000002}]
[]
["SO2 COST-EFFECTIVENESS, $/ton removed",null,"=",{"$f":"D118/D123","v":10788.499350331553},"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":[]}