Does this skill support complex Excel formulas?

Yes, it supports full formula construction and includes a mandatory verification step using LibreOffice to ensure zero errors like #REF!, #VALUE!, or #DIV/0!.

Can it handle professional financial modeling standards?

Absolutely. It follows strict conventions such as blue text for hardcoded inputs, black for formulas, and green for internal links, ensuring models are audit-ready.

How does it handle formula recalculation?

The skill uses a dedicated recalc.py script that leverages LibreOffice to evaluate all formulas and verify their accuracy before finalizing the file.

Will it overwrite my existing spreadsheet formatting?

No. The skill is designed to study and exactly match existing templates, styles, and conventions when modifying files, preserving your established patterns.

Excel & Financial Modeling Pro

Name: Excel & Financial Modeling Pro
Author: Krosebrook

byKrosebrook

•

数据科学与机器学习

Automates spreadsheet creation, complex financial modeling, and data analysis with professional formatting and formula integrity.

关于

This skill empowers Claude to handle sophisticated spreadsheet tasks, ranging from large-scale data analysis to production-grade financial models. It enforces strict industry standards, including specific color-coding for inputs and calculations, precise number formatting, and mandatory formula recalculation to eliminate errors like #REF! or #DIV/0!. By combining the data processing power of pandas with the formatting capabilities of openpyxl, it ensures every spreadsheet is dynamic, audit-ready, and professional.

主要功能

Production-grade financial modeling with industry-standard color coding and formatting
Automated formula verification and recalculation to ensure zero calculation errors
Seamless integration with pandas for high-performance data analysis and visualization
Template preservation that matches existing styles and conventions during modifications
Support for multiple formats including .xlsx, .xlsm, .csv, and .tsv
1 GitHub stars

使用场景

Analyzing and cleaning large datasets before exporting to audit-ready Excel workbooks
Building automated financial projection models with dynamic scenarios and assumptions
Generating formatted corporate reports from raw data sources with proper sourcing documentation

关于

主要功能

Production-grade financial modeling with industry-standard color coding and formatting
Automated formula verification and recalculation to ensure zero calculation errors
Seamless integration with pandas for high-performance data analysis and visualization
Template preservation that matches existing styles and conventions during modifications
Support for multiple formats including .xlsx, .xlsm, .csv, and .tsv
1 GitHub stars

使用场景

Analyzing and cleaning large datasets before exporting to audit-ready Excel workbooks
Building automated financial projection models with dynamic scenarios and assumptions
Generating formatted corporate reports from raw data sources with proper sourcing documentation