Box and Whisker

Report Name: Box and Whisker (example)

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

Report Dependencies: Analytical Results Trend Plot Report and Analytical Results II

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Excel1

Description: The Box and Whisker report uses Analytical Results II report source data to calculate statistic data and generate box and whisker charts.

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

Overview:

The basic statistic calculation equations from Excel used in the report can be found in the box_whisker_data worksheet of the output. It is encapsulated in the EarthSoft.Reports.Library.67219.dll. Since the Syncfusion of the current version (11.3040.0.30) has bugs in drawing Error-bar of a plot, an embedded Excel template with macro is used.

Input Parameters: A selection made to customize the output of a report. Note the report has all the parameters of the ARII Report, except the Additional Fields parameter. The input parameters in the table below are visible to users; all other parameters are hidden by default. Users can publish the report and make those hidden parameters visible in ST_REPORT_PARAMETER if necessary.

Table Source FACILITY_ID, FACILITY_CODE, SYS_LOC_CODE, LOC_NAME, SAMPLE_ID, SYS_SAMPLE_CODE, SAMPLE_NAME, SAMPLE_DATE, SAMPLE_TYPE_CODE, START_DEPTH, END_DEPTH, DEPTH_UNIT, MATRIX_CODE, TASK_CODE, PARENT_SAMPLE_CODE, ANALYSIS_LOCATION, LAB_SAMPLE_ID, LAB_MATRIX_CODE, LAB_NAME_CODE, ANALYTIC_METHOD, ANALYSIS_DATE, COLUMN_NUMBER, FRACTION, TEST_TYPE, PREP_METHOD, LEACHATE_METHOD, LEACHATE_DATE, LAB_SDG, PERCENT_MOISTURE, DILUTION_FACTOR, TEST_ID, CAS_RN, CHEMICAL_NAME, ORGANIC_YN, REPORT_RESULT_TEXT, REPORT_RESULT_VALUE, REPORT_RESULT_UNIT, REPORT_RESULT_LIMIT, REPORTABLE_RESULT, DETECT_FLAG, INTERPRETED_QUALIFIERS, VALIDATOR_QUALIFIERS, LAB_QUALIFIERS, QUANTITATION_LIMIT, METHOD_DETECTION_LIMIT, REPORTING_DETECTION_LIMIT, DETECTION_LIMIT_UNIT, APPROVAL_CODE, RESULT_TEXT, RESULT_NUMERIC, RESULT_UNIT, RESULT_TYPE_CODE, X_COORD, Y_COORD, Z_COORD_AVG, ZFROM, ZTO, LONGTITUDE, LATITUDE, LOC_GROUP_CODE, LOC_REPORT_ORDER

Report Parameters*

Location
Individual(s)	Parameter for selecting individual locations.
Group(s)	Parameter for selecting location groups.
Sample
Date Range	Section to select the start date, end date, most recent sampling, and the option to use date range to select the most recent sampling events
Result
Analyte	Section for selecting analytes and/or analyte groups.
Plot
Plot Group Type	Select how to group plots.
The number of plots per print page	Select the number of plots per page.
Logo file name:	Logo file name to be used in left header.

* This report may include hidden parameter(s) 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.

Report Output
1. The plots worksheet with box and whisker charts. 2. The analytical_results_data worksheet with source data. 3. The box_whisker_data worksheet with statistics data.

Report Output

1. The plots worksheet with box and whisker charts.

2. The analytical_results_data worksheet with source data.

3. The box_whisker_data worksheet with statistics data.

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