Can this skill recalculate formulas without opening Excel?

Yes, the skill utilizes a recalc.py script and LibreOffice to programmatically recalculate all formulas and verify results within the spreadsheet.

How does it handle formula errors like #DIV/0! or #REF!?

The skill includes a mandatory verification step that scans all cells for Excel errors after calculation, providing a detailed summary to fix issues before the file is finalized.

Can I modify existing Excel templates without breaking them?

Absolutely. The skill is designed to study and match existing formats and styles, ensuring that template conventions are preserved when data is modified.

Does it support professional financial modeling standards?

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

Advanced Excel & Spreadsheet Automation

Name: Advanced Excel & Spreadsheet Automation
Author: claudiodearaujo

byclaudiodearaujo

•

Data Science & ML

Creates, edits, and analyzes complex Excel spreadsheets with support for dynamic formulas, financial modeling standards, and automated data visualization.

This skill empowers Claude to handle professional-grade spreadsheet tasks, ranging from simple CSV data exports to intricate financial models. It ensures formula integrity by leveraging LibreOffice for recalculation and enforces industry-standard formatting, such as color-coded inputs and specific number formats. By combining pandas for robust data manipulation and openpyxl for precise cell-level formatting, it allows for the creation of dynamic, error-free .xlsx files that preserve existing templates and follow strict documentation requirements for hardcoded values.

Key Features

01High-performance data analysis and visualization using pandas integration

021 GitHub stars

03Comprehensive error detection for common Excel issues like #REF! and #DIV/0!

04Dynamic formula insertion and verification using automated recalculation scripts

05Template preservation that matches existing styles, formatting, and conventions

06Professional financial modeling standards including industry-specific color coding

Use Cases

01Updating existing corporate spreadsheet templates while maintaining original styles and formulas

02Building automated financial models with dynamic projections and standardized formatting

03Converting and cleaning large datasets from CSV/TSV into formatted Excel reports

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add claudiodearaujo/sistema-de-narra-o-de-livro xlsx-official

For use in Claude.ai and ChatGPT

Download Skill