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...
Saved in:
Main Author: | |
---|---|
Other Authors: | |
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 |