I am trying to write an excel spread sheet for distance and bearing between two co-ordinates, the distance is easy, Pythagoras! but when it comes to calculating the whole circle bearing I’m struggling, theta = tan^1(dE/dN) depending on which quadrant the line falls depends whether you add nothing,180 degrees or 360 degrees but how would I write this in a spread sheet?
I have written spread sheets for levels, profile boards, and volume calculations, if that’s any use to anyone.
Red Flag Submitted
Thank you for helping keep Eng-Tips Forums free from inappropriate posts. The Eng-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Eng-Tips forums is a member-only feature.
Cities are ceaseless engines of engineering activity. Itâ€™s likely that while you were on your way to work, you encountered a number of infrastructure development projects under construction. Download Now
When was the last time you drove down the highway without seeing a commercial truck hauling goods?The ubiquity of these machines underscores the important roll they play in modern commerce. Download Now