ChemStat Report (27490)

<< Click to Display Table of Contents >>

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

ChemStat Report (27490)

Report Name: ChemStat Report 27490

 

Report Type: Standard

 

Description: The Chemstat Report generates a table that presents a statistical analysis for the selected analytes. The report summarizes the entire dataset into a single table with the rows representing each analyte in the dataset, and the columns representing the summary statistics. It allows you to focus in on those analytes and use the spatial and temporal querying tools provided to understand what is going on. It does not show the report by location or by sample, but allows you to easily identify what analytes exceed the Limit Of Detect (LOD) and Action Levels, and the statistics associated with these exceedances. It uses the Analytical Results Report to get source data.

 

The statistics are only calculated if the criteria below are met.

 

Statistic

Criteria

5th Percentile

95% of the results are above LOD*

Median

50% of results are above LOD

Mean

15% of results are above LOD

Standard Deviation

15% of results are above LOD

95th Percentile

5% of results are above LOD

* Limit Of Detect which can be selected as reporting_detection_limit, quantitation_limit, method_detection_limit or mag_reporting_detect_limit over the "Result>Reporting Limit" parameter.

 

1.In finding the minimum and maximum values, non-detects are treated as if they are at the detection limit. If it turns out that one of the non-detects is the minimum or maximum value, then a less-than sign < is inserted before the number.

2.The other statistics are calculated using the standard EQuIS procedure in which the detection limits are multiplied by the Non-Detect Multiplier in the event the measurement turns out to be a non-detect. Calculating the number of action-level exceedances - in the event of non-detects, the detection limit is multiplied by the Non-Detect Multiplier and compared to the action level. This means that non-detects may be considered as exceedances if the product of the detection limit, and the non-detect multiplier, are greater-than the action level.

3.The Chemstat Report has an input parameter called "Check the box to process all data for RV2". Check this box to include all REPORT_RESULT_VALUEs. Uncheck this box to include only detects (aka REPORT_RESULT_VALUE > REPORT_RESULT_LIMIT). Note that the RV2 column of the output is used to calculate the 5th and 95th percentile values.

4.Abnormal or no results in the output for an analyte can be:

a.n.d.: presents Not Determined when the number of detects for an analyte cannot be determined.

b.-: not applicable or no results.

c.Select the 'Check the box to process all data for RV2': suggest to select or check the "Check the box to process all data for RV2'" parameter so that the report will use all detects and non-detects values to calculate the 5th and 95th percentile values. Note that if the parameter is not checked, only the results greater than report_result_limit are used to calculate the 5th and 95th percentiles.

 

Notes:

The Chemstat Report was modified to include the options below.

oTo report the location of the maximum report concentration.

oTo report the location(s) of all the exceedances of the selected action level.

A bug in the calculation of the minimum concentration was also fixed. (76757)

 

Report Dependencies: Analytical Results Report

 

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

 

Contact support@earthsoft.com for a direct link.

 

Language: English

 

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

 

A reporting_limit parameter has been added to the ChemStat Report (27490).

 

Input Parameters

Input Parameter Screenshot

Output Columns

Locations




Select Location(s)



Location Group



Basin
(RT_BASIN.BASIN_CODE)



Location Type


Date Range




Start



End


Analyte




Analyte Groups



Analyte(s)



Matrix



Units


Sample




Sample Type



Sample Method



Depth




Start Depth



End Depth


Reportable Result Flags



GEOLOGIC_UNIT_CODE


Action Levels




Individual(s)



Group


Task Code



Non-Detect Multiplier



Result




Types


Process Multiple Non-Detect Limits of an Analyte at a Location



reporting_limit



                                               

30024-input.param.scrnsht

Contact

support@earthsoft.com

for more information.

 

Tables: DT_SAMPLE, DT_TEST, DT_RESULT, DT_LOCATION, RT_GROUP, RT_METH_ANL_GROUP, DT_ACTION_LEVEL, DT_ACTION_LEVEL_PARAMETER, RT_BASIN, DT_STATIC_PROPS

 

Database Type: v5.5+

 

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

 

Database Version: EQuIS 5+

 

Data Requirements: The report will not export results where DT_SAMPLE.SYS_LOC_CODE or DT_TEST. ANALYSIS_LOCATION are null.

 

Report Requirements: Excel

 

Output Type: Excel Data Table

 

Revision History:

 

In EQuIS 7

 

1.When there is more than one analyte and the last analyte has one result, the last result or analyte of the Raw Data is missed in the Statistics worksheet. In addition, most of the statistic calculations of the analyte prior to the last, are not correct.

2.Another issue is when the last analyte has more than one result, the last row of the results is not used in calculating max or min. The two issues are fixed (139135). In addition, the Result/Unit parameter is marked as required (139072).

3.The report breaks with the error message "...incorrect..." if the value of the min_start_depth or max_end_depth parameter is not provided. The report is modified so that the results of the report are not filtered by dt_sample.start_depth or dt_sample.end_depth if the value of the min_start_depth or max_end_depth parameter is not provided. The issue is fixed (139074).

4.The message "Input string is not in the correct format." for 5th or 95th Percentile is replaced with "Select the 'Check the box to process all data for RV2' parameter to consider non-detects" (case 143095).

 

Example Output:

 

 

30024-ex.output

 

EarthSoft.Reports.Library._27490.UserReport