Skip to content
Shop | Excel tracker

Problem Log and 5 Why Tracker

Log every problem, work through the 5 Why analysis and follow the actions until they are effective.

Screenshot of the Problem Log and 5 Why Tracker workbook with example data
Example data from the workbook.

How it works

  1. Open 06 Lists. Check the target days per level and the cause categories. Set the status date or delete it to use today.
  2. Write every problem of the area in 02 Problem Log: date, line or station, the gap to the standard, level, owner and cause category.
  3. For every 5 Why and full method problem, fill one row in 03 5 Why Tracker. Record how each cause was verified.
  4. When the problem is closed, enter the closing date. Book the effectiveness check and enter its result: effective or recurred.
  5. Read 04 Dashboard in the weekly review: open and overdue problems, days open by level, recurrence rate, Pareto of causes.
  6. Actions that come from the Pareto or the audit go to 05 Action List, with owner and date.

Definitions used in the workbook

  • Days open: Closing date, or the status date for open problems, minus the date opened. Read it per level.
  • Overdue: An open problem whose date opened plus the target days of its level lies before the status date.
  • Closed on time: Problems closed on or before their due date, divided by all closed problems.
  • Recurrence rate: Problems with the check result recurred, divided by problems with the result effective or recurred.
  • Pareto of causes: Problems per cause category, sorted from largest to smallest, with the cumulative share.

Sheets in the workbook

  1. Start
  2. Problem Log
  3. 5 Why Tracker
  4. Dashboard
  5. Action List
  6. Lists

Who it is for

Team leaders and engineers who solve problems at the source.

The method behind the numbers

This workbook is part of the Problem Solving 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 week.