Can I use it with existing Excel templates?

Yes, the skill is designed to study and match existing styles and conventions when modifying established files to ensure consistency.

How does it prevent formula errors?

It features a mandatory verification step using a recalculation script that scans for common Excel errors like #REF!, #DIV/0!, and #VALUE! before finalizing the file.

Can this skill handle complex Excel formulas?

Yes, the skill uses openpyxl to write formulas as strings and includes a dedicated script to recalculate them via LibreOffice to ensure accuracy and functionality.

Does it support industry-standard financial formatting?

Absolutely. It follows strict color-coding conventions—such as blue for inputs and black for formulas—and specific number formatting rules used in professional finance.

Scientific Excel & Data Toolkit

Name: Scientific Excel & Data Toolkit
Author: Zehong-Wang

byZehong-Wang

0•

数据科学与机器学习

Automates the creation, editing, and analysis of professional-grade Excel spreadsheets with dynamic formulas and industry-standard formatting.

This skill empowers Claude to handle complex spreadsheet tasks using Python libraries like pandas and openpyxl. It goes beyond simple data entry by enforcing rigorous financial modeling standards, including specific color-coding conventions and error-free formula construction. It features a mandatory recalculation workflow using LibreOffice to ensure all spreadsheets are publication-ready and functionally dynamic, making it ideal for financial analysts, data scientists, and researchers who require precise, automated Excel outputs.

主要功能

01Advanced data analysis and visualization capabilities

02Industry-standard financial modeling formatting and color-coding

03Automated formula recalculation and error detection via LibreOffice

04Dynamic Excel creation and editing using openpyxl and pandas

05Strict validation to ensure zero formula errors like #REF! or #DIV/0!

060 GitHub stars

使用场景

01Building automated financial models with dynamic projections and scenario analysis

02Updating existing Excel templates while preserving complex formatting and styles

03Cleaning and analyzing large scientific datasets for publication-quality reports

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add zehong-wang/kosmos xlsx

For use in Claude.ai and ChatGPT

Download Skill