AutoSoft Systems
        AutoSoft Systems 2 Round Hill Court
        East Greenwich, RI 02818
        401.884.5653 Fax
                        401.996.3631 Cell
AMDG       Decision Ready Information! autosoft@aol.com
Commercial & custom multi-user computer software for a variety of applications including performance metrics, statistical analysis, data extraction and merger from multiple large databases, computer simulation and management information systems.  Founded in 1982.
We know Excel! Whenever possible, Excel is the user interface, VBA is the programming language, ODBC connects to the database of your choice.
Home About Us Literature Wire & Cable Pharmaceutical & Biotech Construction Management Commercial Products Custom Solutions
Contact Us Events Downloads
TrackwiseŽ Quality Management Tracking
TrackwiseŽ is a trademark of Sparta Systems
AutoSoft is not affiliated with Sparta Systems.
TrackwiseŽ does a great job in managing NCs (Non Conformances) and CAPAs (Corrective Actions / Preventative Actions).  As with most of these types of tools, the reporting features are limited.  The standard solutions are tools like Brio or Cognos, which allow the user to extract a report which can eventually wind up in Excel, but the user has to manually input a series of parameters, manually run the report, and manually move the data into Excel for further manual manipulation to be able to draw conclusions.  Dr. Serdakowski's approach here is like it is everywhere: 
Eliminate the clerical time, maximize the analytical time, get people home on time.
The main screen of this module is:
The first step in the process is to extract the information from TrackwiseŽ. This can be done in 3 different ways:  
- Direct ODBC query  
- Import from a Brio export file  
- Import from a Cognos export file  
In any case, a log is kept of what was imported, who imported the data and when it was imported:
All open records are visible on the "Open" worksheet:
All records are included on the "All" worksheet:
There are a number of reports that provide color coded metrics.  Here is one of them:
To facilitate reporting, there is even an option to automatically generate PowerPoint presentations, with one graph on each slide (a real time saver!).
Metrics are automatically color coded depending upon hitting or missing defined goals:
The ability to spot unfavorable trends before they get out of hand is discussed on the Trending web page.
Click here to jump to the Trending web page
AutoSoft Systems | 2 Round Hill Court, East Greenwich, Rhode Island, USA 02818 | 401.885.3631 | Fax: 401.884.5653 | Mobile: 401.996.3631 
This web page was last updated at 02/21/2014 07:49 AM and is written in EXCEL!
AXIOM is a Trademark of Consona - USYS is a Trademark of Zumbach - AutoSoft Systems is not affiliated with Consona nor Zumbach