SPC全套Excel表格.pdf

X—R控制图
控制图编号：

製品規格標準群組數大小管制X圖R圖製造
H104PCＣＮＣ时间
名稱上限USL0.905上限UCL0.820.38部門
管制項目溝槽寬度中心限CL0.70總組數中心限CL0.720.18機別ＴＰ０５抽樣方法随机
測量單位下限LSL0.5025下限LCL0.610.00測定者日期2014-9-27
日期/時間合計
批號12345678910111213141516171819202122232425ΣＸ＝89.50
樣10.650.750.750.600.700.600.750.600.650.600.800.850.700.650.900.750.750.750.650.600.500.600.800.650.65ΣＲ＝4.45
本20.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
測30.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量測數值的判定條件
定40.650.850.700.750.850.850.750.750.850.800.500.650.750.750.750.800.700.700.650.600.800.650.650.600.60>USL藍色
值50.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<LSL紅色
Ｎ＝125
ΣＸ3.503.853.803.403.753.653.653.603.903.353.753.803.603.554.103.753.803.353.503.103.303.453.503.203.30平均
Ｘ0.700.770.760.680.750.730.730.720.780.670.750.760.720.710.820.750.760.670.700.620.660.690.700.640.66Ｘ＝0.72
R0.200.200.100.150.200.250.150.200.200.200.400.200.050.250.150.150.150.150.200.050.300.200.150.100.10R=0.18

1.00
x0.90預估不良率(PPM)
管Ｘ0.8010355
制0.70
0.60
圖0.50
0.40製程能力分析
12345678910111213141516171819202122232425Std.Dev.=0.09
Sigma=0.08
0.50
RＰＰＫ=0.72
0.40
PP=0.78
管0.30

制0.20Ca=8.00%
圖0.10ＣＰＫ=0.80
0.00CP=0.87
12345678910111213141516171819202122232425Grade=D
備註及原因追
查:
n2345678910
d21.131.692.062.332.532.72.852.973.082.33
D3000000.080.140.180.220
D43.272.572.282.112.001.921.861.821.782.11
A21.881.020.730.580.480.420.370.340.310.58

X
UCL0.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.82
CL0.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.72
LCL0.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.61####
0.420.560.560.360.490.360.560.360.420.360.640.720.490.420.810.560.560.560.420.360.250.360.640.420.420.00####
0.490.720.640.490.560.560.640.490.640.4