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

Copper Mountain Technologies (VNA) - RF Cafe

Innovative Power Products (IPP) Directional Couplers

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

Exodus Advanced Communications Best in Class RF Amplifier SSPAs - RF Cafe

RF Cascade Workbook™ 2018.6

Screenshots

RF Cascade Workbook (System Definition worksheet) - RF Cafe

There might be minor differences between the current version of RF Cascade Workbook™ and what is shown in these screen captures.

System Definition

RF Cascade Workbook | Wireless System Designer (charts) - RF Cafe

20 Chart Types

RF Cascade Workbook (Icon worksheet) - RF Cafe

Block Diagram Icons

RF Cascade Workbook (Help Worksheet) - RF Cafe

Help | Hints

Notes

  • Assistance:

    Because the price for RF Cascade Workbook™ is so low, I cannot provide any level of assistance with setup or operation. After all, you're getting an amazingly feature-filled program for less than an hour of an engineer's billable time. Reported errors, if any, will be addressed ASAP.

  • Macros:

    You must enable macros to run or you cannot use RF Cascade Workbook.

  • System Requirements: Excel 2007 & Windows 2008 or newer.

    These instructions and screenshots were made in Excel 2007, so your screen and menu placements might be a little different. I verified that everything works fine all the way through Excel 2019.

  • Help:

    Here is the complete Help Page from RF Cascade Workbook™

End User License Agreement (EULA)

This product is NOT Shareware, Freeware, or an Evaluation version. Its legal use is contingent upon purchase directly from RF Cafe, as no distributors are authorized. Unauthorized copying, alteration or distribution of this product is prohibited by law. Please visit the RF Cafe website to submit payment for this product. Simply put, you may not use this product if you have not paid for it.

Disclaimer: "RF Cascade Workbook™" is offered AS IS. Your use of this product implies you alone accept responsibility for results obtained through its use, and will hold harmless Kirt Blattenberger, RF Cafe, and all associates for any losses incurred through its use. This product has been tested very thoroughly, and there are no known problems at the time of this release.

Site License Terms

A Site License, if purchased allows an unlimited number of users at one (1) location. Users must be officially affiliated with the site during the time of use. That means the license does not follow a user who permanently leaves the site (graduation, new employment, etc.). The license extends to persons whose primary job is normally performed at that location, but works occasionally from home or at a remote location. Hobbyists employed at the same location are welcome and encouraged to use the software. The single location restriction is imposed to limit distribution to local use for companies with multiple physical locations. This software may not be redistributed in any form, nor posted on the Internet or anywhere that it can be publicly accessed. The file(s) may be distributed on a server, via e-mail, etc., as needed for qualified users.

Disclaimer

RF Cascade Workbook™ is offered AS IS. Your use of RF Cascade Workbook™ implies you alone accept responsibility for results obtained through its use, and will hold harmless Kirt Blattenberger, RF Cafe, and all legal assigns for any losses incurred through its use. RF Cascade Workbook™ has been tested very thoroughly, and there are no known problems at the time of this release. Discrepancies that affect accurate results, if discovered, will be fixed ASAP and a replacement version will be provided at no cost. Also, any and all User modifications to RF Cascade Workbook™ - other than entering values in the provided Unlocked cells, negates any and all responsibility by RF Cafe for the integrity of the software. Unprotecting a worksheet negates responsibility by RF Cafe.

Known Issues

None known.

Please click here to see the new webpage for
RF Cascade Workbook version H

 

 

For more than a decade, RF Cascade Workbook 2005™ has been the de facto standard for spreadsheet-based RF system cascade analysis. RF Cascade Workbook™ version A began the next phase of evolution. Chances are you have never used a spreadsheet quite like this. If you know how to use Excel and you know anything about cascaded system calculations, then you know how to use RF Cascade Workbook™. This is significantly easier and faster than using the multi-thousand dollar simulators when a quick system analysis is all that is needed. Hundreds of hours have gone into developing this tool. Please see RF Cascade Workbook™ intro video below for an overview of features.

Your are welcome to request any the updated version if you own any previous version of 2018.

10/28/2024 Update to version H:
Coming soon, hopefully...
Added Discrete Frequency & Power inputs. Also, minor improvements in interface & functionality.

3/31/2024 Update to version G: Removed two redundant rows of calculations in the Filter & LO area.

1/9/2022 Update to version F: Worksheet Structure unlocked and password removed.

12/25/2021 Update to version E: Minor text changes on Help screen and title.

6/16/2020 Update to version D: Background image was changed.

5/19/2020 Update to version C: The minimum noise figure (NFmin) formula has been modified to prevent a negative value. Please send me an e-mail if you would like a replacement file. Instructions to make the change yourself can be seen here.

4/24/2020 Update to version B: The IP1dB formula was modified.

6/8/2018 Initial Release (version A).

Feature Descriptions

Mouse-over Comments for Cells

