Managing Campus Wide Energy Getting Beyond the Spreadsheet

Jerry Gallegos, Sandia National Laboratories
Celeste Cizik, Group14 Engineering

Sandia National Laboratory encompasses more than 7,000,000 sq.ft. of building area in the New Mexico and California campuses. The Sandia campuses contain hundreds of buildings with over 800 energy meters and tens of thousands of building automation system points. Managing energy and operational data has been a challenge in the past, requiring manual processes and tedious spreadsheets. In an effort to reduce energy and improve operations, Sandia has been deploying building analytics software to tackle the large quantity of data and find actionable information.

Deploying data analytics across Sandia's campuses has had many triumphs and challenges. The goal of this presentation is to help other laboratory operators and managers learn from the process and execute smoothly in the future. The following are key highlights that will be covered:

  • Determining the right approach to incorporate analytics Sandia looked at programming of the BAS, multiple tool options, etc
    Solution: Utilize the BAS for control and critical alarms, implement a 3rd party tool focused on data analytics
  • Getting buy in and integrating tool into operations practices challenge to add a software tool to the day job of typical facility operators
    Solution: Designate energy team member as first point of data review
  • Prioritizing large volume of faults detailed rules can find large quantities of issues, need process to troubleshoot and track
    Solution: work in progress refine rules for different user groups, develop tracking system to note status/progress of issues
  • Limitations of the BAS network older system does not have capability to transfer and store large volumes of data
    Solution: Intermittent CSV solution, moving toward BAS upgrade


  • Integration of data from a wide variety of data sources weather data, meter data, BAS data, etc. in various formats (CSV, SQL, API restful, etc.); moved from spreadsheet analysis to managing a large amount of data on one platform reduce time and analyze data more in depth
  • Monitoring hundreds of energy meters and detect issues identified key issues with meters (ie data gaps, spikes, calibration), created energy dashboard views, and developed key performance indicators (KPIs).
  • Discovering underlying control issues tool has discovered short cycling of boilers, occupancy sensors not triggering temperatures setbacks, overridden equipment, etc. Processes will continue to be refined to effectively address issues and monitoring will continue to be expanded. Overall, building analytics software will allow the campus to more effectively manage energy use and improve operations.

Learning Objectives

  • Plan for the implementation of building data analytics on a large campus;
  • Understand hurdles that may be encountered with building data analytics and how they can be overcome;
  • Evaluate the resulting benefits that can be gained from detailed energy meter monitoring; and
  • Identify potential issues that can be uncovered with a building analytics tool.


Jerry Gallegos is a Professional Engineer and Certified Energy Manager at Sandia National Laboratories leading an energy management program at campuses in New Mexico and California. He has over 18 years of experience in the design and operations of buildings, energy analysis, building automation, laboratory controls, energy modeling, and energy auditing.

Celeste Cizik is a Professional Engineer and Principal at Group14 Engineering overseeing Existing Building and Monitoring Based Commissioning Services. She has over fifteen years of experience in building energy engineering including retro-commissioning, energy analysis, and mechanical system design. She has conducted energy projects at facilities and campuses across the country including large retro-commissioning projects for laboratories utilizing analytical software.


Note: I2SL did not edit or revise abstract or biography text. Abstracts and biographies are displayed as submitted by the author(s).