What problem does it solve? Working with spreadsheet files programmatically often produces broken formulas, inconsistent formatting, or hardcoded values that cannot update. 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 (SUM, growth rates, averages) instead of hardcoded Python-computed values, keeping workbooks dynamic and recalculable. - Automated recalculation and error detection: The scripts/recalc.py utility drives LibreOffice headlessly to recalculate all formulas and reports every #REF!, #DIV/0!, #VALUE!, or #N/A error with exact cell locations as JSON. - Financial modeling conventions: Enforces industry-standard color coding (blue inputs, black formulas, green cross-sheet links), number formatting (parenthesized negatives, 0.0% percentages, 0.0x multiples), and documented hardcode sources. - Use Case: A user asks to build a three-year revenue projection model. The Skill creates the workbook with openpyxl, places assumptions in dedicated cells, writes formulas referencing those assumptions, runs recalc.py to verify zero errors, and delivers a formatted .xlsx file. ## Quick Start Use the xlsx skill to create a sales forecast spreadsheet with formulas for totals and growth rates, then recalculate and verify it has no formula errors.
