What problem does it solve? Working with spreadsheets programmatically often leads to broken formulas, hardcoded values that cannot update, and formatting that violates financial modeling conventions. This Skill ensures Excel files are built with live formulas, industry-standard color coding, and zero formula errors. ## Core Features & Use Cases - Spreadsheet Creation & Editing: Build new .xlsx files or modify existing ones with openpyxl while preserving formulas and formatting. - Data Analysis: Read and analyze spreadsheet data with pandas, then export results back to Excel. - Formula Recalculation & Validation: Run the recalc.py script with LibreOffice to recalculate all formulas and detect errors like #REF!, #DIV/0!, and #VALUE! with exact cell locations. - Financial Modeling Standards: Apply industry color conventions (blue inputs, black formulas, green cross-sheet links) and number formatting rules automatically. - Use Case: Build a revenue projection model where growth rates live in assumption cells, all totals use SUM formulas, and the final file is recalculated and verified error-free before delivery. ## Quick Start Create an Excel financial model from my data with formulas for all calculations, then recalculate it and fix any formula errors.
