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

•

数据科学与机器学习

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.

主要功能

01Seamless integration with pandas for advanced data manipulation and analysis

02Template preservation logic that matches existing styles and conventions

03Automated formula recalculation and error verification (#REF!, #DIV/0! detection)

04Industry-standard financial model formatting (blue-text inputs, black-text formulas)

051 GitHub stars

06Support for complex Excel features including conditional formatting and cell comments

使用场景

01Building dynamic, audit-ready financial models with clear assumption tracking

02Automating the migration of raw data into formatted executive dashboards

03Updating existing corporate templates without breaking formulas or styles

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add krosebrook/source-of-truth-monorepo document-processing

For use in Claude.ai and ChatGPT

Download Skill