《23工序能力计算 (主减速器从动齿轮 剃齿 跨棒距).xls》由会员分享，可在线阅读，更多相关《23工序能力计算 (主减速器从动齿轮 剃齿 跨棒距).xls（6页珍藏版）》请在三一文库上搜索。
1、* PPAP 过程能力调查表 零件名称 主减速器从动齿轮 工序名称剃 齿检测项目跨棒距(4) 零件图号BS15-2302001工序号23日 期2010/4/10 名义值 206.185Cp1.71Pp1.72设备名称剃齿机 上公差OT0.000Cpk1.64Ppk1.66设备型号YWA4232 下公差UT-0.040Avarage206.16570.001设备代号QT-004 组号序号12345AvarageR 1206.1660206.1670206.1620206.1740206.1670.00002206.1670.012 2206.1620206.1670206.1660206.172
2、0206.1670.00001206.1670.010 3206.1670206.1660206.1670206.1710206.1650.00001206.1670.006 4206.1630206.1630206.1720206.1640206.1570.00003206.1640.015 5206.1620206.1640206.1550206.1680206.1680.00003206.1630.013 6206.1620206.1640206.1660206.1680206.1690.00001206.1660.007 7206.1640206.1770206.1630206.165
3、0206.1660.00003206.1670.014 8206.1680206.1650206.1710206.1680206.1680.00000206.1680.006 9206.1650206.1650206.1670206.1730206.1670.00001206.1670.008 10206.1680206.1670206.1710206.1650206.1650.00001206.1670.006 11206.1670206.1650206.1740206.1610206.1680.00002206.1670.013 12206.1680206.1650206.1620206.
4、1730206.1690.00002206.1670.011 13206.1670206.1640206.1630206.1710206.1650.00001206.1660.008 14206.1640206.1630206.1680206.1540206.1660.00003206.1630.014 15206.1660206.1620206.1610206.1580206.1680.00002206.1630.010 16206.1680206.1630206.1620206.1570206.1670.00002206.1630.011 17206.1620206.1640206.175
5、0206.1670206.1670.00002206.1670.013 18206.1680206.1650206.1630206.1640206.1670.00000206.1650.005 19206.1650206.1640206.1610206.1670206.1670.00001206.1650.006 20206.1660206.1630206.1730206.1650206.1660.00001206.1670.010 21206.1650206.1670206.1620206.1650206.1660.00000206.1650.005 22206.1650206.162020
6、6.1690206.1660206.1650.00001206.1650.007 23206.1670206.1760206.1670206.1670206.1660.00002206.1690.010 24206.1670206.1640206.1620206.1650206.1550.00002206.1630.012 25206.1610206.1670206.1640206.1650206.1640.00000206.1640.006 检测： 郑新华编制： 侯连波审核： 孙海朋 -0.0979381 0.02 误 差 平均值 上控制线 下控制线 上公差 下公差 中线 组号 Avarag
7、e 对平均值偏移 对中间值偏移 avarageSSavaragesCp 3206.1672#DIV/0!-5.50%206.1657 0.0043243 0.00367263 0.003907 1.706314 6206.1668#DIV/0!-4.50%0.0035637 9206.1672#DIV/0!-5.50%0.0022804 12206.1638#DIV/0!3.00%0.0053572Pp 15206.1634#DIV/0!4.00%0.00536660.0007280.003867 1.724201 18206.1658#DIV/0!-2.00%0.0028636 21206.
8、167#DIV/0!-5.00%0.0057009 24206.168#DIV/0!-7.50%0.0021213Max-MinMaxMin 27206.1674#DIV/0!-6.00%0.00328630.023206.177206.154 30206.1672#DIV/0!-5.50%0.00249 33206.167#DIV/0!-5.00%0.0047434 36206.1674#DIV/0!-6.00%0.0041593 39206.166#DIV/0!-2.50%0.0031623 42206.163#DIV/0!5.00%0.0053852 45206.163#DIV/0!5.
9、00%0.004 48206.1634#DIV/0!4.00%0.0043932 51206.167#DIV/0!-5.00%0.0049497 54206.1654#DIV/0!-1.00%0.0020736 57206.1648#DIV/0!0.50%0.00249 60206.1666#DIV/0!-4.00%0.0037815 63206.165#DIV/0!0.00%0.0018708 66206.1654#DIV/0!-1.00%0.00251 69206.1686#DIV/0!-9.00%0.0041593 72206.1626#DIV/0!6.00%0.0046152 7520
10、6.1642#DIV/0!2.00%0.0021679 Cpk1Cpk2CpknAn空白列列数 计算 空白行 行数 RRav1 1.644205 1.768424 1.644205 30.86605 0.940250.0120.0088 0.004274 40.9210.01 50.940.005 Ppk1Ppk2Ppk0.009 1.661441.7869621.66144FALSE0.013 0.006 0.014 (Max-Min)%Cpk0.006 57%1.739130.008 0.006 0.013 0.011 0.008 0.014 0.008 0.011 0.013 0.005
11、 0.006 0.01 0.005 0.007 0.009 0.005 0.006 nd2平均值上控制线 下控制线 31.693 0.004324FALSE10.00220.013-0.013 42.059 0.003564FALSE20.00180.013-0.013 52.3260.00228FALSE30.00220.013-0.013 0.005357FALSE4-0.00120.013-0.013 0.005367FALSE5-0.00160.013-0.013 0.002864FALSE60.00080.013-0.013 0.005701FALSE70.0020.013-0.01
12、3 0.002121FALSE80.0030.013-0.013 0.003286FALSE90.00240.013-0.013 0.00249FALSE100.00220.013-0.013 0.004743FALSE110.0020.013-0.013 0.004159FALSE120.00240.013-0.013 0.003162FALSE130.0010.013-0.013 0.005385FALSE14-0.0020.013-0.013 0.004FALSE15-0.0020.013-0.013 0.004393FALSE16-0.00160.013-0.013 0.00495FA
13、LSE170.0020.013-0.013 0.002074FALSE180.00040.013-0.013 0.00249FALSE19-0.00020.013-0.013 0.003782FALSE200.00160.013-0.013 0.001871FALSE21 2.84E-140.013-0.013 0.00251FALSE220.00040.013-0.013 0.004159FALSE230.00360.013-0.013 0.004615FALSE24-0.00240.013-0.013 0.002168FALSE25-0.00080.013-0.013 上公差下公差中线 0.02-0.020 0.02-0.020 0.02-0.020 0.02-0.020 0.02-0.020 0.02-0.020 0.02-0.020 0.02-0.020 0.02-0.020 0.02-0.020 0.02-0.020 0.02-0.020 0.02-0.020 0.02-0.020 0.02-0.020 0.02-0.020 0.02-0.020 0.02-0.020 0.02-0.020 0.02-0.020 0.02-0.020 0.02-0.020 0.02-0.020 0.02-0.020 0.02-0.020