What problem does it solve?
This Skill eliminates the manual, error-prone work of creating, updating, and validating spreadsheet models by ensuring formulas, formatting, and templates are preserved and recalculated correctly.
Core Features & Use Cases
- Create and Edit Workbooks: Create new .xlsx files with formulas and professional formatting or modify existing workbooks while preserving templates and formulas.
- Data Analysis & Visualization: Use pandas for data manipulation and openpyxl for Excel-native formulas and styling to deliver analysis-ready spreadsheets.
- Recalculation and Validation: Recalculate formulas using LibreOffice via the included recalc.py script and verify there are zero Excel formula errors before delivery.
- Use Case: Build a financial projection workbook from raw CSVs that uses in-sheet formulas for all calculations, matches existing corporate template conventions, and passes automated recalculation checks.
Quick Start
Create a new .xlsx from dataset.csv with formulas and formatting, then run the recalc.py script to recalculate and verify there are no formula errors.