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® Work Order Scheduling
Let's face it, scheduling a bunch of work orders in Maximo is a bit of a chore.  There are only a limited number of hours in a work day, and filling up a technician's work load without leaving idle time or overloading is difficult and time consuming.  AutoSoft Systems has solved this problem and guarantees to get your Work Order Planners home on time.  Here is how it works:
The Maintenance Managers identify the default staffing levels and record "exceptions", i.e. vacation or coverage.  The Maximo names of each maintenance technician is extracted from Maximo.
This screen configures the default staffing levels:                          
This screen allows the Maintenance Manager to record "exceptions" to the default schedule:
The Planner needs to know what Work Orders need to be scheduled.  The Maximo_Query.XLSM application allows one or more Planners to execute pre-defined queries to generate a list of work orders that need to be scheduled:
Once the desired filter is selected, the Planner presses the bright green "BUILD A SCHEDULE HELPER USING THE CURRENT FILTER SETTINGS" button to generate the scheduling file.  This file has a "Report" worksheet that provides a list of all Work Orders in Maximo that match the filter criteria specified above.  This report has two views, the condensed view that displays 16 key columns of information ,and the expanded view that displays 38 columns of information.  The columns can be easily customized to meet your requirements: