Jump to content
We've recently updated our Privacy Statement, available here. ×

Problem with calculating OEE via custom expression in Spotfire


Martin Sokolov

Recommended Posts

Hi,

I have one question regarding custom expressions in Spotfire. I'm trying to calculate OEE (Overall Equipment Effectiveness) via custom expression in cross table.

The problem that I'm having is that when there is more than one work order in one shift, I'm getting incorrect (random) value for OEE. I'm only getting the correct value when there is only one work order.

My question is, how to sum the OEE values when there are more then one work order in one shift via custom expression on the axis of the cross table?

Here is the table from which I'm trying to calculate OEE:

12.thumb.png.4328215fd1b2777494f7e84a4602a378.png 

I've tried creating Calculated column with the OEE formula and I'm always getting fixed value for all work orders, for example in my case 0.39, that's why I'm using custom expression on the cell value axis on the cross table.

Thanks.

Link to comment
Share on other sites

Your formula is (excluding the two other axes Sum([PlannedQTY]) and Sum([QTY]):

Sum([RunTime]) / Sum([PlannedProductionTime]) * 20 / (Sum([RunTime]) * 60) * Sum([QTY]) / Sum([QTY]) * 100

which if we substitute Sum([RunTime])=A and Sum([QTY])=B for clarity is:

A / Sum([PlannedProductionTime]) * 20 / (A * 60) * B / B * 100

which still simplifies to (removing A/A and B/B):

1 / Sum([PlannedProductionTime]) * 20 / (60) * 100

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...