This section outlines the format and accessibility requirements of building meter data for the Energy and Water Conservation Technical Division. These requirements allow the energy engineers to perform:

• Measurement and verification of the EWC program and individual projects
• Analysis and troubleshooting of individual and multiple building performance
• Ongoing tracking and fault detection of individual and multiple buildings

Where applicable, the minimum requirements to perform the job are listed along with the preferred capabilities for advanced reporting and analytics. Requirements are broken up between the needs for measurement and verification (M&V) and analysis, comparison, and fault detection. Definitions are provided at the end.
Currently, ENURGY meets the basic needs of M&V. GE Proficy iHistorian is the only tool that meets all needs for full M&V and advanced analysis; at this time, however, EWC has very limited access to this tool.

For Measurement and Verification (M&V)

• Interval and coverage:
  • Monthly totalized consumption and cost for each utility at the total building level (TBU), as validated/verified by UEM/BFS and reported as billed data for both E&G and AUX spaces
  • Daily totalized consumption for each utility at the total building (TBU) and the individual meter level, including main and sub meters, for both E&G and AUX spaces
• Accessibility and format:
  • At a minimum, historical data needs to be available for the above metrics in a spreadsheet listing the values and associated timestamp for each requested building or meter
  • At a minimum, the time range needs to cover two reporting periods (typically one year each) to provide comparison
  • Preferably, bulk download of a single spreadsheet consisting of values and timestamps for multiple buildings and/or multiple meters over a defined time range.
  • For advanced reporting, there should be no limit on the number of building or time range in this query, allowing for identification of maximum and minimum scenarios (e.g. Top 10 for any utility over any time range)
  • At a minimum, data is available as requested through proper channels (e.g. a UEM data request form)
  • Preferably, data is available through a networkable interface with flexibility to allow for further development of data analysis tools

For analysis, comparison, and fault detection

• Interval and coverage:
  • For average data sampling: no larger than 15 minute intervals, preferably 5 minute intervals
  • For raw data sampling: at the same interval as recorded
  • For lab data sampling: at the interval specified by the query
  • Instantaneous for total building (TBU) and individual meters
• Accessibility and format:
  • At a minimum, historical data needs to be available for the above metrics in a spreadsheet listing the values and associated timestamp for each requested building or meter
  • Preferably, bulk download of a single spreadsheet consisting of values and timestamps for multiple buildings and/or multiple meters over a defined time range
  • For advanced reporting, there should be no limit on the number of building or time range in this query, allowing for identification of maximum and minimum scenarios (for examples see the Delta-T Report, Variance Report, Longhorn Lights Out M&V, 3PIM, etc, as previously developed by EWC energy engineering staff)
  • At a minimum, data is available as requested through proper channels (e.g. a UEM data request form)
  • Preferably, data is available through a networkable interface with flexibility to allow for further development of data analysis tools

Visualization Tool

One of the main tasks for the energy stewards is to communicate with campus clients how much energy their buildings are consuming and their impact by participating in behavior programs and other technical projects. It is recommended that only electrical demand is measured in the visualization tools since chilled water and steam consumption is contingent on building systems and not the occupant control unless departments invest in capital upgrades.
If access to iHistorian was available staff would have the capabilities to download .CVS files and reformat for more desirable communications, however this takes a significant amount of staff time.
The following is recommended for a web based visualization tool that will drive behavior change:

• Time-of-day data (electrical only):
  • At a minimum, 15 minute incremental data is needed to have constructive discussions with building occupants
• Real-life equivalencies (pollution created/saved, per person workspace, light bulbs, homes, etc)
• Means to break down end-use for comparison (per floor, department, AHU zone)
• Social Media component-Just providing the energy data will not be sufficient- there is a need for open communication and comments for end-users
  • Discussions boards- occupant can provide feedback and
  • Commitment boards
  • Event tagging- ability to post events throughout campus that drive culture change programs
  • Budgets per day (better than day before, last week, etc)
• Backend user profile analytics
  • EID
  • College/Department
  • Faculty/staff/student user profiles
  • Building
  • Floor

Definitions

• Monthly – time interval defined by the calendar month (12:00AM of the first day of month to 12:00AM of the first day of the next month)
• Daily – time interval defined by a full day (12:00AM of one day to 12:00AM of the following day)
• Total Building Usage (TBU) – The aggregation of meters that represent the metered consumption of the physical building, regardless of E&G or AUX space definitions
• Individual meter – the consumption measurements off of an individual meter, both main and sub-meters
• Timestamp – the time associated with the start of a selected time interval of data
• Time range – the time period for data collection, broken down into time intervals
• Reporting period - the range of time over which consumption is measured and compared to a prior reporting period (typically one year, but could be anything such as a month, fiscal quarter, lunch hour, etc)
• Spreadsheet – Excel workbook or CSV file
• Utilities – includes: chilled water, electricity, steam, or domestic water
• Energy consumption – kWh for electricity, lbs for steam, ton-hrs for chilled water, gallons for domestic water
• Instantaneous - kW for electricity, lbs/hr for steam, tons for chilled water, dT for chilled water, gpm for chilled water, gpm for domestic water
• Average sampling – all averaged intervals are assumed to be time-weighted to properly account for total consumption (example: a one day time-weighted average of measured kW could be multiplied by 24 hours to equate to one day total consumption in kWh)
• Raw sampling – data as identically recorded in the process historian or SQL database
• Lab sampling – for a specified time range and interval, returns the next recorded data point in the process historian after each time stamp