MSA Calculation - My results do not match those of my customer

niotusen

Registered Visitor
#1
Hello!
Have a customer who had their MSA calculation and the results is shown near:

%Tolerance variation
%EV=1,206452
%AV=3,651613
%R&R=3,845161
%PV=8,006452


And when we do our test in excel spread sheet we have our results as shown:
%R&R = 19,84

see attachment file:

Is there some reasons thats our customer has got different results?

Is there someone that can help me to make a test in other system to see the result who are right?
Thanks?
 

Attachments

Elsmar Forum Sponsor

Howard Atkins

Forum Administrator
Staff member
Admin
#2
There seems to be a problem in the work sheet.
Attached 2 worksheets one similar to yours and another .
These do not agree exactly but are close to your customer.

As can be seen even though the R&R is low the system is not good, see the range charts on the Gage R and R spreadsheet - another one.xls file.

I have another comment, if the tolerance is 0.031 is measuring to 0.001 adequate or should the definition be 0.0001?
Anyone
 

Attachments

niotusen

Registered Visitor
#3
Thanks a lot!
It seemes to be different templates and calculations out there, is it best to buy one software to bee sure of the calculations? OR can I validate the calculation thru an example of MSA ref manual?
 

Howard Atkins

Forum Administrator
Staff member
Admin
#4
There are a lot of examples here at the cove of templates.
I think that the basic difference comes from the tolerance method or part variation method.
This is a case of software validation.

If you buy software then you need to be sure that this is validated.

Try the example in the handbook
 
Thread starter Similar threads Forum Replies Date
L Number of Distinct Categories" or NDC Calculation in MSA Studies Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 8
M MSA question on Cg and Cgk Calculation Method and Type of Test Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
Rameshwar25 Manual Formula for p-value Calculation for MSA Analysis Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 10
M Cp calculation on page 193 of the MSA 3rd edition May 2003 with %GRR Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
M Anova confidence intervals calculation - MSA 3rd edition page 122 Statistical Analysis Tools, Techniques and SPC 1
B Attribute MSA calculation - Trying to find a form or software Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
S MSA bias calculation in 3rd edition - Why is d2/d2star used? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
G MSA Manual Bias Calculation - Why is the d2* correction factor needed Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
X MSA Studies on a scale that is used in the calculation of Specific Gravity (SG) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
Nihls When the MSA results show no operator influence Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
S MSA for attribute relation gage Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
Nihls MSA Study Type 1 (CMM) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
M MSA Study Type 1 not capable. We are at the limit. And manufacturing wants to continue producing. Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
I Overwhelmed with attribute MSA requirement for visual inspection IATF 16949 - Automotive Quality Systems Standard 8
H Need MSA 4th ed. compliant attribute MSA template General Measurement Device and Calibration Topics 4
P MSA for titration Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
P MSA - what exactly mean "system" and master sample Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
P MSA study for visual system with artifical inteligence Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
D MSA strategy Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
K Updated MSA with the Annual PPAP validations APQP and PPAP 8
E MSA for Push and Pull test Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 9
6 MSA for Calculated Clearance Dimension Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
Ron Rompen MSA on automated measurement system - Multiple Step Vision System Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
G MSA check list to audit IATF 16949 - Automotive Quality Systems Standard 10
R MSA for ATE (Automatic Test Equipment Embedded Software) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 9
Bev D MSA Tools Misc. Quality Assurance and Business Systems Related Topics 3
R MSA studies for Heat Treatment Equipment Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
C Industrial scales and MSA (IATF 16949 requirement 7.1.5.1.1) IATF 16949 - Automotive Quality Systems Standard 30
M Difference between MSA and MSE? General Measurement Device and Calibration Topics 1
M Test method validation - Is MSA (MSA1, MSA2, MSA3 and linearity) a good solution? Medical Device and FDA Regulations and Standards News 1
A MSA results differences - Supplier results vs. My results Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
R Preliminary MSA and Sockets' correlation Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
I MSA requirement for 5 Micrometers + CP changes need customer approval? IATF 16949 - Automotive Quality Systems Standard 2
T Correct MSA study for an automated camera system which makes attribute inspection Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
Bev D MSA Misc. Quality Assurance and Business Systems Related Topics 46
Emran.mi Measurement system analysis - Can you help me about implementation MSA for CMM device Manufacturing and Related Processes 2
N MSA Study for a Leak Testing Device Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
N Justifications for not performing MSA (Measurement System Analysis) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
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
Prashant G MSA Study - AS 9100 and and our customer want us to do MSA study for their parts dimension Reliability Analysis - Predictions, Testing and Standards 4
D Compression Spring Force MSA Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
E MSA Study on MTS dynamic rate measurements Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
A The FILE recommended by AIAG MSA 4ed for LINEARITY Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
S IATF 16949 Audit MSA IATF 16949 - Automotive Quality Systems Standard 10
C Do Calibration Reference Standards require an MSA study? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
A MSA When an Instrument Measures More than One Parameter Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7
G MSA Type 1 - Cg and Cgk ranges Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
O MSA Study for a steel ruler Manufacturing and Related Processes 6
P IATF 16949 MSA Studies for CMM machines IATF 16949 - Automotive Quality Systems Standard 3
B 7.1.5.1.1 MSA for inline dimension vision inspection equipment IATF 16949 - Automotive Quality Systems Standard 5

Similar threads

Top Bottom