測量系統(tǒng)分析MSA GRR表格

,,,,,,,,,,,,,,,,,

測量系統(tǒng)分析MSAGR&R---數(shù)據(jù)記錄表DataWorksheet,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,報(bào)告編號ReportNO.,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

"量具名稱

EquipmentName",,,,,,"產(chǎn)品類型

Description",,,,"測量人員

OperatorＡ",,,,"測試日期

TestTate",,

,,,,,,,,,,,,,,,,,

"量具編號

EquipmentNO.",,,,,,"基件編號

P/N",,,,"測量人員

OperatorＢ",,,,"平價(jià)人數(shù)

Appraisers",,

,,,,,,,,,,,,,,,,,

"參數(shù)規(guī)格

Dimension",,,,,,"規(guī)格上限

USL",,,,"測量人員

OperatorＣ",,,,"試驗(yàn)次數(shù)

Trials",,

,,,,,,,,,,,,,,,,,

"單位

Unit",,,,,,"規(guī)格下限

LSL",,,"過程變差/過程能力

ProcessVariation(σ/PP)",,,,,"樣品數(shù)

Samples",,10

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

分析時(shí)機(jī)AnalyticalOccasion,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

零件編號PartsNO.,,,,1,2,3,4,5,6,7,8,9,10,Total,平均值A(chǔ)verage,

1.,A,,1,,,,,,,,,,,0,#DIV/0!,

2.,,,2,,,,,,,,,,,0,#DIV/0!,

3.,,,3,,,,,,,,,,,0,#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!

,,,SumA,0,0,0,0,0,0,0,0,0,0,0.0000,,

5.,,,極差Range,0,0,0,0,0,0,0,0,0,0,,,0.000000

6.,B,,1,,,,,,,,,,,0,#DIV/0!,

7.,,,2,,,,,,,,,,,,#DIV/0!,

8.,,,3,,,,,,,,,,,0,#DIV/0!,

9.,,,均值Mean,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,#DIV/0!

,,,SumB,0,0,0,0,0,0,0,0,0,0,0.0000,,

10.,,,極差Range,0,0,0,0,0,0,0,0,0,0,,,0.000000

11.,C,,1,,,,,,,,,,,0,#DIV/0!,

12.,,,2,,,,,,,,,,,0,#DIV/0!,

13.,,,3,,,,,,,,,,,0,#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/A

,,,SumC,0,0,0,0,0,0,0,0,0,0,0,,

15.,,,極差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!,#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.000000,0,,#DIV/0!

,,,,,,,,#N/A,,,,試驗(yàn)次數(shù)Trials,,,2,3

,,,,,,,,#DIV/0!,,,,,,D4,3.267,2.575

,,,,,,#DIV/0!,,,,,#N/A,,,D3,0,0

,,,,,,#DIV/0!,,,,,#N/A,,,A2,1.88,1.023

"注:當(dāng)分析結(jié)果超出要求后，利用均值極差圖分析原因Whenanalysisresultisoutofspec,needanalysetherootcausebymeanandrangechart。",,,,,,,,,,,,,,,,

"均值圖

meanchart",,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,1,2,3,4,5,6,7,8,9,10,,,

,,,UCLx,#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/A,,,

,,,LCLR,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,#N/A,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,公差：,,,,6σ,,,pp,變差,,,,

,,,,PV,#DIV/0!,,,PV,#DIV/0!,,#DIV/0!,PV,#DIV/0!,,,

,,,,TV,0.000000,,,TV,0.000000,,#DIV/0!,TV,#N/A,,,基于公差baseonpartsspec

,,%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,,,基于過程能力BaseonprocessPP

,,%PV,,,#DIV/0!,,,,#DIV/0!,,#DIV/0!,,#DIV/0!,,,公式AFormulaA

,,,,ndc,#DIV/0!,,,,,,#N/A,,,,,公式BFormulaB

,,,,X^2/nkr,#DIV/0!,,sumSQ(sum(men))/nr,,,#DIV/0!,SUMSQ(sum(1-10part))/kr,,,#DIV/0!,,

"極差圖

Rangechart",,SUMSQ(sum(men-part))/r,,,,#DIV/0!,,sumSQ(all),,0.0000000,,,,n=partk=menr=time,,

,,,ANOVATableWithOperator*PartInteraction,,,,,,,ANOVATableWithoutOperator*PartInteraction,,,,,,

,,,Source,,DF,SS,MS,F,P,Source,,DF,SS,MS,F,P

,,,Parts,,9,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,Parts,,9,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!

