GRR表格MSA第四版(手册例)

331012345678910Total1.A10.29-0.561.340.47-0.80.020.59-0.312.26-1.361.942.20.41-0.681.170.5-0.92-0.110.75-0.21.99-1.251.663.30.64-0.581.270.64-0.84-0.210.66-0.172.01-1.312.114.均值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.41-0.561.340.47-0.80.020.59-0.312.01-1.361.817.20.41-0.681.170.5-0.92-0.110.75-0.21.99-1.2511.3048.30.64-0.581.270.64-0.84-0.210.66-0.172.01-1.312.119.均值Mean0.48667-0.606671.260000.53667-0.85333-0.100000.66667-0.226672.00333-1.306670.186000SumB1.46-1.823.781.61-2.56-0.32-0.686.01-3.925.580010.极差Range0.230.120.170.170.120.230.160.140.020.110.14700011.C10.29-0.561.340.47-0.80.020.59-0.312.26-1.361.9412.20.41-0.681.170.5-0.92-0.110.75-0.21.99-1.251.6613.30.64-0.581.270.64-0.84-0.210.66-0.172.01-1.312.1114.均值Mean0.44667-0.606671.260000.53667-0.85333-0.100000.66667-0.226672.08667-1.306670.190333SumC1.34-1.823.781.61-2.56-0.32-0.686.26-3.925.7115.极差Range0.35000.12000.17000.17000.12000.23000.16000.14000.27000.11000.1840000.460000-0.6066671.2600000.536667-0.853333-0.1000000.666667-0.2266672.058889-1.3066670.1888894.140000-5.46000011.3400004.830000-7.680000-0.9000006.000000-2.04000018.530000-11.760000173.3655560.17166723D43.272.5750.3645040.442042D3000.0132740.000000A21.881.02312345678910UCLx0.36450.36450.36450.36450.36450.36450.36450.36450.36450.3645LCLx0.01330.01330.01330.01330.01330.01330.01330.01330.01330.0133UCLR0.44200.44200.44200.44200.44200.44200.44200.44200.44200.4420LCLR0.00000.00000.00000.00000.00000.00000.00000.00000.00000.0000公差：6σpp变差PVPV1.058804PVTVTV#DIV/0!TV基于公差baseonpartsspec%EV#DIV/0!基于零件变差baseonpartsvariation%AV#DIV/0!基于过程变差baseonprocessvariation%RR#DIV/0!基于过程能力BaseonprocessPP%PV#DIV/0!公式AFormulaAndc14.72001098公式BFormulaBX^2/nkr3.21111113.211486786.720911186.738000087.3002000SourceDFSSMSFPSourceDFSSMSFPParts983.509809.278879993.195050.00000983.509809.278871250.189900.0000020.000380.000190.202230.8187320.000380.000190.025300.97502180.016710.000930.099091.00000600.562200.00937780.578910.00742Total8984.089098984.08909SourceVarCompStdev%Contribution%TV%ToleranceSourceVarCompStdev%Contribution%TV%Tolerance0.009370.096800.90%9.49%#DIV/0!0.007420.08615#N/A#N/A#N/A0.009370.096800.90%9.49%#DIV/0!0.007420.08615#N/A#N/A#N/A0.000000.000000.00%0.00%#DIV/0!0.000000.00000#N/A#N/A#N/A0.000000.000000.00%0.00%#DIV/0!0.000000.00000#N/A#N/A#N/A0.000000.000000.00%0.00%#DIV/0!1.030881.0153299.10%99.55%#DIV/0!1.030161.0149799.28%99.64%#DIV/0!1.040251.01993100.00%100.00%#DIV/0!1.037581.01862100.00%100.00%#DIV/0!产品类型Description测量系统分析MSAGR&R---数据记录表DataWorksheet报告编号ReportNO.测量人员OperatorＡ测试日期TestTate试验次数Trials测量人员OperatorＢ平价人数Appraisers量具名称EquipmentName量具编号EquipmentNO.基件编号P/N参数规格Dimension规格上限USL测量人员OperatorＣ样品数Samples分析时机AnalyticalOccasion单位UnitMM规格下限LSL过程变差/过程能力ProcessVariation(σ/PP)0.004333零件编号PartsNO.平均值Average0.1940000.1660000.2110000.1810000.1660000.2110000.1940000.1660000.211000零件均值PartsMeanTotal试验次数Trials注:当分析结果超出要求后，利用均值极差图分析原因Whenanalysisresultisoutofspec,needanalysetherootcausebymeanandrangechart。1.0588041.0588041.058804均值图meanchart0.0000000.0000001.063650#DIV/0!#DIV/0!9.54%#DIV/0!#DIV/0!0.00%#DIV/0!#DIV/0!9.54%SUMSQ(sum(men-part))/rsumSQ(all)n=partk=menr=timeTotalGaugeR&RWithOperator*PartInteractionGaugeR&RWithoutOperator*PartInteractionANOVATableWithOperator*PartInteractionANOVATableWithoutOperator*PartInteraction#DIV/0!#DIV/0!99.54%sumSQ(sum(men))/nrSUMSQ(sum(1-10part))/krPartsOperatorsOperatorsOperators*PartRepeatabilityRepeatabilityReproducibilityReproducibilityOperatorOperatorTotalGaugeR&RTotalGaugeR&RRepeatabilityRepeatabilityTotalVariationTotalVariation极差图RangechartOperators*PartPart-To-PartPart-To-Part=AX=AR=BX=BR=CX=CR=X=PRPX=-=XMinXMaxXDIFF=+=RAXUCLX2=-=RAXLCLX2==RDUCLR4==RDLCLR3-2.00000-1.000000.000001.000002.000003.00000AUCLxLCLxBC0.00000.10000.20000.30000.40000.5000CUCLRLCLRBARegularNewQCPPPAPOther=++=AppraisersRcRRbA/)(RPage：1/4测试日期Test1900/1/0平价人数Appr3试验次数Trials3样品数100.1716670.0043333.365556分析方式Analysismode重复性Repeatability－设备变差EquipmentVariation(EV)==试验次数TrialsK120.8862设备30.5908再现性Reproducibility－評价人变差AppraiserVariation(AV)==评价人数AppraiseK2人20.707130.5231重复性和再现性RepeatabilityandReproducibility(R&R)零件数量PartK3==30.523140.446750.4043零件变差PartsVariation(PV)60.374270.3534==80.337590.3249100.3146总变差TotalVariation(TV)==判定标准DecideCriterion分析人Analyst日期Date测量系统分析MSAGR&R---均值极差法Averageandmethod参数规格Specification报告编号ReportNO.量具名称Equipment产品类型Description测量人员OperatorＡ量具编号EquipmentNO.基件编号PartNO.测量人员OperatorＢ规格上限Upperlimit测量系统分析MSA%总变差Totalvariation（TV）测量单位UnitMM规格下限LowerLimit测量人员OperatorＣ公式AFormulaA99.54%9.54%0.101421过程变差/过程能力ProcessVariation(σ/PP)Datasheet：基于零件变差baseonpartsvariation0.00%0.0000009.54%0.101421基于零件公差Baseonpartsspec1.058804有效分辨率AvailabilityResolution(NDC)=1.41*（PV/R&R）基于零件变差Baseonpartsvariation151.063650基于过程变差Baseonprocessvariation基于过程能力BaseonprocessPP1)   0%%R&R10%：量测系统状况良好Excellent；10%≤%R&R≤30%：量测系统状况可以接收，但需改进Acceptedbutneedimp