What problem does it solve? Building or modifying Excel workbooks by hand is slow and error-prone, especially when formulas, formatting, and financial model conventions are involved. This Skill generates and edits .xlsx files programmatically, recalculates formulas via LibreOffice, and validates the output so spreadsheets arrive correct and consistent. ## Core Features & Use Cases - Spreadsheet Generation: Create workbooks from scratch with openpyxl, including formulas, number formats, conditional formatting, charts, and data validation. - Editing & Analysis: Modify existing .xlsx files at the openpyxl or raw XML level, and analyze tabular data with pandas. - Financial Modeling Standards: Apply professional color coding, number formats, and layouts for DCF, LBO, and comparable-company models. - Use Case: Ask for a quarterly revenue model with an Assumptions sheet, cross-sheet formulas, and currency formatting; the Skill generates the workbook, recalculates all formulas with LibreOffice, previews the result, and validates the file schema. ## Quick Start Create an Excel workbook with a formatted sales table, SUM formulas per region, and recalculated values saved as output.xlsx.