,,,Operators,,-1,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,Operators,,-1,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!

,,,Operators*Part,,-9,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,,,,

,,,Repeatability,,0,#DIV/0!,#DIV/0!,,,Repeatability,,-9,#DIV/0!,#DIV/0!,,

,,,Total,,-1,#DIV/0!,,,,Total,,-1,#DIV/0!,,,

,,,GaugeR&RWithOperator*PartInteraction,,,,,,,GaugeR&RWithoutOperator*PartInteraction,,,,,,

,,,Source,,VarComp,Stdev,%Contribution,%TV,%Tolerance,Source,,VarComp,Stdev,%Contribution,%TV,%Tolerance

,,,TotalGaugeR&R,,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,TotalGaugeR&R,,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!

,,,Repeatability,,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,Repeatability,,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!

,,,Reproducibility,,#DIV/0!,#DIV/0!,#DIV/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!,Operator,,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!

,,,Operators*Part,,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,,,,,,,

,,,Part-To-Part,,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,Part-To-Part,,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!

,,,TotalVariation,,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,TotalVariation,,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

測量系統(tǒng)分析MSAGR&R---均值極差法Averageandmethod,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,報(bào)告編號ReportNO.,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

"量具名稱

Equipment",,,,,,"產(chǎn)品類型

Description",,,,"測量人員

OperatorＡ",,,,,"測試日期

TestTate",1899/12/31

,,,,,,,,,,,,,,,,,

"量具編號

EquipmentNO.",,,,,,"基件編號

PartNO.",,,,"測量人員

OperatorＢ",,,,,"平價(jià)人數(shù)

Appraisers",0

,,,,,,,,,,,,,,,,,

"參數(shù)規(guī)格

Specification",,,,,,"規(guī)格上限

Upperlimit",,,,"測量人員

OperatorＣ",,,,,"試驗(yàn)次數(shù)

Trials",0

,,,,,,,,,,,,,,,,,

"測量單位

Unit",,,,,,"規(guī)格下限

LowerLimit",,,"過程變差/過程能力

ProcessVariation(σ/PP)",,,,,,"樣品數(shù)

Samples",10

,,,,,,,,,,,,,,,,,

Datasheet：,,,,,#N/A,,,#DIV/0!,,,#DIV/0!,,,,,

,,,,,,,,,,,分析方式Analysismode,基于零件變差baseonpartsvariation,,,,

,測量系統(tǒng)分析MSA,,,,,,,,,,%總變差Totalvariation（TV）,,,,,

,重復(fù)性Repeatability－設(shè)備變差EquipmentVariation(EV),,,,,,,,,,,,,,,

,,,,,,,,,,,,=,#N/A,,,

,=,#N/A,,,,,,,"試驗(yàn)次數(shù)

Trials",K1,,,,,,

,,,,,,,,,2,0.8862,,,,,,

,,,,,,,,,3,0.5908,,,,,,

,再現(xiàn)性Reproducibility－評價(jià)人變差A(yù)ppraiserVariation(AV),,,,,,,,,,,,,,,

,,,,,,,,,,,,=,#DIV/0!,,,

,=,#DIV/0!,#DIV/0!,#DIV/0!,,,,,"評價(jià)人數(shù)

Appraisers",K2,,,,,,

,,,,,,,,,2,0.7071,,,,,,

,,,,,,,,,3,0.5231,,,,,,

,重復(fù)性和再現(xiàn)性RepeatabilityandReproducibility(R&R),,,,,,,,,,,,,,,

,,,,,,,,,"零件數(shù)量

PartQTY",K3,,=,#N/A,,,

,=,#N/A,,,,,,,3,0.5231,,,,,,

,,,,,,,,,4,0.4467,,,,,,

,,,,,,,,,5,0.4043,,,,,,

,零件變差PartsVariation(PV),,,,,,,,6,0.3742,,,,,,

,,,,,,公式AFormulaA,,,7,0.3534,,=,#DIV/0!,,,

,=,#DIV/0!,,,,,,,8,0.3375,,,,,,

,,,,,,,,,9,0.3249,,,,,,

,,,,,,,,,10,0.3146,,,,,,

,總變差TotalVariation(TV),,,,,,,,,,有效分辨率AvailabilityResolution(NDC)=1.41*（PV/R&R）,,,,,

,,,,,,,基于零件變差Baseonpartsvariation,,,,,=,#DIV/0!,,,

,=,#N/A,,,,,基于過程變差Baseonprocessvariation,,,,,,,,,

,,,,,,,基于零件公差Baseonpartsspec,,,,,,,,,

