|
|
|
|
|
|
|
|
|
|
|
|
AutoSoft Systems |
| |
|
|
|
AutoSoft
Systems |
2 Round Hill
Court |
| |
|
|
|
East Greenwich,
RI 02818 |
| |
|
|
|
401.885.3631 |
| |
|
|
|
401.884.5653 Fax |
| |
|
|
|
|
|
|
|
|
|
|
|
401.996.3631 Cell |
| AMDG |
|
|
|
"Once you
know it, it's Easy!" |
autosoft@aol.com |
| Commercial and custom computer related products spanning the
areas of data acquisition and control, simulation and modeling, numerical
analysis, chemical process design and manufacturing management information
systems design. 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 |
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
AMDG |
![MCBS00913_0000[1]](maximo_files/index_0000_image004.gif)
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| "IBM MaximoŽ Asset Management unifies comprehensive asset
life cycle and maintenance management on a single platform." |
| From IBM's web page: |
http://www-01.ibm.com/software/tivoli/products/maximo-asset-mgmt/ |
| (AutoSoft is not affiliated with IBM) |
| Maximo is indeed a powerful tool. It is a tremendous repository of valuable
information regarding asset management for large multinational
corporations. AutoSoft has provided a
number of Excel-VBA-ODBC (Visual Basic for Applications, Open Data Base
Connectivity) solutions that have eliminated human error and tedium of
running reports as well a eliminated up to 95% of the work associated with
the generation of these reports. It is important to note that Excel-VBA-ODBC
access directly into Maximo is READ-ONLY.
This assures the integrity of the Maximo database, which is
imperative. |
| Note, these examples are just some of the ways that AutoSoft has
helped improve asset life cycle management through "tuning" of the
Maximo data base. The possibilities
for Excel-VBA-ODBC reporting is endless. We are only limited by our
imaginations. In all cases,
Maintenance Managers identified the need for a report, and worked with Dr.
Serdakowski to prepare the specifications for the report. Dr. Serdakowski then worked his
"magic" to prepare the reports as specified. |
| All examples here share one or more of the following common
motivations: |
| ● |
Improve
visibility to exceptions in the Maximo database to improve accuracy and avoid
compliance issues |
| ● |
Reduce the
clerical time to generate reports by increasing the automation in report
generation |
| ● |
Provide reports
in the most versatile format available - Excel |
| ● |
Reduce the cost
of maintenance |
| ● |
Make report
generation easier for the user who is not a computer expert |
| ● |
Make report
generation easier for the seasoned programmer |
| ● |
Save Time, Save
Money, Improve Accuracy |
| Examples: |
| Future
PM Cost Calculator |
This
program mines data from Maximo to estimate the cost of future preventative
maintenance costs. It also isolates PM
related inconsistencies in the Maximo data base to facilitate corrections. |
| Maximo
Data Scrubber |
This
program combs through the Maximo database and isolates 5 defined exceptions
and 2 specific database changes. It
automatically sends emails to the system owners, notifying them of the
exceptions and "encouraging" them to make corrections. The number of exceptions are trended with
time so that progress can be tracked. |
| Subsystem
Analysis Workbook |
The
program assists system owners in optimizing Preventative Maintenance
frequencies and costs. |
| Data Dictionary Generator |
The
Maximo database comprises approximately 400 tables and views and in excess of 14,000 total fields. This tool provides lists of the tables and
associated fields, as well as "clones" each table into a
stand-alone Excel workbook (at least the first 65,533 records for large
tables in Excel 2003 and 1,048,574 records in Excel 2007), putting the entire
Maximo table structure and content at your fingertips! This tool is a great time saver for any
programmer looking to generates reports out of Maximo. |
| All of this work is using "vanilla"
Excel-VBA-ODBC. All of this source
code is included and easy to understand for anyone with VBA experience. |
|
| An example of the VBA code that harvests data from Maximo: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 04/27/2010 06:59 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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|