{"text_format":"1","workbook":"xlsx","n_sheets":30,"sheets":["Instructions ","#1 Reserve Margins","#2 Heat Rates","#3 Fuel Diversity ","#4 Capacity Factor","#5 EEA Hours","#6 Performance During EEA","#7 Resource Availability","#8 RMR Capacity ","#9 RMR Contract","#10 Demand Response","#11 UnitHours Mtgted","#12 Wholesale Power","#13 Price Cost Markup","#14 Fuel Adj Price","#15 Price Convergence","#16 Congestion Management","#17 Admin Cost","#18 Net Revenues","#19 Avail 825 Shortage","#20 Net CONE Comparison","#21 Resource Deliverability","#22 New Capacity (Entry)","#23 Capacity Retire (Exit) ","#24 Forecasted Demand","#25 Capacity Procure","#26 Capacity Obligation","#27 Over Perform","#28 Under Perform","#29 Total Bonus"],"not_rendered":{"charts":0,"images":19,"macros":1,"external_links":0,"defined_names":8,"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":47,"n_cols":4,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[null,null,"FERC-922 (OMB Control No. 1902-0262)             Expiration Date:  to be determined"]
[null,null," The views expressed in this Information Collection Request do not represent the views of the Commission, the Chairman, or any Commissioner. "]
[]
[]
["Structure of the Information Collection Request"]
["There are three groups of Metrics in this Information Collection Request"]
[]
["Group 1: Administrative and Descriptive Metrics "]
["   All reporting entities should answer these metrics"]
["   These metrics are identified by yellow shading in the title row of the worksheet and on the worksheet tabs"]
["Group 2: Energy Market Metrics "]
["    All RTOs/ISOs should answer these metrics"]
["    These metrics are identified by green shading in the title row of the worksheet and on the worksheet tabs"]
["Group 3: Capacity Market Metrics "]
["   The four RTOs/ISOs with forward capacity markets should answer these metrics"]
["   These metrics are identified by blue shading in the title row of the worksheet and on the worksheet tabs"]
[]
[]
[null,null,"Contact Information"]
["Please complete the following text fields before entering any data in subsequent worksheets. "]
["Balancing Authority Area Name:",null,null,"Example:  PJM, ISO-NE, etc."]
["Name of the Contact Person",null,null,"John Doe"]
["Phone Number of the Contact Person",null,null,"202-111-1234"]
["Email address of the Contact Person",null,null,"john.doe@BAA.org"]
[]
[]
[null,null,"Data Reporting Period"]
["Respondents (utilities and RTOs/ISOs) without centralized capacity markets should enter the first calendar year of the five reporting periods."]
["RTOs/ISOs with centralized capacity markets should enter the four-digit year of the first delivery period of the five reporting periods.  "]
["For example, if June 2014 is the start of the first delivery period, enter 2014  "]
[]
[null,null,null,"YEAR"]
["Enter first reporting period (enter a 4 digit year in YYYY format)",null,null,2014]
[]
[]
[null,null,"Expiration Date"]
[null,null,"To be Determined"]
[]
[null,null,"Where to Send Comments on Public Reporting Burden"]
["The burden for the FERC-922 is estimated to average 402 hours per response, including the time for reviewing instructions,"]
[" searching existing data sources, gathering and maintaining the data, and completing and reviewing the collection of information. "]
[]
["Send comments regarding the burden estimate or any aspect of the collection of information, including suggestions for reducing "]
["burden, to the Federal Energy Regulatory Commission, 888 First Street NE, Washington, DC 20426 (Attention: Information Clearance Officer); "]
["and to the Office of Information and Regulatory Affairs, Office of Management and Budget, Washington, DC 20503 (Attention: Desk Officer "]
["for the Federal Energy Regulatory Commission). No person shall be subject to any penalty if any collection of information does not display"]
["a valid control number (44 U.S.C. § 3512 (a))."]

{"sheet":"#1 Reserve Margins","index":1,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,2,15,6],[0,2,0,6]]}
[null,"Balancing Authority Area Respondent Name:",{"$f":"+'Instructions '!D21","v":"Example:  PJM, ISO-NE, etc."}]
[]
["Group 1: Metric #1 Reserve Margins"]
[null,"Reporting Period",{"$f":"+'Instructions '!D33","v":2014},{"$f":"+C4+1","v":2015},{"$f":"+D4+1","v":2016},2017,2018]
[1,"Forecasted Peak Demand (MW).  Enter the value of the forecasted net coincident peak load (actual peak, not normalized) integrated over the peak hour; net of behind-the-meter photovoltaic and energy efficiency for the entire Balancing Authority Area for the given reporting period.  For some RTOs/ISOs, this number may have been determined prior to an initial capacity auction.  ",null,0,0,0,0]
[{"$f":"+A5+0.01","v":1.01},"Publication Date of the Forecasted Peak Demand.  Enter the date in MM/YYYY format of the last binding capacity auction or the date of the forecast from the most recent planning process at which time the peak demand was forecasted. ","00/0000","00/0000","00/0000","00/0000","0/0000"]
[{"$f":"+A6+0.01","v":1.02},"Total Anticipated Installed Capacity (MW).  Enter the amount of capacity expected to be available for the entire Balancing Authority Area at the time the Forecasted Peak Demand was calculated for the reporting period. This is the cleared capacity in the binding auction for ISOs/RTOs with a capacity market. For IOUs and RTOs/ISOs without capacity markets use the generation estimate used for the planning process (e.g., Resource Adequacy, etc.) ",null,0,0,0,0]
[1.03,"Publication Date of the Estimate of the Total Anticipated Installed Capacity.  Enter the date in MM/YYYY format.  (This may be the same date as the Date of Forecasted Peak Demand)","00/0000","00/0000","00/0000","00/0000","0/0000"]
[1.04,"Anticipated Reserve (MW). The value for Anticipated Reserves for the entire Balancing Authority Area for the given reporting period is calculated as [Total Anticipated Installed Capacity –  Forecasted Peak Demand].  (Automatically calculated)",{"$f":"+C7-C5","v":0},{"$f":"+D7-D5","v":0},{"$f":"+E7-E5","v":0},{"$f":"+F7-F5","v":0},{"$f":"+G7-G5","v":0}]
[1.05,"Anticipated Reserve Margin (%).   The Anticipated Reserve Margin is the ratio of the amount of anticipated reserves in relation to the forecasted demand, calculated as [(Total Anticipated Installed Capacity – Forecasted Peak Demand) / Forecasted Peak Demand].  (Automatically calculated)",{"$f":"+(C9)/C5","v":{"$error":"#DIV/0!"}},{"$f":"+(D9)/D5","v":{"$error":"#DIV/0!"}},{"$f":"+(E9)/E5","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[1.06,"Actual Peak Demand (MW).  Enter the value of the net coincident peak load (actual peak, not normalized) integrated over the peak hour; net of behind-the-meter photovoltaic and energy efficiency for the entire Balancing Authority Area for the given reporting period."]
[1.07,"Total Available Installed Capacity (MW).  Enter the amount of capacity that was available for the entire Balancing Authority Area at the time the Actual Peak Demand was realized during the reporting  period.  This is the available capacity at the time of the Actual Peak Demand."]
[1.08,"Date of the Actual Peak Demand.  Enter the date in DD/MM/YYYY format.  ","00/00/0000","00/00/0000","00/00/0000","00/00/0000","00/00/0000"]
[1.0900000000000001,"Actual Reserve (MW).  The value for the actual reserves for the entire Balancing Authority Area for the given reporting period calculated as [Total Actual Installed Capacity – Actual Peak Demand].  (Automatically calculated) ",{"$f":"+C12-C11","v":0},{"$f":"+D12-D11","v":0},0,0,0]
[1.1000000000000001,"Actual Reserve Margin (%).  The actual reserve margin is the ratio of the amount of reserves procured for a specific reporting period, calculated as [(Total Actual Installed Capacity – Actual Peak Demand) / Actual Peak Demand].  (Automatically calculated)",{"$f":"+(C14)/C11","v":{"$error":"#DIV/0!"}},{"$f":"+(D14)/D11","v":{"$error":"#DIV/0!"}},{"$f":"+(E14)/E11","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[1.1100000000000001,"Adjustment methodology.  Describe your adjustment methodology by technology.","text"]

{"sheet":"#2 Heat Rates","index":2,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,2,10,6],[0,2,0,6]]}
[null,"Balancing Authority Area Respondent Name:",{"$f":"+'#1 Reserve Margins'!C1","v":"Example:  PJM, ISO-NE, etc."}]
[]
["Group 1: Metric #2 Average Heat Rates"]
[]
[null," Reporting Period",{"$f":"+'#1 Reserve Margins'!C4","v":2014},{"$f":"+'#1 Reserve Margins'!D4","v":2015},{"$f":"+'#1 Reserve Margins'!E4","v":2016},{"$f":"+'#1 Reserve Margins'!F4","v":2017},{"$f":"+'#1 Reserve Margins'!G4","v":2018}]
[{"$f":"+'#1 Reserve Margins'!A5+1","v":2},"Average Heat Rate of Oil-fired Steam Generation (Btu/kWh).  ",0,0,0,0,0]
[{"$f":"+A6+0.01","v":2.0099999999999998},"Average Heat Rate of Natural Gas-fired Steam Generation (Btu/kWh).  ",0,0,0,0,0]
[{"$f":"+A7+0.01","v":2.0199999999999996},"Average Heat Rate of Coal-fired Generation (Btu/kWh).  ",0,0,0,0,0]
[2.0299999999999994,"Average Heat Rate of Combustion Turbine Generation (Btu/kWh).",0,0,0,0,0]
[2.0399999999999991,"Average Heat Rate of Combined Cycle Generation (Btu/kWh).",0,0,0,0,0]
[2.0499999999999989,"Explanatory Text.  Explanations, for example, if you haven't used the primary fuel for dual-fuel units, please explain.  ","text"]

{"sheet":"#3 Fuel Diversity ","index":3,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,2,0,6],[28,2,28,6]]}
[null,"Balancing Authority Area Respondent Name:",{"$f":"+'#1 Reserve Margins'!C1","v":"Example:  PJM, ISO-NE, etc."}]
[]
["Group 1: Metric #3  Fuel Diversity"]
[null,{"$f":"+'#1 Reserve Margins'!B4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!C4","v":2014},{"$f":"+'#1 Reserve Margins'!D4","v":2015},{"$f":"+'#1 Reserve Margins'!E4","v":2016},{"$f":"+'#1 Reserve Margins'!F4","v":2017},{"$f":"+'#1 Reserve Margins'!G4","v":2018}]
["Summer Capacity Rating by Fuel Type (MW)"]
[{"$f":"1+'#2 Heat Rates'!A6","v":3},"Biomass",0,0,0,0,0]
[{"$f":"+A6+0.01","v":3.01},"Coal",0,0,0,0,0]
[{"$f":"+A7+0.01","v":3.0199999999999996},"Geothermal",0,0,0,0,0]
[3.0299999999999994,"Natural Gas",0,0,0,0,0]
[3.0399999999999991,"Other Fuel ",0,0,0,0,0]
[3.0499999999999989,"Petroleum Products",0,0,0,0,0]
[3.0599999999999987,"Solar",0,0,0,0,0]
[3.0699999999999985,"Nuclear  (All Fuel Types)",0,0,0,0,0]
[3.0799999999999983,"Water (Hydro)",0,0,0,0,0]
[3.0899999999999981,"Pumped / Hydro Storage ",0,0,0,0,0]
[3.0999999999999979,"Wind",0,0,0,0,0]
[3.1099999999999977,"Battery",0,0,0,0,0]
["Total Energy Generated by Fuel Type (MWh)"]
[{"$f":"+A17+0.01","v":3.1199999999999974},"Biomass",0,0,0,0,0]
[{"$f":"+A19+0.01","v":3.1299999999999972},"Coal",0,0,0,0,0]
[{"$f":"+A20+0.01","v":3.139999999999997},"Geothermal",0,0,0,0,0]
[3.1499999999999968,"Natural Gas",0,0,0,0,0]
[3.1599999999999966,"Other Fuel",0,0,0,0,0]
[3.1699999999999964,"Petroleum Products",0,0,0,0,0]
[3.1799999999999962,"Solar",0,0,0,0,0]
[3.1899999999999959,"Nuclear  (All Fuel Types)",0,0,0,0,0]
[3.1999999999999957,"Water (Hydro)",0,0,0,0,0]
[3.2099999999999955,"Wind",0,0,0,0,0]
[3.2199999999999953,"Explanatory Text.  Add any explanatory text if necessary","Text"]
[]
[null,"\"Summer Capacity\" means the Net Summer Capacity rating as defined by the Energy Information Administration (EIA)"]
[null,"Note: There is no row for Energy Generated (MWh) by Fuel Type for the Pumped Storage and Battery Categories "]

