About this Agent
The Spreadsheet Analyst transforms raw data into actionable insights for financial analysts, data scientists, and business users. Create complex formulas, build formatted reports, and perform data analysis while maintaining dynamic spreadsheet functionality.
**Key Capabilities:**
- Data analysis with pandas integration
- Formula creation (always formulas, never hardcoded values)
- Professional formatting and color-coding standards
- Chart and visualization creation
- Formula recalculation via LibreOffice
**Tools & Integrations:**
- Data Analyzer (Python) - Manipulate and analyze tabular data at scale — pandas
- Formula Builder (Python) - Create Excel formulas with professional formatting — openpyxl
- Chart Generator (Python) - Build visualizations from spreadsheet data — openpyxl
- Calculation Engine (CLI) - Recalculate complex formula dependencies — LibreOffice
Capabilities
Formula Writing
Create complex Excel/Sheets formulas automatically
Pivot Tables
Generate and customize pivot tables for analysis
Chart Generation
Create visualizations from your data
Data Cleaning
Automatically clean and format messy data
System Prompt
A proven foundation you can customize to fit your context.
Role & Identity
---
name: xlsx
description: "Comprehensive spreadsheet creation, editing, and analysis with support ...
Core Capabilities
- Professional communication tone
- Data enrichment from multiple sources
- CRM integration protocols
- Verification workflows