APQP-PAP-MSA测量系统分析自动表格-GRR-可编辑版本

372371.41012345678910Total1.A1#####################71.70371.682#####################71.70371.682717.00182.2#####################71.698971.6821#####################71.698971.6821716.9913.3#####################71.702971.6834#####################71.702971.6834716.99584.均值Mean71.7240371.6859071.7040771.7016071.6825071.7240371.6859071.7040771.7016071.6825071.699620SumA215.1721215.0577215.1122215.1048215.0475215.1721215.0577215.1122215.1048215.04752150.98865.极差Range0.00170.00060.00290.00410.00140.00170.00060.00290.00410.00140.0021406.B171.723371.689171.704671.703371.68371.723371.689171.704671.703371.683717.00667.271.725671.688571.704371.7034#######71.725671.688571.704371.7034#######11.3048.3#######71.691771.704671.703971.6829#######71.691771.704671.703971.6829717.01649.均值Mean71.7246771.6897771.7045071.7035371.6834771.7246771.6897771.7045071.7035371.6834771.701187SumB215.174215.0693215.1135215.1106215.0504215.174215.0693215.1135215.1106215.05042151.035610.极差Range0.00320.00030.00060.00160.00230.00320.00030.00060.00160.00152211.C1#######71.690171.701871.704471.6824#######71.690171.701871.704471.6824717.008812.2#######71.689671.701971.704571.6834#######71.689671.701971.704571.6834717.006213.371.724771.690471.702571.70471.684271.724771.690471.702571.70471.6842717.011614.均值Mean71.7247071.6900371.7020771.7043071.6833371.7247071.6900371.7020771.7043071.6833371.700887SumC215.1741215.0701215.1062215.1129215.05215.1741215.0701215.1062215.1129215.052151.026615.极差Range0.00200.00080.00070.00050.00180.00200.00080.00070.00050.00180.00116071.72446771.68856771.70354471.70314471.68310071.72446771.68856771.70354471.70314471.68310071.700564645.520200645.197100645.331900645.328300645.147900645.520200645.197100645.331900645.328300645.1479006453.05080.0413670.00160723D43.272.57571.7022090.004139D30071.6989200.000000A21.881.02312345678910UCLx71.702271.702271.702271.702271.702271.702271.702271.702271.702271.7022LCLx71.698971.698971.698971.698971.698971.698971.698971.698971.698971.6989UCLR0.00410.00410.00410.00410.00410.00410.00410.00410.00410.0041LCLR0.00000.00000.00000.00000.00000.00000.00000.00000.00000.0000公差：6σpp变差PVPV0.013014PVTVTV#DIV/0!TV基于公差baseonpartsspec%EV#DIV/0!基于零件变差baseonpartsvariation%AV#DIV/0!基于过程变差baseonprocessvariation%RR#DIV/0!基于过程能力BaseonprocessPP%PV#DIV/0!公式AFormulaAndc14.77027381公式BFormulaBX^2/nkr462687.3847487462687.3847902462687.4033932462687.4035058462687.4035732SourceDFSSMSFPSourceDFSSMSFPParts90.018640.00207524.016570.0000090.018640.002071166.180210.0000020.000040.000025.247340.0160220.000040.0000211.677760.00003180.000070.000003.519300.00013600.000070.00000780.000140.00000Total890.01882890.01882SourceVarCompStdev%Contribution%TV%ToleranceSourceVarCompStdev%Contribution%TV%Tolerance0.000000.001621.13%10.63%1.62%0.000000.001551.04%10.18%1.55%0.000000.001060.48%6.95%1.06%0.000000.001330.76%8.74%1.33%0.000000.001230.65%8.04%1.23%0.000000.000800.27%5.22%0.80%0.000000.000750.24%4.91%0.75%0.000000.000800.27%5.22%0.80%0.000000.000970.41%6.37%0.97%0.000230.0151698.87%99.43%15.16%0.000230.0151798.96%99.48%15.17%测试日期TestTate量具编号EquipmentNO.基件编号P/N测量人员OperatorＢB平价人数Appraisers测量系统分析MSAGR&R---数据记录表DataWorksheet报告编号ReportNO.量具名称EquipmentName产品类型Description测量人员OperatorＡA试验次数Trials单位UnitMM规格下限LSL过程变差/过程能力ProcessVariation(σ/PP)样品数Samples参数规格Dimension规格上限USL测量人员OperatorＣC71.69958071.70066071.70126071.70164071.70088071.700620分析时机AnalyticalOccasion零件编号PartsNO.平均值Average71.70018071.699100sumSQ(sum(men))/nrSUMSQ(sum(1-10part))/kr71.701160零件均值PartsMeanTotal试验次数Trials0.001567Part-To-PartPart-To-Part注:当分析结果超出要求后，利用均值极差图分析原因Whenanalysisresultisoutofspec,needanalysetherootcausebymeanandrangechart。均值图meanchart0.0130140.0130140.0130140.1000000.0000000.0130731.24%#DIV/0!9.50%#DIV/0!6.13%13.01%#DIV/0!99.55%0.95%#DIV/0!7.26%0.80%TotalGaugeR&RTotalGaugeR&RRepeatabilityRepeatabilityOperatorsOperators*PartRepeatabilityRepeatabilityTotalSUMSQ(sum(men-part))/rsumSQ(all)n=partk=menr=timeANOVATableWithOperator*PartInteractionANOVATableWithoutOperator*PartInteractionPartsReproducibilityReproducibilityOperatorOperatorOperators*Part极差图RangechartOperatorsGaugeR&RWithOperator*PartInteractionGaugeR&RWithoutOperator*PartInteraction=AX=AR=BX=BR=CX=CR=X=PRPX=-=XMinXMaxXDIFF=+=RAXUCLX2=-=RAXLCLX2==RDUCLR4==RDLCLR371.6600071.6700071.6800071.6900071.7000071.7100071.7200071.73000AUCLxLCLxBC0.00000.00100.00200.00300.00400.0050CUCLRLCLRBARegularNewQCPPPAPOther=++=AppraisersRcRRbA/)(RPage：1/40.000230.01524100.00%100.00%15.24%0.000230.01524100.00%100.00%15.24%测试日期Test1900/1/0平价人数Appr372试验次数Trials371.4样品数100.0016070.0015670.041367分析方式Analysismode重复性Repeatability－设备变差EquipmentVariation(EV)==试验次数TrialsK120.886230.5908再现性Reproducibility－評价人变差AppraiserVariation(AV)==评价人数AppraiserK220.707130.5231重复性和再现性RepeatabilityandReproducibility(R&R)零件数量PartQTYK3==30.523140.446750.4043零件变差PartsVariation(PV)60.374270.3534==80.337590.3249100.3146总变差TotalVariation(TV)==判定标准DecideCriterionTotalVariationTotalVariation测量系统分析MSAGR&R---均值极差法Averageandmethod量具编号EquipmentNO.基件编号PartNO.测量人员Opera