GR&R自动生成Excel表格(MSA第四版)

GR&R自动生成Excel表格(MSA第四版)

测量系统分析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 测量人员 OperatorＡ 测量人员 OperatorＢ 测量人员 OperatorＣ 过程变差/过程能力 Process Variation(σ/PP) 测试日期 Test Tate 平价人数 Appraisers 试验次数 Trials 样品数 Samples 3 3 10Regular3 1.34 1.17 1.27 4 0.47 0.5 0.64New QCP5 -0.8 -0.92 -0.84 6 0.02 -0.11 -0.21 7PPAP8 -0.31 -0.2 -0.17Other9 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.2110000.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.7100X A = 0.190333R A = 0.1840000.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.0500X 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.1900X C = -0.254333RC = 0.328000零件均值 Parts MeanXP0.168889 -0.851111 1.098889 0.366667 -1.064444 -0.185556 0.454444 -0.342222 1.940000 -1.571111-7.660000 9.890000X=0.13 2 D4 3.27 0 1.880.001444Total 1.5200003.300000 -9.580000 -1.670000 4.090000 -3.08000017.460000 -14.140000RP = 3.5111113 2.575 0 1.023R = ( R A + R b + Rc ) / Appraisers=0.341667试验次数TrialsX DIFF = MaxX - Min X =0.444667UCLX = X + A2 R = LCLX = X - A2 R =0.350969-0.348081UCLR = D4 R =LCLR = D3 R =0.879792 0.000000D3 A2注:当分析结果超出要求后，利用均值极差图分析原因When analysis result is out of spec,need analyse the root cause by mean and range chart 。3.00000 UCLx LCLx 2.00000 R UCL LCLR 1.00000均值图 mean chart1 0.3510 -0.3481 0.8798 0.0000 公差： PV TV2 0.3510 -0.3481 0.8798 0.0000 1.104596 0.000000 #DIV/0! #DIV/0! #DIV/0! #DIV/0!5.0936924733 0.3510 -0.3481 0.8798 0.00004

GR&R自动生成Excel表格(MSA第四版)

0.3510 -0.3481 0.8798 0.00005 0.3510 -0.3481 0.8798 0.0000 6σ PV TV6 0.3510 -0.3481 0.8798 0.0000 1.104596 0.000000 #DIV/0! #DIV/0! #DIV/0! #DIV/0!7 0.3510 -0.3481 0.8798 0.00008 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 TV10 0.3510 -0.3481 0.8798 0.0000A0.00000 -1.00000 %EV %AV %RR -2.00000 %PV -3.00000极差图 Range chartsumSQ(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 Source DF SS MS F P Source DF SS MS F 1.2000 Parts 9 88.36193 9.81799 492.29142 0.00000 Parts 9 88.36193 9.81799 245.61391 Operators 2 3.16726 1.58363 79.40605 0.00000 Operators 2 3.16726 1.58363 39.61725 1.0000 Operators*Part 18 0.35898 0.01994 0.43372 0.97411 60 2.75893 0.04598 Repeatability 78 3.11792 0.03997 0.8000 Repeatability Total 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.4000 Repeatability 0.04598 0.21443 3.87% 19.68% #DIV/0! Repeatability 0.03997 0.19993 3.39% 18.42% 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! 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% Total Variation 1.18678 1.08939 100.00% 100.00% #DIV/0! Total Variation 1.17788 1.08530 100.00% 100.00%X^2/nkr 0.0001878 SUMSQ(sum(men-part))/rndc1.104596 1.146135 17.61% 20.04% 26.68% 96.38%UCLx基于公差base on parts spec基于零件变差base on parts variation基于过程变差base on process v ariationLCLx B基于过程能力Base on process PPC 公式A Formula A 公式B Formula BP 0.00000 0.00000C UCLR%Tolerance #DIV/0! LCLR #DIV/0! #DIV/0! B #DIV/0!A#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 测量人员 OperatorＡ 测量人员 OperatorＢ 测量人员 OperatorＣ 过程变差/过程能力Process Variation(σ /PP)测试 1900-1-0 日期 平价 人数 试验 次数 样品 数 3 3 10R=0.341667XDIFF= 0.444667RP =3.511111分析方式Analysis mode 测量系统分析MSA 重复性Repeatability－设备变差Equipment Variation(EV)基于零件变差 base on parts variation% 总变差Total variation（TV）% EV = 100 ´ ( EV /

