MSA-GRR数据自动生成工具(已经解密)

,,,,,,,,,,,,,

,GageR&RLong(x-BarRange)Method-3Trials,,,,,,,,,,,

,,,,,,,,,,,,,

Date:,,>>>>,2006.12.25,,,,,,,,,

日期,,,,,,,,,,,,

PerformedBy:,,>>>>,韦云刘忠云丁德利,,,Dept.,,>>>>,质量部,,,

完成人,,,,,,部门,,,,,,

PartNo.&Name:,,>>>>,DQG128点火线圈,,,GageName:,,>>>>,卡尺,,,

零件编号和名称,,,,,,量具名称,,,,,,

CharacteristicMeasured:,,>>>>,长度,,,GageNo.:,,>>>>,JW023,,,

测试特性,,,,,,量具号,,,,,,

TotalTolerence=,,>>>>,76.5,80.5,,Gagetype:,,>>>>,计量,,,

总偏差,,,,,,量具类型,,,,,,

ResultsSummary:,,Variationintotalmeasurementsystem-SeeMSAreferencemanual,,,,,,,,,,

结果总概,,在测量系统中全部的变量可参看MSA参考手册,,,,,,,,,,

,,,E.V.=,11.5%,,,,R&R=,12.2%,,,

,,,A.V.=,4.0%,,,,PV=,99.3%,,,

,,R&R/Tolerence-Seeacceptanceguidelinesbelow.,,,,,,,,,,

,,R&R/,偏差-查看如下可接受输入数据的指导,,,,,,,,,

,,,E.V.=,0.19%,,A.V.=,0%,,R&R=,0.20%,,

,,,,,,,,,,,,,

ApprovedBy:,>>>>,证实人,,,,,Date:,>>>>,,,,

证实人,,,,,,,日期,,,,,

Gageaccepted:,>>>>,Yes,√,,,,,,,,,

接受量具,,No,,,,,,,,,,

,,,,,,,,,,,,,

Significantfactorstoconsiderbeforestartingstudy,,,,,,,,,,,,CHECK

开始研究前，必须考虑的重要因素,,,,,,,,,,,,检查

1,Whenpossiblesamplepartsshouldbeselectedfromtheprocessandrepresentitsentire,,,,,,,,,,,

,operatingrange.(1or2partsrandomlyselectedperdayuntilsufficientpartsarecollected).,,,,,,,,,,,

,尽可能从工艺流程中选取，并且要能代表该零件的整个工艺过程的各特性（每天随机抽取1到2个零件，直至收集到足够的零件）,,,,,,,,,,,

2,Partsmustbeidentified.,,,,,,,,,,,

,零件必须被确认,,,,,,,,,,,

3,Theinstrumentusedmusthavediscriminationtomeasure1/10oftheexpected,,,,,,,,,,,

,processvariation.,,,,,,,,,,,

,使用的仪器必须具备对工艺变量1/10的分辨率,,,,,,,,,,,

4,Assurethattheproperdimensionismeasured.,,,,,,,,,,,

,确保测量适当的尺寸,,,,,,,,,,,

5,Assurethatallmeasuringinstructionsareavailableandunderstoodbyeach,,,,,,,,,,,

,appraiser.,,,,,,,,,,,

,确保测量说明书可用性和便于评审者阅读,,,,,,,,,,,

6,Measurementsshouldbemadeinrandomorder.,,,,,,,,,,,

,测量应以随机顺序进行,,,,,,,,,,,

7,Readingsshouldbeestimatedtothenearestnumberthatcanbeobtained.,,,,,,,,,,,

,相关的材料上，应该尽量采用可获取的最接近的数据,,,,,,,,,,,

8,ConsulttheMSAreferencemanualformoredetail.,,,,,,,,,,,

,欲获取更详细的情况，可查看MSA参考手册,,,,,,,,,,,

Guidlinesforgageacceptancefor%R&R.,,,,,,,,,,,,

R&R量具,,,,,,,,,,,,

1,<10%-,,Measurementsystemacceptable.,,,,,,,,,

,,,"对于测量系统,可以接受",,,,,,,,,

2,10-30%,,"Maybeacceptablebaseduponimportanceofapplication,costofgage,",,,,,,,,,

,,,"costofrepairs,etc.",,,,,,,,,

,,,基于量具的应用、花费和修理等因素的重要性考虑，而选择接受与否,,,,,,,,,

3,>30%-,,Measurementsystemneedsimprovement.Makeeveryefforttoidentifythe,,,,,,,,,

,,,problemsandhavethemcorrected.,,,,,,,,,

,,,检测系统需要改进。尽可能的找到问题，并予以纠正。,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

使用本表前请阅读可调储存格的批注，%R&R达到预期要求时立即复制数据，选择粘贴数值的方式粘贴到新表。,,,,,,,,,,,,

参数规格下限,规格上限,,测量偏差系数,规格偏差系数,小数位数,,,,,数据结果,,

10.15,10.8,,,,,,,,,,,

,10.475,0.13,0.02,0.2,2,,,,GR&R=,12.2%,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

量具重复性和再现性数据表,,,,,,,,,,,,

