Spreadsheet: 47036d1245942874-vlookup-multiple-lines-value
Sheet: Comp Download

Manufacturer | Material No. | No. | Start Date | Failure | Failure Type | Defect Qty | Number | Result Date | Analysis Result | [NAME]. | [NAME] | Ident-Number | Return Date | Receipt Date / Component | Reference no. | Article No. | Artikelname | Kunde (Artikel) | Failure location | Production plant | Prod. date (YYYY/WW) | Internal remarks |  | Failure description of Article | History of the analysis | [NAME]. |  | Corrective actions | Corrective action date | 8D-Report | Reshipment Location | Plant | Bauteil-Zusatz | Component Failure Type |  | Failure Location result | Component Failure Location | Failure Position Result | Component Failure Position | Failure SubCode Result | Corrective Action code | Component Failure confirmed | Component Failure confirmed by | Component Failure caused by | Analysis Available | AnalyseIdent | QMPruefauftragsNr | BauteilausfallBestaetigtAE | BauteilausfallBestaetigtAQW | BauteilausfallBestaetigtKostal | BauteilausfallBestaetigtHersteller | BauteilausfallBestaetigtSonst | Year | Location | Datecode | Marking | Remarks |  | [NAME] | Total
x | 1 | 2 | 2009-03-31 00:00:00 | x | x | 1 | 3 | 2009-04-07 00:00:00 | The [NAME] was sent to the Kostal supplier [NAME] for analysis.  Electrical tests at room, hot and cold temperfatures could not confirm the failure.  The part will be returned for correlation testsing. | Stack, Paddy (IR-AQS) | [NAME], [NAME] () | 101736326 | 2009-03-19 00:00:00 | 2009-03-31 00:00:00 | 200970176  FA#90486 | 05075750 | Türsteuergerät |  | Field failure | IRAB | 200838 |  |  | [NAME] / not OK IC3 failure.Incorrect output switching which did not support central lock/unlock functions.Sent to supplier for analysis. |  | [NAME], [NAME] (7200 AQS) |  |  |  |  | ArvinMeritor [NAME]. z.o.o., Poland | 002 |  | Faulty / not OK |  | IC | IC | 3 | 3 |  |  | 0 |  | Kostal | 1 | 0 |  | 0 | 1 | 0 | 1 | 0 | 2009 | IRAB | 0835 | L9949 990TC VH MYS 99 835 |  |  | 0 | 5
x | 1 | 2 | 2009-04-08 00:00:00 | x | x | 1 | 3 |  | Analysis update due by 30/4/09 | Stack, Paddy (IR-AQS) | Quinn, [NAME] () | QTS3277966 | 2009-04-07 00:00:00 | 2009-04-08 00:00:00 |  | 05080590 | Türsteuergerät PQ35 |  | Field failure | IRAB | 200828 |  |  | [NAME] / not OK IC16 Defect . Send to supplier. |  | [NAME], [NAME] (7200 AQS) |  |  |  |  | SAS Automotive s.r.o. | 002 |  | Faulty / not OK |  |  | IC |  | 16 |  |  | 0 |  | customer | 1 | 0 |  | 0 | 1 | 0 | 1 | 0 | 2009 | IRAB | 0828 | ST e3 MYS VND5012AK 9900AXV3 828 |  |  | 0
x | 1 | 2 | 2009-03-31 00:00:00 | x | x | 1 | 3 | 2009-04-14 00:00:00 | The cable was sent to the Kostal supplier [NAME] for analysis.  After inspection, the damage could be seen.  They believe that  the terminal was  inserted into the connector the wrong way round first and then pulled out and inserted a second time. | Stack, Paddy (IR-AQS) | Sheehan, [NAME] () | X94594 | 2009-03-18 00:00:00 | 2009-04-01 00:00:00 | K- 070-09 | 10018073 |  |  | Field failure | IRAB | 200903 |  |  | PCB (Printed Circuit Board) Open Circuit / circuit interruption Fails LWS initialisation. Open circuit between MLK pin M706 and resistor R114 ( broken track ). PCB faulty . Sent to vendor. |  | Stack, Paddy (IR-AQS) |  | Elec and Eltec have already changed the high power spray nozzle from " Flat spray  nozzle "  to    " Full cone spray nozzle ".  This has proven to be effective.  28/4/08 | 28/4/08 |  | KARMANN RHEINE GMBH & CO. KG | 002 |  |  |  | PCB (Printed Circuit Board) | PCB (Printed Circuit Board) |  | 1 |  |  | 0 |  | manufacturer | 1 | 1 |  | 0 | 0 | 0 | 1 | 0 | 2009 | IRAB | 0803 | 4 803 ELEC-8  15423 0 01 |  |  | 0
x | 1 | 2 | 2009-01-13 00:00:00 | x | x | 1 | 3 | 2009-04-07 00:00:00 | The part was sent to the Kostal suppliers EBV and Freescale for analysis.  The failure was eventually confirmed in Freescale after some delays and clarifications.  The part was decapsulated and inspected.  A metal particle was seen between two metal track | [NAME], [NAME] (7200 AQS) | [NAME], [NAME] () | 480801313 | 2008-12-09 00:00:00 | 2009-01-13 00:00:00 | RMA#380043 CQI 418454A | 00602502 | Regenlichtsensor |  | Field failure | IRAB | 200835 |  |  | Capacitor SMD / C Faulty / not OK Incorrect voltage reading at pin 50 on controller ic1due to faulty capacitor at C42. Component fail C42. |  | [NAME], [NAME] (7200 AQS) |  |  |  |  | VALMET AUTOMOTIVE INC. | 002 |  | Faulty / not OK |  | Capacitor SMD / C | Capacitor SMD / C | 42 | 42 |  |  | 0 |  | Kostal | 1 | 1 |  | 0 | 1 | 0 | 1 | 0 | 2009 | IRAB | 0000 | NONE |  |  | 0
x | 1 | 2 | 2009-03-03 00:00:00 | x | x | 1 | 3 | 2009-03-24 00:00:00 | Part sent to [NAME] for analysis, Avnet could not find any problem the part will be sent on to Freescale.   result due wk 15/09 | [NAME], [NAME] (7200 AQS) | [NAME], [NAME] () | 070903916 | 2009-02-24 00:00:00 | 2009-03-02 00:00:00 |  | 00602502 | Regenlichtsensor |  | Field failure | IRAB | 200836 |  |  | Relay [NAME] / not OK Failed at bench test for the SRB test  for relay H. Intermittently passes after initial failure. Sent to vendor. |  | Stack, Paddy (IR-AQS) |  | This relay was produced in Hella Spain.  That production plant no longer produces this relay.  Production for this relay was moved to Hella USA in April 2008. |  |  | DAIMLER AG | 002 |  | Faulty / not OK |  | Relay contact | Relay |  | H |  |  | 0 |  | manufacturer | 0 | 1 |  | 0 | 0 | 0 | 1 | 0 | 2009 | IRAB | 0803 | 4RA 940 010-68     A 002 542 23 19   HELLA | Failed at bench test for the SRB test  for relay H. Intermittently passes after initial failure. Sent to vendor. 2009.IRAB.0084 |  | 0
XY | 1 | 2 | 2009-01-13 00:00:00 | x | x | 1 | 3 | 2009-02-23 00:00:00 | The part has been sent to the Kostal supplier Elec & ElteK for analysis.  Analysis show the the solderability problem was due to contamination. | [NAME], [NAME] (7200 AQS) | Marnell, [NAME] (AQW) | No1 | 2008-12-11 00:00:00 | 2009-01-13 00:00:00 |  | 05022705 | Sitz-SG .DC_W203 FS |  | Field failure | IRMA | 200840 |  |  | [NAME] / not OK Cannot read/write from external Eeprom device.Short circuit across pins 1 & 4 on device (75 ohms ). Componenf fail ic6. |  | Stack, Paddy (IR-AQS) |  | EOS. |  |  | DAIMLER AG | 002 |  | Faulty / not OK |  | IC | IC | 6 | 6 |  |  | 0 |  | customer | 1 | 1 |  | 0 | 0 | 0 | 1 | 0 | 2009 | IRAB | 0822 | 95160WP   K822S |  |  | 1
XY | 1 | 2 | 2009-03-09 00:00:00 | x | x | 1 | 3 | 2009-04-07 00:00:00 | The PCB was sent to the Kostal supplier Elec and Eltec for analysis.  After inspection, Elec and [NAME] could see the broken copper line.  After further analysis they deduced the root cause.  Dry film residue stuck to the PCB during during high pressure ri | [NAME], [NAME] (7200 AQS) | Marnell, [NAME] (AQW) | 54580 | 2009-03-02 00:00:00 | 2009-03-04 00:00:00 | KOS01-0903-02 | 05114410 | [NAME] | Audi - Ingolstadt | 0-Km | IRAB | 200848 |  |  | PCB (Printed Circuit Board) Faulty / not OK Soldering defect at pin4 on Relay K4 results intermittent contact with PCB pad due to contamination around PCB pad. PCB faulty. |  |  |  |  |  | 57280 | FAW-VW, FAW-VW | 002 |  | Faulty / not OK |  |  | PCB (Printed Circuit Board) |  | 1 |  |  | 0 |  |  | 0 | 1 |  | 0 | 0 | 0 | 0 | 0 | 2009 | IRAB | 0722 | 73550 0 01   2  722  YY-0194V |  |  | 2
XY | 1 | 2 | 2009-03-24 00:00:00 | x | x | 1 | 3 | 2009-04-17 00:00:00 | The PCB was  sent to the supplier Elec and Eltec for analysis.  Electrical tests could not confirm the failure.  The suspect via's were cross sectioned.  No anomalie that could explain an open circuit could be seen.  The failure is not confirmed. | Stack, Paddy (IR-AQS) | Quinn, [NAME] () | BK 000328 | 2009-03-23 00:00:00 | 2009-03-23 00:00:00 | KOS01-0903-03 | 05075750 | Türsteuergerät |  | Field failure | IRAB | 200823 |  |  | I |  | Stack, Paddy (IR-AQS) |  |  |  |  | DAIMLER AG | 002 |  | Faulty / not OK |  |  | IC |  | 28 |  |  | 0 |  |  | 0 | 3 | 1 | 0 | 1 | 0 | 1 | 0 | 2009 | IRAB | 0833 | VND810  90F9833 |  |  | 3
XY | 1 | 2 | 2009-03-30 00:00:00 | x | x | 1 | 3 |  |  | Stack, Paddy (IR-AQS) | Marnell, [NAME] (AQW) |  | 2009-03-09 00:00:00 | 2009-03-25 00:00:00 |  | 05022705 | Sitz-SG .DC_W203 FS |  | 0-Km | IRAB | 200843 |  |  | [NAME] / not OK Fails left indicator . Output pins 7- 12 pulled low on driver ic after input pin3 is activated. Component fail ic11. |  | Stack, Paddy (IR-AQS) |  |  |  |  | Daimler AG WERK BREMEN | 002 |  | Faulty / not OK |  |  | IC |  | 11 |  |  | 0 |  |  | 0 | 2 |  | 0 | 0 | 0 | 0 | 0 | 2009 | IRAB | 0819 | VN5050J  EZ819 |  |  | 4
XY | 1 | 2 | 2009-02-24 00:00:00 | x | x | 1 | 3 | 2009-03-10 00:00:00 | The part was sent to the Kostal supplier Elec & Eltek for analysis.  The part was sectioned and no problem could be seen. | [NAME], [NAME] (7200 AQS) | Marnell, [NAME] (AQW) | 380803036 | 2008-10-29 00:00:00 | 2009-02-25 00:00:00 |  | 05022184 |  |  | Field failure | IRAB | 200734 |  |  |  |  |  |  |  |  | 56515 | Jaguar Cars Limited, Jaguar Cars Limited |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 2009 | IRAB | 0825 | [PHONE]  825   2 |  |  | 5