What problem does it solve? Building and editing Excel workbooks programmatically often produces broken formulas, inconsistent formatting, and hardcoded values that break when data changes. This Skill enforces correct formula usage, industry-standard financial formatting, and automated error detection so spreadsheets remain dynamic and error-free. ## Core Features & Use Cases - Formula-First Spreadsheet Creation: Generates .xlsx files using openpyxl with live Excel formulas instead of hardcoded Python-computed values, keeping models updateable. - Automated Recalculation & Error Detection: The recalc.py script uses LibreOffice to recalculate all formulas and reports every #REF!, #DIV/0!, #VALUE!, and #N/A error with exact cell locations. - Financial Modeling Standards: Applies industry color conventions (blue inputs, black formulas, green cross-sheet links), number formatting rules, and source documentation requirements for hardcoded values. - Use Case: Build a three-statement financial model from company 10-K data with assumption cells, projection formulas, and proper formatting, then verify zero formula errors before delivery. ## Quick Start Ask the agent to create an Excel financial model from your data with formulas and formatting, then recalculate and verify it contains zero formula errors.