{"sheet":"#4 Capacity Factor","index":4,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,15,2,17],[14,3,14,17],[14,1,14,2],[11,15,11,17],[0,0,0,2],[11,3,11,5],[11,6,11,8],[11,9,11,11],[11,12,11,14],[10,3,10,5],[10,6,10,8],[10,9,10,11],[10,12,10,14],[10,15,10,17],[13,12,13,14],[13,15,13,17],[13,3,13,5],[13,6,13,8],[13,9,13,11],[9,12,9,14],[9,15,9,17],[9,3,9,5],[9,6,9,8],[9,9,9,11],[12,3,12,5],[12,6,12,8],[12,9,12,11],[12,12,12,14],[12,15,12,17],[8,3,8,5],[8,6,8,8],[8,9,8,11],[8,12,8,14],[8,15,8,17],[0,3,0,17],[7,3,7,5],[7,6,7,8],[7,9,7,11],[7,12,7,14],[7,15,7,17],[4,3,4,5],[4,6,4,8],[4,9,4,11],[3,12,3,14],[3,15,3,17],[6,9,6,11],[6,12,6,14],[6,15,6,17],[4,12,4,14],[4,15,4,17],[6,3,6,5],[6,6,6,8],[5,12,5,14],[5,15,5,17],[3,3,3,5],[3,6,3,8],[3,9,3,11],[5,3,5,5],[5,6,5,8],[5,9,5,11]]}
["Balancing Authority Area Respondent Name:",null,null,"Example:  PJM, ISO-NE, etc."]
[]
["Group 1: Metric #4 Capacity Factor by Technology Type"]
[null,null,{"$f":"+'#1 Reserve Margins'!B4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!C4","v":2014},null,null,{"$f":"+'#1 Reserve Margins'!D4","v":2015},null,null,{"$f":"+'#1 Reserve Margins'!E4","v":2016},null,null,{"$f":"+'#1 Reserve Margins'!F4","v":2017},null,null,{"$f":"+'#1 Reserve Margins'!G4","v":2018}]
[null,"Technology / Fuel Type","Units","Capacity Factor*",null,null,"Capacity Factor*",null,null,"Capacity Factor*",null,null,"Capacity Factor*",null,null,"Capacity Factor*"]
[4,"Coal (All types)","All sizes",0,null,null,0,null,null,0,null,null,0,null,null,0]
[{"$f":"+A6+0.01","v":4.01},"Oil (Steam)","All sizes",0,null,null,0,null,null,0,null,null,0,null,null,0]
[{"$f":"+A7+0.01","v":4.0199999999999996},"Natural Gas  (Steam)","All sizes",0,null,null,0,null,null,0,null,null,0,null,null,0]
[4.0299999999999994,"Gas / Oil Turbine","All sizes",0,null,null,0,null,null,0,null,null,0,null,null,0]
[4.0399999999999991,"Combined Cycle","All sizes",0,null,null,0,null,null,0,null,null,0,null,null,0]
[4.0499999999999989,"Nuclear  (All Fuel Types)","All sizes",0,null,null,0,null,null,0,null,null,0,null,null,0]
[4.0599999999999987,"Hydro","All sizes",0,null,null,0,null,null,0,null,null,0,null,null,0]
[4.0699999999999985,"Wind","All sizes",0,null,null,0,null,null,0,null,null,0,null,null,0]
[4.0799999999999983,"Solar","All sizes",0,null,null,0,null,null,0,null,null,0,null,null,0]
[4.0899999999999981,"Explanatory Text.  Add any explanatory text if necessary",null,"Text"]
[]
[null,null,null,"* Note: The capacity factor will range between 0 and 1.  For example, a value of 0.89 indicates a capacity factor of 89 percent."]

{"sheet":"#5 EEA Hours","index":5,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,2,0,6],[12,1,12,2],[7,2,7,6]]}
[null,"Balancing Authority Area Respondent Name:",{"$f":"+'#1 Reserve Margins'!C1","v":"Example:  PJM, ISO-NE, etc."}]
[]
["Group 1: Metric #5  Emergency Energy Alerts (EEA Level 1 or Higher)"]
[null,{"$f":"+'#1 Reserve Margins'!B4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!C4","v":2014},{"$f":"+'#1 Reserve Margins'!D4","v":2015},{"$f":"+'#1 Reserve Margins'!E4","v":2016},{"$f":"+'#1 Reserve Margins'!F4","v":2017},{"$f":"+'#1 Reserve Margins'!G4","v":2018}]
[5,"Number of EEAs (Level 1 or higher) (Integer).  Report the number of recognized EEAs during the reporting period.  If an alert escalates from a lower level to a higher level (e.g., a Level 1 converts to a Level 2 or 3), report as one event. ",0,0,0,0,0]
[{"$f":"+A5+0.01","v":5.01},"Number of EEA Hours (HH:MM).  Report the sum of hours in which any level of an EEA occurred during the reporting period.  Report a number in the form HH:MM where HH is the number of hours and MM is the number of minutes.",0,0,0,0,0]
[{"$f":"+A6+0.01","v":5.0199999999999996},"Amount of Load Shed during EEA Alerts (MWh).  Report the total MWh of load that were shed during the EEAs in the reporting period.  (Do not report the amount of interruptible load terminated due to emergency conditions).",0,0,0,0,0]
[{"$f":"+A7+0.01","v":5.0299999999999994},"Explanatory Text.  Add any explanatory text if necessary.","Text"]

{"sheet":"#6 Performance During EEA","index":6,"n_rows":16,"n_cols":16,"rows_kept":16,"cut":false,"hidden":false,"merged":[[6,3,6,5],[6,6,6,8],[6,9,6,11],[6,12,6,14],[6,15,6,17],[7,3,7,5],[7,6,7,8],[7,9,7,11],[7,12,7,14],[7,15,7,17],[5,3,5,5],[5,6,5,8],[5,9,5,11],[5,12,5,14],[5,15,5,17],[0,3,0,17],[4,9,4,11],[4,6,4,8],[0,0,0,2],[1,0,1,17],[4,3,4,5],[4,12,4,14],[4,15,4,17],[9,3,9,5],[9,6,9,8],[9,9,9,11],[9,12,9,14],[9,15,9,17],[8,3,8,5],[8,6,8,8],[8,9,8,11],[8,12,8,14],[8,15,8,17],[10,15,10,17],[11,3,11,5],[11,6,11,8],[11,9,11,11],[11,12,11,14],[11,15,11,17],[14,12,14,14],[10,3,10,5],[10,6,10,8],[10,9,10,11],[10,12,10,14],[14,15,14,17],[15,1,15,2],[15,3,15,17],[12,3,12,5],[12,6,12,8],[12,9,12,11],[12,12,12,14],[12,15,12,17],[13,3,13,5],[13,6,13,8],[13,9,13,11],[13,12,13,14],[13,15,13,17],[14,3,14,5],[14,6,14,8],[14,9,14,11]]}
["Balancing Authority Area Respondent Name:",null,null,{"$f":"+'#1 Reserve Margins'!C1","v":"Example:  PJM, ISO-NE, etc."}]
[]
["Group 1: Metric #6  Performance by Technology Type during EEA Level 1 or Higher"]
[]
[null,null,{"$f":"+'#1 Reserve Margins'!B4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!C4","v":2014},null,null,{"$f":"+'#1 Reserve Margins'!D4","v":2015},null,null,{"$f":"+'#1 Reserve Margins'!E4","v":2016},null,null,{"$f":"+'#1 Reserve Margins'!F4","v":2017},null,null,{"$f":"+'#1 Reserve Margins'!G4","v":2018}]
[null,"Technology / Fuel Type","Units","Performance",null,null,"Performance",null,null,"Performance",null,null,"Performance",null,null,"Performance"]
[6,"Coal (All types)","All sizes",0,null,null,0,null,null,0,null,null,0,null,null,0]
[{"$f":"+A7+0.01","v":6.01},"Oil (Steam)","All sizes",0,null,null,0,null,null,0,null,null,0,null,null,0]
[{"$f":"+A8+0.01","v":6.02},"Natural Gas  (Steam)","All sizes",0,null,null,0,null,null,0,null,null,0,null,null,0]
[6.0299999999999994,"Gas / Oil Turbine","All sizes",0,null,null,0,null,null,0,null,null,0,null,null,0]
[6.0399999999999991,"Combined Cycle","All sizes",0,null,null,0,null,null,0,null,null,0,null,null,0]
[6.0499999999999989,"Nuclear  (All Fuel Types)","All sizes",0,null,null,0,null,null,0,null,null,0,null,null,0]
[6.0599999999999987,"Hydro","All sizes",0,null,null,0,null,null,0,null,null,0,null,null,0]
[6.0699999999999985,"Wind","All sizes",0,null,null,0,null,null,0,null,null,0,null,null,0]
[6.0799999999999983,"Solar","All sizes",0,null,null,0,null,null,0,null,null,0,null,null,0]
[6.0899999999999981,"Explanatory Text.  Add any explanatory text if necessary",null,"Text"]

