Spreadsheet: 140510d1328793675-cannot-get-pivot-table-to-show-data-by-individual-days-of-the-week-test
Sheet: Data

Incident | Date | ID | Cause | Delay Code | Manager | Comm | Incident Location | Cost | Delays | Month | Day | Delay Cause | Commodity
563092 | 2011-01-30 00:00:00 | 5L55 | LOCO FLR XWP-WIM | L | MPES | S | WIMBLEDON | 35270 | 1000 | 2011-01-30 00:00:00 | 2011-01-30 00:00:00 | Locomotive | Rail Services
442884 | 2011-12-09 00:00:00 | 4E33 | DSD FLT TALNGTN SOKEJN | L | MPEC | C | PETERBOROUGH | 35270 | 1000 | 2011-12-09 00:00:00 | 2011-12-09 00:00:00 | Locomotive | Intermodal
923349 | 2011-05-13 00:00:00 | 4M33 | LOCO FLR BLY | L | MPEC | C | LEDBURN JN | 35270 | 1000 | 2011-05-13 00:00:00 | 2011-05-13 00:00:00 | Locomotive | Intermodal
400316 | 2011-11-25 00:00:00 | 4H19 | FAILED TON-TBW | L | MPEG | G | TONBRIDGE | 35270 | 1000 | 2011-11-25 00:00:00 | 2011-11-25 00:00:00 | Locomotive | Gypsum
419078 | 2011-12-01 00:00:00 | 6C06 | FAILED DON | L | MPEN | N | DONCASTER | 35270 | 1000 | 2011-12-01 00:00:00 | 2011-12-01 00:00:00 | Locomotive | Coal
912718 | 2011-05-08 00:00:00 | 4N54 | NOT DEPARTED DAR      TL2 | P | FPEN | N | NORTHALLERTON | 35270 | 1000 | 2011-05-08 00:00:00 | 2011-05-08 00:00:00 | Production | Coal
840390 | 2011-04-06 00:00:00 | 6R45 | LOCO PROBS SAXISTO | L | MPEF | F | GAINSBOROUGH TRENT JNS | 35270 | 1000 | 2011-04-06 00:00:00 | 2011-04-06 00:00:00 | Locomotive | Metals
834676 | 2011-04-04 00:00:00 | 4Z13 | DIAGRAM ERROR SRA (L2) | P | FPEC | C | STRATFORD | 35270 | 1000 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | Production | Intermodal
462483 | 2011-12-16 00:00:00 | 4M23 | LOCO FAULT @ FLXSNGB | L | MPEC | C | FELIXSTOWE NORTH DOCKS | 35270 | 1000 | 2011-12-16 00:00:00 | 2011-12-16 00:00:00 | Locomotive | Intermodal
282649 | 2011-10-14 00:00:00 | 4O19 | ADTL LOCO WAD-XMO (SRCT) | C | FPEG | G | WADHURST | 29979.5 | 850 | 2011-10-14 00:00:00 | 2011-10-14 00:00:00 | Traincrew | Gypsum
390410 | 2011-11-21 00:00:00 | 4M02 | LOCO PROBS SNF | L | MPEC | C | CHELMSFORD | 24759.54 | 702 | 2011-11-21 00:00:00 | 2011-11-21 00:00:00 | Locomotive | Intermodal
541166 | 2012-01-20 00:00:00 | 4L18 | DIESL TRAC NENGLNN | L | MPEC | C | PETERBOROUGH | 23913.06 | 678 | 2012-01-20 00:00:00 | 2012-01-20 00:00:00 | Locomotive | Intermodal
312818 | 2011-10-25 00:00:00 | 4L02 | BRAKE PROBLEMS @ DBR | L | MPEC | C | DERBY ROAD | 21303.08 | 604 | 2011-10-25 00:00:00 | 2011-10-25 00:00:00 | Locomotive | Intermodal
474605 | 2011-12-21 00:00:00 | 4L23 | - 66728 BRAKE FLR @ MNG | L | MPEC | C | MANNINGTREE | 20350.79 | 577 | 2011-12-21 00:00:00 | 2011-12-21 00:00:00 | Locomotive | Intermodal
842819 | 2011-04-07 00:00:00 | 5Z21 | ADD [NAME] IFD | U | MPES | S | ILFORD | 20103.9 | 570 | 2011-04-07 00:00:00 | 2011-04-07 00:00:00 | Unit | Rail Services
186422 | 2011-09-06 00:00:00 | 4E33 | LOCO FAILED NENGLNN | L | MPEC | C | PETERBOROUGH | 9326.56 | 551 | 2011-09-06 00:00:00 | 2011-09-06 00:00:00 | Locomotive | Intermodal
155479 | 2011-08-23 00:00:00 | 4N83 | UNIT FAULT MCE | L | MPEN | N | METROCENTRE | 12767.74 | 362 | 2011-08-23 00:00:00 | 2011-08-23 00:00:00 | Locomotive | Coal
475692 | 2011-12-21 00:00:00 | 4L02 | WAGON DERAILED @ FLXSSGB | T | FPEC | C | TRIMLEY | 11991.8 | 340 | 2011-12-21 00:00:00 | 2011-12-21 00:00:00 | Terminal | Intermodal
439484 | 2011-12-08 00:00:00 | 4L18 | LATE START BRTDGBF | T | APEC | C | BARTON DOCK | 11110.05 | 315 | 2011-12-08 00:00:00 | 2011-12-08 00:00:00 | Terminal | Intermodal
546144 | 2012-01-23 00:00:00 | 4M23 | LATE START FLXSSGB (L2) | T | FPEC | C | FELIXSTOWE SOUTH DOCKS | 11039.51 | 313 | 2012-01-23 00:00:00 | 2012-01-23 00:00:00 | Terminal | Intermodal
904908 | 2011-05-05 00:00:00 | 4L22 | STAFF REQ. FLXSNGB (L2) | T | FPEC | C | FELIXSTOWE NORTH DOCKS | 10651.54 | 302 | 2011-05-05 00:00:00 | 2011-05-05 00:00:00 | Terminal | Intermodal
81419 | 2011-07-21 00:00:00 | 5O08 | BRAKES STUCK ON ALB  SRCT | L | MPES | S | MADELEY JN | 10545.73 | 299 | 2011-07-21 00:00:00 | 2011-07-21 00:00:00 | Locomotive | Rail Services
967873 | 2011-06-01 00:00:00 | 6Z97 | TRAFFIC BESTONS | T | MPEF | F | BEESTON MCINTYRE | 9875.6 | 280 | 2011-06-01 00:00:00 | 2011-06-01 00:00:00 | Terminal | Metals
481125 | 2011-12-23 00:00:00 | 6B58 | STANDING FOUL THORESBY | T | FPEN | N | THORESBY B.C. | 9769.79 | 277 | 2011-12-23 00:00:00 | 2011-12-23 00:00:00 | Terminal | Coal
350879 | 2011-11-07 00:00:00 | 4M02 | LATE START FELIXSGBR | T | APEC | C | FELIXSTOWE SOUTH DOCKS | 9734.52 | 276 | 2011-11-07 00:00:00 | 2011-11-07 00:00:00 | Terminal | Intermodal
425234 | 2011-12-03 00:00:00 | 1Z81 | AWS [NAME] | L | MPEZ | Z | PARKS BRIDGE JN | 9522.900000000001 | 270 | 2011-12-03 00:00:00 | 2011-12-03 00:00:00 | Locomotive | Charters
319025 | 2011-10-27 00:00:00 | 4E33 | LATE START FELIXSGBR | T | APEC | C | FELIXSTOWE SOUTH DOCKS | 9381.820000000002 | 266 | 2011-10-27 00:00:00 | 2011-10-27 00:00:00 | Terminal | Intermodal
852212 | 2011-04-11 00:00:00 | 0N31 | LATE START NBLYAGB | T | FPEF | F |  | 9311.28 | 264 | 2011-04-11 00:00:00 | 2011-04-11 00:00:00 | Terminal | Metals
375818 | 2011-11-16 00:00:00 | 4L02 | FAILED HIGHAM OLD STATON | L | MPEC | C | CHIPPENHAM JN | 8676.42 | 246 | 2011-11-16 00:00:00 | 2011-11-16 00:00:00 | Locomotive | Intermodal
871285 | 2011-04-19 00:00:00 | 4E33 | FLD PBO | T | MPEC | C | PETERBOROUGH | 8641.150000000001 | 245 | 2011-04-19 00:00:00 | 2011-04-19 00:00:00 | Terminal | Intermodal
836324 | 2011-04-04 00:00:00 | 4L22 | SCHEDULE PBO L2 | T | FPEC | C | PETERBOROUGH | 8323.720000000001 | 236 | 2011-04-04 00:00:00 | 2011-04-04 00:00:00 | Terminal | Intermodal
89531 | 2011-07-25 00:00:00 | 4N84 | VSTP TO NSHMLC | P | FPEN | N | NEWSHAM L.C. | 8253.18 | 234 | 2011-07-25 00:00:00 | 2011-07-25 00:00:00 | Production | Coal
853661 | 2011-04-12 00:00:00 | 4E07 | TRAIN PREP FELIXN GB | T | APEC | C | FELIXSTOWE NORTH DOCKS | 8147.370000000001 | 231 | 2011-04-12 00:00:00 | 2011-04-12 00:00:00 | Terminal | Intermodal
478876 | 2011-12-22 00:00:00 | 6F01 | 8 KEBGSJN DHM | S | FPEN | N | KING EDWARD BRIDGE E. JN | 8041.56 | 228 | 2011-12-22 00:00:00 | 2011-12-22 00:00:00 | Lost Time | Coal
409611 | 2011-11-28 00:00:00 | 4L22 | LATE START HMSHBRF XQW | T | FPEC | C | HAMS HALL NDP (GBRF) | 7653.590000000001 | 217 | 2011-11-28 00:00:00 | 2011-11-28 00:00:00 | Terminal | Intermodal
322282 | 2011-10-28 00:00:00 | 4L78 | TRAIN PREP SELBGBF | T | APEC | C | SELBY (GBRF) | 7195.080000000001 | 204 | 2011-10-28 00:00:00 | 2011-10-28 00:00:00 | Terminal | Intermodal
986730 | 2011-06-09 00:00:00 | 6H89 | TRAFFIC NBLYGBF        WR | T | APEN | N | NORTH BLYTH ALCAN | 7124.540000000001 | 202 | 2011-06-09 00:00:00 | 2011-06-09 00:00:00 | Terminal | Coal
Sum of Cost |  | Day
Incident Location | ID | 2011-01-30 00:00:00 | 2011-12-09 00:00:00 | 2011-05-13 00:00:00 | 2011-11-25 00:00:00 | 2011-12-01 00:00:00 | 2011-05-08 00:00:00 | 2011-04-06 00:00:00 | 2011-04-04 00:00:00 | 2011-12-16 00:00:00 | 2011-10-14 00:00:00 | 2011-11-21 00:00:00 | 2012-01-20 00:00:00 | 2011-10-25 00:00:00 | 2011-12-21 00:00:00 | 2011-04-07 00:00:00 | 2011-09-06 00:00:00 | 2011-08-23 00:00:00 | 2011-12-08 00:00:00 | 2012-01-23 00:00:00 | 2011-05-05 00:00:00 | 2011-07-21 00:00:00 | 2011-06-01 00:00:00 | 2011-12-23 00:00:00 | 2011-11-07 00:00:00 | 2011-12-03 00:00:00 | 2011-10-27 00:00:00 | 2011-04-11 00:00:00 | 2011-11-16 00:00:00 | 2011-04-19 00:00:00 | 2011-07-25 00:00:00 | 2011-04-12 00:00:00 | 2011-12-22 00:00:00 | 2011-11-28 00:00:00 | 2011-10-28 00:00:00 | 2011-06-09 00:00:00 | Grand Total
BARTON DOCK | 4L18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11110.05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11110.05
BEESTON MCINTYRE | 6Z97 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9875.6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9875.6
CHELMSFORD | 4M02 |  |  |  |  |  |  |  |  |  |  | 24759.54 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24759.54
CHIPPENHAM JN | 4L02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8676.42 |  |  |  |  |  |  |  | 8676.42
DERBY ROAD | 4L02 |  |  |  |  |  |  |  |  |  |  |  |  | 21303.08 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21303.08
DONCASTER | 6C06 |  |  |  |  | 35270 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35270
FELIXSTOWE NORTH DOCKS | 4E07 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8147.37 |  |  |  |  | 8147.37
 | 4L22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10651.54 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10651.54
 | 4M23 |  |  |  |  |  |  |  |  | 35270 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35270
