A living route-and-site profitability engine for a $2M/yr sweeping company. New data drops in a folder, fuel statements, payroll, invoices, GPS mileage, and the skill folds it into a versioned workbook where changing one wage cell reflows every route margin and site P&L in the model.
The moment the skill triggers it reads the latest session log, finds the highest-version workbook, diffs the raw-data folder against what the log already knows, and checks open follow-ups, then responds with a one-line status. No recaps, no “what should I look at?”
WEX fuel statements replace modeled gallons with real ones. Payroll kills the labor true-up guess. Invoices update per-site revenue at the line level, never smeared. Because the tabs are wired live, cost inputs flow into the Site P&L and the all-in model, each new file reflows every downstream margin.
Every update recalculates the workbook, verifies key totals independently, bumps the version, and archives the old file. The session log gets a dated entry, decisions, gotchas, open items, and partner communication stays one page, blunt headings, short emails, draft-only.