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

Import Capacitor's VNWA S11data into EXCEL.

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

This is a photo of measuring the S11 characteristics of a 1000pF capacitor using a vector network analyzer (VNWA3E) DG8SAQ.
Right-click on "S11 C--" and a window will appear.
Click on "Export Trace to s1p".
This is an image explaining the steps to measure the S11 characteristics of a 1000pF capacitor using a Vector Network Analyzer (VNWA3E) DG8SAQ and export the S1P data.
This is an image explaining how to add comments when exporting S1P data using the Vector network analyzer (VNWA3E) DG8SAQ.
This is an image showing the location where the data is saved when exporting the S1P data using the Vector network analyzer (VNWA3E) DG8SAQ.
 Decide on a file name and save it.
This image shows the procedure for measuring the S11 characteristics of a 1000pF capacitor using a 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 shows how to open the S1P file saved after measuring the S11 characteristics of a 1000 pF capacitor using a Vector Network Analyzer (VNWA3E) DG8SAQ.
 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.
This is an image of the data immediately after measuring the S11 characteristics of a 1000pF capacitor using a vector network analyzer (VNWA3E) DG8SAQ and importing the saved (s1p) data into Excel.
The data above 100MHz is shifted one square to the left, so we will correct it.
This image shows the data immediately after the S11 characteristics of a 1000pF capacitor was measured using a Vector Network Analyzer (VNWA3E) DG8SAQ and the saved (s1p) data was imported. This image shows how to shift data above 100MHz by one cell to the right.
This image shows the data from measuring the S11 characteristics of a 1000pF capacitor using a Vector Network Analyzer (VNWA3E) DG8SAQ. You can use this data to create a frequency response graph.
Convert Capacitor's VNWA-s1p data to capacitance.
Displays the converted Capacitance data as a graph.
Click here to download Create-S11CFgraph-VNWAs1p.xlsx

© SMPS Solution