标准下载论坛

 找回密码
 注册
搜索
热搜: 活动 交友 安全
查看: 797|回复: 5
打印 上一主题 下一主题

请教各位 这个SPC表格有问题吗

[复制链接]
跳转到指定楼层
1#
发表于 2011-10-26 23:25:42 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式

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
2#
 楼主| 发表于 2011-10-26 23:25:48 | 只看该作者

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

3#
 楼主| 发表于 2011-10-26 23:25:54 | 只看该作者

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
4#
 楼主| 发表于 2011-10-26 23:26:00 | 只看该作者

Pict













































Deveation No : (不良情況说明)












































Pict Pict =

40.200






















=

0.400












































UCL=

0.96





















23, 0, 41, 109, 23, 0, 41, 64

LCL=

0
5#
发表于 2011-10-26 23:26:06 | 只看该作者
老兄,你的这个看都看不清楚啊,
6#
发表于 2011-10-26 23:26:12 | 只看该作者
大哥你传个附件上来,大家给你研究研究撒
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|标准下载库

GMT+8, 2024-11-24 17:38 , Processed in 0.076352 second(s), 18 queries .

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表