The Vehicle Type sheet may be used to define a type of vehicle It may be omitted if vehicle types are not used.
Required: Yes.
Type: Text or (integer) number.
Description: Each vehicle type must have a unique identifier.
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.
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.
Required: Yes.
Type: Number.
Default: 0.
Description: The maximum weight the vehicle can carry. Units are unspecified but must be consistent with orders’
weights. Must be nonnegative.
Required: Yes.
Type: Number.
Default: 0.
Description: The maximum volume the vehicle can carry. Units are unspecified but must be consistent with orders’
volumes. Must be nonnegative.
Required: No.
Type: Text (HH:MM).
Default: 00:00.
Description: Earliest time a vehicle can start at the start location.
Required: No.
Type: Excel time.
Default: No latest start time.
Description: Latest time a vehicle can start at the start location.
Required: No.
Type: Excel time.
Default: No latest finish time.
Description: Latest time a vehicle must arrive at the finish location.
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.
Required: No.
Type: Excel time.
Default: Inferred from data.
Description: Maximum time a vehicle can drive for. Must be nonnegative.
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.
Required: No.
Type: Excel time.
Default: 00:00.
Description: Time needed to load vehicle. (See Load Time in Section 2.11.)
Must be nonnegative.
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.
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.)
Required: No.
Type: Number.
Default: 0.
Description: A fixed cost for using the vehicle.
Required: No.
Type: Number.
Default: 0.
Description: Cost incurred per hour of vehicle’s work time.
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.
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.
Required: No.
Type: Number.
Default: 0.
Description: Cost incurred for each load. Only applied if batched loads is enabled.
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.
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.
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.
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.
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.
Required: No.
Type: Number.
Default: 0.
Description: The per-unit distance component of the finish segment penalty for this vehicle. Must be
nonnegative.
Required: No.
Type: Number.
Default: 0.
Description: The per hour component of the finish segment penalty for this vehicle. Must be nonnegative.
Required: No.
Type: Number.
Default: 0.
Description: The fixed component of the pickup segment penalty for this vehicle type. Must be nonnegative.
Required: No.
Type: Number.
Default: 0.
Description: The per-unit distance component of the pickup segment penalty for this vehicle type. Must be
nonnegative.
Required: No.
Type: Number.
Default: 0.
Description: The fixed component of the delivery segment penalty for this vehicle type. Must be nonnegative.
Required: No.
Type: Number.
Default: 0.
Description: The per-unit distance component of the delivery segment penalty for this vehicle type. Must be
nonnegative.
Required: No.
Type: Number.
Default: 0.
Description: The weight scaled loaded distance penalty factor for this vehicle type. Must be nonnegative.
Required: No.
Type: Number.
Default: 0.
Description: The volume scaled loaded distance penalty factor for this vehicle type. Must be nonnegative.
Required: No.
Type: Text or (integer) number.
Description: Multiple attributes are separated by semicolons. (Multiple attributes can only be specified in a text
cell.)
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.
Required: No.
Type: Boolean.
Description: If set to TRUE, then loaded breaks will not be scheduled for this vehicle type.
Required: No.
Type: Number (positive integer).
Default: 0 (means no constraint on the maximum number of loads).
Description: The maximum number of loads this vehicle type can do. Must be nonnegative. This field is only
applicable if batched loads is enabled.
Required: No.
Type: Text or (integer) number.
Description: The compartment scheme for the vehicle type. If given, must match the identifier of a compartment
scheme defined in the Compartments sheet.
Required: No.
Type: Boolean.
Description: If set to TRUE, then this vehicle can preload orders at its start location.
Note: A non-empty Start Location must be defined.
Note 2: See Preloading for more information.