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

 |  |  |  |  |  |  | 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
373481 | 873 | PRETORIA | D22615 | RUSTENBURG | FREIGHT RAIL | RCB093GP | AHHFC4HK00012498 | JO5CB17138 | 11636 |  | HINO | 9-136 | RRV | TRANSNET | 2012-08-14 00:00:00 | 2012-08-15 00:00:00 | D5899 | 2013-08-19 00:00:00 | CS-625543 |  |  |  | HYDRAULICS | WORK IN PROGRESS , WAITING PART | 12366.99 | 31/05/2013
379056 | 80020 | PRETORIA | D23050 | WITBANK | FREIGHT RAIL | PJK588GP | ADDT5100000004256 | FE6204874B | 26421 |  | NISSAN | UD 60 | RRV | TRANSNET | 2012-11-28 00:00:00 | 2012-11-28 00:00:00 | D5960 | 2012-12-14 00:00:00 | 4501865332 |  |  |  | ROTATING GEAR,CRANE WORM,CASING | WORK IN PROGRESS | 31286.37 | 30/09/2013
381801 | 79710 | PRETORIA | D5997 | CAPITAL PARK | TRANS FRTP | WCX407GP | T341131015 |  | 8348 |  | [NAME] | DRF450-6055 | SP | TRANSNET | 2013-01-11 00:00:00 | 2013-02-14 00:00:00 | D5997 |  |  |  |  |  | RATKAS | QUOTE IN PROGRESS
386085 | 1020 | PRETORIA | D23255 | RUSTENBURG | FREIGHT RAIL | RCZ818GP | ADDT51000000H778 | FE625513B | 188524 |  | NISSAN | UD 60 | RRV | TRANSNET | 2013-01-02 00:00:00 | 2012-07-02 00:00:00 | D5988 | 2013-02-13 00:00:00 | 4501831039 |  |  |  | RIM,MIRROR | WORK IN PROGRESS | 4835.77 | 2013-07-31 00:00:00
385830 | 79332 | PRETORIA | D23213 | RUSTENBURG | FREIGHT RAIL | RCB093GP | AHHFC4HK00012498 | JO5CB17138 | 122125 |  | HINO | 9-136 | RRV | TRANSNET | 2013-02-04 00:00:00 | 2013-02-04 00:00:00 | D5980 | 2013-02-05 00:00:00 | 4501831039 |  |  |  | SAFETY CATCH,TIGHTEN CREEP MOTOR | WORK IN PROGRESS | 24693.48 | 2013-05-31 00:00:00
385829 | 1015 | PRETORIA | D5981 | KOEDOES | TRANS ENGIN | VJM705GP | AA9T265HY6ULF1805 | 953946 |  | 3146.4 | FORKLIFT | 3TON | SP | TRANSNET | 2013-02-04 00:00:00 | 2013-02-04 00:00:00 | D5981 |  |  |  |  |  | SLIDERS | WAITING FOR AUTHORISATION | 2628.73
386022 | 1019 | PRETORIA | D5986 | KOEDOES | TRANS ENGIN | DFZ864FS | AA9T2934HY64LF1676 | JSN179W |  | 2121 | FORKLIFT | TCM | SP | TRANSNET | 2013-02-06 00:00:00 | 2013-02-06 00:00:00 | D5986 |  |  |  |  |  | DIESEL PUMP, INJECTORS,TRANSFER PUMP | WAITING FOR AUTHORISATION | 19493.43
382049 | 80045 | PRETORIA | D23263 | RUSTENBURG | FREIGHT RAIL | RCB093GP | AHHFC4HK00012498 | JO5CB17138 | 11636 |  | HINO | 9-136 | RRV | TRANSNET | 2013-01-22 00:00:00 | 2013-01-22 00:00:00 | D5973 | 2013-02-15 00:00:00 | 4501831039 |  |  |  | EXHAUST | WORK IN PROGRESS | 4747.8 | 2013-05-31 00:00:00
386087 | 1025 | PRETORIA | D5989 | KOEDOES | TRANS ENGIN | TBW403GP | FG0310829 | FG0310829 |  | 4255 | HYUNDAI | HDF30-5 | SP | TRANSNET | 2013-02-06 00:00:00 | 2013-02-07 00:00:00 | D5989 |  |  |  |  |  | SERVICE | WAITING FOR AUTHORISATION | 2534.81
386208 | 79333 | PRETORIA | D5991 | KOEDOES | FREIGHT RAIL | PYR907GP | AHHFC4JHK00012483 | [NAME] | 66113 |  | TOYOTA | 9-136 | RRV | TRANSNET | 2013-01-30 00:00:00 | 2013-02-11 00:00:00 | D5991 |  |  |  |  |  | WINDSCREEN,C.O.F,GEARBOX,FLAP,RRS SERVICE | WAITING FOR AUTHORISATION | 106376.24 | 31/12/2012
386346 | 1036 | PRETORIA | [NAME] | WITBANK | FREIGHT RAIL | PJK504GP | ADDT510000004235 | FE6204868B | 223529 |  | NISSAN | UD 60 | RRV | TRANSNET | 2013-02-11 00:00:00 | 2013-02-12 00:00:00 | D5992 | 2013-02-15 00:00:00 | 4501831039 |  |  |  | BEARINGS,BLADES,CRANE TEST,GLOBES | WORK IN PROGRESS | 28863.83 | 2013-05-31 00:00:00
386382 | 1038 | PRETORIA | D5995 | KOEDOES | FREIGHT RAIL | PJK538GP | ADDT51000000004253 | FE6204856B | 173857 |  | NISSAN | UD 60 | RRV | TRANSNET | 2013-02-12 00:00:00 | 2013-02-13 00:00:00 | D5995 |  |  |  |  |  | CRANE TEST,MUDFLAPS,CABLE,SEALS | WAITING FOR AUTHORISATION | 39750.26 | 31/01/2013
386576 | 1037 | PRETORIA | D23268 | WITBANK | FREIGHT RAIL | PJK566GP | ADDT5100000004238 | FE6204870B | 146360 |  | NISSAN | UD 60 | RRV | TRANSNET | 2013-02-15 00:00:00 | 2013-02-15 00:00:00 | D5996 | 2013-02-15 00:00:00 | 4501831039 |  |  |  | CRANE TEST,CHAIN,BRAKES,SWEEPER PLATES | WORK IN PROGRESS | 38564.14 | 2013-05-31 00:00:00
 |  |  |  |  |  |  |  |  |  | 9522.4