It is always a good idea to stay on top of your data!!! If you update data older than 4 months, you will not see the changes until the following Monday. (It refreshes Sunday overnight.) If your data is older than 13 months, it may not be worth updating. The changes will not show up until the second day of the next month.
Steps in the screenshots correspond to the numbers in the headings.
As a best practice, you might want to get in the habit of checking the DW Tables each week to review the downtime tab. This will help you clean up any incorrect data before the end of the month.
Before you start, there are a couple terms that you need to understand:
Repair Time: The amount of time that the machine was down - without considering production schedules. It is literally just a stopwatch that starts when the machine goes down and stops when it goes back up.
Down Time: The amount of time that the machine was down during the production schedule.
If the production schedule is 24x7, the Down Time and the Repair Time will be the same.
Breakdown: The machine was not running at the time of Work Order/Task Creation. This is considered a Failure in your MBTF metric. Additionally, if the first malfunction is marked breakdown, all of the time will be considered as a breakdown.
1. Open the DW Tables from your desktop or download a copy from your Power BI Site Workspace.
2. Click on the Instructions Tab.
3. Click on the Filter all Tables for Date Range and choose the range you want to work with.
- A: You have the ability to filter using the buttons on the right hand side to navigate to a month's worth of data at a time.
- B: If you wanted to see last week's data - change the toggle to days, and enter a range between -1 and -8 and click OK.
- C: If you wanted to see only results from a specific day, you could choose the Date Range option and enter a specific date in the "is" value.
4. You should always hit the "Apply Date formatting to Date and Date Time Columns" button to ensure the spreadsheet is formatted properly.
5. Click on any of the Downtime Tabs.
Many sites like working from the the tab that includes the Tech Comments.
For the purposes of this document, I have hidden many of the tabs in the spreadsheet that you are not focusing on in this particular exercise. Please know that there is lots more valuable information contained on this report.
I also pulled the screenshots and instructions from the Downtime Tab. The columns might be slightly different if you are using a different tab - but the instructions will be the same if you just look for the headings.
6. Scroll over to Column O. This column is for Tasks that are marked "Is Breakdown". Click on the drop-down arrow and check True.
7. This report is now filtered for WO/Tasks that were not working when the Customer put in the ticket. Go to the Daily Repair time hours. This is Column T.
8. You can determine where the cutoff is that you'd like to look at.
For the purpose of this exercise, we choose to investigate Repair times taking .4 hours or less.
9. The Work Order ID is listed in Column I.
10. The Instructions page tells you that Control + Shift + Z will give you the Work Order comments. Put your cursor on the first WO ID and use that shortcut.
11. The Work Order Description, Task Description and Tech Comments are displayed.
- At this point, only someone at the site can/should determine if this should truly be classified as a breakdown.
- Remember, because this is marked as "is breakdown = true", it is counting in your MBTF.
- If you are an Eaton site, it is also counting AGAINST YOU in your CONC metric.
12. Using the Arrows at the top of the window will take you to the next record in the spreadsheet.
13. If you wish to see the Work Order or Task in the Portal, you must place your cursor on the cell in the report, and use the keyboard shortcuts that are built into the reports.
Ctrl + Shift + W will take you to the Work Order in the portal.
Ctrl + Shift +T will take you to the Task in the Portal.
14. In going to the Portal, we see more info. The repair codes show it was operator error, and there is only 1 minute of downtime.
15. Click on the Task. You can delete the malfunction without re-opening the task.
The next day, your metrics will show one less failure.
0 Comments
Add your comment