DOE F 540.16 Better Buildings Challenge Facility–Level Energy Perform

---

Overview

Instructions
Data Requirements
Energy Data
Multifamily Data
Water Data
Food Service Data
Data Centers
Street Lights
Water Treatment
Property Types
Source-Site Ratios

---

Sheet 1: Instructions

Better Buildings Challenge Data Collection Template

Overview: This template is intended to assist Better Buildings Challenge commercial buildings partners in reporting energy and water data from alternative (non-Portfolio Manager) software tools. All alternative tools must be reviewed and approved by DOE. Annualized energy data for each property in the portfolio must be submitted to the Better Buildings Challenge in this template for the baseline period and to demonstrate progress every year (i.e., annual consumption must be provided for the 12 months ending December 2011, December 2012, etc.). New data should be added to the previously submitted spreadsheet, such that each submission includes a full record of progress over time. General Instructions: Fill in all required information on the appropriate tabs this worksheet. A list of all tabs and what they are used for is below. All column headers shown in red denote required data fields. Cells shaded in gray will populate automatically. The first row of each template shows example data. You may delete or overwrite the gray example text. Additional instructions are provided in the comments included on individual tabs. Please read the comments before entering data in those columns. Contact your Account Manager with any questions. - Energy Data - This is the standard template for data collection. Partners should use this tab to provided all necessary data related to the energy consumption at their non-residential properties. - Multifamily Data - This template is for Multifamily Partners. Use columns O, P, and Q to provide additional detail on the type of data available for each property. - Food Service Data - This template is intended for Food Service Partners to share energy and/or transaction data. Use column I to provide the total number of transactions at each property. If you are using Portfolio Manager to share energy data, please match the Property ID and Property Name in Portfolio Manager with columns A and B. - Specialty Property Types (tabs highlighted in blue) - Partners that would like to share data for any of the specialty property types listed below may do so using the fields provided in the blue tabs. - Data Center - Street Lights - Wastewater Treatment Plants - Water Data - This template is for Partners sharing water data. Columns are available to provide indoor and outdoor water consumption data. If your water meters at a property include both indoor and outdoor water, you may enter data in the Total Water Use column. - Data Requirements - Use this tab to provide more information on the data source that is being used to populate the energy templates. - Property Types - This tab provides a full list of eligible property types. If one of your properties does not fit in to one these categories, "Other" is also available. - Source-Site Ratios - This tab shows the current fuel specific conversion factors used to convert site energy to source energy.

This data is being collected to support the Department of Energy Better Buildings Initiative. The data you supply will be used for developing best practices to facilitate reductions in energy intensity by commercial, manufacturing, and community organizations. Public reporting burden for this collection of information is estimated to average 2 hours per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden, to Office of the Chief Information Officer, Enterprise Policy Development & Implementation Office, IM-22, Paperwork Reduction Project (1910-5141), U.S. Department of Energy, 1000 Independence Ave SW, Washington, DC, 20585-1290; and to the Office of Management and Budget (OMB), OIRA, Paperwork Reduction Project (1910-5141), Washington, DC 20503. Notwithstanding any other provision of the law, no person is required to respond to, nor shall any person be subject to a penalty for failure to comply with a collection of information subject to the requirements of the Paperwork Reduction Act unless that collection of information displays a currently valid OMB control number. Submission of this data is voluntary.

---

Sheet 2: Data Requirements

To obtain approval to use an alternative software tool, a Partner must provide a description of the tool used, as well as sample data illustrating that the tool generates all of the necessary metrics. The description of the tool should include general information (tool name, tool developer, etc.) and must answer the following questions:

1) How does the tool annualize energy data?
Data should be provided as annualized totals every six months (e.g. annual consumption should be provided for the 12 months ending June 2012, December 2012, June 2013, etc.)
To generate annualized totals from monthly bills, does the tool 1) normalize actual billing periods to calendar months, 2) assign energy use to the month it was billed in, 3) assign energy use to the month in which most energy was used, or 4) follow another process?

