Does this skill support standard financial modeling conventions?

Yes, it follows industry-standard color coding: blue for hardcoded inputs, black for formulas, green for internal links, and red for external links, along with specific currency and multiple formatting.

Will it break my existing Excel templates?

No, the skill is specifically instructed to study and match existing formats, styles, and conventions of any file it modifies, ensuring your organizational templates remain intact.

Can I use it to automate reports from Python data?

Absolutely. It leverages pandas for data processing and openpyxl to write that data into formatted Excel files while preserving or creating dynamic formulas.

How does it ensure formulas are correct?

The skill uses a mandatory recalculation script via LibreOffice that scans for errors like #REF!, #DIV/0!, and #VALUE!, returning a detailed JSON summary for immediate fixing.

Excel & Spreadsheet Power Suite

Name: Excel & Spreadsheet Power Suite
Author: nordeim

bynordeim

데이터 과학 및 ML

Automates complex spreadsheet creation, financial modeling, and data analysis with formula integrity and industry-standard formatting.

소개

The xlsx skill empowers Claude to act as an expert data analyst and financial modeler, capable of building robust Excel workbooks from scratch or modifying existing templates. It enforces strict data integrity by using a dedicated recalculation engine to prevent formula errors and follows professional industry standards for financial modeling, such as specific color coding for inputs and calculations. By integrating Python's pandas and openpyxl libraries, it allows for high-performance data manipulation while maintaining the dynamic nature of spreadsheets through cell-based formulas rather than hardcoded values.

주요 기능

Automated formula recalculation and error detection via LibreOffice integration.
Dual-library support using pandas for data analysis and openpyxl for precision formatting.
Industry-standard financial model formatting including specific color coding and number styles.
Dynamic formula construction to ensure spreadsheets remain updateable and non-static.
Intelligent template preservation that respects and matches existing file conventions.
0 GitHub stars

사용 사례

Building automated, error-free financial projections and valuation models.
Modifying existing corporate spreadsheets while maintaining complex formatting and formula structures.
Performing deep data analysis on large datasets and exporting formatted summary reports.

소개

주요 기능

Automated formula recalculation and error detection via LibreOffice integration.
Dual-library support using pandas for data analysis and openpyxl for precision formatting.
Industry-standard financial model formatting including specific color coding and number styles.
Dynamic formula construction to ensure spreadsheets remain updateable and non-static.
Intelligent template preservation that respects and matches existing file conventions.
0 GitHub stars

사용 사례

Building automated, error-free financial projections and valuation models.
Modifying existing corporate spreadsheets while maintaining complex formatting and formula structures.
Performing deep data analysis on large datasets and exporting formatted summary reports.