How easy it is to calculate distances with the "Matrix Excel Distance Calculator 2.0"?
WHAT DOES IT DO?
HOW DOES IT WORK?
WHY SHOULD YOU CHOOSE EXCEL DISTANCE CALCULATOR?
-
Make thousands of distance calculations with the click of a button
-
Calculate distances directly in Excel
-
No third party software installs
-
Always up to date driving information with power of Google Maps
- One-time fee of $70. No monthly fees!
How Easy it is to Use the Excel Matrix Calculator?
It is as easy as Paste and Click. The tool then generates the results for you.
This tool allows you to calculate distances between addresses using Google Maps API. The Google Maps API gives you every month 40,000 calculations free of charge. (which is included in a 200 dollar Credit you receive every month.
- There is no fee to get the google api key.
- No monthly fees.
- Pay as you go for calculations in excess of 40 thousand calculations per month.
- $5 for every 1,000 calculations in excess of the 40k calculations every month.
- The credit will reset every month.
This tool allows the user to do up to 100,000 calculations every 24 hours using theAPI key. This file has complete instructions on how to set everything up with Google to allow this extra functionality. If you need any extra help setting this up feel free to email me.
For any questions or comments email me at jobs@excelVBAmaster.com
How to Use the Software
- Paste Zip Codes or Addresses into first column
- Paste Zip Codes or Addresses into second column
- Push Calculate.
Questions and Answers
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 100,000 calculations every 24 hours per IP address. If you need more than this, please contact me at the email below. jobs@excelVBAmaster.com
Still have Questions? Email jobs@excelVBAmaster.com