Relative Percent Difference II

<< Click to Display Table of Contents >>

EQuIS 7  >>  EQuIS Library > Reports > EarthSoft Standard Reports > Statistics Reports >

Relative Percent Difference II

Report Name: Relative Percent Difference II (60983)

previously called Relative Percent Difference_v2

 

Report Type: Standard

 

Description: The Relative Percent Difference II Report (RDP) determines the difference between analytical results reported in primary, duplicate, and triplicate samples. It is an improved version of the former RDP Report. In addition to bug fixes, the new RDP has the improvements listed below.

 

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.

 

In addition, the new functionality of error diagnosis for no output situations is added to the report. Error diagnosis can now tell whether, if a possible reason

for no output comes from 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 the results for each analyte 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 and by default are the following.

 

Pass: RPD is less than or equal to 30%

Pass 1: RPD is greater than 30%, and the Analysis results are less than 10 times the limit of reporting (LOR)

Pass 2: RPD is between 30% and 50%, and the Analysis results are between 10 and 20 times the LOR

 

If the RPD exceeds the control limits, it is highlighted.

 

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.

 

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

 

Language: English

 

Input Parameters: A selection that customizes the output of a report.

 

Input Parameters

Input Parameter Screenshot

Output Columns

Location




Individual(s)



Group(s)


Sample Information




Sample Type




Original Sample Type (Required)



Duplicate Sample Type (Required)



Triplicate Sample Type


Matrix(es)



Analyte




Analyte Group(s)



Individual Analyte(s)


Fraction(s)



Unit(s)



Task(s)



Delivery Group(s)



Reportable Result(s)


Detection Limit




Reporting Limit (Required)



Non-Detect Multiplier



Non-Detect Handling



Lower Limit (Required)



Upper Limit (Required)


Relative Percent Difference



RPD Lower Limit (Required)



RPD Upper Limit (Required)



                                               

30184-input.params

Contact

support@earthsoft.com
for more information.

 

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

 

Database Type: SQL Server

 

Database Schema: Standard (no custom or add-on schema required)

 

Database Version: 5.6+

 

Data Requirements: None

 

Report Requirements: Excel

 

Report Requirements

Sample Fields

Code

Populate

Results Records

Original

DT_SAMPLE.SAMPLE_TYPE_CODE

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

DT_SAMPLE.SAMPLE_TYPE_CODE

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 the 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

DT_SAMPLE.SAMPLE_TYPE_CODE

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

 

Output Type: Excel/HTML

 

Revision History:

 

1.In version 7.0, the following issue is fixed: the report copied duplicate results to the fields of triplicate results when the Triplicate Sample Type parameter was not selected.  (Case 138301)

 

Example Output: View the following example.

 

30184-ex.output_zoom52