2) How does the tool calculate Site and/or Source EUI in kBtu/square foot?
DOE will track EUI in terms of source energy. The Partner can either provide Source EUI values, or can provide fuel-specific Site EUI values that can be converted by DOE.
What conversion factors are used to generate Site Energy values? Source Energy values?

3) How does the tool calculate Weather Normalized EUI?
Describe the algorithms used, weather stations utilized, and the time period of weather data used for normalization.

4) If applicable, how does the tool calculated Adjusted EUI?
What operating characteristics are adjusted for? How are the adjustments calculated?

5) What checks are performed to ensure that data is complete and accurate?

---

Sheet 3: Energy Data

The property name should be identicial for the same property across all reporting periods. Property Name	Property Owner	Zipcode	Property Type	Please indicate if your data has been normalized for changes in weather or adjusted for changes in any other property characteristics. If normalized or adjusted, please also provide additional information in questions 3 and/or 4 of the Data Requirements tab. If neither apply, please select non-normalized. Type of Data (Weather-normalized or Adjusted)	Ending date for 12 month period in which energy usage is reported Period Ending Date	Total Floor Space (Sq. Ft.)	Report usage for the 12 month period defined by the period ending date in column F Annual Site Electricity Use (kBtu/Sq. Ft.)	Report usage for the 12 month period defined by the period ending date in column F Annual Site Natural Gas Use (kBtu/Sq. Ft.)	Report usage for the 12 month period defined by the period ending date in column F. Please refer to the Data Tracking Manual for a guide on how to track renewable energy. Annual Renewable Energy Generated and Used on Site (kBtu/Sq. Ft.)	Report usage for the 12 month period defined by the period ending date in column F. For Other Fuels, please indicate the unit you are reporting. Annual Site Other Fuel Usage (kBtu/Sq. Ft.)	Annual Total Site Energy Use (kBtu/Sq. Ft.)	Annual Total Source Energy Use (kBtu/Sq. Ft.)	Report energy cost/sq. ft. for the 12 month period defined by the period ending date in column F Annual Energy Cost (US Dollars/Sq. Ft.)	Year Built
Property 1	Company X	XXXXX	Warehouse/Storage - Distribution Center	Weather-normalized	12/31/2010	9,999	88	99			187	350.35	$5.25
Property 2	Company X	XXXXX	Office - Office	Non-normalized	12/31/2010	9,999	88	99			187	350.35
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0

---

Sheet 4: Multifamily Data

The property name should be identicial for the same property across all reporting periods. Property Name	Property Owner	Zipcode	Property Type	Type of Data (Weather-normalized or Adjusted)	Ending date for 12 month period in which energy usage is reported Period Ending Date	Total Floor Space (Sq. Ft.)	Report usage for the 12 month period defined by the period ending date in column F Annual Site Electricity Use (kBtu/Sq. Ft.)	Report usage for the 12 month period defined by the period ending date in column F Annual Site Natural Gas Use (kBtu/Sq. Ft.)	Report usage for the 12 month period defined by the period ending date in column F. Please refer to the Data Tracking Manual for a guide on how to track renewable energy. Annual Renewable Energy Generated and Used on Site (kBtu/Sq. Ft.)	Report usage for the 12 month period defined by the period ending date in column F. For Other Fuels, please indicate the unit you are reporting. Annual Site Other Fuel Usage (kBtu/Sq. Ft.)	Annual Total Site Energy Use (kBtu/Sq. Ft.)	Annual Total Source Energy Use (kBtu/Sq. Ft.)	Report energy cost/sq. ft. for the 12 month period defined by the period ending date in column F Annual Energy Cost (US Dollars/Sq. Ft.)	What areas of the building are included in the energy meters? Metered Areas	Is the data in this row all actual metered data or has it been calculated using the sampling protocol? Actual or Sampled Data?	Number of Units	Year Built
Property 1	Company X	XXXXX	Lodging/Residential - Multifamily Housing	Weather-normalized	12/31/2010	50,000	88	99			187	350.35	$3.45	Whole Building	Sampled	40
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0
											0	0

