OEE calculation: get the data right before the formula
Calculate availability, performance and quality for the same time window and the same definition of production.
Read the guideSolutions
OEE & production performance
Make production losses visible with consistent data.
Production managers and continuous-improvement teams
Relate downtime, output and quality to shifts and products. Track availability, performance and quality separately to identify which losses require action.
SourceMachine / counter
OPC RouterConnect · Transform · TransferDestinationSQL / BI
Typical data points
- Machine state (running / stopped)
- Total count counter
- Good count and scrap
- Product or recipe identifier
- Downtime reason
How the flow works
- Connect
The OPC UA Client reads state, counter and downtime-reason tags.
- Transform
Counter differences are taken and reset and missing-data rules applied; records are associated with shift and product.
- Transfer
Records are written to an SQL database with the source timestamp; OEE components are calculated in the database or the BI layer.
Decisions before connecting
- 01Shift and break definitions
- 02Ideal cycle by product
- 03Total and good-count sources
- 04Counter reset and missing-data rules
Pilot acceptance criterion
Compare calculated times and counts against production records for one shift. Flag performance over 100% and missing telemetry separately.
Connectors used in this scenario
Connector availability, version compatibility and licence scope are verified for each project.
Implementation guide
Frequently asked questions
Does OPC Router calculate OEE itself?
OPC Router builds the workflow that collects counter, state and downtime data and delivers it to the destination. Where the OEE formula is calculated (in the workflow, in an SQL view or in a BI tool) is decided in the project. See the OEE entry for the definitions and try the OEE calculator.
Why can performance exceed 100%?
Performance can exceed 100% when the ideal cycle time is defined slower than the real speed or when a counter reset is misread. Flag it as an error and review the ideal cycle. See common OEE measurement mistakes for detail.
Your next step
Let’s talk about the systems you need to connect.
Share your source, destination and intended outcome. We’ll help define the project scope.