Can this skill handle existing Excel templates?

Yes, it is designed to study and match existing formats, styles, and conventions when modifying established files, ensuring your brand standards are maintained.

What Python libraries does it use?

The skill leverages pandas for data analysis and bulk operations, and openpyxl for complex formatting, formulas, and workbook-specific features.

Is it suitable for professional financial modeling?

Yes, it includes built-in standards for color-coding inputs (blue) and formulas (black), as well as specific formatting for currency, percentages, and multiples.

How are formula errors prevented?

The skill uses a mandatory recalculation step via LibreOffice that scans for errors like #REF!, #DIV/0!, or #VALUE! before the file is delivered.

Does it support complex Excel formulas?

Absolutely. It prioritizes dynamic formulas over hardcoded values and uses a specialized recalculation script to ensure all cell values are accurate.

Advanced Excel & Financial Modeler

Name: Advanced Excel & Financial Modeler
Author: netbarros

bynetbarros

•

データサイエンスとML

Creates, edits, and analyzes complex Excel workbooks with professional financial standards and dynamic formula support.

This skill empowers Claude to handle sophisticated spreadsheet tasks, ranging from deep data analysis with pandas to complex financial modeling using openpyxl. It enforces industry-standard formatting conventions—such as color-coded inputs and formula-based calculations—while ensuring zero-error delivery through automated LibreOffice recalculation. It is ideal for developers and analysts who need to programmatically generate production-ready spreadsheets that remain dynamic, audit-ready, and professional.

主な機能

01High-performance data manipulation and visualization using the pandas library.

02Dynamic formula generation using openpyxl to ensure spreadsheets remain updateable.

036 GitHub stars

04Professional financial modeling with industry-standard color coding and number formatting.

05Strict validation against common Excel errors like #REF!, #DIV/0!, and circular references.

06Automated formula recalculation and error detection via LibreOffice integration.

ユースケース

01Updating existing Excel templates while strictly preserving original styles and conventions.

02Cleaning and transforming large datasets into formatted Excel reports for stakeholders.

03Building automated financial models with scenario analysis and standardized formatting.

主な機能

01High-performance data manipulation and visualization using the pandas library.

02Dynamic formula generation using openpyxl to ensure spreadsheets remain updateable.

036 GitHub stars

04Professional financial modeling with industry-standard color coding and number formatting.

05Strict validation against common Excel errors like #REF!, #DIV/0!, and circular references.

06Automated formula recalculation and error detection via LibreOffice integration.

ユースケース

01Updating existing Excel templates while strictly preserving original styles and conventions.

02Cleaning and transforming large datasets into formatted Excel reports for stakeholders.

03Building automated financial models with scenario analysis and standardized formatting.