Kevin Crittendon, Director of Continuous Improvement, recently presented a webinar for the Society for Maintenance and Reliability Professionals (SMRP). Entitled “Organizing and Understanding Data for Sound Asset Management”, the webinar focused on showing the maintenance professional how to obtain, organize and understand data for decisions related to the management of facilities and operational assets.

The focus was on using a common desktop tool (MS Excel) to organize and understand CMMS data in a manner that leads to specific improvement actions. Crittendon used basic data charts to illustrate “where are we towards our objectives” and “what should we focus on for maximum impact”. The MS Excel elements presented included calculated fields, charts, pivot tables and text to columns.