SPC&CPK 超全EXCEL模板

1、 X R 管管 制制 圖圖管制圖編號： 製 品H104PCH104PC規(guī) 格標 準群組數(shù)大小管 制X 圖R圖製 造 部 門期 間名 稱上限 USL25.905上限 UCL25.830.09管制項目溝槽寬度中心限CL25.80總組數(shù)中心限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量測數(shù)值的判定條件 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%子組數(shù)26 樣本上限制程名稱機 臺記 錄 者日 期P2.

7、55%樣本容量 n 563 樣本下限日期1234567891011121314151617181920212223242526檢查數(shù)量500450500650500550500650500500700500500650500700500650500600500700500700500650不良內容及數(shù)量1215121514141414141420122215201222151414131312121111總不良數(shù)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子組數(shù)26 樣本上限制程名稱機 臺記 錄 者日 期nP15.25樣本容量 n 150 樣本下限日期1234567891011121314151617181920212223242526檢查數(shù)量150150150150150150150150150150150150150150150150150150150150150150150150150150不良內容及數(shù)量12152012221514171717201

10、22215201222151414131312121111總不良數(shù)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子組數(shù)26 樣本上限制程名稱機 臺記 錄 者日 期C15.25樣本容量 n2樣本下限日期1234567891011121314151617181920212223242526檢查數(shù)量22222222222222222222222222不良內容及數(shù)量121

12、5201222151417171720122215201222151414131312121111總不良數(shù)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子組數(shù)26 樣本上限制程名稱機 臺記 錄 者日 期U1.79樣本容量 n9樣本下限日期1234567891011121314151617181

14、920212223242526檢查數(shù)量87979810797981099791098107108108不良內容及數(shù)量1215201222151417171720122215201222151414131312121111總不良數(shù)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 控控制制圖圖的的常常數(shù)數(shù)和和公公式式表表 - -圖圖 -s -s圖圖 均均值值圖圖 全全距距圖圖 均均值值圖圖 標標準準差差圖圖 子子組組容容量量計計算算控控制制限限用用的的系系數(shù)數(shù)標標準準差差估估計計值值的的除除數(shù)數(shù)計計算算

16、控控制制限限用用的的系系數(shù)數(shù)計計算算控控制制限限用用的的系系數(shù)數(shù)標標準準差差估估計計值值的的除除數(shù)數(shù)計計算算控控制制限限用用的的系系數(shù)數(shù)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中中位位數(shù)數(shù)圖圖單單值值圖圖中中位位數(shù)數(shù)圖圖 全全距距圖圖 單單值值圖圖 全全距距圖圖 子子組組容容量量

23、計計算算控控制制限限用用的的系系數(shù)數(shù)標標準準差差估估計計值值的的除除數(shù)數(shù)計計算算控控制制限限用用的的系系數(shù)數(shù)計計算算控控制制限限用用的的系系數(shù)數(shù)標標準準差差估估計計值值的的除除數(shù)數(shù)計計算算控控制制限限用用的的系系數(shù)數(shù)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子子組組容容量量計計算算控控制制限限用用的的系系數(shù)數(shù)標標準準差差估估計計值值的的除除數(shù)數(shù)計計算算控控制制限限用用的的系系數(shù)數(shù)計計算算控控制制限限用用的的系系數(shù)數(shù)標標準準差差估估計計值值的的除除數(shù)數(shù)計計算算控控制制限限用用的的系系數(shù)數(shù)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單單邊邊規(guī)規(guī)格格( (設設計計規(guī)規(guī)格格) )因因沒沒有有規(guī)規(guī)格格上上限限或或下下限限, ,沒沒有有規(guī)規(guī)格格下下限限 CpCp CPUCPU Cpk,Cpk,沒沒有有規(guī)規(guī)格格上上限限 CpCp CPLCPL CpkCpk1.4661.4661.4551.4551.4451.4451.4351.435控控制制圖圖的的常常數(shù)數(shù)和和公公式式表表 -s -s圖圖 標標準準差差圖圖 計計算算控控制制限限用用的的系系數(shù)數(shù)單單值值圖圖 全全距距圖圖 計計算算控控制制限限用用的

29、的系系數(shù)數(shù)D D4 43.2673.2672.5742.5742.2822.2822.1142.1142.0042.0041.9241.9241.8641.8641.8161.8161.7771.777計計算算控控制制限限用用的的系系數(shù)數(shù)單單邊邊規(guī)規(guī)格格( (設設計計規(guī)規(guī)格格) )因因沒沒有有規(guī)規(guī)格格上上限限或或下下限限, ,沒沒有有規(guī)規(guī)格格下下限限 CpCp CPUCPU Cpk,Cpk,沒沒有有規(guī)規(guī)格格上上限限 CpCp CPLCPL CpkCpk標準正態(tài)分佈z過程輸出超過特殊規(guī)定值（如工程規(guī)範限）的比例，這個特殊規(guī)定值與過程均值相距為z個標準差單位（針對處於統(tǒng)計控制狀態(tài)並呈現(xiàn)正態(tài)分佈的過

30、程）。如-2.17，則z0.0150或1.5，在任何實際情況下，該比例為近似值?；騲.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