Spreadsheet: 727154d1617730592-sumifs-across-2-different-workbooks-04-l405-attribute-sheets-apr-2021
Sheet: 1

 |  | Month: | Attribute Reject Information Sheet |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1 | 1
 |  |  | Supplier: |  |  | Various |  |  |  |  |  |  |  | JLR L405 VIEWING STATION
 |  |  | APT Part No: |  |  | L405 Product
 |  |  | Customer Part No: |  |  | Various
 |  |  | Prod Description: |  |  | JLR L405 - Narvik B / Atlas C / Noble C / Bright C |  |  |  |  |  |  |  | WK No: |  |  |  | 13
 |  | 2021-04-01 00:00:00 | File Reference: |  |  |  |  |  |  |  |  |  |  | Station No:
 |  |  |  | Defect Types |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Data Analysis
 |  | Product Description | Total [NAME] | Inclusion | Paint Runs | Orange Peel | Patchy Paint | Overspray | Lack of Paint | Water Damage | Solvent Boil | Contamination | Wet Paint Damage | Mould defect | Securing Rail Damage | Top Edge Cap Damage | Sanding marks | Post Paint Damage | Scratches | Total Processed | Total Good | Total Rejects | RFT
 |  |  |  | 40 | 41 | 55 | 48 |  | 42 | 49 | 47 | 43 | 49 | 58 |  |  |  |  | 44 |  |  |  |  | Suspect
 |  | Covers
P14818301 | 14818301 | 14818301 [NAME] | -880 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -880 | -880 | 0 | 1
P14469401 | 14469401 | 14469401 Shadow | -680 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -680 | -680 | 0 | 1
P14469301 | 14469301 | 14469301 Narvic | -680 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -680 | -680 | 0 | 1 | 159
P68931920 | 68931920 | 68931920 Platinum | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
P14538401 | 14538401 | 14538401 Bright Chrome | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  | Non Locking
P14818501 | 14818501 | 14818501 [NAME] | 360 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 360 | 360 | 0 | 1 | 12
P13015701 | 13015701 | 13015701 Shadow | -560 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -560 | -560 | 0 | 1
P13015501 | 13015501 | 13015501 [NAME] | 400 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 400 | 400 | 0 | 1
P68931921 | 68931921 | 68931921 Platinum | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
P14469701 | 14469701 | 14469701 Bright Chrome | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200 | 200 | 0 | 1
 |  |  | 0
 |  | LHL Locking | 0
P14818201 | 14818201 | 14818201 [NAME] | -40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -40 | -40 | 0 | 1 | 52
P13015201 | 13015201 | 13015201 Shadow | -40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -40 | -40 | 0 | 1
P13015101 | 13015101 | 13015101 [NAME] | -40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -40 | -40 | 0 | 1 | 14
P68931923 | 68931923 | 68931923 Platinum | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
P14258501 | 14258501 | 14258501 Bright Chrome | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  | RHL Locking
P14818401 | 14818401 | 14818401 Atlas | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
P13015401 | 13015401 | 13015401 Shadow | -80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -80 | -80 | 0 | 1
P13015301 | 13015301 | 13015301 [NAME] | -80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -80 | -80 | 0 | 1
P68931922 | 68931922 | 68931922 Platinum | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
P14258701 | 14258701 | 14258701 Bright Chrome | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  | TOTALS: | -2120 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -2320 | -2320 | 0 | 12
 |  | QTY CHECKED: | -2120 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -2120 |  |  |  | RFT
 |  | QTYOK PARTS: | -2120 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -2120 | -2120 |  |  | 1
 |  | QTY NOK PARTS: | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  | INSPECTOR:
 |  | Top 3 Defects:
 |  | Corrective Actions: