PPK CPK (NC250进气门二次磨杆杆部直径).xls

《PPK CPK (NC250进气门二次磨杆杆部直径).xls》由会员分享，可在线阅读，更多相关《PPK CPK (NC250进气门二次磨杆杆部直径).xls（33页珍藏版）》请在三一文库上搜索。

1、工工厂厂车车间间工工序序名名称称质质量量特特性性 零零件件名名称称机机器器编编号号规规 格格 值值 X=AVE（X）= 95.09UCLX=X+A2R=95.33 AVERAGES（X BAR CHART ） R=AVE（R）= 0.33UCLR=D4R=0.76 RANGES（R CHART ） UCLx 01-1 01-2 01-3 01-4 01-5 01-6 01-7 01-8 01-9 01-10 01-11 01-12 01-13 01-14 01-15 01-16 01-17 01-18 01-19 01-20 01-21 01-22 01-23 01-24 01-25 0.00

2、 20.00 40.00 60.00 80.00 100.00 120.00 LCLx CL x AVERAGE UCLR 01-1 01-2 01-3 01-4 01-5 01-6 01-7 01-8 01-9 01- 10 01-11 01- 12 01- 13 01- 14 01- 15 01- 16 01- 17 01- 18 01- 19 01- 20 01- 21 01- 22 01- 23 01- 24 01- 25 0.00 0.20 0.40 0.60 0.80 CL R MAX-MIN 日日期期班班次次01-101-201-301-401-501-601-701-801-9

3、01-10 检检 查查 记记 录录 195.0695.1295.1295.2094.8494.9895.3094.9695.2295.10 295.2894.8494.8895.2295.0095.1895.1695.2894.9895.12 395.1295.3495.2695.1494.9694.9495.2294.8894.9695.30 494.9294.9894.7294.9494.9695.1095.1295.1095.2895.14 5 TOTAL380.4380.3380.0380.5379.8380.2380.8380.2380.4380.7 AVERAGE95.1095.0

4、795.0095.1394.9495.0595.2095.0695.1195.17 MAX-MIN0.360.500.540.280.160.240.180.400.320.20 制制表表/日日期期：审审核核/日日期期： 公公差差上上限限97.10组组容容/频频率率4pcs/连连续续生生产产形形态态 395.10公公差差下下限限93.10图图 号号日日 期期 LCLX=X-A2R=94.85说说 明明 栏栏 对对特特殊殊原原因因采采取取措措施施说说明明 * *任任何何超超出出控控制制限限的的点点 * *连连续续7点点在在中中心心线线之之上上或或之之下下 * *连连续续7点点上上升升/下下降降

5、* *任任何何其其它它明明显显非非随随机机的的图图形形 采采取取措措施施的的说说明明 不不要要对对过过程程做做不不必必要要改改变变 注注明明对对过过程程因因素素（人人机机料料法法环环 或或MSMS）所所做做的的调调整整 组组容容A2 21.88 LCLR=D3R=0.003 1.02 40.73 50.58 60.48 70.42 80.37 90.34 100.31 1.连连续续取取样样 2.组组容容7时时没没有有极极差差下下控控制制限限 Ppk = Min ( =Min7.87 95.33 0.76 UCLx 01-1 01-2 01-3 01-4 01-5 01-6 01-7 01-8

6、01-9 01-10 01-11 01-12 01-13 01-14 01-15 01-16 01-17 01-18 01-19 01-20 01-21 01-22 01-23 01-24 01-25 0.00 20.00 40.00 60.00 80.00 100.00 120.00 LCLx CL x AVERAGE UCLR 01-1 01-2 01-3 01-4 01-5 01-6 01-7 01-8 01-9 01- 10 01-11 01- 12 01- 13 01- 14 01- 15 01- 16 01- 17 01- 18 01- 19 01- 20 01- 21 01- 2

7、2 01- 23 01- 24 01- 25 0.00 0.20 0.40 0.60 0.80 CL R MAX-MIN 01-1101-1201-1301-1401-1501-1601-1701-1801-1901-2001-2101-22 95.1694.9895.3294.8495.2095.1095.3095.3094.9895.2294.9295.36 95.1894.9895.4295.1494.9695.1295.2695.2294.8495.3094.9495.28 95.3095.1095.2295.2094.8495.1495.0294.9895.1295.1095.149

8、5.12 94.8495.1295.2295.3294.8695.2095.2294.9695.1695.1295.1294.92 380.5380.2381.2380.5379.9380.6380.8380.5380.1380.7380.1380.7 95.1295.0595.3095.1394.9795.1495.2095.1295.0395.1995.0395.17 0.460.140.200.480.360.100.280.340.320.200.220.44 批批准准/日日期期： 小小批批量量试试生生产产 D3D4d2 *3.27 *2.57 *2.28 *2.11 *2.00 0.

9、081.92 0.141.86 0.181.82 0.221.78 USL-XX-LSL )1.67 33 7.80) =7.80 说说 明明 栏栏 对对特特殊殊原原因因采采取取措措施施说说明明 * *任任何何超超出出控控制制限限的的点点 * *连连续续7点点在在中中心心线线之之上上或或之之下下 * *连连续续7点点上上升升/下下降降 * *任任何何其其它它明明显显非非随随机机的的图图形形 采采取取措措施施的的说说明明 不不要要对对过过程程做做不不必必要要改改变变 注注明明对对过过程程因因素素（人人机机料料法法环环 或或MSMS）所所做做的的调调整整 1.连连续续取取样样 2.组组容容7时时没

