Lista de Cálculos Predefinidos

Category

Name

Description

Agg, Avg and Sums

Annual Average (select start day)

This calculation is a normal annual count, but it also allows a day of the month to be selected instead of assuming the start is the beginning of the month selected. The result is stored on the last day of each period. So, for example if the Day is set to 2 and the Month to 5 then the result would count records from 2nd May 2011 to the end of 1st May 2012 (23:59:59) and store it on 1st May 2012 (at midnight).

Agg, Avg and Sums

Annual Sum (select start day)

As the Count but a Sum

Agg, Avg and Sums

Annual Sum (select start day) - Summer

This calculation is a normal annual sum, but it also allows a day of the month to be selected instead of assuming the start is the beginning of the month selected. The result is stored on the last day of each period. So, for example if the Day is set to 2 and the Month to 5 then the result would sum records from 2nd May 2011 to the end of 1st May 2012 (23:59:59) and store it on 1st May 2012 (at midnight). Note that the Summer filter means only data from December to February is counted in the final result.

Agg, Avg and Sums

Change Over Time

Calculates the difference between the value at a given time and a date a selected amount of days previously. If no reading is found on that day, it interpolates to the nearest reading it can find.

Agg, Avg and Sums

Conditional Minimum Value

The conditional minimum value function is used to copy values across to a new variable but only when a compared variable recorded at the same location, date and time has a value equal to or greater the limit set up in the calculation.

Agg, Avg and Sums

Conditional Match Text

The conditional text function is used to copy values across to a new variable but only when a compared variable recorded at the same location, date and time exactly matches the text value set up in the calculation.

Agg, Avg and Sums

Cumulative Difference

This calculation will calculate the cumulative difference of two variables from the start of the series. Note that the result is always recalculated for every result going back to the start of the series.

Agg, Avg and Sums

Conditional Daily Maximum

The conditional maximum function is used to determine the maximum value over the selected range of readings. Readings where a different conditional variable are below a trigger value are ignored for the purposes of this calculation.

Agg, Avg and Sums

Conditional Daily Minimum

The conditional maximum function is used to determine the minimum value over the selected range of readings. Readings where a different conditional variable are below a trigger value are ignored for the purposes of this calculation.

Agg, Avg and Sums

Depth Weighted Average

This calculation will calculate the depth weighted average, across a number of sampling locations and depths where each sample point name ends with the depth, i.e. Spt A 1m, Spt A 5m, etc.

Agg, Avg and Sums

Annual Groundwater Drawdown

This calculation determines the difference between the value of two consecutive readings (current minus previous years), the older value being determined by what it was in the same calendar month of the previous year. It only expects one reading per month, and will just select the first value it finds if there are more than one match.

Agg, Avg and Sums

Historic Annual Rainfall

This calculation will calculate the average rainfall either within a calendar month or overall time. Note that the result is written into every result value going back to the start of the series, not just the most recent entry.

Agg, Avg and Sums

Offset Monthly Sum

The offset monthly sum calculation sums all values found starting from an offset date part way into each month (for example 2nd Monday) until an offset into the following month (for example 1st Wednesday), and stores the result as a value in the month at the end of the month the period began in.

Chemicals

Chemical Conversion

This calculation takes a volume or mass of a product (SP) and multiplies it by its composition fraction for each component chemical found to determine the total volume or mass of each component stored/used.

Compliance

CVAC Aluminium Water Quality Guideline

This calculation will calculate the aluminium Water Quality guideline values either for the Chronic (Chronique) or Acute (Aigu) levels.

Compliance

CVAC azote ammoniacal Water Quality Guideline

This calculation will calculate the Ammoniacal Nitrogen (Azote Ammoniacal) Water Quality guideline values either for the Chronic (Chronique) or Acute (Aigu) levels.

Compliance

Copper Water Quality Guideline

This calculation will calculate the copper Water Quality guideline values for either the Chronic or Acute levels

Compliance

Manganese Water Quality Guideline

