msa 1.09

2
PART NAME W/S PARTITION RR DR R/L DATE 26.5.10 NOMINAL DIMENSION 0 APPRAISER A Umesh Kumar APPRAI PART NO. 84665/75 M75J00 CHARACTERISTIC Gap UPPER TOLERANCE 1 APPRAISER B Laxmikant %R & MODEL YN-4 EQUIPMENT USED Feeler Gauge (FG-07) LOWER TOLERANCE 0 APPRAISER C Naresh Prtap ndc Apprisar A Trials 1 2 3 4 5 6 7 8 9 10 Constant Tables (for n=10, r=3) 0.0583 Sr.No. 1 0.85 0.75 0.68 0.48 0.85 0.72 0.82 0.89 0.52 0.90 K1 K2 K3 0.0190 1 If % R 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 2 Avg. (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.6902 3 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 10 4 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.95 MEASUREMENT UNIT ANALYSIS 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.45 5 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 Trials K2 : Based on no. of Appriser K3 : Based on Sample Size used in trials No. of Parts (n) No. Of Trials (r) A2 D3 D4 Actual Parts (n) If 10% acceptabl cost of g If % R & improveme COMPARISION TO TOTAL VARIATION {|(xDIFF x K2) 2 - (EV 2 /nr) {(EV 2 + AV 2 )} 1/2 Part Avg. (XP) RP = {(R&R 2 + PV 2 )} 1/2 RP = 1 2 3 4 5 6 7 8 9 10 0.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 10 0.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 0.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 Apprais 1 2 3 4 5 6 7 8 9 10 0.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 10 0.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 0.00 0.02 0.04 0.06 0.08 0.10 0.12 0.14 0.16 Range (R) Chart for Appraiser TOLERANCE

Upload: mahendra

Post on 19-Nov-2014

284 views

Category:

Documents


7 download

DESCRIPTION

a Calculation on Excel spreadsheet for the measurement system analysis as per AIAG 3rd editionISO TS MSA

TRANSCRIPT

Page 1: MSA 1.09

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

S13
Formula