How does it ensure formula accuracy?

It utilizes a mandatory recalculation script that scans for errors like #REF!, #DIV/0!, and #VALUE!, ensuring the final file is delivered error-free.

Can it handle industry-standard financial formatting?

Absolutely. It follows standard conventions such as blue text for inputs, black for formulas, and specific formatting for currencies, multiples, and percentages.

Does this skill support complex Excel formulas?

Yes, it prioritizes dynamic Excel formulas over hardcoded values, ensuring that your spreadsheets remain interactive and update automatically when data changes.

Does it work with existing Excel templates?

Yes, the skill is designed to study and match the existing format, style, and conventions of any template you provide, ensuring seamless updates.

Advanced Excel & Spreadsheet Automation

Name: Advanced Excel & Spreadsheet Automation
Author: Daisuke134

byDaisuke134

•

Data Science & ML

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

This skill equips Claude with the tools to handle complex spreadsheet workflows, including the creation of dynamic financial models, data visualization, and bulk editing of .xlsx and .csv files. It enforces industry-standard formatting—such as specific color-coding for financial inputs and calculations—and ensures technical accuracy through an automated formula recalculation script. By integrating pandas for data manipulation and openpyxl for structural formatting, it allows for the generation of production-ready spreadsheets that maintain data integrity and professional aesthetics.

Key Features

01Dynamic formula generation with automated error detection and validation

02Data analysis and visualization using pandas and openpyxl

03Template preservation to maintain existing styles and conventions during updates

043 GitHub stars

05LibreOffice-powered formula recalculation for verified spreadsheet outputs

06Industry-standard financial modeling styles (color coding, specific number formats)

Use Cases

01Building robust financial models with linked assumptions and zero formula errors

02Analyzing and transforming large datasets from CSV into formatted Excel reports

03Updating legacy spreadsheets while preserving complex formatting and cell references

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