Library

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

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

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

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

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

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

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

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

FMEA Worksheet

by Tonkin, Allan

Failure Modes & Effects Analysis tool..

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

Process Control Plan Worksheet

by Tonkin, Allan

This tool helps individuals and users document a Process Control Plan during the Improve and Control phase of a DMAIC project..

• Filetype: xls
• Keywords:Tools and Templates, DMAIC: Improve;DMAIC: Control