The S1P files contains the real and imaginary parts of the reflection coefficient, Greek letter ¡®gamma¡¯.
The complex impedance Z is given by Zo * (1+gamma) / (1-gamma)
Excel has the capability of working and manipulating complex numbers, so the spreadsheet formulae can be simplified and use directly the values from the S1P file.
I believe complex number feature also exists in LibreOffice.
To obtain the impedance magnitude after this requires conversion to polar form.
ATAN2 is a useful function to use.
Kind regards
Ed, G8FAX
