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

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

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

,,,,,,,,,,,報告編號ReportNO.,,,,,

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

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

"量具名稱

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

Description",,,,"測量人員

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

TestTate",,

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

"量具編號

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

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

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

Appraisers",,

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

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

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

USL",,,,"測量人員

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

Trials",,

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

"單位

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

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

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

Samples",,10

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

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

分析時機(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,,,,試驗次數(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,,,,,,,,,,,,,,,,

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

,,,,,,,,,,,報告編號ReportNO.,,,,,

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

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

"量具名稱

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

Description",,,,"測量人員

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

TestTate",1899/12/31

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

"量具編號

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

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

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

Appraisers",0

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

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

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

Upperlimit",,,,"測量人員

OperatorＣ",,,,,"試驗次數(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,,,,,,,"試驗次數(shù)

Trials",K1,,,,,,

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

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

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

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

,=,#DIV/0!,#DIV/0!,#DIV/0!,,,,,"評價人數(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。,,,,,,,,,,,,,,,,

"分析評價措施

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,,,,,,,,,,,,,,,,

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

,,,,,,,,,,,,報告編號ReportNO.,,,,

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

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

"量具名稱

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

Description",,,,"測量人員

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

TestTate",1899/12/31

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

"量具編號

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

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

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

Appraisers",0

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

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

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

Upperlimit",,,,"測量人員

OperatorＣ",,,,,"試驗次數(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!,,,,,

,評價者Operators,,,,#DIV/0!,,#DIV/0!,,#DIV/0!,,#DIV/0!,,,,,

,評價者和零件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",,,,"變差估計值

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!,,,

,評價者Operator,,,,#DIV/0!,,#DIV/0!,,#DIV/0!,,#DIV/0!,,#DIV/0!,,,

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

,零件Part,,,