Every trainee, every site, every month — on one live grid.
The problem
Excel wasn't made for dozens of trainees across many sites.
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ANAES ROTATIONS 25/26 — DO NOT EDIT WITHOUT ASKING!!! | ||||||||||
| 2 | Trainee | Grade | Aug | Sep | Oct | Nov | Dec | Jan | Feb | ARCP | Notes |
| 3 | Rees, A | ST4 | UHW | UHW | UHW | Morriston | Morriston | Morriston? | ??? | see other sheet | |
| 4 | Owen, J / Patel, S / Lewis, K3 trainees, 1 cell? | ST3/CT2 | Morriston (Patel 60% + Owen) | Morriston | Glan Clwyd?? | GC | UHW | UHW | TBC | ? | LTFT – check w/ Sarah |
| 5 | Hughes, M | ST5 | Glan Clwyd | Glan Clwyd | Glan Clwyd | Glan Clwyd | OOP? | TBC | TBC | Jun? | |
| 6 | Davies, L | ST6 | UHW | MorristonWho changed this? | UHW | UHW | UHW | Morriston | see other sheet | moved – ask Gareth | |
| 7 | Price, R | CT1 | UHW | UHW | UHW | Morriston | Morriston | Morriston | (old) | ||
| 8 | |||||||||||
| 9 | MORRISTON WTE | 2.6 | 4.0Over capacity? | #REF! | 3.2 | 3 | 3.6 | 2.6 | max 3? or 3.5 | ||
| 10 | UHW WTE | 2 | 3 | 3 | 3 | #VALUE! | 2 | 1 | |||
Features
The real app, with example data.
Drag placements into place. Site capacity updates live, and the heatmap shows pressure.
Six live checks: overlaps, gaps, capacity and more. Each one links to the trainee.
Years of placements on one line, with stage progress and issues marked.
Fill rate, gaps by site, and a full Excel export.
Also included
Outcomes on the trainee record, with Gold Guide codes.
Try changes safely. Promote or discard.
Every change logged. Undo, redo, restore.
Programmes
Each programme keeps its own data. The organisation sees them all.
Your data
Read our privacy notice for how trainee data is handled.
Email us for a walkthrough.