Converting rectangular coodinates to WCBs in excel spreadsheet

[landranger]

i have written a spread sheet to convert rectangular coodinates to whole circle bearings, using ATAN2, but i always get a minus or a positive bearing from 0(ie north).
i need to somehow convert that to a true whole circle bearing.

i am not very up on excel, can some one help?

 

[cherrypicker]

If you try this formula in cell G6 referencing D6 and E6 respectively it can be copied down to calculate the other rows

=IF((ATAN2(E6,D6)/PI()*180)<0,360+(ATAN2(E6,D6)/PI()*180),(ATAN2(E6,D6)/PI()*180))

I've used this and it works!

all the best

 

[landranger]

Thanks cherrypicker it seems to work fine

regards bob

 

[chrisian]

Hi Landranger,
I have found a similar spreadsheet that will work out whole circle bearings and distances. It also displays the WCB as Degrees Minutes and Seconds.
I just downloaded it from here:

http://www.lichfieldsurveysupplies.co.uk/survey_calculators.html

Regards,
Ian.