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
Subsystem Analysis Workbook
MaximoŽ is a trademark of IBM
AutoSoft is not affiliated with IBM.
In these trying economic times, corporations are looking high and low for savings.  One candidate is the cost of Preventative Maintenance.  It is a time consuming task to review each and every subsystem in a corporation and validate that all necessary maintenance is being performed, but excessive maintenance is not.  A Senior Maintenance Engineer defined a methodology to be applied by all system owners corporate-wide to assess their maintenance costs with the goal of adjusting the maintenance procedures and schedules to optimize both costs and effectiveness.  His methodology was quite extensive, and required multiple Brio queries and reports to conduct this comprehensive assessment.  The initial implementation was a failure because the queries were difficult to properly configure, transferring the query results from Brio to Excel was tedious and time consuming, and once the data was in Excel, the analysis was exacting and subjective.      
It is important to note that this entire program was written and revised up to Version 17 by Dr. Serdakowski in less than 80 hours.
In this case, the Maintenance Engineer communicated his methodology to Dr. Serdakowski.  The final product resulted in a 95% labor savings compared against the initial procedure using conventional Maximo reporting tools (Brio) and manually transferring the results to Excel.  The version illustrated below has been implemented across the entire corporation at multiple sites in multiple countries.   
This workbook follows the standard AutoSoft conventions.  Any cell with a YELLOW background is a cell where the user can enter information. The document is fully protected so the user can ONLY enter information in the yellow cells. The main screen looks like: