Skip to main content
OEE Part 3 -
Lean Training
Site Map Lean Principles Muda 8 Wastes Goal - Lean Flow Roadmap - Lean Journey Hansei Lean Thinking Lean Dictionary Online Lean Training Private TrainingSystems2win Training
Quick Start Initial Training Systems2win LeadershipMicrosoft Office Training
Excel Training Excel Drawings (without Visio) Excel Charts Word Training PDF TrainingInstallation and Setup
Installation - Each User Installation - Multi-user Document Storage and Naming Personalize Your Templates Support
Home for Continuous ImprovementOEE Video
(Overall Equipment Effectiveness)
Part 3 - Data Analysis
In this video, you will learn about how to begin analyzing the data from your OEE template
OEE Part 3 -
Data Analysis
Topics in this Video
- Learning Objectives: data analysis — 0:00
- How to import data from work center log worksheets — 0:12
- Using sample data to practice — 0:58
- How to select "A_AllData" for the correct table list — 1:05
- How to use Data > Filter to select date range — 1:25
- How to import data from a daily log — 1:52
- How to view choices of valid log worksheets — 2:20
- How to make sure duplicate data is not imported — 2:45
- Two sources of data to analyze — 3:10
- How to generate a filtered log worksheet — 3:35
- How to generate a filtered summary worksheet — 4:00
- How to use charts — 4:35
- How to use the Andon button — 5:05
Version 13 and higher...
Macros are now activated using the Systems2win menu
(rather than buttons within the workbook, as shown in the video)
Learn More
Foundational Learning
- Quick Start Initial Training to use ANY Systems2win template
- Training & Support home page
- Video Tips
If you don't yet own a license...
Download a dozen free trial
Systems2win templates
Own All 150+ Templates for
Continuous Process Improvement
Translations
For Closed Captions translated into any language,
watch this YouTube version of this same Data Analysis video
Related Topics