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

•

Data Science & 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!.

Key Features

01Industry-standard financial model color-coding (Blue/Black/Green/Red)

02Comprehensive support for .xlsx, .xlsm, .csv, and .tsv formats

03Zero-error formula generation and validation using recalc.py

04Template-aware editing that preserves existing styles and conventions

05Powerful data analysis and visualization using pandas integration

063 GitHub stars

Use Cases

01Building dynamic three-statement financial models with automated growth assumptions

02Cleaning and analyzing large datasets to generate formatted business reports

03Modifying corporate Excel templates while maintaining strict brand formatting

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add daisuke134/anicca.ai xlsx

For use in Claude.ai and ChatGPT

Download Skill