Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesOperations & Supply ChainManufacturing & OperationsOEE Calculator

SpreadsheetManufacturing & OperationsFree

OEE Calculator

Overall Equipment Effectiveness by shift: availability, performance and quality, and where time is lost.

Shown with sample data

Colour

OEE Calculator

Overall Equipment Effectiveness by shift: availability, performance and quality, and where time is lost.

Average OEE
79%
85% is world class
Availability
90%
Performance
90%
Quality
97%
Downtime minutes by line
  • Line 160
  • Line 2155
  • Line 345

How to use it

  1. 1Enter one row per machine per shift.
  2. 2Count all stops over five minutes as downtime.
  3. 3Use the designed cycle time, not the usual one.
  4. 4Attack whichever of the three factors is lowest.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

OEE turns a shift’s numbers into one measure of how well a machine ran. Enter planned time, downtime, ideal cycle time, units made and rejects for each shift; the sheet calculates availability, performance, quality and OEE, and compares each line with the 85% world-class benchmark.

Who it’s for

  • Daily production meetings
  • Finding the biggest loss on a line
  • Tracking improvement after a kaizen

What’s included

  • Shifts sheet: One row per line per shift.
  • By line sheet: Downtime minutes and Units made and Units rejected and the number of entries for each line.

How to use it

  1. 1Enter one row per machine per shift.
  2. 2Count all stops over five minutes as downtime.
  3. 3Use the designed cycle time, not the usual one.
  4. 4Attack whichever of the three factors is lowest.

Questions

What is a good OEE?

85% is considered world class for discrete manufacturing; 60% is typical and 40% is common for plants starting to measure.

Related searchesoee calculatoroverall equipment effectivenessdowntime trackingproduction efficiencylean manufacturing

Details

Format
Spreadsheet
Category
Manufacturing & Operations
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetManufacturing & OperationsFree

OEE Calculator

Overall Equipment Effectiveness by shift: availability, performance and quality, and where time is lost.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Manufacturing & Operations
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More manufacturing & operations templates

View all
Equipment Maintenance Log3 sheets

Overdue

1

Due in 14 days

3

Maintenance spend

$2,875

ABCD
1EquipmentLocationTypeInterval (days)
2Commercial espresso machineFront counterKitchen90
3Walk-in fridgeKitchenRefrigeration180
4DishwasherKitchenKitchen120
5HVAC unitRoofBuilding180
Assets
SpreadsheetManufacturing & Operations

Equipment Maintenance Log

Preventive maintenance due dates from each asset's service history, with overdue alerts, repair and downtime tracking, and maintenance cost by asset and month.

10 min setupPreview
Weekly Production Schedule3 sheets

Attainment

100%

Yield

99%

Downtime

160

ABCD
1DateLineOrder #Product
2Nov 5Line 1MO-871Sourdough loaf 800g
3Nov 5Line 2MO-872Granola bar 40g
4Nov 5Line 3MO-873Oat cookies 12pk
5Nov 6Line 1MO-874Seeded rolls 6pk
Schedule
SpreadsheetManufacturing & Operations

Weekly Production Schedule

Plan production orders by line, day and shift, then record output, scrap and downtime to see attainment, yield and performance by line and day.

10 min setupPreview
Failure Mode and Effects Analysis (FMEA)3 sheets

Failure modes

8

High priority

1

Highest RPN

175

ABCD
1Process stepFailure modeEffect of failureS
2Receive castingsPorosity in casting wallHousing leaks at customer8
3CNC machine boreBore oversizeBearing loose, noise and early failure7
4CNC machine boreBurrs left on joint faceGasket damaged, leak6
5Press-fit bearingBearing not fully seatedShaft misalignment, pump seizure9
Analysis
SpreadsheetManufacturing & Operations

Failure Mode and Effects Analysis (FMEA)

Rate severity, occurrence and detection for every failure mode, get the RPN and action priority, and track risk after actions.

60 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