|
这个软件是与同名书配套的CD盘,在Excell环境下运行,对于初学者来说也有点用(注:软件是英文),内容大概是:一个问题,可以输入数字,软件计算出结果。不知道大家喜不喜欢,希望对有的同志有用。。。
【文件名】:09330@52RD_射频与微波电子学软件.rar
【格 式】:rar
【大 小】:1358K
【简 介】:
About the CD...
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.
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:
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.
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
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/
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 problems occur, you may correct them as follows:
a) If ”######” appears in place of a numerical answer, it means that the cell is too small and you have to resize that cell in order to display the final numerical result correctly. To resize the cell, go to the Excel toolbar menu and select “Format,” “Column,” and “Autofit Selection.”
b) If “#VALUE!” appears, it means any of the following conditions has occurred:
--Divide by zero.
--Negative number under a square-root symbol.
--The number is out of range.
--Excel 97 software is not used with SR-1 or SR-2 revision.
--Excel 2000 software is not used with SR-1A Revision.
--The “Analysis Toolpack” and “Analysis Toolpack - VBA” are not turned on*.
*You need to select from the toolbar menu “Tools,” “Add-ins,” and from the dialog box select “Analysis Toolpack” and “Analysis Toolpack - VBA” in order to set up the software properly. |
|