1
vote
2answers
39 views

Spherical law of cosine what does the 'a' represent?

I want to use the spherical law of cosine formula, θ = atan2( sin Δλ ⋅ cos φ2 , cos φ1 ⋅ sin φ2 − sin φ1 ⋅ cos φ2 ⋅ cos Δλ ), to calculate distances between coordinates, but, I cannot for the life ...
3
votes
2answers
491 views

Excel Distance Calculation

Is there a way (preferably in Excel) to calculate the distance (based on lat, lon) between two lists of points? My end goal would be, for example, to have a list of Starbucks and a list of McDonald's, ...
1
vote
1answer
280 views

QGis creating shape file of several points out of two Excel sheets

I am about to create a Qgis file on which it should be visible which companies are working together. As source I have got two Excel Tables. Table = Distribution Centers Table = Point of sales I ...
4
votes
4answers
2k views

Using a list of geographic locations, and determining the X closest locations to a user-defined location

I've got a list of geographical locations in an Excel spreadsheet. I want users to be able to search for a user-defined location, and then have the X number of closest locations from the list pulled ...