How does this skill handle formula errors?

The skill includes a mandatory verification step using a recalculation script that scans all cells for common Excel errors like #REF!, #DIV/0!, and #VALUE! before the file is finalized.

Which Python libraries are used for spreadsheet processing?

It leverages pandas for high-performance data manipulation and openpyxl for preserving complex formatting, styles, and Excel-specific formulas.

Can I use this for professional financial modeling?

Yes, it is pre-configured with industry-standard conventions such as blue text for hardcoded inputs, black for formulas, and green for internal worksheet links.

Does it support formula recalculation outside of Excel?

Yes, it utilizes a background LibreOffice process through a specialized script to ensure all formulas are fully evaluated and results are accurate even if the file isn't opened in Excel immediately.

Excel & Spreadsheet Scientific Toolkit

Name: Excel & Spreadsheet Scientific Toolkit
Author: K-Dense-AI

byK-Dense-AI

•

2,188

データサイエンスとML

Creates, edits, and analyzes Excel spreadsheets with production-grade formulas, industry-standard financial formatting, and automated recalculation.

概要

This skill empowers Claude to handle complex spreadsheet tasks using Python libraries like pandas and openpyxl. It provides a robust framework for generating error-free Excel models, particularly in financial and scientific contexts. Key capabilities include enforcing industry-standard color coding (e.g., blue for inputs, black for formulas), managing complex cell references without hardcoding values, and integrating scientific schematics directly into workbooks. It includes a mandatory recalculation step via LibreOffice to ensure all formulas are evaluated and validated before final delivery, making it ideal for publication-quality data processing.

主な機能

2,188 GitHub stars
Industry-standard financial modeling formatting (color-coded inputs, formulas, and links)
Comprehensive verification checklist to prevent common spreadsheet errors like #REF! and #DIV/0!
Dual-library support using pandas for data analysis and openpyxl for complex formatting
Automated Excel formula generation and recalculation with built-in error detection
Integration with scientific-schematics for automated data workflow visualization

ユースケース

Building dynamic financial models with standardized color coding and assumption-based calculations
Automating large-scale data cleaning and transformation of CSV/XLSX files for scientific reporting
Generating publication-ready spreadsheets that include both data analysis and descriptive architectural schematics

概要

主な機能

2,188 GitHub stars
Industry-standard financial modeling formatting (color-coded inputs, formulas, and links)
Comprehensive verification checklist to prevent common spreadsheet errors like #REF! and #DIV/0!
Dual-library support using pandas for data analysis and openpyxl for complex formatting
Automated Excel formula generation and recalculation with built-in error detection
Integration with scientific-schematics for automated data workflow visualization

ユースケース

Building dynamic financial models with standardized color coding and assumption-based calculations
Automating large-scale data cleaning and transformation of CSV/XLSX files for scientific reporting
Generating publication-ready spreadsheets that include both data analysis and descriptive architectural schematics