Thank you for visiting RF Cafe! 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 Engineer Jobs Twitter LinkedIn Crosswords Engineering Humor Kirt's Cogitations Engineering Event Calendar RF Engineering Quizzes AN/MPN-14 Radar 5CCG Notable Quotes App Notes Calculators Education Magazines Software,T-Shirts,Coffee Mugs Articles - submitted by RF Cafe visitors Simulators Technical Writings RF Cafe Archives Test Notes Wireless System Designer RF Stencils for Visio Shapes for Word Search RF Cafe Sitemap Advertising Facebook RF Cafe Forums RF Cafe Homepage Thank you for visiting RF Cafe!

Inserting and Deleting Columns
Wireless System Designer™ v1.00

Wireless System Designer™ 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. Wireless System Designer™ 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 Wireless System Designer thing.

** Unprotecting Wireless System Designer™ 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 Wireless System Designer - RF Cafe

Inserting Columns (2) in Wireless System Designer - RF Cafe

Inserting Columns (3) in Wireless System Designer - RF Cafe

Inserting Columns (4) in Wireless System Designer - RF Cafe

Inserting Columns (5) in Wireless System Designer - 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 Wireless System Designer - RF Cafe

Deleting Columns (2) in Wireless System Designer - RF Cafe

Deleting Columns (3) in Wireless System Designer - RF Cafe

Deleting Columns (4) in Wireless System Designer - RF Cafe

Deleting Columns (5) in Wireless System Designer - RF Cafe

 

 

Posted June 14, 2017

RF Cafe Software

   Wireless System Designer - RF Cafe
Wireless System Designer

RF & EE Symbols Word
RF Stencils for Visio
Calculator Workbook
RF Workbench
Smith Chartâ„¢ for Visio
Smith Chartâ„¢ for Excel

About RF Cafe

Kirt Blattenberger - RF Cafe WebmasterCopyright
1996 - 2022
Webmaster:
Kirt Blattenberger,
 BSEE - KB3UON

RF Cafe began life in 1996 as "RF Tools" in an AOL screen name web space totaling 2 MB. Its primary purpose was to provide me with ready access to commonly needed formulas and reference material while performing my work as an RF system and circuit design engineer. The Internet was still largely an unknown entity at the time and not much was available in the form of WYSIWYG ...

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

My Hobby Website:
 AirplanesAndRockets.com

Try Using SEARCH
to Find What You Need. 
There are 1,000s of Pages Indexed on RF Cafe !

height-line