“规划求解”在土方调配计算中的应用

The Application of Excel's Layout Evaluation in the Calculation of Earth Adaptation

土方调配计算中通常采用“线性规划”法,然而当出现数量较多的填挖区时,采用人工计算则工作量太大,而专业分析软件又往往得不到普及。以潮州供水枢纽工程库区防护Ⅱ标段第二施工区域土方工程为例,介绍一种利用Excel的“规划求解”功能解决土方调配计算的方法。

Linear optimization is often used in the calculation of earth adaptation,the calculation is a huge operation by human if there are many excavation areas and placement areas in it. Combining with a calculation example of Chaozhou water supply hinge project, this paper introduced a method which the calculation of earth adaptation was solve by Excel＇ s layout evaluation.