In this video of #engineeringmanagementacademy #excel is used for #FaultTreeAnalysis by #drmehrdadarashpour
❎ Excel workbook to follow along: bit.ly/Excel_Fault_Tree
▶ RELATED VIDEOS: • Risk Assessment via Fa...
⌛ TIMESTAMPS
0:00 - Introduction to Fault Tree Analysis (FTA) in Excel
0:21 - Excel’s Dynamic templates for Logical Gates (And / Or), Events, Failure Mode and Effects Analysis
0:52 - Step 1 (Create logical gate templates - AND gate, OR gate)
2:24 - Step 2 (Create Dynamic templates for top & intermediate Events)
3:39 - Step 3 (Create Dynamic templates for basic Events & complete the fault tree)
4:30 - Step 4 (Calculate Probability of intermediate events & the Top event)
5:44 - Interpret & prioritize failure modes and decide on countermeasures (Risk Treatment Plan)
✍ Request Next Tutorial Video: forms.gle/Frz9U9imCouofdoD8
In a previous video, we discussed how to perform Failure Mode & Effects Analysis or FMEA. The link to that video: • Risk Assessment via Fa... Now, we want to use EXCEL to draw & analyze Fault Trees. We’ll work on an Excel Template for a project safety failure using AND gates, OR gates, basic events, Intermediate events & the top event. You can follow along by getting the Excel workbook: bit.ly/Excel_Fault_Tree
Let’s focus on a site accident scenario with 3 failure causes, falling from heights, hazardous material contact & struck-by incidents. We can follow only 4 simple steps in Excel to perform Fault Tree Analysis for our risk management example based on ISO31000, which is the internation standard for risk management.
Step 1 is to Create logical gate templates
Let’s start by analyzing the provided spreadsheet, accounting for 3 intermediate events, first of which is falling from heights. AND gate provides the Boolean logic, which means falling from heights happens if there’s an unsafe scaffold AND no safety net is installed AND workers have no fall protection harness. We have again used AND gate for hazardous material contact, which means it happens if there’s asbestos exposure AND a poor asbestos management plan AND poor air quality monitoring. The same AND gate provides the Boolean logic for struck-by incidents, which means it happens if workers enter exclusion zones AND site is congested AND operators of heavy machinery make errors. OR gate links the 3 intermediate events to the top event, which means we have a site accident if a fall from height happens OR there’s hazardous material contact OR struck by incidents.
We are able to create logical gates now. From the ‘insert’ menu, select shapes and under ‘flowchart shapes’, choose a similar figure to AND gate. As you can see, We can follow the same procedure to create OR gates.
Step 2 is to Create Dynamic templates for top & intermediate Events
Let’s start with the top event and insert a rectangle from the ‘shape’ menu. Instead of typing a hardcoded label, we can make a dynamic template by linking it to the tabular data, which is great for future updates of project risk assessment using the fault tree. Next, We can change the color as appropriate & start creating intermediate events. First we link the top event to the OR gate by inserting a line from the ‘shape’ menu. Then we link the 3 intermediate events using ‘elbow connectors’ under the shape menu. You can select all elements & group them together for easy relocation & placement.
Step 3 is to Create Dynamic templates for basic Events & complete the fault tree
Let’s start with a basic event and insert a circle from the ‘shape’ menu & repeat the procedure for other 8 basic events.
Now we can build the bottom section of our tree by linking the components.
Step 4 is to Calculate Probability of intermediate events & the Top event
Now, we can focus on the quantitative risk assessment by calculating probability of intermediate events. Falling from heights is connected to 3 basic events using AND gates, so probabilities should be multiplied. Click on the relevant cell and press the = sign. Then, use the “product” function.
Finally, we can calculate the likelihood of the top event. Occurring site accidents is connected to 3 intermediate events using the OR gate, so probabilities should be added together. Click on the relevant cell and press the = sign. Then, use the “SUM” function to add probabilities of falling from heights, hazardous material contact & struck-by incidents. The probability of 0.0002 indicates that in every 10,000 sites, there will be 2 accidents.
This risk analysis technique can easily decide on countermeasures or project risk treatment plans. "Zero harm" is a principle in safety management aiming to achieve the elimination of all incidents, injuries, and harm in workplace. By identifying the root causes of failures, project managers can implement targeted corrective actions to prevent site accidents from occurring in the future.
An easy solution to cause-consequence modelling using only 4 simple steps in Microsoft Excel.
Негізгі бет Fault Tree Analysis (FTA) - EXCEL 4 Steps Project Risk Management Safety Failure Mode & Effects FMEA
Пікірлер: 4