Error Msg: Could not load Microsoft.Office.Interop.Excel

by ronfluegge 6. September 2012 16:16

We have had to update Analysis & Reporting’s Excel functionality for Excel 2007+, but an Excel PIA DLL (Microsoft.Office.Interop.Excel.dll) was inadvertently not included in with the July 31st AR MSI installer file.  It was added and re-uploaded to our sites on August 22nd. 

If you downloaded the AR MSI between July 31st and August 22nd and installed AR, you may have an error reported when running AR reports.  The error is “Could not load file or assembly Microsoft.Office.Interop.Excel ... The system cannot find the file specified.”

If you have Office 2007 or newer, as we understand it, that “missing” file is supposed to be a part of the Office installation, but it may not be installed.

If you do get the error, please download from the link below, unzip the files into the folder where you have Analysis & Reporting installed and retry AR. 

Download it at:



Independent Consultants

by ronfluegge 10. August 2012 00:01

The consultants listed on the Consultants page are independent third parties that have worked with Project users, but their services are not affiliated with the Project.
The Independent Consultants are staffed with professionals who provide a wide variety of services and solutions. Whether you're looking for customized assistance with GADS training and reporting, or Reliability and Cost Performance, you can easily locate a consultant to help with your technology needs.

What we are working on for the next updates

by ronfluegge 2. August 2012 23:54

What we are working on for the next updates:

1. A new report that shows the Operating Hours between Outages.  It will include startup date/time (breaker closed), stop date/time (breaker opened) and hours online for each continuous run on a unit basis.

2. Expanded data collection and reporting for jointly owned units. 

3. WPF / XBAP releases that will allow both Windows/desktop and browser-based versions to be installed (see following details)

4. Adding capability to create the Generation Equipment Status upload file for the Canadian Electricity Association (CEA) Equipment Reliability Information System (ERIS) database

The current GADS OS version is built on Microsoft Framework 3.5 SP1 which was released on November 18, 2008 and whose support will end on January 13, 2015.

We will make available two versions from the same source code base:  a WPF GADS OS standalone version and a WPF GADS OS XBAP version.  These are also being released as a set of free and open source software tools and licensed under the same GNU General Public License Version 2.

The WPF GADS OS standalone version is a Windows application and will replace the current Windows version on January 1, 2014.  This will allow for a 1 year "grace period" before there will no longer be Microsoft support for the current version.

WPF XAML browser applications (XBAPs) combine features of both Web applications and Windows rich-client applications. Like Web applications, XBAPs can be deployed to a Web server and started from Internet Explorer, Google Chrome, or Firefox.  This supersedes the old GADS NxL web-based version.

We will still support Microsoft Access, Microsoft SQL Server and Oracle databases.



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.