Skip to content
Shop | Excel system

Skills Matrix and On the Job Training System

Stations, people, matrix, coverage, risk with single holders and succession, qualification plan, job breakdown, training log in four steps, effectiveness check, key figures and audit.

Screenshot of the Skills Matrix and On the Job Training System workbook with example data
Example data from the workbook.

How it works

  1. 02 Setup, 03 Stations and 04 People: the rules of the area, the tasks that need a release and everybody who works there.
  2. 05 Matrix: the level per person and station, with evidence behind every 3 and 4. 06 Coverage reads the gap per station and shift.
  3. 07 Risk: the slots where one absence hurts, the single holders and who follows them.
  4. 08 Plan: every gap as a line with hours, cost and a date. 09 Breakdown: steps, key points and reasons for the task to be trained.
  5. 10 Training Log: every session in the four steps. 11 Effectiveness: defect rate and weeks to the standard cycle time.
  6. 12 Key Figures every month, 13 Audit every three months, 14 Status in the area review.

Definitions used in the workbook

  • Level 1 to 4: Knows the task, works with support, works alone and is released, trains others.
  • Slot: One station in one shift. Coverage is counted per slot, never as an area average.
  • Four steps: Prepare, show, let the learner do it, follow up and release.
  • Key point: Anything in a step that makes or breaks it: safety, quality, knack or timing. Every key point has a reason.

Sheets in the workbook

  1. Start
  2. Setup
  3. Stations
  4. People
  5. Matrix
  6. Coverage
  7. Risk
  8. Plan
  9. Breakdown
  10. Training Log
  11. Effectiveness
  12. Key Figures
  13. Audit
  14. Status

Who it is for

Production and area managers who run qualification and training at the workplace as a system across an area or a plant.

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.