Spreadsheet Workbook Contract Normalizer

Turn a redacted workbook export into a stable contract for deterministic acceptance checks.

Scenario and prerequisites

• - Use before checking an AI-edited Excel or Sheets export.
• Input is a JSON representation of sheets, columns, rows and formulas; no real customer data or credentials.
• Python 3.10+ and the standard library are enough.

Input and output

Input must contain workbook_id, version, and a non-empty sheets list. Each sheet needs a unique name, columns, rows and optional formulas.

Output is READY or BLOCKED, with schema_hash, sheet counts, formula counts and explicit reasons.

Installation, execution and recovery

Run python scripts/normalize_workbook_contract.py --input examples/input.json --output examples/output.json. Fix duplicate sheet names, missing columns or malformed rows and rerun; do not infer missing cells.

The script does not open Excel, call an LLM or modify a workbook. It only hashes the supplied redacted contract.

Acceptance

The sample must produce READY with two sheets and a non-empty schema hash. Changing a column or formula must change the hash.