Can I use this for professional financial modeling?

Yes, it follows industry standards such as blue text for hardcoded inputs, black for formulas, and specific formatting for currencies, multiples, and percentages.

How does it handle formula errors like #REF! or #DIV/0!?

The skill utilizes a mandatory recalculation script (recalc.py) that scans for errors after modifications, providing a detailed JSON summary of any issues found.

What libraries are used for spreadsheet operations?

The skill uses pandas for high-performance data manipulation and openpyxl for complex formatting, formulas, and workbook-specific features.

Does this skill support Excel formulas?

Yes, the skill prioritizes Excel formulas over hardcoded values to ensure spreadsheets remain dynamic and can be updated by the user manually later.

Is any external software required for this skill?

For full formula recalculation and verification functionality, LibreOffice must be installed on the host system.

Advanced Excel & Spreadsheet Manager

Name: Advanced Excel & Spreadsheet Manager
Author: thanhtoan105

bythanhtoan105

•

Data Science & ML

Automates the creation, editing, and professional formatting of complex Excel workbooks and financial models with full formula support.

About

This skill enables Claude to handle sophisticated spreadsheet tasks ranging from basic data analysis with pandas to building investment-grade financial models with openpyxl. it enforces industry-standard formatting conventions, ensures zero formula errors through automated recalculation via LibreOffice, and maintains strict documentation standards for hardcoded inputs. Whether generating dynamic reports, performing deep data visualization, or modifying existing templates while preserving legacy logic, this skill provides the rigor and precision required for professional spreadsheet engineering.

Key Features

Automated formula validation and recalculation using LibreOffice integration
1 GitHub stars
Support for complex workbook operations including multi-sheet management
Professional financial modeling with industry-standard color coding and formatting
Comprehensive data analysis and visualization using pandas and openpyxl
Strict error prevention for common issues like #REF!, #DIV/0!, and #VALUE!

Use Cases

Analyzing large datasets from CSV/TSV files to generate formatted Excel reports with charts
Building dynamic financial projection models with automated growth rates and margin logic
Updating enterprise spreadsheet templates while preserving legacy formatting and formula integrity

About

Key Features

Automated formula validation and recalculation using LibreOffice integration
1 GitHub stars
Support for complex workbook operations including multi-sheet management
Professional financial modeling with industry-standard color coding and formatting
Comprehensive data analysis and visualization using pandas and openpyxl
Strict error prevention for common issues like #REF!, #DIV/0!, and #VALUE!

Use Cases

Analyzing large datasets from CSV/TSV files to generate formatted Excel reports with charts
Building dynamic financial projection models with automated growth rates and margin logic
Updating enterprise spreadsheet templates while preserving legacy formatting and formula integrity