On 2022-05-29 00:50:-0700, you wrote:
Great thanks. Any body has a spreadsheet then to convert S21 gain and phase data into impedances?
You might find this useful...I did it with real data from my -H4 and my EF 40 m wire. You can make a copy of this spreadsheet so that you have a backup.
Then open it,
and start a new spreadsheet.
Select Data > From Text
In the File Selector mask drop box, select all files *.*
Browse to your s1p / s2p files
import one
start at line ? depending on what line data starts in your snp file.
should read right in.
----- either
copy your data in cols to this spreadsheet, noting that it has a col inserted where freq is converted to MHz
if your data is shorter (fewer rows) delete the extra rows
-----or
copy the formulas from this spreadsheet to your spreadsheet, paying attention to changing cols
It's just some thing I tossed together to look at some data but
S11, SWR, Linear, SWR:Linear, Z, |Z|, Q
are all good calculations
~R~
72/73 de Rich NE1EE
The Dusty Key
On the banks of the Piscataqua
Rich NE1EE