Better Buildings, Better Plants Voluntary Pledge Program

Better Buildings, Better Plants Voluntary Pledge Report

BBC Facility-Level Energy Reporting.xlsx

Better Buildings, Better Plants Voluntary Pledge Program

OMB: 1910-5141

Document [xlsx]
Download: xlsx | pdf

Overview

Instructions
Energy Data
Multifamily Data
Food Service Data
Data Centers
Street Lights
Water Treatment
Water Data
Data Requirements
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: 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. For Other Fuels, please indicate the unit you are reporting. Annual Site Other Fuel Usage (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.)
Property 1 Company X XXXXX Healthcare - Medical Office Weather-normalized 12/31/2010 9,999 88 99

187 380.27 $5.25











0 0











0 0











0 0











0 0











0 0











0 0











0 0











0 0











0 0











0 0











0 0

Sheet 3: 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. For Other Fuels, please indicate the unit you are reporting. Annual Site Other Fuel Usage (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
Property 1 Company X XXXXX Lodging/Residential - Multifamily Housing Weather-normalized 12/31/2010 50,000 88 99

187 380.27 $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 4: 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 F Annual Transaction Count 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 Usage (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 Usage (kBtu) 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.)
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.52 4.38 $7.45













0 0













0 0













0 0













0 0













0 0













0 0













0 0













0 0













0 0













0 0













0 0

Sheet 5: 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 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.)
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 0













0 0













0 0













0 0













0 0













0 0













0 0













0 0













0 0













0 0













0 0

Sheet 6: 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)
100 W Street Lights - Region 2

Other Metered
25

6,830 2,927
100 W Street Lights - Region 3

Other Unmetered
20 120 2555
3,285

























































































































Sheet 7: 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 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)
Wastewater Treatment Plant 1

Utility - Wastewater Treatment Plant Non-normalized 12/31/2010 10 6,400,550

2.01
Drinking Water Pump Station 1

Utility - Drinking Water & Treatment Plant Non-normalized 12/31/2010 12 9,850,360

2.58

























































































































Sheet 8: 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)
Property 1 Company X XXXXX Healthcare - Medical Office 12/31/2010 50,000 265 80 345 5.3

$3.12
















































































































































Sheet 9: 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 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
Electricity (Grid Purchase) 3.14
Electricity (on-Site Solar or Wind Installation) 1.00
Natural Gas 1.05
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 1.00
Wood 1.00
Coal/Coke 1.00
Other 1.00
File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy