《23工序能力计算 (剃齿 跨棒距 ).xls》由会员分享，可在线阅读，更多相关《23工序能力计算 (剃齿 跨棒距 ).xls（6页珍藏版）》请在三一文库上搜索。
1、* PPAP 过程能力调查表 零件名称从动四档齿工序名称剃齿检测项目跨棒距(4) 零件图号 BS15-G1-1701006工序号23日 期2010/6/4 名义值 86.619Cp1.50Pp1.67设备名称剃齿机 上公差OT0.000Cpk1.44Ppk1.60设备型号YWA4232 下公差UT-0.042Avarage86.59880.001设备代号QT-002 组号序号12345AvarageR 186.596086.601086.593086.593086.5980.0000186.5960.008 286.605086.602086.596086.598086.6010.000018
2、6.6000.009 386.599086.602086.594086.606086.5990.0000286.6000.012 486.595086.602086.598086.602086.5930.0000286.5980.009 586.594086.591086.603086.598086.5950.0000286.5960.012 686.599086.593086.602086.603086.5950.0000286.5980.010 786.603086.599086.601086.596086.5930.0000286.5980.010 886.595086.596086.6
3、05086.595086.5980.0000286.5980.010 986.603086.592086.593086.595086.6030.0000386.5970.011 1086.594086.599086.601086.605086.6010.0000286.6000.011 1186.605086.592086.602086.593086.5970.0000386.5980.013 1286.594086.591086.602086.605086.5970.0000386.5980.014 1386.603086.603086.593086.601086.5960.0000286.
4、5990.010 1486.603086.595086.595086.604086.6010.0000286.6000.009 1586.605086.594086.604086.598086.6010.0000286.6000.011 1686.606086.598086.603086.593086.5990.0000286.6000.013 1786.598086.604086.595086.609086.5980.0000386.6010.014 1886.595086.605086.601086.607086.5980.0000286.6010.012 1986.595086.5980
5、86.596086.595086.6040.0000186.5980.009 2086.593086.598086.599086.604086.6040.0000286.6000.011 2186.595086.598086.598086.598086.6020.0000186.5980.007 2286.604086.599086.599086.594086.5950.0000286.5980.010 2386.604086.602086.596086.597086.5970.0000186.5990.008 2486.599086.602086.605086.593086.5970.000
6、0286.5990.012 2586.599086.596086.595086.602086.6070.0000286.6000.012 检测： 郑新华编制： 侯连波审核： 孙海朋 -0.0979381 0.02 误 差 平均值 上控制线 下控制线 上公差 下公差 中线 组号 Avarage 对平均值偏移 对中间值偏移 avarageSSavaragesCp 386.5962#DIV/0!4.29%86.59884 0.0034205 0.00439866 0.004679 1.495912 686.6004#DIV/0!-5.71%0.0035071 986.6#DIV/0!-4.76%0.
7、0044159 1286.598#DIV/0!0.00%0.004062Pp 1586.5962#DIV/0!4.29%0.00454970.000840.004204 1.665232 1886.5984#DIV/0!-0.95%0.0043359 2186.5984#DIV/0!-0.95%0.0039749 2486.5978#DIV/0!0.48%0.0042071Max-MinMaxMin 2786.5972#DIV/0!1.90%0.00540370.01886.60986.591 3086.6#DIV/0!-4.76%0.004 3386.5978#DIV/0!0.48%0.00
8、56303 3686.5978#DIV/0!0.48%0.0057184 3986.5992#DIV/0!-2.86%0.0044944 4286.5996#DIV/0!-3.81%0.0043359 4586.6004#DIV/0!-5.71%0.0045056 4886.5998#DIV/0!-4.29%0.0049699 5186.6008#DIV/0!-6.67%0.0056303 5486.6012#DIV/0!-7.62%0.0049193 5786.5976#DIV/0!0.95%0.0037815 6086.5996#DIV/0!-3.81%0.0046152 6386.598
9、2#DIV/0!-0.48%0.00249 6686.5982#DIV/0!-0.48%0.0039623 6986.5992#DIV/0!-2.86%0.0035637 7286.5992#DIV/0!-2.86%0.0046043 7586.5998#DIV/0!-4.29%0.0048683 Cpk1Cpk2CpknAn空白列列数 计算 空白行 行数 RRav1 1.436075 1.555748 1.436075 30.86605 0.940250.0080.00988 0.004798 40.9210.009 50.940.012 Ppk1Ppk2Ppk0.007 1.598623
10、1.731842 1.598623FALSE0.012 0.01 0.007 (Max-Min)%Cpk0.01 43%2.3333330.011 0.011 0.013 0.014 0.01 0.009 0.011 0.013 0.014 0.012 0.003 0.011 0.003 0.01 0.008 0.012 0.007 nd2平均值上控制线 下控制线 31.693 0.003421FALSE1-0.00180.014-0.014 42.059 0.003507FALSE20.00240.014-0.014 52.326 0.004416FALSE30.0020.014-0.014
11、 0.004062FALSE4 1.42E-140.014-0.014 0.00455FALSE5-0.00180.014-0.014 0.004336FALSE60.00040.014-0.014 0.003975FALSE70.00040.014-0.014 0.004207FALSE8-0.00020.014-0.014 0.005404FALSE9-0.00080.014-0.014 0.004FALSE100.0020.014-0.014 0.00563FALSE11-0.00020.014-0.014 0.005718FALSE12-0.00020.014-0.014 0.0044
12、94FALSE130.00120.014-0.014 0.004336FALSE140.00160.014-0.014 0.004506FALSE150.00240.014-0.014 0.00497FALSE160.00180.014-0.014 0.00563FALSE170.00280.014-0.014 0.004919FALSE180.00320.014-0.014 0.003782FALSE19-0.00040.014-0.014 0.004615FALSE200.00160.014-0.014 0.00249FALSE210.00020.014-0.014 0.003962FAL
13、SE220.00020.014-0.014 0.003564FALSE230.00120.014-0.014 0.004604FALSE240.00120.014-0.014 0.004868FALSE250.00180.014-0.014 上公差下公差中线 0.021-0.0210 0.021-0.0210 0.021-0.0210 0.021-0.0210 0.021-0.0210 0.021-0.0210 0.021-0.0210 0.021-0.0210 0.021-0.0210 0.021-0.0210 0.021-0.0210 0.021-0.0210 0.021-0.0210 0.021-0.0210 0.021-0.0210 0.021-0.0210 0.021-0.0210 0.021-0.0210 0.021-0.0210 0.021-0.0210 0.021-0.0210 0.021-0.0210 0.021-0.0210 0.021-0.0210 0.021-0.0210