SPC CPK超全EXCEL模板完整版可编辑

上传人：1*** IP属地：湖北上传时间：2023-05-15 格式：XLS 页数：46 大小：1.10MB 积分：6 举报 版权申诉

已阅读5页，还剩41页未读，继续免费阅读

版权说明：本文档由用户提供并上传，收益归属内容提供方，若内容存在侵权，请进行举报或认领

文档简介

,,,,,,,,,,,,X,—,R,管制圖,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,管制圖編號：,,,,,,

製品,,H104PC,,,,,,規格,,標準,,群組數大小,,管制,,X圖,,R,圖,製造部門,,ＣＮＣ,,,,期間,,,,

名稱,,,,,,,,上限USL,,25.90,,5,,上限UCL,,25.83,,0.09,,,,,,,,,,,,

管制項目,,溝槽寬度,,,,,,中心限CL,,25.80,,總組數,,中心限CL,,25.80,,0.04,,機別,,ＴＰ０５,,,,抽樣方法,,隨機,,

測量單位,,,,,,,,下限LSL,,25.70,,25,,下限LCL,,25.77,,0.00,,測定者,,,,,,日期,,5月27日,,

日期/,時間,,,,,,,,,,,,,,,,,,,,,,,,,,,合計,,

批,號,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,,ΣＸ＝,,3225.20

樣,1,25.80,25.80,25.80,25.82,25.76,25.81,25.80,25.83,25.82,25.83,25.80,25.83,25.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,,ΣＲ＝,,1.10

本,2,25.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,,,,

測,3,25.83,25.83,25.82,25.77,25.78,25.82,25.79,25.80,25.78,25.78,25.82,25.82,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,,量測數值的判定條件,,

定,4,25.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,,,>USL藍色,

值,5,25.84,25.76,25.78,25.81,25.77,25.81,25.82,25.84,25.80,25.82,25.78,25.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.80,,,<LSL紅色,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,Ｎ＝,125,

ΣＸ,,129.05,129.00,129.00,129.00,128.90,129.07,129.02,129.07,129.01,129.10,128.98,129.03,129.04,129.06,128.99,129.03,128.99,128.98,129.00,128.94,128.98,129.01,129.01,129.01,128.94,,平均,,

Ｘ,,25.81,25.80,25.80,25.80,25.78,25.81,25.80,25.81,25.80,25.82,25.80,25.81,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.79,,Ｘ＝,25.80,

R,,0.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.03,,R=,0.04,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

x,,,,,,,,,,,,,,,,,,,,,,,,,,,,預估不良率(PPM),,

管制圖,,,,,,,,,,,,,,,,,,,,,,,,,,,,0,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,製程能力分析,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,Std.Dev.=,,0.02

,,,,,,,,,,,,,,,,,,,,,,,,,,,,Sigma=,,0.02

R,,,,,,,,,,,,,,,,,,,,,,,,,,,,,ＰＰＫ=,1.76

管制圖,,,,,,,,,,,,,,,,,,,,,,,,,,,,,PP=,1.76

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Ca=,0.07%

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,ＣＰＫ=,1.77

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,CP=,1.77

,,,,,,,,,,,,,,,,,,,,,,,,,,,,Grade=,,A

備註及原因追查:,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,n,2,3,4,5,6,7,8,9,10,,,,,,,,,,,,,,,,,,,,

,d2,1.13,1.69,2.06,2.33,2.53,2.7,2.85,2.97,3.08,2.33,,,,,,,,,,,,,,,,,,,

,D3,0,0,0,0,0,0.08,0.14,0.18,0.22,0,,,,,,,,,,,,,,,,,,,

,D4,3.27,2.57,2.28,2.11,2.00,1.92,1.86,1.82,1.78,2.11,,,,,,,,,,,,,,,,,,,

,A2,1.88,1.02,0.73,0.58,0.48,0.42,0.37,0.34,0.31,0.58,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

