What problem does it solve? Working with spreadsheets programmatically often leads to broken formulas, hardcoded values that can't update, and formatting that violates financial modeling conventions. This Skill provides structured workflows for building dynamic Excel files with zero formula errors and industry-standard formatting. ## Core Features & Use Cases - Spreadsheet Creation & Editing: Build new workbooks or modify existing ones with openpyxl while preserving formulas and formatting. - Formula Recalculation & Error Detection: Use the recalc.py script with LibreOffice to recalculate formulas and scan all cells for errors like #REF!, #DIV/0!, and #VALUE!. - Financial Modeling Standards: Apply color coding (blue inputs, black formulas, green cross-sheet links), number formatting, and assumption documentation conventions. - Use Case: Build a revenue projection model where growth rates live in assumption cells, all calculations use Excel formulas, and the file is recalculated and verified error-free before delivery. ## Quick Start Create an Excel financial model from my data with formulas for totals and growth rates, then recalculate it and fix any formula errors.
