How does this skill handle formula recalculation?

It uses a dedicated recalculation script that leverages LibreOffice to ensure all formulas are evaluated and errors are caught before the file is finalized.

Can it maintain the formatting of my existing templates?

Yes, the skill is designed to study and match existing formats and styles, ensuring that automated updates do not disrupt your established design patterns.

What Python libraries are used for these operations?

The skill primarily utilizes pandas for high-level data manipulation and openpyxl for granular control over Excel formatting, formulas, and workbook structure.

Does it follow standard financial modeling practices?

Absolutely. It enforces industry conventions such as blue text for hardcoded inputs, black for formulas, and specific formatting for currency, multiples, and percentages.

Excel Automation and Financial Modeling

Name: Excel Automation and Financial Modeling
Author: prof-ramos

byprof-ramos

•

数据科学与机器学习

Automates professional spreadsheet creation, complex financial modeling, and advanced data analysis within Claude Code.

This skill empowers Claude to act as a professional financial analyst and data engineer by enabling the precise creation and modification of Excel workbooks. It enforces industry-standard financial modeling practices, including strict color-coding for inputs and formulas, automated error checking using LibreOffice, and professional number formatting. Whether generating dynamic reports with pandas or building robust models with openpyxl, this skill ensures zero formula errors and high-quality output while strictly preserving existing template conventions.

主要功能

01Advanced data analysis and visualization using pandas and openpyxl

02Strict adherence to financial modeling standards including industry-standard color-coding

03Automated formula recalculation and error detection via LibreOffice integration

04Intelligent template preservation that maintains existing styles and conventions

05Professional spreadsheet creation with complex formulas and dynamic cell referencing

061 GitHub stars

使用场景

01Transforming raw datasets from CSV/TSV into formatted, formula-driven Excel reports

02Auditing and repairing complex spreadsheets to eliminate formula errors like #REF! or #DIV/0!

03Building dynamic financial models with automated projections and scenario analysis

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add prof-ramos/.codex xlsx

For use in Claude.ai and ChatGPT

Download Skill