Can I use this for professional financial modeling?

Absolutely. It follows strict industry standards, including blue-text for hardcoded inputs, black-text for formulas, and specific currency and percentage formatting.

What libraries are used for spreadsheet processing?

It primarily uses pandas for heavy data analysis and openpyxl for preserving complex formatting, formulas, and multi-sheet workbooks.

Can it detect formula errors like #REF! or #DIV/0!?

Yes, it runs a verification checklist after recalculation to identify and fix common Excel errors, ensuring publication-quality outputs.

Does this skill support automatic formula calculation?

Yes, it includes a mandatory recalculation step using a LibreOffice-powered script to ensure all formulas are evaluated and error-free before the file is finalized.

How does it handle existing Excel templates?

The skill is designed to match existing formats, styles, and conventions when modifying files, ensuring that template-specific patterns always override general guidelines.

Excel & Data Analysis Toolkit

Name: Excel & Data Analysis Toolkit
Author: Weiwei-Mao

byWeiwei-Mao

0•

데이터 과학 및 ML

Creates, edits, and analyzes Excel spreadsheets with professional formatting, automated formula recalculation, and integrated data visualization.

This skill empowers Claude to handle complex Excel workflows, ranging from basic CSV manipulation to building production-grade financial models. It combines the power of pandas for high-performance data analysis with openpyxl for granular formatting and formula management. A unique feature is its mandatory formula recalculation engine, which uses LibreOffice to ensure every spreadsheet is delivered with zero errors and fully updated values. It strictly adheres to industry-standard financial modeling conventions and can even generate scientific schematics to visually represent complex data processing pipelines or model architectures.

주요 기능

01Professional financial modeling with industry-standard color coding and formatting rules

02Automated formula recalculation and error verification using LibreOffice integration

03Template preservation logic to maintain existing file styles and conventions

040 GitHub stars

05High-performance data manipulation and analysis using pandas and openpyxl

06Integrated scientific schematic generation for complex workflow visualization

사용 사례

01Automating the cleaning, analysis, and reporting of large datasets from CSV or XLSX sources

02Creating publication-quality spreadsheets with embedded diagrams for scientific or technical documentation

03Building dynamic financial models with automated growth projections and assumption-driven formulas

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add weiwei-mao/hydrology-skills xlsx

For use in Claude.ai and ChatGPT

Download Skill