Page Title Goes Here.
Control Chart Of Individual Data Points
Values
2 UCL
Click Here To Change Y Axis Title
LCL
Mean
0
Test1
Test2
-2 Test3
Test4 4
Test5 5
-4 Test6 6
7
Test7 8
Test8
-6
15-May-03
15-May-03
15-May-03
16-May-03
16-May-03
17-May-03
17-May-03
18-May-03
18-May-03
19-May-03
19-May-03
20-May-03
20-May-03
21-May-03
21-May-03
22-May-03
22-May-03
26-May-03
26-May-03
27-May-03
28-May-03
Click Here To Change X Axis Title
DATA SOURCE
X Axis Labels
Control Chart Of The Moving Range
4
Values
UCL
Click Here To Change Y Axis Title
3 LCL
Mean
2 Test1
Test2
Test3
1 Test4
Test5
0 Test6
Test7
Test8
-1
15-May-03
15-May-03
15-May-03
16-May-03
16-May-03
17-May-03
17-May-03
18-May-03
18-May-03
19-May-03
19-May-03
20-May-03
20-May-03
21-May-03
21-May-03
22-May-03
22-May-03
26-May-03
26-May-03
27-May-03
28-May-03
Click Here To Change X Axis Title
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 8e751a7e-4a5d-466b-b26c-cdab1db870fe.xls, Chart Software written by Paul S. Natanson, P.E.. Printed on 11/16/2011 at
5:26 PM Page 1 of 4
Help Modify These Charts Save A Copy Of This Sheet Show Data Sheet
Modify A Previously Saved Copy Restore From Template
Control Limits - Top Chart Re-name And/Or Move A
License
UCL 1.10532 Previously Saved Sheet
Mean -0.8174
LCL -2.7401 Delete A Previously Saved Copy THERE ARE TWO CONTROL
CHARTS ON EACH SHEET:
Control Tests (Click the boxes to turn the markers on and off.) THE TOP CHART is a graph
1 >3σ from centerline or the actual individual
2 8 pts on same side of centerline data points.
3 6 pts in row all increasing or decreasing
4 14 pts in row alternating up and down THE BOTTOM CHART is a
5 2 of 3 pts > 2σ from centerline on same side graph of the moving range
6 4 of 5 pts > 1σ from centerline on same side (i.e., the absolute value of the
7 15 pts in row within 1σ of centerline on either side difference between
8 8 pts in row more than 1σ from centerline on either side adjacent points).
Number Of Data The MEAN, upper control limit (UCL), and lower control limit (LCL) are all based
Points Used For on only the first few data points. To change the number of data points used in
Control Limits the calculation, enter your value here. If your value is greater than the number
5 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 2.36147
Mean 0.72282
LCL 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 8e751a7e-4a5d-466b-b26c-cdab1db870fe.xls, Chart Software written by Paul S. Natanson, P.E.. Printed on 11/16/2011 at
5:26 PM Page 2 of 4
ControlChart Abbreviated Instructions 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.
What it does
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 8e751a7e-4a5d-466b-b26c-cdab1db870fe.xls, Instructions Software written by Paul S. Natanson, P.E.. Printed on
11/16/2011 at 5:26 PM Page 3 of 4
rocess is out of control
w the instructions.
This Sheet" button.
ontrol tests, that
the "Number Of
e 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 8e751a7e-4a5d-466b-b26c-cdab1db870fe.xls, Instructions Software written by Paul S. Natanson, P.E.. Printed on
11/16/2011 at 5:26 PM Page 4 of 4