Life Cycle Cost Prediction for Rolling Stocks in Maintenance Phase Based on VBA Language Program

Abstract

In order to predict and analyze the LCC during rolling stocks’ maintenance phase, provide the important support for the decision during rolling stocks’ design, production, operation and disposal, mitigate the risks for high expenditure, the LCC prediction software is developed with VBA programming language in Microsoft Excel environment based on various rolling stocks’ maintenance scenarios. This software can collect the LCC input and predict the LCC during rolling stocks’ maintenance phase. The data input is based on the history data and RAMS information for each system and approved by the engineers. This software is validated by several systems and a specific metro project. It shows very wide applicability for LCC prediction for comparing and analyzing for customer and design and friendly interface to the users.