Transcript Using the Polar Si8000 Excel Interface

Using the Polar Si8000
Excel Interface
Graphing impedance against Er with
the Polar Si8000 Controlled
Impedance Field Solver
polarinstruments.com
© Polar Instruments 2005
Using the Si8000 Excel Interface
This tutorial explains how to change the axes of charts in
Si8000 Excel workbooks so you can graph any variable
you choose – Z0 against H, Z0 against Er, etc…
2
How to use this tutorial
Please run through all the slides in this presentation to give
yourself an overview.
Then launch the Si8000 and click the Surface Microstrip
graphic and work through the example yourself.
If you have not already done so, download and follow the
introductory tutorial Getting started with the Polar Si8000
– Using the Polar Si8000 Excel Interface.
This tutorial uses Excel’s Chart Wizard – if you are not
familiar with some of the features of Excel you may find it
worth taking a brief course to get the best from your Si8000.
3
Using Excel with the
Si8000 allows you to
build customised
worksheets based on
direct access to the
Si8000’s boundary
element field solving
engine
Graphing Z0 against Er
Each chart defaults to
graphing Z0, impedance
against H1, the substrate
height. You’ll use the
Excel Chart Wizard to
change the chart source
data to show results for
other columns.
4
Choosing the model
Begin by choosing the
Surface Microstrip
controlled impedance
structure from the
Si8000’s structure page
Start Si8000 Excel
and click
Surface Microstrip 1B
5
Preparing the table
Let’s see how
Er influences Z0
6
The table containing
the structure function
and predefined
parameters for the
Surface Microstrip is
displayed along with
its associated chart
Changing table values
Drag the first
value of H1
down to make
H1 constant
7
You want to graph Z0
against Er so begin by
assigning constant
values to all the other
parameters. You’ll
make H1 a constant
value and vary Er
Assigning a range of values to Er
Next – use the Fill
Handle to complete the
series of values for Er
Fill the first two cells
in the Er column with
the values 4.6 and 4.55
respectively and drag
to complete the series
8
Assigning a range of values to Er
Now the table has
the correct range of
values for Er
9
Changing the chart source data
Now you can change
the chart source data to
graph Z0 against Er.
Right click the data
Choose Source Data…
point
10
Changing the X axis
Now you can change
the chart source data to
graph Z0 against Er.
Change the Category
(X) axis labels
Choose the Series tab
from the H1 column
to the Er column.
11
Changing the X axis
Click the Collapse
…click
…note
Dialog
the
again
button
new
torange
choose
to –
the
click
display
new
again
range
thetocurrent
(C5:C31)
confirm
range (B5:B31)…
12
You can use Excel’s
Collapse Dialog
buttons to change the
chart source data –
let’s start by changing
the X axis labels.
Changing the Y axis
Now change the Y
axis (Values) range.
If necessary, repeat for the
Don’t forget to relabel
Values range – in this
the chart X axis to E
example that’s H5:H31r
13
Finalising the chart
These are the two
ranges you will chart.
Now you can fill this
…and press Calculate
column with the formula
14
Viewing the results
The finished result…
…Z0 against Er
TryField
correcting
solving
this
is for
An error has crept into
complete
yourself–tobut
seewhat’s
the
the table
expectedthis?!!
smooth curve
15
Thank you for using this presentation
This presentation is just one of a series of hands-on
tutorials designed to help you get the most out of
your Si8000 Field solver
Please view our other step-by-step presentations
available on the Polar Instruments web site
www.polarinstruments.com
16
For more information:
Contact Polar now:
Phone:
USA / Canada / Mexico
Ken Taylor
Asia / Pacific
Calvin Sie
Japan
Terumitsu Tsuji
polarinstruments.com
© Polar Instruments 2005
( 503) 356 5270
+65 6873 7470
+81 45 339 0155
UK / Europe
Neil Chamberlain
+44 23 9226 9113
Germany / Austria / Switzerland
Hermann Reischer
+43 7666 20041-0
www.polarinstruments.com