Accendo Reliability

Your Reliability Engineering Professional Development Site

  • Home
  • About
    • Contributors
  • Reliability.fm
    • Speaking Of Reliability
    • Rooted in Reliability: The Plant Performance Podcast
    • Quality during Design
    • Way of the Quality Warrior
    • Critical Talks
    • Dare to Know
    • Maintenance Disrupted
    • Metal Conversations
    • The Leadership Connection
    • Practical Reliability Podcast
    • Reliability Matters
    • Reliability it Matters
    • Maintenance Mavericks Podcast
    • Women in Maintenance
    • Accendo Reliability Webinar Series
  • Articles
    • CRE Preparation Notes
    • on Leadership & Career
      • Advanced Engineering Culture
      • Engineering Leadership
      • Managing in the 2000s
      • Product Development and Process Improvement
    • on Maintenance Reliability
      • Aasan Asset Management
      • AI & Predictive Maintenance
      • Asset Management in the Mining Industry
      • CMMS and Reliability
      • Conscious Asset
      • EAM & CMMS
      • Everyday RCM
      • History of Maintenance Management
      • Life Cycle Asset Management
      • Maintenance and Reliability
      • Maintenance Management
      • Plant Maintenance
      • Process Plant Reliability Engineering
      • ReliabilityXperience
      • RCM Blitz®
      • Rob’s Reliability Project
      • The Intelligent Transformer Blog
      • The People Side of Maintenance
      • The Reliability Mindset
    • on Product Reliability
      • Accelerated Reliability
      • Achieving the Benefits of Reliability
      • Apex Ridge
      • Metals Engineering and Product Reliability
      • Musings on Reliability and Maintenance Topics
      • Product Validation
      • Reliability Engineering Insights
      • Reliability in Emerging Technology
    • on Risk & Safety
      • CERM® Risk Insights
      • Equipment Risk and Reliability in Downhole Applications
      • Operational Risk Process Safety
    • on Systems Thinking
      • Communicating with FINESSE
      • The RCA
    • on Tools & Techniques
      • Big Data & Analytics
      • Experimental Design for NPD
      • Innovative Thinking in Reliability and Durability
      • Inside and Beyond HALT
      • Inside FMEA
      • Integral Concepts
      • Learning from Failures
      • Progress in Field Reliability?
      • R for Engineering
      • Reliability Engineering Using Python
      • Reliability Reflections
      • Testing 1 2 3
      • The Manufacturing Academy
  • eBooks
  • Resources
    • Accendo Authors
    • FMEA Resources
    • Feed Forward Publications
    • Openings
    • Books
    • Webinars
    • Journals
    • Higher Education
    • Podcasts
  • Courses
    • 14 Ways to Acquire Reliability Engineering Knowledge
    • Reliability Analysis Methods online course
    • Measurement System Assessment
    • SPC-Process Capability Course
    • Design of Experiments
    • Foundations of RCM online course
    • Quality during Design Journey
    • Reliability Engineering Statistics
    • Quality Engineering Statistics
    • An Introduction to Reliability Engineering
    • Reliability Engineering for Heavy Industry
    • An Introduction to Quality Engineering
    • Process Capability Analysis course
    • Root Cause Analysis and the 8D Corrective Action Process course
    • Return on Investment online course
    • CRE Preparation Online Course
    • Quondam Courses
  • Webinars
    • Upcoming Live Events
  • Calendar
    • Call for Papers Listing
    • Upcoming Webinars
    • Webinar Calendar
  • Login
    • Member Home

by Miguel Pengel Leave a Comment

An Excel – VBA Driven Weibull Calculator

An Excel – VBA Driven Weibull Calculator

Every Reliability Engineer will be familiar with the Weibull Analysis. Most of us even have an Excel template laying around that we refer to!

The problem is, that when we have to handle Suspended data (e.g. components that haven’t failed yet at time of observation), the Excel sheet must use VBA in the background if the user wants a “single-button” tool.

Find below a link to download a VBA driven Weibull Calculator I developed a while back. This tool is a “Single -Button” calculator but is powerful enough to handle “Suspended data” for a more comprehensive analysis.

This calculator outputs:

-Weibull Plot, Beta and Eta Values, R^2 value
-Reliability Function, Survival Function, Hazard Rate and Probability Distribution Charts

Weibull Analysis is one of the most powerful tools a Reliability/ Mechanical Engineer can have in their pocket. Used practically since the 60’s, it was a method of moving away from S-curves and using a distribution that was flexible enough to model infant, random and age related failures.

The outputs of the 2- Parameter Weibull Analysis, Beta and Eta describe the failure rate and Characteristic Life.
These outputs have been used to quantitatively adjust maintenance tactics, spares holding, system reliability and quality control.

Some pitfalls Engineers must consider:

– This type of analysis can only be used at the component-level, not the system level (Don’t go perform a single Weibull analysis on an entire Haul Truck)

-This analysis only works for a single failure mode. If you have multiple failure modes present in your data, the linearized Weibull plot will have an S-bend and a lower R^2 value.

I hope you get as much use out of this as I do!

Download the Calculator HERE. at the end of the article.

Filed Under: Articles, Asset Management in the Mining Industry, on Maintenance Reliability

About Miguel Pengel

Miguel Pengel is a Registered Professional Engineer based in Australia, with experience in a wide variety of heavy industries such as Mining, Smelting and Power Generation.

He holds a degree in Mechanical & Aerospace Engineering, as well as a Masters in Applied Finance from the University of Queensland.

Miguel has worked in Reliability, Mechanical, Production and Project engineering roles for some of the world's largest companies such as Glencore, Hitachi and Rio Tinto.

« The 10 Habits of Highly Effective Reliability-AM Professionals
Airline Security And Lithium Battery Fires »

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Asset Management in the Mining Industry logo Photo of Miguel PengelArticles by Miguel Pengel
in the Asset Management in the Mining Industry: A Blueprint for Operational Excellence article series

Join Accendo

Receive information and updates about articles and many other resources offered by Accendo Reliability by becoming a member.

It’s free and only takes a minute.

Join Today

Recent Posts

  • test
  • test
  • test
  • Your Most Important Business Equation
  • Your Suppliers Can Be a Risk to Your Project

© 2025 FMS Reliability · Privacy Policy · Terms of Service · Cookies Policy