Yandex
 
Log in
Contents
Route planning
API Resources
Technical support
Overview
Quick start
Filling out an Excel template
Interface description
Attributes and options reference guide
Use cases
API integration
Filling out an Excel template
Sample planning
Excel file description
Route planning
Overview
Quick start
Registration
First planning
Filling out an Excel template
Sample planning
Excel file description
Interface description
Vehicle list
Geofence list
Presets
Planning
Import window
Working with the resulting solution
Export
Viewing the solution on the map
Planning result
Waybills
Request processing time
Attributes and options reference guide
Overview
Depot
Order
Vehicle
Geofences
General properties
Time window
Weight and volume
Routing options
Time parameters
Minimizing risk of delays
Transportation method
Solution quality
Grouping locations and multi-orders
Balanced loading
Penalty for service outside of the time window
Grouped routes
Counting the minimum number of stops for active vehicles only
Loading when ready
Throughput
Sequence post-optimization
Proportional penalty for not delivering an order
Undistributed orders
Consider geofences
Using presets
Use cases
Possible logistic scenarios
Example settings for business cases
API integration
Integration architectures
Integration architecture options
Features of API integration
Running the API and editing the solution in the interface
JSON format features
Adding a task
Obtaining results
Comparing MVRP and SVRP method groups
Error handling
Authorization
API key
Typical revisions for API-based integrations
Examples
Planning for multiple vehicles
Planning for a single vehicle
API Resources
RouteQ VRS API
Child Tasks
Get list of child tasks
Multiple Vehicles Routing (MVRP)
Add task
Get task result
Single Vehicle Routing (SVRP)
Add task
Get task result
Validation
Validate arithmetic expression representing vehicle cost
Technical support
Frequently asked questions
Contact us
Route planning
Filling out an Excel template

Filling out an Excel template

  1. Required sheets
  2. Optional sheets

This section provides instructions for filling out Excel templates for route planning.

  • General description
  • Sample templates

Required sheets

  • Orders
  • Vehicles
  • Depot

Optional sheets

  • Incompatible_order_types
  • Location_groups
  • Options
  • Routes

Contact support

Was the article useful?
Please specify why
  • article is hard to understand
  • article content does not match its stated topic
  • recommendations did not help me
  • I don't like how this feature works
  • didn't answer my question
  • other reason
Thank you for your feedback!
Please tell us what you didn't like about this article:
Previous
First planning
Next
Sample planning
Contents
Required sheetsOptional sheets
Previous
First planning
Next
Sample planning