Click here to Skip to main content
11,430,039 members (74,811 online)
Click here to Skip to main content

A Study of Gauge Repeatability and Reproducibility for Automated Measuring Systems using VB.NET

, 24 Jan 2015 CPOL
Rate this:
Please Sign up or sign in to vote.
Gauge R&R using VB.NET.

Introduction

Nowadays automobile industry is interested in automated measuring machines to ensure quality and to compete in the global industry. Gauge Repeatability and Reproducibility takes a major role in ensuring quality by measuring automobile components. The purpose is to make repeatability and reproducibility of Measuring Systems like Camshaft, Crankshaft, and so on. A digital sensor is used for measuring Camshaft and Crankshaft. Then the measured data is analyzed using Gauge Repeatability and Reproducibility methodology . Gage R&R is a statistical method for analyzing measurement data. The result of this system can make standard systems competitive in the global industry.

I have been working on several automation projects. In one of my projects I got a chance to work on Gauge R&R. Instead of using third-party tools, I planned to create a simple program using C# for Gage R&R. I finally completed the program and it is running in an automation company. The main purpose of this article is to share what I studied for developing a Gauge R&R with other members. When I searched on CodeProject for Gauge R&R , I was unable to find anything related to Gauge R&R. So I am happy to write the first article about Gauge R&R in this website.

In this article I have attached a sample Gauge R&R Study Excel worksheet for your reference.

It is a fact of nature that all data contains random variations. Part of this variation is due to individual differences, but another part of this variation is due to uncertainty in the measurements caused by variability in the measurement equipment and process. If the measurement uncertainty is too large then the measurement system may be unusable. A gauge repeatability and reproducibility (R&R) study looks at this variability [1].

Gauge R&R helps determine the magnitude of the variation in a measurement system as well as the sources of this variation. While the sources of variation can be numerous, three of these sources are fundamental: part-to-part variation, repeatability, and reproducibility [1]. Part-to-part variation is the normal range over which measurements are made; the part of your data you actually want to measure. Repeatability is the variation because of the gauge itself, while reproducibility is the variation because of various operators using the gauge. Repeatability and reproducibility together are called "measurement error," or simply "noise," and are measured as "gauge R&R." This noise is a nuisance that adds uncertainty to your data. A good measurement system has very low noise, preferably less than 1% of the total variability in your data, indicated as a gauge R&R of less than 10%. A questionable system will have noise between 1% and 9% of the total variability, or a gauge R&R between 10% and 30%. A poor system will have noise greater than 9% of the total variation, or a gauge R&R greater than 30% [1].

Gauge R&R measures the size of the noise relative to the total data variation, that is called % of total variation or %TV, and relative to the specification range, called % of tolerance. It also separates the variability into its sources, namely part-to-part variation, repeatability, and reproducibility. This information helps operators determine how to fix a poor measurement system. For instance, a high repeatability relative to reproducibility indicates the need for a better gauge. A high reproducibility relative to repeatability indicates the need for better operator training in the use of the gauge [1].

Gauge Repeatability

The variation obtained from one gauge and one operator when measuring the same part several times. Understanding measurement System [2].

Simply said, Gauge Repeatability is checking the final result of parts with one operator multiple times.

Gauge Reproducibility

The difference in the average of measurements made by various operators using the same gauge when measuring the same part. Understanding measurement System [2].

Simply said, Gauge Reproducibility is checking the final result of parts with multiple operators multiple times. There are various ways by which the R&R of an instrument may be assessed, one of which is outlined below. This method, that is based on the method recommended by the Automotive Industry Action Group (AIAG), first computes for variations due to measuring equipment and its operators. The over-all GR&R is then computed from these component variations.

Equipment Variation, or EV, represents the repeatability of the measurement process. It is calculated from measurement data obtained by the same operator from several cycles of measurements, or trials, using the same equipment [4].

Appraiser Variation or AV, represents the reproducibility of the measurement process. It is calculated from measurement data obtained by various operators or appraisers using the same equipment under the same conditions. The R&R is just the combined effect of EV and AV [4].

It must be noted that measurement variations are caused not just by EV and AV, but by Part Variation as well, or PV. PV represents the effect of the variation of parts being measured on the measurement process, and is calculated from measurement data obtained from several parts [4].

