全套SPC表格(很全面的生产分析表格).xls

1、 XR 控制图控制图编号：製 品 H104PC 規 格 標 準 群組數大小 管 制 X 圖 R 圖 製 造 部 門 时间名 稱 上限 USL 0.90 5 上限 UCL 0.82 0.38管制項目 溝槽寬度 中心限CL 0.70 總組數 中心限CL 0.72 0.18 機 別 抽樣方法測量單位 下限 LSL 0.50 25 下限 LCL 0.61 0.00 測 定 者 日 期日期/時間批 號 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25樣 1 0.650.750.750.600.700.600.750.600

2、.650.600.800.850.700.650.900.750.750.750.650.600.500.600.800.650.65本 2 0.700.850.800.700.750.750.800.700.800.700.750.750.700.700.800.800.700.700.650.600.550.800.650.600.70測 3 0.650.750.800.700.650.750.650.800.850.600.900.850.750.850.800.750.850.600.850.650.650.650.750.650.70定 4 0.650.850.700.750.850

3、.850.750.750.850.800.500.650.750.750.750.800.700.700.650.600.800.650.650.600.60值 5 0.850.650.750.650.800.700.700.750.750.650.800.700.700.600.850.650.800.600.700.650.800.750.650.700.65 3.50 3.85 3.80 3.40 3.75 3.65 3.65 3.60 3.90 3.35 3.75 3.80 3.60 3.55 4.10 3.75 3.80 3.35 3.50 3.10 3.30 3.45 3.50 3

4、.20 3.30 0.70 0.77 0.76 0.68 0.75 0.73 0.73 0.72 0.78 0.67 0.75 0.76 0.72 0.71 0.82 0.75 0.76 0.67 0.70 0.62 0.66 0.69 0.70 0.64 0.66R 0.20 0.20 0.10 0.15 0.20 0.25 0.15 0.20 0.20 0.20 0.40 0.20 0.05 0.25 0.15 0.15 0.15 0.15 0.20 0.05 0.30 0.20 0.15 0.10 0.10x管制圖R管制圖備註及原因追查:1 2 3 4 5 6 7 8 9 1 0 1 1

5、 1 2 1 3 1 4 1 5 1 6 1 7 1 8 1 9 2 0 2 1 2 2 2 3 2 4 2 50 .0 0 0 .1 0 0 .2 0 0 .3 0 0 .4 0 0 .5 0 1 2 3 4 5 6 7 8 9 1 0 1 1 1 2 1 3 1 4 1 5 1 6 1 7 1 8 1 9 2 0 2 1 2 2 2 3 2 4 2 50 .4 0 0 .5 0 0 .6 0 0 .7 0 0 .8 0 0 .9 0 1 .0 0 n 2 3 4 5 6 7 8 9 10d2 1.13 1.69 2.06 2.33 2.53 2.7 2.85 2.97 3.08 2.33D

6、3 0 0 0 0 0 0.08 0.14 0.18 0.22 0D4 3.27 2.57 2.28 2.11 2.00 1.92 1.86 1.82 1.78 2.11A2 1.88 1.02 0.73 0.58 0.48 0.42 0.37 0.34 0.31 0.58XUCL 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82CL 0.72 0.72 0.72 0.72 0.72 0

7、.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72LCL 0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.6164.990.42 0.56 0.56 0.36 0.49 0.36 0.56 0.36 0.42 0.36 0.64 0.72

8、 0.49 0.42 0.81 0.56 0.56 0.56 0.42 0.36 0.25 0.36 0.64 0.42 0.42 0.0012.110.49 0.72 0.64 0.49 0.56 0.56 0.64 0.49 0.64 0.49 0.56 0.56 0.49 0.49 0.64 0.64 0.49 0.49 0.42 0.36 0.30 0.64 0.42 0.36 0.49 0.0013.090.42 0.56 0.64 0.49 0.42 0.56 0.42 0.64 0.72 0.36 0.81 0.72 0.56 0.72 0.64 0.56 0.72 0.36 0

