SPC with enable

Abstract

This paper describes a set of spreadsheets which perform the calculations necessary to plot control charts used in statistical process control (SPC). The Enable office automation package was used to develop the spreadsheets. The SPC package is menu driven and includes on-line help. A full on-line manual provides program documentation. The control charts are Individual and Moving Average/Moving Range Charts, X-Bar and Range Charts, Proportion Defective (p) Chart, Number Defective (np) Chart, Defects per Unit (c and u) Charts and Weighted Defects per Unit (D) Chart. The paper describes each of the charts and tells how to select the correct SPC control chart for a given application. Completed charts and spreadsheets are also given.<>