APQP-PAP-MSA測(cè)量系統(tǒng)分析自動(dòng)表格-GRR-可編輯版本

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

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

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

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

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

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

"量具名稱

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

Description",,,,"測(cè)量人員

OperatorＡ",,A,,"測(cè)試日期

TestTate",,

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

"量具編號(hào)

EquipmentNO.",,,,,,"基件編號(hào)

P/N",,,,"測(cè)量人員

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

Appraisers",,3

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

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

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

USL",,72,,"測(cè)量人員

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

Trials",,3

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

"單位

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

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

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

Samples",,10

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

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

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

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

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

1.,A,,1,71.7244,71.6857,71.7058,71.703,71.682,71.7244,71.6857,71.7058,71.703,71.682,717.0018,71.700180,

2.,,,2,71.7247,71.6863,71.7035,71.6989,71.6821,71.7247,71.6863,71.7035,71.6989,71.6821,716.991,71.699100,

3.,,,3,71.7230,71.6857,71.7029,71.7029,71.6834,71.7230,71.6857,71.7029,71.7029,71.6834,716.9958,71.699580,

4.,,,均值Mean,71.72403,71.68590,71.70407,71.70160,71.68250,71.72403,71.68590,71.70407,71.70160,71.68250,,,71.699620

,,,SumA,215.1721,215.0577,215.1122,215.1048,215.0475,215.1721,215.0577,215.1122,215.1048,215.0475,2150.9886,,

5.,,,極差Range,0.0017,0.0006,0.0029,0.0041,0.0014,0.0017,0.0006,0.0029,0.0041,0.0014,,,0.002140

6.,B,,1,71.7233,71.6891,71.7046,71.7033,71.683,71.7233,71.6891,71.7046,71.7033,71.683,717.0066,71.700660,

7.,,,2,71.7256,71.6885,71.7043,71.7034,71.6845,71.7256,71.6885,71.7043,71.7034,71.6845,11.304,71.701260,

8.,,,3,71.7251,71.6917,71.7046,71.7039,71.6829,71.7251,71.6917,71.7046,71.7039,71.6829,717.0164,71.701640,

9.,,,均值Mean,71.72467,71.68977,71.70450,71.70353,71.68347,71.72467,71.68977,71.70450,71.70353,71.68347,,,71.701187

,,,SumB,215.174,215.0693,215.1135,215.1106,215.0504,215.174,215.0693,215.1135,215.1106,215.0504,2151.0356,,

10.,,,極差Range,,0.0032,0.0003,0.0006,0.0016,0.0023,0.0032,0.0003,0.0006,0.0016,,,0.001522

11.,C,,1,71.7257,71.6901,71.7018,71.7044,71.6824,71.7257,71.6901,71.7018,71.7044,71.6824,717.0088,71.700880,

12.,,,2,71.7237,71.6896,71.7019,71.7045,71.6834,71.7237,71.6896,71.7019,71.7045,71.6834,717.0062,71.700620,

13.,,,3,71.7247,71.6904,71.7025,71.704,71.6842,71.7247,71.6904,71.7025,71.704,71.6842,717.0116,71.701160,

14.,,,均值Mean,71.72470,71.69003,71.70207,71.70430,71.68333,71.72470,71.69003,71.70207,71.70430,71.68333,,,71.700887

,,,SumC,215.1741,215.0701,215.1062,215.1129,215.05,215.1741,215.0701,215.1062,215.1129,215.05,2151.0266,,

15.,,,極差Range,0.0020,0.0008,0.0007,0.0005,0.0018,0.0020,0.0008,0.0007,0.0005,0.0018,,,0.001160

"零件均值

PartsMean",,,,71.724467,71.688567,71.703544,71.703144,71.683100,71.724467,71.688567,71.703544,71.703144,71.683100,,,71.700564

Total,,,,645.520200,645.197100,645.331900,645.328300,645.147900,645.520200,645.197100,645.331900,645.328300,645.147900,6453.0508,,0.041367

,,,,,,,,0.001607,,,,試驗(yàn)次數(shù)Trials,,,2,3

,,,,,,,,0.001567,,,,,,D4,3.267,2.575

,,,,,,71.702209,,,,,0.004139,,,D3,0,0

,,,,,,71.698920,,,,,0.000000,,,A2,1.88,1.023

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

"均值圖

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

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

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

,,,UCLx,71.7022,71.7022,71.7022,71.7022,71.7022,71.7022,71.7022,71.7022,71.7022,71.7022,,,

,,,LCLx,71.6989,71.6989,71.6989,71.6989,71.6989,71.6989,71.6989,71.6989,71.6989,71.6989,,,

,,,UCLR,0.0041,0.0041,0.0041,0.0041,0.0041,0.0041,0.0041,0.0041,0.0041,0.0041,,,

,,,LCLR,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,,,

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

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

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

,,,,PV,0.013014,,,PV,0.013014,,0.013014,PV,0.013014,,,

,,,,TV,0.100000,,,TV,0.000000,,#DIV/0!,TV,0.013073,,,基于公差baseonpartsspec

,,%EV,,,0.95%,,,,#DIV/0!,,#DIV/0!,,7.26%,,,基于零件變差baseonpartsvariation

,,%AV,,,0.80%,,,,#DIV/0!,,#DIV/0!,,6.13%,,,基于過程變差baseonprocessvariation

,,%RR,,,1.24%,,,,#DIV/0!,,#DIV/0!,,9.50%,,,基于過程能力BaseonprocessPP

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

,,,,ndc,14.77027381,,,,,,,,,,,公式BFormulaB

