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.