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 …… 此处隐藏：4622字，全部文档内容请下载后查看。喜欢就下载吧 ……