eye.jpg
 
                      AutoSoft Systems
        AutoSoft Systems 2 Round Hill Court
        East Greenwich, RI 02818
        401.885.3631
        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
                            AMDG
MCj04415270000[1] MCj04415170000[1]
Trackwise® Non Conformance Trending
                             
Trackwise® is a trademark of Sparta Systems
AutoSoft is not affiliated with Sparta Systems.
This software tool has been validated & is used by a major International Biotech company
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.  A smooth running operation only stays that way if undesirable trends are "nipped in the bud".  Dr. Serdakowski has developed and implemented a Trending program based on tried and true analytic techniques that provide an "Early Warning System" to unfavorable trends before they can get out of hand.  
Click here to request a copy of a white paper discussing Dr. Serdakowski's algorithm
Defining this algorithm is only half the battle.  Remember AutoSoft's goal:
Eliminate the clerical time, maximize the analytical time, get people home on time.
Implementation of the above algorithm is accomplished by the Trending.xls workbook which links to the QMST module.  The main screen of the Trending program looks like:
                               
                               
                               
                               
                               
Again, this program follows the standard AutoSoft rules.  Yellow cells are for user input.
In this ficticious example, we generate our finished PowerPoint slide deck with a few mouse clicks in less than 1 minute.
We have 3 groups with trend-able results.  The PowerPoint slide shows us:
 
                             
                               
                               
                               
                               
                               
                               
                               
                               
                               
                               
                               
                               
This indicates that there was significant upward trending on two of the three trend-able groups before the Christmas shutdown.  When the process re-started after Christmas, the upward trends were reversed.
The Pareto gives us some feel as to where the problems are:
 
                             
                               
                               
                               
                               
                               
                             
These tools provide the system owner the ability to quickly slice and dice the data so that informed decisions can be made.
                               
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 06/05/2015 10:53 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