基于Excel的桥头加铺纵坡系统设计与实现  

Design and Implementation of the Bridge Longitudinal Slope System Based on Excel

作　　者：林桂亚[1] 程文远 

机构地区：[1]浙江警官职业学院,杭州310018 [2]浙江沪杭甬高速公路股份有限公司,杭州310007

出　　处：《电脑编程技巧与维护》2013年第6期80-81,117,共3页Computer Programming Skills & Maintenance

摘　　要：在分析桥头跳车机理的基础上,利用Excel作为设计和计算工具,实现了一个简单的桥头加铺纵坡系统。以沪杭甬高速公路设计案例为基础,提出一种以桥面为起边坡度和正常路面为终边坡度的基准坡度,在需加铺段插入S形竖曲线的设计方法来恢复沉降受损的线形,使桥头纵坡线形流畅,使桥头纵坡设计变得简单易用,高效便捷。Based on the analysis of the bridge jump mechanism, using Excel as a design and computational tools, this paper achieves a simple bridge paving longitudinal slope system. On the basis of Shanghai-Hangzhou-Ningbo expressway design case,we proposed a bridge to the side slope and the normal road for the final reference slope slope, design methods of inserting S vertical curve for overlay segment to restore damaged linear settlement, so that the bridge longitudinal slope streamline is fluent,and the bridge longitudinal slope design is simnle and easv to use. efficient and convenient.

关 键 词：系统设计 EXCEL软件 竖曲线 纵坡 

分 类 号：TP391.13[自动化与计算机技术—计算机应用技术]