OEE Calculation In Microsoft Excel: Illustration With Practical Example

[@maheshwani8813]

Excellent sir, Very good explained after watching video everybody can easily understand OEE calculation concept.

[@learnandapply]

Thank you so much Mahesh for your valuable comments and appreciation ☺🙏

[@khalidnawaz6536]

Excellent work sir. Please keep posting all good material. So we will learn it from your best skills. Keep it up!

[@learnandapply]

Thank you so much for your valuable comments and appreciation 😊🙏

[@tiramixulighteu6822]

I find this video very useful. I just want to ask about the differences between Planned Shutdown and Downtime loss. I hope I will receive your explanation soon. Thank you in advance!!

[@learnandapply]

Thank you so much for your valuable comments and appreciation. The planned shutdown is a scheduled loss like a lack of orders from customers, whereas downtime loss is due to some unplanned incidences like machines not functioning.

[@barsvelioglu2276]

Excellent tutorial

[@learnandapply]

Thank you so much for your valuable comments and appreciation 🙏☺

[@muhammadhurairabinwaheed3020]

Very well explained

[@learnandapply]

Thank you so much for your valuable comments and appreciation 🙏☺

[@khalidnawaz6536]

This is really an excellent demonstration about to Clculate OEE.. One thing is miscalculation about finding The Performance. The calculation of the performance should be 86.87% which you showed 97.4% in the example. You may Review and can change the %age value of Performance. Thanks

[@learnandapply]

Can you please recheck the values? Where did you get the performance rate of 97.4%?🤔

[@abdullahkashwah9235]

Thank you brother

[@learnandapply]

You're welcome and thank you so much for your valuable comments 🙏☺

[@dechatunmeesuk2126]

Thank you so much

[@learnandapply]

Your welcome and thank you so much for your valuable comments!😊

[@Rahulkumar-yh8oo]

Thank you sir

[@learnandapply]

You're welcome ☺

[@ojoolufemi1817]

Hello, thank you for the video, very informative. Please how do one calculate OEE for multiple machines?

[@learnandapply]

Hi Ojo, thank you for your valuable comment and appreciation! You can use the multiplication of OEE's for these machines to indicate cumulative OEE.

[@khalidnawaz6536]

Performance: Ideal cycle time (0.008)× total production time( 1900) ÷ operating tiime (17.5)

[@khalidnawaz6536]

Sir, cn you upload a video that can show that how we can use these data by plotting a graph on excel nd that will be awesome for all the viewers. Thanks

[@learnandapply]

Ok, thank you so much for your valuable comments and suggestions 😊🙏

[@ajitraut5029]

When organisation keep machine running 24hrs by giving 1or2 extra manpower then they consider total time ie 24hr for calculation. And when organisation gives time to operator for lunch, snacks etc.. and there is no extra operator to run machine during this breaks then they minus that time from available time for OEE calculation.

[@learnandapply]

Well said. Thank you so much for your valuable comments! 😊

[@chineduodoh9832]

Thanks for all you do, please can you share the excel file?

[@learnandapply]

Thank you for your valuable comments and appreciation! 🙏☺️ It's already there in the description.

[@MuhammadSiddiqueSulehria]

Ideal cycle time mean ...?

[@learnandapply]

Ideal cycle time is the minimum time required to produce single unit. (It is either given my machine manufacturer or calculated by time-motion study)

[@subramaniananandhamoorthy3249]

why we are multiplying hundred with all outputs in oee second formula sheet

[@learnandapply]

Just to convert them in percentage. Thank you for your valuable comments. 🙏☺

[@rongwong1431]

india

[@rudreshjoshi8693]

Suppost it given that downtime is 10 min and cleaning time is 15 min then do we need to subtract cleaning time in operations time?? Please answer as soon as possible

[@learnandapply]

Please treat cleaning time as downtime. Though it is needed in some processes, it can be improved.

[@khalidnawaz6536]

I think it should be 86.85%

[@learnandapply]

Please take total values with decimals. 0.008 is actually 0.008333