Nokia Variable Gauge R&R Spreadsheet使用介绍(v1.0)

Variable Gauge R&R Spreadsheet

使用介绍

现代精密塑胶模具（深圳）有限公司测量中心

2006-10-26

一、数据输入

将“安全级”改置为“中”。然后关闭文件重新打开即可。

宏”对话框出现，可打开菜单“工具/宏/安全性”， 例：Comso Mass Tool_Dummy plate _OGP01_JIG0104_20060904 其中：夹具编号用字母“JIG”+本司ERP

3否则，表内的大部分功能将无法使用。如果打开时没有“启用Nokia Gauge R&R (DMM00210-EN-V4.0)电子表格使用介绍

1、GR&R 测试按要求取得实测数据后，需交文员或技术员将数据输入至GaugeR&R 电子表格计算Total Gauge GR&R 百分率。

2、在“\\\\QA-FILESRV\\Quality\\QM\\测量报告\\●GR&R REPORT”文件夹下将“DMM00210-EN-V4.0 GaugeR&R(Nokia)空白模板”另存或复制到相应的文件夹下，重新命名。命名规则（按PERLOS 要求）：项目名称—产品名称—测量仪器编号—夹具编号—8位年月日。

7、完成上述操作后，将各操作员实际测量的数据输入表格相应位置 。 使用复制时注意，粘贴要用选择性粘贴，只粘贴“数据”。

作表填上“尺寸规格的资料”。

8、最后检查数据输入无误后，保存退出即完成数据输入工作。

否则，自动生成的图表可能会出现错误。

6、如果同一图纸进行GR&R 测试的尺寸超过一个,在完成上述操作后,点击“ ”按钮会自动生成新的工作表，工作表中已包含“公司及产品的基本信息”。重命名各工作表名称，然后分别在各工 4、在表格的下列空白处输入“公司及产品的基本资料”。

5、使用下拉箭头选择GR&R 测试的操作人数、样本数及每个操作员的测量次数（见上右图所示）。

此项一定要在数据输入前选定，操作员数量（从2到6选择）

样本数量（从10到20选择）

测试次数（从2到3选择）

依次类推

Variable Gauge R&R –Capability Study

Measurement System is:

ACCEPTABLE for verifying the process capability for this characteristic 测量系统用于检验这个特有的过程能力是可以接受的;

ACCEPTABLE for identifying the difference between the sampled parts 测量系统用于识别样本间的差异是可以接受的.

nominal 规格

LSL 规格下限

USL 规格上限

% Tolerance is the ratio between

measurement error and specification limits 公差百分率是测量误差与规格限度的比值% Contribution is the ratio between

measurement error and measured variation 过程变差百分率是测量误差与标准变差的比值

第5页共20页

Measurement System is :

ACCEPTABLE for verifying the process capability for this characteristic 测量系统用于检验这个特有的过程能力是可以接受的;

MARGINAL for identifying the difference between the sampled parts 测量系统用于识别样本之间的差异勉强可以接受.

ACTIONS:(见第8页)

nominal 规格

% Tolerance is the ratio between

measurement error and specification limits 公差百分率是测量误差与规格限度的比值% Contribution is the ratio between

measurement error and measured variation 过程变差百分率是测量误差与标准变差的比值

LSL 规格下限

USL 规格上限

nominal 规格

Measurement System is :

ACCEPTABLE for verifying the process capability for this characteristic 测量系统用于检验这个特有的过程能力是可以接受的;

INCAPABLE for identifying the difference between the sampled parts 测量系统用于识别样本之间的差异不可以接受.

ACTIONS:(见第8页)

% Tolerance is the ratio between

measurement error and specification limits 公差百分率是测量误差与规格限度的比值% Contribution is the ratio between

measurement error and measured variation 过程变差百分率是测量误差与标准变差的比值

LSL 规格下限

USL 规格上限

-Ensure that the samples used for Gauge R&R study have a representative variation (50…120% of the tolerance area)

-确保用于GR&R研究的样品有足够的代表性,(样品特性的变量应为公差范围的50%～120%) .

-If samples used in the gauge R&R study were not sampled with representative variation, then gauge R&R study should be repeated with representative samples

-如果用于GR&R研究的样品不具有代表性,需要更换具有代表性的样品重做GR&R测试.

-If parts used in the gauge R&R study were sampled with representative variation, or if it is not possible to have samples with representative variation then continue with the capability study. But if the capability is rejected then Measurement System should be improved

-不管用于GR&R研究的样品具不具有代表性,如果继续进行过程能力研究,一旦过程能力评估的结果不能接受时,测量系统则应该改善.

nominal 规格

Measurement System is :

MARGINAL for verifying the process capability for this characteristic

测量系统用于检验这个特有的过程能力是勉强可以接受的

ACCEPTABLE for identifying the difference between the sampled parts 用于识别样本间的差异,测量系统是可以接受的

ACTIONS:(见第10页)

% Tolerance is the ratio between

measurement error and specification limits 公差百分率是测量误差与规格限度的比值% Contribution is the ratio between

measurement error and measured variation 过程变差百分率是测量误差与标准变差的比值

LSL 规格下限USL 规格上限

-Ensure that the samples used for Gauge R&R study have a representative variation (i.e. not excessive variation)

-确保用于GR&R研究的样品有足够的代表性( 也就是不要有过多的变化)

-If samples used in the gauge R&R study were not sampled with representative variation, then gauge R&R study should be repeated with representative samples

