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!
Transcat | Axiom Test Equipment - RF Cafe
Aegis Power | Centric RF | RFCT
Empower RF | Reactel | SF Circuits

Alliance Test | Isotec
Johanson Prototyping Kit - RF Cafe

RF Electronic Stencils Symbols Visio Shapes Office

Johanson Dielectrics EMI Filters - RF Cafe
Johanson Dielectrics EMI Filters - RF Cafe

Anatech Electronics RF & Microwave Filters - RF Cafe

Crane Aerospace & Electronics (RF & Microwave) - 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

Temwell RF Microwave Components - RF Cafe

Note: RF Cascade Workbook 2004™ has been superseded by

RF Cascade Workbook 2018™

minimum height spacer

 

Please go to the RF Cascade Workbook 2018™

webpage for features and purchasing information.

Thank you.

User's Guide


System Requirements:   Microsoft Excel 2003 or newer.

RF Cascade Workbook 2004 (RFCW2004) is the result of requests from some users for a user interface that is more program-like, and that is more presentation-ready. By incorporating a graphical block diagram and adding some VBA automation, RFCW2004 strikes a reasonable balance between effort invested in creature comforts and basic functionality. Here are a few of the new features in RFCW2004:

 - RF Cafe

  • A single chart with menu-selectable plots

  • Scales on both left and right axes

  • Use of error bars for min/max values on plots rather than separate traces

  • Graphical block diagram with menu selectable component icons

  • IMD2 and ΔIMD2 values to accommodate direct conversion calculations

  • DC power supply calculations on same page as cascade calculations

  • Three versions of RFCW204 included with various numbers of components pre configured (6, 12, 18)

  • All component parameter and calculated cascaded values are referenced to the component OUTPUT

  • User's Guide covering all aspects of the workbook, including formulas and instructions for modifying the VBA code

  • RF Cascade Analysis

 - RF CafeAll of the formulas used in RF Cascade Workbook 2004 are presented in the User's Guide to assist in understanding the operation of the spreadsheet. Most calculations are implemented in VBA code, which makes customization more convenient and keeps clutter out of the cells. This is especially helpful in the case of conditional formulas. Additionally, input cells are checked for valid numerical ranges or text values. Expansion of the workbook to include custom calculations is a simple matter. Excel has a very extensive Help section for VBA code writing built-in.

Note: The file is saved in a format that accommodates back through Excel 95. If you are using Excel version 2002 or newer, re-saving the file in the newer format will reduce the file to about half its current size.

Click here to view the User's Guide                       Click to view full-size image (376 kB)
User's Manual Cover                        Entire Worksheet  
RF Electronic Stencils Symbols Visio Shapes Office