Does it follow standard financial modeling conventions?

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

Does this skill support dynamic Excel formulas?

Yes, the skill is designed to prioritize Excel formulas over hardcoded values, ensuring that your spreadsheets remain dynamic and recalculate correctly when data changes.

How are formula errors like #REF! prevented?

The suite includes a mandatory recalculation workflow using a LibreOffice-based script that scans the entire workbook for errors after creation or modification.

Can it handle large datasets?

The skill utilizes pandas for high-performance data manipulation and analysis, making it suitable for processing large CSV or Excel files efficiently.

Excel & Spreadsheet Suite

Name: Excel & Spreadsheet Suite
Author: hongbietcode

byhongbietcode

•

생산성 및 워크플로

Creates, analyzes, and manages professional Excel spreadsheets with automated formula validation and industry-standard formatting.

소개

The Excel & Spreadsheet Suite is a comprehensive toolkit that enables Claude to perform high-stakes spreadsheet operations, from automated data analysis to complex financial modeling. It enforces strict professional standards, including industry-standard color-coding for financial inputs and formulas, automated error detection using LibreOffice integration, and smart template preservation. By prioritizing dynamic formulas over hardcoded values and utilizing both pandas and openpyxl, it ensures that generated spreadsheets are accurate, interactive, and production-ready.

주요 기능

Strict preservation of existing workbook templates and style conventions
Dual-engine support using pandas for analysis and openpyxl for styling
Automated formula recalculation and error detection via LibreOffice integration
Industry-standard financial modeling with specific color-coding and number formatting
Dynamic formula generation to ensure spreadsheets remain updateable and interactive
2 GitHub stars

사용 사례

Modifying existing corporate spreadsheet templates while maintaining structural integrity
Building robust financial models with color-coded inputs and formula-driven projections
Automating the cleaning and analysis of large datasets into formatted Excel reports

소개

주요 기능

Strict preservation of existing workbook templates and style conventions
Dual-engine support using pandas for analysis and openpyxl for styling
Automated formula recalculation and error detection via LibreOffice integration
Industry-standard financial modeling with specific color-coding and number formatting
Dynamic formula generation to ensure spreadsheets remain updateable and interactive
2 GitHub stars

사용 사례

Modifying existing corporate spreadsheet templates while maintaining structural integrity
Building robust financial models with color-coded inputs and formula-driven projections
Automating the cleaning and analysis of large datasets into formatted Excel reports