In all my years as a Six Sigma Black Belt, I’ve never come across such a complete Excel file. This spreadsheet has 37 tabs in it. This is more than the number of Excel files I’ve seen in some projects! I came across this file over the years but I wished I knew who completed […]
Category Archives: Six Sigma
Value Stream Map Spreadsheet
Here\’s a new (fourth) value stream map spreadsheet you can use in Microsoft Excel. The VSM is intended to be a team exercise and maps out in detail the current process and cycle times, then strives to find improvements in the form of reduced cycle time, machine set up time, and overall customer order fulfillment […]
Lean Six Sigma and DMAIC Tools Update
You may have noticed that templatestaff.com has been completely revamped and has had many Lean Six Sigma and DMAIC tools added. While these are not pure Six Sigma software downloads, they are in most cases great tools for your Six Sigma analysis. We have taken both green belt and black belt training and there is […]
Six Sigma Quality Function Deployment – House of Quality
Quality Function Deployment – House of Quality – Excel Download Great Design For Six Sigma (DFSS), the Quality Function Deployment (QFD) techniques and the houses of quality to drive product requirements from Customers’ critical to satisfaction (CTS) to the engineering designers critical Failure Mode Effect Analysis (FMEA). What is Quality Function Deployment? QFD is […]
SPC (Statistical Process Control) Excel Template – 3 Factor DOE
SPC (Statistical Process Control) Excel Template – 3 Factor DOE Folks, as promised from yesterday\’s blog post, here is a 3 factor DOE Excel Template for you to use. Credit must be given to Dean Christolear over at CpkInfo.com, who granted us permission to use the templates. This spreadsheet allows the user to perform a […]
Z-Transform Defined – Six Sigma Glossary of Terms
A Z-Transform is an equation that transfers a set of data represented by a normal distribution into a standard normal distribution (mean equals zero and standard deviation equals one) by subtracting the original mean from the data set and dividing the result by the original standard deviation. Z-Transform
Six Sigma Design Concepts Matrix Tool – Excel Download
Six Sigma Design Concepts Before we talk about Six Sigma design concepts, here\’s the latest update. I\’ve been asked lately about how to download the files. At the bottom of every post, there should be a blue link, just click it and download from there. Six Sigma Design Concepts Matrix The Six Sigma Design […]
Six Sigma Morphological Matrix – Excel Download
Six Sigma Morphological Matrix Get your features locked and avoid feature creep with this template. Break down the category features (by color) then drill down specific features. Columns A, B, C, D can be changed to serve your purpose. The morphological matrix is a simple tool where the team (not just you, the lone wolf) […]
Six Sigma Audit Checklist – Excel Download
Six Sigma Audit Checklist Six Sigma is about data. Nothing new about that. One of the challenges I always come across is when I come across bad data. Many people think that collecting data for a rainy day is a good thing. Then they bring out their data, which often is meaningless and incorrect. I […]
Six Sigma Cause and Effect Matrix – Microsoft Excel Download
Six Sigma Cause and Effect Matrix I have not found a better Cause and Effect matrix than this one. Complete the C&E Matrix prior to proceeding to the FMEA process at the Analyze phase of any DMAIC project. The Six Sigma Cause and Effect matrix must be used as a high level process mapping right […]