Does it support financial modeling standards?

Absolutely. It includes specific guidelines for industry-standard color coding (blue for inputs, black for formulas), number formatting, and structured formula construction.

What file formats are supported?

It provides comprehensive support for .xlsx, .xlsm, .csv, and .tsv files.

Can I modify existing Excel templates without breaking them?

Yes, the skill is designed to study and match existing formats and conventions to ensure that your established templates remain intact while being updated.

How does it ensure formula accuracy?

The skill uses a mandatory recalculation script (recalc.py) that scans for common Excel errors like #REF!, #DIV/0!, and #VALUE! before finalizing the file.

Can this skill handle complex Excel formulas?

Yes, it supports full Excel formula syntax and includes a recalculation script to ensure all values are correctly updated and error-free.

Excel & Spreadsheet Automation

Name: Excel & Spreadsheet Automation
Author: claudiodearaujo

byclaudiodearaujo

•

データサイエンスとML

Automates the creation, editing, and analysis of professional Excel spreadsheets with advanced formula support and financial modeling standards.

This skill provides Claude with a comprehensive framework for managing complex spreadsheet tasks, ranging from basic data entry to building sophisticated financial models. It ensures formula integrity through a dedicated recalculation engine and enforces industry-standard formatting conventions, such as specific color-coding for inputs and calculations. Whether you are performing large-scale data analysis with pandas, generating formatted reports with openpyxl, or updating existing templates while preserving their original structure, this tool ensures high-quality, error-free spreadsheet outputs.

主な機能

01Precise formatting control including cell styles, fonts, and layout alignment

021 GitHub stars

03Template preservation that respects existing styles and conventions

04Advanced formula creation and recalculation with zero-error verification

05Seamless integration with pandas for high-performance data analysis

06Industry-standard financial modeling with color-coded inputs and calculations

ユースケース

01Building dynamic financial models with automated projections and scenario analysis

02Performing complex data cleaning and visualization within Excel workbooks

03Generating automated business reports and dashboards from raw data exports

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add claudiodearaujo/sistema-de-narra-o-de-livro xlsx-official

For use in Claude.ai and ChatGPT

Download Skill