Can this skill handle complex Excel formulas?

Yes, it uses openpyxl to write formulas as strings and a specialized recalculation script to ensure all calculations are accurate and error-free.

How does it ensure there are no errors in the spreadsheet?

It utilizes a verification workflow that scans for errors like #REF! or #DIV/0! and uses a LibreOffice-based engine for full formula recalculation before saving.

Can I use it to modify my existing Excel templates?

Yes, the skill is designed to analyze and match existing styles, formats, and conventions to preserve the integrity and look of your established workbooks.

Does it support industry-standard financial formatting?

Absolutely. The skill includes specific rules for color-coding inputs, formulas, and links, as well as standard currency and percentage formatting used in investment banking.

Excel & Spreadsheet Scientific Toolkit

Name: Excel & Spreadsheet Scientific Toolkit
Author: jimmc414

byjimmc414

•

324

•

データサイエンスとML

Empowers Claude to create, analyze, and format professional Excel spreadsheets and financial models with automated formula recalculation.

The xlsx skill integrates advanced spreadsheet processing capabilities into Claude, enabling the generation of production-grade Excel files and financial models. It leverages pandas for data manipulation and openpyxl for precise formatting and formula management, ensuring that spreadsheets remain dynamic rather than static. A key feature is its integration with a recalculation engine that uses LibreOffice to verify formula integrity, eliminating common errors like #REF! or #DIV/0!. This toolkit is ideal for researchers, financial analysts, and developers who need to automate the creation of complex, styled, and error-free workbooks directly within their AI-driven workflows.

主な機能

01Industry-standard financial modeling color-coding and number formatting

02Dynamic spreadsheet creation using formulas instead of hardcoded values

03Automated formula recalculation using LibreOffice for zero-error delivery

04324 GitHub stars

05Deep integration with pandas for complex data analysis and visualization

06Template preservation that matches existing styles and conventions

ユースケース

01Building dynamic financial models with standardized assumptions and projections

02Updating existing corporate report templates while maintaining formula integrity

03Automating scientific data analysis and exporting formatted research results

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jimmc414/kosmos xlsx

For use in Claude.ai and ChatGPT

Download Skill