Skip to main content

Excel Templates, Training, and Systems

Spaghetti Diagram

also known as Layout Diagram, Spaghetti Chart, or Standard Work Chart

Why use a Layout Diagram?

  • To draw simple Floor Plans
  • As a Spaghetti Map to visually illustrate how a process flows through a work space
  • As a Standardized Work Chart showing visual work instructions
Layout Diagram

Sample Spaghetti Diagram Example


why

Why use a Spaghetti Diagram template?

Why not just draw by hand?

For the same reasons that you use any software

  1. Save time — and money

    Not having to 'start over' for every little change

  2. Legible — so people can read it

    Maybe your hand drawings are okay, but how about your teammates?

  3. Accurate — so you can trust it

    Maybe your dimensions are precise, but how about your teammates?

  4. Training — and online help

    To remind people how to do this (infrequent) process improvement activity

  5. Standardized — consistent, teachable, repeatable

    So that everyone does it the same way

Familiar surroundings

Familiar Microsoft Excel

Use everything you know about familiar Word and Excel

Since your people already own and know how to use Microsoft Excel,

your people have a much higher probability of actually using this powerful standardized work chart.


Training

Spaghetti Chart
Training & Demo Videos

Spaghetti Diagram Video

Additional training
relevant to this template

The Sample and Help worksheets of every template always contain training relevant to THAT template

Translations available for immediate delivery include:

  • Spanish: Diagrama de disposición
  • Portuguese: Diagrama de Disposição
  • German: Bestückungsplan
  • French: Diagramme d'agencement
  • Chinese: 布局图

 

Also see the rest of the Lean tools that come with your Standard Work Chart template

 

 

Download your free trial Spaghetti Mapping template

Video Help

Layout Diagram

 

How to use Excel as
a drawing tool

Also see more videos for
how to use Excel as a drawing tool

 

Video: Selecting the right
Standard Work tools

See more standard work videos


how

How to use your

Spaghetti Diagram template

Choose which template to use

The Layout Diagram is available in two ways:

  1. As a stand-alone template (LayoutDiagram.xlsx)
  2. As the 'Layout' sheet within your Standard Work template (StdWork.xlsx)

Find and open your template

Find and open your Spaghetti Map template (LayoutDiagram.xlsx)
or Standard Work template (StdWork.xlsx)

in the same way that you find and open your other 150+ Systems2win templates.

Excel Ribbon bar > Systems2win menu

If you don't yet own a license, you can download your free trial now.

You will find the Layout sheet as a tab within your StdWork trial template.

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 > Systems2win tab > Open a Blank Sheet

This blank sheet is where you will do your real work

(not on the Sample sheet)

Systems2win menu > Open a BlankSheet

Rename your new sheet.

Or... Insert Sheet

As an alternative to opening a stand-alone document (as instructed above),

you also have the option to Insert Sheet into any other Excel workbook.

If English is not your preferred language

Switch to your language, just like every Systems2win Excel template.


Now your team is ready to start using your

Spaghetti Chart template

Process Observation template

Observe the process

Using one of your templates for process observation

Draw your 'As Is' process

Excel training

On the 'Help' sheet of every Systems2win template, there is a section for 'Excel Tips most valuable for THIS template'

Go to that section of your 'Help' sheet now, and follow the links to learn how to use Excel as a drawing tool.

Help tab

Draw boxes for work areas and material supplies

   (see illustration)

These should be roughly placed as they are on the physical floor.

If exact measurements are important, you can use the grid, and/or shapes to indicate measurements.

Add a brief name or label to identify each work center box.

Layout Diagram

In this spaghetti Diagram illustration, the blue rectangles with a green arrow are gravity-fed inventory racks.

Feel free to invent your own shapes for material handling equipment unique to your process.

Next, add operation numbers in circles.

If you this process also has a standard work combination sheet, then the operation numbers on your spaghetti chart should usually correspond to the Work Element numbers in the standard work chart.

Next, add Operators

One 'operator' symbol per operator, and then empty circles for each additional place where that operator stops to work.

Red lines with arrows indicate the walk path.

Use a dashed line to make it clearly visible if a worker has to backtrack.

Next, add Work In Process (WIP) inventory.

using green-striped WIP circle shapes, with a number indicating how many WIP items are usually found there.

Don't count the part that the operator is carrying or handling, but only parts that are left in a machine or work center after the operator moves on.

Next, focus on Safety

Identify any work areas that have safety concerns, using the shape of a red or green cross, (similar to the shape used for a first aid kit).

Next, focus on Quality

using the shape of a green outlined diamond wherever quality is checked,

and the shape of a red stop sign with a 'Q' in it wherever there might be a quality issue.

Next, focus on Flow

Show the direction of the flow of the thing being processed, using a green arrow, and following the instructions for how to make a bent arrow

(the link to those instructions are found in the Excel Tips section of the Help sheet in LayoutDiagram.xlsx)

Enter (optional) summary data

Perhaps Total Standard WIP, lead time, cycle time, staff level...

Almost always indicate Takt Time. (perhaps using the Insert Sheet button to add a sheet for Takt Time Calculation)

Finally, you can (optionally) add explanatory notes

using text boxes, arrows, and/or clouds and bursts.

Get consensus that everyone agrees

Get consensus that everyone agrees that your "As Is" process is an accurate representation for the way things really are now.

Analyze the 'As Is' process

Use your Takt Time Calculation template (Takt.xlsx)

What isn't ideal?

Are there loops?

How might time & distance be reduced?

Are all of the steps necessary?

Could some steps be combined?

Consider all aspects of the Toyota 4 Rules in Use

Perhaps use your Standard Work template to perform a thorough process analysis

Perhaps return (again and again) to the Hansei questions to stimulate Lean Thinking

messy boys

Who needs standard work?

Improve the process

Copy your "As Is" sheet to serve as the starting point for your "To Be" sheet.

Use the special Systems2win utility: Systems2win menu > Copy Sheet

Process improvement training

Systems2win menu > Copy Sheet

more

Standard Work Chart

The greatest power of your spaghetti diagram is when you print it out and post it on the shop floor along with printed Standard Work Instructions.

Each circled Operation Number on the standard work chart usually corresponds with a Work Element on the Standard Work Sheet.

Your Standard Work Instructions (often with floor plan map) get printed and taped up right in front of each worker at their work station, to remind people of the right way to do each job, thereby eliminating costly quality mistakes.

See the Standard Work training and videos to learn more.

Spaghetti Chart in Standard Work

testimonial quote

This Spaghetti Map Layout Diagram template comes with an entire suite of Lean tools and Standard Work tools

 

to analyze, improve, and standardize ANY process

 

 

 

150+ Templates
Try Some Own Them All

 

 

Download Free Trial

If your organization has
not yet provided a license,
download your free trial now

 

 

 

 

 

 

New User Training

Your Systems2win templates come with free New User Training
to quickly learn features that are common to all 150+ templates

 

 

 

 

Own Yours Now

If your organization has
not yet provided a license,
own yours now

 

 

 

 

 

 

two bikers

Training to get you started.
Tools you won't outgrow.