 |
|
|
|
|
|
|
|
|
| Buy Today (below) and send us your order ID and claim over $70.00 worth of FREE software |
|---|
Screen Shots
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.
![[SQC for Excel Selected Data]](http://www.baran-systems.com/New/Products/SQC_For_Excel/C_StepbyStep/sfx97_d01.gif)
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.
![[Select SQC for Excel Parameters 1/4]](http://www.baran-systems.com/New/Products/SQC_For_Excel/C_StepbyStep/sfx97_d02.gif)
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.
Programs
MS Excel B- Run a Sample Case
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.
Special! Free Choice of Complete Excel Training Course OR Excel Add-ins 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 [email protected] 31 days after purchase date.
$99.00 
Secure Payment Options$149.00
Secure Payment Options
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 & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To...... | Analyzer Excel | Downloader Excel
| MSSQL Migration
Toolkit |
Monte Carlo Add-in |
Excel
Costing Templates