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?
@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 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 :))
for more content like this subscribe: ruclips.net/user/excelwizardinminutes
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?
@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....
@@EXCELWIZARDINMINUTES that's great, I'll try with the Google api but I will surely watch your next tutorial too
@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 :))
there is the new video: ruclips.net/video/1z-nTTYdTcY/видео.html Plz like it and comment if possible :)))