3.7 Sheet: Vehicle Type
The Vehicle Type sheet may be used to define a type of vehicle. It may be omitted if vehicle types are not used.
3.7.1 Column: Id
Required: Yes.
Type: Text or (integer) number.
Description: Each vehicle type must have a unique identifier.
3.7.2 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.3 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.4 Column: Maximum Weight
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.
3.7.5 Column: Maximum Volume
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.
3.7.6 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.7 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.8 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.9 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.10 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.11 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.12 Column: Load Time
Required: No.
Type: Excel time.
Default: 00:00.
Description: Time needed to load vehicle. (See Load Time in Section x15-250002.112.11.)
Must be nonnegative.
3.7.13 Column: Unload Time
Required: No.
Type: Excel time.
Default: 00:00.
Description: Time needed to unload the vehicle. (See Unload Time in Section x15-250002.112.11.)
Must be nonnegative.
3.7.14 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 x15-250002.112.11.)
3.7.15 Column: Cost per Use
Required: No.
Type: Number.
Default: 0.
Description: A fixed cost for using the vehicle.
3.7.16 Column: Cost per Hour
Required: No.
Type: Number.
Default: 0.
Description: Cost incurred per hour of vehicle’s work time.
3.7.17 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.18 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.19 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.20 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.21 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.22 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.23 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 must be present.
3.7.24 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.25 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.26 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.27 Column: Pickup Segment Fixed Penalty
Required: No.
Type: Number.
Default: 0.
Description: The fixed component of the pickup segment penalty for this vehicle type. Must be nonnegative.
3.7.28 Column: Pickup Segment Distance Penalty
Required: No.
Type: Number.
Default: 0.
Description: The per-unit distance component of the pickup segment penalty for this vehicle type. 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 type. 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 type. 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 type. 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 type. Must be nonnegative.
3.7.33 Column: Attributes
Required: No.
Type: Text or (integer) number.
Description: Multiple attributes are separated by semicolons. (Multiple attributes can only be specified in a text
cell.)
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 either
the Standard Fatigue Management or Simple Fatigue Management sheets.
3.7.35 Column: Forbid Loaded Breaks
Required: No.
Type: Boolean.
Description: If set to TRUE, then loaded breaks will not be scheduled for this vehicle type.
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 this vehicle type can do. Must be nonnegative. This field is only
applicable if Batched Loads is enabled.
3.7.37 Column: Compartments
Required: No.
Type: Text or (integer) number.
Description: The compartment scheme for the vehicle type. If given, then this must match the identifier of a
compartment scheme defined in the Compartments sheet.
3.7.38 Column: Allow Preloading
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.
3.7.39 Column: Load Order
Required: No.
Value Type: Text (one of the Load Order codes).
Default: None.
Description: The load order strategy to use.
3.7.40 Column: Heavy Order Threshold
Required: No.
Value Type: Number (nonnegative integer).
Description: Any order with weight greater than or equal to this value is considered a heavy order for this vehicle type
if it is using a weight category load order. (See Heavy Order Threshold in Section x12-110002.82.8.)

