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

•

Ciencia de Datos y ML

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

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.

Características Principales

01Institutional financial modeling standards including specific color-coding and number formatting

02Dynamic Excel formula generation to replace hardcoded calculations

03Advanced data analysis, visualization, and manipulation using pandas

04Automated formula recalculation and error validation via LibreOffice integration

0516 GitHub stars

06Template preservation logic that matches existing styles and conventions during updates

Casos de Uso

01Building dynamic financial models with automated assumptions and institutional-grade formatting

02Performing complex data analysis on large datasets with automated CSV/XLSX reporting

03Updating existing corporate spreadsheet templates while maintaining formula integrity and styles

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add rysweet/amplihack xlsx

For use in Claude.ai and ChatGPT

Download Skill