GR&R自动生成Excel表格(MSA第四版)

TV )= 17.61% 试验次 数 2 3 K1 0.8862 0.5908EV = R ´ K1= 0.201857再现性Reproducibility－評价人变差Appraiser Variation(AV)AV =(X2 DIFF ´ K 2 ) - EV / nr 2()% AV = 100 ´ ( AV / TV )= 20.04% 评价人 数 2 3 K2 0.7071 0.5231= 0.229667重复性和再现性Repeatability and Reproducibility(R&R)% R & R = 100 ´ ( R & R / TV )零件数 量 3 4 5 K3 0.5231 0.4467 0.4043 0.3742 0.3534 0.3375 0.3249 0.3146有效分辨率Availability Resolution(NDC)=1.41*（PV/R&R）R & R = EV + AV22= 26.68%= 0.305766零件变差Parts Variation(PV)6 公式A Formula A 7 8 9 10% PV = 100 ´ ( PV / TV )= 96.38%PV = R p ´ K 3= 1.104596A PV = R p ´ K 3B PV = TV 2 - GRR总变差Total Variation(TV)TV = R & R + PV2= 1.1461352基于零件变差Base on parts variation基于过程变差Base on process variation= 5TV = Tol / 6TV= TV = ( USL - LSL)/6PP判定标准Decide Criterion基于零件公差Base on parts spec 基于过程能力Base on process PP1) 0%<%R&R<10%：量测系统状况良好Excellent；10%≤%R&R≤30%：量测系统状况可以接收，但需改进Accepted but need improvement；判定Decide可接收Accepted30%<%R&R<100%：量测系统必须改进Rejected and must be improved 。 2) 数据分级数NDC经四舍五入取整后，必须大于或等于5 The NDC is truncated to the integer and ought to be greater than or equal to 5。 分析评价措施 Analysis and action分析人Analyst日期DatePage：2/3测量系统分析MSA GR&R---变差数分析法ANOVA method 报告编号Report NO. 量具名称 Equipment 量具编号 Equipment NO. 参数规格 Specification 测量单位 MM Unit 产品类型 Description 基件编号 Part NO. 规格上限 Upper limit 规格下限 Lower Limit测量人员 OperatorＡ 测量人员 OperatorＢ 测量人员 OperatorＣ 过程变差 Process Variation(6σ)测试 1900-1-0 日期 平价 3 人数 试验 3 次数 样品 10 数方差分析表 操作员和零件的相互作用 不包含 格 Operator*Part Interaction without ANOVA 自由DF 平方的总和SS 变差来源 Source Degree of freedom Sum of squares 零件Parts 评价者Operators评价者和零件Operators*Part平均平方MS Mean square 9.8180 1.5836 0.0000 0.0400F-比率 F-ratio 245.6139 39.6172 0.00009 2 0 78 89 变差估计值Estimate of vaiance88.3619 3.1673 0.0000 3.1179 94.6471 标准偏差 Stdev 0.3024 0.1999 0.2268 0.2268 0 1.0423有效分辨率 Availability Resolution(NDC)设备Equipment 汇总Total 变差来源 Source 系统Total Gauge R&R 重复性Repeatability 再现性Reproducibility 评价者Operator相互作用InteractionINT=04.86052 ≈4%贡献率Contribution%总变差TV%公差Tolerance0.0914 0.0400 0.0515 0.0515 0 1.08647.76%3.39% 4.37% 4.37% 0 92.24%27.86%18.42% 20.90% 20.90% 0 96.04%#DIV/0!#DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0!零件Part总变差Total Variation 1.1779 1.0853 100.00% 100.00% Note: Refer to above tab

本文来源：https://www.bwwdw.com/article/xbii.html