Numerical Analysis of Building Structures

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	roomTH:A-229 10:00–11:50 EVEN WEEK (lecture parallel1 parallel nr.101) Thákurova 7 (budova FSv) roomTH:A-229 10:00–11:50 ODD WEEK (lecture parallel1) Thákurova 7 (budova FSv)
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)