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

•

Productivity & Workflow

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.

Key Features

01Strict preservation of existing workbook templates and style conventions

02Dual-engine support using pandas for analysis and openpyxl for styling

03Automated formula recalculation and error detection via LibreOffice integration

04Industry-standard financial modeling with specific color-coding and number formatting

05Dynamic formula generation to ensure spreadsheets remain updateable and interactive

062 GitHub stars

Use Cases

01Modifying existing corporate spreadsheet templates while maintaining structural integrity

02Building robust financial models with color-coded inputs and formula-driven projections

03Automating the cleaning and analysis of large datasets into formatted Excel reports

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add hongbietcode/synthetic-claude xlsx

For use in Claude.ai and ChatGPT

Download Skill