Three Powerful Utility Bill Analysis Methods For the Energy Manager

ABSTRACTfacility.
Utility Bill Tracking systems are at the center ofLike Benchmarking, you can determine your own
an effective energy management program.rules of thumb for your buildings, however, your
However, some organizations spend time andrange of acceptable Load Factors will vary based
money putting together a utility bill trackingupon building type and climate. Rules of Thumb
system and never reap any value. This papermay not be that helpful though. Like
presents three utility bill analysis techniques whichBenchmarking, just identifying the buildings with
energy managers can use to arrive at soundunusually high and low Load Factors, relative to
energy management decisions and achieve costthe other buildings in the portfolio, should be
savings.sufficient.
INTRODUCTIONLoad Factor Summation
Utility bill tracking and analysis is at the center ofLoad Factor can be used to identify billing and
rigorous energy management practice. Reliablemetering errors, buildings that are not turning off
energy management decisions can be madeequipment, and buildings with suspiciously high
based upon analysis from an effective utility billdemands. While Benchmarking can identify buildings
tracking system. From your utility bills you canmost likely to yield large energy efficiency
determine:payoffs, Load Factor Analysis can point to easily
- whether you are saving energy or increasingresolved scheduling and metering issues.
your consumption,WEATHER NORMALIZATION
- which buildings are using too much energy,Another important utility bill analysis method is to
- whether your energy management efforts arenormalize utility bills to weather. Weather
succeeding,Normalization allows the energy manager to
- whether there are utility billing or meteringdetermine whether the facility is saving energy or
errors, andincreasing energy usage, without worrying about
- when usage or metering anomalies occur (ie.weather variation.
when usage patterns change)Suppose an energy manager replaced the existing
Any energy management program is incompletechilled water system in a building with a more
if it does not track utility bills. Equally, any energyefficient system. He likely would expect to see
management program is rendered less effectiveenergy and cost savings from this retrofit.
when its utility tracking system is difficult to useA quarter-million dollar retrofit is difficult to justify
or does not yield valuable information. In eitherwith results like this. And yet, the energy
case, fruitful energy savings opportunities are lost.manager knows that everything in the retrofit
Many practical energy managers make the smartwent as planned. What caused these results?
choice and invest in utility bill tracking software,Clearly the energy manager cannot present these
but then fail to recover their initial investment inresults without some reason or justification.
energy savings opportunities. How could this be?Management may simply look at the figures and,
This paper introduces three simple and usefulsince figures don't lie, conclude they have hired
procedures that can be performed with utility billthe wrong energy manager!
tracking software. Just performing and actingThere are many reasons the retrofit may not
upon the first two types of analysis will likely savehave delivered the expected savings. One
you enough money to pay for your utility billpossibility is that the project is delivering savings,
tracking system in the first year. The three topicsbut the summer after the retrofit was much
are Benchmarking, Load Factor Analysis, andhotter than the summer before the retrofit.
Weather Normalization as shown in Table 1.Hotter summers translate into higher air
BENCHMARKINGconditioning loads, which typically result in higher
Let's suppose you were the new energy managerutility bills.
in charge of a portfolio of school buildings for aHotter Summer -> Higher Air Conditioning Load
district. Due to a lack of resources, you cannot-> Higher Summer Utility Bills
devote your attention to all the schools at theIn other words, the new equipment really did
same time. You must select a handful of schoolssave energy, because it was working more
to overhaul. To identify those schools most inefficiently than the old equipment. The figures
need of your attention, one of the first thingsdon't show this because this summer was so
you might do is find out which schools were usingmuch hotter than last summer.
too much energy. A simple comparison of TotalIf the weather really was the cause of the higher
Annual Utility Costs spent would identify thoseusage, then how could you ever use utility bills to
buildings that spend the most on energy, but notmeasure savings from energy efficiency projects
why.(especially when you can make excuses for poor
Benchmarking Different Categories of Buildingsperformance, like we just did)? Your savings
When benchmarking, it is also useful to onlynumbers would be at the mercy of the weather.
compare similar facilities. For example, if youSavings numbers would be of no value at all
looked at a school district and compared all(unless the weather was the same year after
buildings by $/SQFT, you might find that theyear).
technology centers administration buildings were atOur example may appear a bit exaggerated, but
the top of the list, since administration buildingsit begs the question: Could weather really have
and technology centers often have moresuch an impact on savings numbers?
computers and are more energy intensive thanIt can, but usually not to this extreme. The
elementary schools and preschools. These resultssummer of 2005 was the hottest summer in a
are expected and not necessarily useful. For thiscentury of record-keeping in Detroit, Michigan.
reason, it might be wise to break your buildingsThere were 18 days at 90degF or above
into categories, and then benchmark just onecompared to the usual 12 days. In addition, the
category at a time.average temperature in Detroit was 74.8degF
Different Datasetscompared to the normal 71.4 degF. At first
You can benchmark your buildings against eachthought, 3 degrees doesn't seem like all that
other (as we did in our example) or againstmuch; however, if you convert the temperatures
publicly available databases of similar buildings into cooling degree days, the results look dramatic.
your area. Energy Star's Portfolio Manager allowsJust comparing the June through August period,
you to compare your buildings against others inthere were 909 cooling degree days in 2005 as
your region. Perhaps those buildings in yourcompared to 442 cooling degree days in 2004.
portfolios that looked the most wasteful are still inThat is more than double! Cooling degree days are
the top 50th percentile of all similar buildings inroughly proportional to relative building cooling
your area. This would be useful to know.requirements. For Detroit then, one can infer that
Occasionally, management decides that theiran average building required (and possibly
organization needs to save some arbitraryconsumed) more than twice the amount of
percentage (5%, 10%, etc.) on utility costs eachenergy for cooling in the summer of 2005 than
year. Depending upon the goal, this can be quitethe summer of 2004. It is likely that in the Upper
challenging, if not impossible. Energy managers canMidwestern United States there were several
use benchmarking to guide management in settingenergy managers who faced exactly this problem!
realistic energy management goals. For example,How is an energy manager going to show savings
our school district energy manager might decidefrom a chilled water system retrofit under these
to create a goal that the three most energycircumstances? A simple comparison of utility bills
consuming schools use only $0.80/SQFT. Sincewill not work, as the expected savings will get
this is about as much as the lowest energyburied beneath the increased cooling load. The
consuming schools are currently using, this couldsolution would be to apply the same weather data
be an attainable goal.to the pre- and post-retrofit bills, and then there
If you can find a dataset, you may also be ablewould be no penalty for extreme weather. This is
to benchmark your buildings against a set ofexactly what weather normalization does. To
similar buildings in your area and see the range ofshow savings from a retrofit (or other energy
possibilities for your buildings. In any case,management practice), and to avoid our
benchmarking will focus your energy managementdisastrous example, an energy manager should
efforts and provide realistic goals for the future.normalize the utility bills for weather so that
Rules of Thumbchanges in weather conditions will not compromise
New energy managers often search for a "rule ofthe savings numbers.
thumb" to use for benchmarking. An exampleMore and more energy managers are now
could be: "If your building uses more than $2normalizing their utility bills for weather because
SQFT/Year then you have a problem."they want to be able to prove that they are
Unfortunately, this won't work. Different types ofactually saving energy from their energy
buildings have different energy intensities.management efforts.
Moreover, different building locations will requireIn many software packages, you can establish
differing amounts of energy for heating andthe relationship between weather and usage in
cooling. In San Francisco, where temperatures arejust one click. Because the one-click "tunings" that
consistently in the 60s, there is almost no coolingthe software gives you are not always
requirement for many building types; whereas inacceptable, it does help to understand the
Miami, buildings will almost always require cooling.underlying theory and methodology so that you
Different building types, with their characteristiccan identify the problem tunings and make the
energy intensities, different weather sites, andnecessary adjustments. The more you know
different utility rates all combine to make it hardabout the topic the better. The section that
to have rules of thumb for benchmarking.follows explains in a little more detail the basic
However, energy managers whose portfolios areelements of weather normalization.
all close by, can develop their own rules of thumb.How Weather Normalization Works
These rules will most likely not be transferable toRather than compare last year's usage to this
other energy managers in different locations, withyear's usage, when we use weather normalization,
different building types, or using different utilitywe compare how much energy we would have
configurations.used this year to how much energy we did use
Benchmarking Buildings in Different Locationsthis year. Many in our industry do not call the
There are some complications associated withresult of this comparison, "Savings", but rather
benchmarking. Suppose you were the energy"Usage Avoidance" or "Cost Avoidance" (if
manager of a chain store, and you had buildings incomparing costs). Since we are trying to keep
different national locations. Then benchmarkingthis treatment at an introductory level, we will
might not be useful in the same sense. Would itsimply use the word Savings.
be fair to compare a San Diego store to aWhen we tried to compare last year's usage to
Chicago store, when it is always the rightthis year's usage, we saw disastrous results. We
temperature outside in San Diego, and always tooused the equation:
hot or too cold in Chicago? The Chicago store willSavings = Last year's usage - This year's usage
constantly be heating or cooling, while the SanWhen we normalize for weather, we use the
Diego store might not have many heating orequation:
cooling needs. Comparing at $/SQFT might helpSavings = How much energy we would have
decide which store locations are most expensiveused this year - This year's usage
to operate due to high utility rates and differentThe next question is how to figure out how much
heating and cooling needs.energy we would have used this year? This is
Some energy analysts benchmark using kBtuwhere weather normalization comes in.
SQFT to remove the effect of utility ratesFirst, we select a year of utility bills to which we
(replacing $ with kBtu). Some will take it a stepwant to compare future usage. This would
further using kBtu/SQFT/HDD to remove thetypically be the year before you started your
effect of weather (adding HDD), but adding HDDenergy efficiency program, the year before you
(or CDD) is not a fair measurement, as itinstalled a retrofit, or some year in the past that
assumes that all usage is associated with heating.you want to compare current usage to. In this
This measurement also does not take intoexample, we would select the year of utility data
account cooling (or heating) needs. Manybefore the installation of the chilled water system.
thoughtful energy managers shy away fromWe will call this year the Base Year .
benchmarking that involves CDD or HDD.Next, we calculate degree days for the Base
Different Benchmarking UnitsYear billing periods. Because this example is only
Another popular benchmarking method is to useconcerned with cooling, we need only gather
kBtu/SQFT (per year), rather than $/SQFT (perCooling Degree Days.
year). By using energy units rather than costs,Base Year bills and Cooling Degree Days are then
"rules of thumb" can be created that are notnormalized by number of days. Normalizing by
invalidated with each rate increase. In addition, thenumber of days (in this case, merely, dividing by
varying costs of different utility rates does notnumber of days) removes any noise associated
interfere with the comparison.with different bill period lengths. This is done
Benchmarking Summationautomatically by canned software and would need
Benchmarking is a simple and convenient practiceto be performed by hand if other means were
that allows energy managers to quickly assessemployed.
the energy performance of their buildings byTo establish the relationship between usage and
simply comparing them against each other using aweather, we find the line that comes closest to all
relative (and relevant) yardstick. Buildings most inthe bills. This line, the Best Fit Line, is found using
need of energy management practice are easilystatistical regression techniques available in canned
singled out. Reasonable energy usage targets areutility bill tracking software and in spreadsheets.
easily determined for problem buildings.The next step is to ensure that the Best Fit Line
LOAD FACTOR ANALYSISis good enough to use. The quality of the best fit
Once you have identified which buildings you wantline is represented by statistical indicators, the
to make more efficient, you can use Load Factormost common of which, is the R2 value. The R2
Analysis to concentrate your energyvalue represents the goodness of fit, and in
management focus towards reducing energy orenergy engineering circles, an R2 > 0.75 is
reducing demand.considered an acceptable fit. Some meters have
What Load Factor islittle or no sensitivity to weather or may have
Load Factor is commonly calculated by billingother unknown variables that have a greater
period, and is the ratio between average demandinfluence on usage than weather. These meters
and peak (or metered) demand. Average demandmay have a low R2 value. You can generate R2
is the average hourly draw during the billing period.values for the fit line in Excel or other canned
What Load Factor Meansutility bill tracking software.
High Load Factors (greater than 0.75) representThis Best Fit Line has an equation, which we call
meters that have nearly constant loads.the Fit Line Equation, or in this case the Baseline
Equipment is likely not turned off at night andEquation. The Fit Line Equation might be:
peak usage (relative to off peak usage) is low.Baseline kWh =
Low Load Factors (less than 0.25) belong to(5 kWh/Day * #Days ) + ( 417 kWh/CDD *
meters that have very high peak power draws#CDD )
relative to the remainder of the sample. TheseOnce we have this equation, we are done with
meters could be associated with chillers or electricthe regression process.
heating equipment that is turned off for much ofBase Year bills ~= Best Fit Line = Fit Line Equation
the day. Low Load Factors can also be associatedThe Fit Line Equation represents how your facility
with buildings that shut off nearly all equipmentused energy during the Base Year, and would
during non-running hours, such as elementarycontinue to use energy in the future (in response
schools.to changing weather conditions) assuming no
Load Factors greater than 1 are theoreticallysignificant changes occurred in building consumption
impossible , but appear occasionally on utility bills.patterns.
Isolated instances of very high or low LoadOnce you have the Baseline Equation, you can
Factors are usually an indicator of metering errors.determine if you saved any energy. How? You
One school, Tyler MS, consistently has a muchtake a bill from some billing period after the Base
lower Load Factor than the others (hoveringYear. You then plug in the number of days from
consistently around 20%). Low Load Factors canyour bill and the number of Cooling Degree Days
be ascribed to either very high peak loads orfrom the billing period into your Baseline Equation.
very low loads during other hours. In this case,Suppose for a current month's bill, there were 30
we cannot blame the Load Factor problem ondays and 100 CDD associated with the billing
"peaky" cooling loads, as the problem exists allperiod.
year. A likely cause can be that Tyler MS is doingBaseline kWh =
a better job at shutting off all lighting and other( 5 kWh/Day * #Days ) + ( 417 kWh/CDD *
equipment at night than the other schools. One#CDD )
school (Jackson MS) typically has higher LoadBaseline kWh =
Factors than the other schools. One reason may( 5 kWh/Day * 30 ) + ( 417 kWh/CDD * 100 )
be that lighting, HVAC and other equipment isBaseline kWh = 41,850 kWh
running longer hours than at Tyler MS.Remember, the Baseline Equation represents how
A good energy manager would investigate whatyour building used energy in the Base Year. So,
building operational behavior is contributing to thewith the new inputs of number of days and
low Load Factor values (and consequentlynumber of degree days, the Baseline Equation will
relatively high demand) for Tyler MS, and wouldtell you how much energy the building would have
investigate whether the demand could beused this year based upon Base Year usage
decreased. Inquiring about whether Jackson MS ispatterns and this year's conditions (weather and
turning off equipment at night is also advisable.number of days). We call this usage that is
Load Factor Rules of Thumbdetermined by the Baseline Equation, Baseline
Load Factor analysis is an art, not a science.Usage.
Different building types (i.e. schools, offices,Now, to get a fair estimate of energy savings,
hospitals, etc.) will have different Load Factorwe compare:
ranges. Since hospitals run many areas 24 hours aSavings = How much energy we would have
day, one might expect higher Load Factors thanused this year - How much energy we did use
for schools, which can turn off virtually everythingthis year
at night. Also many things contribute to aOr if we change the terminology a bit:
particular building's Load Factor. A building left onSavings = Baseline Energy Usage - Actual Energy
24 hours a day can still have a low Load Factor ifUsagewhere Baseline Energy Usage is calculated
there are large peaks each month - for example,by the Baseline Equation, using current month's
a 20 bed hospital that has a scheduled MRI truckweather and number of days, and Actual Energy
visit once each month. The MRI demand is large,Usage is the current month's bill.
and can greatly impact the Load Factor of a small