MS Office Automation

Many businesses collect various kinds of information from their staff and from other sources, combine the data, and generate reports to allow management to make strategic business decisions.

Unfortunately, the information may come in as many different forms as there are sources... spreadsheets formatted whatever way an individual decided; incompatible units; data categorized and subtotaled under different rules. It becomes a nightmare for the person who is given the task of generating the summary reports.

A good way to solve this problem and to make the entire process much more efficient is to design a database management system to collect the data under a standard set of rules, and to write automation code to take care of all the details of extracting and reporting, based on a simple report generation user interface.

Here is an example...

Instead of manually bridging a pile of incompatible inputs together...

Everyone enters compatible data by using a common database.

Either forms (Windows GUI) or Web interfaces can be used, depending on whether users are colocated or in different locations.

Once the data is properly stored, the rest is automatic.

Since all of the data is in a compatible format, and was validated while being input, software can process it, perform spreadsheet calculations, and generate tables and graphs.

Instead of working separately with applications such as Access, Excel, and PowerPoint, the entire process looks like one application to the user.

If you use MS Office applications, and would like to streamline your data gathering and reporting, contact us. We can help!