摘要
在水利水电工程建设中,土石方调配问题因其时空跨度大,开挖填筑类型多,决定了合理的调配方案对工程现场管理、工程进度及造价的重要影响,甚至对整个工程成败至关重要的作用。文章在分析同类问题解决方法的基础上,提出了基于动态规划思想及基于VBA语言的人机交互计算系统,重点解决"多供点"—"多需点"—"多类"土石方调配问题,并结合工程实例说明调配系统的合理性和实用性。
In construction of water resources and hydropower projects, reasonable scheme for earthrock dispatch largely affects site management, project progress and cost even the success of the whole project because the earthrock dispatch lasts for a long time and excavation and embankment are various. Based on resolution of similar issues, man-machine interactive computerizing system based on dynamic planning and VBA language is raised in this paper, focusing on resolution of earthrock dispatch of multiple supply points, multiple demand points and various kinds. In combination of engineering practice, rationality and practicability of the dispatching system are stated.
出处
《西北水电》
2012年第3期58-61,共4页
Northwest Hydropower
关键词
土石方调配
多供点
多需点
多类
动态规划
EXCEL
VBA
系统应用
Earthrock dispatch
multiple supply points
multiple demand points
dynamic planning
Excel VBA
systematic application