Can I use this for professional financial modeling?

Absolutely. It follows industry-standard color conventions (Blue for inputs, Green for links, Black for formulas) and includes specific rules for currency, multiples, and percentage formatting.

What Python libraries does this skill utilize?

It leverages pandas for data-heavy analysis and openpyxl for tasks requiring complex formatting, formulas, and specific Excel features.

How does it handle formula calculations?

It uses a dedicated recalculation script (recalc.py) powered by LibreOffice to ensure all formulas are evaluated and the final file contains no errors like #REF! or #DIV/0!.

Does it prevent common spreadsheet errors?

Yes, it includes a verification checklist and automated scanning to identify and fix invalid references, division by zero, and data type mismatches.

Does this skill support existing Excel templates?

Yes, the skill is specifically designed to study and match existing formats, styles, and conventions when modifying files with established patterns.

Advanced Excel & Spreadsheet Manager

Name: Advanced Excel & Spreadsheet Manager
Author: lngyneric

bylngyneric

0•

Data Science & ML

Automates the creation, editing, and analysis of complex Excel spreadsheets with support for dynamic formulas and financial modeling standards.

This skill empowers Claude to handle sophisticated spreadsheet tasks, ranging from high-performance data analysis with pandas to intricate financial modeling using openpyxl. It ensures spreadsheet integrity by prioritizing dynamic formula-based calculations over hardcoded values and includes a dedicated recalculation engine to maintain data accuracy across all sheets. Whether you are generating professional-grade financial reports, updating existing templates while preserving styles, or performing deep data audits, this tool provides the necessary guardrails and formatting standards to deliver production-ready Excel files.

Key Features

01Comprehensive data analysis and visualization using the pandas library

02Dynamic formula generation to ensure spreadsheets remain updateable and interactive

03Automated formula recalculation and error detection using LibreOffice integration

040 GitHub stars

05Industry-standard financial modeling color-coding (Blue for inputs, Black for formulas)

06Smart template preservation that respects existing styles and conventions

Use Cases

01Generating automated monthly financial models with standardized formatting and error-checking

02Migrating and transforming data into existing corporate Excel templates without breaking styles

03Performing bulk data analysis on CSV/XLSX files and exporting results into formatted reports

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add lngyneric/my-notebook-github xlsx

For use in Claude.ai and ChatGPT

Download Skill