Scribd
Upload
24 views4 pages

Using SPC For MS Excel v2

The document provides a step-by-step guide on how to create and update a c control chart using SPC for MS Excel v2.0 to track OSHA recordable injuries in a plant. It outlines the process of entering data, generating the chart, and updating it with new information. The example includes historical data and demonstrates how to interpret the generated chart with average and upper control limits.

Uploaded by

kaultobolega
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
24 views4 pages

Using SPC For MS Excel v2

The document provides a step-by-step guide on how to create and update a c control chart using SPC for MS Excel v2.0 to track OSHA recordable injuries in a plant. It outlines the process of entering data, generating the chart, and updating it with new information. The example includes historical data and demonstrates how to interpret the generated chart with average and upper control limits.

Uploaded by

kaultobolega
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

Using SPC for MS Excel v2.

c Control Charts

You are tracking the number of OSHA recordable injuries per month in a plant, and you
want to use a c chart to monitor the safety performance over time. You have historical
data for the past two years. The steps below demonstrate how to construct and update a c
control chart using SPC for MS Excel v2.0.

Step 1: Enter the data into an Excel spreadsheet.

Step 2: Highlight the month numbers (shown in blue above) and select the attribute
control chart icon on the SPC toolbar (installed when you install SPC for MS Excel v2.0).
Step 3: You will get the dialog box shown below. Fill in the chart name and other
information in the dialog box.

Step 4: Click OK and the chart below is generated.

c Chart: Plant Injuries (Avg=1.5, UCL=5.2, LCL=None for subgroups Jan-01-Dec-02)

UCL
5

4
Number of Injuries

Avg

0
May-01

May-02
Nov-01

Nov-02
Apr-01

Apr-02
Jan-01

Feb-01

Mar-01

Jun-01

Jul-01

Aug-01

Sep-01

Oct-01

Dec-01

Jan-02

Feb-02

Mar-02

Jun-02

Jul-02

Aug-02

Sep-02

Oct-02

Dec-02
The above chart can be updated easily.

Step 1: Enter the new data into the spreadsheet as shown below.

Step 2: Select the Update icon from the SPC toolbar.

Step 3: Select the name of the chart from the drop down list that appears and select OK.

The chart is then updated automatically as shown below.


Number of Injuries

0
1
2
3
4
5
6
Jan-01

Avg
UCL
Feb-01

Mar-01

Apr-01

May-01

Jun-01

Jul-01

Aug-01

Sep-01

Oct-01

Nov-01

Dec-01

Jan-02

Feb-02

Mar-02

Apr-02

May-02

Jun-02

Jul-02

Aug-02

Sep-02
c Chart: Plant Injuries (Avg=1.6, UCL=5.5, LCL=None for subgroups Jan-01-Jan-03)

Oct-02

Nov-02

Dec-02

Jan-03

You might also like