SPC&CPK 超全EXCEL模板

1、 X R 管管 制制 圖圖管制圖編號： 製 品H104PCH104PC規 格標 準群組數大小管 制X 圖R圖製 造 部 門期 間名 稱上限 USL25.905上限 UCL25.830.09管制項目溝槽寬度中心限CL25.80總組數中心限CL25.800.04機 別抽樣方法測量單位下限 LSL25.7025下限 LCL25.770.00測 定 者日 期日期/ 時間批號12345678910111213141516171819202122232425樣125.80 25.80 25.80 25.82 25.76 25.81 25.80 25.83 25.82 25.83 25.80 25.83 2

2、5.79 25.81 25.78 25.82 25.80 25.80 25.78 25.78 25.78 25.78 25.80 25.82 25.77本225.81 25.81 25.80 25.80 25.81 25.80 25.80 25.81 25.79 25.83 25.79 25.78 25.80 25.81 25.80 25.77 25.80 25.76 25.83 25.79 25.81 25.82 25.76 25.81 25.80測325.83 25.83 25.82 25.77 25.78 25.82 25.79 25.80 25.78 25.78 25.82 25.82

3、 25.80 25.78 25.79 25.83 25.80 25.79 25.79 25.79 25.79 25.82 25.81 25.79 25.79定425.78 25.80 25.81 25.81 25.79 25.83 25.81 25.79 25.82 25.84 25.79 25.81 25.82 25.83 25.81 25.83 25.79 25.79 25.80 25.80 25.79 25.82 25.81 25.80 25.77值525.84 25.76 25.78 25.81 25.77 25.81 25.82 25.84 25.80 25.82 25.78 25.

4、80 25.83 25.83 25.81 25.77 25.80 25.83 25.80 25.78 25.80 25.77 25.83 25.79 25.80129.05129.00129.00129.00128.90129.07129.02129.07129.01129.10128.98129.03129.04129.06128.99129.03128.99128.98129.00128.94128.98129.01129.01129.01128.9425.81 25.80 25.80 25.80 25.78 25.81 25.80 25.81 25.80 25.82 25.80 25.8

5、1 25.81 25.81 25.80 25.81 25.80 25.80 25.80 25.79 25.80 25.80 25.80 25.80 25.79R0.06 0.07 0.04 0.05 0.04 0.02 0.02 0.05 0.04 0.06 0.05 0.05 0.03 0.05 0.04 0.06 0.01 0.06 0.05 0.02 0.03 0.06 0.07 0.03 0.03x管制圖R管制圖備註及原因追查:123456789101112131415161718192021222324250.00 0.02 0.04 0.06 0.08 0.10 123456789

6、1011121314151617181920212223242525.55 25.65 25.75 25.85 25.95 備註及原因追查:隨機5月27日合計3225.201.10量測數值的判定條件 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.

7、55%樣本容量 n 563 樣本下限日期1234567891011121314151617181920212223242526檢查數量500450500650500550500650500500700500500650500700500650500600500700500700500650不良內容及數量1215121514141414141420122215201222151414131312121111總不良數1215121514141414141420122215201222151414131312121111不良率2.40% 3.33% 2.40% 2.31% 2.80% 2.55% 2

8、.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管制圖備註及原因追查:12345678910111213141516171819202122232425260.0%0.5%1.0%1.5%2.0%2.5%3.0%3.5%4.0%4.5%5.0%704423合計備註1465037400000003742.55%12345678910111213141516171819202122232425260.0%0.5

9、%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不良內容及數量12152012221514171717201

10、22215201222151414131312121111總不良數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管制圖備註及原因追查:123456789101112131415161718192021222324252

11、60 5 10 15 20 25 30 188113合計備註3900397000000039710.17%12345678910111213141516171819202122232425260 5 10 15 20 25 30 C 管管 制制 圖圖管制圖編號： 製品名稱部 門上 限 UCL26.97中心限 CL15.25下 限 LCL3.54子組數26 樣本上限制程名稱機 台記 錄 者日 期C15.25樣本容量 n2樣本下限日期1234567891011121314151617181920212223242526檢查數量22222222222222222222222222不良內容及數量121

12、5201222151417171720122215201222151414131312121111總不良數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

