• Engineering and Technology • Previous Articles     Next Articles

Method of using excel to calculating plate edge bending moment

CHENG Guo-yong,GUO Zhi-guang,MENG Shu-dong,HU Hui   

  1. (Airport College,CAUC,Tianjin 300300,China)
  • Received:2012-06-11 Revised:2012-09-21 Online:2013-02-23 Published:2014-05-23

Abstract:

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 x 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.

Key words: airport pavement design, airport cement concrete pavement, layer thickness of cement concrete road surface, plate edge bending moment influence diagram

CLC Number: