Tanks, impedance, the j operator and excel

Hi gang,
This one is directed at you math whizzes..... I have a formula for tank
circuit impedance that I am attempting to analyze/plot in MS Excel. The tank
consists of a resistor in series with the coil, a cap in parallel with the
coil resistor combination and a another resistor in parallel with the cap
and coil/resistor.
The formula consists of two quotients; One has a numerator that consists of
several terms multiplied, added, squared, etc and the denominator is
similar. The second quotient is preceded by the "j" operator. (That is the
entire quotient appears to be "j"ed rather than any single term or factor).
This quotient has a numerator and denominator similar to the first).
I assume that the first quotient is the real part of the impedance, while
the second one is the imaginary part, yielding the rectangular Z =R +/-j
form. Does this sound correct?
Assuming the math is done correctly, I believe I can use the IMABS function
on the result to get the magnitude of the impedance. Yes?
In Excel, I have entered the first quotient as ordinary numbers, i.e.
"=A1*(C2+B3)..../D4*6.28*C3......"
I'm getting numbers that seem to make sense.
The second quotient has me scratching my head a bit. I have tried using the
same process on this part, and then using "=IMABS(first quotient
results,+second quotient results)" to get the magnitude of the impedance but
I think this may be incorrect.
Any thoughts? If someone wants it, I can post my Excel file to them.....

Thanks

Bob WB0POQ


.

Quantcast