Tactical data solutions: Large government agency


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.
Wednesday, September 1, 2010 In: Hot Topics Comments (None)