CINXE.COM
Microwaves101 | download-area
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head><meta charset="utf-8" /><link rel="shortcut icon" href="https://d2xunoxnk3vwmv.cloudfront.net/images/favicon.ico" type="image/x-icon" /><title> Microwaves101 | download-area </title><meta name="viewport" content="width=device-width, initial-scale=1.0" /><link href="js/bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css" /><link href="js/font-awesome/css/font-awesome.css" rel="stylesheet" type="text/css" /><link href="css/style.css?version=2" rel="stylesheet" type="text/css" /><link href="css/camera.css" rel="stylesheet" type="text/css" /><link href="https://fonts.googleapis.com/css?family=Ubuntu:400,500,700" rel="stylesheet" /> <!-- Google tag (gtag.js) --> <script async src="https://www.googletagmanager.com/gtag/js?id=G-1BBRLYKF1N"></script> <script> window.dataLayer = window.dataLayer || []; function gtag() { dataLayer.push(arguments); } gtag('js', new Date()); gtag('config', 'G-1BBRLYKF1N'); </script> <script async='async' src='https://www.googletagservices.com/tag/js/gpt.js'></script> <script> var googletag = googletag || {}; googletag.cmd = googletag.cmd || []; </script> <script> googletag.cmd.push(function () { googletag.defineSlot('/4906012/728x90_Leaderboard', [728, 90], 'div-gpt-ad-1513662084890-0').addService(googletag.pubads()); googletag.defineSlot('/4906012/Skyscraper', [160, 600], 'div-gpt-ad-1513662144177-0').addService(googletag.pubads()); googletag.defineSlot('/4906012/Baseboard', [728, 90], 'div-gpt-ad-1513662185452-0').addService(googletag.pubads()); googletag.defineSlot('/4906012/mobile-ad', [320, 60], 'div-gpt-ad-1513662333645-0').addService(googletag.pubads()); googletag.pubads().enableSingleRequest(); googletag.enableServices(); }); </script> <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js" type="text/javascript"></script> <script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.11.2/jquery-ui.min.js"></script> <meta name="description" content="download-area" /></head> <body> <form method="post" action="./download-area" id="form1"> <div class="aspNetHidden"> <input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwULLTIxMDI5MDAyMjJkZFGHIQVn0AJYHQDMpRl8eddvzEfFxwJMExOT6RBorwEx" /> </div> <div class="aspNetHidden"> <input type="hidden" name="__VIEWSTATEGENERATOR" id="__VIEWSTATEGENERATOR" value="1B59457A" /> <input type="hidden" name="__EVENTVALIDATION" id="__EVENTVALIDATION" value="/wEdAAMCsgOxjG6NynSqFPJzEe+4eFRJ+jn0FS3uPSN1G0ic13d+AWLm1JyydA4y2Uf7MiqoaRFpivmfC7a8KE3DWYpFuOSe1C+PpcUaA4h2FgHWcg==" /> </div> <div class="main"> <div id="container" class="container main-container no-padding"> <div class="top-header"> <div class="row no-margin"> <div class="col-lg-6 col-md-4 col-sm-4 col-xs-12"> <ul class="social"> <li><a href="https://www.facebook.com/UnknownEditor/" target="_blank" title="Facebook"> <i class="fa fa-facebook-square"></i></a></li> <li><a href="/contact-us" title="E-Mail"><i class="fa fa-envelope"></i></a></li> <li><a href="javascript:window.print();" title="Print"><i class="fa fa-print"></i></a></li> </ul> </div> <div class="col-lg-6 col-md-8 col-sm-8 col-xs-12 no-padding-xs"> <div class="right-side"> <ul class="right-list"> <li> <a id="HyperLink4" href="https://www.microwaves101.com/encyclopedias/mw101stuff-the-official-microwaves101-newsletter" target="_blank"><i class="fa fa-newspaper-o icon-margin"></i>Sign up for our Newsletter</a></li> <li> <a href="https://www.microwaves101.com/advertise-with-us" target="_blank">Advertise with us</a></li> </ul> </div> </div> </div> </div> <header id="header"> <div class="row no-margin flex-col"> <div class="col-lg-4 col-md-4 col-sm-4"> <div class="logo"> <a id="hlnkLogo" href="./"><img id="Image1" src="https://d2xunoxnk3vwmv.cloudfront.net/images/mw101-main-site-logo-large.png" /></a> </div> </div> <div class="col-lg-8 col-md-8 col-sm-8 no-padding-xs"> <div class="last"> <div class="searchbar"> <input name="ctl00$q" type="text" id="q" class="form-control" placeholder="Search for..." onkeydown="return funEnterPress(event,'btnCustomSearch')" /> <input type="submit" name="ctl00$btnCustomSearch" value="Search" id="btnCustomSearch" class="btn" /> <div class="clearfix"> </div> </div> <div class="header-right"> </div> </div> </div> </div> </header> <nav class="navbar navbar-default navbar-static-top"> <div class=""> <!-- Brand and toggle get grouped for better mobile display --> <div class="navbar-header"> <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbarCollapse" aria-expanded="false"> <span class="sr-only">Toggle navigation</span> <span class="icon-bar"></span><span class="icon-bar"></span><span class="icon-bar"></span> </button> <span class="navbar-brand visible-xs" href="javascript:void(0);">Menu</span> </div> <div class="collapse navbar-collapse" id="navbarCollapse"> <ul class="nav navbar-nav"> <li class="" page="home"> <a href="./">Home</a> </li> <li page="encyclopedias"> <a href="encyclopedias">Encyclopedia</a></li> <li page="calculators"> <a id="HyperLink2" href="calculators">Calculators</a></li> <li page="download-area"> <a id="HyperLink77" href="download-area">Downloads</a></li> <li page="acronyms"> <a id="HyperLink88" href="acronyms">Acronyms</a></li> <li page="discussion-board"> <a id="HyperLink9" href="http://forum.microwaves101.com/">Discussion Board</a></li> <li page="cool-links"> <a id="HyperLink16" href="cool-links">Links</a></li> <li page="feed-from-everythingrf"> <a id="HyperLink19" href="feeds">News</a></li> <li page="contact"> <a id="hlnkNavContactUs" href="contact-us">Contact</a> </li> </ul> </div> </div> </nav> <div class="searchbar hidden"> <i class="fa fa-search search-icon"></i> <input type="text" id="txtSearchByGooglem" onkeydown="return funEnterPress(event,'SearchByGoogle')" class="form-control" placeholder="Search for..."> </div> <div class="clearfix"> </div> <div class="wrapper wrapper-encyclo"> <div class="row"> <div class="col-lg-10 col-md-12 col-sm-12"> <div class="leaderboard-ads"> <div class="leaderboard-inner"> <!-- /4906012/728x90_Leaderboard --> <div id='div-gpt-ad-1513662084890-0'> <script> googletag.cmd.push(function () { googletag.display('div-gpt-ad-1513662084890-0'); }); </script> </div> </div> </div> <div class='page-header'><h1><i class='fa fa-arrow-circle-o-right icon-margin'></i>Download Area</h1></div> <div class="page-content"> <p>Welcome to our Microwaves101's Download Area! If you have something useful that we can add, send it along to us. We'll trade you a <a href="/encyclopedias/pocket-knife-keychain">free gift</a>!</p> <p>Separately, we have a page on books that you are free to download, <a href="https://www.microwaves101.com/encyclopedias/books-as-free-downloads">check it out.</a></p> <p>Our download area is divided into five categories:</p> <blockquote> <p><a href="#EDA">Electronic design analysis (EDA) projects</a></p> <p><a href="#executable">Executable files</a></p> <p><a href="#calculators">Spreadsheet and text downloads</a></p> <p><a href="#graphics">Graphics downloads</a></p> <p><a href="#posters">Cool Microwaves101 poster downloads!</a></p> <p><a href="#info">Information downloads</a></p> </blockquote> <p><strong>New for July 2024. </strong> Here's your chance to become a published author on Microwaves101! These slides were presented at the International Microwave Symposium on June 20, 2024. </p> <p style="margin-left:40px"><a href="/uploads/WriteforMW101.pdf"><em>Download Publishing on Microwaves101 slides</em></a></p> <p>On our page on <a href="https://www.microwaves101.com/encyclopedias/compact-wilkinsons#webb">Compact Wilkinsons</a> you will see imformation on the "Webb Splitter" It was in an old trade journal that no longer exists. We are posting a copy of it for posterity.</p> <p style="margin-left:40px"><em><a href="/uploads/Webb-Compact-Wilkinson-1981.pdf">Here's the original article on the Webb splitter...</a></em></p> <p><a id="combiner" name="combiner"></a>This Excel file is useful for looking at phase and amplitude erriors in a solid-state power amplifier (SSPA)</p> <p style="margin-left:40px"><a href="http://d2xunoxnk3vwmv.cloudfront.net/uploads/Combiner-efficiency-101-rev3.xlsx"><em>Diowload Combiner-efficiency-101-rev3.xlsx</em></a></p> <h2><a id="EDA" name="EDA"></a>Electronic design analysis (EDA) projects</h2> <p>Under this category offer example files in environments such as Keysight ADS, AWR Microwave Office, HFSS, etc.</p> <p><strong>Important: to download these files, you need to right-click the link and "save link as"...</strong></p> <p><strong><a id="bagley" name="bagley"></a>New for November 2024:</strong> here is a MWO file that provides Bagley power dividers in 3, 5 and 7 way configurations. The Bagley power divider is <a href="https://www.microwaves101.com/encyclopedias/bagley-power-divider">explained on this page.</a></p> <p style="margin-left:40px"><a href="http://d2xunoxnk3vwmv.cloudfront.net/uploads/Bagley-Power-Divider-M101-Rev1.emp">Download Bagley Power Divider M101 Rev1.emp</a></p> <p><strong><a id="monopulse" name="monopulse"></a>New for November 2024:</strong> here is a MWO file that contains a monopulse network based on branchline couplers. It is <a href="https://www.microwaves101.com/encyclopedias/monopulse-comparator-using-branchline-couplers">explained on this page.</a></p> <p style="margin-left:40px"><a href="http://d2xunoxnk3vwmv.cloudfront.net/uploads/Monopulse-M101-Rev1.emp">Download Branchline Monopulse M101 Rev1.emp</a></p> <p><strong><a id="hexaplexer" name="hexaplexer"></a>New for September 2024: </strong>here a MWO maximally-flat hexaplexer design. It is explained on <a href="https://www.microwaves101.com/encyclopedias/maximally-flat-hexaplexer">this page. </a> </p> <p style="margin-left:40px"><a href="https://www.microwaves101.com/encyclopedias/maximally-flat-hexaplexer">Download Maximally Flat Hexaplexer.emp</a></p> <p><strong><a id="scardelletti" name="scardelletti"></a>New for May 2024: </strong>Here's a Microwave Office file for the Scardelletti splitter, a compact form of Wilkinson power divider, described on.</p> <p style="margin-left:40px"><a href="http://d2xunoxnk3vwmv.cloudfront.net/uploads/Scardelleti-splitter.emp">Download Scardelletti splitter.emp</a></p> <p><strong><a id="joystick" name="joystick"></a>New for April 2024: </strong>here's a project we call the "joystick gamma amplifier". It can be used to examine out-of-balance conditions in SSPAs, and it is explained on <a href="https://www.microwaves101.com/encyclopedias/joystick-gamma-amplifier">this page</a> (with a link to the first Microwaves101 YouTube video!)</p> <p style="margin-left:40px"><a href="http://d2xunoxnk3vwmv.cloudfront.net/uploads/Joystick-gamma-amplifier.emp">Download Joystick gamma amplifier.emp</a></p> <p><strong>New for December 2023</strong>: here's a project that will allow you to design simplified unequal-split Wilkinson power dividers.</p> <p style="margin-left:40px">Here's the <a href="https://www.microwaves101.com/encyclopedias/unequal-split-wilkinson-power-divider-simplified">page that describes our simplified unequal-split Wilkinson</a></p> <p style="margin-left:40px"><a href="http://d2xunoxnk3vwmv.cloudfront.net/uploads/Unequal-Wilk-2023-Rev1.emp">Download Unequal Wilk 2023 Rev1.emp</a></p> <p><strong><a id="phaseshifter" name="phaseshifter"></a>New for September 2023- February 2024: i</strong>f you are following along with our four-bit phase shifter design which started in September 2023, here are the design files we generated the content from. </p> <p style="margin-left:40px">Lesson 1:<a href="https://www.microwaves101.com/encyclopedias/multi-bit-phase-shifter-design-using-microwave-office"> Setting up a multi-bit phase shifter design</a></p> <p style="margin-left:80px"><a href="http://d2xunoxnk3vwmv.cloudfront.net/uploads/M101-Generic-phase-shifter-simulation-Rev-.emp">Download Generic-phase-shifter-simulation-Rev-.emp</a> (right-click and "save as" if you are using Chrome)</p> <p style="margin-left:40px">Lesson 2: <a href="https://www.microwaves101.com/encyclopedias/multi-bit-phase-shifter-design-how-not-to-calculate-rms-phase-error">How NOT to calculate RMS phase error</a></p> <p style="margin-left:80px"><a href="http://d2xunoxnk3vwmv.cloudfront.net/uploads/M101-Generic-phase-shifter-simulation-Rev1.emp">Download Generic-phase-shifter-simulation-Rev1.emp</a></p> <p style="margin-left:40px">Lesson 3: <a href="https://www.microwaves101.com/encyclopedias/mmic-phase-shifter-22-degree-bit-design">Designing a MMIC-compatible 22-degree bit</a></p> <p style="margin-left:80px"><a href="http://d2xunoxnk3vwmv.cloudfront.net/uploads/M101-Generic-phase-shifter-simulation-Rev2.emp">Download Generic-phase-shifter-simulation-Rev2.emp</a></p> <p style="margin-left:40px">Lesson 4: <a href="https://www.microwaves101.com/encyclopedias/mmic-phase-shifter-45-degree-bit-design">Designing a MMIC-compatible 45-degree bit</a></p> <p style="margin-left:80px"><a href="http://d2xunoxnk3vwmv.cloudfront.net/uploads/M101-Generic-phase-shifter-simulation-Rev3.emp">Download Generic-phase-shifter-simulation-Rev3.emp</a></p> <p style="margin-left:40px">Lesson 5: <a href="http://www.microwaves101.com/encyclopedias/mmic-phase-shifter-90-degree-bit-design">Designing a MMIC-compatible 90-degree bit</a></p> <p style="margin-left:80px"><a href="http://d2xunoxnk3vwmv.cloudfront.net/uploads/M101-Generic-phase-shifter-simulation-Rev4.emp">Download Generic-phase-shifter-simulation-Rev4.emp</a></p> <p style="margin-left:40px">Lessons 6, 7 and 8: <a href="https://www.microwaves101.com/encyclopedias/mmic-shifter-180-degree-bit-spdt-switch">Designing a MMIC single-pole double-throw switch</a>, <a href="https://www.microwaves101.com/encyclopedias/mmic-shifter-180-degree-bit">MMIC-compatible 180-degree bit,</a> and <a href="https://www.microwaves101.com/encyclopedias/mmic-four-bit-phase-shifter-preliminary-design">full three-bit MMIC phase shifter preliminary design</a></p> <p style="margin-left:80px"><a href="http://d2xunoxnk3vwmv.cloudfront.net/uploads/M101-Generic-phase-shifter-simulation-Rev5.emp">Download Generic-phase-shifter-simulation-Rev5.emp</a></p> <p><a id="combiner_loss_prj" name="combiner_loss_prj"></a>Here's a Microwave Office project that calculates full combiner loss, <a href="https://www.microwaves101.com/encyclopedias/power-combiner-loss-calculation">explained on this page</a> <strong>(new for August 2021)</strong>. You can load your own 3dB hybrid coupler four-port S-parameters into it and determine overall loss and other parameters.</p> <p style="margin-left:40px"><a href="/uploads/Coupler-test.emp">Download the Microwave Office combiner loss project</a></p> <p><a name="MWO_coupler"></a>We offer a Microwave Office (MWO) file on symmetric three-section coupler designs, which was used to generate the <a href="encyclopedias/multi-section-symmetric-couplers">content on this page</a>.</p> <p style="margin-left:40px"><a href="http://d2xunoxnk3vwmv.cloudfront.net/uploads/Coupler-three-section-Rev1.emp">Download the three section symmetric coupler design file for Microwave Office</a>.</p> <h2><a id="executable" name="executable"></a>Executable, Python, C++ files</h2> <p><a id="matching" name="matching"></a><strong>New for March 2023.</strong> We now offer a lumped-element matching calculator, thanks to Antonije and Slobodan at University of Belgrade. You can find it in our <a href="https://www.microwaves101.com/download-area#matching">download area</a> (look for "Matching with lumped elements.zip) For a given complex impedance and center frequency, it provides two different L-section transformations to your choice of (real) characteristic impedance. The networks could be referred to as high-pass and low-pass networks. Beware, you need to enter the frequency in Hz, not GHz.</p> <p>There calculator is embedded in a zip file, which contains:</p> <p style="margin-left:40px">1. Matching with lumped elements.pdf - Relatively short text with some theory, few examples, and programs description,<br /> 2. matching_network.m - Program written for Octave/Matlab,<br /> 3. matching_network.exe - Executable (stand-alone) program,<br /> 4. matching_network.cpp - Source C++ code for the "matching_network.exe",<br /> 5. matching_network.py - Program written for Python.</p> <p><a href="/uploads/Matching-with-lumped-elements.zip">Download matching with lumped elements (Zip file)</a></p> <h2><a name="calculators"></a>Spreadsheet and text downloads</h2> <p><strong><a id="spectrum" name="spectrum"></a>New for April 2023:</strong> here is a pulsed RF spectrum spreadsheet, that goes along with this <a href="https://www.microwaves101.com/encyclopedias/pulsed-rf-spectrum-spreadsheet">Microwaves101 page</a>. It is pretty basic, but allows you to plot RF spectrum based on center frequency, CW power, pulse with and duty cycle. Let us know what improvements you'd like to see!</p> <blockquote> <p><a href="/uploads/M101-Pulsed-RF-spectrum-Rev1.xlsx">Download the pulsed RF spectrum spreadsheet</a></p> </blockquote> <p><a id="chorney" name="chorney"></a> Here's a contribution from Dr. Paul Chorney, an expert in all things waveguide. He's provided spreadsheets that do the calculations for you, and also document files (in PDF) that describe the derivations of some of the formulas he used. Thanks, Paul!</p> <blockquote> <p><a href="/uploads/GroupDelayPaulChorney.xlsx">Download a group delay spreadsheet</a> </p> <p style="margin-left:40px">And the<a href="/uploads/GroupDelayinWaveguidesPaulChorney.pdf"> paper that describes the derivation</a> of the group velocity, group delay, and parabolic phase shift formulas in the group delay spreadsheet</p> <p><a href="/uploads/ThermalResistancePaulChorney.xlsx">Download a spreadsheet of thermal resistance calculations</a></p> <p style="margin-left:40px">And the<a href="/uploads/ThermalResistancePaulChorney.pdf"> paper that describes the derivation </a>of the thermal resistance formulas</p> <p><a href="/uploads/WaveguideCalculationsPaulChorney.xlsx">Download a spreadsheet for theoretical attenuation calculations</a></p> </blockquote> <p><a id="chris_skin_depth" name="chris_skin_depth"></a>Here is a skin-depth spreadsheet, contributed by Chris (thanks!!)</p> <p><img alt="" src="/uploads/ChrisGraph.png" style="height:364px; width:500px" /></p> <p style="margin-left:40px"><a href="/uploads/Skin-Depth.xlsx">Download Chris' skin-depth spreadsheet</a></p> <p style="margin-left:40px">Here are three waveguide-related spreadsheets from XXX</p> <p>The spreadsheets below supplement our <a href="https://www.microwaves101.com/calculators">calculator page</a>, and in general offer data-crunching that is too complicated to put onto an HTML page for you.</p> <p><strong>July 2021:</strong>This calculator comes from Ticer - thanks, guys!</p> <p style="margin-left:40px"><a href="/uploads/TCR-Resistor-Calculator-Rev-09-with-protection-METRIC.xls" id="TCRResistorCalc" name="TCRResistorCalc">Download the TCR Resistor Calculator</a></p> <p><a id="spar mixer" name="spar mixer"></a>S-parameter Mixer spreadsheet. <strong>New for January 2021!</strong> This tool allows you to shift the frequency of an IF amplifier's S-parameters so you can cascade it with your RF chain in a receiver design. It is<a href="https://www.microwaves101.com/encyclopedias/excel-s-parameter-mixer"> explained here</a>.</p> <p style="margin-left:40px"><a href="/uploads/S-Parameter-mixer-101-Rev2.xlsx" id="SparMixer" name="SparMixer">Download the S-parameter mixer spreadsheet</a></p> <p>H-tree feed network spreadsheet</p> <p> <a href="/uploads/M101-H-tree-feed-network-Rev-1.xlsx">Download the H-tree feed network spreadsheet</a></p> <p>Charge storage capacitor dissipation is <a href="https://www.microwaves101.com/encyclopedias/charge-storage-capacitor-dissipation">described on this page</a>. And here is the accompanying spreadsheet:</p> <p style="margin-left:40px"> <a href="/uploads/Charge-Storage-M101-Rev-1A.xlsx">Download the capacitor dissipation spreadsheet</a></p> <p>Here's the TRL calculator we promised you over on our <a href="/encyclopedias/trl-calibration">TRL calibration page</a>. </p> <blockquote> <p><a id="TRLxlsx" name="TRLxlsx"></a> <a href="/uploads/MW101-TRLCalc-rev1.xlsx">Download the TRL Calculator spreadsheet</a></p> </blockquote> <p>Here are two presentations contributed by Wayne Struble on Normalized Determinate Function, the Cadillac of stability analyses. For more information, we offer a <a href="/encyclopedias/normalized-determinate-function-ndf">page on NDF here</a>. There are two PDF files, make sure you grab them both.</p> <blockquote> <p><a name="StabilityAnalysis"></a><a href="/uploads/Stability-Analysis-Presentation.pdf">Download the Stability Analysis PDF</a></p> <p><a name="StabilityAnalysisAppendices"></a><a href="/uploads/StabilityAnalysisAppendices.pdf">Download the Stability Analysis appendices</a></p> </blockquote> <p><a name="antennarange"></a>Here's a spreadsheet from our friends over at Texas Instruments that will help you estimate antenna range using the Friis-Equation and 2-Ray Ground Reflection Model. There's even a graphic included!</p> <blockquote> <p><a name="antennarange"> </a><a href="http://www.ti.com/tool/rf-range-estimator">Download the Antenna range calculator spreadsheet</a></p> </blockquote> <p><!--<p><strong>New for February 2017! </strong> This .exe file calculates resonant frequencies and quality factors of cavities with circular cross sections from our friend Ronny in Germany (thanks, Ronny!). It is actually a MatLab GUI, so you'll need either a Version of Matlab or the Matlab Runtime to be installed. In the attached file, there is also an installer which loads the runtime from the internet and installs it.</p> <p>Download Cavity Calculator CCC.zip</p>--></p> <p><a name="transient"></a>Here is an Excel file that analyzes transient flow in one dimension. It's a big file, as it is performing numerical integration in two dimensions (distance and time). It is explained on our page on<a href="/encyclopedias/fourier-s-law"> Fourier's Law.</a></p> <blockquote> <p><a href="/uploads/Transient-heat-analysis-M101-Rev-.xlsx">Download Transient_heat_analysis_M101_Rev-.xlsx</a></p> </blockquote> <p><a name="snp"></a>Long ago a company called eeSOF came up with a standardized way to express <a href="/encyclopedias/s-parameters">S-parameters</a> in a text file which is often referred to as a Touchstone® file. Keysight is now the copyright holder of the word Touchstone, when it is used in this context. They inherited it from Agilent, who inherited it from Hewlett Packard, who bought eeSOF way back in the 1990s. If you call the data an SNP file you don't have to worry about the copyright, right? Here is <a href="/encyclopedias/snp-format">Microwaves101 page on SNP format.</a></p> <p>SNP format predates Microsoft Excel. SNP remains the industry standard, even though the IEEE never created a specification for it. There is a standard document which was published by Tech America which is now part of <a href="https://www.comptia.org/">CompTIA.</a> They don't offer it on their web site, but <a href="https://ibis.org/">IBIS Open Forum does</a>. According to the document it can be freely distributed, so long as the entire specification including copyright notice remain intact and unchanged. So we offer it below:</p> <blockquote> <p><a href="/uploads/touchstone-ver2-0.pdf">Download Touchstone® File Format Specification Version 2.0 Ratified by the IBIS Open Forum April 24, 2009</a></p> </blockquote> <p>SNP refers to S-parameters for N-port networks.</p> <p><a name="MSpatch"></a>Here's a microstrip patch antenna calculator from Jonny:</p> <blockquote> <p>After downloading numerous MSExcel Spreadsheet calculators from MW101, I thought I might contribute one. It is an Excel Calculator for a Microstrip Rectangular Patch Antenna. I got the equations from an article by Professor Ben Horwath at Santa Clara U (titled Microstrip Patch Antenna Design Principles, just google it together with the author's name... UE). However, I added a little bonus. It also includes the ability to calculate the parameters over temperature if the user includes the temperature coefficients of expansion for the board material.</p> </blockquote> <blockquote> <p><a href="/uploads/MSPatchAntennaDesign-1-.xlsx">Download microstrip patch antenna calculator</a></p> </blockquote> <p><a name="adams">We have information from Andy on additional degrees of freedom with </a><a href="encyclopedias/adams-resistive-splitter">Adams' resistive splitters</a>. Here are two spreadsheets on extra degrees of freedom for Adams' resistive splitter</p> <blockquote> <p><a href="/uploads/Adams-splitter-DOF.zip">Download Andy's analyses on the Adams' resistive splitter</a> </p> </blockquote> <p>A lot of people ask us "why do you create spreadsheets for calculating stuff like group delay, when all these calculations and more are built into Keysight's ADS or AWR's Microwave Office software?" There are two reasons, Silly Rabbit: first, not everyone has spent $50K on software, but everyone has Excel. And second, you have a lot more options for presenting data using Excel. How many times have you sat through a design review where all of the plots were cut and pasted from EDA software tool simulations, and you can't identify what you're looking at or what any of the values are?</p> <p>We have two new downloads, one for calculating capacitance and one for calculating complex impedance from S-parameters. The capacitance calculator does the very simple job of calculating parallel plate capacitance, but it will save you the trouble of unit conversion and looking up the Dk of stuff like silicon nitride. While we were at it we included the capacitive reactance calculation at the frequency of your choice.</p> <blockquote> <p><a href="/uploads/Capacitor-calculator-Rev1.xls ">Download the capacitance calculator</a></p> </blockquote> <p>Chris provided the calculator for converting magnitude and phase to impedances, which is a fundamental problem that belongs on any final exam in a microwave class (tell your boos that and ask him to derive it some time for fun).</p> <p>The impedance calculator download has caused a lot of trouble, which may or may not be related to the age of this web site (hopefully we will globally fix this problem and more during 2013...) The problem is that in most browsers, it is not possible to download a .xlsx file (the 2007 version or later of an Excel file) from a Cold Fusion page that was created in Dreamweaver 11.5 (in case you want to assign blame). The file that Chris sent us was the first Excel file that we have dealt with that could not be converted back to .xls due to some tricks he employed. Many people have tried unsuccessfully to download it, and a small number have written to us to complain and we have sent them the file by email. Now we offer the ultimate patch: we zipped it. Download it and and unzip. Sorry for the inconvenience!</p> <blockquote> <p><a href="/uploads/converting-complex-reflection-coefficient-to-real-and-imginary-impedance-1-.zip">Download the impedance calculator in a Zip file</a></p> </blockquote> <blockquote> <p>Here's a spreadsheet that extract Dk and Df from transmission line measurements. The technique is <a href="/encyclopedias/dk-and-df-extraction-spreadsheet"> explained on this page</a>. The spreadsheet contains some data that was provided to us, you'll have to copy over it, and perhaps do some formatting...</p> </blockquote> <blockquote> <p><a href="/uploads/Dk-and-Df-extraction-101-Rev1.xls">Download the Dk and Df extraction spreadsheet</a></p> </blockquote> <p>The Professor has donated his image rejection spreadsheet. Thanks! This file will help you understand the relationships between phase and amplitude imbalances, and overall image rejection, which is also explained on our <a href="/encyclopedias/image-rejection-mixers"> Image Rejection page</a>.</p> <blockquote> <p><a href="/uploads/ImageRejectionCalculator-Rev1.xls">Download the Professor's image rejection spreadsheet</a></p> </blockquote> <p>Here's a spreadsheet that calculates characteristic impedance of a transmission line based on measure reflection coefficient. It's also explained <a href="/encyclopedias/dk-and-df-extraction-spreadsheet"> on our DK and DF Extraction page.</a></p> <blockquote> <p><a href="/uploads/Impedance-calculator-101.xls">Download the impedance calculator spreadsheet</a></p> </blockquote> <p><a name="via"></a>Here's a spreadsheet that performs <a href="/encyclopedias/microstrip-via-hole-inductance">via-hole inductance</a> for microstrip circuits. It is improved for Rev 3 (July 2017)--please delete previous versions (the calculations were correct, but an equation graphic was incorrect).</p> <blockquote> <p><a href="/uploads/Microstrip-via-hole-Rev3-1.xlsx">Download the via-hole inductance spreadsheet</a></p> </blockquote> <p>In the spreadsheet below, Chris answers an important attenuator question. What if you are building a pi attenuator from standard resistors and you're stuck with 1% values? This spreadsheet calculates <em>exact</em> attenuation and return loss from the <em>inexact</em> resistors, for 0.2 dB step size. Thanks, Chris!</p> <blockquote> <p><a href="/uploads/ATTEN-rev1.xls">Download Chris' standard value attenuator spreadsheet</a></p> </blockquote> <p>Here's a spreadsheet for looking at mixer spurs, contributed by Gerald. Thanks! You need to enable macros to get it to work. Also, it was originally intended for Europeans so decimals are separated by commas instead of points. <a href="/encyclopedias/mixer-spur-chart">Here's a companion page</a> on how to use it.</p> <blockquote> <p><a href="/uploads/Mixers.xls">Download the mixer spur spreadsheet</a></p> </blockquote> <p>Here's a simple spur table calculator from Larry.</p> <blockquote> <p><a href="/uploads/SPUR-TABLE.xls">Download Larry's spur table calculator</a></p> </blockquote> <p>If you keep reading down this page, we have at least one one other spur table download. Collect 'em all!</p> <p><a name="HPLP"></a>Here's a spreadsheet that not only calculates the ideal values for lumped elements in a <a href="/encyclopedias/high-pass-low-pass-phase-shifters">high-pass/low-pass phase shifter</a>, it plots the frequency responses of the two filters and their relative phases over frequency! This is a good example of using <a href="/encyclopedias/abcd-parameters">ABCD parameters</a> and complex math in a spreadsheet. This spreadsheet was tuned up during March 2016, now it does multi-bit calculations all at once, and the broken plot was fixed.</p> <blockquote> <p><a href="/uploads/HPLP-Phase-Shifter101-Rev2.xlsx">Download the HP-LP phase shifter spreadsheet</a></p> </blockquote> <p>Here's a link budget calculator from Andre. He supplies this spreadsheet to engineers considering point-to-point wireless connections. OK, this is practically a free advertisement for Adtran, so when you contact them, tell them you found them through this web site and that maybe they should cough up for a sponsorship or we'll remove the link budget calculator one of these days!</p> <blockquote> <p><a href="/uploads/link-planner-v0-28.xls">Download the link budget calculator</a></p> </blockquote> <p>Here's a freespace path loss calculator contributed by Robert! It is something he put together for coworkers so they could understand Wi-Fi a little better. It allows you to customize the general RF situation in the environment (allowing you to match real world better to estimations). It also allows you to select different frequency ranges. This is an Excel 2007 file, software which we don't have, so we have yet to try it! If anyone has any comments of suggestions we will relay them to Robert. Note that the file is zipped, we had to do this because most web browsers won't know what to do with an "xlsx" file!</p> <blockquote> <p><a href="/uploads/Free-Space-Calculator.zip">Download Robert's Freespace Path Loss calculator</a></p> </blockquote> <p>Here a spreadsheet for analyzing even and odd mode impedances of <a href="/encyclopedias/coupled-line-couplers">coupled-line couplers</a>.</p> <blockquote> <p><a href="/uploads/Even-Odd-Analysis-Rev-.xls">Download the even/odd mode analysis spreadsheet</a></p> </blockquote> <p>We now have a multi-section Wilkinson power divider tool for Excel. It is (hopefully) described in detail on<a href="/encyclopedias/designing-wilkinsons-in-excel"> this page</a>. It will analyze up to eight sections but is limited to equal split. The transmission line sections are based on Chebyshev equal-ripple transformer calculations and are exact for the bandwidth that you specify. The resistor calculations are not perfected yet so you might not get the best possible isolation without optimizing the resistors on your own. Be sure to "enable macros" when you open it, and you might have to enable the "analysis tookpaks" to get it to work (look under "tools", "add-ins"...)</p> <blockquote> <p><a href="/uploads/Wilkinson101-Rev1-3.xls">Download the Wilkinson power divider spreadsheet</a></p> </blockquote> <p>Here's a "reverse microstrip calculator" a spreadsheet that lets you specify impedance and solves for line width. It uses <a href="/encyclopedias/linear-interpolation-for-excel">linear interpolation</a>, and is <a href="/encyclopedias/solving-equations-with-linear-interpolation">explained on this page.</a></p> <blockquote> <p><a href="/uploads/Reverse-microstrip-calculator-101-rev-1.xls">Download the reverse microstrip calculator</a></p> </blockquote> <p>Here's a simple spreadsheet that will help you understand the concept of <a href="/encyclopedias/frequency-translators">frequency translators</a></p> <blockquote> <p><a href="/uploads/translator.xls">Download the frequency translator spreadsheet </a></p> </blockquote> <p>Here's a spreadsheet from Nick, which we'll let him describe...</p> <blockquote> <p>I enjoy Microwaves101 far too much to be considered normal. Accordingly, the enclosed utility might spark some interest on the subject of VNA calibration fundamentals in some other kindred spirit. I can't imagine another forum that would possibly have any interest at all...</p> <p>If you think the attached worthy, please accept it gratis for use as a YAOD (Yet-Another-Oddball-Download).</p> <p><a href="/uploads/GenCalStdsV10.xls">Download the calibration utility</a></p> </blockquote> <p>Yes, Nick, Microwaves101 will always provide a home here for YAODs. Please follow up with some text explaining the spreadsheet and we'll post a page with an example...</p> <p><a name="klop"></a>Here's a spreadsheet from Chip that simulates the Klopfenstein taper. We made it more usable, with 21 impedance steps. We're working on an explanation on <a href="/encyclopedias/klopfenstein-taper"> this page.</a></p> <blockquote> <p><a href="/uploads/Klopfenstein-taper-101-Rev1-2.xls">Download the Klopfenstein taper spreadsheet </a></p> </blockquote> <p>Thanks to David, the spreadsheet below now has a correction to the math which was published by Kajfez and Prewitt in 1973. David also made other improvements to make the spreadsheet more usable. Thanks again!</p> <blockquote> <p><a href="/uploads/Klopfenstein-taper-101-Rev1-2-KazfezCorrection.xls">Download David's Klopfenstein taper spreadsheet with the K&P correction</a></p> </blockquote> <p>Here's our version of a poor man's CAD tool for doing layouts (like Visio, or a really cheap version of AutoCAD). It's all explained on <a href="/encyclopedias/fraudocad" name="fraudocad">our FraudoCad page.</a></p> <blockquote> <p><a href="/uploads/FraudoCAD-Rev1-2.xls">Download FraudoCAD</a></p> </blockquote> <p>This Excel spreadsheet calculates free space loss and and Fresnel zone radii. Inputs are frequency in GHz, transmitter TPO, antenna gain, transmission line loss, path distance, RX threshold, and obstruction distance for the Fresnel radius. Outputs are freespace loss in dBm, RX signal in dBm, RX fade margin, 1st, 2nd, 3rd and 4th Fresnel zone radii at the obstruction (calc) point.</p> <p>Contributed by Tim!</p> <blockquote> <p><a href="/uploads/pathcalc.xls">Download Tim's microwave path calculator</a></p> </blockquote> <p><a id="VSWRspreadsheet" name="VSWRspreadsheet"></a>We've finally got around to dressing up our <a href="/encyclopedias/voltage-standing-wave-ratio-vswr">VSWR</a> spreadsheet into something we're proud of! After a couple of iterations, we're now at Rev 4.0, so if you have an older version, now would be a good time to update! We fixed the math, and added a slider bar so you can animate the waveforms. <em>Note: you have to enable macros in order to get this spreadsheet to work!</em> This spreadsheet has its own <a href="/encyclopedias/visualizing-vswr">page of instructions located here.</a></p> <blockquote> <p><a href="/uploads/Standingwave101-Rev4.xlsm">Download the latest standing wave spreadsheet</a></p> </blockquote> <p><a name="linterp"></a>Here's a spreadsheet that shows you how to do linear interpolation in Excel, a valuable skill in any engineering field. Here's a<a href="/encyclopedias/linear-interpolation-for-excel"> page that describes this calculation.</a></p> <blockquote> <p><a href="/uploads/Linterp-101-Rev1-1.xls">Download the linear interpolation spreadsheet </a></p> </blockquote> <p>Here's a spreadsheet contributed by Harald that shows you how to access the polynomial curve fitting capabilities of Excel! Here's Harald's description of its capabilities:</p> <blockquote> <p>Everybody knows that you can produce a graph and add a polyline to it. But do you know, that you also can calculate the coefficients for a polynomial in Excel from a set of data and use them in your spreadsheet directly? You also can display the function of this polyline in the graph. You can copy and paste this formula into a cell for further use in the spreadsheet. It works, but you have only the accuracy as displayed in the graph and it is a lot of work. I did that until a coworker came up and said there is a simpler way to do it without creating a graph and the copy and paste work.</p> <p>This function is very well hidden in Excel and not easy to find. I created an example spreadsheet to show how it works. Up to which order of polynomial it works, I have not tried out yet. The benefit of this function is, that you have the full accuracy of Excel for each coefficient, this is especially important for higher orders of polynomials.</p> <p>The Excel Version I have is Excel 2003, the conditional sum wizard needs to be installed.</p> </blockquote> <blockquote> <p><a href="/uploads/Excel-Polynomial.xls">Download the polynomial curve fit spreadsheet</a></p> </blockquote> <p>Here's an RF unit converter from Frank. Thanks! It's an executable file that converts watts to dB-stuff and voltages, and more. Below is a screen capture that illustrates the capabilities:</p> <p><img alt="" src="/uploads/RF-Unit-Calc.jpg" /></p> <blockquote> <p><a href="/uploads/RFUnitConverter.exe">Download the RF unit converter</a></p> </blockquote> <p>We have a new page that offers some free downloads courtesy of the <a href="/encyclopedias/navy-electricity-and-electronics-series">U.S. Navy!</a> The Navy Electricity and Electronics Training Series (NEETS) was written as part of the non-resident training course series and released to the public in 1998. We've only posted the topics that have to do with microwaves, radar and radio, but if there's enough interest we might upload the entire set. You can find these training manuals on many other web sites, but few have the bandwidth that we have for rapid downloads. Some lesser web sites even try to sell them! Thanks to Steve for suggesting this idea!</p> <p><a name="smith"></a>The previous version was missing a couple of curves. We've created a bare-bones <a href="/encyclopedias/smith-chart-in-excel">Smith Chart</a> using equations for circles inside an Excel file. Then we stripped away the equations and left just the data. You can use this file any way you like, to plot data on the Smith Chart inside Excel. We'll be using it on some future spreadsheets, you betcha.</p> <blockquote> <p><a href="/uploads/Smithchart-101-Rev2.xls">Download the Excel Smith Chart</a></p> </blockquote> <p>Here's Kire's level diagram spreadsheet. Kire is one of our best "answerers" on the Microwaves101 message board, he's a prime example of what makes this a great web site.</p> <blockquote> <p><a href="/uploads/level-kirepudsje.xls">Download Kire's level diagram spreadsheet </a></p> </blockquote> <p>Phil sent us a microstrip miter spreadsheet, thank you sir! In his own words...</p> <blockquote> <p>Here’s a calculator that I made for quickly making miters in AutoCAD. Your's, like all other ones I’ve seen reference the same A, X, and D dimensions. However, to draw a miter in AutoCAD with these dimensions can get tedious with the keystroke entry of perpendiculars, offsets, and trim commands, etc. and then have to repeat it on an assembly with many bends.</p> <p>With this calculator, you enter the bend angle and it will calculate the distance for you to enter when you invoke the CHAMFER command in AutoCAD. This will quickly let you put the optimum miter on any arbitrary angle from 0 to 90 degrees and you can just click-click-click your way through any bend.</p> <p>The table below the calculator just takes the equation and fills in a variety of widths and angles.</p> <p>Pardon the minimal graphics, I made this not as a full self-explanatory file, but just something simple to give our CAD guys to speed up their work. Feel free to use or modify any of it, but this only works for AutoCAD. Other tools use a different method for calculating miters.</p> <p><a href="/uploads/Microstrip-Miter-Calculator.xls">Download Phil's miter calculator</a></p> </blockquote> <p>Here's a spreadsheet that analyzes <a href="/encyclopedias/coupled-line-couplers">coupled-line couplers.</a> You can vary the coupling factor, then see what an ideal coupler does over frequency. Be sure to turn on Excel's Analysis Toolpak!</p> <blockquote> <p><a href="/uploads/Coupler-Analysis-Rev-1.xls">Download the coupler spreadsheet</a></p> </blockquote> <p>Here's a spreadsheet that will help you floorplan a power amplifier! It is described<a href="/encyclopedias/power-amp-designer101"> on this page.</a></p> <blockquote> <p><a href="/uploads/Power-amp-designer-101-rev1-2.xls">Download the power amp designer spreadsheet</a></p> </blockquote> <p>Here's a spreadsheet that calculates resistor values for minimum loss L-pads which are <a href="/encyclopedias/l-pads">described here</a>:</p> <blockquote> <p><a href="/uploads/L-pad-attenuator-101-Rev1.xls">Download the L-pad calculator</a></p> </blockquote> <p>Here's the start of a spreadsheet that looks at the array factor for <a href="/encyclopedias/phased-array-antennas">phased array antenna</a> calculations. Well, OK, it only looks at a single line of antennas (from 1 to 101), it would be too big to download if it simulated an entire array in two dimensions. It is far from finished, but maybe some smart person out there can take over for us and put some more effort into it. It is useful for looking at the various tradeoffs of gain versus number of elements, grating lobes as a function of element spacing, number of phase shifter bits, type of phase shifter, and a few other things. Feedback is appreciated!</p> <blockquote> <p><a href="/uploads/Phased-array-101-Rev1-0.xls">Download the phased array calculator</a></p> </blockquote> <p>Here's two contributions from Spinner GmbH, on waveguide cross sections (including ordinary, reduced height, circular and double-ridged) and waveguide flange dimensions, both in pdf documents. These are the most comprehensive lists we have seen so far. Thanks!</p> <p><strong>Updated August 2024</strong>: Here are the latest versions of Uli's Waveguide list and both of Simone's Flange lists. As always, thanks to both of you!</p> <p> </p> <p>- <a href="/uploads/TD-00036U-Ulis-waveguide-list.pdf">TD-00036: CROSS REFERENCE FOR HOLLOW METALLIC WAVEGUIDES</a> “Uli’s Waveguide List”</p> <p>- <a href="/uploads/TD-00077L-Simones-flange-list.pdf">TD-00077: FLANGES FOR ORDINARY RECTANGULAR WAVEGUIDES</a> “Simone’s Flange List”</p> <p>- <a href="/uploads/TD-00277B-Simones-special-flange-list.pdf">TD-00277 FLANGES FOR SPECIAL WAVEGUIDES </a> "Simone's Special Flange List"</p> <p><a name="waveguideloss"></a>For January 2016, our <a href="/encyclopedias/waveguide-loss">waveguide loss</a> spreadsheet has been improved in several ways. We added standard rectangular waveguide all the way to WR0.51 (for teraHertz frequencies), thanks to "Uli's list" above, which you can also find <a href="/encyclopedias/rectangular-waveguide-dimensions"> on our rectangular waveguide dimensions page</a>. All the low frequency guides are still in the spreadsheet of course, and you can even make custom cross-sections. We made it much simpler to generate your own comparison plots, the plot starts with ten different species of guide but you can add or delete lines as required. You can easily toggle between dB/cm and dB/m on the comparison plot, and compare the effects of using different metals on loss. Enjoy the improved file and make custom versions of the plot below!</p> <blockquote> <p><a href="/uploads/Waveguide-Loss-M101-Rev5.xlsx">Download the waveguide loss spreadsheet</a></p> <p><img alt="SMMW waveguide loss" src="/uploads/SMMW-waveguide-loss.jpg" style="height:363px; width:500px" /></p> </blockquote> <p><a name="waveguide"></a>Here's a table that is more complete than the other one we had on our <a href="/encyclopedias/rectangular-waveguide-dimensions">waveguide dimensions page</a>. It was contributed by Alan D. from NZ. It has the three primary official designations along with some commercial designations, and interior dimensions are given in millimeters and inches.</p> <blockquote> <p><a href="/uploads/Waveguide-Table101-Rev1B.xlsx">Download Alan's waveguide table</a></p> </blockquote> <p>Here's the start of an optimum miter calculator...</p> <blockquote> <p><a href="/uploads/optimum-miter-101.xls">Download the optimum miter calculator</a></p> </blockquote> <p><a id="coax" name="coax"></a> <strong>Major update June 2020:</strong> we went through the coax spreadsheet with a fine-toothed comb and found a number of problems, especially with the <a href="/encyclopedias/surface-roughness">surface roughness effect </a>on loss. We fixed everything we spotted, and added the ability to plot coax loss versus temperature at three temperatures you choose. Please delete all prior versions if you have stored them.</p> <p>Our spreadsheet performs the <a href="/encyclopedias/a-more-exact-coax-attenuation-solution">exact calculation</a> of metal losses of coax with frequency (splitting out the calculations for center and outer conductors). It also computes dielectric losses due to loss tangent and dielectric conductivity and a ton of other parameters like characteristic impedance, capacitance and inductance per unit length, cutoff frequency, etc. The spreadsheet handles the <a href="/encyclopedias/off-center-coax">offset coax calculation</a>. See why our spreadsheet is a ton more useful than Keysight's ADS or AWR's Microwave Office for analyzing coax!</p> <p>Our coax calculator is a perfect example of how we wanted Microwaves101 to work. With the help of our loyal viewers, we've been fixing and updating the spreadsheet and are now up to version 4A. Most recently, Bob pointed out an error on the single frequency point calculation. That's been fixed, and we made the length units include inches, feet, mm and meters. In prior versions, we fixed a bug in our coax calculator spreadsheet, as pointed out by Joe, and thanks to Sergio from Italy, added surface roughness to the calculation, a topic that we all need to<a href="/encyclopedias/surface-roughness"> better understand...</a></p> <blockquote> <p><a href="/uploads/Coax-Microwaves101-Rev4.xlsx">Download the latest coax spreadsheet</a></p> </blockquote> <p>Here's a multi-dielectric coax calculator, contributed by Alex R. We recently corrected a problem with the cut-off frequency calculation for single dielectric, which was pointed out by Andrew (thanks!) It will calculate characteristic impedance of coax that contains up to five concentric dielectrics! Be sure to check out our page that <a href="/encyclopedias/multi-dielectric-coax">explains the math.</a></p> <blockquote> <p><a href="/uploads/Multidielectric-coax101-Rev2-1.xls">Download the multi-dielectric coax spreadsheet</a></p> </blockquote> <p>Here's a filter calculator from Vlad, which does lumped element calculations (Chebyshev and Butterworth) and is very cool and admittedly better than the Excel calculator that we offer farther down the <a href="/encyclopedias/airbridge-inductance">page</a>. We now have a <a href="/encyclopedias/vlad-s-lumped-element-filter-designer">page that describes how to operate Vlad's calculator</a> (but it's so simple you could figure most of it out yourself). We've had a lot of positive feedback about this calculator. The latest version offers the uses control over the plot axes. Please send us your comments on this calculator, Vlad volunteers to fix any problems you have!</p> <blockquote> <p><a href="/uploads/FilterDesigner.zip">Download Vlad's filter calculator</a></p> </blockquote> <p>Here's a MATLAB (c) tool for cylindrical <a href="/encyclopedias/resonant-cavities">resonant cavities</a>. Contributed by Itzik!</p> <blockquote> <p><a href="/uploads/resonant.zip">Download the cylindrical resonant cavity calculator</a></p> </blockquote> <p><a name="sparameter"></a>Our <a href="/encyclopedias/s-parameter-utilities-spreadsheet">S-parameter Utilities spreadsheet</a> is the ultimate tool for manipulating S-parameters into all manner of plots, including group delay, K-factor, maximum available gain, VSWR, mismatch loss, loss factor, and input and output impedance plots. You can now quickly plot all of these parameters, from any manufacturers' S-parameters that you can download! We recently added the ability to calculate length of a transmission line (if Keffective is known), or velocity factor and Keffective if length is known. The spreadsheet has the ability to import data in real/imaginary format (in addition to magnitude or dB). It provides reference plane extension capability, and averaging to the group delay, VF, Keffective and length calculation, and even does Smith chart plots! We recently fixed a bug in the GMAX calculation which fixes a problem where the 15 digits of precision within Excel sometimes aren't enough! (Explanation of this statement can be <a href="/encyclopedias/stability-factor">found here.</a>) The spreadsheet can handle 2001 lines of data, if you want a smaller file it's up to you to truncate it. The latest version includes the Stability Measure B1, thanks to Kelvin. B1 must be greater than zero to ensure stability.</p> <blockquote> <p><a href="/uploads/S-Parameter-Utilities-101-Rev-6-3.xls">Download our S-parameter Utilities spreadsheet</a></p> </blockquote> <p>Back in 2006 we created the heart-shaped S-parameters file and offered it in a spreadsheet download. We all know how SNP files sometimes don't work, so we updated the file slightly and it has been verified to work in Microwave Office. We added a second smaller heart while we were at it. Just tell your Valentine to plot all four S-parameters on a Smith Chart, and he/she will get the image below (plotted in MWO). We had to zip the file, otherwise it won't go through the download chute (it doesn't like the .S2P extension).</p> <blockquote> <p><a href="/uploads/Feb14.zip">Download Feb14.zip</a></p> </blockquote> <p style="text-align:center"><img alt="" src="/uploads/Feb-14-1.jpg" /></p> <p>If you prefer, here's our <a href="/uploads/S-Parameter-Utilities-101-Rev4-Feb14.xls">S-parameter utility spreadsheet with the "heart curve" </a>built in so you don't have to load the S-parameters into Excel. If you're lazy, just grab the graphic below and toss it into a steamy email! Here are <a href="/uploads/Heart-equations.xls">the equations</a> that we used to generate this graphic, we adapted them from something we found on the worldwide web.</p> <blockquote> <p style="text-align:center"><img alt="" src="/uploads/valentine.jpg" /></p> </blockquote> <p>Here's a download for looking at mixer waveforms. We have a new <a href="/encyclopedias/mixer-waveforms">mixer waveform</a> page that will show you how to use this to understand how a mixer works, in the time domain.</p> <blockquote> <p><a href="/uploads/MixerWaveformsRev1.xls">Download the mixer waveform spreadsheet</a></p> </blockquote> <p>Originally Chris and Graham from across the pond have sent us a cool spreadsheet for calculating mixer spurious products! It's as good as the one at Hittite.com, but because you download it before you use it, no one will ever know your secret frequencies! The Microwaves101 Professor has outdone them with an expanded mixer spur calculator which you can now download. We have also put up a page on the <a href="/encyclopedias/spur-search">instructions for using the revised calculator, </a>check it out!</p> <blockquote> <p><a href="/uploads/Spurcalculator02.xls">Download Chris and Graham's spur calculator spreadsheet</a></p> <p><a href="/uploads/ProfessorsSpurSearchRev-1.xls">Download The Professor's spur calculator spreadsheet</a></p> </blockquote> <p>Here's one engineer's collection of aerospace slang, it's from Carl F. Gauze who works at Anonymous Aerospace. (Danger Will Robinson, this document contains the F-word, so don't download it if you have a problem with that!) <a href="/encyclopedias/microwave-slang">Click here</a> to go to the Microwaves101 slang dictionary.</p> <blockquote> <p><a href="/uploads/Aeroslang.doc">Download Carl's Aerospace Slang dictionary</a></p> </blockquote> <p>Here is our lumped-element Chebyshev filter calculator! It now includes plotting capability, so you can synthesize filters and play with them in real time! (We are still working some bugs, be sure to look over the "readme" page.) Using this Excel spreadsheet you can calculate ideal elements for N=3, N=4 and N=5 order low-pass, high-pass, and band-pass filters, and you get to specify the passband and the ripple. A full description is given on our section on <a href="/encyclopedias/lumped-elements">lumped-element filters.</a></p> <blockquote> <p><a href="/uploads/LumpedChebyshevFiltersRev2.xls">Download the Chebyshev lumped-element filter spreadsheet</a></p> </blockquote> <p>This SPICE skin effect cable attenuation model was contributed by Mike Leung of Northrop Grumman Space Technologies (formally TRW). This is for engineers who model circuits using SPICE, which unfortunately excludes everybody at Microwaves101! But it looks cool so we will pass it along!</p> <blockquote> <p><a href="/uploads/SkinAttn.xls">Download the SPICE skin effect cable attenuation model spreadsheet</a></p> </blockquote> <p><a id="transformer" name="transformer"></a>Here's a spreadsheet for calculating N-section impedance transformers, to match two real impedances that you specify! The "bug" is fixed, you can now transform in both directions (Z1<Z2, Z1>Z2). In July, the Professor redid the calculator (again!), it now calculates equal-ripple, maximally flat and exponential transformers (up to eight sections). It even displays the frequency response, you don't need ADS or Eagleware or other expensive software! <em>Note: If your Excel software doesn't have the "Analysis ToolPak" installed , you might not be able to view the graphs properly. Go to "tools", then "Add-Ins", then check the box for "analysis ToolPak".</em> Check out our page on <a href="/encyclopedias/quarter-wave-tricks">quarterwave tricks</a> for more information on transformers. <strong>New for September 2021:</strong> here's a <a href="https://www.microwaves101.com/encyclopedias/equal-ripple-transformer-example">page that shows an example equal-ripple impedance transformer </a>using this spreadsheet. Check it out!</p> <blockquote> <p><a href="/uploads/Xfmr101Rev3.xls">Download The Professor's N-section impedance transformer spreadsheet. </a></p> </blockquote> <p>Our <a href="/encyclopedias/sheet-resistance">RF sheet resistance</a> spreadsheet calculates the equivalent ohms per square versus frequency for up to three layers of different metals, using the <a href="/encyclopedias/skin-depth">skin depth</a> equation and a little calculus that we already solved so you won't have to tax your tired brain! This is a feature you won't find on Keysight's ADS software. It also has a single-metalization option that plots resistivity and conductivity for 1, 2, 3, 4 or 5 skin depths (per request of Chris G.) The spreadsheet is totally unlocked, and features a pull-down menu of metal parameters for your convenience. Try out our on-line <a href="/calculators/869-skin-depth-calculator">skin-depth calculator</a> for quick analyses!</p> <blockquote> <p><a href="/uploads/RF-Sheet-Resistance-Rev-7.xls">Download the RF sheet resistance spreadsheet</a> Rev 7, updated November 2015</p> </blockquote> <p><a id="Cascade" name="Cascade"></a>Cascade101.xls - the best cascade analysis spreadsheet you'll ever get for free. For more information about this and other cascade analysis tools, check out our <a href="/encyclopedias/cascade-analysis">Cascade Analysis</a> page.</p> <blockquote> <p><a href="/uploads/Cascade101free.xls">Download the original free cascade analysis spreadsheet</a></p> <p><a href="/uploads/Cascade101Rev1-2.xls">Download the full cascade analysis spreadsheet</a></p> <p>Here's an air-bridge inductance calculator in Excel, contributed by Matt. The math appears on this page. Note that Matt changed the units to more-relevant picoHenries. Thanks!</p> <blockquote> <p><a href="/uploads/AirbridgeCalculator.xls">Download the air-bridge inductance calculator</a></p> </blockquote> <p><a id="delayconverter" name="delayconverter"></a><strong>Spreadsheet updated for May 2019!</strong> How many times have you had to convert electrical degrees to length or delay? Here's a simple spreadsheet that does the calculation three ways. If you are designing a <a href="/encyclopedias/time-delay-unit-tdu">time delay unit</a>, you know what we are talking about... while you are thinking about this, commit the following to memory so you can do the calculation in your head: 300 mm (~one foot) is one nanosecond delay in free space, and is one wavelength (360 degrees) at 1 GHz.</p> <p style="text-align:center"><img alt="" src="/uploads/delay-phase-length.jpg" /></p> <p><a href="/uploads/M101-delay-phase-and-length-converter-Rev1.xlsx">Download the delay-length-phase calculator</a></p> </blockquote> <p>Our friend Aakash has been working on Smith charts, and thoughtfully sent us some MATLab code to generate a 3D Smith chart and compute some basic functions. He's also included a presentation he made about Smith charts in the following handy zip file.</p> <blockquote> <p><a name="SmithChart3D"></a><a href="/uploads/3DSmithChart.zip">Download the 3D Smith chart code</a></p> </blockquote> <h2><a name="graphics"></a>Graphics downloads</h2> <p>Here's a couple of Visio files that contain graphics for coax and waveguide schematics of block diagrams. These were supplied by Ted! Thanks!</p> <blockquote> <p><a href="/uploads/WaveGuide-Visio-5.vss">Download the waveguide Visio files</a></p> <p><a href="/uploads/Coax-Visio-5.vss">Download the coax Visio files</a></p> </blockquote> <p>What would a microwave web site be without some handy Smith chart downloads? Here are some <a href="/uploads/GreatSmithCharts.zip">great Smith charts</a> that are low in megabytes but high in resolution, perfect for documents!</p> <p>Here's a <a href="/uploads/smith.PDF"> black and white Smith Chart</a> in Adobe Acrobat pdf. Here's a <a href="/uploads/smith-chart-in-color.PDF">color Smith Chart</a>. (Need the Acrobat reader? <a href="https://get.adobe.com/reader/">Click here!</a>)</p> <p>Here's a Microsoft Word document that contains schematic symbols such as resistors, capacitors, circulators, attenuators and switches, power dividers, bias tees, DC blocks and assorted other microwave components. In the latest edition (July 2020), we've fixed the <a href="https://www.microwaves101.com/encyclopedias/doherty-amplifiers">Doherty amplifier</a> block diagram. You can use this file to create your own schematics for documents and presentations. Please send your feedback on this work-in-progress to <a href="mailto:techwriter@microwaves101.com">techwriter@microwaves101.com</a>.</p> <blockquote> <p><a href="/uploads/Electronic-Symbols-21.doc">Download Electronic Symbols 21.doc</a></p> </blockquote> <h2><a name="posters"></a>Cool Microwaves101 posters!</h2> <p>Check out <a href="/encyclopedias/varian-radar-ads-historical"> Varian's "History of Radar" ads</a>, those cats were real gone!</p> <p>Here's a poster for your lab in PDF format. Print it and post it and help us <a href="/uploads/FiteMWstupidity.pdf">Fite Microwave Stupidity!</a></p> <p>Are you sick and tired of picking up a connector out in your lab and finding that some one else wrecked it? The Unknown Editor has a solution for you. Post this handy guide to <a href="/uploads/Connector-Care-Poster-2007.pdf">Connector Care</a> in your lab! It's updated for 2007, thanks to Vinny who caught a mistake on the torque spec (<em>inch ounces</em> should have read<em> inch pounds!</em>)</p> <p>Here is a poster on the topic of Women in Microwaves, that was prepared by Dr. S. Raghavan and Prof. S. Suganthi. Check out <a href="https://www.microwaves101.com/encyclopedias/national-institute-of-technology-trichy">NITT's Microwaves101</a> page for more information on microwave education in India.</p> <blockquote> <p><a href="/uploads/Women-in-Microwaves-Raghavan-2013.pdf">Download Women in Microwaves Poster</a></p> </blockquote> <h2><a name="info"></a>Information downloads</h2> <p>Separately, we have a page on books that you are free to download, <a href="https://www.microwaves101.com/encyclopedias/books-as-free-downloads">check it out.</a></p> <p>At Microwaves101 we pride ourselves on building microwave information into our encyclopedia, so it is indexed, cross-linked, and totally convenient. Not like some crummy pdf data sheets and app notes that suppliers put up for you to go crazy waiting two minutes to download so you can spend ten minutes looking for and probably not finding the info you need. We also make it a point not to steal stuff from other web sites and offer it as our own.</p> <p>But in some cases, we realize there are documents out in the public domain that we can collect and offer in one convenient place. Here are two examples:</p> <p><a name="MYJ"></a><a id="myj" name="myj"></a>Thanks to Rob, we now offer Microwaves101 Hall-of-Famers <a href="/encyclopedias/microwave-hall-of-fame-part-i#myj">Matthaei, Young and Jones</a> "Microwave Filters, Impedance Matching Networks and Coupling Structures" which dates back to 1963 but is still the most complete book on microwave filters ever written, at 1,000 pages. This material was developed under government contract and hence is approved for public release by <a href="http://discover.dtic.mil">DTIC</a> (which is where we found it).</p> <blockquote> <p><a href="/uploads/MYJ-part-1.pdf">Download MYJ Part 1</a></p> <p><a href="/uploads/MYJ-part-2.pdf">Download MYJ Part 2</a></p> </blockquote> <p>Here is a list of microwave laminates, prepared by SPC. You'll find it invaluable. Thanks to Alicia! By the way, if you ask SPC nicely, they might even send you a laminated 11 x 17 inch poster free of charge. Look on their <a href="http://www.standardpc.com/index.html">web site</a> for details.</p> <blockquote> <p><a href="/uploads/microwave-laminates-composition-chart.pdf">Download the Microwave Laminates chart!</a></p> </blockquote> <p><a name="women"></a>Here's a booklet titled "How to Treat Women in the Workplace". It was written for Hughes Aircraft employees in the 1950s, and it would not represent an acceptable company policy today. If you want to be horrified at "the way we were", check this out!</p> <blockquote> <p><a href="/uploads/Hughes-How-to-Handle-Women-1.pdf">Download Women in the Workplace</a></p> </blockquote> <p>Thanks to Chris, we now offer a copy of an 1954 NRL report dating from 1954, on the design and calibration of <a href="encyclopedias/horn-antennas">horn antennas</a>. <em>NRL Report 4433 DESIGN AND CALIBRATION OF MICROWAVE ANTENNA GAIN STANDARDS</em>, by William T. Slayton, gives dimensions for construction of a series of microwave horns of known gain, and may be used as a calibration reference. The horns are designed to match up well to standard waveguide sizes. Virtually all standard gain horns on the market follow the dimensions called out in this report.</p> <p>We found the document at the <a href="http://discover.dtic.mil">Defense Technical Information Center</a>, <a href="https://apps.dtic.mil/sti/citations/AD0047495">specifically here</a>. So we'll assume it is public domain, and offer it through the link below. Enjoy!</p> <blockquote> <p><a href="/uploads/Slayton-NRL-1954-report.pdf">Download DESIGN AND CALIBRATION OF MICROWAVE ANTENNA GAIN STANDARDS, NRL Report 4433</a></p> </blockquote> <p>We have much more on material on William Slayton thanks to his daughter Charlotte! Here is a much better copy of the NRL report.</p> <blockquote> <p><a href="/uploads/William-Slayton-NRL-Report-4433.pdf">Download DESIGN AND CALIBRATION OF MICROWAVE ANTENNA GAIN STANDARDS, NRL Report 4433 (Improved copy) </a></p> </blockquote> <p>Here is an article he wrote for Electronics Magazine in 1955, on the same topic!</p> <blockquote> <p><a href="/uploads/William-Slayton-Electronics-1955.pdf">Download Design of Microwave Gain-Standard Horns</a></p> </blockquote> <p>Finally, here is a speech he gave in 1980 about his experience at NRL, three years after his 1977 retirement.</p> <blockquote> <p><a href="/uploads/William-T-Slayton-My-Experiences-at-the-Naval-Research-Lab.pdf">Download Slayton's 1980 speech</a></p> </blockquote> <p>It's no wonder that William Slayton is in the <a href="/encyclopedias/microwave-hall-of-fame-part-iii#slayton">Microwave Hall of Fame!</a></p> <p>The Quadrennial Defense Review report is put together every four years by the Department of Defense, the latest was issued February 2014. This report defines where we are on the war on terror, as well as the to-be state. If you want to win a government defense contract you should read this and reference it in your proposal.</p> <blockquote> <p><a href="/uploads/2014-Quadrennial-Defense-Review.pdf">Download the Department of Defense February 2014 QDR</a></p> </blockquote> <p>Here's the previous QDR report in case you want to see what changed.</p> <blockquote> <p><a href="/uploads/QDR-as-of-29JAN10-2010.pdf">Download the Department of Defense February 2010 QDR</a></p> </blockquote> <p>The US Department of Homeland Security also issued a quadrennial review report in February 2010.</p> <blockquote> <p><a href="/uploads/QHSR2010.pdf">Download the Department of Homeland Security February 2010 QHSR</a></p> </blockquote> <p><a href="/encyclopedias/darpa-microwave-programs">DARPA</a> has a strategic plan, you should read it!</p> <blockquote> <p><a href="/uploads/DARPA2015.pdf">Download DARPA's 2015 strategic plan</a></p> </blockquote> <p>The Navy's Office of Naval Research has a plan for science and technology, some of which is gonna involve some very high power microwaves...</p> <blockquote> <p><a href="/uploads/2018-USMC-S-and-T-Strategic-Plan.pdf">Download the ONR S&T plan</a></p> </blockquote> <p>The Navy released some great tutorial documents in 1998, including an entire series on electronics. We've posted the NEETS documents on a <a href="/encyclopedias/navy-electricity-and-electronics-series">separate page.</a></p> <p>Read all about the future by grabbing a copy of GLOBAL TRENDS 2030: ALTERNATIVE WORLDS, a publication of the National Intelligence Council. It's 23 MB so it might take a while...</p> <blockquote> <p><a href="/uploads/global-trends-2030-nic-lo.pdf">Download GLOBAL TRENDS 2030</a></p> </blockquote> </div> <div class="leaderboard-ads"> <label> Advertisement </label> <div class="leaderboard-inner"> <!-- /4906012/Baseboard --> <div id='div-gpt-ad-1513662185452-0'> <script> googletag.cmd.push(function () { googletag.display('div-gpt-ad-1513662185452-0'); }); </script> </div> </div> </div> </div> <div class="col-lg-2 no-padding hidden-md hidden-sm hidden-xs"> <div id="fixedads" class="ads-box"> <label> Advertisement </label> <div class="skyscrapper"> <!-- /4906012/Skyscraper --> <div id='div-gpt-ad-1513662144177-0'> <script> googletag.cmd.push(function () { googletag.display('div-gpt-ad-1513662144177-0'); }); </script> </div> </div> </div> </div> </div> </div> <span id="pageName" class="hidden">download-area</span> <div class="clearfix"> </div> <footer id="footer"> <div class="row no-margin"> <div class="col-lg-6 col-md-6 col-sm-6"> <div class="footer-widget"> <div class="footer-heading"> <h5>Published in association with</h5> </div> <ul class="associate-website"> <li><a href="https://www.everythingrf.com" target="_blank"> <img src="https://d2xunoxnk3vwmv.cloudfront.net/images/rf-logo-white.png" alt="everythingrf-logo"></a></li> </ul> </div> </div> <div class="col-lg-6 col-md-6 col-sm-6"> <div class="footer-widget left"> <ul class="quick-link"> <li> <a id="HyperLink1" href="sitemap.xml">Sitemap</a></li> <li> <li> <a id="HyperLink5" href="terms-conditions" target="_blank">Terms & Conditions</a></li> <li> <li> <a id="hlnkPrivacyPolicy" href="privacy-policy">Privacy Policy</a></li> </ul> <div> <span id="lblFooterYear"> 2024 Microwaves101. © All Rights Reserved.</span> </div> </div> </div> <div class="clearfix"> </div> </div> <a class="scroll-to-top hidden" href="javascript:void(0)" id="scrollToTop"><i class="fa fa-arrow-up fa-white"></i></a> </footer> </div> </div> <script type="text/javascript" src='js/bootstrap/js/bootstrap.js'></script> <script type="text/javascript" src='js/ckeditor/ckeditor.js'></script> <script type="text/javascript" src='js/mw101-clientscript.js?version=2'></script> <script type="text/javascript" src='js/jquery.orbit.min.js'></script> <script type="text/javascript" src='js/calculator.js?version=2'></script> </form> <script type="text/javascript"> $(document).ready(function () { $('#featured').orbit({ 'orbits': 0, 'bullets': false, captions: false, 'timer': false, 'animation': 'horizontal-slide' }); $('#featured.orbit').hide(); // hide div, may need to change id to match yours $('#loading').show(); // show the loading gif instead // then when the window has fully loaded $(window).bind('load', function () { $('#loading').hide(); // hide loading gif $('#featured.orbit').fadeIn('slow'); // show orbit }); $('[data-toggle="tooltip"]').tooltip(); }); </script> </body> </html>