{"sheet":"#7 Resource Availability","index":7,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,3,0,7],[0,0,0,2],[14,3,14,7]]}
["Balancing Authority Area Respondent Name:",null,null,{"$f":"+'#1 Reserve Margins'!C1","v":"Example:  PJM, ISO-NE, etc."}]
[]
["Group 1: Metric #7  Resource Availability (EFORd)"]
[null,null,{"$f":"+'#1 Reserve Margins'!B4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!C4","v":2014},{"$f":"+'#1 Reserve Margins'!D4","v":2015},{"$f":"+'#1 Reserve Margins'!E4","v":2016},{"$f":"+'#1 Reserve Margins'!F4","v":2017},{"$f":"+'#1 Reserve Margins'!G4","v":2018}]
[null,"Technology / Fuel Type","Units","EFORd","EFORd","EFORd","EFORd","EFORd"]
[7,"Coal (All types)","All sizes",0,0,0,0,0]
[{"$f":"+A6+0.01","v":7.01},"Oil (Steam)","All sizes",0,0,0,0,0]
[{"$f":"+A7+0.01","v":7.02},"Natural Gas  (Steam)","All sizes",0,0,0,0,0]
[7.0299999999999994,"Gas / Oil Turbine","All sizes",0,0,0,0,0]
[7.0399999999999991,"Combined Cycle","All sizes",0,0,0,0,0]
[7.0499999999999989,"Nuclear  (All Fuel Types)","All sizes",0,0,0,0,0]
[7.0599999999999987,"Hydro","All sizes",0,0,0,0,0]
[7.0699999999999985,"Wind","All sizes",0,0,0,0,0]
[7.0799999999999983,"Solar","All sizes",0,0,0,0,0]
[7.0899999999999981,"Explanatory Text.  Add any explanatory text if necessary.",null,"Text"]