X,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

UCL,25.83,25.83,25.83,25.83,25.83,25.83,25.83,25.83,25.83,25.83,25.83,25.83,25.83,25.83,25.83,25.83,25.83,25.83,25.83,25.83,25.83,25.83,25.83,25.83,25.83,25.83,,,,

CL,25.80,25.80,25.80,25.80,25.80,25.80,25.80,25.80,25.80,25.80,25.80,25.80,25.80,25.80,25.80,25.80,25.80,25.80,25.80,25.80,25.80,25.80,25.80,25.80,25.80,25.80,,,,

LCL,25.77,25.77,25.77,25.77,25.77,25.77,25.77,25.77,25.77,25.77,25.77,25.77,25.77,25.77,25.77,25.77,25.77,25.77,25.77,25.77,25.77,25.77,25.77,25.77,25.77,25.77,83215.13,,,

,665.75,665.55,665.40,666.70,663.61,666.11,665.59,666.98,666.81,667.00,665.88,667.04,665.22,666.36,664.42,666.57,665.72,665.80,664.61,664.65,664.78,664.60,665.46,666.80,664.25,0.00,16641.67,,,

,665.93,666.36,665.56,665.43,665.92,665.73,665.55,666.39,664.89,667.36,664.89,664.48,665.63,666.07,665.61,664.33,665.75,663.80,667.12,664.98,666.13,666.88,663.76,666.24,665.47,0.00,16640.26,,,

,667.03,667.06,666.64,663.92,664.63,666.63,665.34,665.40,664.72,664.37,666.82,666.55,665.63,664.62,665.32,666.97,665.52,665.36,665.19,665.31,665.35,666.77,666.03,665.08,665.12,0.00,16641.37,,,

,664.38,665.62,666.02,665.98,664.87,666.97,666.22,665.21,666.45,667.53,665.17,666.03,666.75,667.33,665.97,667.38,665.18,665.33,665.46,665.55,665.03,666.70,666.14,665.62,664.27,0.00,16647.15,,,

,667.50,663.60,664.60,666.13,663.95,666.25,666.58,667.60,665.77,666.92,664.45,665.88,666.98,667.06,666.24,664.30,665.40,667.02,665.79,664.80,665.70,663.95,667.29,665.03,665.88,0.00,16644.69,,,

,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,,,

R,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

UCL,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,0.09,,,,

CL,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,,,,

LCL,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

USL,25.90,25.90,25.90,25.90,25.90,25.90,25.90,25.90,25.90,25.90,25.90,25.90,25.90,25.90,25.90,25.90,25.90,25.90,25.90,25.90,25.90,25.90,25.90,25.90,25.90,25.90,,,,

LSL,25.70,25.70,25.70,25.70,25.70,25.70,25.70,25.70,25.70,25.70,25.70,25.70,25.70,25.70,25.70,25.70,25.70,25.70,25.70,25.70,25.70,25.70,25.70,25.70,25.70,25.70,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

人人文库> 全部分类> 办公材料 > 对照材料

温馨提示

1. 本站所有资源如无特殊说明，都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
2. 本站的文档不包含任何第三方提供的附件图纸等，如果需要附件，请联系上传者。文件的所有权益归上传用户所有。
3. 本站RAR压缩包中若带图纸，网页内容里面会有图纸预览，若没有图纸预览就没有图纸。
4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
5. 人人文库网仅提供信息存储空间，仅对用户上传内容的表现方式做保护处理，对用户上传分享的文档内容本身不做任何修改或编辑，并不能对任何下载内容负责。
6. 下载文件中如有侵权或不适当内容，请与我们联系，我们立即纠正。
7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

SPC CPK超全EXCEL模板完整版可编辑

文档简介

温馨提示

最新文档

评论

SPC CPK超全EXCEL模板完整版可编辑

文档简介

温馨提示

最新文档

评论

相关文档