excel problem
excel problem
(OP)
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.
I have written spread sheets for levels, profile boards, and volume calculations, if that’s any use to anyone.





RE: excel problem
It takes two arguments, first the change in X, second the change in Y. But be aware that most people who do not live in Redmond instinctively want to enter these two arguments in the other order.
RE: excel problem
"But be aware that most people who do not live in Redmond instinctively want to enter these two arguments in the other order." statement??
cheers olly
RE: excel problem
Microsoft (headquartered - I believe - in Redmond in the US state of Washington) chooses to be different.
RE: excel problem