Thank you zuri125 for your help so far.
Yes, I'm also trying to find the angle or bearing from the first point X to the following points - A, B & C.
I was thinking that if Excel could calculate the answer in degrees clockwise then I could later convert these into compass directions.
For example, I would be able to calculate that Point A is 180 metres in a southeasterly direction (or 135 degrees clockwise) from Point X.
Thanks again.
sorry, ive been trying to see if i am able to find the angles, but its not working. I'll keep on trying but i dont think i can help u with this part.
The standard angle measured from the x-axis (East) is:=ATAN(North/east)*(180/pi())For point (1) at 250E by 100 N, then
angle = ATAN(-100/150)*180/PI() = -33.69 deg. below the horizontal. However, you used the word bearing, which I assume means an angle measured from the north-axis, so 90 - (-34) = 124 deg.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks