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

데이터 과학 및 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.

주요 기능

High-performance data analysis and visualization using pandas and openpyxl
Automated formula recalculation and error scanning using LibreOffice integration
0 GitHub stars
Professional financial modeling with industry-standard color coding and formatting
Dynamic Excel formula generation to replace hardcoded values
Template preservation logic to maintain existing styles and conventions

사용 사례

Building complex financial projection models with dynamic assumptions and growth drivers
Analyzing and visualizing large datasets from CSV/TSV files into professional Excel reports
Updating existing corporate spreadsheet templates while maintaining legacy formatting and logic

소개

주요 기능

High-performance data analysis and visualization using pandas and openpyxl
Automated formula recalculation and error scanning using LibreOffice integration
0 GitHub stars
Professional financial modeling with industry-standard color coding and formatting
Dynamic Excel formula generation to replace hardcoded values
Template preservation logic to maintain existing styles and conventions

사용 사례

Building complex financial projection models with dynamic assumptions and growth drivers
Analyzing and visualizing large datasets from CSV/TSV files into professional Excel reports
Updating existing corporate spreadsheet templates while maintaining legacy formatting and logic