Main Features of Vehicle Routing Add-On

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.

Screenshots

View, Move, Add or Delete Locations

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.