{"sheet":"#8 RMR Capacity ","index":8,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,2,8,6]]}
[null,"Balancing Authority Area Respondent Name:",{"$f":"+'#1 Reserve Margins'!C1","v":"Example:  PJM, ISO-NE, etc."}]
[]
["Group 2: Metric #8 Number and Capacity of Reliability Must-Run Units "]
[null,{"$f":"+'#1 Reserve Margins'!B4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!C4","v":2014},{"$f":"+'#1 Reserve Margins'!D4","v":2015},{"$f":"+'#1 Reserve Margins'!E4","v":2016},{"$f":"+'#1 Reserve Margins'!F4","v":2017},{"$f":"+'#1 Reserve Margins'!G4","v":2018}]
[8,"Number of RMR Units (Integer).  Number of generation units under reliability must-run (RMR) or equivalent contracts in each reporting period.  Please note that RTOs and ISOs use various terms to refer to such arrangements, e.g., “System Support Resources” in MISO.  For the purposes of this report, such arrangements are collectively referred to as RMR.   (RMR refers to \"out of market\" contracts for specific generation units in the organized markets.) ",0,0,0,0,0]
[{"$f":"+A5+0.01","v":8.01},"Total Capacity of RMR Units (MW).  Sum of the Nameplate capacity of the generation units under RMR or equivalent contracts for each reporting period.",0,0,0,0,0]
[{"$f":"+A6+0.01","v":8.02},"Total Available Installed Capacity (MW).    (Automatically copied from Metric 1)",{"$f":"+'#1 Reserve Margins'!C12","v":0},{"$f":"+'#1 Reserve Margins'!D12","v":0},{"$f":"+'#1 Reserve Margins'!E12","v":0},{"$f":"+'#1 Reserve Margins'!F12","v":0},{"$f":"+'#1 Reserve Margins'!G12","v":0}]
[8.0299999999999994,"RMR MW as Percent of Total Available Installed Capacity (%).  The Total Capacity of RMR units as a percentage of the Total Available Installed Capacity of the Balancing Authority Area.  (Automatically calculated)",{"$f":"+C6/C7","v":{"$error":"#DIV/0!"}},{"$f":"+D6/D7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[8.0399999999999991,"Explanatory Text.  Add any explanatory text if necessary","Text"]

{"sheet":"#9 RMR Contract","index":9,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[7,2,7,6]]}
[null,"Balancing Authority Area Respondent Name:",{"$f":"+'#1 Reserve Margins'!C1","v":"Example:  PJM, ISO-NE, etc."}]
[]
["Group 2: Metric #9  Reliability Must-Run Contract Usage "]
[null,{"$f":"+'#1 Reserve Margins'!B4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!C4","v":2014},{"$f":"+'#1 Reserve Margins'!D4","v":2015},{"$f":"+'#1 Reserve Margins'!E4","v":2016},{"$f":"+'#1 Reserve Margins'!F4","v":2017},{"$f":"+'#1 Reserve Margins'!G4","v":2018}]
[9,"Hours RMR Units Were Used (Integer).  Number of unit hours that generation units under reliability must-run (RMR) or equivalent contracts were called upon.  ",0,0,0,0,0]
[{"$f":"+A5+0.01","v":9.01},"Total MWh Provided by RMR Units (Integer).  Sum of the MWh that all RMR units provided in each reporting period.  ",0,0,0,0,0]
[{"$f":"+A6+0.01","v":9.02},"Total Cost of RMR Units ($).  Sum of the costs of all RMR contracts for each reporting period.  ",0,0,0,0,0]
[{"$f":"+A7+0.01","v":9.0299999999999994},"Explanatory Text.  Add any explanatory text if necessary","Text"]

{"sheet":"#10 Demand Response","index":10,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[9,2,9,6]]}
[null,"Balancing Authority Area Respondent Name:",{"$f":"+'#1 Reserve Margins'!C1","v":"Example:  PJM, ISO-NE, etc."}]
[]
["Group 2: Metric #10 Demand Response Capability  "]
[null,{"$f":"+'#1 Reserve Margins'!B4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!C4","v":2014},{"$f":"+'#1 Reserve Margins'!D4","v":2015},{"$f":"+'#1 Reserve Margins'!E4","v":2016},{"$f":"+'#1 Reserve Margins'!F4","v":2017},{"$f":"+'#1 Reserve Margins'!G4","v":2018}]
[10,"Total MWh of Demand Response (MWh).  MWh of Demand Response resources in each reporting period.  (Includes RTO/ISO-registered and controlled demand response.  See the User Guide for instructions.)",0,0,0,0,0]
[{"$f":"+A5+0.01","v":10.01},"Total Available Installed Capacity (MW).   (Automatically copied from Metric 1)",{"$f":"+'#1 Reserve Margins'!C12","v":0},{"$f":"+'#1 Reserve Margins'!D12","v":0},{"$f":"+'#1 Reserve Margins'!E12","v":0},{"$f":"+'#1 Reserve Margins'!F12","v":0},{"$f":"+'#1 Reserve Margins'!G12","v":0}]
[{"$f":"+A6+0.01","v":10.02},"Demand Response Resources as a Percent of Total Available Installed Capacity (%).  The Total MW of Demand Response as a percentage of the Total Available Installed Capacity of the Balancing Authority Area.  (Automatically calculated)",{"$f":"C5/C6","v":{"$error":"#DIV/0!"}},{"$f":"D5/D6","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"+A7+0.01","v":10.029999999999999},"Actual Peak Demand (MW).   (Automatically copied from Metric 1)",{"$f":"+'#1 Reserve Margins'!C11","v":0},{"$f":"+'#1 Reserve Margins'!D11","v":0},{"$f":"+'#1 Reserve Margins'!E11","v":0},{"$f":"+'#1 Reserve Margins'!F11","v":0},{"$f":"+'#1 Reserve Margins'!G11","v":0}]
[{"$f":"+A8+0.01","v":10.039999999999999},"Demand Response Resources as a Percent of Actual Peak Demand (%).  The Total MW of Demand Response as a percentage of the Actual Peak Demand in the Balancing Authority Area.  (Automatically calculated)",{"$f":"C5/C8","v":{"$error":"#DIV/0!"}},{"$f":"D5/D8","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"+A9+0.01","v":10.049999999999999},"Explanatory Text.  Provide any additional information if necessary.   ","Text"]

{"sheet":"#11 UnitHours Mtgted","index":11,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,2,0,6],[8,2,8,6]]}
[null,"Balancing Authority Area Respondent Name:",{"$f":"+'#1 Reserve Margins'!C1","v":"Example:  PJM, ISO-NE, etc."}]
[]
["Group 2: Metric #11 Unit Hours Mitigated"]
[null,{"$f":"+'#1 Reserve Margins'!B4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!C4","v":2014},{"$f":"+'#1 Reserve Margins'!D4","v":2015},{"$f":"+'#1 Reserve Margins'!E4","v":2016},{"$f":"+'#1 Reserve Margins'!F4","v":2017},{"$f":"+'#1 Reserve Margins'!G4","v":2018}]
[11,"Number of Unit Hours With Active Mitigation (Day-ahead) (Integer).  Provide the number of unit hours in each reporting period that any generation unit(s) offer was mitigated in the day-ahead energy market.   ",0,0,0,0,0]
[{"$f":"+A5+0.01","v":11.01},"Number of Unit Intervals With Active Mitigation (Real-time) (Integer).  Provide the number of unit intervals in each reporting period that any generation unit(s) was mitigated in the real-time energy market. ",0,0,0,0,0]
[{"$f":"+A6+0.01","v":11.02},"Percent of Unit Hours With Active Mitigation (Day-ahead) (%).  Calculate the fraction of unit hours in each reporting period that any generation unit(s) offer cap in the day-ahead energy market was set due to mitigation and report that as a percent of the number of all unit hours.  (Automatically calculated)",{"$f":"+C5/8760","v":0},{"$f":"+D5/8760","v":0},{"$f":"+E5/8784","v":0},0,0]
[11.03,"Percent of Unit Intervals With Active Mitigation (Real-time) (%).  Calculate the fraction of unit intervals in each reporting period that any generation unit(s) offer cap in the real-time market was set due to mitigation and report that as a percent of the number of all unit hours.  (Automatically calculated)",{"$f":"+C6/8760","v":0},{"$f":"+D6/8760","v":0},{"$f":"+E6/8784","v":0},{"$f":"+F6/8760","v":0},{"$f":"+G6/8760","v":0}]
[11.04,"Explanatory Text.  Provide any additional information if necessary.   ","text"]
[]
[" "," "]

{"sheet":"#12 Wholesale Power","index":12,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[15,2,15,6],[0,2,0,6]]}
[null,"Balancing Authority Area Respondent Name:",{"$f":"+'#1 Reserve Margins'!C1","v":"Example:  PJM, ISO-NE, etc."}]
[]
["Group 2: Metric #12 Wholesale Power Costs by Charge Type"]
[null,{"$f":"+'#1 Reserve Margins'!B4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!C4","v":2014},{"$f":"+'#1 Reserve Margins'!D4","v":2015},{"$f":"+'#1 Reserve Margins'!E4","v":2016},{"$f":"+'#1 Reserve Margins'!F4","v":2017},{"$f":"+'#1 Reserve Margins'!G4","v":2018}]
["Net Energy  (MWh)"]
[12,"Net Energy for Load.  Total generation plus imports minus exports minus losses. From FERC Form No. 714, Schedule 3, Balancing Authority Net Energy for Load and Peak Demand Sources by Month, Net Energy for Load, Column (e), sum the entries in column (e) for the months in the reporting period (Lines 1-12).  To compute the Net Energy for Load for a Reporting Period which spans calendar years, you will need to include months from another annual Form No. 714.  See User Guide."]
["Wholesale Power Cost Components ($)"]
[12.01,"Energy Component of Total Wholesale Power Cost ($).  Report the total energy component (including system marginal price, congestion and losses) of wholesale power costs paid by load and exports for each reporting period.  This component is the real-time load weighted average locational marginal price.",0,0,0,0,0]
[12.02,"Capacity Component of Total Wholesale Power Cost ($).  Report the total capacity component of wholesale power costs paid by load for each reporting period.  If your RTO/ISO does not have a centralized capacity market enter zero. ",0,0,0,0,0]
[12.03,"Transmission Component of Total Wholesale Power Cost ($).  Report the total FERC-approved Transmission Charges paid by load for each reporting period.",0,0,0,0,0]
[12.04,"Ancillary Service Component of Total Wholesale Power Cost ($).  Report the total ancillary service component of wholesale power costs paid by load for each reporting period.  Include the cost for all ancillary services such as black start, reactive power etc. that are not included in the Operating Reserve charge type.",0,0,0,0,0]
[12.05,"Operating Reserves Component of Total Wholesale Power Cost ($).  Report the total operating reserves component of wholesale power costs paid by load for each reporting period.  Include costs for ancillary services, such as regulation, spinning and non-spinning reserves, and ramp products.",0,0,0,0,0]
[12.06,"RTO and Regulatory Fee Component of Total Wholesale Power Cost ($).  Report the total RTO cost and regulatory fee component of wholesale power costs paid by load for each reporting period.  Include charges to NERC/Reliability organizations (including Reliability Entity fees), RTO startup and expansion fees, etc.  ",0,0,0,0,0]
[12.07,"Other Cost Component of Total Wholesale Power Cost ($).  If the RTO accounts for cost categories that are not included in the above list (i.e., uplift charges), please report those costs here and describe the cost category in the Explanatory Text category below.  Note, for example, that the PJM Balancing Operating Reserve credit and Day Ahead Operating Reserve credit are included in this line.",0,0,0,0,0]
[12.08,"Total Wholesale Power Cost ($).  The worksheet calculates the total wholesale power cost paid by load for each reporting period in dollars by summing the cost components in lines 12.01 through 12.07.  (Automatically calculated)",{"$f":"SUM(C8:C14)","v":0},{"$f":"SUM(D8:D14)","v":0},0,0,0]
[12.09,"Explanatory Text.   Please report any unusual events that provide context to this metric.  For instance, the expansion of the RTO/ISO footprint may explain changes in the capacity costs.","text"]
[]
[]
[null,{"$f":"+'#1 Reserve Margins'!B4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!C4","v":2014},{"$f":"+'#1 Reserve Margins'!D4","v":2015},{"$f":"+'#1 Reserve Margins'!E4","v":2016},{"$f":"+'#1 Reserve Margins'!F4","v":2017},{"$f":"+'#1 Reserve Margins'!G4","v":2018}]
["Wholesale Power Cost Components ($/MWh) "]
[{"$f":"+A16+0.01","v":12.1},"Energy Component of Total Wholesale Power Cost  (Automatically calculated)",{"$f":"+C8/C$15","v":{"$error":"#DIV/0!"}},{"$f":"+D8/D$15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"+A21+0.01","v":12.11},"Capacity Component of Total Wholesale Power Cost (Automatically calculated)",{"$error":"#DIV/0!"},{"$f":"+D9/D$15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"+A22+0.01","v":12.12},"Transmission Component of Total Wholesale Power Cost  (Automatically calculated)",{"$error":"#DIV/0!"},{"$f":"+D10/D$15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[12.129999999999999,"Ancillary Service Component of Total Wholesale Power Cost  (Automatically calculated)",{"$error":"#DIV/0!"},{"$f":"+D11/D$15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[12.139999999999999,"Operating Reserves Component of Total Wholesale Power Cost (Automatically calculated)",{"$error":"#DIV/0!"},{"$f":"+D12/D$15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[12.149999999999999,"RTO/ISO and Regulatory Fee Component of Total Wholesale Power Cost  (Automatically calculated)",{"$error":"#DIV/0!"},{"$f":"+D13/D$15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[12.159999999999998,"Other Cost Component of Total Wholesale Power Cost  (Automatically calculated)",{"$error":"#DIV/0!"},{"$f":"+D14/D$15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[12.169999999999998,"Total Wholesale Power Cost  (Automatically calculated)",{"$error":"#DIV/0!"},{"$f":"+D15/D$15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"#13 Price Cost Markup","index":13,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,2,0,6],[10,2,10,6]]}
[null,"Balancing Authority Area Respondent Name:",{"$f":"+'#1 Reserve Margins'!C1","v":"Example:  PJM, ISO-NE, etc."}]
[]
["Group 2: Metric #13 Price Cost Markup "]
[]
[null,"t = hours in reporting period (e.g., 8,784 hours * 12 five-minute intervals in a leap year\n      or 8,760 hours * 12 five-minute intervalsin other years)\nPi = Real-Time price-based offer in hour i\nCi = Real-Time cost-based offer in hour i\nPC = Price Cost Markup\n\n\n\n"]
[null,"Calculate two supply curves for each five-minute interval of the real-time market in the reporting period. The first curve (price curve) is based on the offer used in the price formation for that interval.  The second curve (cost curve) is based on the default bid of the unit for that interval.  For each curve, starting at the lowest cost offers, aggregate the MWs of the curves until the aggregated MW value equals the real-time demand for that interval.  The intersection of the demand curve with the supply curves provides two prices."]
[null,{"$f":"+'#1 Reserve Margins'!B4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!C4","v":2014},{"$f":"+'#1 Reserve Margins'!D4","v":2015},{"$f":"+'#1 Reserve Margins'!E4","v":2016},{"$f":"+'#1 Reserve Margins'!F4","v":2017},{"$f":"+'#1 Reserve Margins'!G4","v":2018}]
[13,"Average of the Price Cost Margin ($).   Report the average price cost markup of all of the hours.",0,0,0,0,0]
[{"$f":"+A8+0.01","v":13.01},"Top Ten Percent of the Price Cost Margin ($).   Report the average price cost markup of the highest price 10 percent of the hours.",0,0,0,0,0]
[{"$f":"+A9+0.01","v":13.02},"Bottom Ten Percent of the Price Cost Margin ($).   Report the average price cost markup of the lowest price 10 percent of the hours.",0,0,0,0,0]
[13.03,"Explanatory Text.  Explain any variations from this formula, e.g., the RTO/ISO used the difference of Pi and Ci for the marginal resource for each five minute interval.   ","Text"]
[]
[]
[null,"Note: This calculation does not account for physical restrictions on units, transmission constrains or ramping restrictions.  "]

{"sheet":"#14 Fuel Adj Price","index":14,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,2,0,6],[13,2,13,6]]}
[null,"Balancing Authority Area Respondent Name:",{"$f":"+'#1 Reserve Margins'!C1","v":"Example:  PJM, ISO-NE, etc."}]
[]
["Group 2: Metric #14 Fuel-Adjusted Wholesale Energy Price"]
[]
[]
[null,{"$f":"+'#1 Reserve Margins'!B4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!C4","v":2014},{"$f":"+'#1 Reserve Margins'!D4","v":2015},{"$f":"+'#1 Reserve Margins'!E4","v":2016},{"$f":"+'#1 Reserve Margins'!F4","v":2017},{"$f":"+'#1 Reserve Margins'!G4","v":2018}]
[14,"System-wide LMP ($).  Provide the average real-time LMP for the reporting period. ",0,0,0,0,0]
[{"$f":"+A7+0.01","v":14.01},"Reference Year (YYYY).   Report the reference year for the fuel price adjustment.",0,0,0,0,0]
[{"$f":"+A8+0.01","v":14.02},"Fraction of Hours that Natural Gas was the Marginal Fuel.  For purposes of this metric, estimate the fraction of hours in the reporting period that natural gas was the marginal fuel.  Report the fraction with two decimal places.",0,0,0,0,0]
[14.03,"Fraction of Hours that Coal was the Marginal Fuel.  For purposes of this metric, estimate the fraction of hours in the reporting period that coal was the marginal fuel.  Report the fraction with two decimal places. ",0,0,0,0,0]
[14.04,"Fuel Adjustment Factor Natural Gas.  Calculate the natural gas price adjustment for each reporting period compared to the Reference Year.  Report the fraction with two decimal place.",0,0,0,0,0]
[14.049999999999999,"Fuel Adjustment Factor Coal.  Calculate the coal price adjustment for each reporting period compared to the Reference Year.  Report the fraction with two decimal places.    ",0,0,0,0,0]
[14.059999999999999,"Fuel-Adjusted Wholesale Price ($).  The spreadsheet will automatically calculate the adjustment based on the equation above.  (Automatically calculated)",{"$f":"+C7*((C9*C11)+(C10*C12)+(1-C9-C10))","v":0},{"$f":"+D7*((D9*D11)+(D10*D12)+(1-D9-D10))","v":0},{"$f":"+E7*((E9*E11)+(E10*E12)+(1-E9-E10))","v":0},0,0]
[14.069999999999999,"Explanatory Text.  Explain any variations from this formula, e.g., unable to estimate the fraction of hours that a fuel was marginal.  ","Text"]

{"sheet":"#15 Price Convergence","index":15,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,2,0,6],[15,2,15,6]]}
[null,"Balancing Authority Area Respondent Name:",{"$f":"+'#1 Reserve Margins'!C1","v":"Example:  PJM, ISO-NE, etc."}]
[]
[]
[]
[]
["Group 2: Metric #15  Energy Market Price Convergence"]
["Compute this metric four different ways using these two values, the load-weighted average of real time prices and the load-weighted average of day-ahead prices. "]
[]
[" Equation 1:   "," "," Equation 3: "]
[" Equation 2:  ",null," Equation 4:  "]
[null,"Reporting Period",{"$f":"+'#1 Reserve Margins'!C4","v":2014},{"$f":"+'#1 Reserve Margins'!D$4","v":2015},{"$f":"+'#1 Reserve Margins'!E$4","v":2016},{"$f":"+'#1 Reserve Margins'!F$4","v":2017},{"$f":"+'#1 Reserve Margins'!G$4","v":2018}]
[15,"Equation 1 ($/MWh).   Load weighted average of price differences between DA and RT market. See Equation 1.",0,0,0,0,0]
[{"$f":"+A12+0.01","v":15.01},"Equation 2 ($/MWh). Load weighted average of absolute value of price differences. See Equation 2.",0,0,0,0,0]
[{"$f":"+A13+0.01","v":15.02},"Equation 3 ($/MWh).  Load weighted average of quotient of price difference and DA price.  See Equation 3.",0,0,0,0,0]
[15.03,"Equation 4 ($/MWh).  Load weighted average of absolute value of quotient of price difference and DA price.  See Equation 4.",0,0,0,0,0]
[15.04,"Explanatory Text.  Provide any additional information  if necessary.","Text"]
["Zonal Convergence (optional)"]
[null,"Reporting Period",{"$f":"+'#1 Reserve Margins'!C$4","v":2014},{"$f":"+'#1 Reserve Margins'!D$4","v":2015},{"$f":"+'#1 Reserve Margins'!E$4","v":2016},{"$f":"+'#1 Reserve Margins'!F$4","v":2017},{"$f":"+'#1 Reserve Margins'!G$4","v":2018}]
[15.05,"Zone Name"]
[{"$f":"+A19+0.01","v":15.06},"Equation 1 ($/MWh).   Load weighted average of price differences between DA and RT market. See Equation 1.",0,0,0,0,0]
[{"$f":"+A20+0.01","v":15.07},"Equation 2 ($/MWh). Load weighted average of absolute value of price differences. See Equation 2.",0,0,0,0,0]
[{"$f":"+A21+0.01","v":15.08},"Equation 3 ($/MWh).  Load weighted average of quotient of price difference and DA price.",0,0,0,0,0]
[15.09,"Equation 4 ($/MWh).  Load weighted average of absolute value of quotient of price difference and DA price.",0,0,0,0,0]

