{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Instructions","Glossary","Demand Curve Results","Model-->","Model","Multiple Scenario Output","Data Updated Annually-->","Escalation Factor","Winter-to-Summer Ratio","Net EAS","Fixed Inputs-->","Levelized Factor","Peak Load and IRM","AS Adders","Performance and O&M","Capital Costs"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":78,"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":"Instructions","index":0,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,3,1,4]]}
[null,"Project: ",null,"NYISO ICAP Demand Curve "]
[null,"Date: ",null,"2021-04-12"]
[null,"Worksheet:",null,"Instructions"]
[]
[null,"Instructions for Using NYISO ICAP Demand Curve Workbook"]
[]
[]
[null,"Steps:"]
[]
[null,1,"Collect index information from BLS and BEA websites and update Escalation Factor in \"Escalation Factor\" Worksheet"]
[null,2,"Update Net EAS Revenues in \"Net EAS\" Worksheet"]
[null,3,"Update Winter-Summer Ratio in \"Winter-Summer Ratio\" Worksheet "]
[null,4,"Save Previous DCR values in \"Demand Curve Results\" Worksheet"]
[null,5,"Update and run DCR model, using \"Multiple Scenario Output\" Worksheet"]

{"sheet":"Glossary","index":1,"n_rows":50,"n_cols":3,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,2,1,3]]}
[null,"Project: ","NYISO ICAP Demand Curve "]
[null,"Date: ","2021-04-12"]
[null,"Worksheet:","Glossary"]
[]
[null,"Glossary of Named Ranges"]
[]
[]
[null,"Named Range","Name"]
[null,"Annual_Reference_Value","Annual Reference Value ($/kW-Year)"]
[null,"ATWACC","After Tax Weighted Average Cost of Capital (%)"]
[null,"ATWACC_Real","After Tax Weighted Average Cost of Capital (Real, %)"]
[null,"Capability_Year","Capability Year"]
[null,"Capacity_at_LOE","Capacity at LOE Conditions (%)"]
[null,"Capital_Costs","Overnight Capital Costs ($/kW-Year)"]
[null,"CC_Flag","CC Plant Flag"]
[null,"Debt_Fraction","Debt Fraction (%)"]
[null,"Debt_Rate","Debt Rate (%)"]
[null,"Debt_Rate_Real","Debt Rate (Real, %)"]
[null,"DMNC_ICAP","DMNC ICAP (MW)"]
[null,"DMNC_Summer","DMNC Summer (MW)"]
[null,"DMNC_Winter","DMNC Winter (MW)"]
[null,"EAS","Net Energy and Ancillary Services ($/kW-Year)"]
[null,"EAS_Fuel_Type","EAS Fuel Type"]
[null,"Effective_Tax_Rate","Effective Tax Rate (%)"]
[null,"Equity_Rate","Equity Rate (%)"]
[null,"Equity_Rate_Real","Equity Rate (Real, %)"]
[null,"Escalation_Factor","Escalation Factor (%)"]
[null,"Escalation_Factor_Table","Table of all Escalation Factors for all units"]
[null,"FixedOM_Site_Lease","Fixed O&M + Site Lease (Includes Property Taxes and Insurance, $/kW-Year)"]
[null,"Fuel_Type","Fuel Type"]
[null,"Gross CONE","Gross CONE ($/kW-Year)"]
[null,"Inflation_Factor","Inflation Factor (%)"]
[null,"Insurance_Rate","Insurance Rate (%)"]
[null,"IRM","Installed Reserve Margin (or Locational Capacity Requirement, %)"]
[null,"Levelized_Charge","Levelized Fixed Charge (%)"]
[null,"Maximum_Price_Multiple","Maximum price (Multiple of Annualized Capital Cost)"]
[null,"Maximum_Price_Type","Specifies which Maximum Clearing Price calculation is used in the model (always \"NYISO Staff Recommendation\")"]
[null,"Multiple_Scenario_Lookup","Array of Values Used to Lookup Model Results from the Multiple Scenario Output"]
[null,"Multiple_Scenario_Output","Output from the Multiple Scenario Output"]
[null,"Multiple_Scenario_Vars","Variables Included in Multiple Scenario Output"]
[null,"Peak_Load","Peak Load (Average of Gold Book Peak Load Values for 2017 - 2021, MW)"]
[null,"Plant_Life","Plant Life (Years)"]
[null,"Property_Tax_Rate","Property Tax Rate (%)"]
[null,"PropTax_Abate","Property Tax Abatement Flag"]
[null,"Region","Region (Zone)"]
[null,"Total_EPC_Capital_Costs","Total EPC Costs ($/kW-Year)"]
[null,"Unit","Unit/Technology"]
[null,"VSS_Adder","Estimated Voltage Support Services revenues for all non-CC resources ($/kW-Year)"]
[null,"WSR","Winter-to-Summer Ratio"]
[null,"ZCP","Zero Crossing Point (Margin Over 100%)"]

