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

•

Ciencia de Datos y ML

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.

Características Principales

01Production-grade financial modeling with industry-standard color coding and formatting

02Automated formula verification and recalculation to ensure zero calculation errors

03Seamless integration with pandas for high-performance data analysis and visualization

04Template preservation that matches existing styles and conventions during modifications

05Support for multiple formats including .xlsx, .xlsm, .csv, and .tsv

061 GitHub stars

Casos de Uso

01Analyzing and cleaning large datasets before exporting to audit-ready Excel workbooks

02Building automated financial projection models with dynamic scenarios and assumptions

03Generating formatted corporate reports from raw data sources with proper sourcing documentation

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add krosebrook/source-of-truth-monorepo xlsx

For use in Claude.ai and ChatGPT

Download Skill