How does it ensure formula accuracy?

It includes a mandatory verification checklist and a recalculation script that scans for common Excel errors like #REF!, #DIV/0!, and #VALUE! before delivery.

How does this skill handle Excel formulas?

It uses openpyxl to write formulas as strings and includes a specialized script to recalculate values, ensuring the final output is dynamic rather than hardcoded.

Can it modify existing Excel templates?

Absolutely. The skill is designed to load existing workbooks and preserve their specific formatting, styles, and conventions during any modification.

Does it support financial modeling standards?

Yes, it enforces industry-standard color coding—such as blue for inputs and black for formulas—and specific number formatting for currencies and multiples.

What libraries are required for this skill?

This skill leverages pandas for data analysis and openpyxl for formula and style manipulation, along with LibreOffice for background recalculation.

Advanced Excel & Financial Model Processor

Name: Advanced Excel & Financial Model Processor
Author: lawvable

bylawvable

•

데이터 과학 및 ML

Automates the creation, modification, and analysis of professional Excel spreadsheets using industry-standard financial modeling and legal automation patterns.

소개

This skill provides a comprehensive toolkit for managing Excel workbooks through Claude Code, specifically optimized for high-stakes environments like legal and financial sectors. It bridges the gap between Python-based data manipulation and professional spreadsheet standards, ensuring formula integrity, consistent industry-standard color-coding, and precise recalculations via LibreOffice. It is particularly useful for users needing to maintain complex financial models where dynamic formulas are required over hardcoded values and where meticulous documentation of data sources is mandatory.

주요 기능

Professional financial model formatting with industry-standard color coding (Blue/Black/Green/Red)
Automated documentation requirements for hardcoded assumptions and data sources
Automatic formula recalculation and error verification using an integrated recalc script
38 GitHub stars
Hybrid support for pandas (analysis) and openpyxl (formatting/formulas)
Template preservation that matches existing styles and conventions in legacy files

사용 사례

Building dynamic financial projection models with automated formula error prevention
Updating corporate legal spreadsheets while preserving existing styles and complex logical paths
Analyzing large datasets with pandas and exporting them into formatted Excel reports

소개

주요 기능

Professional financial model formatting with industry-standard color coding (Blue/Black/Green/Red)
Automated documentation requirements for hardcoded assumptions and data sources
Automatic formula recalculation and error verification using an integrated recalc script
38 GitHub stars
Hybrid support for pandas (analysis) and openpyxl (formatting/formulas)
Template preservation that matches existing styles and conventions in legacy files

사용 사례

Building dynamic financial projection models with automated formula error prevention
Updating corporate legal spreadsheets while preserving existing styles and complex logical paths
Analyzing large datasets with pandas and exporting them into formatted Excel reports