|
|
|
|
|
|
|
|
|
|
|
|
AutoSoft Systems |
|
|
|
|
AutoSoft
Systems |
2 Round Hill
Court |
|
|
|
|
East Greenwich,
RI 02818 |
|
|
|
|
401.885.3631 |
|
|
|
|
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
AMDG |
|
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: |
|