{"sheet":"#16 Congestion Management","index":16,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,2,0,6],[11,2,11,6]]}
[null,"Balancing Authority Area Respondent Name:",{"$f":"+'#1 Reserve Margins'!C1","v":"Example:  PJM, ISO-NE, etc."}]
[]
["Group 2: Metric #16 Congestion Management"]
[null,{"$f":"+'#1 Reserve Margins'!B4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!C4","v":2014},{"$f":"+'#1 Reserve Margins'!D4","v":2015},{"$f":"+'#1 Reserve Margins'!E4","v":2016},{"$f":"+'#1 Reserve Margins'!F4","v":2017},{"$f":"+'#1 Reserve Margins'!G4","v":2018}]
[16,"Total Day-Ahead Congestion Charges (RTO/ISO wide) ($).  For each reporting period, enter the sum of (Day-Ahead MWh*CLMP) where Day-Ahead MWh consists of MWh settled at day-ahead market energy prices (which includes financial schedules and virtual transactions) and CLMP is the congestion component of the day-ahead energy market price.",0,0,0,0,0]
[16.010000000000002,"Net Payments to FTR Holders (RTO/ISO wide) ($).  Enter the sum of reporting period congestion charges distributed to holders of Financial Transmission Rights (FTRs) or their equivalent such as Transmission Congestion Rights (TCR) or Congestion Revenue Rights (CRRs), net of revenue received from counterflow FTR holders.",0,0,0,0,0]
[16.02,"Net Energy for Load (RTO/ISO wide) (MWh).  (Automatically copied from Metric 12)",{"$f":"'#12 Wholesale Power'!C6","v":0},{"$f":"'#12 Wholesale Power'!D6","v":0},{"$f":"'#12 Wholesale Power'!E6","v":0},{"$f":"'#12 Wholesale Power'!F6","v":0},{"$f":"'#12 Wholesale Power'!G6","v":0}]
[16.03,"Congestion Charges per MWh of Load Served (RTO/ISO wide) ($/MWh).  The worksheet will calculate the ratio of the Total Day-Ahead Congestion Charges divided by the Net Energy for Load.  (Automatically calculated)",{"$f":"C5/C7","v":{"$error":"#DIV/0!"}},{"$f":"D5/D7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[16.04,"Net Payments to FTR Holders as a percent of Total Congestion Charges (RTO/ISO wide) (%).  The worksheet will calculate the ratio of Net Payments to FTR Holders divided by the Total Day-Ahead Congestion Charges.  (Automatically calculated)",{"$f":"C6/C5","v":{"$error":"#DIV/0!"}},{"$f":"D6/D5","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[16.05,"Net Payments to Load Serving Entities (LSEs) through FTRs, ARRs, etc. ($). Total revenue received by LSEs through financial instruments such as auction revenue rights and financial transmission rights, net of charges paid for counterflow ARRs or FTRs. If an ARR is \"self-scheduled\" (i.e. converted) into an FTR, please report only the revenue (or charge) received from the FTR.",0,0,0,0,0]
[{"$f":"A10+0.01","v":16.060000000000002},"Net Payments to Load Serving Entities (LSEs) as a percent of Total Congestion Charges (%) The worksheet will calculate the percentage of revenue received by LSEs through FTRs and ARRs as a percent of Total Day-Ahead Congestion Charges for the reporting period expressed as a percent. (Automatically Calculated)",{"$f":"C10/C5","v":{"$error":"#DIV/0!"}},{"$f":"D10/D5","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["\n16.07","Explanatory Text.  Provide any additional information if necessary.   "]

{"sheet":"#17 Admin Cost","index":17,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,2,0,6],[9,2,9,6]]}
[null,"Balancing Authority Area Respondent Name:",{"$f":"+'#1 Reserve Margins'!C1","v":"Example:  PJM, ISO-NE, etc."}]
[]
["Group 2: Metric #17 Administrative Costs"]
[null,{"$f":"+'#1 Reserve Margins'!B4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!C4","v":2014},{"$f":"+'#1 Reserve Margins'!D4","v":2015},{"$f":"+'#1 Reserve Margins'!E4","v":2016},{"$f":"+'#1 Reserve Margins'!F4","v":2017},{"$f":"+'#1 Reserve Margins'!G4","v":2018}]
[17,"Administrative Costs ($).  Sum the administrative costs (both capital and non-capital) billed by the RTO/ISO for each reporting period.   RTOs/ISOs with capacity markets should see the User Guide for instructions.  ",0,0,0,0,0]
[{"$f":"+A5+0.01","v":17.010000000000002},"Administrative Costs (FERC Form No. 1) ($).  Report the TOTAL Administrative & General Expenses (row 197), page 323 from the last quarter of the filing for the reporting period.  RTOs/ISOs with capacity markets should see the User Guide for instructions. ",0,0,0,0,0]
[{"$f":"+A6+0.01","v":17.020000000000003},"Net Energy for Load (MWh).   (Automatically copied from Metric 12)",{"$f":"+'#12 Wholesale Power'!C6","v":0},{"$f":"+'#12 Wholesale Power'!D6","v":0},{"$f":"+'#12 Wholesale Power'!E6","v":0},{"$f":"+'#12 Wholesale Power'!F6","v":0},{"$f":"+'#12 Wholesale Power'!G6","v":0}]
[17.030000000000005,"Administrative Costs per MWh of Load Served (%).  The worksheet will calculate Administrative Costs divided by the Net Energy for Load for each reporting period .  (Automatically calculated)",{"$f":"+C5/C7","v":{"$error":"#DIV/0!"}},{"$f":"+D5/D7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[17.040000000000006,"Administrative Costs (FERC Form No. 1) per MWh of Load Served (%).  The worksheet will calculate Administrative Costs (FERC Form No. 1) divided by the Net Energy for Load for each reporting  period.  (Automatically calculated)",{"$f":"+C6/C7","v":{"$error":"#DIV/0!"}},{"$f":"+D6/D7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[17.050000000000008,"Explanatory Text.  Describe any significant changes to administrative charges that influence the Administrative Costs reported above, such as prior-year collection true-ups, expansion of RTO/ISO footprint, etc.","text"]

{"sheet":"#18 Net Revenues","index":18,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,2,0,6],[14,2,14,6]]}
[null,"Balancing Authority Area Respondent Name:",{"$f":"+'#1 Reserve Margins'!C1","v":"Example:  PJM, ISO-NE, etc."}]
[]
["Group 2: Metric #18 New Entrant Net Revenues"]
[null,{"$f":"+'#1 Reserve Margins'!B4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!C4","v":2014},{"$f":"+'#1 Reserve Margins'!D4","v":2015},{"$f":"+'#1 Reserve Margins'!E4","v":2016},{"$f":"+'#1 Reserve Margins'!F4","v":2017},{"$f":"+'#1 Reserve Margins'!G4","v":2018}]
["Net Revenue for New Entrant (Combustion Turbine)"]
[18,"Prototypical New Entrant Variable Production Cost (Combustion Turbine) ($).  Enter the new entrant's estimated variable production cost for a combustion turbine for the reporting period.",0,0,0,0,0]
[{"$f":"+A6+0.01","v":18.010000000000002},"Prototypical New Entrant Energy Revenues Received (Combustion Turbine) ($).  Enter the new entrant's estimated revenue received from RTO/ISO energy and ancillary services (as defined in the RTO/ISO Tariff) for a combustion turbine for the given reporting period.  ",0,0,0,0,0]
[{"$f":"+A7+0.01","v":18.020000000000003},"Size in MW of Prototypical New Entrant (Combustion Turbine) (MW).  Enter the nameplate capacity of the unit used in the calculation. ",0,0,0,0,0]
[18.030000000000005,"Net Revenue for New Entrant (Combustion Turbine) ($).  The difference between the Prototypical New Entrant Energy Revenues Received less the Prototypical New Entrant's Variable Production Cost.  (Automatically calculated)",{"$f":"+C7-C6","v":0},{"$f":"+D7-D6","v":0},{"$f":"+E7-E6","v":0},{"$f":"+F7-F6","v":0},{"$f":"+G7-G6","v":0}]
["Net Revenue for New Entrant (Combined Cycle)"]
[{"$f":"+A9+0.01","v":18.040000000000006},"Prototypical New Entrant Variable Production Cost (Combined Cycle) ($).  Enter the new entrant's estimated variable production cost for a combustion cycle for the reporting period.",0,0,0,0,0]
[{"$f":"+A11+0.01","v":18.050000000000008},"Prototypical New Entrant Energy Revenues Received (Combined Cycle) ($).  Enter the new entrant's estimated revenue received from RTO/ISO energy and ancillary services (as defined in the RTO/ISO Tariff) for a combined cycle for the given reporting period. ",0,0,0,0,0]
[{"$f":"+A12+0.01","v":18.060000000000009},"Size in MW of Prototypical New Entrant (Combined Cycle) (MW).  Enter the nameplate capacity of the unit used in the calculation.  ",0,0,0,0,0]
[{"$f":"+A13+0.01","v":18.070000000000011},"Net Revenue for New Entrant (Combined Cycle) ($).  The difference between the Prototypical New Entrant Energy Revenues Received less the Prototypical New Entrant's Variable Production Cost.  (Automatically calculated)",{"$f":"+C12-C11","v":0},{"$f":"+D12-D11","v":0},{"$f":"+E12-E11","v":0},{"$f":"+F12-F11","v":0},{"$f":"+G12-G11","v":0}]
[{"$f":"+A14+0.01","v":18.080000000000013},"Explanatory Text.  Please provide a description on how the cost and revenue estimate were derived for a hypothetical new entrant, including the assumed location (i.e., high cost zone, etc.)","Text"]

{"sheet":"#19 Avail 825 Shortage","index":19,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,2,0,6],[14,2,14,6]]}
[null,"Balancing Authority Area Respondent Name:",{"$f":"+'#1 Reserve Margins'!C1","v":"Example:  PJM, ISO-NE, etc."}]
[]
["Group 2: Metric #19 Order No. 825 Shortage Intervals and Reserve Price Impacts"]
[null,"s = a shortage event \nTs = duration of event s\ni = 5-minute interval before shortage in reporting period \nk = 5-minute interval during shortage in reporting period\nMW = reserves for 5-minute interval\nRMCP = Reserve Market Clearing Price for highest quality product (i.e., spinning reserve) for 5-minute interval\n"]
[null,{"$f":"+'#1 Reserve Margins'!$B$4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!$C$4","v":2014},{"$f":"+'#1 Reserve Margins'!$D$4","v":2015},{"$f":"+'#1 Reserve Margins'!$E$4","v":2016},{"$f":"+'#1 Reserve Margins'!$F$4","v":2017},{"$f":"+'#1 Reserve Margins'!$G$4","v":2018}]
[19,"Number of Shortage Events.   Total number of distinct shortage events in reporting period.  An event is a contiguous set of shortage intervals defined by Order No. 825  that occurred in the reporting period.  Report an integer.",0,0,0,0,0]
[{"$f":"+A6+0.01","v":19.010000000000002},"Total Duration of Shortage Events.  Total minutes/hours where shortage occurred during the reporting period.  Report an integer.",0,0,0,0,0]
[19.020000000000003,"Average Duration of Shortages.  The worksheet will calculate the ratio of the Total Duration of Shortage Events divided by the Number of Shortage Events.   (Automatically calculated)",{"$f":"+C7/C6","v":{"$error":"#DIV/0!"}},{"$f":"+D7/D6","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"+A8+0.01","v":19.030000000000005},"Total Size of Shortage Events.  Total MW shortage during the reporting period.  This is a multi-step calculation.  First, for each shortage event calculate the difference between the average MW  available during the shortage and the average of the MWs required of the highest quality reserve product (i.e., spinning reserve) in the three intervals before the shortage began.  Second, for each event create the product of this difference and the event duration and sum these for the reporting period.  Report an integer.",0,0,0,0,0]
[19.040000000000006,"Average Size of the Shortage Events.  The average size of all of the shortage events in the reporting period.  Divide Total Size of Shortage Events by the Total Duration of Shortage Events.  (Automatically Calculated)   \n",{"$f":"+C9/C7","v":{"$error":"#DIV/0!"}},{"$f":"+D9/D7","v":{"$error":"#DIV/0!"}},{"$f":"+E9/E7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[19.050000000000008,"Total Price Differential of the Shortage Events.  The price differential of the shortage event (the increase between 5-minute intervals) in the reporting period.  This is a multi-step calculation.  First, for each shortage event calculate the difference between the reserve market clearing price of the highest quality reserve product (i.e., spinning reserve) in the three intervals before the shortage began and the average price of the reserve product in the shortage, and multiply this difference by the duration of the shortage. Sum for all events for the reporting period.  Report in $/MWh."]
[{"$f":"+A11+0.01","v":19.060000000000009},"Average Price Differential of the Shortage Events.  The average size of the price differential of the shortage events in the reporting period.  Divide Total Price Differential of the Shortage Events by the Total Duration of Shortage Events.  (Automatically Calculated)",{"$f":"+C11/C7","v":{"$error":"#DIV/0!"}},{"$f":"+D11/D7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"+A12+0.01","v":19.070000000000011},"Total Price Impact of the Shortage Events.  The total price impact of the shortage events in the reporting period.  For each event where shortage pricing occurred, multiply the duration of the shortage event by the product of the average size of each shortage event and the price differential of each shortage event. "]
[{"$f":"+A13+0.01","v":19.080000000000013},"Average Price Impact of the Shortage Events.  The average price impact of the shortage events in the reporting period.  Divide the Total Price Impact of the Shortage Events by the Total Duration of Shortage Events.  (Automatically Calculated)",{"$f":"+C13/C7","v":{"$error":"#DIV/0!"}},{"$f":"+D13/D7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"+A14+0.01","v":19.090000000000014},"Explanatory Text (if necessary).  Report any relevant information about this metric that is not captured above e.g. including the product the price change is associated with, improvements to the methodology, etc.","text"]

{"sheet":"#20 Net CONE Comparison","index":20,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,2,0,6],[12,2,12,6]]}
[null,"Balancing Authority Area Respondent Name:",{"$f":"+'#1 Reserve Margins'!C1","v":"Example:  PJM, ISO-NE, etc."}]
[]
["Group 3: Metric #20 Net Cost of New Entry (Net CONE) value"]
[]
[]
[]
[null,{"$f":"+'#1 Reserve Margins'!B4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!C$4","v":2014},{"$f":"+'#1 Reserve Margins'!D$4","v":2015},{"$f":"+'#1 Reserve Margins'!E$4","v":2016},{"$f":"+'#1 Reserve Margins'!$F$4","v":2017},{"$f":"+'#1 Reserve Margins'!$G$4","v":2018}]
["Net Cost of New Entry"]
[20,"Capacity Zone Name"," "," "," "," "," "]
[{"$f":"A9+0.01","v":20.010000000000002},"Net CONE value Used at the Most Recent Update ($/MW-Year).  Report the estimated Net CONE value used in the most recent update to the Net CONE value for each reporting period. ",0,0,0,0,0]
[{"$f":"+A10+0.01","v":20.020000000000003},"Date of the Most Recent Net CONE Update (MM/YYYY).  Enter the date in MM/YYYY format.","00/0000","00/0000","00/0000","00/0000","00/0000"]
[{"$f":"+A11+0.01","v":20.030000000000005},"Actual Net CONE value in Reporting Period ($/MW-Year).  Rerun the estimate for each historical reporting period using the actual value of local marginal prices (LMP) realized in that  reporting period (e.g., if the estimate for 2014 was produced in 2011 for the initial auction, use the 2014 LMPs and re-run the Net CONE for 2014).  ",0,0,0,0,0]
[{"$f":"+A12+0.01","v":20.040000000000006},"Explanatory Text.  Provide any additional information if necessary.   ","Text"]

{"sheet":"#21 Resource Deliverability","index":21,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,2,0,6],[12,2,12,6]]}
[null,"Balancing Authority Area Respondent Name:",{"$f":"+'#1 Reserve Margins'!C1","v":"Example:  PJM, ISO-NE, etc."}]
[]
["Group 3: Metric #21 Resource Deliverability"]
[]
[]
[]
[null,{"$f":"+'#1 Reserve Margins'!$B$4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!$C$4","v":2014},{"$f":"+'#1 Reserve Margins'!$D$4","v":2015},{"$f":"+'#1 Reserve Margins'!$E$4","v":2016},{"$f":"+'#1 Reserve Margins'!$F$4","v":2017},{"$f":"+'#1 Reserve Margins'!$G$4","v":2018}]
["Resource  Deliverability - Maximum Importable External Capacity into a Capacity Zone"]
[21,"Capacity Zone Name"," "," "," "," "," "]
[{"$f":"+A9+0.01","v":21.01},"Import Limitation into a zone (MW).  The amount of external capacity that can be imported into this zone for purposes of the capacity auction.  Determined at the time of the initial auction. Report for all capacity zones that are separately modeled.  ",0,0,0,0,0]
[{"$f":"+A10+0.01","v":21.020000000000003},"Locational Generation Requirement (or equivalent) in the zone (MW).  The amount of capacity located inside the zone necessary (or is it available) to meet the estimated demand in the zone (calculated at the time of the initial auction).  Report for all capacity zones that are separately modeled.    ",0,0,0,0,0]
[{"$f":"+A11+0.01","v":21.030000000000005},"Locational Generation Procured in the zone (MW).  The amount of capacity that was actually procured for the zone in the auction.  An RTO/ISO with a downward sloping demand curve may actually procure more capacity than the Locational Requirement.  Report the actual amount of capacity procured in the auction for this zone.   ",0,0,0,0,0]
[{"$f":"+A12+0.01","v":21.040000000000006},"Explanatory Text.  Report any relevant information about this zone during the reporting period (e.g., changes in boundaries, significant changes in load).  ","text"]

{"sheet":"#22 New Capacity (Entry)","index":22,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,2,0,6],[11,2,11,6]]}
[null,"Balancing Authority Area Respondent Name:",{"$f":"+'#1 Reserve Margins'!C1","v":"Example:  PJM, ISO-NE, etc."}]
[]
["Group 3: Metric #22 New Capacity (Entry)"]
[]
[]
[]
[null,{"$f":"+'#1 Reserve Margins'!$B$4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!$C$4","v":2014},{"$f":"+'#1 Reserve Margins'!$D$4","v":2015},{"$f":"+'#1 Reserve Margins'!$E$4","v":2016},{"$f":"+'#1 Reserve Margins'!$F$4","v":2017},{"$f":"+'#1 Reserve Margins'!$G$4","v":2018}]
["New Capacity Added"]
[22,"Capacity Zone Name"]
[{"$f":"+A9+0.01","v":22.01},"Number of Generation Units Added (Integer).   Total number of generation units added during the reporting period.  ",0,0,0,0,0]
[{"$f":"+A10+0.01","v":22.020000000000003},"Increase in Capacity with Supply Obligations (MW).  Amount of generating capacity that has cleared in an auction, that now has an obligation to offer into the capacity market during the reporting period.  Do not report existing capacity that has been uprated. ",0,0,0,0,0]
[22.030000000000005,"Explanatory Text.  Provide any additional information if necessary.   ","Text"]

{"sheet":"#23 Capacity Retire (Exit) ","index":23,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,2,0,6],[11,2,11,6]]}
[null,"Balancing Authority Area Respondent Name:",{"$f":"+'#1 Reserve Margins'!C1","v":"Example:  PJM, ISO-NE, etc."}]
[]
["Group 3: Metric #23 Capacity Retirement (Exit) "]
[]
[]
[]
[null,{"$f":"+'#1 Reserve Margins'!$B$4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!$C$4","v":2014},{"$f":"+'#1 Reserve Margins'!$D$4","v":2015},{"$f":"+'#1 Reserve Margins'!$E$4","v":2016},{"$f":"+'#1 Reserve Margins'!$F$4","v":2017},{"$f":"+'#1 Reserve Margins'!$G$4","v":2018}]
["Capacity Retirement (Exit) "]
[23,"Capacity Zone Name"]
[{"$f":"+A9+0.01","v":23.01},"Number of Generation Units Taken out of Service (Integer).   Total number of generation units taken out of service during the reporting period.  ",0,0,0,0,0]
[{"$f":"+A10+0.01","v":23.020000000000003},"Decrease in Capacity with Supply Obligations (MW).  Amount of generating capacity that no longer has an obligation to offer into the capacity market during the reporting period.  Do not report generation capacity that has been de-rated. ",0,0,0,0,0]
[23.030000000000005,"Explanatory Text.  Provide any additional information if necessary.   ","Text"]

