Do I need external software to recalculate formulas?

The skill utilizes LibreOffice via a helper script to ensure all formulas are correctly evaluated and verified, which is particularly useful for files modified via openpyxl.

What Python libraries are used for these operations?

It primarily uses pandas for data-heavy analysis and bulk operations, while openpyxl is used for complex formatting, cell styling, and formula injection.

Does this skill support financial modeling standards?

Yes, it implements industry-standard color-coding (blue for inputs, black for formulas) and specific number formatting for currencies, percentages, and multiples.

How does it handle formula errors?

It includes a mandatory verification step using a recalculation script to catch and fix common errors like #REF!, #DIV/0!, #VALUE!, and #NAME? before delivery.

Can I use this to modify existing Excel templates?

Absolutely. The skill is designed to study and match existing styles and conventions, ensuring that established template patterns are preserved during updates.

Excel & Spreadsheet Automation

Name: Excel & Spreadsheet Automation
Author: cdeistopened

bycdeistopened

•

データサイエンスとML

Automates professional spreadsheet creation, data analysis, and financial modeling with industry-standard formatting and formula integrity.

This skill empowers Claude to handle complex spreadsheet tasks, ranging from automated data analysis using pandas to building sophisticated financial models with openpyxl. It enforces strict industry standards for financial modeling, including specific color-coding for inputs and formulas, error-free calculations, and the mandatory use of dynamic Excel formulas over hardcoded values. With built-in support for formula recalculation and verification, it ensures that generated workbooks are production-ready, professionally formatted, and fully functional across various formats like .xlsx, .xlsm, and .csv.

主な機能

01Professional financial modeling with industry-standard color-coding and number formatting

02Support for preserving existing templates, styles, and conventions during modifications

03Formula recalculation and error verification using a dedicated LibreOffice-based script

04Dynamic formula generation to ensure spreadsheets remain updateable and error-free

051 GitHub stars

06Comprehensive data analysis and visualization using the pandas library

ユースケース

01Updating existing Excel templates with new data while maintaining formula integrity

02Building automated financial projections with standardized assumptions and formatting

03Analyzing large datasets from CSV or Excel files and generating summary reports

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add cdeistopened/skill-stack xlsx

For use in Claude.ai and ChatGPT

Download Skill