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 RF Engineering Quizzes Notable Quotes Calculators Education Engineering Magazine Articles Engineering software RF Cafe Archives RF Cascade Workbook 2018 RF Symbols for Visio - Word Advertising Magazine Sponsor RF Cafe RF Electronics Symbols for Visio RF Electronics Symbols for Office Word RF Electronics Stencils for Visio Sponsor Links Saturday Evening Post NEETS EW Radar Handbook Microwave Museum About RF Cafe Aegis Power Systems Anritsu Alliance Test Equipment Amplifier Solutions Anatech Electronics Axiom Test Equipment Berkeley Nucleonics Bittele Centric RF Conduct RF Copper Mountain Technologies Empower RF everything RF Exodus Advanced Communications Innovative Power Products ISOTEC KR Filters Lotus Systems PCB Directory Rigol San Francisco Circuits Reactel RFCT TotalTemp Technologies Triad RF Systems Windfreak Technologies Withwave LadyBug Technologies Wireless Telecom Group Sponsorship Rates RF Cafe Software Resources Vintage Magazines Thank you for visiting RF Cafe!
KR Electronics (RF Filters) - 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

Amplifier Solutions Corporation (ASC) - RF Cafe
Rigol DSG5000 Microwave Generator - RF Cafe
everythingRF RF & Microwave Parts Database - RF Cafe		 Windfreak Technologies Frequency Synthesizers - RF Cafe
Innovative Power Products Passive RF Products - RF Cafe

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

These Are Available for Free
 

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 tying 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