| 基于VBA的公交上车刷卡人数统计方法 |
| |
| 引用本文： | 姜耀,姜洪奎.基于VBA的公交上车刷卡人数统计方法[J].大连交通大学学报,2014,35(6):6-9. |
| |
| 作者姓名： | 姜耀 姜洪奎 |
| |
| 作者单位： | 1. 大连理工大学交通运输学院,辽宁大连,116024
2. 山东省新泰市实验中学,山东泰安,271200 |
| |
| 基金项目： | 教育部人文社科青年基金资助项目，高等学校博士学科点专项科研基金资助项目 |
| |
| 摘 要： | 提出一种基于VBA宏命令,利用公交IC卡和GPS数据来实现各站点刷卡上车人数统计的方法.根据两种数据的特点,以Excel为主要工作平台,通过VBA程序快速地对两者数据进行筛选和利用,逐步实现各站点公交车到站时间的匹配和各站点上车人数的统计.最后利用此方法对丹东市公交线路的往返各站点上车人数进行统计.与传统的公交随车调查结果对比,通过该方法得到的各站点上车人数数据较为准确,可作为传统方法的替代.
|
| 关 键 词： | 城市交通 VBA 公交IC卡 GPS数据 |
Statistic Method of Numbering Boarding Passengers Bus IC Cards Based on VBA |
| |
| JIANG Yao,JIANG Hongkui.Statistic Method of Numbering Boarding Passengers Bus IC Cards Based on VBA[J].Journal of Dalian Jiaotong University,2014,35(6):6-9. |
| |
| Authors: | JIANG Yao JIANG Hongkui |
| |
| Institution: | JIANG Yao ,JIANG Hongkui (1. School of Transportation ＆ Logistics, Dalian University of Technology, Dalian 116024, China; 2. Xintai Experimental Mid- dle School of Shandong Province, Taian 271200,China) |
| |
| Abstract: | 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. |
| |
| Keywords: | urban traffic VBA IC Card GPS |
| 本文献已被 维普 万方数据 等数据库收录！ |
|
