Theoretical normalized site attenuation calculations by spreadsheet analysis

This paper describes an analysis methodology that implements the theoretical normalized site attenuation (NSA) model into a standard electronic spreadsheet program, such as Microsoft Excel, that can calculate and plot the exact theoretical NSA value for any given frequency of interest. The theoretical NSA is referenced in ANSIC63.4(1992) and is discussed in numerous papers in the open literature. The mathematical model for the theoretical NSA consists of a set of complex equations for horizontal and vertical polarization and is best suited for calculation via computer automation. The spreadsheet analysis technique addressed in this paper has several advantages: (1) the popularity of spreadsheets today provides an easy to use software platform that can be utilized to fully automate the complex theoretical NSA calculations,( 2) the spreadsheet provides an open framework whereby all areas of the model are open for visual inspection, and (3) the spreadsheet model can be used for “what-if” scenarios whereby the test site input parameters are easily modified and the calculations re-pun for new test site configurations