Hey all,

I am trying to figure out an easy way build a table in ESdat that compares the criteria that is available for different environmental standards.

Ideally, I would like to be able to arrange the criteria by ChemGroup for each Environmental Standard.

Is there an easy way to output such a table in ESdat?

Thanks

Hey Warwick,

This is sort of helpful, but not really what I was hoping for. At the moment am pulling out the list of values for each environmental standard and then manipulating the lists manually myself to create something like this;

ChemGroup : ChemName :  Unit  : Criteria A : Criteria B : Crieria C :  Adopted Criteria

Metals          : Antimony    :  mg/L : 0.003       :      -           : 0.0006     :  0.0006

                     : Mercury      :  mg/L :    -            :  0.006       : 0.000063 :  0.000063

The ultimate objective is to show which criteria have been selected for a site in instances where multiple crieria are applicable.

I also want an easy way to show which compounds have criteria but have not been tested for in the samples collected.  I often have instances where not all the compounds of a chem group are reported by the lab even though I have criteria for the missing compound in the environmental standard, and these don't show up in the chem tables.

Hopefully you understand what I am getting at. It's no drama if there is no quick fix for this, I am just trying to see if there is an easier way to do this task that isn't so time consuming.

Thanks

Lachie