A quick design tool for the design of beam‐column member and base plate using MS Excel
This report is for a quick design tool developed for structure designers or engineers to design Circular Hollow Section (CHS) beam-column members and base plates with “I” section, Rectangular Hollow Section (RHS), Circular Hollow Section (CHS), and Square Hollow Section (SHS). This design tool is...
| Main Author: | |
|---|---|
| Other Authors: | |
| Format: | Final Year Project (FYP) |
| Language: | English |
| Published: |
2013
|
| Subjects: | |
| Online Access: | http://hdl.handle.net/10356/52953 |
| _version_ | 1824456212561788928 |
|---|---|
| author | Kong, Qingyang. |
| author2 | Lee Chi King |
| author_facet | Lee Chi King Kong, Qingyang. |
| author_sort | Kong, Qingyang. |
| collection | NTU |
| description | This report is for a quick design tool developed for structure designers or engineers to design Circular Hollow Section (CHS) beam-column members and base plates with “I” section, Rectangular Hollow Section (RHS), Circular Hollow Section (CHS), and Square Hollow Section (SHS).
This design tool is based on Microsoft-Excel (MS) with macros. The macros are built by Visual Basic for Application (VBA). It allows the user to perform his design work by simply entering the data and all the calculation steps will be stated clearly in MS spreadsheets.
In this report, the author will use multiple screenshots with instructions to show all the functions or control buttons used inside the design tool. With Macros, VBA and hyperlink used inside the spreadsheet, the design process becomes much more automatically and the interface becomes much more user-friendly.
As a conclusion, the author wants to build a simply and user friendly design tool to help the user to design easily and quickly without any problem. The author hope the user can enjoy the design process.
The author also hopes this design tool can be developed with more functions and becomes more user-friendly in the future and more users can enjoy using this design tool. |
| first_indexed | 2025-02-19T03:50:31Z |
| format | Final Year Project (FYP) |
| id | ntu-10356/52953 |
| institution | Nanyang Technological University |
| language | English |
| last_indexed | 2025-02-19T03:50:31Z |
| publishDate | 2013 |
| record_format | dspace |
| spelling | ntu-10356/529532023-03-03T17:20:19Z A quick design tool for the design of beam‐column member and base plate using MS Excel Kong, Qingyang. Lee Chi King School of Civil and Environmental Engineering DRNTU::Engineering::Civil engineering This report is for a quick design tool developed for structure designers or engineers to design Circular Hollow Section (CHS) beam-column members and base plates with “I” section, Rectangular Hollow Section (RHS), Circular Hollow Section (CHS), and Square Hollow Section (SHS). This design tool is based on Microsoft-Excel (MS) with macros. The macros are built by Visual Basic for Application (VBA). It allows the user to perform his design work by simply entering the data and all the calculation steps will be stated clearly in MS spreadsheets. In this report, the author will use multiple screenshots with instructions to show all the functions or control buttons used inside the design tool. With Macros, VBA and hyperlink used inside the spreadsheet, the design process becomes much more automatically and the interface becomes much more user-friendly. As a conclusion, the author wants to build a simply and user friendly design tool to help the user to design easily and quickly without any problem. The author hope the user can enjoy the design process. The author also hopes this design tool can be developed with more functions and becomes more user-friendly in the future and more users can enjoy using this design tool. Bachelor of Engineering (Civil) 2013-05-29T05:39:14Z 2013-05-29T05:39:14Z 2013 2013 Final Year Project (FYP) http://hdl.handle.net/10356/52953 en Nanyang Technological University 38 p. application/pdf |
| spellingShingle | DRNTU::Engineering::Civil engineering Kong, Qingyang. A quick design tool for the design of beam‐column member and base plate using MS Excel |
| title | A quick design tool for the design of beam‐column member and base plate using MS Excel |
| title_full | A quick design tool for the design of beam‐column member and base plate using MS Excel |
| title_fullStr | A quick design tool for the design of beam‐column member and base plate using MS Excel |
| title_full_unstemmed | A quick design tool for the design of beam‐column member and base plate using MS Excel |
| title_short | A quick design tool for the design of beam‐column member and base plate using MS Excel |
| title_sort | quick design tool for the design of beam column member and base plate using ms excel |
| topic | DRNTU::Engineering::Civil engineering |
| url | http://hdl.handle.net/10356/52953 |
| work_keys_str_mv | AT kongqingyang aquickdesigntoolforthedesignofbeamcolumnmemberandbaseplateusingmsexcel AT kongqingyang quickdesigntoolforthedesignofbeamcolumnmemberandbaseplateusingmsexcel |