ThinkWork
Interactive Team/Manager Free · no sign-up

Team Skill-Gap Heatmap Generator

Managers usually have skill ratings scattered across scorecards, spreadsheets, and 1:1 notes — but rarely see them side by side. Paste your team's ratings across a shared competency set below and this tool builds a red-to-green heatmap of every rep against every skill, ranks the competencies dragging the team down, and flags which reps could mentor which.

Your numbers

Row 1 = headers: Name, an optional Team/Role column, then one column per competency. Paste comma- or tab-separated data straight out of Excel/Sheets — a second column literally named Team, Role, Group, Region, Pod or Squad is auto-detected and grouped.
Must match the scale your ratings were scored on.
Scores at or below this count as "needs development" — adjust to match your scale.
Score a rep should reach to be considered fully proficient in a competency.

Method & assumptions

  • A second header column literally named Team, Role, Group, Region, Pod or Squad is auto-detected and unlocks a team-vs-team comparison table — omit it if you just want one flat roster.
  • Colour runs red→green across your chosen scale; the bottom heatmap row and right-hand column are simple (unweighted) means, not adjusted for deal size, tenure, or patch difficulty.
  • Gap threshold and proficiency target are entirely yours to calibrate — set them to whatever your own rubric considers "needs development" vs "proficient".
  • With only a handful of ratings per competency, one strong or weak scorer can swing the team average — treat small samples as directional, not definitive.

How to use it

1. Gather each rep's rating (1–5 or 1–10) across the same competency set — from QA scorecards, manager 1:1 notes, or a training/certification assessment. 2. Paste into the box as CSV: row 1 is headers (Name, optional Team/Role, then one column per competency); every row after that is one rep. 3. Set the rating scale, gap threshold, and proficiency target to match your own rubric — there's no universal "good" score. 4. Read the heatmap for individual gaps (red cells), the ranked list for where team-wide coaching will move the average fastest, and the recommendations for who could mentor whom.

For managers

A checklist shows the surface. A standard shows the layer underneath.

If team performance keeps coming up in your 1:1s, the gap is usually structural, not effort. The Mastery Diagnostic measures your team against a written 27-framework standard in two weeks, and tells you exactly where the layer breaks.

See the Mastery Diagnostic Book a discovery call