Keyboard Shortcuts
ctrl + shift + ? :
Show all keyboard shortcuts
ctrl + g :
Navigate to a group
ctrl + shift + f :
Find
ctrl + / :
Quick actions
esc to dismiss
Likes
Search
#export Help! How can I export data to Excel?
#export
|
Hi All,
I am an absolute newbie to nanoVNA, and beg your indulgence. Having once used a $100,000 VNA, using this toy VNA is fun and exciting. But I request help. I am using a clone NanoVNA V2, and VNA View software. 1. Is there a way to export measured curves to Excel, or save the data to a file that can be read by Excel (e.g. .CSV) using this software? 2. Is there an alternative software package that will allow the above, and if so, can you send a link for downloading it? Thanks and regards, Ray From the home of Prof. Emeritus Raymond (Reuven) Boxman School of Electrical Engineering Tel Aviv University Cell: +972 544 634 217 CEO Clear Wave Ltd. <> Scientific Writing Courses: <> |
|
Hello Raymond,
After saving the data as an s1p or s2p file, I resave it as a txt file. I then open up Excel and select Data and then import the data selecting txt file. I then save the data using "spaces" to get the data in the correct column format. I am no expert with Excel and I am sure there will be other suggestions that might be better but I have done this successfully now for more than a year and got accustomed to it! Pete retired EE |
|
Ray,
toggle quoted message
Show quoted text
As Pete mentioned in the prev mesg, Touchstone files are the industry standard for exporting data from this type of equipment. Here is the spec: Regards, Larry On Tuesday, July 27, 2021, 5:19:10 a.m. EDT, Ray <boxman@...> wrote:
Hi All, I am an absolute newbie to nanoVNA, and beg your indulgence. Having once used a $100,000 VNA, using this toy VNA is fun and exciting. But I request help. I am using a clone NanoVNA V2, and VNA View software. 1.? ? ? Is there a way to export measured curves to Excel, or save the data to a file that can be read by Excel (e.g. .CSV) using this software? 2.? ? ? Is there an alternative software package that will allow the above, and if so, can you send a link for downloading it? Thanks and regards, Ray From the home of Prof. Emeritus Raymond (Reuven) Boxman School of Electrical Engineering Tel Aviv University Cell:? ? ? +972 544 634 217 CEO Clear Wave Ltd.? ? ? ? ? ? ? ? <> Scientific Writing Courses:? ? ? ? <> |
|
TNX Larry and Pete!
toggle quoted message
Show quoted text
So let me ask the real newbie question: Where in "NVA view" is the command for saving the data as an s1p or s2p file? Regards, Ray (4X1RB, formerly KB2RG)) From the home of Prof. Emeritus Raymond (Reuven) Boxman School of Electrical Engineering Tel Aviv University Cell: ???? +972 544 634 217 CEO Clear Wave Ltd.? ????????????? Scientific Writing Courses: ??????? -----Original Message-----
From: [email protected] <[email protected]> On Behalf Of WB2UAQ Sent: ????? 27 ???? 2021 14:33 To: [email protected] Subject: Re: [nanovna-users] #export Help! How can I export data to Excel? For got to add after selecting Data, select Get External Data then select From Text. I then calculate the parameters I want from the s1p or s2p and plot them. All I generally use is gamma (S11 mag and phase) and lately S21 mag and phase for using the S21 Shunt-thru method to measure low impedances. |
|
I've never used it but a google search had this as a 1st hit:
toggle quoted message
Show quoted text
On Tuesday, July 27, 2021, 8:20:56 a.m. EDT, Ray <boxman@...> wrote:
TNX Larry and Pete! So let me ask the real newbie question: Where in "NVA view" is the command for saving the data as an s1p or s2p file? Regards, Ray (4X1RB, formerly KB2RG)) From the home of Prof. Emeritus Raymond (Reuven) Boxman School of Electrical Engineering Tel Aviv University Cell: ???? +972 544 634 217 CEO Clear Wave Ltd.? ????????????? Scientific Writing Courses: ??????? -----Original Message----- From: [email protected] <[email protected]> On Behalf Of WB2UAQ Sent: ????? 27 ???? 2021 14:33 To: [email protected] Subject: Re: [nanovna-users] #export Help! How can I export data to Excel? For got to add after selecting Data, select Get External Data then select From Text.? I then calculate the parameters I want from the s1p or s2p and plot them.? All I generally use is gamma (S11 mag and phase) and lately S21 mag and phase for using the S21 Shunt-thru method to measure low impedances. |
|
Hi Larry,
toggle quoted message
Show quoted text
Thanks. But the link is to a description of software to run the nanoVNA under LabView. What software are you using to run your nanoVAN? Do you recommend it? Can you point me towards a link for downloading it? Thanks, Ray From the home of Prof. Emeritus Raymond (Reuven) Boxman School of Electrical Engineering Tel Aviv University Cell: ???? +972 544 634 217 CEO Clear Wave Ltd.? ????????????? Scientific Writing Courses: ??????? -----Original Message-----
From: [email protected] <[email protected]> On Behalf Of Larry Rothman Sent: ????? 27 ???? 2021 15:40 To: [email protected] Subject: Re: [nanovna-users] #export Help! How can I export data to Excel? I've never used it but a google search had this as a 1st hit: On Tuesday, July 27, 2021, 8:20:56 a.m. EDT, Ray <boxman@...> wrote: TNX Larry and Pete! So let me ask the real newbie question: Where in "NVA view" is the command for saving the data as an s1p or s2p file? Regards, Ray (4X1RB, formerly KB2RG)) From the home of Prof. Emeritus Raymond (Reuven) Boxman School of Electrical Engineering Tel Aviv University Cell: ???? +972 544 634 217 CEO Clear Wave Ltd.? ????????????? Scientific Writing Courses: ??????? -----Original Message----- From: [email protected] <[email protected]> On Behalf Of WB2UAQ Sent: ????? 27 ???? 2021 14:33 To: [email protected] Subject: Re: [nanovna-users] #export Help! How can I export data to Excel? For got to add after selecting Data, select Get External Data then select From Text. I then calculate the parameters I want from the s1p or s2p and plot them.? All I generally use is gamma (S11 mag and phase) and lately S21 mag and phase for using the S21 Shunt-thru method to measure low impedances. |
|
Sorry, but I use OneOfEleven's NanoVNA-App software, available here:
toggle quoted message
Show quoted text
direct link: The Windows source code is on github for ver 1.0.207 but many users have had issues with that. There is no doc but after installing, move mouse over graph area and right click for context menu. Make sure to specify calibration source of external as it defaults to none. On Tuesday, July 27, 2021, 8:46:25 a.m. EDT, Ray <boxman@...> wrote:
Hi Larry, Thanks. But the link is to a description of software to run the nanoVNA under LabView. What software are you using to run your nanoVAN? Do you recommend it? Can you point me towards a link for downloading it? Thanks, Ray From the home of Prof. Emeritus Raymond (Reuven) Boxman School of Electrical Engineering Tel Aviv University Cell: ???? +972 544 634 217 CEO Clear Wave Ltd.? ????????????? Scientific Writing Courses: ??????? -----Original Message----- From: [email protected] <[email protected]> On Behalf Of Larry Rothman Sent: ????? 27 ???? 2021 15:40 To: [email protected] Subject: Re: [nanovna-users] #export Help! How can I export data to Excel? I've never used it but a google search had this as a 1st hit: ? ? On Tuesday, July 27, 2021, 8:20:56 a.m. EDT, Ray <boxman@...> wrote: TNX Larry and Pete! So let me ask the real newbie question: Where in "NVA view" is the command for saving the data as an s1p or s2p file? Regards, Ray (4X1RB, formerly KB2RG)) From the home of Prof. Emeritus Raymond (Reuven) Boxman School of Electrical Engineering Tel Aviv University Cell: ???? +972 544 634 217 CEO Clear Wave Ltd.? ????????????? Scientific Writing Courses: ??????? -----Original Message----- From: [email protected] <[email protected]> On Behalf Of WB2UAQ Sent: ????? 27 ???? 2021 14:33 To: [email protected] Subject: Re: [nanovna-users] #export Help! How can I export data to Excel? For got to add after selecting Data, select Get External Data then select From Text. I then calculate the parameters I want from the s1p or s2p and plot them.? All I generally use is gamma (S11 mag and phase) and lately S21 mag and phase for using the S21 Shunt-thru method to measure low impedances. |
|
Hi Larry and Vladimir:
toggle quoted message
Show quoted text
Many thanks. I installed version from Larry's link, and it looks like you can directly save CSV files, which is perfect. I am starting to learn it by trial and error, but would appreciate any link to a users' manual or instructions. Regards, Ray From the home of Prof. Emeritus Raymond (Reuven) Boxman School of Electrical Engineering Tel Aviv University Cell: ???? +972 544 634 217 CEO Clear Wave Ltd.? ????????????? Scientific Writing Courses: ??????? -----Original Message-----
From: [email protected] <[email protected]> On Behalf Of Vladimir Lebedev Sent: ????? 27 ???? 2021 16:37 To: [email protected] Subject: Re: [nanovna-users] #export Help! How can I export data to Excel? Hello Larry! Here in ZIP file in directory Win32/Release is a last stable version NanoVNA-APP 1.1.207 without crash. Best regards Vladimir , dl7pga |
|
Sorry, no manual or instructions for the Nanovna-App.
toggle quoted message
Show quoted text
Search the Forum's various posts regarding use. On Tuesday, July 27, 2021, 9:54:52 a.m. EDT, Ray <boxman@...> wrote:
Hi Larry and Vladimir: Many thanks. I installed version from Larry's link, and it looks like you can directly save CSV files, which is perfect. I am starting to learn it by trial and error, but would appreciate any link to a users' manual or instructions. Regards, Ray From the home of Prof. Emeritus Raymond (Reuven) Boxman School of Electrical Engineering Tel Aviv University Cell: ???? +972 544 634 217 CEO Clear Wave Ltd.? ????????????? Scientific Writing Courses: ??????? -----Original Message----- From: [email protected] <[email protected]> On Behalf Of Vladimir Lebedev Sent: ????? 27 ???? 2021 16:37 To: [email protected] Subject: Re: [nanovna-users] #export Help! How can I export data to Excel? Hello Larry! Here in ZIP file in directory Win32/Release is a last stable version NanoVNA-APP 1.1.207 without crash. Best regards Vladimir , dl7pga |
|
Thanks! I see the author fixed the mouse-over crash issue when she uploaded the source to Github.
toggle quoted message
Show quoted text
On Tuesday, July 27, 2021, 9:36:50 a.m. EDT, Vladimir Lebedev <dl7pga@...> wrote:
Hello Larry! Here in ZIP file in directory Win32/Release is a last stable version NanoVNA-APP 1.1.207 without crash. Best regards Vladimir , dl7pga |
|
Interesting - I had the same issue when I tried the 1.1.207 app from the releases area on OneOfEleven's github site but the 1.1.207 from the zipped file in my last post is working OK.
toggle quoted message
Show quoted text
Which one did you try - the Github one or from the zipped link in my post? On Tuesday, July 27, 2021, 12:12:37 p.m. EDT, Gary W9TD <w9td@...> wrote:
I get an access violation using this version (1.1.207) and it is unusable. 1.1.206 has no problems here. Gary W9TD |
|
That's the same copy (1.1.207) I just installed - and it's working for me now.
toggle quoted message
Show quoted text
Did you D/L from here?: Grab the folder named Win32? ("NanoVNA-App 1.0.207 main.zip\NanoVNA-App-main\Win32") , rename it to "Nanovna-App" and run the exe app from there. It comes up as 1.1.207 On Tuesday, July 27, 2021, 1:52:27 p.m. EDT, Gary W9TD <w9td@...> wrote:
Larry, I used the link to github provided by Vladimir. I will try yours. Gary W9TD |
|
Sorry - the path to the folder should be "Release" - not Win32:
toggle quoted message
Show quoted text
"NanoVNA-App 1.0.207 main.zip\NanoVNA-App-main\Win32\Release" Rename "Release" to whatever you want and run Nanovna-App from there. On Tuesday, July 27, 2021, 3:16:57 p.m. EDT, Larry Rothman <nlroth@...> wrote:
That's the same copy (1.1.207) I just installed - and it's working for me now. Did you D/L from here?:? Grab the folder named Win32? ("NanoVNA-App 1.0.207 main.zip\NanoVNA-App-main\Win32") , rename it to "Nanovna-App" and run the exe app from there. It comes up as 1.1.207 ? ? On Tuesday, July 27, 2021, 1:52:27 p.m. EDT, Gary W9TD <w9td@...> wrote: Larry, I used the link to github provided by Vladimir. I will try yours. Gary W9TD |
Vladimir Lebedev
Gary W9TD
to navigate to use esc to dismiss