SimpleRose cuOpt VRP Excel Template
The Excel workbook above allows you to define a complete vehicle routing problem (VRP) model for NVIDIA cuOpt using structured sheets. Each sheet represents one component of the routing model — vehicles, tasks, travel times, costs, constraints, and solver settings. Not every sheet nor column is required to be filled out.
Download some sample models to get you started quickly
This guide provides an overview of the overall workflow, how the sheets fit together, and key modeling concepts. Individual help pages will explain each sheet and column in detail.
Some of the supported routing features include
- Vehicle and task time windows
- Route cost and duration limits
- Pickup and delivery pairing
- Multiple vehicle capacities
- Heterogeneous fleets
- Fixed and variable vehicle costs
- Optional tasks
- Service times
- Breaks with time windows and allowed locations
- Set priorities for cost and time
Workbook formatting notes
The workbook is relational, meaning certain names must match across multiple sheets. Columns with yellow headers define the allowed values for a field. The first time a relational field appears in the workbook, its header is colored yellow.
When that same field appears again on another sheet, its header will be red. Values entered under a red header must match one of the values defined under the corresponding yellow header. If a value does not match, it will be highlighted in red to indicate a naming mismatch. These mismatches will cause an error when the model is submitted.
Recommended order of completion
The workbook is organized from left to right in the recommended order of completion. New users should work through the sheets sequentially to ensure all required references are defined before they are used elsewhere.
It is also best practice to build the model iteratively. Submit the model to cuOpt at regular intervals as you add components. This helps identify issues early and ensures the model remains valid throughout the build process.
Comments
0 comments
Please sign in to leave a comment.