Search RFCafe.com                           
      More Than 17,000 Unique Pages
Please support me by ADVERTISING!
Serving a Pleasant Blend of Yesterday, Today, and Tomorrow™ Please Support My Advertisers!
   Formulas & Data
Electronics | RF
Mathematics
Mechanics | Physics
     AI-Generated
     Technical Data
Pioneers | Society
Companies | Parts
Principles | Assns


 About | Sitemap
Homepage Archive
        Resources
Articles, Forums Calculators, Radar
Magazines, Museum
Radio Service Data
Software, Videos
     Entertainment
Crosswords, Humor Cogitations, Podcast
Quotes, Quizzes
   Parts & Services
1000s of Listings
 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

Software: RF Cascade Workbook
RF Stencils Visio | RF Symbols Visio
RF Symbols Office | Cafe Press
Espresso Engineering Workbook

Aegis Power  |  Alliance Test
Centric RF  |  Empower RF
ISOTEC  |  Reactel  |  RFCT
San Fran Circuits

RF Cascade Workbook 2018 by RF Cafe

Windfreak Technologies Frequency Synthesizers - RF Cafe

Noisecom

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

Innovative Power Products (IPP) 90 deg Hybrid Couplers

Inserting and Deleting Columns
RF Cascade Workbook 2018™ v1.00

RF Cascade Workbook 2018™ has all calculations on a single worksheet to make inserting and deleting component columns simple - well, relatively simple. There are certain rules that need to be followed in order to assure that all the formulas retain their proper references to other cells' values. RF Cascade Workbook 2018™ does not require any special steps that are not common to Excel or other spreadsheets, but it is probably safe to say that most users are either not familiar at all with the procedure, or do not use it often enough to be confident without a reminder. I have outlined the necessary steps and done screen captures as needed.

* Rather than Deleting columns, I recommend using Excel's "Hide" feature to prevent system component columns from appearing on the screen or on the charts. A hidden cell's contents is still included in the cascade calculations, it just is not shown on the screen.

Note: When columns are inserted or deleted, Excel conveniently adds or deletes, respectively, data sets to the Line Charts. Scatter Charts do not automatically add or delete data sets. Fortunately, the only Scatter Chart is the Frequency Response graph that plots signal power levels inclusive of filter rejection. Therefore, it will be necessary to separately modify the Frequency Response chart after adding or deleting columns.

NOTICE: I highly recommend that you make a backup of the original version of your workbook before adding or deleting columns just in case something goes awry. Excel only allows you to Undo edits up through the last time you save the file, so if you make changes and save the file, then make more changes and discover that your mistake occurred prior to that last save, you're out of luck. That's an Excel thing, not a RF Cascade Workbook 2018 thing.

** Unprotecting RF Cascade Workbook 2018™ relieves RF Cafe of responsibility for the integrity of the file. **

Inserting Columns

Being a firm believer in the adage that says a picture is worth a thousand words, these annotated screen shots outline the complete series of steps required to assure successful insertion of component columns. Stray at your own risk. Don't forget to make a backup copy first!

Inserting Columns (1) in RF Cascade Workbook 2018 - RF Cafe

Inserting Columns (2) in RF Cascade Workbook 2018 - RF Cafe

Inserting Columns (3) in RF Cascade Workbook 2018 - RF Cafe

Inserting Columns (4) in RF Cascade Workbook 2018 - RF Cafe

Inserting Columns (5) in RF Cascade Workbook 2018 - RF Cafe

Deleting Columns

Before detailing the procedure for deleting columns, I would like to suggest that rather than deleting columns that you instead set all the input parameters for the column(s) to null values that do not affect the overall cascade calculation results, and then simply Hide the column(s). Hiding a column causes it to disappear from the spreadsheet and any values from a hidden column do not appear on the charts. You can Unhide column(s) later if the space is needed. I provide a screen shot of the suggested null values to use.

However, if you still prefer to deleted unused columns, the following procedure gets the job done.

Deleting Columns (1) in RF Cascade Workbook 2018 - RF Cafe

Deleting Columns (2) in RF Cascade Workbook 2018 - RF Cafe

Deleting Columns (3) in RF Cascade Workbook 2018 - RF Cafe

Deleting Columns (4) in RF Cascade Workbook 2018 - RF Cafe

Deleting Columns (5) in RF Cascade Workbook 2018 - RF Cafe

 

 

Posted June 8, 2018

Innovative Power Products (IPP) 90 deg Hybrid Couplers
Innovative Power Products Passive RF Products - RF Cafe

Amplifier Solutions Corporation (ASC) - RF Cafe

Cafe Press