MSA-GRR数据自动生成工具

1、Gage R&R Long (x-Bar Range) Method - 3 TrialsDate:2006.12.25日期Performed By:韦云 刘忠云 丁德利Dept.质量部完成人部门Part No. & Name:DQG128点火线圈Gage Name:卡尺零件编号和名称量具名称Characteristic Measured:长度Gage No.: 测试特性量具号Total Tolerence=Gage type:计量总偏差量具类型Results Summary:Variation in total measurement system-See MSA refer

2、ence manual结结果果总总概概在在测测量量系系统统中中全全部部的的变变量量可可参参看看MSA参参考考手手册册 R&R/Tolerence-See acceptance guidelines below.偏差-查看如下可接受输入数据的指导Approved By:证实人Date:证实人日期Gage accepted:接受量具Significant factors to consider before starting studyCHECK开开始始研研究究前前，必必须须考考虑虑的的重重要要因因素素检查When possible sample parts should be selec

3、ted from the process and represent its entire operating range. (1 or 2 parts randomly selected per day until sufficient parts are collected).尽可能从工艺流程中选取，并且要能代表该零件的整个工艺过程的各特性（每天随机抽取1到2个零件，直至收集到足够的零件）Parts must be identified.零件必须被确认The instrument used must have discrimination to measure 1/10 of the ex

4、pectedprocess variation.使用的仪器必须具备对工艺变量1/10的分辨率Assure that the proper dimension is measured.确保测量适当的尺寸Assure that all measuring instructions are available and understood by each appraiser.确保测量说明书可用性和便于评审者阅读Measurements should be made in random order.测量应以随机顺序进行Readings should be estimated to the neares

5、t number that can be obtained.相关的材料上，应该尽量采用可获取的最接近的数据Consult the MSA reference manual for more detail. 欲获取更详细的情况，可查 看MSA参考手册Guidlines for gage acceptance for % R&R.R&R量具Measurement system acceptable.对于测量系统,可以接受May be acceptable based upon importance of application,cost of gage, cost of repai

6、rs, etc.基于量具的应用、花费和修理等因素的重要性考虑，而选择接受与否Measurement system needs improvement. Make every effort to identify theproblems and have them corrected.检测系统需要改进。尽可能的找到问题，并予以纠正。使使用用本本表表前前请请阅阅读读可可调调储储存存格格的的批批注注，%R&R达达到到预预期期要要求求时时立立即即复复制制数数据据，选选择择粘粘贴贴数数值值的的方方式式粘粘贴贴到到新新表表。参参数数规规格格下下限限规规格格上上限限测测量量偏偏差差系系数数规规格格偏

7、偏差差系系数数小小数数位位数数数数据据结结果果7072710.60.020.32GR&R=2.0%量量具具重重复复性性和和再再现现性性数数据据表表零件评价人/试验12345678910Average均值1 A 1.70.8370.970.5271.0771.4870.7870.8170.8371.5571.170.9872. 2.70.8570.9270.5271.0971.570.7970.8270.8571.5671.171.0003. 3.70.8470.970.5271.0871.570.7870.8270.8471.5671.1170.9954. Average均值 70.8

8、40070.9067 70.5200 71.080071.493370.7833 70.8167 70.8400 71.5567 71.1033 X-bar/A=70.994SUM A212.52212.72211.56213.24214.48212.35212.45212.52214.67213.315. Range极差0.02000.02000.00000.02000.02000.01000.01000.02000.01000.0100R-bar/A=.0146. B 1. 70.8470.970.5371.0871.4970.7970.8270.8371.5771.170.9957. 2

9、. 70.8470.9170.5371.0971.570.7970.8270.8571.5671.1271.0018 3. 70.8470.9170.5271.0871.4970.7970.8270.8571.5671.1170.9979. Average均值70.8470.9067 70.5267 71.083371.4933370.7970.8270.8433 71.563371.11X-bar/B=70.998SUM B212.52212.72211.58213.25214.48212.37212.46212.53214.69213.3310. Range极差0.00000.01000.

10、01000.01000.01000.00000.00000.02000.01000.0200R-bar/B=.00911. C 1. 70.8470.970.5471.0771.570.7970.8170.8471.5771.1170.99712. 2. 70.8470.9270.5371.0871.4970.7970.8170.8571.5771.1170.99913. 3. 70.8370.9170.5371.0771.4970.870.8270.8471.5671.1170.99614. Average均值 70.836770.9100 70.5333 71.073371.493370.

11、7933 70.8133 70.8433 71.5667 71.1100 X-bar/C=70.997SUM C212.51212.73211.6213.22214.48212.38212.44212.53214.7213.3315. Range极差0.01000.02000.01000.01000.01000.01000.01000.01000.01000.0000R-bar/C=.01016. PartAverageXbar/p零件均值（Xp）70.838970.9078 70.5267 71.078971.493370.7889 70.8167 70.8422 71.5622 71.10

12、78 X-barbar=70.996Rp=1.03617. Ra= + Rb= + Rc= / 评价人数量 = =R =.01118.Max X = - Min X = = XDIFF .00419.R = D4 = = UCLR UCL/R=.02820.R = D3 = = UCLR LCR/R=.000trialsD4D3Note: Compare all Range values to UCL/R. If any are higher, identify the causeand discard the values. Recompute R using remaining value

13、s.23.27032.580量量具具重重复复性性和和再再现现性性报报告告零件编号和名称：量具名称：日期：特性：量具号：完成人：韦云 刘忠云 丁德利规范：量具类型：R=x-Bar Diff.=R/p=Number of trials=No. of Parts=Measurement Unit ValueTotal Variation (TV)Repeatability - Equipment Variation (EV)% EV=(Variation)R-barbar x K1Enter value K1 = (Tolerence)Reproducibility - Appraiser vari

