Want to Draw a Block Diagram in Excel?

QI Macros has a Ready-Made Block Diagram Template!

Use a Block Diagram to Design Reliability of Systems

block diagram template excel

There are three types of block diagrams:

  • System - physical relationship of major system components
  • Functional - Categorize system components according to the function they provide.
  • Reliability - depicts the effect of a component failure on the system's function.

To Create a Block Diagram

  1. Lay out a diagram of parallel and serial components
  2. Identify probability of failure of each component (value 0-1).
  3. Calculate parallel probabilities. (a+b-a*b)
  4. Multiply serial component probabilities (a*b)
  5. Use parallel parts to increase reliability.

Haven't you waited long enough?
Start creating your Block Diagram in just minutes.

Download a free 30-day trial. Get the Block Diagram now!

The Block Diagram is one of many tools included in QI Macros add-in for Excel.

QI Macros adds a new tab to Excel's menu, making it easy to find any tool you need. If you can't locate a tool, use the find tools feature on the far right side of QI Macros menu.

find tools on QI Macros menu

Other charts in QI Macros add-in