MSA(从动一档结合齿 插齿 跨棒距).xls
零件名称:从动一档结合技术要求:88.45 0 试验次数:3(2或3次) -0.06 工序号:17插花键量具名称: 齿轮千分尺操作者A:郑新华 检测项目:跨棒距(3)量具编号: 量程75100操作者B:林明辉 被测零件数: 10 日期:2010/6/6操作者C:叶声远 1 12 23 34 45 56 67 78 89 91010 A1 188.41488.41788.41588.43188.43788.44188.44588.44388.41888.410A1 1 A2 288.41388.41888.41588.43288.43888.44188.44588.44088.41888.412A2 2 A388.41588.41788.41488.43288.43788.43988.44488.44188.41788.412A3 B1B188.41688.41788.41488.43288.43788.44088.44488.44088.41788.412B1B1 B288.41588.41888.41488.43288.43888.44088.44488.44088.41588.411B2 B388.41588.41788.41488.43288.43688.44188.44588.44188.41788.412B3 C1C188.41588.41788.41488.43088.43688.44288.44488.43988.41788.411C1C1 C288.41588.41888.41388.43288.43688.44088.44488.43888.41888.411C2 C388.41488.41888.41388.43088.43788.44188.44588.43888.41888.412C3 1 12 23 34 45 56 67 78 89 91010 上海汽车股份有限公司汽车齿轮总厂 量量具具重重复复性性和和再再现现性性数数据据表表 测量系统分析报告之一(四)JJ/SQC-70 评价人/零 件平平均均值值 试验#1 12 23 34 45 56 67 78 89 91010 1.A 1 188.41488.41788.41588.43188.43788.44188.44588.44388.41888.41088.427188.4271 2.2 288.41388.41888.41588.43288.43888.44188.44588.44088.41888.41288.427288.4272 3.3 388.41588.41788.41488.43288.43788.43988.44488.44188.41788.41288.426888.4268 4.平平均均值值( (A)88.41488.41488.41788.41788.41588.41588.43288.43288.43788.43788.44088.44088.44588.44588.44188.44188.41888.41888.41188.411 Xa =88.427088.4270 5.极极差差( (A)0.0020.0020.0010.0010.0010.0010.0010.0010.0010.0010.0020.0020.0010.0010.0030.0030.0010.0010.0020.002Ra = 0.00150.0015 6.B B 1 188.41688.41788.41488.43288.43788.44088.44488.44088.41788.41288.426988.4269 7.2 288.41588.41888.41488.43288.43888.44088.44488.44088.41588.41188.426788.4267 8.3 388.41588.41788.41488.43288.43688.44188.44588.44188.41788.41288.427088.4270 9.平平均均值值( (B)88.41588.41588.41788.41788.41488.41488.43288.43288.43788.43788.44088.44088.44488.44488.44088.44088.41688.41688.41288.412 Xb =88.426988.4269 10.极极差差( (B)0.0010.0010.0010.0010 00 00.0020.0020.0010.0010.0010.0010.0010.0010.0020.0020.0010.001Rb = 0.00100.0010 11.C C 1 188.41588.41788.41488.43088.43688.44288.44488.43988.41788.41188.426588.4265 12.2 288.41588.41888.41388.43288.43688.44088.44488.43888.41888.41188.426588.4265 13.3 388.41488.41888.41388.43088.43788.44188.44588.43888.41888.41288.426688.4266 14.平平均均值值( (C)88.41588.41588.41888.41888.41388.41388.43188.43188.43688.43688.44188.44188.44488.44488.43888.43888.41888.41888.41188.411 Xc =88.426588.4265 15.极极差差( (C)0.0010.0010.0010.0010.0010.0010.0020.0020.0010.0010.0020.0020.0010.0010.0010.0010.0010.0010.0010.001Rc =0.00120.0012 16. 零零件件平平均均值值88.41588.41588.41788.41788.41488.41488.43188.43188.43788.43788.44188.44188.44488.44488.44088.44088.41788.41788.41188.411 X = 88.426888.4268 (Xp)(Xp)Rp = 0.03300.0330 17.Ra=Ra= 0.0015+Rb+Rb = =0.0010+Rc+Rc = =0.0012/评评价价人人数数量量= 3 =R = 0.00120.0012 18. MaxX= 88.4270 -MinX= 88.4265=XDIFF =0.00050.0005 19.R= 0.0012 x D4 = 2.58*=UCLR=0.00320.0032 20.R= 0.0012 x D3 = 0*=LCLR=0 0 *D4=3.27(两次试验),D4=2.58(三次试验);D3=0(不大于7次试验)。ULCR代表单R的限值,圈出那些超差值的值,查明原因并纠正;同一评价人采用最初的 仪器重复这些超限读数或者剔除这些超限值,由剩余观测值再次平均并计算R和限值。 注: 操作者:郑新华林明辉叶声远日期:2010/6/6 上海汽车股份有限公司汽车齿轮总厂 测量系统分析报告之四(四) 零件名称 :从动一档结合技术要求:88.45 0 日期:2010/6/6 -0.06 工序号:17插花键量具名称:齿轮千分尺操作者: 检测项目:跨棒距(3)量具编号:量程75100郑新华林明辉 叶声远 UCLx = X + A2R =88.42810 其中 X= 88.4268数据见测量系统分析报告之一 A2 = 1.023 LCLx = X - A2R =88.42552 R = 0.0012数据见测量系统分析报告之一见MSA 表三 平均值在限值外所占比例为: 100.00%100.00% 零件评价人均值图 12345678910 88.390 88.400 88.410 88.420 88.430 88.440 88.450 平均值(A) 平均值(B) 平均值(C) 上控制线 下控制线 零件平均值 上海汽车股份有限公司汽车齿轮总厂 测量系统分析报告之三(四) 零件名称:从动一档结合技术要求:88.45 0 日期:2010/6/6-0.06 工序号:17插花键量具名称:齿轮千分尺操作者: 检测项目:跨棒距(3)量具编号:量程75100郑新华林明辉叶声远 UCLR=0.00320.0032数据见测量系统分析报告之一 LCLR =0 0 重复性极差控制图 12 3 4 5 6 7 8 9 10 0 0.0005 0.001 0.0015 0.002 0.0025 0.003 0.0035 零件 极值 极差(A) 极差(B) 极差(C) 控制线 上海汽车股份有限公司汽车齿轮厂 量具重复性和再现性报告 测量系统分析报告之二(四) 零件名称:从动一档结合技术要求: 88.45 0 日期:2010/6/6 -0.06 工序号:17插花键量具名称:齿轮千分尺操作者: 检测项目:跨棒距(3)量具编号:量程75100郑新华 林明辉 叶声远 根据数据表: 0.00120.0005 Rp=0.0330 测量设备分析%总变差(TV) 重复性-设备变差(EV)%EV=100EV/TV = 100 0.0007/ 0.0104 =7.00% 0.0012 *0.5908试验次数K1 0.000720.886 30.591 重复性-评价人变差(AV)%AV=100AV/TV = 1000.0002/ 0.0104 =2.16% (0.0005*0.52)2-(0.00072/10* 3) n=零件数量 0.0002评价人23r=试验次数 K20.710.52 重复性和再现性(GRR)%GRR=100GRR/TV = 1000.0008/ 0.0104 =7.33% (0.0007 2 +0.0002 2) GRR/T=100 0.00076 / 0.0600 =1.27% 0.0008零件数K3 20.7071 零件变差(PV)30.52 PV= Rp*K340.45%PV=100PV/TV =0.0330*0.314650.40= 1000.0104/ 0.0104 =0.010460.37=99.73% ndc=1.41(PV/GRR)ndc=1.41(PV/GRR) 总变差(TV)70.35 80.34 90.32=19.1939 100.31 =(0.0008 2+0.01042) =0.0104 1 K*REV )nr/EV()K*X(AV 22 2 DIFF = )PVR&R(TV 22 RD IF FX GRR=EV2+AV2 上海汽车股份有限公司汽车齿轮总厂 量具重复性和再现性报告 测量系统分析报告之一(四)JJ/SQC-70 零件名称:从动一档结合技术要求:88.45日期: 2010/6/6 工序号:17插花键量具名称:齿轮千分尺操作者: 检测项目:跨棒距(3)量具编号:量程75100郑新华 林明辉叶声远 根据数据表: 0.00120.0005 Rp=0.0330 测量设备分析%总变差(TV) 重复性-设备变差(EV)%EV=100EV/TV = 100 0.0038 /0.0536 =7.02% 0.0012* 3.05试验次数K1 0.003824.45 33.05 重复性-评价人变差(AV)%AV=100AV/TV = 100 0.00116 /0.0536 =2.17% (0.0005*2.70)2-(0.0038 2/10* 3) n=零件数量 0.0012评价人23 r=试验次数 K23.652.70 重复性和再现性(R&R) %R&R=100R&R/TV = 100 0.00394 /0.0536 =7.34% (0.0038 2 +0.0012 2 ) 0.0039零件数 K3 23.65 零件变差(PV)32.70 PV= Rp*K342.30%PV=100PV/TV =0.0330*1.6252.08= 100 0.0535/0.0536 =0.053561.93=99.73% #REF! 总变差(TV)71.82 81.74 91.67R*K1 101.62 =( 0.00392+0.053 2) =0.0536 所有计算均基于预计5.15( 正态分布曲线下99.0%的面积)。 K1=5.15/d2,式中d2取决于试验次数(m)和零件数目与操作者数量之积(g),g假定大于15。D2值 来自表2。 AV-如果平方根符号下为负数运算,评价人变差(AV)缺省为零(0)。 K2=5.15/d2*,式中d2*取决于评价人数量(m)和(g),g=1因为只有单极差计算。 K2=5.15/d2*,式中d2*取决于零件数量(m)和(g),g=1因为只有单极差计算。 d2*来源于D3。 1 K*REV )nr/EV()K*X(AV 22 2 DIFF = 22 AVEVR&R R D IF FX )PVR&R(TV 22 量量具具重重复复性性和和再再现现性性数数据据表表 1 12 23 34 45 56 67 78 89 91010平平均均值值 A 1 188.4188.4288.4288.4388.4488.4488.4588.4488.4288.4188.427188.4271 2 288.4188.4288.4288.4388.4488.4488.4588.4488.4288.4188.427288.4272 3 388.4288.4288.4188.4388.4488.4488.4488.4488.4288.4188.426888.4268 平平均均值值(A)8 88 8. .4 41 14 48 88 8. .4 41 17 78 88 8. .4 41 15 58 88 8. .4 43 32 28 88 8. .4 43 37 78 88 8. .4 44 40 08 88 8. .4 44 45 58 88 8. .4 44 41 18 88 8. .4 41 18 88 88 8. .4 41 11 188.427088.4270 极极差差(A)0.0020.0020.0010.0010.0010.0010.0010.0010.0010.0010.0020.0020.0010.0010.0030.0030.0010.0010.0020.0020.00150.0015 B B 1 188.4288.4288.4188.4388.4488.4488.4488.4488.4288.4188.426988.4269 2 2 88.4288.4288.4188.4388.4488.4488.4488.4488.4288.4188.426788.4267 3 3 88.4288.4288.4188.4388.4488.4488.4588.4488.4288.4188.427088.4270 平平均均值值(B)8 88 8. .4 41 15 58 88 8. .4 41 17 78 88 8. .4 41 14 48 88 8. .4 43 32 28 88 8. .4 43 37 78 88 8. .4 44 40 08 88 8. .4 44 44 48 88 8. .4 44 40 08 88 8. .4 41 16 68 88 8. .4 41 12 288.426988.4269 极极差差(B)0.0010.0010.0010.0010 00 00.0020.0020.0010.0010.0010.0010.0010.0010.0020.0020.0010.0010.00100.0010 C C 1 188.41588.41788.41488.43088.43688.44288.44488.43988.41788.41188.426588.4265 2 2 88.41588.41888.41388.43288.43688.44088.44488.43888.41888.41188.426588.4265 3 3 88.41488.41888.41388.43088.43788.44188.44588.43888.41888.41288.426688.4266 平平均均值值(C)8 88 8. .4 41 15 58 88 8. .4 41 18 88 88 8. .4 41 13 38 88 8. .4 43 31 18 88 8. .4 43 36 68 88 8. .4 44 41 18 88 8. .4 44 44 48 88 8. .4 43 38 88 88 8. .4 41 18 88 88 8. .4 41 11 188.426588.4265 极极差差(C)0.0010.0010.0010.0010.0010.0010.0020.0020.0010.0010.0020.0020.0010.0010.0010.0010.0010.0010.0010.0010.00120.0012 零零件件平平均均值值88.4146788.41467 88.4174488.4174488.41488.41488.43188.43188.43788.43788.44188.44188.44488.44488.4488.4488.4172288.41722 88.41144488.411444 16零件平均值88.426888.4268 Rp0.03316 0.00117R0.00120.0012 UCL 88.42810LCL88.42552180.00050.0005 190.00320.0032 200.00000.0000 EV0.0037617%EV0.07017 AV0.0013500.000000.00000050.0000010.001%AV0.02168 30RR0.0000140.0000010.004%RR0.073 0PV0.0535%PV0.997 100.00%TV0.000020.0028580.05360 12345678910 极差(A)0.0020.0010.0010.0010.0010.0020.0010.0030.0010.002 极差(B)0.0010.001000.0020.0010.0010.0010.0020.001 极差(C)0.0010.0010.0010.0020.0010.0020.0010.0010.0010.001 控制线0.00320.00320.00320.00320.00320.00320.00320.00320.00320.0032 12345678910 平均值(A)88.41488.41788.41588.43288.43788.44088.44588.44188.41888.411 平均值(B)88.41588.41788.41488.43288.43788.44088.44488.44088.41688.412 平均值(C)88.41588.41888.41388.43188.43688.44188.44488.43888.41888.411 上控制线88.42888.42888.42888.42888.42888.42888.42888.42888.42888.428 下控制线88.42688.42688.42688.42688.42688.42688.42688.42688.42688.426 零件平均值88.426888.426888.426888.426888.426888.426888.426888.426888.426888.4268 ffftttttff ffftttttff ffftttttff tttffffftt tttffffftt tttffffftt 15 15 1