How does it ensure there are no formula errors like #REF! or #DIV/0!?

The skill utilizes a mandatory recalculation script powered by LibreOffice that scans every cell for errors after the file is generated, ensuring a 100% error-free delivery.

Can it work with existing Excel templates?

Yes, it is designed to study and match existing formats, styles, and conventions of your templates, ensuring that any modifications look seamless and professional.

Does this skill support complex Excel formulas?

Yes, it specifically prioritizes using Excel formulas (like SUM, AVERAGE, and growth rates) over hardcoding values to ensure your spreadsheets remain dynamic and interactive.

What file formats are supported?

The skill supports a wide range of spreadsheet formats including .xlsx, .xlsm, .csv, and .tsv files.

Can it follow specific financial formatting standards?

Absolutely. It follows industry conventions like blue text for hardcoded inputs, black for formulas, and specific currency/multiple formats used in investment banking and corporate finance.

Excel & Financial Modeling

Name: Excel & Financial Modeling
Author: dobeutech

bydobeutech

•

データサイエンスとML

Creates and manages professional spreadsheets with dynamic formulas, financial formatting standards, and advanced data analysis capabilities.

概要

This skill equips Claude with a robust toolkit for handling complex spreadsheet tasks, ranging from high-stakes financial modeling to large-scale data analysis. It enforces industry-standard formatting conventions—such as color-coded inputs and specific currency styles—while prioritizing dynamic Excel formulas over hardcoded values to ensure workbooks remain updateable. By leveraging pandas for data manipulation and openpyxl for precise formatting, combined with a LibreOffice-powered recalculation engine, it delivers error-free, production-ready spreadsheets that meet professional business requirements.

主な機能

Industry-standard financial formatting including color-coded inputs and custom number styles
Dynamic formula construction to prevent hardcoded calculation errors
Support for reading, modifying, and preserving existing workbook templates and styles
Automated formula recalculation and error verification via LibreOffice integration
1 GitHub stars
Comprehensive data analysis and visualization using the pandas library

ユースケース

Building dynamic financial projections, valuation models, and 3-statement models from scratch
Automating the cleanup and analysis of large CSV or Excel datasets for business reporting
Updating existing corporate templates with new data while maintaining strict formatting rules

概要

主な機能

Industry-standard financial formatting including color-coded inputs and custom number styles
Dynamic formula construction to prevent hardcoded calculation errors
Support for reading, modifying, and preserving existing workbook templates and styles
Automated formula recalculation and error verification via LibreOffice integration
1 GitHub stars
Comprehensive data analysis and visualization using the pandas library

ユースケース

Building dynamic financial projections, valuation models, and 3-statement models from scratch
Automating the cleanup and analysis of large CSV or Excel datasets for business reporting
Updating existing corporate templates with new data while maintaining strict formatting rules