GRR表格MSA第四版.xlsx

GRR表格MSA第四版.xlsx

《GRR表格MSA第四版.xlsx》由会员分享，可在线阅读，更多相关《GRR表格MSA第四版.xlsx（4页珍藏版）》请在冰豆网上搜索。

测测量量系系统统分分析析MSAGR&R-数数据据记记录录表表DataWorksheet报报告告编编号号ReportNO.量具名称EquipmentName产品类型Description测量人员Operator测试日期TestTate量具编号EquipmentNO.基件编号P/N测量人员Operator平价人数Appraisers3参数规格Dimension规格上限USL测量人员Operator试验次数Trials3单位UnitMM规格下限LSL过程变差/过程能力ProcessVariation（/PP）样品数Samples10分析时机AnalyticalOccasion零件编号PartsNO.12345678910Total平均值Average1.A10.29-0.561.340.47-0.80.020.59-0.312.26-1.361.940.1940002.20.41-0.681.170.5-0.92-0.110.75-0.21.99-1.251.660.1660003.30.64-0.581.270.64-0.84-0.210.66-0.172.01-1.312.110.2110004.均值Mean0.44667-0.606671.260000.53667-0.85333-0.100000.66667-0.226672.08667-1.306670.190333SumA1.34-1.823.781.61-2.56-0.32-0.686.26-3.925.71005.极差Range0.350.120.170.170.120.230.160.140.270.110.1840006.B10.08-0.471.190.01-0.56-0.20.47-0.631.8-1.680.010.0010007.20.25-1.220.941.03-1.20.220.550.082.12-1.6211.3040.1150008.30.07-0.681.340.2-1.280.060.83-0.342.19-1.50.890.0890009.均值Mean0.13333-0.790001.156670.41333-1.013330.026670.61667-0.296672.03667-1.600000.068333SumB0.4-2.373.471.24-3.040.081.85-0.896.11-4.82.050010.极差Range0.180.750.41.020.720.420.360.710.390.180.51300011.C10.04-1.380.880.14-1.46-0.290.02-0.461.77-1.49-2.23-0.22300012.2-0.11-1.131.090.2-1.07-0.670.01-0.561.45-1.77-2.56-0.25600013.3-0.15-0.960.670.11-1.45-0.490.21-0.491.87-2.16-2.84-0.28400014.均值Mean-0.07333-1.156670.880000.15000-1.32667-0.483330.08000-0.503331.69667-1.80667-0.254333SumC-0.22-3.472.640.45-3.98-1.450.24-1.515.09-5.42-7.6315.极差Range0.19000.42000.42000.09000.39000.38000.20000.10000.42000.67000.328000零件均值PartsMean0.168889-0.8511111.0988890.366667-1.064444-0.1855560.454444-0.3422221.940000-1.5711110.001444Total1.520000-7.6600009.8900003.300000-9.580000-1.6700004.090000-3.08000017.460000-14.1400000.133.5111110.341667试验次数Trials230.444667D43.272.5750.3509690.879792D300-0.3480810.000000A21.881.023注:

当分析结果超出要求后，利用均值极差图分析原因Whenanalysisresultisoutofspec,needanalysetherootcausebymeanandrangechart。

均值图meanchart12345678910UCLx0.35100.35100.35100.35100.35100.35100.35100.35100.35100.3510LCLx-0.3481-0.3481-0.3481-0.3481-0.3481-0.3481-0.3481-0.3481-0.3481-0.3481UCLR0.87980.87980.87980.87980.87980.87980.87980.87980.87980.8798LCLR0.00000.00000.00000.00000.00000.00000.00000.00000.00000.0000公差：

6pp变差PV1.104596PV1.1045961.104596PV1.104596TV0.000000TV0.000000#DIV/0!

TV1.146135基于公差baseonpartsspec%EV#DIV/0!

#DIV/0!

#DIV/0!

17.61%基于零件变差baseonpartsvariation%AV#DIV/0!

#DIV/0!

#DIV/0!

