How does this skill handle Excel formulas?

It prioritizes standard, legible formulas and performs a recalculation check to ensure no errors like #REF! or #DIV/0! exist before providing the file.

Which spreadsheet formats are supported by this skill?

The skill supports .xlsx, .xlsm, .csv, and .tsv files for reading, editing, and creating new workbooks.

Does it support professional financial formatting?

Yes, it includes specific rules for investment banking and finance, such as blue-text for inputs, black for formulas, and specialized number formats for multiples and currencies.

Can it create charts and visualizations?

Yes, the skill can generate in-sheet charts, apply conditional formatting, and use visual elements like borders and fills to create professional dashboards.

Will it break my existing spreadsheet formatting?

No, the skill is designed to render and examine existing styles before making changes, ensuring that all modifications match the original document's aesthetic.

Spreadsheet Automation & Financial Modeling

Name: Spreadsheet Automation & Financial Modeling
Author: lawvable

bylawvable

•

데이터 과학 및 ML

Automates the creation, analysis, and professional formatting of complex spreadsheets and financial models with visual validation.

소개

This skill provides a comprehensive toolkit for advanced spreadsheet manipulation within Claude Code. It enables the creation of presentation-ready workbooks, sophisticated data analysis, and the preservation of complex formula structures in .xlsx, .csv, and .tsv formats. Beyond simple data entry, it enforces industry-standard formatting—including specific conventions for investment banking and financial modeling—and utilizes visual quality control to ensure every sheet is professionally styled and mathematically accurate before delivery.

주요 기능

Robust tabular data analysis including aggregation, filtering, and metric computation
Seamless modification of existing workbooks while preserving legacy formulas and styles
Professional financial modeling with standard color-coding and layout conventions
38 GitHub stars
Visual quality control using rendered images to verify formatting and style
Advanced formula management with automatic recalculation and error validation

사용 사례

Building investment banking-grade DCF or LBO models with automated formatting
Updating complex legacy spreadsheets without breaking existing cell references or styles
Converting raw datasets into structured Excel reports with in-sheet charts and pivot tables

소개

주요 기능

Robust tabular data analysis including aggregation, filtering, and metric computation
Seamless modification of existing workbooks while preserving legacy formulas and styles
Professional financial modeling with standard color-coding and layout conventions
38 GitHub stars
Visual quality control using rendered images to verify formatting and style
Advanced formula management with automatic recalculation and error validation

사용 사례

Building investment banking-grade DCF or LBO models with automated formatting
Updating complex legacy spreadsheets without breaking existing cell references or styles
Converting raw datasets into structured Excel reports with in-sheet charts and pivot tables