Hi I just joined the list.
I am brand new to VNA's and especially to s1p/s2p style files.
Is there a way to parce the data?
When I open an s1p file in wordpad, I see 101 frequency points, each followed by 2 sets of numbers with 9 decimal points for each frequency interval in the sweep.
Is there a formula one can write in excel to spit out the actual numbers one might want such as VSWR, impedance and return loss at each frequency interval?
Or can someone give me a crash course in interpreting those numbers?
I'm using the NanoVNA and everything works great in the software and on the unit.
But I would like to be able to open a spread sheet and see VSWR/impedance/return loss at each frequency for reference purposes. Or whatever measurement I want to look at for that matter
The fox delta antenna analyzer software has a very handy table feature where it will show measurements in a table by frequency. It would be super cool if something like that could be implemented in something like Roger's Nanosharp
I've imported a txt version of a s1p file into excel and while it certainly shortens the number string, it still doesn't necessarily give me the info I'm seeking. That's obviously because I don't know exactly how to interpret the data.
Googling for help doesn't really get me much either.
Thanks for any help.
Regards
Colin
toggle quoted message
Show quoted text
-----Original Message-----
From: WB2UAQ
Sent: Sunday, September 13, 2020 6:23 PM
To:
[email protected]Subject: Re: [nanovna-users] Writing nanovna results to csv file #nanovna-saver
I have been saving s1p and s2p files from Saver and then re-save them as .txt files. In Excel I import external data in the .txt format and delimit using spaces. This works well for using S21 Thru and S21 Shunt methods for calculating low impedances and high impedances. Having a great time with this little NanoVNA. BTW, when I was involved with hp network analyzers never heard the term VNA for them as it was assumed they could measure the amplitude and phase. They were referred to as network analyzers. Or scaler network analyzers for those that could not determine phase relationships (they used diode detectors only).
