Abstract:

The paper puts forward an integration method of Excel VBA, VISSIM and MATLAB for traffic simulation platform, which indeed solve the problem of programming difficulty and time consuming if the highlevel programming language is used to reprogram. The Excel VBA is the master control program. Excel VBA has the easy interface programming with VISSIM and MATLAB. The MATLAB has the powerful toolbox, library function and the advantages of analyzing the matrix. The VISSIM and MATLAB are the called objects of Excel VBA. VISSIM usually simulates traffic flow and outputs the performance index. MATLAB is programmed for the proposed traffic control model. The integration of VISSIM and Excel is realized by the COM data communication interface. The integration of Excel and MATLAB is realized by the Excel Link extension interface. The proposed integration method for traffic control simulation platform provides an effective solution to validate the traffic control model. The paper also presents an example of Qlearning signal timing optimization based on the proposed traffic control simulation platform.

Key words: intelligent transportation, simulation platform, interface technique, VISSIM, Excel VBA, MATLAB 

摘要：

本文提出了利用Excel VBA作为主控程序将VISSIM与MATLAB进行集成构建仿真平台的方法，解决了直接对VISSIM二次开发编程难度大、耗时长的问题.该方法综合Excel VBA与VISSIM、MATLAB的接口编程容易，且MATLAB具有强大的工具箱、库函数和擅长处理矩阵的优点，其中VISSIM和MATLAB作为Excel VBA的调用对象，利用MATLAB编制新建交通控制模型的代码，利用VISSIM模拟车流运行和提取各种交通运行性能指标.具体地，VISSIM与Excel之间采用COM数据通讯接口进行集成，Excel与MATLAB之间采用Excel Link扩展接口进行集成.采用这种方法建立的交通控制仿真平台为研究验证新型的交通控制模型提供了有效途径，最后给出了一个基于该控制仿真平台建立的Q学习配时优化模型的实例.

关键词: 智能交通, 仿真平台, 接口技术, VISSIM, Excel VBA, MATLAB