This calculation will calculate the Manganese Water Quality guideline values given a pH and Hardness.

Compliance

CCME Total Ammonia Water Quality Guideline

This calculates an ammonia limit based on CCME guidance table. The inputs are pH and temp.
https://ccme.ca/en/res/ammonia-en-canadian-water-quality-guidelines-for-the-protection-of-aquatic-life.pdf

Coordinates

Co-ordinate Calculation

Calculates the co-ordinates of the data given a known starting location, a direction (in degrees) and the range. All data with the same sample ref as the input data will be updated with the calculated location.

Coordinates

Co-ordinate Calculation (Decimal Degrees)

Calculates the co-ordinates of the data given a known starting location in decimal degrees, a direction (in degrees) and the range in meters. All data with the same sample ref as the input data will be updated with the calculated location. Note, that this calculation assumes the Earth is spherical, and thus will be slightly inaccurate for extreme latitudes.

Coordinates

Co-ordinate Calculation (Decimal Degrees from fixed point)

Calculates the co-ordinates of the data given a fixed starting location in decimal degrees, a direction (in degrees) and the range in meters. All data at the same date and time for the same sample point as the input data will be updated with the calculated location. Note, that this calculation assumes the Earth is spherical, and thus will be slightly inaccurate for extreme latitudes.

Data Updates

Interval Sample Type Update

Updates Sample Type on an interval for displaying and removing data from a Dataset

Data Validation

Validate Dissolved Oxygen Auto Approve

Calculation that approves data where the Dissolved Oxygen value is below the maximum value considered possible in a natural environment (below 15 by default).

Data Validation

Electrical Conductivity Field vs Lab Auto Approve

Calculation that approves data where the range between Field and Lab pH does not exceed the margin allowed (15 percent different by default).

Data Validation

Ecotoxicity - Ceriodaphnia Dubia Auto Approve

Calculation that approves data where the control lethality does not exceed a given percentage (20 by default), and another parameter is greater than a chosen threshold (15 by default).

Data Validation

Ecotoxicity - Danio Rerio Auto Approve

Calculation that approves data where the control lethality does not exceed a given percentage (10 by default).

Data Validation

Ecotoxicity - Daphnia Similis Auto Approve

Calculation that approves data where the control lethality does not exceed a given percentage (10 by default).

Data Validation

Ecotoxicity - Echinometra lucunter Auto Approve

Calculation that approves data where the remaining larvae in the control does is above a given percentage (80 by default).

Data Validation

Ecotoxicity - Hyalella Azteca Auto Approve

Calculation that approves data where the control lethality does not exceed a given percentage (20 by default)

Data Validation

Ecotoxicity - Mysidopsis Juniae Auto Approve

Calculation that approves data where the control lethality does not exceed a given percentage (10 by default).

Data Validation

Ecotoxicity - Nitocra Auto Approve

Calculation that approves data where the control lethality does not exceed a given percentage (30 by default).

Data Validation

Ecotoxicity - Pseudokirchneriella Subcapitata Auto Approve

Calculation that approves data where the control lethality does not exceed a given percentage (20 by default), and another parameter is greater than a chosen threshold (16 by default).

Data Validation

Ecotoxicity - Skeletonema Costatum Auto Approve

Calculation that approves data where the control lethality does not exceed a given percentage (7 by default), and another parameter is greater than a chosen threshold (16 by default), and the pH is above a given lower limit (1 by default).

Data Validation

pH Field vs Lab Auto Approve

Calculation that approves data where the range between Field and Lab pH does not exceed the a given margin allowed (1 by default).

Data Validation

Validate pH Auto Approve

Calculation that approves data where the pH value is within a normal range (between 0 and 14 by default).

Data Validation

Solid Determinations Auto Approve

Calculation that approves data where the Dissolved and Suspended value is within a certain percentage range of the Total value (8% lower and 12% higher by default).

Data Validation

Validate Temperature Auto Approve

Calculation that approves data where the Temperature value is below the maximum value considered possible in a natural environment (below 35C by default). Extra parameters can be provided that will be invalidated when in a sample that has a temperature that exceeds the given value.

