xlsx

The xlsx skill provides a robust environment for Claude to interact with spreadsheet data, designed for users requiring high-precision financial modeling, data analysis, and report generation. This skill integrates pandas for heavy data manipulation and openpyxl for sophisticated spreadsheet styling and formula construction, ensuring that generated documents are both functional and visually professional.

• Automated formula management: Supports the creation of complex Excel formulas, including financial projections and statistical analysis, while enforcing zero-error requirements for #REF!, #DIV/0!, and #VALUE! conditions.
• Financial modeling standards: Implements industry-standard color coding (blue for inputs, black for formulas, green for internal links, red for external, yellow for assumptions) to maintain clarity and auditability.
• Advanced formatting: Applies precise number formatting for currency, years, percentages, and valuation multiples (e.g., 0.0x), ensuring consistency across all generated deliverables.
• Data-driven analysis: Leverages pandas to ingest, clean, and visualize large datasets from .csv, .tsv, or .xlsx formats, enabling rapid insights before outputting structured tables.
• Recalculation engine: Includes mandatory integration with a LibreOffice-backed recalc.py script, allowing Claude to verify formula outcomes externally and programmatically fix logic errors before final delivery.

Usage notes and constraints:

• Always prefer Excel formulas (e.g., =SUM(A1:A10)) over hardcoding Python-calculated results to maintain workbook dynamism.
• When modifying existing templates, the skill strictly adheres to the established style, formatting, and structural conventions of the original file to avoid disrupting user workflows.
• Hardcoded values must be documented within the spreadsheet using specific source citation formats (e.g., Source: Company 10-K, Date, Page).
• Inputs should specify file paths or raw data structures; outputs consist of high-integrity Excel workbooks ready for professional review.
• This tool is essential for financial analysts, data scientists, and engineers needing to produce auditable, scalable, and error-free spreadsheet models directly within the Claude Code environment.