Predefined Calculation List

A list of all the MonitorPro Predefined Calculations

Introduction

MonitorPro has several flexible calculation options available to the users, such as Aggregates (for aggregating data over time), Translation Grids (for transposing data), and the General Calculator for a range of other configurations. In some situations, there is a need for particular, or custom calculation logic to meet a user's needs or to save time creating them using the other inbuilt calculators. To facilitate this MonitorPro has the Predefined Calculator. This enables specific logic to be built in, either offering a much quicker way of configuring complex scenarios, or workflow which cannot be achieved by other means within MonitorPro.

To achieve this a library of calculations has been made and can be activated on request. The list details below the general function of these calculations and their general function.

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.