Jan 20, 2020   7:51 p.m. Dalibor
Academic information system

Persons at STU

This page displays all publicly accessible information about the desired person. Some information about the person's occupation and offices may be hidden.

doc. Ing. Richard Kuracina, Ph.D.
Identification number: 38282
University e-mail: richard.kuracina [at] stuba.sk
Zástupca riaditeľa ústavu - Docent CSc.,PhD. - Department of Safety Engineering (UIBE MTF)

Contacts     Lesson     Final thesis     Projects     
Publications     Bodies     Supervised theses     

Basic information

Basic information about a final thesis

Type of thesis: Diploma thesis
Thesis title:Design of Algorithm for the calculation of cut sets by Fault tree analysis via Microsoft Excel
Written by (author): Ing. Denis Šandor
Department: Ústav integrovanej bezpečnosti (MTF)
Thesis supervisor: doc. Ing. Richard Kuracina, Ph.D.
Opponent:doc. Ing. Miloš Ferjenčík, Ph.D.
Final thesis progress:Final thesis was successfully defended.

Additional information

Additional information about the final thesis follows. Click on the language link to display the information in the desired language.

Language of final thesis:English

Slovak        English

Title of the thesis:Design of Algorithm for the calculation of cut sets by Fault tree analysis via Microsoft Excel
Summary:This work focuses on the issue of determining the cut sets using the method of fault tree (FTA). The major goal was to develop software (macro-Table) that would be created and executable in the Microsoft Excel, which main task would be to automate /replicate the determination process of cut sets using a MOCUS algorithm. In the First Chapter a brief history of determinations algorithms in FTA method is presented. The Second Chapter is devoted to fault tree analysis in general. Here you can find a description of the advantages/ disadvantages and potential use of this method. A principle of function of this method is explained in detail, together with an explanation of the logic of calculation and description of each gate. This section presents four specific algorithms along with their procedure. The Third Chapter is entirely devoted to the basics of programming in VBA. The main part of the thesis begins in the Fourth Chapter. At the beginning of this Chapter the goals of my work are set. This Chapter is mainly focused on details of software interface and description of individual parts. There is a description of the macro buttons but especially the part where rules are set and boundary conditions for usage of the program. The Fifth Chapter deals with the issue of pre-treatment of data entry and editing these data. There is also a section dedicated to ensuring the program against errors. In the Final Chapter Six, an invented algorithm determining the cut sets is elucidated in detail on a particular example. The results of a comparison of the identified cut sets with results from other software are at the same section.
Key words:FTA, algorithm, Excel, macro, VBA, Visual basic, cut sets, Mocus, analysis

Display and download files

To display the final thesis assignment form click on the Display the final thesis assignment form icon. The following icons - Final thesis, Thesis appendices, Supervisor's review, Opponent's review - relate to the final thesis and can be downloaded. They could be displayed on condition they have been inserted and are available publicly.

Display the assignment form

Parts of thesis with postponed release:

Final thesis (final thesis appendices) unlimited
Reviews for final thesis unlimited