测量系统分析MSAGR&R---数据记录表DataWorksheet报告编号ReportNO.量具名称产品类型测量人员测试日期EquipmentNameDescriptionOperatorＡTestTate量具编号基件编号测量人员平价人数3EquipmentNO.P/NOperatorＢAppraisers参数规格规格上限测量人员试验次数3DimensionUSLOperatorＣTrials单位规格下限过程变差/过程能力样品数MM10UnitLSLProcessVariation(σ/PP)Samples分析时机AnalyticalOccasionRegularNewQCPPPAPOther零件编号PartsNO.12345678910Total平均值Average1.A1#DIV/0!2.2#DIV/0!3.30#DIV/0!4.均值Mean#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!X=#DIV/0!ASumA00000000000.00005.极差Range0000000000R=0.000000A6.B1#DIV/0!7.2#DIV/0!8.3#DIV/0!9.均值Mean#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!X=#DIV/0!BSumB00000000000.000010.极差Range0000000000R=0.000000B11.C10#DIV/0!12.20#DIV/0!13.30#DIV/0!14.均值Mean#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/AX=#N/ACSumC0000000000015.极差Range#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/AR=#N/AC零件均值X#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!X=#DIV/0!PartsMeanPTotal0.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000R=#DIV/0!P#N/A试验次数Trials23R=(R+R+Rc)/Appraisers=AbX=MaxX-MinX=#DIV/0!D43.272.575DIFFUCL=X+AR=#DIV/0!UCL=DR=#N/AD300X2R4LCL=X-AR=#DIV/0!LCL=DR=#N/AA21.881.023X2R3注:当分析结果超出要求后，利用均值极差图分析原因Whenanalysisresultisoutofspec,needanalysetherootcausebymeanandrange。chart123456789101.00000UCLx#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!LCLx#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A0.80000UCLLCLR#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A均值图RAmean0.60000公差：6σpp变差chartPV#DIV/0!PV#DIV/0!#DIV/0!PV#DIV/0!UCLx0.0000000.000000#N/A0.40000TVTV#DIV/0!TV基于公差baseonLCLxpartsspec%EV#N/A#N/A#N/A#N/A%AV#DIV/0!#DIV/0!#DIV/0!#DIV/0!基于零件变差baseonBpartsvariation%RR#N/A#N/A#N/A基于过程变差baseonprocessvariation0.20000#N/A基于过程能力BaseonprocessPP%PV#DIV/0!#DIV/0!#DIV/0!#DIV/0!Cndc#DIV/0!#N/A公式AFormulaA0.00000X^2/nkr0.0000000sumS