Richard Palmer and Associates has produced the award-winning Maintenance Planning and Scheduling Handbook (MPSH) Scheduler to speed creation of a weekly schedule using the methodology of the handbook. The spreadsheet allows you to compile the best schedule for each crew’s labor hours in a matter of minutes.
The MPSH Scheduler is simply an “app” for your company’s CMMS. Although the scheduling process outlined in Chapter 6 can be easily executed with paper forms, the MPSH Scheduler is simply an Excel spreadsheet with some macros to manipulate the work orders.
Instead of spending three or four hours manually scheduling at the end of the week, the spreadsheet allows you to compile the best schedule for each crew’s labor hours in a matter of minutes. You can then print out the schedule for each crew or send them an Excel spreadsheet. The spreadsheet even prepares a SQL of the schedule you could use to select out the work orders in the CMMS itself.