# World-class maintenance decisions need world-class maintenance optimization models in Weibull distribution plot model decision-making tools

### You quickly learn how simple it is to use this Weibull curve plotting model. Put your component failure data into the Weibull distribution plot model and see the data’s Weibull curve.

Use this Microsoft Excel spreadsheet to create a Weibull distribution plot model of equipment failure data like the Weibull plot shown below. It lets you use site specific historic failure information to conduct Weibull analysis of your equipments’ probable future operating lives, assuming the future will carry the same equipment risks as the past.

The Weibull excel model plots the failure data from your equipment as a Weibull plot and graphs it against an ‘ideal’ Weibull curve using the data so you can compare how closely the field data actually fits a Weibull distribution. When the fit is not close it means the Weibull distribution is not the form to use for the raw data and you need to find a better distribution shape for the situation (e.g. Lognormal, Extreme Value, Gamma, etc). In the image below the nine data points from worn mining truck tyres that blew-out before they could be changed straddle the Weibull reliability distribution plot. The Weibull plot curve is a reasonable representation of the historic situation. The Weibull beta value is about 8, which definitely means age related failures.

With the model we can see that if we continue with current tyre purchasing specifications and site usage practice and do nothing to improve tyre reliability, then by the time our new tyres do 30,000 km about 5 percent of all the blow-outs will happen. By the time the fleet reaches 40,000 km we will have had 33 percent of all blow-outs. By 44,000 km 60 percent of blow-outs would have occurred. This information is valuable for maintenance decision optimisation such as when to purchase spares and when to bring the truck fleet in to fit new tyres to minimise production losses.

View a PDF document showing the use of the Weibull Excel Model
Weibull Distribution Excel Model Example

#### Weibull Failure Probability Distribution Plot Modelling Excel Spreadsheet

(MS Excel Spreadsheet for modelling the probability of equipment failures based on its past failure history)
 Weibull Distribution Excel Model – AU\$24.99

This Weibull Excel modelling tool was developed by Howard Witt, a professional reliability engineer with over 25 years hands-on industry experience, including nuclear facilities and industrial process plants. He developed the Weibull Excel spreadsheet to make Weibull modelling of raw failure data fast and easy.

100% Money Back, No Questions Asked Guarantee

If you are not satisfied with your purchase we will promptly and pleasantly refund your money in-full with no questions asked. And you can keep the purchase as compensation for the problems caused to you.

Disclaimer

Because it is unknowable how applications will be used, their Developer and Lifetime Reliability Solutions take no responsibility for correctly modelling the situation, or for the outcomes of using an application.

It is recommended that you understand well the theory behind the application you use, so you can confidently judge whether it applies to the situation under investigation and if its output is sufficiently accurate in the circumstances. Remember the warning that applies to all modelling methods — ‘garbage in, garbage out’.

Making A Purchase