
Buy Today (below) and send us your order ID and claim over $70.00 worth of FREE software 

SQC for Excel™ is a Microsoft® Excel addin program for developing statistical Quality Control (SQC) and Statistical Process Control (SPC) calculations, reports and charts automatically.
The main difference between the basic and Premium version of SQC for Excel™ is more functionality, lets go over them one by one.
Please read the following page and fill this table. If you have answered Yes any of the below questions, please order the Premium SQC for Excel™ version.
Functionality  Yes / No  
1  Partial Component Analysis (PCA).  [____] 
2  Nested SQC Charts  [____] 
3  Online  [____] 
4  Changing and Saving Charts format  [____] 
Statistical process control, SPC, is being implemented across the industry without consideration to the multivariable nature of the measurements.
The statistical process control, SPC, and statistical quality control, SQC, foundations are based upon the detection of a statistically significant change in a given process. When a process can be described by a single measurement, such as making an object with a desired length, implementation of these techniques becomes an easy task.
However in the majority of the industries, a given process such as a reactor can not be described completely by a single measurement. Implementation of SQC and SPC technology will yield hundreds of control charts, which will identify some causes, but not the status of the process.
The multivariable nature of processes makes it difficult to provide the unit operator with the information with respect to the health of the process based on SQC and SPC technology due to the number of charts generated.
The PCA technique implemented in the Premium SQC for Excel™ reduce a large multivariable system (i.e. 10 tags with 200 measurements) to a manageable system (i.e. 2 tags with 200 measurement) while preserving most of the information in the original system. Suppose that you have system with 5 measurements as it is shown in the figure below.
Application of normal SQC charts will yield to out of control charts. However, with 3 simple clicks.
 Select the data from the 40^{th} to 140^{th} measurement and Start SQC for Excel™
 Click OK for the data type
 Click OK for the data headers
The SQC chart is in control.
Then select all data (40^{th} to 200^{th} ) and redo the PCA. Observe that the ***
Look at the SQC PCA chart, it takes off after 141 sample, and checking the data shows the first line is draping rapidly.
If you add this functionality to you alarm systems, you can detect run away measurements very easily.
The question is: do you have multivariable data? If so you should purchase Premium SQC for Excel™.
Suppose a process generates 15 batches of a product. For each batch, 2 samples are taken and the thickness of each sample is measured 2 times.
Using the standard SQC charting techniques described in the previous sections, we can analyze the process using XBar and S Charts:
Analyzing the above data yields the following X Bar and S charts:
Question: is your process out of control? With the above technique, you can not be certain.
Considering the above charts, the XBar chart is severely outofcontrol. In interpreting these charts, one should realize that the control limits in the XBar chart were calculated on the basis of the standard deviations within the subgroup on the basis of the withinsample variability. The subsequent subgroups, however, are not only subject to withinsample variability, but also to between sample to sample and batch to batch variability.
What are the sources of variation in a product response? There are three major sources of variation in a process:
1. Measurement variability
2. Sampling variability (within batch)
3. Batch to batch variability
Each of the three sources of variability adds variation or error to the results. The sample pulled from the batch and tested yields to:
E = X  X_{bar} (Average)
Where:
E is the error,
X is the measurement and
X_{bar} (Average) is the population average.
The overall error has three components corresponding to three sources of variations:
E = E _{Batch} + E _{Sample} + E _{Measurement}
Where:
E _{Batch} is the error caused by batch to batch variability,
E _{Sample} is the error caused by batch to sampling variability and
E _{Measurement} is the error caused by batch to measurement variability.
By definition, these errors have zero averages and can be assumed to be represented as normal distributions with fixed variances.
The standard deviation, s , calculated from the data represents an estimate of the combination of these error components.
s ^{2}= s _{Batch} ^{2} + s _{Sample} ^{2} + s _{Measurement}^{2}
Where:
s ^{2 }is the total estimated variable
s _{Batch} ^{2} is the batchtobatch estimated variance
s _{Sample} ^{2} is the sample estimated variance
s _{Measurement} ^{2} is the measurement variance
This is lots of statistics, however, the SQC for Excel™ Premium version makes this very easy to handle.
However, you need to run SQC for Excel™ Premium version and you get the following chart:
Now you can say you are in control. If you have multiple sources of data you should consider Premium SQC for Excel™.
The Premium SQC for Excel™ updates all worksheets selected in the Analysis dialog. To ensure that the Premium SQC for Excel™ program does all calculations on time, please follow these steps:
Variable  Description  Value 
Start and Stop Button  These buttons Start and stop Premium SQC for Excel™.  Do not use now. 
Trigger  External: The content of the cell B3 is changed externally. Internal: The program works at frequency entered in cell B4.  Select Internal trigger and enter 00:01:00 for 1 minute in cell B4. 
Data  The data to be used by Premium SQC for Excel™.  Enter =Now() in cell B8. 
Output  The data to be sent to the External source.  Enter the UCL and LCL from the calculation worksheet. B13 à =Calculation!C12B14 à =Calculation!C11 
Reports and Saving  This option allows the user to print a report and save the data to a disk.  Select both options. 
Do the following steps to Start the SQC_DDE:
Once the external data is being forwarded to the Online.XLS, you can Start the Premium SQC for Excel™ program with the following steps:
In the Online worksheet click on the Start button.
Note: You need to click the STOP button to stop the online program. In case of emergency press the ESCAPE key and then click on the END button. The ESCAPE key will make the program terminate incorrectly and you will need to Start over again.
SQC for Excel™ automatically updates all relevant calculations and charts in the online spreadsheet.
Special! Free Choice of Complete Excel Training Course OR Excel Addins Collection on all purchases totaling over $70.00. ALL purchases totaling over $148.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
Some of our more popular products are below...
Convert Excel Spreadsheets To Webpages  Trading In Excel  Construction Estimators  Finance Templates & Addins Bundle  CodeVBA  SmartVBA  PrintVBA  Excel Data Manipulation & Analysis  Convert MS Office Applications To......  Analyzer Excel  Downloader Excel
 MSSQL Migration
Toolkit 
Monte Carlo Addin 
Excel
Costing Templates