Documentation
README
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 |
Common Workflow
This is the opening of the README. Read the full README on GitHub.