Agent skill
xlsx-to-python-checklist
Sub-skill of xlsx-to-python: Checklist.
Install this agent skill to your Project
npx add-skill https://github.com/vamseeachanta/workspace-hub/tree/main/.claude/skills/_archive/data/office/xlsx-to-python/checklist
SKILL.md
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
formulaslib - 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
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
vamseeachanta/workspace-hub
gsd-complete-milestone
Archive completed milestone and prepare for next version
vamseeachanta/workspace-hub
gsd-reapply-patches
Reapply local modifications after a GSD update
vamseeachanta/workspace-hub
gsd-verify-work
Validate built features through conversational UAT
vamseeachanta/workspace-hub
gsd-thread
Manage persistent context threads for cross-session work
vamseeachanta/workspace-hub
clinical-trial-protocol
Generate clinical trial protocols for medical devices or drugs through a modular, waypoint-based architecture with research-only and full protocol modes.
vamseeachanta/workspace-hub
single-cell-rna-qc
Performs quality control on single-cell RNA-seq data (.h5ad or .h5 files) using scverse best practices with MAD-based filtering and comprehensive visualizations.
Didn't find tool you were looking for?