Can I use it for data visualization?

Yes, it leverages pandas for data manipulation and openpyxl for formatting, allowing for the creation of clean, professional data visualizations within the spreadsheet.

Does it support industry-standard financial formatting?

Absolutely. It follows standard conventions such as blue text for inputs, black for formulas, and yellow backgrounds for key assumptions to ensure models are audit-ready.

Why is LibreOffice mentioned in the requirements?

LibreOffice is used as a backend engine to perform actual cell recalculations, ensuring that the 'data' values in the spreadsheet match the results of the formulas provided.

Can it modify existing Excel templates without breaking them?

Yes. The skill is designed to study and match existing formats, styles, and conventions, ensuring that modifications blend seamlessly with your established patterns.

How does this skill handle formula errors?

It utilizes a recalculation script powered by LibreOffice to verify every formula cell, identifying and flagging errors like #REF!, #DIV/0!, and #VALUE! before the file is finalized.

Advanced Excel & Financial Modeling

Name: Advanced Excel & Financial Modeling
Author: zephyrwang6

byzephyrwang6

•

Data Science & ML

Automates professional spreadsheet creation, data analysis, and financial modeling with rigorous formula verification and industry-standard formatting.

About

This skill transforms Claude into a sophisticated spreadsheet engineer capable of building complex, production-grade workbooks. It provides a robust framework for creating and analyzing .xlsx and .csv files using pandas and openpyxl, with a specific focus on financial modeling standards. The skill enforces strict color-coding for inputs and formulas, ensures zero formula errors through automated recalculation via LibreOffice, and preserves the integrity of existing templates. By prioritizing dynamic formulas over hardcoded values, it ensures spreadsheets remain updateable and transparent for professional use cases.

Key Features

Industry-standard financial model formatting and RGB color-coding conventions
Dynamic spreadsheet generation using live Excel formulas instead of hardcoded results
Seamless integration of pandas for data analysis and openpyxl for visual styling
Requirement-driven documentation for hardcoded values and data sources
37 GitHub stars
Automated formula recalculation and error detection (#REF!, #DIV/0!) via LibreOffice

Use Cases

Performing deep data analysis on large datasets and exporting formatted summary reports
Building dynamic financial projection models with automated growth and scenario assumptions
Updating legacy Excel templates while strictly maintaining existing styles and conventions

About

Key Features

Industry-standard financial model formatting and RGB color-coding conventions
Dynamic spreadsheet generation using live Excel formulas instead of hardcoded results
Seamless integration of pandas for data analysis and openpyxl for visual styling
Requirement-driven documentation for hardcoded values and data sources
37 GitHub stars
Automated formula recalculation and error detection (#REF!, #DIV/0!) via LibreOffice

Use Cases

Performing deep data analysis on large datasets and exporting formatted summary reports
Building dynamic financial projection models with automated growth and scenario assumptions
Updating legacy Excel templates while strictly maintaining existing styles and conventions