10、没有有极极差差下下控控制制限限 01-2301-2401-25 95.1295.1294.66 94.8494.8895.22 95.3495.2695.14 94.9894.7294.94 380.3380.0380.0 95.0795.0094.99 0.500.540.56 X R 控控制制图图 控制图编号： 产 品 NC250-LNC250-L进进气气门门 规 格标 准 子组容量 控 制X 图R图 制 造 部 门 一车间 容量/ 频次 1次/20支 名 称 上限USL 4.9865上限 UCL4.98320.0051 控制项目 杆部直径 中心限CL 4.982子组大小中心限CL4.98

11、180.0024 测定者杨劲松 袁春梅 抽样方法 随 机 测量单位mm 下限LSL4.97725下限 LCL4.98040.0000日 期2010.5.15 日期/时间 合 計 批 号 12345678910111213141516171819202122232425 样14.9814.9824.9844.9824.9844.9844.9844.9844.9814.9824.9824.9844.9814.9844.9854.9794.9824.9824.9824.9814.9824.9824.9824.9794.981 本24.9844.9804.9834.9824.9824.9844.983

12、4.9824.9844.9804.9824.9844.9804.9834.9814.9794.9814.9814.9824.9814.9824.9824.9824.9824.981 测34.9824.9804.9834.9794.9834.9824.9824.9824.9804.9804.9814.9824.9804.9824.9814.9804.9814.9824.9824.9814.9824.9814.9814.9814.981测量数值的判定条件 定44.9844.9814.9844.9804.9834.9814.9824.9814.9824.9814.9814.9814.9814.982

13、4.9814.9814.9814.9824.9824.9824.9834.9824.9804.9814.982 USL 兰色 值54.9844.9814.9824.9804.9814.9834.9814.9814.9814.9804.9834.9814.9824.9824.9824.9824.9824.9824.9834.9834.9814.9834.9794.9824.981 USL 兰色 =Range組界組界頻率XNormal =4.97738497854077=4.97648497854077 24.977384.97738024.9770.000186424.979 =4.978284

14、97854077=4.97738497854077 34.978284.97828034.9770.000437754.979 =4.97918497854077=4.97828497854077 44.979184.97918544.9770.000997014.980 =4.98008497854077=4.97918497854077 54.980084.980081254.9770.002202454.980 =4.98098497854077=4.98008497854077 64.980984.98098064.9770.004719014.980 =4.9818849785407

15、7=4.98098497854077 74.981884.981883774.9780.009806944.981 =4.98278497854077=4.98188497854077 84.982784.982784484.9780.01976764.981 =4.98368497854077=4.98278497854077 94.983684.983681294.9780.038646674.981 =4.98458497854077=4.98368497854077 104.984584.9845814104.9780.073283794.982 =4.98548497854077=4

16、.98458497854077 114.985484.985481114.9780.134784954.982 其他其他0124.9780.240443244.982 134.9790.416026954.983 DescriptionValue The limits are calculated as:Minimum Maximum delta144.9790.698181074.983 Sigma0.001Selected4.9774.9860.001154.9791.136455344.983 Mean4.982X4.9794.985164.9791.794214584.984 Delt

17、a0.001 LCL or UCL for X4.9804.983174.9792.747477194.984 Multiplier 0.112LSL or USL4.9774.986184.9804.080670384.984 Maximum49.004*Sig+ Median4.9784.986194.9805.878501594.985 204.9808.213711974.985 214.98011.13140554.985 224.98014.63181644.986 234.98018.65452484.986 1004-8191004-819 244.98123.06788834

