9.2 Historical Data Collection, Utility Benchmarking & Operator Interviews

9.2 Historical Data Collection, Utility Benchmarking & Operator Interviews

Quick Summary: The initial stage of the EBCx Investigation Phase combines rigorous quantitative data analytics with deep qualitative investigative interviews. By analyzing 24 to 36 months of continuous utility bills, weather-normalizing consumption via degree days, benchmarking Energy Use Intensity (EUI) in ENERGY STAR Portfolio Manager, and decomposing complex electric tariffs, the Commissioning Provider (CxP) establishes an empirical energy baseline. Concurrently, structured interviews with building operators and occupants unmask undocumented control overrides, manual bypasses, chronic hot/cold complaints, and deferred maintenance practices that static utility data cannot directly reveal.

---

Historical Utility Billing Data Collection Protocols

Before an EBCx team touches a single physical tool or inspects an air handler, they must construct a complete empirical picture of how the facility consumes energy and resources. The CxP must request, organize, and audit a minimum of 24 to 36 consecutive months of complete utility billing data for all energy and water utilities serving the site.

Why 24 to 36 Months is Mandatory

Collecting a single year (12 months) of utility records is a dangerous practice that frequently distorts the baseline:

• Climatic Volatility: A single 12-month period may coincide with an unusually mild winter or a record-breaking summer heatwave, presenting an unrepresentative operational profile.
• Billing Adjustments and Estimated Meter Reads: Utilities routinely estimate meter reads for one or two billing cycles before performing a true physical read, resulting in multi-month reconciliation spikes that skew monthly analyses.
• Occupancy Transients: A major tenant vacancy or post-pandemic phased return-to-office during a single 12-month window will falsely distort base energy use. A 24- to 36-month dataset allows the CxP to observe multi-year operational cycles, verify billing consistency, and establish a statistically defensible baseline per ASHRAE Guideline 14 (Measurement of Energy, Demand, and Water Savings).

Comprehensive Utility Data Inventory

The utility inventory must capture all metered energy and fluid streams crossing the site boundary:

1. Electricity: Billed active consumption (kWh), registered peak demand (kW), reactive energy (kVARh) or measured Power Factor ($PF$), billing demand (accounting for ratchets), and time-of-use (TOU) interval splits.
2. Natural Gas: Volumetric consumption in hundreds of cubic feet (CCF) or thousand cubic feet (MCF), billed thermal energy in therms (1 therm = 100,000 Btu) or decatherms (Dth), and heating value adjustment factors.
3. Fuel Oil / Propane: Delivered volume (gallons), delivery dates, tank fill levels, and fuel grade (#2 fuel oil at 138,500 Btu/gal; commercial propane at 91,500 Btu/gal).
4. District Thermal Utilities: District chilled water consumption in ton-hours or MMBtu, peak chilled water demand (tons), entering/leaving water temperature differentials, district steam consumption in thousands of pounds (Mlbs) or MMBtu, and condensate return credit/metering.
5. Municipal Water & Sewer: Total potable water consumption (gallons or hundred cubic feet / HCF), irrigation submetered volume, cooling tower deduct meter readings (water evaporated and exempt from sewer discharge fees), and sewer surcharge rates.

Normalizing for Billing Period Variations

A frequent analytical error is plotting raw monthly utility bills directly against calendar months. Utility billing cycles rarely align with calendar months; a "January" bill may span 34 days from December 15 to January 18, while the subsequent "February" bill spans only 27 days. The CxP must normalize all billing data into energy use per day (kWh/day, therms/day) or re-bin the consumption into standardized calendar months before correlating with climatic data.

---

Energy Benchmarking: Site EUI, Source EUI & ENERGY STAR Portfolio Manager

To establish whether a building is an energy hog or an efficient performer, its raw energy consumption must be converted into standardized energy metrics and benchmarked against peer facilities in identical climate zones.

Site EUI vs. Source EUI

All energy streams must first be converted into a common thermal denominator: British Thermal Units (Btu), expressed in thousands of Btu (kBtu). Standard Higher Heating Value (HHV) conversion factors are applied:

• Electricity: $1\text{ kWh} = 3,412\text{ Btu} = 0.003412\text{ MMBtu}$
• Natural Gas: $1\text{ therm} = 100,000\text{ Btu} = 0.10\text{ MMBtu}$
• Fuel Oil #2: $1\text{ gallon} = 138,500\text{ Btu} = 0.1385\text{ MMBtu}$
• District Chilled Water: $1\text{ ton-hour} = 12,000\text{ Btu} = 0.012\text{ MMBtu}$
• District Steam: $1\text{ lb} \approx 1,000\text{ to }1,194\text{ Btu}$ (dependent on steam pressure/enthalpy)

$\text{Total Site Annual Energy (kBtu)} = \sum (\text{Fuel Quantity} \times \text{Conversion Factor})$

$\text{Site Energy Use Intensity (Site EUI)} = \frac{\text{Total Annual Energy Consumed On-Site (kBtu)}}{\text{Gross Conditioned Floor Area (sq ft)}}$

While Site EUI represents the energy registered on the building's utility meters and paid by the building owner, Source EUI accounts for the primary energy consumed at the power plant and the energy lost during generation, transmission, and distribution:

$\text{Source EUI} = \frac{\sum (\text{Site Energy per Fuel Type} \times \text{Source-to-Site Ratio})}{\text{Gross Conditioned Floor Area (sq ft)}}$

Under EPA ENERGY STAR Portfolio Manager guidelines, standard U.S. national source-to-site ratios are:

• Grid-Supplied Electricity: $2.80$ (i.e., it takes 2.80 units of primary coal, natural gas, or nuclear energy at the generating plant to deliver 1.0 unit of electrical energy at the building electrical service panel).
• On-Site Natural Gas: $1.05$ (reflecting minor transmission and pipeline compression losses).
• District Steam: $1.20$.
• District Chilled Water: $0.91$ (accounting for central plant electric efficiencies).

Source EUI is the truest reflection of a building's total environmental footprint and primary energy consumption. Comparing two buildings using Site EUI alone can be highly misleading; an all-electric building may exhibit a lower Site EUI than a building heated by natural gas, yet consume significantly more primary Source energy due to the 2.80 electric grid multiplier.

ENERGY STAR Portfolio Manager Benchmarking

ENERGY STAR Portfolio Manager is the industry-standard benchmarking platform. The tool normalizes a facility's gross energy consumption against:

1. Weather (heating and cooling degree days corresponding to the building's specific ZIP code).
2. Gross floor area and primary functional use (e.g., commercial office, medical center, school, warehouse).
3. Operating intensity parameters: weekly operating hours, number of workers on the main shift, number of personal computers, and percent of floor area heated and air-conditioned.

The platform outputs a 1 to 100 ENERGY STAR Score:

• Score of 50: Represents the national median performance for that building peer group.
• Score below 50: Indicates higher energy consumption than average, signaling rich opportunities for EBCx.
• Score of 75 or Higher: Represents top-quartile performance; buildings achieving ≥75 are eligible for formal EPA ENERGY STAR certification.

ASHRAE Standard 100-2024 Energy Targets

ASHRAE Standard 100 (Energy Efficiency in Existing Buildings) establishes normative Energy Use Intensity Targets ($\text{EUIt}$) across building types and climate zones. Standard 100 is increasingly adopted by major cities and states (e.g., Washington State Clean Buildings Act, NYC Local Law 97, Boston BERDO) as a mandatory regulatory Building Performance Standard (BPS). The CxP uses Standard 100 to evaluate whether an existing building faces impending municipal carbon or energy fines if operational efficiencies are not achieved.

---

Weather Normalization & Linear Regression Modeling

Energy consumption in commercial buildings is governed by two distinct components: weather-dependent loads (HVAC heating and cooling) and weather-independent base loads (lighting, plug loads, server closets, domestic hot water, vertical transportation).

Decomposing Energy Consumption into Base Load and Weather-Dependent Load:
Energy Use
   ▲
   │                                         * (Peak Summer / Cooling)
   │                                     *   *
   │                                 *   *
   │                             *   *
   │                         *   *
   │  * (Peak Winter / Heating)
   │  *   *
   │      *   *
   │          *   *   *   *   *   *   *   *   * (Base Load: Lights, Plugs, Servers)
   └──────────────────────────────────────────────► Ambient Temperature (°F)
              Winter (HDD)             Summer (CDD)

To isolate these components, the CxP correlates historical utility data with local meteorological data using Heating Degree Days (HDD) and Cooling Degree Days (CDD).

Degree Day Formulations & Balance Point Temperature

Degree days quantify the magnitude and duration of outdoor temperatures departing from a baseline temperature:

$\text{HDD}_{base} = \max(0, T_{base} - T_{mean})$

$\text{CDD}_{base} = \max(0, T_{base} - T_{mean})$

While standard meteorological tables publish degree days using a base temperature of 65°F (18.3°C), modern commercial buildings generate significant internal heat gains from people, lighting, and computers. Consequently, a commercial building often does not require space heating until ambient temperatures drop below 50°F to 55°F. The temperature at which internal heat gains exactly balance envelope and ventilation heat losses is the facility's thermal balance point temperature ($T_{bal}$). An experienced CxP calculates degree days based on the building's true balance point temperature rather than blindly applying 65°F.

Linear Regression Diagnostics

By plotting monthly fuel consumption against degree days, the CxP constructs a single-variable or multi-variable linear regression equation per ASHRAE Guideline 14:

$E = m \cdot \text{DD} + b$

Where:

• $E$ = Monthly energy consumption (therms, MMBtu, or kWh/day).
• $\text{DD}$ = Degree Days per billing day (HDD for heating fuels; CDD for cooling electric).
• $m$ = Slope of the regression line, representing the weather sensitivity of the building envelope and outside air ventilation systems (higher slopes indicate leaky envelopes, lack of insulation, or excessive outdoor air intake).
• $b$ = Y-intercept, representing the weather-independent base load (energy consumed when degree days equal zero).
• $R^2$ = Coefficient of Determination, measuring goodness-of-fit. An $R^2 \ge 0.75\text{ to }0.85$ indicates strong correlation. An $R^2 < 0.60$ alerts the CxP to operational anomalies—such as erratic control overrides, seasonal process changes, or malfunctioning economizer dampers that mask true weather response.

---

Utility Tariffs, Peak Demand Charges & Load Factor Analytics

Energy bills do not just charge for total energy volume (kWh or therms); commercial electric rate schedules are highly complex financial tariffs where peak power demand and timing dictate costs.

1. Consumption Charges vs. Demand Charges

Commercial electric bills are bifurcated into two primary cost buckets:

• Energy Consumption Charge ($/kWh): The total volumetric quantity of electrical energy consumed over the billing cycle.
• Peak Demand Charge ($/kW): The highest rate of electrical power drawn by the facility during any single 15-minute or 30-minute rolling interval during the billing month. In commercial facilities, demand charges often constitute 30% to 50% of the entire monthly electric bill ($15 to $35 per kW).

2. The Demand Ratchet Penalty

A demand ratchet clause is a punitive tariff mechanism enforced by utilities to recover transmission and distribution capacity costs. Under a typical 85% summer ratchet, the billed demand during any month of the year cannot be less than 85% of the highest peak demand recorded during the preceding summer billing season (June through September).

Example: If a building sets a catastrophic 15-minute peak demand of 1,200 kW on a hot August afternoon due to simultaneous chiller startups and air handler staging, its ratchet baseline becomes $1,200 \times 0.85 = 1,020\text{ kW}$. In January, even if the building operates efficiently and draws only 450 kW of actual peak demand, the utility will bill the customer for 1,020 kW. A single operational mistake during peak summer can penalize the building's utility budget for the subsequent 11 consecutive months!

3. Time-of-Use (TOU) & Power Factor Penalties

• Time-of-Use (TOU) Windows: Electricity rates are partitioned into On-Peak, Mid-Peak, and Off-Peak hours. On-peak kWh rates can be 3 to 5 times higher than off-peak rates. EBCx strategies focus on precooling the building during off-peak morning hours and soft-unloading central plants during peak afternoon windows.
• Power Factor ($PF$) Penalties: The ratio of real power (kW) to apparent power (kVA): $PF = \frac{\text{kW}}{\text{kVA}} = \cos(\theta)$ Inductive loads (lightly loaded induction motors, uncorrected fluorescent ballasts, transformer magnetization) draw reactive power (kVAR). Utilities penalize customers whose power factor drops below 0.85 to 0.95 because it forces the utility to oversize distribution conductors and transformers.

4. Electrical Load Factor Analysis

The facility Load Factor ($LF$) is an indispensable diagnostic ratio that evaluates how effectively a building utilizes its electrical demand:

$LF = \frac{\text{Actual Monthly Consumption (kWh)}}{\text{Peak Demand (kW)} \times \text{Billing Hours in Month}}$

Where billing hours in a standard 30-day month = $30 \times 24 = 720\text{ hours}$.

Load Factor Spectrum & EBCx Diagnostic Indications:
┌─────────────────────────────────────────────────────────────────────────────┐
│ LOW LOAD FACTOR (0.25 to 0.45)            HIGH LOAD FACTOR (0.70 to 0.90)   │
├───────────────────────────────────────────┬─────────────────────────────────┤
│ • Spiky, erratic demand profile.          │ • Flat, uniform demand profile. │
│ • Massive peaks relative to average load. │ • High continuous 24/7 load.    │
│ • Diagnostic Focus: Morning hard-starts,  │ • Diagnostic Focus: Base-load   │
│   uncoordinated chiller staging, lack of  │   reductions, nighttime setback │
│   demand limiting, lack of soft-starts.   │   failures, equipment left ON.  │
└───────────────────────────────────────────┴─────────────────────────────────┘

A low load factor ($LF < 0.45$) immediately directs the CxP to inspect equipment staging schedules, morning warm-up/cool-down routines, and demand-limiting sequences to shave spikes. A high load factor ($LF > 0.80$) in a standard single-shift office building warns the CxP that systems are failing to enter nighttime setback, running continuously around the clock.

---

Utility Bill Analysis & Tariff Structure Matrix

The following matrix outlines the primary commercial tariff structures, diagnostic interpretations, and targeted EBCx optimization strategies:

---

Conducting Structured Operator & Occupant Interviews

While utility data and regression models reveal what energy a facility consumes, they cannot explain why systems behave abnormally. That insight resides almost exclusively in the minds of the on-site facility operating engineers, maintenance technicians, and building occupants.

The Psychology and Strategy of Operator Interviews

Operating personnel are frequently skeptical of external commissioning consultants. Technicians often fear that the CxP's role is to scrutinize their work, expose mistakes to ownership, or recommend automated solutions that threaten their jobs. A seasoned BCxP approaches interviews not as an auditor or inquisitor, but as an engineering ally and advocate.

• Conduct interviews on the operator's home turf: in the boiler room, chiller plant control office, or maintenance shop.
• Establish upfront that the objective is to secure the resources, tools, and contractor support that the operating staff have needed for years to fix long-standing problems.
• Inquire about their daily frustrations: "What piece of equipment do you have to baby-sit the most? What alarms do you silence every morning? Where are the coldest and hottest complaints in the building?"

Uncovering Hidden Operational Work-Arounds

Structured interviews consistently unmask operational defects invisible on BAS workstation graphics:

1. Manual Linkage Bypasses: An operator may reveal that an outside air damper linkage was mechanically disconnected with vice-grips and wired 50% open because the electronic actuator stripped its gears two years ago.
2. Defeated Automation Sequences: Chilled water supply temperature reset sequences may have been manually overridden to a flat 42°F because a 3rd-floor executive corner office complained of high humidity during a single thunderstorm three years prior.
3. Seasonal Valve Overrides: Manual three-way bypass valves on primary chilled water headers left cracked open 25% since the previous summer's maintenance overhaul, inducing severe Low $\Delta T$ Syndrome.
4. Ghost Equipment Schedules: Central air handlers programmed to run 24/7 because cleaning crews requested lighting at 11:00 PM, and the legacy automation system tied lighting relay controls to fan motor contactors.

Occupant Comfort Surveys

Complementing operator interviews, the CxP distributes structured occupant comfort surveys across facility departments. Occupants provide empirical data on:

• Chronic thermal discomfort (distinguishing perimeter solar-load complaints from interior airless stagnation).
• Drafts and acoustic noise (e.g., diffuser whistling caused by duct overpressurization).
• Odor migration and stuffiness (identifying negative building pressurization drawing sewer gas or loading dock diesel fumes into fresh air intakes).

---

Structured Operator Interview Protocol & Diagnostic Follow-Up

The following protocol guides the BCxP through structured technical interviews, highlighting common red flags and defining mandatory field verification actions:

---

Mining CMMS Work Orders & Reviewing Record Documentation

The final element of historical data collection involves auditing the facility's Computerized Maintenance Management System (CMMS) database and legacy physical documentation:

1. CMMS Work Order Pattern Analysis

Mining three years of CMMS service tickets reveals systemic equipment failure patterns that operators may overlook during interviews. The CxP categorizes work orders by equipment asset tag, failure code, and physical location:

• A high concentration of work orders for "replace VAV box reheat actuator" indicates severe control loop hunting or excessive differential pressure across the valve body.
• Frequent work orders for "reset freeze-stat" indicate poor mixed-air plenum blending, severe thermal stratification, or leaking outdoor air dampers.
• Chronic work orders for "clearing condensate drain pan overflow" signal improper P-trap dimensions, negative plenum pressure blowing trap seals, or blocked drain lines.

2. Auditing Existing Drawings and Sequences of Operation

The CxP must collect and cross-examine:

• Original mechanical, electrical, and plumbing (MEP) as-built drawings.
• Original Testing, Adjusting, and Balancing (TAB) reports.
• Equipment manufacturer cut-sheets and O&M manuals.
• The written Sequence of Operations (SOO) from the original controls submittal.

Crucially, the CxP must never assume that what is written on an as-built drawing reflects field reality. In older buildings, piping cross-ties have been added, ductwork abandoned, control lines severed, and control sequences rewritten hundreds of times. Legacy documentation serves solely as a reference hypothesis that must be rigorously verified during the physical field investigation.