control_chart_template

Document Sample
control_chart_template Powered By Docstoc
					                                               CONTROL CHART TEMPLATES

                                          General Concepts and Guidelines for Use:

 + In order to preserve the template, use the "file/save as" function to save the formulas and graph to another file.
 + Data entry sections have been designed and are located on the left hand side of the "template" spreadsheet
 + If additional rows are needed or if rows need to be deleted, delete or insert rows somewhere between the first and last row (instead of
   adding them to the end of the sheet). This will help to eliminate the need to reenter formulas or to change the data ranges for the
   graphs so as to include additional rows.
 + Templates are set up to automatically recalculate values with each data entry although you will need to copy the corresponding cells
   from the sections used for graphing in order for these cells to fill in. Copy cells from the last line of cells that are filled in to get the data
   that has been entered to transfer into the graph sections. This is most easily accomplished by highlighting the cells that you want to
   copy and dragging the corner square of the highlighted section downward.
 + In order to evaluate the effectiveness of a change, it may be necessary to “freeze or possibly change” the parameters of some of the
   calculations (e.g. the mean, UCL, LCL, etc.). Freezing can be accomplished by changing the range of the calculations and “changing
   (i.e. adding a new control limit or mean)” can be accomplished by entering an additional area for calculations and by changing the
   referenced cells on the graph sections.
 + Graphs that feed off of the template sheet are set up and can be found on the sheet next to the template sheet.
 + Titles on the graphs are still needed and should be added using either the “File/Page Set Up/Header Footer” and/or the “Chart/Chart
   Options/Titles” functions
 + When you print the XmR chart, look in page preview to make sure that both charts will print. If it looks as if only one will print, you will
   need to click in the upper right hand corner so that the entire page is selected.



     Note: It is recommended you get some help the first time you use this template.




                                                                                                                 Created by Sandie Amin, RN, MBA
controlcharttemplates.xls                                                                                              MetroHealth Medical Center
6/8/00/sa                                                              Page 1                                             Permission to use if cited
Data Entry Section                   Process Chart


 process average     0.12

                             Note: There is no need to data enter in this section. Fill in the cell
                                   and dragging the formulas or cell references from the last lin



      Date           Value                Date            Value
     Jan-98           0.05               Jan-98            0.05
     Feb-98           0.10               Feb-98         0.097933
     Mar-98           0.07               Mar-98         0.072072
     Apr-98           0.13               Apr-98         0.131212
     May-98           0.21               May-98         0.210149
     Jun-98           0.12               Jun-98         0.120885
     Jul-98           0.17               Jul-98         0.168945
     Aug-98           0.13               Aug-98         0.128991
     Sep-98           0.13               Sep-98         0.128652
     Oct-98           0.09               Oct-98         0.093843
     Nov-98           0.11               Nov-98         0.108234
     Dec-98           0.16               Dec-98          0.16474
     Jan-99           0.21               Jan-99         0.213333
     Feb-99           0.10               Feb-99         0.095034
     Mar-99           0.12               Mar-99         0.117679
     Apr-99           0.16               Apr-99         0.156517
     May-99           0.21               May-99         0.211358
     Jun-99           0.25               Jun-99         0.246385
     Jul-99           0.20               Jul-99         0.196626
     Aug-99           0.16               Aug-99         0.160515
     Sep-99           0.19               Sep-99         0.194603
     Oct-99           0.03               Oct-99         0.034645
     Nov-99           0.06               Nov-99         0.062572
     Dec-99           0.16               Dec-99         0.155666
     Jan-00           0.06               Jan-00         0.063123
     Feb-00           0.16               Feb-00         0.161238
     Mar-00           0.11               Mar-00         0.105407
     Apr-00           0.17               Apr-00         0.170201
     May-00           0.14               May-00          0.13554
     Jun-00           0.18               Jun-00         0.183627
     Jul-00           0.22               Jul-00         0.220349
     Aug-00           0.17               Aug-00         0.168682
     Sep-00           0.32               Sep-00         0.322923
     Oct-00           0.11               Oct-00         0.106302
     Nov-00           0.05               Nov-00         0.046562
     Dec-00           0.07               Dec-00         0.068966
     Jan-01           0.06               Jan-01         0.062847
     Feb-01           0.08               Feb-01         0.075384
     Mar-01           0.07               Mar-01         0.068138
     Apr-01           0.09               Apr-01          0.08589
May-01   0.06   May-01   0.064394
Jun-01   0.05   Jun-01   0.048387
Jul-01   0.07   Jul-01   0.065202
Aug-01   0.08   Aug-01   0.084191
Sep-01   0.09   Sep-01   0.091141
Oct-01   0.12   Oct-01   0.118406
Nov-01   0.11   Nov-01   0.106585
Dec-01   0.11   Dec-01   0.106737
Jan-02   0.07   Jan-02   0.070261
Feb-02          Feb-02
Mar-02          Mar-02
Apr-02          Apr-02
May-02          May-02
Jun-02          Jun-02
Jul-02          Jul-02
Aug-02          Aug-02
Sep-02          Sep-02
Oct-02          Oct-02
Nov-02          Nov-02
Dec-02          Dec-02
                                                                    Moving Range Chart


                                                                           Average mR        0.0489

