Generating Reports to Analyze Production Downtime
With the data in place, you can create various reports in the form of charts to analyze downtime by shift, product, process, equipment or issue. The Excel template includes two column charts that report total downtime minutes by shift and product.
To setup cells to show total downtime by product
Go to the Product worksheet and type in the cell next to the first product (Product A) the formula "=SUMIF(Log!C1:C1000,"Product A",Log!G1:G1000)," which will add up all the downtime minutes affecting Product A from the Log.
Copy the formula to the other products and change “Product A" to the name of the other products.
To create a column chart to display total downtime by product
Highlight the cells totaling the downtime from the Product Worksheet.
Select the Insert tab and then Column Chart 2D.
Click on Move Chart and in the dialog box that appears click on the drop down list under Object in and choose the Analysis and Reports Worksheet.
Choose the Quick Layout on the Ribbon to select a pre-formatted chart or create one on you own. The one used in the template includes a title and axis labels with the legend removed manually.
- Repeat the process to create other reports that will update automatically to track downtime by shift, process, equipment, and issue.
For creating other types of charts, including a Pareto chart for root cause analysis, continue to this summary of Excel project management templates and tutorials available for downloading from Bright Hub.