{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["AGCC Annual","AGCC Summer","AGCC Winter","ICAP Prices","DC Model","Demand","Supply","ICAP 2017"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":17,"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":"AGCC Annual","index":0,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["Annual Avoided Generation Capacity Costs (AGCC) due to 1 kW reduction in Peak Load*"]
["All Prices in 2017 Dollars"]
[]
["Year","AGCC at Transmission Level",null,null,null,"AGCC at Distribution Level**",null,null,null,null,"Generator ICAP Prices by Region"]
[null,"NYC","LHV","LI","ROS","NYC","LHV","LI","ROS",null,"NYC","LHV","LI","ROS"]
[{"$f":"'ICAP Prices'!A9","v":2017},{"$f":"6*'AGCC Summer'!B6+6*'AGCC Winter'!B6","v":85.970797168446268},{"$f":"6*'AGCC Summer'!C6+6*'AGCC Winter'!C6","v":83.354583098431021},{"$f":"6*'AGCC Summer'!D6+6*'AGCC Winter'!D6","v":62.184843234124457},{"$f":"6*'AGCC Summer'!E6+6*'AGCC Winter'!E6","v":18.4585632660987},{"$f":"6*'AGCC Summer'!F6+6*'AGCC Winter'!F6","v":92.640945224618818},{"$f":"6*'AGCC Summer'!G6+6*'AGCC Winter'!G6","v":89.821749028481705},{"$f":"6*'AGCC Summer'!H6+6*'AGCC Winter'!H6","v":67.009529347116882},{"$f":"6*'AGCC Summer'!I6+6*'AGCC Winter'!I6","v":19.890693174675324},null,{"$f":"6*'AGCC Summer'!K6+6*'AGCC Winter'!K6","v":83.396949328085284},{"$f":"6*'AGCC Summer'!L6+6*'AGCC Winter'!L6","v":80.43255192272008},{"$f":"6*'AGCC Summer'!M6+6*'AGCC Winter'!M6","v":53.028092994018998},{"$f":"6*'AGCC Summer'!N6+6*'AGCC Winter'!N6","v":14.373112752886101}]
[{"$f":"'ICAP Prices'!A10","v":2018},{"$f":"6*'AGCC Summer'!B7+6*'AGCC Winter'!B7","v":75.010712236338605},{"$f":"6*'AGCC Summer'!C7+6*'AGCC Winter'!C7","v":50.377548560187947},{"$f":"6*'AGCC Summer'!D7+6*'AGCC Winter'!D7","v":62.016102947704795},{"$f":"6*'AGCC Summer'!E7+6*'AGCC Winter'!E7","v":21.061837432708437},{"$f":"6*'AGCC Summer'!F7+6*'AGCC Winter'!F7","v":80.83050887536487},{"$f":"6*'AGCC Summer'!G7+6*'AGCC Winter'!G7","v":54.286151465719762},{"$f":"6*'AGCC Summer'!H7+6*'AGCC Winter'!H7","v":66.827697141923267},{"$f":"6*'AGCC Summer'!I7+6*'AGCC Winter'!I7","v":22.695945509384089},null,{"$f":"6*'AGCC Summer'!K7+6*'AGCC Winter'!K7","v":73.358286025622306},{"$f":"6*'AGCC Summer'!L7+6*'AGCC Winter'!L7","v":45.779439422076777},{"$f":"6*'AGCC Summer'!M7+6*'AGCC Winter'!M7","v":52.672479977833298},{"$f":"6*'AGCC Summer'!N7+6*'AGCC Winter'!N7","v":16.470100952960628}]
[{"$f":"'ICAP Prices'!A11","v":2019},{"$f":"6*'AGCC Summer'!B8+6*'AGCC Winter'!B8","v":80.42103646831282},{"$f":"6*'AGCC Summer'!C8+6*'AGCC Winter'!C8","v":52.698263637946667},{"$f":"6*'AGCC Summer'!D8+6*'AGCC Winter'!D8","v":46.331537522451441},{"$f":"6*'AGCC Summer'!E8+6*'AGCC Winter'!E8","v":20.139283806517568},{"$f":"6*'AGCC Summer'!F8+6*'AGCC Winter'!F8","v":86.660599642578475},{"$f":"6*'AGCC Summer'!G8+6*'AGCC Winter'!G8","v":56.786922023649431},{"$f":"6*'AGCC Summer'!H8+6*'AGCC Winter'!H8","v":49.926225778503706},{"$f":"6*'AGCC Summer'!I8+6*'AGCC Winter'!I8","v":21.701814446678412},null,{"$f":"6*'AGCC Summer'!K8+6*'AGCC Winter'!K8","v":79.390098188633985},{"$f":"6*'AGCC Summer'!L8+6*'AGCC Winter'!L8","v":48.303557287674096},{"$f":"6*'AGCC Summer'!M8+6*'AGCC Winter'!M8","v":38.894409310079517},{"$f":"6*'AGCC Summer'!N8+6*'AGCC Winter'!N8","v":15.724856892920322}]
[{"$f":"'ICAP Prices'!A12","v":2020},{"$f":"6*'AGCC Summer'!B9+6*'AGCC Winter'!B9","v":112.86534656174157},{"$f":"6*'AGCC Summer'!C9+6*'AGCC Winter'!C9","v":112.86534656174157},{"$f":"6*'AGCC Summer'!D9+6*'AGCC Winter'!D9","v":46.78689667831906},{"$f":"6*'AGCC Summer'!E9+6*'AGCC Winter'!E9","v":33.826186037287087},{"$f":"6*'AGCC Summer'!F9+6*'AGCC Winter'!F9","v":121.62214069153187},{"$f":"6*'AGCC Summer'!G9+6*'AGCC Winter'!G9","v":121.62214069153188},{"$f":"6*'AGCC Summer'!H9+6*'AGCC Winter'!H9","v":50.416914524050718},{"$f":"6*'AGCC Summer'!I9+6*'AGCC Winter'!I9","v":36.450631505697295},null,{"$f":"6*'AGCC Summer'!K9+6*'AGCC Winter'!K9","v":108.64502425551768},{"$f":"6*'AGCC Summer'!L9+6*'AGCC Winter'!L9","v":108.64502425551768},{"$f":"6*'AGCC Summer'!M9+6*'AGCC Winter'!M9","v":37.956111729621753},{"$f":"6*'AGCC Summer'!N9+6*'AGCC Winter'!N9","v":26.58618059197963}]
[{"$f":"'ICAP Prices'!A13","v":2021},{"$f":"6*'AGCC Summer'!B10+6*'AGCC Winter'!B10","v":143.932992625738},{"$f":"6*'AGCC Summer'!C10+6*'AGCC Winter'!C10","v":143.932992625738},{"$f":"6*'AGCC Summer'!D10+6*'AGCC Winter'!D10","v":49.373028162803337},{"$f":"6*'AGCC Summer'!E10+6*'AGCC Winter'!E10","v":39.457677236090248},{"$f":"6*'AGCC Summer'!F10+6*'AGCC Winter'!F10","v":155.10020757083836},{"$f":"6*'AGCC Summer'!G10+6*'AGCC Winter'!G10","v":155.10020757083836},{"$f":"6*'AGCC Summer'!H10+6*'AGCC Winter'!H10","v":53.203694140951875},{"$f":"6*'AGCC Summer'!I10+6*'AGCC Winter'!I10","v":42.519048745786904},null,{"$f":"6*'AGCC Summer'!K10+6*'AGCC Winter'!K10","v":142.49536347385066},{"$f":"6*'AGCC Summer'!L10+6*'AGCC Winter'!L10","v":142.49536347385066},{"$f":"6*'AGCC Summer'!M10+6*'AGCC Winter'!M10","v":39.815295443426834},{"$f":"6*'AGCC Summer'!N10+6*'AGCC Winter'!N10","v":31.120303159230758}]
[{"$f":"'ICAP Prices'!A14","v":2022},{"$f":"6*'AGCC Summer'!B11+6*'AGCC Winter'!B11","v":144.09371799795247},{"$f":"6*'AGCC Summer'!C11+6*'AGCC Winter'!C11","v":144.09371799795247},{"$f":"6*'AGCC Summer'!D11+6*'AGCC Winter'!D11","v":50.248939398035077},{"$f":"6*'AGCC Summer'!E11+6*'AGCC Winter'!E11","v":40.13718857651935},{"$f":"6*'AGCC Summer'!F11+6*'AGCC Winter'!F11","v":155.27340301503494},{"$f":"6*'AGCC Summer'!G11+6*'AGCC Winter'!G11","v":155.27340301503494},{"$f":"6*'AGCC Summer'!H11+6*'AGCC Winter'!H11","v":54.147564006503309},{"$f":"6*'AGCC Summer'!I11+6*'AGCC Winter'!I11","v":43.251280793663085},null,{"$f":"6*'AGCC Summer'!K11+6*'AGCC Winter'!K11","v":142.49269315721824},{"$f":"6*'AGCC Summer'!L11+6*'AGCC Winter'!L11","v":142.49269315721824},{"$f":"6*'AGCC Summer'!M11+6*'AGCC Winter'!M11","v":40.543827248228638},{"$f":"6*'AGCC Summer'!N11+6*'AGCC Winter'!N11","v":31.668035186140962}]
[{"$f":"'ICAP Prices'!A15","v":2023},{"$f":"6*'AGCC Summer'!B12+6*'AGCC Winter'!B12","v":144.43616619497095},{"$f":"6*'AGCC Summer'!C12+6*'AGCC Winter'!C12","v":144.43616619497095},{"$f":"6*'AGCC Summer'!D12+6*'AGCC Winter'!D12","v":53.149659332971154},{"$f":"6*'AGCC Summer'!E12+6*'AGCC Winter'!E12","v":41.605532308366065},{"$f":"6*'AGCC Summer'!F12+6*'AGCC Winter'!F12","v":155.64242046871868},{"$f":"6*'AGCC Summer'!G12+6*'AGCC Winter'!G12","v":155.64242046871868},{"$f":"6*'AGCC Summer'!H12+6*'AGCC Winter'!H12","v":57.273339798460299},{"$f":"6*'AGCC Summer'!I12+6*'AGCC Winter'!I12","v":44.833547746084122},null,{"$f":"6*'AGCC Summer'!K12+6*'AGCC Winter'!K12","v":142.48381360857093},{"$f":"6*'AGCC Summer'!L12+6*'AGCC Winter'!L12","v":142.48381360857093},{"$f":"6*'AGCC Summer'!M12+6*'AGCC Winter'!M12","v":43.02809323089776},{"$f":"6*'AGCC Summer'!N12+6*'AGCC Winter'!N12","v":32.85390033615603}]
[{"$f":"'ICAP Prices'!A16","v":2024},{"$f":"6*'AGCC Summer'!B13+6*'AGCC Winter'!B13","v":144.68849036029056},{"$f":"6*'AGCC Summer'!C13+6*'AGCC Winter'!C13","v":144.68849036029056},{"$f":"6*'AGCC Summer'!D13+6*'AGCC Winter'!D13","v":54.541616054429959},{"$f":"6*'AGCC Summer'!E13+6*'AGCC Winter'!E13","v":42.709559000557469},{"$f":"6*'AGCC Summer'!F13+6*'AGCC Winter'!F13","v":155.91432150893377},{"$f":"6*'AGCC Summer'!G13+6*'AGCC Winter'!G13","v":155.91432150893377},{"$f":"6*'AGCC Summer'!H13+6*'AGCC Winter'!H13","v":58.77329316210124},{"$f":"6*'AGCC Summer'!I13+6*'AGCC Winter'!I13","v":46.023231681635203},null,{"$f":"6*'AGCC Summer'!K13+6*'AGCC Winter'!K13","v":142.4734957626078},{"$f":"6*'AGCC Summer'!L13+6*'AGCC Winter'!L13","v":142.4734957626078},{"$f":"6*'AGCC Summer'!M13+6*'AGCC Winter'!M13","v":44.191639327689757},{"$f":"6*'AGCC Summer'!N13+6*'AGCC Winter'!N13","v":33.74763569547148}]
[{"$f":"'ICAP Prices'!A17","v":2025},{"$f":"6*'AGCC Summer'!B14+6*'AGCC Winter'!B14","v":144.99773789626977},{"$f":"6*'AGCC Summer'!C14+6*'AGCC Winter'!C14","v":144.99773789626977},{"$f":"6*'AGCC Summer'!D14+6*'AGCC Winter'!D14","v":57.249032973499396},{"$f":"6*'AGCC Summer'!E14+6*'AGCC Winter'!E14","v":44.087732717597319},{"$f":"6*'AGCC Summer'!F14+6*'AGCC Winter'!F14","v":156.24756238822175},{"$f":"6*'AGCC Summer'!G14+6*'AGCC Winter'!G14","v":156.24756238822175},{"$f":"6*'AGCC Summer'!H14+6*'AGCC Winter'!H14","v":61.690768290408826},{"$f":"6*'AGCC Summer'!I14+6*'AGCC Winter'!I14","v":47.508332669824696},null,{"$f":"6*'AGCC Summer'!K14+6*'AGCC Winter'!K14","v":142.45678764590303},{"$f":"6*'AGCC Summer'!L14+6*'AGCC Winter'!L14","v":142.45678764590303},{"$f":"6*'AGCC Summer'!M14+6*'AGCC Winter'!M14","v":46.52776412694945},{"$f":"6*'AGCC Summer'!N14+6*'AGCC Winter'!N14","v":34.865824260667509}]
[{"$f":"'ICAP Prices'!A18","v":2026},{"$f":"6*'AGCC Summer'!B15+6*'AGCC Winter'!B15","v":145.29254433862687},{"$f":"6*'AGCC Summer'!C15+6*'AGCC Winter'!C15","v":145.29254433862687},{"$f":"6*'AGCC Summer'!D15+6*'AGCC Winter'!D15","v":59.138701354871571},{"$f":"6*'AGCC Summer'!E15+6*'AGCC Winter'!E15","v":45.433509374564132},{"$f":"6*'AGCC Summer'!F15+6*'AGCC Winter'!F15","v":156.56524174420997},{"$f":"6*'AGCC Summer'!G15+6*'AGCC Winter'!G15","v":156.56524174420997},{"$f":"6*'AGCC Summer'!H15+6*'AGCC Winter'!H15","v":63.727048873784014},{"$f":"6*'AGCC Summer'!I15+6*'AGCC Winter'!I15","v":48.958523032935489},null,{"$f":"6*'AGCC Summer'!K15+6*'AGCC Winter'!K15","v":142.43527066020377},{"$f":"6*'AGCC Summer'!L15+6*'AGCC Winter'!L15","v":142.43527066020377},{"$f":"6*'AGCC Summer'!M15+6*'AGCC Winter'!M15","v":48.132253543742308},{"$f":"6*'AGCC Summer'!N15+6*'AGCC Winter'!N15","v":35.960498242219657}]
[{"$f":"'ICAP Prices'!A19","v":2027},{"$f":"6*'AGCC Summer'!B16+6*'AGCC Winter'!B16","v":145.67122917549011},{"$f":"6*'AGCC Summer'!C16+6*'AGCC Winter'!C16","v":145.67122917549011},{"$f":"6*'AGCC Summer'!D16+6*'AGCC Winter'!D16","v":63.015079692181821},{"$f":"6*'AGCC Summer'!E16+6*'AGCC Winter'!E16","v":47.110611062501981},{"$f":"6*'AGCC Summer'!F16+6*'AGCC Winter'!F16","v":156.97330730117466},{"$f":"6*'AGCC Summer'!G16+6*'AGCC Winter'!G16","v":156.97330730117466},{"$f":"6*'AGCC Summer'!H16+6*'AGCC Winter'!H16","v":67.904180702782128},{"$f":"6*'AGCC Summer'!I16+6*'AGCC Winter'!I16","v":50.765744679420237},null,{"$f":"6*'AGCC Summer'!K16+6*'AGCC Winter'!K16","v":142.42458523347671},{"$f":"6*'AGCC Summer'!L16+6*'AGCC Winter'!L16","v":142.42458523347671},{"$f":"6*'AGCC Summer'!M16+6*'AGCC Winter'!M16","v":51.536115283424301},{"$f":"6*'AGCC Summer'!N16+6*'AGCC Winter'!N16","v":37.327558812513786}]
[{"$f":"'ICAP Prices'!A20","v":2028},{"$f":"6*'AGCC Summer'!B17+6*'AGCC Winter'!B17","v":145.97695388917407},{"$f":"6*'AGCC Summer'!C17+6*'AGCC Winter'!C17","v":145.97695388917407},{"$f":"6*'AGCC Summer'!D17+6*'AGCC Winter'!D17","v":65.514837581921356},{"$f":"6*'AGCC Summer'!E17+6*'AGCC Winter'!E17","v":48.496091957592412},{"$f":"6*'AGCC Summer'!F17+6*'AGCC Winter'!F17","v":157.30275203574791},{"$f":"6*'AGCC Summer'!G17+6*'AGCC Winter'!G17","v":157.30275203574791},{"$f":"6*'AGCC Summer'!H17+6*'AGCC Winter'!H17","v":70.597885325346283},{"$f":"6*'AGCC Summer'!I17+6*'AGCC Winter'!I17","v":52.258719781888374},null,{"$f":"6*'AGCC Summer'!K17+6*'AGCC Winter'!K17","v":142.41108060808597},{"$f":"6*'AGCC Summer'!L17+6*'AGCC Winter'!L17","v":142.41108060808597},{"$f":"6*'AGCC Summer'!M17+6*'AGCC Winter'!M17","v":53.717779009056457},{"$f":"6*'AGCC Summer'!N17+6*'AGCC Winter'!N17","v":38.460104440381755}]
[{"$f":"'ICAP Prices'!A21","v":2029},{"$f":"6*'AGCC Summer'!B18+6*'AGCC Winter'!B18","v":146.27940810978242},{"$f":"6*'AGCC Summer'!C18+6*'AGCC Winter'!C18","v":146.27940810978242},{"$f":"6*'AGCC Summer'!D18+6*'AGCC Winter'!D18","v":67.997064974323663},{"$f":"6*'AGCC Summer'!E18+6*'AGCC Winter'!E18","v":49.878470087427402},{"$f":"6*'AGCC Summer'!F18+6*'AGCC Winter'!F18","v":157.62867253209311},{"$f":"6*'AGCC Summer'!G18+6*'AGCC Winter'!G18","v":157.62867253209311},{"$f":"6*'AGCC Summer'!H18+6*'AGCC Winter'!H18","v":73.272699325779797},{"$f":"6*'AGCC Summer'!I18+6*'AGCC Winter'!I18","v":53.74835138731401},null,{"$f":"6*'AGCC Summer'!K18+6*'AGCC Winter'!K18","v":142.39761470853688},{"$f":"6*'AGCC Summer'!L18+6*'AGCC Winter'!L18","v":142.39761470853688},{"$f":"6*'AGCC Summer'!M18+6*'AGCC Winter'!M18","v":55.893879022797556},{"$f":"6*'AGCC Summer'!N18+6*'AGCC Winter'!N18","v":39.592838688998071}]
[{"$f":"'ICAP Prices'!A22","v":2030},{"$f":"6*'AGCC Summer'!B19+6*'AGCC Winter'!B19","v":146.83870733340939},{"$f":"6*'AGCC Summer'!C19+6*'AGCC Winter'!C19","v":146.57858725985415},{"$f":"6*'AGCC Summer'!D19+6*'AGCC Winter'!D19","v":70.461885372535221},{"$f":"6*'AGCC Summer'!E19+6*'AGCC Winter'!E19","v":51.257730841302703},{"$f":"6*'AGCC Summer'!F19+6*'AGCC Winter'!F19","v":158.23136566100152},{"$f":"6*'AGCC Summer'!G19+6*'AGCC Winter'!G19","v":157.95106385760141},{"$f":"6*'AGCC Summer'!H19+6*'AGCC Winter'!H19","v":75.928755789369845},{"$f":"6*'AGCC Summer'!I19+6*'AGCC Winter'!I19","v":55.234623751403781},null,{"$f":"6*'AGCC Summer'!K19+6*'AGCC Winter'!K19","v":142.69227208530907},{"$f":"6*'AGCC Summer'!L19+6*'AGCC Winter'!L19","v":142.38418742377925},{"$f":"6*'AGCC Summer'!M19+6*'AGCC Winter'!M19","v":58.064429899978919},{"$f":"6*'AGCC Summer'!N19+6*'AGCC Winter'!N19","v":40.725750915392901}]
[{"$f":"'ICAP Prices'!A23","v":2031},{"$f":"6*'AGCC Summer'!B20+6*'AGCC Winter'!B20","v":149.15644724067857},{"$f":"6*'AGCC Summer'!C20+6*'AGCC Winter'!C20","v":146.87448689784443},{"$f":"6*'AGCC Summer'!D20+6*'AGCC Winter'!D20","v":72.909421284467413},{"$f":"6*'AGCC Summer'!E20+6*'AGCC Winter'!E20","v":52.633859780587585},{"$f":"6*'AGCC Summer'!F20+6*'AGCC Winter'!F20","v":160.72893021624844},{"$f":"6*'AGCC Summer'!G20+6*'AGCC Winter'!G20","v":158.26992122612546},{"$f":"6*'AGCC Summer'!H20+6*'AGCC Winter'!H20","v":78.566186728951948},{"$f":"6*'AGCC Summer'!I20+6*'AGCC Winter'!I20","v":56.717521315288344},null,{"$f":"6*'AGCC Summer'!K20+6*'AGCC Winter'!K20","v":145.08369060716527},{"$f":"6*'AGCC Summer'!L20+6*'AGCC Winter'!L20","v":142.37079864308146},{"$f":"6*'AGCC Summer'!M20+6*'AGCC Winter'!M20","v":60.229446165161612},{"$f":"6*'AGCC Summer'!N20+6*'AGCC Winter'!N20","v":41.858830515328265}]
[{"$f":"'ICAP Prices'!A24","v":2032},{"$f":"6*'AGCC Summer'!B21+6*'AGCC Winter'!B21","v":151.44822691960485},{"$f":"6*'AGCC Summer'!C21+6*'AGCC Winter'!C21","v":147.16710271762491},{"$f":"6*'AGCC Summer'!D21+6*'AGCC Winter'!D21","v":75.900948319677013},{"$f":"6*'AGCC Summer'!E21+6*'AGCC Winter'!E21","v":54.006842638327427},{"$f":"6*'AGCC Summer'!F21+6*'AGCC Winter'!F21","v":163.19852038750523},{"$f":"6*'AGCC Summer'!G21+6*'AGCC Winter'!G21","v":158.58523999744062},{"$f":"6*'AGCC Summer'!H21+6*'AGCC Winter'!H21","v":81.789814999651952},{"$f":"6*'AGCC Summer'!I21+6*'AGCC Winter'!I21","v":58.197028705094212},null,{"$f":"6*'AGCC Summer'!K21+6*'AGCC Winter'!K21","v":147.46614862603724},{"$f":"6*'AGCC Summer'!L21+6*'AGCC Winter'!L21","v":142.35744825602933},{"$f":"6*'AGCC Summer'!M21+6*'AGCC Winter'!M21","v":62.860761758122969},{"$f":"6*'AGCC Summer'!N21+6*'AGCC Winter'!N21","v":42.992066923401474}]
[{"$f":"'ICAP Prices'!A25","v":2033},{"$f":"6*'AGCC Summer'!B22+6*'AGCC Winter'!B22","v":153.71423993255533},{"$f":"6*'AGCC Summer'!C22+6*'AGCC Winter'!C22","v":147.45643054797847},{"$f":"6*'AGCC Summer'!D22+6*'AGCC Winter'!D22","v":79.668085452842277},{"$f":"6*'AGCC Summer'!E22+6*'AGCC Winter'!E22","v":55.376665318838093},{"$f":"6*'AGCC Summer'!F22+6*'AGCC Winter'!F22","v":165.64034475490874},{"$f":"6*'AGCC Summer'!G22+6*'AGCC Winter'!G22","v":158.89701567670093},{"$f":"6*'AGCC Summer'!H22+6*'AGCC Winter'!H22","v":85.849230013838664},{"$f":"6*'AGCC Summer'!I22+6*'AGCC Winter'!I22","v":59.673130731506568},null,{"$f":"6*'AGCC Summer'!K22+6*'AGCC Winter'!K22","v":149.83967970610169},{"$f":"6*'AGCC Summer'!L22+6*'AGCC Winter'!L22","v":142.34413615252527},{"$f":"6*'AGCC Summer'!M22+6*'AGCC Winter'!M22","v":66.158717789222024},{"$f":"6*'AGCC Summer'!N22+6*'AGCC Winter'!N22","v":44.125449613145804}]
[{"$f":"'ICAP Prices'!A26","v":2034},{"$f":"6*'AGCC Summer'!B23+6*'AGCC Winter'!B23","v":155.95467839316581},{"$f":"6*'AGCC Summer'!C23+6*'AGCC Winter'!C23","v":147.74246635208925},{"$f":"6*'AGCC Summer'!D23+6*'AGCC Winter'!D23","v":83.401558644631805},{"$f":"6*'AGCC Summer'!E23+6*'AGCC Winter'!E23","v":56.743313897294783},{"$f":"6*'AGCC Summer'!F23+6*'AGCC Winter'!F23","v":168.05461033746315},{"$f":"6*'AGCC Summer'!G23+6*'AGCC Winter'!G23","v":159.20524391388926},{"$f":"6*'AGCC Summer'!H23+6*'AGCC Winter'!H23","v":89.872369229129106},{"$f":"6*'AGCC Summer'!I23+6*'AGCC Winter'!I23","v":61.145812389326281},null,{"$f":"6*'AGCC Summer'!K23+6*'AGCC Winter'!K23","v":152.20431728584043},{"$f":"6*'AGCC Summer'!L23+6*'AGCC Winter'!L23","v":142.33086222278735},{"$f":"6*'AGCC Summer'!M23+6*'AGCC Winter'!M23","v":69.445075659965738},{"$f":"6*'AGCC Summer'!N23+6*'AGCC Winter'!N23","v":45.258968097130733}]
[{"$f":"'ICAP Prices'!A27","v":2035},{"$f":"6*'AGCC Summer'!B24+6*'AGCC Winter'!B24","v":158.16973297804816},{"$f":"6*'AGCC Summer'!C24+6*'AGCC Winter'!C24","v":148.02520622702673},{"$f":"6*'AGCC Summer'!D24+6*'AGCC Winter'!D24","v":87.10164402050647},{"$f":"6*'AGCC Summer'!E24+6*'AGCC Winter'!E24","v":58.10677461931116},{"$f":"6*'AGCC Summer'!F24+6*'AGCC Winter'!F24","v":170.44152260565534},{"$f":"6*'AGCC Summer'!G24+6*'AGCC Winter'!G24","v":159.50992050326153},{"$f":"6*'AGCC Summer'!H24+6*'AGCC Winter'!H24","v":93.859530194511265},{"$f":"6*'AGCC Summer'!I24+6*'AGCC Winter'!I24","v":62.615058857016336},null,{"$f":"6*'AGCC Summer'!K24+6*'AGCC Winter'!K24","v":154.56009467851095},{"$f":"6*'AGCC Summer'!L24+6*'AGCC Winter'!L24","v":142.31762635734876},{"$f":"6*'AGCC Summer'!M24+6*'AGCC Winter'!M24","v":72.719876158443014},{"$f":"6*'AGCC Summer'!N24+6*'AGCC Winter'!N24","v":46.392611927058063}]
[{"$f":"'ICAP Prices'!A28","v":2036},{"$f":"6*'AGCC Summer'!B25+6*'AGCC Winter'!B25","v":162.2800009023259},{"$f":"6*'AGCC Summer'!C25+6*'AGCC Winter'!C25","v":148.30464640322447},{"$f":"6*'AGCC Summer'!D25+6*'AGCC Winter'!D25","v":90.768615433875894},{"$f":"6*'AGCC Summer'!E25+6*'AGCC Winter'!E25","v":59.46703390051475},{"$f":"6*'AGCC Summer'!F25+6*'AGCC Winter'!F25","v":174.87069062750635},{"$f":"6*'AGCC Summer'!G25+6*'AGCC Winter'!G25","v":159.81104138278496},{"$f":"6*'AGCC Summer'!H25+6*'AGCC Winter'!H25","v":97.811008010642126},{"$f":"6*'AGCC Summer'!I25+6*'AGCC Winter'!I25","v":64.08085549624434},null,{"$f":"6*'AGCC Summer'!K25+6*'AGCC Winter'!K25","v":159.06752024199267},{"$f":"6*'AGCC Summer'!L25+6*'AGCC Winter'!L25","v":142.3044284470561},{"$f":"6*'AGCC Summer'!M25+6*'AGCC Winter'!M25","v":75.983159929300101},{"$f":"6*'AGCC Summer'!N25+6*'AGCC Winter'!N25","v":47.526370693858972}]
[{"$f":"'ICAP Prices'!A29","v":2037},{"$f":"6*'AGCC Summer'!B26+6*'AGCC Winter'!B26","v":166.69132759292447},{"$f":"6*'AGCC Summer'!C26+6*'AGCC Winter'!C26","v":148.58078324395478},{"$f":"6*'AGCC Summer'!D26+6*'AGCC Winter'!D26","v":94.402744484634042},{"$f":"6*'AGCC Summer'!E26+6*'AGCC Winter'!E26","v":60.824078326112669},{"$f":"6*'AGCC Summer'!F26+6*'AGCC Winter'!F26","v":179.62427542340998},{"$f":"6*'AGCC Summer'!G26+6*'AGCC Winter'!G26","v":160.10860263357196},{"$f":"6*'AGCC Summer'!H26+6*'AGCC Winter'!H26","v":101.72709534982116},{"$f":"6*'AGCC Summer'!I26+6*'AGCC Winter'!I26","v":65.543187851414515},null,{"$f":"6*'AGCC Summer'!K26+6*'AGCC Winter'!K26","v":163.95058613106602},{"$f":"6*'AGCC Summer'!L26+6*'AGCC Winter'!L26","v":142.29126838306954},{"$f":"6*'AGCC Summer'!M26+6*'AGCC Winter'!M26","v":79.234967474245678},{"$f":"6*'AGCC Summer'!N26+6*'AGCC Winter'!N26","v":48.660234027786871}]
[]
["*Based on 2017 Gold Book"]
["**AGCC at Distribution Level = AGCC at Transmission Level / (1-Distribution Losses)"]
[null,"Assumed Distribution Losses:",null,null,7.1999999999999995E-2]
[]
["NYC = New York City (Load Zone J)"]
["LHV = Lower Hudson Valley (Load Zones GHI)"]
["LI = Long Island (Load Zone K)"]
["ROS = Rest of State (Upstate Load Zones A-F)"]
["NYCA=NY Control Area (Statewide)"]
[]
["2017 ICAP Demand Curve Reference Prices:"]
[null,"NYC","LHV","LI","NYCA"]
[null,{"$f":"'DC Model'!E12","v":18.61},{"$f":"'DC Model'!H12","v":14.84},{"$f":"'DC Model'!K12","v":12.72},{"$f":"'DC Model'!N12","v":9.08}]
[]
["2017 Minimum Locational ICAP Requirements (LCRs):"]
[null,"NYC","LHV","LI","NYCA"]
[null,{"$f":"'DC Model'!D6","v":0.81499999999999995},{"$f":"'DC Model'!G6","v":0.91500000000000004},{"$f":"'DC Model'!J6","v":1.0349999999999999},{"$f":"'DC Model'!M6","v":1.18}]

{"sheet":"AGCC Summer","index":1,"n_rows":44,"n_cols":18,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["Summer Month Avoided Generation Capacity Costs (AGCC) due to 1 kW reduction in Peak Load*"]
["All Prices in 2017 Dollars"]
[]
["Year","Avoided GCC at Transmission Level",null,null,null,"Avoided GCC at Distribution Level",null,null,null,null,"Generator ICAP Prices by Region",null,null,null,"Capacity Obligation at Forecasted Price"]
[null,"NYC","LHV","LI","ROS","NYC","LHV","LI","ROS",null,"NYC","LHV","LI","ROS","NYC","LHV","LI","NYCA"]
[{"$f":"'ICAP Prices'!A9","v":2017},{"$f":"O6*K6+(P6-O6)*L6+(R6-P6)*N6","v":10.406463769873794},{"$f":"L6*P6+N6*(R6-P6)","v":9.9704280915379204},{"$f":"M6*Q6+(R6-Q6)*N6","v":8.7035815804429131},{"$f":"N6*R6","v":3.0764272110164499},{"$f":"B6/(1-$E$30)","v":11.213861820984691},{"$f":"C6/(1-$E$30)","v":10.743995788295173},{"$f":"D6/(1-$E$30)","v":9.3788594616841738},{"$f":"E6/(1-$E$30)","v":3.3151155291125538},null,{"$f":"'ICAP Prices'!$C9","v":10.041409606019664},{"$f":"'ICAP Prices'!$F9","v":9.547343371792131},{"$f":"'ICAP Prices'!$I9","v":7.4554264640298129},{"$f":"'ICAP Prices'!$L9","v":2.3955187921476835},{"$f":"B$44*(1+0.18*(1-K6/B$40))","v":0.88254498714652951},{"$f":"C$44*(1+0.15*(1-L6/C$40))","v":0.96394994085050745},{"$f":"D$44*(1+0.18*(1-M6/D$40))","v":1.1121061359867332},{"$f":"E$44*(1+0.12*(1-N6/E$40))","v":1.2842425703779612}]
[{"$f":"'ICAP Prices'!A10","v":2018},10.678778060908353,7.4397356635242424,8.7732485171892627,3.5103062387847395,11.507303944944345,8.0169565339700881,9.4539315917987743,3.7826575848973483,null,{"$f":"'ICAP Prices'!$C10","v":10.395251472720462},{"$f":"'ICAP Prices'!$F10","v":6.7134993782892085},{"$f":"'ICAP Prices'!$I10","v":7.4788896932829889},{"$f":"'ICAP Prices'!$L10","v":2.7450168254934377},0.87975570171692141,0.99015917859365266,1.1117624882186616,1.2787922486244634]
[{"$f":"'ICAP Prices'!A11","v":2019},11.073370756916429,7.6054467070586167,7.5916790508422478,3.3565473010862612,11.932511591504772,8.195524468813165,8.1806886323731121,3.616969074446402,null,{"$f":"'ICAP Prices'!$C11","v":10.879329165204254},{"$f":"'ICAP Prices'!$F11","v":6.9202396175429399},{"$f":"'ICAP Prices'!$I11","v":6.3756211811435453},{"$f":"'ICAP Prices'!$L11","v":2.6208094821533869},0.87593978567783637,0.98824711000621501,1.1279212086441004,1.2807292265778722]
[{"$f":"'ICAP Prices'!A12","v":2020},12.381079757110021,12.381079757110021,6.7906882283105343,4.6305697881385379,13.341680772747866,13.341680772747866,7.3175519701622136,4.9898381337699762,null,{"$f":"'ICAP Prices'!$C12","v":11.886999288717782},{"$f":"'ICAP Prices'!$F12","v":11.886999288717782},{"$f":"'ICAP Prices'!$I12","v":5.5569881116221325},{"$f":"'ICAP Prices'!$L12","v":3.6619995886817795},0.86799646450000545,0.94231127679403537,1.1399110939311945,1.2644921650046983]
[{"$f":"'ICAP Prices'!A13","v":2021},14.97729689308585,14.97729689308585,6.7823748363254746,5.1298163485399604,16.13932854858389,16.13932854858389,7.308593573626589,5.5278193410990948,null,{"$f":"'ICAP Prices'!$C13","v":14.84},{"$f":"'ICAP Prices'!$F13","v":14.84},{"$f":"'ICAP Prices'!$I13","v":5.5268915615235112},{"$f":"'ICAP Prices'!$L13","v":4.0777261808241647},0.84471837721655019,0.91500000000000004,1.1403518948182523,1.258009027840892]
[{"$f":"'ICAP Prices'!A14","v":2022},14.98985705193949,14.98985705193949,6.868902307977617,5.1836105043916625,16.152863202521001,16.152863202521001,7.4018343835965696,5.5857871814565323,null,{"$f":"'ICAP Prices'!$C14","v":14.84},{"$f":"'ICAP Prices'!$F14","v":14.84},{"$f":"'ICAP Prices'!$I14","v":5.6020893354322867},{"$f":"'ICAP Prices'!$L14","v":4.1227906584176743},0.84471837721655019,0.91500000000000004,1.1392505311956733,1.2573062602167462]
[{"$f":"'ICAP Prices'!A15","v":2023},15.016911470004995,15.016911470004995,7.2242195301963932,5.3001983594288786,16.182016670264002,16.182016670264002,7.7847193213323198,5.7114206459362915,null,{"$f":"'ICAP Prices'!$C15","v":14.84},{"$f":"'ICAP Prices'!$F15","v":14.84},{"$f":"'ICAP Prices'!$I15","v":5.9163402249967163},{"$f":"'ICAP Prices'!$L15","v":4.2206414092064284},0.84471837721655019,0.91500000000000004,1.1346479415159678,1.2557803057771331]
[{"$f":"'ICAP Prices'!A16","v":2024},15.03719477946872,15.03719477946872,7.3602737360560173,5.3882642270772694,16.203873684772326,16.203873684772326,7.9313294569569148,5.8063192102125747,null,{"$f":"'ICAP Prices'!$C16","v":14.84},{"$f":"'ICAP Prices'!$F16","v":14.84},{"$f":"'ICAP Prices'!$I16","v":6.0353879798052841},{"$f":"'ICAP Prices'!$L16","v":4.2947207077689047},0.84471837721655019,0.91500000000000004,1.1329043411448327,1.2546250603281854]
[{"$f":"'ICAP Prices'!A17","v":2025},15.062425916981066,15.062425916981066,7.6921728181065898,5.4986227754562433,16.231062410539941,16.231062410539941,8.2889793298562378,5.9252400597588828,null,{"$f":"'ICAP Prices'!$C17","v":14.84},{"$f":"'ICAP Prices'!$F17","v":14.84},{"$f":"'ICAP Prices'!$I17","v":6.3314127738613912},{"$f":"'ICAP Prices'!$L17","v":4.3877561294810681},0.84471837721655019,0.91500000000000004,1.1285686949866054,1.2531741995666827]
[{"$f":"'ICAP Prices'!A18","v":2026},15.086993493621957,15.086993493621957,7.8911669206267838,5.6069682572422108,16.257536092265038,16.257536092265038,8.5034126299857586,6.0419916565110023,null,{"$f":"'ICAP Prices'!$C18","v":14.84},{"$f":"'ICAP Prices'!$F18","v":14.84},{"$f":"'ICAP Prices'!$I18","v":6.507942565139297},{"$f":"'ICAP Prices'!$L18","v":4.4793166815521905},0.84471837721655019,0.91500000000000004,1.12598319969454,1.2517463389749131]
[{"$f":"'ICAP Prices'!A19","v":2027},15.116912877167827,15.116912877167827,8.3908871934813583,5.7401424218680512,16.289776807292917,16.289776807292917,9.0419043033204289,6.1854982994267793,null,{"$f":"'ICAP Prices'!$C19","v":14.84},{"$f":"'ICAP Prices'!$F19","v":14.84},{"$f":"'ICAP Prices'!$I19","v":6.9602561819825981},{"$f":"'ICAP Prices'!$L19","v":4.5921634368308464},0.84471837721655019,0.91500000000000004,1.1193585120516225,1.2499865261392897]
[{"$f":"'ICAP Prices'!A20","v":2028},15.141511643426783,15.141511643426783,8.6871367502640044,5.8506791462091821,16.316284098520239,16.316284098520239,9.3611387395086254,6.3046111489323078,null,{"$f":"'ICAP Prices'!$C20","v":14.84},{"$f":"'ICAP Prices'!$F20","v":14.84},{"$f":"'ICAP Prices'!$I20","v":7.2290304639402088},{"$f":"'ICAP Prices'!$L20","v":4.6860847024944245},0.84471837721655019,0.91500000000000004,1.115421983063517,1.2485218508950209]
[{"$f":"'ICAP Prices'!A21","v":2029},15.165838758892917,15.165838758892917,8.9807223905482907,5.9609565760655796,16.342498662600125,16.342498662600125,9.6775025760218636,6.4234445862775642,null,{"$f":"'ICAP Prices'!$C21","v":14.84},{"$f":"'ICAP Prices'!$F21","v":14.84},{"$f":"'ICAP Prices'!$I21","v":7.4968595279530961},{"$f":"'ICAP Prices'!$L21","v":4.7800194723198484},0.84471837721655019,0.91500000000000004,1.1114992979514418,1.2470569650572148]
[{"$f":"'ICAP Prices'!A22","v":2030},15.233247226704135,15.18989388111159,9.2716659866301168,6.0709735647580301,16.415137097741525,16.368420130508177,9.9910193821445219,6.5419973758168428,null,{"$f":"'ICAP Prices'!$C22","v":14.8913474435883},{"$f":"'ICAP Prices'!$F22","v":14.84},{"$f":"'ICAP Prices'!$I22","v":7.7637466981374939},{"$f":"'ICAP Prices'!$L22","v":4.8739668673731567},0.84431361257526027,0.91500000000000004,1.107590408029637,1.2455918823325947]
[{"$f":"'ICAP Prices'!A23","v":2031},15.594003402531984,15.213676678726298,9.5599892303047458,6.1807289796581086,16.803882976866362,16.394048145179198,10.301712532655976,6.6602682970453753,null,{"$f":"'ICAP Prices'!$C23","v":15.292148660680631},{"$f":"'ICAP Prices'!$F23","v":14.84},{"$f":"'ICAP Prices'!$I23","v":8.0296952869195586},{"$f":"'ICAP Prices'!$L23","v":4.9679260119473341},0.8411541532228991,0.91500000000000004,1.1036952647835601,1.2441266163775613]
[{"$f":"'ICAP Prices'!A24","v":2032},15.950707531766803,15.23718683143681,9.8457136343448699,6.2902217021540681,17.188262426472846,16.41938236146208,10.60960520942335,6.7782561445625733,null,{"$f":"'ICAP Prices'!$C24","v":15.691450061667979},{"$f":"'ICAP Prices'!$F24","v":14.84},{"$f":"'ICAP Prices'!$I24","v":8.2947085950763046},{"$f":"'ICAP Prices'!$L24","v":5.0618960335707719},0.83800651670893644,0.91500000000000004,1.0998138198692833,1.2426611807980592]
[{"$f":"'ICAP Prices'!A25","v":2033},16.303392260719683,15.260424029956875,10.128860533967552,6.3994506276160079,17.568310625775521,16.444422446074217,10.914720402982276,6.8959597280344909,null,{"$f":"'ICAP Prices'!$C25","v":16.089257258929404},{"$f":"'ICAP Prices'!$F25","v":14.84},{"$f":"'ICAP Prices'!$I25","v":8.5587899117767314},{"$f":"'ICAP Prices'!$L25","v":5.1558760630154463},0.83487065879178157,0.91500000000000004,1.0959460251128925,1.2411955891494508]
[{"$f":"'ICAP Prices'!A26","v":2034},16.652089982817593,15.283387975971499,10.409451088289494,6.5084146653607426,17.944062481484472,16.469168077555494,11.217080914105058,7.0133778721559725,null,{"$f":"'ICAP Prices'!$C26","v":16.485575843842181},{"$f":"'ICAP Prices'!$F26","v":14.84},{"$f":"'ICAP Prices'!$I26","v":8.8219425146225614},{"$f":"'ICAP Prices'!$L26","v":5.2498652343051848},0.83174653539539767,0.91500000000000004,1.0920918325098912,1.239729854936386]
[{"$f":"'ICAP Prices'!A27","v":2035},16.996832840597342,15.306078382093768,10.687506281771038,6.617112738615714,18.315552629954031,16.49361894622173,11.516709355356721,7.1305094166117602,null,{"$f":"'ICAP Prices'!$C27","v":16.880411386860363},{"$f":"'ICAP Prices'!$F27","v":14.84},{"$f":"'ICAP Prices'!$I27","v":9.0841696696889347},{"$f":"'ICAP Prices'!$L27","v":5.3438626847234394},0.82863410260868253,0.91500000000000004,1.0882511942246029,1.238263991612683]
[{"$f":"'ICAP Prices'!A28","v":2036},17.337652727683778,15.328494971821272,10.963046925648902,6.7255437844827046,18.682815439314414,16.517774754117749,11.813628152638902,7.2473532160373972,null,{"$f":"'ICAP Prices'!$C28","v":17.27376943759316},{"$f":"'ICAP Prices'!$F28","v":14.84},{"$f":"'ICAP Prices'!$I28","v":9.3454746315649384},{"$f":"'ICAP Prices'!$L28","v":5.4378675548212367},0.8255333166848513,0.91500000000000004,1.0844240625895796,1.2367980125812017]
[{"$f":"'ICAP Prices'!A29","v":2037},17.674581290752045,15.350637479492113,11.236093659357762,6.8337067539007696,19.045885011586254,16.541635214969947,12.107859546721725,7.3639081399792774,null,{"$f":"'ICAP Prices'!$C29","v":17.66565552488284},{"$f":"'ICAP Prices'!$F29","v":14.84},{"$f":"'ICAP Prices'!$I29","v":9.6058606433940383},{"$f":"'ICAP Prices'!$L29","v":5.5318789884247623},0.8224441340408214,0.91500000000000004,1.080610390105007,1.2353319311937283]
[]
["*Based on 2017 Gold Book"]
["**AGCC at Distribution Level = AGCC at Transmission Level / (1-Distribution Losses)"]
[null,"Assumed Distribution Losses:",null,null,7.1999999999999995E-2]
[]
["NYC = New York City Load Zone J)"]
["LHV = Lower Hudson Valley (Load Zones GHI)"]
["LI = Long Island (Load Zone K)"]
["ROS = Rest of State (Upstate Load Zones A-F)"]
["NYCA=NY Control Area (Statewide)"]
[]
["2017 ICAP Demand Curve Reference Prices:"]
[null,"NYC","LHV","LI","NYCA"]
[null,{"$f":"'DC Model'!E12","v":18.61},{"$f":"'DC Model'!H12","v":14.84},{"$f":"'DC Model'!K12","v":12.72},{"$f":"'DC Model'!N12","v":9.08}]
[]
["2017 Minimum Locational ICAP Requirements (LCRs):"]
[null,"NYC","LHV","LI","NYCA"]
[null,{"$f":"'DC Model'!D6","v":0.81499999999999995},{"$f":"'DC Model'!G6","v":0.91500000000000004},{"$f":"'DC Model'!J6","v":1.0349999999999999},{"$f":"'DC Model'!M6","v":1.18}]

{"sheet":"AGCC Winter","index":2,"n_rows":44,"n_cols":18,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["Winter Month Avoided Generation Capacity Costs (AGCC) due to 1 kW reduction in Peak Load*"]
["All Prices in 2017 Dollars"]
[]
["Year","Avoided GCC at Transmission Level",null,null,null,"Avoided GCC at Distribution Level",null,null,null,null,"Generator ICAP Prices by Region",null,null,null,"Capacity Obligation at Forecasted Price"]
[null,"NYC","LHV","LI","ROS","NYC","LHV","LI","ROS",null,"NYC","LHV","LI","ROS","NYC","LHV","LI","NYCA"]
[{"$f":"'ICAP Prices'!A9","v":2017},{"$f":"O6*K6+(P6-O6)*L6+(R6-P6)*N6","v":3.9220024248672507},{"$f":"L6*P6+N6*(R6-P6)","v":3.9220024248672507},{"$f":"M6*Q6+(R6-Q6)*N6","v":1.6605589585778306},{"$f":"N6*R6","v":0},{"$f":"B6/(1-$E$30)","v":4.2262957164517783},{"$f":"C6/(1-$E$30)","v":4.2262957164517783},{"$f":"D6/(1-$E$30)","v":1.7893954295019725},{"$f":"E6/(1-$E$30)","v":0},null,{"$f":"'ICAP Prices'!$D9","v":3.8580819486612157},{"$f":"'ICAP Prices'!$G9","v":3.8580819486612157},{"$f":"'ICAP Prices'!$J9","v":1.3825890349733534},{"$f":"'ICAP Prices'!$M9","v":0},{"$f":"B$44*(1+0.18*(1-K6/B$40))","v":0.93128728523005899},{"$f":"C$44*(1+0.15*(1-L6/C$40))","v":1.0165679415462432},{"$f":"D$44*(1+0.18*(1-M6/D$40))","v":1.2010502879547533},{"$f":"E$44*(1+0.12*(1-N6/E$40))","v":1.3216000000000001}]
[{"$f":"'ICAP Prices'!A10","v":2018},1.823007311814749,0.95652242984041502,1.5627686407615364,0,1.9644475342831345,1.0307353769832057,1.6840179318551038,0,null,{"$f":"'ICAP Prices'!$D10","v":1.831129531549923},{"$f":"'ICAP Prices'!$G10","v":0.91640719205692101},{"$f":"'ICAP Prices'!$J10","v":1.2998569696892268},{"$f":"'ICAP Prices'!$M10","v":0},0.94726546468144157,1.0437744685235975,1.2022620005146929,1.3216000000000001]
[{"$f":"'ICAP Prices'!A11","v":2019},2.3301353211357081,1.1775972325991617,0.13024386956632553,0,2.510921682258306,1.2689625351284071,0.14034899737750595,0,null,{"$f":"'ICAP Prices'!$D11","v":2.3523538662347434},{"$f":"'ICAP Prices'!$G11","v":1.130353263736076},{"$f":"'ICAP Prices'!$J11","v":0.10678037053637368},{"$f":"'ICAP Prices'!$M11","v":0},0.94315672691151853,1.0417957556975892,1.2197360705164366,1.3216000000000001]
[{"$f":"'ICAP Prices'!A12","v":2020},6.4298113365135761,6.4298113365135769,1.0071278847426433,1.0071278847426433,6.9286760091741115,6.9286760091741124,1.0852671171795725,1.0852671171795725,null,{"$f":"'ICAP Prices'!$D12","v":6.2205047538684983},{"$f":"'ICAP Prices'!$G12","v":6.2205047538684983},{"$f":"'ICAP Prices'!$J12","v":0.76903050998149247},{"$f":"'ICAP Prices'!$M12","v":0.76903050998149247},0.91266464011861848,0.99471871445630389,1.2100366050306954,1.3096071894038128]
[{"$f":"'ICAP Prices'!A13","v":2021},9.0115352112038174,9.0115352112038174,1.4464631908084153,1.4464631908084153,9.7107060465558366,9.7107060465558366,1.5586887831987233,1.5586887831987233,null,{"$f":"'ICAP Prices'!$D13","v":8.9092272456417767},{"$f":"'ICAP Prices'!$G13","v":8.9092272456417767},{"$f":"'ICAP Prices'!$J13","v":1.1089910123809616},{"$f":"'ICAP Prices'!$M13","v":1.1089910123809616},0.89146982069126013,0.96985165502261905,1.2050574665403635,1.3043056027144113]
[{"$f":"'ICAP Prices'!A14","v":2022},9.0257626143859184,9.0257626143859184,1.5059209250282286,1.5059209250282288,9.7260372999848261,9.7260372999848261,1.6227596174873151,1.6227596174873156,null,{"$f":"'ICAP Prices'!$D14","v":8.90878219286971},{"$f":"'ICAP Prices'!$G14","v":8.90878219286971},{"$f":"'ICAP Prices'!$J14","v":1.1552152059391529},{"$f":"'ICAP Prices'!$M14","v":1.1552152059391529},0.8914733289793666,0.96985577116095911,1.2043804565356553,1.303584749651874]
[{"$f":"'ICAP Prices'!A15","v":2023},9.0557828958234978,9.0557828958234978,1.6340570252987991,1.6340570252987991,9.7583867411891134,9.7583867411891134,1.7608373117443956,1.7608373117443956,null,{"$f":"'ICAP Prices'!$D15","v":8.9073022680951581},{"$f":"'ICAP Prices'!$G15","v":8.9073022680951581},{"$f":"'ICAP Prices'!$J15","v":1.2550086468195767},{"$f":"'ICAP Prices'!$M15","v":1.2550086468195767},0.89148499501721856,0.96986945847061601,1.2029188592057791,1.3020284995165579]
[{"$f":"'ICAP Prices'!A16","v":2024},9.0775536139130395,9.0775536139130395,1.7299956063489752,1.7299956063489752,9.7818465667166361,9.7818465667166361,1.8642194033932922,1.8642194033932922,null,{"$f":"'ICAP Prices'!$D16","v":8.9055826271012979},{"$f":"'ICAP Prices'!$G16","v":8.9055826271012979},{"$f":"'ICAP Prices'!$J16","v":1.329885241476342},{"$f":"'ICAP Prices'!$M16","v":1.329885241476342},0.89149855070415029,0.9698853628322337,1.2018221996472451,1.3008608204633203]
[{"$f":"'ICAP Prices'!A17","v":2025},9.1038637323972313,9.1038637323972313,1.8493326774766436,1.8493326774766436,9.8101979874970162,9.8101979874970162,1.9928153852119004,1.9928153852119004,null,{"$f":"'ICAP Prices'!$D17","v":8.902797940983838},{"$f":"'ICAP Prices'!$G17","v":8.902797940983838},{"$f":"'ICAP Prices'!$J17","v":1.4232145806301837},{"$f":"'ICAP Prices'!$M17","v":1.4232145806301837},0.8915205019912773,0.96991111742587399,1.2004552770148267,1.2994053761434763]
[{"$f":"'ICAP Prices'!A18","v":2026},9.1284305628158542,9.1284305628158542,1.9652833051851448,1.9652833051851448,9.8366708651032901,9.8366708651032901,2.1177621823115782,2.1177621823115782,null,{"$f":"'ICAP Prices'!$D18","v":8.8992117767006302},{"$f":"'ICAP Prices'!$G18","v":8.8992117767006302},{"$f":"'ICAP Prices'!$J18","v":1.5140996921510865},{"$f":"'ICAP Prices'!$M18","v":1.5140996921510865},0.89154877121751841,0.96994428461238802,1.1991241530937304,1.297988048853679]
[{"$f":"'ICAP Prices'!A19","v":2027},9.1616253187471894,9.1616253187471894,2.1116260885489453,2.1116260885489453,9.8724410762361945,9.8724410762361945,2.2754591471432599,2.2754591471432599,null,{"$f":"'ICAP Prices'!$D19","v":8.8974308722461171},{"$f":"'ICAP Prices'!$G19","v":8.8974308722461171},{"$f":"'ICAP Prices'!$J19","v":1.6290963652547852},{"$f":"'ICAP Prices'!$M19","v":1.6290963652547852},0.89156280983565261,0.96996075557845163,1.1974398857824711,1.2961947086651895]
[{"$f":"'ICAP Prices'!A20","v":2028},9.1879806714355627,9.1879806714355627,2.232002846722887,2.232002846722887,9.9008412407710793,9.9008412407710793,2.4051754813824213,2.4051754813824213,null,{"$f":"'ICAP Prices'!$D20","v":8.8951801013476626},{"$f":"'ICAP Prices'!$G20","v":8.8951801013476626},{"$f":"'ICAP Prices'!$J20","v":1.7239327042358674},{"$f":"'ICAP Prices'!$M20","v":1.7239327042358674},0.89158055234456191,0.96998157217587833,1.1960508912893755,1.2947157631145594]
[{"$f":"'ICAP Prices'!A21","v":2029},9.2140625927374842,9.2140625927374842,2.3521217718389873,2.3521217718389877,9.9289467594153926,9.9289467594153926,2.5346139782747708,2.5346139782747712,null,{"$f":"'ICAP Prices'!$D21","v":8.8929357847561477},{"$f":"'ICAP Prices'!$G21","v":8.8929357847561477},{"$f":"'ICAP Prices'!$J21","v":1.8187869758464963},{"$f":"'ICAP Prices'!$M21","v":1.8187869758464963},0.89159824397508169,0.97000232907966444,1.1946616341509273,1.2932365379097064]
[{"$f":"'ICAP Prices'!A22","v":2030},9.2398706621974309,9.2398706621974309,2.4719815754590875,2.4719815754590875,9.9567571790920582,9.9567571790920582,2.6637732494171198,2.6637732494171198,null,{"$f":"'ICAP Prices'!$D22","v":8.8906979039632095},{"$f":"'ICAP Prices'!$G22","v":8.8906979039632095},{"$f":"'ICAP Prices'!$J22","v":1.9136582851923265},{"$f":"'ICAP Prices'!$M22","v":1.9136582851923265},0.89161588487311094,0.97002302646098715,1.1932721274739517,1.2917570470062518]
[{"$f":"'ICAP Prices'!A23","v":2031},9.2654044709144419,9.2654044709144419,2.5915809837731558,2.5915809837731563,9.9842720591750442,9.9842720591750442,2.7926519221693487,2.7926519221693491,null,{"$f":"'ICAP Prices'!$D23","v":8.8884664405135787},{"$f":"'ICAP Prices'!$G23","v":8.8884664405135787},{"$f":"'ICAP Prices'!$J23","v":2.008545740607377},{"$f":"'ICAP Prices'!$M23","v":2.008545740607377},0.89163347518412994,0.97004366449053314,1.1918823843179909,1.2902773043094709]
[{"$f":"'ICAP Prices'!A24","v":2032},9.2906636215006735,9.2906636215006735,2.804444418934632,2.7109187375671699,10.01149097144469,10.01149097144469,3.0220306238519741,2.9212486396197952,null,{"$f":"'ICAP Prices'!$D24","v":8.8862413760048913},{"$f":"'ICAP Prices'!$G24","v":8.8862413760048913},{"$f":"'ICAP Prices'!$J24","v":2.1820850312775235},{"$f":"'ICAP Prices'!$M24","v":2.1034484536628071},0.89165101505320166,0.97006424333849928,1.1893406885749211,1.288797323674157]
[{"$f":"'ICAP Prices'!A25","v":2033},9.3156477280395382,9.3156477280395382,3.1491537081728276,2.8299935921903416,10.038413500042605,10.038413500042605,3.3934845993241676,3.0495620605499369,null,{"$f":"'ICAP Prices'!$D25","v":8.8840226920875445},{"$f":"'ICAP Prices'!$G25","v":8.8840226920875445},{"$f":"'ICAP Prices'!$J25","v":2.4676630530936059},{"$f":"'ICAP Prices'!$M25","v":2.198365539175521},0.89166850462497349,0.9700847631745948,1.185158048208228,1.2873171189044874]
[{"$f":"'ICAP Prices'!A26","v":2034},9.3403564160433756,9.3403564160433756,3.4908086858158072,2.9488043175217213,10.065039241426051,10.065039241426051,3.7616472907497922,3.1775908593984066,null,{"$f":"'ICAP Prices'!$D26","v":8.8818103704645566},{"$f":"'ICAP Prices'!$G26","v":8.8818103704645566},{"$f":"'ICAP Prices'!$J26","v":2.7522367620383967},{"$f":"'ICAP Prices'!$M26","v":2.293296115216604},0.89168594404367796,0.97010522416804168,1.1809901172352395,1.2858367037538909]
[{"$f":"'ICAP Prices'!A27","v":2035},9.3647893224106866,9.3647893224106866,3.829434388313373,3.0673496979361459,10.091367804321861,10.091367804321861,4.1265456770618245,3.305333726224295,null,{"$f":"'ICAP Prices'!$D27","v":8.8796043928914603},{"$f":"'ICAP Prices'!$G27","v":8.8796043928914603},{"$f":"'ICAP Prices'!$J27","v":3.0358096900515683},{"$f":"'ICAP Prices'!$M27","v":2.3882393031195717},0.89170333345313391,0.97012562648757728,1.1768368439263672,1.2843560919249193]
[{"$f":"'ICAP Prices'!A28","v":2036},9.7090140893705374,9.3889460953828063,4.1650556466637472,3.1856285322697531,10.462299665269976,10.117398809679747,4.4882065158014512,3.4327893666699922,null,{"$f":"'ICAP Prices'!$D28","v":9.237483936072282},{"$f":"'ICAP Prices'!$G28","v":8.8774047411760186},{"$f":"'ICAP Prices'!$J28","v":3.3183853566517456},{"$f":"'ICAP Prices'!$M28","v":2.4831942274885925},0.88888221959044567,0.970145970301455,1.1726981767339448,1.2828752970691204]
[{"$f":"'ICAP Prices'!A29","v":2037},10.107306641402033,9.4128263945003514,4.4976970880812459,3.3036396337846754,10.891494225648742,10.143131890625378,4.8466563449151359,3.5599565019231414,null,{"$f":"'ICAP Prices'!$D29","v":9.659442163628162},{"$f":"'ICAP Prices'!$G29","v":8.8752113971782585},{"$f":"'ICAP Prices'!$J29","v":3.599967268980242},{"$f":"'ICAP Prices'!$M29","v":2.5781600162063825},0.88555598251454848,0.97016625577744509,1.1685740642915865,1.2813943327869135]
[]
["*Based on 2017 Gold Book"]
["**AGCC at Distribution Level = AGCC at Transmission Level / (1-Distribution Losses)"]
[null,"Assumed Distribution Losses:",null,null,7.1999999999999995E-2]
[]
["NYC = New York City Load Zone J)"]
["LHV = Lower Hudson Valley (Load Zones GHI)"]
["LI = Long Island (Load Zone K)"]
["ROS = Rest of State (Upstate Load Zones A-F)"]
["NYCA=NY Control Area (Statewide)"]
[]
["2017 ICAP Demand Curve Reference Prices:"]
[null,"NYC","LHV","LI","NYCA (ROS)"]
[null,{"$f":"'DC Model'!E12","v":18.61},{"$f":"'DC Model'!H12","v":14.84},{"$f":"'DC Model'!K12","v":12.72},{"$f":"'DC Model'!N12","v":9.08}]
[]
["2017 Minimum Locational ICAP Requirements (LCRs):"]
[null,"NYC","LHV","LI","NYCA"]
[null,{"$f":"'DC Model'!D6","v":0.81499999999999995},{"$f":"'DC Model'!G6","v":0.91500000000000004},{"$f":"'DC Model'!J6","v":1.0349999999999999},{"$f":"'DC Model'!M6","v":1.18}]

{"sheet":"ICAP Prices","index":3,"n_rows":53,"n_cols":18,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["ICAP Monthly Price Forecasts, based on 2017 Gold Book"]
["(All Prices in 2017 Dollars)"]
[]
[null,"NYC (J)",null,null,"LHV (G-J)",null,null,"LI (K)",null,null,"ROS (NYCA)"]
[null,"Average","Summer","Winter","Average","Summer","Winter","Average","Summer","Winter","Average","Summer","Winter"]
["Net CONE",{"$f":"'DC Model'!D12","v":14.629527777777778},{"$f":"'DC Model'!E12","v":18.61},{"$f":"'DC Model'!F12","v":10.649055555555556},{"$f":"'DC Model'!G12","v":12.168799999999999},{"$f":"'DC Model'!H12","v":14.84},{"$f":"'DC Model'!I12","v":9.4975999999999985},{"$f":"'DC Model'!J12","v":10.07},{"$f":"'DC Model'!K12","v":12.72},{"$f":"'DC Model'!L12","v":7.4200000000000008},{"$f":"'DC Model'!M12","v":7.6801666666666666},{"$f":"'DC Model'!N12","v":9.08},{"$f":"'DC Model'!O12","v":6.2803333333333331}]
[]
[]
[2017,6.9497457773404401,10.041409606019664,3.8580819486612157,6.7027126602266733,9.547343371792131,3.8580819486612157,4.4190077495015831,7.4554264640298129,1.3825890349733534,1.1977593960738417,2.3955187921476835,0]
[{"$f":"1+A9","v":2018},6.1131905021351924,10.395251472720462,1.831129531549923,3.8149532851730648,6.7134993782892085,0.91640719205692101,4.3893733314861079,7.4788896932829889,1.2998569696892268,1.3725084127467189,2.7450168254934377,0]
[2019,6.6158415157194987,10.879329165204254,2.3523538662347434,4.025296440639508,6.9202396175429399,1.130353263736076,3.2412007758399595,6.3756211811435453,0.10678037053637368,1.3104047410766935,2.6208094821533869,0]
[2020,9.0537520212931391,11.886999288717782,6.2205047538684983,9.0537520212931391,11.886999288717782,6.2205047538684983,3.1630093108018125,5.5569881116221325,0.76903050998149247,2.215515049331636,3.6619995886817795,0.76903050998149247]
[2021,11.874613622820888,14.84,8.9092272456417767,11.874613622820888,14.84,8.9092272456417767,3.3179412869522364,5.5268915615235112,1.1089910123809616,2.5933585966025632,4.0777261808241647,1.1089910123809616]
[2022,11.874391096434856,14.84,8.90878219286971,11.874391096434856,14.84,8.90878219286971,3.3786522706857198,5.6020893354322867,1.1552152059391529,2.6390029321784136,4.1227906584176743,1.1552152059391529]
[2023,11.873651134047579,14.84,8.9073022680951581,11.873651134047579,14.84,8.9073022680951581,3.5856744359081465,5.9163402249967163,1.2550086468195767,2.7378250280130025,4.2206414092064284,1.2550086468195767]
[2024,11.87279131355065,14.84,8.9055826271012979,11.87279131355065,14.84,8.9055826271012979,3.682636610640813,6.0353879798052841,1.329885241476342,2.8123029746226234,4.2947207077689047,1.329885241476342]
[2025,11.871398970491919,14.84,8.902797940983838,11.871398970491919,14.84,8.902797940983838,3.8773136772457875,6.3314127738613912,1.4232145806301837,2.9054853550556259,4.3877561294810681,1.4232145806301837]
[2026,11.869605888350314,14.84,8.8992117767006302,11.869605888350314,14.84,8.8992117767006302,4.0110211286451918,6.507942565139297,1.5140996921510865,2.9967081868516385,4.4793166815521905,1.5140996921510865]
[2027,11.868715436123058,14.84,8.8974308722461171,11.868715436123058,14.84,8.8974308722461171,4.2946762736186912,6.9602561819825981,1.6290963652547852,3.1106299010428158,4.5921634368308464,1.6290963652547852]
[2028,11.867590050673831,14.84,8.8951801013476626,11.867590050673831,14.84,8.8951801013476626,4.4764815840880381,7.2290304639402088,1.7239327042358674,3.205008703365146,4.6860847024944245,1.7239327042358674]
[2029,11.866467892378074,14.84,8.8929357847561477,11.866467892378074,14.84,8.8929357847561477,4.6578232518997957,7.4968595279530961,1.8187869758464963,3.2994032240831723,4.7800194723198484,1.8187869758464963]
[2030,11.891022673775755,14.8913474435883,8.8906979039632095,11.865348951981606,14.84,8.8906979039632095,4.8387024916649102,7.7637466981374939,1.9136582851923265,3.3938125762827416,4.8739668673731567,1.9136582851923265]
[2031,12.090307550597105,15.292148660680631,8.8884664405135787,11.864233220256789,14.84,8.8884664405135787,5.0191205137634682,8.0296952869195586,2.008545740607377,3.4882358762773555,4.9679260119473341,2.008545740607377]
[2032,12.288845718836434,15.691450061667979,8.8862413760048913,11.863120688002446,14.84,8.8862413760048913,5.2383968131769141,8.2947085950763046,2.1820850312775235,3.5826722436167895,5.0618960335707719,2.1034484536628071]
[2033,12.486639975508474,16.089257258929404,8.8840226920875445,11.862011346043772,14.84,8.8840226920875445,5.5132264824351687,8.5587899117767314,2.4676630530936059,3.6771208010954837,5.1558760630154463,2.198365539175521,"Forecasted Capacity Changes"]
[2034,12.683693107153369,16.485575843842181,8.8818103704645566,11.860905185232278,14.84,8.8818103704645566,5.7870896383304791,8.8219425146225614,2.7522367620383967,3.7715806747608944,5.2498652343051848,2.293296115216604,null,"Year","ICAP","ICAP","Zone "]
[2035,12.880007889875912,16.880411386860363,8.8796043928914603,11.859802196445731,14.84,8.8796043928914603,6.0599896798702515,9.0841696696889347,3.0358096900515683,3.8660509939215055,5.3438626847234394,2.3882393031195717,null,null,"S","W"]
[2036,13.25562668683272,17.27376943759316,9.237483936072282,11.858702370588009,14.84,8.8774047411760186,6.331929994108342,9.3454746315649384,3.3183853566517456,3.9605308911549146,5.4378675548212367,2.4831942274885925,"START OF TABLE"]
[2037,13.6625488442555,17.66565552488284,9.659442163628162,11.857605698589129,14.84,8.8752113971782585,6.6029139561871402,9.6058606433940383,3.599967268980242,4.055019502315572,5.5318789884247623,2.5781600162063825,"Greenidge",2017,106.3,106.3,"ROS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Shoreham GT 3 & 4",2018,{"$f":"-45.4-44.6","v":-90},{"$f":"-45.4-45.7","v":-91.1},"K"]
["Annual Capacity Prices ($/kW-year, 2017 $)",null,null,null,null,null,null,null,null,null,null,null,null,"Freeport GT",2018,-47.5,-49,"K"]
[null,"NYC",null,null,"Lower Hudson Valley",null,null,"Long Island",null,null,"Rest-of-State",null,null,"CPV Valley",2018,677.6,690.6,"GHI"]
[{"$f":"A9","v":2017},{"$f":"B9*12","v":83.396949328085284},null,null,{"$f":"E9*12","v":80.43255192272008},null,null,{"$f":"H9*12","v":53.028092994018998},null,null,{"$f":"K9*12","v":14.373112752886101},null,null,"Taylor Biomass*",2018,19,22.5,"GHI"]
[2018,73.358286025622306,null,null,45.779439422076777,null,null,52.672479977833291,null,null,16.470100952960628,null,null,"Bethlehem Uprate",2018,72,51.2,"ROS"]
[2019,79.390098188633985,null,null,48.303557287674096,null,null,38.89440931007951,null,null,15.724856892920322,null,null,"Copenhagen Wind**",2018,{"$f":"79.9*P$50","v":7.9900000000000011},{"$f":"79.9*Q$50","v":23.970000000000002},"ROS"]
[2020,108.64502425551767,null,null,108.64502425551767,null,null,37.956111729621753,null,null,26.586180591979634]
[2021,142.49536347385066,null,null,142.49536347385066,null,null,39.815295443426834,null,null,31.120303159230758]
[2022,142.49269315721827,null,null,142.49269315721827,null,null,40.543827248228638,null,null,31.668035186140962]
[2023,142.48381360857096,null,null,142.48381360857096,null,null,43.02809323089776,null,null,32.85390033615603,null,null,"IP 2",2020,-1012.1,-1030.2,"GHI"]
[2024,142.4734957626078,null,null,142.4734957626078,null,null,44.191639327689757,null,null,33.74763569547148,null,null,"IP 3",2021,-1039.4000000000001,-1040.9000000000001,"GHI"]
[2025,142.45678764590303,null,null,142.45678764590303,null,null,46.52776412694945,null,null,34.865824260667509]
[2026,142.43527066020377,null,null,142.43527066020377,null,null,48.132253543742301,null,null,35.960498242219664]
[2027,142.42458523347671,null,null,142.42458523347671,null,null,51.536115283424294,null,null,37.327558812513786]
[2028,142.41108060808597,null,null,142.41108060808597,null,null,53.717779009056457,null,null,38.460104440381755]
[2029,142.39761470853688,null,null,142.39761470853688,null,null,55.893879022797549,null,null,39.592838688998071]
[2030,142.69227208530907,null,null,142.38418742377928,null,null,58.064429899978919,null,null,40.725750915392901]
[2031,145.08369060716527,null,null,142.37079864308146,null,null,60.229446165161619,null,null,41.858830515328265]
[{"$f":"A24","v":2032},{"$f":"B24*12","v":147.46614862603721},null,null,{"$f":"E24*12","v":142.35744825602936},null,null,{"$f":"H24*12","v":62.860761758122969},null,null,{"$f":"K24*12","v":42.992066923401474},null,null,"END OF TABLE"]
[2033,149.83967970610169,null,null,142.34413615252527,null,null,66.158717789222024,null,null,44.125449613145804,null,null,"*Capacity subject to mitigation"]
[2034,152.20431728584043,null,null,142.33086222278735,null,null,69.445075659965752,null,null,45.258968097130733,null,null,"**Wind cf (S/W) assumed:",null,0.1,0.3]
[2035,154.56009467851095,null,null,142.31762635734879,null,null,72.719876158443014,null,null,46.39261192705807]
[2036,159.06752024199264,null,null,142.30442844705613,null,null,75.983159929300101,null,null,47.526370693858979]
[2037,163.95058613106602,null,null,142.29126838306956,null,null,79.234967474245678,null,null,48.660234027786863]

{"sheet":"DC Model","index":4,"n_rows":29,"n_cols":15,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["ICAP Demand Curve Model*"]
[]
[]
[null,null,null,"NYC (J)",null,null,"G-J(LHV)",null,null,"LI (K)",null,null,"NYCA"]
[null,null,null,"Average","Summer","Winter","Average","Summer","Winter","Average","Summer","Winter","Average","Summer","Winter"]
["IRM/LCR %",null,null,0.81499999999999995,null,null,0.91500000000000004,null,null,1.0349999999999999,null,null,1.18]
["DC Length %",null,null,0.18,null,null,0.15,null,null,0.18,null,null,0.12]
[]
[]
[2037,"Input Year (2016-2036)**"]
[]
["Ref Price (S/W & average)",null,null,{"$f":"AVERAGE(E12,F12)","v":14.629527777777778},18.61,{"$f":"E12+D16*D14*0.077","v":10.649055555555556},{"$f":"AVERAGE(H12,I12)","v":12.168799999999999},14.84,{"$f":"H12+G16*G14*0.054","v":9.4975999999999985},{"$f":"AVERAGE(K12,L12)","v":10.07},12.72,{"$f":"K12+J16*J14*0.075","v":7.4200000000000008},{"$f":"AVERAGE(N12,O12)","v":7.6801666666666666},9.08,{"$f":"N12+M16*M14*0.037","v":6.2803333333333331}]
["Peak Load",null,null,{"$f":"VLOOKUP($A10,Demand,14,FALSE)","v":12522.795863832864},null,null,{"$f":"VLOOKUP($A10,Demand,16,FALSE)","v":16820.157788881937},null,null,{"$f":"VLOOKUP($A10,Demand,15,FALSE)","v":5457.9338251845602},null,null,{"$f":"VLOOKUP($A10,Demand,13,FALSE)","v":34146.882559786885}]
["ICAP LCR",null,null,{"$f":"D13*D$6","v":10206.078629023783},null,null,{"$f":"G13*G$6","v":15390.444376826974},null,null,{"$f":"J13*J$6","v":5648.9615090660191},null,null,{"$f":"M13*M$6","v":40293.32142054852}]
["DC Length MW",null,null,{"$f":"D14*D$7","v":1837.0941532242809},null,null,{"$f":"G14*G$7","v":2308.5666565240458},null,null,{"$f":"J14*J$7","v":1016.8130716318834},null,null,{"$f":"M14*M$7","v":4835.1985704658218}]
["Slope",null,null,{"$f":"-E12/D15","v":-1.0130128587768688E-2},null,null,{"$f":"-H12/G15","v":-6.4282311095769859E-3},null,null,{"$f":"-K12/J15","v":-1.2509673955691454E-2},null,null,{"$f":"-N12/M15","v":-1.8778959886905399E-3}]
["Total Supply",null,null,null,{"$f":"VLOOKUP($A10,Supply,4,FALSE)","v":10299.299999999999},{"$f":"VLOOKUP($A10,Supply,12,FALSE)","v":11089.636795025635},null,{"$f":"VLOOKUP($A10,Supply,6,FALSE)","v":14127.1},{"$f":"VLOOKUP($A10,Supply,14,FALSE)","v":14969.097709174212},null,{"$f":"VLOOKUP($A10,Supply,5,FALSE)","v":5897.9000000000005},{"$f":"VLOOKUP($A10,Supply,13,FALSE)","v":6377.9999127304463},null,{"$f":"VLOOKUP($A10,Supply,8,FALSE)","v":40919.39},{"$f":"VLOOKUP($A10,Supply,16,FALSE)","v":42406.37}]
["Excess Supply",null,null,null,{"$f":"E17-D14","v":93.221370976216349},{"$f":"F17-D14","v":883.55816600185244},null,{"$f":"H17-G14","v":-1263.3443768269735},{"$f":"I17-G14","v":-421.34666765276233},null,{"$f":"K17-J14","v":248.93849093398148},{"$f":"L17-J14","v":729.03840366442728},null,{"$f":"N17-M14","v":626.06857945147931},{"$f":"O17-M14","v":2113.0485794514825}]
["Regional Reliability Additions***",null,null,null,{"$f":"MAX(0,-E18)","v":0},{"$f":"E19*1.087","v":0},null,{"$f":"MAX(0,-H18-E19)","v":1263.3443768269735},{"$f":"H19*1.068","v":1349.2517944512078},null,{"$f":"MAX(0,-K18)","v":0},{"$f":"K19*1.07","v":0},null,{"$f":"MAX(0,-N18-E19-H19-K19)","v":0},{"$f":"N19*1.047","v":0}]
["Augmented Supply",null,null,null,{"$f":"E17+E19","v":10299.299999999999},{"$f":"F17+F19","v":11089.636795025635},null,{"$f":"H17+E19+H19","v":15390.444376826974},{"$f":"I17+F19+I19","v":16318.349503625419},null,{"$f":"K17+K19","v":5897.9000000000005},{"$f":"L17+L19","v":6377.9999127304463},null,{"$f":"N17+N19+K19+H19+E19","v":42182.734376826971},{"$f":"O17+O19+L19+I19+F19","v":43755.62179445121}]
["Augmented Excess",null,null,null,{"$f":"E20-D14","v":93.221370976216349},{"$f":"F20-D14","v":883.55816600185244},null,{"$f":"H20-G14","v":0},{"$f":"I20-G14","v":927.90512679844505},null,{"$f":"K20-J14","v":248.93849093398148},{"$f":"L20-J14","v":729.03840366442728},null,{"$f":"N20-M14","v":1889.412956278451},{"$f":"O20-M14","v":3462.3003739026899}]
["DC Price",null,null,{"$f":"AVERAGE(E22:F22)","v":13.6625488442555},{"$f":"E12+D16*E21","v":17.66565552488284},{"$f":"E12+D16*F21","v":9.659442163628162},{"$f":"AVERAGE(H22:I22)","v":11.857605698589129},{"$f":"H12+G16*H21","v":14.84},{"$f":"H12+G16*I21","v":8.8752113971782585},{"$f":"AVERAGE(K22:L22)","v":6.6029139561871402},{"$f":"K12+J16*K21","v":9.6058606433940383},{"$f":"K12+J16*L21","v":3.599967268980242},{"$f":"AVERAGE(N22:O22)","v":4.055019502315572},{"$f":"MAX(N12+M16*N21,0)","v":5.5318789884247623},{"$f":"MAX(N12+M16*O21,0)","v":2.5781600162063825}]
["Cap DC Price at net CONE",null,null,{"$f":"AVERAGE(E23:F23)","v":13.6625488442555},{"$f":"IF(D22>D12,E12,E22)","v":17.66565552488284},{"$f":"IF(D22>D12,F12,F22)","v":9.659442163628162},{"$f":"AVERAGE(H23:I23)","v":11.857605698589129},{"$f":"IF(G22>G12,H12,H22)","v":14.84},{"$f":"IF(G22>G12,I12,I22)","v":8.8752113971782585},{"$f":"AVERAGE(K23:L23)","v":6.6029139561871402},{"$f":"IF(J22>J12,K12,K22)","v":9.6058606433940383},{"$f":"IF(J22>J12,L12,L22)","v":3.599967268980242},{"$f":"AVERAGE(N23:O23)","v":4.055019502315572},{"$f":"IF(M22>M12,N12,N22)","v":5.5318789884247623},{"$f":"IF(M22>M12,O12,O22)","v":2.5781600162063825}]
["ICAP Price Forecast",null,null,{"$f":"AVERAGE(E24:F24)","v":13.6625488442555},{"$f":"MAX(E23,H24,N24)","v":17.66565552488284},{"$f":"MAX(F23,I24,O24)","v":9.659442163628162},{"$f":"AVERAGE(H24:I24)","v":11.857605698589129},{"$f":"MAX(H23,N23)","v":14.84},{"$f":"MAX(I23,O23)","v":8.8752113971782585},{"$f":"AVERAGE(K24:L24)","v":6.6029139561871402},{"$f":"MAX(K23,N23)","v":9.6058606433940383},{"$f":"MAX(L23,O23)","v":3.599967268980242},{"$f":"AVERAGE(N24:O24)","v":4.055019502315572},{"$f":"N23","v":5.5318789884247623},{"$f":"O23","v":2.5781600162063825}]
[]
[]
["*Based on 2017 Reserve Margin & Locational Capacity Requirements and 2017 Demand Curve reference Prices"]
["**Input any year (2017-2037)"]
["***G-J regional supplies are Lower Hudson Valley only (GHI supply); NYCA regional supplies are ROS only."]

{"sheet":"Demand","index":5,"n_rows":29,"n_cols":17,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Demand (Load) Forecast*"]
[]
["Load  ","A","B","C","D","E","F","G","H","I","J","K","NYCA","J NC Peak","K NCPeak","G-J NC Peak","ROS (A-F)"]
[]
[]
[2017,2653,2000,2852,508,1419,2401,2238,656,1492,11575,5384,{"$f":"SUM(B6:L6)","v":33178},11670,5427,16061,{"$f":"SUM(B6:G6)","v":11833}]
[{"$f":"1+A6","v":2018},2655,2003,2855,509,1420,2403,2218,653,1486,11613,5263,33078,11707,5305,16070,{"$f":"SUM(B7:G7)","v":11845}]
[2019,2657,2006,2859,509,1421,2405,2197,649,1481,11663,5188,33035,11758,5229,16090,11857]
[2020,2659,2009,2862,509,1421,2406,2180,648,1473,11693,5133,32993,11788,5174,16095,11866]
[2021,2661,2013,2865,509,1422,2407,2169,643,1465,11724,5131,33009,11820,5172,16102,11877]
[2022,2663,2017,2868,509,1423,2408,2157,643,1468,11742,5136,33034,11838,5177,16111,11888]
[2023,2665,2021,2870,510,1424,2409,2151,645,1471,11773,5157,33096,11869,5198,16141,11899]
[2024,2666,2026,2874,510,1426,2410,2145,646,1476,11808,5165,33152,11904,5206,16176,11912]
[2025,2667,2028,2875,510,1426,2410,2140,648,1482,11862,5184,33232,11959,5226,16233,11916]
[2026,2668,2029,2877,510,1427,2410,2136,649,1491,11930,5197,{"$f":"SUM(B15:L15)","v":33324},12027,5238,16307,{"$f":"SUM(B15:G15)","v":11921}]
[2027,2669,2032,2879,510,1428,2410,2132,651,1495,11965,5227,33398,12062,5269,16344,11928]
[2028,{"$f":"B16*(B$16/B$11)^0.2","v":2670.2016212568756},{"$f":"C16*(C$16/C$11)^0.2","v":2035.0133597588397},2881.2050575923322,510.20023563298065,1429.0021062498056,2410.4001992914154,2127.0348785444248,652.61190460515297,1500.4593014017339,12010.105664590295,5245.3925743616201,{"$f":"SUM(B17:L17)","v":33471.626903285476},{"$f":"N16*(N$16/N$11)^0.2","v":12107.306081604858},{"$f":"O16*(O$16/O$11)^0.2","v":5287.5952684753101},{"$f":"P16*(P$16/P$11)^0.2","v":16391.002812849791},{"$f":"SUM(B17:G17)","v":11936.02257978225}]
[2029,{"$f":"B17*(B$16/B$11)^0.2","v":2671.4037835005047},2038.0311881874804,2883.4118040623948,510.40054988225285,1430.0049157327594,2410.8004650390435,2122.0813201428218,654.22780035693586,1505.9385385705548,12055.381368543578,5263.8498678339438,33545.531601852272,{"$f":"N17*(N$16/N$11)^0.2","v":12152.782337395622},{"$f":"O17*(O$16/O$11)^0.2","v":5306.2561630674672},{"$f":"P17*(P$16/P$11)^0.2","v":16438.14079851014},11944.052706404436]
[2030,2672.6064869744469,2041.0534919127483,2885.6202407037176,510.60094277868291,1431.0084289423592,2411.20079725392,2117.1392978665008,655.84769713760318,1511.4377843060352,12100.827752874346,5282.3721081481854,33619.715028898543,12198.429406563597,5324.9829153830879,16485.414345717119,11952.090388565875]
[2031,2673.8097319223721,2044.0802775712959,2887.8303688108213,510.80141435314914,1432.0126463724484,2411.601195947082,2112.2087848494848,657.47160485387826,1516.9571116735906,12146.445461013593,5300.9595238368911,33694.178121204604,12244.24793070096,5343.7757578461715,16532.823844324739,11960.135634977169]
[2032,2675.013518588059,2047.1115518096183,2890.0421896792182,511.00196463654208,1433.0175685172176,2412.0016611295691,2107.2897542883634,659.09953343701386,1522.4965940054499,12192.235138817921,5319.6123442367589,33768.921819145733,12290.238553809768,5362.6349237009827,16580.369685308178,11968.188454360225]
[2033,2676.2178472153969,2050.1473212840665,2892.2557046054121,511.20259365976432,1434.0231958712038,2412.4021928124225,2102.3821794421483,660.73149284285296,1528.0563049016298,12238.197434578686,5338.3307994914685,33843.947066705048,12336.401922311017,5381.5606470149496,16628.052260766992,11976.248855448266]
[2034,2677.4227180483845,2053.1875926608627,2894.470914886901,511.40330145373059,1435.029528929291,2412.8027910066849,2097.4860336321262,662.36749305188982,1533.6363182309126,12284.332999031167,5357.1151205545211,33919.254811486477,12382.738685053726,5400.5531626815664,16675.871963928355,11984.316846985856]
[2035,2678.6281313311301,2056.2323726161153,2896.6878218221759,511.60408804936776,1436.0365681867108,2413.203455723401,2092.6012902417156,664.00754406933061,1539.2367081318275,12330.642485363787,5375.9655391920878,33994.846004727653,12429.249493324052,5419.6127064233106,16723.829189150307,11992.3924377289]
[2036,2679.8340873078528,2059.2816678358322,2898.9064267107224,511.8049534776149,1437.0443141390422,2413.6041869736173,2087.7279227163199,665.65165592515496,1544.8575490136363,12377.126549227361,5394.8822879858699,34070.721601313024,12475.935000854452,5438.7395147945654,16771.924331924994,12000.47563644468]
[2037,2681.0405862228804,2062.3354850159367,2901.1267308530214,512.0058977694232,1438.0527672822118,2414.0049847683822,2082.8659045631857,667.29983867417707,1550.4989155573214,12423.785848744377,5413.8656003359692,34146.882559786885,12522.795863832864,5457.9338251845602,16820.157788881937,12008.566451911856]
[]
["*From 2017 Gold Book Tables I-2a,I-2b-1, and I-2b-2;"]
["  2028-2037 load growth based on average load growth for 2022-2027."]

{"sheet":"Supply","index":6,"n_rows":57,"n_cols":18,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["Supply Forecast*"]
[]
[null,"Summer",null,null,null,null,null,null,null,"Winter",null,null,null,null,null,null,null,"Exports from"]
["Year","ROS (A-F)","GHI","J","K","G-J***","Imports","NYCA**",null,"ROS (A-F)","GHI","J","K","G-J***","Imports","NYCA**",null,"GHI to ISONE"]
["2017 Gold Book",{"$f":"'ICAP 2017'!O10","v":19426.900000000001},{"$f":"'ICAP 2017'!H10+'ICAP 2017'!I10+'ICAP 2017'!J10","v":5182.7000000000007},{"$f":"'ICAP 2017'!K10","v":10299.299999999999},{"$f":"'ICAP 2017'!L10","v":6035.4000000000005},{"$f":"C5+D5","v":15482},2533,{"$f":"B5+C5+D5+E5+G5-UDRsSummer","v":42502.3},null,{"$f":"'ICAP 2017'!O16","v":20178.702378095346},{"$f":"'ICAP 2017'!H16+'ICAP 2017'!I16+'ICAP 2017'!J16","v":5237.4609141485762},{"$f":"'ICAP 2017'!K16","v":11089.636795025635},{"$f":"'ICAP 2017'!L16","v":6518.0999127304467},{"$f":"K5+L5","v":16327.097709174212},2310.8000000000002,{"$f":"J5+K5+L5+M5+O5-UDRsWinter","v":44359.700000000004}]
[2017,{"$f":"SUM(B$5,B$37:B37)","v":19533.2},{"$f":"SUM(C$5,C$37:C37)","v":5182.7000000000007},{"$f":"SUM(D$5,D$37:D37)","v":10299.299999999999},{"$f":"SUM(E$5,E$37:E37)","v":6035.4000000000005},{"$f":"C6+D6-R6*D$31","v":15482},2533,42608.6,null,{"$f":"SUM(J$5,I$37:I37)","v":20285.002378095345},{"$f":"SUM(K$5,J$37:J37)","v":5237.4609141485762},{"$f":"SUM(L$5,K$37:K37)","v":11089.636795025635},{"$f":"SUM(M$5,L$37:L37)","v":6518.0999127304467},{"$f":"K6+L6-R6*D$31","v":16327.097709174212},2310.8000000000002,44466.000000000007]
[{"$f":"1+A6","v":2018},{"$f":"SUM(B$5,B$37:B38)","v":19613.190000000002},{"$f":"SUM(C$5,C$37:C38)","v":5879.3000000000011},{"$f":"SUM(D$5,D$37:D38)","v":10299.299999999999},{"$f":"SUM(E$5,E$37:E38)","v":5897.9000000000005},15911.858,1585.2,42299.890000000007,null,{"$f":"SUM(J$5,I$37:I38)","v":20360.172378095343},{"$f":"SUM(K$5,J$37:J38)","v":5950.5609141485766},{"$f":"SUM(L$5,K$37:K38)","v":11089.636795025635},{"$f":"SUM(M$5,L$37:L38)","v":6377.9999127304463},{"$f":"K7+L7-R7*D$31","v":16773.455709174214},1003.1,43806.47,null,511]
[2019,{"$f":"SUM(B$5,B$37:B39)","v":19613.190000000002},{"$f":"SUM(C$5,C$37:C39)","v":5879.3000000000011},{"$f":"SUM(D$5,D$37:D39)","v":10299.299999999999},{"$f":"SUM(E$5,E$37:E39)","v":5897.9000000000005},15900.896000000001,1594.2,42308.890000000007,null,{"$f":"SUM(J$5,I$37:I39)","v":20360.172378095343},{"$f":"SUM(K$5,J$37:J39)","v":5950.5609141485766},{"$f":"SUM(L$5,K$37:K39)","v":11089.636795025635},{"$f":"SUM(M$5,L$37:L39)","v":6377.9999127304463},16762.49370917421,1012.1,43815.47,null,532]
[2020,{"$f":"SUM(B$5,B$37:B40)","v":19613.190000000002},{"$f":"SUM(C$5,C$37:C40)","v":4867.2000000000007},{"$f":"SUM(D$5,D$37:D40)","v":10299.299999999999},{"$f":"SUM(E$5,E$37:E40)","v":5897.9000000000005},15166.5,2016.8,41719.390000000007,null,{"$f":"SUM(J$5,I$37:I40)","v":20360.172378095343},{"$f":"SUM(K$5,J$37:J40)","v":4920.3609141485767},{"$f":"SUM(L$5,K$37:K40)","v":11089.636795025635},{"$f":"SUM(M$5,L$37:L40)","v":6377.9999127304463},16009.997709174211,1434.7,43207.869999999995]
[2021,{"$f":"SUM(B$5,B$37:B41)","v":19613.190000000002},{"$f":"SUM(C$5,C$37:C41)","v":3827.8000000000006},{"$f":"SUM(D$5,D$37:D41)","v":10299.299999999999},{"$f":"SUM(E$5,E$37:E41)","v":5897.9000000000005},14127.1,2256.1999999999998,40919.39,null,{"$f":"SUM(J$5,I$37:I41)","v":20360.172378095343},{"$f":"SUM(K$5,J$37:J41)","v":3879.4609141485766},{"$f":"SUM(L$5,K$37:K41)","v":11089.636795025635},{"$f":"SUM(M$5,L$37:L41)","v":6377.9999127304463},14969.097709174212,1674.1,42406.37]
[2022,{"$f":"SUM(B$5,B$37:B42)","v":19613.190000000002},{"$f":"SUM(C$5,C$37:C42)","v":3827.8000000000006},{"$f":"SUM(D$5,D$37:D42)","v":10299.299999999999},{"$f":"SUM(E$5,E$37:E42)","v":5897.9000000000005},14127.1,2256.1999999999998,40919.39,null,{"$f":"SUM(J$5,I$37:I42)","v":20360.172378095343},{"$f":"SUM(K$5,J$37:J42)","v":3879.4609141485766},{"$f":"SUM(L$5,K$37:K42)","v":11089.636795025635},{"$f":"SUM(M$5,L$37:L42)","v":6377.9999127304463},14969.097709174212,1674.1,42406.37]
[2023,{"$f":"SUM(B$5,B$37:B43)","v":19613.190000000002},{"$f":"SUM(C$5,C$37:C43)","v":3827.8000000000006},{"$f":"SUM(D$5,D$37:D43)","v":10299.299999999999},{"$f":"SUM(E$5,E$37:E43)","v":5897.9000000000005},14127.1,2256.1999999999998,40919.39,null,{"$f":"SUM(J$5,I$37:I43)","v":20360.172378095343},{"$f":"SUM(K$5,J$37:J43)","v":3879.4609141485766},{"$f":"SUM(L$5,K$37:K43)","v":11089.636795025635},{"$f":"SUM(M$5,L$37:L43)","v":6377.9999127304463},14969.097709174212,1674.1,42406.37]
[2024,{"$f":"SUM(B$5,B$37:B44)","v":19613.190000000002},{"$f":"SUM(C$5,C$37:C44)","v":3827.8000000000006},{"$f":"SUM(D$5,D$37:D44)","v":10299.299999999999},{"$f":"SUM(E$5,E$37:E44)","v":5897.9000000000005},14127.1,2256.1999999999998,40919.39,null,{"$f":"SUM(J$5,I$37:I44)","v":20360.172378095343},{"$f":"SUM(K$5,J$37:J44)","v":3879.4609141485766},{"$f":"SUM(L$5,K$37:K44)","v":11089.636795025635},{"$f":"SUM(M$5,L$37:L44)","v":6377.9999127304463},14969.097709174212,1674.1,42406.37]
[2025,{"$f":"SUM(B$5,B$37:B45)","v":19613.190000000002},{"$f":"SUM(C$5,C$37:C45)","v":3827.8000000000006},{"$f":"SUM(D$5,D$37:D45)","v":10299.299999999999},{"$f":"SUM(E$5,E$37:E45)","v":5897.9000000000005},14127.1,2256.1999999999998,40919.39,null,{"$f":"SUM(J$5,I$37:I45)","v":20360.172378095343},{"$f":"SUM(K$5,J$37:J45)","v":3879.4609141485766},{"$f":"SUM(L$5,K$37:K45)","v":11089.636795025635},{"$f":"SUM(M$5,L$37:L45)","v":6377.9999127304463},14969.097709174212,1674.1,42406.37]
[2026,{"$f":"SUM(B$5,B$37:B46)","v":19613.190000000002},{"$f":"SUM(C$5,C$37:C46)","v":3827.8000000000006},{"$f":"SUM(D$5,D$37:D46)","v":10299.299999999999},{"$f":"SUM(E$5,E$37:E46)","v":5897.9000000000005},14127.1,2256.1999999999998,40919.39,null,{"$f":"SUM(J$5,I$37:I46)","v":20360.172378095343},{"$f":"SUM(K$5,J$37:J46)","v":3879.4609141485766},{"$f":"SUM(L$5,K$37:K46)","v":11089.636795025635},{"$f":"SUM(M$5,L$37:L46)","v":6377.9999127304463},14969.097709174212,1674.1,42406.37]
[2027,{"$f":"SUM(B$5,B$37:B47)","v":19613.190000000002},{"$f":"SUM(C$5,C$37:C47)","v":3827.8000000000006},{"$f":"SUM(D$5,D$37:D47)","v":10299.299999999999},{"$f":"SUM(E$5,E$37:E47)","v":5897.9000000000005},14127.1,2256.1999999999998,40919.39,null,{"$f":"SUM(J$5,I$37:I47)","v":20360.172378095343},{"$f":"SUM(K$5,J$37:J47)","v":3879.4609141485766},{"$f":"SUM(L$5,K$37:K47)","v":11089.636795025635},{"$f":"SUM(M$5,L$37:L47)","v":6377.9999127304463},14969.097709174212,1674.1,42406.37]
[2028,{"$f":"SUM(B$5,B$37:B48)","v":19613.190000000002},{"$f":"SUM(C$5,C$37:C48)","v":3827.8000000000006},{"$f":"SUM(D$5,D$37:D48)","v":10299.299999999999},{"$f":"SUM(E$5,E$37:E48)","v":5897.9000000000005},14127.1,2256.1999999999998,40919.39,null,{"$f":"SUM(J$5,I$37:I48)","v":20360.172378095343},{"$f":"SUM(K$5,J$37:J48)","v":3879.4609141485766},{"$f":"SUM(L$5,K$37:K48)","v":11089.636795025635},{"$f":"SUM(M$5,L$37:L48)","v":6377.9999127304463},14969.097709174212,1674.1,42406.37]
[2029,{"$f":"SUM(B$5,B$37:B49)","v":19613.190000000002},{"$f":"SUM(C$5,C$37:C49)","v":3827.8000000000006},{"$f":"SUM(D$5,D$37:D49)","v":10299.299999999999},{"$f":"SUM(E$5,E$37:E49)","v":5897.9000000000005},14127.1,2256.1999999999998,40919.39,null,{"$f":"SUM(J$5,I$37:I49)","v":20360.172378095343},{"$f":"SUM(K$5,J$37:J49)","v":3879.4609141485766},{"$f":"SUM(L$5,K$37:K49)","v":11089.636795025635},{"$f":"SUM(M$5,L$37:L49)","v":6377.9999127304463},14969.097709174212,1674.1,42406.37]
[2030,{"$f":"SUM(B$5,B$37:B50)","v":19613.190000000002},{"$f":"SUM(C$5,C$37:C50)","v":3827.8000000000006},{"$f":"SUM(D$5,D$37:D50)","v":10299.299999999999},{"$f":"SUM(E$5,E$37:E50)","v":5897.9000000000005},14127.1,2256.1999999999998,40919.39,null,{"$f":"SUM(J$5,I$37:I50)","v":20360.172378095343},{"$f":"SUM(K$5,J$37:J50)","v":3879.4609141485766},{"$f":"SUM(L$5,K$37:K50)","v":11089.636795025635},{"$f":"SUM(M$5,L$37:L50)","v":6377.9999127304463},14969.097709174212,1674.1,42406.37]
[2031,{"$f":"SUM(B$5,B$37:B51)","v":19613.190000000002},{"$f":"SUM(C$5,C$37:C51)","v":3827.8000000000006},{"$f":"SUM(D$5,D$37:D51)","v":10299.299999999999},{"$f":"SUM(E$5,E$37:E51)","v":5897.9000000000005},14127.1,2256.1999999999998,40919.39,null,{"$f":"SUM(J$5,I$37:I51)","v":20360.172378095343},{"$f":"SUM(K$5,J$37:J51)","v":3879.4609141485766},{"$f":"SUM(L$5,K$37:K51)","v":11089.636795025635},{"$f":"SUM(M$5,L$37:L51)","v":6377.9999127304463},14969.097709174212,1674.1,42406.37]
[2032,{"$f":"SUM(B$5,B$37:B52)","v":19613.190000000002},{"$f":"SUM(C$5,C$37:C52)","v":3827.8000000000006},{"$f":"SUM(D$5,D$37:D52)","v":10299.299999999999},{"$f":"SUM(E$5,E$37:E52)","v":5897.9000000000005},14127.1,2256.1999999999998,40919.39,null,{"$f":"SUM(J$5,I$37:I52)","v":20360.172378095343},{"$f":"SUM(K$5,J$37:J52)","v":3879.4609141485766},{"$f":"SUM(L$5,K$37:K52)","v":11089.636795025635},{"$f":"SUM(M$5,L$37:L52)","v":6377.9999127304463},14969.097709174212,1674.1,42406.37]
[2033,{"$f":"SUM(B$5,B$37:B53)","v":19613.190000000002},{"$f":"SUM(C$5,C$37:C53)","v":3827.8000000000006},{"$f":"SUM(D$5,D$37:D53)","v":10299.299999999999},{"$f":"SUM(E$5,E$37:E53)","v":5897.9000000000005},14127.1,2256.1999999999998,40919.39,null,{"$f":"SUM(J$5,I$37:I53)","v":20360.172378095343},{"$f":"SUM(K$5,J$37:J53)","v":3879.4609141485766},{"$f":"SUM(L$5,K$37:K53)","v":11089.636795025635},{"$f":"SUM(M$5,L$37:L53)","v":6377.9999127304463},14969.097709174212,1674.1,42406.37]
[2034,{"$f":"SUM(B$5,B$37:B54)","v":19613.190000000002},{"$f":"SUM(C$5,C$37:C54)","v":3827.8000000000006},{"$f":"SUM(D$5,D$37:D54)","v":10299.299999999999},{"$f":"SUM(E$5,E$37:E54)","v":5897.9000000000005},14127.1,2256.1999999999998,40919.39,null,{"$f":"SUM(J$5,I$37:I54)","v":20360.172378095343},{"$f":"SUM(K$5,J$37:J54)","v":3879.4609141485766},{"$f":"SUM(L$5,K$37:K54)","v":11089.636795025635},{"$f":"SUM(M$5,L$37:L54)","v":6377.9999127304463},14969.097709174212,1674.1,42406.37]
[2035,{"$f":"SUM(B$5,B$37:B55)","v":19613.190000000002},{"$f":"SUM(C$5,C$37:C55)","v":3827.8000000000006},{"$f":"SUM(D$5,D$37:D55)","v":10299.299999999999},{"$f":"SUM(E$5,E$37:E55)","v":5897.9000000000005},14127.1,2256.1999999999998,40919.39,null,{"$f":"SUM(J$5,I$37:I55)","v":20360.172378095343},{"$f":"SUM(K$5,J$37:J55)","v":3879.4609141485766},{"$f":"SUM(L$5,K$37:K55)","v":11089.636795025635},{"$f":"SUM(M$5,L$37:L55)","v":6377.9999127304463},14969.097709174212,1674.1,42406.37]
[2036,{"$f":"SUM(B$5,B$37:B56)","v":19613.190000000002},{"$f":"SUM(C$5,C$37:C56)","v":3827.8000000000006},{"$f":"SUM(D$5,D$37:D56)","v":10299.299999999999},{"$f":"SUM(E$5,E$37:E56)","v":5897.9000000000005},14127.1,2256.1999999999998,40919.39,null,{"$f":"SUM(J$5,I$37:I56)","v":20360.172378095343},{"$f":"SUM(K$5,J$37:J56)","v":3879.4609141485766},{"$f":"SUM(L$5,K$37:K56)","v":11089.636795025635},{"$f":"SUM(M$5,L$37:L56)","v":6377.9999127304463},14969.097709174212,1674.1,42406.37]
[2037,{"$f":"SUM(B$5,B$37:B57)","v":19613.190000000002},{"$f":"SUM(C$5,C$37:C57)","v":3827.8000000000006},{"$f":"SUM(D$5,D$37:D57)","v":10299.299999999999},{"$f":"SUM(E$5,E$37:E57)","v":5897.9000000000005},14127.1,2256.1999999999998,40919.39,null,{"$f":"SUM(J$5,I$37:I57)","v":20360.172378095343},{"$f":"SUM(K$5,J$37:J57)","v":3879.4609141485766},{"$f":"SUM(L$5,K$37:K57)","v":11089.636795025635},{"$f":"SUM(M$5,L$37:L57)","v":6377.9999127304463},14969.097709174212,1674.1,42406.37]
[]
["*Generation, SCRs and UDRs from Tab \"ICAP 2017\"; Net Imports from Table V-1"]
["**NYCA total includes Net Imports (from Table V-1) - UDR imports (already counted as Generation Supply).  "]
["***G-J includes impact of net exports on locality supply"]
["GHI to ISONE Export Factor:",null,null,{"$f":"1-0.478","v":0.52200000000000002}]
[]
["Annual Capacity Changes by Region"]
[null,"Summer",null,null,null,null,null,null,"Winter"]
["Year","ROS","GHI","J","K","NCZ (G-J)","NYCA",null,"ROS (A-F)","GHI","J","K","NCZ (G-J)","NYCA"]
[]
[2017,{"$f":"SUMIFS(cap,year,A37,zone,\"=ROS\")","v":106.3},{"$f":"SUMIFS(cap,year,$A37,zone,\"=GHI\")","v":0},{"$f":"SUMIFS(cap,year,$A37,zone,\"=J\")","v":0},{"$f":"SUMIFS(cap,year,$A37,zone,\"=K\")","v":0},{"$f":"C37+D37","v":0},{"$f":"B37+F37+E37","v":106.3},null,{"$f":"SUMIFS(wcap,year,A37,zone,\"=ROS\")","v":106.3},{"$f":"SUMIFS(wcap,year,$A37,zone,\"=GHI\")","v":0},{"$f":"SUMIFS(wcap,year,$A37,zone,\"=J\")","v":0},{"$f":"SUMIFS(wcap,year,$A37,zone,\"=K\")","v":0},{"$f":"J37+K37","v":0},{"$f":"I37+M37+L37","v":106.3}]
[{"$f":"1+A37","v":2018},79.989999999999995,{"$f":"SUMIFS(cap,year,A38,zone,\"=GHI\")","v":696.6},0,-137.5,{"$f":"C38+D38","v":696.6},639.09,null,75.17,713.1,0,-140.1,{"$f":"J38+K38","v":713.1},648.16999999999996]
[2019,0,0,0,0,{"$f":"C39+D39","v":0},0,null,0,0,0,0,{"$f":"J39+K39","v":0},0]
[2020,0,-1012.1,0,0,{"$f":"C40+D40","v":-1012.1},-1012.1,null,0,-1030.2,0,0,{"$f":"J40+K40","v":-1030.2},-1030.2]
[2021,0,-1039.4000000000001,0,0,{"$f":"C41+D41","v":-1039.4000000000001},-1039.4000000000001,null,0,-1040.9000000000001,0,0,-1040.9000000000001,-1040.9000000000001]
[2022,0,0,0,0,0,0,null,0,0,0,0,0,0]
[2023,0,0,0,0,0,0,null,0,0,0,0,0,0]
[2024,0,0,0,0,0,0,null,0,0,0,0,0,0]
[2025,0,0,0,0,0,0,null,0,0,0,0,0,0]
[2026,0,0,0,0,0,0,null,0,0,0,0,0,0]
[{"$f":"1+A46","v":2027},0,0,0,0,{"$f":"C47+D47","v":0},0,null,0,0,0,0,{"$f":"J47+K47","v":0},0]
[{"$f":"1+A47","v":2028},0,0,0,0,{"$f":"C48+D48","v":0},0,null,0,0,0,0,{"$f":"J48+K48","v":0},0]
[2029,0,0,0,0,0,0,null,0,0,0,0,0,0]
[2030,0,0,0,0,0,0,null,0,0,0,0,0,0]
[2031,0,0,0,0,0,0,null,0,0,0,0,0,0]
[2032,0,0,0,0,0,0,null,0,0,0,0,0,0]
[2033,0,0,0,0,0,0,null,0,0,0,0,0,0]
[2034,0,0,0,0,0,0,null,0,0,0,0,0,0]
[2035,0,0,0,0,0,0,null,0,0,0,0,0,0]
[{"$f":"1+A55","v":2036},0,0,0,0,{"$f":"C56+D56","v":0},0,null,0,0,0,0,{"$f":"J56+K56","v":0},0]
[2037,0,0,0,0,0,0,null,0,0,0,0,0,0]

{"sheet":"ICAP 2017","index":7,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["ICAP Zonal Supply by Capability Period, from 2017 Gold Book Table III-3"]
[]
[]
[]
["Zone","A","B","C","D","E","F","G","H","I","J","K","NYCA","G-J","ROS"]
[]
["Summer",3965.4,767.7,6635.8,1927.4,1036.5,4410.7,3004,2092.4,0,9612.2999999999993,5325.1,{"$f":"SUM(B7:L7)","v":38777.299999999996},{"$f":"SUM(H7:K7)","v":14708.699999999999},{"$f":"M7-N7-L7","v":18743.5},"Gen from Table III-3a"]
[null,301.7,73.900000000000006,116.6,62.4,37.5,91.3,53.9,7.4,25,372,50.3,1191.8,{"$f":"SUM(H8:K8)","v":458.3},{"$f":"M8-N8-L8","v":683.2},"SCR ICAP from 2016 DR Report, Table 3"]
[null,null,null,null,null,null,null,null,null,null,315,660,{"$f":"SUM(K9:L9)","v":975},{"$f":"SUM(H9:K9)","v":315},{"$f":"M9-N9-L9","v":0},"UDRs*"]
[null,{"$f":"B7+B8","v":4267.1000000000004},841.6,6752.4000000000005,1989.8000000000002,1074,4502,3057.9,2099.8000000000002,{"$f":"J7+J8","v":25},{"$f":"K7+K8+K9","v":10299.299999999999},{"$f":"L7+L8+L9","v":6035.4000000000005},{"$f":"SUM(B10:L10)","v":40944.300000000003},{"$f":"SUM(H10:K10)","v":15482},19426.900000000001,"NYCA Supply (exc. ROS imports)"]
[]
[]
["Winter",4053.4,781.5,6943.5,1930.7,1069.0999999999999,4927.5,3065.4,2124,0,10544.1,5817.3,{"$f":"SUM(B13:L13)","v":41256.500000000007},{"$f":"SUM(H13:K13)","v":15733.5},{"$f":"M13-N13-L13","v":19705.700000000008},"Gen from Table III-3b"]
[null,{"$f":"B19*$M14/$M19","v":210.5690411257772},40.281269772008287,82.809992363914034,55.235475073633687,26.882993345696519,57.223606414312201,28.26604123486419,4.5813461328678944,15.213526780844333,230.5367950256354,{"$f":"L19*$M14/$M19","v":40.79991273044616},792.4,278.59770917421179,{"$f":"M14-N14-L14","v":473.00237809534201},"SCR ICAP estimate**"]
[null,null,null,null,null,null,null,null,null,null,315,660,{"$f":"SUM(K15:L15)","v":975},315,0,"UDRs*"]
[null,{"$f":"B13+B14","v":4263.969041125777},{"$f":"C13+C14","v":821.78126977200827},7026.3099923639138,1985.9354750736338,1095.9829933456965,4984.7236064143126,3093.6660412348642,2128.581346132868,15.213526780844333,{"$f":"K13+K14+K15","v":11089.636795025635},{"$f":"L13+L14+L15","v":6518.0999127304467},{"$f":"SUM(B16:L16)","v":43023.9},16327.097709174212,20178.702378095346,"NYCA Supply (exc. ROS imports)"]
[]
[]
["SCR Winter Obligation 2015-16",243.6,46.6,95.8,63.9,31.1,66.2,32.700000000000003,5.3,17.600000000000001,266.7,47.2,{"$f":"SUM(B19:L19)","v":916.7},{"$f":"SUM(H19:K19)","v":322.3},{"$f":"SUM(B19:G19)","v":547.20000000000005},"DR Report for 2016, Table 9"]
[]
["*Assumes UDRs (import delivery rights) for full capacity of Neptune and VFT controllable lines from PJM"]
[]
["**Estimate Winter SCR ICAP by zone =  SCR ICAP total (from Table V-2b) x SCR ICAP Obligation by zone / SCR Winter Obligation Total (from 2016 DR Report Table 9)"]