Client work · under subscription
Lab Data Review Tool
Lab EDDs in, ADEC checklist and summary tables out
- Year
- 2026
- Role
- Sole developer — spec, build, validation against hand-done reviews, support
Published 2026-09-30 · Updated 2026-09-30 · By Kai Myers, K.AI Consulting
The problem
Each batch of samples comes back from the lab as an electronic data deliverable (EDD or SEDD) plus a report. Before the data can be used or a stockpile can move, someone builds a per-sample summary of results against the cleanup levels, checks holding times, blanks, lab control samples, matrix spikes, surrogates and detection limits, applies qualifiers, and fills in the state checklist. Done in a spreadsheet, it took about six hours, and the batches arrive every week.
The rules for that review are the firm's own, written down over years. Any tool had to run those rules exactly, keep them private, and be checkable against a reviewer's hand-done version before anyone trusted it.
What I built
A standalone web app that runs on a laptop with no internet connection. It reads the lab's EDD (Excel, Access, or state SEDD XML formats from more than one lab), joins results to the project's cleanup levels, and produces one summary table per sample with results, detection limits, qualifiers and exceedances highlighted.
The ADEC Laboratory Data Review Checklist is filled in automatically, with each QC problem identified and the samples it affects listed, so the reviewer sees at a glance whether a file can move.
No AI in the product. The review logic is the client's cheat sheet encoded as plain, testable rules; the same file produces the same answer every time. AI was used heavily during development, not at runtime.
Validation was done the honest way: run the tool on batches the firm had already reviewed by hand and compare qualifier by qualifier. The disagreements became the question list, and the rules were refined from the firm's answers, not guessed.
A second project profile added Department of Defense deliverables, dual screening levels, and the DoD workbook tabs the client files, selected automatically from the EDD.
Where it landed
- The weekly review went from about six hours to about an hour: a file drop and a read-through
- Less time on paperwork and less worry about a missed qualifier or an audit question
- Runs offline on a field laptop; nothing leaves the machine
- The firm's review rules stay its intellectual property, written into the agreement
- Fixed-price build with a small monthly subscription for updates as lab formats and cleanup levels change
Built with
Decision support only. The tool is not a substitute for review by a qualified environmental professional and is not a guarantee of ADEC or DoD acceptance. Client not named at their request; rules, limit sets and data are theirs.
Got a problem shaped like one of these?