MSA自动计算表格

A中国XXXBC123456789101119.06019.10019.09019.09019.07019.08019.09019.09019.06019.07019.0802219.06019.10019.09019.08019.07019.08019.08019.09019.06019.07019.0783319.06019.10019.09019.08019.07019.08019.08019.09019.06019.07019.078419.06019.10019.09019.08319.07019.08019.08319.09019.06019.070Xa=19.07950.0000.0000.0000.0100.0000.0000.0100.0000.0000.000Ra=0.0026119.07019.09019.10019.06019.08019.08019.09019.07019.08019.08019.0807219.07019.09019.10019.06019.08019.08019.08019.07019.08019.08019.0798319.08019.09019.10019.06019.08019.08019.08019.07019.08019.08019.080919.07319.09019.10019.06019.08019.08019.08319.07019.08019.080Xb=19.080100.0100.0000.0000.0000.0000.0000.0100.0000.0000.000Rb=0.00211119.09019.07019.09019.07019.08019.08019.08019.09019.06019.08019.07912219.09019.07019.09019.07019.08019.08019.07019.09019.06019.08019.07813319.09019.06019.09019.07019.08019.08019.07019.09019.06019.08019.0771419.09019.06719.09019.07019.08019.08019.07319.09019.06019.080Xc=19.078150.0000.0100.0000.0000.0000.0000.0100.0000.0000.000Rc=0.00216Xp=19.07917Rp=0.02718R=0.00219XDIFF=0.00220UCLR=0.00521LCLR=0.00022LCLR=［RXD3］※当试验次数whenthetesttimeisn=2时，D4=3.27；n=3时,D4=2.58；7次以下试验Under7timesexperimentD3=0；UCLR代表单值R的极限，圈出那些超出极限的试验，识别其原因并纠正。用与原来相同的评价人和量具重复这些读数或剔除超限值后，用剩下的观测值来重新计算均值和极差及控制限值。UCLRonbehalfofthelimitsofasinglevalueofR,circlebeyondthelimitsofthosetests,toidentifyandcorrectthecauses.Thesamewiththeoriginalevaluationandmeasuringrepeatthesereadingsortransfinitevalueremoved,therestoftheobservationsusedtorecalculatethemeanandcontrollimitsandtheDistance.评价人Evaluation:A/日期Date：评价人Evaluation:B/日期Date：评价人EvaluationC/日期Date：19.077R=［Ra+Rb+Rc］/［评价人数Evaluationofthenumberofpeople=3］XDIFF=［Xmax-Xmin］UCLR=［RXD4］19.08019.08019.08319.06719.08619.093C19.07119.077平均值Average极差零件均值PartsAverage(Xp)19.074A平均值Average极差B平均值Average极差被测特性CharacteristicofMeasured：量具号MeasureNumber：08142521操作者Operator特性规格CharacteristicSpectification：19+0.1/0量具型式MeasureType序号No.评价人/试验次数Evaluationofperson/trialdegree零件spareparts平均值Average测量系统能力研究GR&RstudyforcriticalmeasurementtoolsA.量具重复性和再现性X--R分析数据表GaugeRepeatabilityandReproducibilityX--RDataAnalysisList部门DepartmentQE试验日期TestDate：2012.3.15零件号和名称PartNumber/Name：1223336管接量具名称MeasureName：数显卡尺日期Date：2012.3.15A中国XXXBC重复性—设备变差Repeatability-EquipmentVariation（EV）EV=R×K1%EV=100［EV/TV］0.0061K113.912%4.563.05再现性—试验人员变差Reproducibility-Variationpilotstaff（AV）AV=√［（XDIFF×K2）2-（EV2/nr)］%AV=100［AV/TV］0.004369.944%23n=零件数量PartsQty3.652.7r=试验次数testtime重复性和再现性Repeatabilityandreproducibility（R＆R）R&R=√（EV2+AV2）%R&R=100［GRR/TV］0.0075零件数量K317.1008%23.65零件变差Partvariation（PV）32.7900PV=RP×K342.300098.5270%=0.043252.0800ndc=1.41(PV/GRR）8.1237907161.9300分析结论AnalysisConclusion71.8200总变差Totalvariation（TV）81.7400TV=√（R&R2+PV2）91.6700=0.04385101.6200⑴.所有的计算都是建立在可预计的5.15σ（正态分布曲线之下面积的99%）的基础之上的；Allcalculationsarebasedonpredictable5.15σ(areaunderthenormaldistributioncurveof99%)basis;⑵.GR＆R结果分析参见MSA参考手册（第三版）第二章—第四节；GR&Rresults,seeMSAReferenceManual(ThirdEdition)ChapterII-SectionIV;⑶.AV如果根号下的计算值为负值，取评价人的变差（AV）等于0。AVNo.Iftherootofthecalculatedvaluesforthenegativeevaluationofpeopletakethevariation(AV)isequalto0.□%R&R＜10%,该量具可接受;Accepted□10%≤%R&R≤30%,依据量具的重要性、成本及维修费用等因素，确定该量具是否可接受；AccordingtheimportanceofMeasureandcostandmaintenancecostsandotherfactors,determinewhetherornotacceptable□%R&R＞30%,该量具不能接受,通知多方论证小组,必须对量具进行改进Notacceptable.评价人EvaluationPersonK2%PV=100［PV/TV］测量设备分析Analysisofmeasuringequipment总变差Totalvariation%试验次数Testtime23被测特性CharacteristicofMeasured：量具号MeasureNumber：08142521操作者Operator特性规格CharacteristicSpectification：19+0.1/0量具型式MeasureType根据数据表Accordingtodatatables：R=0.002XDIFF=0.002RP=0.027B.量具的重复性和再现性X-R分析报告GaugeRepeatabilityandReproducibilityX--RAnalysisReport部门DepartmentQE试验日期TestDate：2012.3.15零件号和名称PartNumber/Name：620871-01管接量具名称MeasureName：数显卡尺日期Date：2012.3.15