MP-Web Compliance Threshold Rules Advanced

MP-Web Compliance Threshold Rules Advanced setup

There are a vast amount of comparison and filter options to aid with setting up compliance limits more complex than simple absolute limits. From those which follow filtering, through to more advanced options where the limit is based on values from other variables, locations, or is conditional to a number of breaches, based on calculated values, or other factors.

Compare Values and Comparison Operators

Compare Values

Fixed - This is the default setting for all more basic compliance set up, with access to the Grid available. 

Variable – Compares the selected compliance data against the data linked to another variable. Here there will be no fixed values present in the grid but data will be compared to values presented against the Variable chosen.   
Calculation – Compares the selected compliance data against a Predefined Calculation.
Aggregate – Compares the selected compliance data against an Aggregate Calculation.
Translation – Compares the selected compliance data against a Translation Grid.
Anything except a less than – Data will exceed the threshold when the data does not have a < prefix before the value.

Comparison Operator

Outside – This is the default comparison operator. Outside treats any values outside of the range as a breach.
Outside Inclusive – This is very similar to the outside operator. The difference is that it will include the upper and lower limits as breached values.
Between – The between operator has the reverse logic to outside. All values within the lower and upper limits will be classified as a breach.
Between Inclusive – Just like outside Inclusive, Between Inclusive consists of the upper and lower limits as well.

Exceedance Mode

Exceedance Mode introduces the concept of exceedances. An exceedance is a precursor to a complete Breach.

Multiple Exceedances – Multiple exceedances sets the number of exceedances within a given time period. If the consecutive breach is set to 4 exceedances in a single day for example, then there is one breach only if there are four or more exceedances in a single day.

Consecutive Exceedances – Consecutive exceedances set the number of consecutive exceedances before a complete breach. There is no time limit, but unlike multiple exceedances, the exceedances have to be consecutive. 

Locations

This enables users to allocate breaches to values that are recorded at a different location.

Original Location – The default and typical example where the data is used to compare from the original location.

Same reference Location for All – This compares all the locations selected in the Threshold Rule to the values of one single location

Different Reference locations for each Sample Points – Allows different sample points to have separate comparison locations.

Date / Time Filter Tab

Only apply this rule starting from the following date:

This function allows you to filter down to different start dates. This can be used in isolation to set when the Threshold Rule becomes applicable or in conjunction with the end date.  

Only apply this rule until the following date:

This enables the compliance to be filtered to a particular end date. For example, if compliance values change over time and you want to record the historical values. 

Filter By Time of Day:

This filter allows you to only use data between certain times of the day. For example, this gives the ability to create night and day compliance.

Filter by Days of the Week:

This filter allows you to choose what days of the week you would like to use in your compliance. All days are selected by default.

Filter by month:

This Filter Allows you to choose a window of time in months. For example, you could choose January to March and call the Threshold Rule ‘Q1’ for seasonally conditional compliance creating multiple Threshold Rules for each of the varying periods.

Dynamic Filter

Dynamic Filtering enables compliance to be conditional based on the values of other Variables or Calculations. For example, a compliance limit may only apply when a pump is discharging, or an engine is on, or compliance is excluded during a start-up phase.

Don’t apply any Filtering - This is the default option, meaning there are no filters running and all values failing a Grid-based limit or Calculated limit will be marked as a breach.

Variable - Filters the selected compliance data against the data present in another Variable.
Calculation - Filters the selected compliance data against the output of a Calculation.
Aggregate - Filters the selected compliance data against an Aggregate.
Translation - Filters the selected compliance data against a Translation Grid.

Filter Constraints

Each of these filter constraints allows the user to filter using different constraints. For example, if the compliance is conditional of a particular flow rate or an ‘open’/’closed’ value then enter the correct logic into the filter constraint, i.e. ‘Greater than’

Equals – Will breach when the value is equal to. For example, when a pump is running and a value of 1 or 0 is stored.
Not Equal – Opposite to Equals.
Less Than – Breaches when the value is less than the specified value.
Greater Than - Breaches when greater than the specified value.
Between – For this Constraint you will have to add two values to provide a range.
Outside – Opposite to Between.
In the Following list – This is essentially the ‘Equals’ constraint but expanded to enable the use of multiple values and text-based values.
Not in the Following list – Opposite of ‘In the following list’.

Interpolation

Interpolation enables you to use comparison data when it doesn’t match the exact date and time of the primary variables data. For example, a pH value could have an upper limit of 9, but this is only a breach when discharging (recorded from an Open/Closed on a control valve). The control valve value may only record when it Opens and Closes so there won’t be a record at the exact time of the pH value. We, therefore, need to interpolate back to the previous Open/Closed value.

Previous – Interpolates back to the previous value;
Next – Interpolates to the next successive value after (if present);
Always Previous – Continuous interpolates backward (i.e. even if there is a value at the same date/time);
Always Next – Continuous interpolates forwards (i.e. even if there is a value at the same date/time);
Nearest – Interpolates to the nearest value, whether backward or forwards.

Locations

Original Location – Where the data for the comparison and primary data are stored against the same location;

Same reference Location for All – Where the data for the comparison and primary data are stored against two different locations;

Different Reference locations for each Sample Point – Where the data is stored against different sample locations for each primary location (or combination).

Filters

The filters enable users to remove Objects from the Threshold Rule which are included in the overall Compliance. 

Variable Filter

Allows you to filter out Variables that may have been part of an existing Compliance but aren’t needed for the specific Threshold Rule.

Sample Point Filter

Allows you to filter out Sample Points that may have been part of an existing Compliance but aren’t needed for the specific Threshold Rule.

Source Filter

Allows you to filter out Sources that may have been part of an existing Compliance but aren’t needed for the specific Threshold Rule.

Sample Type Filter

This can be used to make the Threshold Rule conditional to certain Sample Types.

Data Qualifiers

This can be used to make the Threshold Rule conditional to certain Data Qualifiers.