Data Validation

Total vs Dissolved Auto Approve

Calculation that approves data where the Dissolved value does not exceed the Total value by more than a given percentage margin allowed (20% by default).

Data Validation

Below Trigger Text Replacement

This calculation will detect values in the selected list of variables that are below the supplied trigger value and replace them with the text provided. A complete set of duplicate records is created in the selected source, either with the original values as entered for values equal to or above the trigger, or with the replacement text specified for values below the trigger. For example, setting up a trigger of 0 and setting the text to Dry would convert all negative values to a text reading of Dry. The original value is recorded in the comment for reference.

Data Validation

Data Qualifier

Calculation that updates and sets data qualifiers based on a series of rules about data variance, trends and cross-checking of various parameters against each other.

Data Validation

Default Auto Approve

Calculation that approves data which has no other conditional Auto Approve rules set against them.

Data Validation

Excessive Zero Drift Validation

Calculation that updates data for emissions variables to InVld where the value is below a defined maximum allowed limit for zero drift (limit is exclusive of the exact value specified).

Data Validation

Excessive Zero Drift Validation with Error Code Update

Calculation that updates data for emissions variables to B where the value is below a defined maximum allowed limit for zero drift (limit is exclusive of the exact value specified). It also increases a specified error count variable for each occurrence replaced.

Data Validation

Historical Range Qualifier

Calculation that qualifies data where the values are outside the historical range previously reported at the same location in the same quarter. These ranges will be picked up from compliance rules entered in the system with the selected threshold level type.

Data Validation

Hold Time Qualifier

Calculation that updates data whose analysis date relative to the sample date exceeds the hold time determined from the variable suite each variable is associated to with the text I, moving the original value to the comment for reference.

Data Validation

Ionic Balance Qualifier

Calculation that qualifies data where the sum of the reported values of the listed anions and cations are not within an acceptable range of each other.

Data Validation

Non-Numeric Value Validation

Calculation that updates the values for emissions variables to INVLD where the value is in the list of specific non-numeric values (-, Calib, RF232, No value)

Data Validation

TSP to PM2.5 Validation

Calculation that updates data where TSP is below the value of PM2.5, setting both to InVld.

Data Validation

pH Expected Range Qualifier

Calculation that qualifies data where the pH value is outside the expected range (between 5 and 10 by default).

Data Validation

Conditional PM2.5 Validation

Calculation that updates data for PM2.5 to InVld where QTot equals 0.

Data Validation

Summative Qualifier

Calculation that qualifies data where the component values for a particular group of related parameters are over a certain percentage above the reported Total value for the group (up to 20% higher by default).

Data Validation

Dissolved Vs. Total Qualifier

Calculation that updates data where the relative % difference of the dissolved metal reading exceeds the total metal reading by more than a certain percentage with the text XM (only the dissolved value is changed), moving the original value to the comment for reference. Dissolved values that are not more than five times the detection limit are not changed. If not provided the max allowed difference is assumed to be 30%.

Data Validation

Toxic contamination index - Portuguese

Given an input Toxic Contamination Index numeric value, this calculation converts it to a category description, where 0-1.0 is rated as Muito Baixa, 1.0-1.2 Baixa, 1.2-2.0 Média, >2.0 Alta.

Data Validation

Transfer Data Qualifiers

This calculation will transfer the data qualifiers for other standard generic and specific calculations from the root data used in the calculation to their resulting values, merging them if multiple different ones are found. Note this calculation should be ordered so it is after all the calculations intended to be updated this way or it will not transfer the qualifier correctly (unless manually recalculated).

Data Validation

Conditional TSP Validation

Calculation that updates data for TSP to INVLD where TSPQTot equals 0

Data Validation

Water Pollutant Less Than Adjustment

