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® Change Control Management System Reporting
Trackwise® is a trademark of Sparta Systems
AutoSoft is not affiliated with Sparta Systems.
Trackwise® does a great job in managing change control as required by best practices and regulatory bodies.  As with most of these types of tools, the reporting features are limited.  Dr. Serdakowski has developed and implemented change control reporting tools that pick up where Trackwise leaves off.
The main screen collects all pertinent data from Trackwise® via direct ODBC connection, Cognos® or Brio®:                            
One key parameter that is lost in the Trackwise® system is the duration of time each Change Control spends in each stage of its existence.  This information is retained by the CCMS.xls program.  In this screen shot of scrambled data, one sees the different stages in cells Q1:AD1, and the date that each Change control entered the stage.  This information is NOT readily accessable (if it is retained at all) in Trackwise®.
Retaining this data allows for trending data to be generated on the Trend worksheet:
With graphs being automatically generated:                            
                  As with the QMTS module, generation and migration of these graphs to PowerPoint is accomplished with just a few mouse clicks.
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