Library

Open Access

Performance Gap Matrix template

by McCain, Cecelia

The performance gap matrix is used to identify the performance gaps between one organization and a best practice leader by reducing data to common denominators. Complete instructions are included in the file...

  • Filetype: doc
  • Keywords:Tools and Templates, DMAIC: Define
Open Access

Virtual (CNC) Machine Spreadsheet

by Christolear, Dean

This spreadsheet simulates a Computer Numerical Control (CNC) shaft machining operation. Changes can be made to the Spindle Speed, Feed Rate and Depth of Cut. A single pass or double pass program can be selected. You can Copy/Paste the resulting data into..

  • Filetype: xls
  • Keywords:Tools and Templates, DMAIC: Improve
Open Access

Sigma and Cost of Quality Calculator

by Maxwell, Steve

This is a quick tool which can be used anytime in a Six Sigma project which automatically calculates the sigma levels and cost of quality based upon units produced, units consumed, defects and unit price. This tool is pretty basic but is handy when you ne..

  • Filetype: xls
  • Keywords:Tools and Templates
Open Access

Assignable Cause Log Template

by McCain, Cecelia

The Assignable Cause Log is used with process measures and control plans to document out-of-control situations occurring from nonrandom or assignable causes. A separate log is maintained for each control plan measure.Write the name of the measure in the C..

  • Filetype: doc
  • Keywords:Tools and Templates, DMAIC: Control
Open Access

Problem Analysis Using Pareto Chart

This is a quick and very basic tool which can be used to capture and analyze problem occurrences..

  • Filetype: xls
  • Keywords:Tools and Templates, DMAIC: Define
Open Access

Quincunx Simulator

by Christolear, Dean

This spreadsheet allows the user to perform experiments using the classic bead drop method of a Quincunx. Red beads are held in the container at the top of the page. A funnel at the bottom of the container allows one bead to be dropped into the Quincunx...

  • Filetype: xls
  • Keywords:Tools and Templates, DMAIC: Analyze
Open Access

COPQ Template

by Burke, Jamie

This template can be used to document and create a baseline of costs associated with materials, and resources along with failure costs such as internal failures, external failures, appraisal costs and prevention costs...

  • Filetype: xls
  • Keywords:Tools and Templates, DMAIC: Measure
Open Access

3 Factor DOE

by Christolear, Dean

Allows the user to perform a 3 factor, full factorial DOE. Three factors can be studied to determine the effect of each on the desired output. The main effect of the factors, as well as their interactions, is displayed numerically and graphically. The spr..

  • Filetype: xls
  • Keywords:Tools and Templates, DMAIC: Improve
Open Access

Process Capability Study

by Christolear, Dean

This spreadsheet performs a complete process capability analysis. The data is displayed using a Histogram and SPC charts. The SPC charts are evaluated for eight stability criteria. A capability analysis is performed providing a summary of the process data..

  • Filetype: xls
  • Keywords:Tools and Templates, DMAIC: Measure
Open Access

FMEA Worksheet

by Tonkin, Allan

Failure Modes & Effects Analysis tool..

  • Filetype: xls
  • Keywords:Tools and Templates, DMAIC: Analyze

ASQ News

 

Lean & Six Sigma Review
Process Improvement Using Six Sigma - A webinar in process improvement