9、.72 0.42 0.42 0.42 0.56 0.42 0.49 0.0013.810.42 0.72 0.49 0.56 0.72 0.72 0.56 0.56 0.72 0.64 0.25 0.42 0.56 0.56 0.56 0.64 0.49 0.49 0.42 0.36 0.64 0.42 0.42 0.36 0.36 0.0013.100.72 0.42 0.56 0.42 0.64 0.49 0.49 0.56 0.56 0.42 0.64 0.49 0.49 0.36 0.72 0.42 0.64 0.36 0.49 0.42 0.64 0.56 0.42 0.49 0.4

10、2 0.0012.870.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00RUCL 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38CL 0.18 0.18 0.18 0.1

11、8 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18LCL 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00USL 0.900.900.900.900.900.900.900.900.900.900.900.900.90

12、0.900.900.900.900.900.900.900.900.900.900.900.900.90LSL 0.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.50備註及原因追查:随机9/22/2017合 計 89.50 4.45量測數值的判定條件 USL 藍色= = Range 組界 組界 頻率 X Normal=0.433339055793991=0.3722231759656652 0.43334 0.43334 0 2 0.384

13、0.00324199125 =0.494454935622318=0.4333390557939913 0.49445 0.49445 0 3 0.397 0.006409540.72 =0.555570815450644=0.4944549356223184 0.55557 0.55557 3 4 0.409 0.012351620.50 =0.61668669527897=0.5555708154506445 0.61669 0.61669 15 5 0.421 0.02320080.90 =0.677802575107296=0.616686695278976 0.67780 0.677

14、80 27 6 0.433 0.042478030.70 =0.738918454935622=0.6778025751072967 0.73892 0.73892 22 7 0.446 0.075806725 =0.800034334763948=0.7389184549356228 0.80003 0.80003 43 8 0.458 0.131866090.90 =0.861150214592274=0.8000343347639489 0.86115 0.86115 13 9 0.470 0.223583940.50 =0.9222660944206=0.861150214592274

15、10 0.92227 0.92227 2 10 0.482 0.369513370.82 =0.983381974248926=0.922266094420611 0.98338 0.98338 0 11 0.494 0.595253240.61 其他 其他 0 12 0.507 0.934663840.09 13 0.519 1.43051090.08 DescriptionValue The limits are calculated as:Minimum Maximum delta 14 0.531 2.13407149-0.01 Sigma 0.076 Selected 0.410 1

16、.022 0.061 15 0.543 3.10319322-0.56 Mean 0.716 X 0.500 0.900 16 0.556 4.398359610355 Delta 0.061 LCL or UCL for X 0.613 0.819 17 0.568 6.07651698.00% Multiplier7.639 LSL or USL 0.500 0.900 18 0.580 8.18277760.80 Maximum48.00 4*Sig+ Median 0.410 1.022 19 0.592 10.74060750.94 20 0.604 13.74165390.87 2

17、1 0.617 17.13685920.80 22 0.629 20.83077923 0.641 24.680949124 0.653 28.503635825 0.666 32.086380426 0.678 35.206532727 0.690 37.653716228 0.702 39.253148329 0.714 39.8862530 0.727 39.505174131 0.739 38.138781532 0.751 35.889029133 0.763 32.918396134 0.776 29.43050335 0.788 25.647129436 0.800 21.785

18、217737 0.812 18.037116338 0.824 14.55641339 0.837 11.4504840 0.849 8.7796070641 0.861 6.5615814842 0.873 4.7799574943 0.886 3.3940763244 0.898 2.3490985445 0.910 1.584757946 0.922 1.0420934847 0.934 0.6679323748 0.947 0.417292349 0.959 0.25411550 0.971 0.1508350651 0.983 0.087268275.500 7.638174230.

