Does it use hardcoded values or formulas?

It prioritizes Excel formulas (like =SUM() or cell references) over hardcoded Python results to ensure the spreadsheet remains dynamic and recalculates when data changes.

How does it handle formula errors?

The skill includes a mandatory recalculation step using a specialized script that identifies errors like #REF!, #DIV/0!, and #NAME?, allowing Claude to fix them before final delivery.

Can this skill modify existing Excel templates?

Yes, it is specifically designed to study and match existing formats, styles, and conventions, ensuring modifications blend seamlessly with your established templates.

What standards are used for financial models?

It follows industry-standard color conventions: blue text for inputs, black for formulas, green for internal links, and red for external links, along with specific number formatting for currencies and multiples.

Advanced Excel & Spreadsheet Automation

Name: Advanced Excel & Spreadsheet Automation
Author: kaodean

bykaodean

Data Science & ML

Automates the creation, professional formatting, and deep analysis of Excel workbooks using industry-standard modeling practices.

About

The xlsx skill enables Claude to act as a sophisticated spreadsheet engineer and data analyst. It goes beyond simple data export by enforcing professional financial modeling standards, including specific color-coding (blue for inputs, black for formulas) and rigorous error checking. By integrating pandas for data manipulation and openpyxl for formatting, the skill ensures that spreadsheets remain dynamic through Excel formulas rather than static values. It includes a specialized recalculation engine powered by LibreOffice to verify formula integrity and eliminate common spreadsheet errors before delivery.

Key Features

Dynamic formula generation to ensure spreadsheets remain interactive and updateable
High-performance data analysis and visualization using the pandas library
0 GitHub stars
Professional financial modeling with industry-standard color-coding and formatting rules
Automated formula verification and error detection (e.g., #REF!, #DIV/0!) using LibreOffice
Template preservation that respects existing styles, conventions, and formatting when editing

Use Cases

Building dynamic financial projections and valuation models with multi-period scenarios
Auditing and correcting complex existing spreadsheets for formula errors and structural integrity
Automating the transformation of raw CSV data into formatted, formula-driven Excel reports

About

Key Features

Dynamic formula generation to ensure spreadsheets remain interactive and updateable
High-performance data analysis and visualization using the pandas library
0 GitHub stars
Professional financial modeling with industry-standard color-coding and formatting rules
Automated formula verification and error detection (e.g., #REF!, #DIV/0!) using LibreOffice
Template preservation that respects existing styles, conventions, and formatting when editing

Use Cases

Building dynamic financial projections and valuation models with multi-period scenarios
Auditing and correcting complex existing spreadsheets for formula errors and structural integrity
Automating the transformation of raw CSV data into formatted, formula-driven Excel reports