November 30th, 2016, 01:36 PM
Where to start?
I want to make a program where I input an address and it'll calculate the distance between the input and a database of ~100 other addresses.
The output will be the closest database address.
How should I go about doing this?
I know a little Excel VBA and I read that I can use a Google Maps API but in general, I don't know how to approach?
November 30th, 2016, 02:16 PM
Get the latitude and longitude of every location, then calculate the distance between points using whichever method you want; if the addresses are all close (say, an hour's drive) then the simple √(∆lat+∆long) may be enough for simply comparing distances, otherwise you'll have to use the great-circle distance for accuracy.