A simple design tool for the calculation of effective section area for class 4 closed section using ms-excel

Rectangular Hollow Section (RHS) is one of the most widely used sections in construction. According to Eurocode 3 structural design standard, class 4 RHS requires effective area revise due to local buckling. To increase the structural design precision and the safety of the structure, the Effectiv...

Full description

Saved in:
Bibliographic Details
Main Author: Deng, Liang
Other Authors: Lee Chi King
Format: Final Year Project
Language:English
Published: 2014
Subjects:
Online Access:http://hdl.handle.net/10356/60098
Tags: Add Tag
No Tags, Be the first to tag this record!
Institution: Nanyang Technological University
Language: English
id sg-ntu-dr.10356-60098
record_format dspace
spelling sg-ntu-dr.10356-600982023-03-03T17:12:46Z A simple design tool for the calculation of effective section area for class 4 closed section using ms-excel Deng, Liang Lee Chi King School of Civil and Environmental Engineering DRNTU::Engineering Rectangular Hollow Section (RHS) is one of the most widely used sections in construction. According to Eurocode 3 structural design standard, class 4 RHS requires effective area revise due to local buckling. To increase the structural design precision and the safety of the structure, the Effective Width method was developed to approach the actual effective area by iteration, but it is very time-consuming and impractical with manual calculation due to complex calculation procedure and tedious calculations. Though simplified method reduces the calculation time, it sacrifices the precision, and is still quite time-consuming. Consequently, a user-friendly and open-source program is in demand in order to accelerate the calculation significantly and retain the high precision at the same time. In this project, a Visual Basic Application language based program was developed to automate the iterative calculations, and this program provides not only the optimized effective area, but also many useful intermediate parameters. Besides, this program is very user-friendly and highly customizable. Quantitatively, this program could provide extremely accurate results with precision more than 15 decimal places, and the efficiency is increased at least 700 times as compared to manual calculation. Bachelor of Engineering (Civil) 2014-05-22T05:29:31Z 2014-05-22T05:29:31Z 2014 2014 Final Year Project (FYP) http://hdl.handle.net/10356/60098 en Nanyang Technological University 84 p. application/octet-stream application/pdf
institution Nanyang Technological University
building NTU Library
continent Asia
country Singapore
Singapore
content_provider NTU Library
collection DR-NTU
language English
topic DRNTU::Engineering
spellingShingle DRNTU::Engineering
Deng, Liang
A simple design tool for the calculation of effective section area for class 4 closed section using ms-excel
description Rectangular Hollow Section (RHS) is one of the most widely used sections in construction. According to Eurocode 3 structural design standard, class 4 RHS requires effective area revise due to local buckling. To increase the structural design precision and the safety of the structure, the Effective Width method was developed to approach the actual effective area by iteration, but it is very time-consuming and impractical with manual calculation due to complex calculation procedure and tedious calculations. Though simplified method reduces the calculation time, it sacrifices the precision, and is still quite time-consuming. Consequently, a user-friendly and open-source program is in demand in order to accelerate the calculation significantly and retain the high precision at the same time. In this project, a Visual Basic Application language based program was developed to automate the iterative calculations, and this program provides not only the optimized effective area, but also many useful intermediate parameters. Besides, this program is very user-friendly and highly customizable. Quantitatively, this program could provide extremely accurate results with precision more than 15 decimal places, and the efficiency is increased at least 700 times as compared to manual calculation.
author2 Lee Chi King
author_facet Lee Chi King
Deng, Liang
format Final Year Project
author Deng, Liang
author_sort Deng, Liang
title A simple design tool for the calculation of effective section area for class 4 closed section using ms-excel
title_short A simple design tool for the calculation of effective section area for class 4 closed section using ms-excel
title_full A simple design tool for the calculation of effective section area for class 4 closed section using ms-excel
title_fullStr A simple design tool for the calculation of effective section area for class 4 closed section using ms-excel
title_full_unstemmed A simple design tool for the calculation of effective section area for class 4 closed section using ms-excel
title_sort simple design tool for the calculation of effective section area for class 4 closed section using ms-excel
publishDate 2014
url http://hdl.handle.net/10356/60098
_version_ 1759857740231999488