Free Workbook to calculate the TIME and DISTANCE between Locations in Excel (Using Bing Map)
Автор: Excel with Rami
Загружено: 2022-03-31
Просмотров: 14510
Описание:
***Since the API changed, I made a new video with Google MAPS API: • Free Excel Calculator for Time and Distanc...
This is the second part of 2 lessons where you will learn the ins and out of the Bing Map API that you can use in Excel. All what you will learn doesn't require any coding! In this lesson, you will learn how to use a workbook (see link) to get the coordinates of a location and to get the distance and time between the 2 locations. Feel free to modify the code to include more parameters in the Bing API call (e.g., Walking instead of driving, start time, traffic, ect...)
*** Link to excel workbook:
https://mega.nz/file/qaBDVaAC#aObjNLG...
*** Bing API documentation: https://developers.google.com/maps/do...
*** VLOOKUP: • 036. Everything you need to know about Bas...
*** Dollar sign: • 062. Basic understanding of the $ sign in ...
PS: Ensure that you follow the guidelines:
1) Don't use a MacBook
2) Enable all macros (there is a button for it on one of the sheets)
3) Ensure no typos in addresses
4) Use Latitude/Longitude coordinates for matrices
#Excel #MsExcel #BingMap
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
