Fleet Equipment Performance Measurement Preventive Maintenance Model: Spreadsheet-Based Engine Data Analysis Tool

PDFTech Reporthttp://ntl.bts.gov/lib/60000/60000/60007/0-6626-P1_Final.xlsmFHWA/TX-13/0-6626-P1Product 0-6626-P1Project 0-6626SoftwareSpreadsheetsManualsTrucksHeavy vehiclesHeavy duty vehiclesUnited StatesTexasTexas A&M Transportation InstituteJohnson, JeremyRamani, TaraKader, MichaelTexas A&M Transportation InstituteTexas. Dept. of Transportation. Research and Technology Implementation OfficeUnited States. Federal Highway AdministrationUS Transportation CollectionThis record refers to both the spreadsheet tool - Fleet Equipment Performance Measurement Preventive Maintenance Model: Spreadsheet-Based Engine Data Analysis Tool, http://ntl.bts.gov/lib/60000/60000/60007/0-6626-P1_Final.xlsm - and its accompanying user manual - Spreadsheet-based engine data analysis tool - user's guide, http://ntl.bts.gov/lib/60000/60000/60007/0-6626-P1.pdf.The concept of preventive maintenance is very important in the effective management and deployment ofvehicle fleets. The Texas Department of Transportation (TxDOT) operates a large fleet of over 17,000 piecesof on-road and off-road equipment. Newer engines and vehicles are equipped with on-board diagnosticsystems that can provide data on engine operation\ue2\u20ac\u201dincluding engine speed and throttle position (anindication of load value). There is the possibility of tracking these parameters to refine predictions for whenequipment maintenance should be performed. Project 0-6626 aimed to provide a proof of concept for thisidea by developing an algorithm that can be used to recommend appropriate oil change intervals based onengine data collected through on-board diagnostic systems. This product is a spreadsheet-based analysis tooldeveloped as part of Project 0-6626, which can be used for logging, analyzing, and characterizing enginedata for heavy-duty fleet vehicles in the TxDOT fleet of the selected test vehicle type