VFP与EXCEL控制在交通量分析处理中的应用

交通量调查是进行交通规划、控制和管理的基础 ,调查结果的可靠性将影响到方案决策的合理性 .要全面、准确、高效地利用调查数据 ,仅依靠人工处理是难以办到的 .研究从交通量调查到数据生成的过程 ,分析交通量调查的常用方法 ,着重研究数据处理软件的开发 ,将 VFP与 EXCEL技术融为一体 ,通过 VFP表单输入参数及数据 ,再用 VFP对 EXCEL进行编程 ,并使 EXCEL执行宏指令 ,从而实现动态生成数据分析结果

Software Design of Traffic Data Processing and Analysis

Traffic investigation is the basis of traffic plan,control and management Its reliability will affect the rationality of the project and decision making The data collected is precious and should be made use of exactly and high efficiently But it's difficult to do that only by manual work So it requires people to design a professional software to analyze and tidy up the data The thesis consists of a course from traffic investigation to data processing, and the content includes analyzing the common methods of traffic investigation and laying stress on the software design During the course of programming, \!tools collection\" theory is used as thoughtway The method is that VFP and EXCEL are interinfiltrated to write the programs Macro is one function of EXCEL, and it is the VFP language that used to code it Having been typed in parameters at the periphery of macro and written macroinstructions, the computer will execute the instructions By means of this, the outcome of data processing will be got dynamically