Search RFC: |                                  
Please support my efforts by ADVERTISING!
Serving a Pleasant Blend of Yesterday,
Today, and Tomorrow™

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

Formulas | Data

Electronics | RF
Mathematics
Mechanics
Physics


Calvin & Phineas

kmblatt83@aol.com

Archive | Sitemap

Resources

Articles | Radar
Cogitations
Magazines | AI
RF Museum
Software | Videos
Radio Service
Tech Notes

Entertainment

Crosswords
Humor | Podcasts
Quotes | Quizzes
Tech Comics

Parts | Services

1000s of Listings


About RF Cafe

Software: RF Cascade Workbook | RF Symbols for Office | RF Symbols & Stencils for Visio | Espresso Workbook
Please Support My Advertisers!
Transcat | Axiom Test Equipment - RF Cafe
Aegis Power | Centric RF | RFCT
Empower RF | Reactel | SF Circuits

Alliance Test | Isotec
RF Electronic Stencils Symbols Visio Shapes Office

Johanson Prototyping Kit - RF Cafe

Tennode RF Connectors and Cables - RF Cafe
Anritsu MA25211A P25 Radio Auto Test & Alignment System - RF Cafe

Amplifier Solutions Corporation (ASC) - RF Cafe

Johanson Technology Antennas - RF Cafe

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

Modular Components - RF Cafe

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

minimum height spacer

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