GRR表格MSA第四版.xlsx

1、 测测量量系系统统分分析析MSA GR&R-数数据据记记录录表表 Data Worksheet报报告告编编号号Report NO.量具名称EquipmentName产品类型Description测量人员Operator测试日期TestTate量具编号EquipmentNO.基件编号P/N测量人员Operator平价人数Appraisers3参数规格Dimension规格上限USL测量人员Operator试验次数Trials3单位UnitMM规格下限LSL过程变差/过程能力ProcessVariation(/PP)样品数Samples10分析时机AnalyticalOccasion零件编号Par

2、tsNO.12345678910Total平均值Average1.A10.29-0.561.340.47-0.80.020.59-0.312.26-1.361.940.1940002.20.41-0.681.170.5-0.92-0.110.75-0.21.99-1.251.660.1660003.30.64-0.581.270.64-0.84-0.210.66-0.172.01-1.312.110.2110004.均值Mean0.44667-0.606671.260000.53667-0.85333-0.100000.66667-0.226672.08667-1.306670.190333S

3、um A1.34-1.823.781.61-2.56-0.32-0.686.26-3.925.71005.极差Range0.350.120.170.170.120.230.160.140.270.110.1840006.B10.08-0.471.190.01-0.56-0.20.47-0.631.8-1.680.010.0010007.20.25-1.220.941.03-1.20.220.550.082.12-1.6211.3040.1150008.30.07-0.681.340.2-1.280.060.83-0.342.19-1.50.890.0890009.均值Mean0.13333-0

4、.790001.156670.41333-1.013330.026670.61667-0.296672.03667-1.600000.068333Sum B0.4-2.373.471.24-3.040.081.85-0.896.11-4.82.050010.极差Range0.180.750.41.020.720.420.360.710.390.180.51300011.C10.04-1.380.880.14-1.46-0.290.02-0.461.77-1.49-2.23-0.22300012.2-0.11-1.131.090.2-1.07-0.670.01-0.561.45-1.77-2.5

5、6-0.25600013.3-0.15-0.960.670.11-1.45-0.490.21-0.491.87-2.16-2.84-0.28400014.均值Mean-0.07333-1.156670.880000.15000-1.32667-0.483330.08000-0.503331.69667-1.80667-0.254333Sum C-0.22-3.472.640.45-3.98-1.450.24-1.515.09-5.42-7.6315.极差Range 0.19000.42000.42000.09000.39000.38000.20000.10000.42000.67000.328

6、000零件均值PartsMean0.168889-0.8511111.0988890.366667-1.064444-0.1855560.454444-0.3422221.940000-1.5711110.001444Total1.520000-7.6600009.8900003.300000-9.580000-1.6700004.090000-3.08000017.460000-14.1400000.133.5111110.341667试验次数Trials230.444667D43.272.5750.3509690.879792D300-0.3480810.000000A21.881.023

7、注:当分析结果超出要求后，利用均值极差图分析原因Whenanalysisresultisoutofspec,needanalysetherootcausebymeanandrangechart。均值图meanchart12345678910UCLx0.35100.35100.35100.35100.35100.35100.35100.35100.35100.3510LCLx-0.3481-0.3481-0.3481-0.3481-0.3481-0.3481-0.3481-0.3481-0.3481-0.3481UCLR0.87980.87980.87980.87980.87980.87980.

8、87980.87980.87980.8798LCLR0.00000.00000.00000.00000.00000.00000.00000.00000.00000.0000公差：6pp变差PV1.104596PV1.1045961.104596PV1.104596TV0.000000TV0.000000#DIV/0!TV1.146135基于公差base on parts spec%EV#DIV/0!#DIV/0!#DIV/0!17.61%基于零件变差baseonpartsvariation%AV#DIV/0!#DIV/0!#DIV/0!20.04%基于过程变差baseonprocessvari

