{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["4-1 Available-PM","4-2 Feasible-PM","4-3 Ranking-PM","4-4 EU 7 DPF TCI","4-5 EU 7 DPF CE","4-6 Cost Effectiveness","4-7 Proposed BACT","DO NOT INCLUDE - Identified-PM"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":13,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"4-1 Available-PM","index":0,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,2],[5,0,7,0],[10,0,15,0],[16,0,18,0],[2,0,2,1],[2,2,3,2],[5,1,7,1],[10,1,15,1],[16,1,18,1],[8,0,9,0],[8,1,9,1]]}
["Table 4-1. Summary of Available PM2.5 Emission Control Technologies"]
[]
["Emission Unit",null,"Emission Control Technology"]
["ID","Description"]
[]
["1, 2","Simple Cycle Gas Turbine","Low Sulfur Fuel"]
[null,null,"Low Ash Fuel"]
[null,null,"Good Combustion Practices"]
["5, 6","Combined Cycle Gas Turbine","Low Sulfur Fuel"]
[null,null,"Good Combustion Practices"]
[7,"Emergency Generator Engine","Limited Operation"]
[null,null,"DPF"]
[null,null,"Low Sulfur Fuel"]
[null,null,"Low Ash Fuel"]
[null,null,"Positive Crankcase Ventilation"]
[null,null,"Good Combustion Practices"]
["11, 12","Propane-Fired Boiler","Low Sulfur Fuel"]
[null,null,"FGR"]
[null,null,"Good Combustion Practices"]
[]
["Note:"]
["Data are based on a RBLC review from January 1, 2005 through September 15, 2015."]

{"sheet":"4-2 Feasible-PM","index":1,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[10,0,11,0],[10,1,11,1],[0,0,0,2],[7,1,9,1],[2,2,3,2],[7,0,9,0],[2,0,2,1]]}
["Table 4-2. Summary of  Technically Feasible PM2.5 Control Technology"]
[]
["Emission Unit",null,"Emission Control Technology"]
["ID"," Description"]
[]
["1, 2","Simple Cycle Gas Turbine","Good Combustion Practices"]
["5, 6","Combined Cycle Gas Turbine","Good Combustion Practices"]
["7","Emergency Generator Engine","Limited Operation"]
[null,null,"DPF"]
[null,null,"Good Combustion Practices"]
["11, 12","Propane-Fired Boiler","Low Sulfur Fuel"]
[null,null,"Good Combustion Practices"]
[]
["Note:"]
["Data are based on a RBLC review from January 1, 2005 through September 15, 2015."]

{"sheet":"4-3 Ranking-PM","index":2,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,5],[5,0,6,0],[5,1,6,1],[2,4,3,4],[2,5,3,5],[2,3,3,3],[2,0,2,1],[2,2,3,2]]}
["Table 4-3. Ranking of  Technically Feasible PM2.5 Emission Control Technology"]
[]
["Emission Unit",null,"Emission Control Technology","Control Efficiency (pct)","PM2.5 Emissions (tpy)","PM2.5 Emission Reduction (tpy)"]
["ID"," Description"]
[]
[7,"Emergency Generator Engine","DPF + Limited Operation + Good Combustion Practices",85,{"$f":"$E$7*(100-D6)/100","v":5.3110680479999993E-3},{"$f":"$E$7-E6","v":3.0096052272000001E-2}]
[null,null,"Limited Operation + Good Combustion Practices (existing)",0,3.5407120319999999E-2,0]
["11, 12","Propane-Fired Boiler","Low Sulfur Fuel (existing)",0,0.2,0]
[]
["Note:"]
["Data are based on a RBLC review from January 1, 2005 through September 15, 2015."]

