Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to determine the x & y coordinates based on angles for circle?
Does anyone know any excel function on how to determine the x & y coordinates
based on angles for circle? For example, the radius of circle is 1, if the angle is 0 degree, the the coordinate is (1,0), if the angle is 90 degree, the the coordinate is (0,1), if the angle is 60 degree, does anyone have any suggestion on how to determine the coordinate? Thank for any suggestions Eric |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to determine the x & y coordinates based on angles for circle?
for radius=r, angle=t, center=j,r
x=r * cos(t)+j y=r * sin(t) +k Now you have learned nothing from the assignment, how's that going to work out for you? "Eric" wrote: Does anyone know any excel function on how to determine the x & y coordinates based on angles for circle? For example, the radius of circle is 1, if the angle is 0 degree, the the coordinate is (1,0), if the angle is 90 degree, the the coordinate is (0,1), if the angle is 60 degree, does anyone have any suggestion on how to determine the coordinate? Thank for any suggestions Eric |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to determine the x & y coordinates based on angles for cir
Thank you very much for your suggestions
What if the circle is distorted, and became an ellipse, such as following equation (X*X)/(2*2)+(Y*Y)/(1*1)=1 Do you have any suggestions on how to locate the x & y coordinates based on the angle for ellipse? If I can find the coordinate for ellipse, then I can find the coordinate for circle, since the form of ellipse includes circle. Do you have any suggestions? Thank you for any suggestions Eric "dlw" wrote: for radius=r, angle=t, center=j,r x=r * cos(t)+j y=r * sin(t) +k Now you have learned nothing from the assignment, how's that going to work out for you? "Eric" wrote: Does anyone know any excel function on how to determine the x & y coordinates based on angles for circle? For example, the radius of circle is 1, if the angle is 0 degree, the the coordinate is (1,0), if the angle is 90 degree, the the coordinate is (0,1), if the angle is 60 degree, does anyone have any suggestion on how to determine the coordinate? Thank for any suggestions Eric |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to determine the x & y coordinates based on angles for cir
X=2*COS(RADIANS(THETA))
Y=SIN(RADIANS(THETA)) -- David Biddulph "Eric" wrote in message ... Thank you very much for your suggestions What if the circle is distorted, and became an ellipse, such as following equation (X*X)/(2*2)+(Y*Y)/(1*1)=1 Do you have any suggestions on how to locate the x & y coordinates based on the angle for ellipse? If I can find the coordinate for ellipse, then I can find the coordinate for circle, since the form of ellipse includes circle. Do you have any suggestions? Thank you for any suggestions Eric "dlw" wrote: for radius=r, angle=t, center=j,r x=r * cos(t)+j y=r * sin(t) +k Now you have learned nothing from the assignment, how's that going to work out for you? "Eric" wrote: Does anyone know any excel function on how to determine the x & y coordinates based on angles for circle? For example, the radius of circle is 1, if the angle is 0 degree, the the coordinate is (1,0), if the angle is 90 degree, the the coordinate is (0,1), if the angle is 60 degree, does anyone have any suggestion on how to determine the coordinate? Thank for any suggestions Eric |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to determine the x & y coordinates based on angles for circle?
Just another option: However, the engineering funtions make this a little
hard to do with Excel. Don't forget to convert Degrees to Radians. Radius here is 1. [x] =IMREAL(IMEXP(COMPLEX(LN(1),RADIANS(A1)))) [y] =(IMAGINARY(IMEXP(COMPLEX(LN(1),RADIANS(A1))))) -- HTH :) Dana DeLouis Windows XP & Excel 2007 "Eric" wrote in message ... Does anyone know any excel function on how to determine the x & y coordinates based on angles for circle? For example, the radius of circle is 1, if the angle is 0 degree, the the coordinate is (1,0), if the angle is 90 degree, the the coordinate is (0,1), if the angle is 60 degree, does anyone have any suggestion on how to determine the coordinate? Thank for any suggestions Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Determine next Saturday based on a given date | Excel Worksheet Functions | |||
How do I make circle within circle graphs in Excel 2003? | Charts and Charting in Excel | |||
How to determine the number of units based on given condition? | Excel Worksheet Functions | |||
Determine every wednesday based off year | Excel Discussion (Misc queries) | |||
Determine sums based on value possibilities | Excel Worksheet Functions |