CALIFORNIA COMMISSIONING COLLABORATIVE

Spreadsheet Tools

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

	Description	Source	Date
Pumping System Workbook	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 Workbook and Supporting Documents	CCC	2007
Fan System Workbook	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 Workbook and Supporting Documents	CCC	2007

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. User Guide Download Tool	CCC	2008
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.