{"sheet":"4-4 EU 7 DPF TCI","index":3,"n_rows":49,"n_cols":11,"rows_kept":49,"cut":false,"hidden":false,"merged":[[2,9,2,10],[7,1,7,10],[0,1,0,10],[1,1,1,10],[8,7,9,7],[8,8,9,8]]}
[null,"Table 4-4. Capital Costs for DPF"]
[null,"on the Diesel-Fired Engine (EU ID 7)"]
[null,null,null,null,null,null,null,null,null,"Shaded cells indicate user inputs."]
[null,"Total Capital Investment Determination - DPF",null,null,null,null,null,null,null,"Date:"]
[null,"Project: ",null,"GVEA North Pole PM2.5 BACT Analysis - Emergency Generator Engine (EU ID 7)",null,null,null,null,null,"Prepared By:"]
[null,null,null,null,null,null,null,null,null,"Checked By:"]
[null,null,null,null,null,null,null,null,null,"Rev:"]
[null,"Capital Costs"]
[null,"DIRECT COSTS",null,null,"QTY","UNIT","UNIT COST"," TOTAL MATERIALS COST"," TOTAL LABOR COST"]
[]
[null,"(1)","DPF"]
[null,null,"(a)","Basic equipment"]
[null,null,null,"Total DPF System",1,"EA",25954,{"$f":"E13*G13","v":25954}]
[null,null,null,null,null,null,null,null,null,"TOTAL =",{"$f":"SUM(H13:H13)","v":25954}]
[null,null,"(b)","Instrumentation"]
[null,null,null,"Total Instrumentation",null,"EA",null,{"$f":"E16*G16","v":0},"Included in above price"]
[null,null,null,null,null,null,null,null,null,"TOTAL =",{"$f":"SUM(H16:H16)","v":0}]
[null,null,"(c)","Freight"]
[null,null,null,"DPF Freight",1,"% MATL COST",0.1,{"$f":"G19*G13","v":2595.4},"-"]
[null,null,null,null,null,null,null,null,null,"TOTAL =",{"$f":"SUM(H19:H19)","v":2595.4}]
[null,null,"(d)","Labor"]
[null,null,null,"Labor - offsite fab",0,"MH",null,"None required",{"$f":"E22*G22","v":0}]
[null,null,null,"Labor - onsite",16,"MH",105,null,{"$f":"E23*G23","v":1680}]
[null,null,null,null,null,null,null,null,null,"TOTAL =",{"$f":"SUM(I22:I23)","v":1680}]
[null,null,"(e)","Vendor representatives fees"]
[null,null,null,"Fab Site Vendor Representatives fees (enter no. of days and daily rate)",0,"Days",null,null,{"$f":"G26*E26","v":0}]
[null,null,null,"Onsite Vendor Representatives fees (enter no. of days and daily rate)",0,"Days",null,null,{"$f":"G27*E27","v":0}]
[null,null,null,null,null,null,null,null,null,"TOTAL =",{"$f":"SUM(I26:I27)","v":0}]
[null,"Purchased Equipment and Material Cost (PEMC)",null,null,null,null,null,null,null," PEMC   =",{"$f":"K14+K17+K20+K24+K28","v":30229.4}]
[]
[null,"Direct Installation Costs (DIC)",null,null,"DPF replaces existing silencer, no direct installation costs necessary",null,null,null,null," DIC   =",{"$f":"0","v":0}]
[]
[]
[null,"Total Direct Costs (TDC)",null,null,null,null,null,null,null,"TDC = (PEMC) + (DIC)  =",{"$f":"+K29+K31","v":30229.4}]
[]
[]
[null,"INDIRECT COSTS"]
[null,"(2)","Engineering, Procurement & Construction Support Services",null,null,"% TDC",null,null,{"$f":"E38*K34","v":0},null,"Excluded in this estimate."]
[null,"(3)","Performance tests",null,null,"EA",null,null,{"$f":"G39*E39","v":0},null,"Excluded in this estimate."]
[null,"Total Indirect Costs (TIC)",null,null,null,null,null,null,null,"TIC   =",{"$f":"SUM(I38:I39)","v":0}]
[]
[]
[null,"MANAGEMENT AND CONTINGENCY COSTS"]
[null,"(4)","Unit Operator Costs",null,null,"% TDC",null,null,null,null,"Excluded in this estimate."]
[null,"(5)","Contingency",null,null,"30% PEC",null,null,{"$f":"E45*K34","v":0},null,"Excluded in this estimate."]
[null,"Total Management and Contingency Costs (TM&CC)",null,null,null,null,null,null,null,"TM & CC   =   ",{"$f":"SUM(I44:I45)","v":0}]
[]
[]
[null,"TOTAL CAPITAL INVESTMENT (TCI)",null,null,null,null,null,null,null,"TCI  =  (TDC)+(TIC)+(TM&CC)  = ",{"$f":"K34+K40+K46","v":30229.4}]

