TABLE OF CONTENTS The VBA custom radar functions and supporting material described in this book are provided on a computer disk supplied with the book. The disk contains three files:
Radar Functions 2nd Ed.xla. This is an Excel Add-In file [ [1] , pp. 341 351], containing the VBA code that implements the 43 custom radar functions described in this book.
Function Test 2nd Ed.xls. This is an Excel file that contains an example exercise of each of the custom radar functions. The Function Arguments parameter boxes for these are illustrated in the sections of this book that describe the functions. The function inputs may be changed to see their impact on the function result.
Example Problems 2nd Ed.xls. This is an Excel file that contains the spreadsheet analysis solutions to the example Problems given in Chapter 12. These worksheets and the plots of results are illustrated in Chapter 12.
The 43 custom radar functions, and the solutions that each calculate, are given in Table C.1, grouped by topic. The section of the book in which each is described, and the VBA Module number in the Add-In file where each function is located, are also given.
| Topic and VBA module | Section | Function Name | Calculates |
|---|---|---|---|
| Radar equation | 5.7.1 | SNR_dB | S/N for given radar and target parameters |
| VBA Module 1 | |||
| 5.7.2 | Range_km | Radar range for given radar and target parameters | |
| 5.7.3 | Integrated_SNR_dB | Integrated S/N for pulse integration |
