Accendo Reliability

Your Reliability Engineering Professional Development Site

  • Home
  • About
    • Contributors
    • About Us
    • Colophon
    • Survey
  • Reliability.fm
  • Articles
    • CRE Preparation Notes
    • NoMTBF
    • on Leadership & Career
      • Advanced Engineering Culture
      • ASQR&R
      • 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 Maintenance Management
      • 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
      • RCM Blitz®
      • ReliabilityXperience
      • 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
      • Field Reliability Data Analysis
      • Metals Engineering and Product Reliability
      • Musings on Reliability and Maintenance Topics
      • Product Validation
      • Reliability by Design
      • Reliability Competence
      • Reliability Engineering Insights
      • Reliability in Emerging Technology
      • Reliability Knowledge
    • 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
      • Institute of Quality & Reliability
      • Integral Concepts
      • Learning from Failures
      • Progress in Field Reliability?
      • R for Engineering
      • Reliability Engineering Using Python
      • Reliability Reflections
      • Statistical Methods for Failure-Time Data
      • Testing 1 2 3
      • The Manufacturing Academy
  • eBooks
  • Resources
    • Accendo Authors
    • FMEA Resources
    • Glossary
    • Feed Forward Publications
    • Openings
    • Books
    • Webinar Sources
    • Podcasts
  • Courses
    • Your Courses
    • Live Courses
      • Introduction to Reliability Engineering & Accelerated Testings Course Landing Page
      • Advanced Accelerated Testing Course Landing Page
    • Integral Concepts Courses
      • Reliability Analysis Methods Course Landing Page
      • Applied Reliability Analysis Course Landing Page
      • Statistics, Hypothesis Testing, & Regression Modeling Course Landing Page
      • Measurement System Assessment Course Landing Page
      • SPC & Process Capability Course Landing Page
      • Design of Experiments Course Landing Page
    • The Manufacturing Academy Courses
      • An Introduction to Reliability Engineering
      • Reliability Engineering Statistics
      • An Introduction to Quality Engineering
      • Quality Engineering Statistics
      • FMEA in Practice
      • Process Capability Analysis course
      • Root Cause Analysis and the 8D Corrective Action Process course
      • Return on Investment online course
    • Industrial Metallurgist Courses
    • FMEA courses Powered by The Luminous Group
    • Foundations of RCM online course
    • Reliability Engineering for Heavy Industry
    • How to be an Online Student
    • Quondam Courses
  • Calendar
    • Call for Papers Listing
    • Upcoming Webinars
    • Webinar Calendar
  • Login
    • Member Home
  • Barringer Process Reliability Introduction Course Landing Page
  • Upcoming Live Events
You are here: Home / Articles / An Excel – VBA Driven Weibull Calculator

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

  • Leadership Values in Maintenance and Operations
  • Today’s Gremlin – It’ll never work here
  • How a Mission Statement Drives Behavioral Change in Organizations
  • Gremlins today
  • The Power of Vision in Leadership and Organizational Success

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