| Please Support My Advertisers |
|
|
| Newest Engineering Jobs on the RF Cafe Forums |
| Newest Topics on the RF Cafe Forums |
|
RF Cafe Software
RF Cascade Workbook Hobby & Fun Airplanes and Rockets: My personal hobby website Equine Kingdom: My daughter Sally's horse riding business website - lots of info Doggy Dynasty - My son-in-law's dog training business |
Your Host
Kirt
Blattenberger... single-handedly
redefining what an engineering website should be.
Carpe Diem!
(Seize the Day!)
RF Cascade Workbook© 2005 User’s Guide
Version 1.11 by Kirt Blattenberger RF Cafe Website (www.rfcafe.com) | Chapter 1 | |
Important: You must select “Enable Macros” when opening RF Cascade Workbook 2005, | ||
| ||
Copyright 2005 - Kirt Blattenberger, RF Cafe Website. | ||
Thank you for your support. Your contributions help keep RF Cafe online. | ||
Table of Contents | ||
| ||
1 Introduction | ||
RF Cascade Workbook is built on a foundation of RF Cascade Workbook 2003, and now features frequency calculations for filters and mixers. Also added are calculations for 2nd-order intermodulation products As provided, there are 24 component positions; however, the number of components (and frequency conversions) possible is limited only by the capability of Excel. Most of the formulas are contained in VBA routines to maintain uncluttered cells and simple manipulation. This is especially helpful in the case of conditional formulas. Expansion of the workbook to include custom calculations is a simple matter. | ||
All of the formulas used in RF Cascade Workbook are presented in the following paragraphs to assist in understanding the operation of the spreadsheet. Excel has a very extensive Help section for standard functions and VBA code writing. | ||
The bottom worksheet tab image shown below is the default set of pages. Worksheets with parameter plots can be added or deleted as necessary, and the “DC Power,” “BOM,” and the “User” worksheets can be eliminated entirely without affecting the primary functions. The “Filter-Mixer” worksheet contains Noise Bandwidth and Frequency Units parameters that are also used on the “Inband” worksheet, and therefore must not be deleted. | ||
| ||
1.1 Terms of Use | ||
You may freely modify RF Cascade Workbook for your own use; however, you may not redistribute it under a new name after making changes. Furthermore, you may not redistribute RF Cascade Workbook for any reason without the written permission of Kirt Blattenberger/RF Cafe, because this is licensed software protected under U.S. copyright. RF Cascade Workbook is NOT shareware or freeware. | ||
Your use of RF Cascade Workbook attests to your agreement to hold harmless Kirt Blattenberger/RF Cafe and his assigns for any losses that may occur as a result of the use of RF Cascade Workbook. Every iota of code is available for review and discernment by the user, who is consequently solely responsible for all results. RF Cascade Workbook has been tested and is believed to be free of errors upon release. | ||
Formulas used in RF Cascade Workbook are not proprietary and have been obtained from multiple publicly available sources. All are ideal implementations without any personal “adjustments.” Min/max calculations are constructed based on the author’s notion of what constitutes conditions that would generate extreme cases, but the user’s experience or specific circumstances might require the formula variable combinations to be rearranged. | ||
Prior to using this workbook for the first time, please be sure to create a backup copy so the original version is always accessible. If you loose track of the original (I’ve done that sort of thing, too) and I have your name on file as a legal licensee, I will gladly e mail a replacement version upon request. | ||
1.2 VBA Code Access | ||
Access to the VBA code is made using the “Tools->Macro->Visual Basic Editor” menu selection (Figure 1), and choosing the relevant page. Note that different versions of Excel might have slightly different menu structures, so your menu might look different from Figure 1. | ||
| ||
Figure 1 VBA Menu Access | ||
Figure 2 shows a portion of the VBA code window, where you can make changes to existing functions, or add new ones of your own. The “Option Explicit” directive forces the declaration of all variables, which aids during the debug process by eliminating the difficult to find misspelled variable or constant that is so easy to have in VB. | ||
| ||
Figure 2 VBA Code Window | ||
Version 1.11 by Kirt Blattenberger RF Cafe Website (www.rfcafe.com) | Chapter 1 | |
| RF Cafe's Component Directory Personally Selected |
RF Cafe's Engineering Forums Join the Conversation |
||||
|
|||||