Bulk validation limits

Defaults

Abandons any edits and revert to default.

Query

Select Query to retrieve the data (according to the Number of Periods and the Effective Time), analyze it, and suggest validation limits based on the meters’ data, the Procedure to constrain results, and the desired standard deviation.

Output

The Output tab shows information to aid you with debugging of the query.

• Show. Show the results of the compiled query and shows more information.

• Verbose. Shows the values it sends to the different parameters for every meter.

• Clear. Clears the Output screen.

Referenced Assemblies

The .dll libraries that are used to compile user code.

Note: You can add other .dll libraries.

Abort

Aborts the query.

% of data to fall in this range

This corresponds to the Bell curve distribution of the data sample.

Points that fall outside this range are excluded from the validation limits calculation.

# std dev

The standard deviation is equivalent to the % of data to fall in this range.

Number of Periods

Number of periods in the data sample.

Ending # of Periods Back

Default is one, one period before the current period.

Update

The frequency that the query is run. Choices are the following:

• Daily

• Weekly

• Monthly

• Manual

Granularity

This dropdown list determines which validation rules to use based on the granularity you've selected when determining the Reasonability Limits:

• Default will apply the standard validation rules associated with the meter found on the Meter Validation tab in the Properties for Meter.

• When a meter has been configured to perform data validation by selecting Hourly Data Validation in the Nongranularity Validation property, it will refer to the validation properties configured in the Hourly Data Validation tab.

• When a meter has been configured to perform data validation by selecting Daily Data Validation in the Nongranularity Validation property, it will refer to the validation properties on the Daily Data Validation tab.

  Note: The Primary History Granularity is distinct from the Nongranularity Validation defined here. As long as your meter has been configured for each of the granularities, it will use the validation rules as described above.

Effective Time

Select the time at which the new limits will become date-time effective. The Bulk Validation Limits that you've created will only be used after the Effective Time has passed.

Procedure to constrain results

Write the desired procedure in Visual Basic (VB) or C#.