Can I use it to modify existing templates?

Absolutely. The skill is designed to study and match existing formats and styles, ensuring that new modifications respect established template conventions.

Does it prefer formulas or hardcoded values?

It strictly prioritizes Excel formulas over hardcoded Python results. This ensures that the resulting spreadsheet remains dynamic and can recalculate when source data changes.

What Python libraries does it use?

It leverages pandas for data analysis and bulk operations, and openpyxl for complex formatting, cell-level styling, and formula construction.

Does this skill support financial modeling standards?

Yes, it enforces industry-standard conventions including Blue text for hardcoded inputs, Black for formulas, and specific formatting for currency, percentages, and multiples.

How does it ensure formula accuracy?

The skill follows a 'Zero Formula Errors' policy, utilizing a mandatory recalc.py script and LibreOffice to check for #REF!, #DIV/0!, and other common Excel errors.

Excel Master & Financial Modeler

Name: Excel Master & Financial Modeler
Author: sickn33

bysickn33

•

31,721

•

Data Science & ML

Automates the creation, editing, and analysis of professional Excel workbooks using industry-standard financial modeling conventions.

The xlsx-official skill equips Claude with a rigorous framework for high-stakes spreadsheet tasks, ensuring zero formula errors and adherence to professional financial standards. It provides specialized workflows for Python-based manipulation using pandas and openpyxl while enforcing strict conventions like color-coded inputs, dynamic formula generation over hardcoded values, and mandatory recalculation audits. This skill is ideal for users building investment models, corporate budgets, or complex data reports where accuracy, auditability, and standardized formatting are critical.

Key Features

0131,721 GitHub stars

02Zero-error formula enforcement with automated verification

03Automated formula recalculation via LibreOffice integration

04Industry-standard financial color coding (Blue for inputs, Black for formulas)

05Programmatic Excel manipulation using pandas and openpyxl

06Preservation of existing template styles and conventions

Use Cases

01Automating the generation of formatted corporate reports from raw data

02Developing investment-grade financial models and projections

03Auditing and repairing broken formulas in complex workbooks

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add sickn33/antigravity-awesome-skills xlsx-official

For use in Claude.ai and ChatGPT

Key Features

0131,721 GitHub stars

02Zero-error formula enforcement with automated verification

03Automated formula recalculation via LibreOffice integration

04Industry-standard financial color coding (Blue for inputs, Black for formulas)

05Programmatic Excel manipulation using pandas and openpyxl

06Preservation of existing template styles and conventions

Use Cases

01Automating the generation of formatted corporate reports from raw data

02Developing investment-grade financial models and projections

03Auditing and repairing broken formulas in complex workbooks

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add sickn33/antigravity-awesome-skills xlsx-official

For use in Claude.ai and ChatGPT