What problem does it solve? Sales teams receive performance reports as Excel files in varying formats, and manually copying MTD, YTD, and Year End metrics into a database is slow and error-prone. This Skill automates the monitoring, parsing, and persistence of those metrics for live internal reporting. ## Core Features & Use Cases - Automated File Monitoring: Watches designated directories for new or updated .xlsx and .xls files, ignoring temporary Excel lock files and waiting for writes to complete before processing. - Flexible Metric Extraction: Parses all workbook sheets, detects metric type (MTD, YTD, Year End) from sheet names, and maps columns flexibly across revenue, units, deals, and quota variants. - Audited Database Persistence: Bulk inserts validated metrics into PostgreSQL with transactions, matches representatives by email or name, and logs every import with row counts and timestamps. - Use Case: A sales operations team drops weekly regional Excel reports into a shared folder; the agent automatically extracts each representative's revenue and quota attainment, stores them in PostgreSQL, and emits a completion event for downstream dashboards. ## Quick Start Monitor the sales reports folder and extract all MTD, YTD, and Year End metrics from any new Excel files into the database.
