PeerLab Book a call Plug Peer in
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. Peer grades your team's real calls against a written standard and shows you exactly where the layer breaks.

See how Peer works Book a call