《23工序能力计算 (搓花键3 跨棒距 ).xls》由会员分享，可在线阅读，更多相关《23工序能力计算 (搓花键3 跨棒距 ).xls（6页珍藏版）》请在三一文库上搜索。
1、* PPAP 过程能力调查表 零件名称输出轴工序名称搓花键检测项目跨棒距(2) 零件图号BS15-1701004工序号23日 期2010/6/10 名义值 38.162Cp1.71Pp1.81设备名称搓齿机 上公差OT0.000Cpk1.53Ppk1.62设备型号LECN 下公差UT-0.035Avarage38.1427-0.002设备代号MG-C004 组号序号12345AvarageR 138.138038.141038.141038.138038.1470.0000138.1410.009 238.143038.144038.149038.142038.1390.0000138.143
2、0.010 338.145038.141038.142038.138038.1420.0000138.1420.007 438.143038.148038.143038.146038.1380.0000138.1440.010 538.139038.138038.138038.146038.1440.0000138.1410.008 638.143038.146038.148038.141038.1420.0000138.1440.007 738.138038.144038.141038.143038.1400.0000138.1410.006 838.143038.143038.141038
3、.148038.1400.0000138.1430.008 938.146038.144038.149038.148038.1460.0000038.1470.005 1038.138038.141038.142038.146038.1480.0000238.1430.010 1138.142038.140038.141038.146038.1390.0000138.1420.007 1238.141038.142038.138038.145038.1440.0000138.1420.007 1338.141038.143038.149038.141038.1410.0000138.1430.
4、008 1438.146038.146038.139038.148038.1430.0000138.1440.009 1538.138038.145038.139038.140038.1420.0000138.1410.007 1638.139038.141038.149038.144038.1450.0000138.1440.010 1738.143038.148038.144038.141038.1400.0000138.1430.008 1838.135038.140038.145038.144038.1410.0000238.1410.010 1938.146038.143038.13
5、8038.141038.1400.0000138.1420.008 2038.139038.139038.148038.147038.1430.0000238.1430.009 2138.140038.141038.148038.145038.1410.0000138.1430.008 2238.141038.139038.145038.143038.1420.0000138.1420.006 2338.142038.138038.144038.145038.1410.0000138.1420.007 2438.143038.139038.148038.145038.1470.0000138.
6、1440.009 2538.146038.138038.141038.145038.1440.0000138.1430.008 检测： 林明辉 编制： 侯连波编制： 孙海朋 -0.0979381 0.02 误 差 平均值 上控制线 下控制线 上公差 下公差 中线 组号 Avarage 对平均值偏移 对中间值偏移 avarageSSavaragesCp 338.141#DIV/0!10.00%38.14268 0.0036742 0.00321217 0.003417 1.707047 638.1434#DIV/0!3.14%0.0036469 938.1416#DIV/0!8.29%0.002
7、51 1238.1436#DIV/0!2.57%0.0037815Pp 1538.141#DIV/0!10.00%0.0037417-0.001820.003216 1.813589 1838.144#DIV/0!1.43%0.0029155 2138.1412#DIV/0!9.43%0.0023875 2438.143#DIV/0!4.29%0.0030822Max-MinMaxMin 2738.1466#DIV/0!-6.00%0.00194940.01438.14938.135 3038.143#DIV/0!4.29%0.004 3338.1416#DIV/0!8.29%0.002701
8、9 3638.142#DIV/0!7.14%0.0027386 3938.143#DIV/0!4.29%0.0034641 4238.1444#DIV/0!0.29%0.0035071 4538.1408#DIV/0!10.57%0.0027749 4838.1436#DIV/0!2.57%0.0038471 5138.1432#DIV/0!3.71%0.0031145 5438.141#DIV/0!10.00%0.003937 5738.1416#DIV/0!8.29%0.0030496 6038.1432#DIV/0!3.71%0.0042661 6338.143#DIV/0!4.29%0
9、.0033912 6638.142#DIV/0!7.14%0.0022361 6938.142#DIV/0!7.14%0.0027386 7238.1444#DIV/0!0.29%0.0035777 7538.1428#DIV/0!4.86%0.0032711 Cpk1Cpk2CpknAn空白列列数 计算 空白行 行数 RRav1 1.88458 1.529514 1.529514 30.86605 0.940250.0030.00728 0.003536 40.9210.007 50.940.007 Ppk1Ppk2Ppk0.005 2.002203 1.624976 1.624976FAL
10、SE0.008 0.007 0.006 (Max-Min)%Cpk0.007 40%2.50.005 0.008 0.006 0.007 0.008 0.009 0.007 0.01 0.007 0.01 0.008 0.009 0.008 0.006 0.007 0.009 0.008 nd2平均值上控制线 下控制线 31.693 0.003674FALSE1-0.00350.012-0.012 42.059 0.003647FALSE2-0.00110.012-0.012 52.3260.00251FALSE3-0.00290.012-0.012 0.003782FALSE4-0.0009
11、0.012-0.012 0.003742FALSE5-0.00350.012-0.012 0.002915FALSE6-0.00050.012-0.012 0.002387FALSE7-0.00330.012-0.012 0.003082FALSE8-0.00150.012-0.012 0.001949FALSE90.00210.012-0.012 0.004FALSE10-0.00150.012-0.012 0.002702FALSE11-0.00290.012-0.012 0.002739FALSE12-0.00250.012-0.012 0.003464FALSE13-0.00150.0
12、12-0.012 0.003507FALSE14-1E-040.012-0.012 0.002775FALSE15-0.00370.012-0.012 0.003847FALSE16-0.00090.012-0.012 0.003114FALSE17-0.00130.012-0.012 0.003937FALSE18-0.00350.012-0.012 0.00305FALSE19-0.00290.012-0.012 0.004266FALSE20-0.00130.012-0.012 0.003391FALSE21-0.00150.012-0.012 0.002236FALSE22-0.002
13、50.012-0.012 0.002739FALSE23-0.00250.012-0.012 0.003578FALSE24-1E-040.012-0.012 0.003271FALSE25-0.00170.012-0.012 上公差下公差中线 0.0175-0.01750 0.0175-0.01750 0.0175-0.01750 0.0175-0.01750 0.0175-0.01750 0.0175-0.01750 0.0175-0.01750 0.0175-0.01750 0.0175-0.01750 0.0175-0.01750 0.0175-0.01750 0.0175-0.01750 0.0175-0.01750 0.0175-0.01750 0.0175-0.01750 0.0175-0.01750 0.0175-0.01750 0.0175-0.01750 0.0175-0.01750 0.0175-0.01750 0.0175-0.01750 0.0175-0.01750 0.0175-0.01750 0.0175-0.01750 0.0175-0.01750