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Ž Mean Time Between Failure Reporting
MaximoŽ is a trademark of IBM
AutoSoft is not affiliated with IBM.
Let's face it.  Equipment breaks.  Often at the worst possible time.  Some equipment breaks more often than others.  MaximoŽ has stored in it a huge treasure-trove of information.  Getting it out sometimes seems more difficult than getting gold out of sea water.  AutoSoft's Mean Time Between Failure tool calculates just that for all equipment stored in Maximo.  This is a pre-compiled program, meaning the program pre-processes the necessary information overnight, resulting in a quick and easy user interface that gets you the desired answers in seconds.  The standard AutoSoft interface allows for right clicking to turn fields from blue to green to indicate selections, and entering values in yellow cells for other filtering options.  The main screen looks like this.  Here, we are focusing in on a subset of the data today, only for site "GG" and "Level_1" items:
AXIOM is a Trademark of Consona - USYS is a Trademark of Zumbach - AutoSoft Systems is not affiliated with Consona nor Zumbach
Once the selections are made, clicking the dark blue button creates a stand-alone Excel workbook with the following worksheets.  First, the "Report" worksheet lists all of the work orders that were generated as a result of a failure.  This fictitious report lists 4,249 work orders in a 2 year period over the entire "GG" site:
The fields in this report are too numerous to display above, but are listed below:
  Report Date Location Description Material $$ Asset Description
  Site Owner Total $$ Job Plan Nbr
  Building Geo Location Work Description Job Plan Rev.
  Building Description Classification Problem CC Nbr
  System Category Cause Eqpt Description
  System Description Work Type Remedy Model Number
  SubSystem Wo Nbr CCD Manufacturer
  SubSystem Description Labor Hrs Craft Install Date
  Location Labor $$ Asset Nbr  
But wait a minute, we are just getting started.  We have a "Site" worksheet that summarizes all information for the site(s) specified:
Note the size and complexity of this site.  There are 37,059 assets with a combined run hours in excess of 684 million.  Average mean time between failure is 161,179 hours.  Over $4 million spent on corrective maintenance.
The Building worksheet breaks it down by building.  Here, there are 4 buildings:
Now we are getting a little more granular.  Note that the sort order is MTBF with the lowest listed first.  If I double click on cells B7, the program automatically jumps back to the Report worksheet and lists only those corrective maintenance items that pertain to the selected building:
I can get even more granular if I select the "System" worksheet, where the MTBF for each system is calculated and displayed, the worst system at the top of the list.  Here, the worst system has a MTBF of only 803 hours:
If I click on the pale blue PARETO button, I instantly get a Pareto analysis of the selected column.  Note that the Pareto generation is smart.  MTBF hours, the lower the number, the worst.  MTBF Costs, the higher number the worst.
The same drill down can be done to the Subsystem and Location levels.  Here is a list of the worst 7 performers with MTBF of less than 500 hours.   Yuk.   If we focus on these 7 locations and figure out how to double the MTBF for each of them, we should be able to cut the total cost from $362,702 by half, savings over $180,000 in a 2 year period.  WOW!
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