This article is about “Excel normalization example”, we hope to bring more articles about “Excel normalization example” in the near future:
ABSTRACT
Utility Bill Tracking systems are at the center of an effective energy management program. However, some organizations spend time and money putting together a utility bill tracking system and never reap any value. This paper presents three utility bill analysis techniques which energy managers can use to arrive at sound energy management decisions and achieve cost savings.
INTRODUCTION
Utility bill tracking and analysis is at the center of rigorous energy management practice. Reliable energy management decisions can be made based upon analysis from an effective utility bill tracking system. From your utility bills you can determine:
- whether you are saving energy or increasing your consumption,
- which buildings are using too much energy,
- whether your energy management efforts are succeeding,
- whether there are utility billing or metering errors, and
- when usage or metering anomalies occur (ie. when usage patterns change)
Any energy management program is incomplete if it does not track utility bills. Equally, any energy management program is rendered less effective when its utility tracking system is difficult to use or does not yield valuable information. In either case, fruitful energy savings opportunities are lost.
Many practical energy managers make the smart choice and invest in utility bill tracking software, but then fail to recover their initial investment in energy savings opportunities. How could this be?
This paper introduces three simple and useful procedures that can be performed with utility bill tracking software. Just performing and acting upon the first two types of analysis will likely save you enough money to pay for your utility bill tracking system in the first year. The three topics are Benchmarking, Load Factor Analysis, and Weather Normalization as shown in Table 1.
BENCHMARKING
Let’s suppose you were the new energy manager in charge of a portfolio of school buildings for a district. Due to a lack of resources, you cannot devote your attention to all the schools at the same time. You must select a handful of schools to overhaul. To identify those schools most in need of your attention, one of the first things you might do is find out which schools were using too much energy. A simple comparison of Total Annual Utility Costs spent would identify those buildings that spend the most on energy, but not why.
Benchmarking Different Categories of Buildings
When benchmarking, it is also useful to only compare similar facilities. For example, if you looked at a school district and compared all buildings by $/SQFT, you might find that the technology centers administration buildings were at the top of the list, since administration buildings and technology centers often have more computers and are more energy intensive than elementary schools and preschools. These results are expected and not necessarily useful. For this reason, it might be wise to break your buildings into categories, and then benchmark just one category at a time.
Different Datasets
You can benchmark your buildings against each other (as we did in our example) or against publicly available databases of similar buildings in your area. Energy Star’s Portfolio Manager allows you to compare your buildings against others in your region. Perhaps those buildings in your portfolios that looked the most wasteful are still in the top 50th percentile of all similar buildings in your area. This would be useful to know.
Occasionally, management decides that their organization needs to save some arbitrary percentage (5%, 10%, etc.) on utility costs each year. Depending upon the goal, this can be quite challenging, if not impossible. Energy managers can use benchmarking to guide management in setting realistic energy management goals. For example, our school district energy manager might decide to create a goal that the three most energy consuming schools use only $0.80/SQFT. Since this is about as much as the lowest energy consuming schools are currently using, this could be an attainable goal.
If you can find a dataset, you may also be able to benchmark your buildings against a set of similar buildings in your area and see the range of possibilities for your buildings. In any case, benchmarking will focus your energy management efforts and provide realistic goals for the future.
Rules of Thumb
New energy managers often search for a “rule of thumb” to use for benchmarking. An example could be: “If your building uses more than $2/SQFT/Year then you have a problem.” Unfortunately, this won’t work. Different types of buildings have different energy intensities. Moreover, different building locations will require differing amounts of energy for heating and cooling. In San Francisco, where temperatures are consistently in the 60s, there is almost no cooling requirement for many building types; whereas in Miami, buildings will almost always require cooling. Different building types, with their characteristic energy intensities, different weather sites, and different utility rates all combine to make it hard to have rules of thumb for benchmarking. However, energy managers whose portfolios are all close by, can develop their own rules of thumb. These rules will most likely not be transferable to other energy managers in different locations, with different building types, or using different utility configurations.
Benchmarking Buildings in Different Locations
There are some complications associated with benchmarking. Suppose you were the energy manager of a chain store, and you had buildings in different national locations. Then benchmarking might not be useful in the same sense. Would it be fair to compare a San Diego store to a Chicago store, when it is always the right temperature outside in San Diego, and always too hot or too cold in Chicago? The Chicago store will constantly be heating or cooling, while the San Diego store might not have many heating or cooling needs. Comparing at $/SQFT might help decide which store locations are most expensive to operate due to high utility rates and different heating and cooling needs.
Some energy analysts benchmark using kBtu/SQFT to remove the effect of utility rates (replacing $ with kBtu). Some will take it a step further using kBtu/SQFT/HDD to remove the effect of weather (adding HDD), but adding HDD (or CDD) is not a fair measurement, as it assumes that all usage is associated with heating. This measurement also does not take into account cooling (or heating) needs. Many thoughtful energy managers shy away from benchmarking that involves CDD or HDD.
Different Benchmarking Units
Another popular benchmarking method is to use kBtu/SQFT (per year), rather than $/SQFT (per year). By using energy units rather than costs, “rules of thumb” can be created that are not invalidated with each rate increase. In addition, the varying costs of different utility rates does not interfere with the comparison.
Benchmarking Summation
Benchmarking is a simple and convenient practice that allows energy managers to quickly assess the energy performance of their buildings by simply comparing them against each other using a relative (and relevant) yardstick. Buildings most in need of energy management practice are easily singled out. Reasonable energy usage targets are easily determined for problem buildings.
LOAD FACTOR ANALYSIS
Once you have identified which buildings you want to make more efficient, you can use Load Factor Analysis to concentrate your energy management focus towards reducing energy or reducing demand.
What Load Factor is
Load Factor is commonly calculated by billing period, and is the ratio between average demand and peak (or metered) demand. Average demand is the average hourly draw during the billing period.
What Load Factor Means
High Load Factors (greater than 0.75) represent meters that have nearly constant loads. Equipment is likely not turned off at night and peak usage (relative to off peak usage) is low.
Low Load Factors (less than 0.25) belong to meters that have very high peak power draws relative to the remainder of the sample. These meters could be associated with chillers or electric heating equipment that is turned off for much of the day. Low Load Factors can also be associated with buildings that shut off nearly all equipment during non-running hours, such as elementary schools.
Load Factors greater than 1 are theoretically impossible , but appear occasionally on utility bills. Isolated instances of very high or low Load Factors are usually an indicator of metering errors.
One school, Tyler MS, consistently has a much lower Load Factor than the others (hovering consistently around 20%). Low Load Factors can be ascribed to either very high peak loads or very low loads during other hours. In this case, we cannot blame the Load Factor problem on “peaky” cooling loads, as the problem exists all year. A likely cause can be that Tyler MS is doing a better job at shutting off all lighting and other equipment at night than the other schools. One school (Jackson MS) typically has higher Load Factors than the other schools. One reason may be that lighting, HVAC and other equipment is running longer hours than at Tyler MS.
A good energy manager would investigate what building operational behavior is contributing to the low Load Factor values (and consequently relatively high demand) for Tyler MS, and would investigate whether the demand could be decreased. Inquiring about whether Jackson MS is turning off equipment at night is also advisable.
Load Factor Rules of Thumb
Load Factor analysis is an art, not a science. Different building types (i.e. schools, offices, hospitals, etc.) will have different Load Factor ranges. Since hospitals run many areas 24 hours a day, one might expect higher Load Factors than for schools, which can turn off virtually everything at night. Also many things contribute to a particular building’s Load Factor. A building left on 24 hours a day can still have a low Load Factor if there are large peaks each month – for example, a 20 bed hospital that has a scheduled MRI truck visit once each month. The MRI demand is large, and can greatly impact the Load Factor of a small facility.
Like Benchmarking, you can determine your own rules of thumb for your buildings, however, your range of acceptable Load Factors will vary based upon building type and climate. Rules of Thumb may not be that helpful though. Like Benchmarking, just identifying the buildings with unusually high and low Load Factors, relative to the other buildings in the portfolio, should be sufficient.
Load Factor Summation
Load Factor can be used to identify billing and metering errors, buildings that are not turning off equipment, and buildings with suspiciously high demands. While Benchmarking can identify buildings most likely to yield large energy efficiency payoffs, Load Factor Analysis can point to easily resolved scheduling and metering issues.
WEATHER NORMALIZATION
Another important utility bill analysis method is to normalize utility bills to weather. Weather Normalization allows the energy manager to determine whether the facility is saving energy or increasing energy usage, without worrying about weather variation.
Suppose an energy manager replaced the existing chilled water system in a building with a more efficient system. He likely would expect to see energy and cost savings from this retrofit.
A quarter-million dollar retrofit is difficult to justify with results like this. And yet, the energy manager knows that everything in the retrofit went as planned. What caused these results?
Clearly the energy manager cannot present these results without some reason or justification. Management may simply look at the figures and, since figures don’t lie, conclude they have hired the wrong energy manager!
There are many reasons the retrofit may not have delivered the expected savings. One possibility is that the project is delivering savings, but the summer after the retrofit was much hotter than the summer before the retrofit. Hotter summers translate into higher air conditioning loads, which typically result in higher utility bills.
Hotter Summer -> Higher Air Conditioning Load -> Higher Summer Utility Bills
In other words, the new equipment really did save energy, because it was working more efficiently than the old equipment. The figures don’t show this because this summer was so much hotter than last summer.
If the weather really was the cause of the higher usage, then how could you ever use utility bills to measure savings from energy efficiency projects (especially when you can make excuses for poor performance, like we just did)? Your savings numbers would be at the mercy of the weather. Savings numbers would be of no value at all (unless the weather was the same year after year).
Our example may appear a bit exaggerated, but it begs the question: Could weather really have such an impact on savings numbers?
It can, but usually not to this extreme. The summer of 2005 was the hottest summer in a century of record-keeping in Detroit, Michigan. There were 18 days at 90degF or above compared to the usual 12 days. In addition, the average temperature in Detroit was 74.8degF compared to the normal 71.4 degF. At first thought, 3 degrees doesn’t seem like all that much; however, if you convert the temperatures to cooling degree days, the results look dramatic. Just comparing the June through August period, there were 909 cooling degree days in 2005 as compared to 442 cooling degree days in 2004. That is more than double! Cooling degree days are roughly proportional to relative building cooling requirements. For Detroit then, one can infer that an average building required (and possibly consumed) more than twice the amount of energy for cooling in the summer of 2005 than the summer of 2004. It is likely that in the Upper Midwestern United States there were several energy managers who faced exactly this problem!
How is an energy manager going to show savings from a chilled water system retrofit under these circumstances? A simple comparison of utility bills will not work, as the expected savings will get buried beneath the increased cooling load. The solution would be to apply the same weather data to the pre- and post-retrofit bills, and then there would be no penalty for extreme weather. This is exactly what weather normalization does. To show savings from a retrofit (or other energy management practice), and to avoid our disastrous example, an energy manager should normalize the utility bills for weather so that changes in weather conditions will not compromise the savings numbers.
More and more energy managers are now normalizing their utility bills for weather because they want to be able to prove that they are actually saving energy from their energy management efforts.
In many software packages, you can establish the relationship between weather and usage in just one click. Because the one-click “tunings” that the software gives you are not always acceptable, it does help to understand the underlying theory and methodology so that you can identify the problem tunings and make the necessary adjustments. The more you know about the topic the better. The section that follows explains in a little more detail the basic elements of weather normalization.
How Weather Normalization Works
Rather than compare last year’s usage to this year’s usage, when we use weather normalization, we compare how much energy we would have used this year to how much energy we did use this year. Many in our industry do not call the result of this comparison, “Savings”, but rather “Usage Avoidance” or “Cost Avoidance” (if comparing costs). Since we are trying to keep this treatment at an introductory level, we will simply use the word Savings.
When we tried to compare last year’s usage to this year’s usage, we saw disastrous results. We used the equation:
Savings = Last year’s usage – This year’s usage
When we normalize for weather, we use the equation:
Savings = How much energy we would have used this year – This year’s usage
The next question is how to figure out how much energy we would have used this year? This is where weather normalization comes in.
First, we select a year of utility bills to which we want to compare future usage. This would typically be the year before you started your energy efficiency program, the year before you installed a retrofit, or some year in the past that you want to compare current usage to. In this example, we would select the year of utility data before the installation of the chilled water system. We will call this year the Base Year .
Next, we calculate degree days for the Base Year billing periods. Because this example is only concerned with cooling, we need only gather Cooling Degree Days.
Base Year bills and Cooling Degree Days are then normalized by number of days. Normalizing by number of days (in this case, merely, dividing by number of days) removes any noise associated with different bill period lengths. This is done automatically by canned software and would need to be performed by hand if other means were employed.
To establish the relationship between usage and weather, we find the line that comes closest to all the bills. This line, the Best Fit Line, is found using statistical regression techniques available in canned utility bill tracking software and in spreadsheets.
The next step is to ensure that the Best Fit Line is good enough to use. The quality of the best fit line is represented by statistical indicators, the most common of which, is the R2 value. The R2 value represents the goodness of fit, and in energy engineering circles, an R2 > 0.75 is considered an acceptable fit. Some meters have little or no sensitivity to weather or may have other unknown variables that have a greater influence on usage than weather. These meters may have a low R2 value. You can generate R2 values for the fit line in Excel or other canned utility bill tracking software.
This Best Fit Line has an equation, which we call the Fit Line Equation, or in this case the Baseline Equation. The Fit Line Equation might be:
Baseline kWh =
(5 kWh/Day * #Days ) + ( 417 kWh/CDD * #CDD )
Once we have this equation, we are done with the regression process.
Base Year bills ~= Best Fit Line = Fit Line Equation
The Fit Line Equation represents how your facility used energy during the Base Year, and would continue to use energy in the future (in response to changing weather conditions) assuming no significant changes occurred in building consumption patterns.
Once you have the Baseline Equation, you can determine if you saved any energy. How? You take a bill from some billing period after the Base Year. You then plug in the number of days from your bill and the number of Cooling Degree Days from the billing period into your Baseline Equation.
Suppose for a current month’s bill, there were 30 days and 100 CDD associated with the billing period.
Baseline kWh =
( 5 kWh/Day * #Days ) + ( 417 kWh/CDD * #CDD )
Baseline kWh =
( 5 kWh/Day * 30 ) + ( 417 kWh/CDD * 100 )
Baseline kWh = 41,850 kWh
Remember, the Baseline Equation represents how your building used energy in the Base Year. So, with the new inputs of number of days and number of degree days, the Baseline Equation will tell you how much energy the building would have used this year based upon Base Year usage patterns and this year’s conditions (weather and number of days). We call this usage that is determined by the Baseline Equation, Baseline Usage.
Now, to get a fair estimate of energy savings, we compare:
Savings = How much energy we would have used this year – How much energy we did use this year
Or if we change the terminology a bit:
Savings = Baseline Energy Usage – Actual Energy Usage
where Baseline Energy Usage is calculated by the Baseline Equation, using current month’s weather and number of days, and Actual Energy Usage is the current month’s bill.
So, using our example, suppose this month’s bill was for 30,000 kWh:
Savings = Baseline Energy Usage – Actual Energy Usage
Savings = 41,850 kWh – 30,000 kWh
Savings = 11,850 kWh
SUMMARY
Utility Bill Tracking is at the center of a successful energy management system, but the bills must be used for sound analysis for any meaningful reduction in energy usage. By applying three analysis methods presented here (Benchmarking, Load Factor Analysis, and Weather Normalization), the energy manager can develop insight which should lead to sound energy management decisions.
|
John Avina, President of Abraxas Energy Consulting, has worked in energy analysis and utility bill tracking almost 15 years. During his tenure at Thermal Energy Applications Research Center, Johnson Controls, SRC Systems, Silicon Energy and Abraxas Energy Consulting, Mr. Avina has managed the M&V for a large performance contractor, managed software development for energy analysis applications, created energy analysis software that is commercially for sale, taught over 200 energy management classes, created hundreds of building models and utility bill tracking databases, modeled hundreds of utility rates, performed numerous energy audits and set up and maintained M&V projects for a handful of 500 to 1000 unit big box store chains. Mr. Avina has a MS in Mechanical Engineering from the University of Wisconsin-Madison. He is a member of the American Society of Heating, Refrigerating and Air-Conditioning Engineers (ASHRAE), the Association of Energy Engineers (AEE), the American Solar Energy Society (ASES), and a Certified Energy Manager (CEM) and Certified Measurement and Verification Professional (CMVP).
Abraxas Energy Consulting performs energy audits and provides utility bill tracking, energy auditing, measurement and verification, retro-commissioning, utility bill auditing and other energy management services for its clients world-wide. In addition, Abraxas Energy Consulting provides a selection of utility bill tracking and interval data software packages for its clients. Abraxas Energy Consulting’s clients are ESCOs, energy consultants, governments, universities, hospitals, school districts, private industry and building owners.
Article Source:
http://EzineArticles.com/?expert=John_Avina
|
|
More info about Excel normalization example:
SQL Server normalization rules you must follow
Using normalization to establish a clean data model has its benefits. Find out what they are in this tip on normalization rules.
Validation of Automated Systems For The DNA Laboratory … – Forensic Magazine
The facility had successfully streamlined and automated the operations of DNA extraction, RT-QPCR analysis, normalization and STR PCR amplification setup, and multi … For example, the new protocol for the automated DNA extraction of reference …
OMIS 507 Course Materials
Logical to Physical Modeling and Normalization Example (Excel 2003 format) … VBA for Excel Materials…At Instructors Choice. Lab – Excel VB/Macro Exercises and Labs …
Normalization with examples – docstoc
Preview and download documents about Normalization with examples. Docstoc is a community for sharing professional documents, find free documents and …
3 Normal Forms Database Tutorial
… might try to capture the Invoice data in a spreadsheet, such as Microsoft Excel. … reasonably expect to answer such questions, we begin the normalization process. …
Recommendations for Data Analysis
Example of data normalization for assay efficiency. We have found Microsoft Excel to be … Note that in this example, counts in the absence of endogenous RNA are shown for the …
Winning Stats – Explained! – Stampede Blue
… complete with pictures and examples … the Normal Distribution, which looks a lot like the bell curve . It means that the probability is much higher near the average, and gets smaller as it gets farther from the average. For our example, it …
Ivailo Chakarov – Using Computer Applications
Database Normalization example. Mapping ER Models into Relations. Access 2007 Tutorial … ERD Example. The majority of resources included on this page have been created by Janet …
Excel Macro Installation Instructions
When normalization is finished, a new worksheet titled ‘normalized … For example, in Germany, commas are used as a decimal marker instead of the point. …
This post was mainly about Excel normalization example, you are welcomed to comment here about Excel normalization example.
Related Blogs
iploma … Placement Papers, Fresher Jobs, Walkins, Govt Jobs, Infosys, Wipro, TCS, HCL, Satyam Jobs …