What problem does it solve? Building Excel workbooks programmatically often produces broken formulas, inconsistent formatting, and uncalculated values that only surface when the file is opened. This Skill provides a disciplined workflow for creating, editing, and analyzing .xlsx files so every deliverable arrives with zero formula errors and professional formatting. ## Core Features & Use Cases - Formula-First Spreadsheet Creation: Build workbooks with openpyxl using live Excel formulas instead of hardcoded Python-computed values, keeping files dynamic and updateable. - Automated Recalculation and Error Detection: Run the bundled recalc.py script to recalculate all formulas via LibreOffice and receive a JSON report locating every #REF!, #DIV/0!, #VALUE!, and #NAME? error by sheet and cell. - Financial Modeling Conventions: Apply industry-standard color coding, number formats, and assumption documentation for financial models. - Use Case: A user asks for a revenue projection model; the Skill generates the workbook with formulas, recalculates it with LibreOffice, fixes any reported errors, and delivers a verified file. ## Quick Start Ask the assistant to create an Excel workbook with your data and formulas, then have it run the recalculation script to verify the file contains no formula errors.
