| Using the Power Law model of a Nonhomogeneous Poisson Process (NHPP) as applied to repairable systems first developed by Larry Crow in 1974, a computer application was developed to solve for the parameters of the model for the general case of multiple systems with time and/or failure truncation. The model is commonly used to determine optimum replacement times for equipment and in designing warranty policies. The computer application is in the form of a Microsoft Excel spreadsheet with macros and charts built in to allow the user to view the data and the results graphically.;This application is the first of its kind to allow the analyst to quickly analyze the data, determine the parameters, and view the expected values of failures, reliability, and rate of occurrence of failure (ROCOF) as numbers and graphically. The spreadsheet runs on Microsoft Excel versions 5 and later and does not require any add-ins beyond the standard installation of these versions. |
