How to draw curve with S-Parameter_Utilites_101.xls?

[ruwan2]

Hi,

I am new to spreadsheet. I want to use S-Parameter_Utilites_101.xls. I am not clear about

"There are two pull down boxes, one says whether you are in dB or magnitude or real/imaginary format, and one tells the spreadsheet what the frequency units are..."

Is it in the "Enter data" tab? Or in the new spreadsheet file (after loading the S-parameter)? I cannot find it yet.

Could you explain it to me? Thanks,


To use our spreadsheet, you first need to read the S-parameter data into Excel in a separate file (choose "all files (*.*)" as the file type, using the "delimited" option, with "spaces" as the delimiter). Then copy nine columns of data from the Hittite file into our spreadsheet that you just downloaded, on the "Enter_data" sheet, starting in the first frequency box. That was easy! Save it with a file name that indicates the data that you entered. You'll need to do three more things before you even look at the plots. There are two pull down boxes, one says whether you are in dB or magnitude or real/imaginary format, and one tells the spreadsheet what the frequency units are, make sure you have these correct. You also need to specify the system characteristic impedance (almost always 50 ohms, but once in a while it will be 75 ohms). You should copy some of the header info onto the "Enter_data" sheet on the blank rows near the top of the sheet so you will remember what data you were looking at, then save it under a new filename. Now all you need to do is go to the plots, and adjust the axes and/or make other formatting changes to pretty them up, and add as much detail to the titles as you want. Voila!


Here is what I copy to the new spreadsheet (Inside red box is download data from Hittite website):


- - - Updated - - -

Hi,

I have found the settings for frequency and dB for previous post. Now I have new questions about the column sequence after I see the S-parameter curve is not the expected.



I see the following description on column sequence check:

We downloaded the S-parameters for this passive reciprocal device from the Hittite web site, which is very friendly, and provides S-parameters in "S2P" format. This is a nine column text file with some specific formatting in the header which you can ignore for now. The nine columns that you need are:


Frequency
Magnitude S11
Angle S11
Magnitude S21
Angle S21
Magnitude S12
Angle S12
Magnitude S22
Angle S22

but I do not find the sequence in the header file:


Where is the sequence description?

Thanks,

 

[volker@muehlhaus]

but I do not find the sequence in the header file:
Where is the sequence description?

The magic header line is this (spaces required):
# GHZ S MA R 50
This gives information about the data that follows:
Frequency unit is GHz
Data is S-parameters in magnitude/angle format, referenced to 50 Ohm

In your example, every line starts with freqency, followed by all S-parameters in one line.
In your screenshot, something is wrong because the spaces that separate the data/numbers are missing.