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.
- Press CTRL+A to select all of the meter routes in the field. Press SPACE to check or uncheck the selected toggles.
- Meter routes are created and maintained in UB> Maintenance> Route.
- 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
Small Consumption = Smaller of the previous or current consumption
It 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.
- 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.
- 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.
3 Print the report.
- Click the Print icon to process the report immediately or enter a date and time in the field next to the Print icon to schedule the report to generate at a later time. You can view the progress of the report on the Job Viewer window (SS> Utilities> Show Scheduled Jobs).
- Click the Print icon drop-down menu and select Print Preview to preview the report before printing.
- Click the Print icon drop-down menu and select Excel to export the report data to an Excel spreadsheet as unformatted data.
- Click the Print icon drop-down menu and select Excel (Formatted) to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
- Once the report is generated, you can also display the report using the View Reports window (SS> Utilities> View Report).