{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["5-4 EU ID 1&2 ULSD CE","5-10 NP & Zehnder","ESRI_MAPINFO_SHEET"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":9,"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":"5-4 EU ID 1&2 ULSD CE","index":0,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,1,0,10],[1,1,1,10],[41,2,41,10],[42,2,42,10],[3,8,3,10],[8,1,8,10],[28,1,28,10]]}
[null,"Table 5-4. Annualized Costs for ULSD Combustion in"]
[null,"the Diesel-fired Simple Cycle Gas Turbines (EU ID 1 and 2)"]
[]
[null,null,null,null,null,null,null,null,"Shaded cells indicate user inputs"]
[null,"Cost Effectiveness Determination - ULSD Fuel Switch - No Additional Tank Storage",null,null,null,null,null,null,null,"Date:"]
[null,"Project:  ",null,"GVEA Zhender -  SO2 BACT Analysis (EU ID 1 and 2 - Frame 5 CTs, cost per turbine)",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",null," TOTAL MATERIALS COST"," TOTAL LABOR COST",null,"TOTAL"]
[null,"(1)","Operating & Maintenance Costs",null,null,"%",null,null,{"$f":"'[1]Total Capital Investment'!K44*E11/E40","v":0},null,{"$f":"I11","v":0}]
[null,"(2)","Repair & Replacement Costs",null,null,"%",null,null,{"$f":"E12*'[1]Total Capital Investment'!K47/10","v":0},null,{"$f":"I12","v":0}]
[null,"(3)","Maintenance Materials",null,null,"LOT"]
[null,"(4)","Utilities"]
[null,null,"(a)","ULSD Costs:",18059076.920000002,"GAL",0.26679999999999998,{"$f":"E15*G15","v":4818161.7222560002},null,null,{"$f":"H15","v":4818161.7222560002}]
[]
[null,"Total Direct Annual Costs (TDAC)",null,null,null,null,null,null,null," TDAC   =",{"$f":"SUM(K11:K15)","v":4818161.7222560002}]
[]
[null,"INDIRECT ANNUAL COSTS"]
[null,"(5)","Overhead",null,null,"%",null,null,{"$f":"E20*G20","v":0},null,{"$f":"I20","v":0}]
[null,"(6)","Administrative Charges, Property Taxes, Insurance",null,null,"% of capital",null,null,{"$f":"E21*'[1]Total Capital Investment'!K62","v":0},null,{"$f":"I21","v":0}]
[null,null,"Capital Recovery Factor [see inputs below]",null,{"$f":"($E$39/100*POWER((1+($E$39/100)),$E$40))/((POWER(((1+$E$39/100)),$E$40))-1)","v":9.4392925743255696E-2}]
[null,"(7)","Capital Recovery",null,null,null,null,null,null,"CRF * TCI  = ",{"$f":"E22*'[1]Total Capital Investment'!K62","v":0}]
[]
[null,"Total Indirect Annual Costs (TIAC) (refer to Table 5-10)",null,null,null,null,null,null,null," TIAC   =",{"$f":"'5-10 NP & Zehnder'!C13","v":582886.42405209178}]
[]
[null,"TOTAL ANNUALIZED COSTS (TAC)",null,null,null,null,null,null,null,"TAC = (TDAC) + (TIAC)  =",{"$f":"K17+K25","v":5401048.1463080924}]
[]
[null,"Cost Effectiveness Summary"]
[]
[null,"TOTAL TONS SO2 AVOIDED PER YEAR",null,null,null,null,null,null,null,"=",{"$f":"598.6*0.997","v":596.80420000000004}]
[]
[null,"COST EFFECTIVENESS ($ PER TON AVOIDED BASED ON PTE)",null,null,null,null,null,null,null,"(TAC)/(TPY)   = ",{"$f":"K27/K31","v":9049.9499606539157}]
[]
[]
[]
[]
[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"]

{"sheet":"5-10 NP & Zehnder","index":1,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[22,0,22,1],[23,0,23,1],[5,1,5,2],[5,3,5,4],[0,0,0,4],[1,0,1,4]]}
["Table 5-10. Capital Cost for New ULSD Storage Based on"]
["PTE Maximum Fuel Use and Historic Actual Use"]
[]
[]
[null,"North Pole \nEUs 1 and 2 Maximum Fuel Use","Zehnder \nEUs 1 and 2 Maximum Fuel Use","North Pole \nEUs 1 and 2 Actual Fuel Use","Zehnder \nEUs 1 and 2 Actual Fuel Use"]
["Capital Cost Estimate",30425000,null,21050000]
["Heat Input, MMBtu/day (combined for each set of combustion turbines)",32256,12864,32256,12864]
["Percentage of Heat Input",{"$f":"B7/(B7+C7)","v":0.71489361702127663},{"$f":"C7/(B7+C7)","v":0.28510638297872343},{"$f":"D7/(D7+E7)","v":0.71489361702127663},{"$f":"E7/(D7+E7)","v":0.28510638297872343}]
["Capital Cost (apportioned based on heat input ratio)",{"$f":"B8*$B$6","v":21750638.297872342},{"$f":"C8*$B$6","v":8674361.7021276597},{"$f":"D8*$D$6","v":15048510.638297873},{"$f":"E8*$D$6","v":6001489.3617021283}]
["Capital Cost (apportioned per combustion turbine)",{"$f":"B9/2","v":10875319.148936171},{"$f":"C9/2","v":4337180.8510638298},{"$f":"D9/2","v":7524255.3191489363},{"$f":"E9/2","v":3000744.6808510642}]
["Capital Recovery (per combustion turbine)",{"$f":"B10*B15","v":1026553.1928597387},{"$f":"C10*B15","v":409399.19000953861},{"$f":"D10*B15","v":710236.47361372225},{"$f":"E10*B15","v":283249.06983404403}]
["Administrative Charges, Property Taxes, Insurance (per combustion turbine)",{"$f":"C23*B10","v":435012.76595744683},{"$f":"C23*C10","v":173487.2340425532},{"$f":"C23*D10","v":300970.21276595746},{"$f":"C23*E10","v":120029.78723404257}]
["Total Annual Indirect Cost (per combustion turbine)",{"$f":"SUM(B11:B12)","v":1461565.9588171856},{"$f":"SUM(C11:C12)","v":582886.42405209178},{"$f":"SUM(D11:D12)","v":1011206.6863796797},{"$f":"SUM(E11:E12)","v":403278.85706808663}]
[]
["Capital recovery factor",{"$f":"($C$18/100*POWER((1+($C$18/100)),$C$20))/((POWER(((1+$C$18/100)),$C$20))-1)","v":9.4392925743255696E-2}]
[]
["Data Inputs for Capital Recovery Factor:"]
["Annual Interest Rate (EPA OAQPS Control",null,7,"pct."]
["    Cost Manual)"]
["Project Life (EPA OAQPS Control Cost",null,20,"years"]
["     Manual)"]
[]
["Administrative Charges, Property Taxes",null,0.04]
["     Insurance (percentage of total capital"]
["     cost)"]

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