水利水电技术2017，Vol.48Issue(5)：61-66,94,7.DOI:10.13928/j.cnki.wrahe.2017.05.010
基于Excel平台的矩形渡槽槽身优化设计及优化机理研究
Excel-based study on optimal design of rectangle aqueduct body and its optimization mechanism
摘要
Abstract
By taking the optimal design of the cross-section of rectangle aqueduct body as the objective,the widely used rectangle aqueduct is selected as the study case.Based on the basic shape of the aqueduct and the relevant design specifications,the solving method for the optimization model of the rectangle aqueduct body is established with its mechanical performance,stability property and geometrical requirement as the constraint conditions by means of the platform of Microsoft Excel and its programming solver function,and then the method is applied to the optimization of the aqueducts of the canal system of Donghe Sub-main Canal of Liyutang Reservoir in Kaixian County of Chongqing,from which the optimization mechanism of the optimal variable is deeply analyzed.The result shows that under the condition of that all the constraints are satisfied,the restriction from the width of the side-wall on the optimization is the maximum,while the restriction from the thickness of the support on the optimization is the minimum,and then the cross-section can be rapidly optimized through regulating the width of the side-wall.The optimization method can effectively reduce the concrete volume to be used with a simple and rapid optimization process,furthermore,can provide a certain reference for the design and optimization of rectangle aqueduct as well.关键词
矩形渡槽/槽身优化/Microsoft Excel平台/规划求解/优化机理Key words
rectangular aqueduct/optimal design of aqueduct body/Microsoft Excel platform/planning solving/optimization mechanism分类
建筑与水利引用本文复制引用
焦雨起,卢晓春,熊勃勃,沈桑桑..基于Excel平台的矩形渡槽槽身优化设计及优化机理研究[J].水利水电技术,2017,48(5):61-66,94,7.基金项目
国家自然科学基金资助项目(51509142) （51509142）
三峡大学研究生科研创新基金项目(SDYC2016007) （SDYC2016007）
