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
Don't see what you need?  Ask!  All of these programs started as custom applications.  We can write most anything.
Pharmaceutical & Biotech Offerings Summary
AutoSoft Systems has been supporting the Pharmaceutical & Biotech Manufacturing Industry since 2005
ComplyWell Compliance Inspection Management System
  Used at 5 major manufacturing facilities, this multi-user tool manages the critical compliance inspection process, providing all users with up to the second information on every request, response, document and subject matter expert interview.  ComplyWell contains a complete change log, and the historical record over time allows companies to identify trends in inspectors' requests and tendencies.  Performance metrics measure time required to answer every request. ComplyWell tracks what documents have been retained by the inspectors.  Unlike other applications of its type, ComplyWell is easy to learn and uses an Excel front end. Like riding a bicycle, once users are trained they do not forget how to use this tool, which may be called into service on no notice 3 or 4 times a year.
The MATRIX Database of Databases
  Large Corporations have multiple corporate databases (Change Control, NC/CAPA, Maintenance Work Orders, Documents, Drawings,....) all with unique and limited search and retrieval capabilities.  An exhaustive investigation searching each database in turn could take weeks and require the user to be familiar with multiple user interfaces.  The MATRIX pre-compiles key fields from each database and aggregates the results into one common interface that can search all corporate data simultaneously.  Output hyperlinks the user back to the source database. Implemented at 6 major facilities, estimated annual savings in time is well over $1,000,000.
Using SCADA Process Data to Optimize Preventive Maintenance
  Preventive Maintenance is a necessary function of every manufacturing facility.  How much is too much?  How much is too little?  AutoSoft Systems has developed a suite of software tools that can be easily customized to assist in this decision at a variety of manufacturing facilities.  
PPM - Project Portfolio Manager
  This multi-user tool manages resources, schedules and cash flows for the portfolio of capital construction projects at 3 major manufacturing facilities.  The PPM solves the vexing problem of managing a slew of projects without the overhead of a long learning curve associated with other project portfolio management software programs. Integration with corporate ERP systems eliminates double entry of purchase order and invoice information for cash flow and budget reporting.
  Each user is presented with a list of all projects where he/she has been assigned tasks and can verify or modify the estimated and actual time required for each project on a weekly basis.  The Project Managers have total visibility to all resources, budgets, cash flows and schedules and can quickly adjust to changes.  Resource managers can level load resources and quickly recognize and eliminate future "pinch points."
High Level Analytics The applications listed here offer a very high level of analytics available from very few sources
AutoDNA - Restriction Endonuclease Analysis High Purity Water Trending Analytics
Gasket Intrusion Analysis Corporate High Purity Water Performance Reporting
Steam In Place Analysis Maximo® Preventive Maintenance Forecast Utility
Data Mining from Corporate Databases for Dashboards, Metrics,….
AutoSoft Systems has developed a series of Microsoft Excel / VBA multi-user programs that extract data from various corporate databases. These easy to use tools provide greater clarity in reporting and metrics generation than what is natively available in these Enterprise level solutions.
AutoSoft Systems is not affiliated with any of these data sources.
Trackwise® Corrective & Preventive Action Software Tools
Maximo® Asset Management Software Tools
StarLIMS® Software Tools
PI Historian® Software Tools
GE Proficy® Software Tools
Common Features
  All of the above applications have a common "look and feel" to facilitate training and retention. Few of these applications require installation of additional software on the users' computers.  Users work off of one read-only master document located on the corporate file server.  No additional login is required.  User access is controlled by Active Directory, if the user has access to the folder containing the application, the user can run the application.  All applications contain log files that track each user's activity.  Very low overhead :).  All applications can be quickly modified to use whatever back end database is your corporate standard (SQL Server, Oracle, Access, Progress...)  We can validate all of these applications and implement change control if so desired.
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 10/01/2014 03:05 PM 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