If you have issues with the direction calculations in excel this might be helpful to know:
From an internal question regarding the direction calculations and the formula used:
Direction = 180 + 180/pi*(atan2(-Veast,-Vnorth))
When the customer did the calculation, he has to reverse Veast and Vnorth to find the correct direction (see enclosed the excel file).
The atan formula is atan(y,x) https://en.wikipedia.org/wiki/Atan2
..however, in excel (probably to make things more intuitive) it is actually atan(x,y)..
So reversing them gives you the common formula. So in short it is excel's syntax that is reversed.
Please sign in to leave a comment.