CZECH TECHNICAL UNIVERSITY IN PRAGUE
STUDY PLANS
2023/2024

Numerical Analysis of Building Structures

Code Completion Credits Range Language
124YNAK Z 2 1P+1C Czech
Garant předmětu:
Lecturer:
Tutor:
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 2023/2024:
 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 roomTH:A-43818:00–19:50ODD WEEK(lecture parallel1)Thákurova 7 (budova FSv)A438 roomTH:A-43818:00–19:50EVEN WEEK(lecture parallel1parallel nr.101)Thákurova 7 (budova FSv)A438
Time-table for summer semester 2023/2024:
Time-table is not available yet
The course is a part of the following study plans:
Data valid to 2024-06-19
Aktualizace výše uvedených informací naleznete na adrese https://bilakniha.cvut.cz/en/predmet24667205.html