analyzing-spreadsheets
Installation
SKILL.md
XLSX Processing
Create, edit, analyze .xlsx files. LibreOffice required for formula recalculation via recalc.py.
Iron Rule
Zero formula errors at delivery. All formulas must compute — no #REF!, #DIV/0!, #VALUE!, #N/A, #NAME?. Always run recalc.py after writing formulas.
Decision Matrix
| Task | Tool | Reference |
|---|---|---|
| Data analysis, bulk ops, simple export | pandas | recipes.md |
| Formulas, formatting, Excel features | openpyxl | recipes.md |
| Financial model standards | — | financial-model.md |
| Recalculate formulas | recalc.py |
recipes.md |