{"sheet":"4-5 EU 7 DPF CE","index":4,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[2,8,2,10],[7,1,7,10],[28,1,28,10],[0,1,0,10],[1,1,1,10]]}
[null,"Table 4-5. Annualized Costs for DPF"]
[null,"on the Diesel-Fired Engine (EU ID 7)"]
[null,null,null,null,null,null,null,null,"Shaded cells indicate user inputs"]
[null,"Cost Effectiveness Determination - DPF",null,null,null,null,null,null,null,"Date:"]
[null,"Project:  ",null,"GVEA North Pole PM2.5 BACT Analysis - Emergency Generator Engine (EU ID 7)",null,null,null,null,null,"Prepared By:"]
[null,null,null,null,null,null,null,null,null,"Checked By:"]
[null,null,null,null,null,null,null,null,null,"Rev:"]
[null,"Annualized Costs"]
[null,"DIRECT ANNUAL COSTS",null,null,"QTY","UNIT","UNIT COST"," TOTAL MATERIALS COST"," TOTAL LABOR COST",null,"TOTAL"]
[null,"(1)","Operating Labor",null,null,"MH",null,null,{"$f":"E10*G10","v":0},null,{"$f":"I10","v":0}]
[null,"(2)","DPF",null,null,"MH",null,null,{"$f":"E11*G11","v":0},null,{"$f":"I11","v":0}]
[null,"(3)","Maintenance Labor",null,null,"MH",null,null,{"$f":"E12*G12","v":0},null,0]
[null,"(4)","Maintenance Materials",null,null,"LOT",null,{"$f":"E13*G13","v":0},null,null,{"$f":"H13","v":0}]
[]
[null,"Total Direct Annual Costs (TDAC)",null,null,null,"Excluded in this estimate",null,null,null," TDAC   =",{"$f":"SUM(K10:K13)","v":0}]
[]
[null,"INDIRECT ANNUAL COSTS"]
[null,"(5)","Overhead",null,null,"MH",null,"Excluded in this estimate.",{"$f":"E18*G18","v":0},null,{"$f":"I18","v":0}]
[null,"(6)","Administrative Charges",null,null,"MH",null,"Excluded in this estimate.",{"$f":"E19*G19","v":0},null,{"$f":"I19","v":0}]
[null,"(7)","Property tax",null,null,null,null,"Excluded in this estimate."]
[null,"(8)","Insurance",null,null,null,null,"Excluded in this estimate."]
[null,null,"Capital Recovery Factor [see inputs below]",null,{"$f":"($E$37/100*POWER((1+($E$37/100)),$E$38))/((POWER(((1+$E$37/100)),$E$38))-1)","v":9.4392925743255696E-2}]
[null,"(9)","Capital Recovery",null,null,null,null,null,null,"CRF * TCI  = ",{"$f":"E22*'4-4 EU 7 DPF TCI'!K49","v":2853.441509463174}]
[]
[null,"Total Indirect Annual Costs (TIAC)",null,null,null,null,null,null,null," TIAC   =",{"$f":"SUM(K18:K23)","v":2853.441509463174}]
[]
[null,"TOTAL ANNUALIZED COSTS (TAC)",null,null,null,null,null,null,null,"TAC = (TDAC) + (TIAC)  =",{"$f":"K15+K25","v":2853.441509463174}]
[]
[null,"Cost Effectiveness Summary"]
[]
[null,"TOTAL TONS AVOIDED PER YEAR",null,null,null,null,null,null,null,"=",{"$f":"'4-3 Ranking-PM'!F6","v":3.0096052272000001E-2}]
[]
[null,"COST EFFECTIVENESS ($ PER TON AVOIDED)",null,null,null,null,null,null,null,"(TAC)/(TPY)   = ",{"$f":"K27/K31","v":94811.156083679671}]
[]
[]
[null,null,null,"Data Inputs for Capital Recovery Factor:"]
[null,null,null,"Annual Interest Rate (EPA OAQPS Control Cost Manual) ",7,"%"]
[null,null,null,"Project Life (EPA OAQPS Control Cost Manual) ",20,"years"]
[null,null,null,"Catalyst Life ","N/A","years"]
[null,null,null,"Asset Utilization ","N/A","%"]

{"sheet":"4-6 Cost Effectiveness","index":5,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[5,0,5,5]]}
["Table 4-6. GVEA North Pole Facility - PM2.5 BACT Cost Effectiveness"]
[" Summary1 for Each Emission Unit"]
[" "]
["Control Technology Option","PM2.5 Emissions (tpy)","Total Installed Capital ($)","Total Annualized Cost ($/year)","Annual O&M Cost ($/year)","Cost Effectiveness ($/ton PM2.5 removed)"]
[" "]
["Emergency Generator Engine (EU ID 7)"]
[{"$f":"'4-3 Ranking-PM'!C6","v":"DPF + Limited Operation + Good Combustion Practices"},{"$f":"'4-3 Ranking-PM'!E6","v":5.3110680479999993E-3},{"$f":"'4-4 EU 7 DPF TCI'!K49","v":30229.4},{"$f":"'4-5 EU 7 DPF CE'!K27","v":2853.441509463174},"~",{"$f":"'4-5 EU 7 DPF CE'!K33","v":94811.156083679671}]
["Limited Operation + Good Combustion Practices2 (existing)",{"$f":"'4-3 Ranking-PM'!E7","v":3.5407120319999999E-2},"~","~","~","~"]
[]
["Notes:"]
["1 All emissions costs are on a per unit basis."]
["2 This technology is proposed as the baseline case."]

