事业一部品质部88399363.xlsS1GR&R分析表VariableGaugeR&RSpreadsheet10备注NOTE:不能缺失数据FILLWHITECELLSONLY4操作者Operator1操作者Operator2零件试验试验试验试验试验试验Trial试验试验试验Part#Trial1Trial2Trial3Trial1Trial23Trial1Trial2Trial312345678910#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!操作者与零件交互作用方差分析没有交互作用方差分析记录日期DateMSA序号ANOVATableWithOperator*PartInteractionANOVATableWithoutOperator*PartInteraction操作者Operator序号姓名序号姓名差异源Source自由度DF平方和SS均方和MSF比P值差异源Source自由度DF平方和SS均方和MSF比P值1零件Parts90.00E+000.00E+00#DIV/0!#DIV/0!零件Parts90.00E+000.00E+00#DIV/0!#DIV/0!2操作者Operators10.00E+000.00E+00#DIV/0!#DIV/0!操作者Operators10.00E+000.00E+00#DIV/0!#DIV/0!交互Operator*Part90.00E+000.00E+00#DIV/0!#DIV/0!量具名称Measures重复性Repeatability400.00E+000.00E+00重复性Repeatability490.00E+000.00E+00量具精度合计Total590.00E+00合计Total590.00E+00量具规格Specification量具编号ToolNo.操作者与零件交互作用GR&R分析没有交互作用GR&R分析温度TemperatureGaugeR&RWithOperator*PartInteractionGaugeR&RWithoutOperator*PartInteraction湿度Humidity差异源方差标准偏差贡献%差异源方差标准偏差贡献%公差%公差%车间WorkshopSourceVarCompStdevContributionToleranceSourceVarCompStdevContributionToleranceTotalGaugeR&R0.00E+000.00E+00#DIV/0!NoSpec.TotalGaugeR&R0.00E+000.00E+00#DIV/0!NoSpec.工序名称Processdescription重复性Repeatability0.00E+000.00E+00#DIV/0!Limits重复性Repeatability0.00E+000.00E+00#DIV/0!Limits产品名称Production再现性Reproducibility0.00E+000.00E+00#DIV/0!Available再现性Reproducibility0.00E+000.00E+00#DIV/0!Available测试特性Speciality操作者Operator0.00E+000.00E+00#DIV/0!操作者Operator0.00E+000.00E+00#DIV/0!尺寸单位Sizeunit交互Operator*Part0.00E+000.00E+00#DIV/0!#DIV/0!规格上限UpperSpec.Limit零件Part-To-Part0.00E+000.00E+00#DIV/0!零件Part-To-Part0.00E+000.00E+00#DIV/0!规格下限LowerSpec.Limit总变差TotalVariation0.00E+000.00E+00#DIV/0!总变差TotalVariation0.00E+000.00E+00#DIV/0!特殊特性组织者Organize审核Assessor备注NotesGaugeR&RismadeforProcessCapabilityStudy测量小数位数DecimalDigits(0to36)操作人数NumberofOperators(2to26)测试零件数量NumberofParts(10to20)10试验次数NumberofTrials(23to3)