Spreadsheet: 859743d1708007308-changing-transport-route-transport-route-pq-dj
Sheet: Result Truck Route

The location A-L will rearrnage, then the recievd/Delivery jobs will also change accordingly. |  |  |  |  |  |  |  |  |  |  |  |  |  | Location | contact number | Received | Delivered
 |  |  |  |  |  |  |  |  |  |  |  |  |  | A | [NAME] | Food;Chair | Cabinet
A | à | C | à | B | à | E | à | F | à | D |  |  |  | B | [NAME] | Food;Chair;Cabinet | Goods;Chair
G | à | H | à | I | à | J | à | K | à | L |  |  |  | C | [NAME] | Drinks;Chair;Cabinet | Food;Chair;Cabinet
 |  |  |  |  |  |  |  |  |  |  |  |  |  | D | [NAME] | Food;Chair | Cabinet
Best Result, it is best if the space line will be omitted according to no. of jobs |  |  |  |  |  |  |  |  |  |  |  |  |  | E | [NAME] | Food;Chair;Cabinet | Goods;Chair
Locataion | A |  |  |  |  | Locataion | G |  |  |  |  |  |  | F | Sandy | Drinks;Chair;Cabinet | Food;Chair;Cabinet
Contact | [NAME] |  |  |  |  | Contact | [NAME] |  |  |  |  |  |  | G | [NAME] | Food;Chair | Cabinet
Recived | Food |  |  |  |  | Recived | Food |  |  |  |  |  |  | H | [NAME] | Food;Chair;Cabinet | Goods;Chair
 | Chair |  |  |  |  |  | Chair |  |  |  |  |  |  | I | Carol | Drinks;Chair;Cabinet | Food;Chair;Cabinet
Delivery | Cabinet |  |  |  |  | Delivery | Cabinet |  |  |  |  |  |  | J | [NAME] | Food;Chair | Cabinet
Locataion | C |  |  |  |  | Locataion | H |  |  |  |  |  |  | K | Eddie | Food;Chair;Cabinet | Goods;Chair
Contact | [NAME] |  |  |  |  | Contact | [NAME] |  |  |  |  |  |  | L | [NAME] | Drinks;Chair;Cabinet | Food;Chair;Cabinet
Recived | Drinks |  |  |  |  | Recived | Drinks
 | Chair |  |  |  |  |  | Chair
 | Cabinet |  |  |  |  |  | Cabinet
Delivery | Food |  |  |  |  | Delivery | Food
 | Chair |  |  |  |  |  | Chair |  |  |  |  |  |  | If you want a new order just fill the column 'O' bellow
 | Cabinet |  |  |  |  |  | Cabinet |  |  |  |  |  |  | New order
Locataion | B |  |  |  |  | Locataion | I |  |  |  |  |  |  | Location | contact number | Received | Delivered
Contact | [NAME] |  |  |  |  | Contact | Carol |  |  |  |  |  |  | A
Recived | Food |  |  |  |  | Recived | Food |  |  |  |  |  |  | C
 | Chair |  |  |  |  |  | Chair |  |  |  |  |  |  | B
 | Cabinet |  |  |  |  |  | Cabinet |  |  |  |  |  |  | E
Delivery | Goods |  |  |  |  | Delivery | Goods |  |  |  |  |  |  | F
 | Chair |  |  |  |  |  | Chair |  |  |  |  |  |  | D
Locataion | E |  |  |  |  | Locataion | J |  |  |  |  |  |  | G
Contact | [NAME] |  |  |  |  | Contact | [NAME] |  |  |  |  |  |  | H
Recived | Food |  |  |  |  | Recived | Food |  |  |  |  |  |  | I
 | Chair |  |  |  |  |  | Chair |  |  |  |  |  |  | J
 | Cabinet |  |  |  |  |  | Cabinet |  |  |  |  |  |  | K
Delivery | Goods |  |  |  |  | Delivery | Goods |  |  |  |  |  |  | L
 | Chair |  |  |  |  |  | Chair
Locataion | F |  |  |  |  | Locataion | K
Contact | Sandy |  |  |  |  | Contact
Recived | Drinks |  |  |  |  | Recived | Drinks
 | Chair |  |  |  |  |  | Chair
 | Cabinet |  |  |  |  |  | Cabinet
Delivery | Food |  |  |  |  | Delivery | Food
 | Chair |  |  |  |  |  | Chair
 | Cabinet |  |  |  |  |  | Cabinet
Locataion | D |  |  |  |  | Locataion | L
Contact | [NAME] |  |  |  |  | Contact | [NAME]
Recived | Food |  |  |  |  | Recived | Food
 | Chair |  |  |  |  |  | Chair
Delivery | Cabinet |  |  |  |  | Delivery | Cabinet