{"sheet":"#24 Forecasted Demand","index":24,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[3,1,3,6],[0,2,0,6],[11,2,11,6]]}
[null,"Balancing Authority Area Respondent Name:",{"$f":"+'#1 Reserve Margins'!C1","v":"Example:  PJM, ISO-NE, etc."}]
[]
["Group 3: Metric #24 Forecasted Demand "]
[]
[]
[]
[null,{"$f":"+'#1 Reserve Margins'!$B$4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!$C$4","v":2014},{"$f":"+'#1 Reserve Margins'!$D$4","v":2015},{"$f":"+'#1 Reserve Margins'!$E$4","v":2016},{"$f":"+'#1 Reserve Margins'!$F$4","v":2017},{"$f":"+'#1 Reserve Margins'!$G$4","v":2018}]
["Forecasted Demand "]
[24,"Capacity Zone Name"]
[{"$f":"+A9+0.01","v":24.01},"Demand in the Zone (time of initial auction) (MW).   Total estimated coincident peak demand integrated over the hour needed for this zone at the time of the initial auction for the reporting period.  Note that this load value is not weather-normalized and is the peak value assigned to that zone from the estimated region peak at the time of the initial auction.",0,0,0,0,0]
[{"$f":"+A10+0.01","v":24.020000000000003},"Peak Demand Realized in the Zone (during actual reporting period) (MW).   Peak demand (not weather normalized) realized in this zone during the reporting period. ",0,0,0,0,0]
[24.030000000000005,"Explanatory Text.  Provide any additional information if necessary.   ","Text"]

