Top > Technical-notes > VNWA > Import Resistor's VNWA data into EXCEL.

Import Resistor's VNWA S11data into EXCEL.

Measure and extract the S11 frequency characteristic data of the resistor as shown in the photo below.
Import the extracted data into EXCEL.
VNWA：Vector network analyzer (VNWA3E) DG8SAQ

A photo of measuring the S11 characteristics of a resistor using a Vector network analyzer (VNWA3E) DG8SAQ
Right-click on "S11 |Z|" and a window will appear.
Click on "Export Trace to s1p".
Image explaining the procedure to measure the S11 characteristics of a resistor using the Vector Network Analyzer (VNWA3E) DG8SAQ and export the s1p data
Image explaining how to write comments when measuring the S11 characteristics of a resistor with the Vector Network Analyzer (VNWA3E) DG8SAQ and exporting the s1p data
Image showing the location to save data when measuring the S11 characteristics of a resistor with the Vector Network Analyzer (VNWA3E) DG8SAQ and exporting the s1p data.
 Decide on a file name and save it.
Image showing the procedure for saving a file when measuring the S11 characteristics of a resistor with the Vector Network Analyzer (VNWA3E) DG8SAQ and exporting the S1p data.
First, start EXCEL and open the file you just saved by selecting File → Open.
At that time, select all files.
This image explains how to open resistor S11 characteristic s1p data saved on a Vector Network Analyzer (VNWA3E) DG8SAQ when importing it into Excel.
 When you open the file, a window like the one below will open, so follow the instructions in the image. 
This image shows how to import an S1P file from a Vector Network Analyzer (VNWA3E) DG8SAQ into Excel by specifying "Delimited" as the file format.
This image shows how to import the saved S1P file into Excel using the Vector network analyzer (VNWA3E) DG8SAQ, specifying "Tab" and "Space" as the data delimiter.
This image shows an S1P file saved using the Vector Network Analyzer (VNWA3E) DG8SAQ being imported into Excel with "General" specified as the column and data format.
Data image of resistor S11 characteristic s1p data saved in Vector network analyzer (VNWA3E) DG8SAQ immediately after importing it into Excel
The data above 100MHz is shifted one square to the left, so we will correct it.
Image explaining how to move one cell to the right for data above 100MHz immediately after importing the resistor S11 characteristic s1p data saved in Vector Network Analyzer (VNWA3E) DG8SAQ into Excel
Image of resistor S11 characteristic s1p data saved by Vector network analyzer (VNWA3E) DG8SAQ imported into Excel and prepared for creating frequency characteristic graph.
Convert Resistor's VNWA-s1p data to impedance.
Displays the converted Impedance data as a graph.

© SMPS Solution