Can this skill handle complex Excel formulas?

Yes, it supports full formula construction using openpyxl and includes a mandatory recalculation script to ensure all formulas resolve correctly without errors.

What file formats are supported?

The skill supports .xlsx, .xlsm, .csv, and .tsv formats for comprehensive reading, writing, and data manipulation operations.

Does it follow financial modeling standards?

Yes, the skill enforces industry-standard color coding (blue for inputs, black for formulas) and specific number formatting for currencies, percentages, and valuation multiples.

How does it ensure formulas are not broken after editing?

It utilizes a recalc.py script that leverages LibreOffice to verify all cell references and identifies errors like #REF! or #VALUE! before finalizing the file.

Can I use this for data visualization within spreadsheets?

Absolutely. It leverages pandas for data processing and openpyxl for applying visual formatting, cell fills, and structural layouts to create presentation-ready workbooks.

Excel Spreadsheet Management & Analysis

Name: Excel Spreadsheet Management & Analysis
Author: ttmouse

byttmouse

•

Data Science & ML

Automates the creation, editing, and analysis of professional Excel spreadsheets with advanced formula support and financial modeling standards.

About

This skill empowers Claude to handle complex spreadsheet tasks, ranging from simple CSV processing to building sophisticated financial models. It ensures data integrity by enforcing zero-error formula policies and adhering to industry-standard formatting conventions like specific color coding for inputs and calculations. Whether you are generating data-heavy reports with pandas, applying granular styles with openpyxl, or recalculating dynamic formulas via LibreOffice integration, this skill provides a robust, production-ready framework for professional Excel automation and data visualization.

Key Features

Advanced formula creation and verification with zero-error enforcement (#REF!, #DIV/0!)
Seamless integration with pandas for data analysis and openpyxl for structural styling
Intelligent template preservation that matches existing styles and conventions
Automated formula recalculation using a specialized LibreOffice-based script
Industry-standard financial modeling color coding and professional number formatting
31 GitHub stars

Use Cases

Building dynamic financial models with standardized assumptions, formatting, and source documentation
Automating the generation of recurring business reports while maintaining complex, updateable formula chains
Analyzing and visualizing large datasets from CSV or XLSX files using automated pandas workflows

About

Key Features

Advanced formula creation and verification with zero-error enforcement (#REF!, #DIV/0!)
Seamless integration with pandas for data analysis and openpyxl for structural styling
Intelligent template preservation that matches existing styles and conventions
Automated formula recalculation using a specialized LibreOffice-based script
Industry-standard financial modeling color coding and professional number formatting
31 GitHub stars

Use Cases

Building dynamic financial models with standardized assumptions, formatting, and source documentation
Automating the generation of recurring business reports while maintaining complex, updateable formula chains
Analyzing and visualizing large datasets from CSV or XLSX files using automated pandas workflows