18、.986 254.98127.66745394.977 264.98132.18609254.977 274.98136.31658654.977 284.98139.7447245 294.98242.1882652 304.98243.4351722 314.98243.3739659 324.98242.0101687 334.98239.4654829 344.98235.9598708 354.98331.7801929 364.98327.2416018 374.98322.6488657 384.98318.2640875 394.98314.285229 404.98410.8

19、371264 414.9847.9740467 424.9845.69090214 434.9843.93931913 444.9842.64483703 454.9841.7223221 464.9851.0878463 474.9850.66643593 484.9850.39599252 494.9850.22821977 504.9850.12757255 514.9850.069167 0.0810.112487 0 34.3 0 0 24.5 0 0 24.5 0 0 49.00 0 0 24.5 0 0 24.5 0 0 34.3 0 0 49.00 0 0 49.00 0 20

20、19/9/18 4059388be548919c0614325d4fd9ac74.xls TYPE OF TOLERENCE: BOTH SIDE 1, MAX TOL.3, MIN TOL 4, B“COLUMN INPUT.BEFORE TIME BEFORE DATA DELETE. PROCESSPROCESS CAPABILITYCAPABILITY STUDYSTUDY PART NO:96179248 P/NO:96179248USL :0.88 INSP : PART NAMEG/K-GEARSHIFT P/NAME:G/K-GEARSHIFTLSL :0.72 DATE :

21、OP.NO PROCESS: TOL :0.16MIN UNIT :0.001 CHECK ITEM ITEM: MEAN :0.8Xo : TYPE OF TOL.10.81000.81000.82000.83000.82000.82000.74000.82000.82000.8000 USL0.8800.83000.83000.81000.84000.84000.81000.83000.76000.85000.8400 LSL0.7200.82000.83000.84000.81000.78000.83000.84000.85000.80000.8400 INSPECTOR0.82000.

22、83000.81000.83000.78000.81000.82000.82000.82000.8000 DATE0.82000.83000.82000.82000.81000.82000.82000.82000.84000.8300 UNIT0.001 Xo : DATA NO.10.81 20.81 30.82 40.83 50.82 60.82 70.74 80.82 90.82 100.8 110.83 120.83 130.81 140.84AVG =0.8188MIN =0.74MAX =0.85N =50 150.84 = 0.0206 Cp =1.30 Cpk =0.99 k

23、=0.23 160.81 PC% =77.1% PCk% =100.8% 170.83 OUT OF UPPER SPEC =0.15% OUT OF LOWER SPEC =0.00% 180.76 KURTOSIS =7.40 SKEWNESS =-1.69 190.85 SPREAD RANGE(6) =0.7570.881 200.84 210.82DISTRIBUTIONDISTRIBUTION CURVECURVE 220.83 230.84 240.81 250.78 260.83 270.84 280.85 290.8 300.84 310.82 320.83 330.81 3

24、40.83 350.78 360.81 370.82 380.82 390.82 400.8 410.82MAX+SL/20.8505MIN.UNIT0.001 420.83X+3s0.881Max0.85 430.82US0.88Min0.746.838834 440.82MIN-SL/20.7395KIND QTYT111CLASS QTY6 450.81X-3s0.757GRADE KIND18GRADE KIND r18.5 460.82LS0.72grade width0.019 470.82a0.7221.0263160.695395 480.82b0.8805028.447494

25、0.72 490.84h0.0032110.000492 500.830.0011880.023250.18325 510.70158.14E-05000.70151.68E-060.701500010.70150.7015000.01850.17850 520.70270.000109010.70636.1E-06 0-1000.70630.7063000.013750.173750 530.70390.000147020.71100.000021 0-1000.71100.7110000.0090.1690 540.70510.000196030.71586.86E-05 0-1000.7

26、1580.7158000.004250.164250 550.70630.00026040.72050.0002130.720500010.72050.7205000.00050.15951 560.70740.000344050.72530.000624 0-1000.72530.7253000.005250.154750 570.70860.000454060.73000.001738 0-1000.73000.7300000.010.150 580.70980.000597070.73480.004586 0-1000.73480.7348000.014750.145250 590.71

27、100.000782080.73950.0114730.739500110.73950.7395010.01950.14050 600.71220.00102090.74430.027216 1-1000.74430.7443100.024250.135750 610.71340.0013260100.74900.061205 1-1000.74900.7490100.0290.1310 620.71460.0017170110.75380.130494 1-1000.75380.7538100.033750.126250 630.71580.0022150120.75850.2637730.

