How does the skill handle formula errors?

The skill uses a mandatory recalculation script that scans all cells for Excel errors like #REF!, #DIV/0!, and #VALUE! to ensure every delivered model is error-free.

Is this skill suitable for professional financial modeling?

Yes, it follows industry-standard conventions, such as using blue text for hardcoded inputs and black text for formulas, while ensuring all assumptions are properly documented.

What libraries does the skill use for spreadsheet operations?

It leverages pandas for data analysis and bulk operations, and openpyxl for complex formatting, cell-level styling, and formula preservation.

Can I update existing Excel templates without losing my formatting?

Absolutely. The skill is designed to study and exactly match existing styles and conventions, ensuring modifications blend seamlessly with your established patterns.

Does it require any external software for recalculation?

Yes, it utilizes LibreOffice in the background via a recalc.py script to ensure formulas are evaluated and values are updated correctly before the file is finalized.

Excel & Spreadsheet Automation

Name: Excel & Spreadsheet Automation
Author: rysweet

byrysweet

•

データサイエンスとML

Creates, edits, and analyzes Excel spreadsheets with production-grade formulas, formatting, and industry-standard financial modeling conventions.

概要

The xlsx skill empowers Claude to handle complex spreadsheet tasks, ranging from automated financial modeling to advanced data analysis. It supports creating new workbooks, modifying existing templates while preserving styles, and performing rigorous formula validation using a built-in recalculation engine. By combining the power of pandas for data manipulation and openpyxl for precision formatting, this skill ensures all spreadsheets follow professional standards—including specific color-coding for inputs and calculations, consistent number formatting, and fully documented hardcodes.

主な機能

Industry-standard financial modeling color conventions and formatting
Automated formula creation and validation with zero-error enforcement
Preservation of existing spreadsheet templates and legacy styles
13 GitHub stars
Headless recalculation and error scanning using LibreOffice integration
High-performance data analysis and visualization using pandas

ユースケース

Analyzing large CSV or Excel datasets to produce formatted summary reports
Updating existing enterprise templates without breaking legacy formatting or formulas
Generating dynamic financial models with automated projections and assumptions

概要

主な機能

Industry-standard financial modeling color conventions and formatting
Automated formula creation and validation with zero-error enforcement
Preservation of existing spreadsheet templates and legacy styles
13 GitHub stars
Headless recalculation and error scanning using LibreOffice integration
High-performance data analysis and visualization using pandas

ユースケース

Analyzing large CSV or Excel datasets to produce formatted summary reports
Updating existing enterprise templates without breaking legacy formatting or formulas
Generating dynamic financial models with automated projections and assumptions