xlsx

This skill empowers Claude to perform high-precision spreadsheet operations, making it an essential tool for financial modelers, data analysts, and engineers. It enforces strict best practices for workbook creation and modification, ensuring that spreadsheets remain dynamic, error-free, and professional in appearance. Whether handling complex financial models or basic data analysis tasks, this tool provides a robust framework that prevents the common pitfalls associated with AI-generated spreadsheet files.

The tool is designed for users who require more than simple file interaction; it provides a governed environment where formula errors are minimized and formatting conventions are strictly preserved. By integrating with pandas for data-heavy tasks and openpyxl for granular cell manipulation, it maintains a clean separation between data processing and file aesthetics. All financial models generated via this tool follow industry-standard color coding and number formatting, making them instantly ready for stakeholder review and further iterative work.

• Advanced spreadsheet manipulation: Support for .xlsx, .xlsm, .csv, and .tsv formats.

• Financial modeling standards: Automatic implementation of color-coded inputs, formulas, links, and assumption cells.

• Formula integrity: Mandatory error checking (#REF!, #DIV/0!, etc.) to ensure reliable calculations.

• Data-driven analysis: Seamless integration with pandas for visualization and descriptive statistics.

• Template preservation: Intelligent updates that respect existing style conventions and sheet layouts.

• Formula-first approach: Enforces the use of Excel formulas rather than hardcoded Python calculations to maintain model dynamism.

• Always use the recalc.py script after any file modification involving formulas to verify integrity.

• Documentation requirement: Hardcoded inputs must be accompanied by source references (e.g., Company 10-K, Bloomberg Terminal).

• Formatting: Utilize text strings for years, $#,##0 for currency, and parenthetical notation for negative numbers.

• Use pandas read_excel and to_excel for data extraction, manipulation, and report generation.

• Ensure all cell references are dynamic and avoid circular references during construction.

• This tool is intended for professional reporting, quantitative analysis, and iterative model development.