Thus, the Total Variation (TV), or the over-all variation exhibited by the measurement system, consists of the effects of both R&R and PV. TV is equal to the square root of the sum of (R&R)2 and (PV)2 squared, in other words:

In a GR&R report, the final results are often expressed as %EV, %AV, %R&R, and %PV,

%EV = 100(EV/TV)
%AV = 100(AV/TV)
%R&R = 100(R&R/TV)
%PV = 100(PV/TV) [3]

The gauge is good if its %R&R is less than 10%. A %R&R between 10% to 30% may also be acceptable, depending on what it would take to improve the R&R. A %R&R of more than 30%, however, should prompt the process owner to investigate how the R&R of the gauge can be further improved [4].

Application

An example will be helpful for a gauge R&R Study. In our system, a maximum of 3 operators, 3 trials, and 10 parts can be used. For example, we are using:

  • 2 Operators
  • 2 Trials
  • 4 Parts

Using the code

Steps needed to run the program.

  1. Need SQL Server 2005 or 2008
  2. Create new database named MLA and restore the attached MLA.bak DB to your new DB. (You can find the "MLA.bak" DB backup file in the attached ZIP file.)
  3. To run the program you need a DB connection. From program settings, please provide your DB server name and the UID and PWD of your SQL Server.
  4. Now your Gauge R&R program is ready.

The Gauge R&R Result is: In my sample program the maximum number of parts that can be used is 10, number of operators is 3 and number of trials is 3.

Where Rp=Max(Part/Avg data)-Min(Part/Avg data)

In our ex you can see its 30.000 as max and min as 25.250

R-Bar=sum( Avg(data) / NoofOperators)

Xdiff=Max(Avg data)-Min(Avg data)

References

  1. Quality Introduction to Gage R&R http://www.qualitymag.com/CDA/Archives/53c9323027f28010VgnVCM100000f932a8c0____
  2. Understanding measurement System http://www.swtest.org/swtw_library/1998proc/PDF/T1_Hank.PDF
  3. R & R Repeatability and Reproducibility http://www.sixsigmaspc.com/dictionary/RandR-repeatability-reproducibility.html
  4. Gage R&R http://www.siliconfareast.com/grr.htm
  5. http://elsmar.com/Forums/archive/index.php/t-16530.html

Points of Interest

The main aim of this article is to create a simple and standard Gauge R&R application for the automobile industry. Please find the attached DB file "MLA.bak" and restore it to your local SQL Server DB to access my program.

History

  • Initial release on 2013/07/16.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

syed shanu
Team Leader
India India

His Blog


Syed Shanu is basically from Madurai, Tamil Nadu, India.He was been working in South Korea for past 8 years. He started programming with Basic Language and C language from his high school at 1999.In 2005 he completed his Master of Computer Application. He started his working Career from Dec 2004 with ASP.

He has 9+ years of Experience in Microsoft Technologies.

His work experience with Language and Technology start’s from ASP and SQL Server, Then VB.NET and C# for PDA Application, Touch Screen Application Development, Desktop Application, ASP.NET Web Application Development, MVC and WPF.

He loves to work with Microsoft technology as he started to work on .Net Frame Work version from 1.0 to 4.5.

He had worked with HMI (Human Machine Interface) programs like PLC, Nutrunner Tools, and Sensor programs, RFID programs, Barcode programs and etc.

He also worked with Dotnetnuke .

He had worked with Projects like, Restaurant management with PDA AND Desktop Development, Hospital management with PDA, Desktop and Web development, Online Shopping Cart for web, Inventory Management for web, Asset Management for desktop, SPC for Desktop, Factory Automation for Desktop, MES for both Web and Desktop, ERP for Both Web and Desktop.

He usually uses his free time to spend with his Family and go outing. He loves photography and Hiking.

He’s a Positive thinker, he always believes in Software field there is no problems with solution.
Follow on   Twitter   Google+   LinkedIn

Comments and Discussions

 
QuestionMy vote of 5! Pin
jediYL26-Jan-15 15:36
memberjediYL26-Jan-15 15:36 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.150428.2 | Last Updated 24 Jan 2015
Article Copyright 2015 by syed shanu
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid