my oee is AxPxQ
I am trying to get the losses as percentage of the full picture?
has someone done stacked graphs of OEE and the losses totaling to 100%?
(1-A) (1-A*P*Q)
------------------------------- x
(1-A)+(1-P)+(1-Q)
OEE = A × P × Q
Losses = 1 - A × P × Q
Did I do this right?
I found the percentage loss of each per the total each loss contributing to the total loss
(1-A) (1-A*P*Q)
---------------- x
((1-A)+(1-P)+(1-Q))
percentage loss per the total contributing losses ratio multiplied by the OEE loss will get me the OEE loss per loss, I think
It is pretty abstract to me still.
if that is correct, then I think my simplest form is:
my selects are huge for this in my query, but I think I am getting them in a tenth of a second
This denominator doesn't look right at all.
That is one of the things I am struggling with.
I tried this with 1% 20% 50%, 33.3% in each, and other variations
If I wanted to get availabiltiy (A) percentage of OEE :
A / (A+P+Q) * OEE ?
I would look into this site/link
just browsing over it gave me a lot of clarity.
That site has numerable issue imo
first, your oee calculation can end up over 100%, and the even comment on it
Performance = (Total Count / Run Time) / Ideal Run Rate
but i think that is another discussion
I used the Sepasoft definitions. Still I don’t see much on the losses themselves in the format I need for my graph
Given OEE = A · P · Q, to solve for any one variable, you need the other three. Do you have three input values to get the fourth you want?
what’s wrong being over 100%?
Without knowing your ins and outs that doesn’t discredit it.
For example, if I have a good run with good operators who finish earlier than standard generous estimated time. I would hope it would be over 100%. In fact it might bother me if it wasn’t.
could be something off in the math, or too generous on some inputs possibly,. The formula seems pretty solid to me though.
I cleaned up the notes and columns some, so hopefully if I have an error, it is more obvious.
@andrews more concisely I want to say
Compare What Is OEE - MES Platform 3.0 - Sepasoft MES Help Documentation
imo more traditional, performance can’t be over 100, matches data I have that uses sepasoft module
I want to say thanks for trying to help me too.
Sorry I write so much. So many details to track.
I really could not see much difference between that link and mine in terms of equations.
Are you sayings you are getting different results with your own formula vs what sepasoft is showing you?
Performance = (Total Count / Run Time) / Ideal Run Rate
Performance = (Ideal Cycle Time × Total Count) / Run Time
from oee.com
vs
Performance = actual number of units started / (standard rate * actual runtime) from sepasoft site
I said oee.com site is not so good imo and I thank you for trying to help me
I am working on the losses as a percentage of the total losses for a stack bar chart
I am not sure I had explained it.
If you tell 1000 people to use the "total count", then your responses will vary too much, because total count is not a real thing, it is an abstract of a thing.
Where actual number of units started is a tangible thing, a singular thing of measurable quality that is countable.
Total count could mean:
Outfeed counts plus infeed
Outfeed plus scrap
Outfeed, scrap, and infeed
Where actual number of units started is very specific, and not abstract.
Yes, this also depends on line layout. and at what point in the line you want to grab the count.
I can't mark it as the answer since it is a different account, but that was the right equation to get the individual losses.