{"sheet":"#25 Capacity Procure","index":25,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[3,1,3,6],[4,1,4,6],[0,2,0,6],[13,2,13,6]]}
[null,"Balancing Authority Area Respondent Name:",{"$f":"+'#1 Reserve Margins'!C1","v":"Example:  PJM, ISO-NE, etc."}]
[]
["Group 3: Metric #25 Capacity Market Procurement and Prices"]
[]
[]
[]
[null,{"$f":"+'#1 Reserve Margins'!$B$4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!$C$4","v":2014},{"$f":"+'#1 Reserve Margins'!$D$4","v":2015},{"$f":"+'#1 Reserve Margins'!$E$4","v":2016},{"$f":"+'#1 Reserve Margins'!$F$4","v":2017},{"$f":"+'#1 Reserve Margins'!$G$4","v":2018}]
["Capacity Market Procurement & Prices (RTO-wide)"]
[25,"Date That the Capacity Auction took Place (MM-YYYY).  Enter the date that the initial capacity auction took place. ","00-0000","00-0000","00-0000","00-0000","00-0000"]
[{"$f":"+A9+0.01","v":25.01},"Start Date of the Reporting Period of capacity auction (MM-YYYY).   ","00-0000","00-0000","00-0000","00-0000","00-0000"]
[{"$f":"+A10+0.01","v":25.020000000000003},"Total Capacity Offered into the Auction (RTO-wide) (MW).  Enter the total capacity that offered into the entire RTO for the relevant reporting period. ",0,0,0,0,0]
[25.030000000000005,"Total Capacity Cleared (RTO-wide) (MW).  Enter the total capacity the cleared for the entire RTO during the relevant reporting period. ",0,0,0,0,0]
[25.040000000000006,"Capacity Market Clearing Price (RTO-wide) ($/MW-day).  Enter the RTO-wide clearing price for the relevant reporting.",0,0,0,0,0]
[25.050000000000008,"Explanatory Text.  Provide any additional information if necessary.   ","Text"]
["Capacity Market Procurement & Prices (Zonal)",null," "," "," "," "," "]
[null,{"$f":"+'#1 Reserve Margins'!$B$4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!$C$4","v":2014},{"$f":"+'#1 Reserve Margins'!$D$4","v":2015},{"$f":"+'#1 Reserve Margins'!$E$4","v":2016},{"$f":"+'#1 Reserve Margins'!$F$4","v":2017},{"$f":"+'#1 Reserve Margins'!$G$4","v":2018}]
[25.06,"Capacity Zone Name"]
[25.07,"Total Capacity Offered into the Auction (Zonal) (MW).  Enter the total capacity that offered into each zone where price separation occurred for the relevant reporting period.  ",0,0,0,0,0]
[25.080000000000002,"Total Capacity Cleared (Zonal) (MW).  Enter the total capacity that cleared in each zone where price separation occurred during the relevant reporting period.",0,0,0,0,0]
[25.090000000000003,"Capacity Market Clearing Prices (Zonal) ($/MW-day).  Enter the clearing price for each zone where price separation occurred for the relevant reporting period.",0,0,0,0,0]
[25.100000000000005,"Amount of Capacity in this Zone in Bilateral Contracts, if Known (MW).  Total capacity of bilateral contracts in this zone during the relevant period.",0,0,0,0,0]

