基于VBA的公交上车刷卡人数统计方法

Statistic Method of Numbering Boarding Passengers Bus IC Cards Based on VBA

提出一种基于VBA宏命令,利用公交IC卡和GPS数据来实现各站点刷卡上车人数统计的方法.根据两种数据的特点,以Excel为主要工作平台,通过VBA程序快速地对两者数据进行筛选和利用,逐步实现各站点公交车到站时间的匹配和各站点上车人数的统计.最后利用此方法对丹东市公交线路的往返各站点上车人数进行统计.与传统的公交随车调查结果对比,通过该方法得到的各站点上车人数数据较为准确,可作为传统方法的替代.

A method based on VBA is proposed to number the passengers boading the bus with IC cards. The results can be achieved gradually by screening and utilizing both datum through VBA program according to the properties of these datum on the platform of excel. Finally,the algorithm is tested on the routes datum of Dandong,and the result shows the high accuracy of the method.