Can it create professional financial models?

Yes. It follows industry standards such as blue text for hardcoded inputs, black for formulas, and green for internal links, ensuring models are audit-ready and professional.

Does it support automated formula updates?

Absolutely. It prioritizes using Excel formulas over hardcoded Python results, ensuring that the spreadsheet remains dynamic and updates automatically when values are changed by the user.

Which Python libraries are used for spreadsheet tasks?

It uses pandas for heavy data analysis and bulk operations, while openpyxl is utilized for complex formatting, cell styling, and preserving existing workbook formulas.

How does this skill handle Excel formula errors?

The skill includes a mandatory verification step using a recalculation script that scans for errors like #REF!, #DIV/0!, and #NAME?. It reports these in a structured JSON format so they can be fixed before delivery.

Advanced Excel & Spreadsheet Manager

Name: Advanced Excel & Spreadsheet Manager
Author: yusoofsh

byyusoofsh

データサイエンスとML

Manages complex Excel workbooks with automated formula recalculation, professional financial modeling standards, and deep data analysis capabilities.

概要

This skill empowers Claude to handle sophisticated spreadsheet tasks, ranging from data analysis with pandas to complex financial modeling using openpyxl. It enforces industry-standard formatting, such as color-coded inputs and formula-driven cells, and ensures spreadsheet integrity through an automated LibreOffice recalculation engine that detects and reports formula errors. Whether you are building investor-ready financial models, cleaning CSV data, or generating reports with specific styling, this skill provides a robust framework for reliable, production-grade spreadsheet engineering.

主な機能

Dynamic formula construction to prevent hardcoded values and maintain spreadsheet logic
Comprehensive support for .xlsx, .xlsm, .csv, and .tsv formats with template preservation
0 GitHub stars
Seamless integration between Python data processing (pandas) and Excel manipulation (openpyxl)
Automated formula recalculation and error detection using LibreOffice integration
Professional financial modeling standards including industry-standard color-coding and formatting

ユースケース

Building investor-ready financial models with standardized assumptions and automated projections
Auditing and repairing broken spreadsheets by identifying and fixing #REF!, #DIV/0!, and #VALUE! errors
Automating the generation of complex monthly reports from raw data while maintaining live calculation logic

概要

主な機能

Dynamic formula construction to prevent hardcoded values and maintain spreadsheet logic
Comprehensive support for .xlsx, .xlsm, .csv, and .tsv formats with template preservation
0 GitHub stars
Seamless integration between Python data processing (pandas) and Excel manipulation (openpyxl)
Automated formula recalculation and error detection using LibreOffice integration
Professional financial modeling standards including industry-standard color-coding and formatting

ユースケース

Building investor-ready financial models with standardized assumptions and automated projections
Auditing and repairing broken spreadsheets by identifying and fixing #REF!, #DIV/0!, and #VALUE! errors
Automating the generation of complex monthly reports from raw data while maintaining live calculation logic