[TowerTalk] Calculating Mutual and Array Drive Impedances - software

[n0tt1 at juno.com]

Hi Gents,    (also copy to W1MK)

I'm using the "w1mk-on4un-oh1tv-arrays.xls" program to calculate the
Mutual and Array Drive Impedances for a large phased array.
It's a program available on the CD that comes with ON4UN's
LBDXing book, 5th edition and maybe in previous editions 
as well.

I've entered and verified all the required data.  I noticed that
the spreadsheet says "You can only specify currents in two elements at
a time!  Make sur(e) the currents in other elements are set to ZERO". 

So, I do what it says, entering two currents/phases at a time, writing
down the
results (Magnatude and Imaginary values) of pairs of elements.  
My array has an odd number of elements, so there's one left on the list. 

So, I figured that I would re-enter the last two currents, repeating the 
next to the last one.  What I get are two different answers for the next 
to the last Mag and iMag.

If I enter the current/phase for just the last element, the result is
also different.

If I enter all the currents and phases at the same time, the Mag and iMag

values are different from the paired values...guess that's to be expected
because that doesn't follow the rules.

So now, I don't know what results to believe.

Any help or suggestions appreciated.

73,
Charlie, N0TT