当前位置:
文档之家› 最实用的MSA测量系统分析自动表格
最实用的MSA测量系统分析自动表格
Regular
3 1.34 1.17 1.27 4 0.47 0.5 0.64
New QCP
5 -0.8 -0.92 -0.84 6 0.02 -0.11 -0.21 7
PPAP
8 -0.31 -0.2 -0.17
Other
9 2.26 1.99 2.01 10 -1.36 -1.25 -1.31 Total 1.94 1.66 2.11 平均值Average 0.194000 0.166000 0.211000
X=
0.13 2 D4 3.27 0 1.88
0.001444
Total 1.520000
3.300000 -9.580000 -1.670000 4.090000 -3.080000
17.460000 -14.140000
RP = 3.511111
3 2.575 0 1.023
R = ( R A + R b + Rc ) / Appraisers
0.59 0.75 0.66
均值Mean 0.44667 -0.60667 1.26000 0.53667 -0.85333 -0.10000 0.66667 -0.22667 2.08667 -1.30667 Sum A 极差Range 1 2 3 1.34 0.35 0.08 0.25 0.07 -1.82 0.12 -0.47 -1.22 -0.68 3.78 0.17 1.19 0.94 1.34 1.61 0.17 0.01 1.03 0.2 -2.56 0.12 -0.56 -1.2 -1.28 -0.3 0.23 -0.2 0.22 0.06 2 0.16 0.47 0.55 0.83 -0.68 0.14 -0.63 0.08 -0.34 6.26 0.27 1.8 2.12 2.19 -3.92 0.11 -1.68 -1.62 -1.5 0.01 11.304 0.89 5.7100
8 0.3510 -0.3481 0.8798 0.0000 pp 1.104596 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
9 0.3510 -0.3481 0.8798 0.0000 变差 PV TV
10 0.3510 -0.3481 0.8798 0.0000
B
基于过程能力Base on process PP
C 公式A Formula A 公式B Formula B
P 0.00000 0.00000
C
%Tolerance #DIV/0! LCLR #DIV/0! #DIV/0! B #DIV/0!
A
UCLR
#DIV/0! #DIV/0!
Page:1/3
测量系统分析 MSA GR&R---均值极差法Average and method 报告编号 Report NO. 量具名称 Equipment 量具编号 Equipment NO. 参数规格 Specification 测量单位 MM Unit Datasheet: 产品类型 Description 基件编号 Part NO. 规格上限 Upper limit 规格下限 Lower Limit 测量人员 OperatorA 测量人员 OperatorB 测量人员 OperatorC 过程变差/过程能力
X A = 0.190333
R A = 0.184000
0.001000 0.115000 0.089000
均值Mean 0.13333 -0.79000 1.15667 0.41333 -1.01333 0.02667 0.61667 -0.29667 2.03667 -1.60000 Sum B 极差Range 1 2 3 0.4 0.18 0.04 -0.11 -0.15 -2.37 0.75 -1.38 -1.13 -0.96 3.47 0.4 0.88 1.09 0.67 1.24 1.02 0.14 0.2 0.11 -3.04 0.72 -1.46 -1.07 -1.45 0.08 0.42 -0.29 -0.67 -0.49 1.85 0.36 0.02 0.01 0.21 -0.89 0.71 -0.46 -0.56 -0.49 6.11 0.39 1.77 1.45 1.87 -4.8 0.18 -1.49 -1.77 -2.16 -2.23 -2.56 -2.84 2.0500
A
0.00000
%EV -1.00000 %AV %RR -2.00000 %PV
-3.00000
极差图 Range chart
sumSQ(sum(men))/nr SUMSQ(sum(1-10part))/kr 3.1674500 88.3621222 sumSQ(all) n=part k=men r=time 91.8883667 94.6473000 ANOVA Table With Operator*Part Interaction ANOVA Table Without Operator*Part Interaction DF SS MS F P Source DF SS MS F 9 88.36193 9.81799 492.29142 0.00000 Parts 9 88.36193 9.81799 245.61391 2 3.16726 1.58363 79.40605 0.00000 Operators 2 3.16726 1.58363 39.61725 18 0.35898 0.01994 0.43372 0.97411 60 2.75893 0.04598 Repeatability 78 3.11792 0.03997 89 94.64711 Total 89 94.64711 Gauge R&R With Operator*Part Interaction Gauge R&R Without Operator*Part Interaction 0.6000 Source VarComp Stdev %Contribution %TV %Tolerance Source VarComp Stdev %Contribution %TV Total Gauge R&R 0.09811 0.31322 8.27% 28.75% #DIV/0! Total Gauge R&R 0.09143 0.30237 7.76% 27.86% 0.04598 0.21443 3.87% 19.68% #DIV/0! Repeatability 0.03997 0.19993 3.39% 18.42% 0.4000 Repeatability Reproducibility 0.05212 0.22830 4.39% 20.96% #DIV/0! Reproducibility 0.05146 0.22684 4.37% 20.90% Operator 0.05212 0.22830 4.39% 20.96% #DIV/0! Operator 0.05146 0.22684 4.37% 20.90% 0.2000 Operators*Part 0.00000 0.00000 0.00% 0.00% #DIV/0! 1.08867 1.04339 91.73% 95.78% #DIV/0! Part - To - Part 1.08645 1.04233 92.24% 96.04% 0.0000Part - To - Part Total Variation 1.18678 1.08939 100.00% 100.00% #DIV/0! Total Variation 1.17788 1.08530 100.00% 100.00% Source 1.2000 Parts Operators 1.0000 Operators*Part Repeatability 0.8000 Total
测量系统分析 MSA GR&R--- 数据记录表 Data Worksheet 报告编号 Report NO. 量具名称 Equipment Name 量具编号 Equipment NO. 参数规格 Dimension 单位 MM Unit 分析时机Analytical Occasion 零件编号Parts NO. 1. A 2. 3. 4. 5. 6. B 7. 8. 9. 10. 11. C 12. 13. 14. 15. 1 2 3 1 0.29 0.41 0.64 2 -0.56 -0.68 -0.58 产品类型 Description 基件编号 P/N 规格上限 USL 规格下限 LSL 测量人员 OperatorA 测量人员 OperatorB 测量人员 OperatorC 过程变差/过程能力 Process Variation(σ/PP) 测试日期 Test Tate 平价人数 Appraisers 试验次数 Trials 样品数 Samples 3 3 10
X B = 0.068333 RB = 0.513000
-0.223000 -0.256000 -0.284000
均值Mean -0.07333 -1.15667 0.88000 0.15000 -1.32667 -0.48333 0.08000 -0.50333 1.69667 -1.80667 Sum C -0.22 -3.47 0.4200 2.64 0.4200 0.45 0.0900 -3.98 0.3900 -1.45 0.3800 0.24 0.2000 -1.51 0.1000 5.09 0.4200 -5.42 0.6700 -7.63 极差Range 0.1900
均值图 mean chart
1 0.3510 -0.3481 0.8798 0.0000 公差: PV TV
2 0.3510 -0.3481 0.8798 0.0000 1.104596 0.000000 #DIV/0! #DIV/0! #DIV/0! #DIV/0!