Gage R&R Sheet Formula error?! NDC less than 4

T

terranceyu

#1
Dear covers,

Can you check what is wrong with this GR&R sheet? When I plot to other formats, the R&R% is < 10%, and ndc is more than 4?

Please help.

Regards,
Terrance
 

Attachments

Elsmar Forum Sponsor

Stijloor

Staff member
Super Moderator
#2
Dear covers,

Can you check what is wrong with this GR&R sheet? When I plot to other formats, the R&R% is < 10%, and ndc is more than 4?

Please help.

Regards,
Terrance
Any MSA Friends who can help?
(See attachment in previous post.)

Thank you!!

Stijloor.
 
T

terranceyu

#3
Dear covers,

Can you check what is wrong with this GR&R sheet? When I plot to other formats, the R&R% is < 10%, and ndc is more than 4?

Please help.

Regards,
Terrance
Can anyone help in this? it will be great help if can help to solve this problem.
I had been checking the formula, and found everything is okay.

What had been wrong?
 
D

debyang

#4
It seems that your AV is much smaller than EV, and there is error in the formula for AV calculation. The formula should incorporate this condition as" =IF(((B47*Y64)^2-(B50^2)/(E43*G43))<0, 0,SQRT((B47*Y64)^2-(B50^2)/(E43*G43)))."

After revision to the spreadsheet ,your study TV is still too small(0.0009) when compared to the Spec TV(0.005); the GRR is still high. If use spec TV as computation basis, the PV must be recalculated(=sqrt(spec TV^2-GRR^2));both the GRR% (5.91%)and ndc(23) results come out pretty good.

However, your R data indicate that the EV is not stable, part #5 R(0.0020) is beyond the UCL(0.00129), and the resoluation is not sufficient (only 3 different values:0.0000, 0.0010, 0.0020), you might need to investigate such situations.
 
Last edited by a moderator:
Thread starter Similar threads Forum Replies Date
F Leak Tester Gage R&R Sheet Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
kedarg6500 Gage R&R - Is my sheet calculation wrong? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 21
A Excel Spread Sheet for Gage R&R wanted Excel .xls Spreadsheet Templates and Tools 1
S Gage R&R for Visual Inspection for Sheet Steel Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
L Good Excel .xls sheet for Gage R&R that calculates both Anova and Range Excel .xls Spreadsheet Templates and Tools 9
N How to Validate a Gage R&R Spread Sheet General Measurement Device and Calibration Topics 3
K Gage R & R - How to enter appraiser results into an Excel .xls spread sheet Excel .xls Spreadsheet Templates and Tools 12
A Significance of X chart in AIAG MSA sheet for Gage R&R Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 9
M Gage R sheet - Can someone make sense of this data? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 8
J Seeking: Gage Calibration Data Collection sheet example General Measurement Device and Calibration Topics 3
D Gage R&R / Inspection Sheet - Example Excel .xls Templates Attached Excel .xls Spreadsheet Templates and Tools 39
T Plug Gage Calibration Calibration and Metrology Software and Hardware 1
L Gage R&R TMV Acceptance Criteria Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
S MSA for attribute relation gage Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
E Zero part to part variation - Gage R&R project Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 15
M Gage R&R and right way to measure Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 16
L Gage RandR on automated equipment. IATF 16949 - Automotive Quality Systems Standard 7
B Gage calibration frequency, ISO and IATF - What are the requirements Calibration Frequency (Interval) 3
D Difference between Test Method Validation and Gage R&R Qualification and Validation (including 21 CFR Part 11) 18
R Determining Uncertainty from Gage R&R Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
C Correct Calibration Method for Dial Depth Gage General Measurement Device and Calibration Topics 6
C Gage Block Wringing General Measurement Device and Calibration Topics 3
B Gage R&R with NDC=1 Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 19
S Type 1 Gage R&R or something else? Reliability Analysis - Predictions, Testing and Standards 6
G Should I perform Gage R&R only at the beginning of a new project? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
V Thread Plug Gage Pitch GO Diameter out of spec AQL - Acceptable Quality Level 8
G Gage R&R - Where am I going wrong? Part of a FAIR submission (Aerospace) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
R Gage R&R Excel templates Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
K Gage R&R with more than 3 appraisers Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
Anerol C Gage R&R Template AIAG 4th Edition IATF 16949 - Automotive Quality Systems Standard 3
T Attributes SPC study - Attributive control (Go gage) Statistical Analysis Tools, Techniques and SPC 5
S Capability or Gage R&R Study for Leak Tester? Reliability Analysis - Predictions, Testing and Standards 15
N % Tolerance - Type 1 study on the gages, then a gage R&R (ANOVA) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
M Definitive answer on Type 1 vs Type 2 vs Type 3 Gage Study Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
V Gage Management and Gage R&R Software General Measurement Device and Calibration Topics 1
D Gage R&R Study on Load Cells - Large chemical blending tanks IATF 16949 - Automotive Quality Systems Standard 1
B Minitab Type 1 Gage Study on True Position Question Measurement Uncertainty (MU) 1
S Gage R&R on alloy Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 10
8 Need Help - Runout - Function Gage Inspection, Prints (Drawings), Testing, Sampling and Related Topics 7
L Gage R&R studies for identical Devices - Need to confirm the requirement to perform them Reliability Analysis - Predictions, Testing and Standards 2
G Stab Pin Size For Check Gage Inspection, Prints (Drawings), Testing, Sampling and Related Topics 3
E Functional Gage for TOP applied at RFS Design and Development of Products and Processes 5
F No reproducibility Error in Gage R&R? Reliability Analysis - Predictions, Testing and Standards 4
M Template for Attribute Gage R & R wanted Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
G Warning about Deltronic Gage Pins - The "Certification of Accuracy" document General Measurement Device and Calibration Topics 13
A Gage type 1 study on CMM Capability, Accuracy and Stability - Processes, Machines, etc. 2
Q Gage R&R for Instant Measurement Machine Manufacturing and Related Processes 6
M Gage R&R with large inter part variance - Torque Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
D Do we need normal data for gage r&r studies? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
D Do I need part variation while doing Destructive Variable Gage R&R MSA study Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 19

Similar threads

Top Bottom