1 / 10

LTRA Data Collection and Analysis Process

LTRA Data Collection and Analysis Process. Data Collection Process. ERO-LTRA2008.xls workbook is sent as an attachment to the Data Request letter Workbook is to be filled out by regions and subregions Data submissions due to NERC by March 31 Notification of data corrections by April 16

eliana-bradley
Télécharger la présentation

LTRA Data Collection and Analysis Process

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. LTRA Data Collection and Analysis Process

  2. Data Collection Process • ERO-LTRA2008.xls workbook is sent as an attachment to the Data Request letter • Workbook is to be filled out by regions and subregions • Data submissions due to NERC by March 31 • Notification of data corrections by April 16 • Corrected submissions due by April 30

  3. Data Collection Process • Workbooks are copied to server folder and renamed • Data is extracted from workbooks and imported into an Access database • Data is queried and exported to Excel • Tables and charts are inserted into a draft LTRA report

  4. LTRA Data Collection Timeline NERCData RequestLetter Regional Managersand Data Coordinators February 6 7+ weeks NERCTechnicalAnalyst RegionalData Submissions March 31 2 weeks RegionalData Coordinators Data Corrections April 16 2 weeks NERCTechnicalAnalyst Corrected DataSubmissions April 30 6 weeks RAS June 3 Draft Report Analysis, Charts and Tables

  5. Data Analysis Process • Tables and Charts • Compare to previous year’s data • Identify trend differences • Flag and follow up on outliers • Review demand and capacity projections • Check for consistency with the self-assessment text • Review capacity margin trends • Identify when curves drop below target • Check for consistency with the self-assessment text

  6. NERC/EIA Data Interface KEY NERC = North American Reliability Corporation EIA = Energy Information Administration ES&D = Electricity Supply & Demand database & Unified Generator Database 860 = Annual Electric Generator Report (US only) 411 = Long-Term Generation & Supply Data (US Only) LTRA = Long-Term Reliability Assessment Data Collection (Contains 411 Data) CA/MXGenerator Data All Data NERC EIA ES&D 411 Data 860 Data

  7. Data Analysis Process • Additional Data Queries • Support emerging issues • Identify industry trends • Ad-hoc

  8. Other Data Activities • Electricity Supply and Demand (ES&D) • LTRA data exported to Excel • Includes historic capacity and demand data since 1990 • Contains EIA-860 – Generator data • Available for purchase • NERC members - FREE • Regional Council members - FREE • Government agencies - FREE • Educational Institutions - FREE • Provide support

  9. Problems • Lack of Consistency • Data and definition revisions • Output to tables and charts • Year to year comparison are cumbersome • Supporting questions and teaching the world • No IT Support • VBA hack

  10. DCWG Support • Process Improvement • Helpful tools or applications? • Any suggestions?

More Related