VBA在公路OD调查数据处理中的应用

The application of VBA in highway OD survey data processing

研究了公路工预可及交通规划OD调查数据处理方法,应用VBA技术对Excel进行二次开发处理数据,并以四川某高速公路工可为例,对程序进行了演示和分析,指出该技术大大缩短OD调查数据处理的时间,提高了兼容性和可操作性,简单易行,优点突出,值得推广。

This paper researched the OD survey data processing method of highway engineering and transportation planning, application of VBA technology made two development process data to Excel, and taking Sichuan a expressway project as an example, made demonstration and analysis on program, and pointed out that this technology greatly shorten the OD deployment data processing time, improved the compatibility and interoperability, simple, prominent advantages, was worthy of promotion.