Microsoft Excel Automation


ABCDEF's primary goal is to simplify your business process by making your computer investment responsible for all repetitive data processing tasks. Reducing the human component in data analysis increases consistency and repeatability and reduces your development costs. We accomplish this by using Microsoft Excel to automate repetitive data input, analysis, display in the required format, printing and sharing on a network. One hour of complex data processing performed manually can be reduced to only five seconds on a typical Pentium III or IV.

Starting with well designed user interface screens and intelligent defaults, ABCDEF creates systems that are simple to configure and to operate. Adding options such as barcode readers can reduce set-up time and typing errors. To ensure proper use of the system, both written documentation and online help screens can be provided.

Inputs can be from DAQ boards, test equipment, user entry, bar code wands, existing data files or databases. Data can then be qualified, filtered, moved to the input area and summarized. Most complex analysis can be performed automatically until the final results are determined. This can reduce the overall time and costs to achieve results.

The results should be easy to understand and easy to access. Statistical analysis, pass/fail, trending, projections, summaries, and graphs can be created during the test. With a network interface, all results can be available immediately anywhere across the WAN. A central database can hold both test parameters and data in ASCII, Excel, XML files or in a SQL server. Selective queries can then be reloaded directly into Excel for final processing or presentation. Thorough testing of the application and/or test system ensures that the results are reliable and accurate.

Input Automation Benefits
Data Acquisition
Data Input
Data File Parsing
Barcode Wand Entry
Database Lookup
Intelligent Data Rejection
Data Qualification
Output Automation Benefits
Data Display
Data Analysis
Update SQL Databases
XML Conversion
Complex Charts
Pivot Tables
Printouts



Last updated on: March 20th, 2017