Excel & Spreadsheet Management

소개

Empowers Claude to perform sophisticated spreadsheet operations including the creation of dynamic financial models, data analysis with pandas, and complex formatting using openpyxl. It prioritizes formula-driven logic over hardcoding to ensure spreadsheets remain updateable, incorporates a mandatory recalculation and error-checking workflow via LibreOffice, and strictly follows industry-standard conventions for color-coding, number formatting, and documentation of assumptions. This skill is essential for maintaining data integrity and professional standards in automated spreadsheet workflows.

주요 기능

• Advanced data manipulation and visualization using pandas and openpyxl
• 1 GitHub stars
• Industry-standard financial modeling formatting and color-coding conventions
• Dynamic formula generation to ensure spreadsheets remain updateable
• Template-aware editing that preserves existing styles and organizational logic
• Automated formula recalculation and error detection via LibreOffice integration

사용 사례

• Building production-grade financial models with automated projections and scenario analysis
• Automating data cleaning and analysis within existing corporate Excel templates
• Verifying spreadsheet integrity by programmatically identifying and fixing formula errors