OEE Excel Spreadsheet Template

Register of Machines and Operators

The first step is to register the machines, operators, and mechanics with a limit of 30 per category.

Production Time Planning

Then you will post the planned production time per machine per month.

Quantity Planning Produced
Then, as in the previous tab, you can post the quantity produced per machine per month.

Launch of Quantity Produced
Then you are going to launch the actually produced production per machine per month.

Defect Count
Finally, you should cast the defective parts per machine per month.

Machine Stop Control
Finally, you will be able to launch and control all the machine stops every month.

Full OEE Calculation
Automatically, the worksheet will calculate the OEE of each machine per month.

Automatic Dashboard by Machine
Finally, you'll have a consolidated auto report with all machines per month.

OEE Excel Spreadsheet Template