19、4868 00.487 33.60.487 00.563 00.563 240.563 00.640 00.640 240.640 00.716 00.716 48.000.716 00.792 00.792 240.792 00.869 00.869 240.869 00.945 00.945 33.60.945 00.900 00.900 48.000.900 00.500 00.500 48.000.500 011/25/2018 281270007aaaac73445b16d6c90ea3a0.xlsTYPE OF TOLERENCE: BOTH SIDE 1, MAX TOL.3,

20、MIN TOL 4, B“COLUMN INPUT.BEFORE TIME BEFORE DATA DELETE.PROCESS CAPABILITY STUDYPART NO: 96179248 P/NO: 96179248 USL : 0.88 INSP : PART NAME G/K-GEARSHIFT P/NAME: G/K-GEARSHIFT LSL : 0.72 DATE : OP.NO PROCESS: TOL : 0.16 MIN UNIT : 0.001CHECK ITEM ITEM: MEAN : 0.8 Xo : TYPE OF TOL. 1 0.8100 0.8100

21、0.8200 0.8300 0.8200 0.8200 0.7400 0.8200 0.8200 0.8000USL 0.880 0.8300 0.8300 0.8100 0.8400 0.8400 0.8100 0.8300 0.7600 0.8500 0.8400LSL 0.720 0.8200 0.8300 0.8400 0.8100 0.7800 0.8300 0.8400 0.8500 0.8000 0.8400INSPECTOR 0.8200 0.8300 0.8100 0.8300 0.7800 0.8100 0.8200 0.8200 0.8200 0.8000DATE 0.8

22、200 0.8300 0.8200 0.8200 0.8100 0.8200 0.8200 0.8200 0.8400 0.8300UNIT 0.001 Xo : DATA NO.1 0.81 2 0.81 3 0.82 4 0.83 5 0.82 6 0.82 7 0.74 8 0.82 9 0.82 10 0.8 11 0.83 12 0.83 13 0.81 14 0.84 AVG = 0.8188 MIN = 0.74 MAX = 0.85 N = 5015 0.84 = 0.0206 Cp = 1.30 Cpk = 0.99 k = 0.2316 0.81 PC% = 77.1% P

23、Ck% = 100.8%17 0.83 OUT OF UPPER SPEC = 0.15% OUT OF LOWER SPEC = 0.00%18 0.76 KURTOSIS = 7.40 SKEWNESS = -1.6919 0.85 SPREAD RANGE(6) = 0.757 0.88120 0.8421 0.82 DISTRIBUTION CURVE22 0.8323 0.8424 0.8125 0.7826 0.8327 0.8428 0.8529 0.830 0.8431 0.8232 0.8333 0.8134 0.8335 0.7836 0.8137 0.8238 0.823

24、9 0.8240 0.841 0.82 MAX+SL/2 0.8505 MIN.UNIT 0.00142 0.83 X+3s 0.881 Max 0.8543 0.82 US 0.88 Min 0.74 6.83883441344 0.82 MIN-SL/2 0.7395 KIND QTYT 111 CLASS QTY 645 0.81 X-3s 0.757 GRADE KIND 18 GRADE KIND r 18.546 0.82 LS 0.72 grade width 0.01947 0.82 a 0.72 21.02631579 0.6953952448 0.82 b0.8805023

25、88.44749367 0.7249 0.84 h0.00321005 1 0.000492150 0.83 0.0011875 0.02325 0.1832551 0.70158.1443E-05 0 0 0.70151.6778E-06 0.701500 0 1 0.7015 0.7015 0 0 0.0185 0.1785 052 0.70270.00010946 0 1 0.70636.0978E-06 0 -100 0.7063 0.7063 0 0 0.01375 0.17375 053 0.70390.00014658 0 2 0.71102.1011E-05 0 -100 0.