---

Sheet 5: Water Data

The property name should be identicial for the same property across all reporting periods. Property Name

Property Owner

Zipcode

Property Type

Ending date for 12 month period in which water usage is reported Period Ending Date

Total Floor Space (Sq. Ft.)

Annual Indoor Water Use (kgal)

Annual Outdoor Water Use (kgal)

Total Water Use can be a sum of Indoor and Outdoor Water Use. If the property has one meter with both Indoor and Outdoor Water, you can enter the total value here. Total Annual Water Use (kgal)

Annual Indoor Water Intensity (gal/Sq. Ft.)

Annual Indoor Water Cost (US Dollars)

Annual Outdoor Water Cost (US Dollars)

Total Annual Water Cost (US Dollars)

Year Built

Property 1

Company X

XXXXX

Healthcare - Medical Office

12/31/2010

50,000

265

80

345

5.3

$3.12

---

Sheet 6: Food Service Data

If using Portfolio Manager to report energy data, please include the Property ID number for each property Property ID	The property name should be identicial for the same property across all reporting periods. If using Portfolio Manager to report energy data, please match the Property Name and Property ID with Portfolio Manager Property Name	Property Owner	Zipcode	Property Type	Type of Data (Weather-normalized or Adjusted)	Ending date for 12 month period in which energy usage is reported Period Ending Date	Total Floor Space (Sq. Ft.)	For each row, report the total number of transactions at the location in colum A during the 12 month period in column G Annual Transaction Count	Report usage for the 12 month period defined by the period ending date in column G Annual Site Electricity Use (kBtu)	Report usage for the 12 month period defined by the period ending date in column G Annual Site Natural Gas Use (kBtu)	Report usage for the 12 month period defined by the period ending date in column G Annual Site Electricity Use (kBtu/transaction)	Report usage for the 12 month period defined by the period ending date in column G Annual Site Natural Gas Use (kBtu/transaction)	Report usage for the 12 month period defined by the period ending date in column G. Please refer to the Data Tracking Manual for a guide on how to track renewable energy. Annual Renewable Energy Generated and Used on Site (kBtu/transaction)	Report usage for the 12 month period defined by the period ending date in column G. For Other Fuels, please indicate the unit you are reporting. Annual Site Other Fuel Usage (kBtu/transaction)	Annual Total Site Energy Use (kBtu/Tran.)	Annual Total Source Energy Use (kBtu/Tran.)	Report energy cost/sq. ft. for the 12 month period defined by the period ending date in column F Annual Energy Cost (US Dollars/Tran.)	Year Built
XXXXXXX	Property 1	Company X	XXXXX	Food Sales & Services - Fast Food Restaurant	Non-normalized	12/31/2010	2,500	54,000	72,000	9,912	1.33	0.18			0.00	3.93	$7.45
															0	0.00
															0	0.00
															0	0.00
															0	0.00
															0	0.00
															0	0.00
															0	0.00
															0	0.00
															0	0.00
															0	0.00
															0	0.00

---

Sheet 7: Data Centers

