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

0•

Data Science & ML

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

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.

Key Features

01Seamless data analysis and visualization using the pandas library

020 GitHub stars

03Industry-standard financial modeling with specific color and number formatting

04Advanced template preservation that respects existing styles and conventions

05Dynamic formula construction and automated recalculation via LibreOffice

06Comprehensive error scanning for formula integrity and cell reference accuracy

Use Cases

01Transforming raw datasets into formatted, multi-sheet Excel reports with charts

02Updating existing corporate spreadsheet templates while preserving complex internal formulas

03Building automated financial projection models with dynamic assumptions and scenarios

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add noah-rivard/news-coverage-a24-lionsgate xlsx

For use in Claude.ai and ChatGPT

Download Skill