{"sheet":"Demand Curve Results","index":2,"n_rows":103,"n_cols":17,"rows_kept":103,"cut":false,"hidden":false,"merged":[[10,4,10,8],[46,3,46,8],[75,3,75,8]]}
[null,null,null,"Project: ",null,"NYISO ICAP Demand Curve "]
[null,null,null,"Date: ",null,"2021-04-12"]
[null,null,null,"Worksheet:",null,"Demand Curve Results"]
[]
[null,null,null,"Instructions:",null,"Current ICAP Demand Curve Parameters are linked to \"Multiple Scenario Output\" Table."]
[null,null,null,null,null,"Before completing an annual update, copy values from \"Current Parameters\" section and paste values into \"Historical Values\" section to save results from previous years."]
[]
[null,null,null,"Current ICAP Demand Curve Parameters"]
[]
[]
[null,null,null,null,{"$f":"\"Current Year (\"&Capability_Year&\")\"","v":"Current Year (2021-2022)"}]
[null,null,null,null,null,"C - Central","G - Hudson Valley (Rockland)","J - New York City","K - Long Island"]
[null,null,null,null,"Source","C - Central","G - Hudson Valley (Rockland)","J - New York City","K - Long Island"]
["Gross CONE ($/kW-Year)",null,null,"Gross Cost of New Entry ($/kW-Year)","[1]",{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(F$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A14, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":107.0668},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(G$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A14, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":139.6283},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(H$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A14, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":188.53210000000001},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(I$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A14, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":148.96539999999999}]
["Net EAS ($/kW-Year)",null,null,"Net EAS Revenue ($/kW-Year)","[2]",{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(F$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A15, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":32.915999999999997},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(G$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A15, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":35.151299999999999},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(H$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A15, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":33.416699999999999},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(I$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A15, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":54.146099999999997}]
["Annual Reference Value ($/kW-Year)",null,null,"Annual ICAP Reference Value ($/kW-Year)","[3] = [1] - [2]",{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(F$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A16, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":74.150700000000001},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(G$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A16, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":104.477},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(H$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A16, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":155.11539999999999},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(I$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A16, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":94.819299999999998}]
[]
["DMNC ICAP (MW)",null,null,"ICAP DMNC (MW)","[4]",{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(F$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A18, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":326.7},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(G$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A18, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":347},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(H$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A18, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":348.8},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(I$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A18, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":348.8}]
[null,null,null,"Total Annual Reference Value","[5] = [3] * [4]",{"$f":"F16*1000*F18","v":24225033.689999998},{"$f":"G16*1000*G18","v":36253519},{"$f":"H16*1000*H18","v":54104251.520000003},33072971.840000004]
["Capacity at LOE Conditions",null,null,"Level of Excess (%)","[6]",{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(F$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A20, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":1.0085078249072446},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(G$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A20, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":1.0245655021061202},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(H$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A20, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":1.0350937843152919},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(I$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A20, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":1.0645362070694531}]
["Winter-Summer Ratio",null,null,"Ratio of Summer to Winter DMNCs","[7]",{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(F$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A21, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":1.038},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(G$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A21, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":1.0589999999999999},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(H$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A21, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":1.0760000000000001},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(I$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A21, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":1.073}]
["DMNC summer (MW)",null,null,"Summer DMNC (MW)","[8]",{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(F$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A22, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":329.3},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(G$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A22, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":348.2},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(H$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A22, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":348.5},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(I$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A22, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":351.1}]
["DMNC winter (MW)",null,null,"Winter DMNC (MW)","[9]",{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(F$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A23, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":344.7},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(G$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A23, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":369.9},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(H$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A23, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":374.1},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(I$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A23, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":373}]
[]
[null,null,null,"Assumed Capacity Prices at Tariff Prescribed Level of Excess Conditions"]
["Level of Excess Clearing Price (Summer)",null,null,"Summer ($/kW-Month)","[10]",{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(F$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A26, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":7.2549999999999999},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(G$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A26, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":11.104799999999999},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(H$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A26, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":17.130500000000001},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(I$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A26, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":11.289}]
["Level of Excess Clearing Price (Winter)",null,null,"Winter ($/kW-Month)","[11]",{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(F$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A27, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":4.7823000000000002},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(G$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A27, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":5.8815},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(H$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A27, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":8.1458999999999993},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(I$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A27, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":4.1516999999999999}]
[]
[null,null,null,"Monthly Revenue (Summer)","[12] = [10]*[8]",{"$f":"F26*F22*1000","v":2389071.5},{"$f":"G26*G22*1000","v":3866691.3599999994},{"$f":"H26*H22*1000","v":5969979.25},3963567.9]
[null,null,null,"Monthly Revenue (Winter)","[13] = [11]*[9]",{"$f":"F27*F23*1000","v":1648458.81},{"$f":"G27*G23*1000","v":2175566.8499999996},3047381.19,1548584.1]
[]
[null,null,null,"Seasonal Revenue (Summer)","[14] = 6 * [12]",{"$f":"F29*6","v":14334429},{"$f":"G29*6","v":23200148.159999996},{"$f":"H29*6","v":35819875.5},23781407.399999999]
[null,null,null,"Seasonal Revenue (Winter)","[15] = 6 * [13]",{"$f":"F30*6","v":9890752.8599999994},{"$f":"G30*6","v":13053401.099999998},18284287.140000001,9291504.6000000015]
[null,null,null,"Total Annual Reference Value","[16] = [14]+[15]",{"$f":"SUM(F32:F33)","v":24225181.859999999},{"$f":"SUM(G32:G33)","v":36253549.25999999},{"$f":"SUM(H32:H33)","v":54104162.640000001},33072912]
[]
[null,null,null,"ICAP Demand Curve Parameters"]
["Monthly Reference Point Price ($/kW-month)",null,null,"ICAP Monthly Reference Point Price ($/kW-Month)",null,{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(F$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A37, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":7.8086000000000002},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(G$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A37, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":13.2796},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(H$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A37, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":21.279199999999999},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(I$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A37, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":17.598800000000001}]
["Maximum Clearing Price ($/kW-month)",null,null,"ICAP Max Clearing Price ($/kW-Month)",null,{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(F$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A38, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":14.0101},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(G$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A38, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":18.9374},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(H$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A38, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":26.247499999999999},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(I$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A38, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":21.269400000000001}]
["Zero Crossing Point (margin over 100%)",null,null,"Demand Curve Length",null,{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(F$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A39, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":0.12},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(G$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A39, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":0.15},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(H$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A39, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":0.18},{"$f":"INDEX('Multiple Scenario Output'!$A$31:$AM$36, MATCH(I$12,'Multiple Scenario Output'!$C$31:$C$36, 0), MATCH($A39, 'Multiple Scenario Output'!$A$31:$AM$31, 0))","v":0.18}]
[]
[]
[]
[]
[null,null,null,"Save Historical Values Below"]
[]
[]
[null,null,null,"2021-2022",null,null,null,null,null,null,null,"2022-2023"]
[null,null,null,null,"Source","C - Central","G - Hudson Valley (Rockland)","J - New York City","K - Long Island",null,null,null,"Source","C - Central","G - Hudson Valley (Rockland)","J - New York City","K - Long Island"]
[null,null,null,"Gross Cost of New Entry ($/kW-Year)","[1]",null,null,null,null,null,null,"Gross Cost of New Entry ($/kW-Year)","[1]"]
[null,null,null,"Net EAS Revenue ($/kW-Year)","[2]",null,null,null,null,null,null,"Net EAS Revenue ($/kW-Year)","[2]"]
[null,null,null,"Annual ICAP Reference Value ($/kW-Year)","[3] = [1] - [2]",null,null,null,null,null,null,"Annual ICAP Reference Value ($/kW-Year)","[3] = [1] - [2]"]
[]
[null,null,null,"ICAP DMNC (MW)","[4]",null,null,null,null,null,null,"ICAP DMNC (MW)","[4]"]
[null,null,null,"Total Annual Reference Value","[5] = [3] * [4]",null,null,null,null,null,null,"Total Annual Reference Value","[5] = [3] * [4]"]
[null,null,null,"Level of Excess (%)","[6]",null,null,null,null,null,null,"Level of Excess (%)","[6]"]
[null,null,null,"Ratio of Summer to Winter DMNCs","[7]",null,null,null,null,null,null,"Ratio of Summer to Winter DMNCs","[7]"]
[null,null,null,"Summer DMNC (MW)","[8]",null,null,null,null,null,null,"Summer DMNC (MW)","[8]"]
[null,null,null,"Winter DMNC (MW)","[9]",null,null,null,null,null,null,"Winter DMNC (MW)","[9]"]
[]
[null,null,null,"Assumed Capacity Prices at Tariff Prescribed Level of Excess Conditions",null,null,null,null,null,null,null,"Assumed Capacity Prices at Tariff Prescribed Level of Excess Conditions"]
[null,null,null,"Summer ($/kW-Month)","[10]",null,null,null,null,null,null,"Summer ($/kW-Month)","[10]"]
[null,null,null,"Winter ($/kW-Month)","[11]",null,null,null,null,null,null,"Winter ($/kW-Month)","[11]"]
[]
[null,null,null,"Monthly Revenue (Summer)","[12] = [10]*[8]",null,null,null,null,null,null,"Monthly Revenue (Summer)","[12] = [10]*[8]"]
[null,null,null,"Monthly Revenue (Winter)","[13] = [11]*[9]",null,null,null,null,null,null,"Monthly Revenue (Winter)","[13] = [11]*[9]"]
[]
[null,null,null,"Seasonal Revenue (Summer)","[14] = 6 * [12]",null,null,null,null,null,null,"Seasonal Revenue (Summer)","[14] = 6 * [12]"]
[null,null,null,"Seasonal Revenue (Winter)","[15] = 6 * [13]",null,null,null,null,null,null,"Seasonal Revenue (Winter)","[15] = 6 * [13]"]
[null,null,null,"Total Annual Reference Value","[16] = [14]+[15]",null,null,null,null,null,null,"Total Annual Reference Value","[16] = [14]+[15]"]
[]
[null,null,null,"Demand Curve Parameters",null,null,null,null,null,null,null,"Demand Curve Parameters"]
[null,null,null,"ICAP Monthly Reference Point Price ($/kW-Month)",null,null,null,null,null,null,null,"ICAP Monthly Reference Point Price ($/kW-Month)"]
[null,null,null,"ICAP Max Clearing Price ($/kW-Month)",null,null,null,null,null,null,null,"ICAP Max Clearing Price ($/kW-Month)"]
[null,null,null,"Demand Curve Length",null,null,null,null,null,null,null,"Demand Curve Length"]
[]
[null,null,null,"2023-2024",null,null,null,null,null,null,null,"2024-2025"]
[null,null,null,null,"Source","C - Central","G - Hudson Valley (Rockland)","J - New York City","K - Long Island",null,null,null,"Source","C - Central","G - Hudson Valley (Rockland)","J - New York City","K - Long Island"]
[null,null,null,"Gross Cost of New Entry ($/kW-Year)","[1]",null,null,null,null,null,null,"Gross Cost of New Entry ($/kW-Year)","[1]"]
[null,null,null,"Net EAS Revenue ($/kW-Year)","[2]",null,null,null,null,null,null,"Net EAS Revenue ($/kW-Year)","[2]"]
[null,null,null,"Annual ICAP Reference Value ($/kW-Year)","[3] = [1] - [2]",null,null,null,null,null,null,"Annual ICAP Reference Value ($/kW-Year)","[3] = [1] - [2]"]
[]
[null,null,null,"ICAP DMNC (MW)","[4]",null,null,null,null,null,null,"ICAP DMNC (MW)","[4]"]
[null,null,null,"Total Annual Reference Value","[5] = [3] * [4]",null,null,null,null,null,null,"Total Annual Reference Value","[5] = [3] * [4]"]
[null,null,null,"Level of Excess (%)","[6]",null,null,null,null,null,null,"Level of Excess (%)","[6]"]
[null,null,null,"Ratio of Summer to Winter DMNCs","[7]",null,null,null,null,null,null,"Ratio of Summer to Winter DMNCs","[7]"]
[null,null,null,"Summer DMNC (MW)","[8]",null,null,null,null,null,null,"Summer DMNC (MW)","[8]"]
[null,null,null,"Winter DMNC (MW)","[9]",null,null,null,null,null,null,"Winter DMNC (MW)","[9]"]
[]
[null,null,null,"Assumed Capacity Prices at Tariff Prescribed Level of Excess Conditions",null,null,null,null,null,null,null,"Assumed Capacity Prices at Tariff Prescribed Level of Excess Conditions"]
[null,null,null,"Summer ($/kW-Month)","[10]",null,null,null,null,null,null,"Summer ($/kW-Month)","[10]"]
[null,null,null,"Winter ($/kW-Month)","[11]",null,null,null,null,null,null,"Winter ($/kW-Month)","[11]"]
[]
[null,null,null,"Monthly Revenue (Summer)","[12] = [10]*[8]",null,null,null,null,null,null,"Monthly Revenue (Summer)","[12] = [10]*[8]"]
[null,null,null,"Monthly Revenue (Winter)","[13] = [11]*[9]",null,null,null,null,null,null,"Monthly Revenue (Winter)","[13] = [11]*[9]"]
[]
[null,null,null,"Seasonal Revenue (Summer)","[14] = 6 * [12]",null,null,null,null,null,null,"Seasonal Revenue (Summer)","[14] = 6 * [12]"]
[null,null,null,"Seasonal Revenue (Winter)","[15] = 6 * [13]",null,null,null,null,null,null,"Seasonal Revenue (Winter)","[15] = 6 * [13]"]
[null,null,null,"Total Annual Reference Value","[16] = [14]+[15]",null,null,null,null,null,null,"Total Annual Reference Value","[16] = [14]+[15]"]
[]
[null,null,null,"Demand Curve Parameters",null,null,null,null,null,null,null,"Demand Curve Parameters"]
[null,null,null,"ICAP Monthly Reference Point Price ($/kW-Month)",null,null,null,null,null,null,null,"ICAP Monthly Reference Point Price ($/kW-Month)"]
[null,null,null,"ICAP Max Clearing Price ($/kW-Month)",null,null,null,null,null,null,null,"ICAP Max Clearing Price ($/kW-Month)"]
[null,null,null,"Demand Curve Length",null,null,null,null,null,null,null,"Demand Curve Length"]

{"sheet":"Model-->","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Model","index":4,"n_rows":94,"n_cols":32,"rows_kept":94,"cut":false,"hidden":false,"merged":[[2,1,2,2],[85,4,85,9],[1,1,1,2]]}
["Project: ","NYISO ICAP Demand Curve "]
["Date:","2021-04-12"]
["Worksheet:","Model"]
[]
["Instructions:","Values highlighted in yellow can be toggled to the values on their right, in grey, to view the reference point price for different zones, peaking plant technologies, and fuel assumptions. "]
[]
["Notes:","1. Technology, Service Life and AFUDC automatically update to match unit type. Tax rates automatically update to match region."]
[null,"2. Changing toggle selections on this page will not interfere with or edit the data on the \"Multiple Scenario Output\" tab. "]
[]
[]
[]
["NYISO ICAP Demand Curve Model"]
[]
["Inputs"]
[]
["Timing"]
["Capability Year","2021-2022","2021-2022","2022-2023","2023-2024","2024-2025"]
[]
["Plant"]
["Region","G - Hudson Valley (Rockland)","C - Central","G - Hudson Valley (Rockland)","J - New York City","K - Long Island"]
["Technology ",{"$f":"IF(Region=\"C - Central\",$D21,$C21)","v":"1x0 GE 7HA.02 25ppm"},"1x0 GE 7HA.02 25ppm","1x0 GE 7HA.02 15ppm"]
["Service Life (Years)",20]
["Maximum Price (Multiple of Monthly Gross CONE)",1.5]
["Fuel and SCR Specification",{"$f":"IF(Unit=\"1x0 GE 7HA.02 15ppm\",$D24,$C24)","v":"Dual fuel with SCR"},"Dual fuel with SCR","Gas only without SCR"]
["CC Plant",{"$f":"IF(Unit=\"8000J CC\", TRUE, FALSE)","v":false},true,false]
["Capital Costs without AFUDC($/kW)",{"$f":"IFERROR(INDEX('Capital Costs'!$C$14:$J$70, MATCH(\"Capital Costs without AFUDC\"&Capability_Year, 'Capital Costs'!$C$14:$C$70, 0), MATCH(Region&Unit&Fuel_Type, 'Capital Costs'!$C$14:$J$14, 0)), \"-\")","v":1055.7389604062014}]
["AFUDC (%)",6.8000000000000005E-2]
["Overnight Capital Costs including AFUDC($/kW)",{"$f":"B26*(1+B27)","v":1127.5292097138231}]
["Total EPC Capital Costs",{"$f":"IFERROR(INDEX('Capital Costs'!$C$14:$J$72, MATCH(\"Total EPC Costs\"&Capability_Year, 'Capital Costs'!$C$14:$C$72, 0), MATCH(Region&Unit&Fuel_Type, 'Capital Costs'!$C$14:$J$14, 0)), \"-\")","v":793.4697963024912}]
["Fixed O&M + Site Lease ($/kW-Year)",{"$f":"IFERROR(INDEX('Performance and O&M'!$C$12:$J$33, MATCH(\"FO&M Costs \"&Capability_Year, 'Performance and O&M'!$C$12:$C$33, 0), MATCH(Region&Unit, 'Performance and O&M'!$C$12:$J$12, 0)), \"-\")","v":9.2864211128731586}]
["DMNC Summer (MW)",{"$f":"IFERROR(INDEX('Performance and O&M'!$C$12:$J$26, MATCH($A31, 'Performance and O&M'!$C$12:$C$26, 0), MATCH(Region&Unit, 'Performance and O&M'!$C$12:$J$12, 0)), \"-\")","v":348.2}]
["DMNC Winter (MW)",{"$f":"IFERROR(INDEX('Performance and O&M'!$C$12:$J$26, MATCH($A32, 'Performance and O&M'!$C$12:$C$26, 0), MATCH(Region&Unit, 'Performance and O&M'!$C$12:$J$12, 0)), \"-\")","v":369.9}]
["DMNC ICAP (MW)",{"$f":"IFERROR(INDEX('Performance and O&M'!$C$12:$J$26, MATCH($A33, 'Performance and O&M'!$C$12:$C$26, 0), MATCH(Region&Unit, 'Performance and O&M'!$C$12:$J$12, 0)), \"-\")","v":347}]
["Winter-to-Summer Ratio",{"$f":"IFERROR(INDEX('Winter-to-Summer Ratio'!$D$11:$E$27, MATCH(Region&Capability_Year, 'Winter-to-Summer Ratio'!$D$11:$D$27, 0), MATCH(\"Winter-to-Summer Ratio\", 'Winter-to-Summer Ratio'!$D$11:$E$11, 0)), \"-\")","v":1.0589999999999999}]
["Escalation Factor (%)",{"$f":"IFERROR(INDEX(Escalation_Factor_Table,MATCH(Capability_Year,'Escalation Factor'!$C$36:$C$40,0),MATCH(Unit,'Escalation Factor'!$C$36:$E$36,0)),\"-\")","v":2.9516973216289384E-2}]
[]
["Finance"]
["Inflation Factor (%) ",2.1000000000000001E-2]
["Debt Fraction (%)",0.55000000000000004]
["Debt Rate (%)"]
["Nominal ",6.7000000000000004E-2]
["Real",{"$f":"(Debt_Rate-Inflation_Factor)/(1+Inflation_Factor)","v":4.5053868756121454E-2}]
["Equity Rate (%)"]
["Nominal",0.13]
["Real",{"$f":"(Equity_Rate-Inflation_Factor)/(1+Inflation_Factor)","v":0.10675808031341823}]
["Composite Tax Rate (%)",{"$f":"IF(Region=\"J - New York City\", D46, F46)","v":0.27500000000000002},"NYC:",0.36350000000000005,"Non-NYC:",0.27500000000000002]
["ATWACC Nominal (%)",{"$f":"(1-Debt_Fraction)*Equity_Rate+Debt_Fraction*Debt_Rate*(1-Effective_Tax_Rate)","v":8.5216249999999993E-2}]
["ATWACC Real (%)",{"$f":"(ATWACC-Inflation_Factor)/(1+Inflation_Factor)","v":6.2895445641527908E-2},"Discount rate"]
[]
["Fixed Property Tax Rate (%)",{"$f":"IF(Region=\"J - New York City\", D50, F50)","v":5.0000000000000001E-3},"NYC:",4.74165E-2,"Non-NYC:",5.0000000000000001E-3]
["Insurance Rate (%)",6.0000000000000001E-3]
[]
["Levelized Fixed Charge"]
["Property Tax Abatement (NYC)",{"$f":"IF(Region=\"J - New York City\",TRUE,FALSE)","v":false}]
[]
["Levelized Fixed Charge (%)",{"$f":"IFERROR('Levelized Factor'!C53, \"-\")","v":0.11137725407281394}]
["Levelized Fixed Charge ($/kW-Year)",{"$f":"IFERROR(Levelized_Charge*Capital_Costs, \"-\")","v":125.58110726481559}]
[]
["ICAP Demand Curve"]
["Zero Crossing Point (Margin Over 100%)",{"$f":"IF(Region=C60,D60, IF(Region=E60, F60, IF(Region=G60,H60, IF(Region=I60, J60, IF(Region=K60, N60, Q60)))))","v":0.15},"F - Capital",0.12,"C - Central",0.12,"J - New York City",0.18,"K - Long Island",0.18,"G - Hudson Valley (Rockland)",null,null,0.15,"G - Hudson Valley (Dutchess)",null,0.15]
["Capacity at LOE Conditions (%)",{"$f":"IFERROR(( (Peak_Load*IRM) + DMNC_ICAP ) / (Peak_Load*IRM), \"-\")","v":1.0245655021061202}]
["Peak Load (2020)",{"$f":" INDEX('Peak Load and IRM'!$B$8:$E$13, MATCH(IF(OR(LEFT(Region,1)=\"F\", LEFT(Region,1)=\"C\"), \"NYCA\", LEFT(Region,1)), 'Peak Load and IRM'!$B$8:$B$13, 0), MATCH(\"Peak Load (2020)\", 'Peak Load and IRM'!$B$8:$E$8, 0))","v":15695}]
["IRM/LCR",{"$f":" INDEX('Peak Load and IRM'!$B$8:$E$13, MATCH(IF(OR(LEFT(Region,1)=\"F\", LEFT(Region,1)=\"C\"), \"NYCA\", LEFT(Region,1)), 'Peak Load and IRM'!$B$8:$B$13, 0), MATCH(\"Installed Reserve Margin / \nLocational Capacity Requirement\", 'Peak Load and IRM'!$B$8:$E$8, 0))","v":0.9}]
["Net EAS ($/kW-Year)",{"$f":"Fuel_Type","v":"Dual fuel with SCR"}]
[{"$f":"\"Not escalated ($\"&VALUE(LEFT(Capability_Year,4))-2&\")\"","v":"Not escalated ($2019)"},{"$f":"IFERROR(IF(CC_Flag=TRUE,INDEX('Net EAS'!$J$13:$O$29, MATCH(Region&Unit&Capability_Year, 'Net EAS'!$J$13:$J$29, 0), MATCH($B$64, 'Net EAS'!$J$13:$O$13, 0))+CC_Adder,INDEX('Net EAS'!$J$13:$O$29, MATCH(Region&Unit&Capability_Year, 'Net EAS'!$J$13:$J$29, 0), MATCH($B$64, 'Net EAS'!$J$13:$O$13, 0))+VSS_Adder),\"-\")","v":34.347335519597969}]
[{"$f":"\"Escalated ($\"&VALUE(LEFT(Capability_Year,4))&\")\"","v":"Escalated ($2021)"},{"$f":"IFERROR(B65*(1+D66), \"-\")","v":35.151338009296666},"EAS Inflation rate:",{"$f":"IFERROR(H66/F66-1, \"-\")","v":2.3408001742666329E-2},{"$f":"\"GDP Deflator (\"&VALUE(LEFT(Capability_Year,4))-3&\")\"","v":"GDP Deflator (2018)"},{"$f":"INDEX('Escalation Factor'!$C$175:$S$189, MATCH(VALUE(LEFT(Capability_Year,4))-3, 'Escalation Factor'!$C$175:$C$189, 0), MATCH(\"II\", 'Escalation Factor'!$C$175:$S$175, 0))","v":110.176},{"$f":"\"GDP Deflator (\"&VALUE(LEFT(Capability_Year,4)-1)&\")\"","v":"GDP Deflator (2020)"},{"$f":"INDEX('Escalation Factor'!$C$175:$S$189, MATCH(VALUE(LEFT(Capability_Year,4))-1, 'Escalation Factor'!$C$175:$C$189, 0), MATCH(\"II\", 'Escalation Factor'!$C$175:$S$175, 0))","v":112.755}]
["Calculations and Output"]
[]
["Summary of Cash Flows ($/kW-Year)"]
[]
["Project Year","NPV",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[]
["Discount Rate Adjustment (%)","-",{"$f":"IF(C71<=Plant_Life, 1/(1+ATWACC_Real)^C71,0)","v":0.9408263099635672},0.88515414551966232,0.83277630847821837,0.78349786133064347,0.7371354017400561,0.69351637996260873,0.65247845665951232,0.6138688987096923,0.57754401077443862,0.54336860049847391,0.51121547535704692,0.48096496927644139,0.45250449726609487,0.42572813640477913,0.40053623162137458,0.37683502480305053,0.35453630585048335,0.33355708438142495,0.31381928086078226,0.29524943600767006,0,0,0,0,0,0,0,0,0,0]
[]
["Energy and Ancillary Services Revenue",{"$f":"SUMPRODUCT($C$73:$AF$73, C75:AF75)","v":393.87470800874786},{"$f":"IF(C71<=Plant_Life, EAS, 0)","v":35.151338009296666},{"$f":"IF(D71<=Plant_Life, EAS, 0)","v":35.151338009296666},35.151338009296666,35.151338009296666,35.151338009296666,35.151338009296666,35.151338009296666,35.151338009296666,35.151338009296666,35.151338009296666,35.151338009296666,35.151338009296666,35.151338009296666,35.151338009296666,35.151338009296666,35.151338009296666,35.151338009296666,35.151338009296666,35.151338009296666,35.151338009296666,0,0,0,0,0,0,0,0,0,0]
[]
["Fixed O&M (Excludes Property Tax and Insurance)",{"$f":"SUMPRODUCT($C$73:$AF$73, C77:AF77)","v":104.05539622166927},{"$f":"IF(C71<=Plant_Life, FixedOM_Site_Lease, 0)","v":9.2864211128731586},9.2864211128731586,9.2864211128731586,9.2864211128731586,9.2864211128731586,9.2864211128731586,9.2864211128731586,9.2864211128731586,9.2864211128731586,9.2864211128731586,9.2864211128731586,9.2864211128731586,9.2864211128731586,9.2864211128731586,9.2864211128731586,9.2864211128731586,9.2864211128731586,9.2864211128731586,9.2864211128731586,9.2864211128731586,0,0,0,0,0,0,0,0,0,0]
["Insurance",{"$f":"IFERROR(SUMPRODUCT($C$73:$AF$73, C78:AF78), \"-\")","v":53.345511499405546},{"$f":"IFERROR(IF(C71<=Plant_Life, Insurance_Rate*Total_EPC_Capital_Costs, 0), \"-\")","v":4.7608187778149471},4.7608187778149471,4.7608187778149471,4.7608187778149471,4.7608187778149471,4.7608187778149471,4.7608187778149471,4.7608187778149471,4.7608187778149471,4.7608187778149471,4.7608187778149471,4.7608187778149471,4.7608187778149471,4.7608187778149471,4.7608187778149471,4.7608187778149471,4.7608187778149471,4.7608187778149471,4.7608187778149471,4.7608187778149471,0,0,0,0,0,0,0,0,0,0]
["Levelized Fixed Charge",{"$f":"IFERROR(SUMPRODUCT($C$73:$AF$73, C79:AF79), \"-\")","v":1407.1504743933986},{"$f":"IFERROR(IF(C71<=Plant_Life, Capital_Costs*Levelized_Charge, 0), \"-\")","v":125.58110726481559},{"$f":"IFERROR(IF(D71<=Plant_Life, Capital_Costs*Levelized_Charge, 0), \"-\")","v":125.58110726481559},125.58110726481559,125.58110726481559,125.58110726481559,125.58110726481559,125.58110726481559,125.58110726481559,125.58110726481559,125.58110726481559,125.58110726481559,125.58110726481559,125.58110726481559,125.58110726481559,125.58110726481559,125.58110726481559,125.58110726481559,125.58110726481559,125.58110726481559,125.58110726481559,0,0,0,0,0,0,0,0,0,0]
["Total Costs",{"$f":"IFERROR(SUMPRODUCT($C$73:$AF$73, C80:AF80), \"-\")","v":1564.5513821144727},{"$f":"SUM(C77:C79)","v":139.62834715550369},{"$f":"SUM(D77:D79)","v":139.62834715550369},139.62834715550369,139.62834715550369,139.62834715550369,139.62834715550369,139.62834715550369,139.62834715550369,139.62834715550369,139.62834715550369,139.62834715550369,139.62834715550369,139.62834715550369,139.62834715550369,139.62834715550369,139.62834715550369,139.62834715550369,139.62834715550369,139.62834715550369,139.62834715550369,0,0,0,0,0,0,0,0,0,0]
[]
["Annual Reference Value",{"$f":"IFERROR(SUMPRODUCT($C$73:$AF$73, C82:AF82), \"-\")","v":1170.6766741057249},{"$f":"IFERROR(C80-C75, \"-\")","v":104.47700914620702},{"$f":"IFERROR(D80-D75, \"-\")","v":104.47700914620702},104.47700914620702,104.47700914620702,104.47700914620702,104.47700914620702,104.47700914620702,104.47700914620702,104.47700914620702,104.47700914620702,104.47700914620702,104.47700914620702,104.47700914620702,104.47700914620702,104.47700914620702,104.47700914620702,104.47700914620702,104.47700914620702,104.47700914620702,104.47700914620702,0,0,0,0,0,0,0,0,0,0]
[]
["Annual Reference Value ($/kW - Year)",{"$f":"-PMT(ATWACC_Real,Plant_Life,B82)","v":104.47700914620708}]
["Reference Point Price"]
["Monthly Reference Point Price ($/kW-Month)",{"$f":"IFERROR((B84*DMNC_ICAP)/(6*(\nDMNC_Summer*(1 - (Capacity_at_LOE-1)/ZCP)\n+\nDMNC_Winter*(1 -  ((WSR-1+Capacity_at_LOE-1) / ZCP )\n))), \"-\")","v":13.279598105465798}]
[]
["Other Outputs"]
["Gross CONE ($/kW-Year) ",{"$f":"IFERROR(B66+B84, \"-\")","v":139.62834715550375}]
["ICAP Demand Curve Slope",{"$f":"IFERROR((B86-0)/(1-ZCP-1), \"-\")","v":-88.530654036438634}]
["Level of Excess Clearing Price (Summer, $/kW-Year)",{"$f":"IFERROR(B90*(Capacity_at_LOE-1)+B86, \"-\")","v":11.104798137277466}]
["Level of Excess Clearing Price (Winter, $/kW-Year)",{"$f":"IFERROR(B86*(1-(Capacity_at_LOE-1+WSR-1)/ZCP), \"-\")","v":5.8814895491275907}]
["Maximum Clearing Price Specification","NYISO Staff Recommendation"]
["Maximum Clearing Price ($/kW-Month)",{"$f":"Maximum_Price_Multiple*WSR*Capacity_at_LOE*(Gross_CONE/12)","v":18.937354060089035}]

{"sheet":"Multiple Scenario Output","index":5,"n_rows":36,"n_cols":39,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
["Project: ","NYISO ICAP Demand Curve "]
["Date: ","2021-04-12"]
["Worksheet:","Multiple Scenario Output"]
[]
["Instructions:","After updating the escalation factor, winter-summer ratios, and net EAS and after saving the previous year's demand curve results, update this sheet by completing the following steps:"]
[null,"In rows 33 - 36, update \"Capability Year\" to the current year (e.g. 2021-2022). "]
[null,"Click the \"Perform Runs\" button. "]
[null,"The values in the blue and purple sections should update here and flow through to the \"Demand Curve Results\" tab automatically. "]
[]
[]
[]
[]
[]
[]
[]
["Inputs (Current Parameters from \"Model\")"]
[]
[]
[{"$f":"COLUMN()","v":1},{"$f":"COLUMN()","v":2},{"$f":"COLUMN()","v":3},{"$f":"COLUMN()","v":4},{"$f":"COLUMN()","v":5},{"$f":"COLUMN()","v":6},{"$f":"COLUMN()","v":7},{"$f":"COLUMN()","v":8},{"$f":"COLUMN()","v":9},{"$f":"COLUMN()","v":10},{"$f":"COLUMN()","v":11},{"$f":"COLUMN()","v":12},null,{"$f":"COLUMN()","v":14},{"$f":"COLUMN()","v":15},{"$f":"COLUMN()","v":16},{"$f":"COLUMN()","v":17},{"$f":"COLUMN()","v":18},{"$f":"COLUMN()","v":19},{"$f":"COLUMN()","v":20},{"$f":"COLUMN()","v":21},{"$f":"COLUMN()","v":22},{"$f":"COLUMN()","v":23},{"$f":"COLUMN()","v":24},{"$f":"COLUMN()","v":25},{"$f":"COLUMN()","v":26},{"$f":"COLUMN()","v":27},{"$f":"COLUMN()","v":28},{"$f":"COLUMN()","v":29},{"$f":"COLUMN()","v":30},{"$f":"COLUMN()","v":31},{"$f":"COLUMN()","v":32},{"$f":"COLUMN()","v":33},null,{"$f":"COLUMN()","v":35},{"$f":"COLUMN()","v":36},{"$f":"COLUMN()","v":37},{"$f":"COLUMN()","v":38},{"$f":"COLUMN()","v":39}]
[null,"Adjustable Inputs",null,null,null,null,null,null,null,null,null,null,null,null,"Linked Inputs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Results"]
["Value:","Capability Year","Region","Unit","Equity Rate (Nominal)","Debt Rate (Nominal)","Debt Fraction","Service life (Years)","NYC Property Tax Abatement?","Insurance Rate","AFUDC Percent","Fuel Type","Maximum Price Specification",null,"Overnight Capital Costs ($/kW)","DMNC Summer (MW)","DMNC Winter (MW)","DMNC ICAP (MW)","Winter-Summer Ratio","Escalation Factor (%)","ATWACC (Real, %)","Levelized Fixed Charge (%)","Levelized Fixed Charge ($/kW-Year)","Net EAS ($/kW-Year)","Zero Crossing Point (Margin Over 100%)","Fixed Property Tax Rate (%)","Fixed O&M + Site Lease ($/kW-Year)","Peak Load","IRM","Capacity at LOE Conditions","CC Plant","Gross CONE ($/kW-Year)","Insurance ($/kW-Year)",null,"Annual Reference Value ($/kW-Year)","Monthly Reference Point Price ($/kW-Month)","Maximum Clearing Price ($/kW-Month)","Level of Excess Clearing Price (Summer)","Level of Excess Clearing Price (Winter)"]
["Named Range:","Capability_Year","Region","Unit","Equity_Rate","Debt_Rate","Debt_Fraction","Plant_life","PropTax_Abate","Insurance_Rate","AFUDC_Pct","Fuel_Type","Maximum_Price_Type",null,"Capital_Costs","DMNC_Summer","DMNC_Winter","DMNC_ICAP","WSR","Escalation_Factor","ATWACC_Real","Levelized_Charge",null,"EAS","ZCP","Property_Tax_Rate","FixedOM_Site_Lease","Peak_Load","IRM","Capacity_at_LOE","CC_Plant"]
[]
["Value:",{"$f":"Capability_Year","v":"2021-2022"},{"$f":"Region","v":"G - Hudson Valley (Rockland)"},{"$f":"Unit","v":"1x0 GE 7HA.02 25ppm"},{"$f":"Equity_Rate","v":0.13},{"$f":"Debt_Rate","v":6.7000000000000004E-2},{"$f":"Debt_Fraction","v":0.55000000000000004},{"$f":"Plant_Life","v":20},{"$f":"PropTax_Abate","v":false},{"$f":"Insurance_Rate","v":6.0000000000000001E-3},{"$f":"AFUDC_Pct","v":6.8000000000000005E-2},{"$f":"Fuel_Type","v":"Dual fuel with SCR"},{"$f":"Maximum_Price_Type","v":"NYISO Staff Recommendation"},null,{"$f":"Capital_Costs","v":1127.5292097138231},{"$f":"DMNC_Summer","v":348.2},{"$f":"DMNC_Winter","v":369.9},{"$f":"DMNC_ICAP","v":347},{"$f":"WSR","v":1.0589999999999999},{"$f":"Escalation_Factor","v":2.9516973216289384E-2},{"$f":"ATWACC_Real","v":6.2895445641527908E-2},{"$f":"Levelized_Charge","v":0.11137725407281394},{"$f":"Model!B57","v":125.58110726481559},{"$f":"EAS","v":35.151338009296666},{"$f":"ZCP","v":0.15},{"$f":"Property_Tax_Rate","v":5.0000000000000001E-3},{"$f":"FixedOM_Site_Lease","v":9.2864211128731586},{"$f":"Peak_Load","v":15695},{"$f":"IRM","v":0.9},{"$f":"Capacity_at_LOE","v":1.0245655021061202},{"$f":"CC_Flag","v":false},{"$f":"Gross_CONE","v":139.62834715550375},{"$f":"Model!C78","v":4.7608187778149471},null,{"$f":"Annual_Reference_Value","v":104.47700914620708},{"$f":"Model!B86","v":13.279598105465798},{"$f":"Model!B94","v":18.937354060089035},{"$f":"Model!B91","v":11.104798137277466},{"$f":"Model!B92","v":5.8814895491275907}]
[]
[]
[]
["Output from Multiple Scenarios"]
[]
[]
["Scenario","Capability Year","Region","Unit","Equity Rate (Nominal)","Debt Rate (Nominal)","Debt Fraction","Service life (Years)","Property Tax Abatement?","Insurance Rate","AFUDC Percent","Fuel Type","Maximum Price Specification",null,"Overnight Capital Costs ($/kW)","DMNC Summer (MW)","DMNC Winter (MW)","DMNC ICAP (MW)","Winter-Summer Ratio","Escalation Factor (%)","ATWACC (Real, %)","Levelized Fixed Charge (%)","Levelized Fixed Charge ($/kW-Year)","Net EAS ($/kW-Year)","Zero Crossing Point (Margin Over 100%)","Fixed Property Tax Rate (%)","Fixed O&M + Site Lease ($/kW-Year)","Peak Load","IRM","Capacity at LOE Conditions","CC Plant","Gross CONE ($/kW-Year)","Insurance ($/kW-Year)",null,"Annual Reference Value ($/kW-Year)","Monthly Reference Point Price ($/kW-Month)","Maximum Clearing Price ($/kW-Month)","Level of Excess Clearing Price (Summer)","Level of Excess Clearing Price (Winter)"]
["Demand Curve"]
[{"$f":"C33&\" \"&D33&\" \"&E33&F33&G33&H33&L33&K33","v":"J - New York City 1x0 GE 7HA.02 25ppm 0.130.0670.5520Dual fuel with SCR0.068"},"2021-2022","J - New York City","1x0 GE 7HA.02 25ppm",0.13,6.7000000000000004E-2,0.55000000000000004,20,true,6.0000000000000001E-3,6.8000000000000005E-2,"Dual fuel with SCR","NYISO Staff Recommendation",null,1387.2579000000001,348.5,374.1,348.8,1.0760000000000001,2.9516973216289384E-2,5.9701297747306564E-2,0.11833906052749407,164.16679999999999,33.416699999999999,0.18,4.74165E-2,19.008299999999998,11477,0.86599999999999999,1.0350937843152919,false,188.53210000000001,5.3570000000000002,null,155.11539999999999,21.279199999999999,26.247499999999999,17.130500000000001,8.1458999999999993]
["K - Long Island 1x0 GE 7HA.02 25ppm 0.130.0670.5520Dual fuel with SCR0.068","2021-2022","K - Long Island","1x0 GE 7HA.02 25ppm",0.13,6.7000000000000004E-2,0.55000000000000004,20,false,6.0000000000000001E-3,6.8000000000000005E-2,"Dual fuel with SCR","NYISO Staff Recommendation",null,1200.0364,351.1,373,348.8,1.073,2.9516973216289384E-2,6.2895445641527908E-2,0.11137725407281401,133.6568,54.146099999999997,0.18,5.0000000000000001E-3,10.0059,5227,1.034,1.0645362070694531,false,148.96539999999999,5.3028000000000004,null,94.819299999999998,17.598800000000001,21.269400000000001,11.289,4.1516999999999999]
[{"$f":"C35&\" \"&D35&\" \"&E35&F35&G35&H35&L35&K35","v":"C - Central 1x0 GE 7HA.02 15ppm 0.130.0670.5520Gas only without SCR0.068"},"2021-2022","C - Central","1x0 GE 7HA.02 15ppm",0.13,6.7000000000000004E-2,0.55000000000000004,20,false,6.0000000000000001E-3,6.8000000000000005E-2,"Gas only without SCR","NYISO Staff Recommendation",null,853.2627,329.3,344.7,326.7,1.038,3.0595234145600367E-2,6.2895445641527908E-2,0.11137725407281397,95.034099999999995,32.915999999999997,0.12,5.0000000000000001E-3,8.6120000000000001,32296,1.1890000000000001,1.0085078249072446,false,107.0668,3.4207000000000001,null,74.150700000000001,7.8086000000000002,14.0101,7.2549999999999999,4.7823000000000002]
["G - Hudson Valley (Rockland) 1x0 GE 7HA.02 25ppm 0.130.0670.5520Dual fuel with SCR0.068","2021-2022","G - Hudson Valley (Rockland)","1x0 GE 7HA.02 25ppm",0.13,6.7000000000000004E-2,0.55000000000000004,20,false,6.0000000000000001E-3,6.8000000000000005E-2,"Dual fuel with SCR","NYISO Staff Recommendation",null,1127.5291999999999,348.2,369.9,347,1.0589999999999999,2.9516973216289384E-2,6.2895445641527908E-2,0.11137725407281394,125.58110000000001,35.151299999999999,0.15,5.0000000000000001E-3,9.2864000000000004,15695,0.9,1.0245655021061202,false,139.6283,4.7607999999999997,null,104.477,13.2796,18.9374,11.104799999999999,5.8815]

{"sheet":"Data Updated Annually-->","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Escalation Factor","index":7,"n_rows":189,"n_cols":21,"rows_kept":189,"cut":false,"hidden":false,"merged":[[140,3,140,7],[103,3,103,5],[104,3,104,7],[105,3,105,7],[106,3,106,7],[107,3,107,7],[108,3,108,7],[109,3,109,7],[110,3,110,7],[137,3,137,7],[138,3,138,7],[139,3,139,7],[79,3,79,7],[1,3,1,4],[75,3,75,4],[76,3,76,7],[77,3,77,7],[78,3,78,7],[23,2,24,3]]}
[null,null,"Project: ","NYISO ICAP Demand Curve "]
[null,null,"Date: ","2021-04-12"]
[null,null,"Worksheet:","Escalation Factor"]
[]
[null,null,"Instructions:","To update the escalation factor for each annual update, access updated data through the source links provided."]
[null,null,null,"If the source is the BLS, ensure that the Series ID provided on this worksheet matches the Series ID of the source of the index."]
[null,null,null,"If the source is the BEA (for the GDP Deflator), ensure that the table and line number match the information provided in this worksheet."]
[null,null,null,"Enter all currently available data from the index in the yellow cells."]
[]
[]
[null,null,"Calculation of Escalation Factor"]
[]
[]
[null,null,"Escalation Factor for Currently Selected Zone, Technology, and Capability Year"]
[null,null,"Zone:",{"$f":"Region","v":"G - Hudson Valley (Rockland)"}]
[null,null,"Technology:",{"$f":"Unit","v":"1x0 GE 7HA.02 25ppm"}]
[null,null,"Capability Year:",{"$f":"Capability_Year","v":"2021-2022"},null,null,null,null,"Linked to model. Values will update based on selected capability year."]
["Base year:",null,null,null,"Construction Labor Cost","Materials Cost","Gas and Steam Turbine Cost","GDP Deflator"]
[{"$f":"IF(Capability_Year=\"2021-2022\",2018,2020)","v":2018},null,"Base Year","[A]",{"$f":"INDEX($C$115:$S$130, MATCH(A19-1, $C$115:$C$130, 0), MATCH(\"Construction Labor Cost\", $C$115:$S$115, 0))","v":101108},{"$f":"INDEX($C$84:$S$98, MATCH(A19, $C$84:$C$98, 0), MATCH(\"Materials Index\", $C$84:$S$84, 0))","v":249.83333333333334},{"$f":"INDEX($C$145:$S$159, MATCH($A$19, $C$145:$C$159, 0), MATCH(\"Turbine Index\", $C$145:$S$145, 0))","v":228.03333333333333},{"$f":"INDEX($C$175:$S$189, MATCH(A19, $C$175:$C$189, 0), MATCH(\"GDP Deflator\", $C$175:$S$175, 0))","v":111.42400000000001}]
["Lookup year:",null,"Escalation Year","[B]",{"$f":"INDEX($C$115:$S$130, MATCH(A21-1, $C$115:$C$130, 0), MATCH(\"Construction Labor Cost\", $C$115:$S$115, 0))","v":107893},{"$f":"INDEX($C$84:$S$98, MATCH(A21, $C$84:$C$98, 0), MATCH(\"Materials Index\", $C$84:$S$84, 0))","v":253.4},{"$f":"INDEX($C$145:$S$159, MATCH($A$21, $C$145:$C$159, 0), MATCH(\"Turbine Index\", $C$145:$S$145, 0))","v":238.76666666666665},{"$f":"INDEX($C$175:$S$189, MATCH(A21, $C$175:$C$189, 0), MATCH(\"GDP Deflator\", $C$175:$S$175, 0))","v":112.755}]
[{"$f":"VALUE(LEFT(Capability_Year,4))-1","v":2020},null,"Growth Rate","[B]/[A]-1",{"$f":"IF(Capability_Year=\"2021-2022\",((E20/E19)^(5/8))-1,(E20/E19)-1)","v":4.1429422575824493E-2},{"$f":"F20/F19-1","v":1.4276184122748559E-2},4.706914193831313E-2,1.194536186099926E-2,"Note: In the 2021-2022 capability year the Construction Labor Cost growth rate is calculated as ([B]/[A]^5/8)-1 to account for 5 quarters of growth."]
[null,null,"Weights (By Technology)",null,{"$f":"INDEX($C$62:$G$65, MATCH(Unit, $C$62:$C$65, 0), MATCH(E$18, $C$62:$G$62, 0))","v":0.27256453923209478},{"$f":"INDEX($C$62:$G$65, MATCH(Unit, $C$62:$C$65, 0), MATCH(F$18, $C$62:$G$62, 0))","v":0.23130801547987129},{"$f":"INDEX($C$62:$G$65, MATCH(Unit, $C$62:$C$65, 0), MATCH(G$18, $C$62:$G$62, 0))","v":0.25612744528803388},{"$f":"INDEX($C$62:$G$65, MATCH(Unit, $C$62:$C$65, 0), MATCH(H$18, $C$62:$G$62, 0))","v":0.2400000000000001}]
[]
[null,null,"Escalation Factor:",null,{"$f":"TEXT(E22,\"0%\")&\"*\"&TEXT(E21,\"0.00%\")&\" + \"&TEXT(F22,\"0%\")& \"*\"&TEXT(F21,\"0.00%\")&\" + \"&TEXT(G22,\"0%\")&\"*\"&TEXT(G21,\"0.00%\")&\" + \"&TEXT(H22,\"0%\")&\"*\"&TEXT(H21,\"0.00%\")&\" =\"","v":"27%*4.14% + 23%*1.43% + 26%*4.71% + 24%*1.19% ="}]
[null,null,null,null,{"$f":"IFERROR(E21*E22+F21*F22+G21*G22+H21*H22, \"-\")","v":2.9516973216289384E-2}]
[]
[{"$f":"A21-1","v":2019},null,{"$f":"\"Previous Year\n(Q2 \"&A27&\")\"","v":"Previous Year\n(Q2 2019)"},{"$f":"INDEX($C$175:$E$189, MATCH(A27, $C$175:$C$189, 0), MATCH(\"II\", $C$175:$E$175, 0))","v":112.14100000000001}]
[null,null,{"$f":"\"Current Year\n(Q2 \"&A21&\")\"","v":"Current Year\n(Q2 2020)"},{"$f":"INDEX($C$175:$E$189, MATCH(A21, $C$175:$C$189, 0), MATCH(\"II\", $C$175:$E$175, 0))","v":112.755}]
[null,null,"Annual GDP Deflator Growth Rate",{"$f":"(D28/D27)-1","v":5.4752499085970463E-3},"Note: Annual GDP Deflator Growth Rate provides the growth of the GDP Deflator from the 2nd quarter of the previous year to the current year of data available at the time References Prices are released for each capability year."]
[]
[]
[]
[null,null,"Escalation Factors by Year and Technology"]
[]
[]
[null,null,"Capability Year","1x0 GE 7HA.02 25ppm","1x0 GE 7HA.02 15ppm"]
[null,null,"2021-2022",{"$f":"IFERROR((($D51/$D$49)^(5/8)-1)*$D$64+($E51/$E$49-1)*$E$64+($F51/$F$49-1)*$F$64+(($G51/$G$49)-1)*$G$64, \"-\")","v":2.9516973216289384E-2},{"$f":"IFERROR((($D51/$D$49)^(5/8)-1)*$D$65+($E51/$E$49-1)*$E$65+($F51/$F$49-1)*$F$65+(($G51/$G$49)-1)*$G$65, \"-\")","v":3.0595234145600367E-2},"Note: The model uses the five most recently released quarters of index data to calculate growth for the 2021-2022 capability year escalation factors."]
[null,null,"2022-2023",{"$f":"IFERROR(($D52/$D$51-1)*$D$64+($E52/$E$51-1)*$E$64+($F52/$F$51-1)*$F$64+(($G52/$G$51)-1)*$G$64, \"-\")","v":"-"},{"$f":"IFERROR(($D52/$D$51-1)*$D$65+($E52/$E$51-1)*$E$65+($F52/$F$51-1)*$F$65+(($G52/$G$51)-1)*$G$65, \"-\")","v":"-"}]
[null,null,"2023-2024",{"$f":"IFERROR(($D53/$D$51-1)*$D$64+($E53/$E$51-1)*$E$64+($F53/$F$51-1)*$F$64+(($G53/$G$51)-1)*$G$64, \"-\")","v":"-"},{"$f":"IFERROR(($D53/$D$51-1)*$D$65+($E53/$E$51-1)*$E$65+($F53/$F$51-1)*$F$65+(($G53/$G$51)-1)*$G$65, \"-\")","v":"-"}]
[null,null,"2024-2025",{"$f":"IFERROR(($D54/$D$51-1)*$D$64+($E54/$E$51-1)*$E$64+($F54/$F$51-1)*$F$64+(($G54/$G$51)-1)*$G$64, \"-\")","v":"-"},{"$f":"IFERROR(($D54/$D$51-1)*$D$65+($E54/$E$51-1)*$E$65+($F54/$F$51-1)*$F$65+(($G54/$G$51)-1)*$G$65, \"-\")","v":"-"}]
[null,null,"Note: Years with missing data or missing escalation factors will automatically update when indices below are updated with new data."]
[]
[]
[]
[null,null,"Indices Over Time"]
[]
[]
["Lookup",null,"Capability Year","Construction Labor Cost","Materials Cost","Gas and Steam Turbine Cost","GDP Deflator"]
[2018,null,"2019-2020",{"$f":"INDEX($C$115:$S$130, MATCH(A49-1, $C$115:$C$130, 0), MATCH(\"Construction Labor Cost\", $C$115:$S$115, 0))","v":101108},{"$f":"INDEX($C$84:$S$98, MATCH(A49, $C$84:$C$98, 0), MATCH(\"Materials Index\", $C$84:$S$84, 0))","v":249.83333333333334},{"$f":"INDEX($C$145:$S$161, MATCH(A49, $C$145:$C$161, 0), MATCH(\"Turbine Index\", $C$145:$S$145, 0))","v":228.03333333333333},{"$f":"INDEX($C$175:$S$190, MATCH(A49, $C$175:$C$190, 0), MATCH(\"GDP Deflator\", $C$175:$S$175, 0))","v":111.42400000000001},"Note: The model uses index values from midway through the 2019-2020 capability year because the 2021-2022 capability year escalates costs for five quarters."]
[{"$f":"+A49+1","v":2019},null,"2020-2021",105039,251.53333333333333,{"$f":"INDEX($C$145:$S$161, MATCH(A50, $C$145:$C$161, 0), MATCH(\"Turbine Index\", $C$145:$S$145, 0))","v":231.23333333333335},{"$f":"INDEX($C$175:$S$190, MATCH(A50, $C$175:$C$190, 0), MATCH(\"GDP Deflator\", $C$175:$S$175, 0))","v":112.14100000000001}]
[2020,null,"2021-2022",107893,253.4,{"$f":"INDEX($C$145:$S$161, MATCH(A51, $C$145:$C$161, 0), MATCH(\"Turbine Index\", $C$145:$S$145, 0))","v":238.76666666666665},{"$f":"INDEX($C$175:$S$190, MATCH(A51, $C$175:$C$190, 0), MATCH(\"GDP Deflator\", $C$175:$S$175, 0))","v":112.755}]
[2021,null,"2022-2023","-","-",{"$f":"INDEX($C$145:$S$161, MATCH(A52, $C$145:$C$161, 0), MATCH(\"Turbine Index\", $C$145:$S$145, 0))","v":"-"},{"$f":"INDEX($C$175:$S$190, MATCH(A52, $C$175:$C$190, 0), MATCH(\"GDP Deflator\", $C$175:$S$175, 0))","v":"-"}]
[2022,null,"2023-2024","-","-",{"$f":"INDEX($C$145:$S$159, MATCH(A53, $C$145:$C$159, 0), MATCH(\"Turbine Index\", $C$145:$S$145, 0))","v":"-"},{"$f":"INDEX($C$175:$S$189, MATCH(A53, $C$175:$C$189, 0), MATCH(\"GDP Deflator\", $C$175:$S$175, 0))","v":"-"}]
[2023,null,"2024-2025","-","-",{"$f":"INDEX($C$145:$S$159, MATCH(A54, $C$145:$C$159, 0), MATCH(\"Turbine Index\", $C$145:$S$145, 0))","v":"-"},{"$f":"INDEX($C$175:$S$189, MATCH(A54, $C$175:$C$189, 0), MATCH(\"GDP Deflator\", $C$175:$S$175, 0))","v":"-"}]
[null,null,"Note: Years with missing data or missing escalation factors will automatically update when indices below are updated with new data."]
[]
[]
[]
[null,null,"Weights by Technology"]
[]
[]
[null,null,"Technology","Construction Labor Cost","Materials Cost","Gas and Steam Turbine Cost","GDP Deflator"]
[]
[null,null,"1x0 GE 7HA.02 25ppm",0.27256453923209478,0.23130801547987129,0.25612744528803388,0.2400000000000001]
[null,null,"1x0 GE 7HA.02 15ppm",0.23531176558827943,0.19410970548527423,0.32056602830141506,0.25001250062503133]
[null,null,"Updated 6/19/2020"]
[]
[]
[null,null,"Index Inputs"]
[]
[]
[null,null,"Materials Cost Index"]
[]
[null,null,"Source: ","BLS Producer Price Index - Commodities"]
[null,null,"Seasonal: ","Not Seasonally Adjusted"]
[null,null,"Series Id:","WPUID612"]
[null,null,"Group:","(ID6) Intermediate demand by commodity type"]
[null,null,"Item:","(12) Materials and components for construction"]
[null,null,"Base Date:","198200"]
[null,null,"Years:","2007 to 2020"]
[null,null,"Access:","http://data.bls.gov/cgi-bin/dsrv?wp"]
[null,null,"Date Updated:","2020-09-02"]
[]
[null,null,"Year","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec",null,null,null,"Materials Index",null,"Note: Italicized values are preliminary and are subject to revision up to four months after original publication."]
[null,null,2010,202.3,203.5,204.6,206.1,207.4,206.6,206.3,206.2,205.9,205.9,206.3,207,null,null,null,{"$f":"IFERROR(AVERAGE(E85:G85), \"-\")","v":204.73333333333335}]
[null,null,2011,208.3,209.5,210.9,212.1,212.8,213.7,214.7,214.6,214.5,214.4,214.2,214.2,null,null,null,210.83333333333334]
[null,null,2012,215.3,216.9,217.4,218.3,219.1,219.2,218.5,218.7,219.2,219.1,219.5,219.9,null,null,null,217.53333333333333]
[null,null,2013,221.2,222.2,222.7,223.4,222.9,222.6,222.4,223,222.9,222.9,223,223.1,null,null,null,222.76666666666665]
[null,null,2014,224.8,225.8,226.6,226.9,227.4,227.4,227.7,228.2,228.5,228.6,228.5,228.4,null,null,null,226.43333333333331]
[null,null,2015,229,229.1,229.1,229.4,229.1,229,228.8,228,227.5,227.7,227.6,227.2,null,null,null,229.20000000000002]
[null,null,2016,227.5,227.5,227.8,228.3,228.7,229.1,229.7,230.3,230,229.7,229.7,230.1,null,null,null,227.86666666666667]
[null,null,2017,231.5,232.5,233.2,234.4,234.6,234.8,234.7,235.6,236,237,237.5,237.7,null,null,null,{"$f":"IFERROR(AVERAGE(E92:G92), \"-\")","v":233.36666666666667}]
[null,null,2018,239.7,241.2,244.3,245.4,248.1,249,249.4,249.2,249.6,249.6,249.1,249.7,null,null,null,{"$f":"IFERROR(AVERAGE(N93:O93,D94), \"-\")","v":249.83333333333334},"Note: The 2018 materials index is calculated with values from Nov. 2018-Jan. 2019 because the 2021-2022 capability year escalates costs for five quarters."]
[null,null,2019,250.7,251.5,251.2,251.9,251.7,251.2,252.3,251.3,251.1,250.8,250.8,250.8,null,null,null,251.53333333333333]
[null,null,2020,252.1,252.8,254.3,253.1,253,253.9,255.1,null,null,null,null,null,null,null,null,253.4]
[null,null,2021,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,2022,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(E97:G97), \"-\")","v":"-"}]
[null,null,2023,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[]
[]
[null,null,"Construction Labor Cost Index"]
[]
[null,null,"Source: ","BLS Quarterly Census of Employment and Wages"]
[null,null,"Series Id:","ENU360005052371"]
[null,null,"State:","New York"]
[null,null,"Area:","New York -- Statewide"]
[null,null,"Industry:","NAICS 2371 Utility system construction"]
[null,null,"Owner:","Private"]
[null,null,"Size","All establishment sizes"]
[null,null,"Type","Average Annual Pay"]
[null,null,"Years:","2007 to 2019"]
[null,null,"Access:","http://data.bls.gov/cgi-bin/dsrv?en"]
[null,null,"Date Updated:","2020-09-02"]
[]
[null,null,"Year","Annual",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction Labor Cost",null,"Note: Italicized values are preliminary and are subject to revision."]
[null,null,2010,78635,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D116=\"\", \"-\", D116)","v":78635}]
[null,null,2011,79665,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79665]
[null,null,2012,87406,null,null,null,null,null,null,null,null,null,null,null,null,null,null,87406]
[null,null,2013,88850,null,null,null,null,null,null,null,null,null,null,null,null,null,null,88850]
[null,null,2014,92531,null,null,null,null,null,null,null,null,null,null,null,null,null,null,92531]
[null,null,2015,97529,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97529]
[null,null,2016,102788,null,null,null,null,null,null,null,null,null,null,null,null,null,null,102788]
[null,null,2017,101108,null,null,null,null,null,null,null,null,null,null,null,null,null,null,101108]
[null,null,2018,105039,null,null,null,null,null,null,null,null,null,null,null,null,null,null,105039]
[null,null,2019,107893,null,null,null,null,null,null,null,null,null,null,null,null,null,null,107893]
[null,null,2020,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,2021,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,2022,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,2023,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[]
[]
[]
[null,null,"Gas and Steam Turbine Index"]
[]
[null,null,"Source:","BLS Producer Price Index - Commodities"]
[null,null,"Seasonal:","Not Seasonally Adjusted"]
[null,null,"Group:","(11) Machinery and Equipment"]
[null,null,"Item:","(97) Turbines and Turbine Generator Sets"]
[null,null,"Series ID:","WPU1197"]
[null,null,"Base Date:","198706"]
[null,null,"Years:","2007 to 2020"]
[null,null,"Access:","http://data.bls.gov/cgi-bin/dsrv?wp"]
[null,null,"Date Updated:","2020-09-02"]
[]
[null,null,"Year","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec",null,null,null,"Turbine Index",null,"Note: Italicized values are preliminary and are subject to revision up to four months after original publication."]
[null,null,2010,222.9,221.2,220.2,220.5,221.6,221.5,221.8,222.1,221.9,223,223,223.8,null,null,null,{"$f":"IFERROR(AVERAGE(E146:G146), \"-\")","v":220.63333333333333}]
[null,null,2011,225.5,224.9,224.5,225.7,227.7,228.8,225.9,224.2,226,223.7,221.7,223.5,null,null,null,225.0333333333333]
[null,null,2012,218.9,220,222.1,222.3,224.3,225.2,225.4,224.4,222.9,225.1,226.2,225.7,null,null,null,221.4666666666667]
[null,null,2013,225.4,225.4,226.3,226.4,227.2,226.6,228.8,227.8,229.1,229,232,231.7,null,null,null,226.03333333333333]
[null,null,2014,230.8,231.2,232.7,232.2,231.7,232.2,231.6,233.6,236.1,237.2,237.5,238.5,null,null,null,232.0333333333333]
[null,null,2015,229.7,230.9,234.4,230.9,231.7,227.9,233.5,230,232.9,232.8,232.4,233.1,null,null,null,232.06666666666669]
[null,null,2016,231.9,232.2,232.5,231.2,231.4,233.2,233.5,232.7,232.5,"NA","NA","NA",null,null,null,231.96666666666667]
[null,null,2017,"NA",224.3,223.9,223.4,223.5,227.7,225.6,225.8,225.8,224.5,217.5,211.6,null,null,null,223.86666666666667]
[null,null,2018,210.1,215.1,221,221,219.4,219.7,219.8,221.4,221,224.4,225.9,228.8,null,null,null,{"$f":"IFERROR(AVERAGE(N154:O154,D155), \"-\")","v":228.03333333333333},"Note: The 2018 turbine index is calculated with values from Nov. 2018-Jan. 2019 because the 2021-2022 capability year escalates costs for five quarters."]
[null,null,2019,229.4,231,231.1,231.6,232.7,233.3,233.7,234.4,234.8,234.3,234.9,236.3,null,null,null,231.23333333333335]
[null,null,2020,237.8,238.4,238.9,239,239.6,241.3,242,null,null,null,null,null,null,null,null,238.76666666666665]
[null,null,2021,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,2022,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,2023,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,null,"Note: BLS has not released data in months with the value \"NA\"."]
[]
[]
[]
[null,null,"Non-EPC Cost Index"]
[]
[null,null,"Source:","Bureau of Economic Analysis: Gross Domestic Product Implicit Price Deflator, Index 2012 = 100. "]
[null,null,"Seasonal:","Seasonally Adjusted"]
[null,null,"Timing:","Quarterly"]
[null,null,"Table:","1.1.9"]
[null,null,"Table Location:","Line 1"]
[null,null,"Access:","https://apps.bea.gov/iTable/index_nipa.cfm"]
[null,null,"Date Updated:","2020-09-02"]
[]
[null,null,null,"Quarter"]
[null,null,"Year","I","II","III","IV",null,null,null,null,null,null,null,null,null,null,null,"GDP Deflator",null,"Note: Italicized values are preliminary and are subject to revision."]
[null,null,2010,95.498999999999995,95.942999999999998,96.221999999999994,96.763000000000005,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E176=\"\", \"-\", E176)","v":95.942999999999998}]
[null,null,2011,97.283000000000001,97.921999999999997,98.552999999999997,98.703000000000003,null,null,null,null,null,null,null,null,null,null,null,97.921999999999997]
[null,null,2012,99.32,99.712999999999994,100.22499999999999,100.73699999999999,null,null,null,null,null,null,null,null,null,null,null,99.712999999999994]
[null,null,2013,101.139,101.431,101.91800000000001,102.517,null,null,null,null,null,null,null,null,null,null,null,101.431]
[null,null,2014,102.937,103.512,103.95699999999999,104.123,null,null,null,null,null,null,null,null,null,null,null,103.512]
[null,null,2015,104.03100000000001,104.596,104.926,104.937,null,null,null,null,null,null,null,null,null,null,null,104.596]
[null,null,2016,104.86499999999999,105.592,105.95,106.46899999999999,null,null,null,null,null,null,null,null,null,null,null,105.592]
[null,null,2017,107.01,107.34,107.872,108.598,null,null,null,null,null,null,null,null,null,null,null,107.34]
[null,null,2018,109.23699999999999,110.176,110.614,111.14,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D185=\"\", \"-\", D185)","v":111.42400000000001},"Note: The 2018 GDP deflator is calculated with Q1 2019 data because the 2021-2022 capability year escalates costs for five quarters."]
[null,null,2019,111.42400000000001,112.14100000000001,112.53100000000001,112.95,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E185=\"\", \"-\", E185)","v":112.14100000000001}]
[null,null,2020,113.41500000000001,112.755,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E186=\"\", \"-\",E186)","v":112.755}]
[null,null,2021,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,2022,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,2023,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]

{"sheet":"Winter-to-Summer Ratio","index":8,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,2,1,3]]}
[null,"Project: ","NYISO ICAP Demand Curve "]
[null,"Date: ","2021-04-12"]
[null,"Worksheet:","Winter-to-Summer Ratio"]
[]
[null,"Instructions:","Update WSR annually for each zone."]
[null,null,"Paste updated WSR values into yellow cells next to the correct zone."]
[]
[null,"Annual Winter-to-Summmer Ratios"]
[]
[]
[null,"Zone","Capability Year","Lookup","Winter-to-Summer Ratio","Updated 9/02/2020"]
[null,"C - Central","2021-2022",{"$f":"B12&C12","v":"C - Central2021-2022"},1.038]
[null,"G - Hudson Valley (Rockland)","2021-2022","G - Hudson Valley (Rockland)2021-2022",1.0589999999999999]
[null,"J - New York City","2021-2022","J - New York City2021-2022",1.0760000000000001]
[null,"K - Long Island","2021-2022","K - Long Island2021-2022",1.073]
[null,"C - Central","2022-2023","C - Central2022-2023"]
[null,"G - Hudson Valley (Rockland)","2022-2023","G - Hudson Valley (Rockland)2022-2023"]
[null,"J - New York City","2022-2023","J - New York City2022-2023"]
[null,"K - Long Island","2022-2023","K - Long Island2022-2023"]
[null,"C - Central","2023-2024","C - Central2023-2024"]
[null,"G - Hudson Valley (Rockland)","2023-2024","G - Hudson Valley (Rockland)2023-2024"]
[null,"J - New York City","2023-2024","J - New York City2023-2024"]
[null,"K - Long Island","2023-2024","K - Long Island2023-2024"]
[null,"C - Central","2024-2025","C - Central2024-2025"]
[null,"G - Hudson Valley (Rockland)","2024-2025","G - Hudson Valley (Rockland)2024-2025"]
[null,"J - New York City","2024-2025","J - New York City2024-2025"]
[null,"K - Long Island","2024-2025","K - Long Island2024-2025"]

{"sheet":"Net EAS","index":9,"n_rows":29,"n_cols":15,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,11,1,12]]}
[null,null,null,null,null,null,null,null,null,null,"Project: ","NYISO ICAP Demand Curve "]
[null,null,null,null,null,null,null,null,null,null,"Date: ","2021-04-12"]
[null,null,null,null,null,null,null,null,null,null,"Worksheet:","Net EAS Revenues"]
[]
[null,null,null,null,null,null,null,null,null,null,"Instructions:","Current data reflect the most recent net EAS results from the Net EAS Revenues model."]
[null,null,null,null,null,null,null,null,null,null,null,"To update net EAS results for a future capability year, run Net EAS Model and copy and paste in net EAS values that correspond to capability year, fuel type, and load zone. "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Annual Net EAS Revenue Estimates"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Net EAS Revenues ($/kW-Year)"]
[null,"Unit Type","Lookups",null,null,null,null,"Gas Matrix","zone",null,"Zone","Technology","Capability Year","Dual fuel with SCR","Gas only without SCR"]
[null,"j15",{"$f":"$B14&\"_\"&$I14&\"_\"&\"Yes_No_\"&$H14","v":"j15_C_Yes_No_1"},{"$f":"$B14&\"_\"&$I14&\"_\"&\"Yes_Yes_\"&$H14","v":"j15_C_Yes_Yes_1"},{"$f":"$B14&\"_\"&$I14&\"_\"&\"No_No_\"&$H14","v":"j15_C_No_No_1"},{"$f":"$B14&\"_\"&$I14&\"_\"&\"No_Yes_\"&$H14","v":"j15_C_No_Yes_1"},{"$f":"$B14&\"_\"&$I14","v":"j15_C"},1,"C",{"$f":"K14&L14&M14","v":"C - Central1x0 GE 7HA.02 15ppm2021-2022"},"C - Central","1x0 GE 7HA.02 15ppm","2021-2022","-",30.12316591405002]
[null,"j25",{"$f":"$B15&\"_\"&$I15&\"_\"&\"Yes_No_\"&$H15","v":"j25_G2_Yes_No_1"},{"$f":"$B15&\"_\"&$I15&\"_\"&\"Yes_Yes_\"&$H15","v":"j25_G2_Yes_Yes_1"},{"$f":"$B15&\"_\"&$I15&\"_\"&\"No_No_\"&$H15","v":"j25_G2_No_No_1"},{"$f":"$B15&\"_\"&$I15&\"_\"&\"No_Yes_\"&$H15","v":"j25_G2_No_Yes_1"},{"$f":"$B15&\"_\"&$I15","v":"j25_G2"},1,"G2",{"$f":"K15&L15&M15","v":"G - Hudson Valley (Rockland)1x0 GE 7HA.02 25ppm2021-2022"},"G - Hudson Valley (Rockland)","1x0 GE 7HA.02 25ppm","2021-2022",32.30733551959797,"-"]
[null,"j25","j25_J_Yes_No_1","j25_J_Yes_Yes_1","j25_J_No_No_1","j25_J_No_Yes_1","j25_J",1,"J",{"$f":"K16&L16&M16","v":"J - New York City1x0 GE 7HA.02 25ppm2021-2022"},"J - New York City","1x0 GE 7HA.02 25ppm","2021-2022",30.612338390535811,"-"]
[null,"j25","j25_K_Yes_No_1","j25_K_Yes_Yes_1","j25_K_No_No_1","j25_K_No_Yes_1","j25_K",1,"K","K - Long Island1x0 GE 7HA.02 25ppm2021-2022","K - Long Island","1x0 GE 7HA.02 25ppm","2021-2022",50.867667819761621,"-"]
[null,"j15",{"$f":"$B18&\"_\"&$I18&\"_\"&\"Yes_No_\"&$H18","v":"j15_C_Yes_No_1"},{"$f":"$B18&\"_\"&$I18&\"_\"&\"Yes_Yes_\"&$H18","v":"j15_C_Yes_Yes_1"},{"$f":"$B18&\"_\"&$I18&\"_\"&\"No_No_\"&$H18","v":"j15_C_No_No_1"},{"$f":"$B18&\"_\"&$I18&\"_\"&\"No_Yes_\"&$H18","v":"j15_C_No_Yes_1"},{"$f":"$B18&\"_\"&$I18","v":"j15_C"},1,"C",{"$f":"K18&L18&M18","v":"C - Central1x0 GE 7HA.02 15ppm2022-2023"},"C - Central","1x0 GE 7HA.02 15ppm","2022-2023"]
[null,"j25","j25_G2_Yes_No_1","j25_G2_Yes_Yes_1","j25_G2_No_No_1","j25_G2_No_Yes_1","j25_G2",1,"G2",{"$f":"K19&L19&M19","v":"G - Hudson Valley (Rockland)1x0 GE 7HA.02 25ppm2022-2023"},"G - Hudson Valley (Rockland)","1x0 GE 7HA.02 25ppm","2022-2023"]
[null,"j25","j25_J_Yes_No_1","j25_J_Yes_Yes_1","j25_J_No_No_1","j25_J_No_Yes_1","j25_J",1,"J","J - New York City1x0 GE 7HA.02 25ppm2022-2023","J - New York City","1x0 GE 7HA.02 25ppm","2022-2023"]
[null,"j25",{"$f":"$B21&\"_\"&$I21&\"_\"&\"Yes_No_\"&$H21","v":"j25_K_Yes_No_1"},{"$f":"$B21&\"_\"&$I21&\"_\"&\"Yes_Yes_\"&$H21","v":"j25_K_Yes_Yes_1"},{"$f":"$B21&\"_\"&$I21&\"_\"&\"No_No_\"&$H21","v":"j25_K_No_No_1"},{"$f":"$B21&\"_\"&$I21&\"_\"&\"No_Yes_\"&$H21","v":"j25_K_No_Yes_1"},{"$f":"$B21&\"_\"&$I21","v":"j25_K"},1,"K","K - Long Island1x0 GE 7HA.02 25ppm2022-2023","K - Long Island","1x0 GE 7HA.02 25ppm","2022-2023"]
[null,"j15",{"$f":"$B22&\"_\"&$I22&\"_\"&\"Yes_No_\"&$H22","v":"j15_C_Yes_No_1"},{"$f":"$B22&\"_\"&$I22&\"_\"&\"Yes_Yes_\"&$H22","v":"j15_C_Yes_Yes_1"},{"$f":"$B22&\"_\"&$I22&\"_\"&\"No_No_\"&$H22","v":"j15_C_No_No_1"},{"$f":"$B22&\"_\"&$I22&\"_\"&\"No_Yes_\"&$H22","v":"j15_C_No_Yes_1"},{"$f":"$B22&\"_\"&$I22","v":"j15_C"},1,"C",{"$f":"K22&L22&M22","v":"C - Central1x0 GE 7HA.02 15ppm2023-2024"},"C - Central","1x0 GE 7HA.02 15ppm","2023-2024"]
[null,"j25","j25_G2_Yes_No_1","j25_G2_Yes_Yes_1","j25_G2_No_No_1","j25_G2_No_Yes_1","j25_G2",1,"G2","G - Hudson Valley (Rockland)1x0 GE 7HA.02 25ppm2023-2024","G - Hudson Valley (Rockland)","1x0 GE 7HA.02 25ppm","2023-2024"]
[null,"j25","j25_J_Yes_No_1","j25_J_Yes_Yes_1","j25_J_No_No_1","j25_J_No_Yes_1","j25_J",1,"J","J - New York City1x0 GE 7HA.02 25ppm2023-2024","J - New York City","1x0 GE 7HA.02 25ppm","2023-2024"]
[null,"j25","j25_K_Yes_No_1","j25_K_Yes_Yes_1","j25_K_No_No_1","j25_K_No_Yes_1","j25_K",1,"K","K - Long Island1x0 GE 7HA.02 25ppm2023-2024","K - Long Island","1x0 GE 7HA.02 25ppm","2023-2024"]
[null,"j15",{"$f":"$B26&\"_\"&$I26&\"_\"&\"Yes_No_\"&$H26","v":"j15_C_Yes_No_1"},{"$f":"$B26&\"_\"&$I26&\"_\"&\"Yes_Yes_\"&$H26","v":"j15_C_Yes_Yes_1"},{"$f":"$B26&\"_\"&$I26&\"_\"&\"No_No_\"&$H26","v":"j15_C_No_No_1"},{"$f":"$B26&\"_\"&$I26&\"_\"&\"No_Yes_\"&$H26","v":"j15_C_No_Yes_1"},{"$f":"$B26&\"_\"&$I26","v":"j15_C"},1,"C",{"$f":"K26&L26&M26","v":"C - Central1x0 GE 7HA.02 15ppm2024-2025"},"C - Central","1x0 GE 7HA.02 15ppm","2024-2025"]
[null,"j25",{"$f":"$B27&\"_\"&$I27&\"_\"&\"Yes_No_\"&$H27","v":"j25_G2_Yes_No_1"},{"$f":"$B27&\"_\"&$I27&\"_\"&\"Yes_Yes_\"&$H27","v":"j25_G2_Yes_Yes_1"},{"$f":"$B27&\"_\"&$I27&\"_\"&\"No_No_\"&$H27","v":"j25_G2_No_No_1"},{"$f":"$B27&\"_\"&$I27&\"_\"&\"No_Yes_\"&$H27","v":"j25_G2_No_Yes_1"},{"$f":"$B27&\"_\"&$I27","v":"j25_G2"},1,"G2",{"$f":"K27&L27&M27","v":"G - Hudson Valley (Rockland)1x0 GE 7HA.02 25ppm2024-2025"},"G - Hudson Valley (Rockland)","1x0 GE 7HA.02 25ppm","2024-2025"]
[null,"j25","j25_J_Yes_No_1","j25_J_Yes_Yes_1","j25_J_No_No_1","j25_J_No_Yes_1","j25_J",1,"J",{"$f":"K28&L28&M28","v":"J - New York City1x0 GE 7HA.02 25ppm2024-2025"},"J - New York City","1x0 GE 7HA.02 25ppm","2024-2025"]
[null,"j25","j25_K_Yes_No_1","j25_K_Yes_Yes_1","j25_K_No_No_1","j25_K_No_Yes_1","j25_K",1,"K","K - Long Island1x0 GE 7HA.02 25ppm2024-2025","K - Long Island","1x0 GE 7HA.02 25ppm","2024-2025"]

{"sheet":"Fixed Inputs-->","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Levelized Factor","index":11,"n_rows":53,"n_cols":32,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,2,1,3]]}
[null,"Project: ","NYISO ICAP Demand Curve "]
[null,"Date: ","2021-04-12"]
[null,"Worksheet:","Levelized Factor"]
[]
[null,"Calculation of Levelized Factor"]
[]
[]
[null,"Input"]
[]
[null,"Property Tax Rate ",{"$f":"Property_Tax_Rate","v":5.0000000000000001E-3},"Linked to \"Model\""]
[null,"Total Project Capitalized Cost",{"$f":"Capital_Costs*DMNC_ICAP*1000","v":391252635.77069664}]
[]
[null,"Calendar"]
[null,"Operating Year",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,"Discount Rate Adjustment ",{"$f":"IF(C14<=Plant_Life,1/(1+ATWACC_Real)^(C14), 0)","v":0.9408263099635672},0.88515414551966232,0.83277630847821837,0.78349786133064347,0.7371354017400561,0.69351637996260873,0.65247845665951232,0.6138688987096923,0.57754401077443862,0.54336860049847391,0.51121547535704692,0.48096496927644139,0.45250449726609487,0.42572813640477913,0.40053623162137458,0.37683502480305053,0.35453630585048335,0.33355708438142495,0.31381928086078226,0.29524943600767006,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Parameters and Exemptions"]
[null,"Loan Period Parameter",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"NYC Property Tax Exemption active for 15 years",{"$f":"IF(AND(Region=\"J - New York City\",PropTax_Abate), 1, 0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Depreciation"]
[null,"Effective Tax Depreciation",{"$f":"C23","v":0.05},{"$f":"D23","v":9.5000000000000001E-2},8.5500000000000007E-2,7.6999999999999999E-2,6.93E-2,6.2300000000000001E-2,5.8999999999999997E-2,5.8999999999999997E-2,5.91E-2,5.8999999999999997E-2,5.91E-2,5.8999999999999997E-2,5.91E-2,5.8999999999999997E-2,5.91E-2,2.9499999999999998E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Tax Depreciation (15 year SC)",0.05,9.5000000000000001E-2,8.5500000000000007E-2,7.6999999999999999E-2,6.93E-2,6.2300000000000001E-2,5.8999999999999997E-2,5.8999999999999997E-2,5.91E-2,5.8999999999999997E-2,5.91E-2,5.8999999999999997E-2,5.91E-2,5.8999999999999997E-2,5.91E-2,2.9499999999999998E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Financing"]
[null,"Equity",{"$f":"C11*(1-Debt_Fraction)","v":176063686.09681347}]
[null,"Target Cash Flow to Equity",{"$f":"IF(C14<=Plant_Life,PMT(Equity_Rate_Real,Plant_Life,(-1*$C$27),,0),0)","v":21642318.528421175},21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Debt Service",{"$f":"C11*Debt_Fraction","v":215188949.67388317}]
[null,"Principal",{"$f":"IF(C14<=Plant_Life,PPMT(Debt_Rate_Real,C14,Plant_Life,-1*$C$30,,0),0)","v":6855524.8332894752},7164392.7493828302,7487176.3600308327,7824502.6211095965,8177026.7352829967,8545433.4246297348,8930438.2606071755,9332789.0539352167,9753267.3070997782,10192689.732297225,10651909.837768011,11131819.585600851,11633351.124227332,12157478.598972147,12705220.044175593,13277639.360563526,13875848.381705467,14501009.033574665,15154335.591404669,15837097.038226034,0,0,0,0,0,0,0,0,0,0]
[null,"Loan Balance Start of Year",{"$f":"C30","v":215188949.67388317},{"$f":"C32-C31","v":208333424.8405937},201169032.09121087,193681855.73118004,185857353.11007044,177680326.37478745,169134892.9501577,160204454.68955052,150871665.63561529,141118398.3285155,130925708.59621827,120273798.75845027,109141979.17284942,97508628.048622087,85351149.449649945,72645929.40547435,59368290.044910826,45492441.663205355,30991432.629630692,15837097.038226023,0,0,0,0,0,0,0,0,0,0]
[null,"Interest",{"$f":"IF(C14<=Plant_Life,IPMT(Debt_Rate_Real,C18,Plant_Life,-1*C32,,0),0)","v":9695094.6963747572},9386226.7802814022,9063443.1696333997,8726116.9085546359,8373592.7943812348,8005186.1050344994,7620181.2690570569,7217830.4757290157,6797352.2225644505,6357929.7973670065,5898709.6918962207,5418799.9440633822,4917268.4054368986,4393140.9306920823,3845399.4854886364,3272980.1691007055,2674771.1479587643,2049610.4960895653,1396283.9382595613,713522.49143819499,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Yearly Debt Service (Principal + Interest)",{"$f":"SUM(C31,C33)","v":16550619.529664233},16550619.529664233,16550619.529664233,16550619.529664233,16550619.529664231,16550619.529664233,16550619.529664233,16550619.529664233,16550619.52966423,16550619.529664231,16550619.529664231,16550619.529664233,16550619.52966423,16550619.52966423,16550619.52966423,16550619.529664231,16550619.529664231,16550619.52966423,16550619.52966423,16550619.52966423,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Capital Related Expenses"]
[null,"Property Taxes",{"$f":"IF(C19,0,IF(C14<=Plant_Life,$C$10*$C$11,0))","v":1956263.1788534832},1956263.1788534832,1956263.1788534832,1956263.1788534832,1956263.1788534832,1956263.1788534832,1956263.1788534832,1956263.1788534832,1956263.1788534832,1956263.1788534832,1956263.1788534832,1956263.1788534832,1956263.1788534832,1956263.1788534832,1956263.1788534832,1956263.1788534832,1956263.1788534832,1956263.1788534832,1956263.1788534832,1956263.1788534832,0,0,0,0,0,0,0,0,0,0]
[null,"Tax Depreciation",{"$f":"$C$11*C22","v":19562631.788534831},37169000.398216181,33452100.358394567,30126452.954343639,27113807.658909276,24375039.2085144,23083905.510471102,23083905.510471102,23123030.774048172,23083905.510471102,23123030.774048172,23083905.510471102,23123030.774048172,23083905.510471102,23123030.774048172,11541952.755235551,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Derivation of Carrying Charges"]
[null,"Target Equity IRR",{"$f":"Equity_Rate_Real","v":0.10675808031341823}]
[null,"Principal",{"$f":"C31","v":6855524.8332894752},7164392.7493828302,7487176.3600308327,7824502.6211095965,8177026.7352829967,8545433.4246297348,8930438.2606071755,9332789.0539352167,9753267.3070997782,10192689.732297225,10651909.837768011,11131819.585600851,11633351.124227332,12157478.598972147,12705220.044175593,13277639.360563526,13875848.381705467,14501009.033574665,15154335.591404669,15837097.038226034,0,0,0,0,0,0,0,0,0,0]
[null,"Interest",{"$f":"C33","v":9695094.6963747572},9386226.7802814022,9063443.1696333997,8726116.9085546359,8373592.7943812348,8005186.1050344994,7620181.2690570569,7217830.4757290157,6797352.2225644505,6357929.7973670065,5898709.6918962207,5418799.9440633822,4917268.4054368986,4393140.9306920823,3845399.4854886364,3272980.1691007055,2674771.1479587643,2049610.4960895653,1396283.9382595613,713522.49143819499,0,0,0,0,0,0,0,0,0,0]
[null,"Target Cash Flow to Equity",{"$f":"C28","v":21642318.528421175},21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,21642318.528421175,0,0,0,0,0,0,0,0,0,0]
[null,"Income Taxes",{"$f":"(Effective_Tax_Rate/(1-Effective_Tax_Rate))*(C45+C43-C39)","v":3389218.1829287587},{"$f":"(Effective_Tax_Rate/(1-Effective_Tax_Rate))*(D45+D43-D39)","v":-3171902.7698115148},-1639608.9713575223,-250205.16734281171,1026238.4018187542,2204822.0755138495,2840598.7608320601,2993214.5789909731,3137865.7129724347,3319383.8018179401,3478730.1211569365,3675605.4703124189,3851000.9539518524,4064648.5443498073,4257571.9235873986,8867519.1886634715,13472408.138323899,13709538.040757045,13957351.562692562,14216330.042521356,0,0,0,0,0,{"$f":"(Effective_Tax_Rate/(1-Effective_Tax_Rate))*(AB45+AB43-AB39)","v":0},{"$f":"(Effective_Tax_Rate/(1-Effective_Tax_Rate))*(AC45+AC43-AC39)","v":0},{"$f":"(Effective_Tax_Rate/(1-Effective_Tax_Rate))*(AD45+AD43-AD39)","v":0},{"$f":"(Effective_Tax_Rate/(1-Effective_Tax_Rate))*(AE45+AE43-AE39)","v":0},{"$f":"(Effective_Tax_Rate/(1-Effective_Tax_Rate))*(AF45+AF43-AF39)","v":0}]
[null,"Property Taxes",{"$f":"C38","v":1956263.1788534832},{"$f":"D38","v":1956263.1788534832},1956263.1788534832,1956263.1788534832,1956263.1788534832,1956263.1788534832,1956263.1788534832,1956263.1788534832,1956263.1788534832,{"$f":"L38","v":1956263.1788534832},1956263.1788534832,1956263.1788534832,1956263.1788534832,1956263.1788534832,1956263.1788534832,1956263.1788534832,1956263.1788534832,1956263.1788534832,1956263.1788534832,1956263.1788534832,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Total Carrying Charges",{"$f":"SUM(C43:C47)","v":43538419.41986765},{"$f":"SUM(D43:D47)","v":36977298.467127383},{"$f":"SUM(E43:E47)","v":38509592.265581369},39898996.069596082,41175439.638757639,42354023.312452741,42989799.99777095,43142415.815929867,43287066.949911319,43468585.038756825,43627931.358095825,43824806.70725131,44000202.190890737,44213849.781288691,44406773.160526283,49016720.425602362,53621609.375262782,53858739.277695931,54106552.799631447,54365531.279460244,0,0,0,0,0,{"$f":"SUM(AB43:AB47)","v":0},{"$f":"SUM(AC43:AC47)","v":0},{"$f":"SUM(AD43:AD47)","v":0},{"$f":"SUM(AE43:AE47)","v":0},{"$f":"SUM(AF43:AF47)","v":0}]
[]
[null,"Cumulative Present Value",{"$f":"SUMPRODUCT(C49:AF49, C15:AF15)","v":488281214.61450893}]
[null,"Levelized Carrying Charges (Real)",{"$f":"-1*PMT(ATWACC_Real,Plant_Life,$C$51,,0)","v":43576644.220891014}]
[null,"Levelized Carrying Charge Rate (Real)",{"$f":"C52/C11","v":0.11137725407281394}]

{"sheet":"Peak Load and IRM","index":12,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,3,1,4]]}
[null,null,"Project: ","NYISO ICAP Demand Curve "]
[null,null,"Date: ","2021-04-12"]
[null,null,"Worksheet:","Peak Load and IRM"]
[]
[null,null,"Peak Load and IRM"]
[]
[]
[null,"Lookup","Zone","Peak Load (2020)","Installed Reserve Margin / \nLocational Capacity Requirement"]
[]
[null,"K","K - Long Island",5227,1.034]
[null,"J","J - New York City",11477,0.86599999999999999]
[null,"NYCA","NYCA",32296,1.1890000000000001]
[null,"G","G-J",15695,0.9]
[]
[]
[]
[null,null,"Sources:"]
[null,null,"2020 Gold Book, Tables I-3a, I-4a, and I-5."]
[null,null,"2020 - 2021 Locational Minimum Installed Capacity Requirement Study. NYISO."]

{"sheet":"AS Adders","index":13,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,4,1,5],[1,2,1,3]]}
[null,"Project: ","NYISO ICAP Demand Curve "]
[null,"Date: ","2021-04-12"]
[null,"Worksheet:","AS Adders"]
[]
[null,"AS Adders"]
[]
[null,"Adder Type","Adder ($/kW-Year)"]
[null,"VSS Adder",2.04]

{"sheet":"Performance and O&M","index":14,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,5,1,6]]}
[null,null,null,"Project: ",null,"NYISO ICAP Demand Curve "]
[null,null,null,"Date: ",null,"2021-04-12"]
[null,null,null,"Worksheet:",null,"Performance and O&M"]
[]
[null,null,null,"Performance and O&M Data"]
[]
[]
[null,null,null,null,null,"1x0 GE 7HA.02 25ppm","1x0 GE 7HA.02 25ppm","1x0 GE 7HA.02 25ppm",null,"1x0 GE 7HA.02 15ppm"]
[null,null,null,"Technology",null,"1x0 GE 7HA.02 25ppm dual fuel with SCR ",null,null,null,"1x0 GE 7HA.02 15ppm dual fuel without SCR "]
[null,null,null,"Plant Capacity (MW)",null,{"$f":"AVERAGE(F21:H21)","v":348.2},null,null,null,{"$f":"AVERAGE(J21:J21)","v":326.7}]
[]
[null,null,null,"Lookup",null,{"$f":"F13&F8","v":"G - Hudson Valley (Rockland)1x0 GE 7HA.02 25ppm"},{"$f":"G13&G8","v":"J - New York City1x0 GE 7HA.02 25ppm"},"K - Long Island1x0 GE 7HA.02 25ppm",null,{"$f":"J13&J8","v":"C - Central1x0 GE 7HA.02 15ppm"}]
[null,null,null,"Zone","Units","G - Hudson Valley (Rockland)","J - New York City","K - Long Island",null,"C - Central"]
[]
[null,null,null,"Plant Capacities"]
[]
[null,null,"Capacity- based on average temp (Summer, MW)","Net Plant Capacity - Summer","MW",357.4,358.7,359,null,338]
[null,null,"Capacity- based on average temp (Winter, MW)","Net Plant Capacity - Winer","MW",370.2,370.2,371.1,null,346.1]
[null,null,"DMNC Summer (MW)","DMNC Summer","MW",348.2,348.5,351.1,null,329.3]
[null,null,"DMNC Winter (MW)","DMNC Winter","MW",369.9,374.1,373,null,344.7]
[null,null,"DMNC ICAP (MW)","DMNC ICAP","MW",347,348.8,348.8,null,326.7]
[]
[null,null,null,"Fixed O&M Costs"]
[]
[null,null,null,"Fixed O&M and Site Leasing Costs, Excluding Insurance and Property Taxes (2020)","$/kW-Year",9.0201729106628239,18.463302752293579,9.7190366972477058,null,8.356290174471992]
[]
[null,"2021-2022",{"$f":"\"FO&M Costs \"&B27","v":"FO&M Costs 2021-2022"},{"$f":"\"Fixed O&M and Site Leasing Costs, Excluding Insurance and Property Taxes (\"&B27&\")\"","v":"Fixed O&M and Site Leasing Costs, Excluding Insurance and Property Taxes (2021-2022)"},"$/kW-Year",{"$f":"IFERROR(F$25*(1+INDEX(Escalation_Factor_Table, MATCH($B27, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(F$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":9.2864211128731586},{"$f":"IFERROR(G$25*(1+INDEX(Escalation_Factor_Table, MATCH($B27, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(G$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":19.008283565117271},{"$f":"IFERROR(H$25*(1+INDEX(Escalation_Factor_Table, MATCH($B27, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(H$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":10.0059132431285},null,{"$f":"IFERROR(J$25*(1+INDEX(Escalation_Factor_Table, MATCH($B27, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(J$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":8.6119528289485423}]
[]
[null,"2022-2023",{"$f":"\"FO&M Costs \"&B29","v":"FO&M Costs 2022-2023"},{"$f":"\"Fixed O&M and Site Leasing Costs, Excluding Insurance and Property Taxes (\"&B29&\")\"","v":"Fixed O&M and Site Leasing Costs, Excluding Insurance and Property Taxes (2022-2023)"},"$/kW-Year",{"$f":"IFERROR(F$27*(1+INDEX(Escalation_Factor_Table, MATCH($B29, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(F$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},{"$f":"IFERROR(G$27*(1+INDEX(Escalation_Factor_Table, MATCH($B29, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(G$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},{"$f":"IFERROR(H$27*(1+INDEX(Escalation_Factor_Table, MATCH($B29, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(H$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},null,{"$f":"IFERROR(J$27*(1+INDEX(Escalation_Factor_Table, MATCH($B29, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(J$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"}]
[]
[null,"2023-2024",{"$f":"\"FO&M Costs \"&B31","v":"FO&M Costs 2023-2024"},{"$f":"\"Fixed O&M and Site Leasing Costs, Excluding Insurance and Property Taxes (\"&B31&\")\"","v":"Fixed O&M and Site Leasing Costs, Excluding Insurance and Property Taxes (2023-2024)"},"$/kW-Year",{"$f":"IFERROR(F$27*(1+INDEX(Escalation_Factor_Table, MATCH($B31, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(F$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},{"$f":"IFERROR(G$27*(1+INDEX(Escalation_Factor_Table, MATCH($B31, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(G$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},{"$f":"IFERROR(H$27*(1+INDEX(Escalation_Factor_Table, MATCH($B31, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(H$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},null,{"$f":"IFERROR(J$27*(1+INDEX(Escalation_Factor_Table, MATCH($B31, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(J$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"}]
[]
[null,"2024-2025",{"$f":"\"FO&M Costs \"&B33","v":"FO&M Costs 2024-2025"},{"$f":"\"Fixed O&M and Site Leasing Costs, Excluding Insurance and Property Taxes (\"&B33&\")\"","v":"Fixed O&M and Site Leasing Costs, Excluding Insurance and Property Taxes (2024-2025)"},"$/kW-Year",{"$f":"IFERROR(F$27*(1+INDEX(Escalation_Factor_Table, MATCH($B33, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(F$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},{"$f":"IFERROR(G$27*(1+INDEX(Escalation_Factor_Table, MATCH($B33, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(G$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},{"$f":"IFERROR(H$27*(1+INDEX(Escalation_Factor_Table, MATCH($B33, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(H$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},null,{"$f":"IFERROR(J$27*(1+INDEX(Escalation_Factor_Table, MATCH($B33, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(J$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"}]
[]
[]
[null,null,null,"Updated 7/20/2020"]

{"sheet":"Capital Costs","index":15,"n_rows":74,"n_cols":9,"rows_kept":74,"cut":false,"hidden":false,"merged":[[1,4,1,5]]}
[null,null,null,"Project: ","NYISO ICAP Demand Curve "]
[null,null,null,"Date: ","2021-04-12"]
[null,null,null,"Worksheet:","Capital Costs "]
[]
[null,null,null,"Capital Costs"]
[]
[]
[null,null,null,null,"1x0 GE 7HA.02 25ppm","1x0 GE 7HA.02 25ppm","1x0 GE 7HA.02 25ppm",null,"1x0 GE 7HA.02 15ppm"]
[null,null,null,null,"Dual fuel with SCR","Dual fuel with SCR","Dual fuel with SCR",null,"Gas only without SCR"]
[null,null,null,"Technology","1x0 GE 7HA.02 25ppm dual fuel with SCR ",null,null,null,"1x0 GE 7HA.02 15ppm gas only without SCR"]
[null,null,null,"Plant Capacity (MW) average of zone-specific DMNC ICAP",{"$f":"AVERAGE(E13:G13)","v":348.2},null,null,null,{"$f":"AVERAGE(I13:I13)","v":326.7}]
[]
[null,null,null,"DMNC ICAP (MW)",{"$f":"INDEX('Performance and O&M'!$C$12:$J$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(E15&E8, 'Performance and O&M'!$C$12:$J$12, 0))","v":347},{"$f":"INDEX('Performance and O&M'!$C$12:$J$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(F15&F8, 'Performance and O&M'!$C$12:$J$12, 0))","v":348.8},{"$f":"INDEX('Performance and O&M'!$C$12:$J$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(G15&G8, 'Performance and O&M'!$C$12:$J$12, 0))","v":348.8},null,{"$f":"INDEX('Performance and O&M'!$C$12:$J$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(I15&I8, 'Performance and O&M'!$C$12:$J$12, 0))","v":326.7}]
[null,null,null,"Lookup",{"$f":"E15&E8&E9","v":"G - Hudson Valley (Rockland)1x0 GE 7HA.02 25ppmDual fuel with SCR"},{"$f":"F15&F8&F9","v":"J - New York City1x0 GE 7HA.02 25ppmDual fuel with SCR"},{"$f":"G15&G8&G9","v":"K - Long Island1x0 GE 7HA.02 25ppmDual fuel with SCR"},null,{"$f":"I15&I8&I9","v":"C - Central1x0 GE 7HA.02 15ppmGas only without SCR"}]
[null,null,null,"Zone","G - Hudson Valley (Rockland)","J - New York City","K - Long Island",null,"C - Central"]
[]
[null,null,null,"EPC Costs"]
[null,null,null,"Labor ",72900000,99220000,96770000,null,39020000]
[null,null,null,"Materials",61860000,65190000,65300000,null,29530000]
[null,null,null,"Turbines or Batteries",68500000,68500000,68500000,null,67000000]
[null,null,null,"Other",64180000,69580000,68860000,null,45180000]
[null,null,null,"Total EPC Costs",267440000,302490000,299430000,null,180730000]
[]
[]
[null,null,null,"Owner's Costs"]
[null,null,null,"Owner's Project Development",370000,480000,410000,null,370000]
[null,null,null,"Owner's Operational Personnel Prior to COD",440000,570000,480000,null,440000]
[null,null,null,"Owner's Engineer",1020000,1330000,1120000,null,1020000]
[null,null,null,"Owner's Project Management",1130000,1470000,1240000,null,1130000]
[null,null,null,"Owner's Legal Costs",1000000,1300000,1100000,null,1000000]
[null,null,null,"Owner's Start-up Engineering and Commissioning",270000,350000,300000,null,270000]
[null,null,null,"Sales Tax",0,0,0,null,0]
[null,null,null,"Construction Power and Water",550000,720000,610000,null,550000]
[null,null,null,"Permitting and Licensing Fees",1000000,1300000,1100000,null,1000000]
[null,null,null,"Switchyard",10250000,43800000,5590000,null,10250000]
[null,null,null,"Electrical Interconnection and Deliverability",11000000,13010000,6500000,null,11000000]
[null,null,null,"Gas Interconnection and Reinforcement",23500000,20000000,23500000,null,23500000]
[null,null,null,"System Deliverability Upgrade Costs",0,0,0,null,0]
[null,null,null,"Water Supply Infrastructure",0,10900000,0,null,0]
[null,null,null,"Emission Reduction Credits",400000,400000,400000,null,400000]
[null,null,null,"Political Concessions & Area Development",500000,650000,550000,null,500000]
[null,null,null,"Startup/Testing (Fuel & Consumables)",4500000,4500000,4500000,null,1150000]
[null,null,null,"Initial Fuel Inventory",7240000,7240000,7240000,null,0]
[null,null,null,"Site Security",580000,750000,640000,null,580000]
[null,null,null,"Operating Spare Parts",6500000,6500000,6500000,null,6500000]
[]
[null,null,null,"Builders Risk Insurance (0.45% of Construction Costs)",1203480,1361205,1347435,null,813284.99999999988]
[null,null,null,"Owner's Contingency (5% for Screening Purposes)",16944674,20956060.25,18127871.75,null,12060164.25]
[null,null,null,"Total Owner's Costs ",88398154,137587265.25,81255306.75,null,72533449.25]
[]
[null,null,null,"Capital Costs without AFUDC ($2020)",355838154,440077265.25,380685306.75,null,253263449.25]
[null,null,null,"Capital Costs without AFUDC ($2020/ICAP kW)",{"$f":"E51/(E13*1000)","v":1025.4701844380404},1261.6894072534403,1091.414296875,null,{"$f":"I51/(I13*1000)","v":775.2171694214876}]
[]
[null,"2021-2022",null,{"$f":"\"Capital Costs without AFUDC ($\"&B54&\")\"","v":"Capital Costs without AFUDC ($2021-2022)"},{"$f":"IFERROR(E$51*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B54, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(E$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":366341419.26095188},{"$f":"IFERROR(F$51*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B54, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(F$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":453067014.10148215},{"$f":"IFERROR(G$51*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B54, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(G$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":391921984.75317466},null,{"$f":"IFERROR(I$51*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B54, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(I$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":261012103.78032613}]
[null,"2021-2022","Capital Costs without AFUDC2021-2022",{"$f":"\"Capital Costs without AFUDC ($\"&B55&\"/ICAP kW)\"","v":"Capital Costs without AFUDC ($2021-2022/ICAP kW)"},{"$f":"IFERROR(E$52*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B55, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(E$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":1055.7389604062014},{"$f":"IFERROR(F$52*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B55, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(F$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":1298.9306596946162},{"$f":"IFERROR(G$52*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B55, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(G$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":1123.6295434437347},null,{"$f":"IFERROR(I$52*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B55, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(I$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":798.93512023362757}]
[null,"2021-2022",null,{"$f":"\"Total EPC Costs ($\"&B54&\")\"","v":"Total EPC Costs ($2021-2022)"},{"$f":"IFERROR(E$22*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B56, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(E$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":275334019.31696445},{"$f":"IFERROR(F$22*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B56, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(F$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":311418589.22819537},{"$f":"IFERROR(G$22*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B56, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(G$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":308268267.29015356},null,{"$f":"IFERROR(I$22*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B56, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(I$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":186259476.66713434}]
[null,"2021-2022","Total EPC Costs2021-2022",{"$f":"\"Total EPC Costs ($\"&B55&\"/ICAP kW)\"","v":"Total EPC Costs ($2021-2022/ICAP kW)"},{"$f":"IFERROR(E56/(E$13*1000),\"-\")","v":793.4697963024912},892.82852416340415,883.79663787314666,null,{"$f":"IFERROR(I56/(I$13*1000),\"-\")","v":570.12389552229672}]
[]
[null,"2022-2023",null,{"$f":"\"Capital Costs without AFUDC ($\"&B59&\")\"","v":"Capital Costs without AFUDC ($2022-2023)"},{"$f":"IFERROR(E$54*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B59, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(E$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},{"$f":"IFERROR(F$54*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B59, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(F$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},{"$f":"IFERROR(G$54*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B59, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(G$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},null,{"$f":"IFERROR(I$54*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B59, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(I$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"}]
[null,"2022-2023","Capital Costs without AFUDC2022-2023",{"$f":"\"Capital Costs without AFUDC ($\"&B60&\"/ICAP kW)\"","v":"Capital Costs without AFUDC ($2022-2023/ICAP kW)"},{"$f":"IFERROR(E$55*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B60, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(E$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},{"$f":"IFERROR(F$55*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B60, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(F$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},{"$f":"IFERROR(G$55*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B60, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(G$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},null,{"$f":"IFERROR(I$55*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B60, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(I$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"}]
[null,"2022-2023",null,{"$f":"\"Total EPC Costs ($\"&B59&\")\"","v":"Total EPC Costs ($2022-2023)"},{"$f":"IFERROR(E$56*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B61, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(E$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},{"$f":"IFERROR(F$56*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B61, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(F$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},{"$f":"IFERROR(G$56*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B61, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(G$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},null,{"$f":"IFERROR(I$56*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B61, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(I$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"}]
[null,"2022-2023","Total EPC Costs2022-2023",{"$f":"\"Total EPC Costs ($\"&B60&\"/ICAP kW)\"","v":"Total EPC Costs ($2022-2023/ICAP kW)"},{"$f":"IFERROR(E61/(E$13*1000),\"-\")","v":"-"},"-","-",null,{"$f":"IFERROR(I61/(I$13*1000),\"-\")","v":"-"}]
[]
[null,"2023-2024",null,{"$f":"\"Capital Costs without AFUDC ($\"&B64&\")\"","v":"Capital Costs without AFUDC ($2023-2024)"},{"$f":"IFERROR(E$54*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B64, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(E$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},{"$f":"IFERROR(F$54*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B64, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(F$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},{"$f":"IFERROR(G$54*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B64, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(G$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},null,{"$f":"IFERROR(I$54*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B64, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(I$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"}]
[null,"2023-2024","Capital Costs without AFUDC2023-2024",{"$f":"\"Capital Costs without AFUDC ($\"&B65&\"/ICAP kW)\"","v":"Capital Costs without AFUDC ($2023-2024/ICAP kW)"},{"$f":"IFERROR(E$55*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B65, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(E$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},{"$f":"IFERROR(F$55*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B65, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(F$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},{"$f":"IFERROR(G$55*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B65, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(G$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},null,{"$f":"IFERROR(I$55*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B65, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(I$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"}]
[null,"2023-2024",null,{"$f":"\"Total EPC Costs ($\"&B64&\")\"","v":"Total EPC Costs ($2023-2024)"},{"$f":"IFERROR(E$56*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B66, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(E$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},{"$f":"IFERROR(F$56*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B66, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(F$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},{"$f":"IFERROR(G$56*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B66, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(G$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},null,{"$f":"IFERROR(I$56*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B66, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(I$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"}]
[null,"2023-2024","Total EPC Costs2023-2024",{"$f":"\"Total EPC Costs ($\"&B65&\"/ICAP kW)\"","v":"Total EPC Costs ($2023-2024/ICAP kW)"},{"$f":"IFERROR(E66/(E$13*1000),\"-\")","v":"-"},"-","-",null,{"$f":"IFERROR(I66/(I$13*1000),\"-\")","v":"-"}]
[]
[null,"2024-2025",null,{"$f":"\"Capital Costs without AFUDC ($\"&B69&\")\"","v":"Capital Costs without AFUDC ($2024-2025)"},{"$f":"IFERROR(E$54*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B69, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(E$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},{"$f":"IFERROR(F$54*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B69, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(F$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},{"$f":"IFERROR(G$54*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B69, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(G$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},null,{"$f":"IFERROR(I$54*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B69, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(I$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"}]
[null,"2024-2025","Capital Costs without AFUDC2024-2025",{"$f":"\"Capital Costs without AFUDC ($\"&B70&\"/ICAP kW)\"","v":"Capital Costs without AFUDC ($2024-2025/ICAP kW)"},{"$f":"IFERROR(E$55*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B70, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(E$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},{"$f":"IFERROR(F$55*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B70, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(F$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},{"$f":"IFERROR(G$55*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B70, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(G$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},null,{"$f":"IFERROR(I$55*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B70, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(I$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"}]
[null,"2024-2025",null,{"$f":"\"Total EPC Costs ($\"&B69&\")\"","v":"Total EPC Costs ($2024-2025)"},{"$f":"IFERROR(E$56*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B71, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(E$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},{"$f":"IFERROR(F$56*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B71, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(F$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},{"$f":"IFERROR(G$56*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B71, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(G$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"},null,{"$f":"IFERROR(I$56*(1+INDEX('Escalation Factor'!$C$36:$E$40, MATCH($B71, 'Escalation Factor'!$C$36:$C$40, 0), MATCH(I$8, 'Escalation Factor'!$C$36:$E$36, 0))), \"-\")","v":"-"}]
[null,"2024-2025","Total EPC Costs2024-2025",{"$f":"\"Total EPC Costs ($\"&B70&\"/ICAP kW)\"","v":"Total EPC Costs ($2024-2025/ICAP kW)"},{"$f":"IFERROR(E71/(E$13*1000),\"-\")","v":"-"},"-","-",null,{"$f":"IFERROR(I71/(I$13*1000),\"-\")","v":"-"}]
[]
[null,null,null,"Updated 7/30/2020"]