Introduction
The requirement is for a set of Microsoft Excel Macros to import data from proxy server log files into a Microsoft Excel Workbook and to produce reports and charts based on the imported data.
The Macros may be written in VBA and the result will be a single .XLS workbook containing the macros which would be triggered by either a hot key or a macro button.
The project will be in two stages. First developing the
Macro(s) to import the raw log file data into an Excel Workbook and secondly developing the Macro(s) to process this imported data to produce a number of charts based on the log file data.
Background
The company’s internal proxy servers produces log files which detail fetch request made by user PCs within the company network to servers on the internet via the proxy server. These proxy log files contain many lines, one for each fetch request. The log files are in plain text and each line contains the following fields prefaced by the identifier then the data and separated by a space. Records are separated by a newline character.
1 id= Proxy Server ID