
Excel VBA programming with Excel to compute the load tranceverse distribution coefficient of G-M method
Author(s) -
Ma Longxiang,
Guowen Che
Publication year - 2021
Publication title -
journal of physics. conference series
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.21
H-Index - 85
eISSN - 1742-6596
pISSN - 1742-6588
DOI - 10.1088/1742-6596/1941/1/012026
Subject(s) - worksheet , computer science , computation , visual basic for applications , software , microsoft excel , transverse plane , distribution (mathematics) , engineering drawing , computational science , mathematics , algorithm , programming language , mathematical analysis , structural engineering , engineering , operating system , mathematics education
In this paper, by analyzing the calculation principles of load transverse distribution coefficient of G-M method, using office software Excel, the calculation model of a universal worksheet is given, making the computation of load transverse distribution coefficient with G_M method more accurate and swift. The model is very practical, and can offer reference for bridge and highway designers.