Value Stream Mapping Right in Excel

Easy to Use Value Stream Map and VSM Symbols

The purpose of a Value Stream Map is to analyze value-added and non-value added activities and delays. Value Stream Maps use a group of common symbols.

QI Macros Add-in for Excel Makes Value Stream Mapping as Easy as 1-2-3

value stream mapping template excel

To access the QI Macros Value Stream Mapping Template and Symbols, click on QI Macros Menu, then Lean Tools and then Value Stream Mapping.

value stream map on QI Macros menu in Excel

Once the template opens, you have several options:

  1. VSM Text: Input your data into each cell in the spreadsheet and then click a button to automatically create a value stream map.
  2. Symbols: inventory of VSM symbols to copy and paste into any Value Stream Map
  3. Value Stream Examples 1, 2, and Emergency Room to use as a starting point to save time.
  4. Spaghetti Diagram

vsm-template-options

Automated Value Stream Map

automated value stream map template

The template is pre-populated with values to give you an idea of what to input in each cell. Use the Clear button to delete the contents of each cell and the Reset button to re-populate the sample text.

Each step in a value stream map represents an operation that is performed on the product. The operation is generally performed in one location with a clear beginning and ending point. Value stream maps are broad in scope and are not meant to describe individual tasks like a flowchart.

For each step in the Value Stream Map:

  • Briefly describe the Process or Work in Process step in column B (e.g. Take Order, Paint Door, Measure Board)
  • Estimate the amount of inventory on hand in each WIP area in column C
  • Indicate if the step is value added or non-value added from a customers standpoint in column D
  • Input the cycle time for value added and non-value added steps in columns E and F, respectively
  • Input the number of people it takes to perform the process in column G
  • Input Changeover time (time from completion of step for one product to beginning of step for the next product) in column H
  • Input % of Uptime in column I
  • Input % of waste or scrap in colmn J
  • Input available time in column K

Once you have populated all of the fields, click the Create VSM Button and QI Macros will draw a value stream map for you. Any rows with values will be shown on the Value Stream Map.

 

Tip: Adding and deleting items from the input matrix:

  • do not delete rows - leave cells blank instead of deleting the row
  • the template has room for 27 steps. If you need to add more steps, you will need to copy and paste symbols on the value stream map

 

Value Stream Mapping Symbols and Icons

Click on the Symbols tab to access Value Stream Mapping Symbols and Icons to add to your VSM.

value stream mapping symbols and icons in QI Macros for Excel

Value Stream Examples to edit

Open one of three examples and edit to create your own.

value-stream-map

Learn More...

To create a Value Stream Map using QI Macros...
Try It Now!