# What is Output Sheet ?

Module: Route Optimization
Module slug: route-optimization
Source URL: https://helpcentre.shipsy.io/en-US/shipsy/article/QIWOwKYR-how-to-understand-the-output-sheet
Article ID: QIWOwKYR
Breadcrumbs: Route Optimization > How to understand the 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.

![image.png](/kb-images/how-to-understand-the-output-sheet--qiwowkyr/img_001_99bf7fcd61.png)

### **Understanding**

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

|  |  |  |
| --- | --- | --- |
| S No | Tabs | Fields |
| 1 | Cluster Summary | trip # primary trip # trip type worker code vehicle code total consignments count total distance (km) total time (Hours) total weight (Tonnes) total volume (Cubic Meters) vehicle volume (Cubic Meters) vehicle weight (Tonnes) vehicle type vehicle utilisation route Vehicle Service Time(mins) Total Order Service Time(mins) Weight Utilization Percentage Volume Utilization Percentage Total Product Value Product Value Utilization Percent Trip Cost Multi Trip Order |
| 2 | Tasks Summary | trip # primary trip # reference number address latitude longitude  weight (Tonnes) volume (Cubic Meters) Vehicle Make Type total service time (Hours) Arrival Time (hh:mm:ss) Departure Time (hh:mm:ss) Destination Pincode Destination Pincode City Constraint Tags of The Task |
| 3 | Unallocated Tasks Summary | reference number address latitude longitude weight (Tonnes) volume (Cubic Meters) Constraint Tags of The Task |
| 4 | Dropped Reasons Summary | reference number worker code reason |

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