1	BaRaN Systems LLC BaRaN Systems LLC is a leader in providing quality control software and add-ins for Microsoft Excel and Microsoft Access spreadsheets. Founded in 1991, the company provides consulting, specialized software development and Statistical Quality Control (SQC) and Statistical Process Control (SPC) software for PC and Macintosh platforms. This presentation provides pictorial demonstration of the functionality of SQC for Excel™ product.
2	Quality Control Products The following products are available from us:
3	SQC for Excel™ SQC for Excel ^TM add-ins for MS Excel is designed to provide Quality Control experts with all of the essential statistical quality control functionality within the spreadsheet environment. Some of the functionality can be summarized as: All SQC Variable charts such as X-Bar, X, Range, Moving Range, Individual, S, Trend, EWMA and CUSUM. All SQC Attribute charts such as P chart, nP chart, u chart, c chart. Auto-correlation. Histogram and normal distribution. On-line connection to Microsoft External Data Exchange. Nested SQC chart. Multivariate SQC chart. On-line Charting with any of the above charts.
4	Install The Product
5	Install The Product
6	Install The Product
7	Install The Product
8	Install The Product
9	Install The Product
10	Install The Product
11	Install The Product
12	Install The Product
13	Install The Product
14	Install The Product
15	Install The Product
16	Install The Product
17	Install The Product
18	Install The Product
19	Install The Product
20	Install The Product
21	Install The Product
22	Install The Product
23	Install The Product
24	Install The Product
25	Install The Product
26	Install The Product
27	SQC for Excel™
28	Step 1 – Install it
29	Step 2A –Select Data
30	Step 2B – Select Type of Data
31	Step 2C – Select Type of Control Charts
32	Step 2D – Review the results
33	Step 2E – Review the Multi-Zone Results
34	Step 2F – Review the Auto-Correlation
35	Step 2G – Add USL and LSL
36	Step 2G – Review Process Capability
37	Step 2H – Review Histogram
38	How to Add New Data
39	How to Add New Data - Continued Assume you have 30 sub-groups of data (each sub-group contains 5 measurements) Data from 1-Jul-2001 to 30-Jul-2001 Select the data
40	How to Add New Data - Continued Generate the SQC chart
41	How to Add New Data - Continued Generate the SQC chart
42	How to Add New Data - Continued Generate the SQC chart
43	Method I: Use the Menu Option Add a new sub-group ( a new set of 5 data points has arrived) 31-Jul-01 100.20 100.41 100.55 100.10 100.54
44	Method I: Use the Menu Option Add a new sub-group ( a new set of 5 data points has arrived) 31-Jul-01 100.20 100.41 100.55 100.10 100.54
45	Method II: Add the data to the ORIGINAL file. Add a new sub-group ( a new set of 5 data points has arrived) 31-Jul-01 100.20 100.41 100.55 100.10 100.54 1- Add the data to the ORIGINAL DATA file. 2- Select the NEW data in the ORIGINAL DATA file.
46	Method II: Add the data to the ORIGINAL DATA file. Add a new sub-group ( a new set of 5 data points has arrived) 31-Jul-01 100.20 100.41 100.55 100.10 100.54 1- Select the NEW data in the ORIGINAL DATA file 2- Choose LOAD DATA from SQC Menu
47	Method II: Add the data to the ORIGINAL DATA file. Add a new sub-group ( a new set of 5 data points has arrived) 31-Jul-01 100.20 100.41 100.55 100.10 100.54 1- Select the NEW data in the ORIGINAL DATA file 2- Choose LOAD DATA from SQC Menu
48	Method III: Add the data to the ORIGINAL DATA file. and analyze ALL of the data 1- Select the NEW data in the ORIGINAL DATA file 2- Choose LOAD DATA from SQC Menu 3- Follow all previous procedures
49	Method III: Add the data to the ORIGINAL DATA file and analyze ALL of the data 1- Select the NEW data in the ORIGINAL DATA file 2- Choose LOAD DATA from SQC Menu 3- Follow all previous procedures
50	Method III: Add the data to the ORIGINAL DATA file and analyze ALL of the data 1- Select the NEW data in the ORIGINAL DATA file 2- Choose LOAD DATA from SQC Menu 3- Follow all previous procedures
51	BaRaN Systems LLC