How can I compare my routes with optimized solutions found by TourSolver?  

Would it be interesting to compare your original routes with the ones optimized by TourSolver? This would reveal improvements and economies calculated by the solution.  

You should have a route plan constructed over the geographic area beforehand, and for which you know all customers visited, the assignment to a route/resource as well as sequence numbers for visits in the list. The ideal way to start is to construct a file of data for routes on a given date, for example.

TourSolver's evaluation mode includes a financial simulator and calculates improvements on the main posts (cost, kilometers travelled, durations, number of routes, number of visits, CO2 emissions).   

Proceed as follows:

Preparing your data

In the database of the Template customer file that can be downloaded from TourSolver's My visits tab (see also the article entitled Can I explore TourSolver even if I don't have any data?) construct your data file of customers visited at a given date.  

Three columns must be filled in your visits file to enable comparison of your route plan with the route plan optimized by TourSolver:

  • the Day of the week column indicates the number of the weekday. For evaluation of a route plan on just one date, indicate in this column the value 1 for customers visited.  
  • the Sequence number in the route column indicates the sequence number for each visit in the route.  
  • the Route identifier column indicates the assignment of each visit to a resource or vehicle. Indicate here exactly the same string as the Name of the resources defined in the My resources tab (or another name, depending on whether you have customised the terminology in the My activity tab).  

Importing data and setting up correspondences between fields

Once the file has been customised to your satisfaction, import it into the My visits tab (or a tab with another name if you have customised the terminology in the My activity tab).  

In the data mapping step where data is put into correspondence with the TourSolver constraints, check the association between these three columns and the constraints:  

  • Original visit day
  • Sequence number
  • Identifier

Once constraints mapping has been applied, continue with the wizard to geocode addresses for each of the visits.  

Display of optimization results

Once the optimization calculation has terminated, the range of indicators displays and allows comparison between the situation Before optimization (as submitted in your imported data) and After optimization with TourSolver. The Gains column displays in green posts on which an improvement has been calculated.   

This screen shows the key indicators enabling you to measure the posts on which the route optimisation has yielded improvements and economies.

Back to TourSolver Help