Influence Line Analysis of the Plane Trusses Based on EXCEL

Article Preview

Abstract:

The purpose of this paper is to investigate the application of Excel software in the constructing and plotting of influence lines in plane trusses. Obtaining the influence coefficient of the plane trusses with Excel, the influence lines in the plane trusses were constructed and plotted via VBA Functions in Excel. The research outcome of this paper is expected to be helpful to engineering practice, teaching and research work. Key words: EXCEL;plane trusses;influence line;VBA

You might also be interested in these eBooks

Info:

Periodical:

Pages:

927-930

Citation:

Online since:

May 2012

Authors:

Export:

Price:

Permissions CCC:

Permissions PLS:

Сopyright:

© 2012 Trans Tech Publications Ltd. All Rights Reserved

Share:

Citation:

[1] Ming Bo Zhao. The study of calculating initial force and deformation of plane truss in EXCEL [J]. Building Science Research of SiChuan, 2008:4. (in Chinese)

Google Scholar

[2] Ming Bo Zhao. Study of force of plane statically determinate plane through VBA in EXCEL [J]. Shanxi Architecture, 2005:19. (in Chinese)

Google Scholar

[3] Dao Bin Wang. Matrix analysis theory and program design of structure [M]. Chengdu: Suthwest Jiaotong University Press, 2004. (in Chinese)

Google Scholar

[4] (U.S. John Walkenbach, Chen Mian, Yu Peng (translation). Excel 2003 Collection in Chinese [M]. Beijing: Electronics Industry Press, 2002.

Google Scholar