This calculation adjusts less than values so that the numeric value is converted to 0 if at least half of the readings during the reporting year were less than values, or leaves it as calculated by the less than multiplier as normal if not. The start day and month should be set using numeric values (not the month name), so if the Day is set to 2 and the Month to 5 then the result would average records from 2nd May 2011 to the end of 1st May 2012 (23:59:59) and store it on 1st May 2012 (at midnight).

Data Validation

Zero Drift Validation

Calculation that updates data for emissions variables to 0 where the value is below zero, up to a defined limit (inclusive)

Dates

Date Difference

Date Difference function used to determine the difference between the date the record was recorded against compared to the date recorded as the value. By default, the calculation is how many days are between the two dates in question, but the date interval can be set to y, m, d, h, n, or s to calculate the number of years, months, days, hours, minutes, or seconds respectively.

Dates

Date Difference (Ignore Zero)

Date Difference function that determines the difference between the sampling date of two consecutive readings, ignoring any readings where the value is zero. By default, the calculation is how many days are between the two dates in question, but the date interval can be set to y, m, d, h, n, or s to calculate the number of years, months, days, hours, minutes, or seconds respectively.

Dates

Date Diff (Interpolate)

Date Difference function that determines the difference between the sampling date of two consecutive readings. By default, the calculation is how many days are between the two dates in question, but the date interval can be set to y, m, d, h, n, or s to calculate the number of years, months, days, hours, minutes, or seconds respectively.

Dates

Date Difference Match - US Date Format

Date Difference function used to determine the difference between the date of two records compared to each other, with one reading expected for each variable in each calendar month. By default, the calculation is how many days are between the two dates in question, but the date interval can be set to y, m, d, h, n, or s to calculate the number of years, months, days, hours, minutes, or seconds respectively. US Dates only.

Dates

Date Difference Match - UK Date Format

Date Difference function used to determine the difference between the date of two records compared to each other, assuming the entries use a d/m/y date format, with one reading expected for each variable in each calendar month. By default, the calculation is how many days are between the two dates in question, but the date interval can be set to y, m, d, h, n, or s to calculate the number of years, months, days, hours, minutes, or seconds respectively. UK Dates only.

Dates

Deposition Interval

Date Difference function that determines the interval between two readings, where a selected variable alternates between "Start" and "End". By default, the calculation is how many days are between the two dates in question, but the date interval can be set to y, m, d, h, n, or s to calculate the number of years, months, days, hours, minutes, or seconds respectively.

Dates

Days in Month

This Days in Month function is used to determine the number of days in a month. Note that the month in question is determined from either the sample date, or if the variable chosen contains dates, then it will choose the midpoint between the sample date and the date recorded as the value.

Dates

First Reading of Month

This calculation will copy across the first reading found for each month, for each location, from the input variable and store it in the target variable. If necessary, it will remove other previously calculated readings for the same target month and location.

Dates

Last Reading of Month

This calculation will copy across the last reading found for each month, for each location, from the input variable and store it in the target variable. If necessary, it will remove other previously calculated readings for the same target month and location.

Emissions Calcs

Fuel Gas EF Calculation (inc HHV excl H2 adjustment)

This calculation is designed to calculate emissions estimates give incoming Fuel Gas usage, a pollutant EF, and the calculated fuel HHV excluding H2, the fuel H2 mol fraction, and the standard HHV for the fuel.The formula is: {Pollutant EF}*{Fuel Used}*{HHV ex H2}*(1-{H2 mol fraction})/{Std HHV}

Emissions Calcs

Load Calculation Substitution Protocol

LBL/NPI Substitution Calculation - based on the provided expected frequency of readings any missing readings are filled in based on the current year's data, multiplied by 1.2 if less than 85% data is found and 1.3 if less than 80%.

Engine Downtime

Downtime

Date Difference function that determines down time of some equipment or part of a plant, where a selected variable alternates between "On" and "Off". By default, the calculation is how many days are between the two dates in question, but the date interval can be set to y, m, d, h, n, or s to calculate the number of years, months, days, hours, minutes, or seconds respectively.

Engine Downtime

Engine Downtime