26、7110 0.7110 0 0 0.009 0.169 054 0.70510.00019556 0 3 0.71586.8639E-05 0 -100 0.7158 0.7158 0 0 0.00425 0.16425 055 0.70630.00025995 0 4 0.72050.00021258 0.720500 0 1 0.7205 0.7205 0 0 0.0005 0.1595 156 0.70740.00034425 0 5 0.72530.00062418 0 -100 0.7253 0.7253 0 0 0.00525 0.15475 057 0.7086 0.000454

27、2 0 6 0.73000.00173752 0 -100 0.7300 0.7300 0 0 0.01 0.15 058 0.70980.00059704 0 7 0.73480.00458554 0 -100 0.7348 0.7348 0 0 0.01475 0.14525 059 0.71100.00078187 0 8 0.73950.01147324 0.739500 1 1 0.7395 0.7395 0 1 0.0195 0.1405 060 0.71220.00102008 0 9 0.7443 0.0272156 1 -100 0.7443 0.7443 1 0 0.024

28、25 0.13575 061 0.71340.00132588 0 10 0.74900.06120489 1 -100 0.7490 0.7490 1 0 0.029 0.131 062 0.71460.00171686 0 11 0.75380.13049398 1 -100 0.7538 0.7538 1 0 0.03375 0.12625 063 0.71580.00221476 0 12 0.75850.26377341 0.758500 1 1 0.7585 0.7585 1 1 0.0385 0.1215 064 0.71690.00284623 0 13 0.76330.505

29、48436 1 -100 0.7633 0.7633 2 0 0.04325 0.11675 065 0.71810.00364387 0 14 0.76800.91837618 1 -100 0.7680 0.7680 2 0 0.048 0.112 066 0.71930.00464728 0 15 0.77281.58186593 1 -100 0.7728 0.7728 2 0 0.05275 0.10725 067 0.72050.00590435 0 16 0.77752.58318147 0.777500 2 1 0.7775 0.7775 2 2 0.0575 0.1025 0

30、68 0.7217 0.0074727 0 17 0.78233.99922961 2 -100 0.7823 0.7823 4 0 0.06225 0.09775 069 0.72290.00942126 0 18 0.78705.86994375 2 -100 0.7870 0.7870 4 0 0.067 0.093 070 0.72410.01183205 0 19 0.79188.16822549 2 -100 0.7918 0.7918 4 0 0.07175 0.08825 071 0.72530.01480215 0 20 0.796510.7760023 0.796500 1

31、1 1 0.7965 0.7965 4 3 0.0765 0.0835 072 0.72640.01844574 0 21 0.801313.4779491 11 -100 0.8013 0.8013 7 0 0.08125 0.07875 073 0.72760.02289641 0 22 0.8060 15.981816 11 -100 0.8060 0.8060 7 8 0.086 0.074 074 0.72880.02830943 0 23 0.8108 17.966547 11 -100 0.8108 0.8108 15 0 0.09075 0.06925 075 0.73000.

32、03486421 0 24 0.815519.1486997 0.815500 26 1 0.8155 0.8155 15 16 0.0955 0.0645 076 0.7312 0.0427667 0 25 0.820319.3486264 26 -100 0.8203 0.8203 31 0 0.10025 0.05975 077 0.73240.05225173 0 26 0.825018.5351953 26 -100 0.8250 0.8250 31 0 0.105 0.055 078 0.7336 0.0635852 0 27 0.829816.8337306 26 -100 0.

33、8298 0.8298 31 10 0.10975 0.05025 079 0.73480.07706601 0 28 0.834514.4943838 0.834500 9 1 0.8345 0.8345 41 0 0.1145 0.0455 080 0.73590.09302763 0 29 0.839311.8319226 9 -100 0.8393 0.8393 41 7 0.11925 0.04075 081 0.73710.111839060.1 30 0.84409.15687029 9 -100 0.8440 0.8440 48 0 0.124 0.036 082 0.7383

