Polar to cartesian convert with function

Correct plot should be (50, 40) or (40, 50)...? I'm assuming 0 degrees is from the origin and extending along the positive x-axis and thus your answer would be (40, 50). This confusion may be tied to your statement of converting cartesian angles to polar angles. I don't know what you mean by a cartesian angle since the cartesian system uses points.

Can you upload your spreadsheet so we can see how you are using these functions? Can you be sure to include an example of incorrect results? I cannot recreate your erroneous values based on what you have posted, and the functions seem to work correctly for me.

Now I understand. You are trying to show compass bearings and distances. Two things have to happen with compass bearings:

1) Standard reference for polar coordinates is the positive x axis (going right). Reference for bearings is north (vertical). So to convert bearings to polar, we need to rotate the angle 90 degrees CCW (pi/2 radians).
2) Polar angles increase CCW. Bearing angles increase CW, so we need to invert the "direction" of the angles.

I think this should be a simple rotation/inversion operation: polarangle=90-bearingangle
or in your function:

Please Login or Register  to view this content.

If that helped, and you feel you should become more proficient in this sort of thing, I would suggest that you spend some time to become more proficient in using and understanding the unit circle. IMO, the unit circle is often the easiest "model" for understanding and visualizing basic trig concepts like this. If it helps, I posted a spreadsheet to illustrate properties of the unit circle and basic trig functions: http://www.excelforum.com/tips-and-t...ml#post4291629

For compass headings (i.e., angle a in radians measured CW from +y),

x = d*sin(a)

y = d*cos(a)

a = atan2(y, x)

For anyone who finds it useful,

Row\Col	A	B	C	D	E	F
1	direction	from	function	x	y	Remarks
2	CCW	+x	= ATAN2(x, y)	COS(Θ)	SIN(Θ)	Classic trig
3	CCW	+y	= ATAN2(y, -x)	-SIN(Θ)	COS(Θ)
4	CCW	-x	= ATAN2(-x, -y)	-COS(Θ)	-SIN(Θ)
5	CCW	-y	= ATAN2(-y, x)	SIN(Θ)	-COS(Θ)
6	CW	+x	= ATAN2(x, -y)	COS(Θ)	-SIN(Θ)
7	CW	+y	= ATAN2(y, x)	SIN(Θ)	COS(Θ)	Compass (East-North-Up)
8	CW	-x	= ATAN2(-x, y)	-COS(Θ)	SIN(Θ)
9	CW	-y	= ATAN2(-y, -x)	-SIN(Θ)	-COS(Θ)	Compass reciprocal

Originally Posted by B_Siva

Hi,
Do you have table for 3D coordinates? X,Y,Z

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread