1 Overview
2 Data Model
2.1 Scenarios
2.2 Solutions
2.3 Identifiers
2.4 Attributes
2.5 Weights and Volumes
2.6 Time
2.7 Costs and Hidden Costs
2.8 Global Parameters
2.8.1 Iterations
2.8.2 Batched Loads
2.8.3 Colocated Pickups
2.8.4 Sticky Deliveries
2.8.5 Scaling Factors
2.8.6 Geofencing
2.8.7 Maximum Neighbourhood Size
2.8.8 Preferred-Vehicle Rewards
2.9 Replanning
2.10 Locations
2.11 Vehicles
2.11.1 Vehicle Costs
2.11.2 Vehicle Locations
2.11.3 Vehicle Times
2.11.4 Vehicle Capacities
2.11.5 Vehicle Compartments
2.11.6 Maximum Loads
2.11.7 Maximum Drops per Load
2.11.8 Fatigue Management Scheme
2.11.9 Loaded Breaks
2.11.10 Vehicle Speed Scale
2.11.11 Vehicle Types
2.12 Orders
2.13 Fatigue Management
2.14 Iteration Schemes
2.15 Time Windows
2.15.1 Arrival Only in Time Window
2.16 Soft Time Windows
2.17 Compatibility
2.18 Stops
2.19 Loads
2.20 Solution Times
2.21 Unassigned Orders
2.22 Pickup Segments
2.23 Delivery Segments
2.24 Finish Segments
2.25 Loaded Distance Penalties
3 Microsoft Excel Input
3.1 Identifiers in Excel
3.2 Times in Excel
3.3 Sheet: General
3.3.1 Column: Parameter
3.3.2 Column: Value
3.3.3 Parameter: Scenario Name
3.3.4 Parameter: Iterations
3.3.5 Parameter: Rush Hour
3.3.6 Parameter: Use Miles
3.3.7 Parameter: Iteration Scheme
3.3.8 Parameter: Colocated Pickups
3.3.9 Parameter: Geofence North
3.3.10 Parameter: Geofence East
3.3.11 Parameter: Geofence South
3.3.12 Parameter: Geofence West
3.3.13 Parameter: Hard Geofence Errors
3.3.14 Parameter: Batched Loads
3.3.15 Parameter: Sticky Deliveries
3.3.16 Parameter: Cost Scale
3.3.17 Parameter: Weight Scale
3.3.18 Parameter: Volume Scale
3.3.19 Parameter: Maximum Neighbourhood Size
3.3.20 Parameter: Disable Replanning
3.3.21 Parameter: Previous-Vehicle Fixed Reward
3.3.22 Parameter: Previous-Vehicle Weight Reward
3.3.23 Parameter: Previous-Vehicle Volume Reward
3.3.24 Parameter: Forbid Unrecognised Columns
3.3.25 Parameter: Arrival Only in Time Window
3.4 Sheet: Locations
3.4.1 Column: Id
3.4.2 Column: Name
3.4.3 Column: Attributes
3.4.4 Column: Address
3.4.5 Column: Longitude
3.4.6 Column: Latitude
3.4.7 Column: Site Time
3.4.8 Column: Load Time
3.4.9 Column: Unload Time
3.4.10 Column: Opening Time
3.4.11 Column: Closing Time
3.4.12 Column: Operating Time Windows
3.4.13 Column: Cost per Visit
3.4.14 Column: Hidden Cost per Visit
3.5 Sheet: Orders
3.5.1 Column: Id
3.5.2 Column: Name
3.5.3 Column: Pickup Location
3.5.4 Column: Pickup Service Time
3.5.5 Column: Earliest Pickup Time
3.5.6 Column: Latest Pickup Time
3.5.7 Column: Pickup Time Windows
3.5.8 Column: Pickup Soft Time Windows
3.5.9 Column: Soft Pickup Constant
3.5.10 Column: Soft Pickup Variable
3.5.11 Column: Delivery Location
3.5.12 Column: Delivery Service Time
3.5.13 Column: Earliest Delivery Time
3.5.14 Column: Latest Delivery Time
3.5.15 Column: Delivery Time Windows
3.5.16 Column: Delivery Soft Time Windows
3.5.17 Column: Soft Delivery Constant
3.5.18 Column: Soft Delivery Variable
3.5.19 Column: Maximum Duration
3.5.20 Column: Weight
3.5.21 Column: Volume
3.5.22 Column: Assign Cost
3.5.23 Column: Hidden Assign Cost
3.5.24 Column: Attributes
3.6 Sheet: Vehicle Type
3.6.1 Column: Id
3.6.2 Column: Start Location
3.6.3 Column: Finish Location
3.6.4 Column: Maximum Weight
3.6.5 Column: Maximum Volume
3.6.6 Column: Earliest Start Time
3.6.7 Column: Latest Start Time
3.6.8 Column: Latest Finish Time
3.6.9 Column: Minimum Paid Time
3.6.10 Column: Maximum Drive Time
3.6.11 Column: Maximum Work Time
3.6.12 Column: Load Time
3.6.13 Column: Unload Time
3.6.14 Column: Speed Scale
3.6.15 Column: Cost per Use
3.6.16 Column: Cost per Hour
3.6.17 Column: Cost per Kilometre
3.6.18 Column: Cost per Mile
3.6.19 Column: Cost per Load
3.6.20 Column: Hidden Cost per Use
3.6.21 Column: Hidden Cost per Hour
3.6.22 Column: Hidden Cost per Kilometre
3.6.23 Column: Hidden Cost per Mile
3.6.24 Column: Hidden Cost per Load
3.6.25 Column: Finish Segment Distance Penalty
3.6.26 Column: Finish Segment Per Hour Penalty
3.6.27 Column: Pickup Segment Fixed Penalty
3.6.28 Column: Pickup Segment Distance Penalty
3.6.29 Column: Delivery Segment Fixed Penalty
3.6.30 Column: Delivery Segment Distance Penalty
3.6.31 Column: Loaded Weight Distance Penalty
3.6.32 Column: Loaded Volume Distance Penalty
3.6.33 Column: Attributes
3.6.34 Column: Break Scheme
3.6.35 Column: Forbid Loaded Breaks
3.6.36 Column: Maximum Loads
3.6.37 Column: Compartments
3.7 Sheet: Fleet
3.7.1 Column: Id
3.7.2 Column: Vehicle Type
3.7.3 Column: Name
3.7.4 Column: Start Location
3.7.5 Column: Finish Location
3.7.6 Column: Maximum Weight
3.7.7 Column: Maximum Volume
3.7.8 Column: Earliest Start Time
3.7.9 Column: Latest Start Time
3.7.10 Column: Latest Finish Time
3.7.11 Column: Minimum Paid Time
3.7.12 Column: Maximum Drive Time
3.7.13 Column: Maximum Work Time
3.7.14 Column: Load Time
3.7.15 Column: Unload Time
3.7.16 Column: Speed Scale
3.7.17 Column: Cost per Use
3.7.18 Column: Cost per Hour
3.7.19 Column: Cost per Kilometre
3.7.20 Column: Cost per Mile
3.7.21 Column: Cost per Load
3.7.22 Column: Hidden Cost per Use
3.7.23 Column: Hidden Cost per Hour
3.7.24 Column: Hidden Cost per Kilometre
3.7.25 Column: Hidden Cost per Mile
3.7.26 Column: Hidden Cost per Load
3.7.27 Column: Finish Segment Distance Penalty
3.7.28 Column: Finish Segment Per Hour Penalty
3.7.29 Column: Delivery Segment Fixed Penalty
3.7.30 Column: Delivery Segment Distance Penalty
3.7.31 Column: Loaded Weight Distance Penalty
3.7.32 Column: Loaded Volume Distance Penalty
3.7.33 Column: Attributes
3.7.34 Column: Break Scheme
3.7.35 Column: Forbid Loaded Breaks
3.7.36 Column: Maximum Loads
3.7.37 Column: Maximum Drops per Load
3.7.38 Column: Compartments
3.8 Sheet: Fatigue Management
3.8.1 Column: Id
3.8.2 Column: Number
3.8.3 Column: Duration
3.8.4 Column: Interval
3.9 Sheet: Time Windows
3.9.1 Column: Id
3.9.2 Column: Start
3.9.3 Column: End
3.10 Sheet: Compartments
3.10.1 Column: Scheme Id
3.10.2 Column: Id
3.10.3 Column: Name
3.10.4 Column: Maximum Weight
3.10.5 Column: Maximum Volume
3.10.6 Column: Attributes
3.11 Sheet: Rush Hour
3.11.1 Column: Start
3.11.2 Column: End
3.11.3 Column: Speed Scale
3.12 Sheet: Iteration Schemes
3.12.1 Column: Id
3.12.2 Column: Iterations
3.12.3 Column: Maximum Neighbourhood Size
3.13 Sheet: Order-Vehicle Compatibility
3.13.1 Column A: Order Attribute
3.13.2 Row 1: Vehicle Attribute
3.13.3 All other cells (except A1)
3.14 Sheet: Order-Compartment Compatibility
3.14.1 Column A: Order Attribute
3.14.2 Row 1: Compartment Attribute
3.14.3 All other cells (except A1)
3.15 Sheet: Order-Order Compatibility
3.15.1 Column A: Order Attribute
3.15.2 Row 1: Order Attribute
3.15.3 All other cells (except A1)
3.16 Sheet: Location-Vehicle Compatibility
3.16.1 Cell A1
3.16.2 Column A: Location Attribute
3.16.3 Row 1: Vehicle Attribute
3.16.4 All other cells
3.17 Sheet: Order-Vehicle Costs
3.17.1 Column: Order
3.17.2 Column: Vehicle
3.17.3 Column: Cost
3.17.4 Column: Hidden Cost
3.18 Sheet: Order-Vehicle Preferences
3.18.1 Column: Order
3.18.2 Column: Vehicle
3.18.3 Column: Fixed Reward
3.18.4 Column: Weight Reward
3.18.5 Column: Volume Reward
3.19 Sheet: Order Precedences
3.19.1 Column: Before
3.19.2 Column: After
3.19.3 Column: Gap
3.20 Sheet: Previous Solution
3.20.1 Column: Order
3.20.2 Column: Vehicle
3.20.3 Column: Stop
3.21 Sheet: Time Matrix
3.21.1 The Matrix
3.22 Sheet: Distance Matrix
3.22.1 The Matrix
4 Microsoft Excel Output
4.1 Sheet: Runsheet
4.1.1 Column: Vehicle
4.1.2 Column: Load
4.1.3 Column: Stop Number
4.1.4 Column: ETA
4.1.5 Column: ETD
4.1.6 Column: Stop
4.1.7 Column: Order
4.1.8 Column: Compartment
4.1.9 Column: Address
4.1.10 Column: Volume
4.1.11 Column: Delta Volume
4.1.12 Column: Weight
4.1.13 Column: Delta Weight
4.1.14 Column: Site Time
4.1.15 Column: Load Time
4.1.16 Column: Unload Time
4.1.17 Column: Service Time
4.1.18 Column: Transit Time
4.1.19 Column: Transit Distance
4.1.20 Column: Soft Time Window Start
4.1.21 Column: Soft Time Window End
4.1.22 Column: Soft Time Window Delta
4.2 Sheet: Vehicle Summary
4.2.1 Column: Vehicle
4.2.2 Column: Used
4.2.3 Column: Cost
4.2.4 Column: Peak Volume
4.2.5 Column: Total Volume
4.2.6 Column: Volume Capacity
4.2.7 Column: Peak Weight
4.2.8 Column: Total Weight
4.2.9 Column: Weight Capacity
4.2.10 Column: Number Of Loads
4.2.11 Column: Transit Distance
4.2.12 Column: Loaded Distance
4.2.13 Column: Empty Distance
4.2.14 Column: Actual Start Time
4.2.15 Column: Actual Finish Time
4.2.16 Column: Work Time
4.2.17 Column: Allowed Work Time
4.2.18 Column: Transit Time
4.2.19 Column: Allowed Transit Time
4.2.20 Column: Site Time
4.2.21 Column: Load Time
4.2.22 Column: Unload Time
4.2.23 Column: Service Time
4.2.24 Column: Idle Time
4.2.25 Column: Break Time
4.2.26 Column: Number Of Drops
4.2.27 Column: Number Of Orders
4.2.28 Column: Average Transit Speed
4.2.29 Column: Pickup Soft Time Window Early
4.2.30 Column: Pickup Soft Time Window Late
4.2.31 Column: Delivery Soft Time Window Early
4.2.32 Column: Delivery Soft Time Window Late
4.3 Sheet: Load Summary
4.3.1 Column: Vehicle
4.3.2 Column: Load Number
4.3.3 Column: Peak Volume
4.3.4 Column: Volume Capacity
4.3.5 Column: Peak Weight
4.3.6 Column: Weight Capacity
4.3.7 Column: Loaded Distance
4.3.8 Column: Empty Distance Before
4.3.9 Column: Empty Distance After
4.3.10 Column: Work Time
4.3.11 Column: Transit Time
4.3.12 Column: Site Time
4.3.13 Column: Load Time
4.3.14 Column: Unload Time
4.3.15 Column: Service Time
4.3.16 Column: Idle Time
4.3.17 Column: Break Time
4.3.18 Column: Number Of Drops
4.3.19 Column: Average Transit Speed
4.3.20 Column: Pickup Soft Time Window Early
4.3.21 Column: Pickup Soft Time Window Late
4.3.22 Column: Delivery Soft Time Window Early
4.3.23 Column: Delivery Soft Time Window Late
4.4 Sheet: Solution Summary
4.4.1 Scenario Name
4.4.2 Total Iterations
4.4.3 Total Cost
4.4.4 Total Distance
4.4.5 Loaded Distance
4.4.6 Empty Distance
4.4.7 Average Transit Speed (km/h)
4.4.8 Average Transit Speed (mph)
4.4.9 Loads
4.4.10 Km Per Load
4.4.11 Miles Per Load
4.4.12 Hours Per Load
4.4.13 Drops Per Load
4.4.14 Work Time
4.4.15 Transit Time
4.4.16 Break Time
4.4.17 Idle Time
4.4.18 Total Weight
4.4.19 Total Volume
4.4.20 Assigned Orders
4.4.21 Fleet Usage
4.4.22 Column: Pickup Soft Time Window Early
4.4.23 Column: Pickup Soft Time Window Late
4.4.24 Column: Delivery Soft Time Window Early
4.4.25 Column: Delivery Soft Time Window Late
4.5 Sheet: Unassigned Orders
4.5.1 Column: Order
4.5.2 Column: Pickup Location
4.5.3 Column: Delivery Location
4.5.4 Column: Reason
4.6 Sheet: Replan Changes
4.6.1 Column: Order
4.6.2 Column: Weight
4.6.3 Column: Volume
4.6.4 Column: Previous Vehicle
4.6.5 Column: New Vehicle
4.6.6 Column: Previous Pickup Time
4.6.7 Column: New Pickup Time
4.6.8 Column: Previous Delivery Time
4.6.9 Column: New Delivery Time
5 JSON Input
5.1 Scenario Object
5.2 General Object
5.3 Location Object
5.4 Order Object
5.5 Vehicle Object
5.6 Break Object
5.7 Compartment Object
5.8 Time Window Object
5.9 Soft Time Window Object
5.10 Attribute Pair Object
5.11 Rush Hour Object
5.12 Iteration Batch Object
5.13 Vehicle Cost Object
5.14 Vehicle Preference Object
5.15 Order Precedence Object
6 JSON Output
6.1 Solution Object
6.2 Route Object
6.3 Stop Object
6.4 Stop Type Codes
6.5 Route KPI Object
6.6 Load KPI Object
6.7 Unassigned Reason Object
A JSON Input Example
B JSON Output Example
C Unsupported Excel Functions