working-with-spreadsheets

What problem does it solve? Building Excel files programmatically often produces broken formulas, hardcoded values, and inconsistent formatting that fails financial modeling standards. This Skill provides the rules and code patterns to generate correct, auditable .xlsx workbooks. ## Core Features & Use Cases - Formula-First Generation: Writes Excel formulas instead of hardcoded Python-calculated values, keeping models auditable and editable. - Financial Color Coding & Number Formats: Applies standard conventions (blue inputs, black formulas, green cross-sheet links) plus currency, percentage, and multiple formats. - Formula Recalculation & Error Checking: Uses LibreOffice-based recalculation to detect #REF!, #DIV/0!, #VALUE!, and #NAME? errors after generation. - Use Case: Build a revenue forecast model where growth rates are blue input cells, projections are black formula cells referencing prior periods, and a verification pass confirms zero formula errors before delivery. ## Quick Start Create an Excel financial model with revenue inputs, formula-driven growth projections, and standard color coding, then recalculate it to verify there are no formula errors.