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 creating, editing, and analyzing Excel files while preserving formulas and enforcing zero-error outputs. ## Core Features & Use Cases - Spreadsheet Creation & Editing: Build new workbooks or modify existing ones with openpyxl while preserving formulas, styles, and template conventions. - Formula Recalculation & Error Detection: Run the recalc.py script with LibreOffice to recalculate all formulas and scan every cell for errors like #REF!, #DIV/0!, and #VALUE!. - Financial Modeling Standards: Apply industry-standard color coding, number formatting, and assumption placement for professional financial models. - Use Case: Build a revenue projection model where growth rates live in assumption cells, all totals use live Excel formulas, and the final file is recalculated and verified to contain zero formula errors before delivery. ## Quick Start Create an Excel financial model with formulas for revenue projections, then recalculate it and fix any formula errors.
