# Barbacena
*Weekly farm reports for Fazenda Barbacena — herd, horses, crops, and events → form + multi-week dashboard.*

## Current focus
- Production: GCS durable overrides + dashboard live

## Next up
- [ ] Spot-check the 32 reconstructed weeks against the original PDFs on the Mac (provenance: data/reconstructed-weeks.json → gmailMessageId per week)
- [ ] Optional admin gate on /barbacena UI chrome only

## Last touched
- 2026-07-13 — Reconstructed the 32 quarantined weeks from the weekly e-mails and re-dated two misfiled PDFs, restoring the out/2023–mai/2024 herd series (#840)
- 2026-07-13 — Accuracy audit fixes: 32 corrupt weeks quarantined for manual review, annual Excel sheets excluded from weekly sums, revenue extraction corrected (#840)
- 2026-07-13 — Dashboard usability overhaul: interactive charts, annual reports tab with CSV/print, richer week detail, form prefill (#838)
- 2026-07-13 — Barbacena Excel history 2015-2022 into dashboard (#836)
- 2026-07-13 — Barbacena full history ingest to production (#834)
- 2026-07-13 — Durable overrides on Cloud Run via GCS (#830)
- 2026-07-13 — GCS durable overrides for prod form saves (#830)
- 2026-07-13 — Server API + auth, death/sales charts, estimate empty PDFs (#828)
- 2026-07-13 — PDF parser, 80-week ingest, multi-week dashboard + form (#825)
- 2026-07-13 — Project seed from Gmail PDF analysis (#822)

## Blockers

## Open questions
- Who enters data going forward — office, family, or both?

## Ideas
- WhatsApp photo OCR assist
- Late-report alert (>10 days)

## Notes
- Source: escritoriobarbacena@gmail.com · subject RELATÓRIO SEMANAL
- Excel: `python3 projects/barbacena/scripts/ingest-excel.py /tmp/barbacena-xlsx`
- Pull: `projects/barbacena/scripts/pull-gmail-pdfs.sh` then `ingest-pdfs.mjs`
- API: `GET/POST /api/barbacena/weeks` (POST = admin or local)
- Health: `GET /api/barbacena/health`
- GCS: `lucaslongo/data/barbacena-overrides.json` in `PERSIST_BUCKET` (prod)
- Data: `public/data/weeks.json` + `weeks-full.json` + optional `data/overrides.json`