Relative Percent Difference II

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports > Statistics >

Relative Percent Difference II

Report Name: Relative Percent Difference II (example)

File Name: EarthSoft.Reports.Library.60983.dll

Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Excel1

 

Description: The Relative Percent Difference (RPD) II report determines the difference between analytical results reported in primary, duplicate, and triplicate samples.

 

Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary.

 

Overview:

The Relative Percent Difference II report includes the following functionality:

1.A user interface for input parameters that is user friendly and easily understandable.

2.The required input parameters are labeled as Required.

3.The Report Result Units and Sample Matrix input parameters are no longer a required selection to generate a report.

4.Sample Matrix is modified from single selection to multiple selection.

5.Analyte group(s) is added onto the user interface.

6.Sample types can be selected for original, duplicate, and triplicate types over the user interface.

 

Notes:

•If the units of measurement for the primary, duplicate, and triplicate samples are different, users need to select Unit(s) or Analyte\Analyte Group(s) to unify units (and ensure the necessary unit conversion factor(s) is present).

•The Relative Percent Difference Report involves multiple calculations, so the processing time may take longer than expected. To avoid problems with delay, users may narrow the data input and/or extend the database connection timeout.

•The Detection limit is a key to this report and the calculations are not valid when results without a detection limit are used in the report. With that in mind, we suggest not using this report until the appropriate detection limit is populated for each of your results.

 

This report includes error diagnosis for no output situations. Error diagnosis can help determine the potential cause for no output, such as: no primary sample data, no duplicate sample data, no triplicate sample data or no matching up of chemical name fractions.

 

Relative Percent Difference Calculation Equation

 

|(x2 - x1)|/((x2 + x1)/2)

 

In Professional Version 6.3 or earlier, |(x2 - x1)|/((|x2| + |x1|)/2)

 

The Report Tab compares the analytical results against the laboratory Practical Quantitation Limit (PQL) of the analyte(s) and any result differences encountered in the primary, secondary, and tertiary sampling. The RPD is calculated as the absolute value of the difference between original and replicate samples divided by the average, and then expressed as a percentage.

 

The report checks RPD and the sample results used to calculate RPD and determines and determines if the analyte falls into a defined RPD control limit category. The RPD control limits can be defined by the report parameter selections. The following describes how the results of Category 1-3 are determined.

 

Assume:

 

RL = "Detection Limit:\Reporting Limit"

 

DL_LL_multiplier =  "Detection Limit:\Lower Limit: (Required)" (defaults to 10)

 

DL_UL_multiplier =  "Detection Limit:\Upper Limit: (Required)" (defaults to 20)

 

RPD_LL =  "Relative Percent Difference:\RPD Lower Limit: (Required)" (defaults to 30%).

 

RPD_UL = "Relative Percent Difference:\RPD Upper Limit: (Required)" (defaults to 50%)

 

Determine the result of Category 1 (primary vs duplicates, sample results), Category 2 (primary vs triplicates) or Category 3 (duplicates vs triplicates) of an analyte based on:

 

Pass: Pass is identified if RPD ≤ RPD_LL.

Pass 1: Pass 1 is identified If

A. Pass is not identified, and

B. Each of the 2 sample results < (use ≤ if UseEqualToInUpperLimit=True) DL_LL_multiplier * RL.

Pass 2: Pass 2 is identified if

A. Pass 1 is not identified, and

B. RPD < (use ≤ if UseEqualToInUpperLimit=True) RPD_UL, and

C. Each of the 2 sample results ≥ ( use > if UseEqualToInUpperLimit=True) DL_LL_multiplier * RL, and

D. Each of the 2 sample results < (use ≤ if UseEqualToInUpperLimit=True) DL_UL_multiplier * RL.

Fail:   Fail Is identified If Pass, Pass 1 and Pass 2 are not identified.

 

Warning: Older databases may contain double "Reportable Result(s)" in the published report. The @reportable parameter was replaced by @reportable_results over time. If both parameters exist in ST_REPORT_PARAMETER, the conflict will prevent the "Reportable Result(s)" parameter from working.

 

Resolution: The fix depends on the contents of ST_USER_REPORT_PARAMETER for user reports of this report. First, filter ST_USER_REPORT_PARAMETER with the REPORT_ID for the RPD II report, found in ST_REPORT.

•Case 1 – Only @reportable (old parameter) exists:
Select all entries in the PARAM_NAME column, then Find and Replace '@reportable' with '@reportable_results'.
 

•Case 2 – Both @reportable (old parameter) and @reportable_results (new parameter) exist:

a.Delete @reportable records for these user reports in ST_USER_REPORT_PARAMETER.

