Excel应用于工程网络图中时间—费用整体优化

Application of Excel to Solve Time-cost Optimum in Engineering Network Drawing

工程项目中的时间—费用优化问题,既可以用网络计划技术进行优化,也可以利用线性规划模型求解。然而,这两种方法对一些较复杂的工程项目进行时间—费用优化时,会存在不能保证整体优化和计算量太大的问题。文章应用Excel模型对工程网络图中的时间—费用优化问题进行了研究。

The problem of time - cost optimum in engineering project can be optimumed not only by net planning technology but also by suing lineal programming model. However, there may be some problems while using these two methods to do some complex engineering project time - cost optimum, such as incomplete optimum and too much counting. This paper mainly researches on the problem of applying Excel Model to solve time - cost optimum in engineering network drawing.