测量系统分析数据记录表excel模版下载

Page：1/4
Range chart
0.0000 Total Variation
1.18678 1.08939
100.00% 100.00% #DIV/0!
Total Variation
1.17788 1.08530
100.00% 100.00% #DIV/0!
测量系统分析MSA GR&R---均值极差法Average and method
平均值Average 0.194000 0.166000
3.
3 0.64 -0.58 1.27 0.64 -0.84 -0.21 0.66 -0.17 2.01 -1.31 2.11
0.211000
4. 均值Mean 0.44667 -0.60667 1.26000 0.53667 -0.85333 -0.10000 0.66667 -0.22667 2.08667 -1.30667
10. 极差Range 0.18 0.75
0.4
1.02 0.72 0.42 0.36 0.71 0.39 0.18
11. C
1 0.04 -1.38 0.88 0.14 -1.46 -0.29 0.02 -0.46 1.77 -1.49
2.0500 -2.23
X B = 0.068333
RB = 0.513000
Sum A 1.34 -1.82 3.78 1.61 -2.56 -0.3
2
-0.68 6.26 -3.92
5. 极差Range 0.35 0.12 0.17 0.17 0.12 0.23 0.16 0.14 0.27 0.11
6. B
1 0.08 -0.47 1.19 0.01 -0.56 -0.2 0.47 -0.63 1.8 -1.68
量具名称 Equipment Name
量具编号 Equipment NO.
参数规格 Dimension
单位 Unit
MM
测量系统分析MSA GR&R--- 数据记录表 Data Worksheet
报告编号Report NO.
产品类型 Description
测量人员 OperatorＡ
测试日期 Test Tate
4.39% 20.96% #DIV/0!
Reproducibility
0.05146 0.22684
4.37% 20.90% #DIVB /0!
0.2000 Operator Operators*Part
0.05212 0.00000
0.22830 0.00000
4.39% 0.00%
20.96% #DIV/0! 0.00% #DIV/0!
8.27% 3.87%
28.75% #DIV/0! 19.68% #DIV/0!
Total Gauge R&R Repeatability
0.09143 0.30237 0.03997 0.19993
7.76% 27.86% 3.39% 18.42%
#DIVLC/0LR! #DIV/0!
Reproducibility 0.05212 0.22830
Operator
0.05146 0.22684
4.37% 20.90%
#DIV/0! A
0.0000Part - To - Part 1.08867 1.04339
91.73% 95.78% #DIV/0!
Part - To - Part
1.08645 1.04233
92.24% 96.04% #DIV/0!
-1.5
0.89
0.089000
9. 均值Mean 0.13333 -0.79000 1.15667 0.41333 -1.01333 0.02667 0.61667 -0.29667 2.03667 -1.60000
Sum B 0.4 -2.37 3.47 1.24 -3.04 0.08 1.85 -0.89 6.11 -4.8
X = 0.444667 DIFF
测量人员 OperatorＡ
测量人员 OperatorＢ
测量人员 OperatorＣ 过程变差/过程能力 Process Variation(σ /PP)
RP = 3.511111
分析方式Analysis mode
测试 日期 平Te价st 人数 A试p验pr 次数 T样ria品ls
ANOVA TabDlFe Without OSSperator*PaMrtSInteractioFn
9
88.36193 9.81799 492.29142 0.00000
Parts
9
88.36193 9.81799 245.61391
P 0.00000
1.000O0 pOepraetroartso*rPsart
基件编号 P/N
测量人员 OperatorＢ
平价人数
Appraisers
3
规格上限 USL
测量人员 OperatorＣ
试验次数
Trials
3
规格下限 LSL
过程变差/过程能力 Process Variation(σ/PP)
样品数
Samples
10
分析时机Analytical Occasion
零件编号Parts NO. 1
-0.223000
12.
2 -0.11 -1.13 1.09
0.2
-1.07 -0.67 0.01 -0.56 1.45 -1.77 -2.56
-0.256000
13.
3 -0.15 -0.96 0.67 0.11 -1.45 -0.49 0.21 -0.49 1.87 -2.16 -2.84
-0.284000
数
1900/1/0 3 3 10
基于零件变差base on parts variation
测量系统分析MSA
% 总变差Total variation（TV）
重复性Repeatability－设备变差Equipment Variation(EV)
0.879792 0.000000
D3
0
0
A2 1.88 1.023
注:当分析结果超出要求后，利用均值极差图分析原因When analysis result is out of spec,need analyse the root cause by mean and range chart 。
3.00U0C00Lx
报告编号Report NO.
量具名称 Equipment
量具编号 Equipment NO.
参数规格 Specification
测量单位 MM Unit
Datasheet：
R = 0.341667
产品类型 Description
基件编号 Part NO.
规格上限 Upper limit
规格下限 Lower Limit
LCLx 基于公差base on parts specLeabharlann #DIV/0! #DIV/0!
17.61% 20.04%
B 基于零件变差base on parts variation
#DIV/0! #DIV/0!
26.68% 96.38%
基于过程变差base on process variation 基于过程能力Base on process PP
Total 1.520000 -7.660000 9.890000 3.300000 -9.580000 -1.670000 4.090000 -3.080000 17.460000 -14.140000
R = ( R A + R b + Rc ) / Appraisers X DIFF = MaxX - MinX =
Gauge R&R Without Operator*Part Interaction
UCLR
VarComp Stdev %Contribution %TV %Tolerance
chart
Total Gauge R&R 0.09811 0.4000 Repeatability 0.04598
0.31322 0.21443
S-3U.0M00S00Q(nXsd^uc2m/(nmkren-05p..00a90r30t6)19)82/74r783 91.8883667
0.8798 0.0000
0.8798 0.0000
0.8798 0.0000
0.8798 0.0000
6σ
PV
1.104596
TV
0.000000
#DIV/0!
15. 极差Range 0.1900 0.4200 0.4200 0.0900 0.3900 0.3800 0.2000 0.1000 0.4200 0.6700
X 零件均值
Parts Mean
0.168889 -0.851111 1.098889 0.366667 -1.064444 -0.185556 0.454444 -0.342222 1.940000 -1.571111 P
公式A FoCrmula A
SUMSQ(sum(1-10part))/kr
88.3621222
公式B Formula B
n=part k=men r=time
1.SP20oa0ru0tsrce
ANOVADTFable With SOSperator*PaMrtSInteractionF
P
Source
14. 均值Mean -0.07333 -1.15667 0.88000 0.15000 -1.32667 -0.48333 0.08000 -0.50333 1.69667 -1.80667
X C = -0.254333
Sum C -0.22 -3.47 2.64 0.45 -3.98 -1.45 0.24 -1.51 5.09 -5.42 -7.63
2
3.16726 1.58363 79.40605 0.00000
18
0.35898 0.01994 0.43372 0.97411
Operators
2
3.16726 1.58363 39.61725 0.00000
极差图 0.T80o0ta0Rl epeatability
60
2.75893 0.04598
= 0.341667 0.444667
试验次数Trials
0.13 D4
RC = 0.328000
X = 0.001444
RP = 3.511111
2
3
3.27 2.575
UCLX = X + A2R = LCLX = X - A2R =
0.350969 -0.348081
UCLR = D4R = LCLR = D3R =
均值图
2.00U0C00LR LCLR
0.8798 0.0000
0.8798 0.0000
0.8798 0.0000
1.00000
mean chart
0.00000
公差： PV
TV
1.104596 0.000000
%-E1V.00000
#DIV/0!
%AV
#DIV/0!
%%-PR2V.R00000
#DIV/0! #DIV/0!
5.7100 0.01
X A = 0.190333
RA = 0.184000
0.001000
7.
2 0.25 -1.22 0.94 1.03 -1.2
0.22 0.55 0.08 2.12 -1.62 11.304
0.115000
8.
3 0.07 -0.68 1.34
0.2
-1.28 0.06 0.83 -0.34 2.19
2
1. A
1 0.29 -0.56
2.
2 0.41 -0.68
Regular
3
4
1.34 0.47
1.17
0.5
New QCP
5
6
-0.8 0.02
-0.92 -0.11
PPAP
7
8
0.59 -0.31
0.75 -0.2
Other
9
10
2.26 -1.36
1.99 -1.25
Total 1.94 1.66
89
94.64711
Repeatability
78
3.11792 0.03997
C
Total
89
94.64711
Range 0.S60o0u0rce
Gauge R&R With Operator*Part Interaction VarComp Stdev %Contribution %TV %Tolerance Source
1 0.3510
2 0.3510
3 0.3510
4 0.3510
5 0.3510
6 0.3510
7 0.3510
8 0.3510
9 0.3510
10 0.3510
LCLx -0.3481 -0.3481 -0.3481 -0.3481 -0.3481 -0.3481 -0.3481 -0.3481 -0.3481 -0.3481
#DIV/0!
#DIV/0!
#DIV/0!
sumSQ(sum(men))/nr sumSQ(all)
3.1674500 94.6473000
0.8798
0.8798
0.8798
0.0000
0.0000
0.0000
A
pp
变差
UCLx
1.104596
PV
1.104596
#DIV/0!
TV
1.146135