Hi Rune
If you go to G3TXQ's website: and click on the hyperlink "spreadsheet" which is almost at the bottom of the page , you will get a XL file which calculates "Z" from S11 & S21 data. Take note that the file was originally created in Open Document Format and needs to be converted to XL. I got some warning messages of possible format loss during conversion to XL 2016 so frankly I am not sure if my conversion process is correct & the formula's got corrupted. I also note that calculation of Z is based on S21 data only, and the formulas are as follows: (copied from the XL sheet and I am trying to understand this!)
R =100*10^(-S21mag/20)*COS(S21phase/57.29578)-100
X = -(R+100)*TAN(S21phase/57.29578)
Z = SQRT(R^2+X^2)
S21mag(dB) in NanoVNA Saver = |S21| - is this correct? OR is it Logarithmic Magnitude (Log Mag /dB Mag)
S21phase(deg) in NanoVNA Saver = S21 phase - this should be correct
Excellent software, its just me trying to learn to use it correctly! Any help is much appreciated.
BR-Nan