34、0.133905190.1 31 0.84886.71854116 9 -100 0.8488 0.8488 48 2 0.12875 0.03125 083 0.73950.159666210.2 32 0.85354.67346593 0.853500 0 1 0.8535 0.8535 50 0 0.1335 0.0265 084 0.74070.189596050.2 33 0.85833.08204771 0 -100 0.8583 0.8583 50 0 0.13825 0.02175 085 0.74190.224199470.2 34 0.86301.92697382 0 -1

35、00 0.8630 0.8630 50 0 0.143 0.017 086 0.74310.264007850.3 35 0.86781.14221655 0 -100 0.8678 0.8678 50 0 0.14775 0.01225 087 0.74430.309573210.3 36 0.87250.64188505 0.872500 0 1 0.8725 0.8725 50 0 0.1525 0.0075 088 0.74540.361460580.4 37 0.87730.34198121 0 -100 0.8773 0.8773 50 0 0.15725 0.00275 089

36、0.74660.420238370.4 38 0.88200.17273622 0 -100 0.8820 0.8820 50 0 0.162 0.002 190 0.74780.486466770.5 39 0.88680.08271814 0 -100 0.8868 0.8868 50 0 0.16675 0.00675 091 0.74900.560684110.6 40 0.89150.03755383 0.891500 0 1 0.8915 0.8915 50 0 0.1715 0.0115 092 0.75020.643391190.6 41 0.89630.01616382 0

37、-100 0.8963 0.8963 50 0 0.17625 0.01625 093 0.7514 0.73503370.7 42 0.90100.00659584 0 -100 0.9010 0.9010 50 0 0.181 0.021 094 0.75260.835983040.8 43 0.90580.00255171 0 -100 0.9058 0.9058 50 0 0.18575 0.02575 095 0.75380.946515670.9 44 0.9105 0.0009359 0.910500 0 1 0.9105 0.9105 50 0 0.1905 0.0305 09

38、6 0.75491.066791641.1 45 0.91530.00032544 0 -100 0.9153 0.9153 50 0 0.19525 0.03525 097 0.75611.196832681.2 46 0.92000.00010728 0 -100 0.9200 0.9200 50 0 0.2 0.04 098 0.75731.336500731.3 47 0.92483.3531E-05 0 -100 0.9248 0.9248 50 0 0.20475 0.04475 099 0.75851.485477511.5 48 0.92959.9354E-06 0.92950

39、0 0 1 0.9295 0.9295 50 0 0.2095 0.0495 0100 0.75971.643246221.6 49 0.9295 1 50101 0.76091.809076351.8 50102 0.76211.98201266 2 51103 0.76332.160869432.2 52104 0.76442.344231272.3 53105 0.76562.530461292.5 54106 0.76682.717717972.7 55107 0.76802.903981222.9 56108 0.7692 3.08708843.1 57109 0.7704 3.26

40、478063.3 58110 0.77163.434759163.4 59111 0.77283.594751933.6 60112 0.77393.742588533.7 61113 0.77513.876283233.9 62114 0.77633.99412358 4 63115 0.7775 4.09476274.1 64116 0.7787 4.17731224.2 65117 0.77994.241432874.2 66118 0.78114.287419444.3 67119 0.78234.316275854.3 68120 0.78344.329777144.3 69121

41、0.78464.330514124.3 70122 0.78584.321917374.3 71123 0.78704.308257124.3 72124 0.78824.294616344.3 73125 0.78944.286835114.3 74126 0.79064.291424824.3 75127 0.79184.315452164.3 76128 0.7929 4.36639374.4 77129 0.79414.451962964.5 78130 0.79534.579913284.6 79131 0.79654.757820724.8 80132 0.7977 4.99285

42、25 5 81133 0.79895.291527225.3 82134 0.80015.659474255.7 83135 0.80136.101199776.1 84136 0.80246.619867796.6 85137 0.80367.217103997.2 86138 0.80487.892830337.9 87139 0.80608.645137638.6 88140 0.80729.470202279.5 89141 0.808410.3622522 10 90142 0.809611.3135861 11 91143 0.8108 12.314647 12 92144 0.8

