Homepage - RF Cafe
Webmaster: Kirt Blattenberger | KB3UON | Sitemap | ©1996-2014     Visit RF Cafe on
      Menu below is just a small sample of what is here!          Visit RF Cafe on Facebook Visit RF Cafe on Twitter Visit RF Cafe on LinkedIn
Custom Search
More than 10,000 searchable pages indexed.
•−•  ••−•    −•−•  •−  ••−•  •
RF Cafe Morse Code >Hear It<

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

 
A Disruptive Web Presence

Custom Search
Over 10,000 pages indexed! (none duped or pirated)

Read About RF Cafe
Webmaster: Kirt Blattenberger
    KB3UON

RF Cafe Software

RF Cascade Workbook
RF Cascade Workbook is a very extensive system cascaded component Excel workbook that includes the standard Gain, NF, IP2, IP3, Psat calculations, input & output VSWR, noise BW, min/max tolerance, DC power cauculations, graphing of all RF parameters, and has a graphical block diagram tool. An extensive User's Guide is also included. - Only $35.
RF system analysis including
frequency conversion & filters

RF & EE Symbols Word
RF Stencils for Visio

Product & Service Directory
Personally Selected Manufacturers
RF Cafe T-Shirts & Mugs

RF Cafe Software

Calculator Workbook
RF Workbench
Smith Chart™ for Visio
Smith Chart™ for Excel
Your RF Cafe Progenitor & Webmaster
Click here to read about RF CafeKirt Blattenberger... single-handedly redefining what an
                                 engineering website should be.

View the YouTube RF Cafe Intro Video Carpe Diem! (Seize the Day!)

5CCG (5th MOB): My USAF radar shop

Airplanes and Rockets: My personal hobby website

Equine Kingdom: My daughter Sally's horse riding website