Relative Percent Difference IV

Report Name: Relative Percent Difference IV (example)

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

Dependencies: "Analytical Results II" (EarthSoft.Reports.Library.50943.dll) report

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Report Grid1

Description: The report calculates Relative Percent Difference (RPD) between analytical results reported in primary (PRI), duplicate (DUP), and triplicate (TRI) samples; examines them against RPD\Limit (RPD_LIMIT) and RPD\Warning Limit (RPD_WARNING_LIMIT); and generates a summary of RPD related information along with the details of primary sample information. The report uses the "Analytical Results II" report to obtain the data of PRI, DUP and TRI samples.

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

RPD Calculation

PRI_VS_DUP_RPD, PRI_VS_TRI_RPD, or DUP_VS_TRI_RPD is calculated by the following equation with a unit (RPD_UNIT) of “%”:

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

where x1 and x2 represents PRI_REPORT_RESULT_VALUE and DUP_REPORT_RESULT_VALUE, PRI_REPORT_RESULT_VALUE and TRI_REPORT_RESULT_VALUE, or DUP_REPORT_RESULT_VALUE and TRI_REPORT_RESULT_VALUE.

RPD Examination

PRI_VS_DUP_LIMIT_FLAG, PRI_VS_TRI_LIMIT_FLAG, or DUP_VS_TRI_LIMIT_FLAG = ‘fail’ when the following occurs:

•PRI_VS_DUP_RPD, PRI_VS_TRI_RPD or DUP_VS_TRI_RPD > RPD_LIMIT when the RPD\Comparison Operator input parameter is ‘<=’, or

•PRI_VS_DUP_RPD, PRI_VS_TRI_RPD or DUP_VS_TRI_RPD >= RPD_LIMIT when the RPD\Comparison Operator input parameter is ‘<’.

Similarly, PRI_VS_DUP_WARNING_FLAG, PRI_VS_TRI_WARNING_FLAG, or DUP_VS_TRI_WARNING_FLAG = ‘warn’ when the following occurs:

•PRI_VS_DUP_RPD, PRI_VS_TRI_RPD or DUP_VS_TRI_RPD > RPD_WARNING_LIMIT when the RPD\Comparison Operator input parameter is ‘<=’, or

•PRI_VS_DUP_RPD, PRI_VS_TRI_RPD or DUP_VS_TRI_RPD >= RPD_WARNING_LIMIT when the RPD\Comparison Operator input parameter is ‘<’.

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

Report Parameters	Remark
Analytical Results section	See the input parameters of "Analytical Results II" report. Note that Sample/Type(s) and Result/Non-Detect Multiplier are removed.
Relative Percent Difference section
Sample Type
Original Sample Type	Required and mapped to PRI_SAMPLE_TYPE_CODE in output. Select DT_SAMPLE.SAMPLE_TYPE_CODE to represent primary samples.
Duplicate Sample Type	Required and mapped to DUP_SAMPLE_TYPE_CODE in output. Select DT_SAMPLE.SAMPLE_TYPE_CODE to represent duplicate samples.
Triplicate Sample Type	Mapped to TRI_SAMPLE_TYPE_CODE in output. Select DT_SAMPLE.SAMPLE_TYPE_CODE to represent triplicate samples.
Detection Limit Multiplier	Required, defaults to 1. PRI_REPORT_RESULT_VALUE, DUP_REPORT_RESULT_VALUE or TRI_REPORT_RESULT_VALUE is multiplied by this number when it is non-detect.
Ignore Non-Detect RPD	Defaults to False (or unchecked). Skip the calculation of PRI_VS_DUP_RPD, PRI_VS_TRI_RPD, or DUP_VS_TRI_RPD if a non-detect value is used when the parameter box is checked. Otherwise, the RPD calculations include non-detects.
Limit	Required, defaults to 20, and mapped to RPD_LIMIT in output. See its use in RPD Examination.
Warning Limit	Mapped to RPD_WARNING_LIMIT in output. See its use in RPD Examination.
Comparison Operator	Defaults to '<='and mapped to COMPARISON_OPERATOR in output. See its use in RPD Examination.
Enter the Maximum Number of Decimals for a Calculated Result	Used to round a RPD value and defaults to 2 (e.g., PRI_VS_DUP_RDP is calculated as 50.123 and then equals to 50.12 after rounded by 2).

1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer.