100% found this document useful (7 votes)
2K views4 pages

SPC Format

Just put values and get the result with Process parameters and Control charts.. it is very useful in manufcturing scenario..

Uploaded by

Ashish Gupta
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS or read online on Scribd
100% found this document useful (7 votes)
2K views4 pages

SPC Format

Just put values and get the result with Process parameters and Control charts.. it is very useful in manufcturing scenario..

Uploaded by

Ashish Gupta
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS or read online on Scribd
You are on page 1/ 4

No.

X-R CONTROL CHART Date-

CUSTOMER SUPPLIER INSTRUMENT


PART NAME OPERATION LEAST COUNT
PART NO OPERATION NO PARAMETER
SPECIFICATIONS UTL LTL SPECIFICATIONS WIDTH(S)=UTL-LTL= 0.000

[Link]. 1 2 3 4 5 6 7 8 9 10 Constants Design Centre(D)


1 Group Size 5 Process Centre=X bar(a)
2 d2 2.33 Process shift Design Centre
3 D3 0 Process Width
4 D4 2.11
5 A2 0.58
Calculations : .
xbar #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! X bar(a) #DIV/0!
[Link].(σ)=R-Bar/d2
x max Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 X max Err:502

x min Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 X Min Err:502 UCLX-bar=Xbar(a)+A2 x R-Bar

LCLX-bar=Xbar(a)+A2 x R-Bar
Range=R Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 R-Bar Err:502

UCLR-bar=D4 x R-Bar
HISTOGRAM X-BAR CHART R-BAR CHART LCLR-bar=D3 x R-Bar

40 1 1
UTL(Design) 0.000 LTL (Design) 0.000 0.9 LCLR-bar
UCLRbar CpUTL =UTL-Xbar(a)/3σ
0.9
Class35
Interval 0.0000 [Link] Class 10
0.8 UCLX-Bar L CLXbar Xbar Xbarbar 0.8 1 ### Err:502 Err:502 ###
Sample
30size 50 Cum. 0.7 1 Err:502 Err:502 #DIV/0! #DIV/0! 0.7 2 ### Err:502 Err:502 ### CpLTL =Xbar(a)-LTL/3σ
Class Frequenc
Class Interval Frequenc 0.6 2 Err:502 Err:502 #DIV/0! #DIV/0! 0.6 3 ### Err:502 Err:502 ###
Frequency

25 Marks y

SIZE
SIZE

0.0000 0.0000 0.0000 y


### 0.5
### 3 Err:502 Err:502 #DIV/0! #DIV/0! 0.5 4 ### Err:502 Err:502 ### Potential Capability Index
20 0.0000 0.0000 0.0000 ### ###
0.4 4 Err:502 Err:502 #DIV/0! #DIV/0! 0.4 5 ### Err:502 Err:502 ### (Cp)=((UTL-LTL)/6σ
0.0000 0.0000 0.0000 ### ### 5 Err:502 Err:502 #DIV/0! #DIV/0! 6 ### Err:502 Err:502 ###
0.3 0.3
15 0.0000 0.0000 0.0000 ### ### 6 Err:502 Err:502 #DIV/0! #DIV/0! 7 ### Err:502 Err:502 ### Actual Capability Index
0.2 0.2
10 0.0000 0.0000 0.0000 ### ### 7 Err:502 Err:502 #DIV/0! #DIV/0! 8 ### Err:502 Err:502 ### (Cpk)=Min(CpUTL,CpLTL)
0.1 0.1
0.0000 0.0000 0.0000 ### ### 8 Err:502 Err:502 #DIV/0! #DIV/0! 9 ### Err:502 Err:502 ###
0
5 0.0000 0.0000 0.0000 ### ### 9 Err:502 Err:502 #DIV/0! #DIV/0! 0 10 ### Err:502 Err:502 ### #DIV/0!
0.0000 0.0000 0.0000 ### ### Ro Ro 10
Ro Err:502
Ro Ro Ro Ro Ro
Err:502 Ro Ro
#DIV/0! #DIV/0! Ro Ro Ro Ro Ro Ro Ro Ro Ro Ro
0.0000 0.0000 0.0000 ### ### w w w w w w w w w w w w w w w w w w w w
0 0.0000 0.0000 0.0000 50 ###
29 30 31 32 33 34 35 36 37 38 28 29 30 31 32 33 34 35 36 37
0.

0.

0.
0
0
0
0

0
0
0
0

0
0
0
0

Prepared By Approved By
0.000
#DIV/0!
#DIV/0!
Err:502

Err:502

Err:502

Err:502

Err:502
Err:502

#DIV/0!

#DIV/0!

###
#DIV/
0!
#DIV/0!

You might also like