The property name should be identicial for the same property across all reporting periods. Property Name	Property Owner	Zipcode	Property Type	Type of Data (Weather-normalized or Adjusted)	Ending date for 12 month period in which energy usage is reported Period Ending Date	Stand Alone Data Centers are single buildings that contain data center space only. Embedded Data Centers are data centers located within larger buildings (Office, Hospital, etc.) Stand Alone or Embedded Data Center	Total Floor Space (Sq. Ft.)	IT Energy Use is a measure of data equipment energy usage only, this is usually measured at the output of a UPS or input to PDUs connected to server equipment. Annual IT Energy Use (kWh)	Report usage for the 12 month period defined by the period ending date in column F. This column should include all energy used at the Data Center, including that of the IT equipment. Annual Total Data Center Site Electricity Use (kWh)	Report usage for the 12 month period defined by the period ending date in column F. For Other Fuels, please indicate the unit you are reporting. Annual Other Fuel or Renewable Energy Usage (kBtu)	Report usage for the 12 month period defined by the period ending date in column F Annual Infrastructure Site Electricity Use (kWh)	Report usage for the 12 month period defined by the period ending date in column F. For Other Fuels, please indicate the unit you are reporting. Annual Infrastructure Other Fuel Usage (kBtu)	PUE: Power Usage Effectiveness is equal to the total energy of a Data Center divided by the IT Energy Annual PUE	This column is a measure of the total energy used by a Data Center minus IT Energy Annual Infrastructure Energy	Report energy cost/sq. ft. for the 12 month period defined by the period ending date in column F Annual Energy Cost (US Dollars/Sq. Ft.)	Year Built
Property 1	Company X	XXXXX	Technology/Science - Data Center	Weather-normalized	12/31/2010	Stand Alone	12,000	80,000	100,000	50,000			1.43	0.43	$5.75
													0	350.35
													0	0
													0	0
													0	0
													0	0
													0	0
													0	0
													0	0
													0	0
													0	0
													0	0

---

Sheet 8: Street Lights

IF UNMETERED

IF METERED

The property name should be identicial for the same property across all reporting periods. Street Light Type/Group

Owner

Zipcode

Property Type

Type of Data (Metered or Unmetered)

Ending date for 12 month period in which energy usage is reported Period Ending Date

This count assumes one fixture per pole. If you are tracking street lights differently, please let us know. Number of Poles

Total Energy Demand per Pole (W)

Annual Hours of Operation

Report usage for the 12 month period defined by the period ending date in column F Annual Total Site Electricity Use (kWh)

Annual Total Source Energy Use (kBtu/pole)

Report energy cost/sq. ft. for the 12 month period defined by the period ending date in column F Annual Energy Cost (US Dollars)

Year Built

100 W Street Lights - Region 2

Other

Metered

25

6,830

2,610

100 W Street Lights - Region 3

Other

Unmetered

20

120

2555

2,929

---

Sheet 9: Water Treatment

The property name should be identicial for the same property across all reporting periods. Property Name

Property Owner

Zipcode

Property Type

Type of Data (Weather-normalized or Adjusted)

Ending date for 12 month period in which energy usage is reported Period Ending Date

Enter the average million gallons per day treated at the property for the 12 month Period Ending Date listed in column F. Average Flow (MGD)

Report usage for the 12 month period defined by the period ending date in column F Annual Site Electricity Use (kBtu)

Report usage for the 12 month period defined by the period ending date in column F Annual Site Natural Gas Use (kBtu)

Report usage for the 12 month period defined by the period ending date in column F. For Other Fuels, please indicate the unit you are reporting. Annual Site Other Fuel or Renewable Energy Usage (kBtu)

Annual Total Source Energy Use (kBtu/gal/day)

Report energy cost/sq. ft. for the 12 month period defined by the period ending date in column F Annual Energy Cost (US Dollars)

Year Built

Wastewater Treatment Plant 1

Utility - Wastewater Treatment Plant

Non-normalized

12/31/2010

10

6,400,550

1.79

Drinking Water Pump Station 1

Utility - Drinking Water & Treatment Plant

Non-normalized

12/31/2010

12

9,850,360

2.30

---

Sheet 10: Property Types

Property Type

The list of properties below is from EPA's Portfolio Manager, an online tool used to track building energy usage. On the Data Reporting Template or Community Partners Template, please select the property type that best represents your property. If your property consists of multiple types, select the one that represents more than 50% of the floor area. If no one type represents more than 50% of the floor area, choose "Other".

For more information on property types, visit:

https://www.energystar.gov/buildings/facility-owners-and-managers/existing-buildings/use-portfolio-manager/identify-your-property-type

Or view the Portfolio Manager online help page here:

http://portfoliomanager.supportportal.com/ics/support/default.asp?deptID=23010

