基于Excel的红绿灯仿真控制决策  

Traffic Light Simulation Control Decision-making Based on Excel

作　　者：倪曼[1] 

机构地区：[1]武汉工交职业学院,武汉430205

出　　处：《交通与计算机》2007年第2期115-118,共4页Computer and Communications

摘　　要：电子表格Excel具有强大的计算功能,它是一种可描述问题、建立模型、处理数据与求解的有效工具。汽车行驶到十字路口,受红绿灯控制,产生等待时间。利用Excel对此进行计算机仿真模拟,比较不同控制参数对控制目标的影响,可以找到相对较佳的方案。Excel worksheet has powerful computing functions. It provides a kind of effective tool for describing questions, establishing models, processing data, and seeking for solution. When cars run to the crossroad, they are controlled by the traffic light, which engenders waiting time. Using Excel to do the computer analog simulation, and comparing the effect of different control parameters on controlled goal can help find the better project.

关 键 词：计算机仿真 数学建模 红绿灯 EXCEL 

分 类 号：TP391.13[自动化与计算机技术—计算机应用技术]