to data enter in this section. Fill in the cells by highlighting                  Note: There is no need to data enter in
formulas or cell references from the last line that is filled in.                       and dragging the formulas or ce

                                                                                  Note: The first value in the Moving Ran

                 Process Average            UCL         LCL               Date           Moving Range
                       0.12                 0.26        0.00             Jan-98
                       0.12                 0.26        0.00             Feb-98              0.0479
                       0.12                 0.26        0.00             Mar-98              0.0259
                       0.12                 0.26        0.00             Apr-98              0.0591
                       0.12                 0.26        0.00             May-98              0.0789
                       0.12                 0.26        0.00             Jun-98              0.0893
                       0.12                 0.26        0.00             Jul-98              0.0481
                       0.12                 0.26        0.00             Aug-98              0.0400
                       0.12                 0.26        0.00             Sep-98              0.0003
                       0.12                 0.26        0.00             Oct-98              0.0348
                       0.12                 0.26        0.00             Nov-98              0.0144
                       0.12                 0.26        0.00             Dec-98              0.0565
                       0.12                 0.26        0.00             Jan-99              0.0486
                       0.12                 0.26        0.00             Feb-99              0.1183
                       0.12                 0.26        0.00             Mar-99              0.0226
                       0.12                 0.26        0.00             Apr-99              0.0388
                       0.12                 0.26        0.00             May-99              0.0548
                       0.12                 0.26        0.00             Jun-99              0.0350
                       0.12                 0.26        0.00             Jul-99              0.0498
                       0.12                 0.26        0.00             Aug-99              0.0361
                       0.12                 0.26        0.00             Sep-99              0.0341
                       0.12                 0.26        0.00             Oct-99              0.1600
                       0.12                 0.26        0.00             Nov-99              0.0279
                       0.12                 0.26        0.00             Dec-99              0.0931
                       0.12                 0.26        0.00             Jan-00              0.0925
                       0.12                 0.26        0.00             Feb-00              0.0981
                       0.12                 0.26        0.00             Mar-00              0.0558
                       0.12                 0.26        0.00             Apr-00              0.0648
                       0.12                 0.26        0.00             May-00              0.0347
                       0.12                 0.26        0.00             Jun-00              0.0481
                       0.12                 0.26        0.00             Jul-00              0.0367
                       0.12                 0.26        0.00             Aug-00              0.0517
                       0.12                 0.26        0.00             Sep-00              0.1542
                       0.12                 0.26        0.00             Oct-00              0.2166
                       0.12                 0.26        0.00             Nov-00              0.0597
                       0.12                 0.26        0.00             Dec-00              0.0224
                       0.12                 0.26        0.00             Jan-01              0.0061
                       0.12                 0.26        0.00             Feb-01              0.0125
                       0.12                 0.26        0.00             Mar-01              0.0072
                       0.12                 0.26        0.00             Apr-01              0.0178
0.12   0.26   0.00   May-01   0.0215
0.12   0.26   0.00   Jun-01   0.0160
0.12   0.26   0.00   Jul-01   0.0168
0.12   0.26   0.00   Aug-01   0.0190
0.12   0.26   0.00   Sep-01   0.0069
0.12   0.26   0.00   Oct-01   0.0273
0.12   0.26   0.00   Nov-01   0.0118
0.12   0.26   0.00   Dec-01   0.0002
0.12   0.26   0.00   Jan-02   0.0365
                     Feb-02
                     Mar-02
                     Apr-02
                     May-02
                     Jun-02
                     Jul-02
                     Aug-02
                     Sep-02
                     Oct-02
                     Nov-02
                     Dec-02
e is no need to data enter in this section. Fill in the cells by highlighting
dragging the formulas or cell references from the last line that is filled in.

first value in the Moving Range column is always left blank

               Average mR          URL
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
                  0.05             0.16
0.05   0.16
0.05   0.16
0.05   0.16
0.05   0.16
0.05   0.16
0.05   0.16
0.05   0.16
0.05   0.16
0.05   0.16
                          35%

                          30%
Measured Characteristic




                          25%

                          20%

                          15%

                          10%

                          5%

                          0%




                                Value      Process Average      UCL     LCL


                   0.2500


                   0.2000
Moving Range




                   0.1500


                   0.1000


                   0.0500


                   0.0000




                                    Moving Range       Average mR     URL


                                                                              Template created by Sandie Amin, RN, MBA
                                                                                             MetroHealth Medical Center
                                         XmR Chart                                              Permission to use if cited

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:1
posted:2/12/2012
language:
pages:8