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
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
- Lay out a diagram of parallel and serial components
- Identify probability of failure of each component (value 0-1).
- Calculate parallel probabilities. (a+b-a*b)
- Multiply serial component probabilities (a*b)
- 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.