MSA_GRR数据自动生成工具

GageR&RLong(x-BarRange)Method-3TrialsDate:日期PerformedBy:Dept.完成人部门PartNo.&Name:GageName:卡尺零件编号和名称量具名称CharacteristicMeasured:GageNo.:JW023测试特性量具号TotalTolerence=76.580.5Gagetype:计量总偏差量具类型ResultsSummary:Variationintotalmeasurementsystem-SeeMSAreferencemanual结果总概在测量系统中全部的变量可参看MSA参考手册E.V.=2.0%R&R=2.0%A.V.=0.1%PV=100.0%R&R/Tolerence-Seeacceptanceguidelinesbelow.R&R/偏差-查看如下可接受输入数据的指导E.V.=0.18%A.V.=0%R&R=0.18%ApprovedBy:证实人Date:证实人日期Gageaccepted:Yes√接受量具NoSignificantfactorstoconsiderbeforestartingstudyCHECK开始研究前，必须考虑的重要因素检查1Whenpossiblesamplepartsshouldbeselectedfromtheprocessandrepresentitsentireoperatingrange.(1or2partsrandomlyselectedperdayuntilsufficientpartsarecollected).尽可能从工艺流程中选取，并且要能代表该零件的整个工艺过程的各特性（每天随机抽取1到2个零件，直至收集到足够的零件）2Partsmustbeidentified.零件必须被确认3Theinstrumentusedmusthavediscriminationtomeasure1/10oftheexpectedprocessvariation.使用的仪器必须具备对工艺变量1/10的分辨率4Assurethattheproperdimensionismeasured.确保测量适当的尺寸5Assurethatallmeasuringinstructionsareavailableandunderstoodbyeachappraiser.确保测量说明书可用性和便于评审者阅读6Measurementsshouldbemadeinrandomorder.测量应以随机顺序进行7Readingsshouldbeestimatedtothenearestnumberthatcanbeobtained.相关的材料上，应该尽量采用可获取的最接近的数据8ConsulttheMSAreferencemanualformoredetail.欲获取更详细的情况，可查看MSA参考手册Guidlinesforgageacceptancefor%R&R.R&R量具110%-Measurementsystemacceptable.对于测量系统,可以接受210-30%Maybeacceptablebaseduponimportanceofapplication,costofgage,costofrepairs,etc.基于量具的应用、花费和修理等因素的重要性考虑，而选择接受与否330%-Measurementsystemneedsimprovement.Makeeveryefforttoidentifytheproblemsandhavethemcorrected.检测系统需要改进。尽可能的找到问题，并予以纠正。参数规格下限规格上限7072710.60.020.32GR&R=评价人/试验12345678910Average均值1A1.71.271.4570.671.670.7571.3670.4571.0671.5171.1371.1112.2.71.271.4670.6171.6270.7671.3770.4671.0871.5271.1471.1223.3.71.2271.4670.6171.6170.7771.3870.4671.0871.5271.1471.1254.Average均值71.206771.456770.606771.610070.760071.370070.456771.073371.516771.1367X-bar/A=71.119SUMA213.62214.37211.82214.83212.28214.11211.37213.22214.55213.415.Range极差0.02000.01000.01000.02000.02000.02000.01000.02000.01000.0100R-bar/A=.0156.B1.71.271.4770.6171.6170.7671.3770.4571.0871.5271.1571.1227.2.71.271.4770.671.670.7571.3870.4671.0771.5171.1471.11883.71.2271.4670.6171.6170.7671.3770.4671.0871.5171.1471.1229.Average均值71.2066771.466770.606771.606770.7566771.373370.456771.076771.513371.1433X-bar/B=71.121SUMB213.62214.4211.82214.82212.27214.12211.37213.23214.54213.4310.Range极差0.02000.01000.01000.01000.01000.01000.01000.01000.01000.0100R-bar/B=.01111.C1.71.2171.4570.6271.6270.7671.3670.4671.0871.5371.1471.12312.2.71.271.4670.6171.6170.7671.3670.4671.0771.5271.1371.11813.3.71.271.4770.6271.6170.7671.3770.4771.0771.5371.1571.12514.Average均值71.203371.460070.616771.613370.760071.363370.463371.073371.526771.1400X-bar/C=71.122SUMC213.61214.38211.85214.84212.28214.09211.39213.22214.58213.4215.Range极差0.01000.02000.01000.01000.00000.01000.01000.01000.01000.0200R-bar/C=.01116.PartAverageXbar/p零件均值（Xp）71.205671.461170.610071.610070.758971.368970.458971.074471.518971.1400X-barbar=71.121Rp=1.15117.[Ra=]+[Rb=]+[Rc=]/[评价人数量=]=R=.01218.[MaxX=]-[MinX=]=XDIFF.00319.[R=]×[D4=]※=UCLRUCL/R=.03220.[R=]×[D3=]※=UCLRLCR/R=.000测量偏差系数规格偏差系数小数位数数据结果2.0%量具重复性和再现性数据表零件使用本表前请阅读可调储存格的批注，%R&R达到预期要求时立即复制数据，选择粘贴数值的方式粘贴到新表。trialsD4D3Note:CompareallRangevaluestoUCL/R.Ifanyarehigher,identifythecauseanddiscardthevalues.RecomputeRusingremainingvalues.23.27032.580零件编号和名称：量具名称：日期：特性：量具号：完成人：规范：量具类型：计量R=0.01233x-BarDiff.=0.003R/p=1.151Numberoftrials=3X-barbar=71.12067Tol.=4No.ofParts=10MeasurementUnitValueTotalVariation(TV)Repeatability-EquipmentVariation(EV)%EV=EV/TV=2.01%(Variation)EV=R-barbarxK1EV/TolEntervalueK1=0.5908TrialsK1=0.18%(Tolerence)20.8862EV=0.0072930.5908Reproducibility-Appraiservariation(AV)%AV=AV/TV=0.12%(Variation)AV=Sq.Rt.((X-barDIFFxK2)^2-(EV^2/(nr)))AV/Tol=0.01%(Tolerence)=0.00042Note:AnegativevalueunderthesquarerootsignwillAppraisers23n=Numberofparts=10defaulttheappraiservariationtozero.K20.70710.5231r=Numberoftrials=3Repeatability&Reproduciibility(R&R)%R&R=R&R/TVPartsK3=2.02%(Variation)R&R=SqRt((EV^2)+(AV^2))20.7071R&R/Tol30.5231=0.18%(Tolerence)=0.00729860440.446750.403PartVariation(PV)60.3742%PV=(PV/TV)70.3534PV=RpxK380.3375=99.98%90.3249=0.362139556100.3146TotalVariation(TV)TV=SQRT(R&R^2+PV^2)=0.36确认：制表：GageR&RLong(x-BarRange)Method-3TrialsDate:日期PerformedBy:Dept.完成人部门PartNo.&Name:GageName:卡尺零件编号和名称量具名称CharacteristicMeasured:GageNo.:JW023测试特性量具号TotalTolerence=76.580.5Gagetype:计量总偏差量具类型ResultsSummary:Variationintotalmeasurementsystem-SeeMSAreferencemanual结果总概在测量系统中全部的变量可参看MSA参考手册E.V.=#NUM!R&R=#NUM!A.V.=#NUM!PV=#NUM!R&R/Tolerence-Seeacceptanceguidelinesbelow.R&R/偏差-查看如下可接受输入数据的指导E.V.=0.21%A.V.=0%R&R=#NUM!ApprovedBy:证实人Date:证实人日期Gageaccepted:Yes√接受量具NoSignificantfactorstoconsiderbeforestartingstudyCHECK开始研究前，必须考虑的重要因素检查1Whenpossiblesamplepartsshouldbeselectedfromtheprocessandrepresentitsentireoperatingrange.(1or2partsrandomlyselectedperdayuntilsufficientpartsarecollected).尽可能从工艺流程中选取，并且要能代表