Will it overwrite my existing spreadsheet formatting?

No, the skill is designed to study and match existing formats, styles, and conventions when modifying established templates.

Does this skill support complex Excel formulas?

Yes, it prioritizes dynamic Excel formulas over hardcoded values and includes a verification step to ensure zero formula errors like #REF! or #DIV/0!.

How are formulas recalculated after modification?

The skill uses a specialized recalculation script and LibreOffice to ensure all workbook values are updated and verified for accuracy before delivery.

Can I use this for professional financial models?

Absolutely. The skill follows industry-standard color-coding conventions, such as blue for hardcoded inputs and black for formulas, ensuring model transparency.

Excel & Spreadsheet Automation

Name: Excel & Spreadsheet Automation
Author: Jst-Well-Dan

byJst-Well-Dan

Productividad y Flujo de Trabajo

Automates professional spreadsheet creation, data analysis, and financial modeling with precision formula handling and formatting.

Acerca de

This skill empowers Claude to handle complex spreadsheet tasks ranging from simple data entry to sophisticated financial modeling. It ensures high-quality outputs by enforcing industry-standard color coding, precise number formatting, and mandatory formula verification via LibreOffice recalibration. Whether you are analyzing large datasets with pandas or building dynamic models with openpyxl, this skill maintains data integrity and professional standards across all .xlsx, .xlsm, and CSV files while preserving existing template conventions.

Características Principales

Industry-standard financial modeling with automated color-coding and formatting rules
Advanced formula management with zero-error verification and automatic recalibration
High-performance data analysis and visualization via seamless pandas integration
Comprehensive support for .xlsx, .xlsm, .csv, and .tsv file manipulation
0 GitHub stars
Template preservation that respects and matches existing styles and conventions

Casos de Uso

Cleaning and analyzing large business datasets for executive reporting and insights
Building dynamic financial models with automated projections and scenario analysis
Generating formatted, formula-driven reports from raw data sources automatically

Acerca de

Características Principales

Industry-standard financial modeling with automated color-coding and formatting rules
Advanced formula management with zero-error verification and automatic recalibration
High-performance data analysis and visualization via seamless pandas integration
Comprehensive support for .xlsx, .xlsm, .csv, and .tsv file manipulation
0 GitHub stars
Template preservation that respects and matches existing styles and conventions

Casos de Uso

Cleaning and analyzing large business datasets for executive reporting and insights
Building dynamic financial models with automated projections and scenario analysis
Generating formatted, formula-driven reports from raw data sources automatically