GRR表格MSA第四版

30.1530.161012345678910Total1.A10.1570.1570.1560.1570.1570.1560.1570.1560.1570.1561.5662.20.1550.1550.1560.1540.1550.1550.1550.1560.1540.1551.553.30.1530.1530.1540.1530.1530.1540.1530.1530.1530.1541.5334.均值Mean0.155000.155000.155330.154670.155000.155000.155000.155000.154670.155000.154967SumA0.4650.4650.4660.4640.4650.4650.4650.4650.4640.4654.64905.极差Range0.0040.0040.0020.0040.0040.0020.0040.0030.0040.0020.0033006.B10.1560.1560.1560.1570.1570.1560.1570.1560.1570.1571.5657.20.1540.1540.1550.1550.1540.1550.1550.1540.1550.15511.3048.30.1540.1540.1540.1540.1530.1540.1530.1530.1540.1541.5379.均值Mean0.154670.154670.155000.155330.154670.155000.155000.154330.155330.155330.154933SumB0.4640.4640.4650.4660.4640.4650.4650.4630.4660.4664.648010.极差Range0.0020.0020.0020.0030.0040.0020.0040.0030.0030.0030.00280011.C10.1560.1560.1560.1570.1570.1560.1570.1570.1570.1561.56512.20.1550.1550.1550.1540.1540.1550.1550.1550.1540.1551.54713.30.1540.1540.1530.1530.1530.1540.1540.1530.1530.1541.53514.均值Mean0.155000.155000.154670.154670.154670.155000.155330.155000.154670.155000.154900SumC0.4650.4650.4640.4640.4640.4650.4660.4650.4640.4654.64715.极差Range0.00200.00200.00300.00400.00400.00200.00300.00400.00400.00200.0030000.1548890.1548890.1550000.1548890.1547780.1550000.1551110.1547780.1548890.1551110.1549331.3940001.3940001.3950001.3940001.3930001.3950001.3960001.3930001.3940001.39600013.9440.0003330.00303323D43.272.5750.1580360.007811D3000.1518300.000000A21.881.02312345678910UCLx0.15800.15800.15800.15800.15800.15800.15800.15800.15800.1580LCLx0.15180.15180.15180.15180.15180.15180.15180.15180.15180.1518UCLR0.00780.00780.00780.00780.00780.00780.00780.00780.00780.0078LCLR0.00000.00000.00000.00000.00000.00000.00000.00000.00000.0000公差：6σpp变差PVPV0.000105PVTVTV#VALUE!TV基于公差baseonpartsspec%EV#VALUE!基于零件变差baseonpartsvariation%AV#VALUE!基于过程变差baseonprocessvariation%RR#VALUE!基于过程能力BaseonprocessPP%PV#VALUE!公式AFormulaAndc0.082507979公式BFormulaBX^2/nkr2.16039042.16039052.16039162.16039602.1605540SourceDFSSMSFPSourceDFSSMSFPParts90.000000.000000.527920.8356090.000000.000000.061680.9999420.000000.000000.137060.8728220.000000.000000.016010.98412180.000000.000000.092361.00000600.000160.00000780.000160.00000Total890.00016890.00016SourceVarCompStdev%Contribution%TV%ToleranceSourceVarCompStdev%Contribution%TV%Tolerance0.000000.00162100.00%100.00%-97.37%0.000000.00144100.00%100.00%-86.57%0.000000.00162100.00%100.00%-97.37%0.000000.00144100.00%100.00%-86.57%0.000000.000000.00%0.00%0.00%0.000000.000000.00%0.00%0.00%0.000000.000000.00%0.00%0.00%0.000000.000000.00%0.00%0.00%0.000000.000000.00%0.00%0.00%0.000000.000000.00%0.00%0.00%0.000000.000000.00%0.00%0.00%测试日期TestTate量具编号EquipmentNO.基件编号P/N测量人员OperatorＢb平价人数Appraisers测量系统分析MSAGR&R---数据记录表DataWorksheet报告编号ReportNO.量具名称EquipmentName产品类型Description测量人员OperatorＡa试验次数Trials单位UnitMM规格下限LSL过程变差/过程能力ProcessVariation(σ/PP)过程能力PP样品数Samples参数规格Dimension0.15规格上限USL测量人员OperatorＣc0.1533000.1565000.1546000.1537000.1565000.154700分析时机AnalyticalOccasion零件编号PartsNO.平均值Average0.1566000.155000#VALUE!0.00%sumSQ(sum(men))/nrSUMSQ(sum(1-10part))/kr0.153500零件均值PartsMeanTotal试验次数Trials0.000067Part-To-PartPart-To-Part注:当分析结果超出要求后，利用均值极差图分析原因Whenanalysisresultisoutofspec,needanalysetherootcausebymeanandrangechart。均值图meanchart0.0001050.0001050.000105(0.001667)过程能力PP0.001795-107.53%#VALUE!99.83%-6.29%#VALUE!5.84%-107.53%#VALUE!99.83%0.00%TotalGaugeR&RTotalGaugeR&RRepeatabilityRepeatabilityOperatorsOperators*PartRepeatabilityRepeatabilityTotalSUMSQ(sum(men-part))/rsumSQ(all)n=partk=menr=timeANOVATableWithOperator*PartInteractionANOVATableWithoutOperator*PartInteractionPartsOperatorsGaugeR&RWithOperator*PartInteractionGaugeR&RWithoutOperator*PartInteractionReproducibilityReproducibilityOperatorOperatorOperators*Part极差图Rangechart=AX=AR=BX=BR=CX=CR=X=PRPX=-=XMinXMaxXDIFF=+=RAXUCLX2=-=RAXLCLX2==RDUCLR4==RDLCLR30.148000.150000.152000.154000.156000.158000.16000AUCLxLCLxBC0.00000.00200.00400.00600.00800.0100CUCLRLCLRBARegularNewQCPPPAPOther=++=AppraisersRcRRbA/)(RPage：1/40.000000.00162100.00%100.00%-97.37%0.000000.00144100.00%100.00%-86.57%测试日期Test1900/1/0平价人数Appr30.15试验次数Trials30.16样品数100.0030330.0000670.000333分析方式Analysismode重复性Repeatability－设备变差EquipmentVariation(EV)==试验次数TrialsK120.886230.5908再现性Reproducibility－評价人变差AppraiserVariation(AV)==评价人数AppraiseK220.707130.5231重复性和再现性RepeatabilityandReproducibility(R&R)零件数量PartK3==30.523140.446750.4043零件变差PartsVariation(PV)60.374270.3534==80.337590.3249100.3146总变差TotalVariation(TV)==判定标准DecideCriterionTotalVariationTotalVariation测量系统分析MSAGR&R---均值极差法Averageandmethod量具编号EquipmentNO.基件编号PartNO.测量人员OperatorＢb报告编号ReportNO.量具名称Equipment产品类型Description测量人员OperatorＡa极差图Rangechart测量单位UnitMM规格下限LowerLimit过程变差/过程能力ProcessVariation(σ/PP)过程能力PP参数规格Specification0.15规格上限Upperlimit测量人员OperatorＣc0.00%0.000000-107.53%0.001792Datasheet：基于公差baseonpartsspec测量系统分析MSA%总变差Totalvariation（TV）-107.53%0.001792基于零件变差Baseonpartsvariation0(0.001667)基于过程变差Baseonprocessvariation基于零件公差Baseonpartsspec公式AFormulaA-6.29%0.000105有效分辨率Availabil