Water Quality Compliance Reporting vs Excel / Manual Workflow
The de facto compliance tool for over 90% of small environmental consulting firms. Staff scientists maintain project-specific Excel workbooks with VLOOKUP formulas referencing MCL and RSL lookup tables they built themselves. Conditional formatting highlights exceedances. Tables are manually formatted for Word reports. The workflow is universal, familiar, and deeply flawed — every step introduces error risk, and there is no audit trail when a regulator questions a value.
Excel / Manual Workflow
~$12/month (Microsoft 365)
Water Quality Compliance Reporting
Free during beta
Feature comparison
| Feature | Water Quality Compliance Reporting | Excel / Manual Workflow |
|---|---|---|
| Regulatory standard database | Maintained database of federal MCLs, RSLs, and all 50 state standards — updated within days of regulatory changes | Self-maintained lookup tables that go stale between RSL releases. You find out your table is outdated when a regulator flags your report. |
| Detection limit adequacy | Automatic flagging when a non-detect RL exceeds the applicable standard — generates a dedicated summary table | No built-in check. The VLOOKUP says 'non-detect' but does not evaluate whether compliance can actually be determined from that result. |
| Data qualifier handling | J, U, R, UJ, and B qualifiers handled with correct compliance logic — estimated exceedances distinguished from firm detections | Manual interpretation. Each staff scientist handles qualifiers differently. No standardized logic across projects. |
| Multi-jurisdiction screening | Apply federal, state, and site-specific standards simultaneously — see the most stringent standard for each analyte | Separate VLOOKUP columns for each standard set. Adding a third jurisdiction means rebuilding the comparison. |
| Professional report output | Formatted exceedance tables with standard citations, exportable to Excel/PDF/Word with firm branding | Hours of manual formatting. Copy-paste between Excel and Word. Rebuild the header and footnotes every time. |
| Audit trail | Every import, screening, and export logged with timestamp and user. Fully traceable from result to standard to comparison. | None. Multiple staff editing the same file. No version control. No way to verify which standard was applied. |
| Price | Free during beta | ~$12/month (Microsoft 365) |
Why switch from Excel / Manual Workflow?
No compliance intelligence. Every screening comparison is a manual VLOOKUP. Regulatory standard lookup tables go stale. No detection limit adequacy checking. No audit trail. Hours of formatting per monitoring event. One misplaced decimal is an E&O claim waiting to happen.
- Eliminate the hours you spend VLOOKUP-ing analytes against MCL tables — screen an entire monitoring event in minutes
- Never apply a superseded standard again. The database updates when EPA and state agencies update — you do not maintain lookup tables.
- Catch detection limit adequacy issues your Excel workflow misses — the RL-above-MCL problem that regulators will find
- Generate formatted exceedance tables with standard citations that drop directly into client reports — no reformatting
- Free during beta — try it on your next project alongside your existing workflow with zero risk
Try the Excel / Manual Workflow alternative
Free during beta. No credit card required.