搜索
31.5731.441012345678910Total1.A11.441.491.441.461.501.581.521.561.531.5015.022.21.431.481.451.471.511.571.531.551.521.5015.013.31.441.481.451.471.501.571.521.561.531.5015.024.均值Mean1.436671.483331.446671.466671.503331.573331.523331.556671.526671.500001.501667SumA4.314.454.344.44.514.724.574.674.584.545.05005.极差Range0.010.010.010.010.010.010.010.010.0100.0090006.B11.431.481.451.471.511.571.531.551.531.5015.027.21.441.491.441.471.501.571.521.561.531.5111.3048.31.441.481.451.471.501.571.521.561.531.5015.029.均值Mean1.436671.483331.446671.470001.503331.570001.523331.556671.530001.503331.502333SumB4.314.454.344.414.514.714.574.674.594.5145.070010.极差Range0.010.010.0100.0100.010.0100.010.00700011.C11.441.491.451.471.501.571.521.561.531.5015.0312.21.441.481.441.471.501.571.521.561.531.5015.0113.31.431.481.451.461.501.571.531.561.531.5015.0114.均值Mean1.436671.483331.446671.466671.500001.570001.523331.560001.530001.500001.501667SumC4.314.454.344.44.54.714.574.684.594.545.0515.极差Range0.01000.01000.01000.01000.00000.00000.01000.00000.00000.00000.0050001.4366671.4833331.4466671.4677781.5022221.5711111.5233331.5577781.5288891.5011111.50188912.93000013.35000013.02000013.21000013.52000014.14000013.71000014.02000013.76000013.510000135.170.1344440.00700023D43.272.5751.5090500.018025D3001.4947280.000000A21.881.02312345678910UCLx1.50901.50901.50901.50901.50901.50901.50901.50901.50901.5090LCLx1.49471.49471.49471.49471.49471.49471.49471.49471.49471.4947UCLR0.01800.01800.01800.01800.01800.01800.01800.01800.01800.0180LCLR0.00000.00000.00000.00000.00000.00000.00000.00000.00000.0000公差：6σpp变差PVPV0.042296PVTVTV#DIV/0!TV基于公差baseonpartsspec%EV#DIV/0!基于零件变差baseonpartsvariation%AV#DIV/0!基于过程变差baseonprocessvariation%RR#DIV/0!基于过程能力BaseonprocessPP%PV#DIV/0!公式AFormulaAndc14.42056131公式BFormulaBX^2/nkr203.0103211203.0103300203.1715667203.1717000203.1731000SourceDFSSMSFPSourceDFSSMSFPParts90.161250.017922591.446430.0000090.161250.01792916.702140.0000020.000010.000000.642860.5374420.000010.000000.227410.79706180.000120.000010.296300.99705600.001400.00002780.001520.00002Total890.16278890.16278SourceVarCompStdev%Contribution%TV%ToleranceSourceVarCompStdev%Contribution%TV%Tolerance0.000020.004831.16%10.77%22.29%0.000020.004420.97%9.87%20.40%0.000020.004831.16%10.77%22.29%0.000020.004420.97%9.87%20.40%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.001990.0446198.84%99.42%205.89%0.001990.0445999.03%99.51%205.81%测试日期TestTate量具编号EquipmentNO.基件编号P/N测量人员OperatorＢ平价人数Appraisers测量系统分析MSAGR&R---数据记录表DataWorksheet报告编号ReportNO.量具名称EquipmentName产品类型Description测量人员OperatorＡ试验次数Trials单位UnitMM规格下限LSL过程变差/过程能力ProcessVariation(σ/PP)样品数Samples参数规格Dimension规格上限USL测量人员OperatorＣ1.5020001.5020001.5030001.5020001.5030001.501000分析时机AnalyticalOccasion零件编号PartsNO.平均值Average1.5020001.501000#DIV/0!0.00%sumSQ(sum(men))/nrSUMSQ(sum(1-10part))/kr1.501000零件均值PartsMeanTotal试验次数Trials0.000667Part-To-PartPart-To-Part注:当分析结果超出要求后，利用均值极差图分析原因Whenanalysisresultisoutofspec,needanalysetherootcausebymeanandrangechart。均值图meanchart0.0422960.0422960.0422960.0216670.0000000.04249819.09%#DIV/0!9.73%195.21%#DIV/0!99.53%19.09%#DIV/0!9.73%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==RDLCLR31.350001.400001.450001.500001.550001.60000AUCLxLCLxBC0.00000.00500.01000.01500.0200CUCLRLCLRBARegularNewQCPPPAPOther=++=AppraisersRcRRbA/)(RPage：1/40.002010.04487100.00%100.00%207.09%0.002010.04481100.00%100.00%206.82%测试日期Test1900/1/0平价人数Appr31.57试验次数Trials31.44样品数100.0070000.0006670.134444分析方式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Ｂ报告编号ReportNO.量具名称Equipment产品类型Description测量人员OperatorＡ极差图Rangechart测量单位UnitMM规格下限LowerLimit过程变差/过程能力ProcessVariation(σ/PP)参数规格Specification规格上限Upperlimit测量人员OperatorＣ0.00%0.0000009.73%0.004136Datasheet：基于零件变差baseonpartsvariation测量系统分析MSA%总变差Totalvariation（TV）9.73%0.004136基于零件变差Baseonpartsvariation140.042498基于过程变差Baseonprocessvariation基于零件公差Baseonpartsspec公式AFormulaA99.53%0.042296有效分辨率AvailabilityResolution(NDC)=1.41*（PV/R&R）分析评价措施Analysisandaction基于过程能力BaseonprocessPP1) 0%%R&R10%：量测系统状况良好Excellent；判定Decide良好Excellent10%≤%R&R≤30%：量测系统状况可以接收，但需改进Acceptedbutneedimproveme