How does it handle formula errors like #REF! or #DIV/0!?

The skill utilizes a mandatory recalculation script (recalc.py) that runs the file through LibreOffice to verify all calculations and catch errors before delivery.

Will it overwrite my existing spreadsheet formatting?

No. The skill is instructed to study and exactly match existing styles and conventions when modifying templates to preserve your established patterns.

Can it follow specific financial modeling standards?

Absolutely. It follows industry standards such as blue text for hardcoded inputs, black for formulas, and green for internal links, ensuring professional-grade financial files.

Does this skill support native Excel formulas?

Yes, it specifically prioritizes using Excel formulas over hardcoding values to ensure spreadsheets remain dynamic and interactive for the user.

What file types are supported?

It supports comprehensive operations for .xlsx, .xlsm, .csv, and .tsv files.

XLSX & Spreadsheet Master

Name: XLSX & Spreadsheet Master
Author: Cam10001110101

byCam10001110101

•

생산성 및 워크플로

Automates professional-grade spreadsheet creation, financial modeling, and data analysis with zero-error formula verification.

소개

The XLSX & Spreadsheet Master skill transforms Claude into a powerful Excel automation engine capable of handling complex workbooks with professional precision. It goes beyond simple data entry by enforcing industry-standard financial modeling conventions, such as specific color coding for inputs and formulas, and ensuring every file is delivered without calculation errors. By combining pandas for data manipulation and openpyxl for granular formatting, it allows Claude to generate dynamic, formula-driven spreadsheets that remain fully functional and updateable by end-users.

주요 기능

Preservation of existing workbook templates, styles, and conventions
Industry-standard financial model color coding (Blue for inputs, Black for formulas)
Support for multiple formats including .xlsx, .xlsm, .csv, and .tsv
Automated formula recalculation and error detection via LibreOffice integration
Dynamic formula-driven spreadsheet creation using openpyxl and pandas
1 GitHub stars

사용 사례

Building robust financial projection models with automated data sourcing
Auditing and fixing broken formulas in existing complex spreadsheets
Transforming raw data sets into formatted, executive-ready Excel reports

소개

주요 기능

Preservation of existing workbook templates, styles, and conventions
Industry-standard financial model color coding (Blue for inputs, Black for formulas)
Support for multiple formats including .xlsx, .xlsm, .csv, and .tsv
Automated formula recalculation and error detection via LibreOffice integration
Dynamic formula-driven spreadsheet creation using openpyxl and pandas
1 GitHub stars

사용 사례

Building robust financial projection models with automated data sourcing
Auditing and fixing broken formulas in existing complex spreadsheets
Transforming raw data sets into formatted, executive-ready Excel reports