Real-Time Production Efficiency Monitoring with Microsoft Office: A Practical Approach to Applying Overall Equipment Effectiveness and the Industrial Internet of Things in a Lean Manufacturing Workplace

Finally, a way to cost-effectively to implement OEE and monitor production efficiency …

Real-time production monitoring is a challenge in most manufacturing environments. This is especially true for small to midsize manufacturers. Real-Time Production Efficiency Monitoring with Microsoft® Office shares a proven 16-step process to develop and install a cost-effective real-time monitoring system.

In detail, the book provides insight on sensors, computing hardware and software requirements, system configuration, and programming, network communications, and most importantly, how to capture the highest return on your plant’s investment. Included are details on over 80 macros and subroutines.

Also inside are an overview of Overall Equipment Effectiveness (OEE), the Industrial Internet of Things (IIoT), Lean Manufacturing, production load leveling/scheduling, the involved screens, the applicable programming code, and troubleshooting tips. With over 600 items in the index, Real-Time Production Efficiency Monitoring with Microsoft® Office can also serve as a long-term reference tool.

Benefits of Real-Time Monitoring with Microsoft Office

+ Real-time production problem-solving

+ Visual alerts when there are scheduling/productivity issues

+ Opportunities become much more obvious with color visuals

+ Improved scheduling with real-time production load leveling

+ Better-focused Lean kaizen improvement efforts

+ Do-it-yourself low installed cost

About the Author

Mike Chambers is an experienced hands-on practitioner and a long-time member of the Microsoft Advisory Board. He is a Senior (Managing) Principal with Abidian, a global manufacturing consulting firm. With over 35 years of practical experience, Mike specializes in helping organizations achieve their highest potential by improving their culture while eliminating inefficiencies and ineffective work practices. He has held management and continuous improvement leadership responsibilities at both the facility and corporate levels with three Fortune 500 companies.

An accomplished Certified Lean Six Sigma Master Black Belt (CMBB), Mike is also a hands-on Certified Maintenance and Reliability Professional (CMRP) and licensed master electrician. He has been independently recognized as a sensei for his working knowledge of Lean and the Toyota Production System.

Mike is the author of over two dozen books. When not writing or helping others, Mike and his beautiful wife Kay enjoy hanging out on the Gulf Shores beaches with their two neurotic cats.

With over 35 years of experience, Mike Chambers is a hands-on continuous improvement practitioner and long-time tinkerer of all things electronic. An electrical engineer by education, Mike is also a licensed master electrician and veteran Certified Maintenance and Reliability Professional (CMRP). As a Certified Lean Six Sigma Master Black Belt (MBB), he has been independently recognized as a sensei for his working knowledge of Lean and the Toyota Production System.

Mike has held leadership roles with three Fortune 500 companies and is the author of over two dozen books. His recent work includes Real-Time Production Efficiency Monitoring with Microsoft Office and the Abidian Industrial Internet of Things (IIoT)/Continuous Improvement Dictionary.

When not traveling, Mike and his beautiful wife Kay enjoy hanging out at their home in Gulf Shores with their two neurotic cats.