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

•

数据科学与机器学习

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.

主要功能

Standardized financial modeling formatting and color-coding
Automated formula recalculation using LibreOffice integration
Validation system to ensure zero formula errors like #REF! or #DIV/0!
Support for multiple formats including .xlsx, .xlsm, .csv, and .tsv
1 GitHub stars
Seamless integration between pandas data analysis and openpyxl styling

使用场景

Building dynamic financial models with automated growth assumptions and scenario analysis
Cleaning and transforming large datasets from raw CSVs into professionally formatted Excel reports
Updating existing corporate Excel templates while preserving complex formulas and established styles

关于

主要功能

Standardized financial modeling formatting and color-coding
Automated formula recalculation using LibreOffice integration
Validation system to ensure zero formula errors like #REF! or #DIV/0!
Support for multiple formats including .xlsx, .xlsm, .csv, and .tsv
1 GitHub stars
Seamless integration between pandas data analysis and openpyxl styling

使用场景

Building dynamic financial models with automated growth assumptions and scenario analysis
Cleaning and transforming large datasets from raw CSVs into professionally formatted Excel reports
Updating existing corporate Excel templates while preserving complex formulas and established styles