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 Manufacturers & Services Consultants Engineer Jobs Twitter LinkedIn Advertise on RF Cafe! Engineering Books Crosswords Engineering Humor Kirt's Cogitations Engineering Event Calendar Day in History RF Engineering Quizzes AN/MPN-14 Radar 5CCG Notable Quotes App Notes Bookstore Calculators Education Engineering Organizations Magazines Software,T-Shirts,Coffee Mugs Articles - submitted by RF Cafe visitors Simulators Technical Writings Advertisers Websites RF Cafe Archives Test Notes Slide Rules RF Cascade Workbook RF Stencils for Visio Shapes for Word Thank you for visiting RF Cafe!

RF Cafe Software

RF Cascade Worbook
 RF Cascade Workbook 2005 - RF Cafe
Calculator Workbook
RF Workbench
Smith Chart™ for Visio
Smith Chart™ for Excel
RF & EE Symbols Word
RF Stencils for Visio

Your RF Cafe
Progenitor & Webmaster

Click here to read about RF CafeKirt Blattenberger

Carpe Diem!
(Seize the Day!)

5th MOB:
My USAF radar shop

Airplanes and Rockets:
My personal hobby website

Equine Kingdom:
My daughter Sally's horse riding website

RF Cascade Workbook 2004 User’s Guide© - Chapter 3

Chapter 1, 2, 3, 4, 5,
             6, 7, 8, 9, 10
Version 1.01
by Kirt Blattenberger
RF Cafe Website
Chapter 3
3    Adding or Deleting Rows & Columns
Adding or deleting rows or columns or even cells within cell range A1:P151 is not for the faint of heart, because doing so will require fairly extensive modification of the VBA code. This is why three versions of RF Cascade Workbook 2004 are provided, with 6, 12, and 18 component positions pre coded. If more positions are required due to a large system, then expand the workbook very carefully by inspecting the VBA code and making the necessary modifications. Doing so is really quite simple, but attention to details is required to make certain that all of the references to chart series ranges are kept in sync, and that the added component graphics handling routines function properly.

An alternative to adding components to the worksheet would be to create separate workbook(s) for
subsystem(s), then either transfer the subsystem results into the main workbook in the space of one component position, or dynamically reference the separate workbook(s) from within the main workbook.

Figure 4 illustrates how to dynamically reference an external subsystem output cell value. The easiest method is to open the main workbook and external subsystem workbooks concurrently, then use the “Window->Arrange…-->Horizontal” menu selection to configure the windows as shown. To reference the external Gain value as shown in the example, insert the cursor in the K4 cell in the main workbook and type the equals (=) sign, then click the cursor in the O36 cell in the subsystem workbook, then hit the Enter key. That’s all there is to it. Reference all the other external cells similarly. For the “+/-“ values, you will have to do something like write an equation that takes the average of the Max and Min values from the external workbook in rows 121 through 148 (they are typically nearly symmetrical, though).

RF Cafe -

Figure 4    How To Reference An External Subsystem Workbook
It is also possible to link the entire realm of calculated cascaded values from an external subsystem workbook through proper referencing of cells in the “Calculated Output Values” area, but the necessary steps will not be covered here. Bookkeeping gets to be a real chore, and broken links can be very frustrating under the circumstances.
Chapter 1, 2, 3, 4, 5,
             6, 7, 8, 9, 10
Version 1.01
by Kirt Blattenberger
RF Cafe Website
Chapter 3

Try Using SEARCH to Find What You Need.  >10,000 Pages Indexed on RF Cafe !

Copyright 1996 - 2016
Webmaster:  Kirt Blattenberger, BSEE - KB3UON
Family Websites:  Airplanes and Rockets | Equine Kingdom

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