Book chapter
Retaining Wall Design Optimization with MS Excel Solver
Structures Congress 2006, pp.1-15
2006
DOI: 10.1061/40878(202)34
Abstract
Using reinforced concrete retaining wall as an example, the purpose of this paper is to demonstrate that one does not have to be an optimization expert to take advantage of the power built into modern tools such as the Microsoft Excel. Worksheets designed for usual analysis and design computations can be turned into formal design optimization tools by simply choosing cells corresponding to design variables, objective function and suitable constraint functions. This way an optimum design can be obtained in a systematic manner without having to resort to manual trial and error process. The paper presents the worksheets for design of cantilever retaining walls and shows several optimum design examples. To further demonstrate the usefulness of these worksheets a sensitivity analysis is carried out that shows the effect on optimum cost of various parameters such as wall height, surcharge pressure, allowable soil pressure, and internal soil friction angle.
Details
- Title: Subtitle
- Retaining Wall Design Optimization with MS Excel Solver
- Creators
- M. Asghar Bhatti
- Resource Type
- Book chapter
- Publication Details
- Structures Congress 2006, pp.1-15
- DOI
- 10.1061/40878(202)34
- Language
- English
- Date published
- 2006
- Academic Unit
- Civil and Environmental Engineering
- Record Identifier
- 9984197231402771
Metrics
361 Record Views