List of Portfolio Manager Property Types

Banking/Financial Services - Bank Branch

Food Sales & Services - Convenience Store with Gas Station

Public Services - Courthouse

Banking/Financial Services - Financial Office

Food Sales & Services - Convenience Store without Gas Station

Public Services - Fire Station

Education - Adult Education

Food Sales & Services - Fast Food Restaurant

Public Services - Library

Education - College/University

Food Sales & Services - Restaurant

Public Services - Mailing Center/Post Office

Education - K-12 School

Food Sales & Services - Other

Public Services - Police Station

Education - Pre-school/Daycare

Food Sales & Services - Supermarket/Grocery Store

Public Services - Transportation Terminal/Station

Education - Vocational School

Food Sales & Services - Wholesale Club/Supercenter

Public Services - Other

Education - Other

Healthcare - Ambulatory Surgical Center

Religious Worship Facility

Entertainment/Public Assembly - Convention Center

Healthcare - Hospital (General Medical & Surgical)

Retail - Retail Store

Entertainment/Public Assembly - Movie Theater

Healthcare - Other

Retail - Automobile Dealership

Entertainment/Public Assembly - Museum

Healthcare - Medical Office

Retail - Enclosed Mall

Entertainment/Public Assembly - Performing Arts

Healthcare - Outpatient Rehabilitation/Physical Therapy

Retail - Lifestyle Center

Entertainment/Public Assembly - Bowling Alley

Healthcare - Senior Care Community

Retail - Strip Mall

Entertainment/Public Assembly - Fitness Center/Health Center

Healthcare - Urgent Care/Clinic/Other Outpatient

Retail - Other

Entertainment/Public Assembly - Ice/Curling Rink

Lodging/Residential - Barracks

Services - Personal Services (Health/Beauty, Dry Cleaning, etc)

Entertainment/Public Assembly - Roller Rink

Lodging/Residential - Hotel

Services - Repair Services (Vehicle, Shoe, Locksmith, etc)

Entertainment/Public Assembly - Swimming Pool

Lodging/Residential - Multifamily Housing

Services - Other

Entertainment/Public Assembly - Other

Lodging/Residential - Prison/Incarceration

Technology/Science - Data Center

Entertainment/Public Assembly - Social/Meeting Hall

Lodging/Residential - Residence Hall/Dormatory

Technology/Science - Laboratory

Entertainment/Public Assembly - Indoor Arena

Lodging/Residential - Single Family Home

Technology/Science - Other

Entertainment/Public Assembly - Race Track

Lodging/Residential - Other

Warehouse/Storage - Self-Storage Facility

Entertainment/Public Assembly - Stadium (Closed)

Manufacturing/Industrial Plant

Warehouse/Storage - Non-refrigerated Warehouse

Entertainment/Public Assembly - Stadium (Open)

Office - Office

Warehouse/Storage - Refrigerated Warehouse

Entertainment/Public Assembly - Aquarium

Office - Medical Office

Warehouse/Storage - Distribution Center

Entertainment/Public Assembly - Bar/Nightclub

Office - Veterinary Office

Utility - Drinking Water & Treatment Plant

Entertainment/Public Assembly - Casino

Office - Other

Utility - Energy/Power Station

Entertainment/Public Assembly - Zoo

Other

Utility - Wastewater Treatment Plant

Parking

Utility - Other

---

Sheet 11: Source-Site Ratios

Source-Site Ratios for all Portfolio Manager Fuels
Fuel Type	Source-Site Ratio	kBtu Multiplier
Electricity (Grid Purchase)	2.80	3.4125
Electricity (on-Site Solar or Wind Installation)	1.00	3.4125
Natural Gas	1.05	100
Fuel Oil (1,2,4,5,6,Diesel, Kerosene)	1.01
Propane & Liquid Propane	1.01
Steam	1.20
Hot Water	1.20
Chilled Water	0.91
Wood	1.00
Coal/Coke	1.00
Other	1.00