msa 1.09
DESCRIPTION
a Calculation on Excel spreadsheet for the measurement system analysis as per AIAG 3rd editionISO TS MSATRANSCRIPT
PLANT III
PART NAME W/S PARTITION RR DR R/L DATE 26.5.10 NOMINAL DIMENSION 0 APPRAISER A Umesh Kumar APPRAISEE M. NEGI
PART NO. 84665/75 M75J00 CHARACTERISTIC Gap UPPER TOLERANCE 1 APPRAISER B Laxmikant %R & R 24.31 %
MODEL YN-4 EQUIPMENT USED Feeler Gauge (FG-07) LOWER TOLERANCE 0 APPRAISER C Naresh Prtap ndc 6.00
Apprisar ATrials 1 2 3 4 5 6 7 8 9 10 Constant Tables (for n=10, r=3) 0.0583 Sr.No. ACCEPTABILITY CRITERIA
1 0.85 0.75 0.68 0.48 0.85 0.72 0.82 0.89 0.52 0.90K1 K2 K3
0.01901 If % R & R < 10%, system is acceptable
2 0.79 0.71 0.65 0.45 0.79 0.68 0.86 0.90 0.55 0.95 0.1502
3 0.78 0.79 0.69 0.46 0.80 0.64 0.80 0.95 0.60 0.90 2 1.880 0 3.267 0.8862 0.7071 0.0000
2Avg. (Xi) 0.81 0.75 0.67 0.46 0.81 0.68 0.83 0.91 0.56 0.92 0.74 3 1.020 0 2.575 0.5908 0.5231 0.7497
Range (Ri) 0.07 0.08 0.04 0.03 0.06 0.08 0.06 0.06 0.08 0.05 0.061 10 3 1.020 0 2.575 0.591 0.523 10 0.315 0.8092
0.69023 If % R & R > 30%, system needs improvement
Apprisar B Value of K3 with ref. To n (Sample Size) 1
Trials 1 2 3 4 5 6 7 8 9 10 n 2 3 4 5 6 7 8 9 104 NDC >= 5
1 0.82 0.74 0.65 0.46 0.85 0.67 0.90 0.95 0.55 0.95 24.31 % K3 0.7071 0.5231 0.4467 0.403 0.3742 0.3534 0.3375 0.3249 0.3146
2 0.76 0.79 0.70 0.49 0.89 0.72 0.85 1.00 0.60 0.90 6.00
3 0.79 0.76 0.64 0.52 0.85 0.68 0.85 0.94 0.55 0.95MEASUREMENT UNIT ANALYSIS CONCLUSION
Avg. (Xi) 0.79 0.76 0.66 0.49 0.86 0.69 0.87 0.96 0.57 0.93 0.76
Range (Ri) 0.06 0.05 0.06 0.06 0.04 0.05 0.05 0.06 0.05 0.05 0.053 1 Repeatability - Equipment Variation (EV)
EV = R x K1 => 0.0345 % EV = 100 (EV/TV) => 23.73 %
Apprisar C 2 Reproducibility - Appraiser Variation (AV)
Trials 1 2 3 4 5 6 7 8 9 10 AV = => 0.0077 % AV = 100 (AV/TV) => 5.3 %
1 0.79 0.74 0.65 0.48 0.85 0.70 0.95 0.95 0.56 0.95 n = number of parts
2 0.82 0.69 0.68 0.49 0.83 0.68 0.85 0.85 0.59 0.95 r = number of trials
3 0.75 0.65 0.69 0.54 0.81 0.65 0.85 0.94 0.62 0.95 3 Repeatability & Reproducibility (R & R)
Avg. (Xi) 0.79 0.69 0.67 0.50 0.83 0.68 0.88 0.91 0.59 0.95 0.75 R & R (GRR)= => 0.0353 % R&R = 100 (R&R/TV) => 24.31 %
Range (Ri) 0.07 0.09 0.04 0.06 0.04 0.05 0.10 0.10 0.06 0.00 0.061 4 Part Variation (PV)
PV = Rp X K3 => 0.1409 % PV = 100 (PV/TV) => 97 %
0.79 0.74 0.67 0.49 0.84 0.68 0.86 0.93 0.57 0.93 0.455 Total Variation (TV) No.of distinct categories
TV = => 0.1452 NDC= 1.41(PV/GRR) => 6
Range of Part Avg
PREPARED BY: CHECKEED BY: APPROVED BY:
MEASUREMENT SYSTEM ANALYSIS VARIABLE STUDY (Average-Range Method)
K1 : Based on no. of TrialsK2 : Based on no. of AppriserK3 : Based on Sample Size used in trials
No. of Parts
(n)
No. Of Trials (r) A2 D3 D4
Actual Parts
(n)
If 10% < % R & R < 30%, system may be acceptable based on importance of application, cost of gage, cost of repair, etc.,
COMPARISION TO TOTAL VARIATION
{|(xDIFF x K2)2 - (EV2/nr)|}1/2
{(EV2 + AV2)}1/2
Part Avg.(XP) RP =
{(R&R2 + PV2)}1/2
RP =
1 2 3 4 5 6 7 8 9 100.00
0.10
0.20
0.30
0.40
0.50
0.60
0.70
0.80
0.90
1.00
Average (X bar) Chart for Appraiser A
1 2 3 4 5 6 7 8 9 100.00
0.20
0.40
0.60
0.80
1.00
1.20
Average (X bar) Chart for Appraiser B
1 2 3 4 5 6 7 8 9 100.00
0.10
0.20
0.30
0.40
0.50
0.60
0.70
0.80
0.90
1.00
Average (X bar) Chart for Appraiser C
1 2 3 4 5 6 7 8 9 100.00
0.02
0.04
0.06
0.08
0.10
0.12
0.14
0.16
Range (R) Chart for Appraiser A
1 2 3 4 5 6 7 8 9 100.00
0.02
0.04
0.06
0.08
0.10
0.12
0.14
0.16
Range (R) Chart for Appraiser B
1 2 3 4 5 6 7 8 9 100.00
0.02
0.04
0.06
0.08
0.10
0.12
0.14
0.16
Range (R) Chart for Appraiser C
TOLERANCE