Spreadsheet: 686653d1594737204-calculation-of-inspection-frequency-based-on-number-of-good-lots-inspected-qc1778-fqa-tracker-rev-001
Sheet: References

Part number (4 digits) | Family (standard format) | Customer | GP | Bartec collapsing | 100% SOP
1622 | CAM-BMW Gesture | BMW | BP | Bent connector | Normal Inspection Level 2
1862 | BMW FZV Legacy | BMW |  | [NAME] pins | Reduced Inspection Level 3
1866 | Legacy |  |  | Bezel not on properly | 100% Inspection
2909 | Legacy |  |  | Blue connector not fitted properly
3507 | CAM-BMW Gesture | BMW |  | Bracket on incorrectly
4681 | CAM-BMW Gesture | BMW |  | Broken clip on bracket
5405 | EWS4 Legacy |  |  | Coating
5731 | CAM-JLR-RVC | JLR |  | Contamination in connector
7343 | CAM-BMW-iCAM-SAT | BMW |  | Contamination inside lens
7347 | CAM-JLR Legacy | JLR |  | Cracked lens
7348 | CAM-BMW-iCAM-SAT | BMW |  | Damaged A surface
7353 | CAM-BMW-iCAM-RFK | BMW |  | Damaged back housing
7356 | CAM-BMW-iCAM-RFK | BMW |  | Damaged bartec
7372 | CAM-DAI-SVS Parkman | Daimler |  | Damaged blue connector
7373 | CAM-DAI-SVS Parkman | Daimler |  | Damaged bracket
7374 | CAM-DAI-SVS Parkman | Daimler |  | Damaged connector
7376 | CAM-DAI-SVS Parkman | Daimler |  | Damaged front housing
7377 | CAM-DAI-Parkman HSD DC | Daimler |  | Damaged grommet
7397 | CAM-DAI-RVC3 | Daimler |  | Damaged pigtail cage
7398 | CAM-DAI-RVC3 | Daimler |  | Damaged pillar
7401 | CAM-DAI-RVC3 | Daimler |  | Damaged plastic connector
7405 | CAM-DAI-RVC3 Star 1 | Daimler |  | Dip in bartec
7406 | CAM-DAI-RVC3 Star 1 | Daimler |  | Double [NAME] vent
7407 | CAM-DAI-RVC3 Star 1 | Daimler |  | Exposed seal
7408 | CAM-DAI-RVC3 Star 1 | Daimler |  | Exposed wire / copper
7409 | CAM-DAI-RVC3 Star 1 | Daimler |  | Extra labels attached
8057 | CAM-DAI-RVC3 | Daimler |  | Fail label on camera
8060 | CAM-VCC PAC360 | Volvo |  | Fell on floor
8063 | CAM-DAI-RVC3 | Daimler |  | FT label damaged
8066 | CAM-DAI-RVC2 | Daimler |  | FT label missing
8098 | CAM-BMW-iCAM-RFK | BMW |  | FT label peeling off
8105 | CAM-VCC Standalone | Volvo |  | FT label print missing
8108 | CAM-VCC Standalone | Volvo |  | Gap between housings
8112 | CAM-DAI-SVS Parkman | Daimler |  | Glue bead issue
8145 | CAM-DAI-RVC2 | Daimler |  | Glue on housing
8182 | CAM-DAI-SVS Parkman | Daimler |  | Glue on lens
8232 | CAM-VCC Legacy | Volvo |  | [NAME] vent damaged
8271 | CAM-JLR Legacy | JLR |  | [NAME] vent missing
8306 | CAM-JLR Legacy | JLR |  | [NAME] vent not placed correctly
8330 | CAM-BMW-TRSVC | BMW |  | Green sticker on housing
8331 | CAM-BMW-TRSVC | BMW |  | [NAME] / scratch on lens
8332 | CAM-BMW-TRSVC | BMW |  | Mark inside lens
8333 | CAM-BMW-TRSVC | BMW |  | Mark on housing
8342 | CAM-JLR Legacy | JLR |  | Missing bezel
8390 | CAM-JLR Legacy | JLR |  | Missing screw
8457 | CAM-JLR Legacy | JLR |  | Missing spacer
8466 | CAM-PSA | PSA |  | Missing tape on pigtail
8467 | CAM-PSA | PSA |  | Mixed hosuing in batch
8499 | CAM-VW AV1 LEG | VW |  | OTHER
8561 | CAM-JLR-Gen2 BL | JLR |  | Paint on the connector
8569 | CAM-DAI-RVC2 | Daimler |  | Part at wrong step
8571 | CAM-PSA | PSA |  | Raised black connector
8598 | CAM-JLR-Gen1 | JLR |  | Raised housing
8626 | CAM-PSA | PSA |  | Raised screw
8650 | CAM-JLR-Gen2 BL | JLR |  | Seal missing
8680 | CAM-DAI-RVC2 | Daimler |  | Seal sucked in
8681 | CAM-DAI-RVC2 | Daimler |  | Tap test dot missing
8684 | CAM-VCC PAC360 | Volvo |  | Washer missing
8753 | CAM-JLR-Gen2 BL | JLR |  | Wrong back housing
8754 | CAM-JLR-Gen2 BL | JLR |  | Wrong housing
8758 | CAM-JLR-Gen2 BL | JLR |  | Wrong Q level on FT label
8765 | CAM-REN | Renault |  | Wrong screw
8823 | CAM-JLR-Gen2 BL | JLR |  | Part missing in the batch
8825 | CAM-JLR-Gen2 BL | JLR |  | Foil between seal and housing
8828 | CAM-JLR-Gen2 BL | JLR
8829 | CAM-JLR-Gen2 BL | JLR
8832 | CAM-JLR -I2C | JLR
8918 | CAM-JLR-Gen2 BL | JLR
8919 | CAM-JLR-Gen2 BL | JLR
8920 | CAM-JLR-Gen2 BL | JLR
8924 | CAM-JLR Legacy | JLR
8927 | CAM-JLR Legacy | JLR
8949 | CAM-VCC Standalone | Volvo
8962 | CAM-JLR -I2C | JLR
8993 | CAM-DAI-Parkman HSD DC | Daimler
9004 | CAM-DAI-Parkman HSD DC | Daimler
9009 | CAM-JLR-Gen2 SVS | JLR
9135 | CAM-DAI-SVS Parkman | Daimler
9604 | CAM-VCC PAC360 | Volvo
9863 | CAM-VCC Standalone | Volvo
9865 | CAM-JLR -I2C | JLR
8925 | CAM-JLR-Gen2 BL | JLR
9173 | CAM-DAI-SVS Parkman | Daimler
8155 | CAM-GM-2MP SatCam | GM