How does this skill handle Excel formula errors?

The skill uses a mandatory recalculation script (recalc.py) powered by LibreOffice to scan every cell for errors like #REF!, #DIV/0!, or #VALUE!, ensuring models are delivered error-free.

Does it follow standard financial modeling conventions?

Yes, it defaults to industry standards such as blue text for hardcoded inputs, black for formulas, and green for internal worksheet links unless otherwise specified.

What libraries does this skill use for spreadsheet operations?

It utilizes pandas for data-heavy analysis and bulk operations, and openpyxl for complex formatting, cell styling, and formula preservation.

Can it modify existing Excel templates without breaking them?

Absolutely. The skill is designed to study and exactly match existing formats, styles, and conventions, prioritizing the existing template's patterns over standard guidelines.

Advanced Excel & Spreadsheet Automation

Name: Advanced Excel & Spreadsheet Automation
Author: rysweet

byrysweet

•

Data Science & ML

Automates the creation, editing, and analysis of professional-grade spreadsheets with precise formula management and institutional formatting.

About

This skill empowers Claude to interact with Excel and CSV files with the precision of a professional data analyst or financial modeler. It handles everything from high-performance data manipulation using pandas to complex financial modeling using openpyxl, ensuring all calculations are performed via dynamic formulas rather than hardcoded values. The skill incorporates a mandatory recalculation and verification workflow using LibreOffice to guarantee zero formula errors like #REF! or #DIV/0!, while strictly adhering to industry-standard formatting and color-coding conventions for production-ready financial outputs.

Key Features

Institutional financial modeling standards including specific color-coding and number formatting
Dynamic Excel formula generation to replace hardcoded calculations
Advanced data analysis, visualization, and manipulation using pandas
Automated formula recalculation and error validation via LibreOffice integration
16 GitHub stars
Template preservation logic that matches existing styles and conventions during updates

Use Cases

Building dynamic financial models with automated assumptions and institutional-grade formatting
Performing complex data analysis on large datasets with automated CSV/XLSX reporting
Updating existing corporate spreadsheet templates while maintaining formula integrity and styles

About

Key Features

Institutional financial modeling standards including specific color-coding and number formatting
Dynamic Excel formula generation to replace hardcoded calculations
Advanced data analysis, visualization, and manipulation using pandas
Automated formula recalculation and error validation via LibreOffice integration
16 GitHub stars
Template preservation logic that matches existing styles and conventions during updates

Use Cases

Building dynamic financial models with automated assumptions and institutional-grade formatting
Performing complex data analysis on large datasets with automated CSV/XLSX reporting
Updating existing corporate spreadsheet templates while maintaining formula integrity and styles