From raw data to graphs in 5-minutes.

Energy Charting and Metrics (ECAM) Tool, version 2.0

What is ECAM?

ECAM is a Microsoft Excel®-based tool that facilitates the examination of energy information from buildings, and ultimately reduces the time spent analyzing utility meter data and system operational data. Starting from simple time-series data, ECAM automates a wide array of charting and analysis functionality.

The most common use of ECAM is to complete pre and post energy efficiency project regression analyses of utility interval meter data against outdoor air temperature. However, ECAM has additional applications that can be used independently, including analysis of a building’s load profile, creating per-square-foot metrics of building energy use, and developing scatter charts based on occupancy or time of day. These applications can ultimately be used to better understand a building’s energy use patterns and inform the selection of energy efficiency measures with the highest potential for savings.

The tool makes extensive use of Excel PivotTables to facilitate summarization and filtering of data. It goes beyond normal PivotTables and PivotCharts, however, by automating the creation of scatter charts based on PivotTable data.

Key features include the following:

  • Data processing to attach schedule and day-type information to time-series data
  • Filtering by day-type, occupancy schedule, binned weather data, month/year, pre/post project data, etc.
  • Normalization of data based on user-entered information such as building square footage
  • Creation of standard charts for the points selected by the user
  • Calculation of normalized metrics for the points selected by the user

Who benefits most from using ECAM?

ECAM is useful for anyone who would like to expedite the processing and analysis of building energy data. Commissioning providers, energy auditors, ESCOs, energy consultants, and building engineers will find ECAM useful in translating raw data into meaningful and highly flexible charts — in a matter of minutes.

What’s new in version 2.0?

ECAM v2.0 is now compatible with Excel 2007/2010, and has a host of new charting and analysis features along with major updates to existing functionality. In addition, version 2.0 also includes a new menu option, “PNNL Retuning”, that opens up an array of options for standardized charts to analyze operational data from Building Automation systems. Find out more about PNNL Retuning here.

See the ECAM Overview Presentation and User Guide for more details about additions to version 2.0.

Acknowledgements

The original development of ECAM was co-funded by the Northwest Energy Efficiency Alliance (NEEA), New Buildings Institute (NBI), and the California Energy Commission. The update to v2.0 was primarily funded through the California Energy Commission’s Public Interest Energy Research (PIER) program, with additional funding from CCC and NEEA. Version 2.0 also benefits from the incorporation of charting and functionality developed by the Pacific Northwest National Laboratory (PNNL) for their “Building Re-Tuning” Program.

A number of individuals provided useful feedback on ECAM v2.0 based on beta testing: Danny Taasevigen and Srinivas Katipamula, PNNL; Amber Buhl and Ben Cartwright, PECI; and Brad Acker, University of Idaho.