Spreadsheet: 75844d1276455795-formula-answer-does-not-appear-in-cell-tda-disputes-2010-11
Sheet: Current Period

 |  |  |  | INCIDENT MINS |  | [NAME] |  | INCIDENT | [NAME] | SAVED | SAVED | FINAL | SAVED |  |  |  |  | COMMENTS
Date | TIN | Zone | D | 3P | Self | 3P | Self | 3P Cost | 3P Cost | 3P mins | (£) | COST | SD mins | Comm | TID | Code | Initials
2010-05-30 00:00:00 | 048827 | LNE | A | 0 | 55 | 0 | 55 | 0 | 0 | 0 | 0 | 0 | 55 | Coal | 6H21 | FW | KC
2010-05-31 00:00:00 | 050835 | LNW | A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Royal Mail | 1A92 | FL | SC
2010-05-31 00:00:00 | 050815 | LNW | A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Royal Mail | 1A93 | FL | SC
2010-06-01 00:00:00 | 051779 | ANG | D | 107 | 190 | 197 | 190 | 3608.04 | 6642.84 |  | 0 | 3608.04 |  | Intermodal | 4Z33 | FE | KC
2010-06-01 00:00:00 | 052823 | LNE | A | 12 | 0 | 12 | 0 | 404.64 | 404.64 | 12 | 404.64 | 0 | 0 | Metals | 6N32 | FO | KC
2010-06-01 00:00:00 | 052807 | LNE | A | 61 | 0 | 61 | 0 | 2056.92 | 2056.92 | 61 | 2056.92 | 0 | 0 | Metals | 6N32 | FE | KC
2010-06-02 00:00:00 | 054872 | GW | A | 3 | 3 | 3 | 0 | 101.16 | 101.16 | 2 | 67.44 | 33.72 | 0 | Metronet | 6E32 | FW | KC
2010-06-03 00:00:00 | 057512 | ANG | A | 5 | 2 | 5 | 0 | 168.6 | 168.6 | 5 | 168.6 | 0 | 0 | Intermodal | 4M23 | FO | KC
2010-06-03 00:00:00 | 056954 | LNW | A | 33 | 3 | 29 | 0 | 1112.76 | 977.88 | 29 | 977.88 | 134.88 | 0 | Intermodal | 4M21 | FO | KC
2010-06-03 00:00:00 | 057318 | STH | A | 41 | 141 | 41 | 141 | 1382.52 | 1382.52 | 41 | 1382.52 | 0 | 141 | Metronet | 6E40 | AE | KC
2010-06-03 00:00:00 | 058097 | LNW | A | 206 | 22 | 112 | 0 | 6946.32 | 3776.64 | 112 | 3776.64 | 3169.68 | 0 | Intermodal | 4M23 | FY | KC
2010-06-04 00:00:00 | 059184 | ANG | D | 6 | 4 | 4 | 0 | 202.32 | 134.88 |  | 0 | 202.32 |  | Intermodal | 4M21 | FW | KC
2010-06-04 00:00:00 | 060122 | LNE | A | 20 | 0 | 7 | 0 | 674.4 | 236.04 | 7 | 236.04 | 438.36 | 0 | Rail Services | 5L86 | MD | KC
2010-06-04 00:00:00 | 059633 | LNE | A | 0 | 31 | 0 | 31 | 0 | 0 | 0 | 0 | 0 | 31 | Coal | 4N68 | FZ | KC
2010-06-04 00:00:00 | 060781 | LNE | A | 28 | 4 | 28 | 0 | 944.16 | 944.16 | 0 | 0 | 944.16 | 0 | Metals | 6S45 | FO | KC
2010-06-04 00:00:00 | 061236 | LNE | A | 0 | 39 | 0 | 39 | 0 | 0 | 0 | 0 | 0 | 39 | Metals | 6N69 | AJ | KC
2010-06-04 00:00:00 | 060950 | LNW | A | 0 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 2 | Intermodal | 4L22 | FO | KC
2010-06-05 00:00:00 | 062129 | LNE | A | 94 | 0 | 94 | 0 | 3169.68 | 3169.68 | 94 | 3169.68 | 0 | 0 | Coal | 6F58 | MC | KC
2010-06-05 00:00:00 | 062071 | ANG | A | 0 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 2 | Intermodal | 4M21 | FE | KC
2010-06-05 00:00:00 | 062035 | ANG | A | 48 | 29 | 48 | 29 | 1618.56 | 1618.56 | 48 | 1618.56 | 0 | 29 | Intermodal | 4M21 | AJ | KC
2010-06-05 00:00:00 | 063741 | STH | A | 6 | 0 | 6 | 0 | 202.32 | 202.32 | 6 | 202.32 | 0 | 0 | Infrastructure | 0Y12 | FO | DL
2010-06-05 00:00:00 | 063736 | STH | A | 4 | 0 | 4 | 0 | 134.88 | 134.88 | 6 | 202.32 | -67.44 | 0 | Infrastructure | 0Y12 | FO | DL
2010-06-07 00:00:00 | 066697 | LNE | A | 9 | 45 | 5 | 0 | 303.48 | 168.6 | 5 | 168.6 | 134.88 | 0 | Intermodal | 4E33 | FM | KC
2010-06-07 00:00:00 | 066802 | LNE | A | 40 | 35 | 40 | 35 | 1348.8 | 1348.8 | 40 | 1348.8 | 0 | 35 | Coal | 6N87 | MR | KC
2010-06-07 00:00:00 | 066971 | LNE | A | 54 | 30 | 26 | 0 | 1820.88 | 876.72 | 26 | 876.72 | 944.1599999999999 | 0 | Coal | 6N32 | FO | KC
2010-06-07 00:00:00 | 067086 | LNW | A | 22 | 0 | 22 | 0 | 741.8399999999999 | 741.8399999999999 | 22 | 741.8399999999999 | 0 | 0 | Royal Mail | 1A91 | MM | KC
2010-06-07 00:00:00 | 067396 | LNE | D | 0 | 89 | 0 | 89 | 0 | 0 |  | 0 | 0 |  | Coal | 6N67 | FZ | KC
2010-06-08 00:00:00 | 068510 | LNW | D | 17 | 3 | 9 | 0 | 573.24 | 303.48 |  | 0 | 573.24 |  | Intermodal | 4M21 | FO | KC
2010-06-08 00:00:00 | 069108 | ANG | A | 3 | 8 | 3 | 8 | 101.16 | 101.16 | 3 | 101.16 | 0 | 8 | Intermodal | 4L02 | AE | KC
2010-06-08 00:00:00 | 068911 | LNW | A | 14 | 30 | 14 | 0 | 472.08 | 472.08 | 0 | 0 | 472.08 | 0 | Intermodal | 4M21 | AA | KC
2010-06-08 00:00:00 | 069034 | STH | A | 152 | 50 | 94 | 0 | 5125.44 | 3169.68 | 94 | 3169.68 | 1955.76 | 0 | Metronet | 6E40 | FW | KC
2010-06-08 00:00:00 | 069205 | LNE | A | 0 | 29 | 0 | 29 | 0 | 0 | 0 | 0 | 0 | 29 | Coal | 6R45 | MN | KC
2010-06-08 00:00:00 | 069554 | ANG | A | 27 | 14 | 14 | 0 | 910.4399999999999 | 472.08 | 4 | 134.88 | 775.56 | 0 | Intermodal | 4E33 | FO | KC
2010-06-08 00:00:00 | 069870 | ANG | A | 4 | 1 | 4 | 0 | 134.88 | 134.88 | 0 | 0 | 134.88 | 0 | Metronet | 6E42 | FO | KC
2010-06-09 00:00:00 | 071025 | STH | A | 283 | 0 | 283 | 0 | 9542.76 | 9542.76 | 283 | 9542.76 | 0 | 0 | Infrastructure |  | AE | KC
2010-06-09 00:00:00 | 071547 | STH | A | 36 | 68 | 36 | 0 | 1213.92 | 1213.92 | 36 | 1213.92 | 0 | 0 | Metronet | 6E40 | AJ | KC
2010-06-09 00:00:00 | 072869 | LNW | D | 0 | 6 | 0 | 6 | 0 | 0 |  | 0 | 0 |  | Gypsum | 4F16 | FO | KC
2010-06-10 00:00:00 | 074558 | LNW | A | 12 | 12 | 12 | 0 | 404.64 | 404.64 | 0 | 0 | 404.64 | 0 | Coal | 4S51 | FE | KC
2010-06-08 00:00:00 | 069995 | ANG | D | 4 | 4 | 4 | 4 | 134.88 | 134.88 |  | 0 | 134.88 |  | Intermodal | 4L78 | AE | KC
2010-06-11 00:00:00 | 075836 | ANG | A | 0 | 8 | 0 | 8 | 0 | 0 | 0 | 0 | 0 | 8 | Rail Services | 5M19 | FZ | SC
2010-06-11 00:00:00 | 075048 | LNE | D | 0 | 5 | 0 | 5 | 0 | 0 |  | 0 | 0 |  | Coal | 6N87 | FO | SC
2010-06-10 00:00:00 | 075295 | LNW | D | 4 | 12 | 4 | 12 | 134.88 | 134.88 |  | 0 | 134.88 |  | Intermodal | 4M02 | FE | SC
2010-06-11 00:00:00 | 076025 | GW | A | 38 | 0 | 38 | 0 | 1281.36 | 1281.36 | 38 | 1281.36 | 0 | 0 | First Great W | 5D04 | MD | KC
2010-06-12 00:00:00 | 078640 | ANG | D | 18 | 67 | 18 | 67 | 606.96 | 606.96 |  | 0 | 606.96 |  | Intermodal | 4M23 | FW | KC
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
Total Disputes |  | 44 |  | 1411 | 1045 | 1277 | 754 | 47818.79 | 43060.44 | 974 | 32843.28 | 14735.64 | 379
 |  |  |  | % of disputed mins actually saved |  |  |  |  | 3rd Party | 0.7627251370399374 | Saved | Self [NAME] | 0.5026525198938993
 | Under investigation
 | Level 3
 | Level 2 checked
 | Minutes to be on NR spreadsheet