HVAC-Sample End-Use Breakdown Instructions (Download Spreadsheet)

Procedures for Commercial Building Energy Audits, Second Edition

Sample End-Use Breakdown Instructions :-

Use this template as a starting point for an end-use breakdown (end-use disaggregation). 

1).Estimate the energy consumption of end-use systems in the buildings and enter these estimates into the appropriate column in the table. Spaces for inputs are marked in blue text.
For a Level 1 analysis, these estimates may be based on expected equipment densities or estimates based on similar buildings.
For a Level 2 or Level 3 analysis, the end-use estimates for major end uses may be based upon one of the following:(listed from most accurate to least accurate)
  • Detailed measurements of end uses, measured over time
  • Spot measurements of end uses, with estimated hours of operation with analysis to support annualization of the measured data
  • Detailed calculations or hourly simulations of equipment performance based on manufacturers' specifications or design drawings.
  • Assumptions of typical end-use densities.
2).Input the historical energy consumption for your building.
Replace the inputs in blue text with data for your billing, including the end-use estimates, the building gross floor area (in units of your choosing), and the historical billing data totals for comparison. These inputs should be consistent with the historical energy use used as part of the Preliminary Energy-Use Analysis Template.

3).Replace the sheet titles with your own. Note project name, date, etc.

4).Use the space below the table to document your assumptions or to note conclusions that can be derived from the data.

5).You may need to add additional end uses for your building, if they are significant.
For example, if the template were used for a data center, you would want to include a separate line item for input power supplied to uninterruptible power supplies (UPSs). It is the auditor'sresponsibility to chose end-use categories that are meaningful for the building. These are listed for guidance as typical end-use categories.

6).Delete rows in the end-use table that are not necessary for your building. This will eliminate blank labels on your chart.

The remaining cells will be calculated as a result. A sample sheet is included for your reference, or you may begin from the blank copy.


By using this spreadsheet, the user acknowledges and agrees to the following terms:
The resources supplied here are for personal and office use by purchasers of Procedures for Commercial Building Energy Audits, Second Edition. These resources are provided “as is” without warranty of any kind, either expressed or implied. The entire risk as to the quality and performance of the resources is with the user. In no event will ASHRAE be liable to the user for any damages, including without limitation any lost profits, lost savings, or other incidental or consequential damages arising out of the use of or inability to use these resources.

Table of Content :-
  • Sample End-Use Breakdown Instructions
  • Sample Peak Demand (kW) Breakdown
  • Conversion Table to kBtu

Post a Comment