13、% 525.00%P管制圖備註及原因追查:12345678910111213141516171819202122232425260 5 10 15 20 25 30 32合計備註523970000000397762.64%12345678910111213141516171819202122232425260 5 10 15 20 25 30 U 管管 制制 圖圖管制圖編號： 製品名稱部 門上 限 UCL3.17中心限 CL1.79下 限 LCL0.42子組數26 樣本上限制程名稱機 台記 錄 者日 期U1.79樣本容量 n9樣本下限日期1234567891011121314151617181

14、920212223242526檢查數量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.31P管

15、制圖備註及原因追查:12345678910111213141516171819202122232425260.0 0.5 1.0 1.5 2.0 2.5 3.0 3.5 116合計備註22139700000003971.7912345678910111213141516171819202122232425260.0 0.5 1.0 1.5 2.0 2.5 3.0 3.5 控控制制图图的的常常数数和和公公式式表表 - -图图 -s -s图图 均均值值图图 全全距距图图 均均值值图图 标标准准差差图图 子子组组容容量量计计算算控控制制限限用用的的系系数数标标准准差差估估计计值值的的除除数数计计算算

16、控控制制限限用用的的系系数数计计算算控控制制限限用用的的系系数数标标准准差差估估计计值值的的除除数数计计算算控控制制限限用用的的系系数数n nA A2 2d d2 2D D3 3D D4 4A A3 3c c4 4B B3 32 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

17、.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.0307 70.4190.4192.7042.7040.0760.0761.9241.9241.1821.1820.95940.95940.1180.1188 80.3730.3732.8472.8470.1360.1361.8641.8641.0991.0990.96500.96500.1850.1859 90.3370.3372.9702.9700.

18、1840.1841.8161.8161.0321.0320.96930.96930.2390.23910100.3080.3083.0783.0780.2230.2231.7771.7770.9750.9750.97270.97270.2840.28411110.2850.2853.1733.1730.2560.2561.7441.7440.9270.9270.97540.97540.3210.32112120.2660.2663.2583.2580.2830.2831.7171.7170.8860.8860.97760.97760.3540.35413130.2490.2493.3363.3

19、360.3070.3071.6931.6930.8500.8500.97940.97940.3820.38214140.2350.2353.4073.4070.3280.3281.6721.6720.8170.8170.98100.98100.4060.40615150.2230.2233.4723.4720.3470.3471.6531.6530.7890.7890.98230.98230.4280.42816160.2120.2123.5323.5320.3630.3631.6371.6370.7630.7630.98350.98350.4480.44817170.2030.2033.58

20、83.5880.3780.3781.6221.6220.7390.7390.98450.98450.4460.44618180.1940.1943.6403.6400.3910.3911.6081.6080.7180.7180.98540.98540.4820.48219190.1870.1873.6893.6890.4030.4031.5971.5970.6980.6980.98620.98620.4970.49720200.1800.1803.7353.7350.4150.4151.5851.5850.6800.6800.98690.98690.5100.51021210.1730.173

21、3.7783.7780.4250.4251.5751.5750.6630.6630.98760.98760.5230.52322220.1670.1673.8193.8190.4340.4341.5661.5660.6470.6470.98820.98820.5340.53423230.1620.1623.8583.8580.4430.4431.5571.5570.6330.6330.98870.98870.5450.54524240.1570.1573.8953.8950.4510.4511.5481.5480.6190.6190.98920.98920.5550.55525250.1530

22、.1533.9313.9310.4590.4591.5411.5410.6060.6060.98960.98960.5650.565UCLUCLX X,LCL,LCLX X = =XAXA2 2R RUCLUCLX X,LCL,LCLX X = =XAXA2 2R RUCLUCLR R = = D D4 4R RUCLUCLS S = = B B4 4s sLCLLCLR R = = D D3 3R RLCLLCLS S = = B B3 3s s=R/D=R/D2 2= s/cs/c4 4中中位位数数图图單單值值圖圖中中位位数数图图 全全距距图图 单单值值图图 全全距距图图 子子组组容容量量

23、计计算算控控制制限限用用的的系系数数标标准准差差估估计计值值的的除除数数计计算算控控制制限限用用的的系系数数计计算算控控制制限限用用的的系系数数标标准准差差估估计计值值的的除除数数计计算算控控制制限限用用的的系系数数n nA A2 2d d2 2D D3 3D D4 4E E2 2d d2 2D D3 32 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.2

