Multi-Phase System Reliability Analysis using Excel
Volume 10, Number 2, March 2014 - Paper 03 - pp. 143-154
P. S. SARMA BUDHAVARAPU1, S. K. CHATURVEDI2, DAMODAR GARG1, SUDHANGSHU CHAKRAVORTY11 Reliability Centre, Global R&D Centre, Crompton Greaves Ltd, Kanjur Marg (E), Mumbai, India
2 Reliability Engineering Centre, IIT Kharagpur, Kharagpur, West Bengal, India
(Received on April 01, 2013, Revised on September 20, 2013)
This paper proposes an Excel based algorithm for evaluating phased mission systems. The algorithm estimates the system reliability for a given target operating period. A hybrid methodology has been implemented for developing the algorithm. This algorithm utilizes the powerful mathematical and statistical capabilities of Excel. In this proposed approach, the phase wise functional Reliability Block Diagram (RBD) of the system under investigation is first transformed into a table in an Excel Spreadsheet. Each cell within the table corresponds to a specific connection in the RBD. Failure distributions of the components are also taken as input through Excel sheet. Excel’s macro feature enables automatic running of phase algebra based calculations. The analysis time of a given system is dependent on its complexity, computer configuration, and the accuracy desired and may vary from a few seconds to a few minutes. The algorithm has been successfully applied on several examples taken from the literature.
Click here to download the paper.
Please note : You will need Adobe Acrobat viewer to view the full articles.