Converting rectangular coodinates to WCBs in excel spreadsheet
Converting rectangular coodinates to WCBs in excel spreadsheet
(OP)
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?
i need to somehow convert that to a true whole circle bearing.
i am not very up on excel, can some one help?





RE: Converting rectangular coodinates to WCBs in excel spreadsheet
=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
RE: Converting rectangular coodinates to WCBs in excel spreadsheet
regards bob
RE: Converting rectangular coodinates to WCBs in excel spreadsheet
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
Regards,
Ian.