Cell Comments (RF Cascade Workbook) - RF CafeExcel's cell comment feature is use extensively to provide guidance for RF Cascade Workbook™ (RFCW). The contents of all the hints - and more - can be found on the "Help" worksheet (click the tab at the bottom). The "Help" worksheet, cell mouse-over comments, and this web page comprise the totality of documentation for RF Cascade Workbook™. There is no separate document available. RF Cascade Workbook 2005™ User's Guide should also be useful since it extensively documents formulas. Combined, there is a lot of information about not just how to use RFCW, but also how cascaded system analysis works. RF Cafe is also chock full of related information, so one way or the other, you're covered.

Locked vs. Unlocked Cells and VBA Code

Worksheet Protection (RF Cascade Workbook) - RF CafeThe built-in ability of locking cells to prevent unintentional overwriting of formulas is used in RF Cascade Workbook™. The only worksheets which are locked when you receive the file are the " Most of the time the protection can be left on. Trust me, even after becoming familiar with use, you will still find yourself accidently attempting to type into formula cells, and of course doing so invalidates calculated results. Probably the only time you will need to remove protection is when inserting or deleting columns or rows. I recommend never Unprotecting any worksheet since doing so invalidates the integrity as provided. Be sure to reapply Protection if you decide to Unprotect. See the RFCW Terms of Use information about liability.

Protecting & Unprotecting the Worksheet

Protecting & Unprotecting the Worksheet (RF Cascade Workbook) - RF CafeUse Excel's Protect Sheet and Unprotect Sheet commands to lock and unlock, respectively, the cells (see "Help" worksheet for more information). All cells except User Input cells are formatted to be locked if you choose to enable the "Protect Sheet" option.

When Protecting the worksheet, be sure to select ALL the check boxes in order to ensure that the macros will run (click thumbnail above). You might need to scroll down in the window to access all the check boxes.

Inserting and Deleting Columns

Please see this separate page with screen shots and directions showing how to insert and delete columns.

Navigating the Worksheet

Drop Down Navigation (RF Cascade Workbook) - RF CafeSince the complete worksheet occupies nearly 900 rows, a convenient drop-down menu is provided to move up and down the page. Information necessary for the navigation to function is in the cell behind the menu, so if you accidently overwrite the cells, navigation no longer works (keep Protection turned on).

Hiding and Unhiding Columns

Hide Columns (RF Cascade Workbook) - RF CafeUnhide Columns (RF Cascade Workbook) - RF CafeRather than deleting and/or adding component stage columns, it is much simpler to Hide and/or Unhide columns. Doing so retains all the information without having to go through all the steps needed for deleting and/or adding columns. All the input and calculated is retained and included in the overall output, but the Hidden stage columns are not included in the charts. Hiding component stage columns can be a good way to exclude unneeded plots from the charts without requiring you to delete/add data series - which is itself a pain to do.

System Cascade Charts

System Cascade Charts (RF Cascade Workbook) - RF CafeCharts are pre-configured for plotting all calculated cascade parameters. Auto-scaling of the axes is the default, but you can change all aspects of the chart formats per Excel standard. Select chart to display using drop-down menu.

System-Level Parameters

System Parameter Specification (RF Cascade Workbook) - RF CafeThese four top-level overall system parameters are used for many calculations. Be sure to define them along with the individual stage component parameters.

Build System Block Diagram

Block Diagram (RF Cascade Workbook) - RF CafeBuild your system block diagram using the provided images or make your own. Click on the "Icons" tab at the bottom of the page to access and copy the desired icon (58x32 pixels), then paste it into the block diagram. Use Excel's standard Objects alignment and spacing tools for a perfect layout.

Specify Component Parameters

Specify Component Parameters (RF Cascade Workbook) - RF CafeEnter each stage's nominal and tolerance values. Error checking is provided for exceeding power or gain limits (see below), no negative noise figure (NF), making sure NF is equal to absolute value of a negative gain component, etc. Errors are reported in the "Status" cells. Two rows f user-defined cells are provided for formulas along with a "User Defined" chart that displays the cell data.

Set Limits on Gain and Power Input Values

Stage Gain and Power pmits (RF Cascade Workbook) - RF CafeSet maximum values for stage component input parameters. These values are used for Data Validation in the input parameter cells. This results in a limit where the charts auto-scale, since entering a null value of, say +999 dBm for IP3 will render its affect utterly unnoticeable by the system, the IP3 chart will auto-scale to +1000 dBm or more while the IP3 level in your actual system might be a maximum of +50 dBm. The useful data would then be crunched almost entirely at the bottom 5% of the chart. Of course you can always go in and manually scale the chart axis minimum and maximum values as desired if you do use +999 dBm as the null value. This just keeps things reasonable in case you prefer to let the charts auto-scale. Besides, +100 dBm is good enough in most instances.

Specify Lower and Upper Frequency Sweep Limits for Filter Calculations

