Why does it use a recalculation script?

Since libraries like openpyxl save formulas as strings, the included recalc.py script uses LibreOffice to evaluate those formulas so the file is ready for use immediately upon opening.

How does this skill handle Excel formula errors?

The skill includes a mandatory verification step using a recalculation script that scans for errors like #REF!, #DIV/0!, and #VALUE!, ensuring models are delivered with zero formula errors.

Does it follow standard financial modeling practices?

Yes, it defaults to industry standards: blue text for hardcoded inputs, black for formulas, and green for internal links, ensuring professional compatibility.

Can it modify my existing corporate templates?

The skill is specifically programmed to study and match existing formats, styles, and conventions, ensuring any modifications blend perfectly with your established patterns.

Does it support large dataset analysis?

Yes, it utilizes the pandas library for efficient data analysis, statistics, and bulk operations before applying formatting with openpyxl.

Excel & Spreadsheet Power Suite

Name: Excel & Spreadsheet Power Suite
Author: Activer007

byActiver007

Data Science & ML

Automates the creation, editing, and analysis of professional Excel spreadsheets with advanced formula support and financial modeling standards.

About

This skill empowers Claude to act as a professional financial analyst and data scientist by providing tools for sophisticated spreadsheet manipulation. It handles everything from simple CSV conversions to complex multi-sheet financial models while ensuring formula integrity through automated recalculation via LibreOffice. By enforcing industry-standard formatting and color-coding conventions, it produces production-ready workbooks that maintain dynamic functionality and analytical precision without the risks of hardcoded values or broken references.

Key Features

Advanced data manipulation and visualization using combined pandas and openpyxl workflows
0 GitHub stars
Industry-standard financial modeling formatting and color-coding (Blue/Black/Green/Red conventions)
Automated formula recalculation and error validation using LibreOffice integration
Smart preservation of existing spreadsheet templates, styles, and formatting patterns
Dynamic formula construction to ensure spreadsheets remain updateable and error-free

Use Cases

Building professional-grade financial models with dynamic projections and automated scenario analysis
Automating the cleaning, transformation, and analysis of large datasets from CSV or XLSX sources
Modifying legacy corporate spreadsheets while strictly maintaining established formatting and formula logic

About

Key Features

Advanced data manipulation and visualization using combined pandas and openpyxl workflows
0 GitHub stars
Industry-standard financial modeling formatting and color-coding (Blue/Black/Green/Red conventions)
Automated formula recalculation and error validation using LibreOffice integration
Smart preservation of existing spreadsheet templates, styles, and formatting patterns
Dynamic formula construction to ensure spreadsheets remain updateable and error-free

Use Cases

Building professional-grade financial models with dynamic projections and automated scenario analysis
Automating the cleaning, transformation, and analysis of large datasets from CSV or XLSX sources
Modifying legacy corporate spreadsheets while strictly maintaining established formatting and formula logic