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

1、Page：1/9 测测量量系系统统分分析析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分析时机AnalyticalOcc

2、asion零件编号PartsNO.12345678910Total平均值Average1.A10#DIV/0!2.20#DIV/0!3.30#DIV/0!4.均值Mean#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Sum A00000000000.00005.极差Range00000000000.0000006.B10#DIV/0!7.211.304#DIV/0!8.30#DIV/0!9.均值Mean#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#

3、DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Sum B00000000000.000010.极差Range00000000000.00000011. C10#DIV/0!12.20#DIV/0!13.30#DIV/0!14.均值Mean#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/ASum C0000000000015.极差Range#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A零件均值PartsMean#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#

4、DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Total 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0000000#DIV/0!#N/A试验次数Trials23#DIV/0!D43.2672.575#DIV/0!#N/AD300#DIV/0!#N/AA21.881.023注:当分析结果超出要求后，利用均值极差图分析原因Whenanalysisresultisoutofspec,needanalysetherootcausebymeanandrange

5、chart。均值图meanchart12345678910UCLx#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!LCLx#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!UCLR#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/ALCLR#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A公差：6pp变差PV#DIV/0!PV#DIV/0!#DIV/0!PV

6、#DIV/0!TV0.000000TV0.000000#DIV/0!TV#N/A基于公差base on parts spec%EV#N/A#N/A#N/A#N/A基于零件变差baseonpartsvariation%AV#DIV/0!#DIV/0!#DIV/0!#DIV/0!基于过程变差baseonprocessvariation%RR#N/A#N/A#N/A#N/A基于过程能力Base on process PP%PV#DIV/0!#DIV/0!#DIV/0!#DIV/0!公式AFormulaAndc#DIV/0!#N/A公式BFormulaBX2/nkr0.0000000sumSQ(sum

