Theoretical normalized site attenuation calculations by spreadsheetanalysis

摘要

This paper describes an analysis methodology that implements thetheoretical normalized site attenuation (NSA) model into a standardelectronic spreadsheet program, such as Microsoft Excel, that cancalculate and plot the exact theoretical NSA value for any givenfrequency of interest. The theoretical NSA is referenced inANSIC63.4(1992) and is discussed in numerous papers in the openliterature. The mathematical model for the theoretical NSA consists of aset of complex equations for horizontal and vertical polarization and isbest suited for calculation via computer automation. The spreadsheetanalysis technique addressed in this paper has several advantages: (1)the popularity of spreadsheets today provides an easy to use softwareplatform that can be utilized to fully automate the complex theoreticalNSA calculations,( 2) the spreadsheet provides an open framework wherebyall areas of the model are open for visual inspection, and (3) thespreadsheet model can be used for “what-if” scenarioswhereby the test site input parameters are easily modified and thecalculations re-pun for new test site configurations