首页> 外文会议>Structural Engineering and Public Safety >Retaining Wall Design Optimization with MS Excel Solver
【24h】

Retaining Wall Design Optimization with MS Excel Solver

机译:使用MS Excel规划求解进行挡土墙设计优化

获取原文
获取原文并翻译 | 示例

摘要

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.
机译:本文以钢筋混凝土挡土墙为例,目的是证明不必成为优化专家即可利用Microsoft Excel等现代工具内置的强大功能。只需选择与设计变量,目标函数和合适的约束函数相对应的单元,即可将用于常规分析和设计计算的工作表转变为正式的设计优化工具。这样,可以以系统的方式获得最佳设计,而不必求助于手动试验和错误过程。本文介绍了悬臂式挡土墙的设计工作表,并给出了几个最佳的设计实例。为了进一步证明这些工作表的实用性,我们进行了敏感性分析,显示了对各种参数(如壁高,附加压力,允许土壤压力和内部土壤摩擦角)的最佳成本的影响。

著录项

相似文献

  • 外文文献
  • 中文文献
  • 专利
获取原文

客服邮箱:kefu@zhangqiaokeyan.com

京公网安备:11010802029741号 ICP备案号:京ICP备15016152号-6 六维联合信息科技 (北京) 有限公司©版权所有
  • 客服微信

  • 服务号