FELIXSTOWE SOUTH DOCKS | 4E33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9381.82 |  |  |  |  |  |  |  |  |  | 9381.82
 | 4M02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9734.52 |  |  |  |  |  |  |  |  |  |  |  | 9734.52
 | 4M23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11039.51 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11039.51
GAINSBOROUGH TRENT JNS | 6R45 |  |  |  |  |  |  | 35270 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35270
HAMS HALL NDP (GBRF) | 4L22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7653.59 |  |  | 7653.59
ILFORD | 5Z21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20103.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20103.9
KING EDWARD BRIDGE E. JN | 6F01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8041.56 |  |  |  | 8041.56
LEDBURN JN | 4M33 |  |  | 35270 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35270
MADELEY JN | 5O08 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10545.73 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10545.73
MANNINGTREE | 4L23 |  |  |  |  |  |  |  |  |  |  |  |  |  | 20350.79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20350.79
METROCENTRE | 4N83 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12767.74 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12767.74
NEWSHAM L.C. | 4N84 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8253.18 |  |  |  |  |  | 8253.18
NORTH BLYTH ALCAN | 6H89 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7124.54 | 7124.54
NORTHALLERTON | 4N54 |  |  |  |  |  | 35270 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35270
PARKS BRIDGE JN | 1Z81 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9522.9 |  |  |  |  |  |  |  |  |  |  | 9522.9
PETERBOROUGH | 4E33 |  | 35270 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9326.56 |  |  |  |  |  |  |  |  |  |  |  |  | 8641.15 |  |  |  |  |  |  | 53237.71
 | 4L18 |  |  |  |  |  |  |  |  |  |  |  | 23913.06 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23913.06
 | 4L22 |  |  |  |  |  |  |  | 8323.72 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8323.72
