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

測量系統分析MSAGR&R---數據記錄表DataWorksheet,,,,,,,,,,,,,,,,

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

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

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

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

"量具名稱

EquipmentName",,,,,,"產品類型

Description",,,,"測量人員

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

TestTate",,

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

"量具編號

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

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

OperatorＢ",,B,,"平價人數

Appraisers",,3

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

"參數規格

Dimension",,,,,,"規格上限

USL",,72,,"測量人員

OperatorＣ",,C,,"試驗次數

Trials",,3

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

"單位

Unit",,,,MM,,"規格下限

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

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

Samples",,10

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

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

分析時機AnalyticalOccasion,,,,,,,,,,,,,,,,

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

零件編號PartsNO.,,,,1,2,3,4,5,6,7,8,9,10,Total,平均值Average,

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,,,,試驗次數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

"注:當分析結果超出要求后，利用均值極差圖分析原因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%

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

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

測量系統分析MSAGR&R---均值極差法Averageandmethod,,,,,,,,,,,,,,,,

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

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

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

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

"量具名稱

Equipment",,,,,,"產品類型

Description",,,,"測量人員

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

TestTate",1899/12/31

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

"量具編號

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

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

OperatorＢ",,B,,,"平價人數

Appraisers",3

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

"參數規格

Specification",,,,,,"規格上限

Upperlimit",,72,,"測量人員

OperatorＣ",,C,,,"試驗次數

Trials",3

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

"測量單位

Unit",,,,MM,,"規格下限

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

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

Samples",10

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

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

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

,測量系統分析MSA,,,,,,,,,,%總變差Totalvariation（TV）,,,,,

,重復性Repeatability－設備變差EquipmentVariation(EV),,,,,,,,,,,,,,,

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

,=,0.000950,,,,,,,"試驗次數

Trials",K1,,,,,,

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

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

,再現性Reproducibility－評價人變差AppraiserVariation(AV),,,,,,,,,,,,,,,

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

,=,0.000801,#DIV/0!,#DIV/0!,,,,,"評價人數

Appraisers",K2,,,,,,

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

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

,重復性和再現性RepeatabilityandReproducibility(R&R),,,,,,,,,,,,,,,

,,,,,,,,,"零件數量

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

,判定標準DecideCriterion,,,,,,,,,,,,,,,

1)

0%<%R&R<10%：量測系統狀況良好Excellent；,,,,,,,,,,,判定Decide,,良好Excellent,,,

10%≤%R&R≤30%：量測系統狀況可以接收，但需改進Acceptedbutneedimprovement；,,,,,,,,,,,,,,,,

30%<%R&R<100%：量測系統必須改進Rejectedandmustbeimproved。,,,,,,,,,,,,,,,,

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

"分析評價措施

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

測量系統分析MSAGR&R---變差數分析法ANOVAmethod,,,,,,,,,,,,,,,,

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

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

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

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

"量具名稱

Equipment",,,,,,"產品類型

Description",,,,"測量人員

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

TestTate",1899/12/31

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

"量具編號

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

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

OperatorＢ",,B,,,"平價人數

Appraisers",3

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

"參數規格

Specification",,,,,,"規格上限

Upperlimit",,72,,"測量人員

OperatorＣ",,C,,,"試驗次數

Trials",3

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

"測量單位

Unit",,,,MM,,"規格下限

LowerLimit",,71.4,"過程變差

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

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

,評價者Operators,,,,2,,0.0000,,0.0000,,5.2473,,,,,

,評價者和零件Operators*Part,,,,18,,0.0001,,0.0000,,3.5193,,,,,

,設備Equipment,,,,60,,0.0001,,0.0000,,,,13.18741,≈13,,

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

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

,"變差來源

Source",,,,"變差估計值

Estimateofvaiance",,"標準偏差

Stdev",,%貢獻率Contribution,,%總變差TV,,%公差Tolerance,,,

,系統TotalGaugeR&R,,,,0.0000,,0.0016,,1.13%,,10.63%,,1.62%,,,

,重復性Repeatability,,,,0.0000,,0.0011,,0.48%,,6.95%,,1.06%,,,

,再現性Reproducibility,,,,0.0000,,0.0012,,0.65%,,8.04%,,1.23%,,,

,評價者Operator,,,,0.0000,,0.0007,,0.24%,,4.91%,,0.