Free Excel Calculator for Time and Distance between locations Using Google Maps API

Поделиться
HTML-код
  • Опубликовано: 4 дек 2024

Комментарии • 6

  • @EXCELWIZARDINMINUTES
    @EXCELWIZARDINMINUTES  Месяц назад

    for more content like this subscribe: ruclips.net/user/excelwizardinminutes

  • @vittorialaudani5140
    @vittorialaudani5140 Месяц назад

    Hi, can this solve a vrp? i saw your video about optimizing delivery/pickup route, but i have a problem with the bing key. Or can i use a google maps api on that Excel spreadsheet?

    • @EXCELWIZARDINMINUTES
      @EXCELWIZARDINMINUTES  Месяц назад +1

      @vittorialaudani5140 hello vittoria. Ur timing is perfect. I am editing a new vrp video that will come out next monday. It will use google maps api instead of bing to solve. For the time being you can use this to do the step the vrp solver needs. Otherwise just bare with me for 7 days and u ll get a new vrp solver...u can subscribe and put notifications on so u know when the video is out. But it s definately next monday...let me know if this works....

    • @vittorialaudani5140
      @vittorialaudani5140 Месяц назад

      @@EXCELWIZARDINMINUTES that's great, I'll try with the Google api but I will surely watch your next tutorial too

    • @EXCELWIZARDINMINUTES
      @EXCELWIZARDINMINUTES  Месяц назад +1

      @vittorialaudani5140 basically in the vrp sheet, u need lat long for 1 sheet and the distance and time between each combination of locations. This excel can give you all this. And u can copy paste them. However be aware than in the vrp solver, u need the times in days (u need to convert min to days. Ie /60/24).
      The simplest thing is just to wait 7 days. Then in 5 min, u can do vrp :))

    • @EXCELWIZARDINMINUTES
      @EXCELWIZARDINMINUTES  Месяц назад

      there is the new video: ruclips.net/video/1z-nTTYdTcY/видео.html Plz like it and comment if possible :)))