Laboratory certificate → DÉPASSEMENTS sheet (Québec register)
What you are seeing — the annual report needs every result compared to the criterion, the criterion cited, the exceedances listed first — and today that table is rebuilt by hand in Excel from every certificate.
The sheet is one row per (sample · parameter): the printed result, its unit and detection limit, the register's thresholds, the state — DÉPASSE, QUESTION, sous — the columns exceeded, and the source of the criterion on the row. Exceedances first, then the questions, then the rest by sample and parameter. A censored value whose detection limit sits above the criterion is a question, never a pass and never a flag.
The yardstick is the laboratory's own flag. Bureau Veritas prints >A / A-B on its certificates; our reading is compared to it row by row. Measured on 7 witnesses: 2,235 results, 1,181 compared to the register (Québec — Guide d'intervention, Annexe 7 (eaux souterraines : consommation / résurgence)), 157 exceedances, 52 questions — and of 582 flags the laboratory printed, 582 reproduced (100 %). The check re-opens the sheet and recounts it from its cells; a head that does not equal its body fails the build.
Several certificates make one sheet: a project's deposits are read one by one and printed on ONE DÉPASSEMENTS sheet, each row naming its file. Measured: 2 documents → 802 rows, 53 exceedances, equal to the per-file counts summed. Nothing is interpolated between campaigns; a gap is a gap.
A PDF certificate or the laboratory's export: the exceedance table against the register you choose. Free during the testing period · no account · your rows are discarded after the check.
Check the file you have →