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

•

Data Science & 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.

Key Features

012,188 GitHub stars

02Industry-standard financial modeling formatting (color-coded inputs, formulas, and links)

03Comprehensive verification checklist to prevent common spreadsheet errors like #REF! and #DIV/0!

04Dual-library support using pandas for data analysis and openpyxl for complex formatting

05Automated Excel formula generation and recalculation with built-in error detection

06Integration with scientific-schematics for automated data workflow visualization

Use Cases

01Building dynamic financial models with standardized color coding and assumption-based calculations

02Automating large-scale data cleaning and transformation of CSV/XLSX files for scientific reporting

03Generating publication-ready spreadsheets that include both data analysis and descriptive architectural schematics

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add k-dense-ai/claude-scientific-skills xlsx

For use in Claude.ai and ChatGPT

Download Skill