Search RFCafe.com                           
      More Than 17,000 Unique Pages
Please support me by ADVERTISING!
Serving a Pleasant Blend of Yesterday, Today, and Tomorrow™ Please Support My Advertisers!
   Formulas & Data
Electronics | RF
Mathematics
Mechanics | Physics
     AI-Generated
     Technical Data
Pioneers | Society
Companies | Parts
Principles | Assns


 About | Sitemap
Homepage Archive
        Resources
Articles, Forums Calculators, Radar
Magazines, Museum
Radio Service Data
Software, Videos
     Entertainment
Crosswords, Humor Cogitations, Podcast
Quotes, Quizzes
   Parts & Services
1000s of Listings
 Vintage Magazines
Electronics World
Popular Electronics
Radio & TV News
QST | Pop Science
Popular Mechanics
Radio-Craft
Radio-Electronics
Short Wave Craft
Electronics | OFA
Saturday Eve Post

Software: RF Cascade Workbook
RF Stencils Visio | RF Symbols Visio
RF Symbols Office | Cafe Press
Espresso Engineering Workbook

Aegis Power  |  Alliance Test
Centric RF  |  Empower RF
ISOTEC  |  Reactel  |  RFCT
San Fran Circuits

Cafe Press

Crane Aerospace Electronics Microwave Solutions

Innovative Power Products Cool Chip Thermal Dissipation - RF Cafe

Please Support RF Cafe by purchasing my  ridiculously low-priced products, all of which I created.

RF Cascade Workbook for Excel

RF & Electronics Symbols for Visio

RF & Electronics Symbols for Office

RF & Electronics Stencils for Visio

RF Workbench

T-Shirts, Mugs, Cups, Ball Caps, Mouse Pads

These Are Available for Free

Espresso Engineering Workbook™

Smith Chart™ for Excel

Tennode microwave devices - RF Cafe

Matching Network Designer for Excel

Mr. Manfred Kanther has graciously made his very fine Excel spreadsheet available for download by RF Cafe visitors. It is written in the Excel 2000 environment, so any version from 2000 up through Excel 2007 will support it. Click the screen image to the right to download the ZIP file.

For a final release version of Matching Network Designer, please visit Mr. Kanther's website.

If you did not know better, you would believe that this is actually a stand-alone application, and not a spreadsheet. All of the coding appears to be implemented in the VBA. Depending on the level of macro security you have set in Excel, you might have to click the Enable Macro button as the spreadsheet loads.

Per Manfred:

Click here to download Manfred Kanther's Tuning Network Excel Spreadsheet (Smith Chart interface)

Main Screen Overview

(click image to download the file)

Manfred Kanther's Tuning Network Excel Spreadsheet, with Smith Chart Interface - Component Tuning

Component Tuning Section Detail

Smith Chart is an acknowledged trademark

of the Analog Instruments Company

"All yellow shaded fields are allowed for input data. The impact of component changes in placement and value can be directly explored on the chart and therefore be trimmed for perfect matching conditions. R's, C's, L's and T's (transmission line) can be configured. The worksheet can be duplicated so that you can work on different matching networks in parallel."

Mr. Kanther's e-mail is shown in the spreadsheet. Please be sure to thank him for making this available to you!

See the Example Below

From Manfred:

Let me demonstrate with the attached workbook, dedicated to TI/Chipcon's CC1100 output matching network, how capable the tool is ( or Excel ). Three worksheets are networked together to form the proposed matching network for the CC1100 at the frequency of 915MHz.

This is the proposed network ( Balun ) out of the CC1100 datasheet:

TI/Chipcon CC1100

This is the BOM:

TI/Chipcon CC1100 BOM

This is the output impedance of the N-Port and and the P-Port ( values taken at 915Mhz):

TI/Chipcon CC1100 Impedance

To analyse this network with the tool, three sheets are necessary. The first sheet represents half a Balun Bridge for the N-Output, named "Matching RF-Nout" The second sheet represents half a Balun Bridge for the P-Output, named "Matching RF-Pout" The third sheet "Antenna matching" combines the the Rp, Cp of the overall "Matching RF-Nout" circuit and Rp, LP of the overall "Matching RF-Pout" circuit plus the few components on the way to the antenna.

Some important notes need to be made:

1. The output impedance of the CC1100 ports is given in the datasheet by looking towards the antenna. In the sheets we are looking to the CC1100 outputs hence the conjugate complex of the given impedance must be used.

2. The capacitor of C121 of 1pF needs to be doubled in value if you connect them to ground on both Balun branches instead between of the branches.

3. The Rp, Cp and the Rp, Lp values in the third sheet "Antenna matching" are links backward to the respective sheets of "Matching RF-Nout" and "Matching RF-Pout". Don't overwrite it.

4. The frequency value of the sheets "Matching RF-Nout" and "Matching RF-Pout" is linked forward to the "Antenna matching" frequency input field.

All the links make it possible to change the components values and the overall impact can be observed in the "Antenna matching" sheet. Also the frequency variation of the whole circuit can be shown if you click on the "fo-Variation Yes/No" button on the "Antenna matching" sheet. ( It will take about 10+ seconds to calculate and display the curve ) But don't do that on the other both sheets, it will destroy the links of the frequency input and you need to establish them again ( that is no problem but you need to be aware of it ).

Screen Shots

 - RF Cafe

Match for N Output

 

 - RF Cafe

Match for P Output

 - RF Cafe

Match for Antenna

(looking Back at N & P matches)

Tennode microwave devices - RF Cafe
everythingRF RF & Microwave Parts Database (h1)

Anritsu Test Equipment - RF Cafe

Werbel Microwave (power dividers, couplers)