,,,,,,,基于過程能力BaseonprocessPP,,,,,,,,,

,判定標(biāo)準(zhǔn)DecideCriterion,,,,,,,,,,,,,,,

1)

0%<%R&R<10%：量測系統(tǒng)狀況良好Excellent；,,,,,,,,,,,判定Decide,,#DIV/0!,,,

10%≤%R&R≤30%：量測系統(tǒng)狀況可以接收，但需改進(jìn)Acceptedbutneedimprovement；,,,,,,,,,,,,,,,,

30%<%R&R<100%：量測系統(tǒng)必須改進(jìn)Rejectedandmustbeimproved。,,,,,,,,,,,#DIV/0!,,,,,

2)數(shù)據(jù)分級數(shù)NDC經(jīng)四舍五入取整后，必須大于或等于5TheNDCistruncatedtotheintegerandoughttobegreaterthanorequalto5。,,,,,,,,,,,,,,,,

"分析評價(jià)措施

Analysisandaction",,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,分析人Analyst,,,,,日期Date,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,Operator,,#REF!,#REF!,#REF!,,#REF!,,,,,,,

,,,,,,,,,,,,,,,,,

,,,Part-To-Part,,#REF!,#REF!,#REF!,,#REF!,,,,,,,

,,,TotalVariation,,#REF!,#REF!,#REF!,,#REF!,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

測量系統(tǒng)分析MSAGR&R---變差數(shù)分析法ANOVAmethod,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,報(bào)告編號ReportNO.,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

"量具名稱

Equipment",,,,,,"產(chǎn)品類型

Description",,,,"測量人員

OperatorＡ",,,,,"測試日期

TestTate",1899/12/31

,,,,,,,,,,,,,,,,,

"量具編號

EquipmentNO.",,,,,,"基件編號

PartNO.",,,,"測量人員

OperatorＢ",,,,,"平價(jià)人數(shù)

Appraisers",0

,,,,,,,,,,,,,,,,,

"參數(shù)規(guī)格

Specification",,,,,,"規(guī)格上限

Upperlimit",,,,"測量人員

OperatorＣ",,,,,"試驗(yàn)次數(shù)

Trials",0

,,,,,,,,,,,,,,,,,

"測量單位

Unit",,,,,,"規(guī)格下限

LowerLimit",,,"過程變差

ProcessVariation(6σ)",,,,,,"樣品數(shù)

Samples",10

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,"方差分析表格

ANOVATable",,,#DIV/0!,操作員和零件的相互作用Operator*PartInteraction,,,,,,,,,,,

,"變差來源

Source",,,,"自由DF

Degreeoffreedom",,"平方的總和SS

Sumofsquares",,"平均平方MS

Meansquare",,"F-比率

F-ratio",,有效分辨率AvailabilityResolution(NDC),,,

,零件Parts,,,,#DIV/0!,,#DIV/0!,,#DIV/0!,,#DIV/0!,,,,,

,評價(jià)者Operators,,,,#DIV/0!,,#DIV/0!,,#DIV/0!,,#DIV/0!,,,,,

,評價(jià)者和零件Operators*Part,,,,#DIV/0!,,#DIV/0!,,#DIV/0!,,#DIV/0!,,,,,

,設(shè)備Equipment,,,,#DIV/0!,,#DIV/0!,,#DIV/0!,,,,#DIV/0!,#DIV/0!,,

,匯總Total,,,,#DIV/0!,,#DIV/0!,,,,,,,,,

,,,,,,,,,,,,,,,,,

,"變差來源

Source",,,,"變差估計(jì)值

Estimateofvaiance",,"標(biāo)準(zhǔn)偏差

Stdev",,%貢獻(xiàn)率Contribution,,%總變差TV,,%公差Tolerance,,,

,系統(tǒng)TotalGaugeR&R,,,,#DIV/0!,,#DIV/0!,,#DIV/0!,,#DIV/0!,,#DIV/0!,,,

,重復(fù)性Repeatability,,,,#DIV/0!,,#DIV/0!,,#DIV/0!,,#DIV/0!,,#DIV/0!,,,

,再現(xiàn)性Reproducibility,,,,#DIV/0!,,#DIV/0!,,#DIV/0!,,#DIV/0!,,#DIV/0!,,,

,評價(jià)者Operator,,,,#DIV/0!,,#DIV/0!,,#DIV/0!,,#DIV/0!,,#DIV/0!,,,

,相互作用InteractionINT=0,,,,0,,0,,0,,0,,0,,,

,零件Part,,,