Navigation:  Exports and Outputs > Chemistry Output Tables

 

The Chemistry Output Tables Factual Reporting exports chemistry data and guidelines in a series of formats which are suitable for automated reporting.

 

The example below shows compounds down the left of the page, any exceedance is highlighted the relevant colour, exceedances of both are highlighted in the colour of the exceedance with the highest value, detects are in bold.

Filtering Data

Data can be filtered by either:

A) Using the applied data filter in ESdat (if chemistry data is being filtered at the time),

 

or

 

B) Selecting the data on the basis of Matrix Type; Sample Delivery Group or Date Range; and analysis Method Type

 

Groupings

Data can be grouped by either No Grouping, Chem_Group, Method_Type, or Method_Name.  Chem_Group is user definable in the zRef_Chemistry_Lookup table; Method_Type comes from the lab, and should closely match requests on your COC (ie Pesticides, PAHs etc..); Method_Name is the method the lab used to obtain the result.

 

Location/Sample Data

THe fields listed here are all the Sample, Chemistry, and other fields at the Sample level or higher which are included in the chemistry output queries.  You can select what you need.  Additional fields can be added to the queries.

 

Statistical Summary

The summary is calculated by custom functions embedded in Excel.  This means that they are updated if changes are made to the output data (such as deleting a guideline).  The 95th UCL is not calculated due to issues regarding distribution of the results (ie normal, log-normal, non-parametric).  It is recommended that for the compounds where a 95th percentile is required the export to ProUCL be used.