MSA测量系统分析自动表格.xls

2016/4/11 3 7.83 5.410 12345678910Total 1. A17.297.277.137.217.287.367.257.047.007.1071.93 2.27.287.267.127.227.287.357.267.037.017.0771.88 3.37.297.267.147.217.297.367.257.067.017.0871.95 4.均值Mean 7.28667 7.26333 7.13000 7.21333 7.28333 7.35667 7.25333 7.04333 7.00667 7.083337.192000 Sum A21.8621.7921.3921.6421.8522.0721.7621.1321.0221.25 215.7600 5. 极差Range0.010.010.020.010.010.010.010.030.010.030.015000 6. B17.187.267.207.287.157.347.277.066.916.9371.58 7.27.167.257.207.287.157.347.257.056.916.9511.304 8.37.187.267.217.267.147.337.267.066.946.9571.59 9.均值Mean 7.17333 7.25667 7.20333 7.27333 7.14667 7.33667 7.26000 7.05667 6.92000 6.943337.157000 Sum B21.5221.7721.6121.8221.4422.0121.7821.1720.7620.83 214.7100 10. 极差Range0.020.010.010.020.010.010.020.010.030.020.016000 11. C16.977.267.187.167.087.407.297.186.966.8071.28 12.26.957.257.187.147.077.387.297.186.986.8571.27 13.36.947.267.167.157.067.377.277.176.966.8371.17 14.均值Mean 6.95333 7.25667 7.17333 7.15000 7.07000 7.38333 7.28333 7.17667 6.96667 6.826677.124000 Sum C20.8621.7721.5221.4521.2122.1521.8521.5320.920.48213.72 15. 极差Range 0.03000.01000.02000.02000.02000.03000.02000.01000.02000.05000.023000 7.137778 7.258889 7.168889 7.212222 7.166667 7.358889 7.265556 7.092222 6.964444 6.9511117.157667 64.24000065.33000064.52000064.91000064.50000066.23000065.39000063.83000062.68000062.560000644.190.407778 0.01800023 D43.272.575 7.1760810.046350D300 7.1392530.000000A21.881.023 12345678910 UCLx7.17617.17617.17617.17617.17617.17617.17617.17617.17617.1761 LCLx7.13937.13937.13937.13937.13937.13937.13937.13937.13937.1393 UCLR0.04630.04630.04630.04630.04630.04630.04630.04630.04630.0463 LCLR0.00000.00000.00000.00000.00000.00000.00000.00000.00000.0000 公差：6pp变差 PVPV0.128287PV TVTV#DIV/0!TV 基于公差base on parts spec %EV#DIV/0! 基于零件变差base on parts variation %AV#DIV/0! 基于过程变差base on process variation %RR#DIV/0! 基于过程能力Base on process PP %PV#DIV/0!公式A Formula A ndc4.878797653公式B Formula B X2/nkr 4610.89729004610.96667004612.2494333 4612.67043334612.6775000 SourceDFSSMSFPSourceDFSSMSFP Parts91.352140.150247.690940.0001391.352140.1502432.670790.00000 20.069380.034691.775840.1977520.069380.034697.543690.00094 180.351620.01953165.858490.00000 600.007070.00012780.358690.00460 Total891.78021891.78021 SourceVarCompStdev%Contribution%TV%ToleranceSourceVarCompStdev%Contribution%TV%Tolerance 0.007100.0842332.82%57.29%21.06%0.005600.0748425.71% 50.71%18.71% 0.000120.010850.54%7.38%2.71%0.004600.0678121.11% 45.95%16.95% 0.006980.0835332.28%56.81%20.88%0.001000.031674.60% 21.46%7.92% 0.000510.022482.34%15.29%5.62%0.001000.031674.60% 21.46%7.92% 0.006470.0804529.94%54.72%20.11% 0.014520.1205167.18%81.96%30.13%0.016180.1272174.29% 86.19%31.80% Reproducibility Reproducibility Operator Operator Operators*Part 极差图 Range chart SUMSQ(sum(men-part)/rsumSQ(all) n=part k=men r=time ANOVA Table With Operator*Part InteractionANOVA Table Without Operator*Part Interaction Parts Operators Gauge R&R With Operator*Part InteractionGauge R&R Without Operator*Part Interaction Total Gauge R&RTotal Gauge R&R Repeatability Repeatability Operators Operators*Part RepeatabilityRepeatability Total Part - To - PartPart - To - Part 注:当分析结果超出要求后，利用均值极差图分析原因When analysis result is out of spec,need analyse the root cause by mean and range chart 。 均值图 mean chart 0.1282870.1282870.128287 0.4000000.0000000.133537 9.27%#DIV/0!27.76% 32.07%#DIV/0!96.07% 2.66%#DIV/0!7.96% 8.88%#DIV/0!26.60% sumSQ(sum(men)/nrSUMSQ(sum(1-10part)/kr 7.117000 零件均值 Parts Mean Total 试验次数Trials 0.068000 7.195000 7.158000 7.154000 7.159000 7.128000 7.127000 分析时机Analytical Occasion 零件编号Parts NO.平均值Average 7.193000 7.188000 试验次数 Trials 单位 Unit uM 规格下限 LSL 过程变差/过程能力 Process Variation(/PP) 样 品 数 Samples 参数规格 Dimension 6.8 规格上限 USL 测量人员 Operator C 测试日期 Test Tate 量具编号 Equipment NO. SMT 0001 基件编号 P/N 12511820B-23 测量人员 Operator B 平价人数 Appraisers 测量系统分析测量系统分析MSA GR&R-数据记录表数据记录表 Data Worksheet 报告编号报告编号Report NO. 量具名称 Equipment Name 锡厚3D测试仪 产品类型 Description PCBA 测量人员 Operator A = A X = A R = B X = B R = C X = C R =X = P R P X =-=XMinXMaxXDIFF =+=RAXUCLX 2 =-=RAXLCLX 2 =RDUCLR 4 =RDLCLR 3 6.40000 6.60000 6.80000 7.00000 7.20000 7.40000 7.60000 A UCLx LCLx B C 0.0000 0.0100 0.0200 0.0300 0.0400 0.0500 0.0600 C UCLR LCLR B A Regular New QCP PPAP Other =+=AppraisersRcRRb A /)(R Page：1/4 0.021620.14703100.00%100.00%36.76%0.021780.14759100.00%100.00%36.90% 测试 日期 Test 2016/4/11 平价 人数 Appr 3 7.8 试验 次数 Trials 3 5.4 样 品 数 10 0.0180000.0680000.407778 分析方式Analysis mode 重复性Repeatability设备变差Equipment Variation(EV) = = 试验次数 Trials K1 20.8862 30.5908 再现性Reproducibility評价人变差Appraiser Variation(AV) = = 评价人数 Appraise K2 20.7071 30.5231 重复性和再现性Repeatability and Reproducibility(R&R) 零件数量 Part K3= = 30.5231 40.4467 50.4043 零件变差Parts Variation(PV)60.3742 70.3534= = 80.3375 90.3249 100.3146 总变差Total Variation(TV) = = 判定标准Decide Criterion 分析评价措施 Analysis and action 基于过程能力Base on process PP 1) 0%R&R10%：量测系统状况良好Excellent； 判定Decide 可接收可接收Accepted 10%R&R30%：量测系统状况可以接收，但需改进Accepted but need improvement； 30%R&R100%：量测系统必须改进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。 基于零件变差Base on parts variation5 0.133537基于过程变差Base on process variation 基于零件公差Base on parts spec 公式A Formula A96.07% 0.128287 有效分辨率Availability Resolution(NDC)=1.41*（PV/R&R） 26.60% 0.035518 27.76% 0.037076 Datasheet： 基于零件变差基于零件变差base on parts variation 测量系统分析MSA% 总变差Total variation（TV） 7.96% 0.010634 测量单位 Unit uM 规格下限 Lower Limit 过程变差/过程能力 Process Variation( /PP) 参数规格 Specification 6.8 规格上限 Upper limit 测量人员 Operator C 测量系统分析测量系统分析MSA GR&R-均值极差法Average and method均值极差法Average and method 量具编号 Equipment NO. SMT 0001 基件编号 Part NO. 12511820B-23 测量人员 Operator B 报告编号报告编号Report NO. 量具名称 Equipment 锡厚3D测试仪 产品类型 Description PCBA 测量人员 Operator A Total VariationTotal Variation 1 KREV?= ()()nrEVKXAV DIFF / 2 2 2 -?= 22 &AVEVRR+= )/(100%TVEVEV?= )/(100%TVAVAV = )/&(100&%TVRRRR?= )/(100%TVPVPV?= =R= P R 0.0000 = XDIFF 3 PVKR p = 6/TolTV = =TV 22 PVR&RTV+= LSL)/6PP-USL(TV = 3 PVA KRp= GRRTV - = 2 PV B Page：2/4 分析人Analyst日期Date 测试 日期 2016/4/11 平价 人数 3 7.8 试验 次数 3 5.4 样 品 数 10 包含 With 2.01725 22 Note:Refer to above tables because P value of operator*Part is less than setting value 0.25 0.000 需改善Must be improved 需改善Must be improved 结论 Result 分析评价措施 Analysis and action 基于公差 Base on parts spec 32.82%21.06% 分析方法 Analysis method 基于零件变差Base on parts variation 需改善Must be improved 人与零件相互作用分界 P值 The interaction between Operator and part boundaries P value is 实际P值 Actual P Value 基于零件变差 Base on parts variation %贡献率Contribution%总变差TV 32.82%57.29% 总变差Total Variation0.02160.1470100.00%100.00%36.76% 零件Part0.01450.120567.18%81.96%30.13% 相互作用InteractionINT=000000 评价者Operator0.00050.02252.34%15.29%5.62% 再现性Reproducibility0.00700.083532.28%56.81%20.88% 重复性Repeatability0.00010.01090.54%7.38%2.71% 系统Total Gauge R&R0.00710.084232.82%32.82%57.29%57.29%21.06%21.06% 变差来源 Source 变差估计值 Estimate of vaiance 标准偏差 Stdev%贡献率Contribution%总变差TV%公差Tolerance 设备Equipment600.00710.0001 汇总Total891.7802 0.03471.7758 评价者和零件Operators*Part180.35160.0195165.8585 F-比率 F-ratio有效分辨率 Availability Resolution(NDC) 零件Parts91.35210.15027.6909 评价者Operat