3.7 Sheet: Fleet

This sheet must be defined and contain at least one vehicle.

3.7.1 Column: Id

Required: Yes.
Type: Text or (integer) number.
Description: Each vehicle must be have a unique identifier. Note that a vehicle’s identifier can also function as an attribute name.

3.7.2 Column: Vehicle Type

Required: No.
Type: Text or (integer) number.
Description: The identifier of a vehicle type defined in the Vehicle Type sheet.

3.7.3 Column: Name

Required: No.
Type: Text.
Default: No name.
Description: A descriptive name for the vehicle.

3.7.4 Column: Start Location

Required: No.
Type: Text or (integer) number.
Default: The vehicle begins its route at its first pickup location.
Description: The identifier of the location in the Locations sheet where the vehicle starts its route.

3.7.5 Column: Finish Location

Required: No.
Type: Text or (integer) number.
Default: The vehicle finishes its route at its last delivery location.
Description: The identifier of the location in the Locations sheet where the vehicle must end its route. The transit time and distance associated with returning to this location after the last delivery are considered by the solution.

3.7.6 Column: Maximum Weight

Required: Yes.
Type: Number.
Default: 0.
Description: Maximum weight the vehicle can carry. Units are unspecified but must be consistent with orders’ weights. Must be nonnegative.

3.7.7 Column: Maximum Volume

Required: Yes.
Type: Number.
Default: 0.
Description: Maximum volume the vehicle can carry. Units are unspecified but must be consistent with orders’ volumes. Must be nonnegative.

3.7.8 Column: Earliest Start Time

Required: No.
Type: Text (HH:MM).
Default: 00:00.
Description: Earliest time a vehicle can start at the start location.

3.7.9 Column: Latest Start Time

Required: No.
Type: Excel time.
Default: No latest start time.
Description: Latest time a vehicle can start at the start location.

3.7.10 Column: Latest Finish Time

Required: No.
Type: Excel time.
Default: No latest finish time.
Description: Latest time a vehicle must arrive at the finish location.

3.7.11 Column: Minimum Paid Time

Required: No.
Type: Excel time.
Default: 00:00.
Description: A minimum amount of time that this vehicle’s cost-per-hour will be incurred. If the vehicle’s actual working time is less than this, then the hourly cost will be this value multiplied by the cost-per-hour instead.

3.7.12 Column: Maximum Drive Time

Required: No.
Type: Excel time.
Default: Inferred from data.
Description: Maximum time a vehicle can drive for. Must be nonnegative.

3.7.13 Column: Maximum Work Time

Required: No.
Type: Excel time.
Default: Inferred from data.
Description: Maximum time a vehicle can work for, calculated from the start time to finish time. Must be nonnegative.

3.7.14 Column: Load Time

Required: No.
Type: Excel time.
Default: 00:00.
Description: Time needed to load vehicle. (See Load Time in Section  2.11.)
Must be nonnegative.

3.7.15 Column: Unload Time

Required: No.
Type: Excel time.
Default: 00:00.
Description: Time needed to unload the vehicle. (See Unload Time in Section  2.11.)
Must be nonnegative.

3.7.16 Column: Speed Scale

Required: No.
Type: Number.
Default: 0 (means no speed scale).
Description: Nonnegative speed scale multiplier for the vehicle. (See Speed Scale in Section  2.11.)

3.7.17 Column: Cost per Use

Required: No.
Type: Number.
Default: 0.
Description: A fixed cost for using the vehicle.

3.7.18 Column: Cost per Hour

Required: No.
Type: Number.
Default: 0.
Description: Cost incurred per hour of vehicle’s work time.

3.7.19 Column: Cost per Kilometre

Required: No.
Type: Number.
Default: 0.
Description: Cost incurred per kilometre of transit distance.
Note: If the parameter Use Miles is TRUE in the General sheet then this column must not be present.

3.7.20 Column: Cost per Mile

Required: No.
Type: Number.
Default: 0.
Description: Cost incurred per mile of transit distance.
Note: If the parameter Use Miles is FALSE in the General sheet then this column must not be present.

