---
metadata:
  - name: generator
    content: Diplodoc Platform v5.19.6
alternate:
  - https://docs.routeq.com/doc/en/vrp/quickstart.md
  - https://docs.routeq.com/doc/tr/vrp/quickstart.md
title: RouteQ — start planning with an XLS file
---
> **Documentation Index:** Fetch the complete configuration index at https://docs.routeq.com/doc/en/llms.txt


# First planning

In this scenario, you'll learn how to start your first planning with an Excel file.


## Step 1. Log in to your account {#step-1-entrance}

1. Open [RouteQ](https://yandex.com/courier/).
1. Log in with the username you used to [register](https://docs.routeq.com/doc/en/vrp/registration.md).

## Step 2. Download a file {#step-2-download}

Download a sample populated Excel file:

- In the [Sample planning](https://docs.routeq.com/doc/en/vrp/example.md) section in Help.
- In the **Planning** section in the interface.

![](_images/quickstart-file.png)

{% note info %}

For the first planning, take a simple example with a small number of parameters.

{% endnote %}

## Step 3. Populate the file {#step-3-fill-file}

For the first planning, it's enough to fill in the following fields on the sheets:

{% list tabs %}

- Orders

  - **Order number**
  - **Client address**
  - **Time window**
  - **Service duration**

- Vehicles

  - **Courier name or number**
  - **Return to the depot at the end of the shift, TRUE/FALSE**
  - **Start and end time of the shift**

  You can add vehicles before you start planning in **Master data** → **Vehicle** and keep them there to use in the future tasks. Learn more in [Vehicle reference](https://docs.routeq.com/doc/en/vrp/interface-transport.md).

- Depot

  - **Depot name**
  - **Latitude**
  - **Longitude**
  - **Depot working hours**

{% endlist %}

All other fields can be left empty.

For detailed file and data requirements, see [Instructions for filling in Excel files](https://docs.routeq.com/doc/en/vrp/excel-fill-guide.md).


## Step 4. Upload the file to the interface {#step-4-upload}

In the **Planning** section, click **Upload file**, or drag and drop a file from a folder on your computer.

{% note info %}

After it's uploaded, you may see <svg width="20" height="20" viewBox="0 0 20 20" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M10 0C4.48 0 0 4.48 0 10C0 15.52 4.48 20 10 20C15.52 20 20 15.52 20 10C20 4.48 15.52 0 10 0ZM10 11C9.45 11 9 10.55 9 10V6C9 5.45 9.45 5 10 5C10.55 5 11 5.45 11 6V10C11 10.55 10.55 11 10 11ZM11 15H9V13H11V15Z" fill="#FF0000"/></svg> errors and <svg width="20px" height="18px" viewBox="0 0 20 18" version="1.1" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink"><g id="rnd-2f316f63__Symbols" stroke="none" stroke-width="1" fill="none" fill-rule="evenodd"><g id="rnd-2f316f63__issues-warnings" transform="translate(-208.000000, -118.000000)" fill-rule="nonzero"><g id="rnd-2f316f63__issue" transform="translate(0.000000, 94.000000)"><g id="rnd-2f316f63__icon" transform="translate(208.000000, 24.000000)"><rect id="rnd-2f316f63__Rectangle" fill="#FFFFFF" x="7.5313712" y="5.0075" width="4" height="10"/><path d="M2.0013712,17.0075 L17.0613712,17.0075 C18.6013712,17.0075 19.5613712,15.3375 18.7913712,14.0075 L11.2613712,0.9975 C10.4913712,-0.3325 8.5713712,-0.3325 7.8013712,0.9975 L0.271371202,14.0075 C-0.498628798,15.3375 0.461371202,17.0075 2.0013712,17.0075 Z M9.5313712,10.0075 C8.9813712,10.0075 8.5313712,9.5575 8.5313712,9.0075 L8.5313712,7.0075 C8.5313712,6.4575 8.9813712,6.0075 9.5313712,6.0075 C10.0813712,6.0075 10.5313712,6.4575 10.5313712,7.0075 L10.5313712,9.0075 C10.5313712,9.5575 10.0813712,10.0075 9.5313712,10.0075 Z M10.5313712,14.0075 L8.5313712,14.0075 L8.5313712,12.0075 L10.5313712,12.0075 L10.5313712,14.0075 Z" id="rnd-2f316f63__Shape" fill="#FFCC00"/></g></g></g></g></svg> warnings. Errors must be corrected, while you can continue planning with warnings.

{% endnote %}

Error or warning messages appear next to the names of the tabs where they need to be corrected. There are two ways to navigate between tabs:

- Clicking **Next** and **Back**. The buttons are located at the bottom right of the interface.
    
- Going to any tab in the top horizontal panel.

    ![](_images/quickstart-panel.png)

For example, to fix an error saying **Includes orders with no coordinates**:

1. Go to the **Map** tab.
1. Set up a map area for searching coordinates.
1. Click **Geocode**.
1. If you can't find the address, click ![](_images/download-result.png) → **Download orders without coordinates and remove them from planning**.

## Step 5. Configure the options {#step-5-settings}

1. Go to the **Settings** tab.
1. Set the desired settings for the planning task:
    - **Route date**: The date that the route is planned for.
    - **Time zone**: The time zone in which you enter all time windows.
    - **Transportation method**: Select the way your couriers travel.
    - **Consider geofences**: Choose whether the geofences from the [master data](https://docs.routeq.com/doc/en/vrp/interface-geozones.md) should be taken into account. This option is displayed only if the directory contains geofences.
    - **Solution quality**: Select **Optimal**.
    
## Step 6. Run the planning {#step-6-result}

1. In the lower-right corner, click **Plan**.
1. Wait until the planning is completed.
1. Evaluate the results.

In the interface, you can view, edit, and export the solution. For more information, see [Working with the resulting solution](https://docs.routeq.com/doc/en/vrp/interface-result.md).

{% include [warehouse-feedback](_includes/feedback-81845556eeea.md) %}
