When WhatsApp + Excel Scheduling Hit the Wall
Colored cells and group chats worked fine for 2 teams. At 10+ teams, information was lost, versions conflicted, and coordination collapsed.
10+ teams
The Breaking Point
Better
Schedule Adherence
Faster
Reassignments
The Challenge
Teams were dispatched via WhatsApp messages and a color-coded Excel calendar. For 1-2 teams, this 'worked'-everyone could see the schedule, WhatsApp was familiar, and coordination was manageable. But as the company grew past 10 teams, the system failed catastrophically. Information was lost in WhatsApp scroll-back, multiple Excel versions created conflicting schedules, and there was no audit trail of who was assigned what.
Business Impact
Communication breakdowns causing missed jobs, double-bookings, and team frustration. Lost information about plot details, kit requirements, and site access. No visibility into actual schedule adherence. Emergency changes required multiple WhatsApp messages and spreadsheet updates that often didn't reach everyone.
Who This Affected
Key Pain Points
Excel calendar is 'very flat'-just colored cells with no data structure
Impossible to filter, search, or programmatically update. Works for 2 teams, fails at 10+
WhatsApp information lost in scroll-back
Critical plot details, kit requirements, and site access info buried in message history
No audit trail or version control
Multiple Excel versions creating conflicting schedules with no way to determine which is current
The Solution
Implemented central tracker with calendar-based scheduling, dispatch packets containing complete site/plot/kit context, and status feedback loop. Each team receives all job information in one place, schedule changes propagate automatically, and management has real-time visibility into dispatch state and progress.
Features Implemented
- ✓Central tracker with single source of truth for job assignments
- ✓Calendar-based scheduling with drag-and-drop reassignment
- ✓Dispatch packets with complete site/plot/kit context
- ✓Status feedback loop (dispatched, in progress, completed)
- ✓Mobile access to dispatch information for field teams
- ✓Audit trail showing all schedule changes with timestamps
Implementation Approach
All existing Excel schedules were migrated into the central tracker. Teams were trained to check their dispatch queue instead of WhatsApp for job assignments. Dispatch packets included everything needed: site address, plot number, kit list, access instructions, special requirements. Status updates from mobile app kept office informed of actual progress.
The Results
Better Schedule Adherence
Teams had complete information for each job; fewer missed details or wrong sites
Fewer Miscommunications
Single source of truth eliminated conflicting information and WhatsApp confusion
Faster Reassignments
When team availability changed, jobs could be reassigned with all context preserved
"Views… are just coloured cells on an Excel sheet. So it's very flat. You might make it work for a small team… scales horrifically badly when you start adding more teams."
— Operations Manager
Why This Story Matters
Operations Director
Why It Matters
WhatsApp and Excel feel free and familiar, but they create invisible operational drag that compounds with scale.
Key Focus
Implement structured dispatch system before informal tools break down at 10+ teams.
Installation Manager
Why It Matters
Your teams deserve complete job context in one place, not scattered across WhatsApp messages and spreadsheets.
Key Focus
Give teams dispatch packets with everything they need: site, plot, kit, access, and special requirements.
Related Case Studies
Explore more stories of solar companies solving real challenges