convert from rectangualr to polar

[Alfy]

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]

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?

[Bill Martin]

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

[Alfy]

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".

[Sloth]

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
>
>

[B. R.Ramachandran]

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
>
>

[Alfy]

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?

[B. R.Ramachandran]

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
>
>

[Alfy]

thanks!

[Dana DeLouis]

> =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" <[email protected]> wrote in
message news:[email protected]...
> 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
>>
>>