Skip to content
Shop | Excel system

Digital Shop Floor System

Use cases, data points, reason codes, OEE and losses, vendor scoring, interfaces, security, roadmap and adoption.

Screenshot of the Digital Shop Floor System workbook with example data
Example data from the workbook.

How it works

  1. 02 Setup holds the area data and values. 03 Audit holds the 25 statements of the checklist, scored at three points in time.
  2. 04 Use Cases ranks all ideas. 05 Data Points and 06 Reason Codes define what is collected and how stops are explained.
  3. 07 OEE compares machine data with the old paper figures. 08 Losses shows the loss Pareto of the week.
  4. 09 Vendors scores systems with weighted criteria. 10 Interfaces lists every system and data flow with its owner.
  5. 11 Security tracks the basic rules per area. 12 Roadmap plans the waves. 13 Business Case calculates benefit and payback.
  6. 14 Adoption tracks usage and OEE month by month against the targets.

Definitions used in the workbook

  • Weighted vendor result: Sum of weight times score, divided by 5 times the sum of weights. Close results are decided by a test on the shop floor.
  • Adoption: Share of stops with a reason and share of daily meetings held on the board. Without adoption no benefit.

Sheets in the workbook

  1. Start
  2. Setup
  3. Audit
  4. Use Cases
  5. Data Points
  6. Reason Codes
  7. OEE
  8. Losses
  9. Vendors
  10. Interfaces
  11. Security
  12. Roadmap
  13. Business Case
  14. Adoption

Who it is for

Digitalization teams that select systems and roll them out across a plant.

The method behind the numbers

This workbook is part of the Digital Shop Floor toolkits. The Starter Kit adds the guide and the checklist for the first 30 days. The Excellence Bundle adds playbook, workshop pack, templates, deck and the complete Excel system.

Newsletter

One Lean idea.
Every week.