Workbook Normalization
P1 defines the workbook normalization contract before bulk CSV export.
Seed archives are unpacked only under ignored local paths such as
local/seed/. Raw PDFs, screenshots, extracted legacy repositories, generated
outputs, and unchecked source artifacts must not be tracked.
Current workbook source
The latest tracked workbook snapshot is:
data/workbooks/native_plant_restoration_workbook_v1.0.0c.xlsx
Its main sheets are mapped as follows:
Sheet |
Direction |
|---|---|
Species_Master |
Candidate species table. |
Lookup_Tables |
Controlled vocabulary records. |
Reference_Policy |
Source policy documentation and future reference configuration. |
Source_Attribution |
Field/source attribution records. |
Bloom_Calendar |
Derived or validated bloom-month records. |
Dashboard |
Report output concept, not canonical source data. |
QA_Log |
Review queue or issue provenance. |
CLI
bc-nppd inventory-workbook data/workbooks/native_plant_restoration_workbook_v1.0.0c.xlsx
bc-nppd validate-workbook data/workbooks/native_plant_restoration_workbook_v1.0.0c.xlsx --json
P1 inspection helpers are read-only. Deterministic exports remain deferred until a later phase approves canonical tracked data.