Numerical Analysis of Building Structures
Code | Completion | Credits | Range | Language |
---|---|---|---|---|
124YNAK | Z | 2 | 1P+1C | Czech |
- Course guarantor:
- Vladimír Žďára
- Lecturer:
- Vladimír Žďára
- Tutor:
- Vladimír Žďára
- Supervisor:
- Department of Architectural Engineering
- Synopsis:
-
The subject is focused on the practical modeling of various structural-static problems in particular. We will also focus on the problems of optimizing structures.
The goal is to learn how to define a problem, convert it into a mathematical model, design a solution algorithm and write this algorithm in Excel or VBA.
You'll learn how to use Excel effectively and write applications that you can use years from now.
You will also definitely learn something about numerical modeling.
I have been using Excel for work for 25 years and I would like to teach you how to use it effectively not only in building analysis models. Do not expect great science, but rather a practical approach to the problems you will encounter in practice.
- Requirements:
-
-
- Syllabus of lectures:
-
The course does not have lectures
- Syllabus of tutorials:
-
1. Calculation of cross-sectional quantities. Data and databases in excel.
2. Fire spread 1 and 2D. Cyclic calculations in Excel.
3. Thermal load of structures - stationary and non-stationary.
4. Application of the force method for the analysis of the action of „“doubled„“ constructions.
5. Model of suspended roof structure.
6. Thermal load and tension of the supporting structure of the loggia wall.
7. Advanced matrix operations in Excel.
8. General cross section interaction diagram
9. Optimization of the structural cross-section
10. Using Excel to optimize various technical problems.
11. Evolutionary algorithms and their use for optimization.
12. Multicriteria optimization.
13.
- Study Objective:
-
The student will learn to create applications for solving partial practical problems and models for the analysis of structurally static tasks. It includes problem analysis, creation of a model and a solution algorithm. Implementation of the algorithm and its writing in the VBA and Excel environment.
- Study materials:
-
Orvis, William J, Karas, Tomáš: Excel pro vědce a inženýry. ISBN: 80-85896-49-4
- Note:
- Further information:
- N/A
- Time-table for winter semester 2024/2025:
-
06:00–08:0008:00–10:0010:00–12:0012:00–14:0014:00–16:0016:00–18:0018:00–20:0020:00–22:0022:00–24:00
Mon Tue Wed Thu Fri - Time-table for summer semester 2024/2025:
- Time-table is not available yet
- The course is a part of the following study plans:
-
- Stavební inženýrství, specializace Pozemní stavby (compulsory elective course)
- Stavební inženýrství, specializace Pozemní stavby (compulsory elective course)