Calculate Average Monthly Usage

The Calculate Average Monthly Usage task calculates the average monthly usage for assets that support usage tracking and that can store the average monthly usage, such as water meters, vehicles, and equipment.

The default algorithm first calculates an average daily usage for the past 365 days, or since the asset's installation. The algorithm then multiplies the average daily usage by 365 and divides it by 12 to determine the average monthly usage. You can also enter your own formula if you do not want to use the default algorithm.

Invocation

The Calculate Average Monthly Usage task can be scheduled or invoked manually from the Batch Manager form, and it can be invoked through the console.

This table describes each parameter for this task:

Parameter Description
Asset Asset type for which you are calculating the average monthly usage. You can calculate usage for these types of assets:
  • Fleet equipment
  • Plant equipment
  • Sewer meter
  • Sewer pump
  • Storm meter
  • Storm pump
  • Vehicle
  • Water meter
  • Water pump
Unit Type Unit type for which you are calculating the average monthly usage.
Calculation Formula Formula that will be used to calculate monthly usage. Enter a formula if you want to use something other than the default algorithm. For example, the default algorithm does not consider rollovers, so you must write your own formula if you want to include rollovers in the calculation.
Commit Interval Number of assets processed in each batch.
Note: You can enter any number here, but there are limitations at the database level. Oracle databases have a limit of 1,000 records, and SQL Server databases have a limit of 2,000 records. Entering a larger number will cause errors.

Data output

The average monthly usage is stored in the AVGMONUSG column of the table for the asset type, such as COMPPEQ for plant equipment or COMPWMTR for water meters.

You can use the appropriate Asset InfoViewer to review an asset's average monthly usage. The value is displayed in the Average Monthly Usage field on the Structural tab.