ESdat logo
Solutions
ESdat to import analyze report
your environmental data
Optional Upgrades
Industries
Countries
Support
About

Chemistry Tables

The main components of the Chemistry Table are:

  1. The menu, that controls the Table layout and display.
  2. Analyte Groups, this can be customised under Chem Profile.
  3. The Analytes, the Analyte Name, Order and Output Unit can be customised under Chem Profile 
  4. Environmental Standards: which can be controlled from the Env Standards menu.
  5. Sample Details.  These can be turned on and off and ordered in the Sample Information menu.
  6. Statistics for the results (these can be hidden).
  7. Result details & comments, click on the button to toggle this panel on or off.

Saving your Settings

The Table Layout allows you to save your menu options so they can be easily reapplied to a table.

The Chem Table is automatically refreshed as you make changes to any of the Layout options.  If you are planning on making several changes, you can disable the automatic refresh by clicking the pause buttonclip4076.  Hit the play buttonclip4075to resume refreshing the table.

Environmental Standards

Environmental Standards which are loaded into the system can be displayed and formatted under the Env Standards menu.

If users need to consolidate multiple Action Levels into one, this can be done using the MetaStandards functionality.

Sometimes standards can have variable Action Levels conditional on pH, Hardness or other parameters (termed Conditional Standards in ESdat).  Users can choose to show each Action Level or can show a range from the min to max. Hovering over the cell will show all the Action Levels.

clip4090

Sample Information

The Sample Information menu allows users to choose which fields are shown on the Chemistry Table.  Much of the basic Sample Information (such as Location and Depth) can be edited on the Lab Report Details page, the Field Portal or bulk edited in the Import / Update / Export section.

The Samples shown on the Chemistry Table are sorted in the order of the displayed Sample fields.  The order of the fields can be altered by dragging the names on the menu.

If you want to sort your data by Location and then by Date, you would set the Samples to show the Location before the Date. 

Statistics

The following Statistics can be shown on the Chem Table:

clip4098

The geometric average / standard deviation is also known as the log average / standard deviation. 

Result Details, Qualifiers and Comments.

Users can see full details for a result by toggling on the Result Details and Comments panel and then clicking on each result in the Chem Table.  

This shows the result data as is it stored in the database and allows users to enter their own data Validation and Final qualifiers and comments for each individual result.  This can be useful where there may be an issue with a result, or where concentrations are high.

Users can define their own Qualifiers, however it is recommended the standard USEPA qualifiers be used where applicable:

  • U        The analyte was analyzed for, but was not detected above the level of the Reported sample quantitation limit.
  • J        The result is an estimated quantity. The associated numerical value is the approximate concentration of the analyte in the sample.
  • J+        The result is an estimated quantity, but the result may be biased high.
  • J-        The result is an estimated quantity, but the result may be biased low.
  • R        The data are unusable. The sample results are rejected due to serious deficiencies in meeting Quality Control (QC) criteria. The analyte may or may not be present in the sample.
  • UJ        The analyte was analyzed for, but was not detected. The Reported quantitation limit is approximate and may be inaccurate or imprecise.

Result Qualifiers and Comments can be displayed against each result on the main body of the table using the Results Menu.

If all of the Final, Validation and Lab Qualifer are turned on, just the Final Qualifier will show against a result, if it is populated.  If it isn’t populated the Validation Qualifier will show (if populated), otherwise the Lab Qualifier will show.  Comments works likewise.

Excel Export

The Excel Export menu allows users to export the Chem Table to Excel, as well as configuring default export settings.

clip4104

There are two orientation options for exporting a Chem Table to Excel:

  1. Horizontal – exports the Chem Names horizontally across the page (ie as shown in the browser).
  2. Vertical – export the Chem Names vertically down the page

The Excel Export Settings allow users to configure settings for the print view and how the report will be shown in Excel.

clip4107
clip4108

Header and footer content can be automatically populated with Project or Site details using a drop-down of available data fields.  Auto values (populated by ESdat or Excel) are shown with a red border.  If a logo has been uploaded in Licencee Management it will also be available in this drop down. 

Free text can also be typed into the cell with font formatting available.  

clip4110

The Footer content is configured the same as for the Header, and has the same options.

clip4111

There is a length limit to how much content can be set in Excel headers and footers, which is an Excel constraint. If the allowed length is breached an error notification will be displayed in the print view and the content will need to be revised to fit.  

The “Use 4 Column Style” option on the General tab exports 4 cells for each result, which can be individually populated as below.  This can be used to display multiple Detection Limits for each result, if populated by the laboratory (EQL = Estimated Quantitation Limit, MDL = Method Detection Limit, RDL = Reported Detection Limit, ODL = Other Detection Limit).