GRR-表格自动计算模版

非破坏性测试

请恰当填写以下参数并完成表格参数

K 1测试次数必须为 2 或 33OK K 2操作人数必须为 2 或

3OK K 3零件数

数值必须在 2 和 10之间

'01 PSW '01 PSW'!A6'01 PSW'!A21'01 PSW'!A54'01 PSW'!H54

#REF!

零件号9066888零件名称

xxx 制造厂xxx 特性轮廓度量具编号xxx

编制

xxx 公差

单位mm

量具名称零件检具电话号码xxx 总差异 (TV) 1.5562335

量具 ECL

xxx

日期xxx 操作者P A R T 结果

编号123456

910

平均A 1

0.23500.12500.58200.33200.8940A 10.4336020.20000.12900.52700.36700.8570A 20.4160030.1930

0.1020

0.5640

0.3070

0.8702

A 30.40724平均0.209330.118670.557670.335330.87373X A 0.41895范围0.042

0.027

0.055

0.06

0.037

R A

0.04420B

10.23200.10700.54500.33700.8950B 10.4232020.18500.13100.58900.30500.8750B 20.4170030.1910

0.1290

0.5630

0.3210

0.8610

B 30.41300平均0.202670.122330.565670.3210.877X B 0.41773范围0.047

0.024

0.044

0.032

0.034

R B

0.03620C

10.18600.11200.53600.41600.8230C 10.4146020.20600.13900.57300.45200.8970C 20.4534030.1590

0.1230

0.5540

0.4740

0.8340

C 30.42880平均0.183670.124670.554330.447330.85133X C 0.43227范围0.0470.0270.0370.0580.074R C

0.04860零件平均0.19856

0.12189

0.55922

0.36789

0.86736

x PART =0.42298零件范围

R PART =

0.74547R =

R A + R B + R C / No of operators =

0.04420+0.03620+

0.04860

R =0.04300X DIFF =[Max (X )ABC ] - [Min (X )ABC ] =

0.43227-0.41773X DIFF =

0.01453UCL R =R *D 4 =0.04300* 2.580UCL R =0.11094LCL R =R

*D 3 =0.04300

0.000

LCL R =

0.00000

操作者

姓名操作者所在单位A 甲上海申模B 乙上海塞科利C

丙上海申模直到量具工程更改/版本变化

来自数据表:R =0.04300

X DIFF =0.01453

R PART =0.74547

测量单元分析

基于零件间差别可重复性- 设备变化(EV)

EV =R * K 1

% EV = 100[EV/TV]

EV =

0.13115

Trials

K 1% EV =8.43

3 3.05

可再现性 - 鉴定者差别 (AV)

AV= [ ( X DIFF * K 2)2 - (EV 2 / nr)](n parts, r trials)

% AV = 100[AV/TV]

AV=0.01983Oper

K 2% AV = 1.273 2.70

可重复性 & 可再现性 (R & R)

% R&R = 100[R&R/TV]R&R= (EV 2 + AV 2)% R&R =8.52

R&R=0.13264

零件差异 (PV)

PV=R PART * K 3Parts

K 3% PV = 100[PV/TV]

PV= 1.55057

2.08

% PV =99.64

总差异 (TV)

2.08TV= (R&R 2 + PV 2)#REF!

ndc =1.41[PV / R&R]

TV= 1.55623

All ranges OK ndc=16.48