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 Engineer Jobs LinkedIn Crosswords Engineering Humor Kirt's Cogitations Engineering Event Calendar RF Engineering Quizzes USAF radar shop Notable Quotes App Notes Calculators Education Engineering Magazines Engineering magazine articles Engineering software Engineering smorgasbord RF Cafe Archives RF Cascade Workbook 2018 RF Stencils for Visio RF & EE Shapes for Word Advertising RF Cafe Homepage Sudoku puzzles Thank you for visiting RF Cafe!
Innovative Power Products Couplers

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
Qorvo / Custom MMIC Eliminating Mixup over Mixers - RF Cafe PCB Directory (Assembly)
Windfreak Technologies Axiom Test Equipment - RF Cafe
About RF Cafe
Kirt Blattenberger - RF Cafe Webmaster
Copyright: 1996 - 2024
Webmaster:
    Kirt Blattenberger,
    BSEE - KB3UON

RF Cafe began life in 1996 as "RF Tools" in an AOL screen name web space totaling 2 MB. Its primary purpose was to provide me with ready access to commonly needed formulas and reference material while performing my work as an RF system and circuit design engineer. The World Wide Web (Internet) was largely an unknown entity at the time and bandwidth was a scarce commodity. Dial-up modems blazed along at 14.4 kbps while typing up your telephone line, and a nice lady's voice announced "You've Got Mail" when a new message arrived...

All trademarks, copyrights, patents, and other rights of ownership to images and text used on the RF Cafe website are hereby acknowledged.

My Hobby Website:  AirplanesAndRockets.com

spacer

Please Support RF Cafe by purchasing my  ridiculously low−priced products, all of which I created.

These Are Available for Free