Can it handle existing Excel templates?

Absolutely. The skill is programmed to study and match existing formats, styles, and conventions, ensuring that modifications feel seamless and professional.

What libraries are used for data processing?

The skill uses pandas for high-performance data manipulation and openpyxl for granular spreadsheet formatting, cell styling, and formula management.

How does it ensure financial modeling accuracy?

It follows strict industry standards, including specific color coding (blue for inputs, black for formulas) and rigorous zero-error verification for all cell references.

Does this skill support complex Excel formulas?

Yes, it generates standard Excel formulas rather than hardcoding values, and includes a recalculation step to verify accuracy and resolve errors before the file is finalized.

Does it require external software for formula calculation?

It utilizes a recalc.py script that leverages LibreOffice to evaluate formulas, ensuring the final spreadsheet displays correct values immediately upon being opened.

Excel Spreadsheet Analysis & Modeling

Name: Excel Spreadsheet Analysis & Modeling
Author: ricable

byricable

•

数据科学与机器学习

Automates the creation, editing, and analysis of professional-grade Excel spreadsheets with dynamic formulas and industry-standard financial formatting.

关于

This skill empowers Claude to interact with Excel and CSV files with the precision of a professional financial analyst. It combines the data processing power of pandas with the granular formatting capabilities of openpyxl, enabling the generation of complex financial models, data visualizations, and automated reports. A standout feature is its mandatory formula recalculation workflow using LibreOffice, which ensures that all spreadsheets are delivered with functional dynamic formulas and zero calculation errors (#REF!, #DIV/0!) rather than static hardcoded values.

主要功能

1 GitHub stars
Professional financial modeling with industry-standard color coding and number formatting
Dynamic Excel formula generation and automated verification to ensure zero calculation errors
Deep data analysis and visualization capabilities using pandas and openpyxl integration
Automated formula recalculation via LibreOffice for publication-quality workbooks
Intelligent template preservation that respects and matches existing file styles and conventions

使用场景

Generating automated financial models with dynamic growth scenarios and valuation multiples
Modifying existing corporate templates while maintaining strict adherence to internal formatting standards
Performing bulk data analysis on CSV datasets and exporting results into formatted Excel reports

关于

主要功能

1 GitHub stars
Professional financial modeling with industry-standard color coding and number formatting
Dynamic Excel formula generation and automated verification to ensure zero calculation errors
Deep data analysis and visualization capabilities using pandas and openpyxl integration
Automated formula recalculation via LibreOffice for publication-quality workbooks
Intelligent template preservation that respects and matches existing file styles and conventions

使用场景

Generating automated financial models with dynamic growth scenarios and valuation multiples
Modifying existing corporate templates while maintaining strict adherence to internal formatting standards
Performing bulk data analysis on CSV datasets and exporting results into formatted Excel reports