GAA Wind Events Data Loader

About GAA Wind Events Data Loader

Using the GAA Wind Events Data Loader, you can update the GAA Wind Event.

About the GAA Wind Events Data Loader Requirements

Prerequisites

Download the GAA Wind Events data loader workbook from the APM Wind Generation data loader category in APM.
Identify the data requirements for exporting data from the Events workspace into the data loader workbook.
Extract data from the exported Excel file to populate the data loader workbook.
Note: Ensure to copy the content from the IEC Events Worksheet.

Security Settings

The user who loads data into APM must be associated with the following Security Groups and Security Roles:

MI Data Loader User Security Role

or

MI Data Loader Admin Security Role

About the GAA Wind Events Data Loader General Loading Strategy

Best Practices

When using the data loader workbook, consider the following best practices:

Ensure that Field IDs (that is, row 2 of IEC Events worksheet) do not include special characters or spaces.
Do not modify the first two rows of IEC Events worksheet once the data to be imported is copied from the exported file.
Consider the rules described in the Workbook Layout and Use section of this document.

About the GAA Wind Events Data Loader Workbook Layout and Use

Color Coding

Certain columns in the worksheets have different functions and requirements. To illustrate this, they are color-coded. The following table provides a list of colors and what they represent.


Color	Description	Comment
Pink	Required fields	Indicates columns that contain values that are required in GAA Wind.
Blue	Recommended fields	Indicates columns that, according to GE Vernova Best Practice for GAA Wind, should contain values.
White	Optional fields	Indicates columns where you can specify custom fields.

Configuration Worksheet

Please refer to About the Configuration Worksheet topic that provides a list of fields that appear in the Configuration worksheet.

Note: Do not modify any of the column values on this worksheet.

IEC Events Worksheet

The following table provides a list of fields that appear in the IEC Events worksheet.

Note: Modify only the editable fields (NERC Type, Description, Error Code, and Actual Production) before importing the GAA Wind Events Data Loader workbook. Modifying any other fields will result in unwanted changes in the Event data.


Field Caption	Data Type (Length)	Comment
Unit Name	Character	Identifies the unit for which Event is reported.
IEC Type	Character	Identifies the type of the Event.
Start Date	Date	Identifies the start date of the Event.
End Date	Date	Identifies the end date of the Event.
Duration	Numeric	Identifies the difference between the values in the End Date field and the Start Date field.
Description	Text	Identifies the description of the Event.
NERC Type	Character	Identifies the NERC equivalent of the IEC type.
Error Code	Character	Identifies the validation error.
Actual Production	Numeric	Identifies the actual production of the Unit in megawatt hours.
Event ID	Character	Identifies the Event.
Sub Group Key	Numeric	Identifies the key of the Sub Group for which the Event is reported.
Unit Key	Numeric	Identifies the key of the Unit for which the Event is reported.
Site Reference Name	Character	Identifies the name of the site that is assigned to the Event record.
Start Date Timezone	Character	Identifies the name of the time zone for the Start Date field. Note: The value in this field will always be logged in the User time zone.
End Date Timezone	Character	Identifies the name of the time zone for the End Date field. Note: The value in this field will always be logged in the User time zone.