#Equipment hours spreadsheet plus#

Go to the worksheet with the list and highlight all the choices in the list plus blank rows for possible additions in the future.

Д¬lick on the Source line in the dialog box.

Д¬lick on the Settings tab in the dialog box.

Д¬lick on the Data Validation in the menu to bring up the dialog box.

For example, for shifts, select B9 through B1000. Highlight the cells on the Log Worksheet that you want to access a list. Once you have entered the items in each list on the appropriate worksheet, you can create drop down lists on the Log worksheet by following these steps: Worksheet 6 вЂ“ Analysis and Reports (For example, charts to display downtime by shift, machine, process, and issue over time) Steps for Creating Drop Down Lists.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