Date Difference function that determines engine down time, where a selected variable alternates between "On" and "Off". By default, the calculation is how many days are between the two dates in question, but the date interval can be set to y, m, d, h, n, or s to calculate the number of years, months, days, hours, minutes, or seconds respectively. If downtime runs over to the next week, it inserts a value up to the end of that week, and then the next weeks figure is based from the start of the week instead.

GLOF

GLOF Early Warning System

The Early Warning System calculation is used to generate critical values based on the moving sum of the difference between the square root of modelled and actual river flows expected from measured lake levels. Note that non-numeric readings are ignored for the purposes of this calculation and are assumed to indicate when the river is not flowing (during winter).

GLOF

GLOF Early Warning System V2

The Early Warning System calculation is used to generate critical values based on the moving sum of the difference between the square root of modelled and actual river flows expected from measured lake levels. Note that non-numeric readings are ignored for the purposes of this calculation and are assumed to indicate when the river is not flowing (during winter).

Logger

Barometric Compensation

Calculation to compensate liquid heads from vibrating wire piezometers

Radioactivity

Activity (Bq)

This calculation will find the activity in Bq for a given sample based on the gross counts, background count, self-absorption factor and the counter efficiency.

Radioactivity

Activity (Bq/g)

This calculation will find the activity in Bq/g for a given sample based on the activity in Bq, dry mass, and the ash mass in grams.

Radioactivity

Activity (Bq/m3)

This calculation will find the activity in Bq/m3 for a given sample based on the activity in Bq, volume in ml, and a conversion factor.

Radioactivity

Activity Error

This calculation will find the error for the Activity in Bq for a given sample based on the total and background counts.

Radioactivity

Calibration Data Copy

This calculation will find the most recent calibration data found based on a trigger variable's analysis date and copy the calibration values to the trigger variable's date.

Radioactivity

Combined counting uncertainties as a %

This calculation will combine the errors as a percentage given the tracer count uncertainty and a matching unknown count uncertainty.

Radioactivity

Conversion from Counts

This calculation will convert the value in counts to the required units (e.g. Bq/kg, Bq/m3, nBq/m3, etc.) given the selected isotopes measure value and the matching background count.

Radioactivity

Counting Uncertainty as a %

This calculation will calculate the error in as a percentage given the source count and a matching background count.

Radioactivity

Decision Level (DcL) (Counts)

This calculation will calculate the decision level (DcL) in counts given the selected isotopes background count.

Radioactivity

Detection Level (DtL) (Counts)

This calculation will calculate the detection level (DtL) in counts given the selected isotopes background count.

Radioactivity

Inhalation of Long-Lived Alpha Activity in Dust

This calculation takes the average concentration of activity measured for an area and multiplies it by a dose conversion factor and breathing rate and then multiplies the result by the time spent by each person in the area.

Radioactivity

Error Counts

This calculation will calculate the error in counts given the selected isotopes measure value and the matching background count.

Radioactivity

Gamma2 Multiplier Calculation

This calculation will multiply the input variable by a factor, picked up from a factor variable if a match is found for the sample, if not a default factor set in the calculation is used.

Radioactivity

HVAS Calculation

This calculation will divide the input variable by the volume in m3, retaining all metadata from the input variable. Optionally a factor can be provided to multiply the activity.

Radioactivity

Isotope Count Sum

This calculation will calculate the sum of the counts given for up to three selected isotopes, applying an optional factor for each isotope if provided.

Radioactivity

Mass Difference

This calculation will find the difference between two selected variables for the same location and date, applying a factor to the final result and filtering by sample type if either is provided in the calculation setup.

Radioactivity

This calculation adjusts less than values so that the numeric value is converted to 0 if at least half of the readings during the reporting year were less than values, or leaves it as calculated by the less than multiplier as normal if not. The start month should be set using a numeric value (not the month name), so for example set the Start Month to 7 then the window the check would use would be from July to the following June.

Radioactivity

Self-Absorption Factor

The start month should be set using a numeric value (not the month name), so for example set the Start Month to 7 then the window the check would use would be from July to the following June.',

