Creating The OEE Table

An OEE table can now be produced to display the daily OEE figure. First generate a new table called Daily OEE (click Tables/Graphs on the left and Add a new Table).

Select Compact Table from the type and tick Compact headers, this will make the data clearly readable on the resultant chart. The machine and job information should also be included using the tick boxes in the two respective menus (see below) and set in the order shown above.

Make sure that the 'Number of jobs per table/graph' and 'Number of machines/groups per table/graph' boxes are both set to 0 and that the 'Remove inactive machines/groups' box on the machines menu it ticked.

Setting The OEE Table Period

Click Period on the left and set it for one day as below:

In this example we are producing a table for a whole day, so the interval length should also be set to one day. It is however possible to produce a table showing OEE on an hourly or shift by shift basis simply by changing the Interval Length to 1 hour or 1 shift accordingly.

Adding The OEE Data

Click Columns on the left, tick the 'Remove empty columns' box.

Add each of the following values in sequence using the search icon, the OEE values are near the bottom of the list of expressions just above the TIME options. The order of the columns determines the order they will be displayed in the resultant table. The order can be changed by highlighting a value in the central window and moving it up and down the list using the up and down arrows to the right of the window.

The title for each value will appear at the top of the chart and needs to be manually entered for each value. The formats also need to be set correctly or the data will be displayed incorrectly, as a guide the OEE expressions are all in '%' format apart from the Part counts which are 'I' Integers and the time's are all 'HMS' format.

OEE Values:

Once the columns are set up correctly the chart should look like this:

Any performance figures greater than 100% show that the part is being produced in less time than the database expected time figures, less than 100% shows it is taking longer to produce than the expected time.