{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Instructions","Glossary","Model-->","Model","Multiple Scenario Output","Data Updated Annually-->","Net EAS","Escalation Factor","Winter-to-Summer Ratio","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":91,"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":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,3,1,4]]}
[null,"Project: ",null,"NYISO ICAP Demand Curve "]
[null,"Date: ",null,"2024-06-01"]
[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,"Update and run DCR model, using \"Multiple Scenario Output\" Worksheet"]

{"sheet":"Glossary","index":1,"n_rows":49,"n_cols":3,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,2,1,3]]}
[null,"Project: ","NYISO ICAP Demand Curve "]
[null,"Date: ","2024-06-01"]
[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,"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 (either \"Original Max Price\" or \"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":"Model-->","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Model","index":3,"n_rows":136,"n_cols":22,"rows_kept":136,"cut":false,"hidden":false,"merged":[[2,1,2,2],[119,4,119,9],[1,1,1,2]]}
["Project: ","NYISO ICAP Demand Curve "]
["Date:","2024-06-01"]
["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. All fossil technologies are modeled as equipped with SCR and using dual fuel."]
[null,"2. Service Life and AFUDC automatically update to match unit type. Tax rates automatically update to match region."]
[null,"3. 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","2024-2025",null,null,null,"2024-2025"]
[]
["Plant"]
["Region","C - Central","C - Central","F - Capital","G - Hudson Valley (Dutchess)","G - Hudson Valley (Rockland)","J - New York City","K - Long Island"]
["Technology ","SCGT J Class","SCGT J Class","SCGT 7HA.02","BESS 2h","BESS 4h","BESS 6h","BESS 8h"]
["Service Life (Years)",{"$f":"IF(OR(Unit=\"BESS 2h\", Unit=\"BESS 4h\",Unit=\"BESS 6h\",Unit=\"BESS 8h\"),G22,E22)","v":13},"Maximum 20","Fossil Units",13,"Battery Units:",15]
["Maximum Price (Multiple of Monthly Gross CONE)",1.5]
["Fuel and SCR Specification","Dual fuel with SCR","Dual fuel with SCR","Gas only with SCR","Dual fuel without SCR","Gas only without SCR","Battery"]
["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:$BH$70, MATCH(\"Capital Costs without AFUDC\"&Capability_Year, 'Capital Costs'!$C$14:$C$70, 0), MATCH(Region&Unit&Fuel_Type, 'Capital Costs'!$C$14:$BH$14, 0)), \"-\")","v":1535.1988161804848},null,null,"AFUDC Table","J - New York City","All Others"]
["AFUDC (%)",{"$f":"IF(Region=F26,_xlfn.XLOOKUP(Unit,E27:E32,F27:F32),_xlfn.XLOOKUP(Unit,E27:E32,G27:G32))","v":9.2600000000000002E-2},null,null,"SCGT J Class",9.1200000000000003E-2,9.2600000000000002E-2]
["Overnight Capital Costs including AFUDC($/kW)",{"$f":"B26*(1+B27)","v":1677.3582265587977},null,null,"SCGT 7HA.02",9.1200000000000003E-2,9.2600000000000002E-2]
["Total EPC Capital Costs pre ITC",{"$f":"IFERROR(INDEX('Capital Costs'!$C$14:$BH$72, MATCH(\"Total EPC Costs\"&Capability_Year, 'Capital Costs'!$C$14:$C$72, 0), MATCH(Region&Unit&Fuel_Type, 'Capital Costs'!$C$14:$BH$14, 0)), \"-\")","v":1155.6041131105399},null,null,"BESS 2h",7.85E-2,7.9699999999999993E-2]
["Fixed O&M + Site Lease ($/kW-Year)",{"$f":"IFERROR(INDEX('Performance and O&M'!$C$12:$AQ$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:$AQ$12, 0)), \"-\")","v":7.9768123393316195},null,null,"BESS 4h",7.9200000000000007E-2,8.0399999999999999E-2]
["DMNC Summer (MW)",{"$f":"IFERROR(INDEX('Performance and O&M'!$C$12:$AQ$26, MATCH($A31, 'Performance and O&M'!$C$12:$C$26, 0), MATCH(Region&Unit, 'Performance and O&M'!$C$12:$AQ$12, 0)), \"-\")","v":394.5},null,null,"BESS 6h",9.3200000000000005E-2,9.4700000000000006E-2]
["DMNC Winter (MW)",{"$f":"IFERROR(INDEX('Performance and O&M'!$C$12:$AQ$26, MATCH($A32, 'Performance and O&M'!$C$12:$C$26, 0), MATCH(Region&Unit, 'Performance and O&M'!$C$12:$AQ$12, 0)), \"-\")","v":419.5},null,null,"BESS 8h",0.1158,0.1176]
["DMNC ICAP (MW)",{"$f":"IFERROR(INDEX('Performance and O&M'!$C$12:$AQ$26, MATCH($A33, 'Performance and O&M'!$C$12:$C$26, 0), MATCH(Region&Unit, 'Performance and O&M'!$C$12:$AQ$12, 0)), \"-\")","v":389}]
["Winter-to-Summer Ratio",{"$f":"IFERROR(INDEX('Winter-to-Summer Ratio'!$D$11:$E$17, MATCH(Region&Capability_Year, 'Winter-to-Summer Ratio'!$D$11:$D$17, 0), MATCH(\"Winter-to-Summer Ratio\", 'Winter-to-Summer Ratio'!$D$11:$E$11, 0)), \"-\")","v":1.0329999999999999}]
["Summer-to-Winter Ratio",{"$f":"1/WSR","v":0.96805421103581812}]
["Escalation Factor (%)",{"$f":"IFERROR(INDEX(Escalation_Factor_Table,MATCH(Capability_Year,'Escalation Factor'!$C$36:$C$40,0),MATCH(Unit,'Escalation Factor'!$C$36:$K$36,0)),\"-\")","v":0.16564133697135192}]
[]
["Finance"]
["Inflation Factor (%) ",2.12E-2]
["Debt Fraction (%)",0.55000000000000004]
["Debt Rate (%)"]
["Nominal ",6.7000000000000004E-2]
["Real",{"$f":"(Debt_Rate-Inflation_Factor)/(1+Inflation_Factor)","v":4.484919702311007E-2}]
["Equity Rate (%)"]
["Nominal",0.14000000000000001]
["Real",{"$f":"(Equity_Rate-Inflation_Factor)/(1+Inflation_Factor)","v":0.11633372502937721}]
["Composite Tax Rate (%)",{"$f":"IF(Region=\"J - New York City\", D47, F47)","v":0.26140000000000002},"NYC:",0.33129999999999998,"Non-NYC:",0.26140000000000002]
["ATWACC Nominal (%)",{"$f":"(1-Debt_Fraction)*Equity_Rate+Debt_Fraction*Debt_Rate*(1-Effective_Tax_Rate)","v":9.0217409999999998E-2}]
["ATWACC Real (%)",{"$f":"(ATWACC-Inflation_Factor)/(1+Inflation_Factor)","v":6.7584616137877002E-2},"Discount rate"]
[]
["Fixed Property Tax Rate (%)",{"$f":"IF(Region=\"J - New York City\", D51, F51)","v":6.0000000000000001E-3},"NYC:",4.7663999999999998E-2,"Non-NYC:",6.0000000000000001E-3]
["Insurance Rate (%)",6.0000000000000001E-3]
[]
["Levelized Fixed Charge"]
["Property Tax Abatement (NYC or Battery Unit)",false,true,false]
[]
["Levelized Fixed Charge (%)",{"$f":"IFERROR('Levelized Factor'!C54, \"-\")","v":0.14654618751712287}]
["Levelized Fixed Charge ($/kW-Year)",{"$f":"IFERROR(Levelized_Charge*Capital_Costs, \"-\")","v":245.81045320267424}]
[]
["ICAP Demand Curve"]
["Zero Crossing Point (Margin Over 100%)",{"$f":"IF(Region=C61,D61, IF(Region=E61, F61, IF(Region=G61,H61, IF(Region=I61, J61, IF(Region=K61, N61, Q61)))))","v":0.12},"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]
["Winter Zero Crossing Point (Margin Over 100%)",{"$f":"IF(Region=C62,D62, IF(Region=E62, F62, IF(Region=G62,H62, IF(Region=I62, J62, IF(Region=K62, N62, Q62)))))","v":0.12},"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 (%) - Summer DMNC",{"$f":"IFERROR(((Peak_Load*IRM)+DMNC_Summer)/(Peak_Load*IRM),\"-\")","v":1.0102518786535148}]
["Capacity at LOE Conditions (%) - Winter DMNC",{"$f":"IFERROR(((Peak_Load*IRM)+DMNC_Winter)/(Peak_Load*IRM),\"-\")","v":1.0109015541068429}]
["Capacity at LOE Conditions (%)",{"$f":"IFERROR(( (Peak_Load*IRM) + DMNC_ICAP ) / (Peak_Load*IRM), \"-\")","v":1.0101089500537828}]
["Peak Load (2024)",{"$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 (2024)\", 'Peak Load and IRM'!$B$8:$E$8, 0))","v":31541.599999999999}]
["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":1.22}]
[]
["Net EAS ($/kW-Year)",{"$f":"Fuel_Type","v":"Dual fuel with SCR"},"Dual fuel with SCR","Dual fuel without SCR","Gas only with SCR","Gas only without SCR","Battery"]
[{"$f":"\"Not escalated ($\"&VALUE(LEFT(Capability_Year,4))-2&\")\"","v":"Not escalated ($2022)"},{"$f":"IFERROR(IF(CC_Flag=TRUE,INDEX('Net EAS'!$J$13:$R$49, MATCH(Region&Unit&Capability_Year, 'Net EAS'!$J$13:$J$49, 0), MATCH($B$69, 'Net EAS'!$J$13:$R$13, 0))+CC_Adder,INDEX('Net EAS'!$J$13:$R$49, MATCH(Region&Unit&Capability_Year, 'Net EAS'!$J$13:$J$49, 0), MATCH($B$69, 'Net EAS'!$J$13:$R$13, 0))+VSS_Adder),\"-\")","v":66.665606399608833}]
[{"$f":"\"Escalated ($\"&VALUE(LEFT(Capability_Year,4))&\")\"","v":"Escalated ($2024)"},{"$f":"IFERROR(B70*(1+D71), \"-\")","v":72.823053722584191},"EAS Inflation rate:",{"$f":"IFERROR(H71/F71-1, \"-\")","v":9.2363178789167666E-2},{"$f":"\"GDP Deflator (\"&VALUE(LEFT(Capability_Year,4))-3&\")\"","v":"GDP Deflator (2021)"},{"$f":"INDEX('Escalation Factor'!$C$209:$S$223, MATCH(VALUE(LEFT(Capability_Year,4))-3, 'Escalation Factor'!$C$209:$C$223, 0), MATCH(\"IV\", 'Escalation Factor'!$C$209:$S$209, 0))","v":112.848},{"$f":"\"GDP Deflator (\"&VALUE(LEFT(Capability_Year,4)-1)&\")\"","v":"GDP Deflator (2023)"},{"$f":"INDEX('Escalation Factor'!$C$209:$S$223, MATCH(VALUE(LEFT(Capability_Year,4))-1, 'Escalation Factor'!$C$209:$C$223, 0), MATCH(\"IV\", 'Escalation Factor'!$C$209:$S$209, 0))","v":123.271}]
["2024-2025 CAF"]
["Unit","C - Central","F - Capital","G - Hudson Valley (Dutchess)","G - Hudson Valley (Rockland)","J - New York City","K - Long Island"]
["BESS 2H",0.55420000000000003,0.55420000000000003,0.56159999999999999,0.56159999999999999,0.55930000000000002,0.52759999999999996]
["BESS 4H",0.64470000000000005,0.64470000000000005,0.67949999999999999,0.67949999999999999,0.68840000000000001,0.78939999999999999]
["BESS 6H",0.91769999999999996,0.91769999999999996,0.91920000000000002,0.91920000000000002,0.90410000000000001,0.9153]
["BESS 8H",1,1,1,1,1,0.99719999999999998]
[]
["CAF",{"$f":"IFERROR(INDEX($A$73:$G$77, MATCH(Unit, $A$73:$A$77, 0), MATCH(Region, $A$73:$G$73, 0)), 1)","v":1}]
["2024-205 Finalized CAF",{"$f":"IFERROR(INDEX($A$73:$G$77, MATCH(Unit, $A$73:$A$77, 0), MATCH(Region, $A$73:$G$73, 0)), 1)","v":1}]
[]
["CP"]
["CPMax",0.65]
["CPMin",0.35]
["New Variables"]
["LOE",{"$f":"Capacity_at_LOE","v":1.0101089500537828}]
["SLOLE",1]
["WLOLE",{"$f":"1-$B$87","v":0}]
["Derating Factor"]
["Unit","Factor"]
["SCGT J Class",4.1000000000000002E-2]
["SCGT 7HA.02",4.1000000000000002E-2]
["BESS 2h",0.02]
["BESS 4h",0.02]
["BESS 6h",0.02]
["BESS 8h",0.02]
["Derating Factor",{"$f":"INDEX($B$90:$B$96, MATCH(Unit, $A$90:$A$96, 0))","v":4.1000000000000002E-2}]
["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]
[]
["Discount Rate Adjustment (%)","-",{"$f":"IF(C102<=Plant_Life, 1/(1+ATWACC_Real)^C102,0)","v":0.93669390218231796},{"$f":"IF(D102<=Plant_Life, 1/(1+ATWACC_Real)^D102,0)","v":0.87739546638553778},0.82185098316574412,0.76982280443389539,0.72108832667412082,0.67543903853050025,0.63267962868740724,0.5926271502264675,0.55511023788481662,0.51996837486568359,0.4870512060643355,0.4562178947710066,0.4273365200984563,0,0,0,0,0,0,0]
[]
["Energy and Ancillary Services Revenue",{"$f":"SUMPRODUCT($C$104:$V$104, C106:V106)","v":617.05023635489908},{"$f":"IF(C136=TRUE, EAS, 0)","v":72.823053722584191},{"$f":"IF(D136=TRUE, EAS, 0)","v":72.823053722584191},72.823053722584191,72.823053722584191,72.823053722584191,72.823053722584191,72.823053722584191,72.823053722584191,72.823053722584191,72.823053722584191,72.823053722584191,72.823053722584191,72.823053722584191,0,0,0,0,0,0,0]
[]
["Fixed O&M (Excludes Property Tax and Insurance)",{"$f":"SUMPRODUCT($C$104:$V$104, C108:V108)","v":67.589776694804968},{"$f":"IF(C102<=Plant_Life, FixedOM_Site_Lease, 0)","v":7.9768123393316195},{"$f":"IF(D102<=Plant_Life, FixedOM_Site_Lease, 0)","v":7.9768123393316195},7.9768123393316195,7.9768123393316195,7.9768123393316195,7.9768123393316195,7.9768123393316195,7.9768123393316195,7.9768123393316195,7.9768123393316195,7.9768123393316195,7.9768123393316195,7.9768123393316195,0,0,0,0,0,0,0]
["Insurance",{"$f":"IFERROR(SUMPRODUCT($C$104:$V$104, C109:V109), \"-\")","v":58.750553953197908},{"$f":"IFERROR(IF(C102<=Plant_Life, Insurance_Rate*Total_EPC_Capital_Costs, 0), \"-\")","v":6.9336246786632394},{"$f":"IFERROR(IF(D102<=Plant_Life, Insurance_Rate*Total_EPC_Capital_Costs, 0), \"-\")","v":6.9336246786632394},6.9336246786632394,6.9336246786632394,6.9336246786632394,6.9336246786632394,6.9336246786632394,6.9336246786632394,6.9336246786632394,6.9336246786632394,6.9336246786632394,6.9336246786632394,6.9336246786632394,0,0,0,0,0,0,0]
["Levelized Fixed Charge",{"$f":"IFERROR(SUMPRODUCT($C$104:$V$104, C110:V110), \"-\")","v":2082.8211739790877},{"$f":"IFERROR(IF(C102<=Plant_Life, Capital_Costs*Levelized_Charge, 0), \"-\")","v":245.81045320267424},{"$f":"IFERROR(IF(D102<=Plant_Life, Capital_Costs*Levelized_Charge, 0), \"-\")","v":245.81045320267424},245.81045320267424,245.81045320267424,245.81045320267424,245.81045320267424,245.81045320267424,245.81045320267424,245.81045320267424,245.81045320267424,245.81045320267424,245.81045320267424,245.81045320267424,0,0,0,0,0,0,0]
["Total Costs",{"$f":"IFERROR(SUMPRODUCT($C$104:$V$104, C111:V111), \"-\")","v":2209.1615046270908},{"$f":"SUM(C108:C110)","v":260.72089022066911},{"$f":"SUM(D108:D110)","v":260.72089022066911},260.72089022066911,260.72089022066911,260.72089022066911,260.72089022066911,260.72089022066911,260.72089022066911,260.72089022066911,260.72089022066911,260.72089022066911,260.72089022066911,260.72089022066911,0,0,0,0,0,0,0]
[]
["Annual Reference Value",{"$f":"IFERROR(SUMPRODUCT($C$104:$V$104, C113:V113), \"-\")","v":1592.1112682721914},{"$f":"IFERROR(C111-C106, \"-\")","v":187.89783649808493},{"$f":"IFERROR(D111-D106, \"-\")","v":187.89783649808493},187.89783649808493,187.89783649808493,187.89783649808493,187.89783649808493,187.89783649808493,187.89783649808493,187.89783649808493,187.89783649808493,187.89783649808493,187.89783649808493,187.89783649808493,0,0,0,0,0,0,0]
[]
[]
["Annual Reference Value ($/kW - Year)",{"$f":"-PMT(ATWACC_Real,Plant_Life,B113)","v":187.89783649808484}]
["Adjusted Net EAS for No Net EAS after 2040",{"$f":"-PMT(ATWACC_Real,Plant_Life,B106)","v":72.823053722584191}]
["Adjusted Gross CONE for No Net EAS after 2040",{"$f":"-PMT(ATWACC_Real,Plant_Life,B111)","v":260.72089022066905}]
["Reference Point Price Finalized CAF"]
["Monthly Reference Point Price ($/kW-Month)",{"$f":"IFERROR((Annual_Reference_Value*DMNC_ICAP)\n/(6*(\nDMNC_Summer*(1 - (Capacity_at_LOE-1)/ZCP)\n+\nDMNC_Winter*(1 -  ((WSR-1+Capacity_at_LOE-1) / ZCP )\n)))/(CAF*(1-Derate)), \"-\")","v":20.161186350380426}]
["Summer, ICAP RP",{"$f":"IFERROR((Annual_Reference_Value*DMNC_ICAP*MAX(MIN(CPMax,SLOLE),CPMin))/(6*DMNC_Summer*(1-(Capacity_at_LOE_Summer-1+MAX(0,SWR-1))/ZCP)),\"-\")","v":21.946770937638053}]
["Winter, ICAP RP",{"$f":"IFERROR((Annual_Reference_Value*DMNC_ICAP*MAX(MIN(CPMax,WLOLE),CPMin))/(6*DMNC_Winter*(1-(Capacity_at_LOE_Winter-1+MAX(0,WSR-1))/ZCP)),\"-\")","v":16.02734804994105}]
["Summer, UCAP RP",{"$f":"IFERROR((Annual_Reference_Value*DMNC_ICAP*MAX(MIN(CPMax,SLOLE),CPMin))/(6*DMNC_Summer*(1-(Capacity_at_LOE_Summer-1+MAX(0,SWR-1))/ZCP))/(CAF*(1-Derate)),\"-\")","v":22.885058329132487}]
["Winter, UCAP RP",{"$f":"IFERROR((Annual_Reference_Value*DMNC_ICAP*MAX(MIN(CPMax,WLOLE),CPMin))/(6*DMNC_Winter*(1-(Capacity_at_LOE_Winter-1+MAX(0,WSR-1))/ZCP))/(CAF*(1-Derate)),\"-\")","v":16.712563138624663}]
[]
["Other Outputs"]
["Gross CONE ($/kW-Year) ",{"$f":"Gross_CONE_Adj","v":260.72089022066905}]
["Summer ICAP Demand Curve Slope",{"$f":"IFERROR((B121-0)/(1-ZCP-1), \"-\")","v":-182.88975781365045}]
["Winter ICAP Demand Curve Slope",{"$f":"IFERROR((B122-0)/(1-ZCP-1), \"-\")","v":-133.56123374950874}]
["Level of Excess Clearing Price (Summer, $/kW-Year)",{"$f":"IFERROR(B128*(Capacity_at_LOE-1)+B121, \"-\")","v":20.097947510551435}]
["Level of Excess Clearing Price (Winter, $/kW-Year)",{"$f":"IFERROR(B122*(1-(Capacity_at_LOE-1+WSR-1)/ZCP), \"-\")","v":10.269663495111883}]
["Maximum Clearing Price Summer",{"$f":"(1.5*Gross_CONE*DMNC_ICAP*MAX(MIN(CPMax,SLOLE),CPMin))/(6*DMNC_Summer*(1-(Capacity_at_LOE_Summer-1+MAX(0,SWR-1))/ZCP))","v":45.678931936944537}]
["Maximum Clearing Price Winter",{"$f":"(1.5*Gross_CONE*DMNC_ICAP*MAX(MIN(CPMax,WLOLE),CPMin))/(6*DMNC_Winter*(1-(Capacity_at_LOE_Winter-1+MAX(0,WSR-1))/ZCP))","v":33.358535648970012}]
[]
["Toggle Key for Applying Net EAS after 2040"]
[null,"Net EAS Applied",{"$f":"IF(Fuel_Type<>$E$24,IF(AND(C102<=Plant_Life,C102<=15),TRUE,FALSE),IF(C102<=Plant_Life,TRUE,FALSE))","v":true},true,true,true,true,true,true,true,true,true,true,true,true,false,false,false,false,false,false,false]

{"sheet":"Multiple Scenario Output","index":4,"n_rows":100,"n_cols":44,"rows_kept":100,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
["Project: ","NYISO ICAP Demand Curve "]
["Date: ","2024-06-01"]
["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,"Columns 2 through 13 contain default inputs used to calculate reference point prices. Adjust these inputs as desired."]
[null,"Then, Click the \"Perform Runs\" button. "]
[]
[]
[]
[]
[]
[]
[]
[]
["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},{"$f":"COLUMN()","v":13},{"$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},{"$f":"COLUMN()","v":40},{"$f":"COLUMN()","v":41},null,null,{"$f":"COLUMN()","v":44}]
[null,"Adjustable Inputs",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,null,"Results"]
["Value:","Capability Year","Region","Unit","Equity Rate (Nominal)","Debt Rate (Nominal)","Debt Fraction","Service life (Years)","NYC/Battery Property Tax Abatement?","Insurance Rate","AFUDC Percent","Fuel Type",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)","2024-205 Finalized CAF","Insurance ($/kW-Year)",null,"Annual Reference Value ($/kW-Year)","Monthly Reference Point Price ($/kW-Month)","Summer, ICAP RP","Winter, ICAP RP","Summer, UCAP RP","Winter, UCAP RP","Level of Excess Clearing Price (Summer)","Level of Excess Clearing Price (Winter)","Maximum Clearing Price (Summer)","Maximum 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",null,"Capital_Costs","DMNC_Summer","DMNC_Winter","DMNC_ICAP","WSR","Escalation_Factor","ATWACC_Real","Levelized_Charge",null,"EAS_Adjusted","ZCP","Property_Tax_Rate","FixedOM_Site_Lease","Peak_Load","IRM","Capacity_at_LOE","CC_Plant","Gross_CONE_Adj"]
[]
["Value:","2024-2025",{"$f":"Region","v":"C - Central"},{"$f":"Unit","v":"SCGT J Class"},{"$f":"Equity_Rate","v":0.14000000000000001},{"$f":"Debt_Rate","v":6.7000000000000004E-2},{"$f":"Debt_Fraction","v":0.55000000000000004},{"$f":"Plant_Life","v":13},{"$f":"PropTax_Abate","v":false},{"$f":"Insurance_Rate","v":6.0000000000000001E-3},{"$f":"AFUDC_Pct","v":9.2600000000000002E-2},{"$f":"Fuel_Type","v":"Dual fuel with SCR"},null,{"$f":"Capital_Costs","v":1677.3582265587977},{"$f":"DMNC_Summer","v":394.5},{"$f":"DMNC_Winter","v":419.5},{"$f":"DMNC_ICAP","v":389},{"$f":"WSR","v":1.0329999999999999},{"$f":"Escalation_Factor","v":0.16564133697135192},{"$f":"ATWACC_Real","v":6.7584616137877002E-2},{"$f":"Levelized_Charge","v":0.14654618751712287},{"$f":"Model!B58","v":245.81045320267424},{"$f":"EAS_Adjusted","v":72.823053722584191},{"$f":"ZCP","v":0.12},{"$f":"Property_Tax_Rate","v":6.0000000000000001E-3},{"$f":"FixedOM_Site_Lease","v":7.9768123393316195},{"$f":"Peak_Load","v":31541.599999999999},{"$f":"IRM","v":1.22},{"$f":"Capacity_at_LOE","v":1.0101089500537828},{"$f":"CC_Flag","v":false},{"$f":"Gross_CONE","v":260.72089022066905},{"$f":"CAF","v":1},{"$f":"Model!C109","v":6.9336246786632394},null,{"$f":"Annual_Reference_Value","v":187.89783649808484},{"$f":"Model!B120","v":20.161186350380426},{"$f":"Model!B121","v":21.946770937638053},{"$f":"Model!B122","v":16.02734804994105},{"$f":"Model!B123","v":22.885058329132487},{"$f":"Model!B124","v":16.712563138624663},{"$f":"Model!B130","v":20.097947510551435},{"$f":"Model!B131","v":10.269663495111883},{"$f":"Model!B132","v":45.678931936944537},{"$f":"Model!B133","v":33.358535648970012}]
[]
[]
[]
["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",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)","2024-205 Finalized CAF","Insurance ($/kW-Year)",null,"Annual Reference Value ($/kW-Year)","Monthly Reference Point Price ($/kW-Month)","Summer, ICAP RP","Winter, ICAP RP","Summer, UCAP RP","Winter, UCAP RP","Level of Excess Clearing Price (Summer)","Level of Excess Clearing Price (Winter)","Maximum Clearing Price (Summer)","Maximum Clearing Price (Winter)"]
["Fossil 13 Year - Dual Fuel with SCR"]
[{"$f":"C33&\" \"&D33&\" \"&E33&F33&G33&H33&L33&K33","v":"F - Capital SCGT J Class 0.140.0670.5513Dual fuel with SCR0.0926"},"2024-2025","F - Capital","SCGT J Class",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,13,false,6.0000000000000001E-3,9.2600000000000002E-2,"Dual fuel with SCR",null,1656.3476000000001,406.5,431.7,400.3,1.0329999999999999,0.16564133697135192,6.7584616137877002E-2,0.14654618751712284,242.73140000000001,96.372799999999998,0.12,6.0000000000000001E-3,8.0264000000000006,31541.599999999999,1.22,1.010402603358687,false,257.63290000000001,1,6.875,null,161.26009999999999,17.3444,18.864000000000001,13.8123,19.670500000000001,14.402799999999999,17.2287,8.8165999999999993,45.206400000000002,33.100299999999997]
["J - New York City SCGT J Class 0.140.0670.5513Dual fuel with SCR0.0912","2024-2025","J - New York City","SCGT J Class",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,13,true,6.0000000000000001E-3,9.1200000000000003E-2,"Dual fuel with SCR",null,1948.4653000000001,404.4,435,404.1,1.0669999999999999,0.16564133697135192,6.5062274774774789E-2,0.14659649345404549,285.63819999999998,80.398899999999998,0.18,4.7663999999999998E-2,27.8842,11167.9,0.80400000000000005,1.0450050537969098,false,321.70139999999998,1,8.1791,null,241.30250000000001,36.2408,34.838900000000002,36.461199999999998,36.328299999999999,38.020000000000003,26.1282,13.773199999999999,69.670100000000005,72.914299999999997]
["K - Long Island SCGT J Class 0.140.0670.5513Dual fuel with SCR0.0926","2024-2025","K - Long Island","SCGT J Class",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,13,false,6.0000000000000001E-3,9.2600000000000002E-2,"Dual fuel with SCR",null,1823.2862,407.1,438.1,404,1.0720000000000001,0.16564133697135192,6.7584616137877002E-2,0.14654618751712289,267.19560000000001,134.15700000000001,0.18,6.0000000000000001E-3,9.8824000000000005,5043.3999999999996,1.0529999999999999,1.0760728312247789,false,285.05959999999999,1,7.9814999999999996,null,150.9025,33.876800000000003,28.257200000000001,57.286000000000001,29.465199999999999,59.735199999999999,16.314900000000002,10.161,80.067999999999998,162.32259999999999]
[{"$f":"C36&\" \"&D36&\" \"&E36&F36&G36&H36&L36&K36","v":"C - Central SCGT J Class 0.140.0670.5513Dual fuel with SCR0.0926"},"2024-2025","C - Central","SCGT J Class",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,13,false,6.0000000000000001E-3,9.2600000000000002E-2,"Dual fuel with SCR",null,1677.3581999999999,394.5,419.5,389,1.0329999999999999,0.16564133697135192,6.7584616137877002E-2,0.14654618751712287,245.81049999999999,72.823099999999997,0.12,6.0000000000000001E-3,7.9767999999999999,31541.599999999999,1.22,1.0101089500537828,false,260.72089999999997,1,6.9336000000000002,null,187.89779999999999,20.161200000000001,21.9468,16.0273,22.885100000000001,16.712599999999998,20.097899999999999,10.2697,45.678899999999999,33.358499999999999]
["G - Hudson Valley (Rockland) SCGT J Class 0.140.0670.5513Dual fuel with SCR0.0926","2024-2025","G - Hudson Valley (Rockland)","SCGT J Class",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,13,false,6.0000000000000001E-3,9.2600000000000002E-2,"Dual fuel with SCR",null,1753.9675999999999,400.9,428.5,397.4,1.0580000000000001,0.16564133697135192,6.7584616137877002E-2,0.14654618751712289,257.03730000000002,67.859899999999996,0.15,6.0000000000000001E-3,9.5444999999999993,15220,0.81,1.0322350383673204,false,274.04840000000002,1,7.4665999999999997,null,206.1885,29.332899999999999,28.271000000000001,29.2302,29.479700000000001,30.479900000000001,22.195599999999999,11.6463,56.363199999999999,58.275599999999997]
["G - Hudson Valley (Dutchess) SCGT J Class 0.140.0670.5513Dual fuel with SCR0.0926","2024-2025","G - Hudson Valley (Dutchess)","SCGT J Class",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,13,false,6.0000000000000001E-3,9.2600000000000002E-2,"Dual fuel with SCR",null,1658.6194,400.9,428.5,397.4,1.0580000000000001,0.16564133697135192,6.7584616137877002E-2,0.14654618751712287,243.06440000000001,66.068399999999997,0.15,6.0000000000000001E-3,8.6386000000000003,15220,0.81,1.0322350383673204,false,258.67320000000001,1,6.9702000000000002,null,192.60480000000001,27.400500000000001,26.4085,27.304600000000001,27.537600000000001,28.471900000000002,20.7333,10.879,53.201000000000001,55.006100000000004]
["Fossil 13 Year - Gas Only with SCR"]
["F - Capital SCGT J Class 0.140.0670.5513Gas only with SCR0.0926","2024-2025","F - Capital","SCGT J Class",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,13,false,6.0000000000000001E-3,9.2600000000000002E-2,"Gas only with SCR",null,1582.9253000000001,406.5,431.7,400.3,1.0329999999999999,0.16564133697135192,6.7584616137877002E-2,0.14654618751712287,231.9717,95.762299999999996,0.12,6.0000000000000001E-3,8.0264000000000006,31541.599999999999,1.22,1.010402603358687,false,246.4699,1,6.4718,null,150.70769999999999,16.209399999999999,17.6296,12.9085,18.383299999999998,13.4603,16.101299999999998,8.2395999999999994,43.247599999999998,31.6661]
["C - Central SCGT J Class 0.140.0670.5513Gas only with SCR0.0926","2024-2025","C - Central","SCGT J Class",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,13,false,6.0000000000000001E-3,9.2600000000000002E-2,"Gas only with SCR",null,1601.8031000000001,394.5,419.5,389,1.0329999999999999,0.16564133697135192,6.7584616137877002E-2,0.14654618751712287,234.7381,72.823099999999997,0.12,6.0000000000000001E-3,7.9767999999999999,31541.599999999999,1.22,1.0101089500537828,false,249.2337,1,6.5186999999999999,null,176.41059999999999,18.928599999999999,20.605,15.047499999999999,21.486000000000001,15.690799999999999,18.869199999999999,9.6417999999999999,43.6663,31.8888]
["G - Hudson Valley (Rockland) SCGT J Class 0.140.0670.5513Gas only with SCR0.0926","2024-2025","G - Hudson Valley (Rockland)","SCGT J Class",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,13,false,6.0000000000000001E-3,9.2600000000000002E-2,"Gas only with SCR",null,1680.0094999999999,400.9,428.5,397.4,1.0580000000000001,0.16564133697135192,6.7584616137877002E-2,0.14654618751712289,246.19900000000001,59.893900000000002,0.15,6.0000000000000001E-3,9.5444999999999993,15220,0.81,1.0322350383673204,false,262.80399999999997,1,7.0605000000000002,null,202.9101,28.866499999999998,27.8215,28.765499999999999,29.010999999999999,29.9953,21.842700000000001,11.4611,54.050600000000003,55.884500000000003]
[{"$f":"C43&\" \"&D43&\" \"&E43&F43&G43&H43&L43&K43","v":"G - Hudson Valley (Dutchess) SCGT J Class 0.140.0670.5513Gas only with SCR0.0926"},"2024-2025","G - Hudson Valley (Dutchess)","SCGT J Class",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,13,false,6.0000000000000001E-3,9.2600000000000002E-2,"Gas only with SCR",null,1584.6613,400.9,428.5,397.4,1.0580000000000001,0.16564133697135192,6.7584616137877002E-2,0.14654618751712289,232.2261,58.644799999999996,0.15,6.0000000000000001E-3,8.6386000000000003,15220,0.81,1.0322350383673204,false,247.42869999999999,1,6.5640999999999998,null,188.78399999999999,26.8569,25.884699999999999,26.762899999999998,26.991299999999999,27.9071,20.321999999999999,10.6632,50.888399999999997,52.615000000000002]
["Fossil 13 Year - Dual Fuel without SCR"]
["F - Capital SCGT 7HA.02 0.140.0670.5513Dual fuel without SCR0.0926","2024-2025","F - Capital","SCGT 7HA.02",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,13,false,6.0000000000000001E-3,9.2600000000000002E-2,"Dual fuel without SCR",null,1737.6976999999999,335.79449,363.72214000000002,330.68230999999997,1.0329999999999999,0.16564133697135192,6.7584616137877002E-2,0.14654618751712289,254.65299999999999,62.410800000000002,0.12,6.0000000000000001E-3,9.6255000000000006,31541.599999999999,1.22,1.0085934471862712,false,271.20890000000003,1,6.9303999999999997,null,208.798,21.8413,24.022300000000001,17.135400000000001,25.049299999999999,17.867999999999999,22.302,11.196099999999999,46.804000000000002,33.386000000000003]
["C - Central SCGT 7HA.02 0.140.0670.5513Dual fuel without SCR0.0926","2024-2025","C - Central","SCGT 7HA.02",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,13,false,6.0000000000000001E-3,9.2600000000000002E-2,"Dual fuel without SCR",null,1760.4954,325.66480000000001,352.17240000000004,321.02596999999997,1.0329999999999999,0.16564133697135192,6.7584616137877002E-2,0.14654618751712289,257.9939,56.158499999999997,0.12,6.0000000000000001E-3,9.6035000000000004,31541.599999999999,1.22,1.0083425077035917,false,274.58280000000002,1,6.9854000000000003,null,218.42439999999999,22.826499999999999,25.095500000000001,17.903400000000001,26.168399999999998,18.668800000000001,23.3508,11.735300000000001,47.3215,33.759799999999998]
[{"$f":"C47&\" \"&D47&\" \"&E47&F47&G47&H47&L47&K47","v":"G - Hudson Valley (Dutchess) SCGT 7HA.02 0.140.0670.5513Dual fuel without SCR0.0926"},"2024-2025","G - Hudson Valley (Dutchess)","SCGT 7HA.02",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,13,false,6.0000000000000001E-3,9.2600000000000002E-2,"Dual fuel without SCR",null,1734.0558000000001,331.25033000000002,331.25033000000002,328.12621999999999,1.0580000000000001,0.16564133697135192,6.7584616137877002E-2,0.14654618751712289,254.11930000000001,54.777099999999997,0.15,6.0000000000000001E-3,9.7004999999999999,15220,0.81,1.0266159066205935,false,270.83120000000002,1,7.0114000000000001,null,216.05410000000001,29.555599999999998,28.244499999999999,28.752099999999999,29.452100000000002,29.981300000000001,23.232800000000001,12.5329,53.108199999999997,54.062600000000003]
["Fossil 13 Year - Gas Only without SCR"]
["F - Capital SCGT 7HA.02 0.140.0670.5513Gas only without SCR0.0926","2024-2025","F - Capital","SCGT 7HA.02",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,13,false,6.0000000000000001E-3,9.2600000000000002E-2,"Gas only without SCR",null,1648.818,335.79449,363.72214000000002,330.68230999999997,1.0329999999999999,0.16564133697135192,6.7584616137877002E-2,0.14654618751712289,241.62799999999999,63.036200000000001,0.12,6.0000000000000001E-3,9.6255000000000006,31541.599999999999,1.22,1.0085934471862712,false,257.69580000000002,1,6.4423000000000004,null,194.65960000000001,20.362400000000001,22.395700000000001,15.975099999999999,23.353200000000001,16.658100000000001,20.791899999999998,10.438000000000001,44.472000000000001,31.7225]
["C - Central SCGT 7HA.02 0.140.0670.5513Gas only without SCR0.0926","2024-2025","C - Central","SCGT 7HA.02",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,13,false,6.0000000000000001E-3,9.2600000000000002E-2,"Gas only without SCR",null,1668.9422999999999,325.66480000000001,352.17240000000004,321.02596999999997,1.0329999999999999,0.16564133697135192,6.7584616137877002E-2,0.14654618751712289,244.5771,56.158499999999997,0.12,6.0000000000000001E-3,9.6035000000000004,31541.599999999999,1.22,1.0083425077035917,false,260.66329999999999,1,6.4827000000000004,null,204.50479999999999,21.3718,23.496200000000002,16.762499999999999,24.500699999999998,17.479099999999999,21.8627,10.987500000000001,44.922600000000003,32.048400000000001]
[{"$f":"C51&\" \"&D51&\" \"&E51&F51&G51&H51&L51&K51","v":"G - Hudson Valley (Dutchess) SCGT 7HA.02 0.140.0670.5513Gas only without SCR0.0926"},"2024-2025","G - Hudson Valley (Dutchess)","SCGT 7HA.02",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,13,false,6.0000000000000001E-3,9.2600000000000002E-2,"Gas only without SCR",null,1644.4837,331.25033000000002,331.25033000000002,328.12621999999999,1.0580000000000001,0.16564133697135192,6.7584616137877002E-2,0.14654618751712287,240.99279999999999,45.232799999999997,0.15,6.0000000000000001E-3,9.7004999999999999,15220,0.81,1.0266159066205935,false,257.21289999999999,1,6.5195999999999996,null,211.98,28.9983,27.7119,28.209900000000001,28.896699999999999,29.416,22.794699999999999,12.2965,50.4377,51.344200000000001]
["Battery"]
["BESS 2h"]
[{"$f":"C54&\" \"&D54&\" \"&E54&F54&G54&H54&L54&K54","v":"F - Capital BESS 2h 0.140.0670.5515Battery0.0797"},"2024-2025","F - Capital","BESS 2h",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,15,true,6.0000000000000001E-3,7.9699999999999993E-2,"Battery",null,870.82119999999998,200,200,200,1.0329999999999999,0.19319305701086276,6.7584616137877002E-2,0.1191612148459624,103.7681,78.780500000000004,0.12,6.0000000000000001E-3,17.649999999999999,31541.599999999999,1.22,1.0051974036266236,false,126.49379999999999,0.55420000000000003,5.0757000000000003,null,47.7134,8.9367999999999999,5.4029999999999996,4.0829000000000004,9.9481000000000002,7.5175999999999998,5.1688999999999998,2.7833000000000001,21.485800000000001,16.236499999999999]
["J - New York City BESS 2h 0.140.0670.5515Battery0.0785","2024-2025","J - New York City","BESS 2h",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,15,true,6.0000000000000001E-3,7.85E-2,"Battery",null,1165.4540999999999,200,200,200,1.0669999999999999,0.19319305701086276,6.5062274774774789E-2,0.1209197498118883,140.9264,73.999200000000002,0.18,4.7663999999999998E-2,35.67,11167.9,0.80400000000000005,1.0222742161825833,false,182.77940000000001,0.55930000000000002,6.1829999999999998,null,108.78019999999999,23.963899999999999,13.448700000000001,12.589499999999999,24.5364,22.968800000000002,11.7845,6.3455000000000004,33.8962,31.730499999999999]
["K - Long Island BESS 2h 0.140.0670.5515Battery0.0797","2024-2025","K - Long Island","BESS 2h",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,15,true,6.0000000000000001E-3,7.9699999999999993E-2,"Battery",null,872.78629999999998,200,200,200,1.0720000000000001,0.19319305701086276,6.7584616137877002E-2,0.11916121484596244,104.00230000000001,98.869399999999999,0.18,6.0000000000000001E-3,17.7,5043.3999999999996,1.0529999999999999,1.0376598174380094,false,127.0369,0.52759999999999996,5.3346,null,28.167400000000001,7.6844000000000001,3.8588,4.2046999999999999,7.4631999999999996,8.1320999999999994,3.0514999999999999,1.6431,26.1053,28.4451]
["C - Central BESS 2h 0.140.0670.5515Battery0.0797","2024-2025","C - Central","BESS 2h",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,15,true,6.0000000000000001E-3,7.9699999999999993E-2,"Battery",null,865.45510000000002,200,200,200,1.0329999999999999,0.19319305701086276,6.7584616137877002E-2,0.11916121484596241,103.12869999999999,61.584499999999998,0.12,6.0000000000000001E-3,17.649999999999999,31541.599999999999,1.22,1.0051974036266236,false,125.81359999999999,0.55420000000000003,5.0349000000000004,null,64.229100000000003,12.030200000000001,7.2732000000000001,5.4962,13.391500000000001,10.1198,6.9581,3.7467000000000001,21.3703,16.1492]
["G - Hudson Valley (Rockland) BESS 2h 0.140.0670.5515Battery0.0797","2024-2025","G - Hudson Valley (Rockland)","BESS 2h",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,15,true,6.0000000000000001E-3,7.9699999999999993E-2,"Battery",null,889.45150000000001,200,200,200,1.0580000000000001,0.19319305701086276,6.7584616137877002E-2,0.11916121484596244,105.9881,69.327399999999997,0.15,6.0000000000000001E-3,17.649999999999999,15220,0.81,1.0162229684787722,false,128.85390000000001,0.56159999999999999,5.2157999999999998,null,59.526499999999999,12.9033,7.2306999999999997,6.8734999999999999,13.138,12.489000000000001,6.4486999999999997,3.4723999999999999,23.478000000000002,22.318200000000001]
["G - Hudson Valley (Dutchess) BESS 2h 0.140.0670.5515Battery0.0797","2024-2025","G - Hudson Valley (Dutchess)","BESS 2h",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,15,true,6.0000000000000001E-3,7.9699999999999993E-2,"Battery",null,865.75739999999996,200,200,200,1.0580000000000001,0.19319305701086276,6.7584616137877002E-2,0.11916121484596238,103.1647,70.386099999999999,0.15,6.0000000000000001E-3,17.649999999999999,15220,0.81,1.0162229684787722,false,125.852,0.56159999999999999,5.0373000000000001,null,55.465899999999998,12.023099999999999,6.7374999999999998,6.4047000000000001,12.2418,11.6371,6.0087999999999999,3.2355,22.931000000000001,21.798300000000001]
["BESS 4h"]
[{"$f":"C61&\" \"&D61&\" \"&E61&F61&G61&H61&L61&K61","v":"F - Capital BESS 4h 0.140.0670.5515Battery0.0804"},"2024-2025","F - Capital","BESS 4h",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,15,true,6.0000000000000001E-3,8.0399999999999999E-2,"Battery",null,1359.2619999999999,200,200,200,1.0329999999999999,0.19319305701086276,6.7584616137877002E-2,0.11916121484596238,161.97130000000001,91.808000000000007,0.12,6.0000000000000001E-3,28.95,31541.599999999999,1.22,1.0051974036266236,false,199.6474,0.64470000000000005,8.7261000000000006,null,107.8394,17.363199999999999,12.211499999999999,9.2279999999999998,19.3279,14.6058,11.682600000000001,6.2906000000000004,33.911499999999997,25.626300000000001]
["J - New York City BESS 4h 0.140.0670.5515Battery0.0792","2024-2025","J - New York City","BESS 4h",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,15,true,6.0000000000000001E-3,7.9200000000000007E-2,"Battery",null,1784.6137000000001,200,200,200,1.0669999999999999,0.19319305701086276,6.5062274774774789E-2,0.12091974981188831,215.79499999999999,81.680499999999995,0.18,4.7663999999999998E-2,56.13,11167.9,0.80400000000000005,1.0222742161825833,false,282.74450000000002,0.68840000000000001,10.8195,null,201.06399999999999,35.987099999999998,24.858000000000001,23.2698,36.846800000000002,34.492600000000003,21.7819,11.7287,52.4345,49.084499999999998]
["K - Long Island BESS 4h 0.140.0670.5515Battery0.0804","2024-2025","K - Long Island","BESS 4h",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,15,true,6.0000000000000001E-3,8.0399999999999999E-2,"Battery",null,1379.8329000000001,200,200,200,1.0720000000000001,0.19319305701086276,6.7584616137877002E-2,0.11916121484596241,164.42259999999999,118.5038,0.18,6.0000000000000001E-3,28.95,5043.3999999999996,1.0529999999999999,1.0376598174380094,false,202.49770000000001,0.78939999999999999,9.1250999999999998,null,83.993799999999993,15.315,11.5068,12.5381,14.8741,16.2073,9.0992999999999995,4.8996000000000004,41.612000000000002,45.3416]
["C - Central BESS 4h 0.140.0670.5515Battery0.0804","2024-2025","C - Central","BESS 4h",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,15,true,6.0000000000000001E-3,8.0399999999999999E-2,"Battery",null,1351.548,200,200,200,1.0329999999999999,0.19319305701086276,6.7584616137877002E-2,0.11916121484596243,161.0521,71.678899999999999,0.12,6.0000000000000001E-3,28.95,31541.599999999999,1.22,1.0051974036266236,false,198.6703,0.64470000000000005,8.6682000000000006,null,126.9914,20.4468,14.3802,10.866899999999999,22.7605,17.1997,13.757400000000001,7.4077999999999999,33.7455,25.500900000000001]
["G - Hudson Valley (Rockland) BESS 4h 0.140.0670.5515Battery0.0804","2024-2025","G - Hudson Valley (Rockland)","BESS 4h",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,15,true,6.0000000000000001E-3,8.0399999999999999E-2,"Battery",null,1385.8074999999999,200,200,200,1.0580000000000001,0.19319305701086276,6.7584616137877002E-2,0.11916121484596238,165.1345,77.125900000000001,0.15,6.0000000000000001E-3,28.95,15220,0.81,1.0162229684787722,false,203.0104,0.67949999999999999,8.9259000000000004,null,125.8845,22.552800000000001,15.2913,14.5359,22.963000000000001,21.828700000000001,13.637499999999999,7.3433000000000002,36.989699999999999,35.162500000000001]
["G - Hudson Valley (Dutchess) BESS 4h 0.140.0670.5515Battery0.0804","2024-2025","G - Hudson Valley (Dutchess)","BESS 4h",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,15,true,6.0000000000000001E-3,8.0399999999999999E-2,"Battery",null,1352.153,200,200,200,1.0580000000000001,0.19319305701086276,6.7584616137877002E-2,0.11916121484596244,161.1242,78.832999999999998,0.15,6.0000000000000001E-3,28.95,15220,0.81,1.0162229684787722,false,198.74690000000001,0.67949999999999999,8.6727000000000007,null,119.9139,21.4831,14.566000000000001,13.846500000000001,21.873899999999999,20.793299999999999,12.9907,6.9950000000000001,36.212899999999998,34.424100000000003]
["BESS 6h"]
[{"$f":"C68&\" \"&D68&\" \"&E68&F68&G68&H68&L68&K68","v":"F - Capital BESS 6h 0.140.0670.5515Battery0.0947"},"2024-2025","F - Capital","BESS 6h",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,15,true,6.0000000000000001E-3,9.4700000000000006E-2,"Battery",null,1905.7248999999999,200,200,200,1.0329999999999999,0.18904556726830202,6.7584616137877002E-2,0.11916121484596238,227.08850000000001,97.145899999999997,0.12,6.0000000000000001E-3,40.799999999999997,31541.599999999999,1.22,1.0051974036266236,false,280.51100000000002,0.91769999999999996,12.6225,null,183.36510000000001,20.7408,20.7639,15.690899999999999,23.087700000000002,17.446999999999999,19.8645,10.696300000000001,47.646700000000003,36.005800000000001]
[{"$f":"C69&\" \"&D69&\" \"&E69&F69&G69&H69&L69&K69","v":"J - New York City BESS 6h 0.140.0670.5515Battery0.0932"},"2024-2025","J - New York City","BESS 6h",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,15,true,6.0000000000000001E-3,9.3200000000000005E-2,"Battery",null,2422.482,200,200,200,1.0669999999999999,0.18904556726830202,6.5062274774774789E-2,0.1209197498118883,292.92590000000001,84.515699999999995,0.18,4.7663999999999998E-2,77.14,11167.9,0.80400000000000005,1.0222742161825833,false,385.42469999999997,0.90410000000000001,15.3588,null,300.90899999999999,41.008299999999998,37.202100000000002,34.825200000000002,41.987900000000003,39.305300000000003,32.598500000000001,17.553000000000001,71.476399999999998,66.909700000000001]
["K - Long Island BESS 6h 0.140.0670.5515Battery0.0947","2024-2025","K - Long Island","BESS 6h",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,15,true,6.0000000000000001E-3,9.4700000000000006E-2,"Battery",null,1951.9322,200,200,200,1.0720000000000001,0.18904556726830202,6.7584616137877002E-2,0.11916121484596237,232.59460000000001,128.5496,0.18,6.0000000000000001E-3,40.9,5043.3999999999996,1.0529999999999999,1.0376598174380094,false,286.7045,0.9153,13.209899999999999,null,158.1549,24.8706,21.666499999999999,23.608499999999999,24.154599999999999,26.319600000000001,17.133400000000002,9.2256999999999998,58.915900000000001,64.1965]
["C - Central BESS 6h 0.140.0670.5515Battery0.0947","2024-2025","C - Central","BESS 6h",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,15,true,6.0000000000000001E-3,9.4700000000000006E-2,"Battery",null,1894.7670000000001,200,200,200,1.0329999999999999,0.18904556726830202,6.7584616137877002E-2,0.11916121484596238,225.78270000000001,75.741100000000003,0.12,6.0000000000000001E-3,40.799999999999997,31541.599999999999,1.22,1.0051974036266236,false,279.12389999999999,0.91769999999999996,12.5412,null,203.3828,23.004999999999999,23.0306,17.4038,25.6082,19.351700000000001,22.033100000000001,11.864000000000001,47.411099999999998,35.8277]
["G - Hudson Valley (Rockland) BESS 6h 0.140.0670.5515Battery0.0947","2024-2025","G - Hudson Valley (Rockland)","BESS 6h",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,15,true,6.0000000000000001E-3,9.4700000000000006E-2,"Battery",null,1943.3498,200,200,200,1.0580000000000001,0.18904556726830202,6.7584616137877002E-2,0.11916121484596238,231.5719,80.199399999999997,0.15,6.0000000000000001E-3,40.799999999999997,15220,0.81,1.0162229684787722,false,285.27370000000002,0.91920000000000002,12.9018,null,205.07429999999999,27.159300000000002,24.910499999999999,23.68,27.653300000000002,26.287299999999998,22.2164,11.9627,51.9786,49.411000000000001]
["G - Hudson Valley (Dutchess) BESS 6h 0.140.0670.5515Battery0.0947","2024-2025","G - Hudson Valley (Dutchess)","BESS 6h",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,15,true,6.0000000000000001E-3,9.4700000000000006E-2,"Battery",null,1895.6482000000001,200,200,200,1.0580000000000001,0.18904556726830202,6.7584616137877002E-2,0.1191612148459624,225.8877,83.148700000000005,0.15,6.0000000000000001E-3,40.799999999999997,15220,0.81,1.0162229684787722,false,279.2355,0.91920000000000002,12.547800000000001,null,196.08690000000001,25.969100000000001,23.8188,22.642199999999999,26.441400000000002,25.135200000000001,21.242699999999999,11.4384,50.878399999999999,48.365099999999998]
["BESS 8h"]
[{"$f":"C75&\" \"&D75&\" \"&E75&F75&G75&H75&L75&K75","v":"F - Capital BESS 8h 0.140.0670.5515Battery0.1176"},"2024-2025","F - Capital","BESS 8h",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,15,true,6.0000000000000001E-3,0.1176,"Battery",null,2453.7076000000002,200,200,200,1.0329999999999999,0.18675750296611626,6.7584616137877002E-2,0.11916121484596243,292.38679999999999,97.236500000000007,0.12,6.0000000000000001E-3,51.85,31541.599999999999,1.22,1.0051974036266236,false,360.52589999999998,1,16.289100000000001,null,263.28930000000003,27.330200000000001,29.814299999999999,22.530200000000001,30.422799999999999,22.99,28.523,15.358499999999999,61.2378,46.276299999999999]
[{"$f":"C76&\" \"&D76&\" \"&E76&F76&G76&H76&L76&K76","v":"J - New York City BESS 8h 0.140.0670.5515Battery0.1158"},"2024-2025","J - New York City","BESS 8h",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,15,true,6.0000000000000001E-3,0.1158,"Battery",null,3102.7999,200,200,200,1.0669999999999999,0.18675750296611626,6.5062274774774789E-2,0.1209197498118883,375.18979999999999,85.408500000000004,0.18,4.7663999999999998E-2,97.35,11167.9,0.80400000000000005,1.0222742161825833,false,492.45620000000002,1,19.916399999999999,null,407.04770000000002,50.153199999999998,50.324199999999998,47.109000000000002,51.351300000000002,48.070399999999999,44.096800000000002,23.744499999999999,91.325199999999995,85.490399999999994]
["K - Long Island BESS 8h 0.140.0670.5515Battery0.1176","2024-2025","K - Long Island","BESS 8h",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,15,true,6.0000000000000001E-3,0.1176,"Battery",null,2526.0722000000001,200,200,200,1.0720000000000001,0.18675750296611626,6.7584616137877002E-2,0.1191612148459624,301.00979999999998,132.1712,0.18,6.0000000000000001E-3,52.05,5043.3999999999996,1.0529999999999999,1.0376598174380094,false,370.11930000000001,0.99719999999999998,17.0595,null,237.94810000000001,34.345300000000002,32.597900000000003,35.519599999999997,33.356499999999997,36.346299999999999,25.777699999999999,13.8803,76.057199999999995,82.874099999999999]
["C - Central BESS 8h 0.140.0670.5515Battery0.1176","2024-2025","C - Central","BESS 8h",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,15,true,6.0000000000000001E-3,0.1176,"Battery",null,2439.4693000000002,200,200,200,1.0329999999999999,0.18675750296611626,6.7584616137877002E-2,0.1191612148459624,290.69009999999997,77.411100000000005,0.12,6.0000000000000001E-3,51.85,31541.599999999999,1.22,1.0051974036266236,false,358.72539999999998,1,16.185300000000002,null,281.3143,29.2012,31.855399999999999,24.072600000000001,32.505499999999998,24.5639,30.4757,16.41,60.931899999999999,46.045200000000001]
["G - Hudson Valley (Rockland) BESS 8h 0.140.0670.5515Battery0.1176","2024-2025","G - Hudson Valley (Rockland)","BESS 8h",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,15,true,6.0000000000000001E-3,0.1176,"Battery",null,2502.7981,200,200,200,1.0580000000000001,0.18675750296611626,6.7584616137877002E-2,0.11916121484596238,298.23649999999998,81.238699999999994,0.15,6.0000000000000001E-3,51.85,15220,0.81,1.0162229684787722,false,366.73230000000001,1,16.645800000000001,null,285.49349999999998,34.7547,34.679099999999998,32.966000000000001,35.386899999999997,33.638800000000003,30.9285,16.6538,66.820899999999995,63.520099999999999]
["G - Hudson Valley (Dutchess) BESS 8h 0.140.0670.5515Battery0.1176","2024-2025","G - Hudson Valley (Dutchess)","BESS 8h",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,15,true,6.0000000000000001E-3,0.1176,"Battery",null,2440.5255000000002,200,200,200,1.0580000000000001,0.18675750296611626,6.7584616137877002E-2,0.11916121484596241,290.81599999999997,84.705600000000004,0.15,6.0000000000000001E-3,51.85,15220,0.81,1.0162229684787722,false,358.85910000000001,1,16.193100000000001,null,274.15350000000001,33.374299999999998,33.301600000000001,31.656600000000001,33.981299999999997,32.302700000000002,29.7,15.9923,65.386300000000006,62.156399999999998]
["Fossil 20 Year No NET EAS - Dual Fuel with SCR"]
[{"$f":"C82&\" \"&D82&\" \"&E82&F82&G82&H82&L82&K82","v":"F - Capital SCGT J Class 0.140.0670.5520Dual fuel with SCR0.0926"},"2024-2025","F - Capital","SCGT J Class",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,20,false,6.0000000000000001E-3,9.2600000000000002E-2,"Dual fuel with SCR",null,1656.3476000000001,406.5,431.7,400.3,1.0329999999999999,0.16564133697135192,6.7584616137877002E-2,0.11630622967705023,192.64349999999999,82.56,0.12,6.0000000000000001E-3,8.0264000000000006,31541.599999999999,1.22,1.010402603358687,false,207.54499999999999,1,6.875,null,124.9851,13.4428,14.6206,10.705299999999999,15.245699999999999,11.1629,13.353199999999999,6.8333000000000004,36.417499999999997,26.665099999999999]
["J - New York City SCGT J Class 0.140.0670.5520Dual fuel with SCR0.0912","2024-2025","J - New York City","SCGT J Class",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,20,true,6.0000000000000001E-3,9.1200000000000003E-2,"Dual fuel with SCR",null,1948.4653000000001,404.4,435,404.1,1.0669999999999999,0.16564133697135192,6.5062274774774789E-2,0.12114161288905223,236.0402,68.615099999999998,0.18,4.7663999999999998E-2,27.8842,11167.9,0.80400000000000005,1.0450050537969098,false,272.1035,1,8.1791,null,203.48840000000001,30.561499999999999,29.379300000000001,30.747399999999999,30.635400000000001,32.061900000000001,22.0337,11.614800000000001,58.928800000000003,61.672800000000002]
["K - Long Island SCGT J Class 0.140.0670.5520Dual fuel with SCR0.0926","2024-2025","K - Long Island","SCGT J Class",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,20,false,6.0000000000000001E-3,9.2600000000000002E-2,"Dual fuel with SCR",null,1823.2862,407.1,438.1,404,1.0720000000000001,0.16564133697135192,6.7584616137877002E-2,0.11630622967705023,212.05950000000001,114.92870000000001,0.18,6.0000000000000001E-3,9.8824000000000005,5043.3999999999996,1.0529999999999999,1.0760728312247789,false,229.92349999999999,1,7.9814999999999996,null,114.99469999999999,25.8157,21.533300000000001,43.654600000000002,22.453900000000001,45.521000000000001,12.432700000000001,7.7431999999999999,64.581299999999999,130.9263]
[{"$f":"C85&\" \"&D85&\" \"&E85&F85&G85&H85&L85&K85","v":"C - Central SCGT J Class 0.140.0670.5520Dual fuel with SCR0.0926"},"2024-2025","C - Central","SCGT J Class",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,20,false,6.0000000000000001E-3,9.2600000000000002E-2,"Dual fuel with SCR",null,1677.3581999999999,394.5,419.5,389,1.0329999999999999,0.16564133697135192,6.7584616137877002E-2,0.11630622967705019,195.0872,62.385599999999997,0.12,6.0000000000000001E-3,7.9767999999999999,31541.599999999999,1.22,1.0101089500537828,false,209.99760000000001,1,6.9336000000000002,null,147.6121,15.8386,17.241299999999999,12.590999999999999,17.978400000000001,13.1294,15.7889,8.0678000000000001,36.792099999999998,26.868600000000001]
[{"$f":"C86&\" \"&D86&\" \"&E86&F86&G86&H86&L86&K86","v":"G - Hudson Valley (Rockland) SCGT J Class 0.140.0670.5520Dual fuel with SCR0.0926"},"2024-2025","G - Hudson Valley (Rockland)","SCGT J Class",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,20,false,6.0000000000000001E-3,9.2600000000000002E-2,"Dual fuel with SCR",null,1753.9675999999999,400.9,428.5,397.4,1.0580000000000001,0.16564133697135192,6.7584616137877002E-2,0.1163062296770502,203.9974,58.133699999999997,0.15,6.0000000000000001E-3,9.5444999999999993,15220,0.81,1.0322350383673204,false,221.0085,1,7.4665999999999997,null,162.87469999999999,23.170999999999999,22.3322,23.0899,23.286899999999999,24.077000000000002,17.533000000000001,9.1997999999999998,45.454599999999999,46.9968]
["G - Hudson Valley (Dutchess) SCGT J Class 0.140.0670.5520Dual fuel with SCR0.0926","2024-2025","G - Hudson Valley (Dutchess)","SCGT J Class",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,20,false,6.0000000000000001E-3,9.2600000000000002E-2,"Dual fuel with SCR",null,1658.6194,400.9,428.5,397.4,1.0580000000000001,0.16564133697135192,6.7584616137877002E-2,0.11630622967705022,192.90780000000001,56.598999999999997,0.15,6.0000000000000001E-3,8.6386000000000003,15220,0.81,1.0322350383673204,false,208.51660000000001,1,6.9702000000000002,null,151.91759999999999,21.612200000000001,20.829799999999999,21.5366,21.720300000000002,22.4573,16.3535,8.5808999999999997,42.885399999999997,44.340400000000002]
["Fossil 20 Year No NET EAS - Gas Only with SCR"]
[{"$f":"C89&\" \"&D89&\" \"&E89&F89&G89&H89&L89&K89","v":"F - Capital SCGT J Class 0.140.0670.5520Gas only with SCR0.0926"},"2024-2025","F - Capital","SCGT J Class",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,20,false,6.0000000000000001E-3,9.2600000000000002E-2,"Gas only with SCR",null,1582.9253000000001,406.5,431.7,400.3,1.0329999999999999,0.16564133697135192,6.7584616137877002E-2,0.11630622967705016,184.10409999999999,82.037000000000006,0.12,6.0000000000000001E-3,8.0264000000000006,31541.599999999999,1.22,1.010402603358687,false,198.60239999999999,1,6.4718,null,116.5654,12.5372,13.6357,9.9840999999999998,14.2186,10.4109,12.4536,6.3730000000000002,34.848399999999998,25.516100000000002]
["C - Central SCGT J Class 0.140.0670.5520Gas only with SCR0.0926","2024-2025","C - Central","SCGT J Class",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,20,false,6.0000000000000001E-3,9.2600000000000002E-2,"Gas only with SCR",null,1601.8031000000001,394.5,419.5,389,1.0329999999999999,0.16564133697135192,6.7584616137877002E-2,0.11630622967705023,186.2997,62.385599999999997,0.12,6.0000000000000001E-3,7.9767999999999999,31541.599999999999,1.22,1.0101089500537828,false,200.79519999999999,1,6.5186999999999999,null,138.40969999999999,14.8512,16.166499999999999,11.806100000000001,16.857600000000001,12.3108,14.804600000000001,7.5648999999999997,35.1798,25.691199999999998]
["G - Hudson Valley (Rockland) SCGT J Class 0.140.0670.5520Gas only with SCR0.0926","2024-2025","G - Hudson Valley (Rockland)","SCGT J Class",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,20,false,6.0000000000000001E-3,9.2600000000000002E-2,"Gas only with SCR",null,1680.0094999999999,400.9,428.5,397.4,1.0580000000000001,0.16564133697135192,6.7584616137877002E-2,0.11630622967705023,195.3956,51.3095,0.15,6.0000000000000001E-3,9.5444999999999993,15220,0.81,1.0322350383673204,false,212.00049999999999,1,7.0605000000000002,null,160.69110000000001,22.860299999999999,22.032800000000002,22.7803,22.974699999999999,23.754200000000001,17.297899999999998,9.0763999999999996,43.601900000000001,45.081299999999999]
["G - Hudson Valley (Dutchess) SCGT J Class 0.140.0670.5520Gas only with SCR0.0926","2024-2025","G - Hudson Valley (Dutchess)","SCGT J Class",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,20,false,6.0000000000000001E-3,9.2600000000000002E-2,"Gas only with SCR",null,1584.6613,400.9,428.5,397.4,1.0580000000000001,0.16564133697135192,6.7584616137877002E-2,0.11630622967705023,184.30600000000001,50.239400000000003,0.15,6.0000000000000001E-3,8.6386000000000003,15220,0.81,1.0322350383673204,false,199.5087,1,6.5640999999999998,null,149.26929999999999,21.235399999999998,20.466699999999999,21.161100000000001,21.341699999999999,22.065799999999999,16.0684,8.4313000000000002,41.032699999999998,42.424900000000001]
["Fossil 20 Year NO NET EAS - Dual Fuel without SCR"]
[{"$f":"C94&\" \"&D94&\" \"&E94&F94&G94&H94&L94&K94","v":"F - Capital SCGT 7HA.02 0.140.0670.5520Dual fuel without SCR0.0926"},"2024-2025","F - Capital","SCGT 7HA.02",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,20,false,6.0000000000000001E-3,9.2600000000000002E-2,"Dual fuel without SCR",null,1737.6976999999999,335.79449,363.72214000000002,330.68230999999997,1.0329999999999999,0.16564133697135192,6.7584616137877002E-2,0.11630622967705023,202.10509999999999,62.410800000000002,0.12,6.0000000000000001E-3,9.6255000000000006,31541.599999999999,1.22,1.0085934471862712,false,218.661,1,6.9303999999999997,null,156.2501,16.3446,17.976600000000001,12.823,18.745200000000001,13.3712,16.689299999999999,8.3783999999999992,37.735599999999998,26.917300000000001]
["C - Central SCGT 7HA.02 0.140.0670.5520Dual fuel without SCR0.0926","2024-2025","C - Central","SCGT 7HA.02",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,20,false,6.0000000000000001E-3,9.2600000000000002E-2,"Dual fuel without SCR",null,1760.4954,325.66480000000001,352.17240000000004,321.02596999999997,1.0329999999999999,0.16564133697135192,6.7584616137877002E-2,0.11630622967705022,204.75659999999999,56.158499999999997,0.12,6.0000000000000001E-3,9.6035000000000004,31541.599999999999,1.22,1.0083425077035917,false,221.34549999999999,1,6.9854000000000003,null,165.18709999999999,17.262899999999998,18.978899999999999,13.5398,19.790299999999998,14.118600000000001,17.659400000000002,8.875,38.146599999999999,27.214300000000001]
[{"$f":"C96&\" \"&D96&\" \"&E96&F96&G96&H96&L96&K96","v":"G - Hudson Valley (Dutchess) SCGT 7HA.02 0.140.0670.5520Dual fuel without SCR0.0926"},"2024-2025","G - Hudson Valley (Dutchess)","SCGT 7HA.02",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,20,false,6.0000000000000001E-3,9.2600000000000002E-2,"Dual fuel without SCR",null,1734.0558000000001,331.25033000000002,331.25033000000002,328.12621999999999,1.0580000000000001,0.16564133697135192,6.7584616137877002E-2,0.11630622967705023,201.6815,54.777099999999997,0.15,6.0000000000000001E-3,9.7004999999999999,15220,0.81,1.0266159066205935,false,218.39340000000001,1,7.0114000000000001,null,163.6163,22.382300000000001,21.389399999999998,21.773800000000001,22.303799999999999,22.704699999999999,17.594100000000001,9.4910999999999994,42.825499999999998,43.595100000000002]
["Fossil 20 Year NO NET EAS - Gas Only without SCR"]
[{"$f":"C98&\" \"&D98&\" \"&E98&F98&G98&H98&L98&K98","v":"F - Capital SCGT 7HA.02 0.140.0670.5520Gas only without SCR0.0926"},"2024-2025","F - Capital","SCGT 7HA.02",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,20,false,6.0000000000000001E-3,9.2600000000000002E-2,"Gas only without SCR",null,1648.818,335.79449,363.72214000000002,330.68230999999997,1.0329999999999999,0.16564133697135192,6.7584616137877002E-2,0.11630622967705019,191.76779999999999,54.001399999999997,0.12,6.0000000000000001E-3,9.6255000000000006,31541.599999999999,1.22,1.0085934471862712,false,207.8356,1,6.4423000000000004,null,153.83420000000001,16.091899999999999,17.698699999999999,12.624700000000001,18.455400000000001,13.1645,16.4313,8.2487999999999992,35.867400000000004,25.584700000000002]
["C - Central SCGT 7HA.02 0.140.0670.5520Gas only without SCR0.0926","2024-2025","C - Central","SCGT 7HA.02",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,20,false,6.0000000000000001E-3,9.2600000000000002E-2,"Gas only without SCR",null,1668.9422999999999,325.66480000000001,352.17240000000004,321.02596999999997,1.0329999999999999,0.16564133697135192,6.7584616137877002E-2,0.11630622967705025,194.10839999999999,48.109499999999997,0.12,6.0000000000000001E-3,9.6035000000000004,31541.599999999999,1.22,1.0083425077035917,false,210.19460000000001,1,6.4827000000000004,null,162.08510000000001,16.938700000000001,18.622499999999999,13.285500000000001,19.418600000000001,13.8535,17.3278,8.7083999999999993,36.224899999999998,25.843299999999999]
[{"$f":"C100&\" \"&D100&\" \"&E100&F100&G100&H100&L100&K100","v":"G - Hudson Valley (Dutchess) SCGT 7HA.02 0.140.0670.5520Gas only without SCR0.0926"},"2024-2025","G - Hudson Valley (Dutchess)","SCGT 7HA.02",0.14000000000000001,6.7000000000000004E-2,0.55000000000000004,20,false,6.0000000000000001E-3,9.2600000000000002E-2,"Gas only without SCR",null,1644.4837,331.25033000000002,331.25033000000002,328.12621999999999,1.0580000000000001,0.16564133697135192,6.7584616137877002E-2,0.11630622967705019,191.2637,38.749699999999997,0.15,6.0000000000000001E-3,9.7004999999999999,15220,0.81,1.0266159066205935,false,207.4837,1,6.5195999999999996,null,168.73400000000001,23.0823,22.058399999999999,22.454799999999999,23.0015,23.4148,18.144400000000001,9.7879000000000005,40.686199999999999,41.417400000000001]

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

{"sheet":"Net EAS","index":6,"n_rows":49,"n_cols":18,"rows_kept":49,"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: ","2024-06-01"]
[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, select between standard results and 5-minute results using the toggle below."]
[]
[]
[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 with SCR","Dual fuel without SCR","Gas only without SCR","Battery"]
[null,"j25",{"$f":"$B14&\"_\"&$I14&\"_\"&\"Yes_No_\"&$H14","v":"j25_C_Yes_No_1"},{"$f":"$B14&\"_\"&$I14&\"_\"&\"Yes_Yes_\"&$H14","v":"j25_C_Yes_Yes_1"},{"$f":"$B14&\"_\"&$I14&\"_\"&\"No_No_\"&$H14","v":"j25_C_No_No_1"},{"$f":"$B14&\"_\"&$I14&\"_\"&\"No_Yes_\"&$H14","v":"j25_C_No_Yes_1"},{"$f":"$B14&\"_\"&$I14","v":"j25_C"},1,"C",{"$f":"K14&L14&M14","v":"C - CentralSCGT J Class2024-2025"},"C - Central","SCGT J Class","2024-2025",64.18560639960883,64.185606399608801,"-","-","-"]
[null,"j25","j25_F_Yes_No_1","j25_F_Yes_Yes_1","j25_F_No_No_1","j25_F_No_Yes_1","j25_F",1,"F","F - CapitalSCGT J Class2024-2025","F - Capital","SCGT J Class","2024-2025",85.744109753531291,85.185221912602884,"-","-","-"]
[null,"j25","j25_G1_Yes_No_1","j25_G1_Yes_Yes_1","j25_G1_No_No_1","j25_G1_No_Yes_1","j25_G1",1,"G1","G - Hudson Valley (Dutchess)SCGT J Class2024-2025","G - Hudson Valley (Dutchess)","SCGT J Class","2024-2025",58.002041423674967,51.206147510097303,"-","-","-"]
[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":"K17&L17&M17","v":"G - Hudson Valley (Rockland)SCGT J Class2024-2025"},"G - Hudson Valley (Rockland)","SCGT J Class","2024-2025",59.642087397739481,52.349651750055273,"-","-","-"]
[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":"K18&L18&M18","v":"J - New York CitySCGT J Class2024-2025"},"J - New York City","SCGT J Class","2024-2025",71.120876050925943,"-","-","-","-"]
[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 IslandSCGT J Class2024-2025","K - Long Island","SCGT J Class","2024-2025",120.3335929912476,"-","-","-","-"]
[null,"7ha02","7ha02_K_Yes_No_1","7ha02_K_Yes_Yes_1","7ha02_K_No_No_1","7ha02_K_No_Yes_1","7ha02_K",1,"K",{"$f":"K20&L20&M20","v":"C - CentralSCGT 7HA.022024-2025"},"C - Central","SCGT 7HA.02","2024-2025","-","-",48.930072344558653,48.930072344558702,"-"]
[null,"7ha02","7ha02_K_Yes_No_1","7ha02_K_Yes_Yes_1","7ha02_K_No_No_1","7ha02_K_No_Yes_1","7ha02_K",1,"K","F - CapitalSCGT 7HA.022024-2025","F - Capital","SCGT 7HA.02","2024-2025","-","-",54.653782375025692,55.226243939499007,"-"]
[null,"7ha02","7ha02_K_Yes_No_1","7ha02_K_Yes_Yes_1","7ha02_K_No_No_1","7ha02_K_No_Yes_1","7ha02_K",1,"K","G - Hudson Valley (Dutchess)SCGT 7HA.022024-2025","G - Hudson Valley (Dutchess)","SCGT 7HA.02","2024-2025","-","-",47.665476340592811,38.928234343714273,"-"]
[null,"7ha02","7ha02_K_Yes_No_1","7ha02_K_Yes_Yes_1","7ha02_K_No_No_1","7ha02_K_No_Yes_1","7ha02_K",1,"K","G - Hudson Valley (Rockland)SCGT 7HA.022024-2025","G - Hudson Valley (Rockland)","SCGT 7HA.02","2024-2025","-","-","-","-","-"]
[null,"7ha02","7ha02_K_Yes_No_1","7ha02_K_Yes_Yes_1","7ha02_K_No_No_1","7ha02_K_No_Yes_1","7ha02_K",1,"K","J - New York CitySCGT 7HA.022024-2025","J - New York City","SCGT 7HA.02","2024-2025","-","-","-","-","-"]
[null,"7ha02","7ha02_K_Yes_No_1","7ha02_K_Yes_Yes_1","7ha02_K_No_No_1","7ha02_K_No_Yes_1","7ha02_K",1,"K","K - Long IslandSCGT 7HA.022024-2025","K - Long Island","SCGT 7HA.02","2024-2025","-","-","-","-","-"]
[null,"bat2","bat2_C_Yes_No_1","bat2_C_Yes_Yes_1","bat2_C_No_No_1","bat2_C_No_Yes_1","bat2_C",1,"C","C - CentralBESS 2h2024-2025","C - Central","BESS 2h","2024-2025","-","-","-","-",53.897332074523888]
[null,"bat2","bat2_F_Yes_No_1","bat2_F_Yes_Yes_1","bat2_F_No_No_1","bat2_F_No_Yes_1","bat2_F",1,"F","F - CapitalBESS 2h2024-2025","F - Capital","BESS 2h","2024-2025","-","-","-","-",69.639286260309675]
[null,"bat2","bat2_G1_Yes_No_1","bat2_G1_Yes_Yes_1","bat2_G1_No_No_1","bat2_G1_No_Yes_1","bat2_G1",1,"G1","G - Hudson Valley (Dutchess)BESS 2h2024-2025","G - Hudson Valley (Dutchess)","BESS 2h","2024-2025","-","-","-","-",61.954719220666497]
[null,"bat2","bat2_G2_Yes_No_1","bat2_G2_Yes_Yes_1","bat2_G2_No_No_1","bat2_G2_No_Yes_1","bat2_G2",1,"G2","G - Hudson Valley (Rockland)BESS 2h2024-2025","G - Hudson Valley (Rockland)","BESS 2h","2024-2025","-","-","-","-",60.98553554652559]
[null,"bat2","bat2_J_Yes_No_1","bat2_J_Yes_Yes_1","bat2_J_No_No_1","bat2_J_No_Yes_1","bat2_J",1,"J","J - New York CityBESS 2h2024-2025","J - New York City","BESS 2h","2024-2025","-","-","-","-",65.262336911704637]
[null,"bat2","bat2_K_Yes_No_1","bat2_K_Yes_Yes_1","bat2_K_No_No_1","bat2_K_No_Yes_1","bat2_K",1,"K","K - Long IslandBESS 2h2024-2025","K - Long Island","BESS 2h","2024-2025","-","-","-","-",88.029684524670884]
[null,"bat4","bat4_C_Yes_No_1","bat4_C_Yes_Yes_1","bat4_C_No_No_1","bat4_C_No_Yes_1","bat4_C",1,"C",{"$f":"K32&L32&M32","v":"C - CentralBESS 4h2024-2025"},"C - Central","BESS 4h","2024-2025","-","-","-","-",63.138211267542957]
[null,"bat4","bat4_F_Yes_No_1","bat4_F_Yes_Yes_1","bat4_F_No_No_1","bat4_F_No_Yes_1","bat4_F",1,"F","F - CapitalBESS 4h2024-2025","F - Capital","BESS 4h","2024-2025","-","-","-","-",81.565282534225616]
[null,"bat4","bat4_G1_Yes_No_1","bat4_G1_Yes_Yes_1","bat4_G1_No_No_1","bat4_G1_No_Yes_1","bat4_G1",1,"G1","G - Hudson Valley (Dutchess)BESS 4h2024-2025","G - Hudson Valley (Dutchess)","BESS 4h","2024-2025","-","-","-","-",69.687427989708127]
[null,"bat4","bat4_G2_Yes_No_1","bat4_G2_Yes_Yes_1","bat4_G2_No_No_1","bat4_G2_No_Yes_1","bat4_G2",1,"G2",{"$f":"K35&L35&M35","v":"G - Hudson Valley (Rockland)BESS 4h2024-2025"},"G - Hudson Valley (Rockland)","BESS 4h","2024-2025","-","-","-","-",68.124628646937083]
[null,"bat4","bat4_J_Yes_No_1","bat4_J_Yes_Yes_1","bat4_J_No_No_1","bat4_J_No_Yes_1","bat4_J",1,"J",{"$f":"K36&L36&M36","v":"J - New York CityBESS 4h2024-2025"},"J - New York City","BESS 4h","2024-2025","-","-","-","-",72.294121327763122]
[null,"bat4","bat4_K_Yes_No_1","bat4_K_Yes_Yes_1","bat4_K_No_No_1","bat4_K_No_Yes_1","bat4_K",1,"K","K - Long IslandBESS 4h2024-2025","K - Long Island","BESS 4h","2024-2025","-","-","-","-",106.0038982333067]
[null,"bat6","bat6_C_Yes_No_1","bat6_C_Yes_Yes_1","bat6_C_No_No_1","bat6_C_No_Yes_1","bat6_C",1,{"$f":"LEFT(K38,1)","v":"C"},{"$f":"K38&L38&M38","v":"C - CentralBESS 6h2024-2025"},"C - Central","BESS 6h","2024-2025","-","-","-","-",66.856907860823483]
[null,"bat6","bat6_F_Yes_No_1","bat6_F_Yes_Yes_1","bat6_F_No_No_1","bat6_F_No_Yes_1","bat6_F",1,{"$f":"LEFT(K39,1)","v":"F"},"F - CapitalBESS 6h2024-2025","F - Capital","BESS 6h","2024-2025","-","-","-","-",86.45189119428295]
[null,"bat6","bat6_G1_Yes_No_1","bat6_G1_Yes_Yes_1","bat6_G1_No_No_1","bat6_G1_No_Yes_1","bat6_G1",1,"G1","G - Hudson Valley (Dutchess)BESS 6h2024-2025","G - Hudson Valley (Dutchess)","BESS 6h","2024-2025","-","-","-","-",73.638153379245381]
[null,"bat6","bat6_G2_Yes_No_1","bat6_G2_Yes_Yes_1","bat6_G2_No_No_1","bat6_G2_No_Yes_1","bat6_G2",1,"G2",{"$f":"K41&L41&M41","v":"G - Hudson Valley (Rockland)BESS 6h2024-2025"},"G - Hudson Valley (Rockland)","BESS 6h","2024-2025","-","-","-","-",70.938281326094398]
[null,"bat6","bat6_J_Yes_No_1","bat6_J_Yes_Yes_1","bat6_J_No_No_1","bat6_J_No_Yes_1","bat6_J",1,{"$f":"LEFT(K42,1)","v":"J"},{"$f":"K42&L42&M42","v":"J - New York CityBESS 6h2024-2025"},"J - New York City","BESS 6h","2024-2025","-","-","-","-",74.889578117251006]
[null,"bat6","bat6_K_Yes_No_1","bat6_K_Yes_Yes_1","bat6_K_No_No_1","bat6_K_No_Yes_1","bat6_K",1,{"$f":"LEFT(K43,1)","v":"K"},"K - Long IslandBESS 6h2024-2025","K - Long Island","BESS 6h","2024-2025","-","-","-","-",115.2003022099851]
[null,"bat8","bat8_C_Yes_No_1","bat8_C_Yes_Yes_1","bat8_C_No_No_1","bat8_C_No_Yes_1","bat8_C",1,{"$f":"LEFT(K44,1)","v":"C"},"C - CentralBESS 8h2024-2025","C - Central","BESS 8h","2024-2025","-","-","-","-",68.385731382243591]
[null,"bat8","bat8_F_Yes_No_1","bat8_F_Yes_Yes_1","bat8_F_No_No_1","bat8_F_No_Yes_1","bat8_F",1,{"$f":"LEFT(K45,1)","v":"F"},"F - CapitalBESS 8h2024-2025","F - Capital","BESS 8h","2024-2025","-","-","-","-",86.534839552702636]
[null,"bat8","bat8_G1_Yes_No_1","bat8_G1_Yes_Yes_1","bat8_G1_No_No_1","bat8_G1_No_Yes_1","bat8_G1",1,"G1","G - Hudson Valley (Dutchess)BESS 8h2024-2025","G - Hudson Valley (Dutchess)","BESS 8h","2024-2025","-","-","-","-",75.063426466872286]
[null,"bat8","bat8_G2_Yes_No_1","bat8_G2_Yes_Yes_1","bat8_G2_No_No_1","bat8_G2_No_Yes_1","bat8_G2",1,"G2",{"$f":"K47&L47&M47","v":"G - Hudson Valley (Rockland)BESS 8h2024-2025"},"G - Hudson Valley (Rockland)","BESS 8h","2024-2025","-","-","-","-",71.889708900711767]
[null,"bat8","bat8_J_Yes_No_1","bat8_J_Yes_Yes_1","bat8_J_No_No_1","bat8_J_No_Yes_1","bat8_J",1,{"$f":"LEFT(K48,1)","v":"J"},{"$f":"K48&L48&M48","v":"J - New York CityBESS 8h2024-2025"},"J - New York City","BESS 8h","2024-2025","-","-","-","-",75.706863251401359]
[null,"bat8","bat8_K_Yes_No_1","bat8_K_Yes_Yes_1","bat8_K_No_No_1","bat8_K_No_Yes_1","bat8_K",1,{"$f":"LEFT(K49,1)","v":"K"},"K - Long IslandBESS 8h2024-2025","K - Long Island","BESS 8h","2024-2025","-","-","-","-",118.51564754026479]

{"sheet":"Escalation Factor","index":7,"n_rows":223,"n_cols":21,"rows_kept":223,"cut":false,"hidden":false,"merged":[[83,3,83,7],[1,3,1,4],[79,3,79,4],[80,3,80,7],[81,3,81,7],[82,3,82,7],[23,2,24,3],[174,3,174,7],[107,3,107,5],[108,3,108,7],[109,3,109,7],[110,3,110,7],[111,3,111,7],[112,3,112,7],[113,3,113,7],[114,3,114,7],[171,3,171,7],[172,3,172,7],[173,3,173,7],[142,3,142,7]]}
[null,null,"Project: ","NYISO ICAP Demand Curve "]
[null,null,"Date: ","2024-06-01"]
[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":"C - Central"}]
[null,null,"Technology:",{"$f":"Unit","v":"SCGT J Class"}]
[null,null,"Capability Year:",{"$f":"Capability_Year","v":"2024-2025"},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 or Battery Cost","GDP Deflator"]
[{"$f":"IF(Capability_Year=\"2021-2022\",2018,2020)","v":2020},null,"Base Year","[A]",{"$f":"INDEX($C$119:$S$134, MATCH(A19-1, $C$119:$C$134, 0), MATCH(\"Construction Labor Cost\", $C$119:$S$119, 0))","v":107893},{"$f":"INDEX($C$88:$S$102, MATCH(A19, $C$88:$C$102, 0), MATCH(\"Materials Index\", $C$88:$S$88, 0))","v":253.33333333333334},{"$f":"IF(LEFT(Unit,4)=\"BESS\",INDEX($C$150:$S$164, MATCH($A$19, $C$150:$C$164, 0), MATCH(\"Battery Index\",$C$150:$S$150, 0)),INDEX($C$179:$S$193, MATCH($A$19, $C$179:$C$193, 0), MATCH(\"Turbine Index\", $C$179:$S$179, 0)))","v":238.73333333333335},{"$f":"INDEX($C$209:$S$223, MATCH(A19, $C$209:$C$223, 0), MATCH(\"GDP Deflator\", $C$209:$S$209, 0))","v":106.27500000000001}]
["Lookup year:",null,"Escalation Year","[B]",{"$f":"INDEX($C$119:$S$134, MATCH(A21-1, $C$119:$C$134, 0), MATCH(\"Construction Labor Cost\", $C$119:$S$119, 0))","v":112634},{"$f":"INDEX($C$88:$S$102, MATCH(A21, $C$88:$C$102, 0), MATCH(\"Materials Index\", $C$88:$S$88, 0))","v":350.71033333333338},{"$f":"IF(LEFT(Unit,4)=\"BESS\",INDEX($C$150:$S$164, MATCH($A$21, $C$150:$C$164, 0), MATCH(\"Battery Index\",$C$150:$S$150, 0)),INDEX($C$179:$S$193, MATCH($A$21, $C$179:$C$193, 0), MATCH(\"Turbine Index\", $C$179:$S$179, 0)))","v":263.31400000000002},{"$f":"INDEX($C$209:$S$223, MATCH(A21, $C$209:$C$223, 0), MATCH(\"GDP Deflator\", $C$209:$S$209, 0))","v":123.271}]
[{"$f":"VALUE(LEFT(Capability_Year,4))-1","v":2023},null,"Growth Rate","[B]/[A]-1",{"$f":"IF(Capability_Year=\"2021-2022\",((E20/E19)^(5/8))-1,(E20/E19)-1)","v":4.3941682963676953E-2},{"$f":"F20/F19-1","v":0.38438289473684217},0.10296285953644246,0.15992472359444831,"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$69, MATCH(Unit, $C$62:$C$69, 0), MATCH(E$18, $C$62:$G$62, 0))","v":0.27256453923209478},{"$f":"INDEX($C$62:$G$69, MATCH(Unit, $C$62:$C$69, 0), MATCH(F$18, $C$62:$G$62, 0))","v":0.23130801547987129},{"$f":"INDEX($C$62:$G$69, MATCH(Unit, $C$62:$C$69, 0), MATCH(G$18, $C$62:$G$62, 0))","v":0.25612744528803388},{"$f":"INDEX($C$62:$G$69, MATCH(Unit, $C$62:$C$69, 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.39% + 23%*38.44% + 26%*10.30% + 24%*15.99% ="}]
[null,null,null,null,{"$f":"IFERROR(E21*E22+F21*F22+G21*G22+H21*H22, \"-\")","v":0.16564133697135192}]
[]
[{"$f":"A21-1","v":2022},null,{"$f":"\"Previous Year\n(Q2 \"&A27&\")\"","v":"Previous Year\n(Q2 2022)"},{"$f":"INDEX($C$209:$E$223, MATCH(A27, $C$209:$C$223, 0), MATCH(\"II\", $C$209:$E$209, 0))","v":117.67100000000001}]
[null,null,{"$f":"\"Current Year\n(Q2 \"&A21&\")\"","v":"Current Year\n(Q2 2023)"},{"$f":"INDEX($C$209:$E$223, MATCH(A21, $C$209:$C$223, 0), MATCH(\"II\", $C$209:$E$209, 0))","v":121.76600000000001}]
[null,null,"Annual GDP Deflator Growth Rate",{"$f":"(D28/D27)-1","v":3.4800418114913523E-2},"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",null,null,"SCGT J Class","SCGT 7HA.02","BESS 2h","BESS 4h","BESS 6h","BESS 8h"]
[null,null,"2021-2022",null,null,{"$f":"IFERROR((($D51/$D$49)^(5/8)-1)*$D$64+($E51/$E$49-1)*$E$64+($F51/$F$49-1)*$F$64+(($H51/$H$49)-1)*$G$64, \"-\")","v":3.4136319892625562E-2},{"$f":"IFERROR((($D51/$D$49)^(5/8)-1)*$D$64+($E51/$E$49-1)*$E$64+($F51/$F$49-1)*$F$64+(($H51/$H$49)-1)*$G$64, \"-\")","v":3.4136319892625562E-2},{"$f":"IFERROR((($D51/$D$49)^(5/8)-1)*$D$66+($E51/$E$49-1)*$E$66+($G51/$G$49-1)*$F$66+(($H51/$H$49)-1)*$G$66, \"-\")","v":1.0971997109608358E-2},{"$f":"IFERROR((($D51/$D$49)^(5/8)-1)*$D$67+($E51/$E$49-1)*$E$67+($G51/$G$49-1)*$F$67+(($H51/$H$49)-1)*$G$67, \"-\")","v":1.0971997109608358E-2},{"$f":"IFERROR((($D51/$D$49)^(5/8)-1)*$D$68+($E51/$E$49-1)*$E$68+($G51/$G$49-1)*$F$68+(($H51/$H$49)-1)*$G$68, \"-\")","v":1.0424130797276917E-2},{"$f":"IFERROR((($D51/$D$49)^(5/8)-1)*$D$69+($E51/$E$49-1)*$E$69+($G51/$G$49-1)*$F$69+(($H51/$H$49)-1)*$G$69, \"-\")","v":1.0132417978387855E-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",null,null,{"$f":"IFERROR(($D52/$D$51-1)*$D$64+($E52/$E$51-1)*$E$64+($F52/$F$51-1)*$F$64+(($H52/$H$51)-1)*$G$64, \"-\")","v":3.9794604500737296E-2},3.9794604500737296E-2,{"$f":"IFERROR(($D52/$D$51-1)*$D$66+($E52/$E$51-1)*$E$66+($G52/$G$51-1)*$F$66+(($H52/$H$51)-1)*$G$66, \"-\")","v":2.1372310470776673E-2},{"$f":"IFERROR(($D52/$D$51-1)*$D$67+($E52/$E$51-1)*$E$67+($G52/$G$51-1)*$F$67+(($H52/$H$51)-1)*$G$67, \"-\")","v":2.1372310470776673E-2},{"$f":"IFERROR(($D52/$D$51-1)*$D$68+($E52/$E$51-1)*$E$68+($G52/$G$51-1)*$F$68+(($H52/$H$51)-1)*$G$68, \"-\")","v":1.8629346159403374E-2},{"$f":"IFERROR(($D52/$D$51-1)*$D$69+($E52/$E$51-1)*$E$69+($G52/$G$51-1)*$F$69+(($H52/$H$51)-1)*$G$69, \"-\")","v":1.7137870486359369E-2}]
[null,null,"2023-2024",null,null,0.13028643921252059,0.13028643921252059,{"$f":"IFERROR(($D53/$D$51-1)*$D$66+($E53/$E$51-1)*$E$66+($G53/$G$51-1)*$F$66+(($H53/$H$51)-1)*$G$66, \"-\")","v":0.14184437531762706},{"$f":"IFERROR(($D53/$D$51-1)*$D$67+($E53/$E$51-1)*$E$67+($G53/$G$51-1)*$F$67+(($H53/$H$51)-1)*$G$67, \"-\")","v":0.14184437531762706},{"$f":"IFERROR(($D53/$D$51-1)*$D$68+($E53/$E$51-1)*$E$68+($G53/$G$51-1)*$F$68+(($H53/$H$51)-1)*$G$68, \"-\")","v":0.13654120371243444},{"$f":"IFERROR(($D53/$D$51-1)*$D$69+($E53/$E$51-1)*$E$69+($G53/$G$51-1)*$F$69+(($H53/$H$51)-1)*$G$69, \"-\")","v":0.13362711992770937}]
[null,null,"2024-2025",null,null,0.16564133697135192,0.16564133697135192,{"$f":"IFERROR(($D54/$D$51-1)*$D$66+($E54/$E$51-1)*$E$66+($G54/$G$51-1)*$F$66+(($H54/$H$51)-1)*$G$66, \"-\")","v":0.19319305701086276},{"$f":"IFERROR(($D54/$D$51-1)*$D$67+($E54/$E$51-1)*$E$67+($G54/$G$51-1)*$F$67+(($H54/$H$51)-1)*$G$67, \"-\")","v":0.19319305701086276},{"$f":"IFERROR(($D54/$D$51-1)*$D$68+($E54/$E$51-1)*$E$68+($G54/$G$51-1)*$F$68+(($H54/$H$51)-1)*$G$68, \"-\")","v":0.18904556726830202},{"$f":"IFERROR(($D54/$D$51-1)*$D$69+($E54/$E$51-1)*$E$69+($G54/$G$51-1)*$F$69+(($H54/$H$51)-1)*$G$69, \"-\")","v":0.18675750296611626}]
[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","Storage Battery Cost","GDP Deflator"]
[2018,null,"2019-2020",{"$f":"INDEX($C$119:$S$134, MATCH(A49-1, $C$119:$C$134, 0), MATCH(\"Construction Labor Cost\", $C$119:$S$119, 0))","v":101108},{"$f":"INDEX($C$88:$S$102, MATCH(A49, $C$88:$C$102, 0), MATCH(\"Materials Index\", $C$88:$S$88, 0))","v":249.83333333333334},{"$f":"INDEX($C$179:$S$195, MATCH(A49, $C$179:$C$195, 0), MATCH(\"Turbine Index\", $C$179:$S$179, 0))","v":228.03333333333333},{"$f":"INDEX($C$150:$S$165, MATCH(A49,$C$150:$C$165, 0), MATCH(\"Battery Index\", $C$150:$S$150, 0))","v":205.83333333333334},{"$f":"INDEX($C$209:$S$224, MATCH(A49, $C$209:$C$224, 0), MATCH(\"GDP Deflator\", $C$209:$S$209, 0))","v":103.01900000000001},"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$179:$S$195, MATCH(A50, $C$179:$C$195, 0), MATCH(\"Turbine Index\", $C$179:$S$179, 0))","v":231.23333333333335},{"$f":"INDEX($C$150:$S$165, MATCH(A50,$C$150:$C$165, 0), MATCH(\"Battery Index\", $C$150:$S$150, 0))","v":203.93333333333331},{"$f":"INDEX($C$209:$S$224, MATCH(A50, $C$209:$C$224, 0), MATCH(\"GDP Deflator\", $C$209:$S$209, 0))","v":104.541}]
[2020,null,"2021-2022",107893,253.33333333333334,{"$f":"INDEX($C$179:$S$195, MATCH(A51, $C$179:$C$195, 0), MATCH(\"Turbine Index\", $C$179:$S$179, 0))","v":238.73333333333335},{"$f":"INDEX($C$150:$S$165, MATCH(A51,$C$150:$C$165, 0), MATCH(\"Battery Index\", $C$150:$S$150, 0))","v":204.79999999999998},{"$f":"INDEX($C$209:$S$224, MATCH(A51, $C$209:$C$224, 0), MATCH(\"GDP Deflator\", $C$209:$S$209, 0))","v":106.27500000000001}]
[2021,null,"2022-2023",105547,280.76666666666671,{"$f":"INDEX($C$179:$S$195, MATCH(A52, $C$179:$C$195, 0), MATCH(\"Turbine Index\", $C$179:$S$179, 0))","v":244.16666666666666},{"$f":"INDEX($C$150:$S$165, MATCH(A52,$C$150:$C$165, 0), MATCH(\"Battery Index\", $C$150:$S$150, 0))","v":203.83333333333334},{"$f":"INDEX($C$209:$S$224, MATCH(A52, $C$209:$C$224, 0), MATCH(\"GDP Deflator\", $C$209:$S$209, 0))","v":112.848}]
[2022,null,"2023-2024",106961,345.52033333333338,{"$f":"INDEX($C$179:$S$193, MATCH(A53, $C$179:$C$193, 0), MATCH(\"Turbine Index\", $C$179:$S$179, 0))","v":254.82466666666664},{"$f":"INDEX($C$150:$S$164, MATCH(A53,$C$150:$C$164, 0), MATCH(\"Battery Index\", $C$150:$S$150, 0))","v":229.578},{"$f":"INDEX($C$209:$S$223, MATCH(A53, $C$209:$C$223, 0), MATCH(\"GDP Deflator\", $C$209:$S$209, 0))","v":120.093}]
[2023,null,"2024-2025",112634,350.71033333333338,{"$f":"INDEX($C$179:$S$193, MATCH(A54, $C$179:$C$193, 0), MATCH(\"Turbine Index\", $C$179:$S$179, 0))","v":263.31400000000002},{"$f":"INDEX($C$150:$S$164, MATCH(A54,$C$150:$C$164, 0), MATCH(\"Battery Index\", $C$150:$S$150, 0))","v":243.26800000000003},{"$f":"INDEX($C$209:$S$223, MATCH(A54, $C$209:$C$223, 0), MATCH(\"GDP Deflator\", $C$209:$S$209, 0))","v":123.271}]
[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 or Battery Cost","GDP Deflator"]
[]
[null,null,"SCGT J Class",0.27256453923209478,0.23130801547987129,0.25612744528803388,0.2400000000000001]
[null,null,"SCGT 7HA.02",0.27256453923209478,0.23130801547987129,0.25612744528803388,0.2400000000000001]
[null,null,"BESS 2h",0.15530373574212761,0.16297749348590099,0.52671877077197138,0.15500000000000003]
[null,null,"BESS 4h",0.15530373574212761,0.16297749348590099,0.52671877077197138,0.15500000000000003]
[null,null,"BESS 6h",0.1561371729326986,0.14177635175959433,0.55208647530770705,0.15000000000000002]
[null,null,"BESS 8h",0.15660308316812815,0.13012139108102241,0.56577552575084933,0.14750000000000008]
[]
[]
[]
[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:","2010 to 2022"]
[null,null,"Access:","http://data.bls.gov/cgi-bin/dsrv?wp"]
[null,null,"Date Updated:","2024-05-06"]
[]
[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(E89:G89), \"-\")","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,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(N97:O97,D98), \"-\")","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,{"$f":"IFERROR(AVERAGE(E98:G98), \"-\")","v":251.53333333333333}]
[null,null,2020,252.1,252.8,254.3,252.9,252.8,253.8,255.3,258.8,263.2,262.5,261.39999999999998,263.39999999999998,null,null,null,{"$f":"IFERROR(AVERAGE(E99:G99), \"-\")","v":253.33333333333334}]
[null,null,2021,269.10000000000002,273.8,280.39999999999998,288.10000000000002,298.39999999999998,306,306.649,306.39400000000001,307.483,311.36,316.86099999999999,322.95400000000001,null,null,null,{"$f":"IFERROR(AVERAGE(E100:G100), \"-\")","v":280.76666666666671}]
[null,null,2022,334.22500000000002,340.58300000000003,347.214,348.76400000000001,351.75599999999997,351.005,351.767,353.142,351.51499999999999,350.185,348.774,347.45,null,null,null,{"$f":"IFERROR(AVERAGE(E101:G101), \"-\")","v":345.52033333333338}]
[null,null,2023,349.59199999999998,349.62200000000001,351.214,351.29500000000002,350.46100000000001,350.18400000000003,351.34,351.70699999999999,352.32900000000001,351.44299999999998,351.46899999999999,351.81,null,null,null,{"$f":"IFERROR(AVERAGE(E102:G102), \"-\")","v":350.71033333333338}]
[]
[]
[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:","2010 to 2022"]
[null,null,"Access:","http://data.bls.gov/cgi-bin/dsrv?en"]
[null,null,"Date Updated:","2024-05-06"]
[]
[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(D120=\"\", \"-\", D120)","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,105547,null,null,null,null,null,null,null,null,null,null,null,null,null,null,105547]
[null,null,2021,106961,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D131=\"\", \"-\", D131)","v":106961}]
[null,null,2022,112634,null,null,null,null,null,null,null,null,null,null,null,null,null,null,112634]
[null,null,2023,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[]
[]
[]
[]
[null,null,"Storage Battery 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:","(7901) Storage Batteries"]
[null,null,"Series ID:","WPU117901"]
[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:","2024-05-06"]
[]
[null,null,"Year","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec",null,null,null,"Battery Index",null,"Note: Italicized values are preliminary and are subject to revision up to four months after original publication."]
[null,null,2010,167.6,168.4,168.6,169.2,169.4,169.4,166.6,167.6,167.7,168.2,168.2,171.7,null,null,null,{"$f":"IFERROR(AVERAGE(E151:G151), \"-\")","v":168.73333333333332}]
[null,null,2011,173.1,173.6,174.6,175,175.5,176.8,178.7,179.5,179.3,179.9,178.8,178.2,null,null,null,174.4]
[null,null,2012,179.2,179.1,179.3,179.7,183.8,183.4,183.2,183.4,183.6,183.2,183.4,183,null,null,null,179.36666666666665]
[null,null,2013,183,184.3,185.4,185.5,184.6,183.7,183.7,183.7,185.4,185.6,185.1,185.1,null,null,null,185.06666666666669]
[null,null,2014,184,184.4,184.1,184.5,184.5,184.6,184.1,184.6,184.9,184.5,184.5,184.6,null,null,null,184.33333333333334]
[null,null,2015,184.5,184.4,184.5,184,184.2,185.1,185.2,185.2,185.1,185.1,185.1,185,null,null,null,184.29999999999998]
[null,null,2016,184.9,182.3,182.6,182.6,182.6,182.9,182.9,182.9,182.9,183.9,183.9,184.2,null,null,null,182.5]
[null,null,2017,188,188.9,188.9,192.8,192.8,193.2,193.5,194.4,195,196.3,198.5,198.5,null,null,null,190.20000000000002]
[null,null,2018,202.9,203.2,203.5,207.2,208.3,208.5,207.2,207.5,207.8,206.7,206.3,206.3,null,null,null,{"$f":"IFERROR(AVERAGE(N159:O159,D160), \"-\")","v":205.83333333333334},"Note: The 2018 battery index is calculated with values from Nov. 2018-Jan. 2019 because the 2021-2022 capability year escalates costs for five quarters."]
[null,null,2019,204.9,205.1,203.5,203.2,203.2,204.7,204.3,204.3,204.3,205.1,204.6,204.6,null,null,null,{"$f":"IFERROR(AVERAGE(E160:G160), \"-\")","v":203.93333333333331}]
[null,null,2020,205.1,205.2,205.2,204,204.7,204.3,201.9,201.9,201.9,202.7,202.1,202.1,null,null,null,204.79999999999998]
[null,null,2021,202.5,202.6,203.1,205.8,207.2,209.1,211.49700000000001,213.32900000000001,212.84,219.249,219.803,222.32300000000001,null,null,null,203.83333333333334]
[null,null,2022,228.07300000000001,228.57900000000001,229.14099999999999,231.01400000000001,236.27099999999999,239.65700000000001,241.471,241.46100000000001,241.46100000000001,241.624,242.78700000000001,242.922,null,null,null,229.578]
[null,null,2023,242.71600000000001,242.62899999999999,242.41300000000001,244.762,244.762,245.053,244.71799999999999,244.71799999999999,244.71799999999999,244.19200000000001,244.19200000000001,244.19200000000001,null,null,null,243.26800000000003]
[]
[]
[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:","2010 to 2022"]
[null,null,"Access:","http://data.bls.gov/cgi-bin/dsrv?wp"]
[null,null,"Date Updated:","2024-05-06"]
[]
[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(E180:G180), \"-\")","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(N188:O188,D189), \"-\")","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,238.9,239.5,241.3,242,241.4,241.2,241.6,242.3,242.7,null,null,null,238.73333333333335]
[null,null,2021,243.1,243.8,244.2,244.5,247.1,246.7,247.13800000000001,246.82599999999999,248.93199999999999,249.63,250.01499999999999,250.70099999999999,null,null,null,244.16666666666666]
[null,null,2022,253.184,252.358,255.32400000000001,256.79199999999997,257.16899999999998,258.16899999999998,257.38900000000001,255.179,253.476,253.822,254.34700000000001,255.00200000000001,null,null,null,254.82466666666664]
[null,null,2023,255.70099999999999,256.38299999999998,266.49299999999999,267.06599999999997,267.59800000000001,267.02499999999998,263.61700000000002,269.529,270.67200000000003,271.94299999999998,273.18099999999998,273.46699999999998,null,null,null,263.31400000000002]
[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 2017 = 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:","2022-10-13"]
[]
[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,89.036000000000001,89.471000000000004,89.742999999999995,90.263999999999996,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G210=\"\", \"-\", G210)","v":90.263999999999996}]
[null,null,2011,90.725999999999999,91.325999999999993,91.876000000000005,91.984999999999999,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G211=\"\", \"-\", G211)","v":91.984999999999999}]
[null,null,2012,92.525000000000006,92.906999999999996,93.417000000000002,93.885000000000005,null,null,null,null,null,null,null,null,null,null,null,93.885000000000005]
[null,null,2013,94.257999999999996,94.460999999999999,94.924000000000007,95.426000000000002,null,null,null,null,null,null,null,null,null,null,null,95.426000000000002]
[null,null,2014,95.787999999999997,96.33,96.725999999999999,96.822000000000003,null,null,null,null,null,null,null,null,null,null,null,96.822000000000003]
[null,null,2015,96.769000000000005,97.325000000000003,97.582999999999998,97.581000000000003,null,null,null,null,null,null,null,null,null,null,null,97.581000000000003]
[null,null,2016,97.495999999999995,98.159000000000006,98.41,98.885999999999996,null,null,null,null,null,null,null,null,null,null,null,98.885999999999996]
[null,null,2017,99.39,99.65,100.16200000000001,100.77800000000001,null,null,null,null,null,null,null,null,null,null,null,100.77800000000001]
[null,null,2018,101.419,102.136,102.577,103.01900000000001,null,null,null,null,null,null,null,null,null,null,null,103.01900000000001,"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,103.375,103.88800000000001,104.211,104.541,null,null,null,null,null,null,null,null,null,null,null,104.541]
[null,null,2020,105.03700000000001,104.614,105.538,106.27500000000001,null,null,null,null,null,null,null,null,null,null,null,106.27500000000001]
[null,null,2021,107.66800000000001,109.30500000000001,110.92,112.848,null,null,null,null,null,null,null,null,null,null,null,112.848]
[null,null,2022,115.13500000000001,117.67100000000001,118.962,120.093,null,null,null,null,null,null,null,null,null,null,null,120.093]
[null,null,2023,121.261,121.76600000000001,122.762,123.271,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G223=\"\", \"-\", G223)","v":123.271}]

{"sheet":"Winter-to-Summer Ratio","index":8,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,2,1,3]]}
[null,"Project: ","NYISO ICAP Demand Curve "]
[null,"Date: ","2024-06-01"]
[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"]
[null,"C - Central","2024-2025",{"$f":"B12&C12","v":"C - Central2024-2025"},1.0329999999999999]
[null,"F - Capital","2024-2025","F - Capital2024-2025",1.0329999999999999]
[null,"G - Hudson Valley (Dutchess)","2024-2025","G - Hudson Valley (Dutchess)2024-2025",1.0580000000000001]
[null,"G - Hudson Valley (Rockland)","2024-2025","G - Hudson Valley (Rockland)2024-2025",1.0580000000000001]
[null,"J - New York City","2024-2025","J - New York City2024-2025",1.0669999999999999]
[null,"K - Long Island","2024-2025","K - Long Island2024-2025",1.0720000000000001]

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

{"sheet":"Levelized Factor","index":10,"n_rows":54,"n_cols":32,"rows_kept":54,"cut":false,"hidden":false,"merged":[[1,2,1,3]]}
[null,"Project: ","NYISO ICAP Demand Curve "]
[null,"Date: ","2024-06-01"]
[null,"Worksheet:","Levelized Factor"]
[]
[null,"Calculation of Levelized Factor"]
[]
[]
[null,"Input"]
[]
[null,"Property Tax Rate ",{"$f":"Property_Tax_Rate","v":6.0000000000000001E-3},"Linked to \"Model\""]
[null,"Total Project Capitalized Cost",{"$f":"Capital_Costs*DMNC_ICAP*1000","v":652492350.13137233}]
[]
[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.93669390218231796},0.87739546638553778,0.82185098316574412,0.76982280443389539,0.72108832667412082,0.67543903853050025,0.63267962868740724,0.5926271502264675,0.55511023788481662,0.51996837486568359,0.4870512060643355,0.4562178947710066,0.4273365200984563,0,0,0,0,0,0,0,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 and Battery Exemption active for 15 years",{"$f":"IF(OR(AND(Region=\"J - New York City\",PropTax_Abate),AND(LEFT(Unit,4)=\"BESS\",PropTax_Abate)), 1, 0)","v":0},0,0,0,0,0,{"$f":"IF(OR(AND(Region=\"J - New York City\",PropTax_Abate),AND(LEFT(Unit,4)=\"BESS\",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]
[]
[null,"Depreciation"]
[null,"Effective Tax Depreciation",{"$f":"IF(LEFT(Unit,4)=\"BESS\",C23,IF(CC_Flag=TRUE,#REF!, C24))","v":0.05},{"$f":"IF(LEFT(Unit,4)=\"BESS\",D23,IF(CC_Flag=TRUE,#REF!, D24))","v":9.5000000000000001E-2},{"$f":"IF(LEFT(Unit,4)=\"BESS\",E23,IF(CC_Flag=TRUE,#REF!, E24))","v":8.5500000000000007E-2},{"$f":"IF(LEFT(Unit,4)=\"BESS\",F23,IF(CC_Flag=TRUE,#REF!, F24))","v":7.6999999999999999E-2},{"$f":"IF(LEFT(Unit,4)=\"BESS\",G23,IF(CC_Flag=TRUE,#REF!, G24))","v":6.93E-2},{"$f":"IF(LEFT(Unit,4)=\"BESS\",H23,IF(CC_Flag=TRUE,#REF!, H24))","v":6.2300000000000001E-2},{"$f":"IF(LEFT(Unit,4)=\"BESS\",I23,IF(CC_Flag=TRUE,#REF!, I24))","v":5.8999999999999997E-2},{"$f":"IF(LEFT(Unit,4)=\"BESS\",J23,IF(CC_Flag=TRUE,#REF!, J24))","v":5.8999999999999997E-2},{"$f":"IF(LEFT(Unit,4)=\"BESS\",K23,IF(CC_Flag=TRUE,#REF!, K24))","v":5.91E-2},{"$f":"IF(LEFT(Unit,4)=\"BESS\",L23,IF(CC_Flag=TRUE,#REF!, L24))","v":5.8999999999999997E-2},{"$f":"IF(LEFT(Unit,4)=\"BESS\",M23,IF(CC_Flag=TRUE,#REF!, M24))","v":5.91E-2},{"$f":"IF(LEFT(Unit,4)=\"BESS\",N23,IF(CC_Flag=TRUE,#REF!, N24))","v":5.8999999999999997E-2},{"$f":"IF(LEFT(Unit,4)=\"BESS\",O23,IF(CC_Flag=TRUE,#REF!, O24))","v":5.91E-2},{"$f":"IF(LEFT(Unit,4)=\"BESS\",P23,IF(CC_Flag=TRUE,#REF!, P24))","v":5.8999999999999997E-2},{"$f":"IF(LEFT(Unit,4)=\"BESS\",Q23,IF(CC_Flag=TRUE,#REF!, Q24))","v":5.91E-2},{"$f":"IF(LEFT(Unit,4)=\"BESS\",R23,IF(CC_Flag=TRUE,#REF!, R24))","v":2.9499999999999998E-2},{"$f":"IF(LEFT(Unit,4)=\"BESS\",S23,IF(CC_Flag=TRUE,#REF!, S24))","v":0},{"$f":"IF(LEFT(Unit,4)=\"BESS\",T23,IF(CC_Flag=TRUE,#REF!, T24))","v":0},{"$f":"IF(LEFT(Unit,4)=\"BESS\",U23,IF(CC_Flag=TRUE,#REF!, U24))","v":0},{"$f":"IF(LEFT(Unit,4)=\"BESS\",V23,IF(CC_Flag=TRUE,#REF!, V24))","v":0},{"$f":"IF(LEFT(Unit,4)=\"BESS\",W23,IF(CC_Flag=TRUE,#REF!, W24))","v":0},{"$f":"IF(LEFT(Unit,4)=\"BESS\",X23,IF(CC_Flag=TRUE,#REF!, X24))","v":0},{"$f":"IF(LEFT(Unit,4)=\"BESS\",Y23,IF(CC_Flag=TRUE,#REF!, Y24))","v":0},{"$f":"IF(LEFT(Unit,4)=\"BESS\",Z23,IF(CC_Flag=TRUE,#REF!, Z24))","v":0},{"$f":"IF(LEFT(Unit,4)=\"BESS\",AA23,IF(CC_Flag=TRUE,#REF!, AA24))","v":0},{"$f":"IF(LEFT(Unit,4)=\"BESS\",AB23,IF(CC_Flag=TRUE,#REF!, AB24))","v":0},{"$f":"IF(LEFT(Unit,4)=\"BESS\",AC23,IF(CC_Flag=TRUE,#REF!, AC24))","v":0},{"$f":"IF(LEFT(Unit,4)=\"BESS\",AD23,IF(CC_Flag=TRUE,#REF!, AD24))","v":0},{"$f":"IF(LEFT(Unit,4)=\"BESS\",AE23,IF(CC_Flag=TRUE,#REF!, AE24))","v":0},{"$f":"IF(LEFT(Unit,4)=\"BESS\",AF23,IF(CC_Flag=TRUE,#REF!, AF24))","v":0}]
[null,"Tax Depreciation (5 year Bat)",0.2,0.32,0.192,0.1152,0.1152,5.7599999999999998E-2,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,"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":293621557.5591175}]
[null,"Target Cash Flow to Equity",{"$f":"IF(C14<=Plant_Life,PMT(Equity_Rate_Real,Plant_Life,(-1*$C$28),,0),0)","v":44894871.874535836},44894871.874535836,44894871.874535836,44894871.874535836,44894871.874535836,44894871.874535836,44894871.874535836,44894871.874535836,44894871.874535836,44894871.874535836,44894871.874535836,44894871.874535836,44894871.874535836,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Debt Service",{"$f":"C11*Debt_Fraction","v":358870792.57225484}]
[null,"Principal",{"$f":"IF(C14<=Plant_Life,PPMT(Debt_Rate_Real,C14,Plant_Life,-1*$C$31,,0),0)","v":20933287.564789861},21872128.703124546,22853076.112645794,23878018.225805975,24948928.169736564,26067867.5647365,27236990.493119709,28458547.64606221,29734890.656432018,31068476.625942972,32461872.855347779,33917761.786776423,35438946.167734466,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Loan Balance Start of Year",{"$f":"C31","v":358870792.57225484},{"$f":"C33-C32","v":337937505.007465},316065376.30434048,293212300.19169468,269334281.96588868,244385353.79615211,218317486.23141563,191080495.73829591,162621948.09223372,132887057.4358017,101818580.80985872,69356707.954510942,35438946.167734519,0,0,0,0,0,0,0,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*C33,,0),0)","v":16095066.881912723},15156225.743578045,14175278.334056791,13150336.220896609,12079426.276966022,10960486.881966088,9791363.9535828792,8569806.8006403781,7293463.7902705688,5959877.820759614,4566481.5913548078,3110592.6599261668,1589408.278968117,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Yearly Debt Service (Principal + Interest)",{"$f":"SUM(C32,C34)","v":37028354.446702585},37028354.446702592,37028354.446702585,37028354.446702585,37028354.446702585,37028354.446702585,37028354.446702585,37028354.446702585,37028354.446702585,37028354.446702585,37028354.446702585,37028354.446702592,37028354.446702585,0,0,0,0,0,0,0,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":3914954.1007882343},3914954.1007882343,3914954.1007882343,3914954.1007882343,3914954.1007882343,3914954.1007882343,3914954.1007882343,3914954.1007882343,3914954.1007882343,3914954.1007882343,3914954.1007882343,3914954.1007882343,3914954.1007882343,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Tax Depreciation",{"$f":"$C$11*C22","v":32624617.506568618},61986773.262480371,55788095.936232336,50241910.960115671,45217719.8641041,40650273.413184494,38497048.657750964,38497048.657750964,38562297.892764106,38497048.657750964,38562297.892764106,38497048.657750964,38562297.892764106,38497048.657750964,38562297.892764106,19248524.328875482,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.11633372502937721}]
[null,"Principal",{"$f":"C32","v":20933287.564789861},21872128.703124546,22853076.112645794,23878018.225805975,24948928.169736564,26067867.5647365,27236990.493119709,28458547.64606221,29734890.656432018,31068476.625942972,32461872.855347779,33917761.786776423,35438946.167734466,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Interest",{"$f":"C34","v":16095066.881912723},15156225.743578045,14175278.334056791,13150336.220896609,12079426.276966022,10960486.881966088,9791363.9535828792,8569806.8006403781,7293463.7902705688,5959877.820759614,4566481.5913548078,3110592.6599261668,1589408.278968117,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Target Cash Flow to Equity",{"$f":"C29","v":44894871.874535836},44894871.874535836,44894871.874535836,44894871.874535836,44894871.874535836,44894871.874535836,44894871.874535836,44894871.874535836,44894871.874535836,44894871.874535836,44894871.874535836,44894871.874535836,44894871.874535836,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Income Taxes",{"$f":"(Effective_Tax_Rate/(1-Effective_Tax_Rate))*(C46+C44-C40)","v":11751158.761471299},{"$f":"(Effective_Tax_Rate/(1-Effective_Tax_Rate))*(D46+D44-D40)","v":1691783.6720661456},4232744.8227973832,6558350.8627878614,8715485.186969934,10727969.969157007,11903791.367139263,12336116.089288155,12764737.688094318,13259803.383277902,13729851.615519958,14268201.895384407,14783475.991173737,{"$f":"(Effective_Tax_Rate/(1-Effective_Tax_Rate))*(P46+P44-P40)","v":-13624598.590761039},-13647691.130745383,-6812299.2953805197,0,0,0,0,0,0,0,0,0,{"$f":"(Effective_Tax_Rate/(1-Effective_Tax_Rate))*(AB46+AB44-AB40)","v":0},{"$f":"(Effective_Tax_Rate/(1-Effective_Tax_Rate))*(AC46+AC44-AC40)","v":0},{"$f":"(Effective_Tax_Rate/(1-Effective_Tax_Rate))*(AD46+AD44-AD40)","v":0},{"$f":"(Effective_Tax_Rate/(1-Effective_Tax_Rate))*(AE46+AE44-AE40)","v":0},{"$f":"(Effective_Tax_Rate/(1-Effective_Tax_Rate))*(AF46+AF44-AF40)","v":0}]
[null,"Property Taxes",{"$f":"C39","v":3914954.1007882343},{"$f":"D39","v":3914954.1007882343},3914954.1007882343,3914954.1007882343,3914954.1007882343,3914954.1007882343,3914954.1007882343,3914954.1007882343,3914954.1007882343,{"$f":"L39","v":3914954.1007882343},3914954.1007882343,3914954.1007882343,3914954.1007882343,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Total Carrying Charges",{"$f":"SUM(C44:C48)","v":97589339.183497965},{"$f":"SUM(D44:D48)","v":87529964.094092816},{"$f":"SUM(E44:E48)","v":90070925.244824052},92396531.284814522,94553665.6089966,96566150.391183674,97741971.789165929,98174296.511314824,98602918.110120982,99097983.805304572,99568032.03754662,100106382.31741107,100621656.41320041,-13624598.590761039,-13647691.130745383,-6812299.2953805197,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AB44:AB48)","v":0},{"$f":"SUM(AC44:AC48)","v":0},{"$f":"SUM(AD44:AD48)","v":0},{"$f":"SUM(AE44:AE48)","v":0},{"$f":"SUM(AF44:AF48)","v":0}]
[]
[null,"Cumulative Present Value",{"$f":"SUMPRODUCT(C50:AF50, C15:AF15)","v":810217436.67786539}]
[null,"Levelized Carrying Charges (Real)",{"$f":"-1*PMT(ATWACC_Real,Plant_Life,$C$52,,0)","v":95620266.295840278}]
[null,"Levelized Carrying Charge Rate (Real)",{"$f":"C53/C11","v":0.14654618751712287}]

{"sheet":"Peak Load and IRM","index":11,"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: ","2024-06-01"]
[null,null,"Worksheet:","Peak Load and IRM"]
[]
[null,null,"Peak Load and IRM"]
[]
[]
[null,"Lookup","Zone","Peak Load (2024)","Installed Reserve Margin / \nLocational Capacity Requirement"]
[]
[null,"K","K - Long Island",5043.3999999999996,1.0529999999999999]
[null,"J","J - New York City",11167.9,0.80400000000000005]
[null,"NYCA","NYCA",31541.599999999999,1.22]
[null,"G","G-J",15220,0.81]
[]
[]
[]
[null,null,"Sources:"]
[null,null,"2024 Gold Book, Tables I-3a, I-4a, and I-5. "]
[null,null,"2024 - 2025 Locational Minimum Installed Capacity Requirement Study. NYISO."]

{"sheet":"AS Adders","index":12,"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: ","2024-06-01"]
[null,"Worksheet:","AS Adders"]
[]
[null,"AS Adders"]
[]
[null,"Adder Type","Adder ($/kW-Year)"]
[null,"VSS Adder",2.48]

{"sheet":"Performance and O&M","index":13,"n_rows":33,"n_cols":43,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,5,1,6]]}
[null,null,null,"Project: ",null,"NYISO ICAP Demand Curve"]
[null,null,null,"Date: ",null,"2024-06-01"]
[null,null,null,"Worksheet:",null,"Performance and O&M"]
[]
[null,null,null,"Performance and O&M Data"]
[]
[]
[null,null,null,null,null,"SCGT J Class","SCGT J Class","SCGT J Class","SCGT J Class","SCGT J Class","SCGT J Class",null,"SCGT 7HA.02","SCGT 7HA.02","SCGT 7HA.02",null,"BESS 2h","BESS 2h","BESS 2h","BESS 2h","BESS 2h","BESS 2h",null,"BESS 4h","BESS 4h","BESS 4h","BESS 4h","BESS 4h","BESS 4h",null,"BESS 6h","BESS 6h","BESS 6h","BESS 6h","BESS 6h","BESS 6h",null,"BESS 8h","BESS 8h","BESS 8h","BESS 8h","BESS 8h","BESS 8h"]
[null,null,null,"Technology",null,"SCGT J Class",null,null,null,null,null,null,"SCGT 7HA.02",null,null,null,"BESS 2h",null,null,null,null,null,null,"BESS 4h ",null,null,null,null,null,null,"BESS 6h ",null,null,null,null,null,null,"BESS 8h "]
[null,null,null,"Plant Capacity (MW)",null,{"$f":"AVERAGE(F21:K21)","v":398.7},null,null,null,null,null,null,{"$f":"AVERAGE(M21:O21)","v":326.61149999999998},null,null,null,{"$f":"AVERAGE(Q21:V21)","v":200},null,null,null,null,null,null,{"$f":"AVERAGE(X21:AC21)","v":200},null,null,null,null,null,null,{"$f":"AVERAGE(AE21:AJ21)","v":200},null,null,null,null,null,null,{"$f":"AVERAGE(AL21:AQ21)","v":200}]
[]
[null,null,null,"Lookup",null,{"$f":"F13&F8","v":"C - CentralSCGT J Class"},{"$f":"G13&F8","v":"F - CapitalSCGT J Class"},{"$f":"H13&F8","v":"G - Hudson Valley (Dutchess)SCGT J Class"},{"$f":"I13&F8","v":"G - Hudson Valley (Rockland)SCGT J Class"},{"$f":"J13&F8","v":"J - New York CitySCGT J Class"},{"$f":"K13&F8","v":"K - Long IslandSCGT J Class"},null,{"$f":"M13&M8","v":"C - CentralSCGT 7HA.02"},{"$f":"N13&N8","v":"F - CapitalSCGT 7HA.02"},"G - Hudson Valley (Dutchess)SCGT 7HA.02",null,{"$f":"Q13&Q8","v":"C - CentralBESS 2h"},{"$f":"R13&R8","v":"F - CapitalBESS 2h"},"G - Hudson Valley (Dutchess)BESS 2h","G - Hudson Valley (Rockland)BESS 2h","J - New York CityBESS 2h","K - Long IslandBESS 2h",null,{"$f":"X13&X8","v":"C - CentralBESS 4h"},{"$f":"Y13&X8","v":"F - CapitalBESS 4h"},{"$f":"Z13&X8","v":"G - Hudson Valley (Dutchess)BESS 4h"},{"$f":"AA13&X8","v":"G - Hudson Valley (Rockland)BESS 4h"},{"$f":"AB13&X8","v":"J - New York CityBESS 4h"},{"$f":"AC13&X8","v":"K - Long IslandBESS 4h"},null,{"$f":"AE13&AE8","v":"C - CentralBESS 6h"},{"$f":"AF13&AE8","v":"F - CapitalBESS 6h"},{"$f":"AG13&AE8","v":"G - Hudson Valley (Dutchess)BESS 6h"},{"$f":"AH13&AE8","v":"G - Hudson Valley (Rockland)BESS 6h"},{"$f":"AI13&AE8","v":"J - New York CityBESS 6h"},{"$f":"AJ13&AE8","v":"K - Long IslandBESS 6h"},null,{"$f":"AL13&AL8","v":"C - CentralBESS 8h"},{"$f":"AM13&AL8","v":"F - CapitalBESS 8h"},{"$f":"AN13&AL8","v":"G - Hudson Valley (Dutchess)BESS 8h"},{"$f":"AO13&AL8","v":"G - Hudson Valley (Rockland)BESS 8h"},{"$f":"AP13&AL8","v":"J - New York CityBESS 8h"},{"$f":"AQ13&AL8","v":"K - Long IslandBESS 8h"}]
[null,null,null,"Zone",null,"C - Central","F - Capital","G - Hudson Valley (Dutchess)","G - Hudson Valley (Rockland)","J - New York City","K - Long Island",null,"C - Central","F - Capital","G - Hudson Valley (Dutchess)",null,"C - Central","F - Capital","G - Hudson Valley (Dutchess)","G - Hudson Valley (Rockland)","J - New York City","K - Long Island",null,"C - Central","F - Capital","G - Hudson Valley (Dutchess)","G - Hudson Valley (Rockland)","J - New York City","K - Long Island",null,"C - Central","F - Capital","G - Hudson Valley (Dutchess)","G - Hudson Valley (Rockland)","J - New York City","K - Long Island",null,"C - Central","F - Capital","G - Hudson Valley (Dutchess)","G - Hudson Valley (Rockland)","J - New York City","K - Long Island"]
[]
[null,null,null,"Plant Capacities"]
[]
[null,null,"Capacity- based on average temp (Summer, MW)","Net Plant Capacity - Summer",null,400.2,411.8,408,408,413.9,417,null,330.96632,340.71733,337.40388000000002,null,200,200,200,200,200,200,null,200,200,200,200,200,200,null,200,200,200,200,200,200,null,200,200,200,200,200,200]
[null,null,"Capacity- based on average temp (Winter, MW)","Net Plant Capacity - Winer",null,414.3,429.1,426.9,426.9,434.7,438.1,null,357.00056999999998,365.04752000000002,360.97671000000003,null,200,200,200,200,200,200,null,200,200,200,200,200,200,null,200,200,200,200,200,200,null,200,200,200,200,200,200]
[null,null,"DMNC Summer (MW)","DMNC Summer",null,394.5,406.5,400.9,400.9,404.4,407.1,null,325.66480000000001,335.79449,331.25033000000002,null,200,200,200,200,200,200,null,200,200,200,200,200,200,null,200,200,200,200,200,200,null,200,200,200,200,200,200]
[null,null,"DMNC Winter (MW)","DMNC Winter",null,419.5,431.7,428.5,428.5,435,438.1,null,352.17240000000004,363.72214000000002,331.25033000000002,null,200,200,200,200,200,200,null,200,200,200,200,200,200,null,200,200,200,200,200,200,null,200,200,200,200,200,200]
[null,null,"DMNC ICAP (MW)","DMNC ICAP",null,389,400.3,397.4,397.4,404.1,404,null,321.02596999999997,330.68230999999997,328.12621999999999,null,200,200,200,200,200,200,null,200,200,200,200,200,200,null,200,200,200,200,200,200,null,200,200,200,200,200,200]
[]
[null,null,null,"Fixed O&M Costs"]
[]
[null,null,null,"Fixed O&M and Site Leasing Costs, Excluding Insurance and Property Taxes (2024)",null,7.9768123393316195,8.0264301773669757,8.6386009058882731,9.5444732833652175,27.884187082405347,9.8824381188118817,null,9.6035221075727932,9.6254922133572851,9.7004744089027692,null,17.650000000000002,17.650000000000002,17.650000000000002,17.650000000000002,35.67,17.7,null,28.95,28.95,28.95,28.95,56.129999999999995,28.95,null,40.800000000000004,40.800000000000004,40.800000000000004,40.800000000000004,77.140000000000015,40.9,null,51.850000000000009,51.850000000000009,51.850000000000009,51.850000000000009,97.35,52.05]
[]
[]
[]
[]
[]
[]
[]
[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)"},null,{"$f":"F25","v":7.9768123393316195},{"$f":"G25","v":8.0264301773669757},8.6386009058882731,9.5444732833652175,27.884187082405347,9.8824381188118817,null,9.6035221075727932,9.6254922133572851,9.7004744089027692,null,{"$f":"Q25","v":17.650000000000002},{"$f":"R25","v":17.650000000000002},17.650000000000002,17.650000000000002,35.67,17.7,null,{"$f":"X25","v":28.95},{"$f":"Y25","v":28.95},28.95,28.95,56.129999999999995,28.95,null,{"$f":"AE25","v":40.800000000000004},{"$f":"AF25","v":40.800000000000004},40.800000000000004,40.800000000000004,77.140000000000015,40.9,null,{"$f":"AL25","v":51.850000000000009},{"$f":"AM25","v":51.850000000000009},51.850000000000009,51.850000000000009,97.35,52.05]

{"sheet":"Capital Costs","index":14,"n_rows":72,"n_cols":59,"rows_kept":72,"cut":false,"hidden":false,"merged":[[1,4,1,5]]}
[null,null,null,"Project: ","NYISO ICAP Demand Curve"]
[null,null,null,"Date: ","2024-06-01"]
[null,null,null,"Worksheet:","Capital Costs"]
[]
[null,null,null,"Capital Costs"]
[]
[]
[null,null,null,null,"SCGT J Class","SCGT J Class","SCGT J Class","SCGT J Class","SCGT J Class","SCGT J Class",null,"SCGT J Class","SCGT J Class","SCGT J Class","SCGT J Class","SCGT J Class","SCGT J Class",null,"SCGT 7HA.02","SCGT 7HA.02","SCGT 7HA.02","SCGT 7HA.02","SCGT 7HA.02","SCGT 7HA.02",null,"SCGT 7HA.02","SCGT 7HA.02","SCGT 7HA.02","SCGT 7HA.02","SCGT 7HA.02","SCGT 7HA.02",null,"BESS 2h","BESS 2h","BESS 2h","BESS 2h","BESS 2h","BESS 2h",null,"BESS 4h","BESS 4h","BESS 4h","BESS 4h","BESS 4h","BESS 4h",null,"BESS 6h","BESS 6h","BESS 6h","BESS 6h","BESS 6h","BESS 6h",null,"BESS 8h","BESS 8h","BESS 8h","BESS 8h","BESS 8h","BESS 8h"]
[null,null,null,null,"Dual fuel with SCR","Dual fuel with SCR","Dual fuel with SCR","Dual fuel with SCR","Dual fuel with SCR","Dual fuel with SCR",null,"Gas only with SCR","Gas only with SCR","Gas only with SCR","Gas only with SCR","Gas only with SCR","Gas only with SCR",null,"Dual fuel without SCR","Dual fuel without SCR","Dual fuel without SCR","Dual fuel without SCR","Dual fuel without SCR","Dual fuel without SCR",null,"Gas only without SCR","Gas only without SCR","Gas only without SCR","Gas only without SCR","Gas only without SCR","Gas only without SCR",null,"Battery","Battery","Battery","Battery","Battery","Battery",null,"Battery","Battery","Battery","Battery","Battery","Battery",null,"Battery","Battery","Battery","Battery","Battery","Battery",null,"Battery","Battery","Battery","Battery","Battery","Battery"]
[null,null,null,"Technology","SCGT J Class (Dual fuel with SCR)",null,null,null,null,null,null,"SCGT J Class (Gas Only with SCR)",null,null,null,null,null,null,"SCGT 7HA.02 (Dual Fuel without SCR)",null,null,null,null,null,null,"SCGT 7HA.02 (Gas Only without SCR)",null,null,null,null,null,null,"BESS 2h",null,null,null,null,null,null,"BESS 4h ",null,null,null,null,null,null,"BESS 6h ",null,null,null,null,null,null,"BESS 8h "]
[null,null,null,"Plant Capacity (MW) average of zone-specific DMNC ICAP",{"$f":"AVERAGE(E13:J13)","v":398.7},null,null,null,null,null,null,{"$f":"AVERAGE(L13:Q13)","v":398.7},null,null,null,null,null,null,{"$f":"AVERAGE(S13:U13)","v":326.61149999999998},null,null,null,null,null,null,{"$f":"AVERAGE(Z13:AB13)","v":326.61149999999998},null,null,null,null,null,null,{"$f":"AVERAGE(AG13:AL13)","v":200},null,null,null,null,null,null,{"$f":"AVERAGE(AN13:AS13)","v":200},null,null,null,null,null,null,{"$f":"AVERAGE(AU13:AZ13)","v":200},null,null,null,null,null,null,{"$f":"AVERAGE(BB13:BG13)","v":200}]
[]
[null,null,null,"DMNC ICAP (MW)",{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(E15&E8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":389},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(F15&F8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":400.3},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(G15&G8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":397.4},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(H15&H8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":397.4},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(I15&I8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":404.1},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(J15&J8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":404},null,{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(L15&L8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":389},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(M15&M8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":400.3},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(N15&N8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":397.4},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(O15&O8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":397.4},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(P15&P8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":404.1},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(Q15&Q8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":404},null,{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(S15&S8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":321.02596999999997},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(T15&T8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":330.68230999999997},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(U15&U8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":328.12621999999999},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(V15&V8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(W15&W8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(X15&X8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(Z15&Z8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":321.02596999999997},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(AA15&AA8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":330.68230999999997},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(AB15&AB8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":328.12621999999999},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(AC15&AC8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(AD15&AD8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(AE15&AE8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(AG15&AG8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":200},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(AH15&AH8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":200},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(AI15&AI8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":200},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(AJ15&AJ8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":200},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(AK15&AK8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":200},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(AL15&AL8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":200},null,{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(AN15&AN8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":200},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(AO15&AO8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":200},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(AP15&AP8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":200},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(AQ15&AQ8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":200},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(AR15&AR8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":200},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(AS15&AS8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":200},null,{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(AU15&AU8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":200},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(AV15&AV8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":200},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(AW15&AW8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":200},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(AX15&AX8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":200},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(AY15&AY8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":200},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(AZ15&AZ8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":200},null,{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(BB15&BB8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":200},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(BC15&BC8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":200},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(BD15&BD8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":200},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(BE15&BE8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":200},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(BF15&BF8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":200},{"$f":"INDEX('Performance and O&M'!$C$12:$AQ$21, MATCH(\"DMNC ICAP (MW)\", 'Performance and O&M'!$C$12:$C$21, 0), MATCH(BG15&BG8, 'Performance and O&M'!$C$12:$AQ$12, 0))","v":200}]
[null,null,null,"Lookup",{"$f":"E15&E8&E9","v":"C - CentralSCGT J ClassDual fuel with SCR"},{"$f":"F15&F8&F9","v":"F - CapitalSCGT J ClassDual fuel with SCR"},"G - Hudson Valley (Dutchess)SCGT J ClassDual fuel with SCR","G - Hudson Valley (Rockland)SCGT J ClassDual fuel with SCR","J - New York CitySCGT J ClassDual fuel with SCR","K - Long IslandSCGT J ClassDual fuel with SCR",null,{"$f":"L15&L8&L9","v":"C - CentralSCGT J ClassGas only with SCR"},{"$f":"M15&M8&M9","v":"F - CapitalSCGT J ClassGas only with SCR"},"G - Hudson Valley (Dutchess)SCGT J ClassGas only with SCR","G - Hudson Valley (Rockland)SCGT J ClassGas only with SCR","J - New York CitySCGT J ClassGas only with SCR","K - Long IslandSCGT J ClassGas only with SCR",null,{"$f":"S15&S8&S9","v":"C - CentralSCGT 7HA.02Dual fuel without SCR"},{"$f":"T15&T8&T9","v":"F - CapitalSCGT 7HA.02Dual fuel without SCR"},"G - Hudson Valley (Dutchess)SCGT 7HA.02Dual fuel without SCR","G - Hudson Valley (Rockland)SCGT 7HA.02Dual fuel without SCR","J - New York CitySCGT 7HA.02Dual fuel without SCR","K - Long IslandSCGT 7HA.02Dual fuel without SCR",null,{"$f":"Z15&Z8&Z9","v":"C - CentralSCGT 7HA.02Gas only without SCR"},{"$f":"AA15&AA8&AA9","v":"F - CapitalSCGT 7HA.02Gas only without SCR"},"G - Hudson Valley (Dutchess)SCGT 7HA.02Gas only without SCR","G - Hudson Valley (Rockland)SCGT 7HA.02Gas only without SCR","J - New York CitySCGT 7HA.02Gas only without SCR","K - Long IslandSCGT 7HA.02Gas only without SCR",null,{"$f":"AG15&AG8&AG9","v":"C - CentralBESS 2hBattery"},{"$f":"AH15&AH8&AH9","v":"F - CapitalBESS 2hBattery"},"G - Hudson Valley (Dutchess)BESS 2hBattery","G - Hudson Valley (Rockland)BESS 2hBattery","J - New York CityBESS 2hBattery","K - Long IslandBESS 2hBattery",null,{"$f":"AN15&AN8&AN9","v":"C - CentralBESS 4hBattery"},{"$f":"AO15&AO8&AO9","v":"F - CapitalBESS 4hBattery"},{"$f":"AP15&AP8&AP9","v":"G - Hudson Valley (Dutchess)BESS 4hBattery"},"G - Hudson Valley (Rockland)BESS 4hBattery","J - New York CityBESS 4hBattery","K - Long IslandBESS 4hBattery",null,{"$f":"AU15&AU8&AU9","v":"C - CentralBESS 6hBattery"},{"$f":"AV15&AV8&AV9","v":"F - CapitalBESS 6hBattery"},{"$f":"AW15&AW8&AW9","v":"G - Hudson Valley (Dutchess)BESS 6hBattery"},"G - Hudson Valley (Rockland)BESS 6hBattery","J - New York CityBESS 6hBattery","K - Long IslandBESS 6hBattery",null,{"$f":"BB15&BB8&BB9","v":"C - CentralBESS 8hBattery"},{"$f":"BC15&BC8&BC9","v":"F - CapitalBESS 8hBattery"},{"$f":"BD15&BD8&BD9","v":"G - Hudson Valley (Dutchess)BESS 8hBattery"},"G - Hudson Valley (Rockland)BESS 8hBattery","J - New York CityBESS 8hBattery","K - Long IslandBESS 8hBattery"]
[null,null,null,"Zone","C - Central","F - Capital","G - Hudson Valley (Dutchess)","G - Hudson Valley (Rockland)","J - New York City","K - Long Island",null,"C - Central","F - Capital","G - Hudson Valley (Dutchess)","G - Hudson Valley (Rockland)","J - New York City","K - Long Island",null,"C - Central","F - Capital","G - Hudson Valley (Dutchess)","G - Hudson Valley (Rockland)","J - New York City","K - Long Island",null,"C - Central","F - Capital","G - Hudson Valley (Dutchess)","G - Hudson Valley (Rockland)","J - New York City","K - Long Island",null,"C - Central","F - Capital","G - Hudson Valley (Dutchess)","G - Hudson Valley (Rockland)","J - New York City","K - Long Island",null,"C - Central","F - Capital","G - Hudson Valley (Dutchess)","G - Hudson Valley (Rockland)","J - New York City","K - Long Island",null,"C - Central","F - Capital","G - Hudson Valley (Dutchess)","G - Hudson Valley (Rockland)","J - New York City","K - Long Island",null,"C - Central","F - Capital","G - Hudson Valley (Dutchess)","G - Hudson Valley (Rockland)","J - New York City","K - Long Island"]
[]
[null,null,null,"EPC Costs"]
[]
[null,null,null,"EPC Project Capital Costs, 2024 MM$ (w/o Owner's Costs)",422.63,431.78000000000003,434.76000000000005,494.54,550.86,537.41999999999996,null,422.63,431.78000000000003,434.76000000000005,494.54,550.86,537.41999999999996,null,346.85,355.06,356.54,null,null,null,null,346.85,355.06,356.54,null,null,null,null,167.83,169.19,167.91,173.86,206.1,177.82,null,288.94,290.87,289.08999999999997,297.52999999999997,360.65,304.17,null,418.04,420.75,418.26,430.06,511.96,440.33,null,539.51,542.97,539.77,554.86,663.88,568.65]
[null,null,null,"Dual Fuel Breakout Costs, 2024 MM$ (w/o Owner's Costs)",26.9,26.9,26.9,"Included","Included","Included",null,26.9,26.9,26.9,"Included","Included","Included",null,26.9,26.9,26.9,null,null,null,null,26.9,26.9,26.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,26.9,26.9,26.9]
[null,null,null,"Total EPC Costs",{"$f":"(E19+E20) * 1000000","v":449530000},{"$f":"(F19+F20) * 1000000","v":458680000},461660000,{"$f":"H19*1000000","v":494540000},{"$f":"I19*1000000","v":550860000},537420000,null,{"$f":"(L19) * 1000000","v":422630000},{"$f":"(M19) * 1000000","v":431780000},{"$f":"(N19) * 1000000","v":434760000.00000006},{"$f":"(O19-O21)*1000000","v":467640000.00000006},{"$f":"(P19-P21)*1000000","v":523960000.00000006},{"$f":"(Q19-Q21)*1000000","v":510520000},null,{"$f":"(S19 + S20) * 1000000","v":373750000},{"$f":"(T19 + T20) * 1000000","v":381960000},{"$f":"(U19 + U20) * 1000000","v":383440000},null,null,null,null,{"$f":"Z19*1000000","v":346850000},{"$f":"AA19*1000000","v":355060000},{"$f":"AB19*1000000","v":356540000},null,null,null,null,{"$f":"AG19*1000000","v":167830000},{"$f":"AH19*1000000","v":169190000},167910000,173860000,206100000,{"$f":"AL19*1000000","v":177820000},null,{"$f":"AN19*1000000","v":288940000},{"$f":"AO19*1000000","v":290870000},289090000,297530000,360650000,{"$f":"AS19*1000000","v":304170000},null,{"$f":"AU19*1000000","v":418040000},{"$f":"AV19*1000000","v":420750000},418260000,430060000,511960000,440330000,null,{"$f":"BB19*1000000","v":539510000},{"$f":"BC19*1000000","v":542970000},539770000,554860000,663880000,568650000]
[]
[null,null,null,"Owner's Cost Allowances, 2024 MM$",147.66233949420851,148.16233949420851,141.6123394942085,143.41233949420851,170.70784039420846,136.75869269420849,null,147.66233949420851,148.16233949420851,141.6123394942085,143.41233949420851,170.70784039420846,136.75869269420849,null,143.51592521891894,143.96521746891892,137.32621046891893,null,null,null,null,143.51592521891894,143.96521746891892,137.32621046891893,null,null,null,null,61.19,61.249999999999993,61.19,61.51,102.64999999999999,53.139999999999993,null,68.48,68.59,68.490000000000009,68.95,111.82,60.72999999999999,null,76.489999999999995,76.64,76.5,77.149999999999991,121.16999999999999,69.11999999999999,null,84.14,84.320000000000007,84.15,84.98,130.63,77.14]
[null,null,null,"Owner's Costs",{"$f":"E24*1000000","v":147662339.49420851},{"$f":"F24*1000000","v":148162339.49420851},141612339.49420848,143412339.49420851,170707840.39420846,136758692.6942085,null,{"$f":"L24*1000000","v":147662339.49420851},{"$f":"M24*1000000","v":148162339.49420851},141612339.49420848,143412339.49420851,170707840.39420846,136758692.6942085,null,{"$f":"S24*1000000","v":143515925.21891895},{"$f":"T24*1000000","v":143965217.46891892},137326210.46891892,null,null,null,null,{"$f":"Z24*1000000","v":143515925.21891895},{"$f":"AA24*1000000","v":143965217.46891892},{"$f":"AB24*1000000","v":137326210.46891892},null,null,null,null,{"$f":"AG24*1000000","v":61190000},{"$f":"AH24*1000000","v":61249999.999999993},61190000,61510000,102649999.99999999,{"$f":"AL24*1000000","v":53139999.999999993},null,{"$f":"AN24*1000000","v":68480000},{"$f":"AO24*1000000","v":68590000},68490000.000000015,68950000,111820000,{"$f":"AS24*1000000","v":60729999.999999993},null,{"$f":"AU24*1000000","v":76490000},{"$f":"AV24*1000000","v":76640000},76500000,77149999.999999985,121169999.99999999,69119999.999999985,null,{"$f":"BB24*1000000","v":84140000},{"$f":"BC24*1000000","v":84320000},84150000,84980000,130630000,77140000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Total Owner's Costs ",{"$f":"E25","v":147662339.49420851},{"$f":"F25","v":148162339.49420851},141612339.49420848,143412339.49420851,170707840.39420846,136758692.6942085,null,{"$f":"L25","v":147662339.49420851},{"$f":"M25","v":148162339.49420851},141612339.49420848,143412339.49420851,170707840.39420846,136758692.6942085,null,{"$f":"S25","v":143515925.21891895},{"$f":"T25","v":143965217.46891892},137326210.46891892,0,0,0,null,{"$f":"Z25","v":143515925.21891895},{"$f":"AA25","v":143965217.46891892},137326210.46891892,0,0,0,null,61190000,61249999.999999993,61190000,61510000,102649999.99999999,53139999.999999993,null,{"$f":"AN25","v":68480000},{"$f":"AO25","v":68590000},68490000.000000015,68950000,111820000,60729999.999999993,null,{"$f":"AU25","v":76490000},{"$f":"AV25","v":76640000},76500000,77149999.999999985,121169999.99999999,69119999.999999985,null,{"$f":"BB25","v":84140000},{"$f":"BC25","v":84320000},84150000,84980000,130630000,77140000]
[null,null,null,"Pre ITC Credit Applied",{"$f":"SUM(E22,E49)","v":597192339.49420857},{"$f":"SUM(F22,F49)","v":606842339.49420857},603272339.49420846,637952339.49420857,721567840.39420843,674178692.6942085,null,{"$f":"SUM(L22,L49)","v":570292339.49420857},{"$f":"SUM(M22,M49)","v":579942339.49420857},576372339.49420857,611052339.49420857,694667840.39420855,647278692.6942085,null,{"$f":"SUM(S22,S49)","v":517265925.21891892},{"$f":"SUM(T22,T49)","v":525925217.46891892},520766210.46891892,0,0,0,null,{"$f":"SUM(Z22,Z49)","v":490365925.21891892},{"$f":"SUM(AA22,AA49)","v":499025217.46891892},493866210.46891892,0,0,0,null,229020000,230440000,229100000,235370000,308750000,230960000,null,{"$f":"SUM(AN22,AN49)","v":357420000},{"$f":"SUM(AO22,AO49)","v":359460000},357580000,366480000,472470000,364900000,null,{"$f":"SUM(AU22,AU49)","v":494530000},{"$f":"SUM(AV22,AV49)","v":497390000},{"$f":"SUM(AW22,AW49)","v":494760000},{"$f":"SUM(AX22,AX49)","v":507210000},{"$f":"SUM(AY22,AY49)","v":633130000},{"$f":"SUM(AZ22,AZ49)","v":509450000},null,{"$f":"SUM(BB22,BB49)","v":623650000},{"$f":"SUM(BC22,BC49)","v":627290000},{"$f":"SUM(BD22,BD49)","v":623920000},{"$f":"SUM(BE22,BE49)","v":639840000},{"$f":"SUM(BF22,BF49)","v":794510000},{"$f":"SUM(BG22,BG49)","v":645790000}]
[null,null,null,"Capital Costs without AFUDC ($2024)",{"$f":"SUM(E22,E49)","v":597192339.49420857},606842339.49420857,603272339.49420846,637952339.49420857,721567840.39420843,674178692.6942085,null,{"$f":"SUM(L22,L49)","v":570292339.49420857},579942339.49420857,576372339.49420857,611052339.49420857,694667840.39420855,647278692.6942085,null,{"$f":"SUM(S22,S49)","v":517265925.21891892},525925217.46891892,520766210.46891892,0,0,0,null,{"$f":"SUM(Z22,Z49)","v":490365925.21891892},499025217.46891892,493866210.46891892,0,0,0,null,{"$f":"AG50*0.7","v":160314000},{"$f":"AH50*0.7","v":161308000},160370000,164759000,216125000,161672000,null,{"$f":"AN50*0.7","v":250193999.99999997},{"$f":"AO50*0.7","v":251621999.99999997},250305999.99999997,256535999.99999997,330729000,255429999.99999997,null,{"$f":"AU50*0.7","v":346171000},348173000,346332000,355047000,443191000,356615000,null,{"$f":"BB50*0.7","v":436555000},439103000,436744000,447888000,556157000,452053000]
[null,null,null,"Capital Costs without AFUDC ($2024/ICAP kW)",{"$f":"E51/(E13*1000)","v":1535.1988161804848},{"$f":"F51/(F13*1000)","v":1515.9688720814604},1518.0481617871376,1605.3153988279028,1785.6170264642624,1668.7591403321992,null,{"$f":"L51/(L13*1000)","v":1466.047145229328},{"$f":"M51/(M13*1000)","v":1448.7692717816851},1450.3581768852757,1537.6254139260407,1719.0493451972495,1602.1749819163576,null,{"$f":"S51/(S13*1000)","v":1611.2899689047554},{"$f":"T51/(T13*1000)","v":1590.4244090617333},1587.0911214255264,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"Z51/(Z13*1000)","v":1527.4961250609069},{"$f":"AA51/(AA13*1000)","v":1509.0774510100614},1505.1104738564293,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"AG51/(AG13*1000)","v":801.57},{"$f":"AH51/(AH13*1000)","v":806.54},801.85,823.79499999999996,1080.625,808.36,null,{"$f":"AN51/(AN13*1000)","v":1250.9699999999998},{"$f":"AO51/(AO13*1000)","v":1258.1099999999999},1251.5299999999997,1282.6799999999998,1653.645,1277.1499999999999,null,{"$f":"AU51/(AU13*1000)","v":1730.855},1740.865,1731.66,1775.2349999999999,2215.9549999999999,1783.075,null,{"$f":"BB51/(BB13*1000)","v":2182.7750000000001},2195.5149999999999,2183.7199999999998,2239.44,2780.7849999999999,2260.2649999999999]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2024-2025",null,{"$f":"\"Capital Costs without AFUDC ($\"&B69&\")\"","v":"Capital Costs without AFUDC ($2024-2025)"},{"$f":"E51","v":597192339.49420857},{"$f":"F51","v":606842339.49420857},603272339.49420846,637952339.49420857,721567840.39420843,674178692.6942085,null,{"$f":"L51","v":570292339.49420857},{"$f":"M51","v":579942339.49420857},576372339.49420857,611052339.49420857,694667840.39420855,647278692.6942085,null,517265925.21891892,525925217.46891892,520766210.46891892,0,0,0,null,{"$f":"Z51","v":490365925.21891892},499025217.46891892,493866210.46891892,0,0,0,null,{"$f":"AG51","v":160314000},{"$f":"AH51","v":161308000},160370000,164759000,216125000,161672000,null,{"$f":"AN51","v":250193999.99999997},{"$f":"AO51","v":251621999.99999997},250305999.99999997,256535999.99999997,330729000,255429999.99999997,null,{"$f":"AU51","v":346171000},{"$f":"AV51","v":348173000},346332000,355047000,443191000,356615000,null,{"$f":"BB51","v":436555000},{"$f":"BC51","v":439103000},436744000,447888000,556157000,452053000]
[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":"E52","v":1535.1988161804848},{"$f":"F52","v":1515.9688720814604},1518.0481617871376,1605.3153988279028,1785.6170264642624,1668.7591403321992,null,{"$f":"L52","v":1466.047145229328},1448.7692717816851,1450.3581768852757,1537.6254139260407,1719.0493451972495,1602.1749819163576,null,1611.2899689047554,1590.4244090617333,1587.0911214255264,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"Z52","v":1527.4961250609069},1509.0774510100614,1505.1104738564293,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"AG52","v":801.57},{"$f":"AH52","v":806.54},801.85,823.79499999999996,1080.625,808.36,null,{"$f":"AN52","v":1250.9699999999998},{"$f":"AO52","v":1258.1099999999999},1251.5299999999997,1282.6799999999998,1653.645,1277.1499999999999,null,{"$f":"AU52","v":1730.855},{"$f":"AV52","v":1740.865},1731.66,1775.2349999999999,2215.9549999999999,1783.075,null,{"$f":"BB52","v":2182.7750000000001},{"$f":"BC52","v":2195.5149999999999},2183.7199999999998,2239.44,2780.7849999999999,2260.2649999999999]
[null,"2024-2025",null,{"$f":"\"Total EPC Costs ($\"&B69&\")\"","v":"Total EPC Costs ($2024-2025)"},{"$f":"E22","v":449530000},{"$f":"F22","v":458680000},461660000,494540000,550860000,537420000,null,{"$f":"L22","v":422630000},{"$f":"M22","v":431780000},434760000.00000006,467640000.00000006,523960000.00000006,510520000,null,373750000,381960000,383440000,0,0,0,null,{"$f":"Z22","v":346850000},355060000,356540000,0,0,0,null,{"$f":"AG22","v":167830000},{"$f":"AH22","v":169190000},167910000,173860000,206100000,177820000,null,{"$f":"AN22","v":288940000},{"$f":"AO22","v":290870000},289090000,297530000,360650000,304170000,null,{"$f":"AU22","v":418040000},{"$f":"AV22","v":420750000},418260000,430060000,511960000,440330000,null,{"$f":"BB22","v":539510000},{"$f":"BC22","v":542970000},539770000,554860000,663880000,568650000]
[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":1155.6041131105399},{"$f":"IFERROR(F71/(F$13*1000),\"-\")","v":1145.8406195353484},1161.7010568696528,1244.43885254152,1363.177431328879,1330.2475247524753,null,{"$f":"IFERROR(L71/(L$13*1000),\"-\")","v":1086.4524421593831},{"$f":"IFERROR(M71/(M$13*1000),\"-\")","v":1078.6410192355734},1094.0110719677907,1176.7488676396579,1296.609750061866,1263.6633663366338,null,1164.2360273843267,1155.0663233240386,1168.5747027470102,"-","-","-",null,{"$f":"IFERROR(Z71/(Z$13*1000),\"-\")","v":1080.4421835404783},1073.7193652723668,1086.5940551779131,"-","-","-",null,839.15,845.95,839.55,869.3,1030.5,889.1,null,{"$f":"IFERROR(AN71/(AN$13*1000),\"-\")","v":1444.7},{"$f":"IFERROR(AO71/(AO$13*1000),\"-\")","v":1454.35},{"$f":"IFERROR(AP71/(AP$13*1000),\"-\")","v":1445.45},1487.65,{"$f":"IFERROR(AR71/(AR$13*1000),\"-\")","v":1803.25},1520.85,null,{"$f":"IFERROR(AU71/(AU$13*1000),\"-\")","v":2090.1999999999998},2103.75,2091.3000000000002,2150.3000000000002,2559.8000000000002,2201.65,null,{"$f":"IFERROR(BB71/(BB$13*1000),\"-\")","v":2697.55},2714.85,2698.85,2774.3,3319.4,2843.25]