28、758500110.75850.7585110.03850.12150 640.71690.0028460130.76330.505484 1-1000.76330.7633200.043250.116750 650.71810.0036440140.76800.918376 1-1000.76800.7680200.0480.1120 660.71930.0046470150.77281.581866 1-1000.77280.7728200.052750.107250 670.72050.0059040160.77752.5831810.777500210.77750.7775220.05

29、750.10250 680.72170.0074730170.78233.99923 2-1000.78230.7823400.062250.097750 690.72290.0094210180.78705.869944 2-1000.78700.7870400.0670.0930 700.72410.0118320190.79188.168225 2-1000.79180.7918400.071750.088250 710.72530.0148020200.796510.7760.7965001110.79650.7965430.07650.08350 720.72640.01844602

30、10.801313.47795 11-1000.80130.8013700.081250.078750 730.72760.0228960220.806015.98182 11-1000.80600.8060780.0860.0740 740.72880.0283090230.810817.96655 11-1000.81080.81081500.090750.069250 750.73000.0348640240.815519.14870.8155002610.81550.815515160.09550.06450 760.73120.0427670250.820319.34863 26-1

31、000.82030.82033100.100250.059750 770.73240.0522520260.825018.5352 26-1000.82500.82503100.1050.0550 780.73360.0635850270.829816.83373 26-1000.82980.829831100.109750.050250 790.73480.0770660280.834514.494380.834500910.83450.83454100.11450.04550 800.73590.0930280290.839311.83192 9-1000.83930.83934170.1

32、19250.040750 810.73710.1118390300.84409.15687 9-1000.84400.84404800.1240.0360 820.73830.1339050310.84886.718541 9-1000.84880.84884820.128750.031250 830.73950.1596660320.85354.6734660.853500010.85350.85355000.13350.02650 840.74070.1895960330.85833.082048 0-1000.85830.85835000.138250.021750 850.74190.

33、2241990340.86301.926974 0-1000.86300.86305000.1430.0170 860.74310.2640080350.86781.142217 0-1000.86780.86785000.147750.012250 870.74430.3095730360.87250.6418850.872500010.87250.87255000.15250.00750 880.74540.3614610370.87730.341981 0-1000.87730.87735000.157250.002750 890.74660.4202380380.88200.17273

34、6 0-1000.88200.88205000.1620.0021 900.74780.4864670390.88680.082718 0-1000.88680.88685000.166750.006750 910.74900.5606840400.89150.0375540.891500010.89150.89155000.17150.01150 920.75020.6433910410.89630.016164 0-1000.89630.89635000.176250.016250 930.75140.7350340420.90100.006596 0-1000.90100.9010500

35、0.1810.0210 940.75260.8359830430.90580.002552 0-1000.90580.90585000.185750.025750 950.75380.9465160440.91050.0009360.910500010.91050.91055000.19050.03050 960.75491.0667921450.91530.000325 0-1000.91530.91535000.195250.035250 970.75611.1968331460.92000.000107 0-1000.92000.92005000.20.040 980.75731.336

36、5011470.92483.35E-05 0-1000.92480.92485000.204750.044750 990.75851.4854781480.92959.94E-060.929500010.92950.92955000.20950.04950 1000.75971.6432462490.9295150 1010.76091.809076250 1020.76211.982013251 1030.76332.160869252 1040.76442.344231253 1050.76562.530461354 1060.76682.717718355 1070.76802.9039

37、81356 1080.76923.087088357 1090.77043.264781358 1100.77163.434759359 1110.77283.594752460 1120.77393.742589461 1130.77513.876283462 1140.77633.994124463 1150.77754.094763464 1160.77874.177312465 1170.77994.241433466 1180.78114.287419467 1190.78234.316276468 1200.78344.329777469 1210.78464.330514470

38、1220.78584.321917471 1230.78704.308257472 1240.78824.294616473 1250.78944.286835474 1260.79064.291425475 1270.79184.315452476 1280.79294.366394477 1290.79414.451963478 1300.79534.579913579 1310.79654.757821580 1320.79774.992852581 1330.79895.291527582 1340.80015.659474683 1350.80136.1012684 1360.802

39、46.619868785 1370.80367.217104786 1380.80487.89283887 1390.80608.645138988 1400.80729.470202989 1410.808410.36225 1090 1420.809611.31359 1191 1430.810812.31465 1292 1440.811913.35415 1393 1450.813114.41927 1494 1460.814315.49587 1595 1470.815516.56877 1796 1480.816717.62209 1897 1490.817918.63954 19

