What problem does it solve? Working with Excel files programmatically often leads to broken formulas, hardcoded values that can't update, and formatting inconsistencies. This Skill provides structured workflows for creating, editing, and analyzing spreadsheets (.xlsx, .xlsm, .csv, .tsv) while preserving formulas and enforcing zero formula errors. ## Core Features & Use Cases - Formula-First Spreadsheet Creation: Build workbooks with openpyxl using live Excel formulas instead of hardcoded Python-calculated values, keeping files dynamic and updateable. - Formula Recalculation & Error Detection: Use the included recalc.py script with LibreOffice to recalculate all formulas and scan every cell for errors like #REF!, #DIV/0!, and #VALUE! with exact locations. - Financial Modeling Standards: Apply industry-standard color coding (blue inputs, black formulas, green cross-sheet links), number formatting, and assumption-cell conventions for professional financial models. - Use Case: Build a revenue projection model where growth rates live in assumption cells, all totals use SUM formulas, and the recalc script verifies zero errors before delivery. ## Quick Start Ask the AI to create an Excel financial model with formulas for revenue projections and then recalculate and verify the file has no formula errors.
