Scribd Logo
Upload

Welcome to Scribd!

  • 69 views

    Gauge Repeatability Reproducibility (GRR)

    Uploaded by

    Wixi Mundo

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Gauge Repeatability Reproducibility (GRR)

    Uploaded by

    Wixi Mundo
    69 views2 pages

    Original Title

    Leanmap_SEE_Measurement_System_Evaluation

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    69 views2 pages

    Gauge Repeatability Reproducibility (GRR)

    Uploaded by

    Wixi Mundo

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 2

    Lean6™ Leanmap.

    com
    Six Sigma for Excel Gauge Repeatability Reproducibility (GRR) Navigating to Results

    Gauge: Variable: Unit: Reference/DUT: R&R-Reference: Responsible: Date:


    Tester Freq-deviation ppm Product XYZ GRR Enter Name 1/1/20

    1. Setup 7. Results
    Spec-Limits Test-Conditions EV AV R&R PV TV UCL MSE NDC
    USL: LSL: Appr: Trials: Parts: 0.000 0.000 0.000 0.000 0.000 0 0% #DIV/0!
    20 5 3 3 7 #DIV/0! #DIV/0! #DIV/0! #DIV/0! not 100% OK OK #DIV/0!

    2. Measurements
    Part Appraiser-1: Tester-001 A Appraiser-2: Tester-002 B Appraiser-3: Tester-003 C Part
    No. Trial-1A Trial-2A Trial-3A RA Trial-1B Trial-2B Trial-3B RB Trial-1C Trial-2C Trial-3C RC Mean
    1 8 8 8 0 8 8 8 0 8 8 8 0 8
    2 7.7 8 7.8 0.3 7.7 7.7 7.7 0 8 7.9 8 0.1 7.8333
    3 5 7.7 8 3 8 8 8 0 8 7.7 8 0.3 7.6
    4 6.9 8 8.1 1.2 8 8 8.1 0.1 8 8 8.1 0.1 7.9111
    5 8 8 8 0 8 8 8 0 8 8 8 0 8
    6 8.2 8.2 8 0.2 8.2 8.2 8 0.2 8.2 8.2 8 0.2 8.1333
    7 8 8 8 0 8 8 8 0 8 8 8 0 8
    8 8 8 8 0 8 7.7 7.7 0.3 8 7.7 8 0.3 7.9
    9 8 8 8 0 8 8 8 0 8 8 8 0 8
    10 8 8 8 0 8 8 8 0 8 8 8 0 8
    Sum 75.8 79.9 79.9 4.7 79.9 79.6 79.5 0.6 80.2 79.5 80.1 1 Rp
    Mean 10.829 11.414 11.414 0.6714 11.414 11.371 11.357 0.0857 11.457 11.357 11.443 0.1429 0.5333

    3. Statistics 6. Variations - absolute(bar) and relative(line)


    Tester Rbar SumXbar Xdbar 1.000
    1.600 1200%
    80%
    A 0.671 33.657 11.219 0.900
    B 0.086 34.143 11.381 1.400 70%
    1000%
    0.800
    C 0.143 34.257 11.419 1.200 60%
    0.700 800%
    SumR 0.9 - -
    Rdbar 0.3000 - - 1.000
    0.600 50%
    R(Xbar) - - 0.200 0.500
    0.800 600%
    40%
    0.400
    0.600 30%
    400%
    4. Part Values 0.300
    9 0.400
    0.200 20%
    200%
    8 0.200
    0.100 10%

    7 0.000
    0.000 0%
    0%
    EV
    EV AV
    AV R&R
    R&R PV
    PV TV
    TV
    6
    5
    4 5. Part-Ranges - by Appraiser
    12
    3.5 RA
    3
    10
    3 RB
    2 RC
    2.58
    1
    2
    0 6
    1.5
    0 10 20 4
    1
    Trial-1A Trial-2A Trial-3A 2
    0.5
    Trial-1B Trial-2B Trial-3B 00
    Trial-1C Trial-2C Trial-3C
    Column B
    Column D
    Column C
    Column F
    1 1 2 2 33 44 55 6
    6 77 88 9 9 10 10
    Column G Column H
    Column J Column K
    Column L
    Trial-1A Trial-2A Trial-3A 2
    0.5
    Trial-1B Trial-2B Trial-3B 00
    Trial-1C Trial-2C Trial-3C
    Column B
    Column D
    Column C
    Column F
    1 1 2 2 33 44 55 6
    6 77 88 9 9 10 10
    Column G Column H
    Column J Column K
    Column L

    You might also like