ISO New England GADS Data Uploads Starting July 1, 2012

by ronfluegge 2. July 2012 22:35

If you submit GADS data to the ISO New England, as you are aware, they have announced that effective July 1st, PowerGADS – Production has gone live, and you should begin uploading your data by logging into the ISO-NE PowerGADS portal.

There are several things that you need to be aware of.

First, you will need to create the GADS data (using “Write Data”) in 05 and 07 record format.  Performance Data (05) and Event Data (07) must be uploaded into PowerGADS at the same time, in the same file:  a single, combined file (unlike NERC OATI’s requirement).  See our webpage  for more details.  While data submittal to PowerGADS may be made as year-to-date or monthly, we recommend year-to-date.

Second, it is our current understanding that ISO-NE will be requiring the same data fields as NERC’s mandatory (required) data.  You will not be required, as we understand it, to submit the NERC “voluntary” data; however, you may do so if you desire.

As such, it is our understanding that the following data must be submitted to ISO-NE:

Performance Data:
- Net Maximum Capacity
- Net Dependable Capacity
- Net Actual Generation
- Attempted Unit Starts
- Actual Unit Starts
- Unit Service Hours
- Reserve Shutdown Hours
- Pumping Hours
- Synchronous Condensing Hours
- The remaining 02 record hours, are included in the file by the software but are recalculated by PowerGADS from the event data
- Primary Fuel Code

Event Data:
- Event Number
- Event Type
- Start of Event
- End of Event
- Net Available Capacity (deratings)
- Primary Cause Code
- Contribution Code
- Amplification Code
- Only the 01 and 02 event records are required and on the 02 record, the event verbal description is not a required field

Since the ISO-NE required data is now identical to NERC’s, when creating the single combined file to upload to the PowerGADS portal, you will select the “NERC Format” menu option under “Write Data” instead of the ISO-NE option.  See our webpage  for more details.

Unless you have changed the default location, this single combined file can be found in the same folder where the application is installed (typically C:\GADSOS).

The single, combined file will be named:  Combined_NERC_Data_*.txt  (for example, Combined_NERC_Data_January_June_2012.txt).

While we are not aware of any additional issues related to the GADS Open Source software, this initial uploading of GADS data may result in new/changed requirements from ISO-NE to ASCII file formats, to data validations, to required data fields, etc. We may be required to make additional GADS Open Source code revisions between July 1st and July 31st to address any changes.  You will be notified of any and all changes.

We have posted an update (version for Data Entry and for the Dashboard to our software download sites: and that creates the single, combined file as required.  If you do not wish to download this update, you can simply first create the two GADS 05 and 07 formatted files (e.g., Perf_NERC_Data_January_June_2012.txt and Event_NERC_Data_January_June_2012.txt) and then simply combine them using WordPad or Notepad (i.e., any “text” editor).  If you combine them manually, we suggest putting the 07 records after/below the 05 records.

Microsoft Access

by ronfluegge 19. March 2012 12:05

On December 16, 2011 we send out an Update Bulletin with the following:

“If you plan on using Microsoft Access for your storing your GADS data, you cannot use Windows XP; however, you can use Windows Vista or Windows 7.  When datasets from Microsoft Access are loaded into SAP Crystal Reports, Crystal Reports generates the unhandled exception that we cannot trap or fix.  This only occurs when running Analysis & Reporting on Windows XP in combination with Access databases.  If you are not able to switch to Windows 7, we recommended using SQL Server 2005 Express or SQL Server 2008 R2 Express (with tools) instead of Microsoft Access (SQL Server Express is free from Microsoft).  We can assist in installing SQL Server Express on your machines if you would like to implement this solution.  Or you can change your machines to Windows 7.”

Since then we received Crystal Reports Runtime Service Pack 2 from SAP and have been testing it.  The service pack has fixed the above issue.

We are pleased to announce that you can again run the software using Microsoft Access on Windows XP.  We have tested it extensively and have installed it on several users’ machines that were not able to run it before.

Error says "Loading?"

by ronfluegge 22. February 2012 16:11

If you sent your January-December 2011 GADS data to NERC, Mike Curley might send you an Error Log for your units where the Error says "Loading?". 

It is indicating that the “Typical Unit Loading Characteristics” data field is missing.

For 2012, this performance data field is voluntary, but for 2011 NERC is expecting this field to be provided even though NERC has never, to the best of our knowledge, used the Typical Unit Loading Characteristics data for anything even though you submit it.

To provide the necessary data for 2011, simply check the “Write ALL Data Including Voluntary to NERC” box shown on the two other attachments, recreate the GADS 05/07 files, and resend to NERC.

Starting in 2012 you have the option to send to NERC the full data set or just the mandatory data by respectively checking or not checking that box. 

Once you have either checked it or unchecked it, the software saves your “last” setting so that it will have the same setting the next time you run the software.

Welcome to the GADS Open Source blog!

This will be an easy place to keep up on updates and news related to GADS and the GADS Open Source software.

Check out the FAQ section below as well.