全套SPC控制图软件(自动生成).xls

X R 管管 制制 圖圖 管制圖編號： 製 品 H104PCH104PC 規 格標 準 群組數大小 管 制X 圖R圖製 造 部 門 期 間 名 稱 上限 USL25.905上限 UCL25.820.09 管制項目溝槽寬度中心限CL25.80總組數中心限CL25.800.04機 別抽樣方法 測量單位下限 LSL25.70 25下限 LCL25.770.00 測 定 者日 期 日期/ 時間 批號 12345678910111213141516171819202122232425 樣1 25.77 25.81 25.83 25.82 25.82 25.77 25.79 25.78 25.81 25.77 25.78 25.80 25.81 25.80 25.78 25.78 25.83 25.76 25.79 25.81 25.77 25.81 25.79 25.78 25.78 本2 25.83 25.81 25.78 25.80 25.83 25.80 25.78 25.80 25.79 25.84 25.79 25.78 25.81 25.79 25.79 25.82 25.79 25.80 25.81 25.79 25.82 25.82 25.83 25.78 25.80 測3 25.79 25.79 25.80 25.81 25.82 25.80 25.79 25.83 25.79 25.83 25.79 25.80 25.77 25.79 25.82 25.80 25.82 25.79 25.80 25.78 25.77 25.76 25.81 25.81 25.82 定4 25.80 25.81 25.81 25.78 25.80 25.77 25.79 25.83 25.82 25.82 25.81 25.84 25.83 25.78 25.82 25.81 25.80 25.77 25.79 25.82 25.77 25.77 25.77 25.81 25.76 值5 25.81 25.81 25.80 25.81 25.81 25.79 25.80 25.81 25.80 25.78 25.80 25.84 25.79 25.82 25.79 25.78 25.80 25.77 25.81 25.79 25.76 25.79 25.81 25.81 25.78 129.00129.03129.02129.02129.08128.93128.95129.04129.02129.03128.97129.06129.02128.98129.00128.99129.05128.89129.00128.99128.88128.95129.00128.99128.94 25.80 25.81 25.80 25.80 25.82 25.79 25.79 25.81 25.80 25.81 25.79 25.81 25.80 25.80 25.80 25.80 25.81 25.78 25.80 25.80 25.78 25.79 25.80 25.80 25.79 R0.06 0.02 0.06 0.04 0.02 0.03 0.02 0.05 0.04 0.07 0.03 0.06 0.06 0.04 0.04 0.04 0.04 0.04 0.02 0.03 0.06 0.06 0.06 0.04 0.06 x 管 制 圖 R 管 制 圖 備註及原因追 查: 12345678910111213141516171819202122232425 0.00 0.02 0.04 0.06 0.08 0.10 12345678910111213141516171819202122232425 25.55 25.65 25.75 25.85 25.95 備註及原因追 查: 隨機 12月15日 合計 3224.84 1.08 量測數值的判定條件 USL 藍色 USL 藍色 USL 藍色 USL 藍色 < LSL 紅色 平 均 R=0.00 預估不良率 (PPM) #VALUE! 製程能力分析 Std.Dev.= Sigma =0.00 = PP = Ca = = CP = Grade = P 管管 制制 圖圖 管制圖編號： 製品名稱部 門上 限 UCL4.55%中心限 CL2.55%下 限 LCL0.56%子組數26 樣本上限 制程名稱機 台記 錄 者日 期P2.55%樣本容量 n 563 樣本下限 日期 1234567891011121314151617181920212223242526 檢查數量 500450500650500550500650500500700500500650500700500650500600500700500700500650 不 良 內 容 及 數 量 1215121514141414141420122215201222151414131312121111 總不良數1215121514141414141420122215201222151414131312121111 不良率 2.40% 3.33% 2.40% 2.31% 2.80% 2.55% 2.80% 2.15% 2.80% 2.80% 2.86% 2.40% 4.40% 2.31% 4.00% 1.71% 4.40% 2.31% 2.80% 2.25% 2.60% 1.79% 2.40% 1.64% 2.20% 1.62% P 管 制 圖 備註及原因追查 : 1234567891011121314151617181920212223242526 0.0% 0.5% 1.0% 1.5% 2.0% 2.5% 3.0% 3.5% 4.0% 4.5% 5.0% 704 423 合計備註 14650 374 0 0 0 0 0 0 0 374 2.55% 1234567891011121314151617181920212223242526 0.0% 0.5% 1.0% 1.5% 2.0% 2.5% 3.0% 3.5% 4.0% 4.5% 5.0% nP 管管 制制 圖圖 管制圖編號： 製品名稱部 門上 限 UCL26.36中心限 CL15.25下 限 LCL4.15子組數26 樣本上限 制程名稱機 台記 錄 者日 期nP15.25樣本容量 n 150 樣本下限 日期 1234567891011121314151617181920212223242526 檢查數量 150150150150150150150150150150150150150150150150150150150150150150150150150150 不 良 內 容 及 數 量 1215201222151417171720122215201222151414131312121111 總不良數1215201222151417171720122215201222151414131312121111 不良率 8.00%10.00% 13.33%8.00%14.67% 10.00%9.33%11.14% 11.24% 11.33% 13.33%8.00%14.67% 10.00% 13.33%8.00%14.67% 10.00%9.33% 9.00% 8.67% 8.33% 8.00% 7.67% 7.33% 7.00% P 管 制 圖 備註及原因追查 : 1234567891011121314151617181920212223242526 0 5 10 15 20 25 30 188 113 合計備註 3900 397 0 0 0 0 0 0 0 397 10.17% 1234567891011121314151617181920212223242526 0 5 10 15 20 25 30 C 管管 制制 圖圖 管制圖編號： 製品名稱部 門上 限 UCL26.97中心限 CL15.25下 限 LCL3.54子組數26 樣本上限 制程名稱機 台記 錄 者日 期C15.25樣本容量 n2樣本下限 日期 1234567891011121314151617181920212223242526 檢查數量 22222222222222222222222222 不 良 內 容 及 數 量 1215201222151417171720122215201222151414131312121111 總不良數1215201222151417171720122215201222151414131312121111 不良率 600.00% 750.00%1000.00%600.00%1100.00%750.00% 700.00% 835.71% 842.86% 850.00%1000.00%600.00%1100.00%750.00%1000.00%600.00%1100.00%750.00% 700.00% 675.00% 650.00% 625.00% 600.00% 575.00% 550.00% 525.00% P 管 制 圖 備註及原因追查 : 1234567891011121314151617181920212223242526 0 5 10 15 20 25 30 3 2 合計備註 52 397 0 0 0 0 0 0 0 397 762.64% 1234567891011121314151617181920212223242526 0 5 10 15 20 25 30 U 管管 制制 圖圖 管制圖編號： 製品名稱部 門上 限 UCL3.17中心限 CL1.79下 限 LCL0.42子組數26 樣本上限 制程名稱機 台記 錄 者日 期U1.79樣本容量 n9樣本下限 日期 1234567891011121314151617181920212223242526 檢查數量 87979810797981099791098107108108 不 良 內 容 及 數 量 1215201222151417171720122215201222151414131312121111 總不良數1215201222151417171720122215201222151414131312121111 不良率1.50 2.14 2.22 1.71 2.44 1.88 1.40 2.39 1.87 2.43 2.22 1.50 2.20 1.74 2.29 1.71 2.44 1.50 1.56 1.69 1.30 1.79 1.21 1.44 1.08 1.31 P 管 制 圖 備註及原因追查 : 1234567891011121314151617181920212223242526 0.0 0.5 1.0 1.5 2.0 2.5 3.0 3.5 11 6 合計備註 221 397 0 0 0 0 0 0 0 397 1.79 1234567891011121314151617181920212223242526 0.0 0.5 1.0 1.5 2.0 2.5 3.0 3.5 控控制制图图的的常常数数和和公公式式表表 - -图图 -s-s图图 均均值值图图 全全距距图图 均均值值图图 标标准准差差图图 子子组组 容容量量 计计算算控控制制 限限用用的的系系 数数 标标准准差差估估 计计值值的的除除 数数 计计算算控控制制限限用用的的系系 数数 计计算算控控制制 限限用用的的系系 数数 标标准准差差估估 计计值值的的除除 数数 计计算算控控制制限限用用的的系系数数 n nA A2 2d d2 2D D3 3D D4 4A A3 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.0041.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.7771.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 15150.2230.2233.4723.4720.3470.3471.6531.6530.7890.7890.98230.98230.4280.428 16160.2120.2123.5323.5320.3630.3631.6371.6370.7630.7630.98350.98350.4480.448 17170.2030.2033.5883.5880.3780.3781.6221.6220.7390.7390.98450.98450.4460.446 18180.1940.1943.6403.6400.3910.3911.6081.6080.7180.7180.98540.98540.4820.482 19190.1870.1873.6893.6890.4030.4031.5971.5970.6980.6980.98620.98620.4970.497 20200.1800.1803.7353.7350.4150.4151.5851.5850.6800.6800.98690.98690.5100.510 21210.1730.1733.7783.7780.4250.4251.5751.5750.6630.6630.98760.98760.5230.523 22220.1670.1673.8193.8190.4340.4341.5661.5660.6470.6470.98820.98820.5340.534 23230.1620.1623.8583.8580.4430.4431.5571.5570.6330.6330.98870.98870.5450.545 24240.1570.1573.8953.8950.4510.4511.5481.5480.6190.6190.98920.98920.5550.555 25250.1530.1533.9313.9310.4590.4591.5411.5410.6060.6060.98960.98960.5650.565 UCLUCLX X,LCL,LCLX X = =XAXA2 2R RUCLUCLX X,LCL,LCLX X = =XAXA2 2R R UCLUCLR R = = D D4 4R RUCLUCLS S = = B B4 4s s LCLLCLR R = = D D3 3R RLCLLCLS S = = B B3 3s s =R/D=R/D2 2= s/cs/c4 4 中中位位数数图图單單值值圖圖 中中位位数数图图 全全距距图图 单单值值图图 全全距距图图 子子组组 容容量量 计计算算控控制制 限限用用的的系系 数数 标标准准差差估估 计计值值的的除除 数数 计计算算控控制制限限用用的的系系 数数 计计算算控控制制 限限用用的的系系 数数 标标准准差差估估 计计值值的的除除 数数 计计算算控控制制限限用用的的系系数数 n nA A2 2d d2 2D D3 3D D4 4E E2 2d d2 2D D3 3 2 21.8801.8801.1281.128- -3.2673.2672.6602.6601.1281.128- - 3 31.1871.1871.6931.693- -2.5742.5741.7721.7721.6931.693- - 4 40.7960.7962.0592.059- -2.2822.2821.4571.4572.0592.059- - 5 50.6910.6912.3262.326- -2.1142.1141.2901.2902.3262.326- - 6 60.5480.5482.5342.534- -2.0042.0041.1841.1842.5342.534- - 7 70.5080.5082.7042.7040.0760.0761.9241.9241.1091.1092.7042.7040.0760.076 8 80.4330.4332.8472.8470.1360.1361.8641.8641.0541.0542.8472.8470.1360.136 9 90.4120.4122.9702.9700.1840.1841.8161.8161.0101.0102.9702.9700.1840.184 10100.3620.3623.0783.0780.2230.2231.7771.7770.9750.9753.0783.0780.2230.223 UCLUCLX X,LCL,LCLX X = =XAXA2 2R RUCLUCLX X,LCL,LCLX X = =XEXE2 2R R UCLUCLR R = = D D4 4R RUCLUCLMRMR = = D D4 4R R LCLLCLR R = = D D3 3R RLCLLCLMRMR = = D D3 3R R =R/d=R/d2 2= R/dR/d2 2 UCLUCLP P,LCL,LCLP P = = P3P3P P ( ( 1 1 - - P P ) ) /n/n = = P3P3P P ( ( 1 1 - - P P ) ) /n/n B B4 4UCLUCLnp np,LCL,LCLnpnp = =nP3nnP3nP P ( ( 1 1 - - P P ) ) 3.2763.276 2.5682.568UCLUCLC C,LCL,LCLC C = = C3C3C C 2.2662.266 2.0892.089UCLUCLU U,LCL,LCLU U = = U3U3U/nU/n 1.9701.970 1.8821.882 1.8151.815 1.7611.761 1.7161.716 1.6791.679 1.6401.640 1.6181.618 1.5941.594 1.5721.572 1.5521.552 1.5341.534 1.5181.518 1.5031.503CpkCpk( ( 1 1 k k ) ) CpCp 或或 MINMIN CPU,CPLCPU,CPL 1.4901.490PpkPpk( ( 1 1 k k ) ) PpPp 或或 MINMIN PPU,PPLPPU,PPL 1.4771.477单单边边规规格格( (设设计计规规格格) )因因没没有有规规格格上上限限或或下下限限, ,没没有有规规格格下下限限 CpCp CPUCPU Cpk,Cpk,没没有有规规格格上上限限 CpCp CPLCPL CpkCpk 1.4661.466 1.4551.455 1.4451.445 1.4351.435 D D4 4 3.2673.267 2.5742.574 控控制制图图的的常常数数和和公公式式表表 -s-s图图 标标准准差差图图 计计算算控控制制限限用用的的系系数数 單單值值圖圖 全全距距图图 计计算算控控制制限限用用的的系系数数 2.2822.282 2.1142.114 2.0042.004 1.9241.924 1.8641.864 1.8161.816 1.7771.777 单单边边规规格格( (设设计计规规格格) )因因没没有有规规格格上上限限或或下下限限, ,没没有有规规格格下下限限 CpCp CPUCPU Cpk,Cpk,没没有有规规格格上上限限 CpCp CPLCPL CpkCpk 標準正態分佈 z過程輸出超過特殊規定值（如工程規範限）的比例，這個特殊規定值與過程均值相距為z個標準差單位 （針對處於統計控制狀態並呈現正態分佈的過程）。如-2.17，則z0.0150或1.5，在任何實際情況下， 該比例為近似值。 或 x.x0 x.x0 x.x1x.x1x.x2x.x2x.x3x.x3x.x4x.x4x.x5x.x5x.x6x.x6 4.04.00.000030.00003 3.93.90.000050.000050.000050.000050.000040.000040.000040.000040.000040.000040.000040.000040.000040.00004 3.83.80.000070.000070.000070.000070.000070.000070.000060.000060.000060.000060.000060.000060.000060.00006 3.73.70.000110.000110.000100.000100.000100.000100.000100.000100.000090.000090.000090.000090.000080.00008 3.63.60.000160.000160.000150.000150.000150.000150.000140.000140.000140.000140.000130.000130.000130.00013 3.53.50.000230.000230.000220.000220.000220.000220.000210.000210.000200.000200.000190.000190.000190.00019 3.43.40.000340.000340.000320.000320.000310.000310.000300.000300.000290.000290.000280.000280.000270.00027 3.33.30.000480.000480.000470.000470.000450.000450.000430.000430.000420.000420.000400.000400.000390.00039 3.23.20.000690.000690.000660.000660.000640.000640.000620.000620.000600.000600.000580.000580.000560.00056 3.13.10.000970.000970.000940.000940.000900.000900.000870.000870.000840.000840.000820.000820.000790.00079 3.03.00.001350.001350.001310.001310.001260.001260.001220.001220.001180.001180.001140.001140.001110.00111 2.92.90.00190.00190.00180.00180.00180.00180.00170.00170.00160.00160.00160.00160.00150.0015 2.82.80.00260.00260.00250.00250.00240.00240.00230.00230.00230.00230.00220.00220.00210.0021 2.72.70.00350.00350.00340.00340.00330.00330.00320.00320.00310.00310.00300.00300.00290.0029 2.62.60.00470.00470.00450.00450.00440.00440.00430.00430.00410.00410.00400.00400.00390.0039 2.52.50.00620.00620.00600.00600.00590.00590.00570.00570.00550.00550.00540.00540.00520.0052 2.42.40.00820.00820.00800.00800.00780.00780.00750.00750.00730.00730.00710.00710.00690.0069 2.32.30.01070.01070.01040.01040.01020.01020.00990.00990.00960.00960.00940.00940.00910.0091 2.22.20.01390.01390.01360.01360.01320.01320.01290.01290.01250.01250.01220.01220.01190.0119 2.12.10.01790.01790.01740.01740.01700.01700.01660.01660.01620.01620.01580.01580.01540.0154 2.02.00.02280.02280.02220.02220.02170.02170.02120.02120.02070.02070.02020.02020.01970.0197 1.91.90.02870.02870.02810.02810.02740.02740.02680.02680.02620.02620.02560.02560.02500.0250 1.81.80.03590.03590.03510.03510.03440.03440.03360.03360.03290.03290.03220.03220.03140.0314 1.71.70.04460.04460.04360.04360.04270.04270.04180.04180.04090.04090.04010.04010.03920.0392 1.61.60.05480.05480.05370.05370.05260.05260.05160.05160.05050.05050.04950.04950.04850.0485 1.51.50.06680.06680.06550.06550.06430.06430.06300.06300.06180.06180.06060.06060.05940.0594 1.41.40.08080.08080.07930.07930.07780.07780.07640.07640.07490.07490.07350.07350.07210.0721 1.31.30.09680.09680.09510.09510.09340.09340.09180.09180.09010.09010.08850.08850.08690.0869 z SL Pz X z SL Pz X 1.21.20.11510.11510.11310.11310.11120.11120.10930.10930.10750.10750.10560.10560.10380.1038 1.11.10.13570.13570.13350.13350.13140.13140.12920.12920.12710.12710.12510.12510.12300.1230 1.01.00.15870.15870.15620.15620.15390.15390.15150.15150.14920.14920.14690.14690.14460.1446 0.90.90.18410.18410.18140.18140.17880.17880.17620.17620.17360.17360.17110.17110.16850.1685 0.80.80.21190.21190.20900.20900.20610.20610.20330.20330.20050.20050.19770.19770.19490.1949 0.70.70.24200.24200.23890.23890.23580.23580.23270.23270.22970.22970.22660.22660.22360.2236 0.60.60.27430.27430.27090.27090.26760.26760.26430.26430.26110.26110.25780.25780.25460.2546 0.50.50.30850.30850.30500.30500.30150.30150.29810.29810.29460.29460.29120.29120.28770.2877 0.40.40.34460.34460.34090.34090.33720.33720.33360.33360.33000.33000.32640.32640.32280.3228 0.30.30.38210.38210.37830.37830.37450.37450.37070.37070.36690.36690.36320.36320.35940.3594 0.20.20.42070.42070.41680.41680.41290.41290.40900.40900.40520.40520.40130.40130.39740.3974 0.10.10.46020.46020.45620.45620.45220.45220.44830.44830.44430.44430.44040.44040.43640.4364 0.00.00.50000.50000.49600.49600.49200.49200.48800.48800.48400.48400.48010.48010.47610.4761 x.x7x.x7x.x8x.x8x.x9x.x9 0.000040.000040.000030.000030.000030.00003 0.000050.000050.000050.000050.000050.00005 0.000080.000080.000080.000080.000080.00008 0.000120.000120.000120.000120.000110.00011 0.000180.000180.000170.000170.000170.00017 0.000260.000260.000250.000250.000240.00024 0.000380.000380.000360.000360.000350.00035 0.000540.000540.000520.000520.000500.00050 0.000760.000760.000740.000740.000710.00071 0.001070.001070.001040.001040.001000.00100 0.00150.00150.00140.00140.00140.0014 0.00210.00210.00200.00200.00190.0019 0.00280.00280.00270.00270.00260.0026 0.00380.00380.00370.00370.00360.0036 0.00510.00510.00490.00490.00480.0048 0.00680.00680.00660.00660.00640.0064 0.00890.00890.00870.00870.00840.0084 0.01160.01160.01130.01130.01100.0110 0.01500.01500.01460.01460.01430.0143 0.01920.01920.01880.01880.01830.0183 0.02440.02440.02390.02390.02330.0233 0.03070.03070.03010.03010.02940.0294 0.03840.03840.03750.03750.03670.0367 0.04750.04750.04650.04650.04550.0455 0.05820.05820.05710.05710.05590.0559 0.07080.07080.06940.06940.06810.0681 0.08530.08530.08380.08380.08230.0823 標準正態分佈 z過程輸出超過特殊規定值（如工程規範限）的比例，這個特殊規定值與過程均值相距為z個標準差單位 （針對處於統計控制狀態並呈現正態分佈的過程）。如-2.17，則z0.0150或1.5，在任何實際情況下， z SL Pz X 0.10200.10200.10030.10030.09850.0985 0.12100.12100.11900.11900.11700.1170 0.14230.14230.14010.14010.13790.1379 0.16600.16600.16350.16350.16110.1611 0.19220.19220.18940.18940.18670.1867 0.22060.22060.21770.21770.21480.2148 0.25140.25140.24830.24830.24510.2451 0.28430.28430.28100.28100.27760.2776 0.31920.31920.31560.31560.31210.3121 0.35570.35570.35200.35200.34830.3483 0.39360.39360.38970.38970.38590.3859 0.43250.43250.42860.42860.42470.4247 0.47210.47210.46810.46810.46410.4641 控控制制圖圖選選用用程程序序 否否 是是 是 否 是是 否否 是 是 否 是 否 是 確定要制定控 制圖的特性 是計量型 數據嗎？ 合格品- 樣品容量 是否恆 格數- 樣品容量 是否恆 使用圖 使用中位數圖 子組取樣-例如 批量油漆等 子組均值是 否能方便地 計算？ - 子組容量 大於或等 於嗎？ 使用 -圖 是否能方便 地計算每個 子組的 使用 -圖 使用 -圖 使用或圖 否 使