Here are the ones used in the example spreadsheet to store lists and reports. To make it easier to enter data into this Excel spreadsheet, create separate worksheets to store the lists that will be become drop down options on the log. Action taken (comments on the action taken, which can be used to develop a corrective action plan).Downtime (documented in minutes, hours, etc.).Date (particularly helpful for detecting issues that have implications for seasonal forecasting).To begin, setup your data columns on Worksheet1 (renamed Log) to collect the following information related to the each downtime event: In setting up the spreadsheet, you will need to track production data to help you document the 5 Ws (who, what, where, when and why) to have a complete picture of what happened when the equipment came offline. What Production Data Needs To Be Tracked? With further modification, the spreadsheet can also be adapted to track any вЂњdowntimeвЂќ that may be causing delays in a projectвЂ™s schedule. This example downtime tracking log can be downloaded here from Bright HubвЂ™s media gallery and customized to work with different manufacturing processes. Identifying repeated causes for system and equipment malfunctions can lead to improvements in: By tracking and analyzing production downtime, managers can identify production flow problems and develop action plans that focus on corrective and preventive measures. Production downtime translates into an under utilization of capacity that impacts the bottom line. Tracking Production Downtime to Improve Efficiency

Log working hours spreadsheet excel