b.Have users double-check the "Reportable Result(s)" parameter in their user reports.
 

•Case 3: Only @reportable_results (new parameter) exists:
No changes to ST_USER_REPORT_PARAMETER needed.

 

After resolving the duplicate parameters in ST_USER_REPORT_PARAMETER, delete the @reportable record for this report in ST_REPORT_PARAMETER.

 

Report Requirements for DT_SAMPLE.SAMPLE_TYPE_CODE

Original Samples

Populate

Results Records

Normal (N or selectable)

DT_RESULT.DETECT_FLAG (either "Y" "Yes"

or "N", "No" depending on the report and the desired results),

DT_RESULT.QUANTITATION_LIMIT,

DT_RESULT.REPORTING_DETECTION_LIMIT,

and DT_RESULT.DETECTION_LIMIT_UNIT.

Duplicate Samples

Populate

Results Records

Any SAMPLE_TYPE_CODE

(Default is Field Duplicates, FD or selectable)

DT_SAMPLE.PARENT_SAMPLE_CODE

must be populated with a value that

matches the DT_SAMPLE.SYS_SAMPLE_CODE

of the original sample. Additionally, the

DT_TEST.FRACTION and CHEMICAL_NAME of the duplicate and triplicate sample records must match that of the original sample.

DT_RESULT.DETECT_FLAG (either "Y",

"Yes" or "N", "No" depending on the report

and the desired results),

DT_RESULT.QUANTITATION_LIMIT,

DT_RESULT.REPORTING_DETECTION_LIMIT,

and DT_RESULT.DETECTION_LIMIT_UNIT.

Triplicate

Populate

Results Records

Any SAMPLE_TYPE_CODE (Default is

Field Triplicates, FT or selectable)

DT_SAMPLE.PARENT_SAMPLE_CODE

must be populated with a value that

matches the DT_SAMPLE.SYS_SAMPLE_CODE

of the original sample. Additionally, the

DT_TEST.FRACTION and CHEMICAL_NAME of the duplicate and triplicate sample records must match that of the original sample.

DT_RESULT.DETECT_FLAG (either "Y",

"Yes" or "N", "No" depending on the report and the desired results),

DT_RESULT.QUANTITATION_LIMIT,

DT_RESULT.REPORTING_DETECTION_LIMIT,

and DT_RESULT.DETECTION_LIMIT_UNIT.

 

Tables: DT_FACILITY, DT_LOCATION, DT_RESULT, DT_SAMPLE, DT_TASK, RT_ANALYTE, RT_GROUP, RT_MATRIX, RT_MTH_ANL_GROUP, RT_SAMPLE_TYPE

 

Report Parameters

Location

Individual(s)

Parameter for selecting individual locations.

Group(s)

Parameter for selecting location groups.

Sample Information

Date Range

Section to select the sample start date and end date.

Sample Type

Original Sample Type (required)

Select the SAMPLE_TYPE_CODE which indicates that this is the original sample.

Duplicate Sample Type (required)

Select the SAMPLE_TYPE_CODE which indicates that this is a duplicate sample.

Triplicate Sample Type

Select the SAMPLE_TYPE_CODE which indicates that this is a triplicate sample.

Matrix(s)

Parameter for selecting sample matrix.

Analyte(s)

Parameter for selecting analtye groups and individual analytes.

Fraction(s)

Parameter for selecting fraction.

Unit(s)

Selection for analyte units.

Task(s)

Parameter selection for one or more task(s).

Delivery Group(s)

Parameter seletion for the delivery group.

Reportable Result(s)

Parameter for selecting reportable results.

Detection Limit

Reporting Limit (required)

Select which reporting limit you desire to use (reporting_detection_limit, method_deteciton_limit, etc.)

Non-detect multiplier

Indicate the non-detect multiplier. Default: 0.5

Non-detect handling

Select how non-detects are handled: eliminate non-detects or show all.

Lower Limit (required)

Indicate the lower limit of the detection limit multiplier standard. Default: 10

Upper Limit (required)

Indicate the upper limit of the detection limit multiplier standard. Default: 20

Relative Percent Difference

RPD lower limit (required)

Indicate the lower limit of the relative percent difference standard. Default: 30

RPD upper limit (required)

Indicate the upper limit of the relative percent difference standard. Default: 50

Replace < with <= in Checking Analysis Results to Get Category 1-3:

Check box to replace < with <= in checking analysis results to determine Category 1-3.

Enter the Maximum Number of Decimals for a Calculated Result:

Enter one integer from 0 to 15.

 

1Excel report output requires a valid license of Microsoft Excel to view the output.

 

 



Copyright © 2023 EarthSoft, Inc • Modified: 06 Dec 2022