Thank you for visiting RF Cafe!

Your RF Cafe
Progenitor & Webmaster

Click here to read about RF CafeView the YouTube RF Cafe Intro VideoKirt Blattenberger
BSEE
KB3UON
EIEIO

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 Cafe Software

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

RF Cascade Workbook© 2005 User’s Guide - Chapter 2

Chapter 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13

Version 1.11
by Kirt Blattenberger
RF Cafe Website
(www.rfcafe.com)

Chapter 2

2    Adding or Deleting Rows


Adding or deleting a row (or rows) is a simple process, but care must be taken to be certain that the cascaded formula sequences are not lost. Here is a step by step method that assures cascade integrity. One simple rule applies to adding and deleting rows:


Never Select the First Two Rows Or the Last Two Rows


There are other methods of adding or deleting rows, but this one seems to be the most foolproof. When adding or deleting rows, be sure to make the same changes to all worksheets that tie into the main “Inband” worksheet: “Filter-Mixer,” “DC Power,” and BOM.”


2.1    Adding Rows

RF Cafe: RF Cascade Workbook 2005 screen

RF Cafe: RF Cascade Workbook 2005 screen

RF Cafe: RF Cascade Workbook 2005 screen

-- Use the Ctrl+C keyboard combination to copy the rows to the Windows clipboard.

RF Cafe: RF Cascade Workbook 2005 screen

-- Use the Ctrl+V keyboard combination to paste the rows into the worksheet from the Windows clipboard.

RF Cafe: RF Cascade Workbook 2005 screen


Re-number the “Item” column and enter the new component parameters. Now perform the identical series of operations on the “Filter-Mixer,” “DC Power,” and “BOM” worksheets.

2.2    Deleting Rows

RF Cafe: RF Cascade Workbook 2005 screen

RF Cafe: RF Cascade Workbook 2005 screen

RF Cafe: RF Cascade Workbook 2005 screen

-- Use the Ctrl+C keyboard combination to copy the rows to the Windows clipboard.

RF Cafe: RF Cascade Workbook 2005 screen

-- Use the Ctrl+V keyboard combination to paste the rows into the worksheet from the Windows clipboard.

RF Cafe: RF Cascade Workbook 2005 screen

Re-number the “Item” column and enter the new component parameters. Now perform the identical series of operations on the “Filter-Mixer,” “DC Power,” and “BOM” worksheets.

 

Chapter 1, 2, 3, 4, 5, 6, 7, 8,
        9, 10, 11, 12, 13

Version 1.11
by Kirt Blattenberger
RF Cafe Website
(www.rfcafe.com)

Chapter 2

 
Copyright 1996 - 2016
Webmaster:  Kirt Blattenberger, BSEE - KB3UON

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