Skip to content
Shop | Excel tracker

Skills Matrix Sheet

Stations with the learner hours to qualify, a matrix with four levels and colors, coverage per station and shift with the gap and a chart, and a qualification plan with hours, cost and dates.

Screenshot of the Skills Matrix Sheet workbook with example data
Example data from the workbook.

How it works

  1. 02 Setup: the area, the minimum released per station and shift, the validity and the hourly rate.
  2. 03 Stations: one row per station or task that needs a release, with the learner hours to qualify one person.
  3. 04 Matrix: one row per person, one column per station. Enter the level you can show evidence for, not the level you hope for.
  4. 05 Coverage: read the released people per shift, the covered slots and the gap per station.
  5. 06 Plan: turn every gap into a line with a learner, a trainer, hours and a date. 07 Status every month at the board.

Definitions used in the workbook

  • Level 1 to 4: Knows the task, works with support, works alone and is released, trains others.
  • Released: Level 3 or higher, signed against evidence, with a date and a validity.
  • Slot: One station in one shift. Eight stations in two shifts are 16 slots and, at a minimum of two, 32 released people.
  • Covered: Released people in a slot, counted at most up to the minimum. A third person adds no coverage to that slot.

Sheets in the workbook

  1. Start
  2. Setup
  3. Stations
  4. Matrix
  5. Coverage
  6. Plan
  7. Status

Who it is for

Shift leaders and area managers who want to know who may stand where, and where one absence stops the work.

The method behind the numbers

This workbook is part of the Skills Matrix and On the Job Training toolkits. The Starter Kit adds the guide and the checklist for the first 30 days. The Excellence Bundle adds playbook, workshop pack, templates, deck and the complete Excel system.

Newsletter

One Lean idea.
Every two weeks.