What problem does it solve? Working with spreadsheet files programmatically often leads to broken formulas, hardcoded values that cannot update, and Excel errors like #REF! or #DIV/0! that only surface after delivery. This Skill provides a disciplined workflow for creating, editing, and analyzing .xlsx, .xlsm, .csv, and .tsv files so the final deliverable is a dynamic, error-free spreadsheet. ## Core Features & Use Cases - Formula-first spreadsheet creation: Builds workbooks with live Excel formulas via openpyxl instead of hardcoding Python-computed values, so sheets recalculate when source data changes. - Mandatory recalculation and error scanning: The scripts/recalc.py tool drives LibreOffice headlessly to recalculate all formulas and reports every #REF!, #DIV/0!, #VALUE!, and #NAME? error with exact cell locations. - Financial modeling conventions: Enforces industry-standard color coding (blue inputs, black formulas, green cross-sheet links), number formatting rules, and documented hardcode sources. - Use Case: A user asks to turn a messy CSV export into a formatted financial model with growth projections; the Skill builds the workbook with assumption cells and formulas, recalculates it, fixes any reported errors, and delivers a clean .xlsx. ## Quick Start Use the xlsx skill to create a spreadsheet from my sales data with a totals row using formulas, then recalculate it and confirm there are no formula errors.
