Spreadsheet: 81991d1282071065-only-one-entry-per-month-in-pivot-table-performance-revised
Sheet: Data

Incident | Date | ID | Cause | Delay Code | Manager | Comm | Incident Location | Cost | Delays | Month | Delay Cause
186701 | 2010-07-29 00:00:00 | 6E31 | 148 OVERTIME ACTONTC | T | FPEB | B | [NAME] | 101.16 | 3 | 2010-07-29 00:00:00 | Terminal
183982 | 2010-07-28 00:00:00 | 6E40 | [NAME] | T | APEB | B |  | 2158.08 | 64 | 2010-07-28 00:00:00 | Terminal
180212 | 2010-07-26 00:00:00 | 4M02 | 3 LOST FRSTGTJ - SRA (L2) | S | FPEC | C | FOREST GATE JN | 101.16 | 3 | 2010-07-26 00:00:00 | Lost Time
182845 | 2010-07-27 00:00:00 | 4G77 | LATE START KNGSBCG | T | FPEC | C |  | 101.16 | 3 | 2010-07-27 00:00:00 | Terminal
186631 | 2010-07-29 00:00:00 | 4M23 | 2 LATE BY SRA | S | FPEC | C | BOW JN. | 101.16 | 3 | 2010-07-29 00:00:00 | Lost Time
191114 | 2010-07-31 00:00:00 | 4L02 | 5 MINS TIMELOSS MKT - COL | S | FPEC | C | [NAME] | 101.16 | 3 | 2010-07-31 00:00:00 | Lost Time
190209 | 2010-07-30 00:00:00 | 4L22 | 4 LOST COL-MNG | S | FPEC | C | COLCHESTER | 134.88 | 4 | 2010-07-30 00:00:00 | Lost Time
179295 | 2010-07-26 00:00:00 | 4L78 | [NAME] | L | MPEC | C | DONCASTER | 168.6 | 5 | 2010-07-26 00:00:00 | Locomotive
188794 | 2010-07-30 00:00:00 | 0Z66 | LATE START HMSHBRF | T | FPEC | C | HAMS HALL NDP (GBRF) | 168.6 | 5 | 2010-07-30 00:00:00 | Terminal
180376 | 2010-07-26 00:00:00 | 4L35 | EARLY DONCLCJ | T | APEC | C | DONCASTER | 202.32 | 6 | 2010-07-26 00:00:00 | Terminal
181166 | 2010-07-27 00:00:00 | 4M21 | 4-LOST WMB-WFJ | S | FPEC | C | WILLESDEN WEST LONDN JN | 202.32 | 6 | 2010-07-27 00:00:00 | Lost Time
181914 | 2010-07-27 00:00:00 | 4M23 | 3 LOST CHM - SRA (L2) | S | FPEC | C | FOREST GATE JN | 202.32 | 6 | 2010-07-27 00:00:00 | Lost Time
190120 | 2010-07-30 00:00:00 | 4M02 | 3 LOST CMD XWI | S | FPEC | C | CAMDEN ROAD | 202.32 | 6 | 2010-07-30 00:00:00 | Lost Time
182651 | 2010-07-27 00:00:00 | 4L22 | 2 LOST FRSTGTJ - IFD | S | FPEC | C | FOREST GATE JN | 337.2 | 10 | 2010-07-27 00:00:00 | Lost Time
180312 | 2010-07-26 00:00:00 | 4L22 | 8 LOST COL - IPS | S | FPEC | C | COLCHESTER | 370.92 | 11 | 2010-07-26 00:00:00 | Lost Time
187150 | 2010-07-29 00:00:00 | 4M02 | SLOW RUNNING > TRM | S | FPEC | C | FELIXSTOWE NORTH DOCKS | 1045.32 | 31 | 2010-07-29 00:00:00 | Lost Time
183591 | 2010-07-28 00:00:00 | 4M21 | 5-LOST XWI-HRW | S | FPEC | C | WILLESDEN WEST LONDN JN | 1955.76 | 58 | 2010-07-28 00:00:00 | Lost Time
188250 | 2010-07-30 00:00:00 | 4R51 | 23 BREAKDOWN EGBRGBF | T | APEF | F |  | 101.16 | 3 | 2010-07-30 00:00:00 | Terminal
183757 | 2010-07-28 00:00:00 | 6C31 | STOPPED SHORT DON | C | FPEF | F | DONCASTER | 539.52 | 16 | 2010-07-28 00:00:00 | Traincrew
185853 | 2010-07-29 00:00:00 | 4R51 | WTG ACC KNTNGEJ-SHFTHLJ | T | APEF | F | KNOTTINGLEY EAST JN | 640.68 | 19 | 2010-07-29 00:00:00 | Terminal
179419 | 2010-07-26 00:00:00 | 0N31 | LATE START NBLYGBF | T | FPEF | F |  | 1213.92 | 36 | 2010-07-26 00:00:00 | Terminal
179354 | 2010-07-26 00:00:00 | 6S45 | TRAFFIC NBLYGBF | T | APEF | F | NORTH BLYTH ALCAN | 3001.08 | 89 | 2010-07-26 00:00:00 | Terminal
179442 | 2010-07-26 00:00:00 | 4Y19 | LOST 3 NHD - XVJ | S | FPEG | G | PECKHAM RYE | 101.16 | 3 | 2010-07-26 00:00:00 | Lost Time
179540 | 2010-07-26 00:00:00 | 4Y19 | LOST 3 SNS-VIR | S | FPEG | G | STAINES | 101.16 | 3 | 2010-07-26 00:00:00 | Lost Time
189593 | 2010-07-30 00:00:00 | 4E19 | WTG RELIEF 421S PBO | C | FPEG | G | HOLME JN. | 101.16 | 3 | 2010-07-30 00:00:00 | Traincrew
183892 | 2010-07-28 00:00:00 | 4h91 | TRAIN PREP DONCDDY | T | APEG | G | DONCASTER DOWN DECOY | 168.6 | 5 | 2010-07-28 00:00:00 | Terminal
182275 | 2010-07-27 00:00:00 | 4E19 | OSS XHO | L | MPEG | G | HUNTINGDON | 202.32 | 6 | 2010-07-27 00:00:00 | Locomotive
179580 | 2010-07-26 00:00:00 | 4M91 | DIESL OTH DONCRMT | L | MPEG | G | Doncaster Royal Mail Terminal | 1079.04 | 32 | 2010-07-26 00:00:00 | Locomotive
179646 | 2010-07-26 00:00:00 | 6H28 | LATE START HULLCT | T | FPEN | N | HULL COAL TERMINAL | 101.16 | 3 | 2010-07-26 00:00:00 | Terminal
181551 | 2010-07-27 00:00:00 | 6C31 | [NAME] | T | FPEN | N | BESSACARR JN | 101.16 | 3 | 2010-07-27 00:00:00 | Terminal
187607 | 2010-07-29 00:00:00 | [NAME] | AJ TRAFFIC WBTNPS | T | APEN | N | WEST BURTON POWER STN (GBRF) | 101.16 | 3 | 2010-07-29 00:00:00 | Terminal
188515 | 2010-07-30 00:00:00 | 6C31 | VIA ECML DRIVERS KNOWLEDG | C | FPEN | N | TEMPLE HIRST JN. | 101.16 | 3 | 2010-07-30 00:00:00 | Traincrew
191451 | 2010-07-31 00:00:00 | 6H93 | DIV REQ DONCUDY | P | FPEN | N | [NAME] | 101.16 | 3 | 2010-07-31 00:00:00 | Production
178707 | 2010-07-26 00:00:00 | 6C41 | WTG CREW RELIEF KNTNGWJ | C | FPEN | N | FERRYBRIDGE NORTH JN | 134.88 | 4 | 2010-07-26 00:00:00 | Traincrew
187530 | 2010-07-29 00:00:00 | 4S51 | STOP SHORT CAR | C | FPEN | N | PENRITH | 134.88 | 4 | 2010-07-29 00:00:00 | Traincrew
188129 | 2010-07-30 00:00:00 | 6C43 | PRESENTATION DONCDDY | T | FPEN | N | BESSACARR JN | 134.88 | 4 | 2010-07-30 00:00:00 | Terminal
187667 | 2010-07-29 00:00:00 | 6H88 | FOC REQST RUN EARLY DON | P | FPEN | N | DONCASTER | 202.32 | 6 | 2010-07-29 00:00:00 | Production
181864 | 2010-07-27 00:00:00 | 4H79 | TRAIN PREP DONCDDY | T | APEN | N | DONCASTER DOWN DECOY | 236.04 | 7 | 2010-07-27 00:00:00 | Terminal
185812 | 2010-07-29 00:00:00 | 4R40 | WTG ACC BKBY-IMNGHGB | T | APEN | N | BROCKLESBY | 236.04 | 7 | 2010-07-29 00:00:00 | Terminal
182661 | 2010-07-27 00:00:00 | 6C42 | LATE CALL OUT BESSCRJ-DON | T | FPEN | N | BESSACARR JN | 539.52 | 16 | 2010-07-27 00:00:00 | Terminal
181884 | 2010-07-27 00:00:00 | 4R46 | CONGESTION DRAXGBR | T | APEN | N |  | 640.68 | 19 | 2010-07-27 00:00:00 | Terminal
189420 | 2010-07-30 00:00:00 | 4S51 | LATE START DRAXGBR    TL2 | T | FPEN | N |  | 741.8399999999999 | 22 | 2010-07-30 00:00:00 | Terminal
177768 | 2010-07-25 00:00:00 | 4C10 | LATE PRES DONCDDG | T | FPEN | N | DONCASTER DOWN DECOY | 843 | 25 | 2010-07-25 00:00:00 | Terminal
184844 | 2010-07-28 00:00:00 | 4S51 | AE CONGESTION DRAXGBR | T | APEN | N |  | 1719.72 | 51 | 2010-07-28 00:00:00 | Terminal
180099 | 2010-07-26 00:00:00 | 4N87 | WTG ACCEPT NBLYGBF | T | APEN | N | NEWSHAM L.C. | 2899.92 | 86 | 2010-07-26 00:00:00 | Terminal
186350 | 2010-07-29 00:00:00 | 0Z20 | 25 AC TRAIN PREP PBROGBF | T | APES | S | PETERBOROUGH MAINT DPT (GBRF) | 101.16 | 3 | 2010-07-29 00:00:00 | Terminal
181836 | 2010-07-27 00:00:00 | 5D77 | L/S WLSDDCREC | T | FPES | S | WILLESDEN PRINCESS RDC (GBRF) | 505.8 | 15 | 2010-07-27 00:00:00 | Terminal
183911 | 2010-07-28 00:00:00 | 5Z10 | LATE CALL OUT XIF | T | MPES | S | ILFORD E.M.U.D. | 843 | 25 | 2010-07-28 00:00:00 | Terminal
182987 | 2010-07-27 00:00:00 | 5X78 | STOOD FOUL WILLESDEN | C | DPES | S | HARROW & WEALDSTONE | 910.4399999999999 | 27 | 2010-07-27 00:00:00 | Traincrew
182987 | 2010-07-27 00:00:00 | 5X78 | STOOD FOUL WILLESDEN | C | OQAZ | Z | HARROW & WEALDSTONE | 944.16 | 28 | 2010-07-27 00:00:00 | Traincrew
201688 | 2010-08-05 00:00:00 | 6E40 | LATE PRES GRAIN-GRV | T | FPEB | B | GRAIN FOSTER YEOMAN | 101.16 | 3 | 2010-08-05 00:00:00 | Terminal
195727 | 2010-08-02 00:00:00 | 6V02 | 20 CONGESTION XFD | T | APEB | B | FERME PARK RECP. | 134.88 | 4 | 2010-08-02 00:00:00 | Terminal
207363 | 2010-08-07 00:00:00 | 6V07 | CONGESTION FRMPRSG | T | APEB | B | FERME PARK RECP. | 202.32 | 6 | 2010-08-07 00:00:00 | Terminal
201488 | 2010-08-05 00:00:00 | 4L02 | LOST 5 HARROW - GPO | S | FPEC | C | HARROW & WEALDSTONE | 101.16 | 3 | 2010-08-05 00:00:00 | Lost Time
206252 | 2010-08-07 00:00:00 | 4M23 | TIME LOSS TO TRIMLEY | S | FPEC | C | FELIXSTOWE SOUTH DOCKS | 101.16 | 3 | 2010-08-07 00:00:00 | Lost Time
203033 | 2010-08-05 00:00:00 | 4L22 | 4 LOST COL-MNG | S | FPEC | C | COLCHESTER | 134.88 | 4 | 2010-08-05 00:00:00 | Lost Time
205428 | 2010-08-06 00:00:00 | 4L22 | 5 LOST COL-MNG | S | FPEC | C | COLCHESTER | 134.88 | 4 | 2010-08-06 00:00:00 | Lost Time
205394 | 2010-08-06 00:00:00 | 4M02 | REG LIGHTS REAR LOCO HML | C | FPEC | C | WATFORD JUNCTION | 236.04 | 7 | 2010-08-06 00:00:00 | Traincrew
201145 | 2010-08-05 00:00:00 | 4L02 | 4 LOST XOD - TRI | S | FPEC | C | LEDBURN JN | 269.76 | 8 | 2010-08-05 00:00:00 | Lost Time
199070 | 2010-08-04 00:00:00 | 4L02 | LOST 3 WJH - GPO | S | FPEC | C | WILLESDEN JN. HIGH LEVEL | 303.48 | 9 | 2010-08-04 00:00:00 | Lost Time
202504 | 2010-08-05 00:00:00 | 4M02 | 2 LOST FLXSSGB - DBR | S | FPEC | C | FELIXSTOWE | 303.48 | 9 | 2010-08-05 00:00:00 | Lost Time
196519 | 2010-08-03 00:00:00 | 4L02 | LOST 5 HRW - GPO | S | FPEC | C | HARROW & WEALDSTONE | 370.92 | 11 | 2010-08-03 00:00:00 | Lost Time
200094 | 2010-08-04 00:00:00 | 4G23 | LATE START HMSHBRF | T | APEC | C | HAMS HALL NDP (GBRF) | 404.64 | 12 | 2010-08-04 00:00:00 | Terminal
205216 | 2010-08-06 00:00:00 | 6671 | 4 VIGIL DEVICE MNP | L | MPEC | C | FOREST GATE JN | 606.96 | 18 | 2010-08-06 00:00:00 | Locomotive
195327 | 2010-08-02 00:00:00 | 4L22 | BRAKE PROBS HKC & HMN | W | MPEC | C | DALSTON JUNCTION | 708.12 | 21 | 2010-08-02 00:00:00 | Wagon
196913 | 2010-08-03 00:00:00 | 4E33 | TRAIN PREP @ FXT | T | APEC | C | FELIXSTOWE SOUTH DOCKS | 1079.04 | 32 | 2010-08-03 00:00:00 | Terminal
195538 | 2010-08-02 00:00:00 | 6N91 | 13 LOST NBLYACN HTONSJN | S | FPED | D | NORTH BLYTH ALCAN | 134.88 | 4 | 2010-08-02 00:00:00 | Lost Time
204357 | 2010-08-06 00:00:00 | 6S45 | 3 LOST MRPTNJN WNGTJN | S | FPEF | F | MORPETH | 134.88 | 4 | 2010-08-06 00:00:00 | Lost Time
200874 | 2010-08-05 00:00:00 | 6H51 | RUNNING EARLY YRK | C | FPEG | G | YORK | 101.16 | 3 | 2010-08-05 00:00:00 | Traincrew
194408 | 2010-08-02 00:00:00 | 6B51 | LATE START DONCDDY | T | FPEG | G | DONCDNDCY | 134.88 | 4 | 2010-08-02 00:00:00 | Terminal
203518 | 2010-08-06 00:00:00 | 4O19 | 8 LOST TON | S | FPEG | G | TONBRIDGE | 134.88 | 4 | 2010-08-06 00:00:00 | Lost Time
202353 | 2010-08-05 00:00:00 | 4E80 | [NAME] | C | FPEG | G | LINCOLN CENTRAL | 236.04 | 7 | 2010-08-05 00:00:00 | Traincrew
197505 | 2010-08-03 00:00:00 | 6B52 | 31 WTG STAFF WLBCKCL | T | APEG | G | WELBECK B.C. | 337.2 | 10 | 2010-08-03 00:00:00 | Terminal
201856 | 2010-08-05 00:00:00 | 4E19 | BREAKDOWN XMO | T | APEG | G | MOUNTFIELD SIDINGS (GBRF) | 337.2 | 10 | 2010-08-05 00:00:00 | Terminal
197269 | 2010-08-03 00:00:00 | 4E80 | LOCO ISSUES LBO | L | MPEG | G | LOUGHBOROUGH | 843 | 25 | 2010-08-03 00:00:00 | Locomotive
204997 | 2010-08-06 00:00:00 | 6B52 | TRAFFIC WLBCGBR | T | APEG | G | WELBECK B.C. | 2326.68 | 69 | 2010-08-06 00:00:00 | Terminal
196884 | 2010-08-03 00:00:00 | 4S51 | DRV ROUTE KNOWLEDGE CAR | C | FPEN | N | CARLISLE | 101.16 | 3 | 2010-08-03 00:00:00 | Traincrew
201448 | 2010-08-05 00:00:00 | 4S51 | CONGESTION DRAXGBR | T | APEN | N |  | 101.16 | 3 | 2010-08-05 00:00:00 | Terminal
194599 | 2010-08-02 00:00:00 | 4R51 | LATE DEP. DRAXGBR | T | FPEN | N |  | 168.6 | 5 | 2010-08-02 00:00:00 | Terminal
195624 | 2010-08-02 00:00:00 | 6H87 | 3 LOST DON SHFTHLJ | S | FPEN | N | DONCASTER | 202.32 | 6 | 2010-08-02 00:00:00 | Lost Time
194566 | 2010-08-02 00:00:00 | 4S51 | NO DRIVER CAR | C | FPEN | N | HALTWHISTLE | 236.04 | 7 | 2010-08-02 00:00:00 | Traincrew
197839 | 2010-08-04 00:00:00 | 4R42 | DVR NOT SIGN ROUTE | C | FPEN | N | KNOTTINGLEY EAST JN | 236.04 | 7 | 2010-08-04 00:00:00 | Traincrew
204014 | 2010-08-06 00:00:00 | 4R41 | BREAKDOWN EGBRGBF | T | APEN | N |  | 269.76 | 8 | 2010-08-06 00:00:00 | Terminal
197474 | 2010-08-03 00:00:00 | 6H51 | LOCO FLT HOLYTNJ | L | MPEN | N | HOLYTOWN JN | 337.2 | 10 | 2010-08-03 00:00:00 | Locomotive
193957 | 2010-08-02 00:00:00 | 4K58 | L/START COTAMPS | T | FPEN | N | COTTAM POWER STN DSG PLT (GBRF) | 472.08 | 14 | 2010-08-02 00:00:00 | Terminal
195341 | 2010-08-02 00:00:00 | 6B52 | TRAFFIC  WLBCGBR      TL2 | T | APEN | N |  | 876.72 | 26 | 2010-08-02 00:00:00 | Terminal
202023 | 2010-08-05 00:00:00 | 5M21 | PICK UP RADIO PBO | P | FPES | S | TALLINGTON JN. | 101.16 | 3 | 2010-08-05 00:00:00 | Production
204122 | 2010-08-06 00:00:00 | 6Z93 | UNIT PROBLEMS ASI-MDE | U | FPES | S | ASHFORD (KENT) | 101.16 | 3 | 2010-08-06 00:00:00 | Unit
196682 | 2010-08-03 00:00:00 | 5Y78 | [NAME] | T | MPES | S | ASHFORD (KENT) | 134.88 | 4 | 2010-08-03 00:00:00 | Terminal
205552 | 2010-08-07 00:00:00 | 5X78 | LOCO RUN AROUND ASI | L | FPES | S | ASHFORD (KENT) | 876.72 | 26 | 2010-08-07 00:00:00 | Locomotive