Time Value Map

Use Time Value Maps to analyze value-added and non-value-added activities and delays.

Here is an example of a Time Value Map template included in QI Macros for Excel. Any bar above the center line is value added (VA). Any bar below the center line is non-value added (NVA). The gaps between bars represent delay and are assumed to be non-value added. These can be eliminated with value stream mapping and spaghetti diagramming.

time value map template in Excel

To create a Time Value Map in QI Macros:

  1. Click on Lean Tools » Time Value Map to open the template.
  2. Column A: Enter the list of activities.
  3. Column B: Enter the duration for the activity described in column A.
  4. Column C: Enter the wait time (delay) between the steps.
  5. Column D: Enter whether the activity is value added (1) or non value added (-1).
  6. Column E:
    • Enter the Start Time in E2 (e.g. 12:00:00 AM).
    • Enter the interval in E4 (e.g., 0:01 or 0:05 minutes). The interval affects how the bars are drawn on the chart. If you have wide time spans, a bigger interval might work better. The lower the interval, the wider the bars. If you aren't sure what to enter just use the default.
  7. Click the Create Time Value Map button. This will populate the time value map and also create a stacked bar chart comparing value added and non value added total elapsed time.

create button for time value map template

* NOTE: If not all of your data has been plotted on your Time Value Map, make sure you do not have more than 4,000 rows of data that is being created for calculation (e.g. an action or actions that span multiple hours, while your Interval is set at 0:01 minute, etc.).

Watch a Video of How to Create Time Value Map (Click Here)

Read more - Time Value Map of an Ultrasound Process

Popular Lean Tools in the QI Macros

Other charts created by QI Macros for Excel