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:

• 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%.

• 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.

3     Print the report.

• Once the required report settings have been specified, click the Print button   to print your report.
• Click the options arrow on the right side of the Print button to see other print options.
  • Select Send PDF to Job Viewer to print the report in the default Springbrook format.
  • Select Send Excel to Job Viewer to export the report data to an Excel spreadsheet as unformatted data.
  • Select Send Excel (Formatted) to Job Viewer to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
• Click the Schedule icon next to the Print button in order to schedule the report to generate at a later date and time.
  • Scheduled printing has not yet been enabled for reports generated from process batches. This functionality will be released in an upcoming service pack.
• Users can also regenerate a report with the same configuration as a prior report via the report history section. This can help improve efficiency when an identical report is frequently generated.
  • Once a report has been generated, the date and time it was generated will display in the report history accessed via the Expand Arrow button on the right side of the window.
  • Expand the report history and click on a previous report record to automatically populate the report criteria with the criteria specified on the previously generated report. This section will display the last three times the report was generated.