Does this skill support live Excel formulas?

Yes, it specifically prioritizes using Excel formulas (like SUM or AVERAGE) over hardcoded values to ensure the spreadsheet remains dynamic and recalculates correctly when data changes.

How does the skill ensure there are no formula errors?

The skill utilizes a mandatory recalculation script (recalc.py) that runs through LibreOffice to verify all formulas and catch errors like #REF! or #DIV/0! before finishing the task.

Can it follow specific financial modeling standards?

Absolutely. It follows industry-standard conventions such as blue text for hardcoded inputs, black for formulas, and yellow backgrounds for key assumptions.

Will it overwrite my existing spreadsheet formatting?

No. The skill is designed to study and exactly match your existing templates, styles, and conventions unless you specifically request a change.

XLSX Master

Name: XLSX Master
Author: Within-7

byWithin-7

Ciencia de Datos y ML

Automates professional spreadsheet creation, data analysis, and financial modeling with dynamic formulas and industry-standard formatting.

Acerca de

This skill empowers Claude to perform advanced spreadsheet engineering, enabling the creation, modification, and analysis of complex .xlsx and .csv files. It goes beyond simple data entry by implementing dynamic Excel formulas, preserving existing template styles, and adhering to strict financial modeling standards like color-coded cell conventions. With integrated support for pandas and openpyxl, plus a dedicated recalculation engine, it ensures that every spreadsheet delivered is functionally accurate, professionally formatted, and free of formula errors.

Características Principales

Automated formula recalculation and error detection via LibreOffice integration
0 GitHub stars
Template preservation to maintain existing styles, conventions, and formatting
Professional financial modeling standards including industry-standard color coding
Dynamic Excel formula generation to avoid hardcoded calculation values
Deep data analysis and visualization using pandas and openpyxl

Casos de Uso

Building automated financial models with projected growth and scenario analysis
Updating existing corporate templates with new data while preserving complex formatting
Performing bulk data analysis and generating visual reports directly in Excel format

Acerca de

Características Principales

Automated formula recalculation and error detection via LibreOffice integration
0 GitHub stars
Template preservation to maintain existing styles, conventions, and formatting
Professional financial modeling standards including industry-standard color coding
Dynamic Excel formula generation to avoid hardcoded calculation values
Deep data analysis and visualization using pandas and openpyxl

Casos de Uso

Building automated financial models with projected growth and scenario analysis
Updating existing corporate templates with new data while preserving complex formatting
Performing bulk data analysis and generating visual reports directly in Excel format