24、822.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.0768 80.4330.4332.8472.8470.1360.1361.8641.8641.0541.0542.8472.8470.1360.1369 90.4

25、120.4122.9702.9700.1840.1841.8161.8161.0101.0102.9702.9700.1840.18410100.3620.3623.0783.0780.2230.2231.7771.7770.9750.9753.0783.0780.2230.223UCLUCLX X,LCL,LCLX X = =XAXA2 2R RUCLUCLX X,LCL,LCLX X = =XEXE2 2R RUCLUCLR R = = D D4 4R RUCLUCLMRMR = = D D4 4R RLCLLCLR R = = D D3 3R RLCLLCLMRMR = = D D3 3

26、R 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 /nB B4 4UCLUCLnpnp,LCL,LCLnpnp = =nP3nnP3nP P ( ( 1 1 - - P P ) ) 3

27、.2763.2762.5682.568UCLUCLC C,LCL,LCLC C = = C3C3C C2.2662.2662.0892.089UCLUCLU U,LCL,LCLU U = = U3U3U/nU/n1.9701.9701.8821.8821.8151.8151.7611.7611.7161.7161.6791.6791.6401.6401.6181.6181.5941.5941.5721.5721.5521.5521.5341.5341.5181.5181.5031.503CpkCpk( ( 1 1 k k ) ) CpCp 或或 MINMIN CPU,CPLCPU,CPL1.4

28、901.490PpkPpk( ( 1 1 k k ) ) PpPp 或或 MINMIN PPU,PPLPPU,PPL1.4771.477单单边边规规格格( (设设计计规规格格) )因因没没有有规规格格上上限限或或下下限限, ,没没有有规规格格下下限限 CpCp CPUCPU Cpk,Cpk,没没有有规规格格上上限限 CpCp CPLCPL CpkCpk1.4661.4661.4551.4551.4451.4451.4351.435控控制制图图的的常常数数和和公公式式表表 -s -s图图 标标准准差差图图 计计算算控控制制限限用用的的系系数数單單值值圖圖 全全距距图图 计计算算控控制制限限用用的

29、的系系数数D D4 43.2673.2672.5742.5742.2822.2822.1142.1142.0042.0041.9241.9241.8641.8641.8161.8161.7771.777计计算算控控制制限限用用的的系系数数单单边边规规格格( (设设计计规规格格) )因因没没有有规规格格上上限限或或下下限限, ,没没有有规规格格下下限限 CpCp CPUCPU Cpk,Cpk,没没有有规规格格上上限限 CpCp CPLCPL CpkCpk標準正態分佈z過程輸出超過特殊規定值（如工程規範限）的比例，這個特殊規定值與過程均值相距為z個標準差單位（針對處於統計控制狀態並呈現正態分佈的過

30、程）。如-2.17，則z0.0150或1.5，在任何實際情況下，該比例為近似值。或x.x0 x.x0 x.x1x.x1x.x2x.x2x.x3x.x3x.x4x.x4x.x5x.x5x.x6x.x64.04.00.000030.000033.93.90.000050.000050.000050.000050.000040.000040.000040.000040.000040.000040.000040.000040.000040.000043.83.80.000070.000070.000070.000070.000070.000070.000060.000060.000060.000060

31、.000060.000060.000060.000063.73.70.000110.000110.000100.000100.000100.000100.000100.000100.000090.000090.000090.000090.000080.000083.63.60.000160.000160.000150.000150.000150.000150.000140.000140.000140.000140.000130.000130.000130.000133.53.50.000230.000230.000220.000220.000220.000220.000210.000210.0

32、00200.000200.000190.000190.000190.000193.43.40.000340.000340.000320.000320.000310.000310.000300.000300.000290.000290.000280.000280.000270.000273.33.30.000480.000480.000470.000470.000450.000450.000430.000430.000420.000420.000400.000400.000390.000393.23.20.000690.000690.000660.000660.000640.000640.000