Radioactivity

Total Counts

This calculation will multiply activity per unit time by the count time to give the Total Counts.

Radioactivity

Total uncertainty as a %

This calculation applies the Type B Uncertainty Factor to the calculated counting uncertainty (or combined counting uncertainty for Alpha).

Radioactivity

Total uncertainty in activity

This calculation multiplies the activity by multiplying the calculated total uncertainty by 1.96

Radioactivity

Tritium DtL (Bq/L)

This calculation applies the Type B Uncertainty Factor to the calculated counting uncertainty (or combined counting uncertainty for Alpha).

Radioactivity

Tritium DtL (BqL)

This calculation converts the calculated tritium detection limit in counts to an equivalent figure in Bq/L

Statistics

Linear Regression

The linear regression function is used to determine the least squares linear regression line slope over the selected range of readings. Note that non-numeric readings are ignored for the purposes of this calculation. The date interval can be set to y, m, d, h, n, or s to calculate the number of years, months, days, hours, minutes or seconds respectively.

Statistics

Linear Regression (Daily Window)

The linear regression function is used to determine the least squares linear regression line slope over the selected range of readings. Note that non-numeric readings are ignored for the purposes of this calculation. A result is created once per day at the start time set, picking up any readings for the duration specified. So if for example the Start Time is set at 8 and the Duration to 10 it will use readings from 8am to 6pm each day it finds readings on. The result is scaled per hour, so for example if the input is Atmospheric Pressure in millibars the output will be Atmospheric Pressure trend in millibars per hour.

Statistics

Linear Regression Trend Text (Daily Window)

This calculation calculates the least squares linear regression line slope over the selected range of readings and the R squared value. Note that non-numeric readings are ignored for the purposes of this calculation. These values are then used to generate a descriptive text value based on the thresholds set up: if R2 is below the trigger the result is VARIABLE, if not then values below the lower limit are STABLE, values above the upper limit are STRONGER RISE (or FALL), values between the limits are WEAKER RISE (or FALL).A result is created once per day at the start time set, picking up any readings for the duration specified. So if for example the Start Time is set at 8 and the Duration to 10 it will use readings from 8am to 6pm each day it finds readings on.

Statistics

Maximum across multiple Variables

This calculation will find the maximum reading found for each date/time, for each location, from the list of variables selected and store it in the target variable.

Statistics

Minimum across multiple Variables

This calculation will find the minimum reading found for each date/time, for each location, from the list of variables selected and store it in the target variable.

Statistics

Coefficient of Determination - R squared (Daily Window)

The R squared function is used to determine how close a fit the least squares linear regression line slope over the selected range of readings was. Note that non-numeric readings are ignored for the purposes of this calculation. A result is created once per day at the start time set, picking up any readings for the duration specified. So if for example the Start Time is set at 8 and the Duration to 10 it will use readings from 8am to 6pm each day it finds readings on. The result is scaled per hour, so for example if the input is Atmospheric Pressure in millibars the output will be Atmospheric Pressure trend in millibars per hour.

Statistics

Annual Average Select Start Day

This calculation is a normal annual average, but it also allows a day of the month to be selected instead of assuming the start is the beginning of the month selected. The result is stored on the last day of each period. So for example if the Day is set to 2 and the Month to 5 then the result would average records from 2nd May 2011 to the end of 1st May 2012 (23:59:59) and store it on 1st May 2012 (at midnight).

Statistics

Annual Two-Year Average

This calculation will calculate the average value for the last 24 months for a given date in each year.

Statistics

CuSum

The cumulative Sum function is used to calculate values to show whether a series of values representing a desired process or function is "in control" or "out of control". This version is designed to track only positive deviations from the stable mean, and the variation is scaled based on the standard deviation of the population.

Statistics

Rolling 80th Percentile

The rolling 90th Percentile function is used to determine the 80th percentile over the selected number of readings. Note that non-numeric readings are ignored for the purposes of this calculation.

Statistics

