Presented ACEEE 1992
The Use Of Short-Term Measurements to Decompose Commercial Billing Data Into Primary End Uses
David Robison, Pacific Power
Howard Reichmuth, Lambert Engineering
Electricity billing data is a preferred measurement upon which to base estimates of conservation. It is a high quality measurement and is close to the customer's experience -- their own electric bill. The information is readily available to utilities. However, this type of data is inherently aggregated across end uses. It is difficult to use as an indicator of savings or as a check on building modeling. Combining a previous year's billing data with short term in measurements of two weeks duration, allows these data to be decomposed into four principal end uses. Billing data decomposed in this fashion lends itself to checking modeling results, confirming savings and assisting energy auditors in estimating potential savings.
Discussed are: (a.) Key short term measurement targets and the associated measurement techniques with emphasis on the use of small data loggers and event timers used to make such measurements in a production mode. (b) Analytical methods necessary to disaggregate billing data into primary end uses. (c) Classification of total energy use patterns by daytypes. (d) Estimates of non-seasonal lighting and other end uses. Monthly estimates of HVAC energy use are approximated by the difference between these end uses and the actual monthly billing data. These monthly HVAC estimates are correlated with heating and cooling degree-days to characterize the HVAC energy use. The methods are illustrated by a production application to different types of commercial buildings in parallel to a conventional audit to document the before and after retrofit electricity use.
Utilities prefer electricity billing data as the measurement upon which to base estimates of conservation benefits because it is a high quality measurement, and because it is close to the participating customer's experience - their own energy bill. Furthermore, the information is readily available to utilities as a simple "tension of their metering or load research. However authoritative, this type of data is inherently aggregated across end-uses. It is difficult to use in its raw form as an indicator of savings or as a check on building modeling due to uncertainties in building operation and scheduling. By combining a previous year's billing data and short term measurements (STM) of a few weeks duration, these data can be decomposed into principal end uses. Billing data decomposed in this fashion can be applied to check modeling savings and confirm savings. Such data assist auditors in estimating the customer's post retrofit consumption.
Recent improvements in the cost and performance of data acquisition equipment have greatly simplified the task of on-site measurements and the associated data analysis. These short-term measurements are brief measurements of a building's energy using systems intended to provide specific information about particular equipment or end uses. These measurements are made on-site in a few hours or using a data logger over a time span of up to a few weeks. Short term measurements in a commercial retrofit program help to:
I. Assist the audit. Increased knowledge of energy use at the site allows better determination of savings opportunities and more confidence in audit estimates.
2. Quantify and verify the achieved energy savings. Direct measurements verify key energy savings which are otherwise obscured by occupancy changes at the site.
Combined with the audit, short-term measurements can provide a complete picture of energy-use patterns at the site. STM can produce some types of information not available from an audit, such as equipment operating efficiency and specific end use consumption. Measurements provide accurate data on occupancy and equipment operating schedules which are usually estimated. For impact evaluation, STM can provide savings estimates more objectively and more explicitly than billing analysis. These measurements can provide documentation of savings otherwise unobtainable and specific information as to how and why the savings do or do not occur.
A potential limitation of STM is that measurements made in one season (winter) may not be applicable to the building in another season (summer). However, this limitation applies only to a portion -- usually less than one half -- of the building's energy use. Used with billing data, STM can isolate the seasonally variable component of the building energy use.
Other researchers have investigated the application of STM for quantifying savings. Jamison and Qualmann noted the problem in reconciling computer models to a limited set of actual measurements. Lansberg and Amalfi applied STM to measure non-seasonal lighting loads. Haberi et al. noted the application of decomposing whole building consumption to end uses using load shape methods. These studies have tended to be research level analyses of large, complex buildings. Waltz discussed simplified models of small buildings, reconciled to billing data. The current work differs from these studies by emphasis on a simplified method that can be applied routinely on a production basis to a large number of small buildings.
The key development goal is to reduce the cost of STM. Hardware costs have recently decreased dramatically with the development of numerous new metering products. (Pacific Science 1991, Reichmuth 1992). However, practical operation requires reducing the high labor cost associated with data acquisition and analysis. This has been achieved in the field by standardizing the procedures. Specific measurement tools and protocols are specified for key measurements. A standardized data analysis implements a simplified, general approach without attempting detailed review of the idiosyncrasies that tend to occur at each site.
Extrapolating a short-term measurement to a one-year period assumes that non-seasonal loads have a repeating occupancy cycle that can be confidently extrapolated. This assumption has been examined in one case by reviewing a building where hourly pre/post monitoring was available for the lighting end use. The question then is, if lighting consumption is estimated by a one-time 'snapshot" or end use breakdown at one point in time, how accurate would that "snapshot" be to annual consumption? For this case, the estimated lighting consumption agreed well with monitored consumption. During three months pre-retrofit, the "snapshot' estimate agreed within 2.6% for the total consumption or 3.3% mean absolute percent error
(MAPE) during the period. During five months post-retrofit, the estimate agreed within 2.4% total or 5.5% MAPE. This level of precision is well within the accuracy of field measurement and data normalizing techniques. Therefore, it is possible to extrapolate 'fixed" loads with reasonable confidence. The same conclusion was reached by other researchers. (Landsberg and Amalfi 1992.)
A fully rigorous means for extrapolating STM to an annual basis could involve many variables, each separately considered and applied. The statistical noise introduced by this approach is large enough to overcome any benefits of including all the explanatory variables. This suggests that reliance on the simplest annualizing techniques is likely be the most productive. Accordingly, only simple procedures are applied to identify seasonal-dependent load and correlate to weather variables.
Of more importance than maximizing precision of the estimates, is the need for consistency. A consistent estimation protocol allows savings estimates from early phases of a program to be comparable with savings estimates from later phases. Savings are the difference between the estimated annual energy use before and after the retrofit for the load associated with the subject ECM and normalized to a common occupancy condition. In the following protocol, the pre-retrofit energy use is normalized to post-retrofit occupancy conditions so that the current bill can be explained to the customer.
In the early stages of one commercial retrofit program, a sequence of short-term measurements is conducted pre/post on candidate buildings. These sequences proceed in parallel with the audit as a check on the delivered program service and as a means of increasing the program yield. The measurements must be made in a timely fashion with the audit. The measurement report is to be completed during the project's design phase so that suggested energy conservation measures (ECMS) can be included. Measurements can provide important feedback to the auditors to resolve uncertain estimates or to test new audit ideas.
After the initial phase, a limited subset of short-term measurements will be integrated into the audit and commissioning operations as a quality control feature. An increasing need for physical documentation of savings is anticipated. Currently, the most persuasive approach to this documentation is a hybrid approach employing billing data and selected field measurements. In the future, the capability to undertake the full array of short-term measurements would be maintained but used on a limited basis to develop program improvements and to perform statistical spot checks for evaluation.
The estimating protocol is summarized as follows:
The strength of STM lies in the hourly nature of the data collected. Our experience shows that two weeks of data for regular occupancy patterns (daytype analysis) to assess the comparability of the pre and post retrofit measurements. The necessity of at least two weeks has been noted. (Bronson, et al.,1992). These daytypes are also used as a basis for constructing energy use from a short term snapshot. Daytyping distinguishes between significantly different operating modes for the building. The daytype classification is based on the hourly duty cycle of an occupancy-driven load, such as the load on a major lighting circuit or the total load above a minimum threshold.
The annual estimation protocol restates the obvious: that the annual energy of a load is the load times its annual duration. The subtlety lies in designating loads and in collecting data that will allow measured load energy to be normalized to comparable pre/post occupancy conditions if necessary. The monitored load designations in every STM exercise are structured so that the savings for the ECMs can be estimated.
Loads are classified into four basic types according to variability. Table 1 summarizes the load types, together with the associated measurements needed to document energy savings. Specific measurement protocols are written for each load type. A type 3 measurement, for example, involves a seasonally varying load or more precisely, the sum of all seasonal variations. Type 3 loads are resolved by reference to monthly billing data. In most cases, there is only one significant type 3 load such as the HVAC load or a major refrigeration load. But there are cases such as an air-conditioned super market or a restaurant where the type 3 load will include multiple loads of interest. This requires additional measurements to separately monitor the loads.
As a practical matter, similar end uses are grouped into a block, such as total lighting end use. Sometimes the wiring in a building is so chaotic that end uses or even ECM circuits cannot be cleanly broken out. There are a potentially endless variety of measurement situations that could occur. The simplified technique does not attempt to define every possible contingency. The protocol simply specifies that four basic types of measurements will be used. It can be quite complex to normalize a type 3 load for both weather and occupancy. In the interests of simplicity, the savings associated with a type 3 load is reported only as the unnormalized gross savings. However, the key data necessary for subsequent weather normalization are collected and reported.
An example of this process is demonstrated in Figures 1 and 2. Figure 1 shows a typical daytype load shape derived for one building. The energy consumption is classified into four major end uses. The non-seasonal loads are considered to be relatively fixed throughout the year. (If occupancy or scheduling changes occur, these loads must be normalized for the changes.) When the fixed load assumptions are combined with the annual billing history, Figure 2 results. Figure 2 shows the variation throughout the year due as seasonal loads change. The variation in the seasonal loads can be treated with a simple regression model as shown in Figure 3. This regression model allows seasonal loads to be normalized for changes in weather, if desired. Estimated changes due to specific ECMs are incorporated into the appropriate end uses and used to derive an estimate of the post-retrofit consumption. The predicted consumption provides an improved savings estimate and a means to track the building performance.

Figure 1. Retail Building Weekday Load Shape

Figure 2. Retail Building Annual Energy End Uses

Figure 3. Retail Building HVAC Energy Regression
Table 1. Measurement Types for Annualized Load Estimate
|
Load Characteristics |
Load Type |
Measured Data |
Pre/Post Occupancy Documen-tation |
Demand Data |
Annualized Energy Estimators |
Note # |
Annual Reference Measure |
|
Constant Power |
Type 0 |
1.Connected load, L 2. Total Duration, D |
None, assume constant occupancy |
None |
QL=52*L*D |
|
QL |
|
Constant Power |
Type 1 |
1.Connected load, L 2. Hourly Dutycycle, Dn |
Pre/post daytype, Dn |
Load shape by daytype |
QL=52*L* week S Dn n=1 |
1 |
QL, daytype by load shape |
|
Varying Power |
Type 2 |
1.Hourly Load, QLn 2.Hourly Dutycycle, Dn 3.Peak Time, size |
Pre/post daytype, Dn |
Load shape by daytype |
QL=52*L* week S Dn n=1 |
1 |
QL, daytype by load shape |
|
Seasonally Varying Power |
Type 3 |
1.Hourly total Load, QTn 2.Hourly non-seasonal load, QCn 3.Monthly total energy from billings, QTm 4.Average Monthly Temperature, Tm 5.Peak time, Size |
Pre/post daytype, QCn or QTn |
Non-seasonal load shape by daytype Load shape by daytype Peak Time, Size |
All months QS=S QSm n=1
QS = total - QCn
Mth bill cycle QS=S QSm n=1
|
2 |
QS, daytypes by load shapes
QSm and Tm, average out temp. by month |
Measurement tools are summarized in Table 2.
Table 2. Summary of Measurement Types and Methods
|
Measurement Type |
Instrument/ System Used |
|
AC Power -- Service Entry Various single and three phase combinations |
Datalogger with CTs |
|
Pulse Meter |
Datalogger pulse counting input |
|
AC Power -- Branch Loads All Types |
Datalogger with appropriate CTs |
|
Lighting Loads |
Datalogger with switch scanner unit |
|
Temperature Indoor w Wireway |
Datalogger w AD592 sensor |
|
Other Indoor |
Stickon Datalogger |
|
Outdoor |
Datalogger w AD592 sensor |
|
HVAC Ducts |
Datalogger w AD592 sensor |
|
Meteorological Relative Humidity |
Datalogger w humidity sensor |
|
Solar Insolation |
Datalogger w pyrometer |
|
Wind Speed |
Datalogger frequency input, anemometer |
|
Flow (one-time tests) Hydronic Water |
Ultrasonic flow meter |
|
HVAC Airflow |
Flow Hood |
|
|
Calorimetric w resistance heater |
|
|
Pitot Scan |
|
Gas Usage |
Optical pulse initiator on meter |
|
|
Datalogger, thermocouple flame sensor |
|
|
Relay on gas valve |
Datalogger: Most short-term and some one-time data is collected using a data acquisition system designed for energy-use monitoring in buildings. With the appropriate sensors connected and channels defined, the datalogger continuously samples each sensor output, accumulates the results, and stores the hourly data for later transfer to computer files via direct connections or modem. Menu driven software provides access to current and stored data and set-up functions used to specify channel definitions, data storage intervals, etc.
Single-Channel Loggers: Battery powered single-channel data loggers of the "stick-on' type can monitor specific variables more cost effectively and conveniently. Types of loggers include lighting loggers which monitor lighting duty cycles with photocell sensing, and single channel power loggers, temperature loggers and status logger which monitor duty cycle rather than energy use.
One-time Test Equipment: Equipment available for one-time tests includes the switch scanner loggers and various air and water-flow measurement tools. Illumination sensors, a portable AC power measurement gun, electrical test equipment, and thermometers are used as needed.
Data Analysis Template: The data analysis spreadsheet template speeds the review, analysis, and presentation of the data collected. The various layers of the template include the datalogger channel tables, the hourly data, summary hourly data averaged by day type, graphs for data review, macros for data handling and other chores and finally a report output layer. Several graphs are automatically programmed to allow quick review of data quality. Examples are:
As mentioned, a key to implementation is standardization of the data review and analysis. A generic method is applied. It has the advantage that it can be implemented on a near-automated basis. The following steps describe the process:
1. Pre-retrofit procedure
2. Repeat the sequence after the retrofit. Normalize the pre-retrofit baseline to the post-retrofit occupancy conditions, if needed. Estimate savings as the difference between the pre and post-retrofit annual consumption estimates.
This operation produces three documentation reports:
In a typical case study, savings are estimated in Table 3. Note the difference between the auditor's estimate of ECM savings and that derived from STM. The auditors overestimated the amount of lighting and consequently, the savings from this end use. Savings from hot water conservation were underestimated. Total savings are close to the auditor's estimate, but distributed between end uses. Similar results are apparent in other buildings.
Table 3. Example of STM Savings Estimate
|
|
Pre-Retrofit Annual End User Estimate, kWh/yr |
Post-Retrofit Annual End User Estimate, kWh/yr |
Audit Savings Estimate, kWh/yr |
Annual STM Savings Estimate, kWh/yr |
|
Lighting |
4,068 |
2,699 |
3,203 |
1,369 |
|
Hot Water |
5,676 |
3,506 |
876 |
2,170 |
|
Total |
|
|
4,079 |
3,539 |
At this writing only four buildings have been through the full pre- and post-retrofit measurement cycle. For these buildings, the savings estimates based on STM and audits are compared in Table 4. Even this small sample of buildings reveals important changes in the estimates. In the warehouse, the existing condition was seriously underlit. Improved lighting levels were achieved with efficient fixtures. The higher amount of savings reflects the energy consumption that would have been required to obtain the same lighting level using inefficient fixtures. In the retail building, noticeable savings are due to the occupants becoming more conscious of energy consumption and reducing lighting usage accordingly. In the public building, measured savings are significantly higher because the schedule was determined to be a 17 hour day of the 12 hour day assumed by the audit. Measured savings for this limited set of buildings is about 75% larger than the audit estimates. In several other which only pre-retrofit measurements have significant savings opportunities been observed which would otherwise have escaped notice the audit or commissioning process.
Table 4. Audit and STM Savings Estimates, kWh/year
|
Building |
|
Inside Lights |
Outside Lights |
Hot Water |
Other |
|
Retail |
STM |
1,369 |
NA |
2,170 |
NA |
|
|
Audit |
3,203 |
NA |
876 |
NA |
|
Warehouse |
STM |
31,848 |
NA |
NA |
NA |
|
|
Audit |
5,725 |
NA |
NA |
NA |
|
Retail |
STM |
8,398 |
6,500 |
NA |
1,768 |
|
|
Audit |
0 |
8,875 |
NA |
945 |
|
Public |
STM |
144,924 |
NA |
NA |
NA |
|
|
Audit |
98,821 |
NA |
NA |
NA |
Based on current experience, costs to implement these estimated in Table 5. These cost estimates assume that there are at least three jobs/week, allowing a full-time technician to be assigned to the project. Projects to be located nearby to minimize travel cost. Costs are compared for the full building sequence and for series to isolate a single end use or ECM. In some cases, single end use tests can be integrated into the energy audit for further cost savings.
Table 5. Current Cost Estimate for STM
|
Independent Whole Building End Use |
|
|
|
Site Visit and Installation |
4 hrs @ $40/hr |
$160 |
|
Equipment and Data Retrieval |
3 hrs @ $40/hr |
$120 |
|
Data Checking and Entry |
3 hrs @ $40/hr |
$120 |
|
Data Review and Analysis |
4 hrs @ $60/hr |
$240 |
|
Report Preparation |
2 hrs @ $60/hr |
$120 |
|
Equipment Depreciation |
|
$40 |
|
Total
|
|
$800 |
|
Single ECM Measurements |
|
|
|
Site Visit and Installation |
2 hrs @ $40/hr |
$80 |
|
Equipment and Data Retrieval |
1.5 hrs @ $40/hr |
$60 |
|
Data Review and Report |
1.5 hrs @ $60/hr |
$90 |
|
Equipment Depreciation |
|
$15 |
|
Total
|
|
$245 |
|
Audit Integrated Single ECM |
|
|
|
Site Visit and Installation |
1 hrs @ $40/hr |
$40 |
|
Equipment and Data Retrieval |
1.5 hrs @ $40/hr |
$60 |
|
Data Review and Report |
0.5 hrs @ $60/hr |
$30 |
|
Equipment Depreciation |
|
$15 |
|
Total
|
|
$145 |
The benefit of STM arises from the value of improved energy savings estimates at the initial audit stage or later as part of commissioning new installations. Of twelve buildings, the measurements have not improved the initial audit estimates in six cases. However, in six other cases, useful feedback has been observed, allowing improved energy estimates. Two instances with a combined savings of over 100,000 kWh observed. Some of the most significant observations follow:
The work described here demonstrates the value of Short Term Measurements (STM) to improve auditor's estimates of energy savings. Auditors usually apply standard assumptions to estimate key operating parameters. Measurement of those parameters can improve the accuracy of the estimate. In about half of the cases, STM uncovered significant errors in audit assumptions.
Methods have been developed to perform field measurements and associated data analysis on a routine basis. The ability of this methodology to correctly estimate annual energy consumption based on measurements made at a single point in time has yet to be confirmed. Verification is underway but will require a full year's consumption history.
Significant cost reductions have been achieved for STM. The key features for reducing cost are to standardize field procedures and develop automated analysis procedures.
The following definitions are used in Table 1.
D = accumulated load duration in one week
Dn = fraction of hour that subject load was operating
L = connected load, true power measured at load or by difference when load is turned off and on
QCn = hourly energy of non-seasonal load either measured directly or measured by difference when load is turned off and on
QCm = monthly energy of non-seasonal load
QLn = hourly energy of load, true power or current ratioed to true power
QL = estimated annualized load energy
QSm = estimated monthly energy of seasonal load
QS = estimated annual energy of seasonal load
QTn = hourly energy of total load
QTm = monthly energy of total load
Tm = mean monthly outside air temperature
Pacific Power has funded the development of the tools and techniques. Lambert Engineering has provided capable field support.
Bronson, D. J., Hinchey, S. B., Haberl, J. S., O'Neal, D. L., "A Procedure for Calibrating the DOE-2 Simulation Program to Non-Weather-Dependent Measured Loads", ASHRAE Transactions, Volume 98, Part 1, 1992. ASHRAE, Atlanta, GA.
Haberi, J. S., Athar, A., Abbas, M., and Claridge, D. E., "Comparing Monitoring Protocols for Energy Retrofits", ASHRAE Transactions, Volume 98, Part 1, 1992. ASHRAE, Atlanta, GA.
Jamison, D., and Qualmann, R. L., "Computer Simulations/End-Use Metering or 'Can We Count On Energy Savings Estimates in Designing Demand-Side Programs?", ACEEE Proceedings, 10.105, 1990. ACEEE, Washington, DC.
Kinney, L. F., and Ucar, M., "A Cost-Effective Technique for Determining By-Measure Conservation Savings: Several Cold Nights May be Enough,' Energy Conservation Program Evaluation: Practical Methods, Useful Results, Proceedings Third International Conference, Chicago, 1987.
Landsberg, D. R. and Amalfi, J. A., "Monitoring Approaches for Energy Conservation Impact Evaluation", ASHRAE Transactions, Volume 98, Part 1, 1992. ASHRAE, Atlanta, GA.
Mazzuchi, R. P., "End-Use Profile Development From Whole-Building Data Combined with Intensive Short-Term Monitoring, " ASHRAE Transactions, Volume 98, Part 1, 1992. ASHRAE, Atlanta, GA.
Pacific Science, "1991 Survey of Metering Equipment,' EPRI Project RP2568-21, March, 1991.
Reichmuth, H., and Robison, D., "Innovations in Short- Term Measurement--Economical Alternatives to Long-Term Monitoring," ACEEE Proceedings, 10.211, 1989. ACEEE, Washington, DC.
Reichmuth, H., "Lights Loggers--Who Needs 'Em?', Home Energy, 9(2), March, 1992, P. 21-6.
Waltz, J. P., "Practical Experience in Achieving High Levels of Accuracy in Energy Simulations of Existing Buildings, " ASHRAE Transactions, Volume 98, Part 1,1992. ASHRAE, Atlanta, GA.
Download Paper 1. Word '97 file
© Entire site copyright 2001 by Stellar Processes, Inc.
All rights reserved.