Does it support industry-standard financial formatting?

Yes, it automatically applies professional color-coding conventions, such as blue text for hardcoded inputs, black for formulas, and specific currency/percentage formatting.

How does this skill handle formula errors?

It uses a dedicated recalc.py script and LibreOffice to recalculate all formulas and scan for errors like #REF!, #DIV/0!, and #VALUE! before delivering the file.

Can it work with existing Excel templates?

Absolutely. The skill is designed to study and match existing formats, styles, and conventions, ensuring new data integrates seamlessly without overwriting established patterns.

Which Python libraries are used for processing?

The skill intelligently switches between pandas for data-heavy analysis and openpyxl for complex formatting, cell-level manipulation, and formula preservation.

Advanced Excel & Financial Modeling

Name: Advanced Excel & Financial Modeling
Author: XD3an

byXD3an

0•

데이터 과학 및 ML

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

This skill empowers Claude to handle complex spreadsheet tasks by providing a robust framework for creating, editing, and analyzing .xlsx files. It enforces rigorous financial modeling standards, including color-coded inputs and formula-driven calculations, while ensuring zero formula errors through an integrated LibreOffice recalculation engine. Whether building dynamic projection models, performing large-scale data analysis with pandas, or preserving existing corporate templates, this skill ensures professional, production-grade spreadsheet outputs that remain dynamic and updateable.

주요 기능

01Industry-standard financial model color-coding (Blue for inputs, Black for formulas)

02Template-aware editing that preserves existing styles and conventions

03Dynamic formula generation to eliminate brittle hardcoded values

04Automated formula verification and error detection (#REF!, #DIV/0!, etc.)

050 GitHub stars

06High-performance data manipulation using pandas and openpyxl integration

사용 사례

01Updating complex corporate Excel templates while maintaining formula integrity

02Building professional dynamic financial projection models with automated scenario inputs

03Processing and visualizing large datasets from CSV/TSV into formatted Excel reports

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add xd3an/cc-plus xlsx

For use in Claude.ai and ChatGPT

Download Skill