An optimal design tool for welded rectangular hollow sections joint using MS-excel
This report is to describe an optimal design tool used in the design of rectangular hollow section truss where RHSs are loaded by both axial forces and in-plane moments. Using MS-Excel programme as the implementation platform, with the combination of a simple spreadsheet design tool developed in a p...
| Main Author: | |
|---|---|
| Other Authors: | |
| Format: | Final Year Project (FYP) |
| Language: | English |
| Published: |
2011
|
| Subjects: | |
| Online Access: | http://hdl.handle.net/10356/44889 |
| _version_ | 1826125799409844224 |
|---|---|
| author | Li, Leichen |
| author2 | Lee Chi King |
| author_facet | Lee Chi King Li, Leichen |
| author_sort | Li, Leichen |
| collection | NTU |
| description | This report is to describe an optimal design tool used in the design of rectangular hollow section truss where RHSs are loaded by both axial forces and in-plane moments. Using MS-Excel programme as the implementation platform, with the combination of a simple spreadsheet design tool developed in a previous final year project, this design tool allows users to select a nearly optimized combination of sections for the construction of the RHS joints.
Compared to existing spreadsheet, there are four major functions developed to make the design process more flexible and user-oriented: the design of in-plane internal moment, force and moment equilibrium check, auto filter mechanism and multiple selection tools. These additional functions will be discussed in details in following chapters.
Despite from the differences of technical part between existing spreadsheet and the latest one, their aims are in common, which are to make the design process interactive and enable engineers to design the joints more quickly by simply entering the loadings and certain parameters compared to carrying out large amount of calculations using conventional method.
After going through the design process, the author also provides some suggestions on further improvement of the design tool to make it more convenient to use and powerful in carrying out the design work. |
| first_indexed | 2024-10-01T06:42:37Z |
| format | Final Year Project (FYP) |
| id | ntu-10356/44889 |
| institution | Nanyang Technological University |
| language | English |
| last_indexed | 2024-10-01T06:42:37Z |
| publishDate | 2011 |
| record_format | dspace |
| spelling | ntu-10356/448892023-03-03T16:59:54Z An optimal design tool for welded rectangular hollow sections joint using MS-excel Li, Leichen Lee Chi King School of Civil and Environmental Engineering DRNTU::Engineering::Civil engineering This report is to describe an optimal design tool used in the design of rectangular hollow section truss where RHSs are loaded by both axial forces and in-plane moments. Using MS-Excel programme as the implementation platform, with the combination of a simple spreadsheet design tool developed in a previous final year project, this design tool allows users to select a nearly optimized combination of sections for the construction of the RHS joints. Compared to existing spreadsheet, there are four major functions developed to make the design process more flexible and user-oriented: the design of in-plane internal moment, force and moment equilibrium check, auto filter mechanism and multiple selection tools. These additional functions will be discussed in details in following chapters. Despite from the differences of technical part between existing spreadsheet and the latest one, their aims are in common, which are to make the design process interactive and enable engineers to design the joints more quickly by simply entering the loadings and certain parameters compared to carrying out large amount of calculations using conventional method. After going through the design process, the author also provides some suggestions on further improvement of the design tool to make it more convenient to use and powerful in carrying out the design work. Bachelor of Engineering (Civil) 2011-06-06T08:40:09Z 2011-06-06T08:40:09Z 2011 2011 Final Year Project (FYP) http://hdl.handle.net/10356/44889 en Nanyang Technological University 51 p. application/pdf |
| spellingShingle | DRNTU::Engineering::Civil engineering Li, Leichen An optimal design tool for welded rectangular hollow sections joint using MS-excel |
| title | An optimal design tool for welded rectangular hollow sections joint using MS-excel |
| title_full | An optimal design tool for welded rectangular hollow sections joint using MS-excel |
| title_fullStr | An optimal design tool for welded rectangular hollow sections joint using MS-excel |
| title_full_unstemmed | An optimal design tool for welded rectangular hollow sections joint using MS-excel |
| title_short | An optimal design tool for welded rectangular hollow sections joint using MS-excel |
| title_sort | optimal design tool for welded rectangular hollow sections joint using ms excel |
| topic | DRNTU::Engineering::Civil engineering |
| url | http://hdl.handle.net/10356/44889 |
| work_keys_str_mv | AT lileichen anoptimaldesigntoolforweldedrectangularhollowsectionsjointusingmsexcel AT lileichen optimaldesigntoolforweldedrectangularhollowsectionsjointusingmsexcel |