Lean Six Sigma Templates in Excel
Is it too hard to create documentation for your Lean Six Sigma Project?
- Drawing flowcharts, value stream maps and Ishikawa diagrams?
- Updating monthly charts and dashboards?
- Advanced analysis like Gage R&R, DOE, and so on?
Good news! QI Macros contains more than 140 time-saving fill-in-the-blank templates.
Lean Six Sigma Templates - the Basics
Templates are found in a few different places on QI Macros menu. Control Chart, Capability Analysis and Statistical templates are organized with their corresponding macros. The Lean Six Sigma templates and tools are located together and organized by major category.
To open up any QI Macros template, just click on the QI Macros tab and then the template you want.
- All input areas are shaded in yellow for easy identification.
- Gray shaded areas are calculations that you generally want to stay away from.
- Many templates are made up of several worksheets, so take a look at the worksheet tabs to see all of your options.
Some templates use Excel's drawing tools, some are pre-formatted forms to help you create documents, some are input forms that automatically create charts and some are powerful calculators that perform analysis like Gage R&R and DOE studies.
Some examples from our most popular templates
Just type your data into the VSM Text tab:
The template then uses Excels drawing tools to create/update your Value Stream Map:
Just type your "whys" into the yellow shaded areas and then click the create fishbone button and QI Macros draws the fishbone for you.
Input areas are shaded yellow.
Calculations are shaded gray.
Hover over red triangles in top right of a cells for formulas, additional instructions and tips.
- Color Coded Results: In addition to the color coded input and calculation areas, QI Macros templates also use color to communicate results. Here is another example from the Gage R&R template.
Green: Good | Yellow: Warning | Red: Needs Attention:
- Visible Formulas: The formulas for each calculated cell are visible to you in Excel's formula bar.
- Common Data Tabs: where appropriate (i.e. PPAP forms, FMEA forms), we have added a tab for common data. Enter part #s, supplier name, process description, etc once and all other tabs are linked and updated.
- Instruction Tabs: Each template contains an instructions tab.
Why choose QI Macros for your process improvement needs?
- Only $329 USD - less with quantity discounts
- No annual subscription fees
- Free technical support
Easy to Use
- Works right in Excel
- Create a chart in seconds
- Easy to customize & share charts
Proven and Trusted
- More than 100,000 users
- In More than 80 countries
- Five Star CNET Rating - Virus free