I have a list of data in rectangular form (a+bi) and need to convert it
to polar form (a/_b) in order to find the magnitude. The phase angle
doesnt matter much just really need the magnitude. Any help on
achieving this would be of great help.
thanks;
Alfy


--
Alfy
------------------------------------------------------------------------
Alfy's Profile: http://www.excelforum.com/member.php...o&userid=32049
View this thread: http://www.excelforum.com/showthread...hreadid=517977

On Wed, 1 Mar 2006 14:23:25 -0600, Alfy wrote:

I have a list of data in rectangular form (a+bi) and need to convert it
to polar form (a/_b) in order to find the magnitude. The phase angle
doesnt matter much just really need the magnitude. Any help on
achieving this would be of great help.
thanks;
Alfy

---------------------------------

Here's the math: http://home.alltel.net/okrebs/page111.html

Bill

in order to find the magnitude of the rect. form its just:
sqrt(a^2+b^2)
what i have is a form like a+bi so is there a way to apply formula to
the numbers? or possibly seperate a and b into seperate columns and go
from there?


--
Alfy
------------------------------------------------------------------------
Alfy's Profile: http://www.excelforum.com/member.php...o&userid=32049
View this thread: http://www.excelforum.com/showthread...hreadid=517977

is there a way to implement the formula to do the conversion in excel? I
have 2500 expressions( 5 sheets) = 12500 times i would i have to do it
manually. only need the magnitude from the rectangular form, so
r^2=a^2+b^2 where what i need is "r".


--
Alfy
------------------------------------------------------------------------
Alfy's Profile: http://www.excelforum.com/member.php...o&userid=32049
View this thread: http://www.excelforum.com/showthread...hreadid=517977

You can use data text to columns to extract the data (use + as the
delimiter). You can then use find and replace to delete the i in the second
column.

"Alfy" wrote:


in order to find the magnitude of the rect. form its just:
sqrt(a^2+b^2)
what i have is a form like a+bi so is there a way to apply formula to
the numbers? or possibly seperate a and b into seperate columns and go
from there?


--
Alfy
------------------------------------------------------------------------
Alfy's Profile: http://www.excelforum.com/member.php...o&userid=32049
View this thread: http://www.excelforum.com/showthread...hreadid=517977

Hi,

If the data are in the format "a+bi" (e.g., 1.2+2.1i), try the following
formula (it is written for the contents of A1).

=SQRT(LEFT(A1,FIND("+",A1)-1)^2+RIGHT(LEFT(A1,LEN(A1)-1),LEN(A1)-FIND("+",A1)-1)^2)

Regards,
B. R. Ramachandran

"Alfy" wrote:


in order to find the magnitude of the rect. form its just:
sqrt(a^2+b^2)
what i have is a form like a+bi so is there a way to apply formula to
the numbers? or possibly seperate a and b into seperate columns and go
from there?


--
Alfy
------------------------------------------------------------------------
Alfy's Profile: http://www.excelforum.com/member.php...o&userid=32049
View this thread: http://www.excelforum.com/showthread...hreadid=517977

thanks! it seems to work, and i assume just change "+" to "-" when its
being subtracted...only what would you have to do if the first number
is negative?


--
Alfy
------------------------------------------------------------------------
Alfy's Profile: http://www.excelforum.com/member.php...o&userid=32049
View this thread: http://www.excelforum.com/showthread...hreadid=517977

Hi,

Try this much simpler formula.

=SQRT(IMREAL(A1)^2+IMAGINARY(A1)^2)

It should work for positive as well as negative real and imaginary components.

Regards,
B. R. Ramachandran

"Alfy" wrote:


thanks! it seems to work, and i assume just change "+" to "-" when its
being subtracted...only what would you have to do if the first number
is negative?


--
Alfy
------------------------------------------------------------------------
Alfy's Profile: http://www.excelforum.com/member.php...o&userid=32049
View this thread: http://www.excelforum.com/showthread...hreadid=517977

thanks! :)


--
Alfy
------------------------------------------------------------------------
Alfy's Profile: http://www.excelforum.com/member.php...o&userid=32049
View this thread: http://www.excelforum.com/showthread...hreadid=517977

=SQRT(LEFT(A1,FIND("+",A1)-1)^2+RIGHT(LEFT(A1,LEN(A1)-1),LEN(A1)-FIND("+",A1)-1)^2)

Just to add...

=IMABS(A1)

will do the same thing.
--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"B. R.Ramachandran" wrote in
message ...
Hi,

If the data are in the format "a+bi" (e.g., 1.2+2.1i), try the following
formula (it is written for the contents of A1).

=SQRT(LEFT(A1,FIND("+",A1)-1)^2+RIGHT(LEFT(A1,LEN(A1)-1),LEN(A1)-FIND("+",A1)-1)^2)

Regards,
B. R. Ramachandran

"Alfy" wrote:


in order to find the magnitude of the rect. form its just:
sqrt(a^2+b^2)
what i have is a form like a+bi so is there a way to apply formula to
the numbers? or possibly seperate a and b into seperate columns and go
from there?


--
Alfy
------------------------------------------------------------------------
Alfy's Profile:
http://www.excelforum.com/member.php...o&userid=32049
View this thread:
http://www.excelforum.com/showthread...hreadid=517977