The Department of Transport had an existing traffic management system that produced data, but the data needed further manipulation to provide their customers with the information in their prescribed format.

The Solution

We developed a series of Excel spreadsheets that would import the data from a text file, using macros developed with Visual Basic for Applications we could analyze and consolidate the data and display it in spreadsheets in the format the client needed.

Benefits Attained

• Increased productivity
• Ease of use
• Reduced time
• Worked with the existing system