Spreadsheet: 140475d1328763774-formula-to-give-day-and-year-from-date-range-and-include-in-pivot-table-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 |  | 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 |  | 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 |  | 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 |  | Locomotive | Gypsum
419078 | 2011-12-01 00:00:00 | 6C06 | FAILED DON | L | MPEN | N | DONCASTER | 35270 | 1000 | 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 |  | 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 |  | 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 |  | 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 |  | 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 |  | Traincrew | Gypsum
503445 | 2012-01-05 00:00:00 | FLXS | NGB HIGH WINDS (GBRF) | T | APEC | C | FELIXSTOWE NORTH DOCKS | 28074.92 | 796 | 2012-01-05 00:00:00 |  | Terminal | Intermodal
390410 | 2011-11-21 00:00:00 | 4M02 | LOCO PROBS SNF | L | MPEC | C | CHELMSFORD | 24759.54 | 702 | 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 |  | 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 |  | 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 |  | 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 |  | 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 |  | 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 |  | 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 |  | 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 |  | 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 |  | 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 |  | 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 |  | 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 |  | 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 |  | 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 |  | 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 |  | 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 |  | 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 |  | 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 |  | 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 |  | 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 |  | 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 |  | 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 |  | Terminal | Intermodal
264859 | 2011-10-07 00:00:00 | IMNG | HIG LOADING BAY FAULT | T | APEN | N | THORNE JN | 8147.370000000001 | 231 | 2011-10-07 00:00:00 |  | Terminal | Coal
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 |  | 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 |  | 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 |  | 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 |  | Terminal | Coal
Sum of Cost | Month
Incident Location | Jan | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Grand Total
BARTON DOCK |  |  |  |  |  |  |  |  |  | 11110.05 | 11110.05
BEESTON MCINTYRE |  |  |  | 9875.6 |  |  |  |  |  |  | 9875.6
CHELMSFORD |  |  |  |  |  |  |  |  | 24759.54 |  | 24759.54
CHIPPENHAM JN |  |  |  |  |  |  |  |  | 8676.42 |  | 8676.42
DERBY ROAD |  |  |  |  |  |  |  | 21303.08 |  |  | 21303.08
DONCASTER |  |  |  |  |  |  |  |  |  | 35270 | 35270
FELIXSTOWE NORTH DOCKS | 28074.92 | 8147.37 | 10651.54 |  |  |  |  |  |  | 35270 | 82143.83
FELIXSTOWE SOUTH DOCKS | 11039.51 |  |  |  |  |  |  | 9381.82 | 9734.52 |  | 30155.85
GAINSBOROUGH TRENT JNS |  | 35270 |  |  |  |  |  |  |  |  | 35270
HAMS HALL NDP (GBRF) |  |  |  |  |  |  |  |  | 7653.59 |  | 7653.59
ILFORD |  | 20103.9 |  |  |  |  |  |  |  |  | 20103.9
KING EDWARD BRIDGE E. JN |  |  |  |  |  |  |  |  |  | 8041.56 | 8041.56
LEDBURN JN |  |  | 35270 |  |  |  |  |  |  |  | 35270
MADELEY JN |  |  |  |  | 10545.73 |  |  |  |  |  | 10545.73
MANNINGTREE |  |  |  |  |  |  |  |  |  | 20350.79 | 20350.79
METROCENTRE |  |  |  |  |  | 12767.74 |  |  |  |  | 12767.74
NEWSHAM L.C. |  |  |  |  | 8253.18 |  |  |  |  |  | 8253.18
NORTH BLYTH ALCAN |  |  |  | 7124.54 |  |  |  |  |  |  | 7124.54
NORTHALLERTON |  |  | 35270 |  |  |  |  |  |  |  | 35270
PARKS BRIDGE JN |  |  |  |  |  |  |  |  |  | 9522.9 | 9522.9
PETERBOROUGH | 23913.06 | 16964.87 |  |  |  |  | 9326.56 |  |  | 35270 | 85474.49
SELBY (GBRF) |  |  |  |  |  |  |  | 7195.08 |  |  | 7195.08
STRATFORD |  | 35270 |  |  |  |  |  |  |  |  | 35270
THORESBY B.C. |  |  |  |  |  |  |  |  |  | 9769.79 | 9769.79
THORNE JN |  |  |  |  |  |  |  | 8147.37 |  |  | 8147.37
TONBRIDGE |  |  |  |  |  |  |  |  | 35270 |  | 35270
TRIMLEY |  |  |  |  |  |  |  |  |  | 11991.8 | 11991.8
WADHURST |  |  |  |  |  |  |  | 29979.5 |  |  | 29979.5
WIMBLEDON | 35270 |  |  |  |  |  |  |  |  |  | 35270
(blank) |  | 9311.28 |  |  |  |  |  |  |  |  | 9311.28
Grand Total | 98297.49 | 125067.42 | 81191.54 | 17000.14 | 18798.91 | 12767.74 | 9326.56 | 76006.85 | 86094.07 | 176596.89 | 701147.61