Spreadsheet: 215104d1361266941-i-need-help-again-with-tabs-and-a-formula-transnet-downtime-report-inland-temp-
Sheet: JETPARK

 |  |  |  |  |  |  | Transnet Downtime Report |  |  |  | 2013-02-19 00:00:00
Transnet Downtime Report
RC Number | Pre Inspection Form Number | Branch | Job card Ref | Depot | Cost Centre | Reg No. | Vin Number | Engine No. | [NAME] | Hour [NAME] | [NAME] | [NAME] | Vehicle Type | Department | Date Vehicle Booked In | Date quote sent to TFR | Quote Number | Date Order/Authorization Received | Authorization Number | Planned Completion Date | Date Job Completed | Date Vehicle Collected | Brief Job Description | Remarks/ Comments | Amount Excl. | Licence expire date
378994 | 78014 | [NAME] | 47597 | KRUGERSDORP | 715025 | SMC094GP | ADDT51000000003990 | FE6204601B | 199648 |  | NISSAN | UD60 | RRV | ELECTICAL | 2012-05-13 00:00:00 | 2012-05-23 00:00:00 | Y5255 | 2012-12-14 00:00:00 | 4501857779 |  |  |  | ACCIDENT DAMAGE | WORK IN PROGRESS | 123456.36 | 2012-07-31 00:00:00
376141 | 72955 | [NAME] | 48807 | ISANDO | 715023 | RBD744GP | ADMFRR33H1Z178481 | 6HH1317713 | 204790 |  | ISUZU | FRR 500 | H/V | ELECTICAL | 2012-11-16 00:00:00 | 2012-11-16 00:00:00 | Y5628 |  |  |  |  |  | SERVICE, CYLINDER HEAD | WAITING FOR AUTHORISATION | 42623.19 | 2013-08-31 00:00:00
379184 | 72967 | [NAME] | 48888 | HEIDELBERG | 215259 | BPD610NC | ADDT51000000003441 | FE6704609B | 188185 |  | NISSAN | UD60 | RRV | ADMIN | 2012-10-02 00:00:00 | 2012-10-02 00:00:00 | Y5647 | 2013-02-01 00:00:00 | 4501831039 |  |  |  | SERVICE AND COF | WORK IN PROGRESS | 18548.5 | 2012-07-31 00:00:00
379186 | 72966 | [NAME] | 48889 | HEIDELBERG | 215259 | BPD616NC | ADDT51000000003995 | FE62046038 | 175476 |  | NISSAN | UD60 | RRV | ADMIN | 2012-10-02 00:00:00 | 2012-10-02 00:00:00 | Y5648 | 2013-02-02 00:00:00 | 4501866723 |  |  |  | SERVICE AND COF | WORK IN PROGRESS | 17275.79 | 2012-07-31 00:00:00
379185 | 72965 | [NAME] | 48890 | HEIDELBERG | 215259 | BPD608NC | ADDT51000000003992 | FE6704600B | 216933 |  | NISSAN | UD60 | RRV | ADMIN | 2012-10-02 00:00:00 | 2012-10-02 00:00:00 | Y5649 | 2013-02-01 00:00:00 | 4501831039 |  |  |  | SERVICE AND COF | WORK IN PROGRESS | 27000.92 | 2012-08-31 00:00:00
376239 | 72974 | [NAME] | 48958 | ERMELO | 885010 | DJL897MP | ADMFTR33M1Z179464 | 6HH1316689 | 179871 |  | ISUZU | 800 FREIGHTER | H/V | ELECTICAL | 2012-10-09 00:00:00 | 2012-10-09 00:00:00 | Y5674 |  |  |  |  |  | ACCIDENT DAMAGE | WAITING FOR AUTHORISATION | 61431.39 | 2012-12-31 00:00:00
378903 | 78029 | [NAME] | 49368 | KRUGERSDORP | 715025 | NXF257GP | ADDT51000000003811 | FE6204352B | 227907 |  | NISSAN | UD60 | RRV | ELECTICAL | 2012-11-23 00:00:00 | 2012-11-26 00:00:00 | Y5743 | 2012-12-07 00:00:00 | 4501855710 |  |  |  | SERVICE AND REPAIRS | WORK IN PROGRESS | 58709.45 | 2013-01-31 00:00:00
380195 | 78017 | [NAME] | 49507 | ISANDO | 715023 | RBD774GP | ADMFTR33H1Z178482 | 6HH1317660 | 242170 |  | ISUZU | FRR 500 | H/V | ELECTICAL | 2012-12-13 00:00:00 | 2012-12-13 00:00:00 | Y5756 |  |  |  |  |  | REPAIRS | WAITING FOR AUTHORISATION | 12418.99 | 2013-08-31 00:00:00
380366 | 78016 | [NAME] | 49515 | ISANDO | 14029 | PRC393GP | ADDT16000000000593 | FE6305236B | 296574 |  | NISSAN | UD350 | H/V | SUPPLY CHAIN | 2012-12-18 00:00:00 | 2012-12-18 00:00:00 | Y5759 | 2013-01-16 00:00:00 | 4501859974 |  |  |  | SERVICE AND COF | WORK IN PROGRESS | 39372.63 | 2012-08-10 00:00:00
381639 | 78020 | [NAME] | 49615 | KRUGERSDORP | 715027 | NXF247GP | ADDT51000000003856 | FE6204374B | 277489 |  | NISSAN | UD60 | RRV | ELECTICAL | 2013-01-11 00:00:00 | 2013-01-15 00:00:00 | Y5553 | 2013-01-17 00:00:00 | 4501831039 |  |  |  | SERVICE & COF | WORK IN PROGRESS | 37246.91 | 2013-01-31 00:00:00
382264 | 78031 | [NAME] | 49347 | KIMBERLY | 215399 | BPD591NC | ADDT51000000003859 | FE6204377B | 159743 |  | NISSAN | UD60 | RRV | ADMIN | 2013-01-24 00:00:00 | 2013-01-24 00:00:00 | Y5739 |  |  |  |  |  | SERVICE & COF | WAITING FOR AUTHORISATION | 31985.21 | 2012-07-31 00:00:00
382625 | 78043 | [NAME] | 49347 | KIMBERLY | 215399 | BSL817NC | ADDT51000000003859 | FE6204377B | 159743 |  | NISSAN | UD60 | RRV | ADMIN | 2013-01-25 00:00:00 | 2013-01-25 00:00:00 | Y5739 | 2013-02-12 00:00:00 | 4501831039 |  |  |  | SERVICE & COF | WORK IN PROGRESS | 52505.77 | 31/06/2013
382616 | 78005 | [NAME] | 49578 | BLOEMFONTEIN | 515221 | CPW153FS | ADDT51000000003766 | FE62043038 | 232492 |  | NISSAN | UD60 | RRV | ADMIN | 2013-01-26 00:00:00 | 2013-01-26 00:00:00 | Y5798 | 2013-02-12 00:00:00 | 4501831039 |  |  |  | SERVICE & REPAIRS | WORK IN PROGRESS | 75701.79 | 2013-03-31 00:00:00
386053 | 78048 | [NAME] | 49885 | ISANDO | 715394 | SGP412GP | ADMFSR33L1Z208099 | 6HH1313305 | 98888 |  | ISUZU | 700 FREIGHTER | H/V | ELECTICAL | 2013-02-05 00:00:00 | 2013-02-05 00:00:00 | Y5818 | 2013-02-12 00:00:00 | 4501831039 |  |  |  | REPAIRS | WORK IN PROGRESS | 20721.45 | 2013-10-30 00:00:00
385964 | 1 | [NAME] | 49913 | ISANDO | 715394 | PNY134GP | ADMFSR33L1Z149032 | 6HH1310736 | 143495 |  | ISUZU | 700 FREIGHTER | H/V | ELECTICAL | 2013-02-06 00:00:00 | 2013-02-06 00:00:00 | Y5820 |  |  |  |  |  | REPAIRS | WAITING FOR AUTHORISATION | 3192.5 | 2013-07-31 00:00:00
386137 | 2 | [NAME] | 49977 | ISANDO | 715058 | STG003GP | ADMFTR33M1Z61526 | 6HH1407529 | 126812 |  | ISUZU | 800 FREIGHTER | H/V | ELECTICAL | 2013-02-08 00:00:00 | 2013-02-08 00:00:00 | Y5823 | 2013-02-12 00:00:00 | 4501831039 |  |  |  | COF | WORK IN PROGRESS | 4322.11 | 2013-01-31 00:00:00
386427 | 5 | [NAME] | 50013 | HEIDELBERG | 715554 | PPS871GP | ADDT51000000004586 | FE6205258B | 62337 |  | NISSAN | UD60 | RRV | PERWAY | 2013-02-13 00:00:00 | 2013-02-13 00:00:00 | Y5833 |  |  |  |  |  | REPAIRS | WAITING FOR AUTHORISATION | 4492.56 | 2013-09-30 00:00:00
386505 | 6 | [NAME] | 50019 | KRUGERSDORP | 715025 | NXF257GP | ADDT51000000003811 | FE6204352B | 227907 |  | NISSAN | UD60 | RRV | ELECTICAL | 2012-11-23 00:00:00 | 2012-11-26 00:00:00 | Y5835 |  |  |  |  |  | COF | WAITING FOR AUTHORISATION | 5914.51 | 2013-01-31 00:00:00
386651 | 7 | [NAME] | 48797 | ISANDO | 715058 | STG003GP | ADMFTR33M1Z61526 | 6HH1407529 | 126812 |  | ISUZU | 800 FREIGHTER | H/V | ELECTICAL | 2013-02-15 00:00:00 | 2013-02-15 00:00:00 | [NAME] |  |  |  |  |  | PTO PROPSHAFT | WAITING FOR AUTHORISATION | 2592 | 2013-01-31 00:00:00
386655 | 8 | [NAME] | 50034 | ISANDO | 715394 | PNY134GP | ADMFSR33L1Z149032 | 6HH1310736 | 143495 |  | ISUZU | 700 FREIGHTER | H/V | ELECTICAL | 2013-02-15 00:00:00 | 2013-02-15 00:00:00 | Y5841 |  |  |  |  |  | SERVICE AND COF | WAITING FOR AUTHORISATION | 6978.15 | 2013-07-31 00:00:00
 |  |  |  |  |  |  |  |  |  | 0