RF Cafe Software

RF Cascade Workbook 2005 - RF Cafe
RF Cascade Workbook

Calculator Workbook
RF Workbench
Smith Chart™ for Visio
Smith Chart™ for Excel
RF & EE Symbols Word
RF Stencils for Visio

About RF Cafe

Kirt Blattenberger - RF Cafe WebmasterCopyright
1996 - 2016
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 Internet was still largely an unknown entity at the time and not much was available in the form of WYSIWYG ...

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

Try Using SEARCH
to Find What You Need. 
There are 1,000s of Pages Indexed on RF Cafe !

Electronics World Cover,TOC,and list of posted Popular Electronics articles QST Radio & TV News Radio-Craft Radio-Electronics Short Wave Craft Wireless World About RF Cafe RF Cafe Homepage RF Cafe in Morse Code Google Search of RF Cafe website Sitemap Electronics Equations Mathematics Equations Equations physics Manufacturers & distributors Engineer Jobs Twitter LinkedIn Crosswords Engineering Humor Kirt's Cogitations Engineering Event Calendar RF Engineering Quizzes AN/MPN-14 Radar 5CCG Notable Quotes App Notes Calculators Education Magazines Software,T-Shirts,Coffee Mugs Articles - submitted by RF Cafe visitors Simulators Technical Writings RF Cafe Archives Test Notes RF Cascade Workbook RF Stencils for Visio Shapes for Word Thank you for visiting RF Cafe!

RF Cascade Workbook 2003  v1.10

System Requirements:   Windows 98, Microsoft Excel 2000 or later.

User's Guide

NOTICE: RF Cascade Workbook 2005 replaces the 2003 version and adds a lot of functionality. Therefore, RF Cascade Workbook 2003 will no longer be offered for sale. All of the original information is retained here for reference.

Please click here to go to the RF Cascade Workbook 2005 webpage.

NOTE: Macros DO NOT work in Office 365 version of Excel; therefore, RF Cascade Workbook DOES NOT work in Office 365.

RF Cascade Workbook 2003 incorporates many features requested by users over the last year. While automated program features and multi page displays are useful, it seems most users would rather have the convenience and ease of all input and output cells being on a single worksheet, and have most of the formulas in a VBA routine to maintain uncluttered cells and simple manipulation. Another concern is the rather large size of the basic workbook, since every system saved creates a file the size of the entire workbook.
 

RF Cafe - RF Cascade  Workbook 2003
Click for full-size view


Here is brief list of changes for RF Cascade Workbook 2003:
  • All input/output cells located on a single worksheet (makes inserting/deleting rows simpler)
  • Removed pop-up calculators since they just make the workbook larger
  • Put the vast majority of cell formulas in VBA code for easy manipulation
  • Added the ability to specify individual device IP2 and IP3 as input or output referenced
  • Provided a User’s Guide, and eliminated the online help for a smaller workbook file size
  • Put device tolerance and Min/Max cells next to Nominal parameters
  • Modified formulas to reflect gain min/max values in addition to device min/max variations
  • Added a minimum system SNR value for use in calculating dynamic range
  • Employed Excel’s outline feature to easily show/hide Min/Max values
  • Reduced the number of default graphs (smaller workbook file size)
  • Reduced the overall file size to under 200 kBytes
  • Added AC/DC power budget worksheet

All of the formulas used in RF Cascade Workbook 2003 are presented in the illustrated 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. Expansion of the workbook to include custom calculations is a simple matter.