,零件,,,,,,,,,,,

评价人/试验,1,2,3,4,5,6,7,8,9,10,,Average均值

1A1.,10.59,10.45,10.59,10.46,10.56,10.49,10.47,10.6,10.51,10.39,,10.511

2.2.,10.6,10.45,10.6,10.48,10.56,10.5,10.48,10.62,10.53,10.4,,10.522

3.3.,10.59,10.46,10.61,10.47,10.58,10.49,10.47,10.6,10.51,10.41,,10.519

4.Average均值,10.5933,10.4533,10.6000,10.4700,10.5667,10.4933,10.4733,10.6067,10.5167,10.4000,X-bar/A=,10.517

5.Range极差,0.0100,0.0100,0.0200,0.0200,0.0200,0.0100,0.0100,0.0200,0.0200,0.0200,R-bar/A=,.016

6.B1.,10.61,10.47,10.61,10.47,10.57,10.5,10.49,10.61,10.51,10.41,,10.525

7.2.,10.61,10.47,10.6,10.48,10.56,10.5,10.49,10.6,10.52,10.4,,10.523

83.,10.6,10.47,10.6,10.47,10.57,10.5,10.47,10.61,10.52,10.4,,10.521

9.Average均值,10.6067,10.4700,10.6033,10.4733,10.5667,10.5000,10.4833,10.6067,10.5167,10.4033,X-bar/B=,10.523

10.Range极差,0.0100,0.0000,0.0100,0.0100,0.0100,0.0000,0.0200,0.0100,0.0100,0.0100,R-bar/B=,.009

11.C1.,10.6,10.45,10.61,10.48,10.56,10.51,10.48,10.61,10.53,10.41,,10.524

12.2.,10.59,10.45,10.6,10.47,10.56,10.49,10.49,10.61,10.52,10.39,,10.517

13.3.,10.6,10.45,10.61,10.46,10.58,10.51,10.48,10.6,10.53,10.4,,10.522

14.Average均值,10.5967,10.4500,10.6067,10.4700,10.5667,10.5033,10.4833,10.6067,10.5267,10.4000,X-bar/C=,10.521

15.Range极差,0.0100,0.0000,0.0100,0.0200,0.0200,0.0200,0.0100,0.0100,0.0100,0.0200,R-bar/C=,.013

16.PartAverageXbar/p零件均值（Xp）,10.5989,10.4578,10.6033,10.4711,10.5667,10.4989,10.4800,10.6067,10.5200,10.4011,X-barbar=,10.520

,,,,,,,,,,,Rp=,.206

17.[Ra=]+[Rb=]+[Rc=]/[评价人数量=]=,,,,,,,,,,,R=,.013

18.[MaxX=]-[MinX=]=XDIFF,,,,,,,,,,,,.006

19.[R=]×[D4=]※=UCLR,,,,,,,,,,,UCL/R=,.033

20.[R=]×[D3=]※=UCLR,,,,,,,,,,,LCR/R=,.000

,,,,,,,,,,,,,

trials,D4,D3,,"Note:CompareallRangevaluestoUCL/R.Ifanyarehigher,identifythecauseanddiscardthevalues.RecomputeRusingremainingvalues.",,,,,,,,

2,3.27,0,,,,,,,,,,

3,2.58,0,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

量具重复性和再现性报告,,,,,,,,,,,,

,,,,,,,,,,,,,

零件编号和名称：,DQG128点火线圈,,,,量具名称：,卡尺,,,日期：,2006.12.25,,

特性：,长度,,,,量具号：,JW023,,,完成人：,韦云刘忠云丁德利,,

规范：,76.5-80.5,,,,量具类型：,计量,,,,,,

,R=,,0.012666667,,,x-BarDiff.=,,0.006,,R/p=,,.206

,,,,,,,,,,,,,

Numberoftrials=,3,,X-barbar=,,10.52044444,,Tol.=,4,,No.ofParts=,,10

,,,,,,,,,,,,,

MeasurementUnitValue,,,,,,,TotalVariation(TV),,,,,

,,,,,,,,,,,,,

Repeatability-EquipmentVariation(EV),,,,,,,%EV=,,EV/TV,,,

,,,,,,,=,,11.49%,,(Variation),

EV=,R-barbarxK1,,,,,,,,EV/Tol,,,

EntervalueK1=,,0.5908,,Trials,K1,,=,,0.19%,,(Tolerence),<<<<

,,,,2,0.8862,,,,,,,

EV=,,0.007483467,,3,0.5908,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

Reproducibility-Appraiservariation(AV),,,,,,,%AV=,,AV/TV,,,

,,,,,,,=,,4.04%,,(Variation),

AV=,Sq.Rt.((X-barDIFFxK2)^2-(EV^2/(nr))),,,,,,,,AV/Tol,,,

,,,,,,,=,,0.07%,,(Tolerence),<<<<

=,0.002630577,,,,,,,,,,,

Note:Anegativevalueunderthesquarerootsignwill,,,Appraisers,,2,3,n=,Numberofparts=,,,10,

defaulttheappraiservariationtozero.,,,,K2,0.7071,0.5231,r=,Numberoftria