The following Advanced features are available.

Advanced	Description
PCC	Process Capability Calculations
GRR	Gauge Repeatability & Reproducibility
PCA	Partial Component Analysis
NSQC	Nested SQC Charts
Online	Online Version Setup

Online SQC for Excel™ The Advanced SQC for Excel™ updates all worksheets selected in the Analysis dialog. To ensure that the Advanced SQC for Excel™    program does all calculations on time, please follow these steps: From the SQC menu, choose the Analysis option. Change the parameters to get the following setup:                     Click on the NEXT button. Select the worksheet TAB labeled "Online".   Set the following Parameters Variable Description Value Start and Stop Button These buttons start and stop Advanced 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 Advanced 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!C12 B14 à =Calculation!C11 Reports and Saving This option allows the user to print a report and save the data to a disk. Select both options. Save the Spreadsheet as ONLINE.XLS   Setting the external data generator Do the following steps to start the SQC_DDE: Double click on SFX_DDE.EXE file in the SQC folder Set the parameters as shown above Check mark the Start Sending data Check that the values in Data row in the ONLINE.XLS file is changing. Starting the Online SQC for Excel™ Once the external data is being forwarded to the Online.XLS, you can start the Advanced SQC for Excel™ program with the following steps: From SQC menu, choose Report and set it as shown below.                       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.   Checking the results SQC for Excel™ automatically updates all relevant calculations and charts in the online spreadsheet.