40、98 1500.819119.60484 2099 1510.820320.50207 21100 1520.821421.31601 21101 1530.822622.03255 22102 1540.823822.63898 23103 1550.825023.12429 23104 1560.826223.47948 23105 1570.827423.69767 24106 1580.828623.77435 24107 1590.829823.7074 24108 1600.830923.49715 23109 1610.832123.14634 23110 1620.833322

41、.66002 23111 1630.834522.04543 22112 1640.835721.31177 21113 1650.836920.46996 20114 1660.838119.53239 20115 1670.839318.5126 19116 1680.840417.42496 17117 1690.841616.28435 16118 1700.842815.10584 15119 1710.844013.90438 14120 1720.845212.69449 13121 1730.846411.49002 11122 1740.847610.30389 10123

42、1750.84889.1479329124 1760.84998.0326818125 1770.85116.9672937126 1780.85235.959466127 1790.85355.015375128 1800.85474.1397144129 1810.85593.3357193130 1820.85712.6052193131 1830.85831.9487412132 1840.85941.3656291133 1850.86060.8541680134 1860.86180.4117270135 1870.86300.034910136 1880.8642 -0137 1

43、890.8654 -0138 1900.8666 -0139 1910.8678 -0140 1920.8689 -1141 1930.8701 -1142 1940.8713 -1143 1950.8725 -1144 1960.8737 -1145 1970.8749 -1146 1980.8761 -1147 1990.8773 -1148 2000.8784 -0149 0.8796 -0150 0.8808 -0151 0.8820 -0152 0.8832 -0153 0.8844 -0154 0.8856 -0155 0.8868 -0156 0.8879 -0157 0.889

44、1 -0158 0.8903 -0159 0.8915 -0160 0.8927 -0161 0.8939 -0162 0.8951 -0163 0.8963 -0164 0.8974 -0165 0.8986 -0166 0.8998 -0167 0.9010 -0168 0.9022 -0169 0.9034 -0170 0.9046 -0171 0.9058 -0172 0.9069 -0173 0.9081 -0174 0.9093 -0175 0.9105 -0176 0.9117 -0177 0.9129 -0178 0.9141 -0179 0.9153 -0180 0.9164

45、 -0181 0.9176 -0182 0.9188 -0183 0.9200 -0184 0.9212 -0185 0.9224 -0186 0.9236 -0187 0.9248 -0188 0.9259 -0189 0.9271 -0190 0.9283 -0191 0.9295 -0192 0.701500 0.720500 0.739500 0.758500 0.777500 0.796500 0.815500 0.834500 0.853500 0.872500 0.891500 0.910500 0.929500 0 5 10 15 20 25 30 1 0 0.2 0.4 0.

46、6 0.8 1 1.2 #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! 控控制制图图的的常常数数和和公公式式表表 - -图图 -s -s图图 均均值值图图 全全距距图图 均均值值图图 标标准准差差图图 子子组组 容容量量 计计算算控控制制 限限用用的的系系 数数 标标准准差差估估 计计值值的的除除 数数 计计算算控控制制限限用用的的系系 数数 计计算算控控制制 限限用用的的系系 数数 标标准准差差估估 计计值值的的除除 数数 计计算算控控制制限限用用的的系系数数 n nA A2 2d d2 2D D3 3D D4 4A A

47、3 3c c4 4B B3 3 2 21.8801.8801.1281.128- -3.2673.2672.6592.6590.79790.7979- - 3 31.0231.0231.6931.693- -2.5712.5711.9541.9540.88620.8862- - 4 40.7290.7292.0592.059- -2.2822.2821.6281.6280.92130.9213- - 5 50.5770.5772.3262.326- -2.1142.1141.4271.4270.94000.9400- - 6 60.4830.4832.5432.543- -2.0042.004

48、1.2871.2870.95150.95150.0300.030 7 70.4190.4192.7042.7040.0760.0761.9241.9241.1821.1820.95940.95940.1180.118 8 80.3730.3732.8472.8470.1360.1361.8641.8641.0991.0990.96500.96500.1850.185 9 90.3370.3372.9702.9700.1840.1841.8161.8161.0321.0320.96930.96930.2390.239 10100.3080.3083.0783.0780.2230.2231.777

49、1.7770.9750.9750.97270.97270.2840.284 11110.2850.2853.1733.1730.2560.2561.7441.7440.9270.9270.97540.97540.3210.321 12120.2660.2663.2583.2580.2830.2831.7171.7170.8860.8860.97760.97760.3540.354 13130.2490.2493.3363.3360.3070.3071.6931.6930.8500.8500.97940.97940.3820.382 14140.2350.2353.4073.4070.3280.3281.6721.6720.8170.8170.98100.98100.4060.406 15