Action Level Exceedance Format III

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports > Action Levels >

Action Level Exceedance Format III

Report Name: Action Level Exceedance Format III (example)

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

Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Excel1

 

Description: The Action Level Exceedance Format III Report generates cross-tabbed analytic results with or without action level exceedances. The row headers are chemical_name (Analyte), report_result_unit (Units), report_result_limit (Limits), and action levels if selected. Its column headers are SYS_LOC_CODE (Station ID), SYS_SAMPLE_CODE (Sample ID), MATRIX_CODE (Matrix), SAMPLE_DATE (Sample Date). This allows you to add lab_qualifiers after results and export RT_QUALIFIER.REMARK as a footnote.

 

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

 

Overview:

Two types of action level comparisons are possible.

 

1.The first is to compare each of the action level values of selected action level codes to a result where the Action Level\Select action level comparison method\All parameter is selected.

2.The second is when the Action Level\Select action level comparison method\First and/or min of the rest parameter is selected, the report compares the action level value of the first action level code to a result, and continues to compare the minimum of the action level values of the rest of the action level codes to the result if the result is not flagged to the first action level. It is a class report and obtains source data using the Analytical Results II Report.

 

The Action Level Exceedance Format III Report uses the same tables as the Analytical Results II Report, in addition to the following tables: DT_ACTION_LEVEL,

DT_ACTION_LEVEL_PARAMETER.

 

This report features an option to select an Excel template with customized titles and notes (example: ALEF3_template.xlsx). Note the template file must be placed at ...\My EQuIS Work\ folder or uploaded to DT_FILE. The insert_from_here must be populated in a cell of Column A of the template file so that the report will insert cross- tabbed results from the row the insert_from_here is at. If including action levels with this report, an ActionLevelFormats.xlsx must be stored in DT_FILE (uploaded via Docs & Photos Form). When this is missing, the action level list will be empty.

 

Warning: Do not enter a file name into the Template/File Name parameter if no template file is used.

 

Report Parameters *

Location

Parameter section for selecting individual locations, location groups and whether to use DT_GEOGRAPHY for coordinates.

Sample

Section for selecting sample related parameters.

Test

Section for selecting test related parameters.

Results

Section for selecting result related parameters.

Header

Section for adding up to 3 header lines of text.

Footer

Section for adding up to 2 footer lines of text.

Note

Section for adding up to 5 note lines of text.

Output Type

Output type parameter: xls, xlsx, pdf

WaterMark

True | False parameter for including a watermark

Action Level


Action Level(s)

Select one or more action levels.

Enter a multiplier for all action level limits

Multiplier for action levels. Default value is 1.

Display exceedances Only

True | False parameter for only displaying exceedances.

Use action level units

True | False parameter for using action level units.

 

Comparison operator

Select an operator: <, <=, >, >=

Limit summed action levels

True | False parameter to limit summed action levels.

Use non-detects

True | False paramter to use non-detects

Columns per page for pdf

Parameter for setting column limit for pdf files

Rows per page for pdf

Parameter for setting row limit for pdf files

* This report contains hidden parameters that could affect the output of the report.

 

Consult an EQuIS administrator if these parameters should be visible or use different default values in a published report (a report that allows saving of user reports). These paramaters cannot be viewed or changed in unpublished reports outside of a report parameter file.

 

 

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