9、ation%RR#DIV/0!#DIV/0!#DIV/0!26.68%基于过程能力Base on process PP%PV#DIV/0!#DIV/0!#DIV/0!96.38%公式AFormulaAndc5.093692473公式BFormulaBX2/nkr0.0001878sumSQ(sum(men)/nr3.1674500SUMSQ(sum(1-10part)/kr88.3621222极差图RangechartSUMSQ(sum(men-part)/r91.8883667sumSQ(all)94.6473000n=partk=menr=timeANOVA Table With Oper

10、ator*Part InteractionANOVA Table Without Operator*Part InteractionSourceDFSSMSFPSourceDFSSMSFPParts988.361939.81799492.291420.00000Parts988.361939.81799245.613910.00000Operators23.167261.5836379.406050.00000Operators23.167261.5836339.617250.00000Operators*Part180.358980.019940.433720.97411Repeatabil

11、ity602.758930.04598Repeatability783.117920.03997Total8994.64711Total8994.64711Gauge R&R With Operator*Part InteractionGauge R&R Without Operator*Part InteractionSourceVarCompStdev%Contribution%TV%ToleranceSourceVarCompStdev%Contribution%TV%ToleranceTotalGaugeR&R0.098110.313228.27%28.75%#DIV/0!TotalG

12、augeR&R0.091430.302377.76%27.86%#DIV/0!Repeatability0.045980.214433.87%19.68%#DIV/0!Repeatability0.039970.199933.39%18.42%#DIV/0!Reproducibility0.052120.228304.39%20.96%#DIV/0!Reproducibility0.051460.226844.37%20.90%#DIV/0!Operator0.052120.228304.39%20.96%#DIV/0!Operator0.051460.226844.37%20.90%#DIV

13、/0!Operators*Part0.000000.000000.00%0.00%#DIV/0!Part-To-Part1.088671.0433991.73%95.78%#DIV/0!Part-To-Part1.086451.0423392.24%96.04%#DIV/0!AXARBXBRCX佃RPPXXnXxXRLX2RAXLX2RDL屒4吳-2.50000-2.00000-1.50000-1.00000-0.50000 0.00000 0.50000 1.00000 1.50000 2.00000 2.50000 AUCLxLCLxBC0.0000 0.2000 0.4000 0.600

14、0 0.8000 1.0000 1.2000 CUCLRLCLRBARegularNew QCPPPAPOtherAppraisersRcRRbA/)(RPage：1/4TotalVariation1.186781.08939100.00%100.00%#DIV/0!TotalVariation1.177881.08530100.00%100.00%#DIV/0!测测量量系系统统分分析析MSA GR&R-均均值值极极差差法法AverageAverage andand methodmethod报报告告编编号号ReportReport NO.NO.量具名称Equipment产品类型Descript

15、ion测量人员Operator测试日期TestTate1900/1/0量具编号EquipmentNO.基件编号PartNO.测量人员Operator平价人数Appraisers3参数规格Specification规格上限Upperlimit测量人员Operator试验次数Trials3测量单位UnitMM规格下限LowerLimit过程变差/过程能力Process Variation(/PP)样品数Samples10Datasheet：0.3416670.4446673.511111分析方式Analysismode基基于于零零件件变变差差basebase onon partsparts var

16、iationvariation测量系统分析MSA%总变差Totalvariation（TV）重复性Repeatability设备变差EquipmentVariation(EV)=17.61%=0.201857试验次数TrialsK120.886230.5908再现性Reproducibility評价人变差AppraiserVariation(AV)=20.04%=0.229667评价人数AppraisersK220.707130.5231重复性和再现性RepeatabilityandReproducibility(R&R)零件数量PartQTYK3=26.68%=0.30576630.5231

17、40.446750.4043零件变差PartsVariation(PV)60.3742公式A Formula A70.3534=96.38%=1.10459680.337590.3249100.3146总变差TotalVariation(TV)有效分辨率AvailabilityResolution(NDC)=1.41*（PV/R&R）基于零件变差Baseonpartsvariation=5=1.146135基于过程变差Baseonprocessvariation基于零件公差Baseonpartsspec基于过程能力Base on process PP判定标准DecideCriterion1)0

18、%R&R10%：量测系统状况良好Excellent；判定Decide可可接接收收AcceptedAccepted10%R&R30%：量测系统状况可以接收，但需改进Acceptedbutneedimprovement；30%R&R100%：量测系统必须改进Rejectedandmustbeimproved。2)数据分级数NDC经四舍五入取整后，必须大于或等于5TheNDCistruncatedtotheintegerandoughttobegreaterthanorequalto5。分析评价措施Analysisandaction倱楋R噅(牮 臶K噁/2222&噁 池噅 偬汒汒)/(0%噔噅噅琩琯

19、琨氥噔 瑬噁 硴噁 汸)/&(0&%噔RRRR)/(0%噔噐噐RPXD IF F3PVKRp 6/TolTV T V22PVR&RTVLSL)/6PP-U SL(TV 3PVA KRpGRRTV2PV B-2.50000-2.00000-1.50000-1.00000-0.50000 0.00000 0.50000 1.00000 1.50000 2.00000 2.50000 AUCLxLCLxBC0.0000 0.2000 0.4000 0.6000 0.8000 1.0000 1.2000 CUCLRLCLRBAPage：2/4分析人Analyst日期Date 测测量量系系统统分分析析M

20、SA GR&R-变变差差数数分分析析法法ANOVAANOVA methodmethod报报告告编编号号ReportReport NO.NO.量具名称Equipment产品类型Description测量人员Operator测试日期TestTate1900/1/0量具编号EquipmentNO.基件编号PartNO.测量人员Operator平价人数Appraisers3参数规格Specification规格上限Upperlimit测量人员Operator试验次数Trials3测量单位UnitMM规格下限LowerLimit过程变差ProcessVariation(6)样品数Samples10方差分

21、析表格ANOVATable不包含without操作员和零件的相互作用Operator*PartInteraction变差来源Source自由DFDegreeoffreedom平方的总和SSSumofsquares平均平方MSMean squareF-比率F-ratio有效分辨率AvailabilityResolution(NDC)零件Parts988.36199.8180245.6139评价者Operators23.16731.583639.6172评价者和零件Operators*Part00.00000.00000.0000设备Equipment783.11790.04004.8605244

22、汇总Total8994.6471变差来源Source变差估计值Estimateofvaiance标准偏差Stdev%贡献率Contribution%总变差TV%公差Tolerance系统TotalGaugeR&R0.09140.30247.76%7.76%27.86%27.86%#DIV/0!#DIV/0!重复性Repeatability0.04000.19993.39%18.42%#DIV/0!再现性Reproducibility0.05150.22684.37%20.90%#DIV/0!评价者Operator0.05150.22684.37%20.90%#DIV/0!相互作用Interac

23、tionINT=000000零件Part1.08641.042392.24%96.04%#DIV/0!总变差TotalVariation1.17791.0853100.00%100.00%#DIV/0!Note:RefertoabovetablesbecausePvalueofoperator*Partisgreaterthansettingvalue人与零件相互作用分界P值TheinteractionbetweenOperatorandpartboundariesPvalueis0.25实际P值Actual P Value0.974基于零件变差Baseonpartsvariation%贡献率

24、Contribution%总变差TV7.76%27.86%基于公差Base on parts spec7.76%#DIV/0!可接收Accepted#DIV/0!分析方法Analysis method基于零件变差Base on partsvariation结论Result可接收Accepted分析评价措施Analysisandaction7.76%3.39%4.37%92.24%27.86%18.42%20.90%96.04%0%0%0%0%变差比重Components of variation系统Total Gauge R&R重复性Repeatability再现性Reproducibility零件Part0%200%贡献率Contribution%总变差TV%公差ToleranceResponse by part12345678910-3.0-2.0-1.0 0.0 1.0 2.0 3.0 Response by operatorABC-2.5-2-1.5-1-0.500.511.522.5Page：3/4分析人Analyst日期DatePage：4/4