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

1、Page：1/9 測測量量系系統(tǒng)統(tǒng)分分析析MSA GR&R-數(shù)數(shù)據(jù)據(jù)記記錄錄表表 Data Worksheet報報告告編編號號Report NO.量具名稱EquipmentName產品類型Description測量人員Operator測試日期TestTate量具編號EquipmentNO.基件編號P/N測量人員Operator平價人數(shù)Appraisers3參數(shù)規(guī)格Dimension規(guī)格上限USL測量人員Operator試驗次數(shù)Trials3單位UnitMM規(guī)格下限LSL過程變差/過程能力ProcessVariation(/PP)樣品數(shù)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試驗次數(shù)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! 測測量量系系統(tǒng)統(tǒng)分分析析MSA GR&R-均均值值極極差差法法AverageAverage andand methodmethod報報告告編編號號ReportReport NO.NO.量具名稱Equipment產品類型Description測量人員Operator測試日期TestTate1899/12/31量具編號EquipmentNO.基

13、件編號PartNO.測量人員Operator平價人數(shù)Appraisers3參數(shù)規(guī)格Specification規(guī)格上限Upperlimit測量人員Operator試驗次數(shù)Trials3測量單位UnitMM規(guī)格下限LowerLimit過程變差/過程能力Process Variation(/PP)樣品數(shù)Samples10Datasheet：#N/A#DIV/0!#DIV/0!分析方式Analysismode基基于于零零件件變變差差basebase onon partsparts variationvariation測量系統(tǒng)分析MSA%總變差Totalvariation（TV）重復性Repeatabi

14、lity設備變差EquipmentVariation(EV)= #N/A= #N/A試驗次數(shù)TrialsK120.886230.5908再現(xiàn)性Reproducibility評價人變差AppraiserVariation(AV)= #DIV/0!= #DIV/0!評價人數(shù)AppraisersK220.707130.5231重復性和再現(xiàn)性RepeatabilityandReproducibility(R&R)零件數(shù)量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%：量測系統(tǒng)狀況良好Excellent；判定Decide#DIV/0!10%R&

16、amp;R30%：量測系統(tǒng)狀況可以接收，但需改進Acceptedbutneedimprovement；30%R&R100%：量測系統(tǒng)必須改進Rejectedandmustbeimproved。#DIV/0!2)數(shù)據(jù)分級數(shù)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 測測量量系系統(tǒng)統(tǒng)分分析析MSA GR&R-變變差差數(shù)數(shù)分分析析法法ANOVAANOVA methodmethod報報告告編編號號ReportReport NO.NO.量具名稱Equipment產品類型Description測量人員Operator測試日期TestTate1899/12/31量具編號EquipmentNO.基件編號PartNO.測量人員Operator平價人數(shù)Appraisers3參數(shù)規(guī)格Specification規(guī)格上限Upperlimit測量人員Operator試驗次數(shù)Trials3測量單位Unit

19、MM規(guī)格下限LowerLimit過程變差ProcessVariation(6)樣品數(shù)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系統(tǒng)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!再現(xiàn)性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、系統(tǒng)Total Gauge R&R重復性Repeatability再現(xiàn)性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