The data must be collected and stored in a spreadsheet similar to the spreadsheet shown here. There are few important parameters that you need to identify.

1- The number of data points ( In this example there are 5000 data points)

2- The number of decimal points that you would like to present you data ( In this example 5 decimal place is chosen)

3- What is the Upper Specification Limit or USL ( In this Example 0.003 is chosen). This is optional

4- What is the Lower Specification Limit or LSL ( In this Example -0.003 is chosen). This is optional.

Save the spreadsheet.

Please do the following steps:

1- Select the data ( Click on the first cell and then press the SHIFT KEY and click the last cell)

2- Choose New... option from the SQC menu

3- Click the Next button

4- Make sure you have selected the No Header Row option and click the Next button.

Please do the following steps:

1- Make sure you select the Individual option from the Control Charts pull down menu.

2- Click on the Properties button on the Analysis box and enter the following

• Check Box to use USL
• 0.003 for the USL
• Check box to use LSL
• -0.003 for the LSL

as shown below.

You can decide on the Analysis type or the Standard Deviation Method as well in this screen.

3- Click the OK button

4- Click the Next button

5- Click the Finish button.

Please do the following steps:

1- Chose the Setup... option from the SQC menu.

2- Enter 5 as the number of decimal place and click the OK button.

Please do the following steps:

1- Chose the Report... option from the SQC menu. Make sure you select the Histogram and Process Capability options

2- Select the Save Report as MS Word and make sure you type a correct path and file name.

Example: C:\my_report  or C:\SQC_Results\Capability

Make sure that there are no spaces in the folder or file name.

3- Click the Print button.

4- Using MS Explorer open the MS word file that you have created.

The SQC for Excel program uses a MS word template to generate the report. The file is called SQC Report.DOT and is located in the C:\Program Files\BaRaN Systems LLC\SQC for Excel 2002. Wrong modification to this file might result in problem in generating the correct report. Therefore make sure you make a backup of this file for future use.

Please do the following steps to modify the MS Word template.

1- Use MS Explorer and find the SQC Report.dot file

2- Click on the file name with the RIGHT MOUSE and then select the Open option.

3- Select the Options... option from the Tools menu and then click on the View tab.

4- Make sure that the Bookmarks option is selected.

5- Select the Bookmarks option from the View menu.

Please note that for each report type in the SQC for Excel, there is an equivalent book mark. Selecting the bookmark and click on the Go To button will move the MS Word cursor to the location of the bookmark.

You can modify the SQC Report.DOT file as much as you like as long as

A- The file name is kept as SQC Report.DOT

B- It is stored where SQC for Excel Program resides.

C- None of the bookmarks are not deleted ( They can be in different locations)

6- For example, the file is modified and saved to have the Capability and Histogram shown.

Lots of parameters are set to generate the reports, you can save all of the for the next time you are going to do the similar job.

Please do the following:

1- Select the Setup... from the SQC menu

2- Click on the Save button and select an Un-Used User Case ( Case 6 in this example) and click the OK button.

3- Type in a name that you can recall next time and click the OK button.

4- Next time you want to do the analysis, collect your data, and select New.. from SQC menu

5- Make sure you select the case that you have entered as shown below.

6- Click the Finish button to get your results.