software

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: www.excelforum.com/member.php...oamp;userid=32049
View this thread: www.excelforum.com/showthread...hreadid=517977On Wed, 1 Mar 2006 14:23:25 -0600, Alfy wrote:

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

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

Here's the math: 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: www.excelforum.com/member.php...oamp;userid=32049
View this thread: 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 quot;rquot;.--
Alfy
------------------------------------------------------------------------
Alfy's Profile: www.excelforum.com/member.php...oamp;userid=32049
View this thread: www.excelforum.com/showthread...hreadid=517977You 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.

quot;Alfyquot; wrote:

gt;
gt; in order to find the magnitude of the rect. form its just:
gt; sqrt(a^2 b^2)
gt; what i have is a form like a bi so is there a way to apply formula to
gt; the numbers? or possibly seperate a and b into seperate columns and go
gt; from there?
gt;
gt;
gt; --
gt; Alfy
gt; ------------------------------------------------------------------------
gt; Alfy's Profile: www.excelforum.com/member.php...oamp;userid=32049
gt; View this thread: www.excelforum.com/showthread...hreadid=517977
gt;
gt;

Hi,

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

=SQRT(LEFT(A1,FIND(quot; quot;,A1)-1)^2 RIGHT(LEFT(A1,LEN(A1)-1),LEN(A1)-FIND(quot; quot;,A1)-1)^2)

Regards,
B. R. Ramachandran

quot;Alfyquot; wrote:

gt;
gt; in order to find the magnitude of the rect. form its just:
gt; sqrt(a^2 b^2)
gt; what i have is a form like a bi so is there a way to apply formula to
gt; the numbers? or possibly seperate a and b into seperate columns and go
gt; from there?
gt;
gt;
gt; --
gt; Alfy
gt; ------------------------------------------------------------------------
gt; Alfy's Profile: www.excelforum.com/member.php...oamp;userid=32049
gt; View this thread: www.excelforum.com/showthread...hreadid=517977
gt;
gt;


thanks! it seems to work, and i assume just change quot; quot; to quot;-quot; when its
being subtracted...only what would you have to do if the first number
is negative?--
Alfy
------------------------------------------------------------------------
Alfy's Profile: www.excelforum.com/member.php...oamp;userid=32049
View this thread: www.excelforum.com/showthread...hreadid=517977Hi,

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

quot;Alfyquot; wrote:

gt;
gt; thanks! it seems to work, and i assume just change quot; quot; to quot;-quot; when its
gt; being subtracted...only what would you have to do if the first number
gt; is negative?
gt;
gt;
gt; --
gt; Alfy
gt; ------------------------------------------------------------------------
gt; Alfy's Profile: www.excelforum.com/member.php...oamp;userid=32049
gt; View this thread: www.excelforum.com/showthread...hreadid=517977
gt;
gt;


thanks! --
Alfy
------------------------------------------------------------------------
Alfy's Profile: www.excelforum.com/member.php...oamp;userid=32049
View this thread: www.excelforum.com/showthread...hreadid=517977gt; =SQRT(LEFT(A1,FIND(quot; quot;,A1)-1)^2 RIGHT(LEFT(A1,LEN(A1)-1),LEN(A1)-FIND(quot; quot;,A1)-1)^2)

Just to add...

=IMABS(A1)

will do the same thing.
--
HTH. :gt;)
Dana DeLouis
Windows XP, Office 2003quot;B. R.Ramachandranquot; gt; wrote in
message ...
gt; Hi,
gt;
gt; If the data are in the format quot;a biquot; (e.g., 1.2 2.1i), try the following
gt; formula (it is written for the contents of A1).
gt;
gt; =SQRT(LEFT(A1,FIND(quot; quot;,A1)-1)^2 RIGHT(LEFT(A1,LEN(A1)-1),LEN(A1)-FIND(quot; quot;,A1)-1)^2)
gt;
gt; Regards,
gt; B. R. Ramachandran
gt;
gt; quot;Alfyquot; wrote:
gt;
gt;gt;
gt;gt; in order to find the magnitude of the rect. form its just:
gt;gt; sqrt(a^2 b^2)
gt;gt; what i have is a form like a bi so is there a way to apply formula to
gt;gt; the numbers? or possibly seperate a and b into seperate columns and go
gt;gt; from there?
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Alfy
gt;gt; ------------------------------------------------------------------------
gt;gt; Alfy's Profile:
gt;gt; www.excelforum.com/member.php...oamp;userid=32049
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=517977
gt;gt;
gt;gt;