Does it follow standard financial modeling conventions?

Yes, it adheres to industry standards such as blue text for hardcoded inputs, black for formulas, and green for internal links, while ensuring currencies and multiples are formatted correctly.

How are formula errors prevented?

The skill employs a mandatory verification checklist and an automated 'recalc.py' script that scans for errors like #REF!, #DIV/0!, and #VALUE!, providing a detailed report for immediate fixing.

Can I use this to modify existing Excel templates?

Absolutely. The skill is designed to load existing workbooks, study their formatting, and match established styles to ensure updates are seamless and consistent.

How does this skill handle Excel formulas?

It uses openpyxl to write formulas as strings and a specialized recalculation script powered by LibreOffice to ensure all values are calculated correctly, avoiding the pitfall of hardcoded values.

What libraries does this skill use for data processing?

It primarily uses pandas for high-performance data manipulation and analysis, and openpyxl for tasks requiring specific Excel formatting, styles, and formula preservation.

Advanced Excel & Spreadsheet Management

Name: Advanced Excel & Spreadsheet Management
Author: rysweet

byrysweet

データサイエンスとML

Automates the creation, editing, and analysis of professional Excel spreadsheets with advanced formula support and industry-standard financial modeling conventions.

概要

This skill empowers Claude to handle complex spreadsheet tasks, ranging from simple CSV manipulation to the construction of sophisticated, production-grade financial models. It ensures data integrity by enforcing a zero-formula-error policy and following strict industry standards for color coding, number formatting, and documentation. By leveraging pandas for data analysis and openpyxl for granular formatting, the skill allows for the programmatic generation of dynamic, formula-driven workbooks that remain fully functional and editable for end-users.

主な機能

Rigorous error detection for common Excel issues like #REF! and #DIV/0!
Dynamic formula generation with automated recalculation via LibreOffice integration
Template preservation that maintains existing styles and conventions during updates
Professional financial modeling with standardized color coding and number formatting
Advanced data analysis and visualization using pandas and openpyxl
0 GitHub stars

ユースケース

Performing complex data analysis on large datasets and exporting formatted XLSX summaries
Updating existing corporate spreadsheet templates while preserving historical formulas and formatting
Generating automated financial reports with dynamic projections and valuation multiples

概要

主な機能

Rigorous error detection for common Excel issues like #REF! and #DIV/0!
Dynamic formula generation with automated recalculation via LibreOffice integration
Template preservation that maintains existing styles and conventions during updates
Professional financial modeling with standardized color coding and number formatting
Advanced data analysis and visualization using pandas and openpyxl
0 GitHub stars

ユースケース

Performing complex data analysis on large datasets and exporting formatted XLSX summaries
Updating existing corporate spreadsheet templates while preserving historical formulas and formatting
Generating automated financial reports with dynamic projections and valuation multiples