Rolling 90th Percentile

The rolling 90th Percentile function is used to determine the 90th percentile over the selected number of readings. Note that non-numeric readings are ignored for the purposes of this calculation.

Statistics

Rolling 95th Percentile

The rolling 95th Percentile function is used to determine the 95th percentile over the selected number of readings. Note that non-numeric readings are ignored for the purposes of this calculation.

Statistics

Rolling Average

The rolling average function is used to determine the average over the selected number of readings. Note that non-numeric readings are ignored for the purposes of this calculation.

Statistics

Rolling Average (Aggregate Source)

The rolling average function is used to determine the average over the selected number of readings (ignoring the data source). Note that non-numeric readings are ignored for the purposes of this calculation.

Statistics

Rolling Average (Aggregate Source, count invalid readings)

The rolling average function is used to determine the average over the selected number of readings, ignoring the source of the data. Note that non-numeric readings are included in the count of how many readings we have found for the purposes of this calculation but discarded from the average (NOT treated as if a zero value), so depending on the data found the average may be of fewer values than the number asked for.

Statistics

Rolling Average (count invalid readings)

The rolling average function is used to determine the average over the selected number of readings. Note that non-numeric readings are included in the count of how many readings we have found for the purposes of this calculation but discarded from the average (NOT treated as if a zero value), so depending on the data found the average may be of fewer values than the number asked for.

Statistics

Rolling Average Monthly (Aggregate Source)

The rolling average function is used to determine the average over the selected number of months. All readings for all sources for each combination of sample point and sample type will be combined into a single result.

Statistics

Rolling Maximum (count invalid readings, aggregate sources)

The rolling maximum function is used to determine the maximum over the selected number of readings, ignoring the source of the data. Note that non-numeric readings are included in the count of how many readings we have found for the purposes of this calculation.

Statistics

Rolling Maximum

The rolling maximum function is used to determine the maximum over the selected number of readings. Note that non-numeric readings are included in the count of how many readings we have found for the purposes of this calculation.

Statistics

Rolling Mean plus Standard Deviation Monthly (Aggregate Source)

The rolling mean plus standard deviations function is used to determine the mean average over the selected number of months and also to add a specified number of standard deviations. All readings for all sources for each combination of sample point and sample type will be combined into a single result.

Statistics

Rolling Mean plus Standard Deviation Monthly Filtered (Aggregate Source)

The rolling mean plus standard deviations function is used to determine the mean average over the selected number of months and also to add a specified number of standard deviations. All readings for all sources for each combination of sample point and sample type will be combined into a single result. Only records with no sample type will be used in this calculation.

Statistics

Rolling Median

The rolling median function is used to determine the median over the selected number of readings. Note that non-numeric readings are ignored for the purposes of this calculation.

Statistics

Rolling Median

The rolling median function is used to determine the median over the selected number of readings. Note that non-numeric readings are ignored for the purposes of this calculation.

Statistics

Rolling Minimum (count invalid readings, aggregate sources)

The rolling minimum function is used to determine the minimum over the selected number of readings, ignoring the source of the data. Note that non-numeric readings are included in the count of how many readings we have found for the purposes of this calculation.

Statistics

Rolling Minimum

The rolling minimum function is used to determine the minimum over the selected number of readings. Note that non-numeric readings are included in the count of how many readings we have found for the purposes of this calculation.

Statistics

Rolling Percentile

Rolling Percentile

Statistics

Rolling Sum

Rolling Sum

Statistics

Rolling Sum (Aggregate Source)

Rolling Sum (Aggregate Source)

Statistics

Two Day Mean Average

This calculation is a normal average, except that due to it being for two days it needs to have a start point of the series of day pairs that it creates results for. The result is stored on the end of each summary period. So for example if the series start date is set to 1st January 2016 then the result would average records from 1st and 2nd, 3rd and 4th, etc., if instead the 31st Dec 2015 was used as the start it would pair the 31st Dec 2015 with Jan 1st 2016, the 2nd and 3rd of January 2016, and so on.

