# Calculating OEE losses **URL:** \ **Category:** General Discussion\ **Created:** [May 16, 2022, 4:13pm UTC](https://forum.inductiveautomation.com/t/calculating-oee-losses/59623 "2022-05-16T16:13:36Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Post date:** [May 16, 2022, 4:13pm UTC](https://forum.inductiveautomation.com/t/calculating-oee-losses/59623/1 "2022-05-16T16:13:36Z")
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%? * * * ```auto (1-A) (1-A*P*Q) ------------------------------- x (1-A)+(1-P)+(1-Q) ``` ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [May 16, 2022, 5:13pm UTC](https://forum.inductiveautomation.com/t/calculating-oee-losses/59623/2 "2022-05-16T17:13:26Z")
OEE = A × P × Q Losses = 1 - A × P × Q ---
**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Post date:** [May 16, 2022, 6:09pm UTC](https://forum.inductiveautomation.com/t/calculating-oee-losses/59623/3 "2022-05-16T18:09:36Z")
Did I do this right? I found the percentage loss of each per the total each loss contributing to the total loss ```auto (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: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/6/36edca0eb263f8206fe9f11ae9f76a2774f4907d.png) my selects are huge for this in my query, but I think I am getting them in a tenth of a second ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [May 16, 2022, 6:14pm UTC](https://forum.inductiveautomation.com/t/calculating-oee-losses/59623/4 "2022-05-16T18:14:48Z")
> [@zacharyw.larson](#): > > `((1-A)+(1-P)+(1-Q))` This denominator doesn't look right at all. ---
**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Post date:** [May 16, 2022, 6:19pm UTC](https://forum.inductiveautomation.com/t/calculating-oee-losses/59623/5 "2022-05-16T18:19:27Z")
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 ? ---
**Author:** ![andrews](https://avatars.discourse-cdn.com/v4/letter/a/898d66/32.png) [@andrews](https://forum.inductiveautomation.com/u/andrews)\ **Post date:** [May 16, 2022, 6:21pm UTC](https://forum.inductiveautomation.com/t/calculating-oee-losses/59623/6 "2022-05-16T18:21:47Z")
I would look into this site/link > **[OEE Calculation: Definitions, Formulas, and Examples | OEE](https://www.oee.com/calculating-oee/)** > > Learn how to calculate OEE to gain insight into the effectiveness of your manufacturing process and improve production. just browsing over it gave me a lot of clarity. ---
**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Post date:** [May 16, 2022, 6:23pm UTC](https://forum.inductiveautomation.com/t/calculating-oee-losses/59623/7 "2022-05-16T18:23:25Z")
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 ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [May 16, 2022, 6:25pm UTC](https://forum.inductiveautomation.com/t/calculating-oee-losses/59623/8 "2022-05-16T18:25:36Z")
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? ---
**Author:** ![andrews](https://avatars.discourse-cdn.com/v4/letter/a/898d66/32.png) [@andrews](https://forum.inductiveautomation.com/u/andrews)\ **Post date:** [May 16, 2022, 6:27pm UTC](https://forum.inductiveautomation.com/t/calculating-oee-losses/59623/9 "2022-05-16T18:27:55Z")
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. ---
**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Post date:** [May 16, 2022, 6:28pm UTC](https://forum.inductiveautomation.com/t/calculating-oee-losses/59623/10 "2022-05-16T18:28:52Z")
![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/c/3c89e93c21675120fa3bd368b639fd46343cfc43.png) 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](https://help.sepasoft.com/docs/display/SEPA/What+Is+OEE) 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. ---
**Author:** ![andrews](https://avatars.discourse-cdn.com/v4/letter/a/898d66/32.png) [@andrews](https://forum.inductiveautomation.com/u/andrews)\ **Post date:** [May 16, 2022, 7:57pm UTC](https://forum.inductiveautomation.com/t/calculating-oee-losses/59623/11 "2022-05-16T19:57:07Z")
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? ---
**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Post date:** [May 16, 2022, 8:44pm UTC](https://forum.inductiveautomation.com/t/calculating-oee-losses/59623/12 "2022-05-16T20:44:29Z")
Performance = (Total Count / Run Time) / Ideal Run Rate Performance = (Ideal Cycle Time × Total Count) / Run Time from [oee.com](http://oee.com) vs Performance = actual number of units started / (standard rate \* actual runtime) from sepasoft site I said [oee.com](http://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 ---
**Author:** ![Zach\_Larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zach_larson/32/54388_2.png) [@Zach\_Larson](https://forum.inductiveautomation.com/u/Zach_Larson)\ **Post date:** [March 4, 2024, 1:26pm UTC](https://forum.inductiveautomation.com/t/calculating-oee-losses/59623/13 "2024-03-04T13:26:55Z")
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. ---
**Author:** ![andrews](https://avatars.discourse-cdn.com/v4/letter/a/898d66/32.png) [@andrews](https://forum.inductiveautomation.com/u/andrews)\ **Post date:** [March 11, 2024, 6:55pm UTC](https://forum.inductiveautomation.com/t/calculating-oee-losses/59623/14 "2024-03-11T18:55:39Z")
Yes, this also depends on line layout. and at what point in the line you want to grab the count. ---
**Author:** ![Zach\_Larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zach_larson/32/54388_2.png) [@Zach\_Larson](https://forum.inductiveautomation.com/u/Zach_Larson)\ **Post date:** [March 12, 2024, 12:45pm UTC](https://forum.inductiveautomation.com/t/calculating-oee-losses/59623/15 "2024-03-12T12:45:13Z")
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. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/1/21555269e39c3c530b29e1d8c44bb629a322f35d.png)