Welcome
Digital library of construction informatics
and information technology in civil engineering and construction
 

Works 

Paper w78-2011-Paper-154:
Development of CAD-Spreadsheet integrated solution to Optimazing Site Grading Design for industrial Construction

Facilitated by the SciX project

Z Yin, M Lu, M Al-Hussein

Development of CAD-Spreadsheet integrated solution to Optimazing Site Grading Design for industrial Construction

Abstract: 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.

Keywords: earthwork, optimization least squares method, cut/fill balance, CAD, Excel Solver

DOI:

Full text: content.pdf (1,280,598 bytes) (available to registered users only)

Series: w78:2011 (browse)
Cluster:
Class:
Similar papers:
Sound: N/A.

 

hosted by University of Ljubljana



includes

W78




© itc.scix.net 2003
Home page of this database login Powered by SciX Open Publishing Services 1.002 February 16, 2003