Main Features of Vehicle Routing Add-On

  • Suitable for planning your daily vehicle routes

  • Find best routes based on fixed and variable costs

  • Reduce time and effort of human planners

  • Apply Here Maps and its routing options for road distances and travelling times based on traffic.

  • Handle multiple depots with up to one thousand orders

  • Consider capacity constraints and time windows

  • Import latitudes and longitudes from your KML files or geocoding

  • View locations and vehicle routes on a map

  • Can extend features e.g. skill, priority, and specific customization

Why Google Sheets?

  • Free and very easy web-based spreadsheet application

  • Secure authentication via your Google user accounts

  • Data is on your sides. The add-on will read and send a request to our solver server. You later fetch results to your Sheets.

  • Flexible to manipulate your own data with formulas

  • Integration with other Google products

Overall Process

  1. Log-in to your Google account and install our Add-on from this link. Note that Google Sheets add-ons can run via web browsers on "desktop computers" only. Please also read our privacy policy and terms of services here.

  2. Load our blank template or try our demos.

  3. Fill in latiudes and longitudes which necessary to determine road distances and durations between locations.

  4. Alternatively get location coordinates from KML files, address geocoding, or pinpointing on a map.

  5. Fill in other parameters in Location, Vehicle, Order Sheets.

  6. Set your access key, routing options and a maximum solving time.

  7. Send a solve vehicle route request. When the solving time less than 3 minutes, the add-on will try to automatically fetch a solution.

  8. For a long solving process, maually fetch your solution. Your result on our sever will be deleted after 24 hours.

  9. View your results in Route and Summary Sheets and on a map.

Example_Delivery

Screenshots

View, Move, Add or Delete Locations

Solve and Get Vehicle Routes

View Vehicle Routes

Solving a real-life case

Pricing and conditions

    • For standard users, each solving request has a certain limit e.g. 2 vehicles, 10 orders, and 5 solving requests/day.

    • For premium users,

      • to use Here map, we need an annual subscription at 60.0 USD/vehicle/year, with a minimum of 30 vehicles. There are additional limits on a maximum number of orders, locations, solving requests which depend on use cases. Please contact us for pricing later.

      • we will try to provide other methods, e.g. OpenStreetMap may be available only for a few countries at the beginning. This option may incur an initial fee to prepare data for each country.

      • for other cases, we will use a Great-Circle Distance for calculation. The obtained distances should be less than real road distances. You could try this option to see if a solution is still acceptable.

To handle very special route contraints or implement extra functions, a development fee might be additionally proposed.

Anyway, we are very grateful to discuss your requirements, solve your challenging optimization problems, or get any feedback.

Please read our privacy policy and term of services.