Choosing The Best Utility Bill Tracking Software
ABSTRACT
ABSTRACT
Today's utility bill tracking software can deliver excellent results for energy managers who want to gain a comprehensive understanding of utility usage and costs in their facilities. All of the major commercially available utility bill tracking software programs are good at what they do, however, they are distinctly different in functionality and capacity.
Savvy energy managers have discovered - sometimes the hard way - the importance of selecting the appropriate software package to meet their needs. Before reviewing software packages, it is best to understand the needs of your organization and the resources available. Then you can compare each program's capabilities (such as budgeting and forecasting, temperature correction, rate analysis, report generation, etc.) against your needs.
Making the wrong choice can result in wasted time and hours of frustration, or worse - dissatisfied clients or management.
This paper will help you to identify what tasks you want to accomplish with your utility bill tracking software.
WHY NOT JUST USE SPREADSHEETS?
If you are tracking energy usage and costs for a handful of meters, a spreadsheet may be adequate; however, if you are tracking for a large organization with many facilities, or tracking savings from energy efficiency measures, then commercial energy accounting software may be the best and easiest way to track your utilities. Table 1 presents some positive and negative aspects of using spreadsheets:
TABLE 1. POSITIVE AND NEGATIVE ASPECTS OF USING SPREADSHEETS
Positive Aspects
Negative Aspects
Spreadsheets are inexpensive. You probably already own Excel, and thus pay nothing for the software.
Tracking large numbers of accounts can greatly complicate the spreadsheet, sometimes to the point of absurdity.
You can create exactly the report you want in a spreadsheet.
If you have a bug in the spreadsheet, you may never discover it, since very few people would use the spreadsheet, whereas canned software is used by hundreds of users who ferret out all the bugs.
You can understand every calculation in a spreadsheet (at least initially) since you put the calculations there in the first place.
If you are calculating energy savings from energy projects, then it is likely you are using methods not acceptable by ASHRAE Guideline 14, the IPMVP, and FEMP Guidelines.
Since most people know how to use spreadsheets already, there is no necessity for training.
Other people may have a difficult time understanding how you derived your calculated results.
If you are tracking energy savings for clients, it is best to use standard methodology in standard third-party commercial software in order to present what appears to be (and hopefully is) unbiased and above-board results.
INTRODUCTION TO UTILITY BILL TRACKING SOFTWARE
All the major utility bill tracking software packages are good at what they do. However, they are all different and have different capabilities. Although you can track your utility bills effectively in any of the software packages, depending upon what your specific needs are, there is likely a program that is more suited to your needs than the others. Choosing the correct software package the first time can save you hours of work, and help you avoid the frustration of discovering too late that it does not produce what you wanted.
NARROWING DOWN THE SCOPE OF OUR ANALYSIS
In order to narrow down the scope of this presentation, we have made two rough classifications, which are detailed below. This paper covers desktop (not web-based) utility bill (not interval data) software programs.
Web vs. Desktop Applications
Using the web to track your energy usage is useful for large organizations. Large companies dispersed around the globe can enter their utility usage, and see reports comparing the usage in Lubbock to the usage in London. Central energy managers can then easily allocate energy costs across the enterprise and locate high usage facilities and concentrate efforts there. However, enterprise web applications are usually relatively expensive and often offer only basic analysis functionality. There are a great number of web applications available, most of which focus on interval (e.g. 15-minute) data.
There are also some internet bill tracking services that are relatively inexpensive. These applications will present your data to you on the web in a number of ways, but at present appear to be limited in analytical capacity and functionality. For example, these web services typically will not weather normalize utility data, which results in faulty year over year comparisons of utility bills. These web services are not addressed in this paper.
There are only a handful of utility bill software programs in the desktop market. Desktop applications usually offer more sophisticated analysis than their web brethren, and usually at a much-reduced price compared to web software. Many desktop packages offer some interface to the internet, such as downloading bill, interval or weather data, and creating html reports.
Interval Data vs. Utility Bills
Although there is considerable value to be found in analysis of interval data, there do not appear to be enough interval data experts to go around. Some organizations have paid hundreds of thousands of dollars for interval data enterprise software, only to have it go unused, often due to lack of trained and available staff that can gain meaningful information from it.
Interval data can be used for several purposes, some of which are listed below:
Determining when equipment is turned on and off
Discovering and diagnosing equipment and controls problems,
Load shedding,
Aggregating energy usage across an enterprise into load profiles which can be used when procuring energy supply contracts,
Applying rates to the interval data to get a better understanding of the hourly cost of running the facility.
Viewing utility bills in monthly (or billing) increments is a simpler discipline which is more comprehensible to management, more familiar to energy professionals, and more commonly practiced. Plenty of useful information about a facility can be gleaned from utility bills, some of which are listed below:
Determining whether the facility is saving energy and utility costs
Identifying the most wasteful facilities
Identifying controls and equipment problems
Budgeting and Forecasting
Understanding where utility costs are going
Performing rate analysis
Verifying that the utilities are billing correctly
Identifying changes in facility usage patterns
As the topic of this paper is Utility Bill Tracking, we will not cover interval data analysis here, however it is important to note that some desktop packages can handle both your utility bill and interval data, and can reconcile your utility bills with interval data.
SOFTWARE SELECTION CRITERIA
Perhaps the best method of determining the software program for your specific needs and budget is to clarify what you would want to use the software to accomplish. Below we have listed some of the tasks that utility bill tracking software can help you perform.
There is a comprehensive questionnaire at the end of this paper which will help optimize your software criteria.
Are you more interested in utility accounting or energy analysis and saving energy?
Do you need to identify the most inefficient facilities?
Do you need to measure energy savings from your energy conservation projects or from performance contracts?
Do you need to streamline your utility bill payment system?
Do you need to create an incentive system to encourage employees to save energy?
Do you need to verify that your utility bills are correct?
Do you need to allocate costs from master meters to submeters and subsidiary accounts?
Do you need to identify anomalous changes in utility usage?
Do you need to understand the relationship between production at your factory (or occupancy at your hotel, etc.) and utility usage?
Do you need to create budgets and track your utility costs against the budgeted costs?
Do you need to evaluate different rate structures on your utility data to find the best rate?
Once you have determined your specific needs and budget, you can identify which software features are necessary accomplish these tasks. This section lists features and selection criteria with which you can sift through the software programs to find the one best suited to your needs.
Capacity: How Large A Project Will You Be Working With?
The software packages currently available represent a wide range of capacity - from a low end of several hundred meters to a high end of nearly unlimited accounts. If you are putting together a utility bill tracking project with thousands of meters, then the smaller software packages may not be applicable. Some of the desktop packages have SQL databases that can handle virtually an unlimited number of accounts. Some energy managers get around the database size limitations of the smaller desktop packages by keeping several databases, each corresponding to a different section of the organization. If you are responsible for hundreds or thousands of meters, you might find that it is not necessary to track all of your meters. Tracking fire protection and street lighting meters may not result in any analytic value at all.
Energy Accounting Method: Year to Year Comparison vs. Temperature Correction
There are different ways to view your utility data. You can compare your usage from year to year to see if you are using more or less energy, or you can correct your energy usage for weather data, or other factors, such as occupancy or production.
If you compare utility usage from year to year, you can quantify the change in usage and costs. However, you cannot tell if the change is due to fluctuations in weather, changes in rate, changes to the facility itself (such as new additions, new equipment, or extra shifts), or due to reduction or increase in energy usage (which is what you are trying to determine). Energy analysts often prefer to normalize their data to weather, so that they remove these factors, and get a truer picture as to whether the facility is using more or less energy than it used to. Without weather normalization, they may not be able to tell if their project is truly saving energy, or instead, if the change in weather from year to year is responsible for changes in utility usage. This same type of normalization can be done with other factors as well, such as production, occupancy or calendar.
Be aware as well, not all weather normalization is the same. Some software packages will have extensive normalization capacity, which allows energy analysts to extract the maximum from their utility bills, whereas other programs offer very little in reporting or analysis along this line, treating normalization as an afterthought.
Ease of Use
Most of the programs are relatively simple for such tasks as data entry and report generation. These simple tasks can usually be performed by clerical workers. However, the more complex tasks are best executed by energy professionals. These more complex tasks (such as weather correction, budgeting and forecasting, creating custom reports, modeling rates, etc.) are associated with concepts (such as demand, ratchets, weather regression, and prorating) that may require some technical knowledge and analytical skills. Untrained staff may be able to run the more complex software routines but may be unable to assess the reasonableness of the approach or results.
Knowing that the more complex tasks may be more difficult to learn, it is probably best to judge general ease of use on the simple tasks, such as laying out your site and account information, entering bill data, and producing reports. The more complex functions, such as modeling rates, weather normalization, or budgeting and forecasting, by their very nature, will be more difficult in all programs. Some people are intimidated by these features in the more sophisticated programs thinking that they are just too difficult. Remember, you can grow into these advanced features in time, just as most of us did with MS Excel. In fact, it is probably a wise long-term decision to purchase software that has some features you don't yet understand, as then you have reason and tools with which to grow, and increase your skills.
Before buying the software, it would be best to take a "test drive" and see how intuitive the user interface is.
General Orientation: Energy vs. Accounting
Some software packages are more oriented towards accounting than analysis. Accounting programs will stress things such as entering all charges in the bill (which sometimes can be more than 6 different line items per bill), interfacing with accounting systems, aggregating data for payment, and creating bills for your tenants. Analysis programs will stress weather normalization, allow you to identify and cast out anomalous bills from your analysis, provide graphs displaying the relationship between weather (or production, etc.) and usage, and generally are mostly concerned only with usage, demand and total cost, but not all the little charges on the utility bill that make up the total cost. If your background is accounting, and not energy, then you will likely be more comfortable with an accounting-oriented program, rather than an analysis oriented program. If your background is energy, you will likely be more comfortable with an energy analysis-oriented program.
Interfacing With Your Accounting System
Some software packages can interface with Accounts Payable for bill payment. Typically utility bills for a utility vender are aggregated and then can be exported for Accounts Payable. Some packages will create an export in any format you choose to accommodate existing accounting procedures.
Importing and Exporting Data
All software packages offer import and export of data. Usually you will have to properly format your data before importing it. Some packages will allow you to import data from the text format in which you receive it from the utility. This custom import format is usually created by the software provider or a consultant.
Baseline Modifications
Buildings occasionally change their usage patterns. These changes can lessen the usefulness of annual comparisons of usage and costs. For example, if you were trying to track savings on a building for which you had installed energy efficient lighting, and if the building subsequently adds a new computer lab (or a new addition, or a third shift) your building usage may increase. If you were trying to determine whether the building was saving energy from your lighting retrofit, you would no longer be able to separate out the reduction in usage from the lighting from the increase in usage from the new computer lab. Some software packages will allow you to make "modifications" to the baseline to account for the new computer lab (or new addition, third shift, etc.), which then allows you to determine what savings, if any, are attributable to the lighting retrofit.
Rate Analysis
There are four main reasons analysts may want to include rate analysis in their utility bill tracking project:
To assure that costs are correctly applied to changes in usage and demand. Since using blended rates can introduce large errors, modeling rates is the most accurate method of assigning costs to usage and demand.
To verify that the utility is costing bills correctly.
To assign some agreed upon cost to utility usage and demand, such as is sometimes done in performance contracting, or
To determine which rates are best suited for your accounts.
To analyze rates, the utility rate must be entered into the program. This can be done by the analyst himself, a consultant, or oftentimes by the software provider. Many utility rates have become very difficult even for energy professionals to decipher. If you are planning on performing rate analysis in your organization, you might want to have a plan for who is going to enter the rate into your software, as this sometimes can become time consuming.
Not all desktop software packages can model utility rates, and of those that can, some may be limited in how detailed a rate can be modeled. If you want to investigate rate issues, then determine if your own rate schedules involve provisions such as demand ratchets, fuel surcharges, time of use periods, load factor tiers, etc. and then see if the softwares you are looking at can handle these provisions.
Allocating Costs to Submeters
Some analysts use their utility bill accounting software to allocate costs from master meters to submeters or subsidiary accounts. For example, a mall that charges each different tenant for their energy usage could use the software to allocate costs and usages based upon submeter readings (or other criteria such as square feet), and then create bills for the different departments.
Reporting
Once you know what tasks you intend to accomplish with your utility bill tracking system, you should have a fairly clear idea of the type of reports that will be required to fulfill these tasks. However, the quality of reports, and the ease of creating reports varies from program to program. In addition, in most programs the reports are in crystal reports, or some other canned format in which the data and the reports are not easy to modify. Countless users of one package used to create reports, then export them to Excel, then manipulate the reports to get them just so.
Emissions
Reporting on emissions (CO2, CO, NOx, etc.) being released into the atmosphere is becoming more popular. While most energy managers think it terms of usage and dollars, management may be also interested in reporting CO2 reductions to shareholders or the media.
Software Cost
The utility bill tracking programs currently available are priced from about $8,000 to about $90,000.
In addition, you might want to consider the cost to set up your database, which is usually extra. If you are busy, then the easiest and perhaps best method of starting your utility tracking database is to have an expert set it up for you. That way you can learn the program little by little as you enter data and make reports, while still having time to do the rest of your job.
Services
Consider your vendor as well. There are different types of vendors. What is their overall orientation? Is your vendor grounded in energy efficiency or energy accounting, or is your vendor primarily involved in j
by: John Avina
So Why Buy Wind Turbine And Solar Energy Devices? Cgg News : Cool Car Fm Transmitter Holder 3 In 1 Kit For Iphone / Ipod Review. New 2010 Traffic Crash Data For Genesee County Michigan And Surrounding Cities. Extreme Couponing - How You Are Notified Of Your Winnings How To Use A Comb Binding Machine Fue Technique: Newest For Hair Transplant How To Keep Your Address Private Hand Primer Pump: A Wonderful Way To Go And Take Away Water Disability Benefits: Simple Explanation Of Rsdi The New Sony Bdp-s580 Review - Among The Best Blu-ray Player For 2011 Husqvarna Lawn Mower Review: Hu700l Honda Gcv160 Gas Powered Mower What Is A Tankini And Why Would I Wear One? Fabulous Kinds Of Zucchini Bread