How does this skill handle formula errors?

It uses a mandatory verification workflow and the recalc.py script to scan for and eliminate common Excel errors like #REF!, #VALUE!, and #DIV/0! before delivery.

Does it support financial modeling standards?

Absolutely. It follows industry-standard color coding (blue for inputs, black for formulas) and professional number formatting for currencies, multiples, and percentages.

Can it preserve my existing spreadsheet's formatting?

Yes, the skill is designed to study and match your existing templates' styles, conventions, and patterns when modifying files to ensure consistency.

What libraries does it use for Excel operations?

It utilizes pandas for data-heavy analysis and openpyxl for tasks requiring precise formatting, styles, and complex formula preservation.

Excel & Spreadsheet Mastery

Name: Excel & Spreadsheet Mastery
Author: BA-CalderonMorales

byBA-CalderonMorales

0•

データサイエンスとML

Automates the creation, editing, and sophisticated analysis of Excel spreadsheets with a focus on financial modeling standards and formula integrity.

This skill empowers Claude to handle complex spreadsheet tasks by combining the data manipulation power of pandas with the formatting and formula capabilities of openpyxl. It enforces high-standard financial modeling practices, including industry-standard color coding and rigorous formula error prevention. Whether building dynamic financial models from scratch, analyzing large datasets, or updating existing templates, it ensures all outputs are professional, accurate, and fully recalculated using integrated LibreOffice tools. It prioritizes dynamic formulas over hardcoded values, ensuring your spreadsheets remain functional and updateable.

主な機能

01Industry-standard financial modeling color coding and professional number formatting

02Dynamic formula generation and validation to eliminate #REF! and #DIV/0! errors

03Seamless integration with pandas for data analysis and openpyxl for complex styling

04Template preservation that respects existing styles and conventions during updates

05Automated formula recalculation using LibreOffice to ensure data consistency

060 GitHub stars

ユースケース

01Building automated financial models with dynamic projections and professional formatting

02Batch updating existing spreadsheet templates while preserving complex formulas and styling

03Analyzing and visualizing large datasets within Excel workbooks for business reporting

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add ba-calderonmorales/immersive-awe-canvas xlsx

For use in Claude.ai and ChatGPT

主な機能

01Industry-standard financial modeling color coding and professional number formatting

02Dynamic formula generation and validation to eliminate #REF! and #DIV/0! errors

03Seamless integration with pandas for data analysis and openpyxl for complex styling

04Template preservation that respects existing styles and conventions during updates

05Automated formula recalculation using LibreOffice to ensure data consistency

060 GitHub stars

ユースケース

01Building automated financial models with dynamic projections and professional formatting

02Batch updating existing spreadsheet templates while preserving complex formulas and styling

03Analyzing and visualizing large datasets within Excel workbooks for business reporting