43、11913.3541517 13 93145 0.813114.4192728 14 94146 0.814315.4958716 15 95147 0.815516.5687743 17 96148 0.816717.6220869 18 97149 0.817918.6395377 19 98150 0.819119.6048406 20 99151 0.820320.5020657 21 100152 0.821421.3160091 21 101153 0.822622.0325484 22 102154 0.823822.6389753 23 103155 0.825023.1242

44、942 23 104156 0.826223.4794779 23 105157 0.827423.6976733 24 106158 0.828623.7743521 24 107159 0.829823.7074006 24 108160 0.830923.4971483 23 109161 0.832123.1463355 23 110162 0.833322.6600202 23 111163 0.834522.0454303 22 112164 0.835721.3117656 21 113165 0.836920.4699562 20 114166 0.838119.5323872

45、 20 115167 0.839318.5125962 19 116168 0.840417.4249556 17 117169 0.841616.2843471 16 118170 0.842815.1058394 15 119171 0.844013.9043768 14 120172 0.8452 12.694487 13 121173 0.846411.4900156 11 122174 0.847610.3038921 10 123175 0.84889.147932449.1 124176 0.84998.03268098 8 125177 0.85116.96729316 7 1

46、26178 0.85235.95945953 6 127179 0.85355.01536961 5 128180 0.85474.139713714.1 129181 0.85593.335719413.3 130182 0.85712.605218672.6 131183 0.85831.948741221.9 132184 0.85941.365629141.4 133185 0.86060.854167650.9 134186 0.86180.411726980.4 135187 0.86300.03491044 0 136188 0.8642 -0 137189 0.8654 -0

47、138190 0.8666 -0 139191 0.8678 -0 140192 0.8689 -1 141193 0.8701 -1 142194 0.8713 -1 143195 0.8725 -1 144196 0.8737 -1 145197 0.8749 -1 146198 0.8761 -1 147199 0.8773 -1 148200 0.8784 -0 1490.8796 -0 1500.8808 -0 1510.8820 -0 1520.8832 -0 1530.8844 -0 1540.8856 -0 1550.8868 -0 1560.8879 -0 1570.8891

48、 -0 1580.8903 -0 1590.8915 -0 1600.8927 -0 1610.8939 -0 1620.8951 -0 1630.8963 -0 1640.8974 -0 1650.8986 -0 1660.8998 -0 1670.9010 -0 1680.9022 -0 1690.9034 -0 1700.9046 -0 1710.9058 -0 1720.9069 -0 1730.9081 -0 1740.9093 -0 1750.9105 -0 1760.9117 -0 1770.9129 -0 1780.9141 -0 1790.9153 -0 1800.9164

49、-0 1810.9176 -0 1820.9188 -0 1830.9200 -0 1840.9212 -0 1850.9224 -0 1860.9236 -0 1870.9248 -0 1880.9259 -0 1890.9271 -0 1900.9283 -0 1910.9295 -0 192合計X S 管 制 圖管 制 圖 編 號 ：群 組 數大 小管 制X 圖S 圖 製 造 部 門期 間5 上 限 U C L1 7 . 8 1 3 4 . 2 0 2 總 組 數 中 心 限C L1 5 . 0 9 3 1 . 9 0 2 機 別抽 樣 方法2 5 下 限 L C L1 2 . 3 73 0 . 0 0 0 測 定 者日 期 9 / 2 2 /2 0 1 705 0 01 0 0 01 5 0 02 0 0 0批 號 1 2 3 4 5 6 7 8 9 1 0樣 1 1 6 . 0 0 1 6 . 0 0 1 6 . 0 0 1 5 . 0 0 1 6 . 0 0 1 3 . 0 0