Does this skill support complex Excel formulas?

Yes, it supports full formula creation and uses a dedicated recalculation script to ensure all logic is processed correctly and error-free.

What file formats are supported?

It supports .xlsx, .xlsm, .csv, and .tsv formats for reading, writing, and editing operations.

Can it handle professional financial modeling standards?

Absolutely. It follows industry-standard color coding (blue for inputs, black for formulas) and ensures assumptions are placed in separate cells rather than hardcoded.

Will it break my existing Excel formatting?

No, the skill is designed to study and exactly match existing formats, styles, and conventions when modifying your templates.

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

It utilizes a 'recalc.py' script powered by LibreOffice to scan all cells for errors after modification, providing a detailed report for any necessary fixes.

Excel & Spreadsheet Mastery

Name: Excel & Spreadsheet Mastery
Author: ttmouse

byttmouse

•

数据科学与机器学习

Automates comprehensive spreadsheet creation, financial modeling, and data analysis while ensuring zero formula errors and industry-standard formatting.

关于

This skill enables Claude to perform professional-grade spreadsheet operations, ranging from simple data entry to complex financial modeling and data visualization. It supports a wide array of formats including .xlsx, .xlsm, .csv, and .tsv, utilizing powerful libraries like pandas for data manipulation and openpyxl for intricate formatting. The skill enforces rigorous standards such as industry-standard color coding for financial models, the use of dynamic formulas over hardcoded values, and a mandatory verification process using a LibreOffice-powered recalculation script to guarantee spreadsheets are delivered without errors like #REF! or #DIV/0!.

主要功能

Advanced formula construction with automated error detection and recalculation
25 GitHub stars
Template preservation that matches existing styles and formatting conventions
Source documentation and assumption tracking for hardcoded data
Industry-standard financial modeling (Blue/Black/Green/Red text conventions)
High-performance data analysis and visualization using pandas

使用场景

Building dynamic, error-free financial models with professional formatting
Analyzing and transforming large datasets into formatted Excel reports
Modifying existing spreadsheet templates while preserving complex formulas and styles

关于

主要功能

Advanced formula construction with automated error detection and recalculation
25 GitHub stars
Template preservation that matches existing styles and formatting conventions
Source documentation and assumption tracking for hardcoded data
Industry-standard financial modeling (Blue/Black/Green/Red text conventions)
High-performance data analysis and visualization using pandas

使用场景

Building dynamic, error-free financial models with professional formatting
Analyzing and transforming large datasets into formatted Excel reports
Modifying existing spreadsheet templates while preserving complex formulas and styles