Time Value Map

Use a Time Value Map is 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 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 (i.e. 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

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

To draw Time Value Maps in Excel, purchase QI Macros SPC Software for Excel through our secure shopping cart or try a free, QI Macros 30-day trial!
To create a Time Value Map using QI Macros...
Try It Now!