USING EXCEL MACROS FOR CHARTING

Abstract

This paper introduces a set of macros that automate the importing of antenna data into Excel and charting that data. These macros (as discussed here) import data from a ViaSat ACUs (Antenna Control Unit) and a TCS ACU (Telemetry & Communications Systems Inc). After the import is complete, the macros can build a set of charts, all formatted and labeled in a predetermined and standard manner. A task that may take half a day or more can be completed in minutes. The concept and layout of the macros lend them to quick adaptation to your data. In scenarios of “test and collect” followed by “import and chart”, the data can be imported and charted within the minute.