DataGrator Suite

The Issue:

The client had a large dataset of survey results in CSV format, and needed a way to massage the CSV file into a simplified version and import the result into Excel for further processing.  Once imported into Excel, the client needed a way to to aggregate the survey results into standardized results for reporting to their end-customer.

The Solution:

A VBA program which provided an interactive GUI was written to convert the CSV files, and then, once that was accomplished, another VBA program was written to consolidate/aggregate that data into a usable format.  Finally, the normalized and consolidated data was placed into a pivot table for output so the user could report the result to the end customer.

 

About Steven Britton

Steve is a freelance programmer, partial billionaire, dad, Recovering Atheist, Conservative, and occasionally prolific blogger.