Firstly, thank you for being interested in my question and opening this.
I'm having a hard time calculating input impedance by transmission line theory.
I'm a student studying microwave absorbers. In this field, it is necessary to calculate input impedance to finally obtain reflection loss.
I've uploaded a file showing the equation of transmission line theory.
In the equation, I wonder how I can treat 'j' in tanh when I calculate it in excel program.
I've tried solving the tanh part in many ways like this, but I couldn't
TANH((COMPLEX(0,1))*(2*3.14*((10)^(-2))*(2/3)*((M2*N2)^(1/2))))
TANH((COMPLEX((2*3.14*((10)^(-2))*(2/3)*((N2*O2)^(1/2))),1)))
IMPRODUCT("0+1i", "(2*3.14*((10)^(-2))*(2/3)*((M2*N2)^(1/2)))+0i")
I have no idea how I should threat 'j' in tanh
I'd appreciate it if you'd help me to solve this question.
Best regards.
You can probably do it the way you are trying but as soon as you have generated a complex number you have to use improduct(c1,c2,c3,.....) to multiply them, * doesn't work. You also have to use imdiv() instead of /.
Example complex(1,5)*2 won't work
improduct(complex(1,5),2) does work.
First check whether is it a typographical error or not. Normally, I never saw 'j' in the argument part of tanh(). If we assume that the expression is correct, then use basic exponential mathematics: tanh(x) = sinh(x) / cosh(x) = [exp(x) - exp(-x)] / [exp(x) + exp(-x)]. Now replace 'x' by 'jx'. Therefore, we can write: tanh(jx) = sinh(jx) / cosh(jx) = [exp(jx) - exp(-jx)] / [exp(jx) + exp(-jx)] = -j*sin(x)/cos(x) = -j*tan(x). I think, this will help to calculate Zin using excel.
Sudipta Maity hi I have tried your method but the excel show #NUM! error so could you guide me with any other formula??
Why don't you try the same using FORTRAN/C/C++/MATLAB etc numerical software. Excel is good for office work, not for research.