48-Hour Disclosure Reports
NP3-915-EX / 48 Hour Highest Price AS Offer Selected / 13018NP3-916-EX / 48 Hour Highest Price Offered in SCED / 13029
NP3-908-ER / 48 Hour DAM and SCED Energy Curves Reports / 13054
NP3-909-ER / 48 Hour DAM Bids and Offers Reports / 13055
NP3-910-ER / 48 Hour Real Time Gen and Load Data Reports / 13056
NP3-911-ER / 48 Hour Ancillary Services Reports / 13057
NP3-257-EX / 48-hour Highest Priced Bids Selected or Dispatched in SCED / 13230
48 Hour Highest Price AS Offer Selected, Report 13018
File name: ext.00013018.0000000000000000.20140819.033951569.48_Hour_Highest_Price_AS_Offer_Selected.zip
Traceability: PUC Substantive Rule §25.505
Delivery Date: 3 days past
Description:
48-hr disclosure data for offer price and name of Entity and Resource submitting the offer for the highest-priced AS Offer for each AS type. If multiple Entities and Resources submitted the highest-priced offers selected, all Entities and Resources shall be identified.
NP3-915-EX / 48 Hour Highest Price AS Offer SelectedFile Name: / 2day_Highest_Price_AS_Offer_Selected-<DD-MON-YY>.csv
Column Header / Description
Column1: / Delivery Date
Column2: / Hour Ending
Column3: / Entity Name / QSE offering AS (Add Column)
Column4: / Resource_Name / Resource name offering AS
Column5: / AS_Type / AS Type
Column6: / Block Indicator
Column7: / Offered Quantity / MW Offered
Column8: / Offered Price / Price Offered
Issues
· Report definition references the “entity submitting the offer”; the report contains the resource name.
PUC Substantive Rule 25.505:
(i) Offer curves (prices and quantities) for each type of ancillary service and for energy at each settlement point in the real time market, shall be posted 60 days after the day for which the information is accumulated except that, for the highest-priced offer selected or dispatched for each interval on an ERCOT-wide basis, ERCOT shall post the offer price and the name of the entity submitting the offer 48 hours after the day for which the information is accumulated.
· Data is only sorted by Hour Ending and Resource Name.
Recommendations
· Add Entity Name Column
· Sort Data by Hour Ending, AS Type, Entity Name, and Resource Name
48 Hour Highest Price Offered in SCED, Report 13029
File name: ext.00013029.0000000000000000.20140819.032513342.48_Hour_Highest_Price_Offered_SCED.zip
Traceability: NP3.2.5(6)
Delivery Date: 3 days past
Description:
48-hr disclosure data for offer price and name of Entity and Resource submitting the offer for the highest-priced offer selected or Dispatched by SCED two days after the applicable Operating Day. If multiple Entities or Resources submitted the highest-priced offers selected, all Entities and Resources shall be identified.
NP3-916-EX / 48 Hour Highest Price Offered in SCEDFile Name: / 2day_Highest_Price_AS_Offered_SCED-<DD-MON-YY>.csv
Column Header / Description
Column1: / SCED Time Stamp
Column2: / Repeated Hour Flag
Column3: / Batch ID / Remove Column
Column4: / LMP / LMP for that SCED run
Column5: / Entity Name / QSE offering (Add Column)
Column6: / Generation Resource / Resource offering
Column6: / Proxy Extension
Column7: / Power Balance Penalty Flag
Issues
· Report definition references the “entity submitting the offer”; the report contains the resource name.
Protocol NP3.2.5(6):
(6) ERCOT shall post on the MIS Public Area the offer price and the name of the Entity submitting the offer for the highest-priced offer selected or Dispatched by SCED two days after the applicable Operating Day. If multiple Entities submitted the highest-priced offers selected, all Entities shall be identified on the MIS Public Area.
· Batch ID is meaningless
Recommendations
· Add Entity Name Column
· Remove Batch ID column
48 Hour DAM and SCED Energy Curves Reports, Report ID 13054
File name: ext.00013054.0000000000000000.20140819.032513063.48_Hour_DAM_and_SCED_Energy_Curves.zip
Traceability: NP3.2.5(3)(b), NP3.2.5(3)(c), NP3.2.5(1)(a), NP3.2.5(1)(b), NP3.2.5(3)(a)
Delivery Date: 2 days past
Description:
48-hr disclosure data for Energy Supply and Demand Curves for DAM and SCED.
The following individual files are included in the report:
48-hour Aggregate Supply Curve for Non-Wind Resources;
48-hour Aggregate Supply Curve for WGR;
48-hour Aggregate Supply Curve for Non-Wind Resources by Disclosure Areas;
48-hour Aggregate Supply Curve for WGR by Disclosure Areas;
48-hour Aggregate Energy Supply Curves (3PSO & Energy Only Offers);
48-hour Aggregate Energy Supply Curves (3PSO & Energy Only Offers) by Disclosure Areas;
48-hour Aggregate Minimum Energy Supply Curves;
48-hour Aggregate Minimum Energy Supply Curves by Disclosure Areas;
48-hour Aggregate Energy Demand Curve;
48-hour Aggregate Energy Demand Curves for Controllable Load Resources
NP3-908-ER / 48 Hour DAM and SCED Energy Curves ReportsFile Name: / 48_Hour_Aggr_Energy_Demand_Curves_CLR-DD-MON-YY.csv
48h_Agg_Energy_Demand_Curves_Houston-DD-MON-YY.csv
48h_Agg_Energy_Demand_Curves_North-DD-MON-YY.csv
48h_Agg_Energy_Demand_Curves_South-DD-MON-YY.csv
48h_Agg_Energy_Demand_Curves_West-DD-MON-YY.csv
48h_Agg_Energy_Demand_Curves-DD-MON-YY.csv
48h_Agg_Energy_Supply_Curves_Houston-DD-MON-YY.csv
48h_Agg_Energy_Supply_Curves_North-DD-MON-YY.csv
48h_Agg_Energy_Supply_Curves_South-DD-MON-YY.csv
48h_Agg_Energy_Supply_Curves_West-DD-MON-YY.csv
48h_Agg_Energy_Supply_Curves-DD-MON-YY.csv
48h_Agg_Min_Energy_Supply_Curves_Houston-DD-MON-YY.csv
48h_Agg_Min_Energy_Supply_Curves_North-DD-MON-YY.csv
48h_Agg_Min_Energy_Supply_Curves_South-DD-MON-YY.csv
48h_Agg_Min_Energy_Supply_Curves_West-DD-MON-YY.csv
48h_Agg_Min_Energy_Supply_Curves-DD-MON-YY.csv
48h_Agg_Supply_Curves_Non_Wind_Houston-DD-MON-YY.csv
48h_Agg_Supply_Curves_Non_Wind_North-DD-MON-YY.csv
48h_Agg_Supply_Curves_Non_Wind_South-DD-MON-YY.csv
48h_Agg_Supply_Curves_Non_Wind_West-DD-MON-YY.csv
48h_Agg_Supply_Curves_Non_Wind-DD-MON-YY.csv
48h_Agg_Supply_Curves_Wind_Houston-DD-MON-YY.csv
48h_Agg_Supply_Curves_Wind_North-DD-MON-YY.csv
48h_Agg_Supply_Curves_Wind_South-DD-MON-YY.csv
48h_Agg_Supply_Curves_Wind_West-DD-MON-YY.csv
48h_Agg_Supply_Curves_Wind-DD-MON-YY.csv
Column Header / Description
Energy_<type>_Curves
Column1: / Delivery Date
Column2: / Hour Ending
Column3: / Price / Price in whole dollars
Column4: / MW / MW offered greater than previous Price and less than or equal to Price
Min_Energy_Curves
Column1: / Delivery Date
Column2: / Hour Ending
Column3: / Price / Offer Price
Column4: / MW / MW Offered at and below the Offer Price
Supply_Curves_Wind, Supply_Curves_Non-wind
Column1: / SCED Time Stamp
Column2: / Repeated Hour Flag
Column3: / Price
Column4: / MW / MW Cleared in DAM
Issues
· CLR filename is not consistent
· Minimum Energy Supply Curves are not built like other curves in file
Discussion: Should Minimum Energy Supply Curves be constructed the same way as the rest of the curves?
Recommendations
· Rename CLR file to be consistent with rest of files
48-Hour DAM Bids and Offers, Report ID 13055
File name: ext.00013055.0000000000000000.20140819.040957515.48_Hour_DAM_Offers_and_Bids.zip
Traceability: NP3.2.5(3)(d), NP3.2.5(3)(h)
Delivery Date: 2 days past
Description:
48 Hour disclosure data for DAM for Point-to-Point Obligation Bids and Total Cleared Energy Bids and Energy-Only Offers.
The following individual files are included in the report:
48-hour Total Cleared Energy Bids and Energy-Only Offers;
48-hour Total Cleared Energy Bids and Energy-Only Offers by Disclosure Areas;
48-hour Point-to-Point Obligation Bids;
48-hour Point-to-Point Obligation Bids by Disclosure Areas
NP3-909-ER / 48-Hour DAM Bids and OffersFile Name: / 48h_PTP_Obligation_Bids_Houston-DD-MON-YY.csv
48h_PTP_Obligation_Bids_North-DD-MON-YY.csv
48h_PTP_Obligation_Bids_South-DD-MON-YY.csv
48h_PTP_Obligation_Bids_West-DD-MON-YY.csv
48h_PTP_Obligation_Bids_-DD-MON-YY.csv
48h_Tot_Clrd_Ene_Bids_Ene_Offers_Houston-DD-MON-YY.csv
48h_Tot_Clrd_Ene_Bids_Ene_Offers_North-DD-MON-YY.csv
48h_Tot_Clrd_Ene_Bids_Ene_Offers_South-DD-MON-YY.csv
48h_Tot_Clrd_Ene_Bids_Ene_Offers_West-DD-MON-YY.csv
48h_Tot_Clrd_Ene_Bids_Ene_Offers-DD-MON-YY.csv
Column Header / Description
PTP
Column1: / Delivery Date
Column2: / Hour Ending
Column3: / Settlement Point Source location for PtP Bid
Column4: / Settlement Point Sink location for PtP Bid
Column5: / PtP Bid MW
Column6: / PtP Bid Price
Column7: / Bid ID
Total Cleared
Column1: / Delivery Date
Column2: / Hour Ending
Column3: / Sum Cleared DAM Bids
Column4: / Sum Cleared 3PO
Column5: / Sum Cleared Energy Only Offers
Issues: None.
Discussion: None.
Recommendations: None.
48 Hour Ancillary Services Reports, Report ID 13057
File name: ext.00013057.0000000000000000.20140819.030948587.48_Hour_AS_Disclosure.zip
Traceability: NP3.2.5(3)(e), NP3.2.5(3)(f), NP3.2.5(3)(g)
Delivery Date: 2 days past
Description:
48 Hour disclosure data for DAM AS Offers.
The following individual files are included in the report:
48-hour Aggregate AS Offers
48-hour Self-Arranged AS, 48-hour Cleared DAM AS.
NP3-916-EX / 48 Hour Ancillary Services ReportsFile Name: / 48h_Agg_AS_Offers_OFFNS-DD-MON-YY.csv
48h_Agg_AS_Offers_ONNS-DD-MON-YY.csv
48h_Agg_AS_Offers_REGDN-DD-MON-YY.csv
48h_Agg_AS_Offers_REGUP -DD-MON-YY.csv
48h_Agg_AS_Offers_RRSGN-DD-MON-YY.csv
48h_Agg_AS_Offers_RRSLD-DD-MON-YY.csv
48h_Agg_AS_Offers_RRSNC-DD-MON-YY.csv
48h_Cleared_DAM_AS_NSPIN-DD-MON-YY.csv
48h_Cleared_DAM_AS_REGDN-DD-MON-YY.csv
48h_Cleared_DAM_AS_REGUP-DD-MON-YY.csv
48h_Cleared_DAM_AS_RRSGEN-DD-MON-YY.csv
48h_Cleared_DAM_AS_RRSLOAD-DD-MON-YY.csv
48h_Self_Arranged_AS_NSPIN-DD-MON-YY.csv
48h_Self_Arranged_AS_REGDN-DD-MON-YY.csv
48h_Self_Arranged_AS_REGUP-DD-MON-YY.csv
48h_Self_Arranged_AS_RRSGEN-DD-MON-YY.csv
48h_Self_Arranged_AS_RRSLOAD-DD-MON-YY.csv
Column Header / Description
AS Offers
Column1: / Delivery Date
Column2: / Hour Ending
Column3: / MW Offered / MW Offered at and below the Offer Price
Column4: / <AS Type> Offer Price / Offer Price
Cleared
Column1: / Delivery Date
Column2: / Hour Ending
Column3: / Total Cleared AS - <AS Type> / MW Cleared in DAM
Self-Arranged
Column1: / Delivery Date
Column2: / Hour Ending
Column3: / Total Self-Arranged AS - <AS Type> / MW Self-Arranged
Issues: 48h_Agg_AS_Offers_RRSNC report data is not sorted correctly
Discussion: Should the data in the Cleared RRS on Loads report be separated based on controllable and non-controllable loads?
Clarification: In SAAS-RegDn and RegUp report, there are negative MW values. What do these values represent?
Recommendations
· Sort 48h_Agg_AS_Offers_RRSNC report by hour ending and MW values
· Separate RRSLOAD reports into controllable and non-controllable loads
· ERCOT to provide explanation/documentation for negative MW values in Self-Arranged reports
48-hour Highest Priced Bids Selected or Dispatched in SCED, Report 13230
File name: ext.00013230.0000000000000000.20140819.030948852.48h_Highest_Price_Bids_Selected_Dispatched_in_SCED.zip
Traceability: NP3.2.5(6)
Delivery Date: 3 days past
Description:
48-hr disclosure data for bid price and name of Entity and Resource submitting the bid for the highest-priced bid selected or Dispatched by SCED two days after the applicable Operating Day. If multiple Entities and/or Resources submitted the highest-priced bids selected, all Entities and Resources shall be identified.
Delivery Date: 3 days past (August 16, 2014)
NP3-257-EX / 48-hour Highest Priced Bids Selected or Dispatched in SCEDFile Name: / 48h_Highest_Price_Bids_Selected_Dispatched_in_SCED -<DD-MON-YY>.csv
Column Header / Description
Column1: / SCED Time Stamp
Column2: / Batch ID / Remove Column
Column3: / Repeated Hour Flag
Column4: / QSE
Column5: / Load Resource / Load Resource Bidding
Column6: / Highest Price Dispatched by SCED / Price
Column7: / Proxy Extension
Issues
· Batch ID is meaningless
Recommendations
· Remove Batch ID column