Transport Navigator Attributes
Transport Navigator attributes are only available in the Transport Navigator Module.
TN Time Limit
- Sheets on which it appears
- Possible inputs
Positive integer value (in seconds)
- How it affects the model
Sets the maximum time allowed for the Transport Navigator solver to run. The solver will return the best solution found once this time is reached.
Reference Date and Time
- Sheets on which it appears
- Possible inputs
Date and time formatted as YYYY-MM-DD HH:MM:SS
- How it affects the model
Establishes the start point for all time-based calculations, with period start and end times defined relative to this reference point.
Include Week Number in Time Stamps
- Sheets on which it appears
- Possible inputs
Binary, 1 (include week number) or 0 (do not include week number)
- How it affects the model
Determines whether week numbers are shown in the time stamps for arrival times, departure times, and time windows in the application.
Reset Duty Time at Depot
- Sheets on which it appears
- Possible inputs
Binary, 1 (reset duty time at depot) or 0 (do not reset duty time)
- How it affects the model
Controls whether a vehicle’s duty time is reset when it returns to a depot, impacting compliance with duty time constraints and route planning.
Volume UOM
- Sheets on which it appears
- Possible inputs
String representing a volume unit of measurement (e.g., m3, L)
- How it affects the model
Defines the unit of measurement for all volume-related inputs and calculations in Transport Navigator.
Weight UOM
- Sheets on which it appears
- Possible inputs
String representing a weight unit of measurement (e.g., kg, lb)
- How it affects the model
Defines the unit of measurement for all weight-related inputs and calculations in Transport Navigator.
Period Start
- Sheets on which it appears
- Possible inputs
Positive real value (in hours)
- How it affects the model
Specifies the start time of the period as an offset in hours from the Reference Date and Time (see: Reference Date and Time on TN Settings sheet).
Period End
- Sheets on which it appears
- Possible inputs
Positive real value (in hours)
- How it affects the model
Specifies the end time of the period as an offset in hours from the Reference Date and Time (see: Reference Date and Time on TN Settings sheet).
Mode of Transport
- Sheets on which it appears
- Possible inputs
String matching a defined mode of transport from the Mode of Transport sheet
- How it affects the model
Determines the transport mode used for routing from the warehouse. The associated speed is used in drive time calculations if no actual drive times are provided.
Maximum Duty Time
- Sheets on which it appears
- Possible inputs
Positive real value (in minutes)
- How it affects the model
Sets the maximum allowable duty time before a layover is required. Duty time includes driving time, service time, waiting time and time at the depot in between trips.
Maximum Drive Time
- Sheets on which it appears
- Possible inputs
Positive integer value (in minutes)
- How it affects the model
Defines the maximum driving time before a mandatory layover is required.
Minimum Layover Duration
- Sheets on which it appears
- Possible inputs
Positive integer value (in minutes)
- How it affects the model
Sets the minimum duration of a layover.
Maximum Layover Duration
- Sheets on which it appears
- Possible inputs
Positive integer value (in minutes)
- How it affects the model
Defines the maximum allowable duration of a layover.
Cost Per Stop
- Sheets on which it appears
- Possible inputs
Positive real value
- How it affects the model
Adds a cost for each stop made along the route.
Cost Per Dispatch
- Sheets on which it appears
- Possible inputs
Positive real value
- How it affects the model
Applies a cost for each vehicle dispatched from a warehouse.
Cost Per Layover
- Sheets on which it appears
- Possible inputs
Positive real value
- How it affects the model
Applies a cost penalty for each layover during a route.
Cost Per Hour Late
- Sheets on which it appears
- Possible inputs
Positive real value
- How it affects the model
Applies a cost penalty for each hour a vehicle arrives outside the customer’s specified time window.
Maximum Distance between Stops
- Sheets on which it appears
- Possible inputs
Positive real value
- How it affects the model
Restricts the maximum distance allowed between two consecutive customer stops on a route.
Reloading Time Warehouse
- Sheets on which it appears
- Possible inputs
Positive real value (in minutes)
- How it affects the model
Defines the reloading time needed at a warehouse before a vehicle can depart for the next route.
Maximum Number of Stops per Route
- Sheets on which it appears
- Possible inputs
Positive integer value
- How it affects the model
Limits the number of customer stops allowed per route before a vehicle must return to the warehouse.
Reduced Capacity Per Stop
- Sheets on which it appears
- Possible inputs
Positive real value (in volume UOM)
- How it affects the model
Reduces the available volume capacity of the vehicle after each stop to account for inefficiencies such as packaging or palletizing for multiple deliveries.
Vehicle Capacity Weight
- Sheets on which it appears
- Possible inputs
Positive real value (in Weight UOM, see: TN Settings)
- How it affects the model
Sets the maximum weight that the vehicle can carry.
Vehicle Capacity Volume
- Sheets on which it appears
- Possible inputs
Positive real value (in Volume UOM, see: TN Settings)
- How it affects the model
Sets the maximum volume that the vehicle can carry.
Has Sleep Cabin
- Sheets on which it appears
- Possible inputs
Binary, 1 (yes) or 0 (no)
- How it affects the model
Indicates whether a vehicle has a sleep cabin, allowing it to take layovers anywhere instead of requiring a specific rest location.
Route Ends at Last Stop
- Sheets on which it appears
- Possible inputs
Binary, 1 (yes) or 0 (no)
- How it affects the model
When enabled, the vehicle does not return to the depot after its last delivery. This eliminates the return-leg distance and driving time, reducing both distance cost and driving time cost. The vehicle’s capacity is not reset at the depot and stops are counted continuously.
Pre-Trip Drive Time
- Sheets on which it appears
- Possible inputs
Non-negative real value (in minutes), default is 0
- How it affects the model
Sets the driving time already spent before the driver reaches the depot. This value is used as the initial baseline for route drive time calculations, meaning the driver does not start with a fresh drive time allowance. Must be less than or equal to Pre-Trip Duty Time.
Pre-Trip Duty Time
- Sheets on which it appears
- Possible inputs
Non-negative real value (in minutes), default is 0
- How it affects the model
Sets the duty time already spent before the driver reaches the depot. This value is used as the initial baseline for route duty time calculations, meaning the driver does not start with a fresh duty time allowance. Must be greater than or equal to Pre-Trip Drive Time.
Post-Trip Drive Time
- Sheets on which it appears
- Possible inputs
Non-negative real value (in minutes), default is 0
- How it affects the model
The driving time needed after the last stop for the driver to return home. This time is added to the final drive time to check whether the vehicle can legally complete the route without violating maximum drive time constraints. Must be less than or equal to Post-Trip Duty Time.
Post-Trip Duty Time
- Sheets on which it appears
- Possible inputs
Non-negative real value (in minutes), default is 0
- How it affects the model
The duty time needed after the last stop for the driver to return home. This time is added to the final duty time to check whether the vehicle can legally complete the route without violating maximum duty time constraints. Must be greater than or equal to Post-Trip Drive Time. Incompatible with the “Reset Duty Time at Warehouse” setting.
Cost Per Distance
- Sheets on which it appears
- Possible inputs
Positive real value
- How it affects the model
Adds a cost per kilometer or mile traveled.
Cost Per TN Period
- Sheets on which it appears
- Possible inputs
Positive real value
- How it affects the model
Applies a fixed cost per TN Period for using the vehicle.
Cost Per Vehicle
- Sheets on which it appears
- Possible inputs
Positive real value
- How it affects the model
Applies a fixed cost for using the vehicle in one of the TN Periods.
Cost Per Hour Driving
- Sheets on which it appears
- Possible inputs
Positive real value
- How it affects the model
Adds a cost for each hour of driving time for a vehicle.
Cost Per Hour Waiting
- Sheets on which it appears
- Possible inputs
Positive real value
- How it affects the model
Adds a cost for each hour of waiting time for a vehicle.
Grouping Code
- Sheets on which it appears
- Possible inputs
String value
- How it affects the model
Matches vehicles with customers that have the same grouping code (see: Grouping Code on TN Customer Product sheet), allowing selective assignment of vehicles to specific customer groups.
Demand
- Sheets on which it appears
- Possible inputs
Positive real value
- How it affects the model
Specifies customer demand per product. If used, UOM conversion for volume and weight must be set. Alternatively, use Demand Volume and Demand Weight directly.
Demand Volume
- Sheets on which it appears
- Possible inputs
Positive real value (in Volume UOM, see: TN Settings)
- How it affects the model
Defines the demand per product by volume.
Demand Weight
- Sheets on which it appears
- Possible inputs
Positive real value (in Weight UOM, see: TN Settings)
- How it affects the model
Defines the demand per product by weight.
Service Time
- Sheets on which it appears
- Possible inputs
Positive real value (in minutes)
- How it affects the model
Sets the required service time at each customer stop.
Time Window Start
- Sheets on which it appears
- Possible inputs
Positive real value (in hours from the associated TN Period start)
- How it affects the model
Sets the earliest allowed arrival time at the customer location.
Time Window End
- Sheets on which it appears
- Possible inputs
Positive real value (in hours from the associated TN Period start)
- How it affects the model
Sets the latest allowed arrival time at the customer location.
Is First Stop
- Sheets on which it appears
- Possible inputs
Binary, 1 (yes) or blank (no)
- How it affects the model
Forces the customer to be the first stop on the assigned route.
Is Last Stop
- Sheets on which it appears
- Possible inputs
Binary, 1 (yes) or blank (no)
- How it affects the model
Forces the customer to be the last stop on the assigned route.
Grouping Code
- Sheets on which it appears
- Possible inputs
String value
- How it affects the model
Assigns customers to specific vehicle types with matching grouping codes (see: Grouping Code on TN Vehicles sheet).
Serviced by Warehouse Location
- Sheets on which it appears
- Possible inputs
String value (warehouse name)
- How it affects the model
Determines the warehouse location responsible for servicing the customer’s demand.
Customer Name
- Sheets on which it appears
- Possible inputs
String value (must match a customer name)
- How it affects the model
Defines the customer that must be visited as part of a fixed route.
Location Name
- Sheets on which it appears
- Possible inputs
String value (must match a warehouse name)
- How it affects the model
Specifies the physical location where the vehicle must stop on the fixed route.
TN Period Name
- Sheets on which it appears
- Possible inputs
String value (must match a TN Period name)
- How it affects the model
Assigns the fixed route stop to a specific Transport Navigator period (see: TN Period sheet).