SPC全套Excel版

X R 控控制制图图 控制图编号： 製 品 H104PCH104PC 規 格標 準 群組數大小 管 制X 圖R圖製 造 部 門 时间 名 稱 上限 USL0.905上限 UCL0.820.38 管制項目溝槽寬度中心限CL0.70總組數中心限CL0.720.18機 別抽樣方法随机 測量單位下限 LSL0.50 25下限 LCL0.610.00 測 定 者日 期2018/6/1 日期/ 時間 合 計 批號 12345678910111213141516171819202122232425 樣10.65 0.75 0.75 0.60 0.70 0.60 0.75 0.60 0.65 0.60 0.80 0.85 0.70 0.65 0.90 0.75 0.75 0.75 0.65 0.60 0.50 0.60 0.80 0.65 0.65 本20.70 0.85 0.80 0.70 0.75 0.75 0.80 0.70 0.80 0.70 0.75 0.75 0.70 0.70 0.80 0.80 0.70 0.70 0.65 0.60 0.55 0.80 0.65 0.60 0.70 測30.65 0.75 0.80 0.70 0.65 0.75 0.65 0.80 0.85 0.60 0.90 0.85 0.75 0.85 0.80 0.75 0.85 0.60 0.85 0.65 0.65 0.65 0.75 0.65 0.70量測數值的判定條件 定40.65 0.85 0.70 0.75 0.85 0.85 0.75 0.75 0.85 0.80 0.50 0.65 0.75 0.75 0.75 0.80 0.70 0.70 0.65 0.60 0.80 0.65 0.65 0.60 0.60 值50.85 0.65 0.75 0.65 0.80 0.70 0.70 0.75 0.75 0.65 0.80 0.70 0.70 0.60 0.85 0.65 0.80 0.60 0.70 0.65 0.80 0.75 0.65 0.70 0.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.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.66 R0.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.10R= x預估不良率 (PPM) 管 制 圖 10355 製程能力分析 Std.Dev.= Sigma = R 管 制 圖 Grade = 備註及原因追 查: 12345678910111213141516171819202122232425 0.00 0.10 0.20 0.30 0.40 0.50 12345678910111213141516171819202122232425 0.40 0.50 0.60 0.70 0.80 0.90 1.00 n2345678910 d21.131.692.062.332.532.72.852.973.082.33 D3000000.080.140.180.220 D43.272.572.282.11 2.001.921.861.821.782.11 A21.881.020.730.580.480.420.370.340.310.58 X UCL0.820.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 CL0.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.72 0.72 0.72 0.72 0.72 0.72 LCL0.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.99 0.420.56 0.56 0.36 0.49 0.36 0.56 0.36 0.42 0.36 0.64 0.72 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.11 0.490.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.09 0.420.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.72 0.42 0.42 0.42 0.56 0.42 0.49 0.0013.81 0.420.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.10 0.720.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.42 0.0012.87 0.000.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.000.00 R UCL0.380.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 CL0.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.18 0.18 0.18 0.18 0.18 LCL0.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 USL0.90 0.90 0.90 0.90 0.90 0.90 0.90 0.90 0.90 0.90 0.90 0.90 0.90 0.90 0.90 0.90 0.90 0.90 0.90 0.90 0.90 0.90 0.90 0.90 0.90 0.90 LSL0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 備註及原因追 查: 89.50 4.45 USL 藍色 =Range組界組界頻率XNormal =0.433339055793991=0.372223175965665 20.433340.43334020.3840.00324199 125 =0.494454935622318=0.433339055793991 30.494450.49445030.3970.00640954 0.72 =0.555570815450644=0.494454935622318 40.555570.55557340.4090.01235162 0.50 =0.61668669527897=0.555570815450644 50.616690.616691550.4210.0232008 0.90 =0.677802575107296=0.61668669527897 60.677800.677802760.4330.04247803 0.70 =0.738918454935622=0.677802575107296 70.738920.738922270.4460.07580672 5 =0.800034334763948=0.738918454935622 80.800030.800034380.4580.13186609 0.90 =0.861150214592274=0.800034334763948 90.861150.861151390.4700.22358394 0.50 =0.9222660944206=0.861150214592274 100.922270.922272100.4820.36951337 0.82 =0.983381974248926=0.9222660944206 110.983380.983380110.4940.59525324 0.61其他其他0120.5070.93466384 0.09130.5191.4305109 0.08DescriptionValue The limits are calculated as:Minimum Maximum delta140.5312.13407149 -0.01Sigma0.076Selected0.4101.0220.061150.5433.10319322 -0.56Mean0.716X0.5000.900160.5564.3983596 10355Delta0.061 LCL or UCL for X0.6130.819170.5686.0765169 8.00%Multiplier 7.639LSL or USL0.5000.900180.5808.1827776 0.80Maximum48.004*Sig+ Median0.4101.022190.59210.7406075 0.94200.60413.7416539 0.87210.61717.1368592 0.80220.62920.830779 230.64124.6809491 240.65328.5036358 250.66632.0863804 260.67835.2065327 270.69037.6537162 280.70239.2531483 290.71439.88625 300.72739.5051741 310.73938.1387815 320.75135.8890291 330.76332.9183961 340.77629.430503 350.78825.6471294 360.80021.7852177 370.81218.0371163 380.82414.556413 390.83711.45048 400.8498.77960706 410.8616.56158148 420.8734.77995749 430.8863.39407632 440.8982.34909854 450.9101.5847579 460.9221.04209348 470.9340.66793237 480.9470.4172923 490.9590.254115 500.9710.15083506 510.9830.08726827 5.5007.63817423 0.48680 0.48733.6 0.4870 0.5630 0.56324 0.5630 #N/A0 #N/A24 #N/A0 0.7160 0.71648.00 0.7160 #N/A0 #N/A24 #N/A0 #N/A0 #N/A24 #N/A0 #N/A0 #N/A33.6 #N/A0 0.9000 0.90048.00 0.9000 0.5000 0.50048.00 0.5000 2020/5/22 612dd7e3f325f459350542a3976c6600.xls TYPE OF TOLERENCE: BOTH SIDE 1, MAX TOL.3, MIN TOL 4, BCOLUMN 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 : 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.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 =0.23 160. 81 P C % =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 340. 83 350. 78 360. 81 370. 82 380. 82 390. 82 400. 8 410. 82MAX+SL/20. 8505MIN.UNIT0. 001 420. 83X+3s0. 881Max#VALUE! 430. 82US0. 88Min#VALUE!6. 838834413 440. 82MIN-SL/20. 7395KIND QTYT #VALUE!CLASS QTY6 450. 81X-3s0. 757GRADE KIND#VALUE!GRADE KIND r#VALUE! 460. 82LS0. 72grade width#VALUE! 470. 82a0. 72#VALUE!#VALUE!0. 69539524 480. 82b0. 88050238#VALUE!0. 72 490. 84h0. 00321005#VALUE!0. 0004921 500. 83#VALUE!#VALUE!#VALUE! 51#VALUE!#VALUE!#0#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 52#VALUE!#VALUE!#1#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 53#VALUE!#VALUE!#2#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 54#VALUE!#VALUE!#3#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 55#VALUE!#VALUE!#4#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 56#VALUE!#VALUE!#5#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 57#VALUE!#VALUE!#6#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 58#VALUE!#VALUE!#7#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 59#VALUE!#VALUE!#8#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 60#VALUE!#VALUE!#9#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 61#VALUE!#VALUE!#10#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 62#VALUE!#VALUE!#11#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 63#VALUE!#VALUE!#12#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 64#VALUE!#VALUE!#13#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 65#VALUE!#VALUE!#14#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 66#VALUE!#VALUE!#15#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 67#VALUE!#VALUE!#16#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 68#VALUE!#VALUE!#17#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 69#VALUE!#VALUE!#18#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 70#VALUE!#VALUE!#19#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 71#VALUE!#VALUE!#20#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 72#VALUE!#VALUE!#21#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 73#VALUE!#VALUE!#22#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 74#VALUE!#VALUE!#23#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 75#VALUE!#VALUE!#24#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 76#VALUE!#VALUE!#25#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 77#VALUE!#VALUE!#26#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 78#VALUE!#VALUE!#27#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 79#VALUE!#VALUE!#28#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 80#VALUE!#VALUE!#29#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 81#VALUE!#VALUE!#30#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 82#VALUE!#VALUE!#31#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 83#VALUE!#VALUE!#32#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 84#VALUE!#VALUE!#33#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 85#VALUE!#VALUE!#34#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 86#VALUE!#VALUE!#35#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 87#VALUE!#VALUE!#36#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 88#VALUE!#VALUE!#37#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 89#VALUE!#VALUE!#38#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 90#VALUE!#VALUE!#39#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 91#VALUE!#VALUE!#40#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 92#VALUE!#VALUE!#41#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 93#VALUE!#VALUE!#42#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 94#VALUE!#VALUE!#43#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 95#VALUE!#VALUE!#44#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 96#VALUE!#VALUE!#45#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 97#VALUE!#VALUE!#46#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 98#VALUE!#VALUE!#47#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 99#VALUE!#VALUE!#48#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!00#VALUE!#VALUE!#VALUE! 100#VALUE!#VALUE!#49#VALUE!#VALUE!0 101#VALUE!#VALUE!#50 102#VALUE!#VALUE!#51 103#VALUE!#VALUE!#52 104#VALUE!#VALUE!#53 105#VALUE!#VALUE!#54 106#VALUE!#VALUE!#55 107#VALUE!#VALUE!#56 108#VALUE!#VALUE!#57 109#VALUE!#VALUE!#58 110#VALUE!#VALUE!#59 111#VALUE!#VALUE!#60 112#VALUE!#VALUE!#61 113#VALUE!#VALUE!#62 114#VALUE!#VALUE!#63 115#VALUE!#VALUE!#64 116#VALUE!#VALUE!#65 117#VALUE!#VALUE!#66 118#VALUE!#VALUE!#67 119#VALUE!#VALUE!#68 120#VALUE!#VALUE!#69 121#VALUE!#VALUE!#70 122#VALUE!#VALUE!#71 123#VALUE!#VALUE!#72 124#VALUE!#VALUE!#73 125#VALUE!#VALUE!#74 126#VALUE!#VALUE!#75 127#VALUE!#VALUE!#76 128#VALUE!#VALUE!#77 129#VALUE!#VALUE!#78 130#VALUE!#VALUE!#79 131#VALUE!#VALUE!#80 132#VALUE!#VALUE!#81 133#VALUE!#VALUE!#82 134#VALUE!#VALUE!#83 135#VALUE!#VALUE!#84 136#VALUE!#VALUE!#85 137#VALUE!#VALUE!#86 138#VALUE!#VALUE!#87 139#VALUE!#VALUE!#88 140#VALUE!#VALUE!#89 141#VALUE!#VALUE!#90 142#VALUE!#VALUE!#91 143#VALUE!#VALUE!#92 144#VALUE!#VALUE!#93 145#VALUE!#VALUE!#94 146#VALUE!#VALUE!#95 147#VALUE!#VALUE!#96 148#VALUE!#VALUE!#97 149#VALUE!#VALUE!#98 150#VALUE!#VALUE!#99 151#VALUE!#VALUE!#100 152#VALUE!#VALUE!#101 153#VALUE!#VALUE!#102 154#VALUE!#VALUE!#103 155#VALUE!#VALUE!#104 156#VALUE!#VALUE!#105 157#VALUE!#VALUE!#106 158#VALUE!#VALUE!#107 159#VALUE!#VALUE!#108 160#VALUE!#VALUE!#109 161#VALUE!#VALUE!#110 162#VALUE!#VALUE!#111 163#VALUE!#VALUE!#112 164#VALUE!#VALUE!#113 165#VALUE!#VALUE!#114 166#VALUE!#VALUE!#115 167#VALUE!#VALUE!#116 168#VALUE!#VALUE!#117 169#VALUE!#VALUE!#118 170#VALUE!#VALUE!#119 171#VALUE!#VALUE!#120 172#VALUE!#VALUE!#121 173#VALUE!#VALUE!#122 174#VALUE!#VALUE!#123 175#VALUE!#VALUE!#124 176#VALUE!#VALUE!#125 177#VALUE!#VALUE!#126 178#VALUE!#VALUE!#127 179#VALUE!#VALUE!#128 180#VALUE!#VALUE!#129 181#VALUE!#VALUE!#130 182#VALUE!#VALUE!#131 183#VALUE!#VALUE!#132 184#VALUE!#VALUE!#133 185#VALUE!#VALUE!#134 186#VALUE!#VALUE!#135 187#VALUE!#VALUE!#136 188#VALUE!#VALUE!#137 189#VALUE!#VALUE!#138 190#VALUE!#VALUE!#139 191#VALUE!#VALUE!#140 192#VALUE!#VALUE!#141 193#VALUE!#VALUE!#142 194#VALUE!#VALUE!#143 195#VALUE!#VALUE!#144 196#VALUE!#VALUE!#145 197#VALUE!#VALUE!#146 198#VALUE!#VALUE!#147 199#VALUE!#VALUE!#148 200#VALUE!#VALUE!#149 #VALUE!#VALUE!#150 #VALUE!#VALUE!#151 #VALUE!#VALUE!#152 #VALUE!#VALUE!#153 #VALUE!#VALUE!#154 #VALUE!#VALUE!#155 #VALUE!#VALUE!#156 #VALUE!#VALUE!#157 #VALUE!#VALUE!#158 #VALUE!#VALUE!#159 #VALUE!#VALUE!#160 #VALUE!#VALUE!#161 #VALUE!#VALUE!#162 #VALUE!#VALUE!#163 #VALUE!#VALUE!#164 #VALUE!#VALUE!#165 #VALUE!#VALUE!#166 #VALUE!#VALUE!#167 #VALUE!#VALUE!#168 #VALUE!#VALUE!#169 #VALUE!#VALUE!#170 #VALUE!#VALUE!#171 #VALUE!#VALUE!#172 #VALUE!#VALUE!#173 #VALUE!#VALUE!#174 #VALUE!#VALUE!#175 #VALUE!#VALUE!#176 #VALUE!#VALUE!#177 #VALUE!#VALUE!#178 #VALUE!#VALUE!#179 #VALUE!#VALUE!#180 #VALUE!#VALUE!#181 #VALUE!#VALUE!#182 #VALUE!#VALUE!#183 #VALUE!#VALUE!#184 #VALUE!#VALUE!#185 #VALUE!#VALUE!#186 #VALUE!#VALUE!#187 #VALUE!#VALUE!#188 #VALUE!#VALUE!#189 #VALUE!#VALUE!#190 #VALUE!#VALUE!#191 #VALUE!#VALUE!#192 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! 0 0.2 0.4 0.6 0.8 1 合計 XS 管 制 圖 管制圖編號： 群組數大 小 管 制X 圖S圖製 造 部 門 期 間 5上限 UCL17.813 4.202 總組數中心限 CL 15.093 1.902 機 別抽樣方 法 25下限 LCL 12.373 0.000 測 定 者 日 期2018/6/ 1 0 200 400 600 800 1000 1200 1400 1600 1800 2000 批 號 1 2 3 4 5 6 7 8 9 10 樣 1 16.00 16.00 16.00 15.00 16.00 13.00 13.00 14.00 13.00 15.00 本 2 14.00 15.00 13.00 13.00 15.00 13.00 11.00 16.00 17.00 14.00 測 3 13.00 13.00 16.00 13.00 16.00 14.00 15.00 17.00 14.00 17.00 定 4 12.00 15.00 15.00 13.00 14.00 17.00 17.00 14.00 17.00 20.00 值 5 17.00 17.00 15.00 14.00 17.00 18.00 13.00 14.00 13.00 18.00 72.00 76.00 75.00 68.00 78.00 75.00 69.00 75.00 74.00 84.00 14.40 15.20 15.00 13.60 15.60 15.00 13.80 15.00 14.80 16.80 S 2.07 1.48 1.22 0.89 1.14 2.35 2.28 1.41 2.05 2.39 合計 XS 管 制 圖 管制圖編號： 群組數大 小 管 制X 圖S圖製 造 部 門 期 間 5上限 UCL17.813 4.202 總組數中心限 CL 15.093 1.902 機 別抽樣方 法 25下限 LCL 12.373 0.000 測 定 者 日 期2018/6/ 1 0 200 400 600 800 1000 1200 1400 1600 1800 2000 批 號 1 2 3 4 5 6 7 8 9 10 樣 1 16.00 16.00 16.00 15.00 16.00 13.00 13.00 14.00 13.00 15.00 本 2 14.00 15.00 13.00 13.00 15.00 13.00 11.00 16.00 17.00 14.00 測 3 13.00 13.00 16.00 13.00 16.00 14.00 15.00 17.00 14.00 17.00 定 4 12.00 15.00 15.00 13.00 14.00 17.00 17.00 14.00 17.00 20.00 值 5 17.00 17.00 15.00 14.00 17.00 18.00 13.00 14.00 13.00 18.00 72.00 76.00 75.00 68.00 78.00 75.00 69.00 75.00 74.00 84.00 14.40 15.20 15.00 13.60 15.60 15.00 13.80 15.00 14.80 16.80 S 2.07 1.48 1.22 0.89 1.14 2.35 2.28 1.41 2.05 2.39 X S 管管 制制 圖圖 管制圖編號： 製 品規 格標 準 群組數大小 管 制X 圖S圖製 造 部 門 期 間 名 稱 上限 USL46.0505上限 UCL17.8134.202 管制項目中心限CL45.650總組數中心限CL15.0931.902機 別抽樣方法 測量單位下限 LSL45.250 25下限 LCL12.3730.000 測 定 者日 期2018/6/1 日期/ 時間 合 計 批號 12345678910111213141516171819202122232425 樣116.00 16.00 16.00 15.00 16.00 13.00 13.00 14.00 13.00 15.00 11.00 17.00 20.00 18.00 12.00 11.00 17.00 13.00 19.00 14.