# XLSX To Python Checklist

> Sub-skill of xlsx-to-python: Checklist.

- Skill: `vamseeachanta/xlsx-to-python-checklist` (Agent Skill)
- Install (CLI): `npx skillmds@latest add vamseeachanta/xlsx-to-python-checklist`
- Raw SKILL.md: https://api.skillmd.com/api/skills/vamseeachanta/xlsx-to-python-checklist/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: vamseeachanta (https://skillmd.com/u/vamseeachanta)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/vamseeachanta/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