Distribute the sheet.
Send every team member the self-assessment: Excel template · CSV version. It takes ~15 minutes to fill in.
Collect & upload.
Drop the returned files below — several at once is fine. New sheets for the same person overwrite their previous answers, so re-run the exercise any time.
Read the picture.
The heatmap shows who can do what; the gap view compares against role expectations; the actions view suggests what to train, who can mentor whom, and what to hire for.
You can also load a demo team to see how it works, or import a saved snapshot.
Each cell compares a person's level with the target for their role (editable under Role targets). Only skills with a target for that role are scored — everything else stays blank.
Biggest team gaps
Total missing levels across everyone whose role targets the skill.
Default expectations per CDC role
(from docs/12-roles-and-competences.md). Click a cell to cycle its target
0 → 1 → 2 → 3 → 0 and adapt them to your organisation — changes are saved in your browser.
Data lives only in this browser (localStorage). Export a snapshot to archive a review round, move to another machine, or share with a co-manager.