Does this skill support existing Excel templates?

Yes, the skill is specifically designed to study and exactly match existing formats, styles, and conventions when modifying files to ensure template consistency.

Can it create professional financial models?

Absolutely. It follows industry standards for financial modeling, including blue text for hardcoded inputs and black text for formulas, while ensuring all assumptions are clearly documented.

How does it handle formula errors like #REF! or #DIV/0!?

The skill utilizes a mandatory recalculation script that scans all cells for errors and returns a detailed summary, allowing the AI to fix issues before the file is finalized.

Why does it use formulas instead of hardcoded values?

Using formulas ensures the spreadsheet remains dynamic, allowing users to update input values and see live changes in the results without needing to re-run any code.

Advanced Excel & Spreadsheet Manager

Name: Advanced Excel & Spreadsheet Manager
Author: rysweet

byrysweet

•

数据科学与机器学习

Automates complex spreadsheet creation, editing, and financial modeling with dynamic formulas and industry-standard formatting.

The xlsx skill enables Claude to function as a professional data analyst by creating, modifying, and analyzing Excel workbooks with high precision. It goes beyond simple data entry by enforcing strict financial modeling standards, such as specific color-coding for inputs and formulas, and ensuring zero formula errors through an automated recalculation engine. By combining the data processing power of pandas with the structural control of openpyxl, this skill allows for the generation of dynamic, production-ready spreadsheets that preserve existing templates and provide documented audit trails for all hardcoded data sources.

主要功能

01Automated formula recalculation and error detection using LibreOffice integration.

02Dynamic formula generation to ensure spreadsheets remain interactive and updateable.

03Comprehensive support for .xlsx, .xlsm, .csv, and .tsv formats.

04Strict adherence to industry-standard financial modeling styles and color-coding.

0516 GitHub stars

06Template preservation that matches existing styles, conventions, and formatting.

使用场景

01Generating automated financial reports with complex projections and scenario analysis.

02Batch updating enterprise spreadsheet templates while maintaining formatting integrity.

03Performing deep data analysis with pandas and exporting the results into formatted Excel dashboards.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add rysweet/amplihack xlsx

For use in Claude.ai and ChatGPT

Download Skill