SELBY (GBRF) | 4L78 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7195.08 |  | 7195.08
STRATFORD | 4Z13 |  |  |  |  |  |  |  | 35270 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35270
THORESBY B.C. | 6B58 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9769.79 |  |  |  |  |  |  |  |  |  |  |  |  | 9769.79
TONBRIDGE | 4H19 |  |  |  | 35270 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35270
TRIMLEY | 4L02 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11991.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11991.8
WADHURST | 4O19 |  |  |  |  |  |  |  |  |  | 29979.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29979.5
WIMBLEDON | 5L55 | 35270 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35270
(blank) | 0N31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9311.28 |  |  |  |  |  |  |  |  | 9311.28
Grand Total |  | 35270 | 35270 | 35270 | 35270 | 35270 | 35270 | 35270 | 43593.72 | 35270 | 29979.5 | 24759.54 | 23913.06 | 21303.08 | 32342.59 | 20103.9 | 9326.56 | 12767.74 | 11110.05 | 11039.51 | 10651.54 | 10545.73 | 9875.6 | 9769.79 | 9734.52 | 9522.9 | 9381.82 | 9311.28 | 8676.42 | 8641.15 | 8253.18 | 8147.37 | 8041.56 | 7653.59 | 7195.08 | 7124.54 | 664925.32