标准下载论坛

标题: 请教各位 这个SPC表格有问题吗 [打印本页]
作者: 9000    时间: 2011-10-26 23:25
标题: 请教各位 这个SPC表格有问题吗

Pict


锻打

40.000


40.47

A1

爪极


DJ002

41.500



40.21

10只/次

ZJ008


游标卡尺

39.000



39.94

ZJ11008

邓道宇



























本月的spc情況数据分析

9:10
9:40
9:50
10:20
10:40
11:00
11:20
11:40
12:00
13:00
13:20
13:40
13:59
14:20
14:40
15:00
15:20
15:40
16:00
16:20



40.410
40.120
40.220
40.120
40.450
40.540
40.440
40.000
39.220
39.240
40.240
40.250
40.140
40.200
39.890
40.550
40.460
40.380
40.500
40.400

Sigma
0.353

Cpk
0.986


40.500
40.250
40.330
40.540
40.000
40.120
40.230
40.100
39.420
39.110
40.250
40.010
40.250
40.250
40.460
40.560
40.440
40.400
40.520
40.260

Cp
1.182

Ca
0,K40),(Y13-I2)/((G3-G4)/2),"0"))'>16.62%


40.230
40.320
40.350
40.500
40.200
40.230
40.420
39.400
40.110
39.450
40.480
40.250
40.100
40.260
40.580
40.600
40.460
40.240
40.240
40.270

UCL
40.471

CL
40.208


40.740
40.540
40.450
40.100
40.140
40.120
40.400
39.240
40.250
39.680
40.000
40.360
39.880
40.360
40.480
40.540
40.480
40.260
40.260
40.280

LCL
39.944

A2=
0.580


40.450
40.440
40.400
40.450
39.880
40.410
40.560
39.420
40.460
39.470
39.250
40.100
39.860
40.280
40.460
40.580
40.480
40.280
40.270
40.260

D3=
0

Pict Pict D4=
2.110
作者: 9000    时间: 2011-10-26 23:25

Pict

Pict
0,AVERAGE(C8:C17),"")'>40.466
0,AVERAGE(D817),"")'>40.334
0,AVERAGE(E8:E17),"")'>40.350
0,AVERAGE(F8:F17),"")'>40.342
0,AVERAGE(G8:G17),"")'>40.134
0,AVERAGE(H8:H17),"")'>40.284
0,AVERAGE(I8:I17),"")'>40.410
0,AVERAGE(J8:J17),"")'>39.632
0,AVERAGE(K8:K17),"")'>39.892
0,AVERAGE(L817),"")'>39.390
0,AVERAGE(M8:M17),"")'>40.044
0,AVERAGE(N8:N17),"")'>40.194
0,AVERAGE(O8:O17),"")'>40.046
0,AVERAGE(P817),"")'>40.270
0,AVERAGE(Q817),"")'>40.374
0,AVERAGE(R8:R17),"")'>40.566
0,AVERAGE(S8:S17),"")'>40.464
0,AVERAGE(T8:T17),"")'>40.312
0,AVERAGE(U8:U17),"")'>40.358
0,AVERAGE(V8:V17),"")'>40.294
0,AVERAGE(W8:W17),"")'>

0,AVERAGE(C18:W18),"")'>40.208


0,MAX(C8:C17)-MIN(C8:C17),"")'>0.510
0,MAX(D817)-MIN(D817),"")'>0.420
0,MAX(E8:E17)-MIN(E8:E17),"")'>0.230
0,MAX(F8:F17)-MIN(F8:F17),"")'>0.440
0,MAX(G8:G17)-MIN(G8:G17),"")'>0.570
0,MAX(H8:H17)-MIN(H8:H17),"")'>0.420
0,MAX(I8:I17)-MIN(I8:I17),"")'>0.330
0,MAX(J8:J17)-MIN(J8:J17),"")'>0.860
0,MAX(K8:K17)-MIN(K8:K17),"")'>1.240
0,MAX(L817)-MIN(L817),"")'>0.570
0,MAX(M8:M17)-MIN(M8:M17),"")'>1.230
0,MAX(N8:N17)-MIN(N8:N17),"")'>0.350
0,MAX(O8:O17)-MIN(O8:O17),"")'>0.390
0,MAX(P817)-MIN(P817),"")'>0.160
0,MAX(Q817)-MIN(Q817),"")'>0.690
0,MAX(R8:R17)-MIN(R8:R17),"")'>0.060
0,MAX(S8:S17)-MIN(S8:S17),"")'>0.040
0,MAX(T8:T17)-MIN(T8:T17),"")'>0.160
0,MAX(U8:U17)-MIN(U8:U17),"")'>0.280
0,MAX(V8:V17)-MIN(V8:V17),"")'>0.140
0,MAX(W8:W17)-MIN(W8:W17),"")'>

0,AVERAGE(C19:W19),"")'>0.455

0, 24, 23, 17, 1, 0, 25, 6 Pict























SUL规格上限
41.50
41.50
41.50
41.50
41.50
41.50
41.50
41.50
41.50
41.50
41.50
41.50
41.50
41.50
41.50
41.50
41.50
41.50
41.50
41.50

SLL规格下限
39.00
39.00
39.00
39.00
39.00
39.00
39.00
39.00
39.00
39.00
39.00
39.00
39.00
39.00
39.00
39.00
39.00
39.00
39.00
39.00

UCL管制上限
40.47
40.47
40.47
40.47
40.47
40.47
40.47
40.47
40.47
40.47
40.47
40.47
40.47
40.47
40.47
40.47
40.47
40.47
40.47
40.47

CL中心線
40.21
40.21
40.21
40.21
40.21
40.21
40.21
40.21
40.21
40.21
40.21
40.21
40.21
40.21
40.21
40.21
40.21
40.21
40.21
40.21
作者: 9000    时间: 2011-10-26 23:25

Pict

LCL管制下限
39.94
39.94
39.94
39.94
39.94
39.94
39.94
39.94
39.94
39.94
39.94
39.94
39.94
39.94
39.94
39.94
39.94
39.94
39.94
39.94

























































































R























CL中心線
0.96
0.96
0.96
0.96
0.96
0.96
0.96
0.96
0.96
0.96
0.96
0.96
0.96
0.96
0.96
0.96
0.96
0.96
0.96
0.96
0.96

UCL管制上限
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
























0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
作者: 9000    时间: 2011-10-26 23:26

Pict













































Deveation No : （不良情況说明）











































Pict Pict =
40.200






















=
0.400












































UCL=
0.96





















23, 0, 41, 109, 23, 0, 41, 64
LCL=
0
作者: 星空    时间: 2011-10-26 23:26
老兄，你的这个看都看不清楚啊，
作者: 菜蜂    时间: 2011-10-26 23:26
大哥你传个附件上来，大家给你研究研究撒



欢迎光临 标准下载论坛 (http://bbs.bzxzk.net/) Powered by Discuz! X3.2