SQC for Excel ™ is a Microsoft® Excel add-in program for developing statistical Quality Control (SQC) and Statistical Process Control (SPC) calculations, reports and charts automatically. 

The SQC for Excel™ program can be used to analyze any valid data available within the Microsoft Excel® spreadsheet.  The data is copied to a SQC spreadsheet with references back to the original spreadsheet or as value. By using the link any future changes in the original data will result in automatic re-calculation of all charts and limits. To analyze a data set, highlight all the data points to be processed.

Then choose SQC from the Excel main menu.

From SQC Menu, choose New option. The SQC chart selection wizard will provide the user with the appropriate dialog boxes to choose all necessary parameters. A simple example is shown below.

Enter the user parameters and click on NEXT button.

You can define the type of raw data for the SQC for Excel program. The data is then copied to a new spreadsheet with the required links.

Next you need to specify the analysis type, kind of control charts and any advanced feathers. Each of the above selection have their own properties that can be set to the correct value. For example the control chart properties dialog box is shown below.

The user can select varieties of reports to be generated automatically.

All calculations and equations are explained in detail.

In this example X-Bar, R, Histogram and Auto-correlation charts are plotted automatically from the data selected in the spreadsheet.

 

 

Process capabilities are calculated as:

The advanced charts such as EWMA, CUSUM or Trend charts can be done with just selecting one button.

 

 

The following example provides you with the details of how to use the SQC for Excel program.

A- Start the SQC for Excel program.

• Choose the following option from the Excel menu:
• Start  Programs MS Excel

B- Run a Sample Case

• Choose the following option from the Excel menu:
• SQC Cases [2] Case B - X and Moving Range Chart

Follow the instructions and pay attention to the selections. Click OK

C- The program automatically opens the file CASES.XLS and selects the data with a the first row containing the LABEL and DIAMETER labels. There are 20 data sub-groups.

Click the Next button.

D- The data has a Header row and the appropriate option is checked in the "Header information" selection box.

Click the Next button.

E- The X and MR (Moving Range) chart is selected.

Click the Next button.

F- This dialog box sets the PRINT option.

Click the Finished Button.

G- In the worksheet "Charts" the SQC Charts are plotted.

The Calculation is shown in the worksheet "Calculation"

The "Auto Correlation" worksheet display the AUTO-CORRELATIONS of data.

The data process capabilities are show in the "Capability" worksheet.