Free OEE, takt, and Pareto — inside Excel
Lean Operations Monitor opens beside your workbook. No account. No new MES. Run the calculators today; add logs and reliability later if you need them.
Data stays in Excel
Workbook analysis runs locally in your session
Desktop & Web Excel
Windows, Mac, and Microsoft 365
Free to start
OEE, Takt, and Pareto with no account
Live on AppSource
Install Lean Operations Monitor from Microsoft
| Line | Avail. | Perf. | Quality | OEE |
|---|---|---|---|---|
| Line 1 | 92.4% | 88.1% | 97.2% | 79.1% |
| Line 2 | 87.0% | 91.5% | 94.8% | 75.6% |
| Line 3 | 95.1% | 86.3% | 98.0% | 80.4% |
| Line 4 | 89.8% | 90.2% | 96.1% | 77.9% |
Downtime pareto
Overall OEE
79.1%
Top loss: Changeover (32%)
Layout based on the Lean Operations Monitor task pane. Get it on AppSource →
Two-minute walkthrough of the free tools and optional Lean Ops Pro.
Three free calculators. No login.
Your data never leaves your workbook for these tools.
OEE Calculator
Enter planned time, downtime, cycle time, and counts. See Availability, Performance, Quality, and OEE — then export a clean report to Excel.
Takt Time
Convert shift length, breaks, and customer demand into seconds per unit and units per hour — the pace the line needs to hold.
Pareto Chart
Enter or import category counts, find the vital few defects or losses, and write the table plus cumulative percent back to your sheet.
Built for people who already live in spreadsheets
Plant supervisors and CI engineers — not a new software project.
Production logs and OEE live in separate files — downtime reasons are hard to track shift to shift.
Use free OEE and Pareto in Excel, then Lean Ops Pro for structured production and downtime logs with reliability analytics.
You already work in Excel and do not want a second MES just to see OEE and losses.
Keep the workbook as the system of record. Free calculators need no login; Pro unlocks logs and analytics when you are ready.
Excel monitoring — not a MES project
Use it when you want practical OEE and losses in the file you already keep — without moving immediately to a dedicated MES.
- Workbook stays the system of record
- Free OEE, takt, and Pareto with no account
- Analysis runs in your Excel session
- Not real-time machine connectivity
Install in three steps
AppSource is the supported path. Sideload stays on the docs page for testers.
Get it on AppSource
Install Lean Operations Monitor from Microsoft AppSource. The add-in is free to install.
Open the Lean Ops tab
In Excel, look for the Lean Ops ribbon — not only a button on Home. Click OEE Calculator first.
Run OEE in the task pane
The pane opens beside your workbook. No account. Export the report when you are ready.
Optional later
Need logs and reliability? Lean Ops Pro
After the free calculators, subscribe from Account in the add-in when you want a structured plant system. The workbook stays the working data source.
- Setup — plant profile, shifts, loss categories
- Reference Data — work centers, machines, rates
- Logs — production, planned and unplanned stops
- Analytics — OEE from logs, losses, MTTR/MTBF
Questions before you install
Try it in your workbook
Install Lean Operations Monitor from Microsoft AppSource. OEE, takt, and Pareto stay free.
Get it free on AppSource