Include Top

Home | Login | Live Help is Live Help

Included Menu

DMAIC & DFSS Templates

Team/Project Charter

Click SigmaXL > Templates & Calculators > DMAIC & DFSS Templates > Team/Project Charter to access the Team/Project Charter template.

Project Charter

SIPOC Diagram

Click SigmaXL > Templates & Calculators > DMAIC & DFSS Templates > SIPOC Diagram to access the SIPOC Diagram template.

SIPOC Diagram

Data Measurement Plan

Click SigmaXL > Templates & Calculators > DMAIC & DFSS Templates > Data Measurement Plan to access the Data Measurement Plan template.

Data Measurement Plan
Cause & Effect (Fishbone) Diagram
Click SigmaXL > Templates & Calculators > DMAIC & DFSS Templates > Cause & Effect (Fishbone) Diagram to access the Cause & Effect Diagram form.

Fishbone Diagram

Notes:
  1. Overwrite the text in the Cause, Sub-Cause and Problem Statement/Effect as appropriate.
  2. Use copy and paste to create additional causes or sub-causes.
  3. The arrows with text are grouped. To ungroup use Excel's Draw > Ungroup tool.

Cause & Effect (Fishbone) Template

Click SigmaXL > Templates & Calculators > DMAIC & DFSS Templates > Cause & Effect (Fishbone) Template to access the Cause & Effect Diagram template.

Cause and Effect Template
Cause & Effect (XY) Matrix Example
Click SigmaXL > Templates & Calculators > DMAIC & DFSS Templates > Cause & Effect (XY) Matrix to access the Cause & Effect (XY) Matrix template.

The following example is given in the file Template & Calculator Examples.xls. Click on the worksheet named C&E Matrix. This is a simple Cause and Effect Matrix example for a Call Center. If prompted, please ensure that macros are enabled in order to allow Pareto Charts to be created.
 Cause and Effect Matrix

Notes:
  1. Weight the Output Variables (Y's) on a scale of 1 to 10 with 10 indicating most important to the Customer.
  2. For Root Cause Analysis, assign the association/effect multiplier score for each X to Y using a scale of 0, 1, 3, 9, where 0 = None, 1 = Weak, 3 = Moderate, and 9 = Strong. Initially this assignment will likely be a team subjective assessment. Data should be collected and the degree of association should be validated with Graphical and Statistical Tools.
  3. For Project Selection or Solution Selection, assign the association multiplier score for each X to Y using a scale of 1 to 10, with 10 indicating strong association.

Pareto Chart



Click the Pareto Chart button to create a Pareto Chart of Weighted Scores by Input/Process Variables.




Failure Mode & Effects Analysis (FMEA) Example

Click SigmaXL > Templates & Calculators > DMAIC & DFSS Templates > Failure Mode & Effects Analysis (FMEA) template.

The following example is given in the file Template & Calculator Examples.xls. Click on the worksheet named FMEA. This is a simple Failure Mode and Effects example for Stocking Inventory. If prompted, please ensure that macros are enabled in order to allow sort by RPN.

FMEA Analysis

If you hover the mouse cursor over the Severity, Occurrence or Detection heading the recommended scale will appear as a comment:


FMEA Analysis

The recommended scales for Severity, Occurrence, and Detection are shown below:

FMEA Analysis

Click Risk Priority Number (RPN) Sort to sort the rows by RPN in descending order.

FMEA Analysis

Click Revised Risk Priority Number Sort to sort the rows by Revised RPN in descending order.

FMEA Analysis

Click Row Number Sort to restore the FMEA worksheet to the original row order (ascending).

FMEA Analysis


Quality Function Deployment (QFD) Example

Click SigmaXL > Templates & Calculators > DMAIC & DFSS Templates > Quality Function Deployment (QFD) > 10 by 10 QFD (or 20 by 20, 30 by 30) to access the Quality Function Deployment (QFD) template. Enter data as shown.

Quality Function Deployment


Pugh Concept Selection Matrix Example

Click SigmaXL > Templates & Calculators > DMAIC & DFSS Templates > Pugh Concept Selection Matrix to access the Pugh Concept Selection Matrix template. Enter data as shown.

Pugh Concept Selection Matrix  

Control Plan

Click SigmaXL > Templates & Calculators > DMAIC & DFSS Templates > Control Plan to access the Control Plan template.

Control Plan


Click here to download a Free 30-Day Trial.