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.

	Description	Source	Date
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. BOA Tool Development Report BOA Tool Final Report Training Slides BOA Tool Training Recording Download the BOA Tool 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: Reducing VAV box minimum flow setpoint Reducing duct static pressure setpoint Resetting duct static pressure setpoint Resetting supply air temperature (can also be applied to constant volume fan systems) ReadMe File Download Version 2.0 Workbook and Supporting Documents	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

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

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.