SPC全套Excel模版.pdf
上传人:文库****品店 上传时间:2024-09-11 格式:PDF 页数:3 大小:94KB 金币:10 举报 版权申诉
预览加载中,请您耐心等待几秒...

SPC全套Excel模版.pdf

SPC全套Excel模版.pdf

预览

在线预览结束,喜欢就下载吧,查找使用更方便

10 金币

下载此文档

如果您无法下载资料,请参考说明:

1、部分资料下载需要金币,请确保您的账户上有足够的金币

2、已购买过的文档,再次下载不重复扣费

3、资料包下载后请先用软件解压,在使用对应软件打开

單值和移動全距(X-MR)控制圖製品規格標準群組數大小管制X圖MR圖製造樣品容名稱上限USL1上限UCL15.155.64部門量/頻率管制項目中心限CL總組數中心限CL10.561.73機別抽樣方法測量單位下限LSL24下限LCL5.970.00測定者日期2020/1/31日期/時間合計批號12345678910111213141516171819202122232425ΣX=253.50樣18.008.507.4010.509.3011.1010.4010.409.0010.0011.7010.3016.2011.6011.5011.0012.0011.0010.2010.0010.5010.3011.5011.10ΣR=41.40本測量測數值的判定條件定>USL藍色值<LSL紅色N=24ΣX8.008.507.4010.509.3011.1010.4010.409.0010.0011.7010.3016.2011.6011.5011.0012.0011.0010.2010.0010.5010.3011.5011.100.00平均X8.008.507.4010.509.3011.1010.4010.409.0010.0011.7010.3016.2011.6011.5011.0012.0011.0010.2010.0010.5010.3011.5011.100.00X=10.56MR0.501.103.101.201.800.700.001.401.001.701.405.904.600.100.501.001.000.800.200.500.201.200.4011.10R=1.7320.00預估不良率(PPM)15.00X100000010.005.00製程能力分析0.001234567891011121314151617181920212223242526Std.Dev.=1.68Sigma=1.5315.00PPK=10.00PP=Ca=5.00#DIV/0!CPK=0.00CP=12345678910111213141516171819202122232425Grade=備註及原因追查:n2345678910D43.272.572.282.1121.921.861.821.783.27D3000000.080.140.180.220E22.661.771.461.291.181.111.051.020.982.66d21.131.692.062.332.532.72.852.973.081.13XUCL15.1515.1515.1515.1515.1515.1515.1515.1515.1515.1515.1515.1515.1515.1515.1515.1515.1515.1515.1515.1515.1515.1515.1515.1515.1515.15CL10.5610.5610.5610.5610.5610.5610.5610.5610.5610.5610.5610.5610.5610.5610.5610.5610.5610.5610.5610.5610.5610.5610.5610.5610.5610.56LCL5.975.975.975.975.975.975.975.975.975.975.975.975.975.975.975.975.975.975.975.975.975.975.975.975.975.97####64.0072.2554.76110.2586.49123.21108.16108.1681.00100.00136.89106.09262.44134.56132.25121.00144.00121.00104.04100.00110.25106.09132.25123.210.000.00####0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000