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.
Current Stage: Approved for Implementation.