Search RFC: |                                  
Please support my efforts by ADVERTISING!
Serving a Pleasant Blend of Yesterday,
Today, and Tomorrow™

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

Formulas | Data

Electronics | RF
Mathematics
Mechanics
Physics


Calvin & Phineas

kmblatt83@aol.com

Archive | Sitemap

Resources

Articles | Radar
Cogitations
Magazines | AI
RF Museum
Software | Videos
Radio Service
Tech Notes

Entertainment

Crosswords
Humor | Podcasts
Quotes | Quizzes
Tech Comics

Parts | Services

1000s of Listings


About RF Cafe

Software: RF Cascade Workbook | RF Symbols for Office | RF Symbols & Stencils for Visio | Espresso Workbook
Please Support My Advertisers!
Aegis Power | Centric RF | RFCT
Empower RF | Reactel | SF Circuits

Alliance Test | Isotec
Exodus Advanced Communications Best in Class RF Amplifier SSPAs

Windfreak Technologies Frequency Synthesizers - RF Cafe

Anritsu MG36021A Microwave Frequency Synthesizer Module  - RF Cafe
Innovative Power Products (IPP) Directional Couplers - RF Cafe

ConductRF VIDA67 RF Cables - RF Cafe

LadyBug Technologies LB466A Power Monitor - 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

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