-如果用于GR&R研究的样品不具有代表性,需要更换具有代表性的样品重做GR&R测试.

-If parts used in the gauge R&R study were sampled with representative variation, or if it is not possible to have samples with representative variation then continue with the capability study. But if the capability is rejected then Measurement System should be improved

-不管用于GR&R研究的样品具不具有代表性,如果继续进行过程能力研究,一旦过程能力评估的结果不能接受时,测量系统则应该改善.

nominal 规格

Measurement System is :

MARGINAL for verifying the process capability for this characteristic 测量系统用于检验这个特有的过程能力是勉强可以接受的

MARGINAL for identifying the difference between the sampled parts 测量系统用于识别样本之间的差异勉强可以接受.

ACTIONS:(见第8页)

% Tolerance is the ratio between

measurement error and specification limits 公差百分率是测量误差与规格限度的比值% Contribution is the ratio between

measurement error and measured variation 过程变差百分率是测量误差与标准变差的比值

LSL 规格下限USL 规格上限

nominal 规格

Measurement System is :

MARGINAL for verifying the process capability for this characteristic 测量系统用于检验这个特有的过程能力是勉强可以接受的

INCAPABLE for identifying the difference between the sampled parts 测量系统用于识别样本之间的差异不可以接受.

ACTIONS:(见第8页)

% Tolerance is the ratio between

measurement error and specification limits 公差百分率是测量误差与规格限度的比值% Contribution is the ratio between

measurement error and measured variation 过程变差百分率是测量误差与标准变差的比值

LSL 规格下限

USL 规格上限

nominal 规格

Measurement System is :

INCAPABLE for verifying the process capability for this characteristic 测量系统没有能力检验这个特有的过程能力.

ACCEPTABLE for identifying the difference between the sampled parts 用于识别样本间的差异,测量系统是可以接受的

•ACTIONS 对策:

-Measurement System must be improved 测量系统必须改善

% Tolerance is the ratio between

measurement error and specification limits 公差百分率是测量误差与规格限度的比值% Contribution is the ratio between

measurement error and measured variation 过程变差百分率是测量误差与标准变差的比值

LSL 规格下限USL 规格上限

nominal 规格

Measurement System is :

INCAPABLE for verifying the process capability for this characteristic 测量系统没有能力检验这个特有的过程能力.

MARGINAL for identifying the difference between the sampled parts 测量系统用于识别样本之间的差异勉强可以接受.

•ACTIONS 对策:

-Measurement System must be improved 测量系统必须改善

% Tolerance is the ratio between

measurement error and specification limits 公差百分率是测量误差与规格限度的比值% Contribution is the ratio between

measurement error and measured variation 过程变差百分率是测量误差与标准变差的比值LSL 规格下限USL 规格上限

nominal 规格

Measurement System is :

INCAPABLE for verifying the process capability for this characteristic 测量系统没有能力检验这个特有的过程能力.

INCAPABLE for identifying the difference between the sampled parts 测量系统用于识别样本之间的差异不可以接受.

•ACTIONS 对策:

-Measurement System must be improved 测量系统必须改善

% Tolerance is the ratio between

measurement error and specification limits 公差百分率是测量误差与规格限度的比值% Contribution is the ratio between

measurement error and measured variation 过程变差百分率是测量误差与标准变差的比值

LSL 规格下限

USL 规格上限

nominal 规格

Measurement System is :

ACCEPTABLE for identifying the difference between the sampled parts 用于识别样本间的差异,测量系统是可以接受的

% Contribution is the ratio between

measurement error and measured variation 过程变差百分率是测量误差与标准变差的比值

nominal 规格

Measurement System is :

MARGINAL for identifying the difference between the sampled parts 用于识别样本间的差异,测量系统勉强可以接受

ACTIONS:(见第18页)

% Contribution is the ratio between

measurement error and measured variation 过程变差百分率是测量误差与标准变差的比值

•ACTIONS对策:

-Ensure that the samples used for Gauge R&R study have a representative variation

-确保用于GR&R研究的样品具有足够的代表性

-If samples used in the gauge R&R study were not sampled with representative variation, then gauge R&R study should be repeated with representative samples

-如果用于GR&R研究的样品不具有代表性,需要更换具有代表性的样品重做GR&R测试.

-If parts used in the gauge R&R study were sampled with representative variation, or if it is not possible to have samples with representative variation then continue with the capability study. But if the

capability is rejected then Measurement System should be improved

-不管用于GR&R研究的样品具不具有代表性,如果继续进行过程能力研究,一旦过程能力评估的结果不能接受时,测量系统则应该改善.

nominal 规格

Measurement System is :

INCAPABLE for identifying the difference between the sampled parts 测量系统用于识别样本之间的差异不可以接受.

ACTIONS:(见第20页)

% Contribution is the ratio between

measurement error and measured variation 过程变差百分率是测量误差与标准变差的比值

-Ensure that the samples used for Gauge R&R study have a representative variation

-确保用于GR&R研究的样品具有足够的代表性

-If samples used in the gauge R&R study were not sampled with representative variation, then gauge R&R study should be repeated with representative samples

-如果用于GR&R研究的样品不具有代表性,需要更换具有代表性的样品重做GR&R测试.

-If parts used in the gauge R&R study were sampled with representative variation,

Measurement System should be improved

如果用具有代表性的样品做GR&R研究后,测量系统应该改善.