Does it follow standard financial modeling conventions?

Yes. It defaults to industry standards: blue text for hardcoded inputs, black for formulas, green for internal links, and red for external links, ensuring models are professional and easy to audit.

How does this skill handle Excel formula errors?

The skill uses a dedicated recalculation script that leverages LibreOffice to verify all formulas. It identifies and helps fix errors like #REF!, #DIV/0!, and #VALUE! before finalizing the file.

Can I use this to analyze large datasets?

Absolutely. It integrates pandas for efficient data processing, allowing Claude to read, filter, and summarize large Excel or CSV files before formatting the output.

Will it break my existing spreadsheet formatting?

No. The skill is programmed to study existing template styles and match them exactly, ensuring that updates to your files remain consistent with your established brand or format.

Excel & Financial Modeling

Name: Excel & Financial Modeling
Author: Krosebrook

byKrosebrook

•

データサイエンスとML

Automates the creation, editing, and analysis of professional-grade Excel spreadsheets with precise formula management and financial modeling standards.

概要

This skill empowers Claude to perform sophisticated spreadsheet operations, ranging from high-speed data analysis with pandas to complex financial modeling using openpyxl. It enforces rigorous industry standards, such as zero-error formula validation and specific color-coding conventions for inputs and calculations. Whether you are generating a dynamic 3-statement model, updating existing reporting templates, or performing deep-dive data visualization, this skill ensures data integrity through an automated recalculation engine and strict adherence to professional formatting guidelines.

主な機能

Seamless integration with pandas for advanced data manipulation and analysis
Template preservation logic that matches existing styles and conventions
Automated formula recalculation and error verification (#REF!, #DIV/0! detection)
Industry-standard financial model formatting (blue-text inputs, black-text formulas)
1 GitHub stars
Support for complex Excel features including conditional formatting and cell comments

ユースケース

Building dynamic, audit-ready financial models with clear assumption tracking
Automating the migration of raw data into formatted executive dashboards
Updating existing corporate templates without breaking formulas or styles

概要

主な機能

Seamless integration with pandas for advanced data manipulation and analysis
Template preservation logic that matches existing styles and conventions
Automated formula recalculation and error verification (#REF!, #DIV/0! detection)
Industry-standard financial model formatting (blue-text inputs, black-text formulas)
1 GitHub stars
Support for complex Excel features including conditional formatting and cell comments

ユースケース

Building dynamic, audit-ready financial models with clear assumption tracking
Automating the migration of raw data into formatted executive dashboards
Updating existing corporate templates without breaking formulas or styles