Does it support financial modeling standards?

Yes, it follows industry-standard conventions such as blue text for hardcoded inputs, black for formulas, and specific formatting for currencies, multiples, and percentages.

How does it handle complex Excel formulas?

It uses openpyxl to write formulas as strings and employs a mandatory recalculation step using LibreOffice to ensure all values are correctly updated and error-free.

Can this skill modify existing Excel templates without breaking them?

Yes, the skill is specifically designed to study and match existing formats, styles, and conventions, ensuring that template-specific patterns are preserved during updates.

What file formats are supported?

The skill supports a wide range of spreadsheet formats including .xlsx, .xlsm, .csv, and .tsv.

How are formula errors prevented?

Every model is verified using a recalculation script that returns a JSON summary of any #REF!, #DIV/0!, or #VALUE! errors, allowing for immediate correction.

Advanced XLSX Spreadsheet Manager

Name: Advanced XLSX Spreadsheet Manager
Author: noah-rivard

bynoah-rivard

Ciencia de Datos y ML

Creates, edits, and analyzes sophisticated Excel workbooks with a focus on dynamic formulas, financial modeling standards, and automated recalculation.

Acerca de

The XLSX skill empowers Claude to perform professional-grade spreadsheet engineering, ranging from high-speed data analysis with pandas to the construction of complex financial models. It enforces strict industry standards for color-coding (blue for inputs, black for formulas) and ensures all outputs are dynamic by prioritizing Excel formulas over hardcoded values. With integrated support for LibreOffice-based recalculation, it identifies and fixes common spreadsheet errors like #REF! or #DIV/0! before delivery, making it an essential tool for automated reporting and data management.

Características Principales

Seamless data analysis and visualization using the pandas library
0 GitHub stars
Industry-standard financial modeling with specific color and number formatting
Advanced template preservation that respects existing styles and conventions
Dynamic formula construction and automated recalculation via LibreOffice
Comprehensive error scanning for formula integrity and cell reference accuracy

Casos de Uso

Transforming raw datasets into formatted, multi-sheet Excel reports with charts
Updating existing corporate spreadsheet templates while preserving complex internal formulas
Building automated financial projection models with dynamic assumptions and scenarios

Acerca de

Características Principales

Seamless data analysis and visualization using the pandas library
0 GitHub stars
Industry-standard financial modeling with specific color and number formatting
Advanced template preservation that respects existing styles and conventions
Dynamic formula construction and automated recalculation via LibreOffice
Comprehensive error scanning for formula integrity and cell reference accuracy

Casos de Uso

Transforming raw datasets into formatted, multi-sheet Excel reports with charts
Updating existing corporate spreadsheet templates while preserving complex internal formulas
Building automated financial projection models with dynamic assumptions and scenarios