📦 Resource excel

Crusher Bearing Weibull Analysis Workbook

The Crusher Bearing Weibull Analysis Workbook is an Excel-based reliability engineering tool designed to model and analyze the failure behavior of crusher bearings in mine materials handling systems using the Weibull distribution. It enables practitioners to estimate key reliability metrics—including characteristic life (η), shape parameter (β), and failure probability—using field-collected bearing life data. The workbook supports predictive maintenance planning, root-cause analysis, and evidence-based life extension strategies for critical crushing equipment.

📖 Overview

The workbook implements statistical lifetime data analysis grounded in extreme value theory, where the Weibull distribution serves as the primary model for time-to-failure data due to its flexibility in representing increasing (β > 1), decreasing (β < 1), or constant (β ≈ 1) hazard rates—critical for diagnosing wear-out, infant mortality, or random failure modes in crusher bearings. Users input right-censored or complete failure data (e.g., hours-in-service until seizure, flaking, or vibration alarm), and the workbook performs maximum likelihood estimation (MLE) or rank regression (e.g., median rank plotting) to fit the two-parameter Weibull distribution. Built-in diagnostics—including goodness-of-fit tests (Kolmogorov–Smirnov, Anderson–Darling), probability plots, confidence bounds, and bathtub curve interpretation—help validate model appropriateness and identify outliers or mixed failure mechanisms. Advanced features may include comparative analysis across bearing types, lubrication regimes, or operating conditions (e.g., throughput, feed gradation), enabling reliability-centered decision-making for spares optimization, overhaul scheduling, and design feedback loops to OEMs. Integration with CMMS or SCADA data feeds (via Power Query or API connectors) further enhances its role in digital twin–enabled asset management frameworks.

📑 Key Components

1 Weibull parameter estimation engine (MLE/rank regression)
2 Interactive probability plot (Weibull paper or linearized axes)
3 Reliability metrics dashboard (B10 life, MTTF, conditional reliability, failure rate curve)

🎯 Applications

  • Predicting remaining useful life (RUL) of installed crusher bearings
  • Optimizing preventive maintenance intervals based on empirical failure patterns
  • Benchmarking bearing performance across suppliers, loads, or lubrication practices

📐 Key Formulas

Weibull Cumulative Distribution Function (CDF)

F(t) = 1 − exp[−(t/η)^β]

Calculates the probability that a bearing fails before time t, where η is the scale parameter (characteristic life) and β is the shape parameter.

Weibull Probability Density Function (PDF)

f(t) = (β/η) * (t/η)^(β−1) * exp[−(t/η)^β]

Describes the failure density at time t; used to derive instantaneous failure rate and generate histograms for fitted curves.

Hazard (Failure) Rate

h(t) = (β/η) * (t/η)^(β−1)

Quantifies the instantaneous failure rate at time t; shape determines whether risk increases (β > 1), decreases (β < 1), or remains constant (β = 1).

🔗 Related Concepts

Reliability engineering Life data analysis Censoring (right-censored data) Bathtub curve Condition monitoring

📚 References

#mining reliability #bearing life prediction #Weibull modeling #Excel reliability tool #predictive maintenance