Electronics World articles Popular Electronics articles QST articles Radio & TV News articles Radio-Craft articles Radio-Electronics articles Short Wave Craft articles Wireless World articles Google Search of RF Cafe website Sitemap Electronics Equations Mathematics Equations Equations physics Manufacturers & distributors LinkedIn Crosswords Engineering Humor Kirt's Cogitations RF Engineering Quizzes Notable Quotes Calculators Education Engineering Magazine Articles Engineering software RF Cafe Archives Magazine Sponsor RF Cafe Sponsor Links Saturday Evening Post NEETS EW Radar Handbook Microwave Museum About RF Cafe Aegis Power Systems Alliance Test Equipment Centric RF Empower RF ISOTEC Reactel RF Connector Technology San Francisco Circuits Anritsu Amplifier Solutions Anatech Electronics Axiom Test Equipment Conduct RF Copper Mountain Technologies Exodus Advanced Communications Innovative Power Products KR Filters LadyBug Technologies Rigol TotalTemp Technologies Werbel Microwave Windfreak Technologies Wireless Telecom Group Withwave Resources Vintage Magazines RF Cafe Software WhoIs entry for RF Cafe.com Thank you for visiting RF Cafe!
everythingRF RF & Microwave Parts Database (h1)

Rigol DHO1000 Oscilloscope - RF Cafe

Exodus Advanced Communications Best in Class RF Amplifier SSPAs

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

Windfreak Technologies SynthHD PRO - RF Cafe

Note: RF Cascade Workbook 2002™ has been superseded by

RF Cascade Workbook 2018™

 

Please go to the RF Cascade Workbook 2018™

webpage for features and purchasing information.

Thank you.


Using advanced features of MS Excel, extensive cascade analysis of RF component parameters is performed. Noise power analysis, min/max tolerances, complete graphing of all parameters, and auxiliary pop-up calculators makes RF Cascade Workbook 2002 a tool you cannot afford to be without. Drop down menu navigation and error trapping on all inputs enhances the interface.


New features:

  • This workbook is totally unlocked for easy access to formulas and VBA code
  • Up to 50 components allowed. Display or hide component rows in groups of 5 using the Setup page. Hidden components are still included in cascade calculations.
  • Graphs automatically display only only unhidden components.
  • "-User-" page for custom formula cells. Create formulas that reference any cell in the rest of the workbook using standard Excel functions.
  • Version 1.02c has had it's equation references modified to match those used in RF Cascade Workbook 2003. The changes are minor, but you might want the upgrade anyway.
  • If you purchase RFCW2002 new, the User's Manual for RFCW2003 will be included at no charge  (PDF format - no hard copy).
Click here for dynamic range calculation details and other FAQs.


A summary of features and a few screen shots are listed in the table below.

Setup Page

  • Select which components rows to display or hide.

Title Page

  • Workbook title & subtitle entered here is placed at the top of all pages.
  • Description of project.

Nominal Page

  • Set system reference temperature & frequency units.
  • Enter nominal system component parameters, i.e., gain, NF, IP2, IP3, Psat, VSWR.
  • Instantly see results of changes in extensive tabulated format.
  • Open dialog box to calculate opamp noise figure.
  • Open dialog box to convert VSWR to return loss.
  • Open dialog box to convert input parameters to output parameters.
  • Rows 26 through 49 hidden.

Min-Max Pages

  • Set component min-max parameter variations.
  • Instantly see results of changes for worst case scenario in extensive tabulated format.
  • Turn on/off VSWR interaction effects.
  • Rows 26 through 49 hidden.

-User-

  • Full, unlocked page for creating custom formula cells - reference other page cells.
  • Rows 26 through 49 hidden.

Graph Pages

  • Complete min/nom/max parameter plots on a stage-by-stage basis.
  • Customize graphs.
  • Graphs automatically adjust to display only unhidden components.
  • Separated into 3 pages.
  • Rows 26 through 49 hidden.

Notes

  • Add your project-specific notes.
RF Cascade Workbook 2002 Home Page - RF Cafe

RF Cascade Workbook 2002 Component Nominal Value Entry - RF Cafe

RF Cascade Workbook 2002 Component Min-Max 1 Value Entry - RF Cafe

RF Cascade Workbook 2002 Component Min-Max 2 Value Entry - RF Cafe

RF Cascade Workbook 2002 User - RF Cafe

RF Cascade Workbook 2002 Component Graphs 1 Value Entry - RF Cafe

Windfreak Technologies SynthHD PRO - RF Cafe
Innovative Power Products (IPP) RF Combiners / Dividers

TotalTemp Technologies (Thermal Platforms) - RF Cafe

Crane Aerospace Electronics Microwave Solutions: Space Qualified Passive Products