Plaque It!
Sponsored by: Flash of Genius |
[0001] This application claims priority to U.S. Provisional Application No. 60/286,619 entitled BILLING ENGINE INCLUDING MISSOURI BILLING ENGINE, U.S. Provisional Application No. 60/286,676 entitled MAINTENANCE AND VERIFICATION TOOL KIT AND AUTOMATIC PROCESSING OF SERVER FILES, U.S. Provisional Application No. 60/286,561 entitled INFORMATION CONTROL CENTER (ICC), and U.S. Provisional Application No. 60/286,664 entitled BILLING ENGINE INCLUDING TRINITY BILLING ENGINE, all filed Apr. 27, 2001, all of which are incorporated herein by reference. This application is also a continuation-in-part application of U.S. patent application Ser. No. 10/______ (attorney docket: 112325.124 US1) entitled COMPUTERIZED UTILITY COST ESTIMATION METHOD AND SYSTEM, filed Apr. 23, 2002, which is also incorporated herein by reference.
[0002] 1. Field of the Invention
[0003] The present invention is directed to computer-related and/or assisted systems, methods and computer readable mediums for presenting utility billing or cost estimates. More specifically, it relates to such methods and systems for presenting the actual or forecast billing information and/or cost estimates according to a number of variables, such as utilities' rules, various billing cycles, cost estimation, cost forecast, load forecast, applicable regulatory rules and/or benchmarking.
[0004] 2. Description of the Related Art
[0005] Utilities are typically billed to the customers in the following way. A utility service provider (or its agent) has installed a system or has provided some means for collecting meter information measured by the meter on the characteristics and usage of the utility at a particular location. Each customer site may have a utility billing meter or some other device out in the field to measure utility usage, and perhaps other utility characteristics. The utility company extracts at least some of the meter information relating to utility usage from those meter devices.
[0006] The meter information is retrieved remotely from most customer facilities. One familiar type of remote retrieval of information is accomplished by the billing meter at a customer's facility, which may include a modem dial up system utilizing a plain old telephone system (POTS) line. One such prior art system for remotely collecting meter information from subscriber or customer premises is illustrated in
[0007] Meter information is typically extracted on a monthly basis, to coincide with the usual monthly billing cycle for the customers. A monthly billing statement is prepared, reflecting the underlying meter information, and mailed. The customer then may review the billing statement and the underlying meter information reported on its monthly billing statement, when received.
[0008] Nevertheless, some customers may benefit from the ability to collect and review the meter information more frequently. Some customers may wish to collect the meter information on an hourly basis, or a weekly basis. Alternatively, some customers may wish to have access to current, real time information. We have determined that the ability to review meter information at varying frequencies or on demand is desirable, but is unfortunately not provided by periodic billing statements. Of course, a billing statement cannot provide real time information.
[0009] Similarly, it is possible that customers may wish to have flexibility in the information presented in a billing statement. For example, the usual billing meter information concerning consumption may be less information than some customers would like. Further, we have determined that it is desirable that the utility billing meter collects utility characteristic information which is not included in a billing statement. Unfortunately, we have determined that the typical billing statement is insufficiently flexible to accommodate a wide variety of information, and is incapable of same.
[0010] Power utilities are of particular note in this connection. The following description details such power utilities. We have determined that similar concerns, however, apply to other utilities, such as telephone, water, sewer, and gas as well as any other metered utility.
[0011] The components of power utility usage include “real power”, “reactive power” and “apparent power”. We have determined that a billing statement does not generally reflect each of these components. Real power is commonly referred to in kilowatts; it is used by machinery to produce a product. In contrast, reactive power is typically used by certain pieces of machinery in order to merely make that machinery work. Reactive power is not regarded as a power that does real work; it is merely used to establish a field, such as a magnetic field in induction machines. Apparent power is the sum of real and reactive power. Apparent power is an alternative way of measuring power.
[0012] A conventional power meter will generally provide meter information reflecting the real power component on a consumptive basis and on a demand basis. “Consumptive basis” is an accumulation of the number of hours and the rate at which the power is used. “Demand basis” reflects the amount of power used in a finite period; from the demand basis one can determine the maximum demand for power. Utilities typically reference both a consumptive and demand basis for real power in determining rates and hence billings, since periods of high demand are billed at a greater rate. Some utilities utilize apparent power instead of real power in generating utility bills.
[0013] In addition to power component information, meter information may reflect other information as well. This additional meter information may include, depending on the meter device, time of use, peak demand, load, power outage information, voltage, current, and power factor. This additional information is not necessarily shown in a billing statement, even if a customer desires to review it.
[0014] For utility meters located outside a customer's facility, the utility will typically query the meter or poll the meter for information at a periodic interval corresponding to the billing interval, collect the meter information for the interval, and store the meter information in a customer information system. The communication with the meter can be accomplished in a number of ways, including network access, POTS, mobile access, and long range radio. Alternatively, meter readers may be utilized to manually collect and enter meter information. The collected meter information is then used to generate monthly billing statements.
[0015] The billing statement is typically in a standardized format with which the customer becomes familiar, and the statement presents standard information. In a typical utility bill format, a number of line item charges are usually included. These line items differ depending on the customer and the customer's location.
[0016] However, there are many factors and considerations that affect a customer's billing statement and the fees reflected therein. For example, the amount billed is not necessarily a straight line reflection of energy consumption. We have determined that many utilities charge different rates depending on the usage. As another example, various states have different tax rules, and any particular state may alter its tax rules. Similarly, city taxes may be required.
[0017] Moreover, we have determined that various bills might be calculated on different specific rates. For example, a customer may be subject to certain rates based on kilowatt hours used. Different rates may apply at different levels of usage of kilowatt hours. Even within the same utility, different customers may utilize different standard calculations. Hence, a billing statement is a reflection of what may be a complex set of calculations and considerations.
[0018] In addition to the above complexities affecting billing statements, some utilities provide financial incentives, such as an opportunity for financial revenue, based on participation in a curtailment program. Curtailment typically takes the form of the customer's agreement to participate in a program hosted by a utility. The curtailment program may be “voluntary” or “involuntary.” “Involuntary” curtailment involves the customer agreeing to reduce its load by a particular amount, for example, 10 megawatts, at the utility's convenience, in exchange for certain fee. “Voluntary” curtailment commences with an offer from the utility on a periodic basis to provide a fee for reduced power usage in a defined period of time; the customer may accept or decline the offer of fee for curtailment.
[0019] Certain aspects of conventional systems for utility resource management are illustrated by way of example in
[0020] Accordingly, we have determined that the complexities affecting billing statements make it extremely difficult for a utility customer to predict how fees would change in various scenarios. We have determined that a customer might want to determine how its fees would change if it moved to a different city or state; or how its fees might change if it shifted the demand to a different time of day; or how participation in curtailment would impact its fees; or how even continuing current utility usage will impact its fees.
[0021] Unfortunately, conventional systems fail to expand the potential uses of the meter information that may be collected. Moreover, none of these conventional systems permit the customer to perform its own estimations, planning and bill review, according to the parameters which the customer defines as important. Thus, using conventional systems, it is not possible to forecast utility usage or estimate costs. There remains a need in electrical and other utility industries for such a system.
[0022] The present invention alleviates the deficiencies of conventional techniques and systems described above. It extracts meter information, deposits that information into a database, and presents that information, such as over the web, in a format that is useful for the end user. The meter information is remotely extracted from the customer's meter, by any appropriate and/or standard method. The meter information is stored, and then may be queried by the customer. It is highly advantageous that the meter information is provided on the basis needed by the customer, for example for periodic monthly bills, hourly data, real time data, etc. The information that the customer wants to access, even if not conventionally available, is presented. Moreover, the meter information is processed and presented in a way that permits manipulation of data by the users themselves. The customers may utilize this to show usage, and/or to forecast predicted usage and/or cost estimation. Moreover, the meter information may be processed and presented in a format that is customer-friendly, and that the customer is accustomed to seeing, such as similar to a typical bill format.
[0023] The invention provides a method, system, and computer program device for managing utility information responsive to at least one of usage and estimated usage of utility resources. Information is stored regarding at least one user, at least one utility relating to the at least one user, and a plurality of rules that may be applied by the at least one utility for the at least one user in determining the utility information. Measurement related or estimate related information is collected, representative of the at least one of the utility usage and the estimated usage by the at least one user. At least one preference representative of a variable is selected and utilized in generating the utility information for the at least one user. The utility information for the at least one user is generated, responsive to the at least one preference, the utility information relating to the at least one user, the at least one preference, and the measurement related or estimate related information for the at least one user. A report is displayed, representative of the utility information utilizing the at least one preference.
[0024] According to one or more embodiments, the measurement related or estimate related information is acquired remotely from at least one of: a utility meter, a database of meter information, a periodic reading of a utility meter, and a demand reading of a utility meter.
[0025] According to one or more embodiments, the utility resource is power characterized by power component information, and the power component information includes real power, apparent power, and reactive power; and the measurement related or estimate related information comprises at least two of the real power, the apparent power and the reactive power; and wherein the generated utility information including calculated billing information comprising one another of the at least two of the real power, the apparent and the reactive power.
[0026] According to one or more embodiments, the utility resource is power, and the variables include at least one of time period, site, tariff, state tax, city tax, billing cycle, energy usage, location, and curtailment.
[0027] According to one or more embodiments, the user comprises at least one of an energy provider and a customer with multiple facilities.
[0028] According to one or more embodiments, the report includes actual usage, forecast usage and/or cost estimates, responsive to data input by the user; and the preference reflects at least one of: location, demand, time shift, curtailment participation, extrapolation of current usage, adjustment of current usage, billing period and tariff.
[0029] According to one or more embodiments, an estimated forecast of a utility billing statement for the user, is provided responsive to the at least one preference.
[0030] According to one or more embodiments, the report comprises a plurality of sites, and the report includes a summary corresponding to the plurality of sites.
[0031] According to one or more embodiments, the report includes at least one line item selected from: delivery charge, service charge, transmission charge, customer charge, distribution charge, computer transmission charge, environmental fund rate, low income fund rate, and power factor adjustment.
[0032] According to one or more embodiments, the report has a format resembling a printed billing statement.
[0033] According to one or more embodiments, there are further provided components selected from: estimating cost, reporting exceptions, forecasting cost, benchmarking, providing market prices, and analyzing report information; and the component(s) utilizes at least one of: the measurement related information, the estimate related information, and the user information.
[0034] According to one or more embodiments, an effect on cost of participation in a curtailment program is determined, responsive to a request of the user. Optionally, further, if the user selected participation in the curtailment program, the user's curtailment is verified.
[0035] According to one or more embodiments, at least one of the measurement related information, the estimate related information, and the user information is stored in at least one table.
[0036] According to one or more embodiments, the information stored in the at least one table includes at least one of: peak periods, holidays, bill rates, tariff information, factor information for line items, and billing factor criteria.
[0037] There has thus been outlined, rather broadly, the more important features of the invention in order that the detailed description thereof that follows may be better understood, and in order that the present contribution to the art may be better appreciated. There are, of course, additional features of the invention that will be described hereinafter and which will form the subject matter of the claims appended hereto.
[0038] In this respect, before explaining at least one embodiment of the invention in detail, it is to be understood that the invention is not limited in its application to the details of construction and to the arrangements of the components set forth in the following description or illustrated in the drawings. The invention is capable of other embodiments and of being practiced and carried out in various ways. Also, it is to be understood that the phraseology and terminology employed herein are for the purpose of description and should not be regarded as limiting.
[0039] As such, those skilled in the art will appreciate that the conception, upon which this disclosure is based, may readily be utilized as a basis for the designing of other structures, methods and systems for carrying out the several purposes of the present invention. It is important, therefore, that the claims be regarded as including such equivalent constructions insofar as they do not depart from the spirit and scope of the present invention.
[0040] Further, the purpose of the foregoing abstract is to enable the U.S. Patent and Trademark Office and the public generally, and especially the scientists, engineers and practitioners in the art who are not familiar with patent or legal terms or phraseology, to determine quickly from a cursory inspection the nature and essence of the technical disclosure of the application. The abstract is neither intended to define the invention of the application, which is measured by the claims, nor is it intended to be limiting as to the scope of the invention in any way. These together with other objects of the invention, along with the various features of novelty which characterize the invention, are pointed out with particularity in the claims annexed to and forming a part of this disclosure. For a better understanding of the invention, its operating advantages and the specific objects attained by its uses, reference should be had to the accompanying drawings and descriptive matter in which there is illustrated preferred embodiments of the invention.
[0041] The above-mentioned and other advantages and features of the present invention will be better understood from the following detailed description of the invention with reference to the accompanying drawings, in which:
[0042]
[0043]
[0044]
[0045]
[0046]
[0047]
[0048]
[0049]
[0050]
[0051]
[0052]
[0053]
[0054]
[0055]
[0056] The following detailed description includes many specific details. The inclusion of such details is for the purpose of illustration only and should not be understood to limit the invention. Throughout this discussion, similar elements are referred to by similar numbers in the various figures for ease of reference. In addition, features in one embodiment may be combined with features in other embodiments of the invention.
[0057] Applying its state-of-the-art integrated information platform and metering technology, the present invention provides tools that collect and analyze total company energy and facility information. Using the generated information, the present invention diagnoses, recommends, and implements timely solutions to help manage facility energy requirements.
[0058] The present invention includes a complete range of energy and facility management tools:
[0059] Retriever Module:
[0060] Automated energy consumption data retrieval, archiving, and posting
[0061] Load data posting
[0062] Load analysis and comparison
[0063] Cost estimation based on tariff
[0064] News, weather, and technology links
[0065] Standard personalized branding of web site
[0066] Energy Analysis Module:
[0067] Load aggregation
[0068] Peak load analysis with trending and benchmarking tools
[0069] Cost estimation (“what-if” analysis)
[0070] Utility bill posting per existing tariff(s)
[0071] Automated notification with alarming and paging
[0072] Power Quality Module:
[0073] Data monitoring, event capture, and archiving
[0074] Web access to power quality information in various formats
[0075] Access to 24/7 Information Command Center
[0076] Personalized alarm triggering via pager, e-mail, cellular phone, or personal data assistant (PDA)
[0077] Harmonic analysis
[0078] Load Management Marketplace Module:
[0079] Automated posting of local and regional pricing
[0080] Benchmark load certification
[0081] Verification of load curtailment and payment amount
[0082] Bid notification and acceptance/rejection from supplier/ISO
[0083] Economic value calculation of load curtailment
[0084] Customer election to participate
[0085] Distributed Generation Dispatch Module:
[0086] Automated generator operation or load-shedding initiative
[0087] Verification of power generated and notification of curtailable event
[0088] Viewable data from any combination of assets
[0089] Real-time monitoring and alarming of all asset parameters.
[0090] Calculation of participation level and savings.
[0091] The present invention includes one or more of the following benefits:
[0092] Fast, secure access to information
[0093] Ability to differentiate loads/costs between buildings and/or equipment
[0094] Real-time access to system performance and control of energy assets
[0095] Enterprisewide access to information
[0096] 24/7 alarming and emergency response
[0097] Energy cost control
[0098] Increased reliability of equipment and systems
[0099] Reduced maintenance hours
[0100] Integration with existing equipment
[0101] Early warning of problems
[0102] Complete Scalability
[0103] Enhancement of existing building automation and control systems
[0104] State-of-the-art Information Command Center
[0105] The following specific areas of the present invention are further described herein:
[0106] Power Quality Functionality/Process
[0107] The present invention evaluates power quality to assess the operation of equipment and determining maintenance or repair needs. The evaluation consists of any or all of the following steps:
[0108] Design Analysis
[0109] Review facility and load performance objectives.
[0110] Identify locations where known deficiencies exist.
[0111] Identify pending renovations, expansions, or upgrades
[0112] Load Analysis
[0113] Monitor voltage and load variations at service entrance.
[0114] Measure distribution panel capacity.
[0115] Measure incoming currents and voltages.
[0116] Vulnerability Assessment
[0117] Inspect wiring and grounding.
[0118] Check for improper or missing neutral/ground connections.
[0119] Verify wiring and grounding practices.
[0120] Verify transformer configurations, grounding, and ratings.
[0121] Measure grounding system impedance.
[0122] Verify grounding practices of communication cabling.
[0123] Infrared Thermographic Inspection
[0124] Perform infrared scan of all accessible electrical panels, transformers, switchgear, and automatic transfer switches
[0125] Document equipment and locations showing abnormal heating and recommend corrective action.
[0126] Harmonic Analysis
[0127] Document facility harmonic voltage and current levels.
[0128] Surge Suppression Assessment
[0129] Verify surge suppresser installation practices.
[0130] Verify surge protective device energy ratings.
[0131] Uninterruptible Power Supply (UPS) Assessment
[0132] Preparation and Submittal of Report (including observations and recommendations for corrective action)
[0133] The present invention provides the following benefits for power quality functionality: methodology; increased system reliability; evaluation of power distribution system equipment according to all applicable industry standards; efficient and effective project coordination, requiring minimal customer time; reduction of system emergencies and costly downtime; availability of follow-up system repair and replacement services.
[0134] Retriever Module
[0135] The present invention provides information that enables a user to understand energy consumption data and helps formulate optimal strategies for energy procurement and use. By capturing energy data from metering devices, the present invention continuously updates information on facilities' energy consumption at the frequency selectable by the user. The present invention delivers this critical information via Internet- or network-based tools to make strategic, informed decisions that will increase system reliability and efficiency. The present invention provides the following features: automated retrieval of energy consumption data, archived in a data warehouse and posted to secure web pages; clear and understandable load data in various tabular and graphical formats; tools to analyze and compare energy load across time and facilities; accurate cost estimation based on existing tariffs.
[0136] The present invention provides the following benefits for the retiever module: optimize energy consumption decisions with actionable data; enable your internal energy management staff to make informed decisions; view and analyze your energy use for any single site or facility grouping you choose; gain information to shop for market-priced electricity on an hourly basis; nominate or change contracted natural gas quantities to gain optimal pricing; and calculate your estimated utility bill for any time period or billing cycle you select.
[0137] Energy Analysis Module
[0138] The present invention provides tools that will facilitate development of procurement and usage strategies. Building on information gathered by the Retriever module, the Energy Analysis Module generates signals that will assist in actually implementing an energy management strategy. The present invention includes the features of load aggregation; peak load analysis; trending and benchmarking; cost estimation (“what-if” analysis); utility bill posting per existing tariff(s); and automated alarming and paging based on software algorithms.
[0139] The present invention provides the following benefits: analyze energy power and load with electronic metering devices; manage energy usage patterns with effective visualization and historical trending tools; reduce future energy purchase costs by tracking usage over time; identify largest facility energy consumers by normalizing demand and usage data by a key variable; track the contribution of each facility and business line to overall consumption; generate utility bills for budgetary purposes and to verify accuracy; evaluate energy costs using alternative tariffs; and receive notification of current consumption behavior outside normal parameters.
[0140] Power Quality Module
[0141] The present invention provides an integrated approach to help minimize disruptions using the best metering technology and information. The Power Quality Module captures facility electrical disturbances that fall outside of industry-specified tolerance specifications established by the Computer and Business Equipment Manufacturers' Association CBEMA). This information, combined with monitoring and event notification, characterizes the integrity of the voltage and current waveforms at a specific point in the electrical power distribution system, permitting the assessment of its suitability for the reliable operation of connected equipment.
[0142] The present invention includes the features of: data monitoring, recording, and archiving; event capture; posting of power quality information on customized web site (tabular and graphical); access to 24×7 Information Command Center; alarm triggering (according to prespecified criteria); alarm notification via pager, e-mail, cellular phone, or personal data assistant (PDA); waveform capture; and harmonic analysis.
[0143] The present invention provides the benefits of: receive immediate notification of operating problems within sensitive electronic equipment; capture and analyze alarm trends to avoid unplanned shutdowns of vulnerable equipment; reduce downtime costs; accurately pinpoint electrical events not previously possible after the fact; evaluate auxiliary systems to ensure exceptional performance levels; and optimize operations with a single point of contact for system performance.
[0144] Load Management Marketplace Module
[0145] Once the user has the ability to manage your facility energy load actively, the Load Management Marketplace Module enables the user to capitalize on the volatility of the energy supply market. The ability to make smart business decisions regarding operating costs will increase as idle assets are turned into revenue generating opportunities.
[0146] The present invention includes the following features: automated posting of day-ahead and hour-ahead local and regional pricing; transaction platform that allows bid notification from energy supplier or ISO for voluntary load reduction including time period, total requirement, and price offered; economic value calculation of load curtailment (customer “self-serve”); customer election to participate, including amount of load curtailment and time period; bid acceptance/rejection by supplier/ISO; benchmark load certification; and verification of load curtailment and payment amount.
[0147] The present invention provides the following benefits: capitalize on revenue generation opportunities and maximize energy cost savings; optimize contributions to curtailment opportunities by aggregating multiple sites; maximize your load curtailment planning with automated notifications on energy price signals; and manage ongoing analysis of revenue generating opportunities.
[0148] Information Command Center (ICC)
[0149] Primary Domain Controller (PDC)—Used to provide authentication to all authorized uses of the ICC computer network domain. Also used to perform ICC network administrative taks.
[0150] Backup Domain Controller (BDC)—Routinely synchronized with the PDC. In the event that the PDC is offline, the BDC performs PDC functions. Also serves as a database server for the the MV90 communications database.
[0151] Application Server—Used to dispatch generation and accumulate detailed engine and generator operation-related data from systems with distributed generation.
[0152] Workstations—Equipped with modems, these units are used to perform support through remote interrogation of standalone energy management systems and/or field devices. Also used to perform routine functions for contract related services such as reports, alarm analysis and response, and power quality event analysis. The workstations are used to support internal system maintenance and upgrades. Workstations also monitor locational marginal price (Imp) in various regions around the United States to help determine when generator dispatching should be performed.
[0153] Television—Used to monitor weather conditions in and outside of the region to relate electrical system events to external conditions where appropriate.
[0154] 3 Zone Clocks—Used to track Local, Pacific, and Universal Time in order to relate events and or database information to appropriate regional times.
[0155] Audio System—Provides audible alerts due to event drive occurrences for immediate response by operators.
[0156] ICC Furniture—This fan-cooled console furniture is used to house servers and workstations. Constructed with dual position stations, it provides the users with access to multiple workstations from each position making it convenient to converse via phone with the customer while simultaneously addressing service related issues.
[0157] Uninterruptible Power Supply—Services as temporary backup power for the ICC in the event that an electrical power outage occurs.
[0158] HVAC system—Used to provide climate/humidity control for optimal PC performance.
[0159] In one embodiment of the invention, the billing engine is a C++ program that was written for the purpose of creating reports that will display a cost estimate of billing charges for a given customer based on a customer's tariff and time period. The report, in one embodiment, does not replicate a customer bill exactly, but provides a close estimation of charges over a period of time defined by the system user. All tariff information used by the billing engine is stored, for example, in one or more files.
[0160] The billing engine is invoked by clicking the Cost Estimate menu item from the Customer Electric Selection List web page. After the engine has been started, the user has the option of creating a new report or selecting from a previously saved report. If the user selects an existing report, the report criteria page is displayed. If a new report is selected, the user will have an option of providing filtering information for the currently selected customer before the report criteria page is displayed. On the report criteria page, the user will be required to enter the dates for which the report will apply, the tariff to be used in the calculation, and the site or sites to be viewed, if there are more than one. The user may also select the report type and can create a name under which the report will be saved. After all criteria have been entered or selected, the user can click on the View Results button to display the report information.
[0161] The billing engine source code includes debugging flags and trace directives. These flags use the C++ define mechanism. By uncommenting these define statements, the engine will display information in great detail on the report web page. When compiling the production version, these flags should all be commented out. The flags exist in the following modules as follows:
[0162] Web_rate.cpp
[0163] TRACE WEB BILL
[0164] TRACE_FAKE_CYCLES
[0165] Bill_calc.cpp
[0166] DEBUG BILL
[0167] DEBUG AND
[0168] TRACE_BILL
[0169] LEVEL TRACE
[0170] Paramlist. cpp
[0171] TRACE_PARAM_MUNGE
[0172] The flow of the billing calculation engine can be defined in four main modules. Each module and a brief description follows:
[0173] Web_rate. cpp
[0174] This module is the site abstraction layer and is responsible for all user interface functionality and retrieving the data.
[0175] Bill_calc.cpp
[0176] This module is the administrator that is responsible for looping through all of the charges and calculating these charges. This module also contains most of the main objects used in the billing engine. These objects are listed below with their methods and operators:
[0177] Billing-item
[0178] Operator=—This operator is used to assign the values from one billed item to another.
[0179] Billing engine
[0180] Read_from_file—This method reads each line from the .ini file, determines what kind of data has been read, and then calls the appropriate objects to process the line of data.
[0181] Init_period—This method is used to initialize specified periods and prepare them for processing.
[0182] And_period—This method is used for joining periods that need to be accessed for a given billing period defined by the user
[0183] Not_period—This method is used to filter out periods which will not be applies to the billing period specified.
[0184] Process_period expression—This method is used to process the periods information by evaluating the operators, if they exist and calling and-period and not-period to process.
[0185] Get_usage—This method will get the usage information from the database for a specified period of time. It will calculate the amount to bill for this period of time.
[0186] Calculate_bill—This method is and administrative method which calls the calc charges method which is responsible for calculating all charges for a given bill.
[0187] Calc_charges—This method is the primary method that is responsible for the calculating of all charges for a given bill.
[0188] Get_tariff_choices—This accumulates the list of tariffs that can be selected from.
[0189] Locate_tariff—This method finds a tariff from the tariff list object.
[0190] Get_tariff_name—Given a tariff, this method returns the tariff name that is to be displayed on the web page.
[0191] Identify_tariff_constants—Based on a given tariff constant, this method returns true if the tariff can be found and false if the tariff cannot be found.
[0192] Check_charge—This method determines if the tariff listed for a given charge actually exists in the tariff list.
[0193] Dump—This method is used to display all utility, tariff, period and charge information. This is only used for debugging purposes.
[0194] Evaluate—This method is used to evaluate all billing functions provided in the billing engine. These functions include billamt, billqty, billhrs, billhistqty, billdays, and billhistamt.
[0195] Calculate_historical_bill—This function is used to calculate an historical bill. It is called from the evaluate method when the .ini file specifies the usage of the functions billhistqty or billhistamt.
[0196] Utility—Stores and operates on utility information provided in the .ini file.
[0197] Parse—This method is used to parse a line from the [utilities] section of the .ini file and put the data into a utility object.
[0198] Operator=—This operator is used to assign the values from one utility to another.
[0199] Utility_list—Collection of utility objects
[0200] Find—Given the name of a utility, this method will find and return the utility object within the collection that contains the provided utility name
[0201] Append—This method will add a utility object to the collection.
[0202] Dump—This method will create standard output of all utilities in the utility list.
[0203] This method is used for debugging purposes.
[0204] Tariff—Stores and operates on tariff information provided in the .ini file
[0205] Parse—This method is used to parse a line from the [tariffs] section of the .ini file and put the data into a tariff object.
[0206] Operator=—This operator is used to assign the values from one tariff to another.
[0207] Tariff_list—An object storing a collection of tariff objects
[0208] Find—Given the name of a tariff and utility, this method will find and return the tariff object within the collection that contains the provided information.
[0209] Append—This method will add a tariff object to the collection.
[0210] Dump—This method will create standard output of all tariffs in the tariff_list. This method is used for debugging purposes.
[0211] Period—Stores and operates on period information provided in the .ini file.
[0212] Parse—This method is used to parse a line from the [periods] section of the .ini file and put the data into a period object.
[0213] Operator=—This operator is used to assign the values from one period to another.
[0214] Operator &=—This operator is used to combine multiple periods together.
[0215] Sort_times—This method checks if the start time for a given period is before the end time. If it is not, the start time becomes the end time and the end time becomes the start time.
[0216] Clip date_range—This method will process the clipped, notclipped, prorate and endonly options for the defined period.
[0217] Period-list—An object containing a collection of periods.
[0218] Find—Given the name of a period and utility, this method will find and return the period object within the collection that contains the provided information.
[0219] Append—This method will add a period object to the collection.
[0220] Dump—This method will create standard output of all periods in the period-list. This method is used for debugging purposes.
[0221] Charge—Stores and operates on charge information provided in the .ini file.
[0222] Parse—This method is used to parse a line from the [charges] section of the .ini file and put the data into a charge object.
[0223] Operator=—This operator is used to assign the values from one charge to another.
[0224] Is applicable—This method will determine if a charge is to be applied to a given bill.
[0225] Prorate_tariff_change—The method is used to calculate the proration coefficient where a charge is to be prorated.
[0226] Charge-list—An object containing a collection of charge objects.
[0227] Find—Given the name of a tariff and utility, this method will find and return the charge object within the collection that contains the provided information.
[0228] Append—This method will add a charge object to the collection.
[0229] Dump—This method will create standard output of all charges in the charge-list. This method is used for debugging purposes.
[0230] Tariff information is stored and manipulated in a file. The file is made up of four basic types of entry or sections. Each of these types identifies the beginning of that specific section of the file. These sections are identified as utilities, tariffs, periods and charges. Each type of entry has its own specific comma-delimited format, as follows:
[0231] Utilities
[0232] This section contains a list of the utilities who have rates stored in the file. The section format follows:
[0233] Wholesaler—The number of the utility in the EnerWise database. Currently, the values are 27 for Conectiv Power Delivery (CPD), I for SCE.
[0234] Name—The name of the utility as identified throughout this file.
[0235] Description—Long description of the utility name.
[0236] Regulated—‘Y’ for regulated, ‘N’ for not regulated.
[0237] Service identifier—Currently supports ew_eastern for EnerWise® customers and ami-pacific for Amicos customers.
[0238] Tariffs
[0239] This section contains a list of all of the tariffs in a file. The section format follows:
[0240] Utility name—The name of the utility as it corresponds to the [utilities] section of this file.
[0241] Utility Regulated Name—The regulated utility name.
[0242] Rate identifier—Rate identifier such as R—residencial, GS—general service.
[0243] Service Identifier—This corresponds to the rate identifier in the utility section.
[0244] Long Rate Name—This is the name for the rate as it is displayed on the web page.
[0245] Periods
[0246] This section is used to define the time periods for different utilities. These periods can be defined by specific dates to separate winter and summer billing periods, or by hours and days of the week to define off-peak, mid-peak, and on-peak times. The section format follows:
[0247] Utility—This defines the utility for which the period will apply. The value indicated corresponds to the utility name in the utilities section of the file.
[0248] Name—A brief name to describe the period. Examples of this name would be summer, winter, off-peak, on-peak, mid-peak.
[0249] Time zone—The time zone for which the period is defined. The system currently supports US/Eastern, US/Pacific, or GMT (Greenwich mean time).
[0250] Start date/time—This time indicates the time for which the period begins. The format of the date/time should be m/d/yyyy hh:mi.
[0251] End date/time—This time indicates the time for which the period ends. The format of the date/time should be m/d/yyyy hh:mi.
[0252] Bits—This field contains the days and hours for which the period applies. The format for hours is beginning hour—ending hour where beginning hour is the end of the hour for which the period is to begin and ending hour is the end of the ending hour. The hours are 1 to 24. The days are in a three character format. An example for this field would be Mon Tue Wed Thu Fri 1-8 to indicate weekdays from 12:00 AM to 8:00 AM.
[0253] Period qualifier—This field will either be notclipped, clipped, endonly, or prorate.
[0254] Charges
[0255] This section defines all of the specific charges for a given tariff. The section format follows:
[0256] Utility—The name of utility for this tariff as defined in the [utilities] section of this file.
[0257] Tariff—The name of the tariff as defined in the [tariffs] section of this file.
[0258] Group—The group for which this charge applies. This group is used for presentation purposed on the web page.
[0259] Name—The name of the charge as it will appear on the web page.
[0260] Period—The usage period for this charge as defined in the [periods] section of this file. Multiple periods can be entered by using the & character. An example of this would be summer & off-peak.
[0261] Time zone—The time zone for the applicability date of this charge. The system currently supports US/Eastern, US/Pacific, or GMT (Greenwich mean time).
[0262] Start date—The date for which the charge is effective. The format for the start date is m/d/yyyy.
[0263] End date—The end date of this charge. The format for the end date is m/d/yyyy.
[0264] Unit—The unit that is being used in the calculation. This field can be one of the following:
[0265] eval: term0 [*/+−] terml [*/+].. termn
[0266] max: term0, terml . . . termn
[0267] min: term0, terml . . . termn
[0268] A term is one of a number such as 234.23 or $kW, $kWHr, kVar, kVarhr, (see supporting data below) or billqty.item or billamt.item, where item is an item on the bill, or a total.
[0269] Operation identifier—The system supports max, min, avg, sum, count, max_slide. The common usage for this field is max for kw (demand) and sum for kwh (usage).
[0270] Minimum level—The minimum amount of usage for this charge to be applies. A value of zero should be the default.
[0271] Maximum level—The maximum amount of usage for this charge to be applied. A value of 0 should be the default to indicate no maximum.
[0272] Amount—The multiplier to be used in the calculation. This field is the cost per unit.
[0273] Charge qualifier—This column is can be used to indicate the criteria that must be met in order for this charge to apply. A value of
[0274] Prorate (optional)—If present, this optional field is used to indicate proratation across rate changes.
[0275] Level (optional)—If present, this optional field is used to indicate that the charge will use the average of multiple charges on the level, rather than the sum.
[0276] Summable (optional)—If present, this optional field is used to indicate that the item is considered a varying amount for purposes of charting.
[0277] Hidden (optional)—If present, this optional field is used to indicate that the charge will be used, but not presented on the web page.
[0278] Flatten (optional)—If present, this optional field. is used to indicate that hours are to be day aligned.
[0279] Data Support
[0280] The following data is supported in the unit and charge qualifier fields and can be identified in the file, as follows:
[0281] kW identified by $kw
[0282] kWh identified by $kwh
[0283] Service voltage identified by $service_voltage
[0284] kVAR identified by $kvar
[0285] kVARh identified by $kvarh
[0286] State tax identified by $state_tax
[0287] City tax identified by $city_tax
[0288] Timing identified by $timing
[0289] Phase identified by $phase
[0290] Excess tform identified by $excess_tform
[0291] Temperature identified by $temperature
[0292] Gas identified by $gas
[0293] Water identified by $water
[0294] Firm service identified by $firm_service
[0295] Air-conditioning cycling identified by $ac_cycling
[0296] Air-conditioning tons identified by $ac_tons
[0297] Standby kW identified by $standby
[0298] Limiter tariff identified by $limiter_tariff
[0299] Added facilities identified by $added_facilities
[0300] Controllable power identified by $control_power
[0301] Function Support
[0302] The billing engine provides built in functions for use in the file. These functions can be used to reference charges that have been previously listed in the file. An example of the syntax would be $billqty.charge. The following is a list of the functions:
[0303] $billqty—This function will produce the quantity of units used in the calculation of previously listed charge.
[0304] $billamt—This function will produce the billing amount of a previously listed charge.
[0305] $billhrs—This function will product the number of hours used for the calculation of a previously listed charge.
[0306] $billdays—The function will produce the number of days that applies to a given period.
[0307] $billhistqty—This function will produce the quantity of units used in the calculation for a previous period in history. This is used primarily for calculating ratchets.
[0308] $billhistamt—This function will produce the billing amount for a previous period in history for a given charge.
[0309] Note that one or more files or other means for accessing the data may alternatively be used.
[0310] In accordance with one embodiment of the invention, meter information regarding utility usage by a customer or other source that has been extracted from utility collection and/or billing meters is deposited into a database, and ultimately presented to an end user on behalf of a customer, such as on a web site over the World Wide Web, i.e., the Internet. The user may use the meter information to prepare various reports of utility billing information relating to actual and/or forecast utility usage and/or cost estimations for the customer. The reports may encompass any of the various variables such as user-defined billing periods, and may optionally include information not reflected in the standard billing statement. Advantageously, the present invention optionally allows the user on behalf of the customer to estimate their own energy usage responsive to estimated usage parameters, and further provides the customer the ability to define their usage requirements responsive to altering their usage parameters via the cost estimation of the present invention as described below is detail.
[0311]
[0312] The billing engine
[0313] The interval meters with modems
[0314] As will be appreciated, there are several ways in which utility billing information, reflecting meter information, may be reviewed. One limited manner of reviewing utility billing information is via a standard printed energy billing statement
[0315] Some systems may retrieve meter information from an existing utility billing meter
[0316] The stored meter information may then be referenced in connection with a query by the customer browser
[0317] Meter information may be obtained on an as-needed basis from, for example, a standard remotely accessible utility billing meter. Therefore, remote access of a utility billing meter is particularly useful for customers who desire information more frequently than available in connection with the standard monthly billing statement. Remote access of a utility billing meter thus would be desirable for customers who prefer information at more frequent intervals such as hourly, quarter hourly, real time, or weekly.
[0318] Information that is not typically reflected in a billing statement, such as unprocessed and/or expanded meter power component information, may advantageously also be obtained from a utility billing meter in the present invention. Remote access, therefore, may be useful for customers who desire information beyond the conventionally available information on a billing statement. The typical information from a utility billing meter is limited to consumption and demand information, and perhaps some reactive power consumption information. Although some utilities generate utility billing statements based on apparent power, most utilities generate utility billing statements reflecting measured real power. By capturing at least two of the three power components in accordance with the present invention, however, all of the power components may be calculated. According to at least one embodiment of this invention, meter power component information, and/or other utility and usage information available from a utility billing meter, may be collected, manipulated and displayed as part of the reports of utility billing information, via the billing engine
[0319] In
[0320] The meter information from the local distribution company's customer information system is transmitted to the billing engine
[0321] Hence, meter information coming into the billing engine
[0322] The illustrated system shows a file transfer protocol (“FTP”) server
[0323] Reference is now made to
[0324] Rates are entered via an appropriate standard user interface via standard inputs. The rates are indicative of calculations which ultimately result in the fees shown in a utility billing statement. Rates are discussed by way of example herein.
[0325] The database and report generators
[0326] Also illustrated in
[0327] The billing engine in the data driven rate storage
[0328] Interval data storage
[0329] The billing engine also includes a section for providing a data driven HTML bill report presentation, block
[0330] Reference is now made to FIGS.
[0331] In the example shown in
[0332] The user may select particular sites and/or tariffs
[0333] Variables affecting the fees may be adjusted by the user: various applicable tariffs may be selected and applied to a particular site, the state or city taxes may be altered. The energy usage may be altered as well. Any or all of these and/or other variable attributes affecting reports of actual usage, forecast usage and/or cost estimates may be displayed and altered, if preferred, by the user. In the illustrated example, these variables are specified and applied within a particular site. However, it may be desirable to provide that a user may apply one or more variables globally to a set of sites for a customer.
[0334] By utilizing the user interface and the ability to adjust variables, the user may provide an estimated forecast of its utility billing statement in specific scenarios. For example, a scenario might include a reduction of consumption by 40%. The cost estimate report displays results derived from a calculation of how such a reduction would impact the utility billing statement. In another example, a forecast estimate report is made by adjusting state tax to reflect a 20% increase. The results of the cost estimate report display show how that adjustment will impact the customer's billing statement.
[0335] In the example illustrated in
[0336] Reference is now made to
[0337] Consider, in this particular example, that the customer has five facilities under its care, including the three illustrated
[0338] Once the user has altered the variables as desired, the user should in some way indicate that the alterations are complete, such as by indicating “finished”
[0339] The system then produces a utility information report incorporating the altered variables, as illustrated in
[0340] Where the utility information report covers multiple sites or facilities, it is preferable for the report to be represented independently for each site or facility. A user may page through the utility information report by selecting a particular facility and any subcategory within that facility. In the illustrated example, the utility information report for each facility is further divided into subcategories by time period. Optionally, the present invention also contemplates a consolidated report for multiple sites and/or facilities.
[0341] In accordance with well known procedures for HTML displays, selecting a site from the table of contents automatically displays the details of the utility information report for that selected site. In the illustrated example, the selected site is “Agriculture Production.” The billing engine displays the utility information report for the selected site
[0342] The utility information report for each selected site and/or combination thereof optionally includes line items. Advantageously, line items which are detailed in the utility information report are those normally included in the printed utility billing statement for that customer. The utility information report preferably resembles a printed utility billing statement, in order to be familiar to a customer and therefore user friendly. In this example, the line items in the report for the Agriculture Production site
[0343] Note that the utility information report optionally includes a display of the summary of the subtotals
[0344] Utilizing the utility information reports, a user may adjust particular information, do an analysis, and obtain an estimate of a forecast or actual billing statement for a particular time period. Also, by utilizing the utility information report, a customer can determine if it is currently over or under or on target for its budget for energy. The customer may also run different hypothetical scenarios, such as moving a facility to a different state, to determine whether it is more cost effective to have a facility in an area with a particular rate versus a different area with a different rate.
[0345] Reference is now made to
[0346] The exception reporting component
[0347] The forecasting component
[0348] Also illustrated is the curtailment component
[0349] The system optionally includes a benchmarking component
[0350] Optionally, the system also includes a market price component
[0351] The system optionally includes an analytical package component
[0352] Reference is now made to