Reliable compliance reporting starts with reliable data. Before any lab result is used in a DMR calculation, trend analysis, or regulatory submission, it must be validated. Water quality software automates data validation by applying a battery of QA/QC checks the moment data is imported — catching errors, flagging anomalies, and ensuring only defensible results reach your compliance reports.
Validation Checks Performed Automatically
Permit Limit Comparison
Every result is compared against the applicable effluent limit for that outfall and parameter. The software identifies exceedances of daily maximums, monthly averages, and instantaneous limits, flagging them immediately so reviewers can investigate and initiate corrective actions before the reporting deadline.
Cation/Anion Balance
For samples with a full suite of major ions (calcium, magnesium, sodium, potassium, bicarbonate, sulfate, chloride, nitrate), the software calculates the cation/anion balance. A difference greater than 5–10% indicates potential analytical error, missing parameters, or sample contamination. This check catches problems that might not be visible when reviewing individual parameter results.
Holding Time Verification
Each analytical method has a regulatory maximum holding time — the allowed interval between sample collection and laboratory analysis. The software compares the sample collection date to the analysis date and flags any parameter where the holding time has been exceeded. Results analyzed past holding time may be unreliable and may need to be qualified or re-sampled.
Statistical Outlier Detection
The software compares each result to historical data for the same monitoring location and parameter. Values that fall outside expected ranges based on statistical analysis (e.g., more than three standard deviations from the running mean) are flagged as potential outliers for manual review.
Detection Limit Flagging
Results are checked against MDL, PQL, and reporting limits. The software flags samples where the reporting limit exceeds the permit limit (meaning the lab cannot confirm compliance), identifies non-detect results that need special handling in calculations, and tracks laboratory qualifiers (U, J, B, E flags).
Duplicate Precision & Blank Contamination
For samples with field or laboratory duplicates, the software calculates relative percent difference (RPD) and flags pairs that exceed acceptable precision thresholds. Trip blanks and equipment blanks are checked for contamination that could affect sample integrity.
The Data Review Workflow
Validation is not just about running checks — it is about providing a structured workflow for data reviewers to act on the results:
- Import — EDD files are imported and validation checks run automatically
- Review — Flagged results are presented in a review queue with the specific validation issue identified
- Disposition — Reviewers can accept with justification, reject, request re-analysis, or qualify the result
- Approve — Validated and dispositioned data is approved for use in reports and DMR calculations
- Audit trail — Every review decision is logged with the reviewer, timestamp, and justification
Frequently Asked Questions
What types of data validation does water quality software perform?
Software performs multiple validation checks including permit limit comparison, cation/anion balance verification, holding time checks, statistical outlier detection, detection limit flagging, duplicate precision evaluation, blank contamination checks, and historical range comparison.
What is cation/anion balance and why is it important?
Cation/anion balance compares the sum of positively charged ions (cations) to the sum of negatively charged ions (anions) in a water sample. In a valid sample, these should be approximately equal. A significant imbalance indicates a potential analytical error, missing parameters, or sample contamination.
How does holding time validation work?
Each analytical parameter has a regulatory maximum holding time between sample collection and analysis. Software compares the collection date and analysis date to verify the sample was analyzed within the allowed holding time. Exceeded holding times are flagged because results may be unreliable.
What happens when validation flags an issue?
Flagged results are presented to data reviewers with the specific validation issue identified. Reviewers can accept the result with a documented justification, reject the result, request re-analysis, or qualify the result with appropriate data flags before the data is used in reports or DMR calculations.
Related Ecesis Solutions
Water Quality Software
Lab imports, data validation, permit tracking and DMR reporting.
Environmental Data
Sensor integration, statistical analysis and trend visualization.
Compliance Obligations
Track all regulatory obligations and recurring deadlines.
Inspections & Audits
Mobile field inspections with corrective action tracking.
Document Control
Manage SOPs, permits, and compliance documents.
Task Tracking
Assign corrective actions with due dates and accountability.
Ready to Automate Your Data Validation?
Call (720) 547-5102 or click below to see automated QA/QC in action.
