This is a tool that allows you take multiple starting locations and multiple ending locations and quickly calculate the driving distance between the two.
Only $49.00 - Google API Key/Business Version
This tool allows the user to do up to 100,000 calculations every 24 hours using an API key. This file has complete instructions on how to set everything up with Google to allow this extra functionality. Google charges $0.50 for every 1,000 calculations over the free 2,500 limit. If you need any extra help setting this up feel free to email me.
***As of June 11 the Google Fees for this tool will have changed. Each user will get a $200 credit which allows for 40,000 calculations in any one month period. After that the fees are $5 dollars for every 1,000 Calculations.
For any questions or comments email me at jobs@excelVBAmaster.com
- Paste Zip Codes or Addresses into first column
- Paste Zip Codes or Addresses into second column
- Push Calculate.
Q: Will this work outside of the United States?
A: Yes, the input and output are the same as if you manually went to Google Maps and entered your locations and submitted them online
Q: Can I calculate the distance between exact addresses, not just Zip Codes?
A: Yes, the calculator can handle partial addresses as well as complete addresses. (Cities, States, Countries, etc.)
Q: Will this work on a Mac as well as a Windows Machine?
A: Yes, the calculator will work on recent versions of Excel for Mac as well as Windows.
Q: Are there any limitations?
A: Yes, driving distance is generated using Google Maps API which limits the results to 2,500 calculations every 24 hours per IP address. If you need more than this, use the Google API Key Version which is limited to 100,000 every 24 hours.
Still have Questions? Email jobs@excelVBAmaster.com