Reliability, time to market, and cost are three critical factors that determine if a product is successful in the marketplace. Meeting diverse customer expectations is the starting point and driving force of all design, verification, and production activities. In the context of reliability planning and requirements, customer needs should be analyzed and further correlated with reliability data analysis based on real-time on-site data.
This paper present a prototype of spreadsheet-based reliability toolkit, ERAT (Excel-based Reliability Analysis Toolkit) which has been developed based on Microsoft Excel 2016 Macro and VBA(Visual Basic for Application) that reliability end-users can easily be accessible. It was designed to accommodate parametric and non-parametric reliability data analysis for customer needs. Reliability data analysis toolkit use exponential distribution, weibull distribution and lognormal distribution analysis module for lifetime distributions and provide the functionality for complete data, type I censored data, type II censored data and multiply censored data. In addition, parameter estimation, calculation of reliability measures were implemented with graphic capability.
By utilizing the ERAT, End-user is able to develop custom-based ad-hoc models more easily and expected to save cost of reliability analysis system implementation in small and medium-sized business level during the life-cycle of product development.