基于统计原理的板边弯矩计算方法  

Method of using excel to calculating plate edge bending moment

作　　者：程国勇[1] 郭志光[1] 孟曙东[1] 胡辉[1] 

机构地区：[1]中国民航大学机场学院,天津300300

出　　处：《中国民航大学学报》2013年第1期73-75,共3页Journal of Civil Aviation University of China

基　　金：天津市教委科研项目(20090418);中央高校基本科研业务费专项(ZXH2009A002)

摘　　要：板边弯矩的计算是机场刚性道面板设计的重要内容,传统采用手工在板边弯矩影响图上数格的方法,计算效率低且误差在所难免。首先建立板边弯矩影响图数据库,然后用excel内嵌的VBA功能,通过程序判断板边弯矩影响图每个网格的结点与轮印的相对位置以及在不完整网格内均匀布点的方式,采用程序计算出不同机型一个主起落架轮印覆盖的格数,即可精确计算出板边弯矩。通过算例验证表明,该方法的计算误差随着在不完整网格内均匀布点的密度增大而减小,当按照0.02网格长×0.02网格宽的密度布点时,计算误差在0.001以内。上述方法不仅可彻底避免主观因素带来的误差而且大大提高计算效率,基于上述原理还可开发出机场刚性道面设计软件。The calculation of plate edge bending moment is the important content in designing rigid pavement of airport. It is low efficiency and has inevitable errors that the traditional manual of counting cells＇ number. This paper, firstly, establish database of plate edge bending moment influence diagram; then using VBA embedded in excel designs a program which can verdict the relative position between each node of a grid and tire seal of aircraft main landing gear and can calculate the number of covered cells; finally precisely calculate the bending moment of plate edge. Through a practical example we can conclude that the calculation error of the method presented in this paper decreases with increasing density of the points evenly assigned in incomplete grid. When according to 0.02 grid long × 0.02 grid wide assigns each grid, the calculation error within 0.001. The method not only can completely avoid subjective factors but also greatly improve the computational efficiency. Basing on the above principles, airport rigid pavement design software can be developed.

关 键 词：机场道面设计 水泥混凝土道面 面层厚度 板边弯矩影响图 

分 类 号：V351.11[航空宇航科学与技术—人机与环境工程]