Values and results to check Validation of Gauge (Gage) R&R program

Elsmar Forum Sponsor
G

gaugefixer

#2
Can't read file

Howard,

Is this file encrypted? I'm getting that it's in an unrecognizable format. I'm using Excel 2002.
 

Jim Wynne

Staff member
Admin
#3
gaugefixer said:
Howard,

Is this file encrypted? I'm getting that it's in an unrecognizable format. I'm using Excel 2002.
It opens OK for me in Excel 2003. You might try:

 

Marc

Hunkered Down for the Duration
Staff member
Admin
#4
It downloads and opens in Excel on my Mac running Office X (version prior to the current Mac version).

It also opens in NeoOfficeJ on my Mac.

Nice file. Thanks, Howard!
 
R

Rockerzz501

#5
Re: Validation of Gauge R&R program

Howard Atkins said:
Some years ago I saw a booklet from Ford as how to validate Gauge R&R programs.
At last I have found a workbook with the information.
Attached is a workbook which has values and results to check that the programs you are using are correct.
Enjoy
I try to calibrate one Gage R&R variable MSA sheet posted in this site and resulting R&R is not the same with Ford standards.

I try to analyze the K1, K2, K3 constants used and I found out the constants in the MSA tested sheet is using 5.15 instead of 6 (Ford is using Six sigma for K1,K2 constants in the calibration sheet). Instead of K1=5.15/d2, Ford calibration is using 6/d2 for the standard deviation(six sigma standard).I have try to fix the constants the results are ok.:agree1:

Attached is the corrected and calibrated sheet with Ford standards. Thank you Mr. Atkins for the useful validation program.
 

Attachments

L

lifestar

#6
Howard

thanks for the file. can you please provide additional info on the source. Name, date, etc. Is it an AIAG publication?
 

Marc

Hunkered Down for the Duration
Staff member
Admin
#7
Howard

thanks for the file. can you please provide additional info on the source. Name, date, etc. Is it an AIAG publication?
Most files uploaded are screened. If you open the file, it is clearly a file Ford used to give out (its logo is quite evident in the Instructions tab), just like Delphi's PPAP file which we have permission to post.
 
L

lifestar

#8
I wasn't questioning the propriety of the file. I was planning on sharing it with someone else and wanted to give more information about its source - especially its age - that is all.
 

Marc

Hunkered Down for the Duration
Staff member
Admin
#9
I'll let Howard chime in here, but I think it's an old one and it appears Rockerzz501 updated it. I haven't used it or looked at the formulas so I can't vouch for its accuracy.

