What is Output Sheet ?

The objective is to understand the Routing playground output sheet so that troubleshooting and analysis can be performed on it.

What is Output Sheet ?

An output sheet is the result (under Visualise tab/ FLM trips > Optimisation requests) that an user obtains after running the Optimiser in the form of an excel sheet.

Understanding

Contents of the Output sheet are mentioned in table below:-

As we can see in the table above, the output sheet has 4 tabs.

Now lets understand these one by one with some important fields

Cluster Summary

It is a trip level output where user can see all the trips created by the Optimiser

1. "trip # - This is an unique trip number created by optimiser
2. primary trip #
3. trip type
4. worker code - unique code of assigned worker/rider
5. vehicle code - unique code of assigned vehicle(generally the vehicle number)
6. total consignments count - sum of total CNs allocated/planned against the trip
7. total distance (km) - estimated round trip distance
8. total time (Hours) - estimated round trip time
9. total weight (Tonnes) - weight that trip will carry
10. total volume (Cubic Meters) - total volume that trip will take
11. vehicle volume (Cubic Meters) - Volume capacity of the vehicle
12. vehicle weight (Tonnes) - weight capacity of the vehicle
13. vehicle type
14. vehicle utilisation
15. route
16. Vehicle Service Time(mins)
17. Total Order Service Time(mins) - time that vehicle will take to service all the CNs
18. Weight Utilisation Percentage
19. Volume Utilisation Percentage
20. Total Product Value
21. Product Value Utilisation Percent
22. Trip Cost: Total cost of the trip
23. Multi Trip Order

Tasks Summary

It is a consignment level output where user can see all CNs allocated/planned by the Optimiser

1. trip # - trip number to which the consignment is assigned to
2. primary trip #
3. reference number - consignment number
4. address: address string of the destination address
5. latitude
6. longitude
7. weight (Tonnes)
8. volume (Cubic Meters)
9. Vehicle Make
10. Type
11. total service time (Hours)
12. Arrival Time (hh:mm:ss) - time at which vehicle will reach to a particular pickup/drop point
13. Departure Time (hh:mm:ss) - time at which vehicle will leave from a particular pickup/drop point
14. Destination Pincode
15. Destination Pincode City
16. Constraint Tags of The Task - tag mapped to the CN that is used to map the vehicle

Unallocated Tasks Summary

It is the list of all unallocated/dropped consignments

1. reference number - consignment number that has dropped
2. address
3. latitude
4. longitude
5. weight (Tonnes)
6. volume (Cubic Meters)
7. Constraint Tags of The Task

Dropped Reasons Summary

It is the list of all the reason that why a CN got dropped

1. reference number - consignment that has dropped
2. worker code - vehicle number tried
3. reason - reason of drop with that vehicle

Outcome

By understanding the output sheet we can simply divide it in two sections

1. Allocated: where CNs are planned in the trips, this can further be analysed that how optimum trips are created
2. Unallocated: initially this the most frequent part where client asks for understanding/debugging and here is the guide for it