Why does it use formulas instead of hardcoded values?

Using Excel formulas ensures the spreadsheet remains dynamic and updateable by human users, allowing the model to recalculate automatically when source data changes.

How does this skill handle formula errors?

It uses a specialized recalculation script and LibreOffice to scan for #REF!, #DIV/0!, and other errors, ensuring every delivered model is functional and error-free.

Can it maintain my existing spreadsheet styles?

Yes, it is programmed to study and match existing formats, styles, and conventions, ensuring that updates to your templates feel native and consistent.

Does it support professional financial modeling standards?

Absolutely. It follows industry-standard conventions such as blue text for hardcoded inputs, black for formulas, and specific formatting for currency, percentages, and multiples.

Excel & Spreadsheet Master

Name: Excel & Spreadsheet Master
Author: nijjaraerp

bynijjaraerp

0•

데이터 과학 및 ML

Automates the creation, editing, and analysis of professional-grade Excel spreadsheets and financial models with dynamic formulas and rigorous verification.

This skill empowers Claude to perform sophisticated spreadsheet operations using Python libraries like pandas and openpyxl. It ensures high-fidelity financial modeling through strict color-coding standards, zero-error formula verification via LibreOffice recalculation, and preservation of existing templates. Whether creating complex projection models from scratch or analyzing massive CSV datasets, this skill provides a robust framework for dynamic, error-free spreadsheet management that maintains full interactivity for end-users.

주요 기능

01High-performance data analysis and visualization using pandas and openpyxl

02Automated formula recalculation and error scanning using LibreOffice integration

030 GitHub stars

04Professional financial modeling with industry-standard color coding and formatting

05Dynamic Excel formula generation to replace hardcoded values

06Template preservation logic to maintain existing styles and conventions

사용 사례

01Building complex financial projection models with dynamic assumptions and growth drivers

02Analyzing and visualizing large datasets from CSV/TSV files into professional Excel reports

03Updating existing corporate spreadsheet templates while maintaining legacy formatting and logic

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nijjaraerp/claude xlsx

For use in Claude.ai and ChatGPT

Download Skill