Report Name: Action Level Exceedance Format III (example)
File Name: EarthSoft.Reports.Library.111561.dll
Software: EQuIS Professional and EQuIS Enterprise
Source: EQuIS Professional install
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.
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,
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.
* This table shows partially expanded parameters. Refer to related report articles for complete input parameter lists (e.g. Analytical Results II.)
** The Additional Fields parameter may be customized as explained in the help article How To Customize Additional Fields Parameter.
*** This report contains hidden parameters: Matrix code for groundwater and Enter the max decimal place for the results of the report
Copyright © 2022 EarthSoft, Inc • Modified: 25 Nov 2021