Statistics

Mean plus n Standard Deviations of last twelve readings

Calculates the mean plus a specified number of standard deviations and populate user defined fields with the highest "breach" (if any), and the two calculated limits compared against. If a valid compliance and threshold level type is provided that identifies a single compliance rule it will override all existing checking of limits for this compliance rule with the rules of this calculation instead; doing so allows email alerts of threshold breaches, highlighting of breaches in standard functions (and custom functions that support advanced compliance logic), showing calculated limits on standard graphing functions that show advanced compliance limits, etc.

Statistics

Mean plus n Standard Deviations of last twelve readings no LOD (Generic)

Calculates the mean plus a specified number of standard deviations and populate user defined fields with the highest "breach" (if any), and the two calculated limits compared against. If a valid compliance and threshold level type is provided that identifies a single compliance rule it will override all existing checking of limits for this compliance rule with the rules of this calculation instead; doing so allows email alerts of threshold breaches, highlighting of breaches in standard functions (and custom functions that support advanced compliance logic), showing calculated limits on standard graphing functions that show advanced compliance limits, etc.

Testing

Custom Parameter Test Calc

This calculation does not do anything, it was created to test all the different custom parameter lists work as expected.

Translation Grid

Cubic Interpolation of Translation Grid

This calculation will calculate interpolated values for a translation grid by cubic interpolation instead of regular linear interpolation. Note that it is best for normal interpolation to be turned off entirely in the Translation Grid paired with this calculation to avoid unnecessary data histories being created.

Units

Unit Conversion

Standard unit conversion calculation applying a multiplicative factor to the duplicated values. Choose all variables involved on the variable tab, and then select the units to go from and to, and then the factor to apply, and if necessary, an offset. IMPORTANT: The long name of the two variables must be the same if the conversion is to work. For example, if you were to choose Temp (C) to Temp (F) the Factor would be 1.8 and the offset 32 (if dealing with absolute temperatures), or for Temp (F) to Temp (C) use a Factor of 0.5555 and Offset of -32. Note the offset is applied before the factor.

Units

Unit Conversion (Expanded)

Standard unit conversion calculation applying a multiplicative factor to the duplicated values, with the addition of applying to numeric values in Data UDF 2 (if present). Choose all variables involved on the variable tab, and then select the units to go from and to, and then the factor to apply, and if necessary, an offset. IMPORTANT: The long name of the two variables must be the same if the conversion is to work. For example, if you were to choose Temp (C) to Temp (F) the Factor would be 1.8 and the offset 32 (if dealing with absolute temperatures), or for Temp (F) to Temp (C) use a Factor of 0.5555 and Offset of -32. Note the offset is applied before the factor.

Water Quality Index

Water Quality Index

Calculates the National Sanitation Foundation Water Quality Index value, using the additive methodology. Based on the UN GEMS Water Quality guidance a minimum of 4 parameters must be present for an index value to be calculated. Details of the calculation of the index values and their application can be found in Brown, Robert M., et al. "A WATER QUALITY INDEX- DO WE DARE." (1970). Q Values for individual parameters calculated according to rating curve formula given by Raveendra Kumar Rai, et al., in The Yamuna River Basin: Water Resources and Environment (2011).

Water Quality Index

Water Quality Index Text

Given an input Water Quality Index numeric value, this calculation converts it to a category description, where 0-25 is rated as Poor, 25-50 Fair, 50-70 Medium, 70-90 Good, and 90-100 Excellent.

Water Quality Index

Water Quality Index Text - Portuguese

Given an input Water Quality Index numeric value, this calculation converts it to a category description, where 0-25 is rated as Poor, 25-50 Fair, 50-70 Medium, 70-90 Good, and 90-100 Excellent.

Water Quality Index

Water Quality Index Text (Spanish)

Given an input Water Quality Index numeric value, this calculation converts it to a category description, where 0-25 is rated as Pobre, 25-50 Justa, 50-70 Medio, 70-90 Bueno, and 90-100 Excelente