About this document
Excel Macro for Data Processing by Ranggi P. Nugraha is a document available to read on EtoBox.
The document contains VBA code that performs the following: 1. Opens CSV files containing capacity data, extracts the maximum traffic channel (TC) value for each base station (BSC) and date, and copies this to a template spreadsheet. 2. Calculates the average of the top 3 maximum TC values for each BSC and copies it to the template. 3. Contains additional subroutines to process capacity data for spots east and west separately, as well as to analyze historical traffic data between start and end dates.
- Author
- Ranggi P. Nugraha
- Language
- EN