Fault Tree Diagram in Excel

Fault Tree Diagrams take reliability block diagrams one step further by adding logic symbols (and/or) to connect the blocks. (Similar to root cause analysis.)

How to Create a Fault Tree Diagram.

  1. Taking a failure event that occurred, analyze that event (ask why?)
  2. List failures, events, or conditions that had to exist to cause the failure.
  3. Use logic symbols to connect the causes (e.g., this and that cause the failure.)

Sample Fault Tree Diagram

fault tree diagram in Excel

To create a Fault Tree using QI Macros...
Try It Now!