LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Old January 24th 05, 04:55 AM
Joel Kolstad
 
Posts: n/a
Default

Well, i've never used Excel for vector algebra.

It's certainly nowhere near as clean as, e.g., Matlab or MathCAD, but it can
certainly do it. Look up the 'COMPLEX' function; it'll tell you you need to
install the 'Analysis ToolPak add-in' and under 'see also' point you to the
functions you'll need (e.g., IMSUM for complex arithmetic, etc.)

As i understand the Z11 formula
i stated, you will still get a vector
solution, so in essence the Z11 will
be a gamma reflection coefficient, or magnitude
(from 0 to 1) with an angle.


Right, or... just a regular old complex number. You can use IMABS and
IMARGUMENT to obtain the maginutde and angle of your complex number.

---Joel




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ranger II 8 prong plug patgkz Boatanchors 9 January 8th 05 03:23 PM
an all-shadow stream for fans of the old time radio series! DJ Twain Broadcasting 0 May 14th 04 10:49 PM
FS: HP/TOSHIBA/COMPAQ AC ADAPTORS $10USDea +shipping Dave & Daphne Schertzer Swap 0 February 20th 04 12:45 AM
FS: OLDER HP, TOSHIBA, COMPAQ AC LAPTOP ADAPTORS $15EA+SHIP Dave & Daphne Schertzer Swap 0 January 31st 04 02:11 AM


All times are GMT +1. The time now is 07:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 RadioBanter.
The comments are property of their posters.
 

About Us

"It's about Radio"

 

Copyright © 2017