Lista de Cálculos Predefinidos

Group

Name

Comments

Agg, Avg and Sums

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

Agg, Avg and Sums

Annual Count (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)

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

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

Annual Two Year Average

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

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

Combined Sample Points All Time Sum

This calculation will calculate the sum for the each variable chosen and add up all selected sample points for all time and put them into a chosen sample point.

Agg, Avg and Sums

Combined Variables All Time Sum

This calculation will calculate the sum for the each sample point chosen and add up all selected variables for all time up to the calculation date and put them into a chosen variable.

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 are always recalculated for every result going back to the start of the series.

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 determine 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 over all 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.

Agg, Avg and Sums

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.

Agg, Avg and Sums

Weekly Sum Select Start Date

This calculation will calculate the weekly sum with a starting date based on the parameter provided - with 1 meaning Monday, 2 Tuesday up to 7 for Sunday.

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

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

Compliance

CVAC azote ammoniacal

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

Compliance

BCWQG Ammoniacal Nitrogen

This calculation will calculate the Ammoniacal Nitrogen Water Quality guideline values for BC either for the Chronic or Acute 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 NH3 Limit

This calculation will calculate the Total Ammonia  Water Quality guideline values either for the protection of aquatic life.

Compliance

Multivariable Range Filter Flag

This calculation is intended to be used with the compliance filtering option, if all variables selected are within the numeric ranges provided the result is YES, otherwise the result is NO. The readings must all be at the same location and date/time, any that are missing are presumed to be within the range.

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 Validation

Update Sample Type After Interval

Calculation that changes the sample type of any data after a certain amount of days has passed since it was first imported (default 30).

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 exceeed 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 exceeed a given percentage (20 by default), and another parameter is greater than a chosen threshold (15 by default).

Data Validation

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

Data Validation

Ecotoxicity - Danio Rerio Auto Approve

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

Data Validation

Ecotoxicity - Daphnia Similis Auto Approve

Calculation that approves data where the control lethality does not exceeed 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 exceeed a given percentage (20 by default).

Data Validation

Ecotoxicity - Mysidopsis Juniae Auto Approve

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

Data Validation

Ecotoxicity - Nitocra Auto Approve

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

Data Validation

Ecotoxicity - Pseudokirchneriella Subcapitata Auto Approve

Ecotoxicity - Pseudokirchneriella Subcapitata Auto Approve

Data Validation

Ecotoxicity - Skeletonema Costatum Auto Approve

Calculation that approves data where the control lethality does not exceeed 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 exceeed 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 exceeed the Total value by more that 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 occurence 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

QAQC Accuracy of Field Duplicates Range Check

Calculation that adds PASS/FAIL flag where the absolute range between normal and duplicate samples exceeds the specified limit (default 0.4).

Data Validation

QAQC Accuracy of Field Duplicates RPD Check

Calculation that adds PASS/FAIL flag where the RPD between normal and duplicate samples exceeds the specified limit (default 30).

Data Validation

QAQC Field Blanks Check

Calculation that adds PASS/FAIL flag where values for field blanks are above the detection limit.

Data Validation

QAQC Field vs Lab RPD Check

Calculation that adds PASS/FAIL flag when the calculated RPD for field and lab values for the same parameter are different by more than the limit set (30 by default), and the value is more than a certain multiplier of the LOD (10 by default).

Data Validation

QAQC Field vs Lab Range Check

Calculation that adds PASS/FAIL flag when values for field and lab values for the same parameter are different by more than an absolute limit (0.4 by default).

Data Validation

QAQC Hold Time Check

Calculation that adds PASS/FAIL flag where the difference between the sample date and analysis date exceeds the specified number of days (default 5).

Data Validation

QAQC Ionic Balance Check

Calculation that adds PASS/FAIL flag when values for anions and cations are different by more than a percentage limit (10% by default), and the EC is greater than an absolute limit (100 by default).

Data Validation

QAQC Lab vs Lab RPD Check

Calculation that adds PASS/FAIL flag when the calculated RPD for two different lab values for the same parameter are different by more than the limit set (30 by default), and the value is more than a certain multiplier of the LOD (10 by default).

Data Validation

QAQC Outliers Percentage Check

Calculation that adds PASS/FAIL flag when a parameter is greater or less than the highest and lowest of the most recent readings (10 by default) by more than the percentage limit set (50 by default), and the value is more than a certain multiplier of the LOD (10 by default).

Data Validation

QAQC Sample Temperature Check

Calculation that adds PASS/FAIL flag where the sample temperature at arrival or of the cool box exceeds the specified limit (default 4).

Data Validation

QAQC Sampling Location Check

Calculation that adds PASS/FAIL flag where the distance between the data and sample point locations is greater than a selected amount, by default 20m.

Data Validation

QAQC Total vs Dissolved Metals Check

Calculation that adds PASS/FAIL flag when the Total parameter for a metal compared to the Dissolved parameter is greater by more than the limit set (10 by default), and the value is more than a certain multiplier of the LOD (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 dissovled value is changed), moving the original value to the comment for reference. Dissolved values that are not more than five tiems 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

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.

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.

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

Demo Database - Keep Data Current

This calculation will check if there is any undeleted data in the previous complete month (so on 1st July it will see if there is any data in June), and update the sample date to shuffle all the data forwards into the empty month.

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

Logger

Barometric Compensation

Calculation to compensate liquid heads from vibrating wire peizometers

Logger

Elevation Interpolated Barometric Compensation

Calculation to calculate interpolated barometric pressure for other locations via linear regression between multiple readings at different elevations, generating calculated pressure values for all other locations selected in the calculation. Elevations are found for all locations in a factor table.

Statisitics

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.

Statisitics

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.

Statisitics

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.

Statisitics

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.

Statisitics

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.

Statisitics

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

CuSum

Cumulative Sum function 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

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.

Statistics

Conditional Daily Minimum

The conditional minimum 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.

Statistics

Enhanced Seasonal Mann Kendall Compliance Check

This calculation will copy across the input value if it is valid for a compliance check to be made, blanking the value so it does not get checked if a Seasonal Mann Kendall test shows the trend is not increasing, and for locations not near a water source if a secondary compliance limit is not exceeded in the current value.

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 (count invalid readings, aggregate sources)

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

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 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 1 or more times the mean plus a specified number of standard deviations (which can be zero) and populate user defined fields with the highest "breach" (if any), and the two calculated limits compared against. Default values are 1 for number of means, 4 for number of standard deviations and 12 for number of rows. 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

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.

Translation Grid

Cubic Interpolation of Translation Grid

This calculation will calculate interpolated values for a translation grid by cubic interpolation instead of the 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 Balance

Dynamic Stage Curve

This calculation will calculate the volume based on the depth using the most recent survey information available up to that point in time.

Water Balance

Dynamic Stage Curve Time Decay

This calculation will calculate the volume based on the depth using the most recent survey information available up to that point in time, also factoring in the accumulation of tailings raising the minimum pond elevation over time from the most recent survey date.

Water Balance

Rating Curve Flow Calculation

Calculation that takes a river level and using the most recently found entries for the coefficients a and b, reference water level (H0) and optionally an offset, calculates the flow.

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 Muito ruim, 25-50 Ruim, 50-70 Médio, 70-90 Bom, and 90-100 Excelente.

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.