XLSX To Python Checklist

Checklist

Checklist

• Dual-pass load (values + formulas) — verify cached values exist
• All formula cells extracted with both formula text and computed value
• Named ranges mapped to variable names
• Dependency graph built and classified (inputs/intermediates/outputs)
• Calculation blocks identified (vs data/lookup tables)
• Row patterns detected — normalize formulas via Translator, group by pattern
• Loop collapse — repeated patterns (≥3 rows) emit Python loops, not per-cell code
• Formula → Python translation — simple arithmetic auto-translated; complex via formulas lib
• Baseline tests generated using Excel cell values as pytest.approx() assertions
• 10 parametric variations generated per calculation
• Parametric tests verify at minimum: result is finite, within physical bounds
• Dark-intelligence archive YAML produced with legal_scan_passed: false
• Legal scan passed — set legal_scan_passed: true
• Calc-report YAML generated from archive