Numerical Analysis of Building Physics

The course is not on the list Without time-table
Code Completion Credits Range Language
124YNAS Z 2 2C Czech
Garant předmětu:
Vladimír Žďára
Vladimír Žďára
Vladimír Žďára
Department of Architectural Engineering

The subject is focused on practical modeling of various technical problems, especially in the field of construction physics of buildings and optimization of structures.

The goal is to learn how to define a problem, create a mathematical and physical model, design a solution algorithm and write this algorithm in Excel or VBA.

Learn how to use Excel effectively and write applications that you can use years from now.

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. Don't expect big science, but rather a practical approach to the problems you will encounter in practice.


Basic knowledge of working with MS Excel. I always adapt the course content to the students' initial knowledge.

Syllabus of lectures:

The course does not have lectures

Syllabus of tutorials:

1. Stationary temperature field of layered circuit construction. Data and databases in excel.

2. Fire propagation in a 1D field. A simple example - discretization of space and time. Cyclic calculations in Excel.

3. Non-stationary (dynamic) temperature field of layered circuit construction. Cyclic calculations in Excel

4. Modeling of heat gains and losses of windows. Energy transport by conduction, flow, radiation.

5. User functions and use of VBA in Excel

6. Building-physical behavior of a ventilated structure.

7. Advanced matrix operations in Excel.

8. A network model of the energy behavior of the building.

9. Optimizing the thickness of the thermal insulation of the building.

10. Using Excel to optimize various technical problems.

11. Evolutionary algorithms I

12. Evolutionary algorithms II


Study Objective:

The student will learn to create applications for solving partial practical problems and models in construction physics. 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:

1.Halliday, D. :Fyzika - Mechanika - Termodynamika. Prométheus VUTBrno 2000.

2.Orvis, J.: Microsoft Excel pro vědce a inženýry. Computer Press. 1996

3.Brož,M.: Mistrovství v Microsoft Excel. Computer Press 2000

Further information:
No time-table has been prepared for this course
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/predmet1106406.html