Spreadsheet: 494080d1482165324-sort-array-formula-results-in-descending-order-sort-array-formula-results-in-descending-order-download-example-1
Sheet: PS_PLANNING

 | PRODUCTION PLANNING SHEET |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ]
 | ITEM |  |  |  |  |  |  | DESIGN STAGE |  |  | PROCUREMENT |  |  |  |  | WORKSHOP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DELIVERY
 | ITEM NO | JOB NO. | [NAME] | QTY | VALUE  (EXC DESIGN & FITTING) | SIZE | SPECIFICATION | TOTAL DESIGN HOURS | ACTUAL WORKING DAYS | SITE SURVEY REQUIRED? | SPECILIST SUB-CONTRACT ELEMENTS? | PRE-ORDER SPECILIST MATERIALS/FIXINGS? | EXTERNAL FITTING TEAM SCHEDULED? | TARGET DELIVERY? |  | ACTUAL DATE ISSUED TO WORKSHOP | TOTAL WORKSHOP HOURS | ACTUAL WORKING DAYS | KINTBURY OR DORSET? | MAKER | MILL | CNC | METAL SHOP | WORK SHOP | VENEER | FINISHING | FINISHED | MAKER | MILL | CNC | METAL SHOP | WORK SHOP | VENEER | FINISHING | FINISHED |  | ACTUAL DELIVERY DATE | DAY | DELIVERY TYPE | DELIVERY COUNT  (BY JOB) | DELIVERY ORDER | DRIVER | T/PORT | TIME | CLIENT/CUSTOMER | JOB NAME | ADDRESS | P/CODE | CONTACT NAME | PHONE NO. | DELIVERY RESTRICTIONS
 | 1 | CA67 | Test Job AA - Description 1 | 1 | 150 | Test Job AA - Size 1 | Test Job AA - spec 1 | 1 | 0 | Y | TEST JOB AA SUB 1 | TEST JOB AA MATERIAL ORDER 1 | TEST JOB AA - FIT TEAM 1 | 2017-02-03 00:00:00 | 0 | 00:00:00 | 1.5 | 0 | SITE 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | HG | Y | 0 | Y | 0 | Y | 0 | 0 | 0 | 2017-02-03 00:00:00 |  | DELIVERY | DEL 1 | 1 | Driver 1 | Vehicle 1 | 9 - 12 | TEST CLIENT 1 | TEST JOB AA | TEST JOB AA ADDRESS LINE 2 ADDRESS LINE 3 | RG17 AAP | TEST JOB AA SITE CONTACT | TEST JOB AA TEL NO. | TEST JOB AA SITE RESTRICTIONS
 | 2 | CA67 | Test Job AA - Description 2 | 2 | 250 | Test Job AA - Size 2 | Test Job AA - spec 2 | 2 | 0 | Y | TEST JOB AA SUB 2 | TEST JOB AA MATERIAL ORDER 2 | TEST JOB AA - FIT TEAM 2 | 2017-02-03 00:00:00 | 0 | 0 | 2.5 | 0 | SITE 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | HG | 0 | Y | 0 | Y | 0 | 0 | Y | 0 | 2017-02-07 00:00:00 |  | SITE | DEL 2 | 1 | Driver 2 | Vehicle 3 | 15 - 17 | TEST CLIENT 1 | TEST JOB AA | TEST JOB AA ADDRESS LINE 2 ADDRESS LINE 3 | RG17 AAP | TEST JOB AA SITE CONTACT | TEST JOB AA TEL NO. | TEST JOB AA SITE RESTRICTIONS
 | 3 | CA67 | Test Job AA - Description 3 | 3 | 350 | Test Job AA - Size 3 | Test Job AA - spec 3 | 3 | 0 | N | TEST JOB AA SUB 3 | TEST JOB AA MATERIAL ORDER 3 | TEST JOB AA - FIT TEAM 3 | 2017-02-03 00:00:00 | 0 | 0 | 3.5 | 0 | SITE 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | DF | Y | Y | Y | Y | Y | 0 | 0 | 0 | 2017-02-03 00:00:00 |  | SITE | DEL 1 | 1 | Driver 1 | Vehicle 1 | 9 - 12 | TEST CLIENT 1 | TEST JOB AA | TEST JOB AA ADDRESS LINE 2 ADDRESS LINE 3 | RG17 AAP | TEST JOB AA SITE CONTACT | TEST JOB AA TEL NO. | TEST JOB AA SITE RESTRICTIONS
 | 4 | CA67 | Test Job AA - Description 4 | 4 | 450 | Test Job AA - Size 4 | Test Job AA - spec 4 | 4 | 0 | N | TEST JOB AA SUB 4 | TEST JOB AA MATERIAL ORDER 4 | TEST JOB AA - FIT TEAM 4 | 2017-02-03 00:00:00 | 0 | 0 | 4.5 | 0 | SITE 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | JK | 0 | 0 | Y | 0 | Y | 0 | 0 | 0 | 2017-02-03 00:00:00 |  | CLIENT COLLECT | DEL 1 | 2 | Driver 1 | Vehicle 1 | 9 - 12 | TEST CLIENT 1 | TEST JOB AA | TEST JOB AA ADDRESS LINE 2 ADDRESS LINE 3 | RG17 AAP | TEST JOB AA SITE CONTACT | TEST JOB AA TEL NO. | TEST JOB AA SITE RESTRICTIONS
 | 5 | CA67 | Test Job AA - Description 5 | 5 | 550 | Test Job AA - Size 5 | Test Job AA - spec 5 | 5 | 0 | Y | TEST JOB AA SUB 5 | TEST JOB AA MATERIAL ORDER 5 | TEST JOB AA - FIT TEAM 5 | 2017-02-03 00:00:00 | 0 | 0 | 5.5 | 0 | ALL OUTSOURSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | DD | 0 | 0 | Y | 0 | Y | 0 | Y | 0 | 2017-02-07 00:00:00 |  | DELIVERY | DEL 2 | 1 | Driver 2 | Vehicle 3 | 15 - 17 | TEST CLIENT 1 | TEST JOB AA | TEST JOB AA ADDRESS LINE 2 ADDRESS LINE 3 | RG17 AAP | TEST JOB AA SITE CONTACT | TEST JOB AA TEL NO. | TEST JOB AA SITE RESTRICTIONS
 | 6 | CA67 | Test Job AA - Description 6 | 6 | 650 | Test Job AA - Size 6 | Test Job AA - spec 6 | 6 | 0 | Y | TEST JOB AA SUB 6 | TEST JOB AA MATERIAL ORDER 6 | TEST JOB AA - FIT TEAM 6 | 2017-02-03 00:00:00 | 0 | 0 | 6.5 | 0 | SITE 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | TG | 0 | Y | Y | 0 | 0 | 0 | 0 | 0 | 2017-02-07 00:00:00 |  | SITE | DEL 2 | 1 | Driver 2 | Vehicle 3 | 15 - 17 | TEST CLIENT 1 | TEST JOB AA | TEST JOB AA ADDRESS LINE 2 ADDRESS LINE 3 | RG17 AAP | TEST JOB AA SITE CONTACT | TEST JOB AA TEL NO. | TEST JOB AA SITE RESTRICTIONS
 | 7 | CA67 | Test Job AA - Description 7 | 7 | 750 | Test Job AA - Size 7 | Test Job AA - spec 7 | 7 | 0 | N | TEST JOB AA SUB 7 | TEST JOB AA MATERIAL ORDER 7 | TEST JOB AA - FIT TEAM 7 | 2017-02-03 00:00:00 | 0 | 0 | 7.5 | 0 | SITE 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | MM | 0 | Y | 0 | 0 | Y | 0 | Y | 0 | 2017-02-22 00:00:00 |  | DELIVERY | DEL 3 | 3 | Driver 4 | Vehicle 2 | 7 - 9 | TEST CLIENT 1 | TEST JOB AA | TEST JOB AA ADDRESS LINE 2 ADDRESS LINE 3 | RG17 AAP | TEST JOB AA SITE CONTACT | TEST JOB AA TEL NO. | TEST JOB AA SITE RESTRICTIONS
 | 8 | CA67 | Test Job AA - Description 8 | 8 | 850 | Test Job AA - Size 8 | Test Job AA - spec 8 | 8 | 0 | N | TEST JOB AA SUB 8 | TEST JOB AA MATERIAL ORDER 8 | TEST JOB AA - FIT TEAM 8 | 2017-02-03 00:00:00 | 0 | 0 | 8.5 | 0 | SITE 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | PE | 0 | Y | 0 | 0 | Y | 0 | 0 | 0 | 2017-02-25 00:00:00 |  | COLLECTION | DEL 4 | 2 | Driver 1 | Vehicle 4 | 15 - 16 | TEST CLIENT 1 | TEST JOB AA | TEST JOB AA ADDRESS LINE 2 ADDRESS LINE 3 | RG17 AAP | TEST JOB AA SITE CONTACT | TEST JOB AA TEL NO. | TEST JOB AA SITE RESTRICTIONS
 | 1 | CB34 | Test Job BB - Description 1 | 1 | 1050 | Test Job BB - Size 1 | Test Job BB - spec 1 | 10 | 0 | N | TEST JOB AA SUB 1 | TEST JOB AA MATERIAL ORDER 1 | TEST JOB AA - FIT TEAM 1 | 2017-03-03 00:00:00 | 0 | 0 | 10.5 | 0 | SITE 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | PE | Y | Y | Y | 0 | Y | 0 | 0 | 0 | 2017-02-22 00:00:00 |  | DELIVERY | DEL 1 | 1 | Driver 4 | Vehicle 2 | 12 - 1 | TEST CLIENT 1 | TEST JOB BB | TEST JOB BB ADDRESS LINE 2 ADDRESS LINE 3 | TN5 BB | TEST JOB BB SITE CONTACT | TEST JOB BB TEL NO. | TEST JOB BB SITE RESTRICTIONS
 | 2 | CB34 | Test Job BB - Description 2 | 2 | 2050 | Test Job BB - Size 2 | Test Job BB - spec 2 | 20 | 0 | N | TEST JOB AA SUB 2 | TEST JOB AA MATERIAL ORDER 2 | TEST JOB AA - FIT TEAM 2 | 2017-03-03 00:00:00 | 0 | 0 | 20.5 | 0 | SITE 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | H | 0 | Y | 0 | 0 | 0 | 0 | Y | 0 | 2017-02-22 00:00:00 |  | SITE | DEL 1 | 4 | Driver 4 | Vehicle 2 | 12 - 1 | TEST CLIENT 1 | TEST JOB BB | TEST JOB BB ADDRESS LINE 2 ADDRESS LINE 3 | TN5 BB | TEST JOB BB SITE CONTACT | TEST JOB BB TEL NO. | TEST JOB BB SITE RESTRICTIONS
 | 3 | CB34 | Test Job BB - Description 3 | 3 | 3050 | Test Job BB - Size 3 | Test Job BB - spec 3 | 30 | 0 | N | TEST JOB AA SUB 3 | TEST JOB AA MATERIAL ORDER 3 | TEST JOB AA - FIT TEAM 3 | 2017-03-03 00:00:00 | 0 | 0 | 30.5 | 0 | SITE 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | S | Y | 0 | Y | 0 | Y | 0 | 0 | 0 | 2017-02-25 00:00:00 |  | SITE | DEL 2 | 1 | Driver 1 | Vehicle 4 | 12 - 1 | TEST CLIENT 1 | TEST JOB BB | TEST JOB BB ADDRESS LINE 2 ADDRESS LINE 3 | TN5 BB | TEST JOB BB SITE CONTACT | TEST JOB BB TEL NO. | TEST JOB BB SITE RESTRICTIONS
 | 4 | CB34 | Test Job BB - Description 4 | 4 | 4050 | Test Job BB - Size 4 | Test Job BB - spec 4 | 40 | 0 | Y | TEST JOB AA SUB 4 | TEST JOB AA MATERIAL ORDER 4 | TEST JOB AA - FIT TEAM 4 | 2017-03-03 00:00:00 | 0 | 0 | 40.5 | 0 | SITE 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | F | 0 | 0 | 0 | 0 | Y | 0 | 0 | 0 | 2017-02-22 00:00:00 |  | DELIVERY | DEL 1 | 1 | Driver 4 | Vehicle 1 | 12 - 1 | TEST CLIENT 1 | TEST JOB BB | TEST JOB BB ADDRESS LINE 2 ADDRESS LINE 3 | TN5 BB | TEST JOB BB SITE CONTACT | TEST JOB BB TEL NO. | TEST JOB BB SITE RESTRICTIONS
 | 5 | CB34 | Test Job BB - Description 5 | 5 | 5050 | Test Job BB - Size 5 | Test Job BB - spec 5 | 50 | 0 | Y | TEST JOB AA SUB 5 | TEST JOB AA MATERIAL ORDER 5 | TEST JOB AA - FIT TEAM 5 | 2017-03-03 00:00:00 | 0 | 0 | 50.5 | 0 | ALL OUTSOURSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | W | 0 | 0 | Y | 0 | Y | 0 | Y | 0 | 2017-02-25 00:00:00 |  | DELIVERY | DEL 2 | 1 | Driver 1 | Vehicle 4 | 12 - 1 | TEST CLIENT 1 | TEST JOB BB | TEST JOB BB ADDRESS LINE 2 ADDRESS LINE 3 | TN5 BB | TEST JOB BB SITE CONTACT | TEST JOB BB TEL NO. | TEST JOB BB SITE RESTRICTIONS
 | 6 | CB34 | Test Job BB - Description 6 | 6 | 6050 | Test Job BB - Size 6 | Test Job BB - spec 6 | 60 | 0 | N | TEST JOB AA SUB 6 | TEST JOB AA MATERIAL ORDER 6 | TEST JOB AA - FIT TEAM 6 | 2017-03-03 00:00:00 | 0 | 0 | 60.5 | 0 | SITE 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | F | 0 | Y | 0 | 0 | Y | Y | 0 | 0 | 2017-03-22 00:00:00 |  | DELIVERY | DEL 3 | 1 | Driver 3 | Vehicle 5 | 11 - 13 | TEST CLIENT 1 | TEST JOB BB | TEST JOB BB ADDRESS LINE 2 ADDRESS LINE 3 | TN5 BB | TEST JOB BB SITE CONTACT | TEST JOB BB TEL NO. | TEST JOB BB SITE RESTRICTIONS
 | 7 | CB34 | Test Job BB - Description 7 | 7 | 7050 | Test Job BB - Size 7 | Test Job BB - spec 7 | 70 | 0 | Y | TEST JOB AA SUB 7 | TEST JOB AA MATERIAL ORDER 7 | TEST JOB AA - FIT TEAM 7 | 2017-03-03 00:00:00 | 0 | 0 | 70.5 | 0 | SITE 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | S | 0 | Y | Y | Y | Y | 0 | Y | 0 | 2017-03-22 00:00:00 |  | DELIVERY | DEL 3 | 1 | Driver 3 | Vehicle 5 | 11 - 13 | TEST CLIENT 1 | TEST JOB BB | TEST JOB BB ADDRESS LINE 2 ADDRESS LINE 3 | TN5 BB | TEST JOB BB SITE CONTACT | TEST JOB BB TEL NO. | TEST JOB BB SITE RESTRICTIONS
 | 8 | CB34 | Test Job BB - Description 8 | 8 | 8050 | Test Job BB - Size 8 | Test Job BB - spec 8 | 80 | 0 | Y | TEST JOB AA SUB 8 | TEST JOB AA MATERIAL ORDER 8 | TEST JOB AA - FIT TEAM 8 | 2017-03-03 00:00:00 | 0 | 0 | 80.5 | 0 | SITE 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | DD | 0 | Y | Y | 0 | Y | 0 | 0 | 0 | 2017-03-22 00:00:00 |  | SITE | DEL 3 | 1 | Driver 3 | Vehicle 5 | 11 - 13 | TEST CLIENT 1 | TEST JOB BB | TEST JOB BB ADDRESS LINE 2 ADDRESS LINE 3 | TN5 BB | TEST JOB BB SITE CONTACT | TEST JOB BB TEL NO. | TEST JOB BB SITE RESTRICTIONS
 | 1 | CC81 | Test Job CC - Description 1 | 10 | 88 | Test Job CC - Size 1 | Test Job CC - spec 1 | 22 | 0 | Y | TEST JOB AA SUB 1 | TEST JOB AA MATERIAL ORDER 1 | TEST JOB AA - FIT TEAM 1 | 2017-04-03 00:00:00 | 0 | 0 | 0.88 | 0 | SITE 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | R | 0 | Y | Y | 0 | Y | 0 | 0 | 0 | 2017-04-03 00:00:00 |  | DELIVERY | DEL 2 | 1 | Driver 3 | Vehicle 1 | 9 - 17 | TEST CLIENT 2 | TEST JOB CC | TEST JOB CC ADDRESS LINE 2 ADDRESS LINE 3 | RG30 1CC | TEST JOB CC SITE CONTACT | TEST JOB CC TEL NO. | TEST JOB CC SITE RESTRICTIONS
 | 2 | CC81 | Test Job CC - Description 2 | 2 | 77 | Test Job CC - Size 2 | Test Job CC - spec 2 | 4 | 0 | Y | TEST JOB AA SUB 2 | TEST JOB AA MATERIAL ORDER 2 | TEST JOB AA - FIT TEAM 2 | 2017-04-03 00:00:00 | 0 | 0 | 0.7700000000000001 | 0 | SITE 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | F | 0 | Y | 0 | 0 | 0 | 0 | Y | 0 | 2017-03-22 00:00:00 |  | SITE | DEL 1 | 2 | Driver 3 | Vehicle 5 | 6 - 8 | TEST CLIENT 2 | TEST JOB CC | TEST JOB CC ADDRESS LINE 2 ADDRESS LINE 3 | RG30 1CC | TEST JOB CC SITE CONTACT | TEST JOB CC TEL NO. | TEST JOB CC SITE RESTRICTIONS
 | 3 | CC81 | Test Job CC - Description 3 | 77 | 99 | Test Job CC - Size 3 | Test Job CC - spec 3 | 6 | 0 | Y | TEST JOB AA SUB 3 | TEST JOB AA MATERIAL ORDER 3 | TEST JOB AA - FIT TEAM 3 | 2017-04-03 00:00:00 | 0 | 0 | 0.99 | 0 | SITE 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | S | Y | 0 | Y | 0 | 0 | 0 | 0 | 0 | 2017-03-22 00:00:00 |  | SITE | DEL 1 | 2 | Driver 3 | Vehicle 5 | 6 - 8 | TEST CLIENT 2 | TEST JOB CC | TEST JOB CC ADDRESS LINE 2 ADDRESS LINE 3 | RG30 1CC | TEST JOB CC SITE CONTACT | TEST JOB CC TEL NO. | TEST JOB CC SITE RESTRICTIONS
 | 4 | CC81 | Test Job CC - Description 4 | 4 | 66 | Test Job CC - Size 4 | Test Job CC - spec 4 | 3 | 0 | Y | TEST JOB AA SUB 4 | TEST JOB AA MATERIAL ORDER 4 | TEST JOB AA - FIT TEAM 4 | 2017-04-03 00:00:00 | 0 | 0 | 0.66 | 0 | SITE 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | S | 0 | 0 | Y | Y | 0 | Y | 0 | 0 | 2017-03-22 00:00:00 |  | DELIVERY | DEL 2 | 1 | Driver 3 | Vehicle 1 | 9 - 17 | TEST CLIENT 2 | TEST JOB CC | TEST JOB CC ADDRESS LINE 2 ADDRESS LINE 3 | RG30 1CC | TEST JOB CC SITE CONTACT | TEST JOB CC TEL NO. | TEST JOB CC SITE RESTRICTIONS
 | 5 | CC81 | Test Job CC - Description 5 | 7 | 44 | Test Job CC - Size 5 | Test Job CC - spec 5 | 3 | 0 | Y | TEST JOB AA SUB 5 | TEST JOB AA MATERIAL ORDER 5 | TEST JOB AA - FIT TEAM 5 | 2017-04-03 00:00:00 | 0 | 0 | 0.44 | 0 | ALL OUTSOURSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | HH | 0 | 0 | Y | Y | Y | 0 | Y | 0 | 2017-03-22 00:00:00 |  | DELIVERY | DEL 2 | 1 | Driver 3 | Vehicle 1 | 9 - 17 | TEST CLIENT 2 | TEST JOB CC | TEST JOB CC ADDRESS LINE 2 ADDRESS LINE 3 | RG30 1CC | TEST JOB CC SITE CONTACT | TEST JOB CC TEL NO. | TEST JOB CC SITE RESTRICTIONS
 | 6 | CC81 | Test Job CC - Description 6 | 77 | 777 | Test Job CC - Size 6 | Test Job CC - spec 6 | 255 | 0 | Y | TEST JOB AA SUB 6 | TEST JOB AA MATERIAL ORDER 6 | TEST JOB AA - FIT TEAM 6 | 2017-04-03 00:00:00 | 0 | 0 | 7.77 | 0 | SITE 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | SS | 0 | Y | 0 | 0 | Y | Y | 0 | 0 | 2017-02-22 00:00:00 |  | DELIVERY | DEL 2 | 2 | Driver 3 | Vehicle 1 | 9 - 17 | TEST CLIENT 2 | TEST JOB CC | TEST JOB CC ADDRESS LINE 2 ADDRESS LINE 3 | RG30 1CC | TEST JOB CC SITE CONTACT | TEST JOB CC TEL NO. | TEST JOB CC SITE RESTRICTIONS
 | 7 | CC81 | Test Job CC - Description 7 | 200 | 444 | Test Job CC - Size 7 | Test Job CC - spec 7 | 6 | 0 | N | TEST JOB AA SUB 7 | TEST JOB AA MATERIAL ORDER 7 | TEST JOB AA - FIT TEAM 7 | 2017-04-03 00:00:00 | 0 | 0 | 4.44 | 0 | SITE 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | DD | 0 | 0 | Y | Y | Y | 0 | Y | 0 | 2017-02-22 00:00:00 |  | DELIVERY | DEL 2 | 2 | Driver 3 | Vehicle 4 | 9 - 17 | TEST CLIENT 2 | TEST JOB CC | TEST JOB CC ADDRESS LINE 2 ADDRESS LINE 3 | RG30 1CC | TEST JOB CC SITE CONTACT | TEST JOB CC TEL NO. | TEST JOB CC SITE RESTRICTIONS
 | 8 | CC81 | Test Job CC - Description 8 | 44 | 4567 | Test Job CC - Size 8 | Test Job CC - spec 8 | 33 | 0 | N | TEST JOB AA SUB 8 | TEST JOB AA MATERIAL ORDER 8 | TEST JOB AA - FIT TEAM 8 | 2017-04-03 00:00:00 | 0 | 0 | 45.67 | 0 | SITE 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | II | 0 | Y | 0 | Y | Y | 0 | 0 | 0 | 2017-02-22 00:00:00 |  | CLIENT COLLECT | DEL 2 | 5 | Driver 3 | Vehicle 4 | 9 - 17 | TEST CLIENT 2 | TEST JOB CC | TEST JOB CC ADDRESS LINE 2 ADDRESS LINE 3 | RG30 1CC | TEST JOB CC SITE CONTACT | TEST JOB CC TEL NO. | TEST JOB CC SITE RESTRICTIONS