Spreadsheet: 132621d1323859900-if-cell-is-blank-take-number-shown-in-different-cell-test
Sheet: Sheet1

 |  |  |  | INCIDENT MINS |  | [NAME] |  |  | INCIDENT | [NAME] | SAVED | SAVED | FINAL | SAVED |  |  |  | COMMENTS
Date | TIN | Zone | D | TP | Self | TP | Self | TID | TP Cost | TP Cost | TP mins | (£) | COST | SD mins | Traffic | Code | Initials
2011-11-14 00:00:00 | 368963 | STH | A | 129 | 17 | 129 | 17 | 4O19 | 4549.830000000001 | 4549.830000000001 | 0 | 0 | 4549.830000000001 | 0 | Road | MP | KC
2011-11-14 00:00:00 | 368897 | STH | A | 20 | 3 | 20 | 3 | 4O19 | 705.4000000000001 | 705.4000000000001 | 0 | 0 | 705.4000000000001 | 0 | Rail | MC | KC
2011-11-14 00:00:00 | 370038 | ANG | A | 40 | 41 | 30 | 0 | 4R03 | 1410.8 | 1058.1 | 30 | 1058.1 | 352.7 | 0 | Road | FW | KC
2011-11-14 00:00:00 | 370734 | LNE | A | 0 | 311 | 0 | 311 | 6N63 | 0 | 0 | 0 | 0 | 0 | 311 | Road | AA | KC
2011-11-16 00:00:00 | 377214 | LNE | A | 11 | 7 | 11 | 7 | 6H98 | 387.97 | 387.97 | 11 | 387.97 | 0 | 7 | Rail | FO | KC
2011-11-16 00:00:00 | 375818 | ANG | A | 441 | 149 | 47 | 0 | 4L02 | 15554.07 | 1657.69 | 47 | 1657.69 | 13896.38 | 0 | Road | MC | KC
2011-11-17 00:00:00 | 381259 | LNE | A | 0 | 7 | 0 | 7 | 6N66 | 0 | 0 | 0 | 0 | 0 | 7 | Rail | AJ | KC
2011-11-18 00:00:00 | 382701 | LNE | A | 17 | 3 | 17 | 3 | 4L78 | 599.59 | 599.59 | 17 | 599.59 | 0 | 3 | Road | FO | KC
2011-11-18 00:00:00 | 381259 | LNE | A | 0 | 7 | 0 | 7 | 6N66 | 0 | 0 | 0 | 0 | 0 | 7 | Road | AJ | KC
2011-11-19 00:00:00 | 384395 | ANG | A | 0 | 28 | 0 | 28 | 4M29 | 0 | 0 | 0 | 0 | 0 | 28 | Rail | AE | KC
2011-11-22 00:00:00 | 391353 | ANG | A | 16 | 0 | 16 | 0 | 4M21 | 564.32 | 564.32 | 0 | 0 | 564.32 | 0 | Rail | FZ | KC
2011-11-22 00:00:00 | 383730 | STH | A | 81 | 38 | 81 | 36 | 6V19 | 2856.87 | 2856.87 | 40 | 1410.8 | 1446.07 | 19 | Road | FZ | KC
2011-11-23 00:00:00 | 393195 | LNE | D | 161 | 30 | 161 | 0 | 4R20 | 5678.47 | 5678.47 |  | 0 | 5678.47 |  | Road | AA | KC
2011-11-23 00:00:00 | 393689 | ANG | A | 91 | 34 | 91 | 34 | 4L22 | 3209.57 | 3209.57 | 91 | 3209.57 | 0 | 34 | Rail | AA | KC
2011-11-23 00:00:00 | 394237 | LNW | A | 0 | 57 | 0 | 57 | 6M90 | 0 | 0 | 0 | 0 | 0 | 0 | Road | AA | KC
2011-11-24 00:00:00 | 399442 | STH | A | 72 | 17 | 72 | 17 | 6V19 | 2539.44 | 2539.44 | 72 | 2539.44 | 0 | 17 | Rail | FO | KC
2011-11-24 00:00:00 | 399608 | ANG | A | 6 | 3 | 6 | 0 | 4L22 | 211.62 | 211.62 | 6 | 211.62 | 0 | 0 | Road | FZ | KC
2011-11-24 00:00:00 | 398250 | LNE | A | 45 | 106 | 20 | 0 | 4E33 | 1587.15 | 705.4000000000001 | 0 | 0 | 1587.15 | 0 | Road | AG | KC
2011-11-25 00:00:00 | 400316 | STH | D | 471 | 86 | 471 | 86 | 4H19 | 16612.17 | 16612.17 |  | 0 | 16612.17 |  | Rail | ML | KC
2011-11-25 00:00:00 | 401445 | STH | A | 0 | 60 | 0 | 60 | 4E19 | 0 | 0 | 0 | 0 | 0 | 60 | Rail | FW | KC
2011-11-26 00:00:00 | 404313 | LNE | A | 19 | 8 | 19 | 8 | 6H93 | 670.1300000000001 | 670.1300000000001 | 19 | 670.1300000000001 | 0 | 8 | Road | FO | KC
2011-11-29 00:00:00 | 407673 | STH | D | 255 | 986 | 255 | 986 | 4M90 | 8993.85 | 8993.85 |  | 0 | 8993.85 |  | Road | ML | KC
2011-11-29 00:00:00 | 412982 | STH | A | 110 | 3 | 55 | 0 | 4O20 | 3879.7 | 1939.85 | 0 | 0 | 3879.7 | 0 | Rail | FO | KC
2011-11-30 00:00:00 | 415892 | ANG | A | 9 | 11 | 9 | 0 | 4E33 | 317.43 | 317.43 | 9 | 317.43 | 0 | 0 | Road | AJ | KC
2011-11-30 00:00:00 | 406068 | LNW | A | 40 | 0 | 40 | 0 | 6F74 | 1410.8 | 1410.8 | 40 | 1410.8 | 0 | 0 | Rail | FL | KC
2011-11-30 00:00:00 | 417457 | STH | A | 3 | 27 | 3 | 27 | 6V19 | 105.81 | 105.81 | 3 | 105.81 | 0 | 14 | Road | FO | KC
2011-12-02 00:00:00 | 421146 | LNE | A | 23 | 11 | 23 | 11 | 4N98 | 811.21 | 811.21 | 23 | 811.21 | 0 | 11 | Road | MX | KC
2011-12-02 00:00:00 | 421282 | ANG | A | 5 | 3 | 5 | 0 | 4L23 | 176.35 | 176.35 | 5 | 176.35 | 0 | 0 | Rail | FO | KC
2011-12-02 00:00:00 | 422555 | ANG | A | 37 | 10 | 37 | 10 | 4L02 | 1304.99 | 1304.99 | 37 | 1304.99 | 0 | 10 | Rail | FK | KC
2011-12-02 00:00:00 | 422611 | LNW | A | 0 | 3 | 0 | 3 | 4K55 | 0 | 0 | 0 | 0 | 0 | 3 | Road | FO | KC
2011-12-02 00:00:00 | 423111 | LNE | A | 7 | 0 | 7 | 0 | 4E19 | 246.89 | 246.89 | 7 | 246.89 | 0 | 0 | Road | FE | KC
2011-12-02 00:00:00 | 423659 | GW | D | 103 | 0 | 103 | 0 | 6Z30 | 3632.81 | 3632.81 |  | 0 | 3632.81 |  | Rail | ML | KC
2011-12-03 00:00:00 | 424640 | ANG | A | 0 | 13 | 0 | 13 | 4M21 | 0 | 0 | 0 | 0 | 0 | 13 | Road | AE | KC
2011-12-03 00:00:00 | 425326 | ANG | A | 65 | 44 | 32 | 22 | 4M23 | 2292.55 | 1128.64 | 32 | 1128.64 | 1163.91 | 22 | Rail | AC | KC
2011-12-03 00:00:00 | 424234 | STH | A | 272 | 137 | 65 | 48 | 1Z81 | 9593.44 | 2292.55 | 65 | 2292.55 | 7300.89 | 48 | Road | MT | KC
2011-12-05 00:00:00 | 430565 | LNE | A | 148 | 160 | 148 | 160 | 4L78 | 5219.96 | 5219.96 | 148 | 5219.96 | 0 | 160 | Road | FO | KC
2011-12-06 00:00:00 | 432074 | STH | D | 168 | 70 | 168 | 70 | 4O19 | 5925.360000000001 | 5925.360000000001 |  | 0 | 5925.360000000001 |  | Rail | MP | KC
2011-12-06 00:00:00 | 432312 | STH | D | 0 | 23 | 0 | 23 | 4O19 | 0 | 0 |  | 0 | 0 |  | Rail | MP | KC
2011-12-06 00:00:00 | 434058 | LNE | A | 0 | 3 | 0 | 3 | 6Y19 | 0 | 0 | 0 | 0 | 0 | 3 | Road | FO | KC
2011-12-06 00:00:00 | 431705 | LNE | A | 0 | 43 | 0 | 43 | 0Z02 | 0 | 0 | 0 | 0 | 0 | 43 | Road | FL | KC
2011-12-06 00:00:00 | 431332 | LNE | A | 9 | 249 | 4 | 0 | 6C18 | 317.43 | 141.08 | 4 | 141.08 | 176.35 | 0 | Rail | AE | KC
2011-12-06 00:00:00 | 437167 | LNW | A | 0 | 56 | 0 | 56 | 4G23 | 0 | 0 | 0 | 0 | 0 | 56 | Rail | FZ | KC
2011-12-06 00:00:00 | 437367 | LNW | A | 0 | 45 | 0 | 45 | 4G77 | 0 | 0 | 0 | 0 | 0 | 45 | Road | AE | KC
2011-12-09 00:00:00 | 442789 | LNE | D | 0 | 38 | 0 | 38 | 6D15 | 0 | 0 |  | 0 | 0 |  | Road | FY | KC
2011-12-09 00:00:00 | 442787 | ANG | A | 22 | 6 | 22 | 0 | 4E19 | 775.94 | 775.94 | 22 | 775.94 | 0 | 0 | Rail | FE | KC
2011-12-09 00:00:00 | 444442 | ANG | A | 27 | 25 | 27 | 25 | 4M21 | 952.2900000000001 | 952.2900000000001 | 27 | 952.2900000000001 | 0 | 25 | Road | AF | KC
2011-12-09 00:00:00 | 442884 | LNE | D | 1000 | 500 | 500 | 0 | 4E33 | 35270 | 17635 |  | 0 | 35270 |  | Rail | MO | KC
2011-12-09 00:00:00 | 444298 | LNE | A | 0 | 172 | 0 | 172 | 4R01 | 0 | 0 | 0 | 0 | 0 | 172 | Road | FW | KC
Total Disputes |  | 48
 |  |  |  |  |  |  |  |  | Still to be resolved
TP | TP | TP | TP |  | SELF | SELF | TP
Disputed | Won | Lost | Saved |  | Disputed | Won | Lost
2694 | 755 | 1939 | 26628.85 |  | 2436 | 1126 | 1310
% saved | 0.2802524127691166 |  |  |  | % saved | 0.4622331691297208
 | Under investigation
 | Level 3
 | Level 2 checked
 | Minutes to be on NR spreadsheet after Day 8
 | Agreed 50/50
 | Level 4
 | On Hold
 | Europorte Incident