Existing Building Commissioning Toolkit

Spreadsheet Tools

Energy Savings Calculation Tools
Calculate energy savings related to specific Existing Building Commissioning measures with these Microsoft Excel© workbooks. Training documents and recommended test procedures are provided to assist first-time users.

 DescriptionSourceDate
C-BOA (Custom Building Optimization Analysis)

An Excel© spreadsheet-based tool that offers a standardized approach to calculating savings for common EBCx measures. The engine of the tool is a suite of engineering calculations programmed in Visual Basic macros. The user provides site-specific inputs that customize the calculations and make the tool applicable to a broad range of projects.

Learn More & Download

Join the users group on LinkedIn. Just search LinkedIn for C-BOA Users

CEC PIER, SCE, CCC

2012

Building Optimization Analysis (BOA) Tool

An Excel© spreadsheet-based tool designed to streamline and standardize the energy savings calculation process for Existing Building Commissioning. The BOA tool targets commercial buildings and allows providers to calculate energy and peak demand savings for thirteen common controls- and schedule-based commercial building optimization measures.

For BOA Tool technical support, please contact boatool@peci.org

SCE, PG&E, SDG&E, & SMUD

2011

Pumping System Workbook Version 2.0

For variable flow pumping systems, this spreadsheet tool calculates energy savings from one or a combination of the following measures:

  • Reducing flow rate
  • Reducing differential pressure setpoint
  • Resetting differential pressure setpoint
 

ReadMe File
Download Version 2.0 Workbook and Supporting Documents

CCC

2008

Fan System Workbook Version 2.0

For variable volume fan systems, this spreadsheet tool calculates energy savings from one or a combination of the following measures:

CCC

2008



Data Analysis Tools
Use these Microsoft Excel-based tools to record, organize, and analyze data collected during the retrocommissioning process.

 

Description

Source

Date

Energy Charting and Metrics (ECAM) Tool

ECAM, a tool for energy charting and metrics, facilitates the examination of energy information from buildings, reducing the time spent analyzing trend and utility meter data. In addition to being very easy-to-use, this tool is also flexible. Key features include:

  • Data processing to attach schedule and day-type information to time-series data;
  • Filtering by daytype, day of week, time of day, occupancy, binned weather data, month or year, pre/post, equipment status, and combinations of these parameters;
  • Normalization of data based on user-entered information;.
  • Calculation of normalized metrics for the points selected by the user; and
  • Creation of a variety of load profile and x-y charts for the points selected by the user.

Learn More & Download

CCC

2011

Utility Consumption Analysis Tool

This tool calculates average daily energy consumption for each month based on monthly utility bills and the dates the meter was read and includes the following features:

  • Prorates and interpolates energy use when utility bills do not coincide with a single calendar month, as is most often the case
  • Allows a user to input other comparison data, such as degree-days
  • Allows utility bills to be entered in any order
  • Sorts bills by date or energy use
  • Creates a formatted line chart to show how energy use changes over time

Download Workbook

CCC

2007

Findings Workbook

This workbook helps organize, track, and report retrocommissioning investigation and implementation activities and includes the following features:

  • Defines key fields used to track the progress and results of an RCx project
  • Automates the creation of tables for reporting at each stage of an RCx project
  • Allows measures not selected for implementation to be automatically filtered from reports
  • Facilitates the estimation of cost savings from user-input energy savings by including the structure of several rate tariffs from California
  • Aids research by including standard drop-down categories to group RCx findings
  • Facilitates decision-making through clear presentation of prioritized measures for implementation

Download Workbook

CCC

2007

 

Submit Your Commissioning Resources

IMPORTANT NOTICE: These sample documents are provided for instructional purposes only. CCC is not rendering advice concerning any commission project or practices. These documents are neither approved nor intended to serve as a standard form. The user of these documents should confer with qualified advisors with respect to its commissioning and other documentation.