Can Claude recalculate formulas in Excel files using this skill?

Yes, the skill includes a specialized recalculation script that uses LibreOffice to evaluate all formulas and verify that no calculation errors like #REF! or #DIV/0! exist.

How does it handle data analysis versus spreadsheet creation?

It uses a hybrid approach: pandas for high-performance data analysis and visualization, and openpyxl for tasks requiring formula preservation and specific cell styling.

Will it overwrite my existing spreadsheet formatting?

No. The skill is designed to study and match existing styles, ensuring that template conventions are preserved and not replaced by generic formatting.

Does this skill support industry-standard financial formatting?

Absolutely. It follows strict conventions such as blue text for hardcoded inputs, black for formulas, and green for internal worksheet links to ensure professional financial model standards.

Advanced Excel & Spreadsheet Engineer

Name: Advanced Excel & Spreadsheet Engineer
Author: kjgarza

bykjgarza

数据科学与机器学习

Provides comprehensive spreadsheet creation, financial modeling, and data analysis with strict formula preservation and industry-standard formatting.

关于

This skill transforms Claude into a sophisticated spreadsheet architect capable of building, auditing, and analyzing complex Excel workbooks. It enforces high-fidelity financial modeling practices, including specific color-coding for inputs and calculations, and ensures zero formula errors through an integrated LibreOffice recalculation engine. By combining pandas for data manipulation and openpyxl for cell-level formatting, it allows Claude to generate dynamic, production-ready spreadsheets that maintain logical integrity and professional aesthetic standards.

主要功能

Support for complex Excel features including formulas, styles, conditional formatting, and cell comments.
Hybrid data processing using pandas for analysis and openpyxl for preserved workbook logic.
Dynamic spreadsheet construction that replaces hardcoded values with updateable cell references.
0 GitHub stars
Industry-standard financial modeling with automated color-coding (Blue for inputs, Black for formulas).
Automated formula recalculation and error detection via LibreOffice-powered verification.

使用场景

Updating corporate spreadsheet templates while strictly preserving existing brand styles and conventions.
Auditing and repairing broken Excel files by identifying #REF!, #DIV/0!, and circular references.
Building automated financial models with standard currency, multiple, and percentage formatting.

关于

主要功能

Support for complex Excel features including formulas, styles, conditional formatting, and cell comments.
Hybrid data processing using pandas for analysis and openpyxl for preserved workbook logic.
Dynamic spreadsheet construction that replaces hardcoded values with updateable cell references.
0 GitHub stars
Industry-standard financial modeling with automated color-coding (Blue for inputs, Black for formulas).
Automated formula recalculation and error detection via LibreOffice-powered verification.

使用场景

Updating corporate spreadsheet templates while strictly preserving existing brand styles and conventions.
Auditing and repairing broken Excel files by identifying #REF!, #DIV/0!, and circular references.
Building automated financial models with standard currency, multiple, and percentage formatting.