《17工序能力计算 (主动四档结合齿 插齿.xls》由会员分享，可在线阅读，更多相关《17工序能力计算 (主动四档结合齿 插齿.xls（6页珍藏版）》请在三一文库上搜索。
1、* PPAP 过程能力调查表 零件名称主动四档结合齿工序名称插齿检测项目跨棒距(3) 零件图号BS15-1701013工序号17日 期2010/6/5 名义值 88.475Cp1.70Pp1.83设备名称插齿机 上公差OT0.000Cpk1.40Ppk1.52设备型号Y5132A 下公差UT-0.060Avarage88.45020.005设备代号QC-004 组号序号12345AvarageR 188.455088.449088.445088.452088.4580.0000388.4520.013 288.455088.447088.452088.443088.4570.0000388.4
2、510.014 388.456088.450088.452088.449088.4440.0000288.4500.012 488.450088.445088.458088.449088.4490.0000288.4500.013 588.452088.443088.457088.441088.4480.0000488.4480.016 688.456088.443088.449088.457088.4580.0000488.4530.015 788.451088.447088.450088.455088.4550.0000188.4520.008 888.457088.454088.4430
3、88.453088.4550.0000388.4520.014 988.458088.444088.457088.450088.4510.0000388.4520.014 1088.443088.441088.440088.449088.4520.0000388.4450.012 1188.450088.459088.447088.442088.4540.0000488.4500.017 1288.448088.442088.450088.451088.4560.0000388.4490.014 1388.452088.448088.445088.455088.4550.0000288.451
4、0.010 1488.441088.445088.442088.448088.4550.0000388.4460.014 1588.458088.445088.453088.457088.4410.0000688.4510.017 1688.455088.443088.444088.441088.4510.0000488.4470.014 1788.441088.456088.444088.449088.4440.0000388.4470.015 1888.458088.449088.449088.452088.4530.0000188.4520.009 1988.455088.452088.
5、444088.450088.4570.0000388.4520.013 2088.457088.448088.443088.444088.4530.0000488.4490.014 2188.454088.457088.445088.450088.4500.0000288.4510.012 2288.452088.455088.441088.454088.4410.0000588.4490.014 2388.453088.455088.454088.453088.4400.0000488.4510.015 2488.455088.448088.443088.458088.4580.000048
6、8.4520.015 2588.442188.453088.457088.453088.4550.0000388.4520.015 检测： 林明辉编制： 孙海朋审核： 孙连奎 -0.0979381 0.02 误 差 平均值 上控制线 下控制线 上公差 下公差 中线 组号 Avarage 对平均值偏移 对中间值偏移 avarageSSavaragesCp 388.4518#DIV/0!-11.33%88.45017 0.0050695 0.00554547 0.005899 1.695078 688.4508#DIV/0!-9.67%0.0057619 988.4502#DIV/0!-8.67%
7、0.0043818 1288.4502#DIV/0!-8.67%0.0047645Pp 1588.4482#DIV/0!-5.33%0.0065345 0.0051688 0.005457 1.832634 1888.4526#DIV/0!-12.67%0.0064265 2188.4516#DIV/0!-11.00%0.0034351 2488.4524#DIV/0!-12.33%0.0054589Max-MinMaxMin 2788.452#DIV/0!-11.67%0.00570090.01988.45988.44 3088.445#DIV/0!0.00%0.005244 3388.45
8、04#DIV/0!-9.00%0.0065038 3688.4494#DIV/0!-7.33%0.0050794 3988.451#DIV/0!-10.00%0.0044159 4288.4462#DIV/0!-2.00%0.0056303 4588.4508#DIV/0!-9.67%0.0074967 4888.4468#DIV/0!-3.00%0.005933 5188.4468#DIV/0!-3.00%0.0058907 5488.4522#DIV/0!-12.00%0.0037014 5788.4516#DIV/0!-11.00%0.0050299 6088.449#DIV/0!-6.
9、67%0.0059582 6388.4512#DIV/0!-10.33%0.0045497 6688.4486#DIV/0!-6.00%0.0070214 6988.451#DIV/0!-10.00%0.0062048 7288.4524#DIV/0!-12.33%0.0066558 7588.45202#DIV/0!-11.70%0.0057881 Cpk1Cpk2CpknAn空白列列数 计算 空白行 行数 RRav1 1.403027 1.987129 1.403027 30.86605 0.940250.01 0.0117560.00571 40.9210.012 50.940.007
10、Ppk1Ppk2Ppk0.013 1.516883 2.148384 1.516883FALSE0.016 0.014 0.008 (Max-Min)%Cpk0.014 32%3.1578950.014 0.009 0.017 0.009 0.01 0.007 0.013 0.014 0.015 0.009 0.011 0.014 0.012 0.014 0.002 0.015 0.0149 nd2平均值上控制线 下控制线 31.6930.00507FALSE10.00680.020-0.020 42.059 0.005762FALSE20.00580.020-0.020 52.326 0.0
11、04382FALSE30.00520.020-0.020 0.004764FALSE40.00520.020-0.020 0.006535FALSE50.00320.020-0.020 0.006427FALSE60.00760.020-0.020 0.003435FALSE70.00660.020-0.020 0.005459FALSE80.00740.020-0.020 0.005701FALSE90.0070.020-0.020 0.005244FALSE10 1.42E-140.020-0.020 0.006504FALSE110.00540.020-0.020 0.005079FAL
12、SE120.00440.020-0.020 0.004416FALSE130.0060.020-0.020 0.00563FALSE140.00120.020-0.020 0.007497FALSE150.00580.020-0.020 0.005933FALSE160.00180.020-0.020 0.005891FALSE170.00180.020-0.020 0.003701FALSE180.00720.020-0.020 0.00503FALSE190.00660.020-0.020 0.005958FALSE200.0040.020-0.020 0.00455FALSE210.00
13、620.020-0.020 0.007021FALSE220.00360.020-0.020 0.006205FALSE230.0060.020-0.020 0.006656FALSE240.00740.020-0.020 0.005788FALSE250.007020.020-0.020 上公差下公差中线 0.03-0.030 0.03-0.030 0.03-0.030 0.03-0.030 0.03-0.030 0.03-0.030 0.03-0.030 0.03-0.030 0.03-0.030 0.03-0.030 0.03-0.030 0.03-0.030 0.03-0.030 0.03-0.030 0.03-0.030 0.03-0.030 0.03-0.030 0.03-0.030 0.03-0.030 0.03-0.030 0.03-0.030 0.03-0.030 0.03-0.030 0.03-0.030 0.03-0.030