Exceedance Table Generation

The standard exceedance table is the core deliverable in compliance reporting. LimnaFlow generates it with all the columns your PM expects: Location, Sample ID, Sample Date, Analyte, CAS Number, Result, Qualifier, Units, Applicable Standard, Standard Type (MCL, RSL, state standard), Standard Value, and Exceedance Factor (result divided by standard). Results are sorted by location then analyte by default, with configurable sort order.

Color coding provides immediate visual assessment: red for exceedances, yellow for detection limit inadequacy, green for compliant results, and gray for non-detect. Each standard value in the table links to its source citation with regulation number and effective date, providing defensibility when your tables appear in reports submitted to regulatory agencies.

Many state agencies require a complete data summary table in compliance report appendices — not just exceedances, but all results for all analytes at all locations. LimnaFlow generates this 'everything' table showing the full dataset with standards displayed for context alongside each result. Columns are configurable, and the table is sortable and filterable.

The data summary table serves as the foundation for reviewer QA/QC. A project manager or senior consultant can scan the complete dataset to verify that the exceedance table captured every issue. Because it includes all results — detects, non-detects, exceedances, and compliant values — it provides the full picture that summary tables alone cannot convey.

The detection limit adequacy table isolates the specific condition where compliance cannot be determined: non-detect results where the laboratory reporting limit exceeds the applicable standard. Columns include Location, Analyte, Reporting Limit, Applicable Standard, and the Gap (RL minus standard value). This table answers a direct question: where do we have analytical limitations that prevent us from concluding compliance?

This is a deliverable that many project managers require but that Excel workflows rarely produce systematically. In LimnaFlow, it is generated automatically from the screening results — no additional manual filtering or formula work needed. The table is especially critical for PFAS projects where parts-per-trillion MCLs frequently exceed standard laboratory reporting limits.

The comparative exceedance table presents side-by-side results across multiple sampling events at the same location. Columns represent sampling dates; rows represent analytes. Exceedances are highlighted per event, giving an immediate visual of whether contamination at a location is increasing, decreasing, or stable over time. This is the table format many agencies expect for quarterly monitoring reports.

The summary statistics table calculates minimum, maximum, mean, median, number of detects, number of non-detects, number of exceedances, and detection frequency for each analyte across all locations. These statistics are required by many state agencies in compliance reports and are tedious to calculate manually, especially when non-detect handling (using half the detection limit, using zero, or using the full detection limit) must follow a specific agency protocol.

Every table type supports configuration to match your reporting requirements. Sort order can be set by location, by analyte, or by exceedance factor (highest exceedances first). Filters let you show exceedances only, all results, or specific analyte groups — VOCs, metals, PFAS, SVOCs/PAHs. Significant figures are configurable per table, and unit display preferences (ug/L vs. ppb, ng/L vs. ppt) can be set to match your client's or agency's conventions.

Inline standard citations appear in every table. Each standard value links to its source regulation — the specific Federal Register citation, state regulation number, or EPA document — so that anyone reviewing your table can verify the standard independently. This level of traceability is what separates a professional compliance deliverable from an unattributed Excel table.