Data validation and analysis

Data validation                                   

ESdat is able to produce a Chemical Quality Assurance Report summarising the following QA checks and flagging any potential issues:

Field QA

• Field duplicates and triplicates (Relative Percent Difference (RPD) values)

• Field blanks, trip blanks, rinsates

• Trip spikes

Lab QA

• Lab duplicates (RPD values)

• Holding times

• Inorganic logic checks (Ionic balance, TDS>Na+Cl, COD>BOD, etc.)

• Lab control samples/reference materials

• Matrix spikes

• Surrogates

Data analysis

Graphing

A graph may be produced for any time-series data. Graphing features will enable you to analyse and present your data via:

• trend analysis including Mann Kendal or Linear Regression;
• annotating the graph (TUp, TDn, and LH stand for Trending Up/Down, Last value Highest);
• producing your graphs in Excel (can be edited like any other Excel chart);
• saving and opting to automatically update when opening in Excel;
• displaying compliance levels; and
• customisable templates. 
  

Comparing with environmental guidelines/compliance levels

Environmental Standards, and exceedances can be shown and flagged on all the ESdat outputs, including chemistry output tables, graphs, and maps. ESdat comes pre-loaded with most regulatory guidelines and users can add their own site-specific or other guidelines as required.

Tabulating

Chemistry Tables are rapidly generated and exported to Excel. Users are able to specify:

• compound orientation & grouping;
• environmental standards to be included;
• customisable exceedance formatting;
• statistical output;
• templates; and
• other settings.