Frequency Sweep Limits (RF Cascade Workbook) - RF CafeEnter the lower and upper frequency range for calculating the system response inclusive of filters and frequency conversion stages. 175 equally spaced frequency steps are calculated for all stages. Depending on your system, you might want to do sweeps across the entire input band of concern, then do narrower sweeps that will provide finer detail within your smaller filter bandwidths.

Note: the Lower frequency cannot be zero (0) because of the logarithmic horizontal chart scale. The smallest value permitted is 10-12, which is small enough to include 1 Hz even when the Upper frequency is 1 THz.

Filter Specifications

Filter Specifications (RF Cascade Workbook) - RF CafeEvery stage can contain a frequency-dependent component which can be an actual filter or a model of the frequency response of an amplifier, cable, coupler, etc. RFCW checks to make sure all required inputs are present and alerts you if they are not. For example, if you select a bandpass filter and do not enter a lower frequency or if you use a Chebyshev and do not enter a ripple value (or if you enter invalid values, like lower frequency greater than upper frequency).

Frequency Translation (Mixers | Modulators) Specifications

Frequency Translation Specifications (RF Cascade Workbook) - RF CafeAs with the filter specifications, every stage can have a frequency translation. That means there is no limit to the number of frequency conversions your system can have, although from a practical standpoint you will probably never have more than three. RFCW checks to make sure all required inputs are present and alerts you if they are not.

Frequency-Dependent Power Levels

Frequency-Dependent Power Levels (RF Cascade Workbook) - RF CafeFrequency-dependent power levels based on filter responses and frequency translations are calculated separately from the other system cascade calculations (NF, IP2, IP3, etc.). Along with the filter response, all nominal stage component gains are included. Results are plotted in the "Frequency Response" ("Signal Power vs. Frequency") chart. These frequency-dependent gains and power levels are not used in any of other cascade calculations (NF, IP2, IP3, etc.). Note that frequency and power levels presented this matrix are actually calculated in cells below Row 540, but are done this way to conveniently place power levels next to their associated frequencies while making data selection for the chart simpler (take my word for it).

RF Cascade Workbook™ Intro Video (part 1)

RF Cascade Workbook™ Intro Video (part 2)

For archival purposes only, here are links to previous versions of RF Cascade Workbook:

RF Cascade Workbook 2002

RF Cascade Workbook 2003 (includes user guide)

RF Cascade Workbook 2004 (includes user guide)

RF Cascade Workbook 2005 (includes user guide)

 

12/25/2021 Update to v2018.4

Changed title to "RF Cascade Workbook" and revision numbers to a format of "2018.n"
Updated "Workbook Protection" area in "Help."
Updated official business name from "RF Cafe" to my name "Kirt Blattenberger." This was done for business registration simplicity."

 

6/16/2020 Update to v2018.3

The background image was changed to a muted log-log graph pattern.

You can change the background image to anything you like, or have no background image at all. To do so, go to Page Layout -> Delete Background. To add a background, do Page Layout -> Background and select a file.

 

RF Cascade Workbook v1.2 Noise Figure equation edit - RF Cafe5/19/2020 Update to v2018.2:

The Minimum Noise Figure calculation has been modified to prevent negative number.

If you already have data entered into a file, you might prefer to edit that file rather than copy the data it into a new v1.20 file. If you are comfortable with editing both the spreadsheet cell equations and Visual Basic code, the instructions below and screen shots at the right show you how to do it.

  1. Click in cell F108 and replace the existing equation with this one:

    =IF(F35-F36<0,0,F35-F36)

  2. This is how to modify the VBA code:
    1. Click on the "Developer" tab.
    2. Click on the "Visual Basic" toolbar button.
    3. In the tree page, double-click on "CascadeParameters" under the "Modules" branch.
    4. Add the following equation to the end of the "Function CascadeNF" function:

      If CascadeNF < 0 Then

      CascadeNF = 0

      End If

      Click on "File->Save."

    5. Save the entire workbook file to preserve the changes.

 

RF Cascade Workbook v1.10 IP1dB Formula Correction - RF Cafe4/24/2020 Update to v2018.1:

IP1dB Formula Correction Instructions

You might prefer to just change the IP1dB formula cells rather than copy all the information from an existing workbook into the new version. If so, these instructions provide a simple way to do it. Screen captures of each step are in the image to the right (click for a larger version).

 

  1. Click in cell F45 and change the formula from

    =F43-F33-1 to

    =F43-(F33-1) , or to

    =F43-F33+1 ,

    then press Enter.

  2. Click in cell F45 and select Copy.
  3. Highlight cells H45 through AE45.
  4. Select Paste Special... then select Formulas and press OK.
  5. Click in one of the IP1dB cells in row 45 and verify that it contains the new formula.
  6. Save your workbook.
Exodus Advanced Communications Best in Class RF Amplifier SSPAs - RF Cafe
Rigol DHO1000 Oscilloscope - RF Cafe

TotalTemp Technologies (Thermal Platforms) - RF Cafe

LadyBug RF Power Sensors