20.04%基于过程变差baseonprocessvariation%RR#DIV/0!

#DIV/0!

#DIV/0!

26.68%基于过程能力BaseonprocessPP%PV#DIV/0!

#DIV/0!

#DIV/0!

96.38%公式AFormulaAndc5.093692473公式BFormulaBX2/nkr0.0001878sumSQ（sum（men）/nr3.1674500SUMSQ（sum（1-10part）/kr88.3621222极差图RangechartSUMSQ（sum（men-part）/r91.8883667sumSQ（all）94.6473000n=partk=menr=timeANOVATableWithOperator*PartInteractionANOVATableWithoutOperator*PartInteractionSourceDFSSMSFPSourceDFSSMSFPParts988.361939.81799492.291420.00000Parts988.361939.81799245.613910.00000Operators23.167261.5836379.406050.00000Operators23.167261.5836339.617250.00000Operators*Part180.358980.019940.433720.97411Repeatability602.758930.04598Repeatability783.117920.03997Total8994.64711Total8994.64711GaugeR&RWithOperator*PartInteractionGaugeR&RWithoutOperator*PartInteractionSourceVarCompStdev%Contribution%TV%ToleranceSourceVarCompStdev%Contribution%TV%ToleranceTotalGaugeR&R0.098110.313228.27%28.75%#DIV/0!

TotalGaugeR&R0.091430.302377.76%27.86%#DIV/0!

Repeatability0.045980.214433.87%19.68%#DIV/0!

Repeatability0.039970.199933.39%18.42%#DIV/0!

Reproducibility0.052120.228304.39%20.96%#DIV/0!

Reproducibility0.051460.226844.37%20.90%#DIV/0!

Operator0.052120.228304.39%20.96%#DIV/0!

Operator0.051460.226844.37%20.90%#DIV/0!

Operators*Part0.000000.000000.00%0.00%#DIV/0!

Part-To-Part1.088671.0433991.73%95.78%#DIV/0!

Part-To-Part1.086451.0423392.24%96.04%#DIV/0!

AXARBXBRCX佃RPPXXnXxXRLX2RAXLX2RDL屒4吳-2.50000-2.00000-1.50000-1.00000-0.500000.000000.500001.000001.500002.000002.50000AUCLxLCLxBC0.00000.20000.40000.60000.80001.00001.2000CUCLRLCLRBARegularNewQCPPPAPOtherAppraisersRcRRbA/）（RPage：

1/4TotalVariation1.186781.08939100.00%100.00%#DIV/0!

TotalVariation1.177881.08530100.00%100.00%#DIV/0!

测测量量系系统统分分析析MSAGR&R-均均值值极极差差法法AverageAverageandandmethodmethod报报告告编编号号ReportReportNO.NO.量具名称Equipment产品类型Description测量人员Operator测试日期TestTate1900/1/0量具编号EquipmentNO.基件编号PartNO.测量人员Operator平价人数Appraisers3参数规格Specification规格上限Upperlimit测量人员Operator试验次数Trials3测量单位UnitMM规格下限LowerLimit过程变差/过程能力ProcessVariation（/PP）样品数Samples10Datasheet：

0.3416670.4446673.511111分析方式Analysismode基基于于零零件件变变差差basebaseononpartspartsvariationvariation测量系统分析MSA%总变差Totalvariation（TV）重复性Repeatability设备变差EquipmentVariation（EV）=17.61%=0.201857试验次数TrialsK120.886230.5908再现性Reproducibility評价人变差AppraiserVariation（AV）=20.04%=0.229667评价人数AppraisersK220.707130.5231重复性和再现性RepeatabilityandReproducibility（R&R）零件数量PartQTYK3=26.68%=0.30576630.523140.446750.4043零件变差PartsVariation（PV）60.3742公式AFormulaA70.3534=96.38%=1.10459680.337590.3249100.3146总变差TotalVariation（TV）有效分辨率AvailabilityResolution（NDC）=1.41*（PV/R&R）基于零件变差Baseonpartsvariation=5=1.1