1711阅读
2回复

[分享]Radio frequency and microwave electronics

巍巍昆仑雪莲花

UID ：20062

注册：2008-10-25
登录：2018-10-28
发帖：4586
等级：九级仿真大师

0楼发表于: 2012-11-29 14:10:59

Bound into the back of each textbook, is a CD containing data files in the form of an electronic book (E-book), which contains all the numerical examples from the text. The solutions are programmed using Visual Basic software, which is a built-in feature of the "Microsoft ExcelÒ" application software.

I) Main Features
The main features of this CD are as follows:
a) It is a powerful interactive tool for learning the textbook content and also for solving numerical problems.
b) The CD includes 90 solved problems based on numerical examples in the book.
c) The big advantage of the interactive software tool is its use of "live math". Every number and formula is interactive and the reader can change the starting parameters of a problem and watch as the final results change before one's eyes. This feature allows one to experiment with every number, formula, etc., and to explore many "what if " scenarios.
d) Each solved problem becomes a worksheet, where one can modify to solve dozens of related problems.
e) The electronic book takes advantage of the powerful Microsoft ExcelÒ environment to perform many tedious and complicated RF and microwave design calculations (usually involving complex numbers), thus allowing the student to focus on the essential concepts.
f) This is an excellent tool for students, engineers and educators, to:
1) Understand the fundamentals and practical concepts of RF and Microwaves, and,
2) Encourage applications and new RF/Microwave circuit designs using the concepts presented in the book.

Return to Table of Contents

II) How to start the program
The following steps need to be carried out before the "contents of the CD-ROM" is ready for use.
a)      As the very first step, the user should decide whether to                                                              1)     Read all the files directly from the CD-ROM or,
2)      Create a folder called “E-book” in the C: Drive. Copy the entire content of the CD-ROM into the folder entitled "E-book".
b)      Open Microsoft Excel 2000 software (or Excel 97 with SR-1 or SR-2 revision) and open the "E-book" folder. You may begin the program by double clicking on the "Table of Contents" file. (If you have problems running the CD-ROM under Excel 2000, download and install SR-1A revision from www.microsoft.com .)
Note: As a shortcut, you may double click on the “Table of Contents” file directly without opening the Excel software.
c)      Once the "Table of Contents" file opens up, you need to locate and click on the "About the CD" file at the top, to open up its contents.
d)      Carefully read all the information in the "About the CD" file, close it by either a) holding ALT+TAB keys and choosing EXCEL, or b) clicking on "Return to Table of Contents" ARROW to return to the E-book table of contents.
e)      Turn on both “Analysis Toolpack” and “Analysis Toolpack - VBA” as discussed below. Proceed to the desired example by clicking on it and selecting the "Enable Macros".

III) How to use the E-book software
Before proceeding to the worked-out examples, we need to select from the toolbar menu “Tools,” “Add-ins,” and from the dialog box select both “Analysis Toolpack” and “Analysis Toolpack - VBA” in order to set up the software properly.

When a particular example is selected and clicked for interactive use, the user will encounter a dialogue box wherein the following must be selected:
"Enable Macros"
Once the example is opened, then one observes that each numerical example consists of several sections, which can be briefly summarized as:

Return to Table of Contents

Problem statement: Is word for word text taken from the book describing the nature of the problem.
Input data: This section provides all of the manipulatable data, which the reader may have at one' own disposal to vary interactively and experiment with, in order to examine different scenarios and obtain answers to "what if" questions. Inside the input data box, the user may change only the values of the parameters , but not any of the units. The user should type the new value in the appropriate box and press "Enter/Return" to observe the desired change. This is the only place where the user is allowed to make any changes to the software.

Return toTable of Contents.xls Table of Contents

Output data: This section contains step by step solution of the problem along with easy explanations provided for quick assimilation of the results. Most of the complicated calculations are done in complex numbers using visual basic programming technique, that is part and parcel of Microsoft ExcelÒ software.
Problem format and color codes: All problems are formatted and color-coded in the same manner throughout the software. This is done for user's easy recognition and reference, delineated as follows:
                                                 Color code
Example xx.xx                                Cyan                                                       Problem text                                        Tan
Solution:                                         Navy Blue
              Input data
                     heading                                Red
                     content                               Turquoise/Brown
              Output data
                     Heading                                Sky Blue
                     Content                                Yellow
                     Interactive Answers           Green
                     Caution                Red
                     Note/conclusion           Pink

Return to Table of Contents

IV) Software knowledge required
A rudimentary knowledge of Microsoft ExcelÒ is required to operate the software successfully. The user does not need to know Visual Basic programming techniques to work with the examples' solutions interactively.

V) Minimum Software/Hardware Requirements
The user needs to have the following:
a)      Hardware requirements-A personal computer (PC) with a Pentium chip preferably.
b)      Software requirements- Windows 95/98/NT operating system and Microsoft Excel 2000 (or Excel 97 with: SR-1 or SR-2 revisions). If you have problems running the CD-ROM under Excel 2000, download and install SR-1A Revision.
Note 1: To obtain any of the Service Releases, (SR-1 or SR-2 for Excel 97 or SR-1A for Excel 2000) the user needs to download the required software from the following Website:
http://www.microsoft.com/

Return toTable of Contents.xls Table of Contents

Go to the search link and find the SR-1, SR-2 (Excel 97) or SR-1A (Excel 2000) revision, which is suitable to the version of Microsoft Office that you own. Download and install the SR-1, SR-2 or SR-1A upgrade to repair all known bugs in Microsoft Excel 97 or Excel 2000. Without this correction, Excel 97 (or Excel 2000) gives incomplete values for the worked-out examples in the CD-ROM.

VI) Troubleshooting Problems
If the following probl ..

未注册仅能浏览部分内容，查看全部内容及附件请先登录或注册