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
MaximoŽ Future PM Cost Calculator
MaximoŽ is a trademark of IBM
AutoSoft is not affiliated with IBM.
This program mines data from Maximo and estimates the cost of future preventative maintenance costs.  This program is written in Microsoft Excel 2003 using VBA and ODBC to harvest data from Maximo. 
It is important to note that this entire program was written by Dr. Serdakowski in less than 40 hours. In this case, the Corporate Facilities and Engineering Manager had a clear vision for what was needed and communicated his vision to Dr. Serdakowski.  This type of detailed analysis using Excel-VBA-ODBC generated a 95% labor savings compared against conventional Maximo reporting tools such as Brio, which is a very effective tool for "one-up" queries but cannot be automated.  Also, human error is dramatically reduced because as any experienced Brio user knows, one has to properly enter the necessary parameters when running the same query on different systems.   
The main screen looks like:
The calculation scheme is well documented:
This screen provides the ability to quickly update the Maximo Database "meta" data:                          
As any maintenance supervisor knows, PMs are scheduled at different intervals, with more comprehensive PMs being scheduled at longer time intervals than less comprehensive (less expensive) ones.  If the more comprehensive is scheduled, there is no reason to perform the shorter one.  This can only happen if the PM frequencies are properly aligned.  This screen searches the entire PM database and reports on only those PMs that act on the same equipment but have intervals that do not mesh.  In the case below, rows 2 through 5, PMs of increasing complexity are scheduled for every 6 months, 1 year, 2 years, and the most comprehensive PM is scheduled for every 5 years, where 5 is NOT an integer multiple of 2.  The 5 is displayed in RED, and this exception makes the list. It becomes a simple task for the maintenance manager to re-define the most comprehensive PM to occur either every 4 years or every 6 years, to make the entire collection of PMs for the Clean Steam Generator consistent, and therefore not part of this exception report. All exceptions corporate-wide are listed in this report:
The Log worksheet tracks the various query results with time so that progress can be measured.  Note columns T and U below.  When the report was initially run, there were 17 PM Site Exceptions corporate-wide.  In a matter of weeks, all of these exceptions were removed from the Maximo data base.
This next report totals all PMs for each site corporate wide.  The count, the labor hours and the material costs. The detail is by equipment type.  Note the column names.  The display skips from A,B,C to AE-AM.  In this case there are many different sites corporate-wide, but we are only displaying a few here.  Additionally, there are over 900 rows of information in this example.
Here is the same type of report; however the rows are now System Descriptions:                        
Notice how the summary numbers at the top match.
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:51 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