It's easy to calculate the distance between 2 cities with the GPS Google API. If you don't know how to manage a Google API, watch this playlist • Presentation of the pl...
How does the distance change due to heavy traffic? Does heavy traffic made the road longer or shorter? You could always use a map to find out the distance, I suppose.
The API calculates the best road in function of the traffic. So it depends when you call the API, the distance could be slightly different (if there is traffic or not)
bonjour peut on le faire d une adresse complète a une autre adresse complète ex 25 RUE DU PERE LACHAISE 75019 PARIS à 35 AVENUE DU LOIRET 35000 RENNES? MERCI A VOUS
@@FredericLEGUEN-Excel Do you know an elegant way like this to get Information from local XML files? Using the data->import->XML is not an option becuase the steucture of the XML is not supported. :-(
Fantastically helpful, thank you!!
How does the distance change due to heavy traffic? Does heavy traffic made the road longer or shorter?
You could always use a map to find out the distance, I suppose.
The API calculates the best road in function of the traffic. So it depends when you call the API, the distance could be slightly different (if there is traffic or not)
bonjour
peut on le faire d une adresse complète a une autre adresse complète
ex 25 RUE DU PERE LACHAISE 75019 PARIS à 35 AVENUE DU LOIRET 35000 RENNES?
MERCI A VOUS
Ha zut ! Je n'avais pas vu le message avant. Ça doit être possible ou alors convertir vos adresses en coordonnées GPS
thank you, this worked out well. cheers
Can this be applied to other countries?
Of course 😉
how to calculate distance between two airports?
you have to pay to use API keys correct?
Not for the first 10,000 requests 😉
@@FredericLEGUEN-Excel Is there a way to have this local. 10k is not enough :(
@@jmwengue 10k per day that's for a company, not individual person. So yes, your company must pay for the service
La même in french, please ?
Ici www.udemy.com/course/convertir-vos-adresses-en-coordonnees-gps-avec-excel/learn/lecture/21009540#overview
wonderful, thanks a lot!
Thanks
@@FredericLEGUEN-Excel Do you know an elegant way like this to get Information from local XML files? Using the data->import->XML is not an option becuase the steucture of the XML is not supported. :-(
Power Query maybe, but not sure