Does it support financial modeling color standards?

Absolutely. It follows industry conventions like blue for hardcoded inputs, black for formulas, and green for internal links unless the user specifies a different format.

Which Python libraries are used for spreadsheet operations?

It utilizes pandas for data-heavy analysis and bulk operations, while openpyxl is used for precise cell-level formatting and formula management.

Is LibreOffice required for this skill?

Yes, the skill assumes LibreOffice is installed to facilitate the recalculation of formula values, ensuring the spreadsheet is fully functional upon delivery.

How does the skill ensure Excel formulas work correctly?

The skill uses a specialized recalc.py script and LibreOffice to recalculate and validate all formulas, identifying and reporting errors like #REF! or #DIV/0! before the file is finalized.

Can it modify existing Excel templates without breaking styles?

Yes, it is programmed to study and match existing formats, styles, and conventions, ensuring that modifications blend seamlessly with your established templates.

Excel & Spreadsheet Mastery

Name: Excel & Spreadsheet Mastery
Author: GGPrompts

byGGPrompts

•

데이터 과학 및 ML

Automates professional-grade spreadsheet creation, financial modeling, and data analysis with formula preservation and validation.

The xlsx skill empowers Claude to perform sophisticated spreadsheet tasks ranging from automated data entry to high-stakes financial modeling. It enforces strict industry standards such as color-coded inputs and formula-based calculations to ensure workbooks remain dynamic and error-free. By leveraging pandas for data manipulation and openpyxl for formatting, the skill handles complex tasks like template preservation, automated recalculation via LibreOffice, and deep data visualization. It is ideal for users needing production-ready Excel files that follow professional conventions for currency, multiples, and documentation.

주요 기능

01Industry-standard financial modeling styles and color-coding conventions

02High-performance data analysis and visualization using pandas

031 GitHub stars

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

05Automated formula recalculation and zero-error validation

06Preservation of existing styles, formats, and templates during modification

사용 사례

01Building dynamic financial models with automated valuation multiples and scenario analysis

02Modifying legacy spreadsheets while maintaining complex formatting and existing calculation logic

03Transforming raw data into formatted, formula-driven reports for business intelligence

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add ggprompts/my-plugins xlsx

For use in Claude.ai and ChatGPT

Download Skill