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

电子表格Excel具有强大的计算功能,它是一种可描述问题、建立模型、处理数据与求解的有效工具.汽车行驶到十字路口,受红绿灯控制,产生等待时间.利用Excel对此进行计算机仿真模拟,比较不同控制参数对控制目标的影响,可以找到相对较佳的方案.

Traffic Light Simulation Control Decision-making Based on 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.