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 requests/day.
    • For premium users, currently please inform us a number of vehicles and your expected usage demand. We will provide a quote for your access key and help prepare computation resources suitable for your scenario. Additional charge may be included when you need to include special constraints or functions.

We are very grateful to discuss your requirements or get any feedback from you via our email.

Please read our privacy policy and term of services.