Coverage objective
Attend the maximum number of team meetings in person.
Allocate sessions across your trainer pool, reveal diary clashes, minimise unnecessary mileage and identify where an overnight stay unlocks better coverage.
Planning readiness
0%
Loading
Checking meeting details and trainer bases.
Manual workbook update
Upload the latest meeting planner
The website does not sync with SharePoint. Download the latest Excel file, then drop it here or choose it. Matching attendance decisions, assignments, notes and PL-informed flags are retained.
Drop the updated Excel workbook hereAccepted: .xlsx, .xlsm or .xls · Current source: embedded workbook snapshot
Next actions
Get the plan decision-ready
Decision status
Meeting coverage
Trainer split
Workload and travel
Data completeness
What still needs confirming
Geographic plan
Map meetings, bases and daily routes.
Meeting dots follow attendance status. Area-centre locations are temporary until an exact venue is entered.
Loading interactive map…
The meeting register remains available if map tiles are blocked.
The meeting register remains available if map tiles are blocked.
Diary view
See every meeting date and clash.
The calendar flags confirmed timing conflicts, potential conflicts caused by TBC times, and days that exceed available trainer capacity.
Exceptions
Clashes and scheduling warnings
Meeting register
Control every attendance decision.
Update the venue and time, assign a trainer, change the RAG status and record that the meeting lead has been informed.
| Status | Date & time | Meeting lead | Venue | Type / organiser | Assigned | Drive | PL informed |
|---|
Planner setup
Set bases, constraints and source data.
Base locations unlock mileage and drive-time calculations. The planner now supports shared live storage when connected to Cloudflare D1; browser storage remains as a fallback/cache.
Optimisation rules
Travel and scheduling assumptions
Coverage first assigns no more than one TBC-time session per trainer per day.
minutes
Used only for optimisation until the real meeting time is entered.
minutes
miles
Source and portability
Keep the planner current manually
Import latest Excel planner
Download the latest SharePoint workbook and upload it here. Source fields are refreshed while existing attendance decisions are preserved where meetings match.
Export or restore planner
Create a JSON backup containing bases, decisions, notes and route settings, or restore one from another browser.
Reset local decisions
Return to the workbook snapshot embedded in this file. This removes local assignments, statuses, bases and notes.
Technical note
How mileage is calculated
The planner starts with a clearly marked estimate using straight-line distance adjusted for UK roads. “Refresh road mileage” requests road distance and duration from the public OSRM routing service. Venue and base searches use Postcodes.io for UK postcodes and OpenStreetMap Nominatim for other place names. Exact results depend on the addresses entered and network access.