Spreadsheet: 136334d1326547489-excel-2007-sumifs-not-working-completely-sumifs-help
Sheet: DeliveryIssues

Delivery |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December
Date | MonthNum | Week# | Month | SQDCM | ISSUE | Area | Location | Line Location (if applicable) | Shift | Associate | Associate # | Supervisor | Team Leader | Reported By | Reporting Organization | Downtime - Reason | Downtime - Cause | Line | Part # | Part Name | Downtime(Seconds) | Downtime Target (Weekly) | Lots affected | PPP - Total # | PPP - Downtime (Minutes) | Lots Affected2 | 4 Box | PPP - Countermeasure |  |  |  | 1st | 2nd
2011-11-04 00:00:00 |  |  |  | Delivery | AF Calls | MMC | H 14 | E22R | 2nd | [NAME] | 20633 | Chad Ridenbaugh | [NAME] | Pam Jones | HAM | Cart bumped into Engine on [NAME] | Delivery train going down aisle bumped blue cardboard cart, knocking it into another cart, which got pushed into an engine on the line |  |  |  | 0 | 180 |  |  |  |  |  |  |  |  |  | Downtime | Downtime | PPP | PPP
2011-11-08 00:00:00 |  |  |  | Delivery | Downtime | Main/Body |  | 230R Line 1 | 1st | [NAME] |  | [NAME] | [NAME] | AF TL | HAM | Wrong Parts Delivered | Associate overlooked single digit in part number |  |  |  | 81 |  |  |  |  |  |  |  |  |  | IOD
2011-11-08 00:00:00 |  |  |  | Delivery | Downtime | Main/Body |  | 230R Line 1 | 1st | [NAME] |  | [NAME] | [NAME] | AF TL | HAM | Parts Delivered to Wrong Location | Parts needed were delivered to overflow area, due to 4 racks being in Delivery Location;Parts Delivered to overflow area for Line 1 |  |  |  | 71 |  |  |  |  |  |  |  |  |  | MMC
2011-11-10 00:00:00 |  |  |  | Delivery | Downtime | Exhaust | [NAME] | Exhaust | 1st | [NAME] |  | [NAME] |  |  |  | Wrong Lot # Delivered | Delivery associate didn't check Lot/Part # prior to Delivery. |  |  |  | 109 |  |  |  |  |  |  |  |  |  | Main/Body
2011-11-14 00:00:00 |  |  |  | Delivery | AF Calls | Main/Body | Main/Body | 231R | 2nd | [NAME] |  |  |  |  | HAM | [NAME] | 74220 TA0 |  | 74220 TA0 |  | 0 | 180 |  |  |  |  |  |  |  |  | Exhaust
2011-11-14 00:00:00 |  |  |  | Delivery | AF Calls | Main/Body | Main/Body | 192R | 2nd | [NAME] |  |  |  |  | HAM | Parts Not Delivered | 18210 TA4 |  | 18210 TA4 |  | 0 | 180 |  |  |  |  |  |  |  |  | West Dock
2011-11-14 00:00:00 |  |  |  | Delivery | AF Calls | MMC | IOD | 104L | 2nd | [NAME] |  |  | [NAME] | AF TL | HAM | Sideliner delivery | 83780 TE0 A040 M1 (Line 2) |  | 83780 TE0 A040 M1 |  | 0 | 180 |  |  |  |  |  |  |  |  | North Dock
2011-11-15 00:00:00 |  |  |  | Delivery | AF Calls | Main/Body | Main/Body | 193L | 2nd | [NAME] |  |  |  | Deb | HAM | Parts missing | 1803H STK A200 |  | 1803H STK A200 |  | 0 | 180
2011-11-15 00:00:00 |  |  |  | Delivery | AF Calls | Main/Body | Main/Body | 193R | 2nd | [NAME] |  |  |  | Danielle | HAM | Parts not delivered | 18210 TE1 A110 |  | 18210 TE1 A110 |  | 0 | 180
2011-11-15 00:00:00 |  |  |  | Delivery | AF Calls | Main/Body | Main/Body | 223R | 2nd | [NAME] |  |  |  | Danielle | HAM | Parts Not Delivered | 84540: Parts were en route at time of call |  | 84540 |  | 0 | 180
2011-11-15 00:00:00 |  |  |  | Delivery | AF Calls | Main/Body | Main/Body | 276L | 2nd | [NAME] |  |  |  | Jeanette | HAM | Parts not delivered | 73550 |  | 73550 |  | 0 | 180
2011-11-16 00:00:00 |  |  |  | Delivery | Downtime | Main/Body | Line 2 Sub Area | Line 2 Sub Area | 1st | [NAME] |  | [NAME] | [NAME] | AF | HAM | Parts Not Delivered | 53600 TA5 Y010 M1 not delivered due to being sent to break early |  | 53600 TA5 Y010 |  | 390 |  |  |  |  |  | ..\..\Problem Summaries CLC\88 KI\November\Aaron Neitz 11-16-11.xls
2011-11-16 00:00:00 |  |  |  | Delivery | Downtime | West Dock |  | W07R | 1st | [NAME] |  | Shane Burd | [NAME] | AF TL | HAM | Parts Not Delivered | Appropriate part # not verified for current Lot |  |  |  | 41
2011-11-16 00:00:00 |  |  |  | Delivery | # PPP | West Dock | West Body | 038L Line 1 | 1st |  |  | Shane Burd | [NAME] | AF TL | HAM | Parts were mistakenly pulled off of line as an empty rack | Parts ultimately got loaded on an RCC trailer bound back to MEI, and hand to be redirected back to MAP for unload and re-delivery. |  |  |  | 0 |  |  | 38 |  |  |  | Associate counseled
2011-11-16 00:00:00 |  |  |  | Delivery | AF Calls | Main/Body | Main/Body | G12L | 2nd | [NAME] |  |  |  |  | HAM | Short 1 part | Short 1 pc 73200 TA5 |  | 73200 TA5 |  | 0 | 180
2011-11-16 00:00:00 |  |  |  | Delivery | AF Calls | Main/Body | Main/Body | O70R | 2nd | [NAME] |  |  |  |  | HAM | Excessive empties on line | There were 8 Empties reported on the line |  |  |  | 0 | 180
2011-11-16 00:00:00 |  |  |  | Delivery | AF Calls | MMC | MMC | [NAME] | 2nd |  |  |  | [NAME] |  | HAM | Parts Not Delivered | 36542/36532 |  | 36542 |  | 0 | 180
2011-11-21 00:00:00 |  |  |  | Delivery | AF Calls | MMC | MMC |  | 2nd | [NAME] |  |  | [NAME] | MEI T/L | MEI | [NAME] |  | 2 | 77320 |  | 0 | 180
2011-11-22 00:00:00 |  |  |  | Delivery | Downtime | MMC | Inpanel Sub Area |  | 2nd | [NAME], [NAME], [NAME], [NAME] |  | Chad Ridenbaugh | [NAME] | MEI Associate | MEI | Parts Not Delivered | Parts were unloaded and mixed with another model type.  Wasn't caught until delivery associate made delivery and verified check sheet. |  |  |  | 235 | 180 | 2-213/214
2011-11-22 00:00:00 |  |  |  | Delivery | Downtime | MMC | Inpanel Sub Area |  | 2nd | [NAME] |  | Chad Ridenbaugh | [NAME] | MAP Associate | HAM | Parts Not Delivered | Lot should have been last lot delivered on 1st shift, therefore causing the lot to not be delivered on time. |  |  |  | 46 | 180 | 2-307/308
2011-11-28 00:00:00 |  |  |  | Delivery | Downtime | IOD | Suspension |  | 2nd | [NAME]; [NAME] | 20604; 20632 | Chad Ridenbaugh | [NAME] | Inpanel Associate | HAM | Parts Not Delivered | Associate delivered the wrong gear boxes; 53600 TA5 A010; Parts needed were 53600 TA5 Y010 |  | 53600 TA5 Y010 |  | 397 | 180 | 2-353/354 |  |  |  | ..\..\Problem Summaries CLC\88 KI\November\Sub Line Downtime for Gearbox 11-28-2011.xlsx
2011-11-28 00:00:00 |  |  |  | Delivery | AF Calls | Main/Body | Main/Body |  | 2nd | [NAME] |  |  | [NAME] | MEI T/L | MEi | [NAME] |  | 2 | 53600 TA5 Y010 | Gearbox | 0 | 180
2011-11-29 00:00:00 |  |  |  | Delivery | # PPP | East Dock | MMC | 107R Line 2 | 2nd | [NAME] | C35134 | Chad Ridenbaugh |  | [NAME] | HAM | Parts were delivered to WRONG location | Investigation pending parts delivery to wrong location on 1st shift |  |  |  | 0 | 180 | 2-373/374 | 2
2011-11-29 00:00:00 |  |  |  | Delivery | # PPP | East Dock |  | 249R Line 2 | 2nd | [NAME] | 840696 | Chad Ridenbaugh |  | MEI T/L | MEI | Parts were delivered to wrong location | Associate delivered 73162 TE0 A010 M1 instead of 73152 TE0 A010 M1 |  | 73152 TE0 A010 M1 |  | 0 | 180 |  | 10
2011-11-30 00:00:00 |  |  |  | Delivery | Downtime | West Dock | West Body | G53 | 2nd | [NAME]; [NAME] |  | [NAME] |  | MAP Associate | HAM | Wrong Parts Delivered | Devanning associate placed wrong parts on cart for delivery, and delivery associate delivered wrong parts to line. |  |  |  | 73 | 180
2011-12-02 00:00:00 |  |  |  | Delivery | Downtime | Main/Body |  | 089L Line 1 | 2nd | [NAME] | 20664 | Chad Ridenbaugh |  | AF | HAM | Parts Not Delivered | 84525 STK A000; 84575 STK A000 |  | 84525 STK A000 |  | 332 | 180 |  | 15 |  |  |  | Associate counseled
2011-12-06 00:00:00 |  |  |  | Delivery | Downtime | MMC | Main/Body |  | 1st | [NAME] |  | [NAME] |  | AF | HAM | Parts Delivered to Wrong Location | Line 2 Body parts were delivered to Line 1 area | 2 | Multiple |  | 919 |  |  |  |  |  | ..\..\Problem Summaries CLC\88 KI\December\Nathan Penhorwood 12-6-11.xls
2011-12-06 00:00:00 |  |  |  | Delivery | Downtime | MMC |  | 273R | 2nd | [NAME] | 18380 | Chad Ridenbaugh |  | AF | HAM | Parts Not Delivered | Train containing parts was late due to traffic | 2 | 8325A TA5 A200 |  | 235 | 180 |  |  |  |  | ..\..\Problem Summaries CLC\88 KI\December\235 secs DT to AF.xlsx
2011-12-07 00:00:00 |  |  |  | Delivery | # PPP | Main/Body |  | 292R Line 1 | 1st |  |  | [NAME] | [NAME] | AF TL | HAM | [NAME] | Parts were returned to RCC staging area. | 1 | 84400 STK A015 M1 (NH690L) |  | 0 |  |  | 30 |  |  | ..\..\Problem Summaries CLC\88 KI\December\84400-stk-a015-m1 12-7-11.xls
2011-12-09 00:00:00 |  |  |  | Delivery | Downtime | MMC |  |  | 1st |  |  | [NAME] | [NAME] | AF | HAM | Parts Not Delivered | 36 of required 60 parts were delivered; delivery associate noticed what "appeared" to be 24 of the same part line side, thinking they had enough, they didn't deliver the remaining parts. |  |  |  | 1564 |  |  |  |  |  | ..\..\Problem Summaries CLC\88 [NAME] 12-9-11.xls
2011-12-09 00:00:00 |  |  |  | Delivery | Downtime | IOD |  | 70R | 2nd | [NAME] |  | Chad Ridenbaugh | [NAME] | AF | HAM | [NAME] | Parts were being returned to IOD RCC by delivery associate | 2 | 7902A TA5 Z702 |  | 140 | 180 | 2-593/594 |  |  |  | ..\..\Problem Summaries CLC\88 KI\December\AF 140 secs DT return Parts.xlsx
2011-12-09 00:00:00 |  |  | December | Delivery | # PPP | West Dock |  |  | 2nd |  |  | [NAME] |  | AF TL | HAM | [NAME] | Parts were found on RCC trailer, and returned to the line. | 2 | 76200 TA5 A110 M1 | Left Side Mirror | 0 | 180 |  | 18 |  | 2-581/582 | ..\..\Problem Summaries CLC\88 KI\December\Left Side Mirrors 18 PPP 20111209.xls
2011-12-13 00:00:00 |  |  |  | Delivery | # PPP | MMC | MMC |  | 1st |  |  | [NAME] | [NAME] | AF | HAM | Short Parts | Parts were ultimately found line side | 1 | 81234 TA0 A710 M1 |  | 0 |  |  | 15 |  |  | ..\..\Problem Summaries CLC\88 [NAME]
2011-12-13 00:00:00 |  |  |  | Delivery | Downtime | Exhaust |  |  | 1st | AF Exhaust Line 2 Associate |  |  |  | MAP Associate | HAM | Part damaged | Damaged part found after installation, causing part to be removed, and new part installed | 2 | 1830H TA5 A101 | Silencer, Exhaust Sub Assy | 83 |  |  |  |  |  | ..\..\Problem Summaries CLC\88 [NAME] 121311.xls
2011-12-13 00:00:00 |  |  |  | Delivery | Downtime | MMC | MMC |  | 2nd | [NAME] | EP549322 | Chad Ridenbaugh | [NAME] | AF TL | HAM | Parts Not Delivered | Train was delivered to the wrong line | 1 | Multiple |  | 177 | 180 |  |  |  |  | ..\..\Problem Summaries CLC\88 KI\December\AF Downtime 12-12.xlsx
2011-12-13 00:00:00 |  |  |  | Delivery | Downtime | West Dock | West Body | 118L Line 2 | 2nd | [NAME] |  | [NAME] | [NAME] | AF TL | HAM | Parts Delivered to Wrong Location | Parts were moved by AF associates to wrong locations as a result of congestion. | 2 | 33500 STK A200 XA | Tail light | 59 | 180 |  |  |  |  | ..\..\Problem Summaries CLC\88 KI\December\Switched taillights [NAME]
2011-12-13 00:00:00 |  |  |  | Delivery | Downtime | Main/Body | Inpanel Sub Area | I24L | 2nd | [NAME] | 20790 | Chad Ridenbaugh | [NAME] | MAP Associate | HAM | Wrong Parts Delivered | The wrong parts were delivered to the Inpanel Sub Area causing an "unknown" amount of downtime. Estimated at 11 min. Actual impact under investigation | 1 | 53200 TK4 A020 M1 |  | 660 | 180 | 1-65/66 |  |  |  | ..\..\Problem Summaries CLC\88 KI\December\Inpanel Sub-Line DT.xlsx
2011-12-15 00:00:00 |  |  |  | Delivery | Downtime | MMC | Line 1 Body | 151L | 1st | [NAME] |  | [NAME] | [NAME] | AF TL | HAM | Parts Not Delivered | Parts were returned to MMC | 1 | 74151 STK A000 |  | 63 |  |  |  |  |  | ..\..\Problem Summaries CLC\88 KI\December\Camron -Dan [NAME] 12-15-11.xls
2011-12-15 00:00:00 |  |  |  | Delivery | Downtime | West Dock |  | W13L Line 2 | 1st | [NAME] munafo |  | Shane Burd | [NAME] | AF TL | HAM | Parts Not Delivered | Parts weren't delivered due to a shortage of carts | 2 | 74195 TA1 A010 | Bonnet Dampers | 46
2011-12-15 00:00:00 |  |  |  | Delivery | Downtime | North Dock | Line 1 Front Door subline |  | 2nd | [NAME] |  | [NAME] | [NAME] | AF TL | HAM | Wrong Parts Delivered | Parts were delivered to the line in the wrong order | 1 | 72482 TK4 A020 M1 |  | 262 | 180 |  |  |  |  | ..\..\Problem Summaries CLC\88 KI\December\Front Door Garnish Downtime 262 secs 20111215.xls
2011-12-15 00:00:00 |  |  |  | Delivery | Downtime | North Dock | Line 1 Front Door subline |  | 2nd | [NAME] |  | [NAME] | [NAME] | AF TL | HAM | Wrong Lot # Delivered | [NAME] (119-120) was delivered lineside when next lot was 117-118 | 1 | 72482 TK4 A020 M1 | Garnish | 262 | 180 | 1-117/118 |  |  |  | ..\..\Problem Summaries CLC\88 KI\December\Front Door Garnish Downtime 262 secs 20111215.xls
2011-12-16 00:00:00 |  |  |  | Delivery | Downtime | West Dock | West Body | [NAME] | 2nd | [NAME]; [NAME] |  | [NAME] | [NAME] | AF TL | HAM | Parts Not Delivered | Fuel tank straps were not delivered lineside in time. | 1 | 17521 TK5 A000 | Fuel Tank Straps | 306 | 180 |  |  |  |  | ..\..\Problem Summaries CLC\88 KI\December\Fuel Tank Straps 306 secs downtime.xls
2011-12-20 00:00:00 |  |  |  | Delivery | Downtime | West Dock | West Body | G54 | 2nd | Shauna Lusby |  | [NAME] | [NAME] | AF TL | HAM | Parts Late to the Line | Paint dropped 12-15 cars, causing the delivery of the next lot to actually arrive later than what AF truly needed. | 2 | 1900A R40 A630 | Radiators | 27 | 180 |  |  |  |  | ..\..\Problem Summaries CLC\88 KI\December\Radiator Downtime 27 secs 20111220.xls
2011-12-21 00:00:00 |  |  |  | Delivery | Downtime | West Dock | West Body | 038R | 2nd | [NAME] |  | [NAME] | [NAME] | AF TL | HAM | Parts Not Delivered | Parts were not delivered and returned to 2A on shuttle. | 2 | 39820 TE0 A010 M1 | Pioneer Unit Assy | 28 |  |  | 39 |  |  | ..\..\Problem Summaries CLC\88 KI\December\Missing Pioneer Unit Assembly 20111221.xls
2011-12-23 00:00:00 |  |  |  | Delivery | # PPP | Main/Body | Main/Body | 129L | 1st | [NAME] | 24012/24024 | [NAME] | [NAME] | AF TL | HAM | Parts Not Delivered | Parts came in on 2 different trailers due to Purchasing Issue | 1 | 71800 TK4 A000 M1 | Side sill | 0 |  |  | 18 |  |  | ..\..\Problem Summaries CLC\88 [NAME]
2011-12-23 00:00:00 |  |  |  | Delivery | Downtime | Main/Body | Main/Body |  | 2nd | [NAME] | 20381 | Chad Ridenbaugh | [NAME] | Delivery Associate | MEI | Parts Not Delivered | Parts were not set up properly | 1 | 5020A TK5 A003 |  | 340 | 180 | 1-309/310 |  |  |  | ..\..\Problem Summaries CLC\88 KI\December\AF Downtime 12-23  340 secs.xlsx
2011-12-23 00:00:00 |  |  |  | Delivery | Downtime | Main/Body | Main/Body | 285R | 2nd | [NAME] | 20406 | Chad Ridenbaugh | [NAME] | AF TL | HAM | Wrong Parts Delivered | Parts were pulled wrong by the Set Up associate | 1 | 78500 TA5 A510 M1 | Steering Wheel | 45 | 180 | 1-277/278 |  |  |  | ..\..\Problem Summaries CLC\88 KI\December\AF Downtime 12-23  45 secs.xlsx
2011-12-23 00:00:00 |  |  |  | Delivery | Downtime | Main/Body | Main/Body | E34R | 2nd | [NAME] | 763383 | Chad Ridenbaugh | [NAME] | Line TL | HAM | Parts Delivered to Wrong Location | Parts were delivered to the wrong side of the line | 1 | 51271 TA0 A010 |  | 720 | 180 |  |  |  |  | ..\..\Problem Summaries CLC\88 KI\December\Engine Sub Line Downtime 12-23-2011.xlsx
2012-01-11 00:00:00 |  |  |  | Delivery | Downtime | West Dock | West Body | 022R | 2nd | [NAME] |  | [NAME] | [NAME] | AF TL | HAM | Parts Not Delivered | Parts were never shipped from 2A; this mis-shipment wasn't caught by devanning/setup associate or Delivery associate on their respective checksheets. | 2 | 4600A TA5 A200 | Master Power | 903 | 180 |  |  |  |  | ..\..\Problem Summaries CLC\88 KI\January\line down 15 mins 20120111.xls
2012-01-11 00:00:00 |  |  |  | Delivery | Downtime | Main/Body | Inpanel Sub Area | I24L | 2nd | Shdawn Cramer | 823915 | Chad Ridenbaugh | [NAME] | Inpanel TL | HAM | Wrong Lot # Delivered | Delivery Associate delivered the wrong Lot# | 2 | Multiple |  | 305 | 180 | 2-453/454