7、(men)/nr0.0000000SUMSQ(sum(1-10part)/kr0.0000000极差图RangechartSUMSQ(sum(men-part)/r0.0000000sumSQ(all)0.0000000n=partk=menr=timeANOVA Table With Operator*Part InteractionANOVA Table Without Operator*Part InteractionSourceDFSSMSFPSourceDFSSMSFPParts90.000000.00000#DIV/0!#DIV/0!Parts90.000000.00000#DIV

8、/0!#DIV/0!Operators20.000000.00000#DIV/0!#DIV/0!Operators20.000000.00000#DIV/0!#DIV/0!Operators*Part180.000000.00000#DIV/0!#DIV/0!Repeatability600.000000.00000Repeatability780.000000.00000Total890.00000Total890.00000Gauge R&R With Operator*Part InteractionGauge R&R Without Operator*Part Inte

9、ractionSourceVarCompStdev%Contribution%TV%ToleranceSourceVarCompStdev%Contribution%TV%ToleranceTotalGaugeR&R0.000000.00000#DIV/0!#DIV/0!#DIV/0!TotalGaugeR&R0.000000.00000#DIV/0!#DIV/0!#DIV/0!Repeatability0.000000.00000#DIV/0!#DIV/0!#DIV/0!Repeatability0.000000.00000#DIV/0!#DIV/0!#DIV/0!Repro

10、ducibility0.000000.00000#DIV/0!#DIV/0!#DIV/0!Reproducibility0.000000.00000#DIV/0!#DIV/0!#DIV/0!Operator0.000000.00000#DIV/0!#DIV/0!#DIV/0!Operator0.000000.00000#DIV/0!#DIV/0!#DIV/0!Operators*Part0.000000.00000#DIV/0!#DIV/0!#DIV/0!Part-To-Part0.000000.00000#DIV/0!#DIV/0!#DIV/0!Part-To-Part0.000000.00

11、000#DIV/0!#DIV/0!#DIV/0!AX=AR=BX=BR=CX=佃R礽=PPX=-=X楍nX慍xXRLX2=-=RAXLX2=RDL屒4吳0.00000 0.10000 0.20000 0.30000 0.40000 0.50000 0.60000 0.70000 0.80000 0.90000 1.00000 AUCLxLCLxBC0.0000 0.1000 0.2000 0.3000 0.4000 0.5000 0.6000 0.7000 0.8000 0.9000 1.0000 CUCLRLCLRBARegularNew QCPPPAPOther=+=A p p r a i

12、s e r sR cRRbA/)(RPage：2/9TotalVariation0.000000.00000#DIV/0!#DIV/0!#DIV/0!TotalVariation0.000000.00000#DIV/0!#DIV/0!#DIV/0! 测测量量系系统统分分析析MSA GR&R-均均值值极极差差法法AverageAverage andand methodmethod报报告告编编号号ReportReport NO.NO.量具名称Equipment产品类型Description测量人员Operator测试日期TestTate1899/12/31量具编号EquipmentNO.基

13、件编号PartNO.测量人员Operator平价人数Appraisers3参数规格Specification规格上限Upperlimit测量人员Operator试验次数Trials3测量单位UnitMM规格下限LowerLimit过程变差/过程能力Process Variation(/PP)样品数Samples10Datasheet：#N/A#DIV/0!#DIV/0!分析方式Analysismode基基于于零零件件变变差差basebase onon partsparts variationvariation测量系统分析MSA%总变差Totalvariation（TV）重复性Repeatabi

14、lity设备变差EquipmentVariation(EV)= #N/A= #N/A试验次数TrialsK120.886230.5908再现性Reproducibility評价人变差AppraiserVariation(AV)= #DIV/0!= #DIV/0!评价人数AppraisersK220.707130.5231重复性和再现性RepeatabilityandReproducibility(R&R)零件数量PartQTYK3= #N/A= #N/A30.523140.446750.4043零件变差PartsVariation(PV)60.3742公式A Formula A70.3

15、534= #DIV/0!= #DIV/0!80.337590.3249100.3146总变差TotalVariation(TV)有效分辨率AvailabilityResolution(NDC)=1.41*（PV/R&R）基于零件变差Baseonpartsvariation= #DIV/0!= #N/A基于过程变差Baseonprocessvariation基于零件公差Baseonpartsspec基于过程能力Base on process PP判定标准DecideCriterion1)0%R&R10%：量测系统状况良好Excellent；判定Decide#DIV/0!10%R&

16、amp;R30%：量测系统状况可以接收，但需改进Acceptedbutneedimprovement；30%R&R100%：量测系统必须改进Rejectedandmustbeimproved。#DIV/0!2)数据分级数NDC经四舍五入取整后，必须大于或等于5TheNDCistruncatedtotheintegerandoughttobegreaterthanorequalto5。分析评价措施Analysisandaction倱楋R噅=()(牮 臶噅 K噁/22-22&噁 池噅 偬汒汒倫倽)/(0%噔噅噅=琩琯琨氰氥噔 瑬噁 硴噁 汸璴琽)/&(0&%噔RRR

17、R=)/(0%噔噐噐=R=P=XD I F F3P VKRp= 6/T o lT V=s=T V22P VR&RT V+=L S L )/6 P P-U S L(T V=3PVA KRp=GRRTV-=2PV B极差图Rangechart0.00000 0.10000 0.20000 0.30000 0.40000 0.50000 0.60000 0.70000 0.80000 0.90000 1.00000 AUCLxLCLxBC0.0000 0.1000 0.2000 0.3000 0.4000 0.5000 0.6000 0.7000 0.8000 0.9000 1.0000 C

18、UCLRLCLRBAPage：3/9分析人Analyst日期Date 测测量量系系统统分分析析MSA GR&R-变变差差数数分分析析法法ANOVAANOVA methodmethod报报告告编编号号ReportReport NO.NO.量具名称Equipment产品类型Description测量人员Operator测试日期TestTate1899/12/31量具编号EquipmentNO.基件编号PartNO.测量人员Operator平价人数Appraisers3参数规格Specification规格上限Upperlimit测量人员Operator试验次数Trials3测量单位Unit

19、MM规格下限LowerLimit过程变差ProcessVariation(6)样品数Samples10方差分析表格ANOVATable#DIV/0!操作员和零件的相互作用Operator*PartInteraction变差来源Source自由DFDegreeoffreedom平方的总和SSSumofsquares平均平方MSMean squareF-比率F-ratio有效分辨率AvailabilityResolution(NDC)零件Parts#DIV/0!#DIV/0!#DIV/0!#DIV/0!评价者Operators#DIV/0!#DIV/0!#DIV/0!#DIV/0!评价者和零件Op

20、erators*Part#DIV/0!#DIV/0!#DIV/0!#DIV/0!设备Equipment#DIV/0!#DIV/0!#DIV/0!#DIV/0! #DIV/0!#DIV/0!汇总Total#DIV/0!#DIV/0!变差来源Source变差估计值Estimateofvaiance标准偏差Stdev%贡献率Contribution%总变差TV%公差Tolerance系统TotalGaugeR&R#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!重复性Repeatability#DIV/0!#DIV/0!#DIV/

21、0!#DIV/0!#DIV/0!再现性Reproducibility#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!评价者Operator#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!相互作用InteractionINT=000000零件Part#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!总变差TotalVariation#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#人与零件相互作用分界P值TheinteractionbetweenOperatorandpartboundariesPvalueis

22、0.25实际P值Actual P Value#DIV/0!基于零件变差Baseonpartsvariation%贡献率Contribution%总变差TV#DIV/0!#DIV/0!基于公差Base on parts spec#DIV/0!#DIV/0!#DIV/0!#DIV/0!分析方法Analysismethod基于零件变差Base on partsvariation结论Result#DIV/0!分析评价措施Analysisandaction0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0%0%0%0%变差比重Components of variation

23、系统Total Gauge R&R重复性Repeatability再现性Reproducibility0%200%贡献率Contribution%总变差TV%公差ToleranceResponse by part123456789100.0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1.0 Response by operatorABC00.10.20.30.40.50.60.70.80.91Page：4/9分析人Analyst日期Datea1559.839.50.823.70.678a1558.840.10.923.80.679a155739.80.62

24、3.80.676a21109.288.78.324.50.662a21091.388.48.324.60.663a2109288.48.424.70.662a31465104.1325.40.671a31456.8102.53.125.40.671a31457102.63.225.40.672b1551.540.80.623.70.679b1551.639.70.923.80.678b1552.639.10.623.70.68b2109888.58.124.60.663b21093.1888.324.60.663b21099.188.28.524.50.664b3146788.78.124.60.67b31465.488.88.524.70.671b31467.688.58.424.50.672c1559.839.51.123.40.678c155