Value Stream Mapping Template
Training to get you started.
Tools you won't outgrow.
When you first open your Value Stream Mapping Excel template, (VSM.xlsx)
you will start on the 'Help' sheet,
that supplements the training on this web page.
Then open the 'Sample' sheet
that has sample data that you can play with.
Value Stream Map Template
These value stream mapping templates
have training to get you started,
and features that you won't outgrow.
Sample Value Stream Map example.
Bookmark = why
Value Stream Mapping template
- To do value stream mapping
It's easy to learn
how to draw using Excel
Have you ever tried
using Visio to do math?
See our online value stream mapping training for:
- Why do value stream mapping? (at all)
- How to do value stream mapping (better)
- Why use an electronic value stream map? (not just sticky notes)
You don't have to program and debug your own formulas
to answer those questions that caused your team to do value stream mapping in the first place
What questions should your team be asking?
When you own Systems2win, you don't just get one simplistic drawing tool.
You get a full suite of value stream mapping tools,
including a set of 'Design Guideline' templates, to ensure that your team is asking the right questions.
- Capacity planning
How can we make only what we need when we need it?
Taking into consideration factors like:
- Work centers that have different work schedules
- Work centers that make subcomponents in quantities different from the end product
- Scrap, rework, staff unavailability, downtime, and other factors that affect capacity
- Show different levels of detail
Use the 'Hide or Show Rows' button to show only what different audiences want to see
Perhaps show only a few important rows to executives, more rows for your team, and even more for your consultant.
Perhaps include or exclude the engineering or sales quoting process that (sometimes) precedes production.
Optionally drill down to related documents
- Personalize it
Familiar Microsoft Excel
Use everything you know about familiar Word and Excel
Use everything you familiar Microsoft Excel
to add your own formulas, charts, or even macros
It's a Systems2win template
Your personalizations can be automatically found and transferred
each time that you upgrade in the future
This entire suite of process improvement templates
is priced low enough to empower every team member
How to use your
Value Stream Mapping Template
Learning experiments to learn to use your Excel Value Stream Map template
Find and open your template
Find and open your
value stream mapping template
in the same way that you find and open
your other 150+ Systems2win templates.
If you don't yet own a license,
you can download your free trial now.
Save your working document
following the usual document storage and naming conventions established by your leaders
Open a Blank Sheet
When you're ready to start doing your own real work...
click the button to 'Open a Blank Sheet'
Excel Ribbon bar > Systems2win tab > Open a Blank Sheet
This blank sheet is where you will do your real work
(not on the Sample sheet)
Choose which value stream mapping template to use
A window appears giving you the choice of:
- Simple - Just Draw
- Power Tool -
Draw, Measure, Analyze, Improve, and Manage
- Supply Chain Map
If the scope of your Team Charter includes your suppliers,
then consider using your Supply Chain Mapping template.
Otherwise, you will almost always use your VSM Power Tool.
Rename your new sheet.
If your organization has not yet provided a license,
Trial templates are fully functional for 60 days, and are fantastic for learning.
But you don't want to do too much real work on a trial template,
because once you purchase your licensed version,
So once you have played enough to have confidence that these tools will greatly leverage your continuous improvement efforts, you should throw away that trial template, and start doing your real work on your new power tools.
When you own Systems2win Value Stream Mapping templates
you own an entire suite of useful value stream mapping tools
with online training for how to do value stream mapping
to make your life easier at every step of your Lean Journey
to the Value Stream Mapping training available to you
Now that you have your Value Stream Mapping template opened in front of you in Excel,
the first thing to do is to get oriented to the value stream mapping training that is available to get you started,
and how to quickly find training for advanced features when they become important to you.
Notice the menu in the sidebar >>>>>
with the blue buttons
You will find that menu on every training page related to value stream mapping,
and it will help you keep track of where you are.
The top part of the sidebar menu
has links to learn about the Systems2win value stream mapping templates
that make every step of the value stream mapping process so much easier
The bottom part of the sidebar menu
Video: Value Stream Mapping
Introduction to Training
has links to training pages related to value stream mapping,
where you will find answers to questions like:
- What's a value stream?
- What's a value stream map?
- Why do value stream mapping? What are the benefits?
- When should we do value stream mapping?
- When should we use sticky notes?
- When should we use our software?
- What do we do next?
Make sure you're ready to use a value stream mapping template
If you're just becoming oriented to what's involved in value stream mapping
then that's great...
Download your trial, and just start playing and learning.
If you already own your Systems2win templates, and are ready to begin real-world value stream mapping
then as you follow the instructions for how to do Value Stream Mapping,
when you get to the part where you are ready to use a value stream mapping template,
then follow the instructions on this page.
(Optionally) change the language
If you prefer to use a language other than English,
see our online training for how to
easily switch between languages.
Translations available for immediate delivery include:
- Spanish: Mapeo de la Cadena de valor
- Portuguese: Mapeamento do Fluxo de Valor
- Chinese: 价值流图
- French: Cartographie de la chaîne de valeur
- German: Wertstromanalyse
If you have limited vision, or limited use of your hands
Learn how to use the special features for people with disabilities.
to your Value Stream Mapping template
The Help sheet
Video: How to Find Help & Training for any Systems2win template
Notice that when you first open any Systems2win Excel template,
it opens to the 'Help' worksheet.
And every 'Help' worksheet is organized the exact same way,
so when you learn how to find help for one Systems2win template,
you know how to find help for ANY Systems2win template.
If this is the first Systems2win template you've ever used,
take a few minutes to become familiar with what help is available on the 'Help' sheet, and how it is organized.
The QuickStart Training video will show you how to quickly find the help you need whenever you need it.
The Ribbon bar
In version 13, all macro buttons have been replaced
by menu items in the Systems2win menu in the Excel Ribbon bar.
The Sample sheet
Once you have familiarized yourself with the help available on the 'Help' sheet,
you should be ready to start learning how to use your value stream mapping template.
And the fastest way to learn is to play with the sample data on the 'Sample' sheet.
Don't do real work on the Sample sheet
The Sample sheet is very useful because it has sample data that you can play with for faster learning,
but when you're ready to make your own value stream map,
If you skipped the Quick Start Training for how to use ANY Systems2win template,
you should stop and review that now.
Once you learn how to use one Systems2win template, you know how to use them all.
Before doing anything else, it's probably a good idea to just take a look around the Sample sheet first.
View > Zoom to adjust your value stream map to fit your viewing screen.
Notice that when you scroll, the top and left panes remain frozen,
making it much easier to keep track of where you are on you map.
Perhaps also quickly review our other Viewing Tips
which you will also find useful when using any of your other 150+ Systems2win templates.
Click the navigation links in the upper left corner to quickly take you to:
- Analysis and Charts
And then from those sections,
click the 'Top' link to quickly take you back to the top of your document.
Video: Hide or Show Rows
Video: Add or Remove a Process
Click the button to 'Hide/Show Rows' to
quickly hide or show rows
so that you don't overwhelm your target audience with more answers than they have questions.
and easily unhide the correctly programmed lean analytics
that become important as you round each next corner of your lean journey.
Add or Remove a Process
Click the button to 'Add or Remove a Process'.
Notice that it doesn't just add & remove the cell borders...
it adds and removes the correctly-programmed math.
Add or Remove Columns
Click the button to 'Add or Remove Columns'.
Notice that every column that contains a Process Box is paired with the column to its RIGHT.
And those paired columns are always kept together when you add or remove columns.
Unprotect and Protect Sheet
Click the buttons to 'Unprotect' and 'Protect Sheet'.
Notice that you don't need to unprotect the sheet
to copy unlimited rows of your own user-defined fields and formulas.
Click any row or column header
and notice that you get pop-up help
(just like every Systems2win template)
And notice that there are also links to online training and videos,
right there next to the row headers in the Critical Path section.
Have you ever watched someone new to value stream mapping
try to figure out what they're looking at on a value stream map that doesn't have easily accessible training?
They ask questions like, "What does C/T mean?", or "How did it come up with than number?"
When you use any Systems2win template, help is always there with one quick click.
Play with Sample Data
Now that you are oriented...
Perhaps take some time to play with some of the sample data on the Sample sheet,
learning how things work, before starting a new worksheet where you will begin YOUR value stream map.
Bookmark = start
Start your own value stream map
Open a Blank Sheet
If you haven't already...
select Systems2win menu > Open a Blank Sheet
(following the instructions already covered in the section above)
Rename your worksheet
Right-click the worksheet tab > Rename
You will usually name your sheet based on the State of your value stream
(e.g. "As Is", "As Was", "Current", "Future 1", "Ideal"...)
Define your Defaults
Do not skip this step!!!
How can any math be correct
until you have defined your units of measure, work time available, and other defaults?
In the 'Instructions' section of the 'Help' sheet,
use the dropdown list to choose your desired
Cycle Time Unit of Measure
which can be seconds, minutes, or hours.
If you change Cycle Time Unit of Measure, then:
- you must change it first — before entering any other data
- you must manually recalculate the workbook
Defaults that you define on each sheet
In the Systems2win menu
On each worksheet containing a value stream map,
in the Excel Ribbon bar, select
Systems2win menu > Change Lead Time UOM
then in the window that appears,
select your Lead Time Unit of Measure,
which you can switch at any time between
- Working Days
- Calendar Days (including non-working days)
In the row headers on the sheet for each value stream map
enter additional default values
in the double-border pink cells
See image >>>>>
Tip: You might need to use the button to 'Hide/Show Rows'
to unhide all of the rows that have double-border pink cells where you enter optional default data
Tip: If you are still using an old version of the template,
default units of measure used to be defined on the 'UOMs' sheet
Demand Unit of Measure
Video: Units of Measure
This is the unit of measure for "the thing being transformed"
which might be inventory, medical patients, paperwork, etc.
Choose the lowest unit of measure that is most commonly delivered to the end customer.
Example: If you make soda, the UOM could be bottle, or six pack, or 12 pack, but might more likely be case or pallet.
As explained in the video,
each process can optionally have its own Process Unit of Measure.
Example: a process might make 4 'wheels' per 'go cart',
and all the math is handled for you.
What do you call your workers? Staff? Employees? FTE's? (full time employee equivalents)
Tip: You might need to use your 'Hide/Show Rows' button to Show the rows containing the following optional defaults
Unit of Measure — Distance Within
This is usually a smaller unit of measure such as feet or meters.
This unit of measure is irrelevant for a Supply Chain Map.
Unit of Measure — Distance Between
This is usually a larger unit of measure such as miles or kilometers,
but might be a small unit of measure for some value streams.
To change currency, simply use the dropdown list at the top of the sheet to select your preferred currency symbol, and then click the Currency button.
This will change the currency denomination for all money-related cells in the worksheet.
Because so many currencies use the same symbol, you can also use the pink cell in the Critical Path tier to clarify exactly which currency is used for this value stream.
The following defaults are defined in the pink cells in the Value column
Demand per Week
Enter weekly demand.
Even if your forecast uses some other time period,
you must enter Demand per Week,
but then notice that the next row calculates Demand per your currently-selected Lead Time Unit of Measure,
allowing you to switch at any time between working days, calendar days, weeks, or hours
Work Time Available
In the pink cells in the Critical Path row headers,
enter your default values for the elements of Work Time Available.
Pulse Batch Size
See the online training for Factors to Consider when choosing Pulse Batch Size.
Change Over Batch Size
When it becomes important, you can calculate your optimum Change Over Batch Sizes.
In othe words, how much time is available to do more frequent change overs, so that you can deliver exactly what your customer wants as quickly as she wants it?
What's your smallest optimum batch size? Let your template do the math.
Takt Time Calculator
After you follow the instructions above to enter your default data into the pink double-border cells, notice that your value stream mapping template automatically calculated:
- Work Time Available
- Takt Time
- Pitch Pulse Rate
Define the segment of the value stream that you will be mapping
Define the boundaries of where this value stream map starts and ends.
Enter the process description in the first Process Box (in the first column of processes)
and the last Process Box (in the last column)
Learn more about value stream segments and loops
Start working with your Process Flow Boxes
Your (very short) descriptions will often be just one word.
Examples: Deburr. Wash. Assemble. Ship.
or maybe two words: Gather Data. Enter Data. Admit Patient.
Because value stream mapping is done infrequently,
it is a good idea to refresh everyone's memory
by going over the definition of a Continuous Process Flow Box
every time that you do another round of value stream mapping.
In a value stream map, as long as 'the thing being processed' doesn't stop flowing, you use just one 'Continuous Flow Process Box'.
This is very different from a similar-looking Process box in a traditional flowchart. See the online training if you need to refresh your memory.
Analyze and Improve your Value Stream
Learn how to use your value stream mapping template for Value Stream Analysis
to Define, Measure, Analyze, Improve, and Control your value stream
(not just draw it)
The biggest strength of your Systems2win value stream mapping template is Value Stream Analysis,
which has its own training page.
When you're ready to print
You have all the power of Microsoft Excel to print on any size plotter that you own.
If you don't yet own a plotter, then perhaps change the Print Settings to print on multiple pages,
which you can then tape together if your value stream map is too large to be readable on one small sheet of paper.
Keep your goals in mind
Now that your value stream map is completed,
be sure to return to FINISH the instructions for how to do value stream mapping
because your goal was not to "draw a value stream map",
your goal was "to transform your value stream".
And when done correctly...
the process of value stream mapping
Transforming not only the flow of the things that you process,
but also transforming relationships
between managers and employees,
and perhaps even ultimately transforming
We hope you enjoy your journey,
and we thank you for choosing Systems2win to be a part of it
Return to home training page for how to do value stream mapping