search

NanoVNA-Saver / nanovna-saver

A tool for reading, displaying and saving data from the NanoVNA
GNU General Public License v3.0
896 stars 272 forks source link

Export data to Excel #50

Closed PY3IG closed 5 years ago

PY3IG commented 5 years ago

I think exporting the data generated by VNA to Excel allows you to do other work. As an example we have the study of G3TXQ with RF chokes. With miniVNA you can reproduce this experiment using the spreadsheet available. http://www.karinya.net/g3txq/chokes/ I would like to reproduce the experiment using nanoVNA Thanks

mihtjel commented 5 years ago

Hello, the Touchstone files exported under "Files", "Save file (S1P)" / S2P can be imported into Excel. :-)

mihtjel commented 5 years ago

Hello, the specification is here: https://ibis.org/touchstone_ver2.0/touchstone_ver2_0.pdf

The format is: HZ S11-Re S11-Im S21-Re S21-Im 0 0 0 0

The value represented is S11 and S21 in complex form. See:

https://en.wikipedia.org/wiki/Scattering_parameters

-- Rune / 5Q5R

On Sat, 19 Oct 2019 at 16:21, PY3IG notifications@github.com wrote:

Could you help me name each column? This data was exported to S2P. I want to capture the data loss transmission and transmission phase. Thanks! | Hz | S | RI | R | 50

3000000 = Hz probably 0.9927071011657248 = 0.06675267100972475 = 0.004743234093470405 = -0.08028878868055044 = 0 0 0 0

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub https://github.com/mihtjel/nanovna-saver/issues/50?email_source=notifications&email_token=AGLTTOIUJVGZTK6IFAEDBVLQPMQZLA5CNFSM4JCCWBT2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEBXTM2Q#issuecomment-544159338, or unsubscribe https://github.com/notifications/unsubscribe-auth/AGLTTOPGMJGNPCKQOPQSNALQPMQZLANCNFSM4JCCWBTQ .

PY3IG commented 5 years ago

Thanks! Spreadsheet already in operation!

mihtjel commented 5 years ago

Cool! If you publish any results from it, I would love to see them :-)

-- Rune / 5Q5R

On Sat, 19 Oct 2019 at 22:44, PY3IG notifications@github.com wrote:

Thanks! Spreadsheet already in operation!

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub https://github.com/mihtjel/nanovna-saver/issues/50?email_source=notifications&email_token=AGLTTOJCZUBJYPAXJC2HRXDQPNWRDA5CNFSM4JCCWBT2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEBX4KMQ#issuecomment-544195890, or unsubscribe https://github.com/notifications/unsubscribe-auth/AGLTTOIEPLPIE7GZKOQ33QTQPNWRDANCNFSM4JCCWBTQ .