Can it modify existing Excel templates without breaking formatting?

Yes, it is specifically designed to study and exactly match existing styles and conventions, ensuring that template patterns are preserved during updates.

How does this skill handle Excel formula errors?

The skill utilizes a mandatory recalculation script (recalc.py) that scans every cell for errors like #REF!, #DIV/0!, and #VALUE!, ensuring all models are delivered error-free.

Which Python libraries are used for spreadsheet operations?

It leverages pandas for high-performance data manipulation and openpyxl for complex formatting, formulas, and preserving Excel-specific features.

Does it support professional financial formatting?

Absolutely. It follows industry standards such as blue text for hardcoded inputs, black for formulas, and specific currency, percentage, and multiple formatting rules.

Excel & Spreadsheet Mastery

Name: Excel & Spreadsheet Mastery
Author: rysweet

byrysweet

数据科学与机器学习

Enables professional spreadsheet creation, data analysis, and financial modeling with rigorous formula verification and industry-standard formatting.

关于

This skill empowers Claude to perform advanced spreadsheet operations, ranging from basic CSV manipulation to building complex financial models with professional formatting and dynamic formulas. It enforces strict standards such as zero-error formula verification using a dedicated recalculation engine, color-coded financial conventions, and comprehensive data analysis via pandas. Whether you are generating new reports, analyzing large datasets, or updating established templates while preserving existing styles, this skill ensures accuracy, auditability, and professional-grade output in .xlsx, .xlsm, and other spreadsheet formats.

主要功能

Advanced data analysis and visualization using pandas for large-scale data manipulation
Template preservation logic that matches existing styles and formatting patterns
Dynamic formula creation with automated recalculation and error detection via LibreOffice
Professional financial modeling standards including color-coded inputs and formula conventions
Strict verification for common Excel errors like #REF!, #DIV/0!, and circular references
0 GitHub stars

使用场景

Performing data cleaning and statistical analysis on large datasets with automated spreadsheet export
Automating the update of complex corporate reporting templates while maintaining formula integrity
Building dynamic financial projection models from raw business assumptions and data sources

关于

主要功能

Advanced data analysis and visualization using pandas for large-scale data manipulation
Template preservation logic that matches existing styles and formatting patterns
Dynamic formula creation with automated recalculation and error detection via LibreOffice
Professional financial modeling standards including color-coded inputs and formula conventions
Strict verification for common Excel errors like #REF!, #DIV/0!, and circular references
0 GitHub stars

使用场景

Performing data cleaning and statistical analysis on large datasets with automated spreadsheet export
Automating the update of complex corporate reporting templates while maintaining formula integrity
Building dynamic financial projection models from raw business assumptions and data sources