UB> Meter Management> Misread Meters

Misread Meters Report

Summary

The Meter Misread Report displays meters that have an unexpectedly high or low consumption level. The report will compare the consumption on a current meter reading to the consumption of the meter reading of the same read period in the previous year and then calculate a variance percentage. If the variance percentage is greater than a user defined amount, the device will display on the report.

If there are multiple reads during the read period of the previous year such as meter reads entered on service requests, the consumption of the meter readings of the previous year with the same read period will be totaled to calculate the variance percentage.

If there are multiple meter readings on a device during the selected meter read date range, each meter reading will create a separate line item on the report. The meter reading will be compared to the total meter reading of the same read period.

Step by Step

1 Open the Misread Meters window (UB> Meter Management> Misread Meters).

2 Configure the report.

Select the meter routes to include on the report.

Click the toggle next to the field title to select or deselect all the displayed routes.
Meter routes are created and maintained in UB> Maintenance> Route.

Use the Filter Type drop-down to filter the report by Specified Variance or Imported Misread.
Enter a meter read date range in the Begin Reading Date and End Reading Date fields.

You can view the meter read date for a meter in the customer account in UB> Maintenance> Account> Device tab> Expand a device type> Expand a device> Read Date column.

Enter a misread Variance Percentage.

The report will display meter readings that are extraordinary. The Variance Percentage field defines the range of what is considered ordinary variability in the meter readings. The variance of each meter reading is calculated by comparing the current meter reading to the meter reading of the same read period in the previous year.
The Variance field will default to 100%. If you leave the variance at 100%, a device will display on the report if the consumption on the meter reading included in the date range is twice or half the consumption during the same read period of the previous year.
The formula for the variance is:

( (Larger consumption – Smaller consumption) / Smaller consumption ) X 100 = Variance %

Larger consumption = Larger of the previous or current consumption

Smaller Consumption = Smaller of the previous or current consumption

If there are multiple readings in the previous year, the consumption on those meter readings will be totaled.

If the calculated variance of the current consumption is equal or greater than the set variance, the current reading is flagged as a possible misread. For example, if you set the variance to 100% where last year’s consumption was 500 and the current consumption is 900, the calculated variance would be 80%.

( (900 – 500) / 500 ) * 100 = 80

The meter will display on the report as a misread meter if the calculated variance is greater than the value entered in the Variance Percentage field. In the example above, 80% is less than the set variance of 100% so the reading is not labeled a misread.
The Variance Percentage field will be disabled when Import Misread is selected in the Filter Type field above.

Check the Include Meter Read toggle to include the current meter reading on the report.
Check the Use Annual Average If Last Year's Consumption is Zero toggle to compare the current consumption to an average consumption if last year's consumption was zero.
- This toggle will be disabled when Import Misread is selected in the Filter Type field above.
Check the Exclude Zero Consumption Reads toggle if the report should flag a reading as a misread if the current consumption is 0.
The report will display the route number, sequence number, serial/MXU/register number, customer number, customer name, service address, consumption, prior consumption and the variance for each meter.