Low-cost Weibull Excel spread sheet to create a Weibull Distribution Model and Weibull plot for Weibull analysis of Component Failure Data
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
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.
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
OPTION 1: Use the automated card payment system. Once you check-out and pay you receive a confirmation email listing the purchase details. We get a notification email of your purchase. After your payment is approved (which is usually immediately) you get an email with a link from where you can download your goods. YOU HAVE 24 HOURS TO DOWNLOAD YOUR PURCHASE.Please check if the download notification email goes to your junk mail folder. To use the automated payment system, just click the ADD TO CART button on each product page when you want to order. Click the VIEW CART button to see your full order or to check-out.
OPTION 2: If preferred, you can order manually. In which case the order will be processed and sent to you as an email attachment or a download link is provided once payment is approved. Please print-off the and complete it with you product choices then fax or post it to us. Payment options for manual ordering are explained on the order form and must be received prior to shipment.