用编程处理控制因素辅助铁路纵断面设计

Solving Affecting Factors of Vertical Section Design in Railway with Computer-aided Programs

铁路纵断面的设计受很多因素的制约。实践证明,通过分析各工点的数据项,同时综合考虑相关技术要求,可以计算出纵断面控制因素的数据结果,但传统方法繁琐而且工作量很大。为了使纵断面的设计工作变得高效和便捷,本文应用软件开发技术,在Excel中建立VBA语言程序,通过合理的算法,优化原始数据项的获取方式,分析计算控制因素,准确高效地得出纵断面控制因素相关的数据成果。

The design of the vertical section of railway has been affected by many factors. It has been proved in practice that data results of the affecting factors can be calculated through analyzing data items of each worksite by taking account the relevant technical requirements. However, traditional methods usually require too much work. In order to design railway vertical section effectively and conveniently, this article explains the method of obtaining the relative data results on affect- ing factors in vertical section design of railway by establishing the VBA language software in Excel to optimize methods of acquiring original data items as well as analyze and calculate the data items of controlling factors.