Realize that this is similar to many of the questions here. However, I have not been able to find the answer that incorporates the altitude differences.
Given the Latitude, Longitude and Altitude of Origin and Destination points, I am looking for Distance & Bearing (from origin to destination).
Please assume:
| Point | Latitude | Longitude | Ground Elevation | Height Over Ground | Altitude Above Sea Level |
|---|---|---|---|---|---|
| Origin | 41.099218 | -73.419432 | 23 | 200 | 223 |
| Destination | 41.158622 | -73.277665 | 40 | 0 | 40 |
| Difference | 0.059404 | 0.141767 | 17 | NA | -183 |
Using =ACOS(COS(RADIANS(90-C2))*COS(RADIANS(90-C3))+SIN(RADIANS(90-C2))*SIN(RADIANS(90-C3))*COS(RADIANS(D2-D3))) in excel I have calculated the distance between these two points. (assume column 1, row 1 = A1 ("Point"))
Current Close But Not Exact Output:
- Unknown Haversine Unit: 0.00213
- Miles: 8.44
- Kilometers: 13.59
- Meters: 13,587.43
This does not take into account the altitude differences. Which could be dramatic.
I AM SEEKING:
- Math to incorporate the altitude differences.
- Math to determine Bearing from Origin to Destination
I have been working on this for a few days and would appreciate any guidance. THANK YOU.