Relative Percent Difference

<< Click to Display Table of Contents >>

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

Relative Percent Difference

Report Name: Relative Percent Difference (21339)

 

Report Type: Standard

 

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

 

Once these fields are populated, it is possible to run the report. The first step in this process is to choose the parameters. If any of the following fields are not populated correctly or if the location chosen in the report does not have duplicate or triplicates associated with the original sample, a “Report did not generate output” prompt will appear.

 

Note: Only values of DT_RESULT.REPORTABLE_RESULT “Yes” or "Y" are returned. Report Result Units and Sample Matrix must be selected for the report to run.

 

Once parameter selections have been made, click the GO button. The report output will be displayed in two separate tabs in Excel.

 

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 or

 

Relative Percent Difference calculation equation: |(x2 - x1)|/((x2 + x1)/2).

 

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 (see chart below for default parameters).

 

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.

 

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

 

Language: English

 

Input Parameters: A selection made to customize the output of a report.

 

Input Parameters

Input Parameter Screenshot

Output Columns

LOR option

(select limit of reporting)


non-detect handling



Location




Group(s)



Individual(s)


Sample




Matrix(es)



Analyte(s)



Units



Date Range




Start



End

Delivery Group(s)



Task(s)



Non-Detect Multiplier



RPD lower limit



RPD upper limit



LOR multiple lower limit



LOR multiple upper limit



Sample type code for original sample



Sample type code for duplicate sample



Sample type code for triplicate sample









                                               

30269_input

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: 6.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 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 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

 

Revision History: In version 7.0, the revisions below have been completed.

 

When the report is published in a facility, the value of the facilty_id is hard coded in the data sources of the Sample\Units and Sample type code parameters in ST_REPORT_PARAMETER. If a facility other than the report-published facility is connected, the Sample\Units and Sample type code parameters may not list correct items. This issue is resolved (Case 133093).

 

Example Output: View the following example.

 

30269_output