33、620.000620.000600.000600.000580.000580.000560.000563.13.10.000970.000970.000940.000940.000900.000900.000870.000870.000840.000840.000820.000820.000790.000793.03.00.001350.001350.001310.001310.001260.001260.001220.001220.001180.001180.001140.001140.001110.001112.92.90.00190.00190.00180.00180.00180.001

34、80.00170.00170.00160.00160.00160.00160.00150.00152.82.80.00260.00260.00250.00250.00240.00240.00230.00230.00230.00230.00220.00220.00210.00212.72.70.00350.00350.00340.00340.00330.00330.00320.00320.00310.00310.00300.00300.00290.00292.62.60.00470.00470.00450.00450.00440.00440.00430.00430.00410.00410.004

35、00.00400.00390.00392.52.50.00620.00620.00600.00600.00590.00590.00570.00570.00550.00550.00540.00540.00520.00522.42.40.00820.00820.00800.00800.00780.00780.00750.00750.00730.00730.00710.00710.00690.00692.32.30.01070.01070.01040.01040.01020.01020.00990.00990.00960.00960.00940.00940.00910.00912.22.20.013

36、90.01390.01360.01360.01320.01320.01290.01290.01250.01250.01220.01220.01190.01192.12.10.01790.01790.01740.01740.01700.01700.01660.01660.01620.01620.01580.01580.01540.01542.02.00.02280.02280.02220.02220.02170.02170.02120.02120.02070.02070.02020.02020.01970.01971.91.90.02870.02870.02810.02810.02740.027

37、40.02680.02680.02620.02620.02560.02560.02500.02501.81.80.03590.03590.03510.03510.03440.03440.03360.03360.03290.03290.03220.03220.03140.03141.71.70.04460.04460.04360.04360.04270.04270.04180.04180.04090.04090.04010.04010.03920.03921.61.60.05480.05480.05370.05370.05260.05260.05160.05160.05050.05050.049

38、50.04950.04850.04851.51.50.06680.06680.06550.06550.06430.06430.06300.06300.06180.06180.06060.06060.05940.05941.41.40.08080.08080.07930.07930.07780.07780.07640.07640.07490.07490.07350.07350.07210.07211.31.30.09680.09680.09510.09510.09340.09340.09180.09180.09010.09010.08850.08850.08690.08691.21.20.115

39、10.11510.11310.11310.11120.11120.10930.10930.10750.10750.10560.10560.10380.1038zSLPzXzSLPzX1.11.10.13570.13570.13350.13350.13140.13140.12920.12920.12710.12710.12510.12510.12300.12301.01.00.15870.15870.15620.15620.15390.15390.15150.15150.14920.14920.14690.14690.14460.14460.90.90.18410.18410.18140.181

40、40.17880.17880.17620.17620.17360.17360.17110.17110.16850.16850.80.80.21190.21190.20900.20900.20610.20610.20330.20330.20050.20050.19770.19770.19490.19490.70.70.24200.24200.23890.23890.23580.23580.23270.23270.22970.22970.22660.22660.22360.22360.60.60.27430.27430.27090.27090.26760.26760.26430.26430.261

41、10.26110.25780.25780.25460.25460.50.50.30850.30850.30500.30500.30150.30150.29810.29810.29460.29460.29120.29120.28770.28770.40.40.34460.34460.34090.34090.33720.33720.33360.33360.33000.33000.32640.32640.32280.32280.30.30.38210.38210.37830.37830.37450.37450.37070.37070.36690.36690.36320.36320.35940.359

42、40.20.20.42070.42070.41680.41680.41290.41290.40900.40900.40520.40520.40130.40130.39740.39740.10.10.46020.46020.45620.45620.45220.45220.44830.44830.44430.44430.44040.44040.43640.43640.00.00.50000.50000.49600.49600.49200.49200.48800.48800.48400.48400.48010.48010.47610.4761x.x7x.x7x.x8x.x8x.x9x.x90.000

43、040.000040.000030.000030.000030.000030.000050.000050.000050.000050.000050.000050.000080.000080.000080.000080.000080.000080.000120.000120.000120.000120.000110.000110.000180.000180.000170.000170.000170.000170.000260.000260.000250.000250.000240.000240.000380.000380.000360.000360.000350.000350.000540.000540.000520.000520.000500.000500.000760.000760.000740.000740.000710.000710.001070.001070.001040.001040.001000.001000.00