How does it handle formula errors like #REF! or #NAME?

The skill includes a mandatory verification step that scans all cells for errors and provides a detailed summary to fix them before the file is finalized.

Can it handle professional financial modeling standards?

Absolutely. It includes specific rules for industry-standard color-coding, such as blue text for hardcoded inputs and black text for formulas.

Does this skill support complex Excel formulas?

Yes, it supports full formula creation and uses a specialized recalculation script to evaluate values and verify accuracy within the workbook.

Is external software required for formula recalculation?

Yes, the skill utilizes LibreOffice via a Python script to ensure that formulas are correctly recalculated and values are populated in the file.

Can it modify existing Excel templates?

Yes, it is designed to load existing workbooks, insert or delete rows and columns, and update data while preserving the original formatting and style.

Advanced Excel & Spreadsheet Engineering

Name: Advanced Excel & Spreadsheet Engineering
Author: Krosebrook

byKrosebrook

•

Data Science & ML

Creates, modifies, and analyzes professional Excel spreadsheets with automated formula recalculation and industry-standard financial formatting.

This skill empowers Claude to handle complex spreadsheet tasks ranging from simple data entry to building sophisticated financial models. It ensures production-grade output by enforcing zero formula errors and adhering to industry-standard formatting conventions, such as color-coded inputs and specific number formats. By leveraging Python libraries like pandas and openpyxl alongside a specialized recalculation script, it provides a robust workflow for maintaining dynamic, formula-driven workbooks while avoiding the pitfalls of hardcoded values.

Key Features

01Standardized financial modeling formatting and color-coding

02Automated formula recalculation using LibreOffice integration

03Validation system to ensure zero formula errors like #REF! or #DIV/0!

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

051 GitHub stars

06Seamless integration between pandas data analysis and openpyxl styling

Use Cases

01Building dynamic financial models with automated growth assumptions and scenario analysis

02Cleaning and transforming large datasets from raw CSVs into professionally formatted Excel reports

03Updating existing corporate Excel templates while preserving complex formulas and established styles

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