23工序能力计算 (剃齿 跨棒距 ).xls

* PPAP 过程能力调查表 零件名称从动三档齿工序名称剃齿检测项目跨棒距(4) 零件图号 BS15-G1-1701005工序号23日 期2010/6/4 名义值 98.270Cp1.69Pp1.77设备名称剃齿机 上公差OT0.000Cpk1.56Ppk1.63设备型号YWA4232 下公差UT-0.041Avarage98.25120.002设备代号QT-002 组号序号12345AvarageR 198.246098.253098.243098.248098.2480.0000198.2480.010 298.255098.252098.242098.252098.2550.0000398.2510.013 398.253098.250098.254098.246098.2550.0000198.2520.009 498.255098.256098.248098.255098.2470.0000298.2520.009 598.254098.256098.253098.248098.2450.0000298.2510.011 698.249098.256098.255098.247098.2450.0000298.2500.011 798.247098.259098.251098.249098.2470.0000298.2510.012 898.258098.259098.255098.248098.2480.0000398.2540.011 998.253098.255098.252098.245098.2500.0000198.2510.010 1098.254098.255098.251098.255098.2430.0000398.2520.012 1198.255098.252098.252098.255098.2470.0000198.2520.008 1298.254098.254098.250098.255098.2470.0000198.2520.008 1398.253098.253098.253098.256098.2470.0000198.2520.009 1498.250098.245098.245098.254098.2510.0000298.2490.009 1598.255098.254098.254098.252098.2500.0000098.2530.005 1698.256098.248098.253098.247098.2490.0000198.2510.009 1798.248098.254098.255098.253098.2580.0000198.2540.010 1898.248098.255098.255098.250098.2480.0000198.2510.007 1998.245098.248098.250098.245098.2490.0000198.2470.005 2098.243098.248098.249098.250098.2500.0000198.2480.007 2198.255098.250098.248098.252098.2580.0000298.2530.010 2298.254098.249098.249098.254098.2450.0000198.2500.009 2398.254098.252098.252098.252098.2470.0000198.2510.007 2498.259098.250098.252098.250098.2500.0000298.2520.009 2598.250098.256098.255098.250098.2520.0000198.2530.006 检测： 雷学春编制： 侯连波审核：孙海朋 -0.0979381 0.02 误 差 平均值 上控制线 下控制线 上公差 下公差 中线 组号 Avarage 对平均值偏移 对中间值偏移 avarageSSavaragesCp 398.2476#DIV/0!4.63%98.25118 0.0036469 0.00379177 0.004034 1.694019 698.2512#DIV/0!-4.15%0.0053572 998.2516#DIV/0!-5.12%0.0036469 1298.2522#DIV/0!-6.59%0.0043243Pp 1598.2512#DIV/0!-4.15%0.00454970.0016760.003858 1.771398 1898.2504#DIV/0!-2.20%0.0048785 2198.2506#DIV/0!-2.68%0.00498 2498.2536#DIV/0!-10.00%0.0053198Max-MinMaxMin 2798.251#DIV/0!-3.66%0.00380790.01798.25998.242 3098.2516#DIV/0!-5.12%0.0050794 3398.2522#DIV/0!-6.59%0.0032711 3698.252#DIV/0!-6.10%0.0033912 3998.2524#DIV/0!-7.07%0.0032863 4298.249#DIV/0!1.22%0.003937 4598.253#DIV/0!-8.54%0.002 4898.2506#DIV/0!-2.68%0.0037815 5198.2536#DIV/0!-10.00%0.0036469 5498.2512#DIV/0!-4.15%0.0035637 5798.2474#DIV/0!5.12%0.0023022 6098.248#DIV/0!3.66%0.0029155 6398.2526#DIV/0!-7.56%0.0039749 6698.2502#DIV/0!-1.71%0.0038341 6998.2514#DIV/0!-4.63%0.0026077 7298.2522#DIV/0!-6.59%0.0038987 7598.2526#DIV/0!-7.56%0.0027928 Cpk1Cpk2CpknAn空白列列数 计算 空白行 行数 RRav1 1.555523 1.832516 1.555523 30.86605 0.940250.010.0072 0.003497 40.9210.013 50.940.008 Ppk1Ppk2Ppk0.008 1.626576 1.916221 1.626576FALSE0.008 0.009 0.012 (Max-Min)%Cpk0.011 41%2.4117650.01 0.004 0.003 0.005 0.003 0.009 0.003 0.009 0.007 0.007 0.005 0.007 0.007 0.005 0.002 0.009 0.006 nd2平均值上控制线 下控制线 31.693 0.003647FALSE1-0.00190.014-0.014 42.059 0.005357FALSE20.00170.014-0.014 52.326 0.003647FALSE30.00210.014-0.014 0.004324FALSE40.00270.014-0.014 0.00455FALSE50.00170.014-0.014 0.004879FALSE60.00090.014-0.014 0.00498FALSE70.00110.014-0.014 0.00532FALSE80.00410.014-0.014 0.003808FALSE90.00150.014-0.014 0.005079FALSE100.00210.014-0.014 0.003271FALSE110.00270.014-0.014 0.003391FALSE120.00250.014-0.014 0.003286FALSE130.00290.014-0.014 0.003937FALSE14-0.00050.014-0.014 0.002FALSE150.00350.014-0.014 0.003782FALSE160.00110.014-0.014 0.003647FALSE170.00410.014-0.014 0.003564FALSE180.00170.014-0.014 0.002302FALSE19-0.00210.014-0.014 0.002915FALSE20-0.00150.014-0.014 0.003975FALSE210.00310.014-0.014 0.003834FALSE220.00070.014-0.014 0.002608FALSE230.00190.014-0.014 0.003899FALSE240.00270.014-0.014 0.002793FALSE250.00310.014-0.014 上公差下公差中线 0.0205-0.02050 0.0205-0.02050 0.0205-0.02050 0.0205-0.02050 0.0205-0.02050 0.0205-0.02050 0.0205-0.02050 0.0205-0.02050 0.0205-0.02050 0.0205-0.02050 0.0205-0.02050 0.0205-0.02050 0.0205-0.02050 0.0205-0.02050 0.0205-0.02050 0.0205-0.02050 0.0205-0.02050 0.0205-0.02050 0.0205-0.02050 0.0205-0.02050 0.0205-0.02050 0.0205-0.02050 0.0205-0.02050 0.0205-0.02050 0.0205-0.02050