14、ation (AV)(Variation)Sq.Rt.(X-bar DIFF x K2)2-(EV2/(nr)(Tolerence)Note:A negative value under the square root sign willAppraisersNumber of parts =default the appraiser variation to zero.Number of trials =Repeatability & Reproduciibility (R&R)(Variation)SqRt(EV2) + (AV2)(Tolerence)Part Variat

15、ion (PV)(PV / TV)Rp x K3Total Variation (TV)SQRT(R&R2 + PV2)结论：该测量系统可以接受，满足测量要求。确认：制表：Gage R&R Long (x-Bar Range) Method - 3 TrialsDate:2006.12.25日期Performed By:韦云 刘忠云 丁德利Dept.质量部完成人部门Part No. & Name:DQG128点火线圈Gage Name:卡尺零件编号和名称量具名称Characteristic Measured:长度Gage No.: 测试特性量具号Total Tolere

16、nce=Gage type:计量总偏差量具类型Results Summary:Variation in total measurement system-See MSA reference manual结结果果总总概概在在测测量量系系统统中中全全部部的的变变量量可可参参看看MSA参参考考手手册册 R&R/Tolerence-See acceptance guidelines below.偏差-查看如下可接受输入数据的指导Approved By:证实人Date:证实人日期Gage accepted:接受量具Significant factors to consider before st

17、arting studyCHECK开开始始研研究究前前，必必须须考考虑虑的的重重要要因因素素检查When possible sample parts should be selected from the process and represent its entire operating range. (1 or 2 parts randomly selected per day until sufficient parts are collected).尽可能从工艺流程中选取，并且要能代表该零件的整个工艺过程的各特性（每天随机抽取1到2个零件，直至收集到足够的零件）Parts must b

18、e identified.零件必须被确认The instrument used must have discrimination to measure 1/10 of the expectedprocess variation.使用的仪器必须具备对工艺变量1/10的分辨率Assure that the proper dimension is measured.确保测量适当的尺寸Assure that all measuring instructions are available and understood by each appraiser.确保测量说明书可用性和便于评审者阅读Measur

19、ements should be made in random order.测量应以随机顺序进行Readings should be estimated to the nearest number that can be obtained.相关的材料上，应该尽量采用可获取的最接近的数据Consult the MSA reference manual for more detail. 欲获取更详细的情况，可查 看MSA参考手册Guidlines for gage acceptance for % R&R.R&R量具Measurement system acceptable.对于测

20、量系统,可以接受May be acceptable based upon importance of application,cost of gage, cost of repairs, etc.基于量具的应用、花费和修理等因素的重要性考虑，而选择接受与否Measurement system needs improvement. Make every effort to identify theproblems and have them corrected.检测系统需要改进。尽可能的找到问题，并予以纠正。使使用用本本表表前前请请阅阅读读可可调调储储存存格格的的批批注注，%R&R达达到

21、到预预期期要要求求时时立立即即复复制制数数据据，选选择择粘粘贴贴数数值值的的方方式式粘粘贴贴到到新新表表。参参数数规规格格下下限限规规格格上上限限测测量量偏偏差差系系数数规规格格偏偏差差系系数数小小数数位位数数数数据据结结果果12.3215.68140.6720.020.23GR&R=2.0%量量具具重重复复性性和和再再现现性性数数据据表表零件评价人/试验12345678910Average均值1 A 1. 13.82514.28814.59314.07214.29913.46414.47313.82914.414.21114.1452. 2. 13.83514.28914.60114

22、.08714.30813.46514.47713.83814.40614.22114.1533. 3. 13.82614.29114.61114.08114.30913.47214.48813.84814.4214.22814.1574. Average均值 13.828714.2893 14.6017 14.080014.305313.4670 14.4793 13.8383 14.4087 14.2200 X-bar/A=14.1525. Range极差0.01000.00300.01800.01500.01000.00800.01500.01900.02000.0170R-bar/A=.

23、0146. B 1. 13.83614.30314.60214.07514.30613.48214.48713.84714.40414.22814.1577. 2. 13.83114.30214.59814.07314.31813.46614.48813.84314.40414.22314.1558 3. 13.83214.2914.60314.08814.313.47314.47713.83514.41214.21214.1529. Average均值13.833014.2983 14.6010 14.078714.308013.4737 14.4840 13.8417 14.4067 14

24、.2210 X-bar/B=14.15510. Range极差0.00500.01300.00500.01500.01800.01600.01100.01200.00800.0160R-bar/B=.01211. C 1. 13.83414.2914.59314.07914.31813.47314.47513.8314.40914.22614.15312. 2. 13.83914.30514.60214.08914.30913.46514.47413.83214.40414.22814.15513. 3. 13.82814.30114.59914.08114.30613.48414.48613

25、.84514.40314.22614.15614. Average均值 13.833714.2987 14.5980 14.083014.311013.4740 14.4783 13.8357 14.4053 14.2267 X-bar/C=14.15415. Range极差0.01100.01500.00900.01000.01200.01900.01200.01500.00600.0020R-bar/C=.01116. PartAverageXbar/p零件均值（Xp）13.831814.2954 14.6002 14.080614.308113.4716 14.4806 13.8386 14.4069 14.2226 X-barbar=14.154Rp=1.12917. Ra= + Rb= + Rc= / 评价人数量 = =R =.01218.Max X = - Min X = = XDIFF .00319.R = D4 = = UCLR UCL/R=.03120.R = D3 = =