I use the following formula to find the distance between two grid points on map.
D2 would contain a grid input in this format
35R LV 66008500
F2 would contain another grid input in the same format
35R LV 67008600
=TRUNC(SQRT(((((VALUE(MID(D2,8,4)))-(VALUE(MID(F2,8,4))))*10)^2)+ ((((VALUE(MID(D2,12,4)))-(VALUE(MID(F2,12,4))))*10)^2)))
This returns the hypotenuse of a right triangle essentially. The distances are correct, it value returned should be 1,414 (meters).
Then I use the following formula to calculate the angle between the two points (based off the right angle triangle created by the measurements calculated above):
=DEGREES(TANH((((VALUE(MID(A3,12,4)))-(VALUE(MID(C3,12,4)))))/(((VALUE(MID(A3,8,4)))-(VALUE(MID(C3,8,4)))))))
THE PROBLEM:
The answer returned is 43.6 degrees. Mathematically (or logically in my head) the answer should be 45 degrees.
-If the base (adjacent) of the triangle is 1000 and the side (opposite) is 1000, then the tan (radian converted to degrees) should be 45.
What am I doing wrong, or what am I miscontruing as the truth?
Bookmarks