Page Title Goes Here.
Control Chart Of Individual Data Points
2
Click Here To Change Y Axis Title
-2
-4
Column C Column G Column H Column E Column S Column T Column U Column V Column W Column X Column Y Column Z
-6
16-May-03
16-May-03
18-May-03
19-May-03
20-May-03
21-May-03
22-May-03
26-May-03
15-May-03
15-May-03
15-May-03
17-May-03
17-May-03
18-May-03
19-May-03
20-May-03
21-May-03
22-May-03
26-May-03
27-May-03
Click Here To Change X Axis Title
Control Chart Of The Moving Range
4
Click Here To Change Y Axis Title
28-May-03
Column AC Column AF Column AG Column AD Column AR Column AS Column AT Column AU Column AV Column AW Column AX Column AY
-1
15-May-03
16-May-03
17-May-03
18-May-03
20-May-03
21-May-03
22-May-03
26-May-03
Click Here To Change X Axis Title
Filename is 61987161.xls, Chart
Software written by Paul S. Natanson, P.E..
Printed on 07/01/2011 at 01:18:13
28-May-03
15-May-03
15-May-03
16-May-03
17-May-03
18-May-03
19-May-03
19-May-03
20-May-03
21-May-03
22-May-03
26-May-03
27-May-03
Page 1 of 6
Total number of data points is 21 Number of data points used to calculate the upper and lower control limits and the mean is .. 5
Filename is 61987161.xls, Chart
Software written by Paul S. Natanson, P.E..
Printed on 07/01/2011 at 01:18:13
Page 2 of 6
Help
Modify These Charts
Save A Copy Of This Sheet Modify A Previously Saved Copy
Show Data Sheet Restore From Template License
Control Limits - Top Chart
UCL Mean LCL
1.11 -0.82 -2.74
Re-name And/Or Move A Previously Saved Sheet Delete A Previously Saved Copy
THERE ARE TWO CONTROL CHARTS ON EACH SHEET: THE TOP CHART is a graph or the actual individual data points. THE BOTTOM CHART is a graph of the moving range (i.e., the absolute value of the difference between adjacent points).
Control Tests (Click the boxes to turn the markers on and off.)
1 2 3 4 5 6 7 8 >3 from centerline 8 pts on same side of centerline 6 pts in row all increasing or decreasing 14 pts in row alternating up and down 2 of 3 pts > 2 from centerline on same side 4 of 5 pts > 1 from centerline on same side 15 pts in row within 1 of centerline on either side 8 pts in row more than 1 from centerline on either side
Number Of Data Points Used For Control Limits 5
The MEAN, upper control limit (UCL), and lower control limit (LCL) are all based on only the first few data points. To change the number of data points used in the calculation, enter your value here. If your value is greater than the number of data points then all of the data points will be used.
DATA SOURCE X Axis Labels File name ControlChart.xls Sheet name . Data Range of cells . BA11:BA31 Y Values File name ControlChart.xls Sheet name . Data Range of cells . BB11:BB31 Control Limits - Bottom Chart
UCL Mean LCL
2.36 0.72 0
USER NOTES (Notes and comments made outside this area will not be preserved when charts are modified.)
This area is for a place where the user may enter any notes that he or she wishes.
Filename is 61987161.xls, Chart
Software written by Paul S. Natanson, P.E..
Printed on 07/01/2011 at 01:18:13
Page 3 of 6
Filename is 61987161.xls, Chart
Software written by Paul S. Natanson, P.E..
Printed on 07/01/2011 at 01:18:13
Page 4 of 6
ControlChart Abbreviated Instructions
What it does
June 10, 2004
By Paul S. Natanson. P.E. Email: paul628@concentric.net Phone: +1-908-630-0406 (9 AM - 9 PM, Eastern USA time) For a more complete set of instructions, see the users' manual that was shipped with this "ControlChart" product.
This product (called "ControlChart") automates the process of building control charts to help determine when a process is out of control and might need to be repaired or recalibrated.
Build a set of control charts
To build or modify set of control charts on the "Chart" sheet Click on the "Modify These Charts" button and follow the instructions. Warning: This replaces the charts presently on the "Chart" sheet. To save them first, click the "Save A Copy Of This Sheet" button.
Highlight a failed control test
The check boxes allow you to turn the control test markers on and off. When a data point fails one of the eight control tests, that data point will be highlighted with a marker to indicated the failed test (if the checkbox for that test is checked).
Change the control limits
The upper and lower control limits are based on the first several data points. You can use the scroll bar (next to the "Number Of "Data Points - - - " box to change the number of data points that are used in the calculation.
Save a set of charts
To save a copy of the charts that are presently on the "Chart" sheet, click on the "Save A Copy Of This Sheet" button.
Modify or update a set of charts
To modify or update a previously saved set of charts, click on the "Modify A Previously Saved Copy" button. The only charts that can be modified or updated are those on the "Chart" sheet. This button copies the selected charts to the "Chart" sheet where they can be modified. To save the charts on the "Chart" sheet before they are replaced, click the "Save A Copy Of This Sheet" button first.
Rename and/or move a previously saved set of charts
To move or rename a sheet containing a previously saved set of charts in the current workbook, click the "Rename And/Or Move A Previously Saved Sheet" button. (To move or copy to or from other workbooks, see the users' manual.)
Delete a previously saved set of charts
To delete a previously saved set of charts, click on the "Delete A Previously Saved Sheet" button.
Show or hide the temporary intermediate data sheet
To show or hide the temporary intermediate data sheet click on the "Show / Hide The Data Sheet" button.
Recovering from mistakes
Although most operations cannot be undone, nothing is really permanent until you save the workbook. To undo a mistake, simply close the workbook without saving it. Additionally, if your "Chart" sheet becomes corrupted, you can click on the "Restore From Template" button to replace the "Chart" sheet with a template that you can use as a starting point for building new charts.
Becoming an authorized (or re-authorized) user
The "License" button allows you to accept the agreement and use the software. If you make changes to the VB code, you might need to click this button to re-accept the agreement.
Filename is 61987161.xls, Instructions
Software written by Paul S. Natanson, P.E..
Printed on 07/01/2011 at 01:18:13
Page 5 of 6
rocess is out of control
the instructions. This Sheet" button.
ontrol tests, that
the "Number Of
only charts that can et where they can be
he users' manual.)
a mistake, simply close ore From Template"
code, you might need
Filename is 61987161.xls, Instructions
Software written by Paul S. Natanson, P.E..
Printed on 07/01/2011 at 01:18:13
Page 6 of 6