{"sheet":"4-7 Proposed BACT","index":6,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4],[3,2,4,2],[13,0,13,1]]}
["Table 4-7.  GVEA North Pole Facility - Proposed PM2.5 BACT and Associated"]
["Emission Rate for Each Emission Unit"]
[" "]
["Emission Unit",null,"Fuel","PM2.5 BACT"]
["ID","Description",null,"Description","Emission Rate1"]
[]
[1,"Simple Cycle Gas Turbine","Fuel Oil","Good Combustion Practices","0.12 lb/MMBtu"]
[2,"Simple Cycle Gas Turbine","Fuel Oil","Good Combustion Practices","0.12 lb/MMBtu"]
["5, 6","Combined Cycle Gas Turbine","LSR","Good Combustion Practices","0.12 lb/MMBtu"]
[7,"Emergency Generator Engine","Fuel Oil","Limited Operation + Good Combustion Practices","0.0022 lb/hp-hr"]
["11, 12","Boiler","Propane","Low Sulfur Fuel","0.7 lb/103 gal"]
[]
["Note:"]
["1 Emissions are on a per unit basis."]
["2 Each proposed BACT is an existing control technology."]
[" "]

{"sheet":"DO NOT INCLUDE - Identified-PM","index":7,"n_rows":39,"n_cols":5,"rows_kept":39,"cut":false,"hidden":false,"merged":[[3,0,6,0],[20,0,26,0],[12,0,14,0],[32,0,37,0],[29,0,29,2]]}
["Table D-1a. Summary of Identified PM2.5 Control Technology -  Liquid Fuel-Fired Simple Cycle Turbines > 25 MW  (RBLC 15.190)"]
[]
["Pollutant","Control Technology Used","Number of RBLC Entries (11 Total)"]
["PM","None",8]
[null,"Good Combustion Practices",1]
[null,"Low Ash Fuel",1]
[null,"Low Sulfur Fuel",1]
["Note: Data is based on a RBLC review from January 1, 2005 through September 15, 2015."]
[]
["Table D-1b. Summary of Identified PM2.5 Control Technology -  Liquid Fuel-Fired Combined Cycle Turbines > 25 MW  (RBLC 15.290)"]
[]
["Pollutant","Control Technology Used","Number of RBLC Entries (8 Total)"]
["PM","Good Combustion Practices",4]
[null,"None",3]
[null,"Low Sulfur Fuel",3]
["Note: Data is based on a RBLC review from January 1, 2005 through September 15, 2015."]
[]
["Table D-1c. Summary of Identified PM2.5 Control Technology - Large Diesel Engines > 500 hp (RBLC 17.110)"]
[]
["Pollutant","Control Technology Used",{"$f":"\"Number of RBLC Entries (\"& SUM(C21:C27)& \" Total)\"","v":"Number of RBLC Entries (81 Total)"}]
["PM","Good Combustion Practices",27]
[null,"None",27]
[null,"Federal Standards",13]
[null,"Limited Operation",5]
[null,"Low Sulfur Fuel",5]
[null,"Low Ash Fuel",3]
[null,"Positive Crankcase Ventilation",1]
["Note: Data is based on a RBLC review from January 1, 2005 through September 15, 2015."]
[]
["Table D-1d. Summary of Identified PM2.5 Control Technology -  Natural Gas-Fired Commercial/Institutional Boilers <100 MMBtu/hr (RBLC 13.310)"]
[]
["Pollutant","Control Technology Used","Number of RBLC Entries (65 Total)"]
["PM","Good Control Practices",27]
[null,"None",25,null,{"$f":"(C33+C34+C36)","v":54}]
[null,"Low Sulfur Fuel",19]
[null,"Operational Limit",2]
[null,"FGR",1]
[null,"Baghouse",1]
["Note: Data is based on a RBLC review from January 1, 2005 through September 15, 2015."]