|
Re: spreadsheet for importing snp files, Excel 2010
On 2022-05-30 09:44:-0700, you wrote:
Rich, What is SWR:Linear?Not sure. I was using the spreadsheet to 1. Confirm that menu items were returning values I expected, so that I could update the manual with meaningful language 2. Explore data relationships. I provided the spreadsheet in a separate thread so that 1. It would be easier to find, rather than being an offhand reply to a different message 2. Provide a path for those not as familiar with spreadsheets to be able to import data easier, and to see how the complex data is handled by Excel. Many of the formulae are in the user manual posted in the files section, so folks wanting to create their own spreadsheets (for plotting and comparisons, data exploration, etc) can use those equations to process the data once it is in complex form. Then it's up to users to decide how to use it. ~R~ |
|
Re: Nanovnasaver plots
On Mon, May 30, 2022 at 12:50 AM, tuckvk3cca wrote:
One port S11 measurement on a NanoVNA-H4 gives good results up to several thousand ohms (see attached 3K ohm example). It is better than using the S21 serial method. The S21 serial method does not work that well on a NanoVNA. The reason is that the Ch0 and CH1 impedances are not 50 ohms across a wide range of frequencies and the NanoVNA does not do a 12 point calibration. There have been several discussions in this group about measuring chokes, baluns and impedance using various methods. Lots of good info if you do a group search. Roger |
|
Re: Nanovnasaver plots
On Sun, May 29, 2022 at 12:50 AM, tuckvk3cca wrote:
There are two methods to Convert S21 to Z. The series method is used for "high impedances" and the "shunt method" for low impedances. These are built into the latest firmware for H/H4 and in NanoVNA Saver and NanoVNA app. You need a very good test jig for S21 series or the phase angle will have errors and the impedance measured will be way off. Also the H/H4 do not have precise 50 ohm source and load impedance so you get errors from that as well. But to directly answer your question here is is a link to a Web site with a spreadsheet. The link is in the last paragraph. Here is a link to another one.... /g/nanovna-users/message/17807 Roger |
|
nVNA-H4 v4.3_MS, firmware 1.1, User Manual 0100
I posted an updated version of this doc, which is the same content as the older doc, but because it contains more operational information, I renamed it to a user manual. I thought that I had sent a message to the group when it posted, but I didn't see the message.
We now have a newer firmware version, so I'll see if I can find the time to update... ~R~ 72/73 de Rich NE1EE The Dusty Key On the banks of the Piscataqua |
|
Re: Locked, then white screen on NanoVNA-H
Yes, disconnect all power for a while. The ultimate and first try to fix ANY and EVERY computer that I know of. Even my wife has learned that.
toggle quoted message
Show quoted text
Dave K8WPE David J. Wilcox¡¯s iPad On May 28, 2022, at 1:40 PM, Roger Need via groups.io <sailtamarack@...> wrote: |
|
Re: Nanovnasaver plots
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 |
John M. Polard F5VLB
Rich NE1EE
Roger Need
F4WCV
David Wilcox K8WPE