Does this skill support complex Excel formulas?

Yes, it prioritizes creating dynamic Excel formulas over hardcoding values, ensuring your spreadsheets remain updateable and functional.

Can it follow professional financial modeling standards?

Absolutely. It follows industry-standard conventions such as blue text for hardcoded inputs, black for formulas, and specific formatting for currencies and multiples.

How are formula errors prevented?

The skill includes a mandatory verification step using a recalculation script that scans for errors like #REF!, #DIV/0!, and #VALUE! before finalizing files.

What libraries does Claude use for spreadsheet tasks?

Claude utilizes pandas for high-speed data analysis and openpyxl for complex formatting, formula preservation, and workbook structure management.

Can I use this to update my existing corporate templates?

Yes, the skill is designed to study and match existing formats, styles, and conventions to ensure modifications look seamless within established files.

Advanced Excel & Spreadsheet Automation

Name: Advanced Excel & Spreadsheet Automation
Author: ai-wes

byai-wes

0•

数据科学与机器学习

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

This skill empowers Claude to perform complex spreadsheet operations, ranging from high-level data analysis with pandas to granular formatting and formula management with openpyxl. It enforces rigorous financial modeling standards, including specific color-coding for inputs and calculations, and utilizes a dedicated recalculation script to ensure zero-error formula delivery. Whether generating new dynamic models or updating legacy templates, this skill ensures that spreadsheets remain functional, professional, and audit-ready.

主要功能

01Deep data analysis and visualization using pandas integration

02Automated formula creation and validation with zero-error enforcement

03Formula recalculation and error scanning via LibreOffice support

040 GitHub stars

05Industry-standard financial modeling color-coding and number formatting

06Strict preservation of existing workbook templates and formatting patterns

使用场景

01Building dynamic financial models with linked assumptions and automated projections

02Modifying existing complex spreadsheets while preserving original formula logic

03Transforming raw data into formatted corporate reports with charts and tables

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add ai-wes/glassbox-operator xlsx

For use in Claude.ai and ChatGPT

Download Skill