Statistics: Samples, Statistics and Exceedances of Each Location

Report Name: Statistics - Samples, Statistics and Exceedances of Each Location (example)

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

Dependencies: saved (Beta) Analytical Results or Analytical Results report

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Excel1

Description: In past versions of EQuIS, this report was titled Statistics: Analyte by Sample Transpose. The report lists sample values and calculates the statistics, such as the Number of Samples, the Number of Detects, Maximum, Mean, 95% UCL, and Minimum and Standard Deviation based on a saved Analytical Results Report. The report can also report action level exceedances, if the Action Level input is selected.

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

Overview:

If a sample value or a statistical value (Max and Mean) is greater than an action level value, the value is colored. Each Excel worksheet holds the results of a location. A user selection of "Transpose results of each location" is provided to transpose the results.

The "Use non-detects" parameter is used to include or exclude non-detects in the output, and the list of the "Save Analytical Results Report" parameter includes pick reports from both Analytical Results and (Beta) Analytical Results.

Notes:

The saved Analytical Results Report used needs to meet the following requirements:

•The output should contain only one matrix.

•Method Analyte Groups (MAGs) must be used; do not select individual or no analytes.

•The MAGs selected for the report must have the default_unit defined for all analytes.

Tables: All tables used by the Analytical Results or Analytical Results II reports in addition to DT_ACTION_LEVEL, DT_ACTION_LEVEL_PARAMETER, DT_ACTION_LEVEL_PARAMETER, DT_ALS, RT_ANALYTE, RT_MATRIX, RT_MATRIX, RT_MTH_ANL_GROUP, RT_MTH_ANL_GROUP_MEMBER, ST_REPORT, ST_USER_REPORT

Report Parameters

Saved Analytical Results Report	Select a saved Analytical Results user report.
Action Level(s)	Parameter for selecting action levels.
Transpose results of each location	Parameter for transposing results each location. Default: false
Use non-detects	Parameter to use non-detects. Default: true

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