Tuesday, December 14, 2010

Maximize the Benefit of your EAM’s Scheduling Module

Maximize the Benefit of your EAM’s Scheduling Module

Most facilities take little advantage of the scheduling capability of their Enterprise Asset Management (EAM) System. This is in part to the way this information is displayed. Experience has shown that many rely on exporting the scheduling data to an Excel spreadsheet and use this as their weekly schedule. This format is, of course, limited to the functionality of Excel as a scheduling platform. On the occasion where Microsoft Project is used, data is manually entered to generate the schedule.

If you can easily get your scheduling data from the EAM system into an Excel spreadsheet, a Microsoft Project is really minutes away. A standard week schedule project format can be created as a template. Use this as the basis for future weekly schedules. Once your scheduling data is in Excel format, it can be easily imported into Microsoft Project. The Excel spreadsheet and Microsoft Project column headers must match and data imports directly field to field from Excel to Project. Simply verify print format and you now have a Microsoft Project schedule based on your EAM system scheduling data.