Skip to content
Shop | Excel tracker

Target Condition and Experiment Log

Measure the current condition step by step with spread and share inside the planned cycle, write the next target condition with its date and measure, keep the obstacle list, and log every experiment with the figure you expected against the figure you got.

Screenshot of the Target Condition and Experiment Log workbook with example data
Example data from the workbook.

How it works

  1. 02 Setup: the process, the two people who will practice, the planned cycle and the demand per shift.
  2. 03 Current Condition: measure at least sixty cycles and ten shifts. The sheet calculates spread, share inside the planned cycle and the effective cycle.
  3. 04 Target Condition: write how the process will work at a date four to six weeks out, with one measure and one figure.
  4. 06 Obstacles: write every obstacle as it appears. Take one into work at a time.
  5. 05 Experiments: one row per experiment. Write the expected figure before the change is made, the actual figure the same day.
  6. 07 Status every week at the process, with the coach.

Definitions used in the workbook

  • Challenge: Where the process has to be in one to three years, taken from a goal of the annual plan, with a measure, a figure and a month.
  • Current condition: How the process works today, measured: mean, lowest, highest, share inside the planned cycle, interruptions.
  • Target condition: How the process will work at a date four to six weeks away. A description of the working process, not a result target.
  • Obstacle: One thing in the way of the target condition, named as a thing and not as a solution.
  • Experiment: One change and one assumption, with the expected result written down before it runs.

Sheets in the workbook

  1. Start
  2. Setup
  3. Current Condition
  4. Target Condition
  5. Experiments
  6. Obstacles
  7. Status

Who it is for

Team leaders and supervisors who want to improve one process in small steps instead of in projects.

Cheaper in the pack

This workbook is part of the Shop Floor and Lean Tool Pack (EUR 149), which holds all 20 Excel tools of this topic area, and of the Excel Tools Complete Library with all 100 tools.

The method behind the numbers

This workbook is part of the Improvement Kata and Coaching Kata 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.