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

•

Data Science & 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.

Key Features

01Professional financial model formatting with industry-standard color coding (Blue/Black/Green/Red)

02Automated documentation requirements for hardcoded assumptions and data sources

03Automatic formula recalculation and error verification using an integrated recalc script

0438 GitHub stars

05Hybrid support for pandas (analysis) and openpyxl (formatting/formulas)

06Template preservation that matches existing styles and conventions in legacy files

Use Cases

01Building dynamic financial projection models with automated formula error prevention

02Updating corporate legal spreadsheets while preserving existing styles and complex logical paths

03Analyzing large datasets with pandas and exporting them into formatted Excel reports

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add lawvable/awesome-legal-skills xlsx-processing-anthropic

For use in Claude.ai and ChatGPT

Download Skill