3.7.21 Column: Cost per Load

Required: No.
Type: Number.
Default: 0.
Description: Cost incurred for each load. Only applied if batched loads is enabled.

3.7.22 Column: Hidden Cost per Use

Required: No.
Type: Number.
Default: 0.
Description: Hidden “cost” for using the vehicle. This is not included in the cost calculation for the solution and could be used to prioritise certain vehicles.

3.7.23 Column: Hidden Cost per Hour

Required: No.
Type: Number.
Default: 0.
Description: Additional cost incurred per hour of vehicle use. This is not included in the cost calculation for the solution and could be used to prioritise vehicles.

3.7.24 Column: Hidden Cost per Kilometre

Required: No.
Type: Number.
Default: 0.
Description: Additional cost incurred per km of vehicle use. This is not included in the cost calculation for the solution and could be used to prioritise certain vehicles.
Note: If the parameter Use Miles is TRUE in the General sheet then this column must not be present.

3.7.25 Column: Hidden Cost per Mile

Required: No.
Type: Number.
Default: 0.
Description: Additional cost incurred per mile of vehicle use. This is not included in the cost calculation for the solution and could be used to prioritise certain vehicles.
Note: If the parameter Use Miles is FALSE in the General sheet then this column cannot be present.

3.7.26 Column: Hidden Cost per Load

Required: No.
Type: Number.
Default: 0.
Description: Additional cost incurred for each load. This is not included in the cost calculation for the solution. Only applied if batched loads is enabled.

3.7.27 Column: Finish Segment Distance Penalty

Required: No.
Type: Number.
Default: 0.
Description: The per-unit distance component of the finish segment penalty for this vehicle. Must be nonnegative.

3.7.28 Column: Finish Segment Per Hour Penalty

Required: No.
Type: Number.
Default: 0.
Description: The per hour component of the finish segment penalty for this vehicle. Must be nonnegative.

3.7.29 Column: Delivery Segment Fixed Penalty

Required: No.
Type: Number.
Default: 0.
Description: The fixed component of the delivery segment penalty for this vehicle. Must be nonnegative.

3.7.30 Column: Delivery Segment Distance Penalty

Required: No.
Type: Number.
Default: 0.
Description: The per-unit distance component of the delivery segment penalty for this vehicle. Must be nonnegative.

3.7.31 Column: Loaded Weight Distance Penalty

Required: No.
Type: Number.
Default: 0.
Description: The weight scaled loaded distance penalty factor for this vehicle. Must be nonnegative.

3.7.32 Column: Loaded Volume Distance Penalty

Required: No.
Type: Number.
Default: 0.
Description: The volume scaled loaded distance penalty factor for this vehicle. Must be nonnegative.

3.7.33 Column: Attributes

Required: No.
Type: Text or (integer) number.
Description: Multiple attributes must be separated by semicolons.

3.7.34 Column: Break Scheme

Required: No.
Type: Text or (integer) number.
Description: The break scheme requirements for the vehicle. Must match a break scheme identifier defined in the Fatigue Management sheet.

3.7.35 Column: Forbid Loaded Breaks

Required: No.
Type: Boolean.
Description: If set to TRUE, then loaded breaks will not be scheduled for the vehicle.

3.7.36 Column: Maximum Loads

Required: No.
Type: Number (positive integer).
Default: 0 (means no constraint on the maximum number of loads).
Description: The maximum number of loads the vehicle can do. Must be nonnegative. This field is only applicable if batched loads has been enabled.

3.7.37 Column: Maximum Drops per Load

Required: No.
Type: Number (positive integer).
Default: 0 (means no constraint on the maximum number of drops per load).
Description: The maximum number of delivery locations the vehicle can visit on a given load. Must be nonnegative. This field is only applicable if batched loads has been enabled.

3.7.38 Column: Compartments

Required: No.
Type: Text or (integer) number.
Description: The compartment scheme for the vehicle. If given, must match the identifier of a compartment scheme defined in the Compartments sheet.