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

Ciencia de Datos y ML

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

Acerca de

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.

Características Principales

Professional financial modeling with industry-standard color coding and formatting rules
Automated formula recalculation and error verification using LibreOffice integration
Template preservation logic to maintain existing file styles and conventions
0 GitHub stars
High-performance data manipulation and analysis using pandas and openpyxl
Integrated scientific schematic generation for complex workflow visualization

Casos de Uso

Automating the cleaning, analysis, and reporting of large datasets from CSV or XLSX sources
Creating publication-quality spreadsheets with embedded diagrams for scientific or technical documentation
Building dynamic financial models with automated growth projections and assumption-driven formulas

Acerca de

Características Principales

Professional financial modeling with industry-standard color coding and formatting rules
Automated formula recalculation and error verification using LibreOffice integration
Template preservation logic to maintain existing file styles and conventions
0 GitHub stars
High-performance data manipulation and analysis using pandas and openpyxl
Integrated scientific schematic generation for complex workflow visualization

Casos de Uso

Automating the cleaning, analysis, and reporting of large datasets from CSV or XLSX sources
Creating publication-quality spreadsheets with embedded diagrams for scientific or technical documentation
Building dynamic financial models with automated growth projections and assumption-driven formulas