,,,,X^2/nkr,462687.3847487,,sumSQ(sum(men))/nr,,,462687.3847902,SUMSQ(sum(1-10part))/kr,,,462687.4033932,,

"極差圖

Rangechart",,SUMSQ(sum(men-part))/r,,,,462687.4035058,,sumSQ(all),,462687.4035732,,,,n=partk=menr=time,,

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

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

,,,Parts,,9,0.01864,0.00207,524.01657,0.00000,Parts,,9,0.01864,0.00207,1166.18021,0.00000

,,,Operators,,2,0.00004,0.00002,5.24734,0.01602,Operators,,2,0.00004,0.00002,11.67776,0.00003

,,,Operators*Part,,18,0.00007,0.00000,3.51930,0.00013,,,,,,,

,,,Repeatability,,60,0.00007,0.00000,,,Repeatability,,78,0.00014,0.00000,,

,,,Total,,89,0.01882,,,,Total,,89,0.01882,,,

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

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

,,,TotalGaugeR&R,,0.00000,0.00162,1.13%,10.63%,1.62%,TotalGaugeR&R,,0.00000,0.00155,1.04%,10.18%,1.55%

,,,Repeatability,,0.00000,0.00106,0.48%,6.95%,1.06%,Repeatability,,0.00000,0.00133,0.76%,8.74%,1.33%

,,,Reproducibility,,0.00000,0.00123,0.65%,8.04%,1.23%,Reproducibility,,0.00000,0.00080,0.27%,5.22%,0.80%

,,,Operator,,0.00000,0.00075,0.24%,4.91%,0.75%,Operator,,0.00000,0.00080,0.27%,5.22%,0.80%

,,,Operators*Part,,0.00000,0.00097,0.41%,6.37%,0.97%,,,,,,,

,,,Part-To-Part,,0.00023,0.01516,98.87%,99.43%,15.16%,Part-To-Part,,0.00023,0.01517,98.96%,99.48%,15.17%

,,,TotalVariation,,0.00023,0.01524,100.00%,100.00%,15.24%,TotalVariation,,0.00023,0.01524,100.00%,100.00%,15.24%

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

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

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

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

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

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

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

"量具名稱

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

Description",,,,"測(cè)量人員

OperatorＡ",,A,,,"測(cè)試日期

TestTate",1899/12/31

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

"量具編號(hào)

EquipmentNO.",,,,,,"基件編號(hào)

PartNO.",,,,"測(cè)量人員

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

Appraisers",3

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

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

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

Upperlimit",,72,,"測(cè)量人員

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

Trials",3

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

"測(cè)量單位

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

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

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

Samples",10

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

Datasheet：,,,,,0.001607,,,0.001567,,,0.041367,,,,,

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

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

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

,,,,,,,,,,,,=,7.26%,,,

,=,0.000950,,,,,,,"試驗(yàn)次數(shù)

Trials",K1,,,,,,

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

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

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

,,,,,,,,,,,,=,6.13%,,,

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

Appraisers",K2,,,,,,

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

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

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

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

PartQTY",K3,,=,9.50%,,,

,=,0.001242,,,,,,,3,0.5231,,,,,,

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

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

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

,,,,,,公式AFormulaA,,,7,0.3534,,=,99.55%,,,

,=,0.013014,,,,,,,8,0.3375,,,,,,

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

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

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

,,,,,,,基于零件變差Baseonpartsvariation,,,,,=,15,,,

,=,0.013073,,,,,基于過程變差Baseonprocessvariation,,,,,,,,,

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

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

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

1)

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

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

30%<%R&R<100%：量測(cè)系統(tǒng)必須改進(jìn)Rejectedandmustbeimproved。,,,,,,,,,,,,,,,,

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

"分析評(píng)價(jià)措施

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

"量具名稱

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

Description",,,,"測(cè)量人員

OperatorＡ",,A,,,"測(cè)試日期

TestTate",1899/12/31

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

"量具編號(hào)

EquipmentNO.",,,,,,"基件編號(hào)

PartNO.",,,,"測(cè)量人員

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

Appraisers",3

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

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

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

Upperlimit",,72,,"測(cè)量人員

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

Trials",3

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

"測(cè)量單位

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

LowerLimit",,71.4,"過程變差

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

Samples",10

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

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

,"方差分析表格

ANOVATable",,,包含With,操作員和零件的相互作用Operator*PartInteraction,,,,,,,,,,,

,"變差來源

Source",,,,"自由DF

Degreeoffreedom",,"平方的總和SS

Sumofsquares",,"平均平方MS

Meansquare",,"F-比率

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

,零件Parts,,,,9,,0.0186,,0.0021,,524.0166,,,,,

,評(píng)價(jià)者Operators,,,,2,,0.0000,,0.0000,,5.2473,,,,,

,評(píng)價(jià)者和零件Operators*Part,,,,18,,0.0001,,0.0000,,3.5193,,,,,

,設(shè)備Equipment,,,,60,,0.0001,,0.0000,,,,13.18741,≈13,,

,匯總Total,,,,89,,0.0188,,,,,,,,,

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

,"變差來源

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

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

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

,系統(tǒng)TotalGaugeR&R,,,,0.0000,,0.0016,,1.13%,,10.63%,,1.62%,,,

,重復(fù)性Repeatability,,,,0.0000,,0.0011,,0.48%,,6.95%,,1.06%,,,

,再現(xiàn)性Reproducibility,,,,0.0000,,0.0012,,0.65%,,8.04%,,1.23%,,,

,評(píng)價(jià)者Operator,,,,0.0000,,0.0007,,0.24%,,4.91%,,0.