We show you how to register the data of your vehicles in Excel so that it is compatible with the optimizer

If you use an Excel file to record the vehicles in your planning, take into account the advice that we leave you below so that the file is compatible and your optimal optimization.

  • Put all the information in Excel Sheet 1

  • Organize the information by columns and give them a title in the first row. You can identify your vehicles by license plate number or driver's name. The number of columns will depend on the amount of data you need to take into account for the operation, for example, these can be: name, start point, starting point, time, volume or weight, among others.

  • You must write in detail the start and departure point of your vehicles. Sometimes the starting point may be part of a circular route and be the same point as the starting point.

  • Information such as hours, maximum weight, maximum volume or maximum stops, is additional information that you can include in this file.

Once you have your vehicle file created, you only need to go to the Assets page and in the Create Vehicles option click on Upload File.

All this information will be related to the optimizer. Tip: to make sure that each field within Planner is correctly designated, a green check will appear next to each field:

And if you don't know where to start, you can do so by downloading our example Excel file. You will find it on the Assets page, by clicking on Create Vehicles and Download example.

You can also create vehicles from scratch. You can find more information about creating vehicles from scratch in the following article.

Did this answer your question?