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.