4.4 Sheet: Solution Summary

4.4.1 Scenario Name

Type: Text.
Description: The name of the scenario from which the solution was generated. Matches the name field of the General sheet.

4.4.2 Total Iterations

Type: Number.
Description: The actual number of iterations completed by the optimiser before termination.

4.4.3 Total Cost

Type: Number.
Description: The total cost for all routes in the solution.

4.4.4 Total Distance

Type: Number.
Description: The total transit distance of all routes in the solution.

4.4.5 Loaded Distance

Type: Number.
Description: The total transit distance travelled in all routes while the vehicles are carrying at least one order.

4.4.6 Empty Distance

Type: Number.
Description: The total transit distance travelled in all routes while the vehicles are empty.

4.4.7 Average Transit Speed (km/h)

Type: Number.
Description: The average speed of the vehicles in the solution. This is derived by dividing the total transit distance by the total transit time. Only present if Use Miles in the General sheet is false.

4.4.8 Average Transit Speed (mph)

Type: Number.
Description: The average speed of the vehicles in the solution. This is derived by dividing the total transit distance by the total transit time. Only present if Use Miles in the General sheet is true.

4.4.9 Loads

Type: Number.
Description: If batched loads is true then the total number of loads in the solution.

4.4.10 Km Per Load

Type: Number.
Description: If batched loads is true and Use Miles is false then the average kilometres per load in the solution.

4.4.11 Miles Per Load

Type: Number.
Description: If batched loads and Use Miles are both true then the average miles per load in the solution.

4.4.12 Hours Per Load

Type: Excel time.
Description: If batched loads is true then the average time per load in the solution.

4.4.13 Drops Per Load

Type: Number.
Description: If batched loads is true then the total average number of drops per load in the solution.

4.4.14 Work Time

Type: Excel time.
Description: The total work time for all routes in the solution.

4.4.15 Transit Time

Type: Excel time.
Description: The total transit time for all routes in the solution.

4.4.16 Break Time

Type: Excel time.
Description: The total break time for all routes in the solution.

4.4.17 Idle Time

Type: Excel time.
Description: The total idle time for all routes in the solution.

4.4.18 Total Weight

Type: Number.
Description: The cumulative weight carried in all routes in the solution.

4.4.19 Total Volume

Type: Number.
Description: The cumulative volume carried in all routes in the solution.

4.4.20 Assigned Orders

Type: Number.
Description: The number of assigned orders represented as a fraction of the total number of orders.

4.4.21 Fleet Usage

Type: Number.
Description: The number of vehicles used in the solution represented as a fraction of the total number of vehicles.

4.4.22 Column: Pickup Soft Time Window Early

Type: Excel time.
Description: The total time an order’s pickup occurred before the start of its closest soft time window.

4.4.23 Column: Pickup Soft Time Window Late

Type: Excel time.
Description: The total time an order’s pickup occurred after the end of its closest soft time window.

4.4.24 Column: Delivery Soft Time Window Early

Type: Excel time.
Description: The total time an order’s delivery occurred before the start of its closest soft time window.

4.4.25 Column: Delivery Soft Time Window Late

Type: Excel time.
Description: The total time an order’s delivery occurred after the end of its closest soft time window.