||Development of CAD-Spreadsheet integrated solution to Optimazing Site Grading Design for industrial Construction
||Z Yin, M Lu, M Al-Hussein
||Industrial construction covers a wide range of construction projects that are essential to our utilitiesand basic industries, such as petroleum refineries and petrochemical plants, synthetic fuel plants, fossilfuel and nuclear power plants etc. Land formation for an industrial construction site needs to considermany engineering constraints such as (1) ensuring proper drainage, (2) prevention of flood, (3) drivingsafety, (4) optimizing earthwork by balancing cut and fill, (5) minimizing truck travel distances inearthmoving, and (6) proper equipment matching for achieving high equipment utilization rates. Wehave developed a computer-based application framework by seamlessly integrating earthwork designin CAD and earthwork optimization in spreadsheet, in order to facilitate the practical application of theproposed framework on site formation for industrial construction. This paper presents an optimizationproblem formulation in an Excel spreadsheet model based on the least squares method. The Solverutility for optimization analysis in Excel provides a cost-effective tool to identify the optimum designsurface model satisfying practical constraints on slopes and the highest elevation. A case study is usedto demonstrate the effectiveness of the proposed application framework for earthwork optimizationbased on site formation on an industrial project in Alberta.
|Year of publication:
||earthwork, optimization least squares method, cut/fill balance, CAD, Excel Solver
Z Yin, M Lu, M Al-Hussein (2011).
Development of CAD-Spreadsheet integrated solution to Optimazing Site Grading Design for industrial Construction. Proceedings of the 28th International Conference of CIB W78, Sophia Antipolis, France, 26-28 October,