What problem does it solve? Working with spreadsheet files programmatically often produces broken formulas, hardcoded values, or inconsistent formatting. This Skill ensures every .xlsx, .xlsm, .csv, or .tsv deliverable uses live Excel formulas, passes error checks, and follows professional formatting conventions. ## Core Features & Use Cases - Spreadsheet Creation & Editing: Build new workbooks or modify existing ones using openpyxl for formulas and formatting, or pandas for data analysis and bulk operations. - Formula Recalculation & Error Detection: Run the included recalc.py script to recalculate all formulas via LibreOffice and get a JSON report of any #REF!, #DIV/0!, #VALUE!, or other errors with exact cell locations. - Financial Modeling Standards: Apply industry-standard color coding (blue inputs, black formulas, green cross-sheet links), number formatting, and assumption documentation for financial models. - Use Case: A user provides a messy CSV export and asks for a clean financial summary. The Skill restructures the data, adds SUM and growth-rate formulas, applies currency formatting, recalculates, and verifies zero formula errors before delivery. ## Quick Start Use the xlsx skill to clean up the attached sales-export.csv and turn it into a formatted spreadsheet with totals and growth-rate formulas.