{"sheet":"#26 Capacity Obligation","index":26,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[3,1,3,6],[0,2,0,6],[11,2,11,6]]}
[null,"Balancing Authority Area Respondent Name:",{"$f":"+'#1 Reserve Margins'!C1","v":"Example:  PJM, ISO-NE, etc."}]
[]
["Group 3: Metric #26 Capacity Obligations and Performance Assessment Events"]
[]
[]
[]
[null,{"$f":"+'#1 Reserve Margins'!$B$4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!$C$4","v":2014},{"$f":"+'#1 Reserve Margins'!$D$4","v":2015},{"$f":"+'#1 Reserve Margins'!$E$4","v":2016},{"$f":"+'#1 Reserve Margins'!$F$4","v":2017},{"$f":"+'#1 Reserve Margins'!$G$4","v":2018}]
["Capacity Obligations (RTO-wide)"]
[26,"Total Capacity with Capacity Obligation (RTO-wide) (MW).  Enter the cleared capacity eligible for bonus payments or subject to penalties for the entire RTO during the reporting period. "]
[{"$f":"+A9+0.01","v":26.01},"Total Number of Performance Assessment Events (RTO-wide) (Integer).",0,0,0,0,0]
[{"$f":"+A10+0.01","v":26.020000000000003},"Total Duration of Performance Assessment Events (RTO-wide) (Hours).",0,0,0,0,0]
[26.030000000000005,"Explanatory Text.  Provide any additional information if necessary.   ","Text"]
["Capacity Obligations (Zonal)"]
[null,{"$f":"+'#1 Reserve Margins'!$B$4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!$C$4","v":2014},{"$f":"+'#1 Reserve Margins'!$D$4","v":2015},{"$f":"+'#1 Reserve Margins'!$E$4","v":2016},{"$f":"+'#1 Reserve Margins'!$F$4","v":2017},{"$f":"+'#1 Reserve Margins'!$G$4","v":2018}]
[26.04,"Capacity Zone Name"]
[26.05,"Total Capacity with Capacity Obligations (Zonal) (MW).  Enter the cleared capacity eligible for bonus payments or subject to penalties for the zone during the reporting period.  ",0,0,0,0,0]
[26.060000000000002,"Total Number of Performance Assessment Events (Zonal) (Integer).",0,0,0,0,0]
[26.070000000000004,"Total Duration of Performance Assessment Events (Zonal) (Hours).",0,0,0,0,0]

{"sheet":"#27 Over Perform","index":27,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,1,3,6],[0,2,0,6],[11,2,11,6]]}
[null,"Balancing Authority Area Respondent Name:",{"$f":"+'#1 Reserve Margins'!C1","v":"Example:  PJM, ISO-NE, etc."}]
[]
["Group 3: Metric #27 Capacity Over-Performance "]
[]
[]
[]
["Equation 1."]
[null,{"$f":"+'#1 Reserve Margins'!$B$4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!$C$4","v":2014},{"$f":"+'#1 Reserve Margins'!$D$4","v":2015},{"$f":"+'#1 Reserve Margins'!$E$4","v":2016},{"$f":"+'#1 Reserve Margins'!$F$4","v":2017},{"$f":"+'#1 Reserve Margins'!$G$4","v":2018}]
["Capacity Eligible for Bonus Payments for Over-Performance (RTO-wide)"]
[27,"Total Number of Units That Over-Performed During Assessment Events (RTO-wide) (Integer).",0,0,0,0,0]
[{"$f":"+A10+0.01","v":27.01},"Weighted Average Capacity that Over-Performed During Assessment Events (RTO-wide) (MW).   See Equation 1. ",0,0,0,0,0]
[{"$f":"+A11+0.01","v":27.020000000000003},"Explanatory Text.  Provide any additional information if necessary.   ","Text"]
["Capacity Eligible for Bonus Payments for Over-Performance (Zonal)"]
[null,{"$f":"+'#1 Reserve Margins'!$B$4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!$C$4","v":2014},{"$f":"+'#1 Reserve Margins'!$D$4","v":2015},{"$f":"+'#1 Reserve Margins'!$E$4","v":2016},{"$f":"+'#1 Reserve Margins'!$F$4","v":2017},{"$f":"+'#1 Reserve Margins'!$G$4","v":2018}]
[27.03,"Capacity Zone Name"]
[{"$f":"+A15+0.01","v":27.040000000000003},"Total Number of Units That Over-Performed During Assessment Events (Zonal) (Integer).",0,0,0,0,0]
[27.050000000000004,"Weighted Average Capacity that Over-Performed During Assessment Events (Zonal) (MW).   See Equation 1.",0,0,0,0,0]

{"sheet":"#28 Under Perform","index":28,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,1,3,6],[0,2,0,6],[11,2,11,6]]}
[null,"Balancing Authority Area Respondent Name:",{"$f":"+'#1 Reserve Margins'!C1","v":"Example:  PJM, ISO-NE, etc."}]
[]
["Group 3: Metric #28 Capacity Under-Performance "]
[]
[]
[]
["Equation 1."]
[null,{"$f":"+'#1 Reserve Margins'!$B$4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!$C$4","v":2014},{"$f":"+'#1 Reserve Margins'!$D$4","v":2015},{"$f":"+'#1 Reserve Margins'!$E$4","v":2016},{"$f":"+'#1 Reserve Margins'!$F$4","v":2017},{"$f":"+'#1 Reserve Margins'!$G$4","v":2018}]
["Capacity Facing Penalty Payments for Under-Performance (RTO-wide)"]
[28,"Total Number of Units That Under-Performed During Assessment Events (RTO-wide) (Integer).",0,0,0,0,0]
[{"$f":"+A10+0.01","v":28.01},"Weighted Average Capacity that Under-Performed During Assessment Events (RTO-wide) (MW).   See Equation 1.  "]
[{"$f":"+A11+0.01","v":28.020000000000003},"Explanatory Text.  Provide any additional information if necessary.   ","Text"]
["Capacity Facing Penalty Payments for Under-Performance (Zonal)"]
[null,{"$f":"+'#1 Reserve Margins'!$B$4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!$C$4","v":2014},{"$f":"+'#1 Reserve Margins'!$D$4","v":2015},{"$f":"+'#1 Reserve Margins'!$E$4","v":2016},{"$f":"+'#1 Reserve Margins'!$F$4","v":2017},{"$f":"+'#1 Reserve Margins'!$G$4","v":2018}]
[28.03,"Capacity Zone Name"]
[{"$f":"+A15+0.01","v":28.040000000000003},"Total Number of Units That Under-Performed During Assessment Events (RTO-wide) (Integer).",0,0,0,0,0]
[28.050000000000004,"Weighted Average Capacity that Under-Performed During Assessment Events (RTO-wide) (MW).   See Equation 1.",0,0,0,0,0]

{"sheet":"#29 Total Bonus","index":29,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,1,3,6],[0,2,0,6],[13,2,13,6]]}
[null,"Balancing Authority Area Respondent Name:",{"$f":"+'#1 Reserve Margins'!C1","v":"Example:  PJM, ISO-NE, etc."}]
[]
["Group 3: Metric #29 Total Capacity Bonus Payments and Penalties "]
[]
[]
[]
[null,{"$f":"+'#1 Reserve Margins'!$B$4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!$C$4","v":2014},{"$f":"+'#1 Reserve Margins'!$D$4","v":2015},{"$f":"+'#1 Reserve Margins'!$E$4","v":2016},{"$f":"+'#1 Reserve Margins'!$F$4","v":2017},{"$f":"+'#1 Reserve Margins'!$G$4","v":2018}]
["Total Capacity Bonus Payments and Penalties (RTO-wide)"]
[29,"Total Bonus Payments for Over-Performance (RTO-wide) ($).",0,0,0,0,0]
[{"$f":"+A9+0.01","v":29.01},"Total Penalties Charged for Under-Performance (RTO-wide) ($).",0,0,0,0,0]
[{"$f":"+A10+0.01","v":29.020000000000003},"Total Capacity that Under-Performed (RTO-wide) (Integer).  (Automatically copied from Metric #28.01)",{"$f":"+'#28 Under Perform'!C11","v":0},{"$f":"+'#28 Under Perform'!D11","v":0},{"$f":"+'#28 Under Perform'!E11","v":0},{"$f":"+'#28 Under Perform'!F11","v":0},{"$f":"+'#28 Under Perform'!G11","v":0}]
[29.030000000000005,"Total Capacity with Supply Obligations (RTO-wide) (Integer).  (Automatically copied from Metric #26.00)",{"$f":"+'#26 Capacity Obligation'!C9","v":0},{"$f":"+'#26 Capacity Obligation'!D9","v":0},{"$f":"+'#26 Capacity Obligation'!E9","v":0},{"$f":"+'#26 Capacity Obligation'!F9","v":0},{"$f":"+'#26 Capacity Obligation'!G9","v":0}]
[29.040000000000006,"Fraction of Capacity That did not Meet its Obligation (%).  The spreadsheet will calculate the ratio by dividing the total capacity that did not meet its obligations by the total obligation.  (Automatically calculated)",{"$f":"+C11/C12","v":{"$error":"#DIV/0!"}},{"$f":"+D11/D12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[29.050000000000008,"Explanatory Text.  Provide any additional information if necessary.   ","Text"]
["Total Capacity Bonus Payments and Penalties (Zonal)"]
[null,{"$f":"+'#1 Reserve Margins'!$B$4","v":"Reporting Period"},{"$f":"+'#1 Reserve Margins'!$C$4","v":2014},{"$f":"+'#1 Reserve Margins'!$D$4","v":2015},{"$f":"+'#1 Reserve Margins'!$E$4","v":2016},{"$f":"+'#1 Reserve Margins'!$F$4","v":2017},{"$f":"+'#1 Reserve Margins'!$G$4","v":2018}]
[29.06,"Capacity Zone Name"]
[{"$f":"+A17+0.01","v":29.07},"Total Bonus Payments for Over-Performance (Zonal) ($).",0,0,0,0,0]
[29.080000000000002,"Total Penalties Charged for Under-Performance (Zonal) ($).",0,0,0,0,0]