OpenStreetMap Forum

amar13

New Member

Registered: 2021-07-27

Posts: 2

Calculating distance between multiple adresses in excel with OSM help

Hi,

I have multiple adresses that I want to know the distance between in a excel sheet and I know its possible to setup api with OSM to calculate these. Could someone please help me through the process of how I do it?

Thanks in advance!

Sincerely
Amar

stephan75

Member

Registered: 2008-05-28

Posts: 2,918

Re: Calculating distance between multiple adresses in excel with OSM help

the OSM wiki at https://wiki.openstreetmap.org/wiki/Routing

can be a starting point for your research.

BikePC

Member

From: Zoetermeer NL

Registered: 2010-06-09

Posts: 695

Re: Calculating distance between multiple adresses in excel with OSM help

If you know the coordinates of the addresses you can calculate the birdseye distance between them: DISTANCE = ACOS(SIN(A3*$C$2)*SIN(A4*$C$2)+COS(A3*$C$2)*COS(A4*$C$2)*COS(B4*$C$2-B3*$C$2))*6371
The coordinates have to be in decimal format. In a spreadsheet the latitudes are in column A, the longitudes in column B. Cell C2 contains the constant value 0.0174532925 (Pi/180). Result is in kilometers. ref.: https://www.movable-type.co.uk/scripts/latlong.html

But I doubt this is what you are looking for? The distance 'on the ground' depends on the presence of roads and of the type of 'vehicle' you are calculating the distance for. A pedestrian surely will take a different route compared to automobiles, bicycles, etc., etc..

Last edited by BikePC (2021-08-16 20:13:32)

---

GPS: Garmin Edge 800 / Edge Touring Plus / Edge Explore