Meter Actions

The following common actions are available in the Actions Menu:

The following action is only available in the Meter Module in the Actions menu and on the toolbar.

  • Validate Data.
  • Fill Data.
  • Calculate Statistics.

  • Compute Validation Parameters.

These actions are defined below.

Validate Data

The Validate Data command manually executes the validation rules configured on the Validation Parameters Tab for the selected meters over the selected date range. When selected, the user must specify a date range using the calendar selection boxes or select the Entire Range check box. To clear all existing data status flags before validating, check the Clear Status Before Validating box.

Fill Data

The Fill Data command manually executes the Filling Parameter rules configured on the Filling Parameters Tab for the selected meters over the selected date range. When selected, the user must specify a date range for validation using the calendar selection boxes. To recalculate previously filled values, select the Recompute Filled Data check box.

Calculate Statistics

The Calculate Statistics command manually calculates the statistics for the selected meters based on all available historic data subject to the Data Statistics Calculation Length parameter on theSystem Settings, System Parameters Tab. Statistics are shown on the Daily Statistics Tab and Daily Statistics Tab. For meters without available data, a message box warning, “No data in calculation period” will appear.

Compute Validation Parameters

The Compute Validation Parameters command can be used to automatically compute maximum and minimum meter validation parameters from historical meter data using the following method:

  • Max Metric: over N days of history, determine by month, the hourly mean and standard deviation.

    • Calculated Statistical Max = Mean + n * Standard Deviation

    • Calculated Max Metric = (1 + m) * Statistical Max (e.g. m = 0.2 to apply a margin of 20%.)

  • Min Metric: over N days of history, determine by month, the hourly mean and standard deviation.

    • Calculated Statistical Min = Mean – n * Standard Deviation

    • Calculated Min Metric = (1 - m) * Statistical Min (e.g. m = 0.2 to apply a margin of 20%.)

    • If Calculated Min Metric is <= 0:

    • If disallow negative is checked, set to 0.

    • If disallow zero and disallow negative is checked, do not install a minimum

The Compute Validation Parameters dialog has the following fields:

  • Days Back: The number of days back of data to use in the calculation

  • Minimum Number of Days: The minimum number of days required to calculate validation parameters for a meter

  • Standard Deviation Multiplier: Standard Deviation multiplier in the above calculation (n in the above calculation)

  • Result Margin: Result margin (m in the above calculation)

  • Metric: The parameter(s) to compute. Options are Max, Min, or Both

  • Exclude Bad: When set to true, data marked as bad is excluded from the calculation

  • Exclude Filled: When set to true, data marked as filled is excluded from the calculation

  • Exclude Incomplete: When set to true, data marked as incomplete is excluded from the calculation

  • Exclude Load Control: When set to true, data marked as load control is excluded from the calculation

  • Exclude Load Event: When set to true, data marked as load event is excluded from the calculation