On the other hand, it has been downloaded (between Howard's post and Rockerzz501's update) about 2000 times with only one 'problem' post (Rockerzz501's correction).
 
W

Wilsonknowledge

#10
Some years ago I saw a booklet from Ford as how to validate Gauge R&R programs.
At last I have found a workbook with the information.
Attached is a workbook which has values and results to check that the programs you are using are correct.
Enjoy

Thanks for this helpful information. May I share my learning

I just study Six Sigma and the teacher told me the Guage R&R < 30%
is acceptable is proposed by FORD, and some write state that at current change to it is a Rule of Thumb by AIAG that <10% is best, 10% to 30% may be acceptable depend on situation
:thanx:

Wilson Lee
 
Thread starter Similar threads Forum Replies Date
A How to interpret Minitab Results? What is difference in Cpk and Ppk values? Using Minitab Software 2
M Specific Values of Quality Objectives Benchmarking 5
G Can calibrated device values be used instead of manufacturers spec? General Measurement Device and Calibration Topics 2
I Recommendation about h and k values when CUSUM charts are used Statistical Analysis Tools, Techniques and SPC 4
Q Criteria to raise a Nonconformance based on KPI values ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 39
E IEC 60335-1 power input deviation - Table 1 Values Other ISO and International Standards and European Regulations 0
D Asterix when pasting a column of values from Excel into Minitab (V17) Using Minitab Software 5
Q Cycle times, value stream mapping, inventory, average values? Lean in Manufacturing and Service Industries 1
N When to record values if a spec for a mfg process is set Manufacturing and Related Processes 3
J Recomended Values - Auditing process in a supplier IATF 16949 - Automotive Quality Systems Standard 18
H In-house device calibration record - Actual values obtained required? General Measurement Device and Calibration Topics 9
N Regression Model (Minitab 18) - Which values my input parameters should have Using Minitab Software 2
Q Really do they add value (Vision, Mission, Values)? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 1
Q Values - ISO 9001 2015 - Clause 4.1 Note 3 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
V Correlating Maximum 'Range' of Values for a given "RSD" (Control Limits) Statistical Analysis Tools, Techniques and SPC 3
A Power Traceability certificate for values for voltage, current and phase General Measurement Device and Calibration Topics 1
M Cp & Cpk about a diameter measured with min.,max. and average values. Capability, Accuracy and Stability - Processes, Machines, etc. 13
D Standard torque values for threaded fasteners AS9100, IAQG 9100, Nadcap and related Aerospace Standards and Requirements 8
V Different gage values for assessment on as-is data and % data Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
E How do you perform a GR&R for system software generated values? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
A 61010-1 Accessible Parts - Limit Values and Crepage and Air Clearance Distances Other Medical Device Related Standards 1
I Dual Acceptance Criteria: Cpk and Individual Values Statistical Analysis Tools, Techniques and SPC 3
Rameshwar25 Getting values of k1, k2 and k3 for n=30, r=3 and k=3 Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
F Fully nested ANOVA: A missing p-values (Minitab) Using Minitab Software 11
T Variation in values of the levels in Factorial/Response surface design Using Minitab Software 1
C Specification + MU - Dealing with reported MU Values Measurement Uncertainty (MU) 6
Ajit Basrur How to allow users to enter values in a protected MS Excel worksheet ? Excel .xls Spreadsheet Templates and Tools 4
M Injection Moulding Minitab DOE - All P Values are 0 Using Minitab Software 7
A Help with acceptable screw gage values per standard BS 919 for Go/ No Go gage General Measurement Device and Calibration Topics 4
K Can I do an average measurement values for a sample? Statistical Analysis Tools, Techniques and SPC 1
Z Using Sum Values for Category Data in Minitab Using Minitab Software 4
N Basic Math Problem - Finding in between Values General Measurement Device and Calibration Topics 14
J Minitab Factorial Experiments - Excluding certain values Using Minitab Software 3
B Rounding Numerical Values Up or Down with respect to the number of Significant Digits Measurement Uncertainty (MU) 9
M Typical values of MTBF for Optical Avionic Networks Reliability Analysis - Predictions, Testing and Standards 1
N Interpretation of Measurement Values - Technical Specification - Amperage Inspection, Prints (Drawings), Testing, Sampling and Related Topics 5
D Hole Limit Dimension Values Placement - Smaller Limit On Top? Manufacturing and Related Processes 3
M Changing PFMEA (Process FMEA) RPN Values based on a Rejection FMEA and Control Plans 4
R How to assess capability for parameters which has got either Min values or Max values Statistical Analysis Tools, Techniques and SPC 2
V Minitab and Excel Giving Different Cpk Values for the same Data Using Minitab Software 12
S Are the Values for Constants determined by Sample Size or Sub-Group Size Statistical Analysis Tools, Techniques and SPC 14
D Analyze of Fractional Factorial Design in Minitab - I didn't get F and P- values Using Minitab Software 4
Z Subsetting based on values in a text column in Minitab Using Minitab Software 1
K Recording Weight Values on Calibration Certificates General Measurement Device and Calibration Topics 13
L Importing CSV (comma separated values) / Excel process steps into Visio diagram Excel .xls Spreadsheet Templates and Tools 2
G Accuracy of Cpk and Cp values with 5% of production Capability, Accuracy and Stability - Processes, Machines, etc. 3
W Z-values in Logistic Regression stem from a Wald test? Using Minitab Software 7
B Normalizing Continuous Data with "0" values Using Minitab Software 3
0 Calculating axis values of normal probability plot Statistical Analysis Tools, Techniques and SPC 4
S Percentile Values for weibull, exponential and 3 parameter logonormal distributions Six Sigma 10
Similar threads


















































Top Bottom