请教各位 这个SPC表格有问题吗
Pict
- R Control Chart
机种锻打規格中心值=40.0040.000X-barUCL40.47班组A1品名爪极
机台编号DJ002規格上限值41.500上限公差1.50CL40.21频率10只/次图号ZJ008
量測工具游标卡尺規格下限值39.000下限公差1.00LCL39.94模具号ZJ11008制表者邓道宇
Item1234567891011121314151617181920 SPC
抽樣時間2011年4月22日 本月的spc情況数据分析
9:109:409:5010:2010:4011:0011:2011:4012:0013:0013:2013:4013:5914:2014:4015:0015:2015:4016:0016:20
Measurement Data (量測数据)140.41040.12040.22040.12040.45040.54040.44040.00039.22039.24040.24040.25040.14040.20039.89040.55040.46040.38040.50040.400 Sigma0.353
Cpk0.986
240.50040.25040.33040.54040.00040.12040.23040.10039.42039.11040.25040.01040.25040.25040.46040.56040.44040.40040.52040.260 Cp1.182
Ca0,K40),(Y13-I2)/((G3-G4)/2),"0"))'>16.62%
340.23040.32040.35040.50040.20040.23040.42039.40040.11039.45040.48040.25040.10040.26040.58040.60040.46040.24040.24040.270 UCL40.471
CL40.208
440.74040.54040.45040.10040.14040.12040.40039.24040.25039.68040.00040.36039.88040.36040.48040.54040.48040.26040.26040.280 LCL39.944
A2=0.580
540.45040.44040.40040.45039.88040.41040.56039.42040.46039.47039.25040.10039.86040.28040.46040.58040.48040.28040.27040.260 D3=0
Pict Pict
D4=
2.110
Pict
0,AVERAGE(C8:C17),"")'>40.4660,AVERAGE(D8:D17),"")'>40.3340,AVERAGE(E8:E17),"")'>40.3500,AVERAGE(F8:F17),"")'>40.3420,AVERAGE(G8:G17),"")'>40.1340,AVERAGE(H8:H17),"")'>40.2840,AVERAGE(I8:I17),"")'>40.4100,AVERAGE(J8:J17),"")'>39.6320,AVERAGE(K8:K17),"")'>39.8920,AVERAGE(L8:L17),"")'>39.3900,AVERAGE(M8:M17),"")'>40.0440,AVERAGE(N8:N17),"")'>40.1940,AVERAGE(O8:O17),"")'>40.0460,AVERAGE(P8:P17),"")'>40.2700,AVERAGE(Q8:Q17),"")'>40.3740,AVERAGE(R8:R17),"")'>40.5660,AVERAGE(S8:S17),"")'>40.4640,AVERAGE(T8:T17),"")'>40.3120,AVERAGE(U8:U17),"")'>40.3580,AVERAGE(V8:V17),"")'>40.2940,AVERAGE(W8:W17),"")'> =0,AVERAGE(C18:W18),"")'>40.208
R0,MAX(C8:C17)-MIN(C8:C17),"")'>0.5100,MAX(D8:D17)-MIN(D8:D17),"")'>0.4200,MAX(E8:E17)-MIN(E8:E17),"")'>0.2300,MAX(F8:F17)-MIN(F8:F17),"")'>0.4400,MAX(G8:G17)-MIN(G8:G17),"")'>0.5700,MAX(H8:H17)-MIN(H8:H17),"")'>0.4200,MAX(I8:I17)-MIN(I8:I17),"")'>0.3300,MAX(J8:J17)-MIN(J8:J17),"")'>0.8600,MAX(K8:K17)-MIN(K8:K17),"")'>1.2400,MAX(L8:L17)-MIN(L8:L17),"")'>0.5700,MAX(M8:M17)-MIN(M8:M17),"")'>1.2300,MAX(N8:N17)-MIN(N8:N17),"")'>0.3500,MAX(O8:O17)-MIN(O8:O17),"")'>0.3900,MAX(P8:P17)-MIN(P8:P17),"")'>0.1600,MAX(Q8:Q17)-MIN(Q8:Q17),"")'>0.6900,MAX(R8:R17)-MIN(R8:R17),"")'>0.0600,MAX(S8:S17)-MIN(S8:S17),"")'>0.0400,MAX(T8:T17)-MIN(T8:T17),"")'>0.1600,MAX(U8:U17)-MIN(U8:U17),"")'>0.2800,MAX(V8:V17)-MIN(V8:V17),"")'>0.1400,MAX(W8:W17)-MIN(W8:W17),"")'> =0,AVERAGE(C19:W19),"")'>0.455
0, 24, 23, 17, 1, 0, 25, 6 Pict
#VALUE!
SUL规格上限41.5041.5041.5041.5041.5041.5041.5041.5041.5041.5041.5041.5041.5041.5041.5041.5041.5041.5041.5041.50
SLL规格下限39.0039.0039.0039.0039.0039.0039.0039.0039.0039.0039.0039.0039.0039.0039.0039.0039.0039.0039.0039.00
UCL管制上限40.4740.4740.4740.4740.4740.4740.4740.4740.4740.4740.4740.4740.4740.4740.4740.4740.4740.4740.4740.47
CL中心線40.2140.2140.2140.2140.2140.2140.2140.2140.2140.2140.2140.2140.2140.2140.2140.2140.2140.2140.2140.21
LCL管制下限39.9439.9439.9439.9439.9439.9439.9439.9439.9439.9439.9439.9439.9439.9439.9439.9439.9439.9439.9439.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管制上限000000000000000000000
000000000000000000000
Deveation No : (不良情況说明) [/alig
没有找到相关结果
已邀请:
2 个回复
jolinpanda (威望:0) (江苏 无锡) 电气/能源 工程师
赞同来自: