Tactical data solutions: Large government agency

2010-09-01

Our tactical data solution consolidated thousands of spreadsheets for a large government agency

We were approached by our client who had an urgent need to consolidate data from thousands of spreadsheets for future management reporting.

We delivered a flexible Microsoft Access database – on time, and on budget – to automatically import the spreadsheet data and consolidate it for reporting.

Features included:

• an intuitive user-interface;
• the ability to cope with multiple versions of the spreadsheet forms;
• an easy to follow duplicate resolution process; and
• a mapping function to ensure future spreadsheet versions could be consolidated.