What problem does it solve? Working with spreadsheet files programmatically often leads to broken formulas, hardcoded values that cannot update, and formatting inconsistencies. This Skill provides a complete workflow for creating, editing, and analyzing .xlsx, .xlsm, .csv, and .tsv files while guaranteeing zero formula errors and professional financial-model formatting standards. ## Core Features & Use Cases - Formula-first spreadsheet generation: Builds Excel files with live formulas (never hardcoded Python-calculated values) so workbooks stay dynamic and recalculable. - Automated recalculation and error detection: The scripts/recalc.py tool uses LibreOffice to recalculate all formulas and reports #REF!, #DIV/0!, #VALUE!, and other errors with exact cell locations. - Financial modeling conventions: Enforces industry-standard color coding (blue inputs, black formulas, green cross-sheet links), number formatting, and assumption documentation. - Use Case: A user asks to build a revenue projection model from raw sales data. The Skill creates the workbook with openpyxl, writes growth formulas referencing assumption cells, applies currency formatting, runs recalc.py to verify zero errors, and delivers a finished .xlsx file. ## Quick Start Use the xlsx skill to create a spreadsheet from my sales data with a summary sheet that calculates totals and growth rates using formulas.
