What is required for the formula recalculation feature?

The skill utilizes a recalc.py script which assumes LibreOffice is installed to programmatically evaluate formulas and identify errors like #REF! or #VALUE!.

Can I use this to analyze existing data files?

Absolutely. It leverages pandas for data manipulation, allowing Claude to perform statistical analysis and visualization on your existing spreadsheet data.

Will it preserve my existing spreadsheet's formatting?

Yes, it is designed to study and match existing styles, and conventions. Existing template patterns always override standard guidelines to ensure consistency.

Does this skill support complex Excel formulas?

Yes, it prioritizes dynamic Excel formulas over hardcoded values and utilizes a recalculation engine to ensure all references are accurate and functional.

How does it handle financial modeling standards?

It follows professional conventions: blue text for hardcoded inputs, black for formulas, and specific formatting for currency, multiples, and percentages.

Excel & Spreadsheet Mastery

Name: Excel & Spreadsheet Mastery
Author: Daisuke134

byDaisuke134

•

データサイエンスとML

Automates advanced spreadsheet creation, data analysis, and professional financial modeling with rigorous formula validation.

概要

This skill transforms Claude into a sophisticated spreadsheet engineer capable of building, editing, and analyzing complex .xlsx files. It moves beyond basic data entry by implementing industry-standard financial modeling practices, including specific color-coding conventions (blue for inputs, black for formulas) and strict number formatting. By integrating pandas for data manipulation and openpyxl for formatting, it ensures that every spreadsheet is dynamic and error-free. The skill specifically prioritizes live formulas over hardcoded values and includes a robust recalculation workflow to prevent common errors like #REF! or #DIV/0!.

主な機能

Industry-standard financial model color-coding (Blue/Black/Green/Red)
Comprehensive support for .xlsx, .xlsm, .csv, and .tsv formats
Zero-error formula generation and validation using recalc.py
Template-aware editing that preserves existing styles and conventions
Powerful data analysis and visualization using pandas integration
3 GitHub stars

ユースケース

Building dynamic three-statement financial models with automated growth assumptions
Cleaning and analyzing large datasets to generate formatted business reports
Modifying corporate Excel templates while maintaining strict brand formatting

概要

主な機能

Industry-standard financial model color-coding (Blue/Black/Green/Red)
Comprehensive support for .xlsx, .xlsm, .csv, and .tsv formats
Zero-error formula generation and validation using recalc.py
Template-aware editing that preserves existing styles and conventions
Powerful data analysis and visualization using pandas integration
3 GitHub stars

ユースケース

Building dynamic three-statement financial models with automated growth assumptions
Cleaning and analyzing large datasets to generate formatted business reports
Modifying corporate Excel templates while maintaining strict brand formatting