OEE calculator by shift (availability, performance, quality)

Overall equipment effectiveness for each machine and shift, from planned time, stops, cycle time and rejects.

Downloads are included in the $19.85 yearly membership. Sign in

XLSXCSVODSXMLNumbers

	A	B	C	D
1	OEE calculator by shift
2	Example data — replace the blue input cells with your own.
3
4	OEE	AVAILABILITY	PERFORMANCE	QUALITY
5	79.1%	90.7%	88.4%	98.7%
6
7	Inputs
8	OEE target	85%	A commonly cited benchmark for top-performing discrete manufacturing. It is a guide, not a law.
9	Shift rows with a machine name	30
10
11	All shifts: totals
12	Planned production time (min)	13,860
13	Unplanned stop time (min)	1,290
14	Run time (min)	12,570
15	Ideal time for total count (min)	11,112
16	Total count (parts)	38,170

Showing the first 16 of 52 rows and 11 of 11 columns. Cells with formulas show the formula on hover.

	A	B	C	D	E	F	G	H	I	J	K	L
1	Shift log
2	One row per machine and shift. Blue cells are inputs; every other column is a formula.
3	Enter one row per machine per shift. Formula columns stay blank until a machine name is entered.
4	Date	Shift	Machine	Planned production time (min)	Unplanned stop time (min)	Ideal cycle time (s per part)	Total count (parts)	Reject count (parts)	Run time (min)	Availability	Performance	Quality
5	Sep 7, 2026	A	Press 1	450	25	12.0	1,901	25	425	94.4%	89.5%	98.7%
6	Sep 7, 2026	A	Press 2	450	54	15.0	1,337	26	396	88.0%	84.4%	98.1%
7	Sep 7, 2026	A	Lathe 3	450	69	45.0	447	10	381	84.7%	88.0%	97.8%
8	Sep 7, 2026	B	Press 1	480	39	12.0	2,004	20	441	91.9%	90.9%	99.0%
9	Sep 7, 2026	B	Press 2	480	34	15.0	1,449	8	446	92.9%	81.2%	99.4%
10	Sep 7, 2026	B	Lathe 3	450	68	45.0	462	7	382	84.9%	90.7%	98.5%
11	Sep 8, 2026	A	Press 1	480	48	12.0	2,003	10	432	90.0%	92.7%	99.5%
12	Sep 8, 2026	A	Press 2	450	49	15.0	1,393	35	401	89.1%	86.8%	97.5%
13	Sep 8, 2026	A	Lathe 3	480	26	45.0	547	10	454	94.6%	90.4%	98.2%
14	Sep 8, 2026	B	Press 1	480	40	12.0	1,947	14	440	91.7%	88.5%	99.3%
15	Sep 8, 2026	B	Press 2	480	47	15.0	1,494	17	433	90.2%	86.3%	98.9%
16	Sep 8, 2026	B	Lathe 3	450	24	45.0	514	5	426	94.7%	90.5%	99.0%

Showing the first 16 of 205 rows and 12 of 19 columns. Cells with formulas show the formula on hover.

	A
1	OEE calculator by shift
2	Notes: what this workbook does, how to use it and the method behind it.
3
4	What it does
5	Calculates overall equipment effectiveness (OEE) for each machine and shift from planned production time, unplanned stops, ideal cycle time, total count and rejects.
6	The Shifts tab holds the log. The Dashboard adds up minutes and counts first and divides afterwards, so every ratio is weighted by time and volume.
7	The example data is fictional: three machines over ten shifts. The log has room for 200 machine-shift rows.
8
9	How to use it
10	1. On the Shifts tab, enter the date, shift, machine, planned production time (min), unplanned stop time (min), ideal cycle time (s per part), total count and reject count in the blue columns.
11	2. Read the Row check column (S). Correct any row marked Stops exceed planned time or Rejects exceed total count.
12	3. Type each machine name once in the machine table on the Dashboard so that its results are included.
13	4. Set the OEE target in the Inputs block. The default is 85 percent.
14	5. Read OEE, availability, performance and quality from the tiles, then use the loss breakdown to see where the time went.
15
16	Formulas and method

Showing the first 16 of 37 rows and 1 of 1 columns. Cells with formulas show the formula on hover.

What does this template do?

Overall equipment effectiveness (OEE) shows how much of a machine's planned time becomes good parts made at the ideal rate. This workbook is for production engineers, supervisors and continuous improvement teams who log machine data by shift and want the same figures every time.

Each row on the Shifts tab is one machine on one shift. Run time is planned production time less unplanned stops. Availability is run time divided by planned time. Performance is ideal cycle time multiplied by total count, divided by run time. Quality is good count divided by total count. OEE is availability multiplied by performance multiplied by quality.

The Dashboard adds up minutes and counts before it divides, so totals are weighted by time and volume instead of being averaged from row percentages. The loss breakdown shows where the time went: unplanned stops, slow running and rejects. The example data is fictional: three machines over ten shifts.

What’s inside

Availability, performance and quality multiply into OEE for every row
Dashboard totals come from summed minutes and counts, not averaged percentages
Per-machine table with the gap to the OEE target
Loss breakdown in minutes: unplanned stops, slow running and rejects
Checks flag rows where stops exceed planned time or rejects exceed total count

Which tabs does the workbook have?

Tab	What it holds
Dashboard	OEE tiles, all-shift totals, the per-machine table, the loss breakdown and the checks.
Shifts	Shift log with one row per machine and shift, and the formulas for each row.
Notes	What the workbook does, the formulas in words, assumptions and limits.

What formulas does this template use?

This template holds 2,314 formulas in 2,666 cells across 3 tabs, so 87% of its cells calculate. They use 8 distinct functions; the longest formula is 142 characters and 44 of them read from another tab.

Function	Uses	What it does
`IF`	3,503	one result when a test is true, another when false
`OR`	207	true when any test is true
`SUMIFS`	30	adds values meeting several conditions
`SUM`	26	adds numbers
`SUMPRODUCT`	4	multiplies matching entries, then adds them
`ABS`	2	absolute value
`COUNTA`	1	counts non-empty cells
`COUNTIF`	1	counts cells meeting one condition

Counted from the workbook itself. Only functions that Excel, LibreOffice Calc, Google Sheets and Apple Numbers evaluate the same way are used, so the formulas survive every download format.

How do you use it?

Enter each machine's shift data in the blue columns of the Shifts tab: date, shift, machine, planned time, stops, ideal cycle time, total count and rejects.
Read the Row check column (S) and correct any flagged row before reading the results.
Read OEE, availability, performance and quality from the four tiles at the top of the Dashboard.
Compare each machine with the OEE target in the per-machine table, then review the loss breakdown.
Replace the example rows with your own log, and add machines by typing their names in the machine table.

What is it good for?

Weekly OEE review by machine
Finding the largest source of lost time on a press line
Comparing shifts or crews working on the same equipment
Measuring the effect of a changeover reduction project

Questions about this sheet

Why are the Dashboard percentages not an average of the shift OEE values?

Each total adds minutes and counts first and divides afterwards, so a long shift carries more weight than a short one. An average of row percentages would give a short shift the same weight as a long one.

What does the performance figure assume?

It assumes the ideal cycle time you enter is the rate the machine can sustain when it runs at full speed. If the ideal is set too high, performance can exceed 100 percent, and the workbook does not flag it.

Is 85 percent a required OEE?

No. The 85 percent target is a benchmark often quoted for top-performing discrete manufacturing. Set the target that fits your own operation.

What is the quality loss?

The quality loss is the ideal cycle time multiplied by the reject count, in minutes. It is the time spent making parts that were rejected.