Embedded Files
FTA - Failure Tree Analysis 10€
FTA - Failure Tree Analysis 10€
FTA - Failure Tree Analysis template
FTA - Failure Tree Analysis template
This excel tool allows to build easily some failure trees to support analysis of unexpected events or issues
Control menu
Control menu
Buttons on the left allow to create a new tree, to open a failure tree and to refresh the display of the failure tree.
Buttons on the right allows to select one options of quantitative analysis :
ASIL eveluation to assign level QM, ASIL A ,B, C or D to each cause
Probability to calculate probability of happening with the lambda and the time , following exponential rule
RPN to evaluate risk of happening according to FMEA criteria => Severity/Occurence/Detection
Add a cause at the next level
Add a cause at the next level
Right Click , then "Add Cause" to create a new cause at the next level
Other options :
Hide next causes : to not display the next levels causes. This can be used when failure trees become too big or when a complete branch is already analyzed or secured
Choose existing cause : when the cause to set at the next level has to call back an existing cause with as well its next level causes. Selecting this option displays the list of causes already defined in the failure trees. Select the wished cause from the list to add it at the next level.
Change cause name
Change cause name
Click on a cause and then press "F2 " to enter in the cell and change its value. and finish with << Enter>> . This will update the name/description of the cause.
Confirm the update by a click on <<Refresh>> in the control menu, to check if new name has been reccorded.
Display cause analysis by double click
Display cause analysis by double click
A double click on a cause displays the cause analysis form to complete
Set Logical operators
Set Logical operators
Select logical operator from the list
can be : AND/OR/XOR ,
Why ? to apply the 5x whys method,
Failure tree to create from this cause an other failure tree ( appear then in the list of failure trees by clicking on <<Open Tree>>
ND : standing for "not defined"
Set status of a cause
Set status of a cause
Open : to highlight that investigations are in progress
Close : to indicate that investigations are completed and that the cause is out of risk
Root cause : to highlight current cause in the tree as the root cause of the hazardous event happening
Deep into each cause analysis
Deep into each cause analysis
Double click on a cause displays the cause analysis table in the sheet "Cause analysis".
Answer all generic questions to check the risks of happening and check design controls that drive the risks to an acceptable level
Complete the investigations creating specific todos items ( =action list)
Set generic Questions & Actions
Set generic Questions & Actions
Define in the sheet "Generic Q&A" the list of generic questions to answer at each cause level
At each adding of a new cause in a failure tree , those generic questions and actions will be adressed to the cause created in a specific table created in the sheet "Cause Analysis" (access by double click on a cause in Failure tree)
Cut set analysis
Cut set analysis
Run cut set analysis by a click on <<Cut set analysis>> button in the sheet "Cut set analysis", to display the different conditions of happening and check order of happening.
Work in priority on scenarios with order 1, then 2, 3 etc
And try as much as possible by design to not get any failures happening with order 1 cause.
Mentions légales
The Files Market
RCS= 888 232 212 RCS Compiegne
N°Siren=888 232 212
N°Siret=888 232 212 00017
Google Sites
Report abuse